public function fetchLocked(Acad_Model_Course_Subject $subject) { $sql = 'SELECT `test_info`.`test_info_id`, `test_info`.`degree_id`, `test_info`.`semester_id`, `test_info`.`test_id`, `test_type`.`test_type_id`, `test_type`.`test_type_name` FROM `test_info` INNER JOIN `test_type` ON (`test_info`.`test_type_id` = `test_type`.`test_type_id`) WHERE (`test_info`.`department_id` = ? AND `test_info`.`subject_code` = ? ) AND `test_info`.`is_locked` = 1'; $data = array($subject->getDepartment(), $subject->getSubject_code()); $result = Zend_Db_Table::getDefaultAdapter()->query($sql, $data)->fetchAll(); return $result; }