public function indexAction()
{
/** 验证是否登录 **/
$this->verify(__METHOD__);
$classid = $this->getRequest()->getParam('ClassID');
$data = array();
if (empty($classid)) {
$data['pagename'] = '课程添加';
$data['info'] = array();
} else {
$data['pagename'] = '课程编辑';
$data['info'] = Admin_ClassesModel::instance()->fetchRow(array('condition' => 'classid = ?', 'bind' => array($classid)));
}
$data['grade'] = RThink_Config::get('app.grade');
$subject = Admin_SubjectModel::instance()->fetchAll(array());
$subjectList = array();
foreach ($subject as $key => $value) {
if (!isset($subjectList[$value['Grade']])) {
$subjectList[$value['Grade']] = array();
}
array_push($subjectList[$value['Grade']], $value);
}
$data['subjectList'] = $subjectList;
$this->setInvokeArg('layout', 'admin1_layout');
$this->render($data);
}
public function indexAction()
{
//检查权限
$this->verify(__METHOD__);
$show['pagename'] = '科目列表';
$grade = $this->getRequest()->getQuery('grade', '');
$perpage = 20;
$page = intval($this->getRequest()->getQuery('page'));
$page = $page ? $page : 1;
$data = $count_opt = array();
$option = array('condition' => '', 'order' => 'Grade asc', 'limit' => array('offset' => ($page - 1) * $perpage, 'count' => $perpage));
if (!empty($grade)) {
$option['condition'] .= "grade = ?";
$option['bind'] = array($grade);
$count_opt = array('condition' => "grade = ?", 'bind' => array($grade));
}
$data['subjectList'] = Admin_SubjectModel::instance()->fetchAll($option);
$data['count'] = Admin_SubjectModel::instance()->count($count_opt);
$data['grade'] = RThink_Config::get('app.grade');
$pagination = new Pagination();
$data['pagination'] = $pagination->maxnum($data['count'], $perpage)->show('page_metronic');
$data['menu'] = Widget_Admin_MenuModel::headerMenu();
$this->setInvokeArg('layout', 'admin1_layout');
$this->render($data);
}
public static function instance()
{
if (null == self::$_instance) {
self::$_instance = new self();
}
self::$_instance->selectTable(self::$_table);
return self::$_instance;
}
public function indexAction()
{
/** 验证是否登录 **/
$this->verify(__METHOD__);
$SubjectID = $this->getRequest()->getParam('SubjectID');
Admin_SubjectModel::instance()->delete(array('SubjectID' => $SubjectID));
$this->sendMsg(1, '删除成功');
}
public function indexAction()
{
//检查权限
$admin = $this->verify(__METHOD__);
$show['pagename'] = '选择课程列表';
$MemberID = $this->getRequest()->getParam('MemberID', 0);
$Grade = $this->getRequest()->getParam('Grade', 0);
$SubjectID = $this->getRequest()->getParam('SubjectID', 0);
$perpage = 20;
$page = intval($this->getRequest()->getParam('page'));
$page = $page ? $page : 1;
$data = $count_opt = array();
//个人信息
$member_option = array('condition' => 'MemberID = ?', 'bind' => array($MemberID));
$MemberInfo = Admin_MemberModel::instance()->fetchAll($member_option);
$data['MemberInfo'] = $MemberInfo[0];
$Grade = empty($Grade) ? $MemberInfo[0]['Grade'] : $Grade;
//所选课程列表
$option = array('order' => 'ChosenID desc,B.ClassNo asc', 'limit' => array('offset' => ($page - 1) * $perpage, 'count' => $perpage));
if (!empty($SubjectID)) {
$option['condition'][] = 'B.SubjectID = ?';
$option['bind'][] = $SubjectID;
}
if (!empty($Grade)) {
$option['condition'][] = 'B.Grade = ?';
$option['bind'][] = $Grade;
}
if (!empty($MemberID)) {
$option['condition'][] = 'A.MemberID = ?';
$option['bind'][] = $MemberID;
}
$option['condition'] = implode(' and ', $option['condition']);
$count_opt['condition'] = $option['condition'];
$count_opt['bind'] = $option['bind'];
$data['ChosenList'] = Admin_ChosenModel::instance()->getChosenClassList($option);
$count = Admin_ChosenModel::instance()->getChosenCount($count_opt);
$data['count'] = $count[0]['count'];
$data['grade'] = RThink_Config::get('app.grade');
$subject = Admin_SubjectModel::instance()->fetchAll(array());
$subjectList = array();
foreach ($subject as $key => $value) {
if (!isset($subjectList[$value['Grade']])) {
$subjectList[$value['Grade']] = array();
}
array_push($subjectList[$value['Grade']], $value);
}
$data['subjectList'] = $subjectList;
$pagination = new Pagination();
$data['pagination'] = $pagination->maxnum($data['count'], $perpage)->show('page_metronic');
$data['query'] = array('MemberID' => $MemberID, 'SubjectID' => $SubjectID, 'Grade' => $Grade);
$this->setInvokeArg('layout', 'admin1_layout');
$this->render($data);
}
public function indexAction()
{
$this->verify(__METHOD__);
$Grade = $this->getRequest()->getPost('Grade');
$SubjectType = $this->getRequest()->getPost('SubjectType');
$subject = RThink_Config::get('app.subject');
$Title = $subject[$SubjectType];
if (empty($Title)) {
$this->sendMsg(-1, '科目添加异常');
}
$data = array('Grade' => $Grade, 'Title' => $Title, 'SubjectType' => $SubjectType, 'CreateTime' => date('Y-m-d H:i:s'));
/* 写入账号 */
Admin_SubjectModel::instance()->add($data);
$this->sendMsg(1, "操作成功");
}
public function indexAction()
{
/** 验证是否登录 **/
$this->verify(__METHOD__);
$Grade = $this->getRequest()->getParam('Grade');
$SubjectID = $this->getRequest()->getParam('SubjectID');
$Chapter = $this->getRequest()->getParam('Chapter');
$ClassType = $this->getRequest()->getParam('ClassType');
if (empty($Grade) || empty($SubjectID) || empty($Chapter)) {
$this->sendMsg(1, '请将课程信息填写完整');
}
$option = array('condition' => 'Grade = ? and SubjectID = ? and Chapter = ? and ClassType = ? ', 'bind' => array($Grade, $SubjectID, $Chapter, $ClassType), 'order' => 'No desc', 'limit' => '');
$maxNo = Admin_ClassesModel::instance()->getMaxNo($option);
$No = $maxNo ? $maxNo + 1 : 1;
$option1 = array('condition' => 'SubjectID = ? ', 'bind' => array($SubjectID), 'limit' => '');
$SubjectType = Admin_SubjectModel::instance()->getSubjectType($option1);
$data['ClassNo'] = sprintf("%d%02d%02d%02d", $SubjectType, $Grade, $Chapter, $No);
$data['No'] = $No;
$this->sendMsg(0, '成功', $data);
}
public function indexAction()
{
//检查权限
$this->verify(__METHOD__);
$show['pagename'] = '章节列表';
$grade = $this->getRequest()->getQuery('Grade', '');
$subjectID = $this->getRequest()->getQuery('SubjectID', '');
$perpage = 20;
$page = intval($this->getRequest()->getQuery('page'));
$page = $page ? $page : 1;
$data = $count_opt = array();
$option = array('condition' => '', 'order' => 'Grade asc', 'limit' => array('offset' => ($page - 1) * $perpage, 'count' => $perpage));
$conditionArr = $bindArr = array();
if (!empty($grade)) {
$conditionArr[] = "Grade = ?";
$bindArr[] = $grade;
}
if (!empty($subjectID)) {
$conditionArr[] = "SubjectID = ?";
$bindArr[] = $subjectID;
}
$option['condition'] = $count_opt['condition'] = implode(' and ', $conditionArr);
$option['bind'] = $count_opt['bind'] = $bindArr;
$data['ChapterList'] = Admin_ChapterModel::instance()->fetchAll($option);
$subject = Admin_SubjectModel::instance()->fetchAll(array());
$subjectList = array();
foreach ($subject as $key => $value) {
if (!isset($subjectList[$value['Grade']])) {
$subjectList[$value['Grade']] = array();
}
array_push($subjectList[$value['Grade']], $value);
}
$data['subjectList'] = $subjectList;
$data['count'] = Admin_ChapterModel::instance()->count($count_opt);
$data['grade'] = RThink_Config::get('app.grade');
$pagination = new Pagination();
$data['pagination'] = $pagination->maxnum($data['count'], $perpage)->show('page_metronic');
$data['menu'] = Widget_Admin_MenuModel::headerMenu();
$this->setInvokeArg('layout', 'admin1_layout');
$this->render($data);
}
public function indexAction()
{
/** 验证是否登录 **/
$this->verify(__METHOD__);
//@todo $this->verify(__METHOD__);
// $id = $this->getRequest()->getParam('id');
$data = array();
$data['grade'] = RThink_Config::get('app.grade');
$data['subject'] = RThink_Config::get('app.subject');
$data['pagename'] = '菜单添加';
$subject = Admin_SubjectModel::instance()->fetchAll(array());
$subjectList = array();
foreach ($subject as $key => $value) {
if (!isset($subjectList[$value['Grade']])) {
$subjectList[$value['Grade']] = array();
}
array_push($subjectList[$value['Grade']], $value);
}
$data['subjectList'] = $subjectList;
$this->setInvokeArg('layout', 'admin1_layout');
$this->render($data);
}
public function indexAction()
{
//检查权限
$admin = $this->verify(__METHOD__);
$show['pagename'] = '推荐课程列表';
$MemberID = $this->getRequest()->getQuery('MemberID', 0);
$SubjectID = $this->getRequest()->getQuery('SubjectID');
$perpage = 20;
$page = intval($this->getRequest()->getQuery('page'));
$page = $page ? $page : 1;
$data = $count_opt = array();
$option = array('condition' => 'A.MemberID = ?', 'bind' => array($MemberID), 'order' => 'RecommendID desc', 'limit' => array('offset' => ($page - 1) * $perpage, 'count' => $perpage));
if (!empty($SubjectID)) {
$option['condition'] .= ' and B.SubjectID = ?';
$option['bind'][] = $SubjectID;
}
$count_opt['condition'] = $option['condition'];
$count_opt['bind'] = $option['bind'];
$data['RecommendList'] = Admin_RecommendModel::instance()->getRecommendClassList($option);
$data['count'] = Admin_RecommendModel::instance()->getRecommendCount($count_opt);
$data['grade'] = RThink_Config::get('app.grade');
$member_option = array('condition' => 'MemberID = ?', 'bind' => array($MemberID));
$MemberInfo = Admin_MemberModel::instance()->fetchAll($member_option);
$data['MemberInfo'] = $MemberInfo[0];
$TeacherList = Admin_AdminModel::instance()->fetchAll(array());
$TeacherList_tmp = array();
foreach ($TeacherList as $key => $value) {
$TeacherList_tmp[$value['id']] = $value;
}
$data['TeacherList'] = $TeacherList_tmp;
$grade = $MemberInfo[0]['Grade'];
$member_option = array('condition' => 'Grade = ?', 'bind' => array($grade));
$data['SubjectList'] = Admin_SubjectModel::instance()->fetchAll($member_option);
$pagination = new Pagination();
$data['pagination'] = $pagination->maxnum($data['count'], $perpage)->show('page_metronic');
$data['query'] = array('MemberID' => $MemberID, 'SubjectID' => $SubjectID);
$this->setInvokeArg('layout', 'admin1_layout');
$this->render($data);
}
public function indexAction()
{
//检查权限
$this->verify(__METHOD__);
$show['pagename'] = '课程列表';
$grade = $this->getRequest()->getQuery('Grade');
$subject = $this->getRequest()->getQuery('SubjectID');
$chapter = $this->getRequest()->getQuery('Chapter');
$classno = $this->getRequest()->getQuery('ClassNo');
$memberID = $this->getRequest()->getQuery('MemberID');
$perpage = 20;
$page = intval($this->getRequest()->getQuery('page'));
$page = $page ? $page : 1;
$data = $count_opt = array();
$option = array('condition' => '', 'order' => 'ClassNo asc,Grade asc', 'limit' => array('offset' => ($page - 1) * $perpage, 'count' => $perpage));
$data['count'] = Admin_AdminModel::instance()->count($count_opt);
$conditionArr = $bindArr = array();
if (!empty($grade)) {
$conditionArr[] = "grade = ?";
$bindArr[] = $grade;
}
if (!empty($subject)) {
$conditionArr[] = "subjectid = ?";
$bindArr[] = $subject;
}
if (!empty($classno)) {
$conditionArr[] = "classno = ?";
$bindArr[] = $classno;
}
if (!empty($chapter)) {
$conditionArr[] = "chapter = ?";
$bindArr[] = $chapter;
}
$option['condition'] = $count_opt['condition'] = implode(' and ', $conditionArr);
$option['bind'] = $count_opt['bind'] = $bindArr;
// print_r($option);exit;
$data['classList'] = Admin_ClassesModel::instance()->fetchAll($option);
$data['count'] = Admin_ClassesModel::instance()->count($count_opt);
$data['grade'] = RThink_Config::get('app.grade');
$pagination = new Pagination();
$data['pagination'] = $pagination->maxnum($data['count'], $perpage)->show('page_metronic');
$data['menu'] = Widget_Admin_MenuModel::headerMenu();
$data['query'] = array('ClassNo' => $classno, 'Grade' => $grade, 'SubjectID' => $subject, 'Chapter' => $chapter, 'MemberID' => $memberID);
$subject = Admin_SubjectModel::instance()->fetchAll(array());
$subjectList = array();
foreach ($subject as $key => $value) {
if (!isset($subjectList[$value['Grade']])) {
$subjectList[$value['Grade']] = array();
}
array_push($subjectList[$value['Grade']], $value);
}
$data['subjectList'] = $subjectList;
$recommendClassIds = array();
if (!empty($memberID)) {
$recommend_option = array('fields' => 'ClassID', 'condition' => 'MemberID = ?', 'bind' => array($memberID), 'order' => 'ClassID desc', 'limit' => '');
$recommendClasses = Admin_RecommendModel::instance()->fetchAll($recommend_option);
foreach ($recommendClasses as $key => $value) {
$recommendClassIds[] = $value['ClassID'];
}
}
$data['recommendClassIds'] = $recommendClassIds;
$this->setInvokeArg('layout', 'admin1_layout');
$this->render($data);
}
