<?php
/**
+-----------------------------------------------------------------------------------------------
* GouGuOPEN [ 左手研发，右手开源，未来可期！]
+-----------------------------------------------------------------------------------------------
* @Copyright (c) 2021~2024 http://www.gouguoa.com All rights reserved.
+-----------------------------------------------------------------------------------------------
* @Licensed 勾股OA，开源且可免费使用，但并不是自由软件，未经授权许可不能去除勾股OA的相关版权信息
+-----------------------------------------------------------------------------------------------
* @Author 勾股工作室 <hdm58@qq.com>
+-----------------------------------------------------------------------------------------------
*/
declare(strict_types=1);
namespace app\user\controller;

use app\api\BaseController;
use think\facade\Db;

class Api extends BaseController
{
    //删除档案记录相关
    public function del_profiles()
    {
        $id = get_params("id");
        if (Db::name('AdminProfiles')->where('id', $id)->update(['delete_time' => time()]) !== false) {
            return to_assign(0, "删除成功");
        } else {
            return to_assign(1, "删除失败");
        }
    }

    //删除班次考勤时间
    public function del_work_plan_time()
    {
        $id = get_params("id");
        if (Db::name('AttendanceWorkTime')->where('id', $id)->update(['is_del' => 1]) !== false) {
            return to_assign(0, "删除成功");
        } else {
            return to_assign(1, "删除失败");
        }
    }

    //获取班次列表
    public function get_work_plan()
    {
        $list = Db::name('AttendanceWorkPlan')->where('is_del', '=', 0)->order('create_time asc')->select()->each(function ($item, $key) {
            $item['create_time'] = date('Y-m-d H:i:s', $item['create_time']);
            $item['update_time'] = $item['update_time'] > 0 ? date('Y-m-d H:i:s', $item['update_time']) : "";
            return $item;
        })->toArray();
        foreach ($list as &$val) {
            $mappingTimes = Db::name('AttendanceWorkPlanWorkTimeLink')->where(['work_plan_id' => $val['id']])->column('work_time_id');
            $times = Db::name('AttendanceWorkTime')->where('id', 'in', $mappingTimes)->where('is_del', '=', 0)->select()->toArray();
            $val['times'] = $times;
        }
        $res['data'] = $list;
        return table_assign(0, '', $res);
    }
}