123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677 |
- <?php
- namespace App\Service;
- use App\Model\BasicType;
- use App\Model\Employee;
- use App\Model\PaymentReceipt;
- use App\Model\PaymentReceiptInfo;
- use App\Model\PurchaseOrder;
- use App\Model\ReturnExchangeOrder;
- use App\Model\SalesOrder;
- use Illuminate\Support\Facades\DB;
- class PaymentReceiptService extends Service
- {
- public function paymentReceiptGet($data,$user){
- $order_number = (new OrderNoService())->createOrderNumber(PaymentReceipt::prefix);
- if(! $order_number) return [false,'工单编号生成失败!'];
- return [true,['order_number' => $order_number]];
- }
- public function customerEdit($data,$user){
- list($status,$msg) = $this->customerRule($data,$user, false);
- if(!$status) return [$status,$msg];
- try {
- DB::beginTransaction();
- $model = PaymentReceipt::where('id',$data['id'])->first();
- // $model->data_order_no = $data['data_order_no'];
- // $model->data_type = $data['data_type'];
- $model->type = $data['type'];
- $model->account = $data['account'] ?? 0;
- $model->pay_way = $data['pay_way'] ?? 0;
- // $model->amount = $data['amount'] ?? 0;
- $model->mark = $data['mark'] ?? '';
- $model->payment_receipt_date = $data['payment_receipt_date'] ?? 0;
- $model->save();
- $time = time();
- $old = PaymentReceiptInfo::where('del_time',0)
- ->where('payment_receipt_id',$data['id'])
- ->select('file')
- ->get()->toArray();
- $old = array_column($old,'file');
- PaymentReceiptInfo::where('del_time',0)
- ->where('payment_receipt_id',$data['id'])
- ->update(['del_time' => $time]);
- $new = [];
- if(! empty($data['file'])){
- $insert = [];
- foreach ($data['file'] as $value){
- $insert[] = [
- 'payment_receipt_id' => $model->id,
- 'file' => $value['url'],
- 'type' => PaymentReceiptInfo::type_one,
- 'name' => $value['name'],
- 'crt_time' => $time,
- ];
- }
- $new[]= $value['url'];
- PaymentReceiptInfo::insert($insert);
- }
- if(! empty($data['employee_one'])){
- $insert = [];
- foreach ($data['employee_one'] as $value){
- $insert[] = [
- 'payment_receipt_id' => $model->id,
- 'data_id' => $value,
- 'type' => PaymentReceiptInfo::type_two,
- 'crt_time' => $time,
- ];
- }
- PaymentReceiptInfo::insert($insert);
- }
- if(! empty($data['amount_list'])){
- $insert = [];
- foreach ($data['amount_list'] as $value){
- $insert[] = [
- 'payment_receipt_id' => $model->id,
- 'data_type' => $data['type'],
- 'data_order_no' => $value['data_order_no'],
- 'data_order_type' => $data['data_type'],
- 'amount' => $value['amount'],
- 'type' => PaymentReceiptInfo::type_three,
- 'crt_time' => $time,
- ];
- }
- PaymentReceiptInfo::insert($insert);
- }
- DB::commit();
- }catch (\Exception $exception){
- DB::rollBack();
- return [false,$exception->getMessage()];
- }
- $this->delStorageFile($old, $new);
- if(! empty($data['check'])) {
- list($status,$msg) = (new CheckService())->checkAll([
- "id" => $data['id'],
- "order_number" => $data['order_number'],
- "opt_case" => CheckService::ten,
- "menu_id" => $data['menu_id']
- ],$user);
- if(! $status) return [true, '保存成功,收付款确认失败,异常信息:' . $msg];
- }
- return [true,''];
- }
- public function customerAdd($data,$user){
- list($status,$msg) = $this->customerRule($data,$user);
- if(!$status) return [$status,$msg];
- try {
- DB::beginTransaction();
- $model = new PaymentReceipt();
- $model->order_number = $data['order_number'];
- // $model->data_order_no = $data['data_order_no'];
- $model->data_type = $data['data_type'];
- $model->type = $data['type'];
- $model->account = $data['account'] ?? 0;
- $model->pay_way = $data['pay_way'] ?? 0;
- // $model->amount = $data['amount'] ?? 0;
- $model->mark = $data['mark'] ?? '';
- $model->crt_id = $user['id'];
- $model->depart_id = $data['depart_id'];
- $model->top_depart_id = $data['top_depart_id'];
- $model->payment_receipt_date = $data['payment_receipt_date'] ?? 0;
- $model->save();
- $time = time();
- if(! empty($data['file'])){
- $insert = [];
- foreach ($data['file'] as $value){
- $insert[] = [
- 'payment_receipt_id' => $model->id,
- 'file' => $value['url'],
- 'type' => PaymentReceiptInfo::type_one,
- 'name' => $value['name'],
- 'crt_time' => $time,
- ];
- }
- PaymentReceiptInfo::insert($insert);
- }
- if(! empty($data['employee_one'])){
- $insert = [];
- foreach ($data['employee_one'] as $value){
- $insert[] = [
- 'payment_receipt_id' => $model->id,
- 'data_id' => $value,
- 'type' => PaymentReceiptInfo::type_two,
- 'crt_time' => $time,
- ];
- }
- PaymentReceiptInfo::insert($insert);
- }
- if(! empty($data['amount_list'])){
- $insert = [];
- foreach ($data['amount_list'] as $value){
- $insert[] = [
- 'payment_receipt_id' => $model->id,
- 'data_type' => $data['type'],
- 'data_order_no' => $value['data_order_no'],
- 'data_order_type' => $data['data_type'],
- 'amount' => $value['amount'],
- 'type' => PaymentReceiptInfo::type_three,
- 'crt_time' => $time,
- ];
- }
- PaymentReceiptInfo::insert($insert);
- }
- DB::commit();
- }catch (\Exception $exception){
- DB::rollBack();
- return [false,$exception->getMessage()];
- }
- if(! empty($data['check'])) {
- list($status,$msg) = (new CheckService())->checkAll([
- "id" => $model->id,
- "order_number" => $data['order_number'],
- "opt_case" => CheckService::ten,
- "menu_id" => $data['menu_id']
- ],$user);
- if(! $status) return [true, '保存成功,收付款确认失败,异常信息:' . $msg];
- }
- return [true,''];
- }
- public function customerDel($data){
- if($this->isEmpty($data,'id')) return [false,'请选择数据!'];
- $booking = PaymentReceipt::where('del_time',0)->where('id',$data['id'])->first();
- if(empty($booking)) return [false,'收付款单不存在或已被删除'];
- $booking = $booking->toArray();
- if($booking['state'] != PaymentReceipt::STATE_ZERO) return [false,'请确认收付款单状态,删除失败'];
- try {
- DB::beginTransaction();
- $time = time();
- $old = PaymentReceiptInfo::where('del_time',0)
- ->where('payment_receipt_id',$data['id'])
- ->select('file')
- ->get()->toArray();
- $old = array_column($old,'file');
- PaymentReceipt::where('id',$data['id'])->update([
- 'del_time'=> $time
- ]);
- PaymentReceiptInfo::where('del_time',0)
- ->where('payment_receipt_id',$data['id'])
- ->update(['del_time' => $time]);
- DB::commit();
- }catch (\Exception $exception){
- DB::rollBack();
- return [false,$exception->getMessage()];
- }
- $this->delStorageFile($old);
- return [true,''];
- }
- public function customerDetail($data){
- if(empty($data['id']) && empty($data['order_number'])) return [false,'请选择数据!'];
- if(! empty($data['id'])){
- $customer = PaymentReceipt::where('del_time',0)
- ->where('id',$data['id'])
- ->first();
- }else{
- $customer = PaymentReceipt::where('del_time',0)
- ->where('order_number',$data['order_number'])
- ->first();
- $data['id'] = empty($customer->id) ? 0 : $customer->id;
- }
- if(empty($customer)) return [false,'收付款记录不存在或已被删除'];
- $customer = $customer->toArray();
- $array = [
- $customer['account'],
- $customer['pay_way'],
- ];
- $basic_map = BasicType::whereIn('id',$array)
- ->pluck('title','id')
- ->toArray();
- $customer['account_title'] = $basic_map[$customer['account']] ?? "";
- $customer['pay_way_title'] = $basic_map[$customer['pay_way']] ?? "";
- $customer['state_title'] = PaymentReceipt::$name[$customer['state']] ?? "";
- $customer['type_title'] = PaymentReceipt::$model_type[$customer['type']] ?? "";
- $customer['data_type_title'] = PaymentReceipt::$data_type[$customer['data_type']] ?? "";
- $customer['crt_name'] = Employee::where('id',$customer['crt_id'])->value('emp_name');
- $customer['crt_time'] = $customer['crt_time'] ? date("Y-m-d H:i:s",$customer['crt_time']): '';
- $customer['payment_receipt_date'] = $customer['payment_receipt_date'] ? date("Y-m-d",$customer['payment_receipt_date']): '';
- $customer['receipt_amount'] = $customer['state'] == PaymentReceipt::STATE_TWO ? $customer['amount'] : 0;
- $file = PaymentReceiptInfo::where('del_time',0)
- ->where('payment_receipt_id',$data['id'])
- ->get()->toArray();
- $emp_id = [];
- $order_no = [];
- foreach ($file as $value){
- if(in_array($value['type'],PaymentReceiptInfo::$man)){
- $emp_id[] = $value['data_id'];
- }
- if(! empty($value['data_order_no'])) $order_no[] = $value['data_order_no'];
- }
- if($customer['data_type'] == PaymentReceipt::data_type_one){
- $order = SalesOrder::where('del_time',0)
- ->whereIn('order_number',$order_no)
- ->pluck('contract_fee','order_number')
- ->toArray();
- $getDifferentAmountALL = (new ReturnExchangeOrderService())->getDifferentAmountALL2(array_keys($order));
- }else{
- $order = PurchaseOrder::where('del_time',0)
- ->whereIn('order_number',$order_no)
- ->pluck('purchase_total','order_number')
- ->toArray();
- $getDifferentAmountALL = (new ReturnExchangeOrderService())->getDifferentAmountALL2(array_keys($order), ReturnExchangeOrder::Order_type2);
- }
- $infos = PaymentReceiptInfo::where('del_time',0)
- ->where('type',PaymentReceiptInfo::type_three)
- ->where('payment_receipt_id','<>',$customer['id'])
- ->get()->toArray();
- $infos_map = [];
- foreach ($infos as $value){
- $keys = $value['data_order_no'] . $value['data_type'];
- if(isset($infos_map[$keys])){
- $infos_map[$keys] += $value['amount'];
- }else{
- $infos_map[$keys] = $value['amount'];
- }
- }
- $emp_map = Employee::whereIn('id',array_unique($emp_id))
- ->pluck('emp_name','id')
- ->toArray();
- $customer['file'] = $customer['employee_one'] = $customer['amount_list'] = [];
- foreach ($file as $value){
- if($value['type'] == PaymentReceiptInfo::type_one){
- $tmp = [
- 'url' => $value['file'],
- 'name' => $value['name'],
- ];
- $customer['file'][] = $tmp;
- }elseif (in_array($value['type'],PaymentReceiptInfo::$man)){
- $tt = $emp_map[$value['data_id']] ?? '';
- if(! empty($tt)){
- $tmp = [
- 'id' => $value['data_id'],
- 'name' => $emp_map[$value['data_id']] ?? '',
- ];
- if($value['type'] == PaymentReceiptInfo::type_two){
- $customer['employee_one'][] = $tmp;
- }
- }
- }elseif ($value['type'] == PaymentReceiptInfo::type_three){
- $total = $has_amount = 0;
- $receipt_amount = $value['amount'];
- if($customer['type'] == PaymentReceipt::type_one){
- //坏账金额
- $bad_amount = $infos_map[$value['data_order_no'] . PaymentReceipt::type_four] ?? 0;
- //除了本单外的已收金额
- $has_amount = $infos_map[$value['data_order_no'] . PaymentReceipt::type_one] ?? 0;
- //总回款金额 = 合同金额 - 退换货金额 - 已收金额 - 坏账金额
- $total = ($order[$value['data_order_no']] ?? 0) - ($getDifferentAmountALL[$value['data_order_no']] ?? 0) - $bad_amount - $has_amount;
- }elseif($customer['type'] == PaymentReceipt::type_three){
- //已回款金额
- $one = $infos_map[$value['data_order_no'] . PaymentReceipt::type_one] ?? 0;
- //除了本单外的已红冲金额
- $has_amount = $infos_map[$value['data_order_no'] . PaymentReceipt::type_three] ?? 0;
- //总红冲金额 = 已回款金额 - 已红冲金额
- $total = $one - $has_amount;
- }elseif($customer['type'] == PaymentReceipt::type_four){
- //已回款金额
- $one = $infos_map[$value['data_order_no'] . PaymentReceipt::type_one] ?? 0;
- //已红冲金额
- $three = $infos_map[$value['data_order_no'] . PaymentReceipt::type_three] ?? 0;
- //除了本单外的已坏账金额
- $has_amount = $infos_map[$value['data_order_no'] . PaymentReceipt::type_four] ?? 0;
- //总坏账金额 = 合同金额 - 退换货金额 - 已收金额 + 已红冲金额 - 坏账金额
- $total = ($order[$value['data_order_no']] ?? 0) - ($getDifferentAmountALL[$value['data_order_no']] ?? 0) - $one + $three - $has_amount;
- }
- $tmp = [
- 'data_order_no' => $value['data_order_no'],
- 'amount' => $value['amount'],
- 'total_amount' => $total,
- 'has_amount' => $has_amount,
- 'receipt_amount' => $receipt_amount
- ];
- $customer['amount_list'][] = $tmp;
- }
- }
- return [true, $customer];
- }
- public function customerList($data,$user){
- $model = PaymentReceipt::Clear($user,$data);
- $model = $model->where('del_time',0)
- ->select('type','id','data_type','order_number','data_order_no','amount','account','pay_way','crt_id','crt_time','mark','state','payment_receipt_date')
- ->orderby('id', 'desc');
- if(isset($data['state'])) $model->where('state', $data['state']);
- if(! empty($data['data_order_no'])) {
- $info = PaymentReceiptInfo::where('del_time',0)
- ->where('type',PaymentReceiptInfo::type_three)
- ->where('data_order_no', 'LIKE', '%'.$data['data_order_no'].'%')
- ->select('payment_receipt_id')
- ->get()->toArray();
- $model->whereIn('id', array_unique(array_column($info,'payment_receipt_id')));
- }
- if(! empty($data['order_number'])) $model->where('order_number', 'LIKE', '%'.$data['order_number'].'%');
- if(! empty($data['data_type'])) $model->where('data_type', $data['data_type']);
- if(! empty($data['type'])) $model->where('type', $data['type']);
- if(! empty($data['account'])) $model->where('account',$data['account']);
- if(! empty($data['pay_way'])) $model->where('pay_way',$data['pay_way']);
- if(! empty($data['mark'])) $model->where('mark', 'LIKE', '%'.$data['mark'].'%');
- if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
- $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
- $model->where('crt_time','>=',$return[0]);
- $model->where('crt_time','<=',$return[1]);
- }
- if(! empty($data['payment_receipt_date'][0]) && ! empty($data['payment_receipt_date'][1])){
- $return = $this->changeDateToTimeStampAboutRange($data['payment_receipt_date']);
- $model->where('payment_receipt_date','>=',$return[0]);
- $model->where('payment_receipt_date','<=',$return[1]);
- }
- if(! empty($data['belong'])){
- $id = (new RangeService())->paymentReceiptSearch($data);
- $model->whereIn('id',$id);
- }
- $list = $this->limit($model,'',$data);
- $list = $this->fillData($list);
- return [true, $list];
- }
- public function customerRule(&$data, $user, $is_add = true){
- if(empty($data['order_number'])) return [false,'收付款单编号不能为空'];
- if(empty($data['data_type'])) return [false,'单号类型不能为空'];
- if(empty($data['type'])) return [false,'收付款类型不能为空'];
- if(empty($data['amount_list']) || ! is_array($data['amount_list'])) return [false,'关联单号与金额不能为空'];
- foreach ($data['amount_list'] as $value){
- if(empty($value['data_order_no'])) return [false,'关联单号不能为空'];
- if(empty($value['amount'])) return [false,'金额不能为空'];
- $res = $this->checkNumber($value['amount']);
- if(! $res) return [false, '金额请输入不超过两位小数并且大于0的数值'];
- }
- if(! empty($data['payment_receipt_date'])) $data['payment_receipt_date'] = $this->changeDateToDate($data['payment_receipt_date']);
- //所属部门 以及 顶级部门
- if(empty($data['depart_id'])) {
- $data['depart_id'] = $this->getDepart($user);
- $data['top_depart_id'] = $user['depart_map'][$data['depart_id']] ?? 0;
- }
- list($status,$msg) = $this->limitingSendRequestBackgExpire("paymentReceipt" . $data['order_number']);
- if(! $status) return [false, $msg];
- if($is_add){
- $bool = PaymentReceipt::where('del_time',0)
- ->where('order_number',$data['order_number'])
- ->exists();
- if($bool) return [false,'收付款单编号已存在,请重新获取'];
- }else{
- if(empty($data['id'])) return [false,'ID不能为空'];
- $booking = PaymentReceipt::where('del_time',0)->where('id',$data['id'])->first();
- if(empty($booking)) return [false,'收付款单不存在或已被删除'];
- $booking = $booking->toArray();
- if($booking['state'] != PaymentReceipt::STATE_ZERO) return [false,'请确认收付款单状态,编辑失败'];
- }
- return [true, ''];
- }
- public function fillData($data){
- if(empty($data['data'])) return $data;
- $emp = Employee::whereIn('id',array_unique(array_column($data['data'],'crt_id')))
- ->pluck('emp_name','id')
- ->toArray();
- $array = array_unique(array_merge_recursive(array_column($data['data'],'account'),array_column($data['data'],'pay_way')));
- $basic_map = BasicType::whereIn('id',$array)
- ->pluck('title','id')
- ->toArray();
- $map = [];
- $info = PaymentReceiptInfo::where('del_time',0)
- ->where('type',PaymentReceiptInfo::type_three)
- ->whereIn('payment_receipt_id', array_unique(array_column($data['data'],'id')))
- ->select('payment_receipt_id','data_order_no')
- ->get()->toArray();
- foreach ($info as $value){
- $map[$value['payment_receipt_id']][] = $value['data_order_no'];
- }
- foreach ($data['data'] as $key => $value){
- $data['data'][$key]['crt_time'] = $value['crt_time'] ? date('Y-m-d H:i:s',$value['crt_time']) : '';
- $data['data'][$key]['payment_receipt_date'] = $value['payment_receipt_date'] ? date('Y-m-d',$value['payment_receipt_date']) : '';
- $data['data'][$key]['crt_name'] = $emp[$value['crt_id']] ?? '';
- $data['data'][$key]['state_title'] = PaymentReceipt::$name[$value['state']] ?? '';
- $data['data'][$key]['type_title'] = PaymentReceipt::$model_type[$value['type']] ?? '';
- $data['data'][$key]['data_type_title'] = PaymentReceipt::$data_type[$value['data_type']] ?? '';
- $data['data'][$key]['account_title'] = $basic_map[$value['account']] ?? '';
- $data['data'][$key]['pay_way_title'] = $basic_map[$value['pay_way']] ?? '';
- $data['data'][$key]['data_order_no'] = $map[$value['id']] ?? [];
- }
- return $data;
- }
- //详情里
- public function getPaymentReceiptDataList($data){
- $data['data_order_no'] = $data['order_number'];
- $info1 = PaymentReceiptInfo::where('del_time',0)
- ->where('data_order_no',$data['data_order_no'])
- ->where('type',PaymentReceiptInfo::type_three)
- ->get()->toArray();
- $map = [];
- foreach ($info1 as $value){
- $key = $value['payment_receipt_id'] . $value['data_type'];
- if(isset($map[$key])){
- $map[$key] += $value['amount'];
- }else{
- $map[$key] = $value['amount'];
- }
- }
- $order = PaymentReceipt::where('del_time',0)
- ->whereIn('id',array_column($info1,'payment_receipt_id'))
- ->get()->toArray();
- $emp_id = PaymentReceiptInfo::where('del_time',0)
- ->whereIn('payment_receipt_id',array_column($order,'id'))
- ->where('type',PaymentReceiptInfo::type_two)
- ->get()->toArray();
- $info = [];
- if(! empty($emp_id)){
- $emp_map = Employee::whereIn('id',array_unique(array_column($emp_id,'data_id')))
- ->pluck('emp_name','id')
- ->toArray();
- foreach ($emp_id as $value){
- $name = $emp_map[$value['data_id']] ?? "";
- if(isset($info[$value['data_id']])){
- $info[$value['data_id']] .= ',' . $name;
- }else{
- $info[$value['data_id']] = $name;
- }
- }
- }
- //四个金额类型
- $one = $two = $three = $four = 0;
- foreach ($order as $key => $value){
- $keys = $value['id'] . $value['type'];
- //归属人
- $order[$key]['belong'] = $info[$value['id']] ?? '';
- $order[$key]['state_title'] = PaymentReceipt::$name[$value['state']] ?? '';
- $order[$key]['type_title'] = PaymentReceipt::$model_type[$value['type']] ?? '';
- $order[$key]['payment_receipt_date'] = $value['payment_receipt_date'] ? date('Y-m-d',$value['payment_receipt_date']) : '';
- //统计每个收付款单 =》总收付款金额
- $amount = $map[$keys] ?? 0;
- $order[$key]['amount'] = $amount;
- if($value['type'] == PaymentReceipt::type_one){
- $one += $amount;
- }elseif($value['type'] == PaymentReceipt::type_two){
- $two += $amount;
- }elseif($value['type'] == PaymentReceipt::type_three){
- $three += $amount;
- }elseif($value['type'] == PaymentReceipt::type_four){
- $four += $amount;
- }
- }
- $return['receipt_amount'] = $one;
- $return['not_receipt_amount'] = 0;
- $return['red_amount'] = $three;
- $return['bad_amount'] = $four;
- $return['all_count'] = count($order);
- $return['list'] = $order;
- return $return;
- }
- //列表里 默认:(收款)
- public function getPaymentReceiptDataCountList($data,$type=0){
- $data_order_no = [];
- if(! $type){
- foreach ($data as $value){
- $data_order_no[] = $value['order_number'];
- }
- }else{
- $data_order_no = $data;
- }
- if(empty($data_order_no)) return [];
- $order = PaymentReceiptInfo::where('del_time',0)
- ->where('type',PaymentReceiptInfo::type_three)
- ->whereIn('data_order_no',$data_order_no)
- ->get()->toArray();
- $return = [];
- foreach ($order as $value){
- $key = $value['data_order_no'] . $value['data_type'];
- if(isset($return[$key])){
- $return[$key] += $value['amount'];
- }else{
- $return[$key] = $value['amount'];
- }
- }
- return $return;
- }
- //废弃
- public function getPaymentReceiptDeatail($data){
- $customer = PaymentReceipt::where('del_time',0)
- ->where('crt_time',$data['crt_time'])
- ->where('id',$data['id'])
- ->first();
- if(empty($customer)) return [];
- $customer = $customer->toArray();
- $array = [
- $customer['account'],
- $customer['pay_way'],
- ];
- $basic_map = BasicType::whereIn('id',$array)
- ->pluck('title','id')
- ->toArray();
- $customer['account_title'] = $basic_map[$customer['account']] ?? "";
- $customer['pay_way_title'] = $basic_map[$customer['pay_way']] ?? "";
- $customer['state_title'] = PaymentReceipt::$name[$customer['state']] ?? "";
- $customer['type_title'] = PaymentReceipt::$model_type[$customer['type']] ?? "";
- $customer['data_type_title'] = PaymentReceipt::$data_type[$customer['data_type']] ?? "";
- $customer['crt_name'] = Employee::where('id',$customer['crt_id'])->value('emp_name');
- $customer['crt_time'] = $customer['crt_time'] ? date("Y-m-d H:i:s",$customer['crt_time']): '';
- $customer['payment_receipt_date'] = $customer['payment_receipt_date'] ? date("Y-m-d",$customer['payment_receipt_date']): '';
- $customer['receipt_amount'] = $customer['state'] == PaymentReceipt::STATE_TWO ? $customer['amount'] : 0;
- $file = PaymentReceiptInfo::where('del_time',0)
- ->where('payment_receipt_id',$data['id'])
- ->get()->toArray();
- $emp_id = [];
- foreach ($file as $value){
- if(in_array($value['type'],PaymentReceiptInfo::$man)){
- $emp_id[] = $value['data_id'];
- }
- }
- $emp_map = Employee::whereIn('id',array_unique($emp_id))
- ->pluck('emp_name','id')
- ->toArray();
- $customer['file'] = $customer['employee_one'] = [];
- foreach ($file as $value){
- if($value['type'] == PaymentReceiptInfo::type_one){
- $tmp = [
- 'url' => $value['file'],
- 'name' => $value['name'],
- ];
- $customer['file'][] = $tmp;
- }elseif (in_array($value['type'],PaymentReceiptInfo::$man)){
- $tt = $emp_map[$value['data_id']] ?? '';
- if(! empty($tt)){
- $tmp = [
- 'id' => $value['data_id'],
- 'name' => $emp_map[$value['data_id']] ?? '',
- ];
- if($value['type'] == PaymentReceiptInfo::type_two){
- $customer['employee_one'][] = $tmp;
- }
- }
- }
- }
- return $customer;
- }
- public function maked(){
- $payment = PaymentReceipt::where('del_time',0)
- ->where('data_order_no','LIKE', '%'."T9SO.".'%')
- ->where('amount','>',0)
- ->get()->toArray();
- $insert = [];
- foreach ($payment as $value){
- $insert[] = [
- 'payment_receipt_id' => $value['id'],
- 'crt_time' => $value['crt_time'],
- 'type' => PaymentReceiptInfo::type_three,
- 'data_order_no' => $value['data_order_no'],
- 'amount' => $value['amount'],
- 'data_order_type' => $value['type'],
- 'data_type' => PaymentReceipt::type_one,
- ];
- }
- if(! empty($insert)) PaymentReceiptInfo::insert($insert);
- }
- }
|