t_nine/app/Service/DeleteService.php

<?php

namespace App\Service;

use App\Model\Construction;
use App\Model\Customer;
use App\Model\CustomerInfo;
use App\Model\Employee;
use App\Model\OrderOperation;
use App\Model\SalesOrder;
use App\Model\SalesOrderInfo;
use App\Model\ScheduleInfo;
use Illuminate\Support\Facades\DB;

class DeleteService extends Service
{
    public function getMan($data,$user){
        if(empty($data['id']) || empty($data['type']) || empty($data['man_type'])) return [false, '必填参数不能为空！'];

        $return = [];
        if($data['type'] == 1){
            $return = $this->getSaleOrderMan($data);
        }

        return [true, $return];
    }

    public function delete($data,$user){
        if(empty($data['id']) || empty($data['type']) || empty($data['man_type']) || empty($data['man'])) return [false, '必填参数不能为空！'];

        try {
            DB::beginTransaction();
            if($data['type'] == 1){
                $this->delSaleOrderMan($data,$user);
            }
            DB::commit();
        }catch (\Exception $exception){
            DB::rollBack();
            return [false,$exception->getMessage()];
        }

        return [true,''];
    }

    public function getSaleOrderMan($data){
        $man_id = SalesOrderInfo::where('del_time',0)
            ->where('sales_order_id',$data['id'])
            ->where('type',$data['man_type'])
            ->get('data_id')->toArray();
        $man_id = array_column($man_id,'data_id');
        return Employee::whereIn('id',$man_id)->select('id', 'emp_name')->get()->toArray();
    }

    public function delSaleOrderMan($data,$user){
         $time = time();
         SalesOrderInfo::where('del_time',0)
             ->where('sales_order_id',$data['id'])
             ->where('type',$data['man_type'])
             ->update(['del_time' => $time]);
         if(! empty($data['man'])){
             $insert = [];
             foreach ($data['man'] as $value){
                 $insert[] = [
                     'sales_order_id' => $data['id'],
                     'data_id' => $value,
                     'type' => $data['man_type'],
                     'crt_time' => $time,
                 ];
             }
             SalesOrderInfo::insert($insert);

             $type = 0;
             if($data['man_type'] == SalesOrderInfo::type_two) $type = OrderOperation::sixty;
             if($data['man_type'] == SalesOrderInfo::type_three) $type = OrderOperation::seventeen;
             $order = SalesOrder::where('id',$data['id'])->first();
             $order = $order->toArray();
             if($type){
                 (new OrderOperationService())->add([
                     'order_number' => $order['order_number'],
                     'msg' => OrderOperation::$type[$type] ?? "",
                     'type' => $type
                 ],$user);
             }
         }
    }

    public function fp($data,$user){
        if(empty($data['id']) || empty($data['type']) || empty($data['man'])) return [false, '必填参数不能为空！'];

        try {
            DB::beginTransaction();
            if($data['type'] == 1){
                $this->fpSaleOrderMan($data,$user);
            }elseif ($data['type'] == 2){
                $this->fpCustomerMan($data,$user);
            }

            DB::commit();
        }catch (\Exception $exception){
            DB::rollBack();
            return [false,$exception->getMessage()];
        }

        return [true,''];
    }

    public function fpSaleOrderMan($data,$user){
        $time = time();
        if(! empty($data['man'])){
            $insert = [];
            foreach ($data['man'] as $value){
                $insert[] = [
                    'sales_order_id' => $data['id'],
                    'data_id' => $value,
                    'type' => SalesOrderInfo::type_two,
                    'crt_time' => $time,
                ];
            }
            SalesOrderInfo::insert($insert);

            $order = SalesOrder::where('id',$data['id'])->first();
            $order = $order->toArray();
            (new OrderOperationService())->add([
                'order_number' => $order['order_number'],
                'msg' => OrderOperation::$type[OrderOperation::eighteen] ?? "",
                'type' => OrderOperation::eighteen
            ],$user);
        }
    }

    public function fpCustomerMan($data,$user){
        $time = time();
        if(! empty($data['man'])){
            $insert = [];
            foreach ($data['man'] as $value){
                $insert[] = [
                    'customer_id' => $data['id'],
                    'data_id' => $value,
                    'type' => CustomerInfo::type_two,
                    'crt_time' => $time,
                ];
            }
            CustomerInfo::insert($insert);

            $title = Customer::where('id',$data['id'])->value('title') ?? "";
            (new OrderOperationService())->add([
                'order_number' => Customer::$order_number . "|" . $data['id'] . "|" . $title,
                'msg' => OrderOperation::$type[OrderOperation::twenty_three] ?? "",
                'type' => OrderOperation::twenty_three
            ],$user);
        }
    }

    public function yj($data,$user){
        if(empty($data['id']) || empty($data['type']) || empty($data['man'])) return [false, '必填参数不能为空！'];

        try {
            DB::beginTransaction();
            if($data['type'] == 1){
                $this->yjSaleOrderMan($data,$user);
            }elseif ($data['type'] == 2){
                $this->yjCustomerMan($data,$user);
            }

            DB::commit();
        }catch (\Exception $exception){
            DB::rollBack();
            return [false,$exception->getMessage()];
        }

        return [true,''];
    }

    public function yjSaleOrderMan($data,$user){
        $time = time();

        SalesOrderInfo::where('del_time',0)
            ->where('sales_order_id',$data['id'])
            ->where('type', SalesOrderInfo::type_two)
            ->where('data_id', $user['id'])
            ->update(['del_time' => $time]);
        if(! empty($data['man'])){
            $insert = [];
            foreach ($data['man'] as $value){
                $insert[] = [
                    'sales_order_id' => $data['id'],
                    'data_id' => $value,
                    'type' => SalesOrderInfo::type_two,
                    'crt_time' => $time,
                ];
            }
            SalesOrderInfo::insert($insert);

            $order = SalesOrder::where('id',$data['id'])->first();
            $order = $order->toArray();
            (new OrderOperationService())->add([
                'order_number' => $order['order_number'],
                'msg' => OrderOperation::$type[OrderOperation::nineteen] ?? "",
                'type' => OrderOperation::nineteen
            ],$user);
        }
    }

    public function yjCustomerMan($data,$user){
        $time = time();

        CustomerInfo::where('del_time',0)
            ->where('customer_id',$data['id'])
            ->where('type', CustomerInfo::type_two)
            ->update(['del_time' => $time]);
        if(! empty($data['man'])){
            $insert = [];
            foreach ($data['man'] as $value){
                $insert[] = [
                    'customer_id' => $data['id'],
                    'data_id' => $value,
                    'type' => CustomerInfo::type_two,
                    'crt_time' => $time,
                ];
            }
            CustomerInfo::insert($insert);

            $title = Customer::where('id',$data['id'])->value('title') ?? "";
            (new OrderOperationService())->add([
                'order_number' => Customer::$order_number . "|" . $data['id'] . "|" . $title,
                'msg' => OrderOperation::$type[OrderOperation::twenty_four] ?? "",
                'type' => OrderOperation::twenty_four
            ],$user);
        }
    }

    public function pq($data,$user){
        list($status,$msg) = $this->pqRule($data,$user);
        if(! $status) return [false,$msg];

        try {
            DB::beginTransaction();

            if(! empty($msg['schedule_id']) && ! empty($msg['day_start_stamp']) && ! empty($msg['day_end_stamp'])){
                //如果已经设置过排期 将子表占用数据释放
                $schedule = ScheduleInfo::where('del_time',0)
                    ->where('schedule_id',$msg['schedule_id'])
                    ->where('start_time',$msg['day_start_stamp'])
                    ->where('end_time',$msg['day_end_stamp'])
                    ->where('is_use','>', ScheduleInfo::not_use)
                    ->first();
                if(! empty($schedule)) ScheduleInfo::where('id',$schedule->id)->update(['is_use' => ScheduleInfo::not_use]);
            }

            Construction::where('id',$data['id'])->update([
                'schedule_id' => $data['schedule_id'],
                'day_stamp' => $data['day_stamp'],
                'day_start_stamp' => $data['day_start_stamp'],
                'day_end_stamp' => $data['day_end_stamp'],
                'pq_state' => Construction::STATE_ONE
            ]);

            if(! empty($data['schedule_info_id'])) ScheduleInfo::where('id',$data['schedule_info_id'])->update(['is_use' => 1]);

            DB::commit();
        }catch (\Exception $exception){
            $this->dellimitingSendRequestBackg(ScheduleInfo::limit_key . $data['schedule_info_id']);
            DB::rollBack();
            return [false,$exception->getMessage()];
        }

        $this->dellimitingSendRequestBackg(ScheduleInfo::limit_key . $data['schedule_info_id']);

        return [true,''];
    }

    public function pqRule(&$data,$user){
        if(empty($data['id'])) return [false, '施工单不能为空！'];
        $construction = Construction::where('id',$data['id'])->where('del_time',0)->first();
        if(empty($construction)) return [false,'施工单不存在或已被删除'];
        $construction = $construction->toArray();
        if($construction['state'] != Construction::STATE_TWO) return [false,'施工单未确认无法排期！'];
        if(empty($data['schedule_id']) ||empty($data['day_stamp']) || empty($data['day_start_stamp']) || empty($data['day_end_stamp'])) return [false,'排班时间信息不能为空'];
        //day_stamp 日期的时间戳（0点的） day_start_stamp 日期加上开始时分的时间戳  day_end_stamp 日期加上结束时分的时间戳
        if($construction['day_stamp'] != $data['day_stamp'] || $construction['day_start_stamp'] != $data['day_start_stamp'] && $construction['day_end_stamp'] != $data['day_end_stamp']) {
            $schedule_info = ScheduleInfo::where('del_time',0)
                ->where('day',$data['day_stamp'])
                ->where('start_time',$data['day_start_stamp'])
                ->where('end_time',$data['day_end_stamp'])
                ->where('is_use',ScheduleInfo::not_use)
                ->first();
            if(empty($schedule_info)) return [false,'该时间段排班已满或不存在！'];
            $data['schedule_info_id'] = $schedule_info->id;
            list($status,$msg) = $this->limitingSendRequestBackg(ScheduleInfo::limit_key . $data['schedule_info_id']);
            if(! $status) return [false,'操作频繁，请稍等！'];
        }else{
            return [false,'排期未做更新！'];
        }

        return [true, $construction];
    }
}