PaymentReceiptService.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677
  1. <?php
  2. namespace App\Service;
  3. use App\Model\BasicType;
  4. use App\Model\Employee;
  5. use App\Model\PaymentReceipt;
  6. use App\Model\PaymentReceiptInfo;
  7. use App\Model\PurchaseOrder;
  8. use App\Model\ReturnExchangeOrder;
  9. use App\Model\SalesOrder;
  10. use Illuminate\Support\Facades\DB;
  11. class PaymentReceiptService extends Service
  12. {
  13. public function paymentReceiptGet($data,$user){
  14. $order_number = (new OrderNoService())->createOrderNumber(PaymentReceipt::prefix);
  15. if(! $order_number) return [false,'工单编号生成失败!'];
  16. return [true,['order_number' => $order_number]];
  17. }
  18. public function customerEdit($data,$user){
  19. list($status,$msg) = $this->customerRule($data,$user, false);
  20. if(!$status) return [$status,$msg];
  21. try {
  22. DB::beginTransaction();
  23. $model = PaymentReceipt::where('id',$data['id'])->first();
  24. // $model->data_order_no = $data['data_order_no'];
  25. // $model->data_type = $data['data_type'];
  26. $model->type = $data['type'];
  27. $model->account = $data['account'] ?? 0;
  28. $model->pay_way = $data['pay_way'] ?? 0;
  29. // $model->amount = $data['amount'] ?? 0;
  30. $model->mark = $data['mark'] ?? '';
  31. $model->payment_receipt_date = $data['payment_receipt_date'] ?? 0;
  32. $model->save();
  33. $time = time();
  34. $old = PaymentReceiptInfo::where('del_time',0)
  35. ->where('payment_receipt_id',$data['id'])
  36. ->select('file')
  37. ->get()->toArray();
  38. $old = array_column($old,'file');
  39. PaymentReceiptInfo::where('del_time',0)
  40. ->where('payment_receipt_id',$data['id'])
  41. ->update(['del_time' => $time]);
  42. $new = [];
  43. if(! empty($data['file'])){
  44. $insert = [];
  45. foreach ($data['file'] as $value){
  46. $insert[] = [
  47. 'payment_receipt_id' => $model->id,
  48. 'file' => $value['url'],
  49. 'type' => PaymentReceiptInfo::type_one,
  50. 'name' => $value['name'],
  51. 'crt_time' => $time,
  52. ];
  53. }
  54. $new[]= $value['url'];
  55. PaymentReceiptInfo::insert($insert);
  56. }
  57. if(! empty($data['employee_one'])){
  58. $insert = [];
  59. foreach ($data['employee_one'] as $value){
  60. $insert[] = [
  61. 'payment_receipt_id' => $model->id,
  62. 'data_id' => $value,
  63. 'type' => PaymentReceiptInfo::type_two,
  64. 'crt_time' => $time,
  65. ];
  66. }
  67. PaymentReceiptInfo::insert($insert);
  68. }
  69. if(! empty($data['amount_list'])){
  70. $insert = [];
  71. foreach ($data['amount_list'] as $value){
  72. $insert[] = [
  73. 'payment_receipt_id' => $model->id,
  74. 'data_type' => $data['type'],
  75. 'data_order_no' => $value['data_order_no'],
  76. 'data_order_type' => $data['data_type'],
  77. 'amount' => $value['amount'],
  78. 'type' => PaymentReceiptInfo::type_three,
  79. 'crt_time' => $time,
  80. ];
  81. }
  82. PaymentReceiptInfo::insert($insert);
  83. }
  84. DB::commit();
  85. }catch (\Exception $exception){
  86. DB::rollBack();
  87. return [false,$exception->getMessage()];
  88. }
  89. $this->delStorageFile($old, $new);
  90. if(! empty($data['check'])) {
  91. list($status,$msg) = (new CheckService())->checkAll([
  92. "id" => $data['id'],
  93. "order_number" => $data['order_number'],
  94. "opt_case" => CheckService::ten,
  95. "menu_id" => $data['menu_id']
  96. ],$user);
  97. if(! $status) return [true, '保存成功,收付款确认失败,异常信息:' . $msg];
  98. }
  99. return [true,''];
  100. }
  101. public function customerAdd($data,$user){
  102. list($status,$msg) = $this->customerRule($data,$user);
  103. if(!$status) return [$status,$msg];
  104. try {
  105. DB::beginTransaction();
  106. $model = new PaymentReceipt();
  107. $model->order_number = $data['order_number'];
  108. // $model->data_order_no = $data['data_order_no'];
  109. $model->data_type = $data['data_type'];
  110. $model->type = $data['type'];
  111. $model->account = $data['account'] ?? 0;
  112. $model->pay_way = $data['pay_way'] ?? 0;
  113. // $model->amount = $data['amount'] ?? 0;
  114. $model->mark = $data['mark'] ?? '';
  115. $model->crt_id = $user['id'];
  116. $model->depart_id = $data['depart_id'];
  117. $model->top_depart_id = $data['top_depart_id'];
  118. $model->payment_receipt_date = $data['payment_receipt_date'] ?? 0;
  119. $model->save();
  120. $time = time();
  121. if(! empty($data['file'])){
  122. $insert = [];
  123. foreach ($data['file'] as $value){
  124. $insert[] = [
  125. 'payment_receipt_id' => $model->id,
  126. 'file' => $value['url'],
  127. 'type' => PaymentReceiptInfo::type_one,
  128. 'name' => $value['name'],
  129. 'crt_time' => $time,
  130. ];
  131. }
  132. PaymentReceiptInfo::insert($insert);
  133. }
  134. if(! empty($data['employee_one'])){
  135. $insert = [];
  136. foreach ($data['employee_one'] as $value){
  137. $insert[] = [
  138. 'payment_receipt_id' => $model->id,
  139. 'data_id' => $value,
  140. 'type' => PaymentReceiptInfo::type_two,
  141. 'crt_time' => $time,
  142. ];
  143. }
  144. PaymentReceiptInfo::insert($insert);
  145. }
  146. if(! empty($data['amount_list'])){
  147. $insert = [];
  148. foreach ($data['amount_list'] as $value){
  149. $insert[] = [
  150. 'payment_receipt_id' => $model->id,
  151. 'data_type' => $data['type'],
  152. 'data_order_no' => $value['data_order_no'],
  153. 'data_order_type' => $data['data_type'],
  154. 'amount' => $value['amount'],
  155. 'type' => PaymentReceiptInfo::type_three,
  156. 'crt_time' => $time,
  157. ];
  158. }
  159. PaymentReceiptInfo::insert($insert);
  160. }
  161. DB::commit();
  162. }catch (\Exception $exception){
  163. DB::rollBack();
  164. return [false,$exception->getMessage()];
  165. }
  166. if(! empty($data['check'])) {
  167. list($status,$msg) = (new CheckService())->checkAll([
  168. "id" => $model->id,
  169. "order_number" => $data['order_number'],
  170. "opt_case" => CheckService::ten,
  171. "menu_id" => $data['menu_id']
  172. ],$user);
  173. if(! $status) return [true, '保存成功,收付款确认失败,异常信息:' . $msg];
  174. }
  175. return [true,''];
  176. }
  177. public function customerDel($data){
  178. if($this->isEmpty($data,'id')) return [false,'请选择数据!'];
  179. $booking = PaymentReceipt::where('del_time',0)->where('id',$data['id'])->first();
  180. if(empty($booking)) return [false,'收付款单不存在或已被删除'];
  181. $booking = $booking->toArray();
  182. if($booking['state'] != PaymentReceipt::STATE_ZERO) return [false,'请确认收付款单状态,删除失败'];
  183. try {
  184. DB::beginTransaction();
  185. $time = time();
  186. $old = PaymentReceiptInfo::where('del_time',0)
  187. ->where('payment_receipt_id',$data['id'])
  188. ->select('file')
  189. ->get()->toArray();
  190. $old = array_column($old,'file');
  191. PaymentReceipt::where('id',$data['id'])->update([
  192. 'del_time'=> $time
  193. ]);
  194. PaymentReceiptInfo::where('del_time',0)
  195. ->where('payment_receipt_id',$data['id'])
  196. ->update(['del_time' => $time]);
  197. DB::commit();
  198. }catch (\Exception $exception){
  199. DB::rollBack();
  200. return [false,$exception->getMessage()];
  201. }
  202. $this->delStorageFile($old);
  203. return [true,''];
  204. }
  205. public function customerDetail($data){
  206. if(empty($data['id']) && empty($data['order_number'])) return [false,'请选择数据!'];
  207. if(! empty($data['id'])){
  208. $customer = PaymentReceipt::where('del_time',0)
  209. ->where('id',$data['id'])
  210. ->first();
  211. }else{
  212. $customer = PaymentReceipt::where('del_time',0)
  213. ->where('order_number',$data['order_number'])
  214. ->first();
  215. $data['id'] = empty($customer->id) ? 0 : $customer->id;
  216. }
  217. if(empty($customer)) return [false,'收付款记录不存在或已被删除'];
  218. $customer = $customer->toArray();
  219. $array = [
  220. $customer['account'],
  221. $customer['pay_way'],
  222. ];
  223. $basic_map = BasicType::whereIn('id',$array)
  224. ->pluck('title','id')
  225. ->toArray();
  226. $customer['account_title'] = $basic_map[$customer['account']] ?? "";
  227. $customer['pay_way_title'] = $basic_map[$customer['pay_way']] ?? "";
  228. $customer['state_title'] = PaymentReceipt::$name[$customer['state']] ?? "";
  229. $customer['type_title'] = PaymentReceipt::$model_type[$customer['type']] ?? "";
  230. $customer['data_type_title'] = PaymentReceipt::$data_type[$customer['data_type']] ?? "";
  231. $customer['crt_name'] = Employee::where('id',$customer['crt_id'])->value('emp_name');
  232. $customer['crt_time'] = $customer['crt_time'] ? date("Y-m-d H:i:s",$customer['crt_time']): '';
  233. $customer['payment_receipt_date'] = $customer['payment_receipt_date'] ? date("Y-m-d",$customer['payment_receipt_date']): '';
  234. $customer['receipt_amount'] = $customer['state'] == PaymentReceipt::STATE_TWO ? $customer['amount'] : 0;
  235. $file = PaymentReceiptInfo::where('del_time',0)
  236. ->where('payment_receipt_id',$data['id'])
  237. ->get()->toArray();
  238. $emp_id = [];
  239. $order_no = [];
  240. foreach ($file as $value){
  241. if(in_array($value['type'],PaymentReceiptInfo::$man)){
  242. $emp_id[] = $value['data_id'];
  243. }
  244. if(! empty($value['data_order_no'])) $order_no[] = $value['data_order_no'];
  245. }
  246. if($customer['data_type'] == PaymentReceipt::data_type_one){
  247. $order = SalesOrder::where('del_time',0)
  248. ->whereIn('order_number',$order_no)
  249. ->pluck('contract_fee','order_number')
  250. ->toArray();
  251. $getDifferentAmountALL = (new ReturnExchangeOrderService())->getDifferentAmountALL2(array_keys($order));
  252. }else{
  253. $order = PurchaseOrder::where('del_time',0)
  254. ->whereIn('order_number',$order_no)
  255. ->pluck('purchase_total','order_number')
  256. ->toArray();
  257. $getDifferentAmountALL = (new ReturnExchangeOrderService())->getDifferentAmountALL2(array_keys($order), ReturnExchangeOrder::Order_type2);
  258. }
  259. $infos = PaymentReceiptInfo::where('del_time',0)
  260. ->where('type',PaymentReceiptInfo::type_three)
  261. ->where('payment_receipt_id','<>',$customer['id'])
  262. ->get()->toArray();
  263. $infos_map = [];
  264. foreach ($infos as $value){
  265. $keys = $value['data_order_no'] . $value['data_type'];
  266. if(isset($infos_map[$keys])){
  267. $infos_map[$keys] += $value['amount'];
  268. }else{
  269. $infos_map[$keys] = $value['amount'];
  270. }
  271. }
  272. $emp_map = Employee::whereIn('id',array_unique($emp_id))
  273. ->pluck('emp_name','id')
  274. ->toArray();
  275. $customer['file'] = $customer['employee_one'] = $customer['amount_list'] = [];
  276. foreach ($file as $value){
  277. if($value['type'] == PaymentReceiptInfo::type_one){
  278. $tmp = [
  279. 'url' => $value['file'],
  280. 'name' => $value['name'],
  281. ];
  282. $customer['file'][] = $tmp;
  283. }elseif (in_array($value['type'],PaymentReceiptInfo::$man)){
  284. $tt = $emp_map[$value['data_id']] ?? '';
  285. if(! empty($tt)){
  286. $tmp = [
  287. 'id' => $value['data_id'],
  288. 'name' => $emp_map[$value['data_id']] ?? '',
  289. ];
  290. if($value['type'] == PaymentReceiptInfo::type_two){
  291. $customer['employee_one'][] = $tmp;
  292. }
  293. }
  294. }elseif ($value['type'] == PaymentReceiptInfo::type_three){
  295. $total = $has_amount = 0;
  296. $receipt_amount = $value['amount'];
  297. if($customer['type'] == PaymentReceipt::type_one){
  298. //坏账金额
  299. $bad_amount = $infos_map[$value['data_order_no'] . PaymentReceipt::type_four] ?? 0;
  300. //除了本单外的已收金额
  301. $has_amount = $infos_map[$value['data_order_no'] . PaymentReceipt::type_one] ?? 0;
  302. //总回款金额 = 合同金额 - 退换货金额 - 已收金额 - 坏账金额
  303. $total = ($order[$value['data_order_no']] ?? 0) - ($getDifferentAmountALL[$value['data_order_no']] ?? 0) - $bad_amount - $has_amount;
  304. }elseif($customer['type'] == PaymentReceipt::type_three){
  305. //已回款金额
  306. $one = $infos_map[$value['data_order_no'] . PaymentReceipt::type_one] ?? 0;
  307. //除了本单外的已红冲金额
  308. $has_amount = $infos_map[$value['data_order_no'] . PaymentReceipt::type_three] ?? 0;
  309. //总红冲金额 = 已回款金额 - 已红冲金额
  310. $total = $one - $has_amount;
  311. }elseif($customer['type'] == PaymentReceipt::type_four){
  312. //已回款金额
  313. $one = $infos_map[$value['data_order_no'] . PaymentReceipt::type_one] ?? 0;
  314. //已红冲金额
  315. $three = $infos_map[$value['data_order_no'] . PaymentReceipt::type_three] ?? 0;
  316. //除了本单外的已坏账金额
  317. $has_amount = $infos_map[$value['data_order_no'] . PaymentReceipt::type_four] ?? 0;
  318. //总坏账金额 = 合同金额 - 退换货金额 - 已收金额 + 已红冲金额 - 坏账金额
  319. $total = ($order[$value['data_order_no']] ?? 0) - ($getDifferentAmountALL[$value['data_order_no']] ?? 0) - $one + $three - $has_amount;
  320. }
  321. $tmp = [
  322. 'data_order_no' => $value['data_order_no'],
  323. 'amount' => $value['amount'],
  324. 'total_amount' => $total,
  325. 'has_amount' => $has_amount,
  326. 'receipt_amount' => $receipt_amount
  327. ];
  328. $customer['amount_list'][] = $tmp;
  329. }
  330. }
  331. return [true, $customer];
  332. }
  333. public function customerList($data,$user){
  334. $model = PaymentReceipt::Clear($user,$data);
  335. $model = $model->where('del_time',0)
  336. ->select('type','id','data_type','order_number','data_order_no','amount','account','pay_way','crt_id','crt_time','mark','state','payment_receipt_date')
  337. ->orderby('id', 'desc');
  338. if(isset($data['state'])) $model->where('state', $data['state']);
  339. if(! empty($data['data_order_no'])) {
  340. $info = PaymentReceiptInfo::where('del_time',0)
  341. ->where('type',PaymentReceiptInfo::type_three)
  342. ->where('data_order_no', 'LIKE', '%'.$data['data_order_no'].'%')
  343. ->select('payment_receipt_id')
  344. ->get()->toArray();
  345. $model->whereIn('id', array_unique(array_column($info,'payment_receipt_id')));
  346. }
  347. if(! empty($data['order_number'])) $model->where('order_number', 'LIKE', '%'.$data['order_number'].'%');
  348. if(! empty($data['data_type'])) $model->where('data_type', $data['data_type']);
  349. if(! empty($data['type'])) $model->where('type', $data['type']);
  350. if(! empty($data['account'])) $model->where('account',$data['account']);
  351. if(! empty($data['pay_way'])) $model->where('pay_way',$data['pay_way']);
  352. if(! empty($data['mark'])) $model->where('mark', 'LIKE', '%'.$data['mark'].'%');
  353. if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
  354. $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
  355. $model->where('crt_time','>=',$return[0]);
  356. $model->where('crt_time','<=',$return[1]);
  357. }
  358. if(! empty($data['payment_receipt_date'][0]) && ! empty($data['payment_receipt_date'][1])){
  359. $return = $this->changeDateToTimeStampAboutRange($data['payment_receipt_date']);
  360. $model->where('payment_receipt_date','>=',$return[0]);
  361. $model->where('payment_receipt_date','<=',$return[1]);
  362. }
  363. if(! empty($data['belong'])){
  364. $id = (new RangeService())->paymentReceiptSearch($data);
  365. $model->whereIn('id',$id);
  366. }
  367. $list = $this->limit($model,'',$data);
  368. $list = $this->fillData($list);
  369. return [true, $list];
  370. }
  371. public function customerRule(&$data, $user, $is_add = true){
  372. if(empty($data['order_number'])) return [false,'收付款单编号不能为空'];
  373. if(empty($data['data_type'])) return [false,'单号类型不能为空'];
  374. if(empty($data['type'])) return [false,'收付款类型不能为空'];
  375. if(empty($data['amount_list']) || ! is_array($data['amount_list'])) return [false,'关联单号与金额不能为空'];
  376. foreach ($data['amount_list'] as $value){
  377. if(empty($value['data_order_no'])) return [false,'关联单号不能为空'];
  378. if(empty($value['amount'])) return [false,'金额不能为空'];
  379. $res = $this->checkNumber($value['amount']);
  380. if(! $res) return [false, '金额请输入不超过两位小数并且大于0的数值'];
  381. }
  382. if(! empty($data['payment_receipt_date'])) $data['payment_receipt_date'] = $this->changeDateToDate($data['payment_receipt_date']);
  383. //所属部门 以及 顶级部门
  384. if(empty($data['depart_id'])) {
  385. $data['depart_id'] = $this->getDepart($user);
  386. $data['top_depart_id'] = $user['depart_map'][$data['depart_id']] ?? 0;
  387. }
  388. list($status,$msg) = $this->limitingSendRequestBackgExpire("paymentReceipt" . $data['order_number']);
  389. if(! $status) return [false, $msg];
  390. if($is_add){
  391. $bool = PaymentReceipt::where('del_time',0)
  392. ->where('order_number',$data['order_number'])
  393. ->exists();
  394. if($bool) return [false,'收付款单编号已存在,请重新获取'];
  395. }else{
  396. if(empty($data['id'])) return [false,'ID不能为空'];
  397. $booking = PaymentReceipt::where('del_time',0)->where('id',$data['id'])->first();
  398. if(empty($booking)) return [false,'收付款单不存在或已被删除'];
  399. $booking = $booking->toArray();
  400. if($booking['state'] != PaymentReceipt::STATE_ZERO) return [false,'请确认收付款单状态,编辑失败'];
  401. }
  402. return [true, ''];
  403. }
  404. public function fillData($data){
  405. if(empty($data['data'])) return $data;
  406. $emp = Employee::whereIn('id',array_unique(array_column($data['data'],'crt_id')))
  407. ->pluck('emp_name','id')
  408. ->toArray();
  409. $array = array_unique(array_merge_recursive(array_column($data['data'],'account'),array_column($data['data'],'pay_way')));
  410. $basic_map = BasicType::whereIn('id',$array)
  411. ->pluck('title','id')
  412. ->toArray();
  413. $map = [];
  414. $info = PaymentReceiptInfo::where('del_time',0)
  415. ->where('type',PaymentReceiptInfo::type_three)
  416. ->whereIn('payment_receipt_id', array_unique(array_column($data['data'],'id')))
  417. ->select('payment_receipt_id','data_order_no')
  418. ->get()->toArray();
  419. foreach ($info as $value){
  420. $map[$value['payment_receipt_id']][] = $value['data_order_no'];
  421. }
  422. foreach ($data['data'] as $key => $value){
  423. $data['data'][$key]['crt_time'] = $value['crt_time'] ? date('Y-m-d H:i:s',$value['crt_time']) : '';
  424. $data['data'][$key]['payment_receipt_date'] = $value['payment_receipt_date'] ? date('Y-m-d',$value['payment_receipt_date']) : '';
  425. $data['data'][$key]['crt_name'] = $emp[$value['crt_id']] ?? '';
  426. $data['data'][$key]['state_title'] = PaymentReceipt::$name[$value['state']] ?? '';
  427. $data['data'][$key]['type_title'] = PaymentReceipt::$model_type[$value['type']] ?? '';
  428. $data['data'][$key]['data_type_title'] = PaymentReceipt::$data_type[$value['data_type']] ?? '';
  429. $data['data'][$key]['account_title'] = $basic_map[$value['account']] ?? '';
  430. $data['data'][$key]['pay_way_title'] = $basic_map[$value['pay_way']] ?? '';
  431. $data['data'][$key]['data_order_no'] = $map[$value['id']] ?? [];
  432. }
  433. return $data;
  434. }
  435. //详情里
  436. public function getPaymentReceiptDataList($data){
  437. $data['data_order_no'] = $data['order_number'];
  438. $info1 = PaymentReceiptInfo::where('del_time',0)
  439. ->where('data_order_no',$data['data_order_no'])
  440. ->where('type',PaymentReceiptInfo::type_three)
  441. ->get()->toArray();
  442. $map = [];
  443. foreach ($info1 as $value){
  444. $key = $value['payment_receipt_id'] . $value['data_type'];
  445. if(isset($map[$key])){
  446. $map[$key] += $value['amount'];
  447. }else{
  448. $map[$key] = $value['amount'];
  449. }
  450. }
  451. $order = PaymentReceipt::where('del_time',0)
  452. ->whereIn('id',array_column($info1,'payment_receipt_id'))
  453. ->get()->toArray();
  454. $emp_id = PaymentReceiptInfo::where('del_time',0)
  455. ->whereIn('payment_receipt_id',array_column($order,'id'))
  456. ->where('type',PaymentReceiptInfo::type_two)
  457. ->get()->toArray();
  458. $info = [];
  459. if(! empty($emp_id)){
  460. $emp_map = Employee::whereIn('id',array_unique(array_column($emp_id,'data_id')))
  461. ->pluck('emp_name','id')
  462. ->toArray();
  463. foreach ($emp_id as $value){
  464. $name = $emp_map[$value['data_id']] ?? "";
  465. if(isset($info[$value['data_id']])){
  466. $info[$value['data_id']] .= ',' . $name;
  467. }else{
  468. $info[$value['data_id']] = $name;
  469. }
  470. }
  471. }
  472. //四个金额类型
  473. $one = $two = $three = $four = 0;
  474. foreach ($order as $key => $value){
  475. $keys = $value['id'] . $value['type'];
  476. //归属人
  477. $order[$key]['belong'] = $info[$value['id']] ?? '';
  478. $order[$key]['state_title'] = PaymentReceipt::$name[$value['state']] ?? '';
  479. $order[$key]['type_title'] = PaymentReceipt::$model_type[$value['type']] ?? '';
  480. $order[$key]['payment_receipt_date'] = $value['payment_receipt_date'] ? date('Y-m-d',$value['payment_receipt_date']) : '';
  481. //统计每个收付款单 =》总收付款金额
  482. $amount = $map[$keys] ?? 0;
  483. $order[$key]['amount'] = $amount;
  484. if($value['type'] == PaymentReceipt::type_one){
  485. $one += $amount;
  486. }elseif($value['type'] == PaymentReceipt::type_two){
  487. $two += $amount;
  488. }elseif($value['type'] == PaymentReceipt::type_three){
  489. $three += $amount;
  490. }elseif($value['type'] == PaymentReceipt::type_four){
  491. $four += $amount;
  492. }
  493. }
  494. $return['receipt_amount'] = $one;
  495. $return['not_receipt_amount'] = 0;
  496. $return['red_amount'] = $three;
  497. $return['bad_amount'] = $four;
  498. $return['all_count'] = count($order);
  499. $return['list'] = $order;
  500. return $return;
  501. }
  502. //列表里 默认:(收款)
  503. public function getPaymentReceiptDataCountList($data,$type=0){
  504. $data_order_no = [];
  505. if(! $type){
  506. foreach ($data as $value){
  507. $data_order_no[] = $value['order_number'];
  508. }
  509. }else{
  510. $data_order_no = $data;
  511. }
  512. if(empty($data_order_no)) return [];
  513. $order = PaymentReceiptInfo::where('del_time',0)
  514. ->where('type',PaymentReceiptInfo::type_three)
  515. ->whereIn('data_order_no',$data_order_no)
  516. ->get()->toArray();
  517. $return = [];
  518. foreach ($order as $value){
  519. $key = $value['data_order_no'] . $value['data_type'];
  520. if(isset($return[$key])){
  521. $return[$key] += $value['amount'];
  522. }else{
  523. $return[$key] = $value['amount'];
  524. }
  525. }
  526. return $return;
  527. }
  528. //废弃
  529. public function getPaymentReceiptDeatail($data){
  530. $customer = PaymentReceipt::where('del_time',0)
  531. ->where('crt_time',$data['crt_time'])
  532. ->where('id',$data['id'])
  533. ->first();
  534. if(empty($customer)) return [];
  535. $customer = $customer->toArray();
  536. $array = [
  537. $customer['account'],
  538. $customer['pay_way'],
  539. ];
  540. $basic_map = BasicType::whereIn('id',$array)
  541. ->pluck('title','id')
  542. ->toArray();
  543. $customer['account_title'] = $basic_map[$customer['account']] ?? "";
  544. $customer['pay_way_title'] = $basic_map[$customer['pay_way']] ?? "";
  545. $customer['state_title'] = PaymentReceipt::$name[$customer['state']] ?? "";
  546. $customer['type_title'] = PaymentReceipt::$model_type[$customer['type']] ?? "";
  547. $customer['data_type_title'] = PaymentReceipt::$data_type[$customer['data_type']] ?? "";
  548. $customer['crt_name'] = Employee::where('id',$customer['crt_id'])->value('emp_name');
  549. $customer['crt_time'] = $customer['crt_time'] ? date("Y-m-d H:i:s",$customer['crt_time']): '';
  550. $customer['payment_receipt_date'] = $customer['payment_receipt_date'] ? date("Y-m-d",$customer['payment_receipt_date']): '';
  551. $customer['receipt_amount'] = $customer['state'] == PaymentReceipt::STATE_TWO ? $customer['amount'] : 0;
  552. $file = PaymentReceiptInfo::where('del_time',0)
  553. ->where('payment_receipt_id',$data['id'])
  554. ->get()->toArray();
  555. $emp_id = [];
  556. foreach ($file as $value){
  557. if(in_array($value['type'],PaymentReceiptInfo::$man)){
  558. $emp_id[] = $value['data_id'];
  559. }
  560. }
  561. $emp_map = Employee::whereIn('id',array_unique($emp_id))
  562. ->pluck('emp_name','id')
  563. ->toArray();
  564. $customer['file'] = $customer['employee_one'] = [];
  565. foreach ($file as $value){
  566. if($value['type'] == PaymentReceiptInfo::type_one){
  567. $tmp = [
  568. 'url' => $value['file'],
  569. 'name' => $value['name'],
  570. ];
  571. $customer['file'][] = $tmp;
  572. }elseif (in_array($value['type'],PaymentReceiptInfo::$man)){
  573. $tt = $emp_map[$value['data_id']] ?? '';
  574. if(! empty($tt)){
  575. $tmp = [
  576. 'id' => $value['data_id'],
  577. 'name' => $emp_map[$value['data_id']] ?? '',
  578. ];
  579. if($value['type'] == PaymentReceiptInfo::type_two){
  580. $customer['employee_one'][] = $tmp;
  581. }
  582. }
  583. }
  584. }
  585. return $customer;
  586. }
  587. public function maked(){
  588. $payment = PaymentReceipt::where('del_time',0)
  589. ->where('data_order_no','LIKE', '%'."T9SO.".'%')
  590. ->where('amount','>',0)
  591. ->get()->toArray();
  592. $insert = [];
  593. foreach ($payment as $value){
  594. $insert[] = [
  595. 'payment_receipt_id' => $value['id'],
  596. 'crt_time' => $value['crt_time'],
  597. 'type' => PaymentReceiptInfo::type_three,
  598. 'data_order_no' => $value['data_order_no'],
  599. 'amount' => $value['amount'],
  600. 'data_order_type' => $value['type'],
  601. 'data_type' => PaymentReceipt::type_one,
  602. ];
  603. }
  604. if(! empty($insert)) PaymentReceiptInfo::insert($insert);
  605. }
  606. }