Changeset 206 for trunk/phpbms/modules/bms/include/invoices_search_functions.php

Timestamp:

03/27/07 11:44:14 (5 years ago)

Author:

brieb

Message:

Fixed install problems with scheduler.
Fixed convert to invoice function.
Expanded logging details for errors.

Files:

• trunk/phpbms/modules/bms/include/invoices_search_functions.php (modified) (3 diffs)

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

@@ -110 +110 @@
 
         $whereclause=buildWhereClause($theids,"invoices.id");
-        $whereclause="(".$whereclause.") AND (invoices.type!=\"Invoice\" OR invoices.type!=\"VOID\") AND invoices.amountpaid=invoices.totalti;";
+        $whereclause="(".$whereclause.") AND (invoices.type!=\"Invoice\" OR invoices.type!=\"VOID\") AND invoices.amountpaid=invoices.totalti";
         
         //Look up default assignedto
@@ -121 +121 @@
                 $assignedtoid=$therecord["defaultassignedtoid"];
 
-        $querystatement = "UPDATE invoices SET invoices.type=\"Invoice\" invoices.invoicedate=ifnull(invoices.invoicedate,Now()),modifiedby=\"".$_SESSION["userinfo"]["id"]."\" WHERE".$whereclause;
+        $querystatement = "UPDATE invoices SET invoices.type=\"Invoice\", invoices.invoicedate=ifnull(invoices.invoicedate,Now()),modifiedby=\"".$_SESSION["userinfo"]["id"]."\" WHERE".$whereclause;
         $queryresult = mysql_query($querystatement,$dblink);
         if (!$queryresult) reportError(300,"Could not mark as invoice: ".mysql_error($dblink)." -- ".$querystatement);          
@@ -131 +131 @@
         $querystatement="SELECT id FROM invoices WHERE (".$whereclause.") AND statusid!=4";
         $queryresult = mysql_query($querystatement,$dblink);
+        if (!$queryresult) reportError(300,"Could not retrieve history for history cleaning: ".mysql_error($dblink)." -- ".$querystatement);            
         
         while($therecord=mysql_fetch_array($queryresult)){
-                $querystatement = "UPDATE invoices SET invoices.statusid=4,invoices.statusdate=Now(), invoices.assignedtoid=".$assignedtoid.", WHERE id=".$therecord["id"];
+                $querystatement = "UPDATE invoices SET invoices.statusid=4,invoices.statusdate=Now(), invoices.assignedtoid=".$assignedtoid." WHERE invoices.id=".$therecord["id"];
                 $queryresult = mysql_query($querystatement,$dblink);
                 if (!$queryresult) reportError(300,"Could not mark as invoice: ".mysql_error($dblink)." -- ".$querystatement);