$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"> Узел "' . clean($_GET['addr']) . '" не пустой. Перед удалением узла необходимо удалить пассивное оборудование!!!</div> <div class="span1 toolbar m0"> <button class="icon-blocked m0" id="exit" title="Отмена"></button> </div>';
//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 = ''; }