[Dcmms-devel] SF.net SVN: dcmms: [1133] branches/ms4w/dcmms
Brought to you by:
maher_karim,
sdteffen
From: <sdt...@us...> - 2006-08-11 19:02:26
|
Revision: 1133 Author: sdteffen Date: 2006-08-11 12:02:14 -0700 (Fri, 11 Aug 2006) ViewCVS: http://svn.sourceforge.net/dcmms/?rev=1133&view=rev Log Message: ----------- Removed file/folder Removed Paths: ------------- branches/ms4w/dcmms/seal.php branches/ms4w/dcmms/search.php branches/ms4w/dcmms/team_report.php branches/ms4w/dcmms/workorder_status_report.php branches/ms4w/dcmms/workorderlist.php Deleted: branches/ms4w/dcmms/seal.php =================================================================== --- branches/ms4w/dcmms/seal.php 2006-08-11 19:00:24 UTC (rev 1132) +++ branches/ms4w/dcmms/seal.php 2006-08-11 19:02:14 UTC (rev 1133) @@ -1,136 +0,0 @@ -<?php -/* DCMMS -- DC Maintenance Management System - * - * seal.php - Record information on broken meter seals. - * - * Copyright (C) 2004, 2005 DORSCH Consult - * - * This program is free software; you can redistribute it and/or modify - * it under the terms of the GNU General Public License as published by - * the Free Software Foundation; either version 2 of the License, or - * (at your option) any later version. - * - * This program is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - * GNU General Public License for more details. - * - * You should have received a copy of the GNU General Public License - * along with this program; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. - */ - -require_once("include/dcmmspage.php"); -require_once("include/dcmpostgis.php"); -require_once("include/dcmmspear.php"); -require_once("HTML/QuickForm.php"); -require_once("DB/DataObject/FormBuilder.php"); -require_once("DB/DataObject.php"); -require_once("DB/common.php"); -require_once("PEAR.php"); - -$dcmPage = new DcmmsPage(_("Unsealed")); -/** - * \todo Adjust icon. - */ -$dcmPage->setIconImage("team_management.png"); -$dcmPage->setPageName(basename(__FILE__)); - -$options = &PEAR::getStaticProperty("DB_DataObject", "options"); -$config = parse_ini_file("conf/dataobject.ini", TRUE); -/** - * \todo Refactor - */ -$options = $config["DB_DataObject"]; -$_DB_DATAOBJECT_FORMBUILDER["CONFIG"] = $config["DB_DataObject_FormBuilder"]; -$options["database"] = "pgsql://".$_SESSION["UserName"].":". - $_SESSION["Password"]."@"."localhost/".$_SESSION["strDataBase"]; -/** - * Set up DB_DataObject config settings. - */ -$do =& DB_DataObject::factory('seal'); - -$blnShowform = false; - -if(isset($_REQUEST['action'])){ - if(PEAR::isError($do)or(null == $do)) { - die($do->getMessage()); - } - switch($_REQUEST["action"]) { - case "edit": - $do->get($_REQUEST["id"]); - $blnShowform = true; - break; - case "insert": - if(isset($_REQUEST['WorkorderID'])) { - $do->maintenanceoid = $_REQUEST['WorkorderID']; - if($do->insert()) {; - $blnShowform = true; - } - } - break; - default: - break; - } -} - -if(isset($_REQUEST["WorkorderID"])&&($_REQUEST["WorkorderID"] != 0)) { - $_SESSION["WorkorderID"] = $_REQUEST["WorkorderID"]; -} - -if($blnShowform) { - $dcmPage->add(_("Unseal information for maintenance record : "). - '<a href="maintenance.php?page=resource&id='. - $_SESSION['WorkorderID'].'&action=viewworkorder&PHPSESSID='.session_id(). - '">'.$_SESSION['WorkorderID'].'</a>'); - -$dcmPage->add('<p><a href="'.basename(__FILE__). - '?action=queryrecord&WorkorderID='.$_SESSION['WorkorderID'].'">'. - _('Show Unsealed Meters').'</a></p>'); - -$formBuilder = DB_DataObject_FormBuilder::create($do); - -$form = $formBuilder->getForm(); -if($form->validate()){ - $form->process(array(&$formBuilder, 'processForm'), false); -} -if(isset($_SESSION['WorkorderID'])) { - $form->setDefaults(array('maintenanceoid' => $_SESSION['WorkorderID'])); -} -$form->addElement("hidden", "action", "edit"); -$dcmPage->add($form->toHtml()); -} else { - $dcmPage->add(_("Unseal information for maintenance record : "). - "<a href=\"maintenance.php?page=resource&id=". - $_SESSION["WorkorderID"]."&action=viewworkorder&PHPSESSID=".session_id(). - "\">".$_SESSION["WorkorderID"]."</a>"); - - $dcmPage->add("<p><a href=\"".basename(__FILE__)."?action=insert&WorkorderID=". - $_SESSION["WorkorderID"]."\">"._("Unseal Meter")."</a></p>"); - - $query = "select ID, Reason, Responsible, SubscriberOID, SerialNumber from Seal "; - if((isset($_REQUEST['action']))&&(isset($_REQUEST['WorkorderID']))&& - ('queryrecord' == $_REQUEST['action'])&&($_REQUEST['WorkorderID']!=0)) { - $query = $query." where MaintenanceOID = ".$_REQUEST["WorkorderID"]; - $_SESSION["WorkorderID"] = $_REQUEST["WorkorderID"]; - } - $objDbTablePager = new DbTablePager($dcmPage->postgis->db, $query); - $objDbTablePager->addRows(); - $objDbTablePager->setCellContents(0, 0, _("ID"), "TH"); - $objDbTablePager->setCellContents(0, 1, _("Reason"), "TH"); - $objDbTablePager->setCellContents(0, 2, _("Responsible"), "TH"); - $objDbTablePager->setCellContents(0, 3, _("Subscriber #"), "TH"); - $objDbTablePager->setCellContents(0, 4, _("Serial Number"), "TH"); - $objDbTablePager->setCellContents(0, 5, _("Action"), "TH"); - $intRowCount = $objDbTablePager->getRowCount(); - for($intI = 1; $intI < $intRowCount; $intI++) { - $strID = $objDbTablePager->getCellContents($intI, 0); - $objDbTablePager->setCellContents($intI, 5, - "<a href=\"".basename(__FILE__)."?action=edit&id=$strID&WorkorderID=". - $_REQUEST["WorkorderID"]."\">"._("Edit")."</a>"); - } - $dcmPage->add($objDbTablePager->toHtml()); -} -$dcmPage->setCvsDate("$Date$Empty"); -echo($dcmPage->toHtml()); -?> Deleted: branches/ms4w/dcmms/search.php =================================================================== --- branches/ms4w/dcmms/search.php 2006-08-11 19:00:24 UTC (rev 1132) +++ branches/ms4w/dcmms/search.php 2006-08-11 19:02:14 UTC (rev 1133) @@ -1,42 +0,0 @@ -<?php -/** - * DCMMS -- DC Maintenance Management System - * - * search.php - Search page redirecting workorder and landmark searches. - * - * Copyright (C) 2005 DORSCH Consult - * - * This program is free software; you can redistribute it and/or modify - * it under the terms of the GNU General Public License as published by - * the Free Software Foundation; either version 2 of the License, or - * (at your option) any later version. - * - * This program is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - * GNU General Public License for more details. - * - * You should have received a copy of the GNU General Public License - * along with this program; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. - */ - -/** - * \todo Actually perform the search here. - * \todo If landmark query has one hit, user should be forwarded to map page. - * \todo Avoid forwarding whenever possible. - * \todo Search plug-ins. - */ -if(isset($_REQUEST['WorkorderID'])) { - session_start(); - if(is_numeric($_REQUEST['WorkorderID'])) { - header('Location: query_workorder_status.php?WorkorderID='. - $_REQUEST['WorkorderID']); - } else { - header('Location: zoom.php?name='.$_REQUEST['WorkorderID']); - } -} else { - echo('FATAL ERROR: No WorkorderID provided'); -} - -?> Deleted: branches/ms4w/dcmms/team_report.php =================================================================== --- branches/ms4w/dcmms/team_report.php 2006-08-11 19:00:24 UTC (rev 1132) +++ branches/ms4w/dcmms/team_report.php 2006-08-11 19:02:14 UTC (rev 1133) @@ -1,43 +0,0 @@ -<?php -/* DCMMS -- DC Maintenance Management System - * - * team_report.php - List maintenance teams. - * - * Copyright (C) 2005 NGWA, DORSCH Consult - * - * This program is free software; you can redistribute it and/or modify - * it under the terms of the GNU General Public License as published by - * the Free Software Foundation; either version 2 of the License, or - * (at your option) any later version. - * - * This program is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - * GNU General Public License for more details. - * - * You should have received a copy of the GNU General Public License - * along with this program; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. - */ - -require_once('include/dcmmspage.php'); -require_once('include/dcmpostgis.php'); -require_once('include/dcmmspear.php'); -require_once('HTML/Table.php'); - -$dcmPage = new DcmmsPage(_('Team Report')); - -$dcmPage->setIconImage('documents.png'); - -$dcmPage->add('<p>'.sprintf( - _('A %sReport%s listing all maintenance teams.'), - '<a href="reports.php">', '</a>').'</p>'); -$strQuery = 'select * from TeamView'; -$objTable = new DbTable($dcmPage->postgis->db, $strQuery); -$objTable->addRows(); -/** - * TODO: better layout, i18n - */ -$dcmPage->add($objTable->toHtml()); -$dcmPage->setCvsDate("$Date$Empty"); -echo($dcmPage->toHtml()); ?> Deleted: branches/ms4w/dcmms/workorder_status_report.php =================================================================== --- branches/ms4w/dcmms/workorder_status_report.php 2006-08-11 19:00:24 UTC (rev 1132) +++ branches/ms4w/dcmms/workorder_status_report.php 2006-08-11 19:02:14 UTC (rev 1133) @@ -1,97 +0,0 @@ -<?php -/* DCMMS -- DC Maintenance Management System - * - * workorder_status_report.php - Summary of pending workorders - * - * Copyright (C) 2003 DORSCH Consult, Northern Governorates Water Administration - * Copyright (C) 2006 DC Water and Environment - * - * This program is free software; you can redistribute it and/or modify - * it under the terms of the GNU General Public License as published by - * the Free Software Foundation; either version 2 of the License, or - * (at your option) any later version. - * - * This program is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - * GNU General Public License for more details. - * - * You should have received a copy of the GNU General Public License - * along with this program; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. - */ - -@include("include/header.php"); -include("include/dcmpostgis.php"); - -$dcmPage = new DcmPage(basename(__FILE__)); - -$dcmPage->header(_("Workorder Status Report"),TRUE,"","documents.png"); -echo("<img class=\"org_logo_report\" src=\"".$_SESSION["OrgLogoSmall"]. - "\" border=\"0\" alt=\"Organization Logo\" />"); -echo("<p>".sprintf( - _("A DCMMS %sReport%s summarizing the workorder status for a period of time.") - ,"<a href=\"reports.php\">","</a>")."</p>"); -$strHeader2 = _("Querying all DCMMS records"); -if((array_key_exists("FromDate",$_POST))&&(array_key_exists("ToDate", -$_POST))&&($_POST["FromDate"]!="")&&($_POST["ToDate"]!="")) { - $query = 'select dcmmstranslation(\''.$_SESSION['language']. - '\', Workordersubtype.Description), 2*count(*)-sum(status) as '. - 'pending, sum(status)-count(*) as completed, count(*) from workorder - left join WorkorderSubtype on Workorder.Subtype = WorkorderSubtype.Subtype - left join Maintenance on Workorder.ID = Maintenance.ID where '. - "receiveddate > '".$_POST["FromDate"]."' and receiveddate < '".$_POST["ToDate"]."'"; - - // echo($query); - $strHeader2 = sprintf(_("Period from %s to %s"), $_POST["FromDate"], - $_POST["ToDate"]); -} else { - $query = 'select dcmmstranslation(\''.$_SESSION['language']. - '\', WorkorderSubtype.Description) as Type, 2*count(*)-sum(Status) as - Pending, sum(Status)-count(*) as Completed, Count(*) from Workorder - left join WorkorderSubtype on Workorder.Subtype = WorkorderSubtype.Subtype - left join Maintenance on Workorder.ID = Maintenance.ID'; -} -$strAdministra = ""; -if ((array_key_exists("AdministrativeArea",$_POST)) && ($_POST["AdministrativeArea"] !=0)){ - $strAdministra = " and administrativearea = ".$_POST["AdministrativeArea"]; -} - $query = $query.$strAdministra.' group by dcmmstranslation(\''. - $_SESSION['language'].'\', WorkorderSubtype.Description)'; - // echo ($query); - ?> -<form name="workorderstatus" action="workorder_status_report.php?PHPSESSID="<?= - session_id() ?>" method="POST"> -<table summary="workorderstatus"> <?php - -$strAdministra = ""; - -// AdministrativeArea -$Adminquery = "select distinct Landmark.Administra, ". - pg_localize('Name', 'AdministrativeArea'). - " from AdministrativeArea, Landmark where Landmark.Administra = ". - "AdministrativeArea.CodedValue".$strAdministra; -//echo($query); -$result = pg_exec($Adminquery); -$arrResult = array(); -while($arrRow = pg_fetch_row($result)) { - array_push($arrResult, $arrRow); -} - -$dcmPage->printSelect("AdministrativeArea", $arrResult, $_POST, - _("Query for landmarks in this region.")); - -$dcmPage->printTextInput("FromDate", $_POST, $dcmPage->getTimeStamp("", "", 1), - _("Insert the report period starting date.")); -$dcmPage->printTextInput("ToDate", $_POST, $dcmPage->getTimeStamp(), - _("Insert the report period ending date.")); - - ?> - -</table> - <input type="submit" name="submit" value="<?=_("Create Report")?>" - title="<?= _('Click this button to create the report.') ?>"/> -</form> -<h2><?= $strHeader2 ?></h2> <?php -$dcmPage->printTable("Complaints", $query); -$dcmPage->footer("$Date$Empty"); ?> Deleted: branches/ms4w/dcmms/workorderlist.php =================================================================== --- branches/ms4w/dcmms/workorderlist.php 2006-08-11 19:00:24 UTC (rev 1132) +++ branches/ms4w/dcmms/workorderlist.php 2006-08-11 19:02:14 UTC (rev 1133) @@ -1,289 +0,0 @@ -<?php -/* DCMMS -- DC Maintenance Management System - * - * workorderlist.php - Display and filter lists of workorder records. - * - * Copyright (C) 2003 - 2004 DORSCH Consult, NGWA - * Copyright (C) 2005 DORSCH Consult - * - * This program is free software; you can redistribute it and/or modify - * it under the terms of the GNU General Public License as published by - * the Free Software Foundation; either version 2 of the License, or - * (at your option) any later version. - * - * This program is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - * GNU General Public License for more details. - * - * You should have received a copy of the GNU General Public License - * along with this program; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. - */ - -/** - * \todo Delete action. - * \todo Avoid redirection. - */ -require_once('include/dcmmspage.php'); -require_once('include/dcmmspear.php'); -require_once('Pager/Pager.php'); -require_once('DB/DataObject.php'); -require_once('DB/DataObject/FormBuilder.php'); -require_once('HTML/QuickForm/Renderer/Default.php'); - -$dcmPage = new DcmmsPage(_('Workorder')); -$dcmPage->setIconImage('todo.png'); -$dcmPage->setPageName(basename(__FILE__)); -if(!isset($_REQUEST['action'])) { - $_REQUEST['action'] = 'list'; -} - -/** - * Determine workorder status - */ -$intStatus = 1; -switch($_REQUEST["action"]) { - case "list" : - if(array_key_exists("status", $_REQUEST) && $_REQUEST["status"] == 2) { - $intStatus = 2; - } elseif (array_key_exists("status", $_REQUEST) && $_REQUEST["status"] == 2) { - $intStatus = 3; - } else { - $intStatus = 1; - } - break; - case "view" : - case "edit" : - $arrWorkorderRecord = array(); - $strQuery = $strQuery = "select ID,Complainant, Subtype, Telephone,". - " LocationDescription, Status, ". - $dcmPage->postgis->formatTimestamp("ReceivedDate"). - " as ReceivedDate, Note, AdministrativeArea, Team, DcmmsUser, Network". - " from Workorder where ID="; - if((array_key_exists("NewWorkorderID", $_SESSION)) && - ($_SESSION["NewWorkorderID"] != "")) { - $strQuery = $strQuery.$_SESSION["NewWorkorderID"]; - } else { - $strQuery = $strQuery.$_REQUEST["WorkorderID"]; - } - //echo($strQuery); - $objResult = pg_query($strQuery); - if($objResult) { - $arrWorkorderRecord = pg_fetch_assoc($objResult); - $intStatus = $arrWorkorderRecord['status']; - } - break; -} -/** - * Display tabs. - */ -if(2 == $intStatus) { - $dcmPage->add('<a href="'.basename(__FILE__).'?PHPSESSID='.session_id(). - '&action=list&status=1" class="tab_one_inactive">'); -} else { - $dcmPage->add('<span class="tab_one">'); -} -$dcmPage->add(_('Pending')); -if(2 == $intStatus) { - $dcmPage->add('</a>'); -} else { - $dcmPage->add('</span>'); -} -$dcmPage->add(' '); -if(1 == $intStatus) { - $dcmPage->add('<a href="'.basename(__FILE__).'?PHPSESSID='.session_id(). - '&action=list&status=2" class="tab_one_inactive">'); -} else { - $dcmPage->add('<span class="tab_one">'); -} -$dcmPage->add(_('Completed')); -if(1 == $intStatus) { - $dcmPage->add('</a>'); -} else { - $dcmPage->add('</span>'); -} -$boolFormDisabled = false; -/** - * Handle request actions. - */ -switch($_REQUEST['action']) { - case 'list' : - /** - * List workorders. - */ - $strWhere = "workorder.subtype = workordersubtype.Subtype and ". - " Maintenance.status=".$_REQUEST["status"]; - /** - * Ensure full maps in print_workorder.php - */ - $_SESSION["gravitymain"] = "Y"; - $_SESSION["pressurizedmain"] = "Y"; - - $query = 'select count(*) from Workorder - left join WorkorderSubtype on Workorder.Subtype=WorkorderSubtype.Subtype - left join Maintenance on Workorder.ID = Maintenance.ID where '.$strWhere; - $result = pg_exec($query); - $arrRow = pg_fetch_array($result, 0); - $params['totalItems'] = $arrRow[0]; - $params['perPage'] = 10; - $params['nextImg'] = _('Next >>'); - $params['prevImg'] = _('<< Back'); - $pager =& Pager::factory($params); - $data = $pager->getPageData(); - $links = $pager->getLinks(); - list($from, $to) = $pager->getOffsetByPageId(); - /** - * \todo Adjust table to data model. - */ - $query = 'select Workorder.ID as WorkorderID, - workorder.complainant, dcmmstranslation(\''.$_SESSION['language']. - '\', WorkorderSubtype.Description) as Type - from Workorder - left join WorkorderSubtype on Workorder.Subtype = WorkorderSubtype.Subtype - left join Maintenance on Workorder.ID = Maintenance.ID - where '.$strWhere. - ' order by Workorder.ID desc'; - //echo($query); - $arreActions = array('Map' => - basename(__FILE__).'?PHPSESSID='. - session_id().'&action=map&WorkorderID=', - 'View' => 'workorderpage.php?'. - 'PHPSESSID='.session_id().'&action=view&id=', - 'Print' => 'print_workorder.php?PHPSESSID='.session_id(). - '&action=print&WorkorderID=', "Maintenance"=>"maintenance.php?". - "PHPSESSID=".session_id()."&action=viewworkorder&id=", - "Resource"=>"resource.php?table=Staff&PHPSESSID=".session_id(). - "&action=select_workorder&WorkorderID=" - ); - if(2 == $_REQUEST["status"]) { - $arreActions = array_merge($arreActions, $arrCompletedActions); - } - $objDbTablePager = new DbTablePager($dcmPage->postgis->db, $query, - array('class' => 'tab_one_panel')); - $objDbTablePager->addRows(); - $objDbTablePager->setCellContents(0, 0, _('ID'), 'TH'); - $objDbTablePager->setCellContents(0, 1, _('Complainant'), 'TH'); - $objDbTablePager->setCellContents(0, 2, _('Type'), 'TH'); - $objDbTablePager->setCellContents(0, 3, _('Action'), 'TH'); - $intRowCount = $objDbTablePager->getRowCount(); - /** - * Localize types - * \todo Switch to database side translation. - */ - for($intI = 1; $intI < $intRowCount; $intI++) { - $objDbTablePager->setCellContents($intI, 2, - _($objDbTablePager->getCellContents($intI, 2))); - } - /** - * Add actions - */ - - for($intI = 1; $intI < $intRowCount; $intI++) { - $strID = $objDbTablePager->getCellContents($intI, 0); - $strActionHtml = ''; - foreach($arreActions as $strActionName => $strActionUrl) { - $strActionHtml .= '<a href="'.$strActionUrl.$strID.'">'. - _($strActionName).'</a> '; - } - $objDbTablePager->setCellContents($intI, 3, $strActionHtml); - } - $dcmPage->add($objDbTablePager->toHtml()); - break; - case 'view' : - /** - * View one workorder. - */ - case 'edit' : - /** - * Edit or view one workorder. - * \todo Refactor this (e.g. DcmmsDataObjectPage). - */ - $options = &PEAR::getStaticProperty('DB_DataObject', 'options'); - $config = parse_ini_file('conf/dataobject.ini', TRUE); - $options = $config['DB_DataObject']; - $_DB_DATAOBJECT_FORMBUILDER['CONFIG'] = - $config['DB_DataObject_FormBuilder']; - $options['database'] = 'pgsql://'.$_SESSION['UserName'].':'. - $_SESSION['Password'].'@'.'localhost/'.$_SESSION['strDataBase']; - - $objWorkorder = DB_DataObject::factory('Workorder'); - if(PEAR::isError($objWorkorder)or(NULL == $objWorkorder)) { - die($objWorkorder->getMessage()); - } - if(!$objWorkorder->get($_REQUEST['WorkorderID'])) { - die(sprintf(_('Could not retrieve record for workorder #%s.'), - $_REQUEST['WorkorderID'])); - } - if(PEAR::isError($objWorkorder)or(NULL == $objWorkorder)) { - die($objWorkorder->getMessage()); - } - $objWorkorderBuilder = DB_DataObject_FormBuilder::create($objWorkorder); - if(PEAR::isError($objWorkorderBuilder)) { - die($objWorkorderBuilder->getMessage()); - } - $objWorkorderForm = $objWorkorderBuilder->getForm(); - if($objWorkorderForm->validate()) { - if($objWorkorderForm->process(array(&$objWorkorderBuilder, - 'processForm'), false)) { - header('Location: '.basename(__FILE__).'?message='. - urlencode(_('Successfully updated the workorder record.'))); - } else { - $dcmPage->add('<p class="important">'. - _('Failed to update the workorder record.').'</p>'); - } - } - /** - * Come back to the data entry form. - */ - $objWorkorderForm->addElement("hidden", "action", "edit"); - $objRenderer =& new HTML_QuickForm_Renderer_Default(); - $objRenderer->setFormTemplate( - "\n<form{attributes}>\n<table class=\"tab_one_panel\">\n{content}\n</table></form>"); - $objWorkorderForm->accept($objRenderer); - - $dcmPage->add($objRenderer->toHtml()); - - break; - case "map" : - $query = "select box3d(shape),StartPoint(shape) from workorder where id=". - $_REQUEST["WorkorderID"]; - $_SESSION["WorkorderID"]=$_REQUEST["WorkorderID"]; - $result = pg_query($query); - $numrows = pg_numrows($result); - for($i=0; $i<$numrows;$i++) { - $r = pg_fetch_row($result, $i); - $box3d = $r[0]; - $box3d = str_replace("BOX3D(", "", $box3d); - $token = strtok($box3d, " "); - $minx = $token; - $token = strtok(" "); - $miny = $token; - $token = strtok(","); - $token = strtok(" "); - $maxx = $token+1; - $token = strtok(" "); - $maxy = $token+1; - } - /** - * Remember the WorkorderID if it exists. - */ - $strWorkorderID = ""; - if(array_key_exists("WorkorderID", $_REQUEST)) { - $strWorkorderID = "&WorkorderID=".$_REQUEST["WorkorderID"]; - } - header("location: map.php?PHPSESSID=".$_REQUEST["PHPSESSID"]. - "&gravitymain=Y&pressurizedmain=Y&ViewRegion=Quick+". - "View&minx=$minx&miny=$miny&maxx=$maxx&maxy=$maxy&imagewidth=400&". - "imageheight=300&CMD=ADD_REPAIR". - "&KEYMAPXSIZE=120&KEYMAPYSIZE=66&MapSize=400%2C300&PREVIOUS_MODE=1". - $strWorkorderID); - if(isset($dbconnect)) { - pg_close ($dbconnect); - } - break; -} - -$dcmPage->setCvsDate("$Date$Empty"); -echo($dcmPage->toHtml()); -?> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |