1,'course_flag'=>2,'course_source'=>1); $orderList = array( 1=>array('operate_dt desc','时间倒序',1), 2=>array('operate_dt asc','时间正序',2), 3=>array('course_join desc','加入量倒序',3), 4=>array('course_join asc','加入量倒序',4), ); $statusList = array('全部状态','未上架',3=>'已上架'); $orderby = $orderList[$sort][0]; if (!empty($keyword)){ $condition['course_id|course_name'] = array('LIKE','%'.$keyword.'%'); } if (!empty($courseStatus)){ $condition['course_status'] = $courseStatus; } $this->assign('sort',$sort); $this->assign('orderby',$orderby); $this->assign('keyword',$keyword); $this->assign('orderList',$orderList); $this->assign('statusList',$statusList); $this->assign('courseStatus',$courseStatus); $count = M('Course')->where($condition)->count(); //分页 $Page = new \Think\Page($count); $show = $Page->show(); $courseList = M('Course')->where($condition)->field()->order($orderby)->limit($Page->firstRow.','.$Page->listRows)->select(); $this->assign('page',$show); $this->assign('list',$courseList); $this->display(); } //编辑自由记 public function edit(){ $step = I('step',''); $courseId = I('course_id',''); if (empty($step)){ $info = array(); if (!empty($courseId)){ $info = M('Course')->where(array('course_id'=>$courseId))->find(); } $this->assign('info',$info); $this->display(); }else if($step==2){ $courseName = I('course_name',''); $courseContent = I('course_content',''); if (mb_strlen($courseName,'UTF8')<2 || mb_strlen($courseName,'UTF8')>40){ $this->error('自由记名称2到40个汉字'); } if (mb_strlen($courseContent,'UTF8')<2 || mb_strlen($courseContent,'UTF8')>10000){ $this->error('自由记名称2到10000个汉字'); } $res = M('Course')->where(array('course_name'=>$courseName,'is_delete'=>1))->field('course_id')->find(); //新增 if (empty($courseId) && $res!=NULL){ $courseName = $this->getNotepadName($courseName); } //更新 if (!empty($courseId) && $courseId!=$res['course_id']){ $courseName = $this->getNotepadName($courseName); } if (empty($courseId)){ M('Course')->add(array('course_content'=>$courseContent,'course_name'=>$courseName,'course_source'=>1,'course_flag'=>2,'operate_dt'=>time())); }else{ M('Course')->where(array('course_id'=>$courseId))->save(array('course_content'=>$courseContent,'course_name'=>$courseName)); } $this->success('自由记操作成功','/admin/notepad/index'); } } //获取课程名称相同时,新的课程名称 private function getNotepadName($courseName){ $course = M('Course')->where(array('course_name'=>$courseName,'is_delete'=>1))->field('course_id')->find(); $res = M('TitleNum')->where(array('title_name'=>$courseName,'title_source'=>2))->field('title_id,title_num')->find(); if ($res!=NULL){ $courseName = $courseName.'('.($res['title_num']+1).')'; M('TitleNum')->where(array('title_id'=>$res['title_id']))->setInc('title_num'); }else if($course!=NULL){ $courseName = $courseName.'('.($res['title_num']+1).')'; M('TitleNum')->add(array('title_name'=>$courseName,'operate_dt'=>time())); //$courseName = $courseName; } return $courseName; } public function del(){ $courseId = I('course_id',''); if (empty($courseId)){ $this->error("自由记ID错误",'/admin/notepad/index'); } //M('Course')->where(array('course_id'=>$courseId))->save(array('is_delete'=>2)); M('Course')->where(array('course_id'=>$courseId))->delete(); $this->success('自由记删除成功','/admin/notepad/index'); } public function status(){ $courseId = I('course_id',''); $courseStatus = I('course_status',''); if (empty($courseId)){ $this->error("自由记ID错误",'/admin/notepad/index'); } M('Course')->where(array('course_id'=>$courseId))->save(array('course_status'=>$courseStatus)); $this->success('自由记状态修改成功','/admin/notepad/index'); } }