public static function findByPapernameAndNums($paper_name, $numbers) { $paper_id = Paper::findId($paper_name); $qlist = Question::find(array('paper_id = :pid: AND number IN ({numbers:array})', 'bind' => array('pid' => $paper_id, 'numbers' => array_values($numbers)))); if (count($qlist) == 0) { throw new Exception("Can not find any questions."); } return $qlist; }
function updateSQL($json_array, $class_name) { if ($class_name == 'index') { $this->worklist($json_array, $class_name); } else { foreach ($json_array as $key => $value) { if ($class_name == 'module') { $this->worklist($value, $class_name, 'belong_module', $key); } if ($class_name == 'factor') { $paper_id = Paper::findId($key); $this->worklist($value, $class_name, 'paper_id', $paper_id); } } } }