Changeset 634 for trunk/phpbms/include

Timestamp:

08/06/09 15:48:24 (3 years ago)

Author:

nate

Message:

• Fixed invoicestatus insert statement when creating credit memos from the search page (was erroneously using ids instead of uuids).
• Fixes to search functions to use uuids where they should have been before. (These still need testing).
• Added the ability for search functions' idsArray to be uuids and not just ids (where applicable). This is mostly just useful for api calls.

Files:

• trunk/phpbms/include/common_functions.php (modified) (1 diff)

trunk/phpbms/include/common_functions.php

@@ -319 +319 @@
 
 /**
+ * function getUuidArray
+ * Gets an array of uuids for a given tabledefuuid and list of ids.  Will not
+ * give a uuid more than once and may not return an array of the same count
+ * as the count of the $ids array.
+ *
+ * @param object $db
+ * @param string $tabledefuuid
+ * @param array $ids
+ *
+ * @return array Array of Uuids for the $ids in no particular order.  Count
+ * (length) of this array is less than or equal to the $ids array.  Returns false
+ * if $ids is of length 0.
+ */
+
+function getUuidArray($db, $tabledefuuid, $ids){
+
+        if(!count($ids))
+                return false;
+
+        $querystatement = "
+                        SELECT
+                                        `maintable`
+                        FROM
+                                        `tabledefs`
+                        WHERE
+                                        `uuid` = '".$tabledefuuid."'";
+
+        $queryresult = $db->query($querystatement);
+
+        $tablerecord = $db->fetchArray($queryresult);
+
+        $whereclause = "";
+        foreach($ids as $id)
+                $whereclause .= " OR `id` = '".(int)$id."'";
+
+        $whereclause = substr($whereclause, 4);
+
+        $querystatement = "
+                        SELECT
+                                        `uuid`
+                        FROM
+                                        `".$tablerecord["maintable"]."`
+                        WHERE
+                                        ".$whereclause;
+
+        $queryresult = $db->query($querystatement);
+
+        $thereturn = array();
+        if($db->numRows($queryresult))
+                while($therecord = $db->fetchArray($queryresult))
+                        $thereturn[] = $therecord["uuid"];
+
+        return $thereturn;
+
+}//end function --getUuidArray--
+
+
+/**
   * retrieves an id given a uuid and a table definition's uuid
   *