function processKeywords($name)
{
set_time_limit(30 * 60);
$config = config();
$job = new JobSearchPos('poschecker' . $name);
$time = $config->poschecker->start_time[$name];
$time[0] += $config->poschecker->time_diff;
if ($job->checktime($time)) {
error_log('Start processing keywords');
$job->state('started');
}
if ($job->state() == 'started') {
$job->start(['type' => $name]);
}
}
')->execute();
$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();
