danci/www.hanlinyuanonline.com/Application/Admin/Controller/NotepadController.class.php

<?php
namespace Admin\Controller;
use Common\Controller\AdminController;
class NotepadController extends AdminController {
    public function __construct(){
        parent::__construct();
    }
    //自由记列表
    public function index(){
        $sort = I('sort','1');
        $courseStatus = I('course_status','');
        $keyword = I('get.keyword','');
        $condition = array('is_delete'=>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');
    }
}