Changeset 610 for trunk/phpbms/install

Timestamp:

06/15/09 18:13:44 (3 years ago)

Author:

nate

Message:

• Receipts, recieptitems, and aritems now uses uuid fields.
• Added updates and uuid generation to support the above.

Files:

• trunk/phpbms/install/generateuuids.php (modified) (3 diffs)

trunk/phpbms/install/generateuuids.php

@@ -111 +111 @@
             $this->createUUIDs("tbld:3342a3d4-c6a2-3a38-6576-419299859561"); //product categories
             $this->createUUIDs("tbld:27b99bda-7bec-b152-8397-a3b09c74cb23"); //addresses
-
+            $this->createUUIDs("tbld:c595dbe7-6c77-1e02-5e81-c2e215736e9c"); //aritems
+            $this->createUUIDs("tbld:43678406-be25-909b-c715-7e2afc7db601"); //receipts
+
+            $this->aritemList = $this->generateUUIDList("aritems");
+            $this->recieptList = $this->generateUUIDList("reciepts");
             $this->productsList = $this->generateUUIDList("products");
             $this->addressList = $this->generateUUIDList("addresses");
@@ -188 +192 @@
             $this->updateFields("invoicestatushistory", array("invoiceid"=>$this->invoiceList, "invoicestatusid"=>$this->invoiceStatsList, "assignedtoid"=>$this->userList));
             $this->updateFields("addresstorecord", array("tabledefid"=>$this->tabledefList, "recordid"=>$this->clientList, "addressid"=>$this->addressList));
+            $this->updateFields("receiptitems", array("receiptid"=>$this->recieptList, "aritemid"=>$this->aritemList));
+            $this->updateFields("receipts", array("clientid"=>$this->clientList, "payementmethodid"=>$this->paymentList));
+            $this->updateFields("aritems", array("clientid"=>$this->clientList));
 
             //we would have to run this if their were addresses associated with other records
             //$this->updateVariableUUIDs("addresstorecord", "tabledefid", "recordid");
 
+            $this->updateAritems(); // need receipt list to work
             $this->updateBMSSettings();
 
@@ -369 +377 @@
     }//end function updateMenuLinks
 
+
+    /**
+     * function updateAritems
+     */
+
+    function updateAritems() {
+
+        $querystatment = "
+            SELECT
+                `type`,
+                `relatedid`
+            FROM
+                `aritems`
+            GROUP BY
+                `type`,
+                `relatedid`
+        ";
+
+        $queryresult = $this->db->query($querystatment);
+
+        while($therecord = $this->db->fetchArray($queryresult)){
+
+            switch($therecord["type"]){
+
+                case "credit":
+
+                    $oldRelatedid = $therecord["relatedid"];
+                    $updatestatement = "
+                        UPDATE
+                            `aritems`
+                        SET
+                            `relatedid`='".$this->recieptList[$oldRelatedid]."'
+                        WHERE
+                            `relatedid` = '".$oldRelatedid."'
+                            AND
+                            `type`='credit'
+                    ";
+
+                    $this->db->query($updatestatement);
+                    break;
+
+                default:
+                    $oldRelatedid = $therecord["relatedid"];
+
+                    $updatestatement = "
+                        UPDATE
+                            `aritems`
+                        SET
+                            `relatedid`='".$this->recieptList[$oldRelatedid]."'
+                        WHERE
+                            `relatedid` = '".$oldRelatedid."'
+                            AND
+                            `type`!='credit'
+                    ";
+
+                    $this->db->query($updatestatement);
+                    break;
+
+            }//end switch
+
+        }//end if
+
+    }//end method
+
     /**
      * Updates specific settings that reference ids