Changeset 710 for trunk/phpbms/modules/bms/include/clients.php

Timestamp:

01/04/10 13:22:31 (2 years ago)

Author:

nate

Message:

• Changed imports to incorporate changes made to tables.php (as a result of uuids).

Files:

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

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

@@ -1249 +1249 @@
                                                 if($rowFieldNum == $fieldNum){
                                                         $verify = $this->table->verifyVariables($trimmedRowData);
-                                                        if(!count($verify))
-                                                                $theid = $this->table->insertRecord($trimmedRowData, NULL, true);
+                                                        if(!count($verify)){
+                                                                $createdby = NULL;
+                                                                $overrideID = true;
+                                                                $replace = false;
+                                                                if(!isset($trimmedRowData["uuid"])){
+                                                                        $useUuid = true;
+                                                                        $thereturn = $this->table->insertRecord($trimmedRowData, $createdby, $overrideID, $replace, $useUuid);
+                                                                        $theid = $thereturn["id"];
+                                                                }else{
+                                                                        $useUuid = false;
+                                                                        $thereturn = $this->table->insertRecord($trimmedRowData, $createdby, $overrideID, $replace, $useUuid);
+                                                                        $theid = $thereturn;
+                                                                }//end if
+                                                        }//end if
+                                                                
                                                 }else
                                                         $this->error .= '<li> incorrect amount of fields for line number '.$rowNum.'.</li>';
@@ -1398 +1411 @@
                                                         `addresses`.`phone`
                                                 FROM
-                                                        ((clients INNER JOIN addresstorecord ON clients.id = addresstorecord.recordid AND addresstorecord.tabledefid=2 AND addresstorecord.primary=1) INNER JOIN addresses ON  addresstorecord.addressid = addresses.id)
+                                                        ((clients INNER JOIN addresstorecord ON clients.uuid = addresstorecord.recordid AND addresstorecord.tabledefid='tbld:6d290174-8b73-e199-fe6c-bcf3d4b61083' AND addresstorecord.primary='1') INNER JOIN addresses ON  addresstorecord.addressid = addresses.uuid)
                                                 WHERE
                                                         `clients`.`id` IN (".$inStatement.")
@@ -1418 +1431 @@
 
                 function displayTransaction($recordsArray, $fieldsArray){
-
+                        
                         if(count($recordsArray) && count($fieldsArray)){