[Dccss-commit] SF.net SVN: dccss:[363] branches/ms4w/apps/dccss/query.php

[<mah...@us...>]

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.