首页
关于
Search
1
阿里云rds数据库mysql版cpu占用100%排查问题过程
1,405 阅读
2
解决Gitlab进行clone、push、pull的时候报错aborting due to possible repository corruption on the remote side. git-pack-objects died with error.index-pack failed问题
1,302 阅读
3
nginx、php-fpm、thinkphp接口请求偶尔返回502导致前端报CORS跨域错误问题
842 阅读
4
使用VMware Workstation pro 15安装黑苹果后,开机卡在logo的问题
787 阅读
5
mysql查询某个字段有两条重复记录的SQL语句
591 阅读
计算机
数据库
Linux
PHP开发
前端
好文收藏
产品
创业
天天向上
阅读
工作
登录
Search
标签搜索
PHP
ss
pdo
mysql
php8
阅读
摘抄
PHP后端开发技术学习
累计撰写
104
篇文章
累计收到
1
条评论
首页
栏目
计算机
数据库
Linux
PHP开发
前端
好文收藏
产品
创业
天天向上
阅读
工作
页面
关于
搜索到
104
篇与
basil
的结果
2022-05-10
Linux系统centos通过php、thinkphp5.1框架将HTML网页转为图片方法
思路使用PHP调用chrome浏览器来完成centos安装chrome浏览器添加源vim /etc/yum.repos.d/google-chrome.repo[google-chrome] name=google-chrome baseurl=https://dl.google.com/linux/chrome/rpm/stable/x86_64 enabled=1 gpgcheck=1 gpgkey=https://dl.google.com/linux/linux_signing_key.pub执行安装命令yum -y install google-chrome-stable如果安装失败则执行yum -y install google-chrome-stable通过chrome-php插件以及chrome的headless模式将HTML转为图片安装chrome-php插件composer require chrome-php/chromedemo$browserFactory = new BrowserFactory(Env::get('chrome.bin_path', '/opt/google/chrome/chrome')); $browserFactory->setOptions([ 'userAgent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.41 Safari/537.36 Edg/101.0.1210.32', 'windowSize' => [1920, 1000], ]); $browser = $browserFactory->createBrowser(); try { $page = $browser->createPage(); $url = Env::get('webpage.customer_contacts_relation_graph_url') . "?company_id=$companyId"; $page->navigate($url)->waitForNavigation(Page::NETWORK_IDLE, 60000); $saveFilePath = $this->getSavePath($companyId); $page->screenshot([ 'captureBeyondViewport' => true, 'clip' => $page->getFullPageClip(), 'format' => 'jpeg', // default to 'png' - possible values: 'png', 'jpeg', 'quality' => 100 ])->saveToFile($saveFilePath); return $saveFilePath; }catch (\Exception $e){ $browser->close(); throw $e; } finally { $browser->close(); }
2022年05月10日
414 阅读
2022-05-10
centos系统Chrome浏览器网页中文显示乱码解决办法
```bash yum groupinstall "X Window System" -y yum -y groupinstall Fonts ```
2022年05月10日
174 阅读
2022-05-07
docker镜像php8.1.5-fpm包含swoole、redis、pdo_mysql、zip、imagick、gd等扩展以及composer的Dockerfile文件
FROM php:8.1.5-fpm-buster RUN sed -i s/deb.debian.org/mirrors.aliyun.com/g /etc/apt/sources.list \ && ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \ && echo 'Asia/Shanghai' > /etc/timezone \ && apt update \ && apt install libzip-dev -y \ && apt install vim -y \ && apt install build-essential -y \ && apt install libmagickcore-dev libmagickwand-dev -y \ && apt install libevent-dev -y \ && pecl install -o -f zip \ && docker-php-ext-enable zip \ && pecl install -o -f redis \ && docker-php-ext-enable redis \ && pecl install -o -f imagick \ && docker-php-ext-enable imagick \ && pecl install -o -f swoole \ && docker-php-ext-enable swoole \ && docker-php-ext-install gd \ && docker-php-ext-install bcmath \ && docker-php-ext-install pdo_mysql \ && docker-php-ext-install pcntl \ && docker-php-ext-install bz2 \ && php -r "copy('https://install.phpcomposer.com/installer', 'composer-setup.php');" \ && php composer-setup.php \ && mv composer.phar /usr/local/bin/composer
2022年05月07日
434 阅读
2022-04-21
阿里云rds数据库mysql版cpu占用100%排查问题过程
背景某天去到公司,用户反馈说系统响应很慢,甚至有些功能基本用不了,严重影响工作效率。测试同事说阿里云RDS数据库的CPU占用了100%,我打开阿里云dms的监控页面,确实如此,接着开始排查问题。问题排查过程因为前段时间遇到过代码死循环查询数据库导致了CPU占用100%的问题,所以一开始就往这个方向排查。首先通过阿里云的dms控制台执行show processlist命令查询数据库正在执行的线程如下 发现大量状态为sending data的线程,通过查询资料,这个状态的意思是读取和过滤数据,如果一个表数据量很大且没有索引的话,就容易出现sending data状态,官方解释是,线程正在读取和处理 SELECT 的行记录,发送给客户端,由于在这个状态下的操作会执行大量的磁盘访问(读),因此它通常是查询生命周期最长的状态。但具体为什么会占用大量CPU,还有待学习了解。之前的死循环会出现在一些同步erp数据到业务系统的定时任务中,因为需要同步大量的数据而使用了循环。使用上面的sql语句(info字段)搜索代码,发现只有一个定时任务的方法使用了这个语句,因此接着登录服务器查询这个定时任务,但是没有找到相应的定时任务,后来了解到原来一直没有配置,但是同事在前一天手动执行过这个定时任务,通过如下监控信息 发现从前一天下午5点09分开始数据库的CPU就开始飙升到100%了。通过ps命令找不到相关的定时任务进程正在执行,但为什么那些语句一直存在呢?然后在运维同事的帮助下,使用lsof和ll /proc/pid命令以及上面show processlist结果的端口查询到发起那个语句请求的进程是php-fpm,工作目录是tp框架的public目录,印象中tp框架的php think命令运行的模式是cli,因此导致sending data状态有可能不是定时任务导致的。因为当时没有及时排查出原因,所以采取了同事的建议将服务器重启。 重启后数据库的CPU确实降下来了,但是过了一会又升上去了。确定了不是由于定时任务导致的,接着继续排查代码中调用这个定时任务方法的地方,后来确实发现还有一个接口调用了这个方法,通过查询nginx的access.log日志,发现当时一直有IP频繁地请求着这个接口,初步认定是由于这个接口调用了这个方法导致的问题。接着和同事一起去查看这个方法的代码,但是却没有发现这个方法的问题,逻辑上产生死循环的逻辑也没有被发现。在测试环境模拟复现这个问题,发现在死循环中获取一个数据量为三万的表的同一条数据时(查询条件有加索引并命中)并不会导致CPU飙升,但是没有索引或没有命中索引的情况下,CPU就会一直飙升。 从上面排查的过程中,没有发现死循环,考虑到有些单据数据行比较多,所以模拟了短时间内循环查询并修改大量不同单据的情景,在命中索引的情况下,CPU占用不高,但是没有命中索引的情况下,CPU占用升到百分之五十多。接着看了生产环境相关的表,数据量大概是十万行,而且用于查询的entry_id字段并没有设置索引,因此同步数据时,如果数据量较大,循环插入或者更新数据时会导致数据库CPU占用持续升高。通过下面的监控图 119.23.123.173 - - [21/Apr/2022:11:10:03 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194500 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.176 - - [21/Apr/2022:11:10:07 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194249 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.174 - - [21/Apr/2022:11:10:09 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194045 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.179 - - [21/Apr/2022:11:10:09 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194045 HTTP/1.1" 201 1003 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.174 - - [21/Apr/2022:11:10:14 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194552 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.167 - - [21/Apr/2022:11:10:14 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194552 HTTP/1.1" 201 1892 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.164 - - [21/Apr/2022:11:10:17 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194613 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.154 - - [21/Apr/2022:11:10:26 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194548 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.169 - - [21/Apr/2022:11:10:31 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194229 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 47.112.84.217 - - [21/Apr/2022:11:10:31 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194249 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.165 - - [21/Apr/2022:11:10:32 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194264 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.178 - - [21/Apr/2022:11:10:35 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194592 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.170 - - [21/Apr/2022:11:10:39 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194500 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.159 - - [21/Apr/2022:11:10:41 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194580 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.170 - - [21/Apr/2022:11:10:41 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194580 HTTP/1.1" 201 1125 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.154 - - [21/Apr/2022:11:10:46 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194576 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.170 - - [21/Apr/2022:11:10:46 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194576 HTTP/1.1" 201 1296 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.154 - - [21/Apr/2022:11:10:51 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194536 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.171 - - [21/Apr/2022:11:10:53 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194613 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 47.112.84.213 - - [21/Apr/2022:11:10:56 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194264 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.163 - - [21/Apr/2022:11:10:57 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194524 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.172 - - [21/Apr/2022:11:11:02 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194548 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 47.112.84.216 - - [21/Apr/2022:11:11:02 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194500 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.166 - - [21/Apr/2022:11:11:06 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194508 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400"结合同事在前一天手动执行了定时任务并且是全量获取数据以及nginx的access.log日志的情况,从前一天执行了定时任务开始一直到第二天11点08分的CPU都是占满的状态,然后重启了服务器,CPU降了下来,接着因为相关接口被频繁调用,所以又导致CPU重新占满。问题原因数据量大的表且用于查询的字段没有设置索引,导致查询效率低。执行定时任务时没有传入增量获取的参数,采用了全量获取数据的方式进行同步数据,数据量较大,一直占用着数据库资源。解决办法与预防措施需要给数据量较大的表频繁查询的字段添加索引同步大量数据时,采用增量的方式,如果是需要重新获取全量数据,则尽量在晚上执行,且要考虑同步的时长是否会影响白天系统的使用。优化同步数据的方法,尽量避免在循环中调用数据库,造成数据库资源占用过高,影响系统性能。
2022年04月21日
1,405 阅读
2022-03-11
ERP收料通知单字段
一、请求参数说明: 1.formid:业务对象表单Id,字符串类型(必录) 2.data:JSON格式数据(详情参考JSON格式数据)(必录) 2.1.NeedUpDateFields:需要更新的字段,数组类型,格式:[key1,key2,...] (非必录)注(更新单据体字段得加上单据体key) 2.2.NeedReturnFields:需返回结果的字段集合,数组类型,格式:[key,entitykey.key,...](非必录) 注(返回单据体字段格式:entitykey.key) 2.3.IsDeleteEntry:是否删除已存在的分录,布尔类型,默认true(非必录) 2.4.SubSystemId:表单所在的子系统内码,字符串类型(非必录) 2.5.IsVerifyBaseDataField:是否验证所有的基础资料有效性,布尔类,默认false(非必录) 2.6.IsEntryBatchFill:是否批量填充分录,默认true(非必录) 2.7.ValidateFlag:是否验证标志,布尔类型,默认true(非必录) 2.8.NumberSearch:是否用编码搜索基础资料,布尔类型,默认true(非必录) 2.9.IsAutoAdjustField:是否自动调整JSON字段顺序,布尔类型,默认false(非必录) 2.10.InterationFlags:交互标志集合,字符串类型,分号分隔,格式:"flag1;flag2;..."(非必录) 例如(允许负库存标识:STK_InvCheckResult) 2.11.Model:表单数据包,JSON类型(必录) 备注: 1.示例Model数据包中字段顺序不建议改变,否则可能会有相互影响,如果出现字段值被覆盖或丢失,则可以尝试把字段顺序向后调整一下。 2.示例Model数据包默认包含允许引入的字段,实际按需构建既可。 3.如需创建关联关系,可参考http://club.kingdee.com/forum.php?mod=viewthread&tid=1394265 。 二、返回结果: {"Result":{"ResponseStatus":{"ErrorCode":"","IsSuccess":"false","Errors":[{"FieldName":"","Message":"","DIndex":0}],"SuccessEntitys":[{"Id":"","Number":"","DIndex":0}],"SuccessMessages":[{"FieldName":"","Message":"","DIndex":0}],"MsgCode":""},"Id":"","Number":"","NeedReturnData":[{}]}} 三、代码示例: // 使用webapi引用组件Kingdee.BOS.WebApi.Client.dll K3CloudApiClient client = new K3CloudApiClient("https://hopo.ik3cloud.com/K3cloud/"); var loginResult = client.ValidateLogin("20170307142733","Administrator","888888",2052); var resultType = JObject.Parse(loginResult)["LoginResultType"].Value<int>(); //登录结果类型等于1,代表登录成功 if (resultType == 1) { client.Save("PUR_ReceiveBill","{"NeedUpDateFields":[],"NeedReturnFields":[],"IsDeleteEntry":"true","SubSystemId":"","IsVerifyBaseDataField":"false","IsEntryBatchFill":"true","ValidateFlag":"true","NumberSearch":"true","IsAutoAdjustField":"false","InterationFlags":"","Model":{"FID":0,"FBillTypeID":{"FNUMBER":""},"FBillNo":"","FDate":"1900-01-01","FStockOrgId":{"FNumber":""},"FReceiveDeptId":{"FNumber":""},"FStockGroupId":{"FNumber":""},"FReceiverId":{"FNumber":""},"FDemandOrgId":{"FNumber":""},"FCorrespondOrgId":{"FNumber":""},"FPurOrgId":{"FNumber":""},"FPurDeptId":{"FNumber":""},"FPurGroupId":{"FNumber":""},"FPurchaserId":{"FNumber":""},"FSupplierId":{"FNumber":""},"FNote":"","FSupplyId":{"FNumber":""},"FSupplyAddress":"","FSettleId":{"FNumber":""},"FChargeId":{"FNumber":""},"FOwnerTypeIdHead":"","FOwnerIdHead":{"FNumber":""},"FConfirmerId":{"FUserID":""},"FConfirmDate":"1900-01-01","FIsInsideBill":"false","FIsMobile":"false","FScanBox":"","FProviderContactId":{"FCONTACTNUMBER":""},"FIsChecked":"false","FIsChangeQty":"false","FIncoming":"false","FACCTYPE":"","F_WH_SH":"","F_WH_KZ":"false","F_WH_TLKZ":"false","F_WH_yfk":"false","F_WH_SFJE":0,"F_WH_HZSL":0,"F_wh_qrrq":"1900-01-01","F_wh_jyrq":"1900-01-01","F_WH_jyry1":"","F_WH_QRRY1":"","F_WH_LLRKD":"","F_wh_PDJK":"false","F_WH_YWLX":"","F_WH_SP":{"FNumber":""},"F_WH_XTBJ":"false","F_WH_XTDD":"false","FinanceEntity":{"FEntryId":0,"FSettleOrgId":{"FNumber":""},"FSettleModeId":{"FNumber":""},"FSettleCurrId":{"FNumber":""},"FPayConditionId":{"FNumber":""},"FIsIncludedTax":"false","FPricePoint":"","FPriceListId":{"FNumber":""},"FDiscountListId":{"FNumber":""},"FLocalCurrId":{"FNumber":""},"FExchangeTypeId":{"FNumber":""},"FExchangeRate":0,"FISPRICEEXCLUDETAX":"false"},"FDetailEntity":[{"FEntryID":0,"FMaterialId":{"FNumber":""},"FMaterialDesc":"","FAuxPropId":{"FAUXPROPID__FF100001":"","FAUXPROPID__FF100002":{"FNumber":""}},"FUnitId":{"FNumber":""},"FActReceiveQty":0,"FPreDeliveryDate":"1900-01-01","FSUPDELQTY":0,"FPriceUnitId":{"FNumber":""},"FStockID":{"FNumber":""},"FStockLocId":{"FSTOCKLOCID__FF100006":{"FNumber":""},"FSTOCKLOCID__FF100007":{"FNumber":""},"FSTOCKLOCID__FF100008":{"FNumber":""},"FSTOCKLOCID__FF100009":{"FNumber":""},"FSTOCKLOCID__FF100010":{"FNumber":""},"FSTOCKLOCID__FF100011":{"FNumber":""},"FSTOCKLOCID__FF100014":{"FNumber":""},"FSTOCKLOCID__FF100015":{"FNumber":""},"FSTOCKLOCID__FF100016":{"FNumber":""},"FSTOCKLOCID__FF100017":{"FNumber":""}},"FStockStatusId":{"FNumber":""},"FLot":{"FNumber":""},"FRejectReason":"","FProduceDate":"1900-01-01","FDemandDeptId":{"FNumber":""},"FDemanderId":{},"FGiveAway":"false","FChargeProjectID":{"FNumber":""},"FCtrlStockInPercent":"false","FMtoNo":"","FExtAuxUnitId":{"FNumber":""},"FExtAuxUnitQty":0,"FProjectNo":"","FCheckJoinBaseQty":0,"FReceiveBaseQty":0,"FRefuseBaseQty":0,"FSampleDamageBaseQty":0,"FCheckJoinQty":0,"FReceiveQty":0,"FRefuseQty":0,"FSampleDamageQty":0,"FCheckInComing":"false","FDeliverySite":"","FCardJoinQty":0,"FCardQty":0,"FCardBaseQty":0,"FCardJoinBaseQty":0,"FCheckBaseQty":0,"FCheckQty":0,"FTransferBaseQty":0,"FIsReceiveUpdateStock":"false","FTransferQty":0,"FBomId":{"FNumber":""},"FSupplierLot":"","FExpiryDate":"1900-01-01","FAuxUnitQty":0,"FDescription":"","FStockInMaxQty":0,"FStockInMinQty":0,"FEntryTaxRate":0,"FTaxCombination":{"FNumber":""},"FDiscountRate":0,"FPrice":0,"FTaxPrice":0,"FProcScrapBaseQty":0,"FProcScrapQty":0,"FMtrlScrapBaseQty":0,"FMtrlScrapQty":0,"FCsnReceiveBaseQty":0,"FCsnReceiveQty":0,"FRefuseJoinBaseQty":0,"FRefuseJoinQty":0,"FCsnReceiveJoinBaseQty":0,"FCsnReceiveJoinQty":0,"FPriceBaseQty":0,"FSetPriceUnitID":{"FNumber":""},"FStockUnitID":{"FNumber":""},"FStockQty":0,"FStockBaseQty":0,"FActlandQty":0,"FConfirmDeliQty":0,"FConfirmDeliDate":"1900-01-01","FConfirmInfo":"","FXTRecQty":0,"FTest":"","FExplain":"","F_UN_HH":"","F_UN_TH":0,"F_UN_DDDJ":0,"F_UN_DDJS":0,"F_UN_S":0,"F_UN_DDSL":0,"F_WH_RKS":0,"FPriceDiscount":0,"F_WH_QSH":"false","F_WH_BL":"false","FACCRATE":0,"F_CKSL":0,"F_WH_zs":0,"FRejectsDiscountAmount":0,"FJoinRejectsDiscountAmount":0,"F_WH_jhrq":"1900-01-01","F_CGDDDJLX":"","F_WH_PZYC":"","F_wh_blxx":{"FNumber":""},"F_WH_DJYQty":0,"F_wh_DQRQty":0,"F_wh_yjjhrq":"1900-01-01","F_wh_JHDZ":"","F_wh_shgs":0,"F_wh_cjsl":0,"F_wh_blQty":0,"F_WH_CLFA":{"FNumber":""},"F_wh_thlx":{"FNumber":""},"F_wh_dqr":"false","F_SQ_SP":"","F_WH_SLZT":"","FTaxDetailSubEntity":[{"FDetailID":0,"FTaxRate":0}],"FSerialSubEntity":[{"FDetailID":0,"FSerialNo":"","FSerialNote":""}]}],"FReceiveTrace":[{"FEntryID":0,"FLogComId":{"FCODE":""},"FCarryBillNo":"","FTraceDetail":[{"FDetailID":0}]}]}}"); } 四、JSON格式数据: { "NeedUpDateFields": [], "NeedReturnFields": [], "IsDeleteEntry": "true", "SubSystemId": "", "IsVerifyBaseDataField": "false", "IsEntryBatchFill": "true", "ValidateFlag": "true", "NumberSearch": "true", "IsAutoAdjustField": "false", "InterationFlags": "", "Model": { "FID": 0, "FBillTypeID": { "FNUMBER": "" }, "FBillNo": "", "FDate": "1900-01-01", "FStockOrgId": { "FNumber": "" }, "FReceiveDeptId": { "FNumber": "" }, "FStockGroupId": { "FNumber": "" }, "FReceiverId": { "FNumber": "" }, "FDemandOrgId": { "FNumber": "" }, "FCorrespondOrgId": { "FNumber": "" }, "FPurOrgId": { "FNumber": "" }, "FPurDeptId": { "FNumber": "" }, "FPurGroupId": { "FNumber": "" }, "FPurchaserId": { "FNumber": "" }, "FSupplierId": { "FNumber": "" }, "FNote": "", "FSupplyId": { "FNumber": "" }, "FSupplyAddress": "", "FSettleId": { "FNumber": "" }, "FChargeId": { "FNumber": "" }, "FOwnerTypeIdHead": "", "FOwnerIdHead": { "FNumber": "" }, "FConfirmerId": { "FUserID": "" }, "FConfirmDate": "1900-01-01", "FIsInsideBill": "false", "FIsMobile": "false", "FScanBox": "", "FProviderContactId": { "FCONTACTNUMBER": "" }, "FIsChecked": "false", "FIsChangeQty": "false", "FIncoming": "false", "FACCTYPE": "", "F_WH_SH": "", "F_WH_KZ": "false", "F_WH_TLKZ": "false", "F_WH_yfk": "false", "F_WH_SFJE": 0, "F_WH_HZSL": 0, "F_wh_qrrq": "1900-01-01", "F_wh_jyrq": "1900-01-01", "F_WH_jyry1": "", "F_WH_QRRY1": "", "F_WH_LLRKD": "", "F_wh_PDJK": "false", "F_WH_YWLX": "", "F_WH_SP": { "FNumber": "" }, "F_WH_XTBJ": "false", "F_WH_XTDD": "false", "FinanceEntity": { "FEntryId": 0, "FSettleOrgId": { "FNumber": "" }, "FSettleModeId": { "FNumber": "" }, "FSettleCurrId": { "FNumber": "" }, "FPayConditionId": { "FNumber": "" }, "FIsIncludedTax": "false", "FPricePoint": "", "FPriceListId": { "FNumber": "" }, "FDiscountListId": { "FNumber": "" }, "FLocalCurrId": { "FNumber": "" }, "FExchangeTypeId": { "FNumber": "" }, "FExchangeRate": 0, "FISPRICEEXCLUDETAX": "false" }, "FDetailEntity": [ { "FEntryID": 0, "FMaterialId": { "FNumber": "" }, "FMaterialDesc": "", "FAuxPropId": { "FAUXPROPID__FF100001": "", "FAUXPROPID__FF100002": { "FNumber": "" } }, "FUnitId": { "FNumber": "" }, "FActReceiveQty": 0, "FPreDeliveryDate": "1900-01-01", "FSUPDELQTY": 0, "FPriceUnitId": { "FNumber": "" }, "FStockID": { "FNumber": "" }, "FStockLocId": { "FSTOCKLOCID__FF100006": { "FNumber": "" }, "FSTOCKLOCID__FF100007": { "FNumber": "" }, "FSTOCKLOCID__FF100008": { "FNumber": "" }, "FSTOCKLOCID__FF100009": { "FNumber": "" }, "FSTOCKLOCID__FF100010": { "FNumber": "" }, "FSTOCKLOCID__FF100011": { "FNumber": "" }, "FSTOCKLOCID__FF100014": { "FNumber": "" }, "FSTOCKLOCID__FF100015": { "FNumber": "" }, "FSTOCKLOCID__FF100016": { "FNumber": "" }, "FSTOCKLOCID__FF100017": { "FNumber": "" } }, "FStockStatusId": { "FNumber": "" }, "FLot": { "FNumber": "" }, "FRejectReason": "", "FProduceDate": "1900-01-01", "FDemandDeptId": { "FNumber": "" }, "FDemanderId": {}, "FGiveAway": "false", "FChargeProjectID": { "FNumber": "" }, "FCtrlStockInPercent": "false", "FMtoNo": "", "FExtAuxUnitId": { "FNumber": "" }, "FExtAuxUnitQty": 0, "FProjectNo": "", "FCheckJoinBaseQty": 0, "FReceiveBaseQty": 0, "FRefuseBaseQty": 0, "FSampleDamageBaseQty": 0, "FCheckJoinQty": 0, "FReceiveQty": 0, "FRefuseQty": 0, "FSampleDamageQty": 0, "FCheckInComing": "false", "FDeliverySite": "", "FCardJoinQty": 0, "FCardQty": 0, "FCardBaseQty": 0, "FCardJoinBaseQty": 0, "FCheckBaseQty": 0, "FCheckQty": 0, "FTransferBaseQty": 0, "FIsReceiveUpdateStock": "false", "FTransferQty": 0, "FBomId": { "FNumber": "" }, "FSupplierLot": "", "FExpiryDate": "1900-01-01", "FAuxUnitQty": 0, "FDescription": "", "FStockInMaxQty": 0, "FStockInMinQty": 0, "FEntryTaxRate": 0, "FTaxCombination": { "FNumber": "" }, "FDiscountRate": 0, "FPrice": 0, "FTaxPrice": 0, "FProcScrapBaseQty": 0, "FProcScrapQty": 0, "FMtrlScrapBaseQty": 0, "FMtrlScrapQty": 0, "FCsnReceiveBaseQty": 0, "FCsnReceiveQty": 0, "FRefuseJoinBaseQty": 0, "FRefuseJoinQty": 0, "FCsnReceiveJoinBaseQty": 0, "FCsnReceiveJoinQty": 0, "FPriceBaseQty": 0, "FSetPriceUnitID": { "FNumber": "" }, "FStockUnitID": { "FNumber": "" }, "FStockQty": 0, "FStockBaseQty": 0, "FActlandQty": 0, "FConfirmDeliQty": 0, "FConfirmDeliDate": "1900-01-01", "FConfirmInfo": "", "FXTRecQty": 0, "FTest": "", "FExplain": "", "F_UN_HH": "", "F_UN_TH": 0, "F_UN_DDDJ": 0, "F_UN_DDJS": 0, "F_UN_S": 0, "F_UN_DDSL": 0, "F_WH_RKS": 0, "FPriceDiscount": 0, "F_WH_QSH": "false", "F_WH_BL": "false", "FACCRATE": 0, "F_CKSL": 0, "F_WH_zs": 0, "FRejectsDiscountAmount": 0, "FJoinRejectsDiscountAmount": 0, "F_WH_jhrq": "1900-01-01", "F_CGDDDJLX": "", "F_WH_PZYC": "", "F_wh_blxx": { "FNumber": "" }, "F_WH_DJYQty": 0, "F_wh_DQRQty": 0, "F_wh_yjjhrq": "1900-01-01", "F_wh_JHDZ": "", "F_wh_shgs": 0, "F_wh_cjsl": 0, "F_wh_blQty": 0, "F_WH_CLFA": { "FNumber": "" }, "F_wh_thlx": { "FNumber": "" }, "F_wh_dqr": "false", "F_SQ_SP": "", "F_WH_SLZT": "", "FTaxDetailSubEntity": [ { "FDetailID": 0, "FTaxRate": 0 } ], "FSerialSubEntity": [ { "FDetailID": 0, "FSerialNo": "", "FSerialNote": "" } ] } ], "FReceiveTrace": [ { "FEntryID": 0, "FLogComId": { "FCODE": "" }, "FCarryBillNo": "", "FTraceDetail": [ { "FDetailID": 0 } ] } ] } } 五、字段说明: 基本信息:FBillHead 实体主键:FID 单据编号:FBillNo 单据状态:FDocumentStatus 收料组织:FStockOrgId (必填项) 收料日期:FDate (必填项) 单据类型:FBillTypeID (必填项) 货主类型:FOwnerTypeIdHead (必填项) 货主:FOwnerIdHead (必填项) 供应商:FSupplierId (必填项) 送货单号:FSendBillNo 提货单号:FLadBillNo 承运商:FCarrierId 收料部门:FReceiveDeptId 库存组:FStockGroupId 收料员:FReceiverId 采购组织:FPurOrgId (必填项) 采购部门:FPurDeptId 采购组:FPurGroupId 采购员:FPurchaserId 备注:FNote 创建人:FCreatorId 创建日期:FCreateDate 最后修改人:FModifierId 最后修改日期:FModifyDate 审核日期:FApproveDate 审核人:FApproverId 作废人:FCancellerId 作废日期:FCancelDate 作废状态:FCancelStatus 供货方联系人(旧):FSupplyContact 结算方:FSettleId 供货方:FSupplyId 收款方:FChargeId 整单关闭状态:FCloseStatus 业务类型:FBusinessType 需要检验:FNeedCheck 需求组织:FDemandOrgId 供货方地址:FSupplyAddress 对应组织:FCorrespondOrgId 确认状态:FConfirmStatus 确认人:FConfirmerId 确认日期(停用):FConfirmDate 序列号上传:FScanBox 外部单据:FIsInsideBill 供货方联系人:FProviderContactId 来自移动:FIsMobile 变更数量操作:FIsChangeQty 验收方式:FACCTYPE 供应商编码:F_GYSBM 已检验:FIsChecked 已来料:FIncoming 事项:F_WH_SH 自动下推控制按钮:F_WH_KZ 退料控制:F_WH_TLKZ 预付款:F_WH_yfk 创建人部门:F_CJRBM 实付金额:F_WH_SFJE 收料数量汇总:F_WH_HZSL 确认日期:F_wh_qrrq 检验日期:F_wh_jyrq 检验人员:F_WH_jyry1 确认人员:F_WH_QRRY1 入库人员:F_WH_LLRKD 协同历史数据判断:F_wh_PDJK 是否同步协同:F_wh_xtpt 采购订单业务类型:F_WH_YWLX 产品首批选型:F_WH_SP 协同标记:F_WH_XTBJ HOPO协同单:F_WH_XTDD 财务信息:FinanceEntity 实体主键:FEntryId 付款组织:FPayOrgId 结算组织:FSettleOrgId (必填项) 结算方式:FSettleModeId 付款条件:FPayConditionId 税额:FBillTaxAmount 金额:FBillAmount 价税合计:FBillAllAmount 价目表:FPriceListId 折扣表:FDiscountListId 定价时点:FPricePoint (必填项) 结算币别:FSettleCurrId (必填项) 汇率类型:FExchangeTypeId 汇率:FExchangeRate 本位币:FLocalCurrId 税额(本位币):FBillTaxAmount_LC 价税合计(本位币):FBillAllAmount_LC 金额(本位币):FBillAmount_LC 含税:FIsIncludedTax 价外税:FISPRICEEXCLUDETAX 明细信息:FDetailEntity 实体主键:FEntryID 物料编码:FMaterialId (必填项) 物料名称:FMaterialName 规格型号:FMateriaModel 辅助属性:FAuxPropId 长度:FF100001 颜色:FF100002 物料类别:FMateriaType 实到数量:FActlandQty 交货数量:FActReceiveQty 仓库:FStockID 库存状态:FStockStatusId BOM版本:FBomId 供应商批号:FSupplierLot 生产日期:FProduceDate 有效期至:FExpiryDate 库存辅单位数量:FAuxUnitQty 需求部门:FDemandDeptId 控制入库数量:FCtrlStockInPercent 入库上限:FStockInMaxQty 入库下限:FStockInMinQty 合格入库关联数量:FInStockJoinQty 入库数量:FInStockQty 免费:FIsFree 计价数量:FPriceUnitQty 折扣率%:FDiscountRate 净价:FTaxNetPrice 金额:FAmount 税率%:FEntryTaxRate 单价:FPrice 税额:FEntryTaxAmount 价税合计:FAllAmount 需求跟踪号:FReqTraceNo 订单单号:FOrderBillNo 含税单价:FTaxPrice 价格下限:FMinPrice 价格上限:FMaxPrice 备注:FDescription 金额(本位币):FAmount_LC 税额(本位币):FTaxAmount_LC 价税合计(本位币):FAllAmount_LC 需求人:FDemanderId 价格系数:FPriceCoefficient 系统定价:FSysPrice 拒收数量:FRejectQty 拒收原因:FRejectReason 库存更新标志:FStockFlag 货主类型:FOwnerTypeId 货主:FOwnerId 保管者类型:FKeeperTypeId 保管者:FKeeperId 采购基本数量:FBaseUnitQty 退料关联数量(基本单位):FReturnJoinBaseQty 退料数量(基本单位):FReturnBaseQty 合格入库关联数量(基本单位):FInStockJoinBaseQty 入库数量(基本单位):FInStockBaseQty 退料数量:FReturnQty 退料关联数量:FReturnJoinQty 基本单位:FBaseUnitId 收料单位:FUnitId (必填项) 计价单位:FPriceUnitId (必填项) 库存辅单位:FAuxUnitId 合同单号:FContactNo 交货地址:FDeliveryAddress 基本单位关联数量(组):FJoinBaseQty 仓位:FStockLocId 新成品仓位:FF100006 新配件仓位:FF100007 配件仓位:FF100008 不良配件仓位:FF100009 新包材仓位:FF100010 不良成品仓位:FF100011 滞留配件仓位:FF100014 滞留成品仓位:FF100015 返修仓位:FF100016 行政仓位:FF100017 源单内码:FSrcId 源单分录内码:FSrcEntryId 保质期:FExpPeriod 保质期单位:FExpUnit 分录关闭状态:FMRPCloseStatus 源单类型:FSrcFormId 源单单号:FSrcBillNo 在架寿命期:FShelfLife 批号:FLot 交货地点(2.0删除):FDeliverySite 税组合:FTaxCombination 折扣额:FDiscount 物料说明:FMaterialDesc 关联应付数量(计价基本):FBaseAPJoinQty 入库上限(基本单位数量):FBaseStockInMaxQty 入库下限(基本单位数量):FBaseStockInMinQty 业务流程:FBFLowId 实收数量:FMustQty 计划跟踪号:FMtoNo 项目编号:FProjectNo 是否赠品:FGiveAway 费用项目:FChargeProjectID 合格入库关联数量(辅单位):FINSTOCKJOINSECQTY 退货关联数量(辅单位):FRETURNJOINSECQTY 紧急放行:FEmergencyRelease 检验关联数量(基本单位):FCheckJoinBaseQty 合格数量(基本单位):FReceiveBaseQty 判退数量(基本单位):FRefuseBaseQty 样本破坏数量(基本单位):FSampleDamageBaseQty 检验关联数量:FCheckJoinQty 合格数量:FReceiveQty 判退数量:FRefuseQty 样本破坏数量:FSampleDamageQty 来料检验:FCheckInComing 卡片关联数量:FCardJoinQty 卡片数量:FCardQty 卡片数量(基本单位):FCardBaseQty 卡片关联数量(基本单位):FCardJoinBaseQty 检验数量(基本单位):FCheckBaseQty 检验数量:FCheckQty 累计调拨数量(基本单位):FTransferBaseQty 累计调拨数量:FTransferQty 收料更新库存(废弃):FIsReceiveUpdateStock 辅单位:FExtAuxUnitId 实收数量(辅单位):FExtAuxUnitQty 工废数量(基本单位):FProcScrapBaseQty 工废数量:FProcScrapQty 料废数量(基本单位):FMtrlScrapBaseQty 料废数量:FMtrlScrapQty 工废关联数量(基本单位):FProcScrapJoinBaseQty 工废关联数量:FProcScrapJoinQty 料废关联数量(基本单位):FMtrlScrapJoinBaseQty 料废关联数量:FMtrlScrapJoinQty 预计到货日期:FPreDeliveryDate 让步接收数量(基本单位):FCsnReceiveBaseQty 让步接收数量:FCsnReceiveQty 不合格关联数量(基本单位):FRefuseJoinBaseQty 不合格关联数量:FRefuseJoinQty 让步接收关联数量(基本单位):FCsnReceiveJoinBaseQty 让步接收关联数量:FCsnReceiveJoinQty 计价基本数量:FPriceBaseQty 定价单位:FSetPriceUnitID 库存单位:FStockUnitID (必填项) 库存单位数量:FStockQty 库存基本数量:FStockBaseQty 采购基本分子:FPurBaseNum 库存基本分母:FStockBaseDen 携带的主业务单位:FSRCBIZUNITID 合格入库库存关联数量(基本单位):FSTOCKJOINBASEQTY 退料库存关联数量(基本单位):FRETURNSTKJNBASTQTY 关联应付数量(库存基本):FStockBaseAPJoinQty 供应商交货数量:FSUPDELQTY 执行人:FEXECUTEID 执行日期:FEXECUTEDATE 行状态:FENTRYSTATUS 分录价目表:FPriceListEntry 采购订单分录内码:FPOORDERENTRYID 确认交货数量:FConfirmDeliQty 确认到货日期:FConfirmDeliDate 确认意见:FConfirmInfo 序列号单位:FSNUNITID 序列号单位数量:FSNQTY 是否同步第三方(GY):FISSYNTOTHIRD 产品类型:FRowType 父项产品:FPARENTMATID 单价折扣:FPriceDiscount 价目表分录id:FPriLstEntryId 样本破坏入库关联数量(基本单位):FSDJNBASEQTY 供应商承担样本破坏基本数量:FJYSUPSAMDANQTY 验收比例%:FACCRATE 订单数量:FPOQTY 不良品折让金额:FRejectsDiscountAmount 入库关联不良品折让金额:FJoinRejectsDiscountAmount 尾差处理标识:FTailDiffFlag 收料数量(校验):FXTRecQty 质检说明(不启用):FTest 质检说明:FExplain 采购订单行号:F_UN_HH 退货数:F_UN_TH 订单含税单价:F_UN_DDDJ 订单价税合计:F_UN_DDJS 订单税率:F_UN_S 订单数量:F_UN_DDSL 入库数:F_WH_RKS 少货:F_WH_QSH 是否合格:F_WH_BL 费用物料已出库数量:F_CKSL 物流部物料分类:F_WH_FL 支数:F_WH_zs 是否门窗系统物料:F_WH_MC 年度备货日期:F_WH_jhrq 采购订单单据类型:F_CGDDDJLX 品质异常描述:F_WH_PZYC 不良类型:F_wh_blxx 待检验数量:F_WH_DJYQty 待确认数量:F_wh_DQRQty 预计交货日期:F_wh_yjjhrq 交货地址:F_wh_JHDZ 损耗工时:F_wh_shgs 抽检数量:F_wh_cjsl 不合格数量:F_wh_blQty 处理方案:F_WH_CLFA 退货类型:F_wh_thlx VMI物料:F_WH_vmiwl 待确认:F_wh_dqr 产品首批选型:F_SQ_SP 收料状态:F_WH_SLZT 是否VMI毛坯:F_SQ_VMIMP 税务明细:FTaxDetailSubEntity 实体主键:FDetailID 税率名称:FTaxRateId 税率%:FTaxRate 税额:FTaxAmount 计入成本比例%:FCostPercent 计入成本金额:FCostAmount 增值税:FVAT 卖方代扣代缴:FSellerWithholding 买方代扣代缴:FBuyerWithholding 辅助属性|序列号:FSerialSubEntity 实体主键:FDetailID 序列号:FSerialNo 序列号:FSerialId 备注:FSerialNote 物料:FSRMATERIALID 数量(辅序):FSRQTY 基本单位数量(辅序):FSRBASEQTY 入库关联数量(辅序):FSRJOINQTY 入库关联基本数量(辅序):FSRJOINBASEQTY 检验结果:FSRINSPECTRESULT 退料关联基本数量(辅序):FSRMRBJOINBASEQTY 退料关联数量(辅序):FSRMRBJOINQTY 使用决策:FUSEPOLICY 辅助属性(辅序):FSRAUXPROPID 长度:FF100001 颜色:FF100002 供应商批号(辅序):FSRSUPPLYLOT 生产日期(辅序):FSRPRODUCEDATE 有效期至(辅序):FSREXPIRYDATE 批号(辅序):FSRLOT 物流跟踪:FReceiveTrace 实体主键:FEntryID 物流公司:FLogComId 物流单号:FCarryBillNo 物流详情:FTraceDetail 实体主键:FDetailID 物流时间:FTdTime 物流详情:FTdContent 关联关系表:FDetailEntity_Link 实体主键:FLinkId 业务流程图:FDetailEntity_Link_FFlowId 推进路线:FDetailEntity_Link_FFlowLineId 转换规则:FDetailEntity_Link_FRuleId 源单表内码:FDetailEntity_Link_FSTableId 源单表:FDetailEntity_Link_FSTableName 源单内码:FDetailEntity_Link_FSBillId 源单分录内码:FDetailEntity_Link_FSId 原始携带量:FDetailEntity_Link_FBaseUnitQtyOld 修改携带量:FDetailEntity_Link_FBaseUnitQty 原始携带量:FDetailEntity_Link_FStockBaseQtyOld 修改携带量:FDetailEntity_Link_FStockBaseQty 迁移图:FDetailEntity_Link_FLnkTrackerId 上游状态:FDetailEntity_Link_FLnkSState 数量FLnk:FDetailEntity_Link_FLnkAmount
2022年03月11日
368 阅读
2022-03-05
thinkphp5.1框架写的接口返回500错误以及空结果,捕获不了异常问题
thinkphp5.1框架写的接口返回500错误以及空结果,捕获不了异常问题
2022年03月05日
389 阅读
2022-03-03
Redis持久化方式对比
Redis持久化方式对比
2022年03月03日
317 阅读
2022-03-01
解决Gitlab进行clone、push、pull的时候报错aborting due to possible repository corruption on the remote side. git-pack-objects died with error.index-pack failed问题
问题代码管理用的是gitlab,某一天在本地进行clone、push、pull等操作的时候报以下错误 remote: aborting due to possible repository corruption on the remote side. error: pack-objects died of signal 9 error: git upload-pack: git-pack-objects died with error. fatal: git upload-pack: aborting due to possible repository corruption on the remote side. fatal: early EOF fatal: index-pack failed error: remote unpack failed: unpack-objects abnormal exit解决办法网上各种解决办法,例如设置压缩、内存不足等等都试过了,就是解决不了。通过gitlab-ctl tail也排查不出异常。最后通过以下命令重启gitlab服务解决了,但还不清楚具体原因。systemctl stop gitlab-runsvdir && systemctl start gitlab-runsvdir20230602更新升级Gitlab之后就没出现过这个问题了
2022年03月01日
1,302 阅读
1
...
4
5
6
...
13