workHour/app/Service/ItemService.php

<?php

namespace App\Service;

use App\Model\Device;
use App\Model\Employee;
use App\Model\Item;
use App\Model\ItemDetails;
use App\Model\ItemEmployee;
use App\Model\ItemNode;
use App\Model\ItemNodeDetails;
use App\Model\ItemNodeEmployee;
use App\Model\Tag;
use App\Model\SysMenu;
use Illuminate\Support\Facades\DB;

class ItemService extends Service
{
    public function itemEdit($data,$user){
        list($status,$msg) = $this->itemRule($data, $user, false);
        if(!$status) return [$status,$msg];

        try {
            DB::beginTransaction();

            $model = Item::where('id', $data['id'])->first();
            $old_employee_id = $model->charge_id;
            $tableName = $model->getTable();
            $model->code = $data['code'] ?? '';
            $model->title = $data['title'] ?? '';
            $model->mark = $data['mark'] ?? "";
            $model->start_time = $data['start_time'] ?? 0;
            $model->end_time = $data['end_time'] ?? 0;
            $model->state = $data['state'] ?? 0;
            $model->budget = $data['budget'] ?? 0;
            $model->charge_id = $data['charge_id'] ?? 0;
            $model->field = $data['field'] ?? "";
            $model->item_attribute = $data['item_attribute'] ?? 0;

            //项目管理的字段
            if($user['select_tree_type'] == SysMenu::tree_type_one){
                $model->is_review_required = $data['is_review_required'] ?? 0;
                $model->review_id = $data['review_id'] ?? 0;
                $model->priority_id = $data['priority_id'] ?? 0;
            }

            $model->save();

            $time = time();

            // 人员项目表
            $this->saveEmployee($data['id'], $time, $data, $user, $old_employee_id);

            ItemDetails::where('del_time',0)
                ->where('item_id', $model->id)
                ->update(['del_time' => $time]);
            $this->saveDetail($model->id, $time, $data);

            list($status, $msg) = CustomFieldSettingService::syncCustomFieldData($model->id, $tableName, $data, $user);
            if (! $status) {
                DB::rollBack();
                return [false, $msg];
            }

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

        return [true, ''];
    }

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

        try {
            DB::beginTransaction();

            $model = new Item();
            $tableName = $model->getTable();
            $model->code = $data['code'] ?? '';
            $model->title = $data['title'] ?? '';
            $model->mark = $data['mark'] ?? "";
            $model->start_time = $data['start_time'] ?? 0;
            $model->end_time = $data['end_time'] ?? 0;
            $model->state = $data['state'] ?? 0;
            $model->budget = $data['budget'] ?? 0;
            $model->charge_id = $data['charge_id'] ?? 0;
            $model->field = $data['field'] ?? "";
            $model->item_attribute = $data['item_attribute'] ?? 0;
            $model->is_review_required = $data['is_review_required'] ?? 0;
            $model->review_id = $data['review_id'] ?? 0;
            $model->priority_id = $data['priority_id'] ?? 0;
            $model->crt_id = $user['id'];
            $model->top_depart_id = $data['top_depart_id'];
            $model->save();

            $time = time();
            $this->saveDetail($model->id, $time, $data);

            // 人员项目表
            $this->saveEmployee($model->id, $time, $data, $user);

            list($status, $msg) = CustomFieldSettingService::syncCustomFieldData($model->id, $tableName, $data, $user);
            if (!$status) {
                DB::rollBack();
                return [false, $msg];
            }

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

        return [true, ''];
    }

    private function saveDetail($id, $time, $data){
        if(! empty($data['man_list'])){
            $unit = [];
            foreach ($data['man_list'] as $value){
                $unit[] = [
                    'item_id' => $id,
                    'type' => $value['type'],
                    'data_id' => $value['data_id'],
                    'crt_time' => $time,
                    'top_depart_id' => $value['top_depart_id'],
                ];
            }
            if(! empty($unit)) ItemDetails::insert($unit);
        }

        if(! empty($data['device_list'])){
            $receipt = [];
            foreach ($data['device_list'] as $value){
                $receipt[] = [
                    'item_id' => $id,
                    'type' => $value['type'],
                    'data_id' => $value['data_id'],
                    'crt_time' => $time,
                    'top_depart_id' => $value['top_depart_id'],
                ];
            }
            if(! empty($receipt)) ItemDetails::insert($receipt);
        }
    }

    private function saveEmployee($id, $time, $data, $user, $old_employee_id = 0){
        if($old_employee_id != $data['charge_id']){
            ItemEmployee::where('del_time',0)
                ->where('item_id', $id)
                ->where('data_id', $old_employee_id)
                ->delete();

            ItemEmployee::insert([
                'item_id' => $id,
                'data_id' => $data['charge_id'],
                'top_depart_id' => $user['top_depart_id'],
                'crt_time' => $time
            ]);
        }
    }

    private function getDetail($id){
        $data = ItemDetails::where('del_time',0)
            ->where('item_id', $id)
            ->get()->toArray();

        $id = $id2 = [];
        foreach ($data as $value){
            if($value['type'] == ItemDetails::type_one) {
                $id[] = $value['data_id'];
            }else{
                $id2[] = $value['data_id'];
            }
        }
        $map = Employee::whereIn('id', $id)->select('title','id','number')->get()->toArray();
        $map = array_column($map,null,'id');
        $map2 = Device::whereIn('id', $id2)->select('code','id','title')->get()->toArray();
        $map2 = array_column($map2,null,'id');

        $unit = $receipt = [];
        foreach ($data as $value){
            if($value['type'] == ItemDetails::type_one) {
                $tmp = $map[$value['data_id']] ?? [];
                $unit[] = [
                    'type' => $value['type'],
                    'data_id' => $value['data_id'],
                    'data_title' => $tmp['title'],
                    'data_code' => $tmp['number'],
                ];
            }else{
                $tmp = $map2[$value['data_id']] ?? [];
                $receipt[] = [
                    'type' => $value['type'],
                    'data_id' => $value['data_id'],
                    'data_title' => $tmp['title'] ?? "",
                    'data_code' => $tmp['code'] ?? "",
                ];
            }
        }

        return [
            'man_list' => $unit,
            'device_list' => $receipt,
        ];
    }

    public function getItemMap($ids){
        $ids = array_filter((array)$ids);
        if (empty($ids)) return [];

        return Item::whereIn('id', $ids)
            ->select('id', 'title', 'code')
            ->get()
            ->keyBy('id')
            ->toArray();
    }

    public function itemDel($data){
        if($this->isEmpty($data,'id')) return [false,'请选择数据！'];

        try {
            DB::beginTransaction();
            $time = time();

            Item::where('del_time',0)
                ->whereIn('id',$data['id'])
                ->update(['del_time' => $time]);

            ItemDetails::where('del_time',0)
                ->whereIn('item_id', $data['id'])
                ->update(['del_time' => $time]);

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

        return [true, ''];
    }

    public function itemDetail($data, $user){
        if($this->isEmpty($data,'id')) return [false,'请选择数据！'];
        $customer = Item::where('del_time',0)
            ->withCustomData($user)
            ->where('id',$data['id'])
            ->first();
        if(empty($customer)) return [false,'项目不存在或已被删除'];
        $customer->getFormattedCustomFields();// 自定义数据附件处理
        $customer = $customer->toArray();

        $customer['start_time']  = ! empty($customer['start_time']) ? date("Y-m-d", $customer['start_time']) : "";
        $customer['end_time']  = ! empty($customer['end_time']) ? date("Y-m-d", $customer['end_time']) : "";
        $customer['crt_name'] = Employee::where('id',$customer['crt_id'])->value('title');
        $customer['charge_name'] = Employee::where('id',$customer['charge_id'])->value('title');
        $customer['crt_time'] = $customer['crt_time'] ? date("Y-m-d H:i:s",$customer['crt_time']): '';
        $customer['state_title'] = Item::State_Type[$customer['state']] ?? '';
        $customer['priority_title'] = Tag::where('id', $customer['priority_id'])->value('title') ?? "";

        $details = $this->getDetail($data['id']);
        $customer = array_merge($customer, $details);

        return [true, $customer];
    }

    public function itemCommon($data,$user, $field = []){
        if(empty($field)) $field = Item::$field;

        $model = Item::TopClear($user,$data);
        $model = $model->where('del_time',0)
            ->select($field)
            ->orderby('id', 'desc');

        if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
        if(! empty($data['code'])) $model->where('code', 'LIKE', '%'.$data['code'].'%');
        if(! empty($data['id'])) $model->whereIn('id', $data['id']);
        if(! empty($data['state'])) $model->where('state', $data['state']);
        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]);
        }

        return $model;
    }

    public function itemCommon1($data,$user, $field = []){
        if(empty($field)) $field = Item::$field;

        $model = Item::TopAndEmployeeClear($user,$data);
        $model = $model->where('del_time',0)
            ->select($field)
            ->orderby('id', 'desc');

        if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
        if(! empty($data['code'])) $model->where('code', 'LIKE', '%'.$data['code'].'%');
        if(! empty($data['id'])) $model->whereIn('id', $data['id']);
        if(! empty($data['state'])) $model->where('state', $data['state']);
        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]);
        }

        return $model;
    }

    public function itemList($data,$user){
        $select_tree_type = $user['select_tree_type'];
        if(empty($select_tree_type)){
            //工时
            $model = $this->itemCommon($data, $user);
        }else{
            //项目管理
            $model = $this->itemCommon1($data, $user);
        }

        $list = $this->limit($model,'',$data);
        $list = $this->fillData($list);

        return [true, $list];
    }

    public function itemRule(&$data, $user, $is_add = true){
        $data['top_depart_id'] = $user['top_depart_id'];
        if(empty($data['code'])) return [false, '项目编码不能为空'];
        if(empty($data['title'])) return [false, '项目名称不能为空'];
        if(! empty($data['start_time'])) $data['start_time'] = $this->changeDateToDate($data['start_time']);
        if(! empty($data['end_time'])) $data['end_time'] = $this->changeDateToDate($data['end_time'],true);
        $isMonthEnd = date('j', $data['end_time']) == date('t', $data['end_time']);
        if(! $isMonthEnd) return [false, '项目结束日期必须是当月最后一天'];
        if(empty($data['state'])) return [false, '项目状态不能为空'];
        if(! isset(Item::State_Type[$data['state']])) return [false, '项目状态不存在'];
        if(empty($data['man_list'])) return [false, '人员不能为空'];
        foreach ($data['man_list'] as $key => $value){
            if(empty($value['type'])) return [false, '类型不能为空'];
            if(empty($value['data_id'])) return [false, '人员不能为空'];
            $data['man_list'][$key]['top_depart_id'] = $data['top_depart_id'];
        }
        list($status, $msg) = $this->checkArrayRepeat($data['man_list'],'data_id','人员');
        if(! $status) return [false, $msg];
        if(empty($data['device_list'])) return [false, '设备不能为空'];
        if(isset($data['device_list'])){
            foreach ($data['device_list'] as $key => $value){
                if(empty($value['type'])) return [false, '类型不能为空'];
                if(empty($value['data_id'])) return [false, '设备ID不能为空'];
                $data['device_list'][$key]['top_depart_id'] = $data['top_depart_id'];
            }
        }

        list($status, $msg) = $this->checkArrayRepeat($data['device_list'],'data_id','设备');
        if(! $status) return [false, $msg];

        if(isset($data['budget'])){
            $res = $this->checkNumber($data['budget'],2,'non-negative');
            if(! $res['valid']) return [false,'预算：' . $res['error']];
        }
        if(! empty($data['item_attribute']) && ! isset(Item::Item_Attribute[$data['item_attribute']])) return [false, '项目属性不存在'];

        if($is_add){
            $bool = Item::where('code',$data['code'])
                ->where('top_depart_id', $data['top_depart_id'])
                ->where('del_time',0)
                ->exists();
        }else{
            if(empty($data['id'])) return [false,'ID不能为空'];
            $bool = Item::where('code',$data['code'])
                ->where('top_depart_id', $data['top_depart_id'])
                ->where('id','<>',$data['id'])
                ->where('del_time',0)
                ->exists();
        }
        if($bool) return [false, '项目编码已存在'];

        return [true, ''];
    }

    public function fillData($data){
        if(empty($data['data'])) return $data;

        $emp = (new EmployeeService())->getEmployeeMap(array_unique(array_merge_recursive(array_column($data['data'],'charge_id'), array_column($data['data'],'crt_id'))));
        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]['start_time'] = $value['start_time'] ? date('Y-m-d',$value['start_time']) : '';
            $data['data'][$key]['end_time'] = $value['end_time'] ? date('Y-m-d',$value['end_time']) : '';
            $data['data'][$key]['crt_name'] = $emp[$value['crt_id']] ?? '';
            $data['data'][$key]['charge_name'] = $emp[$value['charge_id']] ?? '';
            $data['data'][$key]['state_title'] = Item::State_Type[$value['state']] ?? "";
        }

        return $data;
    }

    /**
     * 填充项目导出数据（主表与明细平铺）
     */
    public function fillDataForExport($data, $column, $user, &$return)
    {
        if (empty($data)) return;

        $dataArray = is_array($data) ? $data : $data->toArray();
        $mainIds = array_column($dataArray, 'id');

        // 1. 获取详情映射 [item_id => [ [type_title=>..., code_2=>..., title=>...], ... ]]
        $detailsMap = $this->getDetailsMap($mainIds, $user);

        // 2. 获取主表状态映射
        $stateMap = \App\Model\Item::State_Type;
        $attrMap = \App\Model\Item::Item_Attribute;

        $empMap = Employee::whereIn('id', array_unique(array_column($dataArray,'charge_id')))->get()->keyBy('id');

        foreach ($dataArray as $main) {
            $itemId = $main['id'];
            $details = $detailsMap[$itemId] ?? [];

            // 3. 提取并格式化主表信息
            $mainInfo = $main;
            $mainInfo['state_title'] = $stateMap[$main['state'] ?? ''] ?? '';
            $mainInfo['item_attribute_title'] = $attrMap[$main['item_attribute'] ?? ''] ?? '';

            $tmpEmp = $empMap[$main['charge_id']] ?? null;
            $mainInfo['charge_number'] = $tmpEmp ? $tmpEmp->number : '';
            $mainInfo['charge_name'] = $tmpEmp ? $tmpEmp->title : '';

            // 日期格式化
            $mainInfo['start_time'] = !empty($main['start_time']) ? date('Y-m-d', $main['start_time']) : '';
            $mainInfo['end_time']   = !empty($main['end_time']) ? date('Y-m-d', $main['end_time']) : '';

            if (empty($details)) {
                // 如果单据没有明细，保底出一行
                $tempRow = [];
                foreach ($column as $col) {
                    $tempRow[] = $mainInfo[$col] ?? '';
                }
                $return[] = $tempRow;
            } else {
                // 4. 核心平铺逻辑：每一行明细都带上主表信息
                foreach ($details as $sub) {
                    // 合并主表数据和详情数据（sub 中包含 type_title, code_2, title 等）
                    $fullRowData = array_merge($mainInfo, $sub);

                    $tempRow = [];
                    foreach ($column as $col) {
                        $tempRow[] = $fullRowData[$col] ?? '';
                    }
                    $return[] = $tempRow;
                }
            }
        }
    }

    /**
     * 获取明细聚合映射表
     */
    public function getDetailsMap($mainIds, $user)
    {
        $details = ItemDetails::where('del_time', 0)
            ->whereIn('item_id', $mainIds)
            ->where('top_depart_id', $user['top_depart_id'])
            ->get();

        if ($details->isEmpty()) return [];

        // 1. 批量提取关联 ID
        $empIds = $details->where('type', ItemDetails::type_one)->pluck('data_id')->unique();
        $devIds = $details->where('type', ItemDetails::type_two)->pluck('data_id')->unique();

        // 2. 批量获取档案 Map
        $empMap = Employee::whereIn('id', $empIds)->get()->keyBy('id');
        $devMap = Device::whereIn('id', $devIds)->get()->keyBy('id');

        $typeNames = ItemDetails::$type_name;

        $res = [];
        foreach ($details as $item) {
            $detailRow = [];
            $detailRow['type_title'] = $typeNames[$item->type] ?? '';

            // 根据类型处理影子列 code_2 和 名称 title
            if ($item->type == ItemDetails::type_one) {
                $emp = $empMap[$item->data_id] ?? null;
                $detailRow['code_2'] = $emp ? $emp->number : '';
                $detailRow['title_2']  = $emp ? $emp->title : '';
            } else {
                $dev = $devMap[$item->data_id] ?? null;
                $detailRow['code_2'] = $dev ? $dev->code : '';
                $detailRow['title_2']  = $dev ? $dev->title : '';
            }

            // 归档到对应的主表 ID 下
            $res[$item->item_id][] = $detailRow;
        }

        return $res;
    }


    //项目节点
    public function itemNodeEdit($data,$user){
        list($status,$msg) = $this->itemNodeRule($data, $user, false);
        if(!$status) return [$status,$msg];

        try {
            DB::beginTransaction();

            $model = ItemNode::where('id', $data['id'])->first();
            $old_employee_id = $model->charge_id;
            $tableName = $model->getTable();
            $model->title = $data['title'] ?? '';
            $model->mark = $data['mark'] ?? "";
            $model->start_time = $data['start_time'] ?? 0;
            $model->end_time = $data['end_time'] ?? 0;
            $model->is_delivery_required = $data['is_delivery_required'] ?? 0;
            $model->entrust_type = $data['entrust_type'] ?? 0;
            $model->charge_id = $data['charge_id'] ?? 0;
            $model->node_id = $data['node_id'] ?? 0;
            $model->node_weight = $data['node_weight'] ?? 0;
            $model->is_review_required = $data['is_review_required'] ?? 0;
            $model->review_id = $data['review_id'] ?? 0;
            $model->priority_id = $data['priority_id'] ?? 0;
            $model->save();

            $time = time();
            ItemNodeDetails::where('del_time',0)
                ->where('item_node_id', $model->id)
                ->update(['del_time' => $time]);

            $this->saveNodeDetail($model->id, $time, $data);

            // 人员项目节点表
            $this->saveNodeEmployee($model->id, $time, $data, $user, $old_employee_id);

            list($status, $msg) = CustomFieldSettingService::syncCustomFieldData($model->id, $tableName, $data, $user);
            if (! $status) {
                DB::rollBack();
                return [false, $msg];
            }

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

        return [true, ''];
    }

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

        try {
            DB::beginTransaction();

            $model = new ItemNode();
            $model->item_id = $data['item_id'] ?? 0;
            $tableName = $model->getTable();
            $model->code = $this->generateBillNo([
                'top_depart_id' => $user['top_depart_id'],
                'type' => ItemNode::Order_type,
                'period' => date("Ym", time())
            ]);
            $model->title = $data['title'] ?? '';
            $model->mark = $data['mark'] ?? "";
            $model->start_time = $data['start_time'] ?? 0;
            $model->end_time = $data['end_time'] ?? 0;
            $model->is_delivery_required = $data['is_delivery_required'] ?? 0;
            $model->entrust_type = $data['entrust_type'] ?? 0;
            $model->charge_id = $data['charge_id'] ?? 0;
            $model->node_id = $data['node_id'] ?? 0;
            $model->node_weight = $data['node_weight'] ?? 0;
            $model->is_review_required = $data['is_review_required'] ?? 0;
            $model->review_id = $data['review_id'] ?? 0;
            $model->priority_id = $data['priority_id'] ?? 0;
            $model->crt_id = $user['id'];
            $model->top_depart_id = $data['top_depart_id'];
            $model->save();

            $time = time();
            $this->saveNodeDetail($model->id, $time, $data);

            // 人员项目节点表
            $this->saveNodeEmployee($model->id, $time, $data, $user);

            list($status, $msg) = CustomFieldSettingService::syncCustomFieldData($model->id, $tableName, $data, $user);
            if (!$status) {
                DB::rollBack();
                return [false, $msg];
            }

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

        return [true, ''];
    }

    private function saveNodeEmployee($id, $time, $data, $user, $old_employee_id = 0){
        if($old_employee_id != $data['charge_id']){
            ItemNodeEmployee::where('del_time',0)
                ->where('item_node_id', $id)
                ->where('data_id', $old_employee_id)
                ->delete();

            ItemNodeEmployee::insert([
                'item_node_id' => $id,
                'item_id' => $data['item_id'],
                'data_id' => $data['charge_id'],
                'top_depart_id' => $user['top_depart_id'],
                'crt_time' => $time
            ]);
        }
    }

    private function saveNodeDetail($id, $time, $data){
        if(! empty($data['man_list'])){
            $unit = [];
            foreach ($data['man_list'] as $value){
                $unit[] = [
                    'item_id' => $data['item_id'],
                    'item_node_id' => $id,
                    'type' => $value['type'],
                    'data_id' => $value['data_id'],
                    'crt_time' => $time,
                    'top_depart_id' => $value['top_depart_id'],
                ];
            }
            if(! empty($unit)) ItemNodeDetails::insert($unit);
        }

        if(! empty($data['device_list'])){
            $receipt = [];
            foreach ($data['device_list'] as $value){
                $receipt[] = [
                    'item_id' => $data['item_id'],
                    'item_node_id' => $id,
                    'type' => $value['type'],
                    'data_id' => $value['data_id'],
                    'crt_time' => $time,
                    'top_depart_id' => $value['top_depart_id'],
                ];
            }
            if(! empty($receipt)) ItemNodeDetails::insert($receipt);
        }
    }

    private function getNodeDetail($id){
        $data = ItemNodeDetails::where('del_time',0)
            ->where('item_node_id', $id)
            ->get()->toArray();

        $id = $id2 = [];
        foreach ($data as $value){
            if($value['type'] == ItemNodeDetails::type_one) {
                $id[] = $value['data_id'];
            }else{
                $id2[] = $value['data_id'];
            }
        }
        $map = Employee::whereIn('id', $id)->select('title','id','number')->get()->toArray();
        $map = array_column($map,null,'id');
        $map2 = Device::whereIn('id', $id2)->select('code','id','title')->get()->toArray();
        $map2 = array_column($map2,null,'id');

        $unit = $receipt = [];
        foreach ($data as $value){
            if($value['type'] == ItemNodeDetails::type_one) {
                $tmp = $map[$value['data_id']] ?? [];
                $unit[] = [
                    'type' => $value['type'],
                    'data_id' => $value['data_id'],
                    'data_title' => $tmp['title'],
                    'data_code' => $tmp['number'],
                ];
            }else{
                $tmp = $map2[$value['data_id']] ?? [];
                $receipt[] = [
                    'type' => $value['type'],
                    'data_id' => $value['data_id'],
                    'data_title' => $tmp['title'] ?? "",
                    'data_code' => $tmp['code'] ?? "",
                ];
            }
        }

        return [
            'man_list' => $unit,
            'device_list' => $receipt,
        ];
    }

    public function itemNodeDel($data){
        if($this->isEmpty($data,'id')) return [false,'请选择数据！'];

        try {
            DB::beginTransaction();
            $time = time();

            ItemNode::where('del_time',0)
                ->whereIn('id',$data['id'])
                ->update(['del_time' => $time]);

            ItemNodeDetails::where('del_time',0)
                ->whereIn('item_node_id', $data['id'])
                ->update(['del_time' => $time]);

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

        return [true, ''];
    }

    public function itemNodeDetail($data, $user){
        if($this->isEmpty($data,'id')) return [false,'请选择数据！'];
        $customer = ItemNode::where('del_time',0)
            ->withCustomData($user)
            ->where('id',$data['id'])
            ->first();
        if(empty($customer)) return [false,'项目节点不存在或已被删除'];
        $customer->getFormattedCustomFields();// 自定义数据附件处理
        $customer = $customer->toArray();

        $customer['start_time']  = ! empty($customer['start_time']) ? date("Y-m-d", $customer['start_time']) : "";
        $customer['end_time']  = ! empty($customer['end_time']) ? date("Y-m-d", $customer['end_time']) : "";
        $customer['crt_name'] = Employee::where('id',$customer['crt_id'])->value('title');
        $customer['charge_name'] = Employee::where('id',$customer['charge_id'])->value('title');
        $customer['crt_time'] = $customer['crt_time'] ? date("Y-m-d H:i:s",$customer['crt_time']): '';
        $customer['state_title'] = ItemNode::State_Type[$customer['state']] ?? '';

        $customer['priority_title'] = Tag::where('id', $customer['priority_id'])->value('title') ?? "";
        $customer['node_title'] = Tag::where('id', $customer['node_id'])->value('title') ?? "";
        $tag = (new TagService())->getTagMap(array_unique([$customer['priority_id'], $customer['node_id'] ]));
        $priority_tmp = $tag[$customer['priority_id']] ?? [];
        $customer['priority_title'] = $priority_tmp['title'] ?? '';
        $customer['priority_code'] = $priority_tmp['code'] ?? '';
        $node_tmp = $tag[$customer['node_id']] ?? [];
        $customer['node_title'] = $node_tmp['title'] ?? '';
        $customer['node_code'] = $node_tmp['code'] ?? '';

        $details = $this->getNodeDetail($data['id']);
        $customer = array_merge($customer, $details);

        return [true, $customer];
    }

    public function itemNodeCommon($data,$user, $field = []){
        if(empty($field)) $field = ItemNode::$field;

        $model = ItemNode::TopAndEmployeeClear($user,$data);
        $model = $model->where('del_time',0)
            ->select($field)
            ->orderby('id', 'desc');

        if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
        if(! empty($data['code'])) $model->where('code', 'LIKE', '%'.$data['code'].'%');
        if(! empty($data['id'])) $model->whereIn('id', $data['id']);
        if(isset($data['state'])) $model->where('state', $data['state']);
        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]);
        }

        return $model;
    }

    public function itemNodeList($data,$user){
        $model = $this->itemNodeCommon($data, $user);
        $list = $this->limit($model,'',$data);
        $list = $this->fillNodeData($list);

        return [true, $list];
    }

    public function itemNodeRule(&$data, $user, $is_add = true){
        $data['top_depart_id'] = $user['top_depart_id'];
        if(empty($data['item_id'])) return [false, '项目ID不能为空'];
        $item = Item::where('item_id', $data['item_id'])->where('del_time',0)->first();
        if(empty($item)) return [false, '项目不存在或已被删除'];
        $item = $item->toArray();
        if(empty($data['title'])) return [false, '节点名称不能为空'];
        if(! empty($data['start_time'])) $data['start_time'] = $this->changeDateToDate($data['start_time']);
        if(! empty($data['end_time'])) $data['end_time'] = $this->changeDateToDate($data['end_time'],true);

        $itemStartTime = $item['start_time'];
        $itemEndTime = $item['end_time'];
        if (!empty($data['start_time'])) {
            $inputStartTime = $data['start_time'];

            if ($itemStartTime > 0 && $inputStartTime < $itemStartTime) {
                return [false, '节点开始时间不能早于项目开始时间：' . date('Y-m-d', $itemStartTime)];
            }
        }
        if (!empty($data['end_time'])) {
            $inputEndTime = $data['end_time'];
            if ($itemEndTime > 0 && $inputEndTime > $itemEndTime) {
                return [false, '节点结束时间不能晚于项目结束时间：' . date('Y-m-d', $itemEndTime)];
            }
        }

        if(! empty($data['man_list'])) {
            foreach ($data['man_list'] as $key => $value){
                if(empty($value['type'])) return [false, '类型不能为空'];
                if(empty($value['data_id'])) return [false, '人员不能为空'];
                $data['man_list'][$key]['top_depart_id'] = $data['top_depart_id'];
            }
            list($status, $msg) = $this->checkArrayRepeat($data['man_list'],'data_id','人员');
            if(! $status) return [false, $msg];
        }

        if(! empty($data['device_list'])) {
            foreach ($data['device_list'] as $key => $value){
                if(empty($value['type'])) return [false, '类型不能为空'];
                if(empty($value['data_id'])) return [false, '设备ID不能为空'];
                $data['device_list'][$key]['top_depart_id'] = $data['top_depart_id'];
            }
            list($status, $msg) = $this->checkArrayRepeat($data['device_list'],'data_id','设备');
            if(! $status) return [false, $msg];
        }

        if($is_add){
            $bool = ItemNode::where('item_id',$data['item_id'])
                ->where('top_depart_id', $data['top_depart_id'])
                ->where('title', $data['title'])
                ->where('del_time',0)
                ->exists();
        }else{
            if(empty($data['id'])) return [false,'ID不能为空'];
            $bool = ItemNode::where('title', $data['title'])
                ->where('item_id',$data['item_id'])
                ->where('top_depart_id', $data['top_depart_id'])
                ->where('id','<>',$data['id'])
                ->where('del_time',0)
                ->exists();
        }
        if($bool) return [false, '该项目下节点名称已存在'];

        return [true, ''];
    }

    public function fillNodeData($data){
        if(empty($data['data'])) return $data;

        $emp = (new EmployeeService())->getEmployeeMap(array_unique(array_merge_recursive(array_column($data['data'],'charge_id'), array_column($data['data'],'crt_id'))));
        $tag = (new TagService())->getTagMap(array_unique(array_merge_recursive(array_column($data['data'],'priority_id'),array_column($data['data'],'node_id'))));
        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]['start_time'] = $value['start_time'] ? date('Y-m-d',$value['start_time']) : '';
            $data['data'][$key]['end_time'] = $value['end_time'] ? date('Y-m-d',$value['end_time']) : '';
            $data['data'][$key]['crt_name'] = $emp[$value['crt_id']] ?? '';
            $data['data'][$key]['charge_name'] = $emp[$value['charge_id']] ?? '';
            $data['data'][$key]['state_title'] = ItemNode::State_Type[$value['state']] ?? "";
            $priority_tmp = $tag[$value['priority_id']] ?? [];
            $data['data'][$key]['priority_title'] = $priority_tmp['title'] ?? '';
            $data['data'][$key]['priority_code'] = $priority_tmp['code'] ?? '';
            $node_tmp = $tag[$value['node_id']] ?? [];
            $data['data'][$key]['node_title'] = $node_tmp['title'] ?? '';
            $data['data'][$key]['node_code'] = $node_tmp['code'] ?? '';
        }

        return $data;
    }
}