function _before_start_table($tbl) { // get client names global $clients_info; $ids = $clients_info = array(); foreach ($tbl->Rows as $r) { $ids[$r["data"]["klient_id"]] = $r["data"]["klient_id"]; $ids[$r["data"]["referrer_id"]] = $r["data"]["referrer_id"]; } if (count($ids)) { $clients = db::get_assoc_arrays("SELECT id, fio, telnum, email, city FROM " . TABLE_CLIENTS . " WHERE id IN (" . join(', ', $ids) . ")"); foreach ($clients as $r) { $clients_info[$r["id"]] = $r; } } }
$r->Caption = "Сдать клиенту"; $r->DoSort = true; $r->Key = "time_kln"; $r->Align = "left"; $r->Process = "format_date"; foreach ($orders as $row) { $tbl->AddRow($row, 'id'); } $visits_fields = array('id', 'status', 'date', 'client_id'); $visits_order_by = ' ORDER BY id ASC'; if (isset($_REQUEST['sort_cgui_table_id_usotr_visits2'])) { $visits_order_by = ' ORDER BY ' . $visits_fields[$_REQUEST['sort_cgui_table_id_usotr_visits2']] . ' ASC'; } elseif (isset($_REQUEST['sort_cgui_table_id_usotr_visits2_up'])) { $visits_order_by = ' ORDER BY ' . $visits_fields[$_REQUEST['sort_cgui_table_id_usotr_visits2_up']] . ' DESC'; } $visits = db::get_assoc_arrays("SELECT " . join(", ", $visits_fields) . " FROM " . TABLE_VISITS . " WHERE user_id = " . $id . $visits_order_by); $tbl = $GUI->Table("sotr_visits" . $n); $tbl->Width = "50%"; $tbl->RowEvent2 = "document.location.href=\"?section=vis&subsection=2&visit=%var%\""; $r = $tbl->NewColumn(); $r->Caption = "Номер встречи"; $r->DoSort = true; $r->Key = "id"; $r = $tbl->NewColumn(); $r->Caption = "Статус"; $r->DoSort = true; $r->Key = "status"; $r->Align = "left"; $r->Process = "get_status"; $r = $tbl->NewColumn(); $r->Caption = "Дата";
/** * @deprecated * @return array */ function kln_getrawlist() { if ($_SESSION["user"]["data"]["group_id"] == 1 || $_SESSION["user"]["data"]["group_id"] == 0) { $sql = "SELECT * FROM " . TABLE_CLIENTS; } else { $sql = "SELECT * FROM " . TABLE_CLIENTS . " WHERE filial_id = " . db::input($_SESSION["user"]["data"]["filial_id"]); } return db::get_assoc_arrays($sql); }
if (!is_author($_SESSION['user']['data']['id'])) { $f = $Filter->AddFilter("CGUI_FilterSelect"); $f->name = "Способ оплаты"; $f->keyid = "payment_id"; $f->SetSelectData($data_payments, "name"); $f = $Filter->AddFilter("CGUI_FilterDate"); $f->name = "Распределить до"; $f->keyid = "raspred_srok"; $f = $Filter->AddFilter("CGUI_FilterDate"); $f->name = "Следующий контакт"; $f->keyid = "next_rel_date"; $f = $Filter->AddFilter("CGUI_FilterDate"); $f->name = "Дата комментария ОК"; $f->keyid = "ok_comment_date"; } $data_status = db::get_assoc_arrays("SELECT id, status_name FROM " . TABLE_ORDERS_STATUS); $statusFilter = $Filter->AddFilter("CGUI_FilterSelect"); $statusFilter->name = "Статус заказа"; $statusFilter->keyid = "status_id"; $statusFilter->SetSelectData($data_status, "status_name"); $f = $Filter->AddFilter("CGUI_FilterIntegerRange"); $f->name = "Гонорар автора"; $f->keyid = "cost_auth"; if (!is_author($_SESSION['user']['data']['id'])) { $f = $Filter->AddFilter("CGUI_FilterCurDate"); $f->name = "Отдать сегодня"; $f->keyid = "time_kln"; $flt_today_id = $f->id; } $Filter->MakeUserSets(20); if (!is_author($_SESSION['user']['data']['id'])) {
<div class="cgui_form_text" style="width: 530px; height: 30px; margin-left:50px; margin-top: 50px;"> <input type="text" value="{$subject}" name="subject" style="position: absolute; width:530px;"> </div> <div class="cgui_form_label" style="margin-left: 10px; margin-top: 90px;">Текст</div> <div class="cgui_form_text" style="width: 530px; height: 100px; margin-left:50px; margin-top: 90px;"> <textarea name="text" style="position: absolute; width:530px; height:100px"></textarea> </div> <button class="cgui_form_button" style="width: 100px; margin-left: 250px; margin-top: 210px">Отправить</button> </form></div> HTML; die; } $messages = db::get_assoc_arrays("SELECT * FROM " . TABLE_MESSAGES . " WHERE addr = 'k" . db::input($_SESSION['frame']['client']["id"]) . "' OR creator_id = 'k" . db::input($_SESSION['frame']['client']["id"]) . "' ORDER BY created DESC"); $output_messages = $readed_messages = $unreded_messages = array(); foreach ($messages as $o) { if ($o["readed"]) { $readed_messages[$o["id"]] = $o; } else { $unreded_messages[$o["id"]] = $o; } if ($o['creator_id'] == 'k' . $_SESSION['frame']['client']["id"]) { $output_messages[$o["id"]] = $o; } } function print_messages_table($ms) { $cnt = 0; $out = "";