public static function get_napravl_list_as_string($discipline_id) { return db::get_single_values_string("\n SELECT n.name\n FROM " . TABLE_NAPRAVL . " n\n JOIN " . TABLE_DISCIPLINE_TO_NAPRAVL . " d ON d.napravl_id = n.id\n WHERE d.discipline_id = " . db::input($discipline_id) . "\n "); }
if ($fltr != "") { $fltr .= " AND "; } $fltr .= "status_id = " . $status_id; } } elseif ($_SESSION["user"]["data"]["group_id"] == get_role_id_by_name('Автор')) { $distribution_status_id = get_status_id_by_iname('ON_THE_DISTRIBUTION'); if ($fltr != "") { $fltr .= " AND "; } // Чтобы не показывать заказ со статусом "ждет предоплаты" всем подряд, если он за кем-то закреплен $fltr .= "(status_id = " . $distribution_status_id . " OR author_id = " . $_SESSION["user"]["data"]["id"] . ")"; // $fltr .= "(status_id IN(" . $distribution_status_id . ", " . get_status_id_by_iname('WAITING_PREPAYMENT') . ") OR author_id = " . $_SESSION["user"]["data"]["id"] . ")"; if ($_SESSION['cgui_filcol_ord']['selset'] != "std2") { //Если выбран набор "мои заказы" - пропускаем фильтрацию по дисциплинам $author_disciplines = db::get_single_values_string("SELECT discipline_id FROM " . TBL_PREF . "author_to_discipline WHERE author_id = " . $_SESSION["user"]["data"]["id"]); if (!empty($author_disciplines)) { $fltr .= " AND disc_id IN(" . $author_disciplines . ")"; } } } elseif ($_SESSION["user"]["data"]["group_id"] == 5) { $delivery_boy_orders = array(); foreach (db::get_arrays("SELECT order_id FROM " . TBL_PREF . "data_visits WHERE user_id = " . db::input($_SESSION["user"]["data"]["id"])) as $res_order) { $delivery_boy_orders[] = $res_order['order_id']; } if ($fltr != "") { $fltr .= " AND "; } $fltr .= "id IN (" . join(', ', $delivery_boy_orders) . ")"; } if (!empty($fltr) && !empty($search_filter)) {
$usrs = array(); $usrs[0] = "-выберите-"; $ruk_group = Role::findOneBy(array('name' => 'Руководитель')); $elder_manager_group = Role::findOneBy(array('name' => 'Старший менеджер')); foreach ($data_users as $u) { if ($u["black_list"]) { continue; } if ($u["group_id"] == $ruk_group['id'] || $u["group_id"] == $elder_manager_group['id']) { $usrs[$u["id"]] = sotr_getFullName($u["id"]); } } $f = $frm->Select(310, $ypos, 278, $usrs, "", $filial["user_id"]); $f->linkName = 'manager'; $f->AddValidator(new CGUI_VALIDATOR_NOZERO()); $h = $frm->Hidden(db::get_single_values_string("SELECT city_id FROM " . TBL_PREF . "filial_to_city WHERE filial_id = " . db::input($filial['id']), '_')); $h->linkName = 'city'; city_modal($h->idname, $id); $b = $frm->Button("Города", 10, $ypos += 30, 70); $b->Event = 'open_cities("' . $h->idname . '", "' . $GUI->Vars["city_modal_form"]->idname . '");'; $frm->Label("Email филиала", 10, $ypos += 30); $t = $frm->Text(10, $ypos += 20, 573, $filial["email"]); $t->linkName = 'email'; $frm->Label("Адрес сайта", 10, $ypos += 30); $t = $frm->Text(10, $ypos += 20, 573, $filial["web"]); $t->linkName = 'url'; $frm->Label("Путь к форме заказа", 10, $ypos += 30); $t = $frm->Text(10, $ypos += 20, 573, $filial["order_form_path"]); $t->linkName = 'order_form_path'; $frm->Label("Описание", 10, $ypos += 30); $t = $frm->TextArea(10, $ypos += 20, 573, 50, $filial["about"]);