Changeset 419

Timestamp:

07/11/08 11:49:24

Author:

nate

Message:

• Added php support for a tax id in clients (clients_addedit.php) and in the phpBMS configuration settings.
  
• Added database support for said tax id.
  

Files:

• trunk/phpbms/modules/base/adminsettings.php (modified) (2 diffs)
• trunk/phpbms/modules/bms/clients_addedit.php (modified) (2 diffs)
• trunk/phpbms/modules/bms/install/createtables.sql (modified) (1 diff)
• trunk/phpbms/modules/bms/install/modules.sql (modified) (1 diff)
• trunk/phpbms/modules/bms/install/settings.sql (modified) (1 diff)
• trunk/phpbms/modules/bms/install/update.php (modified) (1 diff)
• trunk/phpbms/modules/bms/install/updatev0.98.sql (added)
• trunk/phpbms/modules/bms/install/version.php (modified) (1 diff)

trunk/phpbms/modules/base/adminsettings.php

@@ -147 +147 @@
-                        <span class="notes">
-                                <strong>Example:</strong> Replace this with your comapny name + BMS (e.g. "Kreotek BMS").  Replacing
-
+p
-                        </span>
-                </p>
@@ -188 +188 @@
-                        <label for="company_phone">phone number</label><br />
-                        <input id="company_phone" name="company_phone" type="text" value="<?php echo htmlQuotes($therecord["company_phone"]) ?>" size="40" maxlength="128" />
+                </p>
+        
+                <p>
+                        <label for="company_taxid">company tax id</label><br />
+                        <input id="company_taxid" name="company_taxid" type="text" value="<?php echo htmlQuotes($therecord["company_taxid"]) ?>" size="40" maxlength="128" />
-                </p>
-

trunk/phpbms/modules/bms/clients_addedit.php

@@ -133 +133 @@
-                $theinput = new inputField("webaddress",$therecord["webaddress"],"web address",false,"www",68,128);
-                $theform->addField($theinput);
+                
+                $theinput = new inputField("taxid", $therecord["taxid"], "tax id", false, "", 25, 32);
+                $theform->addField($theinput);
-
-                $theform->jsMerge();
@@ -251 +254 @@
-                        
-                        <p><?php $theform->showField("webaddress")?></p>
+                        
+                        <p><?php $theform->showField("taxid")?></p>
-                </fieldset>
-                

trunk/phpbms/modules/bms/install/createtables.sql

@@ -27 +27 @@
-  `email` varchar(128) default NULL,
-  `webaddress` varchar(128) default NULL,
+  `taxid` VARCHAR(64) default NULL,
-  `salesmanagerid` int(11) default NULL,
-  `leadsource` varchar(64) default NULL,

trunk/phpbms/modules/bms/install/modules.sql

@@ -1 @@
-6
+8

trunk/phpbms/modules/bms/install/settings.sql

@@ -17 +17 @@
-INSERT INTO `settings` (`name`, `value`) VALUES ('prospects_on_orders','1');
-INSERT INTO `settings` (`name`, `value`) VALUES ('clear_payment_on_invoice','1');
+INSERT INTO `settings` (`name`, `value`) VALUES ('company_taxid', '');

trunk/phpbms/modules/bms/install/update.php

@@ -327 +327 @@
-
-                                        break;
+                                
+                                // ================================================================================================
+                                case "0.96";
+
+                                        $thereturn.= processSQLfile($db,"updatev0.98.sql");
+                                        
+                                        //Updating Module Table
+                                        $updatestatement = "
+                                                UPDATE 
+                                                        modules 
+                                                SET 
+                                                        version='0.98' 
+                                                WHERE 
+                                                        name='bms';";
+
+                                        $db->query($updatestatement);
+
+                                        $thereturn .= "Update of Business Management System Module to 0.98 Finished\n\n";
+
+                                        $ver["version"] = "0.98";
+
+                                        break;
-
-                        }//end switch

trunk/phpbms/modules/bms/install/version.php

@@ -3 +3 @@
-        $modules["bms"]["name"] = "Buisness Management System (BMS)";
-        
-6
+8
-        
-        $modules["bms"]["description"] = 
-        "The Business Magagement functionality of phpBMS.  This module includes clients/propsetcs, quote/order/invoice, and products sections.";
-        
-6
+8
-
-?>