|
From: <mah...@us...> - 2008-12-15 21:00:39
|
Revision: 363
http://dccss.svn.sourceforge.net/dccss/?rev=363&view=rev
Author: maher_karim
Date: 2008-12-15 21:00:33 +0000 (Mon, 15 Dec 2008)
Log Message:
-----------
Modified Paths:
--------------
branches/ms4w/apps/dccss/query.php
Modified: branches/ms4w/apps/dccss/query.php
===================================================================
--- branches/ms4w/apps/dccss/query.php 2008-12-15 20:58:25 UTC (rev 362)
+++ branches/ms4w/apps/dccss/query.php 2008-12-15 21:00:33 UTC (rev 363)
@@ -49,10 +49,54 @@
$Queryform->addElement('select', 'Table', _('Table:'),$arrTable);
$Queryform->addElement('text', 'searchvalue', _('Enter Search Value:'),
array('size' => 50, 'maxlength' => 128));
+$Queryform->addElement('radio', 'query',_('Query DeliverPoint Number'),'',5);
$Queryform->addElement('radio', 'query',_('Query Meter Number'),'',1);
$Queryform->addElement('radio', 'query',_('Query Subscriber Number'),'',2);
$Queryform->addElement('radio', 'query',_('Query Subscriber name'),'',3);
$Queryform->addElement('radio', 'query',_('Query Meter cabinet'),'',4);
+
+//print_r($_POST);
+/*
+$objArea =&$Queryform->addElement('hierselect', 'area', _('Area:'),
+ array('title' => _('Narrow down the area in which to search for points of interest.')));
+$strQuery = 'select dcmmstranslation(\''.$_SESSION['language'].
+ '\',Name), CodedValue from AdministrativeArea';
+ //print_r($strQuery);
+$arrAdministrativeArea[0] = _('[Select One]');
+$objResult =pg_query($strQuery);
+
+while($arrRow =& pg_fetch_row($objResult)) {
+ $arrAdministrativeArea[$arrRow[1]] = $arrRow[0];
+}
+$strQuery = 'select dcmmstranslation(\''.$_SESSION['language'].
+ '\',Name), Administra, CodedValue from Village where codedvalue in
+ (select village from landmark) order by Administra';
+
+$arrVillage[0][0] = _('[Select One]');
+$objResult =pg_query($strQuery);
+
+$intLast = 0;
+while($arrRow =& pg_fetch_row($objResult)) {
+ if($arrRow[1] != $intLast) {
+ $arrVillage[$arrRow[1]][0] = _('[Select One]');
+ }
+ // $arrVillage[$arrRow[1]][$arrRow[2]] = $arrRow[0];
+ $arrVillage[$arrRow[1]][$arrRow[2]] = $arrRow[0];
+}
+$strQuery = 'select dcmmstranslation(\''.$_SESSION['language'].
+ '\',Name), Administra, village from landmark order by Administra';
+$arrlandmark[0][0][0] = _('[Select One]');
+$objResult =pg_query($strQuery);
+
+$intLast = 0;
+while($arrRow =& pg_fetch_row($objResult)) {
+ if($arrRow[1] != $intLast) {
+ $arrlandmark[$arrRow[1]][0][0] = _('[Select One]');
+ }
+ $arrlandmark[$arrRow[1]][$arrRow[2]][$arrRow[0]] = $arrRow[0];
+}
+$objArea->setOptions(array($arrAdministrativeArea,$arrVillage));
+*/
$Queryform->addElement('submit', null, _('Search The Database'));
// Define filters and validation rules
@@ -80,6 +124,8 @@
$strWhere="name='".$Queryform->exportValue('searchvalue')."'";
} elseif ($Queryform->exportValue('query')==3){
$strWhere="name='".$Queryform->exportValue('searchvalue')."'";
+ } elseif ($Queryform->exportValue('query')==5){
+ $strWhere="sequence='".$Queryform->exportValue('searchvalue')."'";
}
}else{
@@ -98,6 +144,8 @@
$strWhere=" and (deliverypoint.cabinetid='".
$Queryform->exportValue('searchvalue')."' or subscriber.cabinetid='".
$Queryform->exportValue('searchvalue')."')";
+ } elseif ($Queryform->exportValue('query')==5){
+ $strWhere=" and deliverypoint.sequence=".$Queryform->exportValue('searchvalue');
}
}
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|