PHP addr_id_fullの例

コード例 #1

ファイル: backend.php プロジェクト: steryoshkin/fibers

        $sql_u = "UPDATE " . $table_node . " SET\r\n                \tstreet_id = " . clean($_POST['street_name_id']) . ", \r\n                    street_num_id = " . $street_num_id . ",\r\n                    num_ent = " . (empty($_POST['num_ent']) ? "NULL" : $_POST['num_ent']) . ",\r\n                    location_id = " . ($_POST['location_id'] != 0 ? $_POST['location_id'] : "NULL") . ",\r\n                    room_id = " . ($_POST['room_id'] != 0 ? $_POST['room_id'] : "NULL") . ",\r\n                    incorrect=" . (empty($_POST['incorrect']) ? "NULL" : "true") . ",\r\n                    node_type_id = " . ($_POST['node_type_id'] != 0 ? $_POST['node_type_id'] : "NULL") . ",\r\n                    descrip= " . (empty($_POST['descrip']) ? "NULL" : "'" . $_POST['descrip'] . "'") . ",\r\n\t\t\t\t\tuser_id = " . $user_id . ",\r\n\t\t\t\t\t" . ($_POST['act'] == 'n_node' ? 'type = 0,' : '') . "\r\n\t\t\t\t\tis_new = 'f'::boolean\r\n                    WHERE id = " . $id . ";";
        echo $sql_u;
        $data_old = pg_fetch_assoc(pg_query("SELECT * FROM " . $table_node . " WHERE id = " . $id));
        pg_query($sql_u);
        pg_query("UPDATE " . $table_node . " SET address = '" . addr_id($id) . "', address_full = '" . addr_id_full($id) . "' WHERE id = " . $id);
    }
    //}
    //pg_query("UPDATE ".$table_node." SET address='".addr_id($id)."', address_full='".addr_id_full($id)."' WHERE id=".$id);
    $loc_text = addr_id_loc($id);
    if ($loc_text) {
        $loc_text = "'" . $loc_text . "'";
    } else {
        $loc_text = "NULL";
    }
    //pg_query("UPDATE ".$table_node." SET loc_text = ".$loc_text." WHERE id=".$id);
    pg_query("UPDATE " . $table_node . " SET address='" . addr_id($id) . "', address_full='" . addr_id_full($id) . "', loc_text = " . $loc_text . " WHERE id=" . $id);
    $data_new = pg_fetch_assoc(pg_query("SELECT * FROM " . $table_node . " WHERE id = " . $id));
    $result = serialize(array_diff($data_old, $data_new));
    add_log($table_node, $id, $result, $user_id);
    echo @$text;
    die;
}
// удаление узла div
if (isset($_GET['act']) && $_GET['act'] == 'd_node' && @is_numeric($_GET['node_id'])) {
    $sql = "SELECT COUNT(*) FROM " . $table_pq . " AS p1 WHERE p1.node =" . clean($_GET['node_id']);
    if (pg_result(pg_query($sql), 0)) {
        $text = '
            <div class="span11 m5">&nbsp;Узел "' . clean($_GET['addr']) . '" не пустой. Перед удалением узла необходимо удалить пассивное оборудование!!!</div>
            <div class="span1 toolbar m0">
                <button class="icon-blocked m0" id="exit" title="Отмена"></button>
            </div>';

コード例 #2

ファイル: index.php プロジェクト: steryoshkin/fibers

//if (isset($_GET['act']) && $_GET['act'] == 'pq_file' && ( is_numeric($_GET['pq_id']) || isset($_GET['id']))) {
if (isset($_GET['act']) && $_GET['act'] == 'pq_file' && (@is_numeric($_GET['pq_id']) || isset($_GET['id']))) {
    if (@is_numeric($_GET['pq_id'])) {
        $i = 1;
        // id кросса/муфты
        $pq_id = clean($_GET['pq_id']);
        // навигация
        $sql = "SELECT n1.id AS id, pt.type AS type, p1.num AS num, LEFT(p1.descrip, 15) AS descrip FROM " . $table_pq . " AS p1 , " . $table_node . " AS n1, " . $table_pq_type . " AS pt WHERE p1.node = n1.id AND p1.id=" . $pq_id . " AND p1.pq_type_id = pt.id;";
        $result = pg_fetch_assoc(pg_query($sql));
        //print_r($result);
        // id узла
        $node_id = $result['id'];
        // тип и номер кросса/муфты
        $pq_type = $result['type'];
        $pq_num = $result['num'];
        $address = isset($node_id) ? addr_id_full($node_id) : "";
        $descrip = !empty($result['descrip']) ? ' "' . $result['descrip'] . '"' : '';
        if ($result['type'] == 0) {
            $type = 'Кросс';
        } else {
            if ($result['type'] == 1) {
                $type = 'Муфта';
            } else {
                $type = 'Медный';
            }
        }
        if (isset($result['num'])) {
            $num = ' №' . $result['num'];
        } else {
            $num = '';
        }