Пример #1
0
 public function getIncome()
 {
     return Income::model()->findAllBySql("select income.* from income \nleft join check_income\n   on check_income.id = income.check_id\nwhere (class_id = :cid and student_id = :sid)\nand (check_income.returned is null or check_income.returned < '2000-01-01')", array('cid' => $this->class_id, 'sid' => $this->student_id));
 }
Пример #2
0
 function getIncomes()
 {
     return Income::model()->findAllBySql("select income.*\nfrom income\nleft join check_income \n   on income.check_id = check_income.id\nwhere check_income.payee_id = :id\n  and check_income.session_id = :sid\norder by abs(check_income.check_num) asc", array('id' => $this->id, 'sid' => ClassSession::savedSessionId()));
 }
Пример #3
0
 /**
  * Returns the data model based on the primary key given in the GET variable.
  * If the data model is not found, an HTTP exception will be raised.
  */
 public function loadModel()
 {
     if ($this->_model === null) {
         if (isset($_GET['student_id']) && isset($_GET['check_id']) && isset($_GET['class_id'])) {
             // XXX this is stupid and tedious. fix.
             $this->_model = Income::model()->findbyPk(array('student_id' => $_GET['student_id'], 'check_id' => $_GET['check_id'], 'class_id' => $_GET['class_id']));
         }
         if ($this->_model === null) {
             throw new CHttpException(404, 'The requested page does not exist.');
         }
     }
     return $this->_model;
 }
Пример #4
0
 public function getIncomes()
 {
     return Income::model()->findAllBySql('select income.* 
           from income
           left join class_info
            on income.class_id = class_info.id
           where income.student_id = :stid
             and class_info.session_id = :ssid', array('ssid' => ClassSession::savedSessionId(), 'stid' => $this->id));
 }