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

<?php
namespace Admin\Controller;
use Common\Controller\AdminController;
class SquareController extends AdminController {
    public function __construct(){
        parent::__construct();
    }
    public function course(){
        $sort = I('sort','1');
        $courseStatus = I('course_status','');
        $keyword = I('get.keyword','');
        $condition = array('course_flag'=>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('全部状态',2=>'待审核',3=>'已上架',4=>'审核不通过');
        $orderby = $orderList[$sort][0];
        if (!empty($keyword)){
            $condition['course_id|course_name'] = array('LIKE','%'.$keyword.'%');
        }
        if (!empty($courseStatus)){
            $condition['course_status'] = $courseStatus;
        }else{
            $condition['course_status'] = array('IN','2,3,4');
        }
        $this->assign('sort',$sort);
        $this->assign('orderby',$orderby);
        $this->assign('keyword',$keyword);
        $this->assign('orderList',$orderList);
        $this->assign('statusList',$statusList);
        $this->assign('courseStatus',$courseStatus);
        $crons = $condition;
        $crons['is_delete'] = 1;
        $count = M('Course')->where($condition)->count();
        //分页
        $Page = new \Think\Page($count);
        $show = $Page->show();
        $courseList = D('Course')->getCourseList($condition,$Page->firstRow, $Page->listRows, $orderby);
        $this->assign('page',$show);
        $this->assign('list',$courseList);
        $this->display();
    }
    
    public function detailCourse(){
        $courseId = I('course_id','');
        if (empty($courseId) || $courseId<1000000){
            $this->error("课程ID错误",'/admin/square/course');
        }
        $keyword = I('get.keyword','');
        $condition = array('is_delete'=>1,'course_id'=>$courseId);
        if (!empty($keyword)){
            $condition['words_name'] = array('LIKE','%'.$keyword.'%');
        }
        $count = M('Words')->where($condition)->count();
        //分页
        $Page = new \Think\Page($count);
        $show = $Page->show();
        $wordsRes = M('Words')->where($condition)->field()->order('words_id desc')->limit($Page->firstRow.','.$Page->listRows)->select();
        $wordsList = array();
        foreach ($wordsRes as $row){
            $wordsList[] = array(
                'words_id' => $row['words_id'],
                'course_id' => $row['course_id'],
                'words_name' => $row['words_name'],
                'words_voice' => $row['words_voice'],
                'words_read' => $row['words_read'],
                'operate_dt' => $row['operate_dt'],
                'words_text' => $this->getWordsText($row),
            );
        }
        $this->assign('page',$show);
        $this->assign('list',$wordsList);
        $this->assign('keyword',$keyword);
        $this->assign('courseId',$courseId);
        $this->display('detailCourse');
    }
    
    public function show(){
        $wordsId = I('words_id','');
        $wordsKeys = array('n'=>'words_n','pron'=>'words_pron','adj'=>'words_adj','num'=>'words_num','v'=>'words_v','adv'=>'words_adv','art'=>'words_art','prep'=>'words_prep','conj'=>'words_conj','int'=>'words_int','vt'=>'words_vt','vi'=>'words_vi',);
        $info = array();
        if (!empty($wordsId)){
            $info = M('Words')->where(array('words_id'=>$wordsId))->find();
        }
        $this->assign('info',$info);
        $this->assign('wordsKeys', $wordsKeys);
        $this->display();
    }
    //修改课程状态
    public function statusCourse(){
        $courseId = I('course_id','');
        $courseStatus = I('course_status','');
        if (empty($courseId) || $courseId<1000000){
            $this->error("课程ID错误",'/admin/square/course');
        }
        M('Course')->where(array('course_id'=>$courseId))->save(array('course_status'=>$courseStatus));
        if ($courseStatus==3){
            $info = M('Course')->where(array('course_id'=>$courseId))->find();
            $noticeTitle = '上传课程审核已通过';
            $noticeContent = '亲爱的小主，你上传至单词广场的《'.$info['course_name'].'》课程已审核通过，赶紧去单词广场查看下吧。';
            M('Notice')->add(array('notice_title'=>$noticeTitle,'notice_content'=>$noticeContent,'ref_user_id'=>$info['user_id'],'user_id'=>0,'operate_dt'=>time()));
            M('User')->where(array('user_id'=>$info['user_id'],'is_delete'=>1))->setInc('sys_notice');
        }
        $this->success('课程状态修改成功','/admin/square/course');
    }
    
    //修改自由记
    public function statusNotepad(){
        $courseId = I('course_id','');
        $courseStatus = I('course_status','');
        if (empty($courseId) || $courseId<1000000){
            $this->error("自由记ID错误",'/admin/square/notepad');
        }
        M('Course')->where(array('course_id'=>$courseId))->save(array('course_status'=>$courseStatus));
        if ($courseStatus==3){
            $info = M('Course')->where(array('course_id'=>$courseId))->find();
            $noticeTitle = '上传自由记审核已通过';
            $noticeContent = '亲爱的小主，你上传至单词广场的《'.$info['course_name'].'》自由记已审核通过，赶紧去单词广场查看下吧。';
            M('Notice')->add(array('notice_title'=>$noticeTitle,'notice_content'=>$noticeContent,'ref_user_id'=>$info['user_id'],'user_id'=>0,'operate_dt'=>time()));
            M('User')->where(array('user_id'=>$info['user_id'],'is_delete'=>1))->setInc('sys_notice');
        }
        $this->success('自由记状态修改成功','/admin/square/notepad');
    }
    
    public function notepad(){
        $sort = I('sort','1');
        $courseStatus = I('course_status','');
        $keyword = I('get.keyword','');
        $condition = array('course_source'=>2,'couse_flag'=>2);
        $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('全部状态',2=>'待审核',3=>'已上架',4=>'审核不通过');
        $orderby = $orderList[$sort][0];
        if (!empty($keyword)){
            $condition['course_id|course_name'] = array('LIKE','%'.$keyword.'%');
        }
        if (!empty($courseStatus)){
            $condition['course_status'] = $courseStatus;
        }else{
            $condition['course_status'] = array('IN','2,3,4');
        }
        $this->assign('sort',$sort);
        $this->assign('orderby',$orderby);
        $this->assign('keyword',$keyword);
        $this->assign('orderList',$orderList);
        $this->assign('statusList',$statusList);
        $this->assign('courseStatus',$courseStatus);

        $crons = $condition;
        $crons['is_delete'] = 1;
        $count = M('Course')->where($crons)->count();
        //分页
        $Page = new \Think\Page($count);
        $show = $Page->show();
        $notepadList = D('Course')->getCourseList($condition,$Page->firstRow, $Page->listRows, $orderby);
        $this->assign('page',$show);
        $this->assign('list',$notepadList);
        $this->display();
    }
    
    public function detailNotepad(){
        $courseId = I('course_id','');
        $info = array();
        if (!empty($courseId)){
            $info = M('Course')->where(array('course_id'=>$courseId))->find();
        }
        $this->assign('info',$info);
        $this->assign('courseId', $courseId);
        $this->display();
    }
    
    public function unpass(){
        $step = I('step');
        $courseId = I('course_id','');
        if (empty($courseId) || $courseId<1000000){
            $this->error("ID错误",$_SERVER['HTTP_REFERER']);
        }
        $info = M('Course')->where(array('course_id'=>$courseId))->find();
        if (empty($step)){
            $refererUrl = $_SERVER['HTTP_REFERER'];
            if (empty($refererUrl)){
                $refererUrl = '/admin/square/index';
            }
            $this->assign('info',$info);
            $this->assign('courseId', $courseId);
            $this->assign('refererUrl', $refererUrl);
            $this->display();
        }else if($step==2){
            $refererUrl = I('refererUrl');
            $courseReason = I('course_reason');
            if (mb_strlen($courseReason,'UTF8')<3 || mb_strlen($courseReason,'UTF8')>50){
                $this->error('未通过原因3到50个汉字');
            }
            M('Course')->where(array('course_id'=>$courseId))->save(array('course_reason'=>$courseReason,'course_status'=>4));
            if ($info['course_flag']==1){
                $noticeTitle = '上传课程审核不通过';
                $noticeContent = '亲爱的小主，你上传至单词广场的《'.$info['course_name'].'》课程审核不通过，原因为：'.$courseReason.'。请修改后再重新上传。';
            }else{
                $noticeTitle = '上传自由记审核不通过';
                $noticeContent = '亲爱的小主，你上传至单词广场的《'.$info['course_name'].'》自由记审核不通过，原因为：'.$courseReason.'。请修改后再重新上传。';
            }
            M('Notice')->add(array('notice_title'=>$noticeTitle,'notice_content'=>$noticeContent,'ref_user_id'=>$info['user_id'],'user_id'=>0,'operate_dt'=>time()));
            M('User')->where(array('user_id'=>$info['user_id'],'is_delete'=>1))->setInc('sys_notice');
            $this->success('审核未通过成功',$refererUrl);
        }
    }
}