workHour/app/Service/PersonSalaryService.php

<?php

namespace App\Service;

use App\Model\Employee;
use App\Model\MonthlyPsOrder;
use App\Model\MonthlyPsOrderDetails;
use Illuminate\Support\Facades\DB;

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

        try {
            DB::beginTransaction();

            $model = MonthlyPsOrder::where('id',$data['id'])->first();
//            $model->month = $data['month'] ?? 0;
//            $model->save();

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

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

        return [true, ''];
    }

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

        try {
            DB::beginTransaction();

            $model = new MonthlyPsOrder();
            $model->code = $this->generateBillNo([
                'top_depart_id' => $user['top_depart_id'],
                'type' => MonthlyPsOrder::Order_type,
                'period' => date("Ym", $data['month'])
            ]);
            $model->month = $data['month'] ?? 0;
            $model->crt_id = $user['id'];
            $model->top_depart_id = $data['top_depart_id'];
            $model->save();

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

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

        return [true, ''];
    }

    private function saveDetail($id, $time, $data){
        if(! empty($data['details'])){
            $unit = [];
            foreach ($data['details'] as $value){
                $unit[] = [
                    'main_id' => $id,
                    'employee_id' => $value['employee_id'],
                    'salary' => $value['salary'],
                    'social_insurance' => $value['social_insurance'],
                    'public_housing_fund' => $value['public_housing_fund'],
                    'crt_time' => $time,
                    'top_depart_id' => $value['top_depart_id'],
                ];
            }
            if(! empty($unit)) MonthlyPsOrderDetails::insert($unit);
        }
    }

    private function getDetail($id){
        $data = MonthlyPsOrderDetails::where('del_time',0)
            ->where('main_id', $id)
            ->select('employee_id', 'salary', 'social_insurance', 'public_housing_fund')
            ->get()->toArray();

        $id = array_column($data,'employee_id');
        $map = Employee::whereIn('id', $id)->select('title','id','number')->get()->toArray();
        $map = array_column($map,null,'id');

        foreach ($data as $key => $value){
            $tmp = $map[$value['employee_id']] ?? [];
            $merge = [];
            $merge['employee_title'] = $tmp['title'];
            $merge['employee_number'] = $tmp['number'];
            $merge['start_time'] = date("Y-m-d", $value['start_time']);
            $merge['end_time'] = date("Y-m-d", $value['end_time']);
            $data[$key] = array_merge($value, $merge);
        }

        $detail = [
            'details' => $data,
        ];

        foreach ($detail as $key => $value) {
            if (empty($value)) {
                $detail[$key] = (object)[]; // 转成 stdClass 对象
            }
        }

        return $detail;
    }

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

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

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

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

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

        return [true, ''];
    }

    public function MonthlyPsOrderDetail($data, $user){
        if($this->isEmpty($data,'id')) return [false,'请选择数据！'];
        $customer = MonthlyPsOrder::where('del_time',0)
            ->where('id',$data['id'])
            ->first();
        if(empty($customer)) return [false,'人员月度工资单不存在或已被删除'];
        $customer = $customer->toArray();
        $customer['crt_name'] = Employee::where('id',$customer['crt_id'])->value('title');
        $customer['crt_time'] = $customer['crt_time'] ? date("Y-m-d H:i:s",$customer['crt_time']): '';
        $customer['month'] = $customer['month'] ? date("Y-m",$customer['month']): '';

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

        return [true, $customer];
    }

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

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

        if(! empty($data['code'])) $model->where('code', 'LIKE', '%'.$data['code'].'%');
        if(! empty($data['id'])) $model->whereIn('id', $data['id']);
        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 MonthlyPsOrderList($data,$user){
        $model = $this->MonthlyPsOrderCommon($data, $user);
        $list = $this->limit($model,'',$data);
        $list = $this->fillData($list);

        return [true, $list];
    }

    public function MonthlyPsOrderRule(&$data, $user, $is_add = true){
        if(empty($data['month'])) return [false, '月份不能为空'];
        $data['month'] = $this->changeDateToDate($data['month']);

        $data['top_depart_id'] = $user['top_depart_id'];
        if(empty($data['details'])) return [false, '人员月度工时单明细不能为空'];
        foreach ($data['details'] as $key => $value){
            if(empty($value['employee_id'])) return [false, '人员不能为空'];
            $res = $this->checkNumber($value['salary'],2,'non-negative');
            if(! $res['valid']) return [false,'工资：' . $res['error']];
            $res = $this->checkNumber($value['social_insurance'],2,'non-negative');
            if(! $res['valid']) return [false,'社保：' . $res['error']];
            $res = $this->checkNumber($value['public_housing_fund'],2,'non-negative');
            if(! $res['valid']) return [false,'公积金：' . $res['error']];
            $data['details'][$key]['top_depart_id'] = $data['top_depart_id'];
        }
        list($status, $msg) = $this->checkArrayRepeat($data['details'],'employee_id','人员');
        if(! $status) return [false, $msg];

        if($is_add){
            $bool = MonthlyPsOrder::where('top_depart_id', $data['top_depart_id'])
                ->where('month', $data['month'])
                ->where('del_time',0)
                ->exists();
        }else{
            if(empty($data['id'])) return [false,'ID不能为空'];
            $bool = MonthlyPsOrder::where('top_depart_id', $data['top_depart_id'])
                ->where('month', $data['month'])
                ->where('id','<>',$data['id'])
                ->where('del_time',0)
                ->exists();
        }
        if($bool) return [false, date("Y-m", $data['month']) . '已存在人员月度工资单'];

        return [true, ''];
    }

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

        $emp = (new EmployeeService())->getEmployeeMap(array_unique(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]['month'] = $value['month'] ? date('Y-m',$value['month']) : '';
            $data['data'][$key]['crt_name'] = $emp[$value['crt_id']] ?? '';
        }

        return $data;
    }

    public function fillDataForExport($data, $column, &$return)
    {
        if(empty($data)) return;

        $mainIds = array_column($data, 'id');
        // 获取详情映射 [main_id => [details...]]
        $detailsMap = $this->getDetailsMap($mainIds);

        // 默认空行模板
        $defaultRow = array_fill_keys($column, '');

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

            // 提取主表信息
            $mainInfo = [
                'code'  => $main['code'],
                'month' => $main['month'] ? date('Y-m', $main['month']) : '',
            ];

            if (empty($details)) {
                // 如果没有详情，至少导出一行主表信息（可选）
                $return[] = array_merge($defaultRow, $mainInfo);
            } else {
                // 核心：遍历详情，每一行详情都合并主表信息
                foreach ($details as $sub) {
                    // 合并主表字段 + 详情字段
                    $fullRow = array_merge($mainInfo, $sub);
                    // 过滤掉不在导出列里的字段，并补充缺失列
                    $return[] = array_merge($defaultRow, array_intersect_key($fullRow, $defaultRow));
                }
            }
        }
    }

    public function getDetailsMap($main_ids)
    {
        // 获取详情
        $details = MonthlyPsOrderDetails::where('del_time', 0)
            ->whereIn('main_id', $main_ids)
            ->get();

        // 获取人员信息
        $empIds = $details->pluck('employee_id')->unique();
        $empMap = Employee::whereIn('id', $empIds)->get()->keyBy('id');

        $res = [];
        foreach ($details as $item) {
            $tmpEmp = $empMap[$item->employee_id] ?? null;

            // 组装每一行详情需要展示的字段
            $res[$item->main_id][] = [
                'employee_number' => $tmpEmp ? $tmpEmp->number : '',
                'salary'     => $item->salary,
                'social_insurance'  => $item->social_insurance,
                'public_housing_fund'    => $item->public_housing_fund,
            ];
        }
        return $res; // 返回 [main_id => [detail_row, detail_row]]
    }
}