Changeset 743 for trunk/phpbms

Timestamp:

01/09/10 17:58:06 (2 years ago)

Author:

brieb

Message:

• Fixed gnereation of uuid errors with attachments and notes related to records

Files:

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

trunk/phpbms/install/generateuuids.php

@@ -115 +115 @@
             $this->createUUIDs("tbld:c595dbe7-6c77-1e02-5e81-c2e215736e9c"); //aritems
             $this->createUUIDs("tbld:43678406-be25-909b-c715-7e2afc7db601"); //receipts
-            $this->createUUIDs("tbld:157b7707-5503-4161-4dcf-6811f8b0322f"); //client email projects
 
             $this->aritemList = $this->generateUUIDList("aritems");
@@ -122 +121 @@
             $this->addressList = $this->generateUUIDList("addresses");
             $this->productcatList = $this->generateUUIDList("productcategories");
+            $this->productList = $this->generateUUIDList("products");
             $this->clientList = $this->generateUUIDList("clients");
             $this->statusList = $this->generateUUIDList("invoicestatuses");
@@ -170 +170 @@
 
         $this->updateFields("files", array("roleid"=>$this->roleList));
-        $this->updateFields("attachments", array("fileid"=>$this->fileList));
+        $this->updateFields("attachments", array("fileid"=>$this->fileList, "tabledefid"=>$this->tabledefList));
         $this->updateFields("menu", array("parentid"=>$menuList, "roleid"=>$this->roleList));
         $this->updateFields("smartsearches", array("tabledefid"=>$this->tabledefList, "moduleid"=>$this->moduleList));
         $this->updateFields("tabs", array("roleid"=>$this->roleList));
-        $this->updateFields("notes", array("assignedtoid"=>$this->userList, "assignedbyid"=>$this->userList, "attachedtabledefid", "parentid"=>$notesList));
+        $this->updateFields("notes", array("assignedtoid"=>$this->userList, "assignedbyid"=>$this->userList, "attachedtabledefid"=>$this->tabledefList, "parentid"=>$notesList));
         $this->updateFields("log", array("userid"=>$this->userList));
 
@@ -213 +213 @@
             $this->updateFields("aritems", array("clientid"=>$this->clientList));
             $this->updateFields("prerequisites", array("parentid"=>$this->productList, "childid"=>$this->productList));
-            $this->updateFields("clientemailprojects", array("userid"=>$this->userList));
 
             //we would have to run this if their were addresses associated with other records
@@ -321 +320 @@
 
             foreach($fields as $key=>$value)
-                if(strpos($therecord[$key],":") === false)
-                    $updateClause .= ", `".$key."` = '".$value[$therecord[$key]]."'";
+                if(strpos($therecord[$key],":") === false && ((int) $therecord[$key]))
+                    if(isset($value[$therecord[$key]]) && $therecord[$key] != 0)
+                        $updateClause .= ", `".$key."` = '".$value[$therecord[$key]]."'";
+                    else
+                        $updateClause .= ", `".$key."` = ''";
 
             if($updateClause){
@@ -509 +511 @@
                 *
             FROM
-                `setings`
+                `settings`
             WHERE
                 `name` = 'default_payment'
@@ -616 +618 @@
                     `id` = ".$therecord["id"];
 
+            $this->db->query($updatestatement);
+
         }//endwhile