PaymentReceiptService.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306
  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 Illuminate\Support\Facades\DB;
  8. class PaymentReceiptService extends Service
  9. {
  10. public function paymentReceiptGet($data,$user){
  11. $order_number = (new OrderNoService())->createOrderNumber(PaymentReceipt::prefix);
  12. if(! $order_number) return [false,'工单编号生成失败!'];
  13. return [true,['order_number' => $order_number]];
  14. }
  15. public function customerEdit($data,$user){
  16. list($status,$msg) = $this->customerRule($data,$user, false);
  17. if(!$status) return [$status,$msg];
  18. try {
  19. DB::beginTransaction();
  20. $model = PaymentReceipt::where('id',$data['id'])->first();
  21. $model->data_order_no = $data['data_order_no'];
  22. $model->data_type = $data['data_type'];
  23. $model->type = $data['type'];
  24. $model->account = $data['account'] ?? 0;
  25. $model->pay_way = $data['pay_way'] ?? 0;
  26. $model->amount = $data['amount'] ?? 0;
  27. $model->mark = $data['mark'] ?? '';
  28. $model->payment_receipt_date = $data['payment_receipt_date'] ?? 0;
  29. $model->save();
  30. $time = time();
  31. PaymentReceiptInfo::where('del_time',0)
  32. ->where('payment_receipt_id',$data['id'])
  33. ->update(['del_time' => $time]);
  34. if(! empty($data['file'])){
  35. $insert = [];
  36. foreach ($data['file'] as $value){
  37. $insert[] = [
  38. 'payment_receipt_id' => $model->id,
  39. 'file' => $value['url'],
  40. 'type' => PaymentReceiptInfo::type_one,
  41. 'name' => $value['name'],
  42. 'crt_time' => $time,
  43. ];
  44. }
  45. PaymentReceiptInfo::insert($insert);
  46. }
  47. if(! empty($data['employee_one'])){
  48. $insert = [];
  49. foreach ($data['employee_one'] as $value){
  50. $insert[] = [
  51. 'payment_receipt_id' => $model->id,
  52. 'data_id' => $value,
  53. 'type' => PaymentReceiptInfo::type_two,
  54. 'crt_time' => $time,
  55. ];
  56. }
  57. PaymentReceiptInfo::insert($insert);
  58. }
  59. DB::commit();
  60. }catch (\Exception $exception){
  61. DB::rollBack();
  62. return [false,$exception->getMessage()];
  63. }
  64. return [true,''];
  65. }
  66. public function customerAdd($data,$user){
  67. list($status,$msg) = $this->customerRule($data,$user);
  68. if(!$status) return [$status,$msg];
  69. try {
  70. DB::beginTransaction();
  71. $model = new PaymentReceipt();
  72. $model->order_number = $data['order_number'];
  73. $model->data_order_no = $data['data_order_no'];
  74. $model->data_type = $data['data_type'];
  75. $model->type = $data['type'];
  76. $model->account = $data['account'] ?? 0;
  77. $model->pay_way = $data['pay_way'] ?? 0;
  78. $model->amount = $data['amount'] ?? 0;
  79. $model->mark = $data['mark'] ?? '';
  80. $model->crt_id = $user['id'];
  81. $model->depart_id = $data['depart_id'];
  82. $model->top_depart_id = $data['top_depart_id'];
  83. $model->payment_receipt_date = $data['payment_receipt_date'] ?? 0;
  84. $model->save();
  85. $time = time();
  86. if(! empty($data['file'])){
  87. $insert = [];
  88. foreach ($data['file'] as $value){
  89. $insert[] = [
  90. 'payment_receipt_id' => $model->id,
  91. 'file' => $value['url'],
  92. 'type' => PaymentReceiptInfo::type_one,
  93. 'name' => $value['name'],
  94. 'crt_time' => $time,
  95. ];
  96. }
  97. PaymentReceiptInfo::insert($insert);
  98. }
  99. if(! empty($data['employee_one'])){
  100. $insert = [];
  101. foreach ($data['employee_one'] as $value){
  102. $insert[] = [
  103. 'payment_receipt_id' => $model->id,
  104. 'data_id' => $value,
  105. 'type' => PaymentReceiptInfo::type_two,
  106. 'crt_time' => $time,
  107. ];
  108. }
  109. PaymentReceiptInfo::insert($insert);
  110. }
  111. DB::commit();
  112. }catch (\Exception $exception){
  113. DB::rollBack();
  114. return [false,$exception->getMessage()];
  115. }
  116. return [true,''];
  117. }
  118. public function customerDel($data){
  119. if($this->isEmpty($data,'id')) return [false,'请选择数据!'];
  120. $booking = PaymentReceipt::where('del_time',0)->where('id',$data['id'])->first();
  121. if(empty($booking)) return [false,'收付款单不存在或已被删除'];
  122. $booking = $booking->toArray();
  123. if($booking['state'] != PaymentReceipt::STATE_ZERO) return [false,'请确认收付款单状态,删除失败'];
  124. try {
  125. DB::beginTransaction();
  126. $time = time();
  127. PaymentReceipt::where('id',$data['id'])->update([
  128. 'del_time'=> $time
  129. ]);
  130. PaymentReceiptInfo::where('del_time',0)
  131. ->where('payment_receipt_id',$data['id'])
  132. ->update(['del_time' => $time]);
  133. DB::commit();
  134. }catch (\Exception $exception){
  135. DB::rollBack();
  136. return [false,$exception->getMessage()];
  137. }
  138. return [true,''];
  139. }
  140. public function customerDetail($data){
  141. if($this->isEmpty($data,'id')) return [false,'请选择数据!'];
  142. $customer = PaymentReceipt::where('del_time',0)
  143. ->where('id',$data['id'])
  144. ->first();
  145. if(empty($customer)) return [false,'记录不存在或已被删除'];
  146. $customer = $customer->toArray();
  147. $customer['state_title'] = PaymentReceipt::$name[$customer['state']] ?? "";
  148. $customer['type_title'] = PaymentReceipt::$model_type[$customer['type']] ?? "";
  149. $customer['crt_name'] = Employee::where('id',$customer['crt_id'])->value('emp_name');
  150. $customer['crt_time'] = $customer['crt_time'] ? date("Y-m-d H:i:s",$customer['crt_time']): '';
  151. $customer['payment_receipt_date'] = $customer['payment_receipt_date'] ? date("Y-m-d",$customer['payment_receipt_date']): '';
  152. $file = PaymentReceiptInfo::where('del_time',0)
  153. ->where('payment_receipt_id',$data['id'])
  154. ->get()->toArray();
  155. $emp_id = [];
  156. foreach ($file as $value){
  157. if(in_array($value['type'],PaymentReceiptInfo::$man)){
  158. $emp_id[] = $value['data_id'];
  159. }
  160. }
  161. $emp_map = Employee::whereIn('id',array_unique($emp_id))
  162. ->where('del_time',0)
  163. ->pluck('emp_name','id')
  164. ->toArray();
  165. $customer['file'] = $customer['employee_one'] = [];
  166. foreach ($file as $value){
  167. if($value['type'] == PaymentReceiptInfo::type_one){
  168. $tmp = [
  169. 'url' => $value['file'],
  170. 'name' => $value['name'],
  171. ];
  172. $customer['file'][] = $tmp;
  173. }elseif (in_array($value['type'],PaymentReceiptInfo::$man)){
  174. $tt = $emp_map[$value['data_id']] ?? '';
  175. if(! empty($tt)){
  176. $tmp = [
  177. 'id' => $value['data_id'],
  178. 'name' => $emp_map[$value['data_id']] ?? '',
  179. ];
  180. if($value['type'] == PaymentReceiptInfo::type_two){
  181. $customer['employee_one'][] = $tmp;
  182. }
  183. }
  184. }
  185. }
  186. return [true, $customer];
  187. }
  188. public function customerList($data,$user){
  189. $model = PaymentReceipt::Clear($user,$data);
  190. $model = $model->where('del_time',0)
  191. ->select('type','id','data_type','order_number','data_order_no','amount','account','pay_way','crt_id','crt_time','mark','state','payment_receipt_date')
  192. ->orderby('id', 'desc');
  193. if(isset($data['state'])) $model->where('state', $data['state']);
  194. if(! empty($data['data_order_no'])) $model->where('data_order_no', 'LIKE', '%'.$data['data_order_no'].'%');
  195. if(! empty($data['order_number'])) $model->where('order_number', 'LIKE', '%'.$data['order_number'].'%');
  196. if(! empty($data['data_type'])) $model->where('data_type', $data['data_type']);
  197. if(! empty($data['type'])) $model->where('type', $data['type']);
  198. if(! empty($data['account'])) $model->where('account',$data['account']);
  199. if(! empty($data['pay_way'])) $model->where('pay_way',$data['pay_way']);
  200. if(! empty($data['mark'])) $model->where('mark', 'LIKE', '%'.$data['mark'].'%');
  201. if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
  202. $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
  203. $model->where('crt_time','>=',$return[0]);
  204. $model->where('crt_time','<=',$return[1]);
  205. }
  206. if(! empty($data['payment_receipt_date'][0]) && ! empty($data['payment_receipt_date'][1])) {
  207. $return = $this->changeDateToTimeStampAboutRange($data['payment_receipt_date']);
  208. $model->where('payment_receipt_date','>=',$return[0]);
  209. $model->where('payment_receipt_date','<=',$return[1]);
  210. }
  211. if(! empty($data['belong'])){
  212. $id = (new RangeService())->paymentReceiptSearch($data);
  213. $model->whereIn('id',$id);
  214. }
  215. $list = $this->limit($model,'',$data);
  216. $list = $this->fillData($list);
  217. return [true, $list];
  218. }
  219. public function customerRule(&$data, $user, $is_add = true){
  220. if(empty($data['order_number'])) return [false,'收付款单编号不能为空'];
  221. if(empty($data['data_order_no'])) return [false,'关联单号不能为空'];
  222. if(empty($data['data_type'])) return [false,'单号类型不能为空'];
  223. if(empty($data['type'])) return [false,'金额类型不能为空'];
  224. if(empty($data['amount'])) return [false,'金额不能为空'];
  225. $res = $this->checkNumber($data['amount']);
  226. if(! $res) return [false, '金额请输入不超过两位小数并且大于0的数值'];
  227. if(! empty($data['payment_receipt_date'])) $data['payment_receipt_date'] = $this->changeDateToDate($data['payment_receipt_date']);
  228. //所属部门 以及 顶级部门
  229. if(empty($data['depart_id'])) {
  230. $data['depart_id'] = $this->getDepart($user);
  231. $data['top_depart_id'] = $user['depart_map'][$data['depart_id']] ?? 0;
  232. }
  233. if($is_add){
  234. $bool = PaymentReceipt::where('del_time',0)
  235. ->where('order_number',$data['order_number'])
  236. ->exists();
  237. if($bool) return [false,'收付款单编号已存在,请重新获取'];
  238. }else{
  239. if(empty($data['id'])) return [false,'ID不能为空'];
  240. $booking = PaymentReceipt::where('del_time',0)->where('id',$data['id'])->first();
  241. if(empty($booking)) return [false,'收付款单不存在或已被删除'];
  242. $booking = $booking->toArray();
  243. if($booking['state'] != PaymentReceipt::STATE_ZERO) return [false,'请确认收付款单状态,编辑失败'];
  244. }
  245. return [true, ''];
  246. }
  247. public function fillData($data){
  248. if(empty($data['data'])) return $data;
  249. $emp = Employee::whereIn('id',array_unique(array_column($data['data'],'crt_id')))
  250. ->pluck('emp_name','id')
  251. ->toArray();
  252. $array = array_unique(array_merge_recursive(array_column($data['data'],'account'),array_column($data['data'],'pay_way')));
  253. $basic_map = BasicType::whereIn('id',$array)
  254. ->pluck('title','id')
  255. ->toArray();
  256. foreach ($data['data'] as $key => $value){
  257. $data['data'][$key]['crt_time'] = $value['crt_time'] ? date('Y-m-d H:i:s',$value['crt_time']) : '';
  258. $data['data'][$key]['payment_receipt_date'] = $value['payment_receipt_date'] ? date('Y-m-d',$value['payment_receipt_date']) : '';
  259. $data['data'][$key]['crt_name'] = $emp[$value['crt_id']] ?? '';
  260. $data['data'][$key]['state_title'] = PaymentReceipt::$name[$value['state']] ?? '';
  261. $data['data'][$key]['type_title'] = PaymentReceipt::$model_type[$value['type']] ?? '';
  262. $data['data'][$key]['data_type_title'] = PaymentReceipt::$data_type[$value['data_type']] ?? '';
  263. $data['data'][$key]['account_title'] = $basic_map[$value['account']] ?? '';
  264. $data['data'][$key]['pay_way_title'] = $basic_map[$value['pay_way']] ?? '';
  265. }
  266. return $data;
  267. }
  268. }