28 if (!defined(
'NOTOKENRENEWAL')) {
29 define(
'NOTOKENRENEWAL',
'1');
31 if (!defined(
'NOREQUIREMENU')) {
32 define(
'NOREQUIREMENU',
'1');
34 if (!defined(
'NOREQUIREHTML')) {
35 define(
'NOREQUIREHTML',
'1');
37 if (!defined(
'NOREQUIREAJAX')) {
38 define(
'NOREQUIREAJAX',
'1');
40 if (!defined(
'NOLOGIN')) {
41 define(
'NOLOGIN',
'1');
43 if (!defined(
'NOSESSION')) {
44 define(
'NOSESSION',
'1');
48 if (!defined(
'USESUFFIXINLOG')) {
49 define(
'USESUFFIXINLOG',
'_cron');
52 $sapi_type = php_sapi_name();
53 $script_file = basename(__FILE__);
57 if (substr($sapi_type, 0, 3) ==
'cgi') {
58 echo
"Error: You are using PHP for CGI. To execute ".$script_file.
" from command line, you must use PHP for CLI mode.\n";
62 require_once $path.
"../../htdocs/master.inc.php";
63 require_once DOL_DOCUMENT_ROOT.
"/cron/class/cronjob.class.php";
64 require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
67 if (!isset($argv[1]) || !$argv[1]) {
68 usage($path, $script_file);
73 if (!isset($argv[2]) || !$argv[2]) {
74 usage($path, $script_file);
78 $userlogin = $argv[2];
81 $version = DOL_VERSION;
84 $hookmanager->initHooks(array(
'cli'));
95 print
"***** ".$script_file.
" (".$version.
") pid=".
dol_getmypid().
" ***** userlogin=".$userlogin.
" ***** ".
dol_print_date($now,
'dayhourrfc').
" *****\n";
98 if (empty($conf->cron->enabled)) {
99 print
"Error: module Scheduled jobs (cron) not activated\n";
104 if (empty($conf->cron->enabled)) {
105 print
"Error: module Scheduled jobs (cron) not activated\n";
110 if ($key != $conf->global->CRON_KEY) {
111 print
"Error: securitykey is wrong\n";
115 if (!empty($dolibarr_main_db_readonly)) {
116 print
"Error: instance in read-only mode\n";
121 if ($userlogin ==
'firstadmin') {
122 $sql =
'SELECT login, entity from '.MAIN_DB_PREFIX.
'user WHERE admin = 1 and statut = 1 ORDER BY entity LIMIT 1';
123 $resql = $db->query($sql);
125 $obj = $db->fetch_object(
$resql);
127 $userlogin = $obj->login;
128 echo
"First admin user found is login '".$userlogin.
"', entity ".$obj->entity.
"\n";
136 $user =
new User($db);
137 $result = $user->fetch(
'', $userlogin,
'', 1);
139 echo
"User Error: ".$user->error;
140 dol_syslog(
"cron_run_jobs.php:: User Error:".$user->error, LOG_ERR);
143 if (empty($user->id)) {
144 echo
"User login: ".$userlogin.
" does not exists";
145 dol_syslog(
"User login:".$userlogin.
" does not exists", LOG_ERR);
151 $langcode = (empty($conf->global->MAIN_LANG_DEFAULT) ?
'auto' : $conf->global->MAIN_LANG_DEFAULT);
152 if (!empty($user->conf->MAIN_LANG_DEFAULT)) {
153 $langcode = $user->conf->MAIN_LANG_DEFAULT;
155 if ($langs->getDefaultLang() != $langcode) {
156 $langs->setDefaultLang($langcode);
157 $langs->tab_translate = array();
160 $langs->loadLangs(array(
'main',
'admin',
'cron',
'dict'));
164 if (isset($argv[3]) && $argv[3]) {
173 if (!is_numeric($id)) {
174 echo
"Error: Bad value for parameter job id";
175 dol_syslog(
"cron_run_jobs.php Bad value for parameter job id", LOG_WARNING);
178 $filter[
't.rowid'] = $id;
181 $result = $object->fetchAll(
'ASC,ASC,ASC',
't.priority,t.entity,t.rowid', 0, 0, 1, $filter, 0);
183 echo
"Error: ".$object->error;
184 dol_syslog(
"cron_run_jobs.php fetch Error ".$object->error, LOG_ERR);
190 $nbofjobs = count($object->lines);
191 $nbofjobslaunchedok = 0;
192 $nbofjobslaunchedko = 0;
194 if (is_array($object->lines) && (count($object->lines) > 0)) {
198 foreach ($object->lines as $line) {
199 dol_syslog(
"cron_run_jobs.php cronjobid: ".$line->id.
" priority=".$line->priority.
" entity=".$line->entity.
" label=".$line->label, LOG_DEBUG);
200 echo
"cron_run_jobs.php cronjobid: ".$line->id.
" priority=".$line->priority.
" entity=".$line->entity.
" label=".$line->label;
203 if ((empty($line->entity) ? 1 : $line->entity) != $conf->entity) {
204 dol_syslog(
"cron_run_jobs.php we work on another entity conf than ".$conf->entity.
" so we reload mysoc, langs, user and conf", LOG_DEBUG);
205 echo
" -> we change entity so we reload mysoc, langs, user and conf";
207 $conf->entity = (empty($line->entity) ? 1 : $line->entity);
208 $conf->setValues($db);
209 $mysoc->setMysoc($conf);
212 if ($conf->entity != $user->entity) {
213 $result = $user->fetch(
'', $userlogin,
'', 1);
215 echo
"\nUser Error: ".$user->error.
"\n";
216 dol_syslog(
"cron_run_jobs.php:: User Error:".$user->error, LOG_ERR);
220 echo
"\nUser login: ".$userlogin.
" does not exists for entity ".$conf->entity.
"\n";
221 dol_syslog(
"User login:".$userlogin.
" does not exists", LOG_ERR);
229 $langcode = (empty($conf->global->MAIN_LANG_DEFAULT) ?
'auto' : $conf->global->MAIN_LANG_DEFAULT);
230 if (!empty($user->conf->MAIN_LANG_DEFAULT)) {
231 $langcode = $user->conf->MAIN_LANG_DEFAULT;
233 if ($langs->getDefaultLang() != $langcode) {
234 $langs->setDefaultLang($langcode);
235 $langs->tab_translate = array();
236 $langs->loadLangs(array(
'main',
'admin',
'cron',
'dict'));
245 if (($line->datenextrun < $now) && (empty($line->datestart) || $line->datestart <= $now) && (empty($line->dateend) || $line->dateend >= $now)) {
251 $result = $cronjob->fetch($line->id);
253 echo
"Error cronjobid: ".$line->id.
" cronjob->fetch: ".$cronjob->error.
"\n";
254 echo
"Failed to fetch job ".$line->id.
"\n";
255 dol_syslog(
"cron_run_jobs.php::fetch Error ".$cronjob->error, LOG_ERR);
259 $result = $cronjob->run_jobs($userlogin);
261 echo
"Error cronjobid: ".$line->id.
" cronjob->run_job: ".$cronjob->error.
"\n";
262 echo
"At least one job failed. Go on menu Home-Setup-Admin tools to see result for each job.\n";
263 echo
"You can also enable module Log if not yet enabled, run again and take a look into dolibarr.log file\n";
264 dol_syslog(
"cron_run_jobs.php::run_jobs Error ".$cronjob->error, LOG_ERR);
265 $nbofjobslaunchedko++;
266 $resultstring =
'KO';
268 $nbofjobslaunchedok++;
269 $resultstring =
'OK';
272 echo
" - run_jobs ".$resultstring.
" result = ".$result;
275 $result = $cronjob->reprogram_jobs($userlogin, $now);
277 echo
"Error cronjobid: ".$line->id.
" cronjob->reprogram_job: ".$cronjob->error.
"\n";
278 echo
"Enable module Log if not yet enabled, run again and take a look into dolibarr.log file\n";
279 dol_syslog(
"cron_run_jobs.php::reprogram_jobs Error ".$cronjob->error, LOG_ERR);
283 echo
" - reprogrammed\n";
285 echo
" - not qualified\n";
293 echo
"cron_run_jobs.php no qualified job found\n";
298 if ($nbofjobslaunchedko) {
312 print
"Usage: ".$script_file.
" securitykey userlogin|'firstadmin' [cronjobid]\n";
313 print
"The script return 0 when everything worked successfully.\n";
315 print
"On Linux system, you can have cron jobs ran automatically by adding an entry into cron.\n";
316 print
"For example, to run pending tasks each day at 3:30, you can add this line:\n";
317 print
"30 3 * * * ".$path.$script_file.
" securitykey userlogin > ".DOL_DATA_ROOT.
"/".$script_file.
".log\n";
318 print
"For example, to run pending tasks every 5mn, you can add this line:\n";
319 print
"*/5 * * * * ".$path.$script_file.
" securitykey userlogin > ".DOL_DATA_ROOT.
"/".$script_file.
".log\n";