Changeset 569 for trunk/phpbms/install

Timestamp:

06/03/09 19:02:18 (3 years ago)

Author:

brieb

Message:

• prepped attached notes for uuid handling
• fixed smartsearch addedit uuid problems

Location:

trunk/phpbms/install

Files:

• generateuuids.php (modified) (3 diffs)
• updatev0.98.sql (modified) (1 diff)

trunk/phpbms/install/generateuuids.php

@@ -88 +88 @@
         //$this->createUUIDs("tbld:7e75af48-6f70-d157-f440-69a8e7f59d38"); //Tabs
         //$this->createUUIDs("tbld:29925e0a-c825-0067-8882-db4b57866a96"); //Smart Searches
+        //$this->createUUIDs("tbld:83187e3d-101e-a8a5-037f-31e9800fed2d"); //Menu
 
         //generate lists used elsewhere
+        $this->moduleList= $this->generateUUIDList("modules");
+
+        $this->tabledefList = $this->generateUUIDList("tabledefs");
+
+        //BMS updates
+        if(in_array("mod:0aa9cca0-7388-0eae-81b9-9935f9d127cc", $this->moduleList)){
+
+            //$this->createUUIDs("tbld:6d290174-8b73-e199-fe6c-bcf3d4b61083"); //clients
+
+        }//endif
+
+
+        $this->userList = $this->generateUUIDList("users");
+        $this->userList[0] ="";
+
         $this->roleList = $this->generateUUIDList("roles");
         $this->roleList[-100] = "Admin";
         $this->roleList[0] = "";
 
-        //$this->userList = $this->generateUUIDList("users");
-        //$this->userList[0] ="";
-        //
-        //$this->tabledefList = $this->generateUUIDList("tabledefs");
-        //
-        //$this->moduleList= $this->generateUUIDList("modules");
+        $menuList = $this->generateUUIDList("menu");
+        $menuList[0] = "";
+
+        $notesList = $this->generateUUIDList("notes");
 
         //function calls for all we have to do go here
@@ -113 +127 @@
         //$this->updateFields("widgets", array("roleid"=>$this->roleList, "moduleid"=>$this->moduleList));
         //$this->updateFields("usersearches", array("tabledefid"=>$this->tabledefList, "userid"=>$this->userList, "roleid"=>$this->roleList));
-        //$this->updateFields("reports", array("roleid"=>$this->roleList, "tabledefid"=>$this->tabledefList));
         //$this->updateFields("relationships", array("fromtableid"=>$this->tabledefList, "totableid"=>$this->tabledefList));
-        $this->updateFields("tabs", array("roleid"=>$this->roleList));
-
+        //$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));
+
+        //custom stuff
         //$this->updateMenuLinks();
+
+        //BMS updates
+        if(in_array("mod:0aa9cca0-7388-0eae-81b9-9935f9d127cc", $this->moduleList)){
+
+        }//endif
+
+
+        //Updates that need to be done after all the other updates
+        // Notes attachedtoid
+        // attachments
+        // addresstorecord
+        // AR??
 
         // ======
@@ -193 +222 @@
                 ";
 
-//echo $updatestatement."<br />";
-                $this->db->query($updatestatement);
+echo $updatestatement."<br />";
+//                $this->db->query($updatestatement);
 
             }//endif

trunk/phpbms/install/updatev0.98.sql

@@ -234 +234 @@
 --menu INSERT--
 DELETE FROM `menu`;
-INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', 'Tools', '', '0', '3', 1, 1, NOW(), NOW(), '');
+INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', 'Tools', '', '', '3', 1, 1, NOW(), NOW(), '');
 INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:d9e0eaa6-26b3-fcfb-f1b5-ee0eef8a857a', 'Notes', 'search.php?id=12', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '30', 1, 1, NOW(), NOW(), '');
 INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:03e984b6-d7ac-def2-a4f5-662003e94bfd', 'Tasks', 'search.php?id=23', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '40', 1, 1, NOW(), NOW(), '');
 INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:c4871074-90e9-c9bb-bcf9-b69ca0c30e8b', 'Events', 'search.php?id=24', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '50', 1, 1, NOW(), NOW(), '');
 INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:2bcd88e6-703f-128c-7f18-1aad44fb46fb', 'Snapshot', 'modules/base/snapshot.php', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '10', 1, 1, NOW(), NOW(), '');
-INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', 'System', '', '0', '10', 1, 1, NOW(), NOW(), 'Admin');
+INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', 'System', '', '', '10', 1, 1, NOW(), NOW(), 'Admin');
 INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:e44cf976-658a-50d7-4a8f-b575713e3964', 'Configuration', 'modules/base/adminsettings.php', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '10', 1, 1, NOW(), NOW(), 'Admin');
 INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:cf16add3-b02a-bd9b-b3c7-3fe9d0d2e0ba', 'Users', 'search.php?id=9', 'menu:f07d910f-f56d-3d24-e74f-7a3b36b2d3c8', '40', 1, 1, NOW(), NOW(), 'Admin');