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

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

Revision: 362
          http://dccss.svn.sourceforge.net/dccss/?rev=362&view=rev
Author:   maher_karim
Date:     2008-12-15 20:58:25 +0000 (Mon, 15 Dec 2008)

Log Message:
-----------


Modified Paths:
--------------
    branches/ms4w/apps/dccss/logbook_report.php

Modified: branches/ms4w/apps/dccss/logbook_report.php
===================================================================
--- branches/ms4w/apps/dccss/logbook_report.php	2008-12-15 20:57:31 UTC (rev 361)
+++ branches/ms4w/apps/dccss/logbook_report.php	2008-12-15 20:58:25 UTC (rev 362)
@@ -19,6 +19,10 @@
  * along with this program; if not, write to the Free Software
  * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  */
+ 
+/*--Script to be used
+create or replace view new_customer as select bill200803_billed .* from bill200803_billed left outer join subscriber on (subscriber.paracode=bill200803_billed.pnr) where subscriber.paracode is null
+*/
 require_once('include/dccsspage.php');
 require_once('include/dcmmspear.php');
 //Required for database connection
@@ -67,9 +71,9 @@
 
 if($Logbookform->validate()) {
   $Logbookform->process($Logbookform, false);
-  $objBill->orderBy('sequence,subsequence');
+  $objBill->orderBy('tr,book_1');
   $objBill->limit($Logbookform->exportValue('batch')*100, 100);
-  $objBill->logbook=$Logbookform->exportValue('logbookno');
+  $objBill->book=$Logbookform->exportValue('logbookno');
   $num_rows = $objBill->find();
   $numCounter = 2;
   while($objBill->fetch()) {
@@ -133,9 +137,9 @@
       <td colspan="3">'._('Survey Date.:').'</td></tr></table>');
     $DccssPage->add('<table class="surveyform">
       <tr><td colspan="3">'._('13.Cabinet No.(PEWSSA) : ').'</td><td colspan="1">'._('14.Meter Number: ').'
-      </td><td colspan="2">'._('15.Meter Reading:').'<b>'.$objBill->meterreading.'</b></td><td>
+      </td><td colspan="2">'._('15.Meter Reading:').'<b>'.$objBill->curr_readi.'</b></td><td>
       </td>
-      <tr><td colspan="3">'._('16.Meter location Code:').'<b>'.$objBill->meterlocation.'</b></td><td colspan="1">'.
+      <tr><td colspan="3">'._('16.Meter location Code:').'<b>'.$objBill->meter_site.'</b></td><td colspan="1">'.
       _('17.Connection Before Meter:').
       '</td><td><input type="checkbox"/>'._('Yes').'<input type="checkbox"/>'.
       _('No').'</td></tr>
@@ -143,7 +147,7 @@
       _('Yes').'<input
       type="checkbox" />'._('No').'</td><td>'._('19.Flat No.:').'</td><td>'.
       _('20.Floor No.:').
-      '</td><td>'._('21.Meter No.(logbook):').'<b>'.$objBill->meternumber.'</b></td></tr>
+      '</td><td>'._('21.Meter No.(logbook):').'<b>'.$objBill->num.'</b></td></tr>
       <tr><td>'._('22.Meter Type:').'
       </td><td colspan="4"><input type="checkbox"
       />'._(' Defence Factories ').'| <input type="checkbox"/>'._('Legal Connection').
@@ -163,14 +167,14 @@
       <tr><td>'._('25.Leakage:').'</td><td colspan="4"><input type="checkbox"
       />'._(' None ').'| <input type="checkbox"/>'._(' Minor ').'| <input type="checkbox"/>'.
       _(' Major ').'</td></tr>
-      <tr><td colspan="3">'._('26.Logbook No.:').' '.$objBill->logbook.'
-      </td><td>'._('27.Sequence:').' '.$objBill->sequence.'/'.$objBill->subsequence.'</td><td>
+      <tr><td colspan="3">'._('26.Logbook No.:').' '.$objBill->book.'
+      </td><td>'._('27.Sequence:').' '.$objBill->tr.'/'.$objBill->book_1.'</td><td>
             '._('28.Subscription No.:').''.
-      $objBill->subscribernumber.'</td></tr>
+      $objBill->account_nu.'</td></tr>
       <tr><td colspan="4">'._('29.Subscriber is the Owner:').'<input type="checkbox" /> '.
       _(' Yes ').'<input
       type="checkbox" /> '._(' No ').'
-      </td><td>'._('30.Name:').' '.$objBill->name.'</td></tr>
+      </td><td>'._('30.Name:').' '.$objBill->full_name.'</td></tr>
       <tr><td>'._('31.Type of use:').'</td><td colspan="4">
       <input type="checkbox" /> '._('Domestic').'
       | <input type="checkbox" /> '._('Hospital').'


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.