/**
* @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;
}
