protected function _getWhere() { $ret = parent::_getWhere(); $ret['flightId = ?'] = $this->_getParam('flightId'); $ret['mainCrew = ?'] = TRUE; return $ret; }
protected function _getWhere() { $ret = parent::_getWhere(); if ($this->_getParam('trainingId') != NULL) { $ret['trainingId = ?'] = $this->_getParam('trainingId'); } return $ret; }
protected function _getWhere() { $users = Kwf_Registry::get('userModel'); $ret = parent::_getWhere(); $ret['status = ?'] = 0; $ret['userId = ?'] = $users->getAuthedUserId(); return $ret; }
protected function _getWhere() { $users = Kwf_Registry::get('userModel'); $employeesModel = Kwf_Model_Abstract::getInstance('Employees'); $employeesSelect = $employeesModel->select()->whereEquals('userId', $users->getAuthedUserId()); $employee = $employeesModel->getRow($employeesSelect); $ret = parent::_getWhere(); $employeeId = -1; if ($employee != NULL) { $employeeId = $employee->id; } $ret['employeeId = ?'] = $employeeId; return $ret; }
protected function _getWhere() { $users = Kwf_Registry::get('userModel'); $employeesModel = Kwf_Model_Abstract::getInstance('Employees'); $employeesSelect = $employeesModel->select()->whereEquals('userId', $users->getAuthedUserId()); $employee = $employeesModel->getRow($employeesSelect); $resultsModel = Kwf_Model_Abstract::getInstance('TrainingResults'); if ($employee != NULL) { $resultsSelect = $resultsModel->select()->where(new Kwf_Model_Select_Expr_Sql("employeeId = " . $employee->id . " AND currentScore = 0 AND trainingGroupId = " . $this->_getParam('groupId'))); $result = $resultsModel->getRow($resultsSelect); } $ret = parent::_getWhere(); if ($result != NULL) { $ret['resultId = ?'] = $result->id; } return $ret; }
protected function _getWhere() { $ret = parent::_getWhere(); $ret['planId = ?'] = $this->_getParam('planId'); return $ret; }
protected function _getWhere() { $ret = parent::_getWhere(); $ret['trainingGroupId = ?'] = $this->_getParam('groupId'); return $ret; }
protected function _getWhere() { $ret = parent::_getWhere(); $ret['groupType = ?'] = 2; return $ret; }
protected function _getWhere() { $ret = parent::_getWhere(); $ret['checkDate = ?'] = date('Y-m-d'); return $ret; }
protected function _getWhere() { $ret = parent::_getWhere(); $ret['contentQuestionId = ?'] = $this->_getParam('questionId'); return $ret; }
protected function _getWhere() { $ret = parent::_getWhere(); $ret['member_id = ?'] = $this->_getParam('member_id'); return $ret; }
protected function _getWhere() { $where = parent::_getWhere(); $where['customer_id = ?'] = $this->_getParam('customer_id'); return $where; }