/** * @usage 根据examinee_id 选择出该被试的相关试卷的答案 * @notice 一个人最多有6条记录 * @param int $examinee_id * @throws Exception * @return array */ public static function getListByExamineeId($examinee_id) { if (DBHandle::dataFormatCheck($examinee_id) != 2) { throw new Exception('input type is not available'); } return self::find(array("examinee_id = :examinee_id:", 'bind' => array('examinee_id' => intval($examinee_id)))); }
public function uploadchildrenofindexAction() { die('finished -|-_-|-'); try { $file_path = './comment/childrenOfIndexComment.xlsx'; set_time_limit(0); $childHandler = new ExcelUpload($file_path); $data = $childHandler->handleChildComment(); $dbHandle = new DBHandle(); $dbHandle->insertChildIndexComment($data); echo 'finished'; } catch (Exception $e) { echo $e->getMessage(); return false; } }
/** * 根据Paper_id 获取相应试卷的具体题目情况 * 返回值 [phalcon_mvc_model_object_array] 返回数组的项可能为空,需判断处理 * @param $paper_id; */ public static function getQuestionsByPaperId($paper_id) { $data_type = DBHandle::dataFormatCheck($paper_id); if ($data_type != 2) { throw new Exception("input type is not available"); } $question_object_array = self::find(array("paper_id = :paper_id:", 'bind' => array('paper_id' => $paper_id))); return $question_object_array; }
/** * 按照ids_array 返回响应的results_array * $ids_array 不能为空, 否则抛出 Empty Exception * 返回值 [phalcon_mvc_model_object_array] 返回数组的项可能为空,需判断处理 * @param array $ids_array */ public static function getListByIdsArray($ids_array) { $data_type = DBHandle::dataFormatCheck($ids_array); if ($data_type != 4) { throw new Exception("input type is not available!"); } $rtn_array = null; #If you bind arrays in bound parameters, keep in mind, that keys must be numbered from zero: $ids_array = array_values($ids_array); $rtn_array = self::find(array("id IN ({name:array})", 'bind' => array('name' => $ids_array))); return $rtn_array; }