youfeng/app/Service/TableHeadService.php

<?php

namespace App\Service;

use App\Model\TableSearchSetting;
use App\Model\TableSetting;
use Illuminate\Support\Facades\DB;

class TableHeadService extends Service
{
    public function tableheadAdd($data, $user){
        if(empty($data['table_head'])) return [false,'自定义表头不能为空'];
        if(empty($data['menu_id'])) return [false, 'menu_id不能为空'];

        $time = time();
        $insert = [];
        //表头
        foreach ($data['table_head'] as $value){
            if(empty($value['key'])) return [false, 'key不能为空'];
            if(empty($value['value'])) return [false, 'value不能为空'];
            if(empty($value['sort'])) return [false, 'sort不能为空'];
            if(! isset($value['is_show'])) return [false, 'is_show不能为空'];

            $insert[] = [
                'key' => $value['key'],
                'value' => $value['value'],
                'sort' => $value['sort'],
                'is_show' => $value['is_show'],
                'is_click_detail' => $value['is_click_detail'] ?? 0,
                'float' => $value['float'],
                'width' => $value['width'] ?? 150,
                'menu_id' => $data['menu_id'],
                'crt_time' => $time,
                'crt_id' => $user['id'],
            ];
        }

        DB::beginTransaction();
        try{
            TableSetting::where('del_time',0)
                ->where('crt_id',$user['id'])
                ->where('menu_id',$data['menu_id'])
                ->where('key', '<>', TableSetting::IS_FILTER)
                ->update(['del_time' => $time]);
            TableSetting::insert($insert);

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

        return [true,''];
    }

    public function tableheadGet($data, $user){
        if(empty($data['menu_id'])) return [false,'menu_id不能为空！'];
        $header_common = config("header.common") ?? [];
        $header_common = $header_common[$data['menu_id']] ?? [];

        $header = TableSetting::where('del_time',0)
            ->where('menu_id',$data['menu_id'])
            ->where('crt_id',$user['id'])
            ->select('key','value','sort','is_show','is_click_detail','menu_id','float','width')
            ->get()->toArray();
        $header_map = array_column($header,null,'key');
        $header_default = config("header.{$data['menu_id']}") ?? [];

        foreach ($header_default as $key => $value){
            if(isset($header_map[$value['key']])) {
                //存在保存好的设置的表头 以下信息沿用
                $tmp = $header_map[$value['key']];
                $header_default[$key]['sort'] = $tmp['sort'];
                $header_default[$key]['is_show'] = $tmp['is_show'];
                $header_default[$key]['is_click_detail'] = $tmp['is_click_detail'];
                $header_default[$key]['float'] = $tmp['float'];
                $header_default[$key]['width'] = $tmp['width'];
            }else{
                $header_default[$key]['sort'] = $key + 1;
                $header_default[$key]['is_show'] = 1;
                $header_default[$key]['float'] = 0;
                $is_click_detail = 0;
                if($value['key'] == "order_number") {
                    $is_click_detail = 1;
                }elseif ($value['key'] == "title"){
                    $is_click_detail = 1;
                }
                //默认选中
                $header_default[$key]['is_click_detail'] = $is_click_detail;
                $header_default[$key]['width'] = 150;
            }
        }

        //时间排序
        usort($header_default, function($a, $b) {
            return $a['sort'] - $b['sort'];
        });

        return [true, ['column' => $header_default, 'common' => $header_common]];
    }

    public function filterAdd($data, $user){
        if(! isset($data['is_filter'])) return [false,'是否打开筛选不能为空'];
        if(empty($data['menu_id'])) return [false, 'menu_id不能为空'];

        $time = time();
        $insert = [];

        //是否打开筛选
        $insert[] = [
            'key' => TableSetting::IS_FILTER,
            'value' => "是否打开筛选",
            'sort' => 0,
            'is_show' => 0,
            'is_click_detail' => $data['is_filter'] ?? 1,
            'float' => 0,
            'width' => 0,
            'menu_id' => $data['menu_id'],
            'crt_time' => $time,
            'crt_id' => $user['id'],
        ];

        DB::beginTransaction();
        try{
            TableSetting::where('del_time',0)
                ->where('crt_id',$user['id'])
                ->where('menu_id',$data['menu_id'])
                ->where('key', TableSetting::IS_FILTER)
                ->update(['del_time' => $time]);
            TableSetting::insert($insert);

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

        return [true,''];
    }

    public function filterGet($data, $user){
        if(empty($data['menu_id'])) return [false,'menu_id不能为空！'];

        $is_filter_model = TableSetting::where('del_time',0)
            ->where('menu_id',$data['menu_id'])
            ->where('crt_id',$user['id'])
            ->where('key', TableSetting::IS_FILTER)
            ->select('is_click_detail as is_filter')
            ->first();
        $is_filter = 1;
        if(! empty($is_filter_model)) $is_filter = $is_filter_model->is_filter;

        return [true, ['is_filter' => $is_filter]];
    }

    public function tableSearchAdd($data, $user){
        if(empty($data['table_search'])) return [false,'搜索项不能为空'];
        if(empty($data['menu_id'])) return [false, 'menu_id不能为空'];

        $time = time();
        $insert = [];
        //表头
        foreach ($data['table_search'] as $value){
            if(empty($value['key'])) return [false, 'key不能为空'];
            if(! isset($value['is_show'])) return [false, 'is_show不能为空'];

            $insert[] = [
                'key' => $value['key'],
                'is_show' => $value['is_show'],
                'menu_id' => $data['menu_id'],
                'crt_time' => $time,
                'crt_id' => $user['id'],
            ];
        }

        DB::beginTransaction();
        try{
            TableSearchSetting::where('del_time',0)
                ->where('crt_id',$user['id'])
                ->where('menu_id',$data['menu_id'])
                ->update(['del_time' => $time]);
            TableSearchSetting::insert($insert);

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

        return [true,''];
    }

    public function tableSearchGet($data, $user){
        if(empty($data['menu_id'])) return [false,'menu_id不能为空！'];

        $search = TableSearchSetting::where('del_time',0)
            ->where('menu_id',$data['menu_id'])
            ->where('crt_id',$user['id'])
            ->select('key','is_show','menu_id')
            ->get()->toArray();

        return [true, $search];
    }
}