<?php
$_REQUEST['schema'] = "svendborg";
$_REQUEST['formid'] = "115770004835770";
$table = new table("{$_REQUEST['schema']}.tforms{$_REQUEST['formid']}_join");
$table->execQuery("set client_encoding='UFT8'", "PDO");
$query = "SELECT {$_REQUEST['schema']}.tforms{$_REQUEST['formid']}_join.*,public.save_check.ok FROM {$_REQUEST['schema']}.tforms{$_REQUEST['formid']}_join LEFT JOIN public.save_check ON public.save_check.irowid={$_REQUEST['schema']}.tforms{$_REQUEST['formid']}_join.irowid ORDER by public.save_check.irowid, {$_REQUEST['schema']}.tforms{$_REQUEST['formid']}_join.adresse LIMIT 100000000";
$result = $table->execQuery($query);
$rows = $table->fetchAll($result, "assoc");
//print_r($rows);
<?php
$table = new table("{$_REQUEST['schema']}.tforms{$_REQUEST['formid']}_join");
$table->execQuery("set client_encoding='UTF8'", "PDO");
$response = $table->getRecords(NULL, "*", "irowid='{$_REQUEST['id']}'");
$row = $response['data'][0];
if (empty($row)) {
die("empty");
}
//print_r($row);
$checkTable = new table("public.save_check");
$checkTable->execQuery("set client_encoding='UTF8'", "PDO");
$checkResponse = $checkTable->getRecords(NULL, "*", "irowid={$_REQUEST['id']}");
$checkRow = $checkResponse['data'][0];
//print_r($checkRow);
include 'libs/FirePHPCore/fb.php';
include 'model/tables.php';
$postgisdb = $parts[3];
$table = new table("vandforsyningsplan.anlaeg_join");
$table->execQuery("set client_encoding='LATIN1'", "PDO");
$response = $table->getRecords(NULL, "*", "id='{$_REQUEST['id']}'");
$row = $response['data'][0];
$response = $table->getRecords(NULL, "id,navn_paa_vandvaerk,html", "overordnet_id='{$row['overordnet_id']}'");
$rowOverordnet = $response['data'];
//print_r($rowOverordnet);
$table = new table("vandforsyningsplan.boringer");
$table->execQuery("set client_encoding='LATIN1'", "PDO");
$response = $table->getRecords(NULL, "*", "plant_id='{$_REQUEST['id']}'");
$rowBoringer = $response['data'];
//print_r($rowBoringer);
$table = new table("vandforsyningsplan.maengde");
$table->execQuery("set client_encoding='LATIN1'", "PDO");
$table->execQuery("set datestyle TO SQL,DMY", "PDO");
//$response = $table->getRecords(NULL,"*","plantid='{$_REQUEST['id']}' AND startdate::date>='01/01/2010'");
$response = $table->getRecords(NULL, "*", "plantid='{$row['overordnet_id']}'");
$rowMaengde = $response['data'];
$i = 0;
foreach ($rowMaengde as $value) {
if (is_int($i / 2)) {
$year[] = $value['time'];
} else {
$year[] = "";
}
$amount[] = $value['amount'];
$i++;
}
<?php
include "inc/lp_fields.php";
include "inc/lp_ref.php";
$table = new table("lokalplaner.lpplandk2_join");
$table->execQuery("set client_encoding='LATIN1'", "PDO");
$response = $table->getRecords(NULL, "*", "planid='{$_REQUEST['planid']}'");
$row = $response['data'][0];
$table = new table("lokalplaner.lpdelplandk2_join");
$table->execQuery("set client_encoding='LATIN1'", "PDO");
$response = $table->getRecords(NULL, "*", "lokplan_id='{$_REQUEST['planid']}'");
$rowsLpDel = $response['data'];
if (!is_array($rowsLpDel)) {
$rowsLpDel = array();
}
//print_r($rowsLpDel);
<?php
include "html_header.php";
include "inc/lp_fields.php";
include "inc/lp_ref.php";
$table = new table("lokalplaner.lpplandk2_join");
$table->execQuery("set client_encoding='latin1'", "PDO");
$response = $table->getRecords(null, "*", "plannr='{$_REQUEST['plannr']}'");
//print_r($response['data'][0]);
$row = $response['data'][0];
if (empty($row)) {
die;
}
/*
$table = new table("public.lpdelplandk2_join");
$response = $table->getRecords("lokplan_id='{$_REQUEST['planid']}'");
print_r($response['data']);
$rowsLpDel = $response['data'];
*/
$postgisObject = new postgis();
//$postgisObject->execQuery("set client_encoding='latin1'","PG");
$query = "SELECT * FROM lokalplaner.lpdelplandk2_join where lokplan_id='" . $row["planid"] . "' order by delnr";
//echo $query;
$result = $postgisObject->execQuery($query, "PG");
$rowsLpDel = pg_fetch_all($result);
if (!is_array($rowsLpDel)) {
$rowsLpDel = array();
}
$i = 1;
?>
<!DOCTYPE html>
