<?php

namespace App\Http\Controllers\API\Admin;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use App\Lib\Rs;
use Illuminate\Support\Facades\DB;
use Illuminate\Validation\Rule;

class ExamItemController extends Controller
{
    /**
     * 获取大类列表（exam_item_class表中pid=0或pid为null）
     */
    public function getBigClassList(Request $request)
    {
        $name = $request->input('name', '');
        $status = $request->input('status', null);
        $page = $request->input('page', 1);
        $pageSize = $request->input('page_size', 10);

        $query = DB::table('exam_item_class')
            ->where('deleted', 0)
            ->where(function($q) {
                $q->where('pid', 0)->orWhereNull('pid');
            });

        if (!empty($name)) {
            $query->where('name', 'like', '%' . $name . '%');
        }

        if ($status !== null) {
            $query->where('status', $status);
        }

        $total = $query->count();
        $list = $query->orderBy('id', 'asc')
            ->skip(($page - 1) * $pageSize)
            ->take($pageSize)
            ->get();

        return Rs::success([
            'list' => $list,
            'total' => $total,
            'page' => $page,
            'page_size' => $pageSize,
            'total_pages' => ceil($total / $pageSize)
        ]);
    }

    /**
     * 获取子类列表（exam_item_class表中pid>0）
     */
    public function getSubClassList(Request $request)
    {
        $bigClassId = $request->input('big_class_id', '');
        $name = $request->input('name', '');
        $status = $request->input('status', null);
        $page = $request->input('page', 1);
        $pageSize = $request->input('page_size', 10);

        $query = DB::table('exam_item_class')
            ->where('deleted', 0)
            ->where('pid', '>', 0);

        if (!empty($bigClassId)) {
            $query->where('pid', $bigClassId);
        }

        if (!empty($name)) {
            $query->where('name', 'like', '%' . $name . '%');
        }

        if ($status !== null) {
            $query->where('status', $status);
        }

        $total = $query->count();
        $list = $query->orderBy('id', 'asc')
            ->skip(($page - 1) * $pageSize)
            ->take($pageSize)
            ->get();

        return Rs::success([
            'list' => $list,
            'total' => $total,
            'page' => $page,
            'page_size' => $pageSize,
            'total_pages' => ceil($total / $pageSize)
        ]);
    }

    /**
     * 获取项目列表（exam_item表）
     */
    public function getItemList(Request $request)
    {
        $classId = $request->input('class_id', '');
        $bigClassId = $request->input('big_class_id', '');
        $name = $request->input('name', '');
        $code = $request->input('code', '');
        $status = $request->input('status', null);
        $page = $request->input('page', 1);
        $pageSize = $request->input('page_size', 10);

        $query = DB::table('exam_item as ei')
            ->leftJoin('exam_item_class as sub_class', 'ei.class_id', '=', 'sub_class.id')
            ->leftJoin('exam_item_class as big_class', 'sub_class.pid', '=', 'big_class.id')
            ->where('ei.deleted', 0)
            ->select(
                'ei.*',
                'big_class.id as big_class_id',
                'big_class.name as big_class_name',
                'sub_class.name as sub_class_name'
            );

        if (!empty($classId)) {
            $query->where('ei.class_id', $classId);
        }

        if (!empty($bigClassId)) {
            $query->where('sub_class.pid', $bigClassId);
        }

        if (!empty($name)) {
            $query->where(function($q) use ($name) {
                $q->where('ei.name', 'like', '%' . $name . '%')
                  ->orWhere('ei.code', 'like', '%' . $name . '%');
            });
        }

        if (!empty($code)) {
            $query->where('ei.code', 'like', '%' . $code . '%');
        }

        if ($status !== null) {
            $query->where('ei.status', $status);
        }

        $total = $query->count();
        $list = $query->orderBy('ei.id', 'asc')
            ->skip(($page - 1) * $pageSize)
            ->take($pageSize)
            ->get();

        // 为每个项目加载资源信息
        foreach ($list as $item) {
            $resources = DB::table('exam_item_resource as eir')
                ->leftJoin('department_resource as dr', 'eir.resource_id', '=', 'dr.id')
                ->where('eir.item_id', $item->id)
                ->where('eir.deleted', 0)
                ->select('dr.id', 'dr.name')
                ->get();
            $item->resources = $resources;

            // 加载关联部位
            $bodyParts = DB::table('exam_item_body_part as eibp')
                ->join('exam_body_part as ebp', 'eibp.body_part_id', '=', 'ebp.id')
                ->where('eibp.item_id', $item->id)
                ->where('ebp.deleted', 0)
                ->select('ebp.id', 'ebp.code', 'ebp.name', 'ebp.parent_id')
                ->orderBy('ebp.sort_order', 'asc')
                ->get();
            $item->body_parts = $bodyParts;
        }

        return Rs::success([
            'list' => $list,
            'total' => $total,
            'page' => $page,
            'page_size' => $pageSize,
            'total_pages' => ceil($total / $pageSize)
        ]);
    }

    /**
     * 保存大类
     */
    public function saveBigClass(Request $request)
    {
        $data = $request->validate([
            'id' => 'required|integer',
            'code' => 'sometimes|string|max:50',
            'name' => 'required|string|max:255',
            'status' => 'required|integer|in:0,1',
        ]);

        $conditions = ['id' => $data['id']];
        $values = [
            'code' => $data['code'] ?? '',
            'name' => $data['name'],
            'status' => $data['status'],
            'pid' => 0,
        ];

        $updated = DB::table('exam_item_class')->updateOrInsert($conditions, $values);

        if ($updated) {
            return Rs::success();
        }

        return Rs::error('操作失败');
    }

    /**
     * 保存子类
     */
    public function saveSubClass(Request $request)
    {
        $data = $request->validate([
            'id' => 'required|integer',
            'code' => 'sometimes|string|max:50',
            'name' => 'required|string|max:255',
            'pid' => 'required|integer',
            'status' => 'required|integer|in:0,1',
        ]);

        $conditions = ['id' => $data['id']];
        $values = [
            'code' => $data['code'] ?? '',
            'name' => $data['name'],
            'pid' => $data['pid'],
            'status' => $data['status'],
        ];

        $updated = DB::table('exam_item_class')->updateOrInsert($conditions, $values);

        if ($updated) {
            return Rs::success();
        }

        return Rs::error('操作失败');
    }

    /**
     * 保存项目
     */
    public function saveItem(Request $request)
    {
        $data = $request->validate([
            'id' => 'required|integer',
            'big_class_id' => 'sometimes|integer',
            'class_id' => 'required|integer',
            'code' => 'sometimes|string|max:50',
            'name' => 'required|string|max:100',
            'desc' => 'sometimes|string|max:255',
            'need_appointment' => 'sometimes|integer|in:0,1',
            'exam_part_code' => 'sometimes|string|max:50',
            'fasting_status' => 'sometimes|integer|in:0,1',
            'check_tips' => 'sometimes|string',
            'check_time' => 'sometimes|integer',
            'use_seats' => 'sometimes|integer',
            'enable_channel_mask' => 'sometimes|integer',
            'status' => 'required|integer|in:0,1',
        ]);

        $conditions = ['id' => $data['id']];
        $values = [
            'class_id' => $data['class_id'],
            'code' => $data['code'] ?? '',
            'name' => $data['name'],
            'desc' => $data['desc'] ?? '',
            'need_appointment' => $data['need_appointment'] ?? 1,
            'exam_part_code' => $data['exam_part_code'] ?? '',
            'fasting_status' => $data['fasting_status'] ?? 0,
            'check_tips' => $data['check_tips'] ?? '',
            'check_time' => $data['check_time'] ?? null,
            'use_seats' => $data['use_seats'] ?? 1,
            'enable_channel_mask' => $data['enable_channel_mask'] ?? 0,
            'status' => $data['status'],
        ];

        $updated = DB::table('exam_item')->updateOrInsert($conditions, $values);

        if ($updated) {
            return Rs::success();
        }

        return Rs::error('操作失败');
    }

    /**
     * 删除大类
     */
    public function deleteBigClass(Request $request)
    {
        $data = $request->validate([
            'id' => 'required|integer',
        ]);

        // 检查是否有子类
        $hasSubClass = DB::table('exam_item_class')
            ->where('pid', $data['id'])
            ->where('deleted', 0)
            ->exists();

        if ($hasSubClass) {
            return Rs::error('该大类下存在子类，无法删除');
        }

        $deleted = DB::table('exam_item_class')->where('id', $data['id'])->update(['deleted' => 1]);

        if ($deleted) {
            return Rs::success();
        }

        return Rs::error('删除失败');
    }

    /**
     * 删除子类
     */
    public function deleteSubClass(Request $request)
    {
        $data = $request->validate([
            'id' => 'required|integer',
        ]);

        // 检查是否有项目
        $hasItem = DB::table('exam_item')
            ->where('class_id', $data['id'])
            ->where('deleted', 0)
            ->exists();

        if ($hasItem) {
            return Rs::error('该子类下存在项目，无法删除');
        }

        $deleted = DB::table('exam_item_class')->where('id', $data['id'])->update(['deleted' => 1]);

        if ($deleted) {
            return Rs::success();
        }

        return Rs::error('删除失败');
    }

    /**
     * 删除项目
     */
    public function deleteItem(Request $request)
    {
        $data = $request->validate([
            'id' => 'required|integer',
        ]);

        $deleted = DB::table('exam_item')->where('id', $data['id'])->update(['deleted' => 1]);

        if ($deleted) {
            return Rs::success();
        }

        return Rs::error('删除失败');
    }

    /**
     * 获取所有大类（用于下拉选择）
     */
    public function getAllBigClasses()
    {
        $list = DB::table('exam_item_class')
            ->where('deleted', 0)
            ->where(function($q) {
                $q->where('pid', 0)->orWhereNull('pid');
            })
            ->where('status', 1)
            ->orderBy('id', 'asc')
            ->get();

        return Rs::success($list);
    }

    /**
     * 获取渠道列表（用于多选）
     */
    public function getChannelList()
    {
        $list = DB::table('channel')
            ->where('status', 1)
            ->orderBy('id', 'asc')
            ->get();

        return Rs::success($list);
    }

    /**
     * 获取分组列表
     */
    public function getGroupList(Request $request)
    {
        $name = $request->input('name', '');
        $code = $request->input('code', '');
        $page = $request->input('page', 1);
        $pageSize = $request->input('page_size', 10);

        $query = DB::table('exam_group as eg')
            ->leftJoin('exam_group_item as egi', 'eg.id', '=', 'egi.group_id')
            ->select(
                'eg.*',
                DB::raw('COUNT(DISTINCT egi.item_id) as item_count')
            )
            ->groupBy('eg.id');

        if (!empty($name)) {
            $query->where('eg.name', 'like', '%' . $name . '%');
        }

        if (!empty($code)) {
            $query->where('eg.code', 'like', '%' . $code . '%');
        }

        $total = $query->get()->count();
        $list = $query->orderBy('eg.id', 'desc')
            ->skip(($page - 1) * $pageSize)
            ->take($pageSize)
            ->get();

        return Rs::success([
            'list' => $list,
            'total' => $total,
            'page' => $page,
            'page_size' => $pageSize,
            'total_pages' => ceil($total / $pageSize)
        ]);
    }

    /**
     * 保存分组
     */
    public function saveGroup(Request $request)
    {
        $data = $request->validate([
            'id' => 'required|integer',
            'name' => 'required|string|max:50',
            'code' => 'sometimes|string|max:50',
        ]);

        $conditions = ['id' => $data['id']];
        $values = [
            'name' => $data['name'],
            'code' => $data['code'] ?? '',
        ];

        DB::table('exam_group')->updateOrInsert($conditions, $values);

        return Rs::success();
    }

    /**
     * 删除分组
     */
    public function deleteGroup(Request $request)
    {
        $data = $request->validate([
            'id' => 'required|integer',
        ]);

        $deleted = DB::table('exam_group')->where('id', $data['id'])->delete();

        if ($deleted) {
            return Rs::success();
        }

        return Rs::error('删除失败');
    }

    /**
     * 获取分组内的项目列表
     */
    public function getGroupItemList(Request $request)
    {
        $data = $request->validate([
            'group_id' => 'required|integer',
        ]);

        $list = DB::table('exam_item as ei')
            ->join('exam_group_item as egi', 'ei.id', '=', 'egi.item_id')
            ->leftJoin('exam_item_class as sub_class', 'ei.class_id', '=', 'sub_class.id')
            ->leftJoin('exam_item_class as big_class', 'sub_class.pid', '=', 'big_class.id')
            ->where('egi.group_id', $data['group_id'])
            ->where('ei.deleted', 0)
            ->select(
                'ei.*',
                'big_class.id as big_class_id',
                'big_class.name as big_class_name',
                'sub_class.name as sub_class_name'
            )
            ->orderBy('ei.id', 'asc')
            ->get();

        return Rs::success($list);
    }

    /**
     * 添加项目到分组
     */
    public function addItemToGroup(Request $request)
    {
        $data = $request->validate([
            'group_id' => 'required|integer',
            'item_id' => 'required|integer',
        ]);

        $exists = DB::table('exam_group_item')
            ->where('group_id', $data['group_id'])
            ->where('item_id', $data['item_id'])
            ->exists();

        if ($exists) {
            return Rs::error('该项目已存在于分组中');
        }

        DB::table('exam_group_item')->insert([
            'group_id' => $data['group_id'],
            'item_id' => $data['item_id'],
            'created_at' => now(),
            'updated_at' => now(),
        ]);

        return Rs::success();
    }

    /**
     * 从分组移除项目
     */
    public function removeItemFromGroup(Request $request)
    {
        $data = $request->validate([
            'group_id' => 'required|integer',
            'item_id' => 'required|integer',
        ]);

        $deleted = DB::table('exam_group_item')
            ->where('group_id', $data['group_id'])
            ->where('item_id', $data['item_id'])
            ->delete();

        if ($deleted) {
            return Rs::success();
        }

        return Rs::error('移除失败');
    }

    /**
     * 获取项目的资源配置列表
     */
    public function getItemResourceList(Request $request)
    {
        $data = $request->validate([
            'item_id' => 'required|integer',
        ]);

        $list = DB::table('exam_item_resource as eir')
            ->join('department_resource as dr', 'eir.resource_id', '=', 'dr.id')
            ->leftJoin('department as d', 'dr.department_id', '=', 'd.id')
            ->where('eir.item_id', $data['item_id'])
            ->where('eir.deleted', 0)
            ->select(
                'dr.id',
                'dr.name',
                'dr.code',
                'dr.department_id',
                'd.name as department_name',
                'dr.status'
            )
            ->orderBy('eir.id', 'asc')
            ->get();

        return Rs::success([
            'list' => $list
        ]);
    }

    /**
     * 添加资源到项目
     */
    public function addItemResources(Request $request)
    {
        $data = $request->validate([
            'item_id' => 'required|integer',
            'resource_ids' => 'required|array',
            'resource_ids.*' => 'integer',
        ]);

        $item_id = $data['item_id'];
        $resource_ids = $data['resource_ids'];

        $insertData = [];
        foreach ($resource_ids as $resource_id) {
            $exists = DB::table('exam_item_resource')
                ->where('item_id', $item_id)
                ->where('resource_id', $resource_id)
                ->where('deleted', 0)
                ->exists();

            if (!$exists) {
                $insertData[] = [
                    'item_id' => $item_id,
                    'resource_id' => $resource_id,
                    'deleted' => 0,
                    'created_at' => now(),
                    'updated_at' => now()
                ];
            }
        }

        if (!empty($insertData)) {
            DB::table('exam_item_resource')->insert($insertData);
        }

        return Rs::success();
    }

    /**
     * 从项目移除资源
     */
    public function removeItemResource(Request $request)
    {
        $data = $request->validate([
            'item_id' => 'required|integer',
            'resource_id' => 'required|integer',
        ]);

        $deleted = DB::table('exam_item_resource')
            ->where('item_id', $data['item_id'])
            ->where('resource_id', $data['resource_id'])
            ->update(['deleted' => 1]);

        if ($deleted) {
            return Rs::success();
        }

        return Rs::error('移除失败');
    }

    /**
     * 获取检查组列表
     */
    public function getExamGroupList(Request $request)
    {
        $page = $request->input('page', 1);
        $pageSize = $request->input('page_size', 10);
        $name = $request->input('name', '');

        $query = DB::table('exam_group');

        if (!empty($name)) {
            $query->where('name', 'like', '%' . $name . '%');
        }

        $total = $query->count();
        $list = $query->orderBy('id', 'asc')
            ->skip(($page - 1) * $pageSize)
            ->take($pageSize)
            ->get();

        return Rs::success([
            'list' => $list,
            'total' => $total,
            'page' => $page,
            'page_size' => $pageSize,
            'total_pages' => ceil($total / $pageSize)
        ]);
    }

    /**
     * 获取项目关联的部位列表
     */
    public function getItemBodyParts(Request $request)
    {
        $data = $request->validate([
            'item_id' => 'required|integer',
        ]);

        $list = DB::table('exam_item_body_part as eibp')
            ->join('exam_body_part as ebp', 'eibp.body_part_id', '=', 'ebp.id')
            ->where('eibp.item_id', $data['item_id'])
            ->where('ebp.deleted', 0)
            ->select('ebp.id', 'ebp.code', 'ebp.name', 'ebp.parent_id')
            ->orderBy('ebp.sort_order', 'asc')
            ->get();

        return Rs::success($list);
    }

    /**
     * 保存项目关联的部位（全量覆盖）
     */
    public function saveItemBodyParts(Request $request)
    {
        $data = $request->validate([
            'item_id' => 'required|integer',
            'body_part_ids' => 'required|array',
            'body_part_ids.*' => 'integer',
        ]);

        $itemId = $data['item_id'];
        $bodyPartIds = $data['body_part_ids'];

        // 先删除旧关联
        DB::table('exam_item_body_part')->where('item_id', $itemId)->delete();

        // 插入新关联
        if (!empty($bodyPartIds)) {
            $insertData = [];
            foreach ($bodyPartIds as $partId) {
                $insertData[] = [
                    'item_id' => $itemId,
                    'body_part_id' => $partId,
                    'created_at' => now(),
                ];
            }
            DB::table('exam_item_body_part')->insert($insertData);
        }

        return Rs::success();
    }
}