isAjax()){ //分页参数 $length = input('rows',10,'intval'); //每页条数 $page = input('page',1,'intval'); //第几页 $start = ($page - 1) * $length; //分页开始位置 //排序 $sortRow = input('sidx','id','trim'); //排序列 $sort = input('sord','desc','trim'); //排序方式 $order = $sortRow.' '.$sort; $title = input('title','','trim'); if($title){ $map[] = ['title','like','%'.$title.'%']; } $map[] = ['del','=',0]; $map[] = ['org_id','=',cur_org_id()]; $map= empty($map) ? true: $map; //数据查询 $lists = db('attendance_group')->limit($start,$length)->where($map)->order(['id'=>'desc'])->select(); //数据返回 $totalCount = db('attendance_group')->where($map)->count(); $totalPage = ceil($totalCount/$length); $result['page'] = $page; $result['total'] = $totalPage; $result['records'] = $totalCount; $result['rows'] = $lists; return json($result); }else{ return $this->fetch(); } } /** * 新增/编辑 */ public function add($id=0){ if(request()->isPost()){ $res = model('AttendanceGroup')->updates(); if($res){ $this->success('操作成功',url('index')); }else{ $this->error(model('AttendanceGroup')->getError()); } }else{ $title = '新增'; if($id){ $title = '编辑'; } $info = model('AttendanceGroup')->info($id); $this->assign('info',$info); $users = model('WorkTypeMode')->getWorkerUserApp($this->orgId,-1); $classes = db('attendance_class')->where('org_id',$this->orgId)->where('del',0)->select(); $addrs= db('attendance_addr')->where('org_id',$this->orgId)->where('del',0)->where('enable',1)->select(); $this->assign('users',$users); $this->assign('classes',$classes); $this->assign('addrs',$addrs); $this->assign('title',$title); return $this->fetch(); } } /** * 删除记录 * @param int $id */ public function del($id=0){ if(!$id){ $this->error('参数错误'); } $res = db('attendance_group')->where('id',$id)->setField('del',1); if($res){ $this->success('删除成功'); }else{ $this->error('删除失败'); } } /* * 排班*/ public function scheduling(){ $id = input('id',0); $this->assign('id',$id); return $this->fetch(); } public function pbjson(){ $id = input('id'); $start = input('start'); $end = input('end'); $data = array(); if(!$start||!$end||$start>$end){ header('Content-Type:application/json; charset=utf-8'); exit(json_encode($data)); } $start = date('Y-m-d',strtotime($start)); $end = date('Y-m-d',strtotime($end)); $list = db('attendance_group_class') ->alias('gc') ->join('attendance_class c','c.id = gc.class_id') ->where('gc.day','>=',$start) ->where('gc.day','<=',$end) ->where('gc.group_id',$id) ->field('c.name,gc.*') ->select(); foreach ($list as $k=>$v){ $arr = array( 'taskid' => $v['id'], 'title' => $v['name'], 'status' => 1, 'start' => $v['day'].' 00:00:00', 'end' => $v['day'].' 23:59:59' ); $arr['color'] = '#478fca'; $data[] = $arr; } header('Content-Type:application/json; charset=utf-8'); exit(json_encode($data)); } public function addGroupClass(){ $gid = input('id'); if(request()->isPost()){ $res = model('AttendanceGroup')->groupUpdates(); if($res){ $this->success('操作成功',url('addGroupClass')); }else{ $this->error(model('AttendanceGroup')->getError()); } }else{ $start = input('start'); $start = date('Y-m-d',strtotime($start)); $info = model('AttendanceGroup')->showOne($gid); $content = json_decode($info['content'],true); $circle = $content['circle']; $classids = $info['class_id']?explode(',',$info['class_id']):[]; $class = []; if($classids){ $class = db('attendance_class')->whereIn('id',$classids)->select(); } $this->assign('gid',$gid); $this->assign('classList',$class); $this->assign('weekList',$circle); $this->assign('day',$start); return $this->fetch(); } } }