/** * @return array */ protected function _getFields() { if ($this->_fields) { return $this->_fields; } if (!$this->_auto->config['general_cache'] || !($this->_fields = Cache::GetArrayCache('fields'))) { $this->_fields = array(); $this->_db->Select('auto_fields', array('*'), array('active' => 1)); while ($field = $this->_db->FetchArray()) { $this->_fields[$field['id']] = $field; } Cache::SetArrayCache('fields', $this->_fields); } return $this->_fields; }
/** * Constructor * * @param db $db * @param int $timer Current time in UNIX format * @param array $tables * @param string $db_table_prefix */ public function __construct(db &$db, &$timer, array $tables, $db_table_prefix = '') { if (is_object($db)) { $this->db =& $db; } parent::__construct($tables, $db_table_prefix, $timer); }
protected function DecrementCounter($mark_id, $model_id) { $this->base->Update('auto_marks', array("auto_num" => "IF(auto_num=0, 0, auto_num-1)"), array('id' => $mark_id), true); if ($model_id) { $this->base->Update('auto_models', array("auto_num" => "IF(auto_num=0, 0, auto_num-1)"), array('id' => $model_id), true); } }
/** * Module statistic * * @return array of stats */ public function Stats() { if (!($stats = Cache::GetArrayCache('stats'))) { $vac_all = $this->dbase->SelectOne('job_vacancies', array('count' => 'COUNT(*)')); $vac_on_site = $this->dbase->SelectOne('job_vacancies', array('count' => 'COUNT(*)'), array('allow_site' => 1)); $this->dbase->SetWhere('add_date', $this->dbase->timer->cur_time - 24 * 60 * 60, ">"); $vac_today = $this->dbase->SelectOne('job_vacancies', array('count' => 'COUNT(*)')); $this->dbase->SetBeginBlockWhere(); $this->dbase->SetWhere("date_exp", $this->dbase->timer->cur_time, '>'); $this->dbase->SetWhere("vac_", '', "=", 'job_vacancies', 'OR'); $this->dbase->SetEndBlockWhere(); $vac_no_moder = $this->dbase->SelectOne("job_vacancies", array("count" => "COUNT(*)"), array('allow_site' => 0)); $vac_max = $this->dbase->SelectOne('job_vacancies', array('max' => 'MAX(id)')); $res_all = $this->dbase->SelectOne('job_resumes', array('count' => 'COUNT(*)')); $res_on_site = $this->dbase->SelectOne('job_resumes', array('count' => 'COUNT(*)'), array('allow_site' => 1)); $this->dbase->SetWhere('add_date', $this->dbase->timer->cur_time - 24 * 60 * 60, ">"); $res_today = $this->dbase->SelectOne('job_resumes', array('count' => 'COUNT(*)')); $this->dbase->SetBeginBlockWhere(); $this->dbase->SetWhere("date_exp", $this->dbase->timer->cur_time, '>'); $this->dbase->SetWhere("vac_", '', "=", 'job_resumes', 'OR'); $this->dbase->SetEndBlockWhere(); $res_no_moder = $this->dbase->SelectOne("job_resumes", array("count" => "COUNT(*)"), array('allow_site' => 0)); $res_max = $this->dbase->SelectOne('job_resumes', array('max' => "MAX(id)")); $comp_all = $this->dbase->SelectOne('job_companies', array('count' => 'COUNT(*)')); $this->dbase->SetWhere('add_date', $this->dbase->timer->cur_time - 24 * 60 * 60, ">"); $comp_today = $this->dbase->SelectOne('job_companies', array('count' => 'COUNT(*)')); $stats = array('vacancy_all' => $vac_all['count'], 'vacancy_today' => $vac_today['count'], 'vacancy_on_site' => $vac_on_site['count'], 'vacancy_no_noder' => $vac_no_moder['count'], 'vacancy_max' => $vac_max['max'], 'resume_all' => $res_all['count'], 'resume_today' => $res_today['count'], 'resume_on_site' => $res_on_site['count'], 'resume_no_moder' => $res_no_moder['count'], 'resume_max' => $res_max['max'], 'company_all' => $comp_all['count'], 'company_today' => $comp_today['count']); Cache::SetArrayCache('stats', $stats); } return $stats; }
public function GetFields() { $fields = array(); $this->_db->Select('job_fields', array('ctype', 'title', 'required', 'type', 'default', 'id', 'active')); while ($row = $this->_db->FetchArray()) { $fields[$row['id']] = $row; } return $fields; }