+----------------------------------------------------------------------------------------------- */ declare (strict_types = 1); namespace app\oa\controller; use app\api\BaseController; use app\oa\model\Schedule; use think\facade\Db; use think\facade\View; class Api extends BaseController { //获取工作日志列表 public function get_schedule() { $param = get_params(); $project_id = isset($param['project_id']) ? $param['project_id'] : 0; $task_id = isset($param['task_id']) ? $param['task_id'] : 0; if ($project_id>0) { $task_ids = Db::name('ProjectTask')->where(['delete_time' => 0, 'project_id' => $project_id])->column('id'); $where[] = ['a.tid', 'in', $task_ids]; } if ($task_id>0) { $where[] = ['a.tid', '=', $task_id]; } $where[] = ['a.delete_time', '=', 0]; $model = new Schedule(); $list = $model->datalist($param,$where); return table_assign(0, '', $list); } //调整工时 public function update_schedule() { $param = get_params(); $is_leader = isLeader($this->uid); $role_auth = isAuth($this->uid,'office_admin','conf_1'); $hour_auth = valueAuth('office_admin','conf_2'); $edit_role = false; if($hour_auth==4 && $role_auth > 0){ $edit_role = true; } if($hour_auth==3 && $is_leader > 0){ $edit_role = true; } if($hour_auth==2){ $admin_id = Db::name('Schedule')->where('id',$param['id'])->value('admin_id'); if($admin_id == $this->uid){ $edit_role = true; } } if($edit_role == false){ return to_assign(1, "您无权限编辑"); } if (isset($param['start_time_a'])) { $param['start_time'] = strtotime($param['start_time_a'] . '' . $param['start_time_b']); } if (isset($param['end_time_a'])) { $param['end_time'] = strtotime($param['end_time_a'] . '' . $param['end_time_b']); } if($param['start_time']>time()){ return to_assign(1, "开始时间不能大于当前时间"); } if ($param['end_time'] <= $param['start_time']) { return to_assign(1, "结束时间需要大于开始时间"); } $where1[] = ['delete_time', '=', 0]; $where1[] = ['id', '<>', $param['id']]; $where1[] = ['admin_id', '=', $param['admin_id']]; $where1[] = ['start_time', 'between', [$param['start_time'], $param['end_time'] - 1]]; $where2[] = ['delete_time', '=', 0]; $where2[] = ['id', '<>', $param['id']]; $where2[] = ['admin_id', '=', $param['admin_id']]; $where2[] = ['start_time', '<=', $param['start_time']]; $where2[] = ['start_time', '>=', $param['end_time']]; $where3[] = ['delete_time', '=', 0]; $where3[] = ['id', '<>', $param['id']]; $where3[] = ['admin_id', '=', $param['admin_id']]; $where3[] = ['end_time', 'between', [$param['start_time'] + 1, $param['end_time']]]; $record = Db::name('Schedule') ->where(function ($query) use ($where1) { $query->where($where1); }) ->whereOr(function ($query) use ($where2) { $query->where($where2); }) ->whereOr(function ($query) use ($where3) { $query->where($where3); }) ->count(); if ($record > 0) { return to_assign(1, "您所选的时间区间已有工作记录,请重新选时间"); } $param['labor_time'] = ($param['end_time'] - $param['start_time']) / 3600; $res = Db::name('Schedule')->strict(false)->field(true)->update($param); if ($res !== false) { return to_assign(0, "操作成功"); add_log('edit', $param['id'], $param); } else { return to_assign(1, "操作失败"); } } }