FinancialManager.php 16 KB

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