$log->TRACE(new_projects::trovitGenerateRss('upload/trovit.xml', $projects_for_xml));
// генерация xml для joobradio
if (date('H') == 4) {
$log->TRACE(new_projects::jobradioGenerateRss('upload/jobradio.xml'));
if (users_suspicious_contacts::getResetContacts()) {
users_suspicious_contacts::resetContacts();
users_suspicious_contacts::setResetContacts();
}
}
// генерация xml для careerjet
if (date('H') == 23) {
$log->TRACE(new_projects::careerjetGenerateRss('upload/careerjet.xml'));
}
// генерация xml для adWords
if (date('H') == 3) {
$log->TRACE(new_projects::adWords('upload/adwords.csv'));
}
// сбор статистики.
$scl = new stat_collector();
$log->TRACE($scl->Run());
$log->TRACE($scl->wordsStatRun());
if (date('H') == 1) {
// разделение stat_monthly
$log->TRACE($scl->stat_monthly_split());
}
// Отсылаем email тем у кого заканчивается закрепление проекта наверху главной страницы
$log->TRACE($mail->EndTopDaysPrjSendAlerts());
if (date('H') == 7) {
$log->TRACE($mail->sendYdDayRegistry());
//$log->TRACE( $mail->SbrReqvAlerts() );
$log->TRACE($mail->SbrDeadlineAlert());
<?php
ini_set('max_execution_time', '0');
ini_set('memory_limit', '512M');
require_once '../classes/stdf.php';
require_once '../classes/projects.php';
if (empty($argv[1])) {
new_projects::adWords('upload/adwords.csv');
exit;
}
$filename = 'upload/adwords0.csv';
// syntax 2012-01-01:2012-12-31
$d = explode(':', $argv[1]);
if (count($d) == 2) {
$profs = array();
$groups = array();
$rows = $DB->rows("SELECT * FROM professions");
foreach ($rows as $row) {
$profs[$row['id']] = $row;
}
$rows = $DB->rows("SELECT * FROM prof_group");
foreach ($rows as $row) {
$groups[$row['id']] = $row;
}
$sql = "\n SELECT\n p.id, e.compname, country.country_name, city.city_name,\n date_trunc('seconds', p.create_date) c_date, p.name, p.descr, p.cost, p.currency, p.priceby,\n array_agg(pts.category_id) cats, array_agg(pts.subcategory_id) subcats\n FROM\n projects p\n INNER JOIN\n employer e ON e.uid = p.user_id AND e.is_banned = B'0'\n LEFT JOIN\n country ON country.id = p.country\n LEFT JOIN\n city ON city.id = p.city\n LEFT JOIN\n project_to_spec pts ON pts.project_id = p.id\n LEFT JOIN\n projects_blocked pb ON pb.project_id = p.id\n WHERE\n pb.project_id IS NULL AND p.create_date >= '{$d[0]} 00:00:00' AND p.create_date <= '{$d[1]} 23:59:59'\n GROUP BY\n p.id, e.compname, country.country_name, city.city_name, c_date, p.name, p.descr, p.cost, p.currency, p.priceby\n ORDER BY\n id DESC\n ";
$tmpfile = "/var/tmp/adwords.csv";
$fp = fopen($tmpfile, "w");
$res = $DB->query($sql);
$c = 0;
while ($row = pg_fetch_assoc($res)) {
$data = array();
