Changeset 312

Timestamp:

10/04/07 14:05:01

Author:

brieb

Message:

Fixed minor update problems.
Fixed invalid stylesheet definitions.
Added potential windows servers nl_langinfo workaround.

Files:

• trunk/phpbms/common/stylesheet/mozilla/forms.css (modified) (1 diff)
• trunk/phpbms/common/stylesheet/mozilla/pages/snapshot.css (modified) (1 diff)
• trunk/phpbms/include/common_functions.php (modified) (1 diff)
• trunk/phpbms/install/update.php (modified) (1 diff)
• trunk/phpbms/install/updatev0.9.sql (modified) (1 diff)
• trunk/phpbms/modules/bms/include/clients_credit.php (modified) (7 diffs)
• trunk/phpbms/modules/bms/include/receipts.php (modified) (5 diffs)
• trunk/phpbms/modules/bms/install/paymentmethods.sql (modified) (1 diff)
• trunk/phpbms/modules/bms/install/relationships.sql (modified) (1 diff)
• trunk/phpbms/modules/bms/install/updatev0.90.sql (modified) (1 diff)
• trunk/phpbms/modules/bms/report/aritems_clientstatement.php (modified) (1 diff)
• trunk/phpbms/modules/bms/snapshot.php (modified) (2 diffs)
• trunk/phpbms/modules/sample/include/sampletable.php (modified) (1 diff)

trunk/phpbms/common/stylesheet/mozilla/forms.css

@@ -9 +9 @@
-        vertical-align: middle; 
-        font-style:normal;
+        foo:1pxl;
-}
-SELECT{padding:0 0 0 3px;}

trunk/phpbms/common/stylesheet/mozilla/pages/snapshot.css

@@ -82 +82 @@
-#eventsBox h2{margin:0; padding:4px 0 4px;}
-#eventsBox #eventsList table{border-collapse:collapse;}
-
-
+
+
+
+
+
+
+
+
+
+
-        font-weight:bold;
-        padding:4px;
-
-
+
+
+
+
+
+
-
-#eventButtons {

trunk/phpbms/include/common_functions.php

@@ -576 +576 @@
-        return $value;
-}
+
+
+//for windows servers, we have no define time constants and nl_langinfo function
+//in a limited fashion; some windows servers still show that the function
+//exists even though it's not implemented, thus the second check;
+
+$nl_exists = function_exists("nl_langinfo");
+if($nl_exists)
+        $nl_exists = @ nl_langinfo(CODESET);
+
+if(!nl_exists){
+
+        function nl_langinfo($constant){
+        
+                echo $constant; 
+                
+        }//end function
+
+        function nl_setup(){
+        
+                $date = mktime(0,0,0,10,7,2007);
+                
+                for($i = 1; $i<=7; $i++){
+                
+                        define("ABDAY_".$i, date("D", $date));
+                        define("DAY_".$i, date("l"), $date);
+                        
+                        $date = strtotime("tomorrow", $date);
+                }//end for
+                
+                
+                for($i = 1; $i<=12; $i++){
+                        
+                        $date = mktime(0, 0, 0, $i, 1, 2007);
+                        
+                        define("ABMON_".$i, date("M", $date));
+                        define("MON_".$i, date("F"), $date);
+                
+                }//end for
+                                
+        }//end function
+
+        nl_setup();
+        
+
+}//end if
+
+nl_langinfo(ABMON_12);
+
-?>

trunk/phpbms/install/update.php

@@ -64 +64 @@
-                <h1>Before Updating</h1>
-                
-
+ class="important"
-                <p>
-                        By downloading and decompressing this update, you may have already replaced script files 

trunk/phpbms/install/updatev0.9.sql

@@ -110 +110 @@
-DELETE FROM tableoptions WHERE name='printex';
-INSERT INTO tableoptions (tabledefid, name, `option`,othercommand, roleid) SELECT id, "printex", 1, 0, 0 FROM tabledefs WHERE `type` != "view";
+INSERT INTO `reports` (`name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('SQL Export', 'export', '0', '0', '-100', 'report/general_sql.php', 'Generate SQL INSERT statements for records.', 1, NOW(), 1, NOW());

trunk/phpbms/modules/bms/include/clients_credit.php

@@ -83 +83 @@
-                                        relatedid,
-                                        amount,
+                                        `type`,
-                                        paid,
-                                        itemdate,
@@ -96 +97 @@
-                        $queryresult = $this->db->query($querystatement);
-                        
+                        $querystatement = "
+                                SELECT
+                                        SUM(amount) AS theamount,
+                                        SUM(amount - paid) AS thedue
+                                FROM
+                                        aritems
+                                WHERE
+                                        clientid = ".((int) $clientid)."
+                                        AND `status` = 'open'
+                                ORDER BY
+                                        posted";
+                        
+                        $sumresult = $this->db->query($querystatement);
+                        $sumrecord = $this->db->fetchArray($sumresult);
+                        
-                ?><table border="0" cellpadding="0" cellspacing="0" class="querytable" id="openItems">
-
@@ -101 +117 @@
-                                <tr>
-                                        <th align="left" nowrap="nowrap">doc ref</th>
+                                        <th align="left" nowrap="nowrap">type</th>
-                                        <th align="left" nowrap="nowrap">doc date</th>
-                                        <th align="left" nowrap="nowrap">due date</th>
-m
+
-                                        <th align="right">due</th>
-                                </tr>
@@ -110 +127 @@
-                        <tfoot>
-                                <tr class="queryfooter">
-4" align="right">&nbsp;
-&nbsp;
+5" align="right"><?php echo formatVariable($sumrecord["theamount"], "currency")?>
+<?php echo formatVariable($sumrecord["thedue"], "currency")?>
-                                </tr>
-                        </tfoot>
@@ -132 +149 @@
-                                                                
-                                                                ?><tr class="queryGroup">
-5
+6
-                                                                </tr><?php
-                                                                
@@ -141 +158 @@
-                                                        ?><tr class="row<?php echo $row?>">
-                                                                <td><?php echo $therecord["relatedid"]?></td>
+                                                                <td nowrap="nowrap"><?php echo $therecord["type"]?></td>
-                                                                <td><?php echo formatFromSQLDate($therecord["itemdate"])?></td>
-
+
+
+
+
+
+
+
+
-                                                                <td align="right"><?php echo formatVariable($therecord["amount"],"currency")?></td>
-                                                                <td align="right"><?php echo formatVariable($therecord["amount"] - $therecord["paid"],"currency")?></td>
@@ -149 +174 @@
-                                                
-                                        } else {
-5
+6
-                                        }//endif
-                                ?>

trunk/phpbms/modules/bms/include/receipts.php

@@ -143 +143 @@
-                        $this->db->query($deletestatement);
-
-split
+explode
-
-                        foreach($itemsArray as $item){
-                        
-split
+explode
-                                
-                                if(count($itemRecord) > 1){
@@ -362 +362 @@
-                        $newWhere = "";
-                        while($therecord = $this->db->fetchArray($queryresult))
-,
+ OR
-                                
-                        if(strlen($newWhere))
-2
+4
-                        else
-                                $newWhere = "id = -1974";
@@ -434 +434 @@
-                                
-                                if($therecord["amount"] == $checkrecord["thesum"]){
-,
+ OR
-                                        $count++;
-                                        
@@ -442 +442 @@
-
-                        if(strlen($newWhere))
-2
+4
-                        else
-                                $newWhere = "id = -1974";
@@ -606 +606 @@
-                                }//endwhile
-
-,
+ OR
-                        }//endwhile
-
-                        if(strlen($newWhere))
-2
+4
-                        
-                        if($newWhere){

trunk/phpbms/modules/bms/install/paymentmethods.sql

@@ -1 @@
-name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('Business Check','draft',10,0,0,'',1,NOW(),1,
-name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('Personal Check','draft',10,0,0,'',1,NOW(),1,
-name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('Cashiers Check','draft',10,0,0,'',1,NOW(),1,
-name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('VISA','charge',0,0,0,'',1,NOW(),1,
-name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('Mastercard','charge',0,0,0,'',1,NOW(),1,
-name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('American Express','charge',0,0,0,'',1,NOW(),1,
-name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('Cash','',20,0,0,'',1,NOW(),1,
-name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('Accounts Reveivable','receivable',30,0,0,'',1,NOW(),1,
-name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('Wire Transfer','draft',10,0,0,'',1,NOW(),1,
-name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('Money Order','',20,0,0,'',1,NOW(),1,
-name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('VISA - Debit','charge',0,0,0,'',1,NOW(),1,
-name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('Discover Card','charge',0,0,0,'',1,NOW(),1,
+id`, `name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('1', 'Business Check', 'draft', '10', '0', '0', '', 1, NOW(), 1, 
+id`, `name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('2', 'Personal Check', 'draft', '10', '0', '0', '', 1, NOW(), 1, 
+id`, `name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('3', 'Cashiers Check', 'draft', '10', '0', '0', '', 1, NOW(), 1, 
+id`, `name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('4', 'VISA', 'charge', '0', '0', '0', '', 1, NOW(), 1, 
+id`, `name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('5', 'Mastercard', 'charge', '0', '0', '0', '', 1, NOW(), 1, 
+id`, `name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('6', 'American Express', 'charge', '0', '0', '0', '', 1, NOW(), 1, 
+id`, `name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('7', 'Cash', '', '20', '0', '0', '', 1, NOW(), 1, 
+id`, `name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('8', 'Net 30', 'receivable', '30', '0', '0', '', 1, NOW(), 1, 
+id`, `name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('9', 'Wire Transfer', 'draft', '10', '0', '0', '', 1, NOW(), 1, 
+id`, `name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('10', 'Money Order', '', '20', '0', '0', '', 1, NOW(), 1, 
+id`, `name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('11', 'VISA - Debit', 'charge', '0', '0', '0', '', 1, NOW(), 1, 
+id`, `name`, `type`, `priority`, `inactive`, `onlineprocess`, `processscript`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('12', 'Discover Card', 'charge', '0', '0', '0', '', 1, NOW(), 1, 

trunk/phpbms/modules/bms/install/relationships.sql

@@ -1 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+

trunk/phpbms/modules/bms/install/updatev0.90.sql

@@ -195 +195 @@
-INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES (304,'receipts.amount','amount',4,'field');
-INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `othercommand`, `roleid`) VALUES (3,'mark_rtp','mark ready to post',1,20);
+DELETE FROM `relationships`;
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'sales managers', 'salesmanagerid', '2', '9', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('clientid', 'sales orders', 'id', '2', '3', 1, NOW(), 1, NOW(), '1');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'clients', 'clientid', '3', '2', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'tax areas', 'taxareaid', '3', '6', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'sales orders', 'invoiceid', '5', '3', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'products', 'productid', '5', '4', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'parent products', 'parentid', '8', '4', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'child products', 'childid', '8', '4', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('categoryid', 'products', 'id', '7', '4', 1, NOW(), 1, NOW(), '1');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('productid', 'sales order line items', 'id', '4', '5', 1, NOW(), 1, NOW(), '1');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('parentid', 'prerequisites', 'id', '4', '8', 1, NOW(), 1, NOW(), '1');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('taxareaid', 'sales orders', 'id', '6', '3', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('salesmanagerid', 'sales person for clients', 'id', '9', '2', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('createdby', 'created clients', 'id', '9', '2', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('modifiedby', 'modified clients', 'id', '9', '2', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('createdby', 'created sales orders', 'id', '9', '3', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('modifiedby', 'modified invoices', 'id', '9', '3', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('invoiceid', 'line items', 'id', '3', '5', 1, NOW(), 1, NOW(), '1');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('discountid', 'sales orders', 'id', '25', '3', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'discounts', 'discountid', '3', '25', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'clients', 'clientid', '303', '2', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('clientid', 'AR items', 'id', '2', '303', 1, NOW(), 1, NOW(), '1');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'invoices', 'relatedid', '303', '3', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('relatedid', 'AR items', 'id', '3', '303', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'clients', 'clientid', '304', '2', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('clientid', 'receipts', 'id', '2', '304', 1, NOW(), 1, NOW(), '1');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'product categories', 'categoryid', '4', '7', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('shippingmethodid', 'sales orders', 'id', '300', '3', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('paymentmethodid', 'sales orders', 'id', '301', '3', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('paymentmethodid', 'receipts', 'id', '301', '304', 1, NOW(), 1, NOW(), '1');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('id', 'receipts', 'relatedid', '303', '304', 1, NOW(), 1, NOW(), '0');
+INSERT INTO `relationships` (`tofield`, `name`, `fromfield`, `fromtableid`, `totableid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`, `inherint`) VALUES ('assignedtoid', 'assigned to sales orders', 'id', '9', '3', 1, NOW(), 1, NOW(), '0');

trunk/phpbms/modules/bms/report/aritems_clientstatement.php

@@ -165 +165 @@
-                        
-                        $pdf->Cell(1 - 0.01, 0.17, formatVariable($totalDue, "currency"), 1, 0, "R", 1);
+                        
+                        $this->currentTotal = 0;
+                        $this->term1Total = 0;
+                        $this->term2Total = 0;
+                        $this->term3Total = 0;
-
-                }//end while            

trunk/phpbms/modules/bms/snapshot.php

@@ -251 +251 @@
-                        WHERE
-                          `status` = 'open'
-
-
+
-                
-                $queryresult = $this->db->query($querystatement);
@@ -317 +316 @@
-                $sumrecord = $this->db->fetchArray($sumresult);
-                
-
-
-
+
+
+
+
+
+
-                
-                        ?>

trunk/phpbms/modules/sample/include/sampletable.php

@@ -13 +13 @@
-*/  
-if(class_exists("phpbmsTable")){
-[tablename]
+tablename
-                
-                // CLASS OVERRIDES ===================================================================