Exemplos de Components\Classes db::get_single_values_string em PHP

Exemplo n.º 1

Arquivo: Disciplines.php Projeto: yonkon/diplom

 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    ");
 }

Exemplo n.º 2

Arquivo: list.php Projeto: yonkon/diplom

        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)) {

Exemplo n.º 3

Arquivo: edit.php Projeto: yonkon/diplom

 $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"]);