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__);
$RecommendID = $this->getRequest()->getParam('RecommendID');
Admin_RecommendModel::instance()->delete(array('RecommendID' => $RecommendID));
$this->sendMsg(1, '删除成功');
}
public function indexAction()
{
/** 验证是否登录 **/
$admin = $this->verify(__METHOD__);
$classID = $this->getRequest()->getParam('ClassID');
$memberID = $this->getRequest()->getParam('MemberID');
$teacherID = $admin['id'];
$params = array('ClassID' => $classID, 'MemberID' => $memberID, 'CreateTime' => date('Y-m-d H:i:s'), 'TeacherID' => $teacherID);
Admin_RecommendModel::instance()->add($params);
$this->sendMsg(1, "操作成功");
}
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);
}
