function projectStat() { $name = basename($_GET['name']); $fname = !empty($_GET['file']) ? basename($_GET['file']) : ''; $statDir = DATA_PATH . '/stat/' . $name; // get last month stat if ($fname == '') { $todayPrefix = date('Y-m-'); $statFile = $statDir . '/' . $name . '_' . $todayPrefix . '01.csv'; if (!file_exists($statFile) || filemtime($statFile) < time() - 60 * 60) { createCurrentMonthData(); } } else { $statFile = $statDir . '/' . $fname; } header('Content-Type: text/csv; charset=windows-1251'); header('Content-Disposition: attachment; filename=' . basename($statFile)); echo mb_convert_encoding(file_get_contents($statFile), 'windows-1251', 'utf-8'); }
$db->prepare('update results_google set posprev = pos, process = 0')->execute(); $db->prepare(' insert into monthlyresults_mail select null as id, project, pos, keyword, NOW() as checkdate from results_mail ')->execute(); $db->prepare('update results_mail set posprev = pos, process = 0')->execute(); $db->prepare(' insert into monthlyresults_yandex select null as id, project, pos, keyword, region_code, region_name, NOW() as checkdate from results_yandex ')->execute(); $db->prepare('update results_yandex set posprev = pos, process = 0')->execute(); $db->commit(); updateProjectsKeywords(); error_log('resets num = 0'); setResetsNum(0); error_log(getResetsNum()); } $config = config(); // remove states foreach ($config->poschecker->checkers as $name) { $job = new JobSearchPos('poschecker' . $name, false); $job->state('stoped'); } copyDailyDataAndReset(); createCurrentMonthData();