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 = "";
