예제 #1
0
 /**
  * 根据学校id归类获取信息
  *
  * @param int $school_id
  *
  * @return mixed
  * @author Hunter.<*****@*****.**>
  */
 public function getStatisticsForSchoolAndGrade($school_id = 0)
 {
     $page = new Page();
     $page_table = $page->getSource();
     $classes = new Classes();
     $classes_table = $classes->getSource();
     $eva_task_log = new EvaTaskLog();
     $eva_task_log_table = $eva_task_log->getSource();
     $sql_query = "select c.grade_id,count(DISTINCT p.id) as countP, 'reading' as type from {$page_table} as p\nleft join (\nSELECT grade_id,GROUP_CONCAT(id) as id_concat FROM {$classes_table}\nwhere school_id=:school_id\ngroup by grade_id\n) c on FIND_IN_SET(p.classes_id,c.id_concat)\nwhere is_finished=0\ngroup by c.grade_id\n\nunion all\n\nselect c.grade_id,count(DISTINCT p.id) as countP, 'reading_finished' as type from {$page_table} as p\nleft join (\nSELECT grade_id,GROUP_CONCAT(id) as id_concat FROM {$classes_table}\nwhere school_id=:school_id\ngroup by grade_id\n) c on FIND_IN_SET(p.classes_id,c.id_concat)\nwhere is_finished=1\ngroup by c.grade_id\n\nunion all\n\nselect c.grade_id,count(DISTINCT p.id) as countP, 'eva_task' as type from {$eva_task_log_table} as p\nleft join (\nSELECT grade_id,GROUP_CONCAT(id) as id_concat FROM {$classes_table}\nwhere school_id=:school_id\ngroup by grade_id\n) c on FIND_IN_SET(p.classes_id,c.id_concat)\ngroup by c.grade_id";
     try {
         if (DEBUG) {
             $logger = Di::getDefault()->getLogger();
             $logger->log($sql_query, \Phalcon\Logger::DEBUG);
         }
         $stmt = $this->di->getDefault()->get('db')->prepare($sql_query);
         $stmt->bindParam(':school_id', $school_id, \PDO::PARAM_INT);
         $stmt->execute();
         $result = $stmt->fetchAll(\PDO::FETCH_ASSOC);
         return $result;
     } catch (\PDOException $e) {
         if (DEBUG) {
             die($e->getMessage());
         } else {
             $this->di->get('logger_error')->log('PDOException: ' . $e->getMessage(), \Phalcon\Logger::ERROR);
             $this->di->get('dispatcher')->forward(['module' => 'home', 'controller' => 'error', 'action' => 'show_sql_error']);
         }
     }
 }
예제 #2
0
 /**
  * 根据班级id获取具体班级名称(一个)
  *
  * @return string
  * @author Hunter.<*****@*****.**>
  */
 public function getClassesName()
 {
     $classesId = $this->getClassesId();
     //根据当前用户的班级值获取对应的班级信息(包括年级)
     $classesInfo = Classes::findFirst($classesId);
     return Config('CONFIG_GRADE')[$classesInfo->getGradeId()] . $classesInfo->getName();
 }
예제 #3
0
 /**
  * 根据班级id/ids获取具体班级名称(多个)
  *
  * @return array
  * @author Hunter.<*****@*****.**>
  */
 public function getClassesName()
 {
     $classesId = $this->getClassesId();
     //根据当前用户的班级值获取对应的班级信息(包括年级)
     $classesInfo = Classes::find(['id IN ({id:array})', 'bind' => ['id' => $classesId]]);
     $className = [];
     foreach ($classesInfo as $k => $classes) {
         $className[$classes->getId()] = Config('CONFIG_GRADE')[$classes->getGradeId()] . $classes->getName();
     }
     return $className;
 }