public function event_scheduler_list_json() { if ($this->isAjax) { if ($no_auth = $this->checkAuth()) { return $no_auth; } } $response = array('data' => array(), 'recordsTotal' => 0, 'recordsFiltered' => 0); $error = $this->setLocalization("Error"); $param = !empty($this->data) ? $this->data : array(); $query_param = $this->prepareDataTableParams($param, array('operations', '_', 'next_run', 'event_trans')); if (!isset($query_param['where'])) { $query_param['where'] = array(); } $filter = $this->getEventsFilters(); $query_param['where'] = array_merge($query_param['where'], $filter); $filds_for_select = $this->getScheduleEventsFields(); if (!empty($query_param['select'])) { $this->cleanQueryParams($query_param, array_keys($filds_for_select), $filds_for_select); } else { $query_param['select'] = $filds_for_select; } if (!array_key_exists('event', $query_param['select'])) { $query_param['select']['event'] = $filds_for_select['event']; } if (!array_key_exists('last_run', $query_param['select'])) { $query_param['select']['last_run'] = $filds_for_select['last_run']; } if (array_key_exists('id', $this->postData)) { $query_param['where'] = array('S_E.id' => $this->postData['id']); $response['action'] = 'fillModalForm'; } $response['recordsTotal'] = $this->db->getTotalRowsScheduleEvents(); $response["recordsFiltered"] = $this->db->getTotalRowsScheduleEvents($query_param['where'], $query_param['like']); $cronTab = new \CronExpression('* * * * *', new Cron\FieldFactory()); foreach ($cronTab->getMessageParts() as $key => $val) { $cronTab->setMessageParts($key, $this->setLocalization($val)); } $deferred = $this->setLocalization('deferred'); $unlimited = $this->setLocalization('unlimited'); $not_run = $this->setLocalization('do not yet running'); $all_event = array_merge($this->formEvent, $this->hiddenEvent); $all_event = array_combine($this->getFieldFromArray($all_event, 'id'), $this->getFieldFromArray($all_event, 'title')); $all_recipients = array('to_all' => $this->setLocalization('All'), 'by_group' => $this->setLocalization('Group'), 'to_single' => $this->setLocalization('One'), 'by_filter' => $this->setLocalization('Filter')); $response['data'] = array_map(function ($row) use($cronTab, $deferred, $all_event, $all_recipients, $unlimited, $not_run) { $cronTab->setCurrentTime($row['last_run']); $row['event_trans'] = $all_event[$row['event']]; $row['post_function'] = array_key_exists($row['post_function'], $all_event) ? $all_event[$row['post_function']] : $row['post_function']; $row['date_begin'] = (int) strtotime($row['date_begin']); if ($row['date_begin'] < 0) { $row['date_begin'] = 0; } $row['date_end'] = (int) strtotime($row['date_end']); if ($row['date_end'] <= 0) { $row['date_end'] = $unlimited; } $row['last_run'] = (int) strtotime($row['last_run']); if ($row['last_run'] <= 0) { $row['last_run'] = $not_run; } $row['cron_str'] = $row['schedule']; $cronTab->setExpression($row['schedule'])->setMessage(); if (!empty($row['schedule']) && (int) $row['periodic']) { $row['next_run'] = $cronTab->getNextRunDate()->getTimestamp(); $row['schedule'] = implode(' ', $cronTab->getMessage()); } else { $row['date_end'] = $row['next_run'] = $row['state'] ? $cronTab->getNextRunDate()->getTimestamp() : $deferred; $row['schedule'] = $cronTab->getMessageParts('once'); } $recipient = json_decode($row['recipient'], TRUE); list($row['recipient'], $recipient) = each($recipient); $row['user_list_type'] = $row['recipient']; $row['recipient'] = $all_recipients[$row['recipient']]; if (!empty($recipient) && is_array($recipient)) { $row = array_merge($row, (array) $recipient); } return $row; }, $this->db->getScheduleEvents($query_param)); $response["draw"] = !empty($this->data['draw']) ? $this->data['draw'] : 1; $error = ''; if ($this->isAjax) { if (!empty($response['data']) && !empty($this->postData['id'])) { $response['data'][0] = array_merge($response['data'][0], array_map(function ($row) { return is_numeric($row) ? str_pad((string) $row, 2, '0', STR_PAD_LEFT) : $row; }, \CronForm::getInstance()->setExpression($response['data'][0]['cron_str'])->getFormData())); if (array_key_exists('interval', $response['data'][0])) { $response['data'][0]['interval'] = str_replace('0', 'repeating_interval_', $response['data'][0]['interval']); } $response['data'][0]['type'] = "schedule_type_" . ((int) $response['data'][0]['periodic'] + 1); } $response = $this->generateAjaxResponse($response); return new Response(json_encode($response), empty($error) ? 200 : 500); } else { return $response; } }
require_once __DIR__ . '/../../admin/vendor/autoload.php'; define('PROJECT_PATH', realpath(dirname(__FILE__) . '/../')); require_once PROJECT_PATH . '/../storage/config.php'; $run_start_time = time(); $five_minute_interval = $run_start_time - $run_start_time % 300 + 300; echo strftime('%Y-%m-%d %H:%M:%S', $five_minute_interval), PHP_EOL; $_SERVER['TARGET'] = 'ADM'; $schedule_events = Mysql::getInstance()->from("`schedule_events`")->where(array('state' => 1, 'date_begin<=' => 'now()'))->where(array('date_end>last_run and date_end>' => 'now()', 'date_end' => 0), 'OR ')->get()->all(); $update_data = array(); $event = new \AdminPanelEvents(); $cronTab = new \CronExpression('* * * * *', new Cron\FieldFactory()); $cronTab->setCurrentTime('now'); foreach ($schedule_events as $row) { if (!empty($row['schedule'])) { $cronTab->setExpression($row['schedule']); $next_run_interval = $five_minute_interval - $cronTab->getNextRunDate()->getTimestamp(); if ($next_run_interval < 0 || $next_run_interval > 300) { continue; } $event->setTtl((int) $row['ttl']); if (!empty($row['post_function']) && !empty($row['param1'])) { $event->setPostFunctionParam($row['post_function'], $row['param1']); } else { $event->setPostFunctionParam('', ''); } if ($add_params = json_decode($row['recipient'], TRUE)) { list($user_list_type, $param) = each($add_params); $row['user_list_type'] = $user_list_type; if (is_array($param)) { $row = array_merge($row, $param);