$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();