function fetch_form_list($uid) { global $form_list; global $form_list_size; // permissions should be incorporated here $sql_str = "SELECT " . "tng_form.form_id, " . "tng_form.form_name " . "FROM " . "tng_form " . "INNER JOIN tng_process_form_permissions ON tng_form.form_id = tng_process_form_permissions.form_id " . "WHERE " . "tng_process_form_permissions.uid = " . $_SESSION['obj_login']->uid . " "; $dbconn = new DBConn(); $dbconn->connect(); $result = pg_query($dbconn->conn, $sql_str); if (!$result) { echo "An error occurred while executing the query " . pg_last_error($dbconn->conn); $dbconn->disconnect(); } else { // successfuly ran the query $form_list_size = pg_num_rows($result); // fill the array with the form ids and form names. // each element in the form_list array is an array // of two elements. for ($i = 0; $i < $form_list_size; $i++) { $form_list[$i] = array(pg_fetch_result($result, $i, 0), pg_fetch_result($result, $i, 1)); } } $dbconn->disconnect(); }
function get_form_id($submission_id) { $sql_str = "SELECT " . "form_id " . "FROM " . "tng_form_submission " . "WHERE form_submission_id = " . $submission_id; $dbconn = new DBConn(); if ($dbconn == NULL) { die('Could not create connection object'); } $dbconn->connect(); $result = pg_query($dbconn->conn, $sql_str); if (!$result) { echo "An error occurred while executing the query - " . $sql_str . " - " . pg_last_error($dbconn->conn); $dbconn->disconnect(); return false; } $form_id = pg_fetch_result($result, 0, 0); $dbconn->disconnect(); return $form_id; }
} $feature_defn = OGR_L_GetLayerDefn($src_layer); /*---------------------------------------------------------------------------------------*/ /* this is done to find out the geometry type only - should be moved to its own function */ $feature = OGR_L_GetNextFeature($src_layer); $geometry = OGR_F_GetGeometryRef($feature); $geom_type = strtolower(OGR_G_GetGeometryName($geometry)); // execute sql command using form id to find out spatial table name and attribute table // namme $sql_str = "SELECT " . "tng_spatial_data.table_name, " . "tng_spatial_attribute_table.attr_table_name " . "FROM " . "tng_form_spatial_data " . "INNER JOIN tng_spatial_data ON tng_form_spatial_data.spatial_table_id = tng_spatial_data.spatial_table_id " . "INNER JOIN tng_spatial_attribute_table on tng_form_spatial_data.spatial_table_id = tng_spatial_attribute_table.spatial_table_id " . "WHERE " . "tng_form_spatial_data.form_id = 1 " . "AND " . "tng_spatial_data.geometry_type = '" . $geom_type . "'"; $dbconn = new DBConn(); $dbconn->connect(); $result = pg_query($dbconn->conn, $sql_str); if (!$result) { echo "An error occurred while executing the query - class_form.php:47 " . pg_last_error($dbconn->conn); $dbconn->disconnect(); } else { $dst_layer_name = pg_fetch_result($result, 0, 0); $dst_attr_table_name = pg_fetch_result($result, 0, 1); $dbconn->disconnect(); } /* end find geometry type */ /*---------------------------------------------------------------------------------------*/ /* get the handle for the destination layer */ $dst_layer = OGR_DS_GetLayerByName($dst_ds, $dst_layer_name); if ($dst_layer == NULL) { echo "could not create a handle for " . $dst_layer_name; exit; } echo "<br> dst layer : " . $dst_layer_name . "<br>"; OGR_L_ResetReading($src_layer);