FinancialManager.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299
  1. <?php
  2. namespace app\cxinv\controller;
  3. use app\cxinv\model\FinancialCheck as FinancialCheck;
  4. use app\cxinv\model\ManagerProduct;
  5. use app\cxinv\model\ProductFz;
  6. use think\App;
  7. class FinancialManager extends Base{
  8. public function __construct(App $app) {
  9. parent::__construct($app);
  10. $this->model=new \app\cxinv\model\FinancialManager();
  11. }
  12. public function List(){
  13. $param = $this->request->param(["code"=>"","type"=>[],"seller_code"=>"","buyer_code"=>"","orderCode"=>"","cxCode"=>"",
  14. "goodNo"=>"","inv_number"=>"","inv_buyer_code"=>"",'inv_seller_code'=>"",'channel'=>[],'status'=>"","start"=>"","end"=>"",
  15. "page"=>1,"size"=>15],"post","trim");
  16. $where=[];
  17. if($param['code']!="") $where[]= ["code","=","%{$param['code']}%"];
  18. if(!empty($param['type'])) $where[]= ["type","in",$param['type']];
  19. if(!empty($param['channel'])) $where[]= ["channel","in",$param['channel']];
  20. if($param['status']!="") $where[]= ["status","in",$param['status']];
  21. if($param['start']!="") $where[]= ["create_time",">=",startTime($param['start'])];
  22. if($param['end']!="") $where[]= ["create_time","<=",endTime($param['end'])];
  23. if($param['seller_code']!="") $where[]= ["seller_code","=",$param['seller_code']];
  24. if($param['buyer_code']!="") $where[]= ["buyer_code","=",$param['buyer_code']];
  25. if($param['orderCode']!="") $where[]= ["orderCode","like", "%{$param['orderCode']}%"];
  26. if($param['cxCode']!="") $where[]= ["cxCode","like","%{$param['cxCode']}%"];
  27. if($param['goodNo']!="") $where[]= ["goodNo","like","%{$param['goodNo']}%"];
  28. if($param['inv_number']!="") $where[]= ["inv_number","like","%{$param['inv_number']}%"];
  29. if($param['inv_buyer_code']!="") $where[]= ["inv_buyer_code","=",$param['inv_buyer_code']];
  30. if($param['inv_seller_code']!="") $where[]= ["inv_seller_code","=",$param['inv_seller_code']];
  31. $list = $this->model->with(['ProductRela'=>["product"]])
  32. ->where($where)
  33. ->order("id desc")
  34. ->paginate(['page'=>$param['page'],'list_rows'=>$param['size']]);
  35. return success('获取成功',['list'=>$list->items(),'count'=>$list->total()]);
  36. }
  37. // 'code'=>'string',//订单或记录的唯一标识符
  38. // 'type'=>'int',//记录类型 1入库 2出库 3入库红冲 4出库红冲
  39. // 'source'=>'int',//数据来源,1结算 2 线下订单
  40. // channel=>'int',//渠道,1订单 2 线下订单 3 toC订单
  41. // 'seller_code'=>'string',//卖方代码
  42. // 'seller_name'=>'string',//卖方名称
  43. // 'buyer_code'=>'string',//买方代码
  44. // 'buyer_name'=>'string',//买方名称
  45. // 'orderCode'=>'string',//订单编号
  46. // 'cxCode'=>'string',//客户编号
  47. // 'poCode'=>'string',//采购订单编号
  48. // 'platform_type'=>'int',//平台类型,1ToB 2ToC
  49. // 'goodNo'=>'string',//商品编号
  50. // 'goodName'=>'string',//商品名称
  51. // 'unit'=>'string',//商品单位
  52. // 'num'=>'int',//商品数量
  53. // 'goodPrice'=>'decimal',//商品单价
  54. // 'totalPrice'=>'decimal',//商品总价
  55. // 'cat_code'=>'string',//商品分类代码
  56. // 'cat_name'=>'string',//商品分类名称
  57. // 'tax'=>'decimal',//税率或税费
  58. // 'inv_fee'=>'decimal',//发票费用
  59. // 'inv_seller_code'=>'string',//发票卖方代码
  60. // 'inv_seller_name'=>'string',//发票卖方名称
  61. // 'inv_buyer_code'=>'string',//发票买方代码
  62. // 'inv_buyer_name'=>'string',//发票买方名称
  63. // 'inv_number'=>'string',//发票编号
  64. // 'inv_type'=>'string',//发票类型
  65. // 'inv_item_id'=>'int',//发票项目ID
  66. // 'inv_good_name'=>'string',//发票商品名称
  67. // 'inv_cat_code'=>'string',//发票商品分类代码
  68. // 'inv_spec'=>'string',//发票商品规格
  69. // 'inv_unit'=>'string',//发票商品单位
  70. // 'inv_num'=>'int',//发票商品数量
  71. // 'inv_subprice'=>'decimal',//发票商品子项单价
  72. // 'inv_subtotal'=>'decimal',//发票商品子项总价
  73. // 'inv_tax'=>'decimal',//发票税额
  74. // 'inv_tax_total'=>'decimal',//发票总税额
  75. // 'inv_price'=>'decimal',//发票单价
  76. // 'inv_total'=>'decimal',//发票总价
  77. // 'cat_diff'=>'int',//分类差异
  78. // 'tax_diff'=>'int',//税费差异
  79. // 'remark'=>'string',//备注或说明
  80. public function create(){
  81. $list=$this->request->post("list",[],"trim");
  82. if(empty($list)) return error("请传入数据");
  83. foreach ($list as $key=>&$item){
  84. $valid = $this->validate($item,[
  85. 'type|单据类型'=>'require|in:1,2,3,4',
  86. 'source|单据来源'=>'require|in:1,2',
  87. "channel|渠道"=>'require|in:1,2,3',
  88. 'invoiceCode|发票代码'=>'max:255',
  89. 'seller_code|卖方公司纳税识别号'=>'require|max:255',
  90. 'seller_name|卖方公司名称'=>'require|max:255',
  91. 'buyer_code|买方公司纳税识别号'=>'require|max:255',
  92. 'buyer_name|买方公司名称'=>'require|max:255',
  93. 'orderCode|订单号'=>'max:255',
  94. 'cxCode|主订单号'=>'max:255',
  95. 'poCode|Po订单号'=>'max:255',
  96. 'platform_type|平台类型'=>'require|in:1,2',
  97. 'goodType|商品类型'=>'require|in:1,2,3',
  98. 'goodNo|商品编号'=>'require|max:255',
  99. 'goodName|商品名称'=>'require|max:255',
  100. 'unit|商品单位'=>'require|max:255',
  101. 'num|商品数量'=>'require|integer',
  102. 'goodPrice|商品单价'=>'require|float',
  103. 'totalPrice|商品总价'=>'require|float',
  104. 'cat_code|商品分类代码'=>'require|max:255',
  105. 'cat_name|商品分类名称'=>'require|max:255',
  106. 'tax|税率或税费'=>'require|float',
  107. 'inv_fee|发票关联费用'=>'float',
  108. 'inv_seller_code|发票卖方代码'=>'max:255',
  109. 'inv_seller_name|发票卖方名称'=>'max:255',
  110. 'inv_buyer_code|发票买方代码'=>'max:255',
  111. 'inv_buyer_name|发票买方名称'=>'max:255',
  112. 'inv_number|发票编号'=>'max:255',
  113. 'inv_type|发票类型'=>'max:255',
  114. 'inv_open_date|发票开票日期'=>'max:255',
  115. 'inv_item_id|发票项目ID'=>'integer',
  116. 'inv_good_name|发票商品名称'=>'max:255',
  117. 'inv_cat_code|发票商品分类代码'=>'max:255',
  118. 'inv_spec|发票商品规格'=>'max:255',
  119. 'inv_unit|发票商品单位'=>'max:255',
  120. 'inv_num|发票商品数量'=>'float',
  121. 'inv_subprice|发票商品税后单价'=>'float',
  122. 'inv_subtotal|发票商品税后总价'=>'float',
  123. 'inv_tax|发票税额'=>'max:255',
  124. 'inv_tax_total|发票总税额'=>'float',
  125. 'inv_price|发票单价'=>'float',
  126. 'inv_total|发票总价'=>'float',
  127. 'cat_diff|分类差异'=>'max:255',
  128. 'tax_diff|税费差异'=>'max:255',
  129. 'remark|备注'=>'max:255',
  130. 'relaArr|关联数据'=>'array',
  131. 'fz_date|入账月份'=>'max:255'
  132. ]);
  133. if($valid!==true)return error($valid);
  134. if($item['channel']==1){
  135. $check = $this->model->CheckDatas($item);
  136. if(!empty($check)) return error("数据校验不通过",1004,$check);
  137. }
  138. if($item['tax']!='' && $item['inv_tax']!=''){
  139. $item['inv_tax'] = str_replace("%","",$item['inv_tax']);
  140. $item['tax_diff'] = $item['tax']==$item['inv_tax']?1:2;
  141. }
  142. if($item['cat_code']!='' && $item['inv_cat_code']!=''){
  143. $item['cat_diff'] = $item['cat_code']==$item['inv_cat_code']?1:2;
  144. }
  145. $companyCode= in_array($item['type'],['2','4'])?$item['seller_code']:$item['buyer_code'];
  146. $fz_date = ProductFz::where(['company_code'=>$companyCode,'fz_date'=>$item['fz_date']])->findOrEmpty();
  147. if($fz_date->isEmpty()) return error("请先生成封账单");
  148. if($fz_date->status!=0) return error("{$item['fz_date']}封账状态不可用");
  149. $item['apply_id']=$this->uid;
  150. $item['apply_name']=$this->uname;
  151. $item['code']= makeNo("PM", count($list)==1?"":str_pad(strval($key),4,0,STR_PAD_LEFT));
  152. }
  153. $this->model->startTrans();
  154. try{
  155. foreach ($list as $val){
  156. (new \app\cxinv\model\FinancialManager)->CreateData($val);
  157. }
  158. $this->model->commit();
  159. }catch (\Exception $e){
  160. $this->model->rollback();
  161. return error($e->getMessage());
  162. }
  163. return success("操作成功");
  164. }
  165. public function info(){
  166. $id=$this->request->param("id",0,"intval");
  167. $info=$this->model->with(['ProductRela'=>["product"]])->findOrEmpty($id);
  168. if($info->isEmpty()) return error("数据不存在");
  169. return success("获取成功",$info);
  170. }
  171. //处理待确认数据
  172. public function CheckSure(){
  173. $params = $this->request->param(['manager_id'=>'','relaArr'=>[],"fz_date"=>"","is_checkOrder"=>0],'post','trim');
  174. $valid = $this->validate($params,[
  175. 'manager_id|出库明细ID'=>'require|integer',
  176. 'relaArr|关联数据'=>'require|array',
  177. 'fz_date|封账月份'=>'max:255',
  178. 'is_checkOrder|是否生成计提单子'=>'require|in:0,1'
  179. ]);
  180. if($valid!==true) return error($valid);
  181. $manager = $this->model->findOrEmpty($params['manager_id']);
  182. if($manager->isEmpty()) return error('待确认数据不存在');
  183. if($manager['status']!=1 && $manager['status']!=4) return error('当前待确认数据状态不允许操作');
  184. $manager->relaArr=$params['relaArr'];
  185. $manager->fz_date=$params['fz_date']??$manager->fz_date;
  186. $companyCode= in_array($manager['type'],['2','4'])?$manager['seller_code']:$manager['buyer_code'];
  187. $fz_date = ProductFz::where(['company_code'=>$companyCode,'fz_date'=>$manager['fz_date']])->findOrEmpty();
  188. if($fz_date->isEmpty()) return error("请先生成封账单");
  189. if($fz_date->status!=0) return error("{$manager['fz_date']}封账状态不可用");
  190. $this->model->startTrans();
  191. try{
  192. $manager->cl_uid=$this->uid; //调整单需要创建人
  193. $manager->cl_uname=$this->uname;//调整单需要创建人
  194. if($manager->type==1 || $manager->type==4)$check = $this->model->inProduct($manager);
  195. else {
  196. if($params['is_checkOrder']==1)$check = $this->model->OutKet($manager);
  197. else$check = $this->model->outProduct($manager);
  198. }
  199. if(empty($check)) return error('待确认数据处理失败');
  200. if($manager->balance_num!=0) return error('待确认数据数量未处理完不可提交');
  201. ManagerProduct::AddProduct($manager->id,$check);
  202. $manager->save();
  203. $this->model->commit();
  204. }catch (\Exception $e){
  205. $this->model->rollback();
  206. return error($e->getMessage());
  207. }
  208. return success('操作成功');
  209. }
  210. //待确认数据 c端订单确认处理
  211. public function CheckSureByOther(){
  212. $params = $this->request->param(['manager_id'=>[],'relaArr'=>[],"fz_date"=>"","is_checkOrder"=>0],'post','trim');
  213. $valid = $this->validate($params,[
  214. 'manager_id|出库明细ID'=>'require|array',
  215. 'relaArr|关联数据'=>'require|array',
  216. 'fz_date|封账月份'=>'max:255',
  217. 'is_checkOrder|是否生成计提单子'=>'require|in:0,1'
  218. ]);
  219. if($valid!==true) return error($valid);
  220. $manager = $this->model->whereIn('id',$params['manager_id'])->select();
  221. if($manager->isEmpty()) return error('待确认数据不存在');
  222. $goodNos = array_unique(array_column($manager->toArray(),'goodNo'));
  223. if(count($goodNos)!=1) return error('待确认数据商品编码不一致');
  224. if($params['is_checkOrder']==1){
  225. $totalnum = array_sum(array_column($manager->toArray(),'balance_num'));
  226. $relaNum = array_sum(array_column($params['relaArr'],'num'));
  227. if($totalnum!=$relaNum) return error('待确认数据数量不一致');
  228. }
  229. $this->model->startTrans();
  230. try{
  231. foreach ($manager as $item){
  232. $item->relaArr=[];
  233. $relaArr= array_map(function (&$val) use ($item){
  234. $temp=$val;
  235. $temp['id']=$val['id'];
  236. $temp['num']=$item->balance_num;
  237. $val['num']= bcsub($val['num'],$item->balance_num,8);
  238. return $temp;
  239. },$params['relaArr']);
  240. $item->relaArr= $relaArr;
  241. $item->fz_date=$params['fz_date']??$item->fz_date;
  242. $item->cl_uid=$this->uid;
  243. $item->cl_uname=$this->uname;
  244. $companyCode= in_array($item['type'],['2','4'])?$item['seller_code']:$item['buyer_code'];
  245. $fz_date = ProductFz::where(['company_code'=>$companyCode,'fz_date'=>$item['fz_date']])->findOrEmpty();
  246. if($fz_date->isEmpty()) throw new \Exception("请先生成封账单");
  247. if($fz_date->status!=0) throw new \Exception("{$manager['fz_date']}封账状态不可用");
  248. if($item->type==1 || $item->type==4)$check = $this->model->inProduct($item);
  249. else {
  250. if($params['is_checkOrder']==1)$check = $this->model->OutKet($item);
  251. else$check = $this->model->outProduct($item);
  252. }
  253. if(empty($check)) throw new \Exception('待确认数据处理失败');
  254. if($item->balance_num!=0) throw new \Exception('待确认数据数量未处理完不可提交');
  255. ManagerProduct::AddProduct($item->id,$check);
  256. $item->save();
  257. }
  258. $this->model->commit();
  259. }catch (\Exception $e){
  260. $this->model->rollback();
  261. return error($e->getMessage());
  262. }
  263. return success('操作成功');
  264. }
  265. // 删除待确认数据
  266. public function delete(){
  267. $ids = $this->request->param('id',[]);
  268. $info=$this->model->whereIn('id',$ids)->select();
  269. if($info->isEmpty()) return error("数据不存在");
  270. foreach ($info as $item){
  271. if($item->status!=1 && $item->status!=4) return error("当前数据[$item->id]状态不允许删除");
  272. if($item->balance_num!=$item->total_num) return error("数据[$item->id]数量已处理过不可删除");
  273. }
  274. $info->delete();
  275. return success("删除成功");
  276. }
  277. public function CheckList(){
  278. $params = $this->request->param(["page"=>1,"size"=>20,"goodType"=>'',"goodNo"=>'',"company_code"=>'',"start_time"=>"","end_time"=>"","keywords"=>""],"post","trim");
  279. $where=[];
  280. if($params['goodType']!='') $where[]=['goodType','=',$params['goodType']];
  281. if($params['goodNo']!='') $where[]=['goodNo','=',$params['goodNo']];
  282. if($params['company_code']!='') $where[]=['company_code','=',$params['company_code']];
  283. if($params['keywords']!="") $where[]=['goodName|goodNo','like',"%".$params['keywords']."%"];
  284. if($params['start_time']!="" && $params['end_time']!=""){
  285. $where[]=['create_time','between',[$params['start_time'],$params['end_time']]];
  286. }
  287. $list = FinancialCheck::where($where)
  288. ->order('id desc')
  289. ->paginate(['page'=>$params['page'],'list_rows'=>$params['size']]);
  290. return success('获取成功',['list'=>$list->items(),'count'=>$list->total()]);
  291. }
  292. }