コード例 #1
0
ファイル: functions.php プロジェクト: yonkon/diplom
function addvisit_2_exec($Frm, $Err)
{
    if (!$Err) {
        if (!isset($_SESSION["make_visit_tmp"]["klient"])) {
            $Frm->_gui->ERR("Клиент не определен");
            return;
        }
        $kln = kln_get($_SESSION["make_visit_tmp"]["klient"]);
        if (!$kln) {
            $Frm->_gui->ERR("Клиент не определен");
            return;
        }
        $ord_id = 0;
        if (isset($_SESSION["make_visit_tmp"]["order"]) && intval($_SESSION["make_visit_tmp"]["order"])) {
            $ord_id = intval($_SESSION["make_visit_tmp"]["order"]);
            if (!Order::find($ord_id)) {
                $Frm->_gui->ERR("Заказ не найден");
                return;
            }
        }
        // Проверить время
        $t1 = $Frm->GetNmValue("start");
        $t2 = $Frm->GetNmValue("finish");
        if ($t2 <= $t1) {
            $Frm->_gui->ERR("Некорректно задано время");
            return;
        }
        $dt = explode("-", $_SESSION["make_visit_tmp"]["date"]);
        $dt = mktime(0, 0, 0, $dt[1], $dt[0], $dt[2]);
        $fil = intval($_SESSION["make_visit_tmp"]["filial_id"]);
        if ($fil <= 0) {
            $Frm->_gui->ERR("Некорректный филиал");
            return false;
        }
        $courier_id = $Frm->GetNmValueI("user");
        $visits = db::get_single_value("SELECT COUNT(*) FROM " . TABLE_VISITS . " WHERE user_id = " . db::input($courier_id) . " AND tm_start <= " . db::input($t1) . " AND tm_finish > " . db::input($t1) . " AND date = " . db::input($dt));
        if ($visits) {
            $Frm->_gui->ERR("На это время уже назначена встреча");
            return false;
        }
        $vis_id = Meeting::create(array("user_id" => $courier_id, "date" => $dt, "status" => 0, "tm_start" => $t1, "tm_finish" => $t2, "client_id" => $kln["id"], "order_id" => $ord_id, "filial_id" => $fil, "created" => time(), "creator_id" => $_SESSION["user"]["data"]["id"], "summa" => $_SESSION["make_visit_tmp"]["summa1"], "about" => $_SESSION["make_visit_tmp"]["about"], "opisanie_klienta" => $Frm->GetNmValueH("opisanie_klienta"), "opisanie_pyti" => $Frm->GetNmValueH("opisanie_pyti"), "station_id" => $Frm->GetNmValueI("station")));
        $Frm->_gui->OK("Встреча создана");
        // Создаем сообщение при необходимости
        if ($courier_id != $_SESSION["user"]["data"]["id"]) {
            $prior = 1;
            $msg_id = mls_Send("u" . $courier_id, "u" . $_SESSION["user"]["data"]["id"], "Новая встреча №" . $vis_id, "Вы проводите встречу " . date("d.m.Y", $dt) . " c " . utils_cvt_i2times($t1) . " по " . utils_cvt_i2times($t2) . "." . " <a href='?section=vis&subsection=2&visit=" . $vis_id . "'>Подробнее...</a><br>Внимание! Ответ на данное сообщение обязателен!", $prior, 0, 0, 0, 0, $vis_id, 0);
            if ($msg_id) {
                \Components\Classes\Author::enqueue_message_to_email($msg_id, array($courier_id), \Components\Entity\EmailNotificationType::TO_CLIENT_ON_ORDER_CHANGE);
                Meeting::update($vis_id, array('uved_umsg' => $msg_id));
            }
        }
        page_reloadToSec("2");
    }
}
コード例 #2
0
ファイル: functions.php プロジェクト: yonkon/diplom
function tp_get_id($value, $row, $table, &$info)
{
    if ($table instanceof CGUI_Table && $table->rowmenu) {
        $table->rowmenu->Vars[1] = $value;
        $table->rowmenu->Vars[2] = $row["klient_id"];
        $html = $table->rowmenu->GetHTML($value);
    } else {
        $html = $value;
    }
    if ($ref_id = db::get_single_value("SELECT ref_id FROM " . TBL_PREF . "clients WHERE id = " . $row["klient_id"])) {
        $info = new CGUI_TableCellInfo();
        $info->Text("<p>Номер: #" . $ref_id . "</p>" . "<p>Имя: " . db::get_single_value("SELECT fio FROM " . TBL_PREF . "clients WHERE id = " . $ref_id) . "</p>");
        $info->icon = '<img src="' . SITE_URL . '/gui/skin/coins.png"/>';
    }
    return $html;
}
コード例 #3
0
ファイル: filial_cities.php プロジェクト: yonkon/diplom
function add_city_exec($Frm, $Err)
{
    if (!$Err) {
        $name = str_replace("'", '"', htmlspecialchars($Frm->GetValue(0)));
        if (db::get_single_value("SELECT COUNT(*) FROM " . TABLE_CITIES . " WHERE name = '" . db::input($name) . "'")) {
            $Frm->_gui->informer->ERR("Запись существует");
            page_reloadAll();
        }
        db::insert(TABLE_CITIES, array('name' => $name));
        $Frm->_gui->informer->OK("Добавлено");
        page_reloadSubSec();
    }
}
コード例 #4
0
ファイル: inc_problems.php プロジェクト: yonkon/diplom
            $r1->DoSort = $custom_column['do_sort'];
            $r1->Key = $custom_column['internal_name'];
            $r1->Align = $custom_column['align'];
            $r1->Process = $custom_column['on_execute'];
            $r->Custom[] = $r1;
        }
    } else {
        $r = $tbl->NewColumn();
        $r->Caption = $column['name'];
        $r->DoSort = $column['do_sort'];
        $r->Key = $column['internal_name'];
        $r->Align = $column['align'];
        $r->Process = $column['on_execute'];
    }
}
$GUI->Vars['tm_started'] = db::get_single_value("select p_value from ofc_sys_log where p_name='email_notify_last_tm_start'");
$ds = time() - $GUI->Vars['tm_started'];
if ($ds < 60) {
    $GUI->Vars['tm_info'] = "менее минуты";
} else {
    if ($ds < 60 * 15) {
        $GUI->Vars['tm_info'] = ceil($ds / 60) . " мин.";
    } else {
        $GUI->Vars['tm_info'] = "более 15 мнут";
    }
}
$GUI->Vars['tm_needcnt'] = db::get_single_value("select count(id) from ofc_email_notifications");
$GUI->Vars['tm_working'] = db::get_single_value("select p_value from ofc_sys_log where p_name='email_notify_last_tm_work'");
$GUI->Vars['tm_allcnt'] = db::get_single_value("select p_value from ofc_sys_log where p_name='email_notify_last_all_cnt'");
$GUI->Vars['tm_goodcnt'] = db::get_single_value("select p_value from ofc_sys_log where p_name='email_notify_last_good_cnt'");
コード例 #5
0
ファイル: Napravls.php プロジェクト: yonkon/diplom
 public static function getName($napravl_id)
 {
     return db::get_single_value("SELECT name FROM " . TABLE_NAPRAVL . " WHERE id = " . db::input($napravl_id));
 }
コード例 #6
0
ファイル: list.php プロジェクト: yonkon/diplom
    $i++;
}
$tbl->FilterMYSQL($result_filter);
$totals = db::get_arrays("\n  SELECT filial_id, SUM(`value`) as total_expenses\n  FROM " . TBL_PREF . $Filter->DstTable . "\n  WHERE " . $result_filter . "\n  GROUP BY filial_id\n");
if ($totals) {
    $stat_tbl = $GUI->Table("expenses_stat" . $n);
    $stat_tbl->Width = "50%";
    $column = $stat_tbl->NewColumn();
    $column->Caption = "Филиал";
    $column->Key = "id";
    $column = $stat_tbl->NewColumn();
    $column->Caption = "Общий расход";
    $column->Key = "total_expenses";
    if (is_director($_SESSION['user']['data']['id'])) {
        $column = $stat_tbl->NewColumn();
        $column->Caption = "Итого расход руководителя";
        $column->Key = "director_expenses";
    }
    foreach ($totals as $row) {
        $res = array();
        if ($row['filial_id'] == 0) {
            $res['id'] = 'Руководитель';
            $res['director_expenses'] = '';
        } else {
            $res['id'] = get_filial_name($row['filial_id']);
            $res['director_expenses'] = $row['total_expenses'] * (1 - db::get_single_value("SELECT consumption FROM " . TBL_PREF . "data_filials WHERE id = " . $row['filial_id']));
        }
        $res['total_expenses'] = $row['total_expenses'];
        $stat_tbl->AddRow($res);
    }
}
コード例 #7
0
ファイル: functions.php プロジェクト: yonkon/diplom
function editdiscip_exec($Frm, $Err)
{
    if (!$Err) {
        $id = $Frm->GetNmValueI('id');
        if (empty($id)) {
            $Frm->_gui->informer->ERR('Произошла ошибка. Попробуйте перезагрузить страницу');
            page_reloadAll();
        }
        $name = trim($Frm->GetNmValueH('name'));
        $napravl = $Frm->GetNmValue('napravl');
        if (empty($napravl) || empty($name)) {
            $Frm->_gui->informer->ERR('Заполните Название и выберите Направление');
            page_reloadAll();
        }
        if (db::get_single_value("SELECT COUNT(*) FROM " . TABLE_DISCIPLINE . " WHERE LOWER(name) = '" . db::input(strtolower($name)) . "' AND id != " . db::input($id))) {
            $Frm->_gui->informer->ERR('Дисциплина с таким именем уже существует');
            page_reloadAll();
        }
        Discipline::update($id, array('code' => $Frm->GetNmValueI('code'), 'name' => $name));
        Disciplines::addToNapravList($id, $napravl);
        $Frm->_gui->informer->OK("Сохранено");
        page_reloadAll();
    }
}
コード例 #8
0
ファイル: functions.php プロジェクト: yonkon/diplom
function get_config_value_by_iname($internal_name)
{
    return db::get_single_value("SELECT value FROM " . TBL_PREF . "configs WHERE internal_name = '" . db::input($internal_name) . "'");
}
コード例 #9
0
ファイル: messages.php プロジェクト: yonkon/diplom
 $s->RowSize = 5;
 $s->linkName = 'employers';
 $frm->Label("c", 330, $ypos);
 $t = $frm->DatePic(350, $ypos, 100);
 $t->linkName = 'date_from';
 $frm->Label("по", 330, $ypos += 25);
 $t = $frm->DatePic(350, $ypos, 100);
 $t->linkName = 'date_to';
 $frm->Label("Направление", 330, $ypos += 25);
 $s = $frm->Select(330, $ypos += 20, 100, array(0 => "все", 1 => "входящие", 2 => "исходящие"));
 $s->linkName = 'direction';
 // С клиентами
 $clients1 = array();
 $clients = kln_getrawlist();
 foreach ($clients as $v) {
     if (db::get_single_value("SELECT COUNT(id) FROM " . TABLE_MESSAGES . " WHERE (addr='k" . $v["id"] . "' AND creator_id='u" . $id . "') OR (addr='u" . $id . "' AND creator_id='k" . $v["id"] . "')")) {
         $clients1[$v["id"]] = $v['fio'];
     }
 }
 if (count($clients1) > 1) {
     $clients1 = array(0 => "-любым-") + $clients1;
 }
 $t = $frm->Checkbox(10, $ypos += 30, false, 1);
 $t->linkName = 'with_clients';
 $frm->Label("Переписка с клиентами:", 30, $ypos);
 $s = $frm->Select(10, $ypos += 20, 480, $clients1);
 $s->RowSize = 10;
 $s->linkName = 'clients';
 $frm->VLine(10, $ypos += 200, 480);
 $frm->Button("Получить", 250 - 80 - 10, $ypos += 20, 80, true);
 $frm->OnExecute = "getmsgs_exec";
コード例 #10
0
ファイル: _checknew.php プロジェクト: yonkon/diplom
<?php

use Components\Classes\db;
require_once '../../includes/application_top.php';
if (!$_SESSION["user"]["auth"]) {
    die("запрещено");
}
if (db::get_single_value("SELECT id FROM " . TABLE_MESSAGES . " WHERE addr = 'u" . db::input($_SESSION["user"]["data"]["id"]) . "' AND readed = '0' AND basket = '0'")) {
    die("1");
} else {
    die("0");
}
コード例 #11
0
ファイル: cabinet_messages.php プロジェクト: yonkon/diplom
} else {
    if (!empty($_REQUEST['new']) && !empty($_REQUEST['r'])) {
        try {
            $receiver = Employee::find($_REQUEST['r']);
        } catch (Exception $e) {
            redirect("?type=cabinet&messages");
        }
        if (!empty($_REQUEST['send'])) {
            if ($receiver['id'] != $_REQUEST['receiver']) {
                redirect("?type=cabinet&messages");
            }
            $message_id = mls_Send('u' . $receiver['id'], 'k' . $_SESSION['frame']['client']['id'], $_REQUEST['subject'], $_REQUEST['text'], 1, 0);
            \Components\Classes\Author::enqueue_message_to_email($message_id, array($receiver['id']), \Components\Entity\EmailNotificationType::TO_RECEIVER_ON_MESSAGE_COMMON);
            redirect("?type=cabinet&messages");
        }
        $receiver_full_name = db::get_single_value("SELECT sname FROM " . TABLE_ROLES . " WHERE id = " . $receiver['group_id']) . ' ' . $receiver['fio'];
        $subject = '';
        if (!empty($_REQUEST['o'])) {
            $subject = 'Вопрос по заказу №' . $_REQUEST['o'];
        }
        echo "<div style='margin-bottom: 5px'><a href='?type=cabinet&messages'><< к списку сообщений</a></div>";
        echo <<<HTML
<div id="cgui_form_0" class="cgui_form_box" style="width:600px; height: 270px; margin: 0 auto;">
<div class="cgui_form_capt">Новое сообщение</div>
<form class="cgui_form" method="post">
<input type="hidden" name="send" value="1"/>
<div class="cgui_form_text" style="width: 530px; height: 50px; margin-left:50px; margin-top: 10px;">
  <input type="text" value="{$receiver_full_name}" style="position: absolute; width:530px;">
  <input name="receiver" value="{$receiver['id']}" type="hidden">
</div>
コード例 #12
0
ファイル: diplom.api.class.php プロジェクト: yonkon/diplom
 public static function add_client($client_params)
 {
     $result = array('status' => false, 'msg' => '');
     if (empty($client_params['fio'])) {
         $client_params['fio'] = 'Клиент с сайта';
     }
     if (Client::exist($client_params['email'])) {
         $result['msg'] = "Клиент с email - " . $client_params['email'] . " уже существует";
         return $result;
     }
     $date = mktime();
     if (!empty($client_params['filial_id'])) {
         $filial_id = Filials::check($client_params['filial_id']);
     } else {
         $filial_id = Filials::search($client_params['filial']);
         if ((!$filial_id || $filial_id == 9) && !empty($client_params['city'])) {
             $query = "SELECT ftc.filial_id FROM " . TBL_PREF . "data_city dc JOIN " . TBL_PREF . "filial_to_city ftc ON ftc.city_id = dc.id" . " WHERE dc.name = '" . db::input($client_params['city']) . "'";
             $filial_id = db::get_single_value($query);
             if (!$filial_id) {
                 $filial_id = 9;
             }
         }
     }
     $client_id = Client::create(array('filial_id' => $filial_id, 'fio' => $client_params['fio'], 'email' => $client_params['email'], 'telnum' => $client_params['telnum'], 'city' => $client_params['city'], 'liketel' => $client_params['liketel'], 'teltime' => $client_params['teltime'], 'icq' => $client_params['icq'], 'skype' => $client_params['skype'], 'contacts' => $client_params['contacts'], 'blocked' => $client_params['blocked'], 'about' => $client_params['about'], 'ocenka' => $client_params['ocenka'], 'ref_id' => $client_params['ref_id'], 'from_id' => $client_params['from_id'], 'added_by' => $client_params['added_by'], 'orderform' => $client_params['orderform'], 'password' => $client_params['password']));
     return self::generate_response(true, "OK", array('id' => $client_id, 'date' => $date));
 }
コード例 #13
0
ファイル: delete.php プロジェクト: yonkon/diplom
if (!user_can($GUI->mmenu->selected->id, $GUI->mmenu->selected->selected->id, $_SESSION["user"]["data"]["group_id"], "Удалить")) {
    $GUI->informer->ERR(PERMISSION_DENIED);
    page_ReloadSubSec();
}
$id = intval($_REQUEST["del"]);
if ($_SESSION["user"]["data"]["id"] == $id) {
    $GUI->ERR("Нельзя удалить себя");
    page_ReloadSubSec();
}
$employer = Employee::find($id);
if ($employer) {
    if (count(Order::findBy(array('manager_id' => $id)))) {
        $GUI->informer->ERR("У сотрудника есть назначенные заказы");
        page_ReloadSubSec();
    }
    if (db::get_single_value("SELECT COUNT(id) FROM " . TBL_PREF . "data_visits WHERE user_id = '" . $id . "' AND status <> 1")) {
        $GUI->informer->ERR("У сотрудника есть назначенные встречи");
        page_ReloadSubSec();
    }
    $frm = $GUI->Form("В черный список", 300, 260);
    $t = $frm->Hidden($id);
    $t->linkName = 'id';
    $frm->VLine(10, 180, 280);
    $frm->Button("Выполнить", 60, 200, 80, true);
    $frm->OnExecute = "deluser_exec";
    $b = $frm->Button("Назад", 160, 200, 80);
    $b->Event = "document.location.href=\"?" . $GUI->Url(array('section', 'subsection', 'del')) . "edit=" . $id . "\"; return false;";
    $frm->Label("Перенести в черный список сотрудника", 10, 10);
    $frm->Label("'" . $employer["fio"] . "'?", 10, 30);
    $frm->Label("Причина:", 10, 60);
    $t = $frm->TextArea(10, 80, 280, 70);
コード例 #14
0
ファイル: gui_table.php プロジェクト: yonkon/diplom
 function MakeHTML()
 {
     $this->_check_sort_links();
     if ($this->isort) {
         $this->_inlinesort();
     }
     $where = "";
     if ($this->mysql_filter != "") {
         $where = " WHERE " . $this->mysql_filter;
     }
     if ($this->mysql_source) {
         $this->Rows = array();
         $limit = "";
         if ($this->pager) {
             $this->pager->allcount = intval(db::get_single_value("SELECT COUNT(" . $this->mysql_source_alias . "id) AS cnt FROM " . TBL_PREF . $this->mysql_source . $where));
             $limit = $this->pager->GetLimitStr();
         }
         $ord_str = "ORDER BY ";
         if (!is_null($this->order_rules)) {
             $ord_str .= $this->order_rules . ",";
         }
         $ord_str .= !$this->GetCurSortKey() ? $this->mysql_source_alias . "id" : $this->mysql_source_alias . $this->GetCurSortKey();
         foreach (db::get_arrays("SELECT " . $this->mysql_flds . " FROM " . TBL_PREF . $this->mysql_source . $where . " " . $ord_str . $limit) as $r) {
             $this->AddRow($r, $this->mysql_source_alias . "id");
         }
     } else {
         if ($this->pager) {
             $this->pager->allcount = count($this->Rows);
             if ($this->pager->GetLimitStr() != '') {
                 $tmp = $this->Rows;
                 $this->Rows = array();
                 for ($i = 0; $i < $this->pager->onPage; $i++) {
                     if (isset($tmp[$this->pager->curPage * $this->pager->onPage + $i])) {
                         $this->Rows[$i] = $tmp[$this->pager->curPage * $this->pager->onPage + $i];
                     }
                 }
             }
         }
     }
     $this->StartTable();
     $this->HtmlB = "";
     foreach ($this->Rows as $kr => $r) {
         $rdata = $r["data"];
         $r["style"]["cursor"] = "arrow";
         $r["style"]["background-color"] = "";
         if ($this->OnRowStart) {
             eval("\$" . "s = " . $this->OnRowStart . "(\$" . "r);");
         }
         if (is_array($this->Highlite)) {
             if ($rdata[$this->Highlite[0]] == $this->Highlite[1]) {
                 $r["style"]["background-color"] = "yellow";
             }
         }
         if (!empty($_SESSION['user']['data']['conf_ord_colors']) && $this->useColors) {
             $currentColors = unserialize($_SESSION['user']['data']['conf_ord_colors']);
             $r["style"]["background-color"] = isset($currentColors[$rdata['id']]) ? $currentColors[$rdata['id']] : '#FFFFFF';
         } else {
             $currentColors = array();
         }
         $st = $this->makeRowStyle($r);
         $this->HtmlB .= "<tr style='" . $st . "'  data-color='" . (isset($currentColors[$rdata['id']]) ? $currentColors[$rdata['id']] : '#FFFFFF') . "' data-row-id='" . $rdata['id'] . "'";
         if ($this->RowSelect) {
             $this->HtmlB .= " onmouseover='jQuery(this).css(\"background-color\", \"" . $this->RowSelectCol . "\");' onmouseout='jQuery(this).css(\"background-color\", \"" . $r["style"]["background-color"] . "\");'";
             if ($this->RowEvent != "") {
                 $this->HtmlB .= " onclick='" . $this->RowEvent . "(" . $r["data"][$r["ek"]] . ");'";
             } else {
                 if ($this->RowEvent2 != "") {
                     if (strpos($this->RowEvent2, "%var%") != false) {
                         $s = str_replace("%var%", $r["data"][$r["ek"]], $this->RowEvent2);
                     } else {
                         $attr_index = strpos($this->RowEvent2, "%var.");
                         $s = str_replace("%var.", '', $this->RowEvent2);
                         $attr_ends = strpos($s, '%', $attr_index);
                         $attr_name = substr($s, $attr_index, $attr_ends - $attr_index);
                         $s = str_replace($attr_name . '%', $r["data"][$attr_name], $s);
                     }
                     $this->HtmlB .= " onclick='" . $s . "'";
                 }
             }
         }
         $this->HtmlB .= ">" . "\n";
         foreach ($this->Columns as $k => $v) {
             $s = "";
             if (count($v->Custom)) {
                 $v = $v->Custom[$this->Settings["cust"][$k]];
             }
             if ($v->Key != "" && isset($rdata[$v->Key])) {
                 if (is_array($v->ExtData)) {
                     $s = $v->ExtData[$rdata[$v->Key]];
                 } else {
                     $s = $rdata[$v->Key];
                 }
             }
             if ($v->Process != "") {
                 $this->Rows[$kr]['info'][$k] = '';
                 eval("\$" . "s=" . $v->Process . "(\$" . "s, \$" . "rdata, \$" . "this, \$" . "this->Rows[\$" . "kr]['info'][\$" . "k]);");
             } elseif ($v->Format) {
                 switch ($v->Format) {
                     case CGUI_TABLE_FMT_SIZE:
                         $s = _tbl_fmt_size($s);
                         break;
                     case CGUI_TABLE_FMT_DATE:
                         $s = _tbl_fmt_date($s);
                         break;
                     case CGUI_TABLE_FMT_DATETIME:
                         $s = _tbl_fmt_datetime($s);
                         break;
                 }
             }
             if (!empty($this->Rows[$kr]["info"][$k])) {
                 $s = $this->Rows[$kr]["info"][$k]->GetHTML($s);
             }
             $this->HtmlB .= "<td";
             if ($v->NoWrap) {
                 $this->HtmlB .= " nowrap";
             }
             if ($v->Align) {
                 $this->HtmlB .= " style='text-align: " . $v->Align . "'";
             }
             if ($v->hidden) {
                 $this->HtmlB .= ' class="hide"';
             }
             if ($v->id) {
                 $this->HtmlB .= ' id="' . $v->id . '"';
             }
             $this->HtmlB .= ">";
             if ($v->instantEdit) {
                 $this->HtmlB .= '<span class="instantEditOldValue">' . $s . '</span><span class="instantEdit" data-title="' . $v->Caption . '" data-field="' . $v->Key . '" data-value="' . $rdata[$v->Key] . '"></span>' . "\n";
             } else {
                 $this->HtmlB .= $s . "\n";
             }
             $this->HtmlB .= "</td>" . "\n";
         }
         $this->HtmlB .= "</tr>" . "\n";
     }
     $this->EndTable();
 }
コード例 #15
0
ファイル: Disciplines.php プロジェクト: yonkon/diplom
 public static function getName($discipline_id)
 {
     return db::get_single_value("SELECT name FROM " . TABLE_DISCIPLINE . " WHERE id = " . db::input($discipline_id));
 }
コード例 #16
0
     foreach ($orders as $order_id) {
         $order_id = trim($order_id);
         if (empty($order_id)) {
             continue;
         }
         $order_info = get_order_info($order_id);
         $company_paid = calculate_debt_to_company($order_info['cost_kln'], $order_info['cost_auth'], $order_info['filial_id']);
         Order::update($order_id, array('company_paid' => $company_paid));
         $data = array('change_date' => time(), 'change_user_id' => $_SESSION['user']['data']['id'], 'order_id' => $order_id, 'filial_id_new' => $order_info['filial_id'], 'klient_id_new' => $order_info['klient_id'], 'vuz_id_new' => $order_info['vuz_id'], 'vuz_user_new' => $order_info['vuz_user'], 'type_id_new' => $order_info['type_id'], 'type_user_new' => $order_info['type_user'], 'napr_id_new' => $order_info['napr_id'], 'disc_id_new' => $order_info['disc_id'], 'disc_user_new' => $order_info['disc_user'], 'time_kln_new' => $order_info['time_kln'], 'cost_kln_new' => $order_info['cost_kln'], 'payment_id_new' => $order_info['payment_id'], 'subject_new' => $order_info['subject'], 'about_kln_new' => $order_info['about_kln'], 'about_mng_new' => $order_info['about_mng'], 'kurs_new' => $order_info['kurs'], 'prakt_pc_new' => $order_info['prakt_pc'], 'pages_min_new' => $order_info['pages_min'], 'pages_max_new' => $order_info['pages_max'], 'src_min_new' => $order_info['src_min'], 'src_max_new' => $order_info['src_max'], 'from_id_new' => $order_info['from_id'], 'oform_new' => $order_info['oform'], 'next_rel_date_new' => $order_info['next_rel_date'], 'status_id_new' => $order_info['status_id'], 'ok_comment_new' => $order_info['ok_comment'], 'ok_comment_date_new' => $order_info['ok_comment_date'], 'payment_comment_new' => $order_info['payment_comment'], 'cost_auth_new' => $order_info['cost_auth'], 'time_auth_new' => $order_info['time_auth'], 'oplata_kln_new' => $order_info['oplata_kln'], 'author_paid_new' => $order_info['author_paid'], 'company_paid_new' => $company_paid, 'filial_id_old' => $order_info['filial_id'], 'klient_id_old' => $order_info['klient_id'], 'vuz_id_old' => $order_info['vuz_id'], 'vuz_user_old' => $order_info['vuz_user'], 'type_id_old' => $order_info['type_id'], 'type_user_old' => $order_info['type_user'], 'napr_id_old' => $order_info['napr_id'], 'disc_id_old' => $order_info['disc_id'], 'disc_user_old' => $order_info['disc_user'], 'time_kln_old' => $order_info['time_kln'], 'cost_kln_old' => $order_info['cost_kln'], 'payment_id_old' => $order_info['payment_id'], 'subject_old' => $order_info['subject'], 'about_kln_old' => $order_info['about_kln'], 'about_mng_old' => $order_info['about_mng'], 'kurs_old' => $order_info['kurs'], 'prakt_pc_old' => $order_info['prakt_pc'], 'pages_min_old' => $order_info['pages_min'], 'pages_max_old' => $order_info['pages_max'], 'src_min_old' => $order_info['src_min'], 'src_max_old' => $order_info['src_max'], 'from_id_old' => $order_info['from_id'], 'oform_old' => $order_info['oform'], 'next_rel_date_old' => $order_info['next_rel_date'], 'status_id_old' => $order_info['status_id'], 'ok_comment_old' => $order_info['ok_comment'], 'ok_comment_date_old' => $order_info['ok_comment_date'], 'payment_comment_old' => $order_info['payment_comment'], 'cost_auth_old' => $order_info['cost_auth'], 'time_auth_old' => $order_info['time_auth'], 'oplata_kln_old' => $order_info['oplata_kln'], 'author_paid_old' => $order_info['author_paid'], 'company_paid_old' => $order_info['company_paid']);
         OrderHistory::create($data);
     }
     $result[] = 0;
     break;
 case 'color':
     $bDoUpdate = false;
     $currentColors = db::get_single_value("SELECT conf_ord_colors FROM " . TBL_PREF . "data_users WHERE id = " . $_SESSION['user']['data']['id']);
     if (empty($currentColors)) {
         $currentColors = array();
     } else {
         $currentColors = unserialize($currentColors);
     }
     $currentColors[$_GET['order_id']] = $_GET['value'];
     $currentColors = serialize($currentColors);
     Employee::update($_SESSION['user']['data']['id'], array('conf_ord_colors' => $currentColors));
     $_SESSION['user']['data']['conf_ord_colors'] = $currentColors;
     break;
 case 'referrer_payment_status_all':
     $bDoUpdate = false;
     $orders = explode(',', $_GET['order_id']);
     foreach ($orders as $order_id) {
         $order_id = trim($order_id);
コード例 #17
0
ファイル: functions.php プロジェクト: yonkon/diplom
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();
    }
}