<?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);
|
}
|
}
|