page_ScriptNeed("instant_edit.js", "js"); global $GUI; if (isset($_REQUEST["ref_system_flds_cfg"])) { if (isset($_POST["flds"])) { $_SESSION["user"]["data"]["conf_ref_system_fld"] = serialize($_POST["flds"]); } else { $_SESSION["user"]["data"]["conf_ref_system_fld"] = serialize(array()); } Employee::update($_SESSION["user"]["data"]["id"], array('conf_ref_system_fld' => $_SESSION["user"]["data"]["conf_ref_system_fld"])); $_SESSION["ref_system_flds_cfg"] = true; $GUI->OK("Выполнено"); die(""); } $temp_table = 'referrer_system_' . $_SESSION["user"]["data"]["id"]; $query = "\n SELECT o.*, ref.id AS referrer_id, ref.fio AS referrer_fio, ref.email AS referrer_email, ref.telnum AS referrer_phone, ref.city AS referrer_city, ref.referrer_code\n FROM " . TBL_PREF . "orders o\n JOIN " . TBL_PREF . "clients c ON c.id = o.klient_id\n JOIN " . TBL_PREF . "clients ref ON ref.id = c.ref_id\n WHERE c.ref_id != 0\n ORDER BY o.id ASC\n"; db::query("CREATE TEMPORARY TABLE " . TBL_PREF . $temp_table . " AS (" . $query . ")"); //Search panel $sp = $GUI->UPanel(); $sp->Caption = "Поиск партнера"; $searchWhere = ''; if (!empty($_REQUEST["kln_search"])) { $sp->defOpen = true; if (!empty($_REQUEST['search_id'])) { if (!empty($searchWhere)) { $searchWhere .= ' OR'; } $searchWhere .= "referrer_id = '" . db::input($_REQUEST['search_id']) . "'"; } if (!empty($_REQUEST['search_name'])) { if (!empty($searchWhere)) { $searchWhere .= ' OR';
function cron_sendEmailNotifications() { $execution_time = ini_get('max_execution_time'); if (empty($execution_time)) { $execution_time = DEF_EXEC_TIME; } else { if ($execution_time > MAX_EXEC_TIME * 2) { $execution_time = MAX_EXEC_TIME * 2; } } $execution_time_start = time(); $execution_time_end = $execution_time_start + $execution_time / 2; $notifications = \Components\Entity\EmailNotification::findBy(array(), array('attempts_to_send' => 'ASC'), EMAIL_NOTIFICATION_LIMIT, 0); $notification_index = 0; $good_cnt = 0; $notification_count = count($notifications); while (time() <= $execution_time_end && $notification_index < $notification_count) { $notification = $notifications[$notification_index]; $message = \Components\Entity\Message::find($notification['message_id']); if (!empty($message)) { //Прочитано, или не шлем - надо его сразу убить, чтобы потом когда включим не повалил шквал старых писем if ($message['readed'] || !\Components\Entity\EmailNotificationType::isSendable($notification['type'])) { \Components\Entity\EmailNotification::delete($notification['id']); } else { $attachments = array(); // надо только для писем типа \Components\Entity\EmailNotification::TO_SUBSCRIBED_AUTHORS_ON_DISTRIBUTION $all_added_size = 0; $fna = 0; if ($notification['type'] == \Components\Entity\EmailNotification::TO_SUBSCRIBED_AUTHORS_ON_DISTRIBUTION && !empty($message['order_id'])) { $files = get_order_files($message['order_id']); foreach ($files as $file) { $all_added_size += $file['size']; if ($all_added_size > 16000000) { // write to body, but not add file $fna++; } else { $attachments[] = array('path' => get_file_path($message['order_id'], $file), 'name' => $file['name']); } } } $subtext = ""; if ($fna) { $subtext = "<br><br>-----------------------------------<br>" . "Еще " . $fna . " файла(ов) не были добавлены к письму из-за ограничения размеров"; } // Это условие проверено выше //if ( \Components\Entity\EmailNotificationType::isSendable($notification['type']) ) //{ $email = new \Components\Classes\Email(); $email->IsHTML(true); $email->setData(array('email' => $notification['receiver_email'], 'name' => ''), $message['subject'], $message['text'] . $subtext, $attachments, true, Message::getReceiverEmailAndName($message['creator_id']), Message::getReceiverEmailAndName($message['creator_id'])); try { $send_result = $email->send(); if ($send_result) { \Components\Entity\EmailNotification::delete($notification['id']); $good_cnt++; } else { \Components\Entity\EmailNotification::update($notification['id'], array('attempts_to_send' => $notification['attempts_to_send'] + 1, 'last_attempt' => time(), 'last_error' => $email->ErrorInfo)); } } catch (\Components\Exceptions\Exception $e) { \Components\Entity\EmailNotification::update($notification['id'], array('attempts_to_send' => $notification['attempts_to_send'] + 1, 'last_attempt' => time())); } unset($email); //} } } $notification_index++; } db::query("update ofc_sys_log set p_value=" . $execution_time_start . " where p_name='email_notify_last_tm_start'"); db::query("update ofc_sys_log set p_value=" . (time() - $execution_time_start) . " where p_name='email_notify_last_tm_work'"); db::query("update ofc_sys_log set p_value=" . $notification_index . " where p_name='email_notify_last_all_cnt'"); db::query("update ofc_sys_log set p_value=" . $good_cnt . " where p_name='email_notify_last_good_cnt'"); }
/** * @deprecated * @param $user_id * @return bool */ function is_manager($user_id) { if (db::num_rows(db::query("\n SELECT *\n FROM " . TBL_PREF . "data_users u\n JOIN " . TBL_PREF . "roles r ON u.group_id = r.id\n WHERE (r.name = 'Старший менеджер' OR r.name = 'Менеджер' OR r.name = 'Младший менеджер') AND u.id = " . db::input($user_id) . "\n "))) { return true; } return false; }
function deluser_exec($Frm, $Err) { if (!$Err) { if (is_director($_SESSION["user"]['data']['id'])) { $id = $Frm->GetNmValueI('id'); if (count(Order::findBy(array('manager_id' => $id)))) { $Frm->_gui->informer->ERR("У сотрудника есть назначенные заказы"); return; } if (db::get_single_value("SELECT COUNT(id) FROM " . TBL_PREF . "data_visits WHERE user_id = '" . $id . "' AND status <> 1")) { $Frm->_gui->informer->ERR("У сотрудника есть назначенные встречи"); return; } $resone = $Frm->GetNmValueH('reason'); db::query("insert into " . TABLE_USERS_BLACK . " select * from " . TABLE_USERS . " where id= " . $id); EmployeeBlack::update($id, array('comments' => $resone, 'blocked' => 1, 'black_list' => 1, 'removed_by' => $_SESSION['user']['data']['id'], 'removed_time' => time())); Employee::delete($id); $Frm->_gui->informer->OK("Сотрудник перенесен в черный список"); } else { $Frm->_gui->informer->ERR("Перемещать сотрудников в черный список может только руководитель"); } page_reloadSec(); } }