title = '日程列表'; $act_id = input('get.act_id'); $query = $this->_query($this->table)->where('is_deleted',0)->like('title') ->where('pid',0) ->where('act_id',$act_id) ->order('sort desc,id asc')->page(false); } /** * 添加日程 * @auth true * @menu true * @throws \think\Exception * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException * @throws \think\exception\PDOException */ public function add() { $this->title = '添加日程'; $this->_form($this->table, 'form'); } /** * 编辑日程 * @auth true * @menu true * @throws \think\Exception * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException * @throws \think\exception\PDOException */ public function edit() { $this->title = '编辑日程'; $this->_form($this->table, 'form'); } /** * 表单数据处理 * @param array $vo * @throws \ReflectionException * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException */ protected function _form_filter(&$data) { if($this->request->isGet()) { $this->schedule_list = !empty($data['schedule_list']) ? json_decode($data['schedule_list'],true):[]; $pid = isset($data['pid']) ? $data['pid'] : 0; if(input('get.pid')) $pid = input('get.pid'); $this->pid = $pid; } if($this->request->isPost()) { $theme_arr= input('post.theme'); $theme_time= input('post.theme_time'); $schedule_list = []; if(!empty($theme_arr)){ foreach ($theme_arr as $k=>$t){ if($t) $schedule_list[] = ['theme'=>$t,'theme_time'=>$theme_time[$k]]; } } if($data['pid']) { $data['date_time'] =\app\common\model\ActivitySchedule::where('id',$data['pid'])->value('date_time'); } if(!empty($data)) $data['schedule_list'] = json_encode($schedule_list); } } /** * 启用 * @auth true * @menu true * @throws \think\Exception * @throws \think\exception\PDOException */ public function resume() { $this->_save($this->table, ['status' => '1']); } /** * 禁用 * @auth true * @menu true * @throws \think\Exception * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException * @throws \think\exception\PDOException */ public function forbid() { $this->_save($this->table, ['status' => '0']); } /** * 删除 * @auth true * @menu true * @throws \think\Exception * @throws \think\exception\PDOException */ public function remove() { $this->_save($this->table, ['is_deleted' => 1]); } /** * 二级日程列表 * @auth true * @menu true * @throws \think\Exception * @throws \think\exception\PDOException */ public function second(){ $this->title ='二级日程'; $pid = input('pid'); $list = $this->_query('ActivitySchedule') ->where(['is_deleted'=>0,'pid'=>$pid]) ->like('title') ->order('id desc')->page(); $this->assign('list',$list); $this->fetch(''); } }