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); }