Changeset 386

Timestamp:

05/06/08 13:36:09

Author:

brieb

Message:

• Fixed Install and Update Problems
  
• Fixed JS problems with sales order entry
  
• Removed references to now defunct autofill
  
• Reformatted product entry.
  

Files:

• trunk/phpbms/common/javascript/autofill.js (deleted)
• trunk/phpbms/common/javascript/smartsearch.js (modified) (1 diff)
• trunk/phpbms/common/stylesheet/mozilla/pages/products.css (modified) (1 diff)
• trunk/phpbms/install/install_include.php (modified) (1 diff)
• trunk/phpbms/install/menu.sql (modified) (1 diff)
• trunk/phpbms/modules/bms/include/invoices.php (modified) (2 diffs)
• trunk/phpbms/modules/bms/install/createtables.sql (modified) (4 diffs)
• trunk/phpbms/modules/bms/install/tablecolumns.sql (modified) (2 diffs)
• trunk/phpbms/modules/bms/install/tabledefs.sql (modified) (2 diffs)
• trunk/phpbms/modules/bms/install/update.php (modified) (5 diffs)
• trunk/phpbms/modules/bms/install/updatev0.96.sql (modified) (2 diffs)
• trunk/phpbms/modules/bms/javascript/invoice.js (modified) (2 diffs)
• trunk/phpbms/modules/bms/javascript/invoiceaddress.js (modified) (1 diff)
• trunk/phpbms/modules/bms/products_addedit.php (modified) (6 diffs)

trunk/phpbms/common/javascript/smartsearch.js

@@ -342 +342 @@
-                
-                smartSearch.inDropDown[ssID] = false;
-
-
+//
+//
-
-        },//end method

trunk/phpbms/common/stylesheet/mozilla/pages/products.css

@@ -2 +2 @@
-/* $LastChangedDate$ */
-
-
-
+
+
+
+
-
-rightsideDiv{clear:both;float:right;width:200px;margin:0;padding:0;}
-
-#memo{width:98%;height:255px;
+topTitle{
+
+
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-#webstuff{display:none}

trunk/phpbms/install/install_include.php

@@ -9 +9 @@
-        $thereturn="Processing SQL from file '".$filename."'\n";
-                while(!feof($thefile)) {
-1024
+2048
-                        if(strrpos($sqlstatement,";")==strlen($sqlstatement)-1){
-                                $theresult=$db->query($sqlstatement);

trunk/phpbms/install/menu.sql

@@ -26 +26 @@
-INSERT INTO `menu` (`id`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('219', 'Help', '', '0', '200', '1', '1', NOW(), NOW(), '0');
-INSERT INTO `menu` (`id`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('220', 'About phpBMS', 'javascript:menu.showHelp()', '219', '0', '1', '1', NOW(), NOW(), '0');
-name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES (
+id`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('100',

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

@@ -122 +122 @@
-                                        invoicestatuses.invoicedefault,
-                                        invoicestatuses.setreadytopost,
+                                        invoicestatuses.defaultassignedtoid,
-                                        users.firstname,
-                                        users.lastname
@@ -147 +148 @@
-                                $phpbms->topJS[] = 'statuses['.$therecord["id"].']["name"]="'.htmlQuotes($therecord["name"]).'";';
-                                $phpbms->topJS[] = 'statuses['.$therecord["id"].']["setreadytopost"]='.$therecord["setreadytopost"].';';
+                                $phpbms->topJS[] = 'statuses['.$therecord["id"].']["userid"]="'.htmlQuotes($therecord["defaultassignedtoid"]).'";';
-                                $phpbms->topJS[] = 'statuses['.$therecord["id"].']["firstname"]="'.htmlQuotes($therecord["firstname"]).'";';
-                                $phpbms->topJS[] = 'statuses['.$therecord["id"].']["lastname"]="'.htmlQuotes($therecord["lastname"]).'";';                              

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

@@ -51 +51 @@
-  KEY `notin` (`inactive`),
-  KEY `thefirstname` (`firstname`),
-  KEY `address` (`address1`),
-  KEY `zip` (`postalcode`),
-  KEY `created` (`creationdate`),
-  KEY `thelastname` (`lastname`),
@@ -79 +77 @@
-  `statusid` int(10) unsigned default NULL,
-  `statusdate` date default NULL,
+  `readytopost` tinyint(3) unsigned NOT NULL default '0',
-  `assignedtoid` int(10) unsigned default NULL,
-  `readytopost` TINYINT UNSIGNED NOT NULL DEFAULT 0,  
-  `ponumber` varchar(64) default NULL,
-  `orderdate` date default NULL,
@@ -89 +87 @@
-  `address2` varchar(128) default NULL,
-  `city` varchar(64) default NULL,
-20
+5
-  `postalcode` varchar(15) default NULL,
-  `country` varchar(64) default '',
@@ -122 +120 @@
-  `creationdate` datetime NOT NULL default '0000-00-00 00:00:00',
-  `modifiedby` int(11) default NULL,
-
+
+
+
+
+
+
+
+
+
+
+
-  UNIQUE KEY `theid` (`id`),
-  KEY `client` (`clientid`)

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

@@ -1 +1 @@
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('2', 'e-mail', 'clients.email', 'left', '', '3', '', '0', '', NULL, '0');
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('2', 'has credit', 'clients.hascredit', 'center', '', '1', '', '0', '', 'boolean', '80');
-
+n
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('2', 'type', 'clients.type', 'left', '', '0', '', '0', '', NULL, '0');
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('2', 'phone', 'IF(clients.workphone != \'\' OR clients.homephone != \'\' OR clients.mobilephone != \'\' OR clients.otherphone != \'\',IF(clients.workphone != \'\', concat(clients.workphone, \' (w)\'), IF(clients.homephone != \'\', concat(clients.homephone, \' (h)\'), IF(clients.mobilephone != \'\', concat(clients.mobilephone, \' (m)\'), IF(clients.otherphone != \'\', concat(clients.otherphone, \' (o)\'), \'\')))) ,\'\')', 'left', '', '4', 'concat(clients.workphone, clients.homephone, clients.mobilephone,clients.otherphone)', '0', '', NULL, '0');
@@ -72 +72 @@
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES (304,'date','receipts.receiptdate','left','',3,'',0,'','date',0);
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES (304,'status','receipts.status','left','',2,'',0,'',NULL,0);
-addresses.address1
+IF(addresses.address1!=\'\',addresses.address1,\'\')
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('305', 'default ship to', 'addresstorecord.defaultshipto', 'center', '', '4', '', '0', '', 'boolean', '0');
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('305', 'ship to name', 'addresses.shiptoname', 'left', '', '3', '', '0', '', NULL, '0');

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

@@ -6 +6 @@
-INSERT INTO `tabledefs` (`id`, `displayname`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES (7,'Product Categories','table',2,'productcategories','productcategories','modules/bms/productcategories_addedit.php',0,'modules/bms/productcategories_addedit.php',0,0,-100,-100,'delete','productcategories.id !=0','productcategories.name','','','',1,NOW(),1,NOW());
-INSERT INTO `tabledefs` (`id`, `displayname`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES (8,'Prerequisites','table',2,'prerequisites','(prerequisites left join products on prerequisites.parentid=products.id) left join products as childproducts on prerequisites.childid=childproducts.id','N/A',0,'N/A',0,0,-100,-100,'NA','prerequisites.id =-1','products.id','','','',1,NOW(),1,NOW());
-18,'Client Duplicates','view',2,'clients','(clients, clients dupclients)','N/A',0,'N/A',0,0,-100,-100,'NA','clients.id = -100','concat(clients.lastname,\", \",clients.firstname)','','','',1,NOW(),1,
+'18', 'Client Duplicates', 'view', '2', 'clients', '((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 AS dclients INNER JOIN addresstorecord as daddresstorecord on dclients.id = daddresstorecord.recordid AND daddresstorecord.tabledefid=2 AND daddresstorecord.primary=1) INNER JOIN addresses AS daddresses ON daddresstorecord.addressid = daddresses.id)', 'N/A', '0', 'N/A', '0', '0', '-100', '-100', 'NA', 'clients.id = -100', 'clients.company, clients.lastname, clients.firstname', NULL, NULL, NULL, 1, NOW(), 1, 
-INSERT INTO `tabledefs` (`id`, `displayname`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES (25,'Discounts','table',2,'discounts','discounts','modules/bms/discounts_addedit.php',0,'modules/bms/discounts_addedit.php',0,0,-100,-100,'inactivate','discounts.id!=0','discounts.id','search','all records','name',1,NOW(),1,NOW());
-INSERT INTO `tabledefs` (`id`, `displayname`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES (300,'Shipping Methods','table',2,'shippingmethods','shippingmethods','modules/bms/shippingmethods_addedit.php',30,'modules/bms/shippingmethods_addedit.php',30,30,30,-100,'inactivate','shippingmethods.inactive!=0','shippingmethods.priority, shippingmethods.name','','','',1,NOW(),1,NOW());
@@ -15 +15 @@
-INSERT INTO `tabledefs` (`id`, `displayname`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('305', 'Client Addresses', 'view', '2', 'addresstorecord', '((addresstorecord INNER JOIN addresses ON addresstorecord.addressid = addresses.id) INNER JOIN clients ON addresstorecord.recordid = clients.id)', 'modules/bms/addresses_addedit.php', '0', 'modules/bms/addresses_addedit.php', '0', '0', '-100', '-100', 'remove', 'addresstorecord.tabledefid=2 AND addresstorecord.id = -100', 'addresstorecord.primary DESC,  addresstorecord.defaultshipto DESC,  addresses.title,  addresses.address1', NULL, NULL, NULL, 1, NOW(), 1, NOW());
-INSERT INTO `tabledefs` (`id`, `displayname`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('306', 'Addresses', 'table', '2', 'addresses', 'addresses', 'modules/bms/addresses_addedit.php', '0', 'modules/bms/addresses_addedit.php', '0', '0', '-100', '-100', 'delete', 'addresses.id != -100', 'address.title', NULL, NULL, NULL, 1, NOW(), 1, NOW());
-INSERT INTO `tabledefs` (`id`, `displayname`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('18', 'Client Duplicates', 'view', '2', 'clients', '((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 AS dclients INNER JOIN addresstorecord as daddresstorecord on dclients.id = daddresstorecord.recordid AND daddresstorecord.tabledefid=2 AND daddresstorecord.primary=1) INNER JOIN addresses AS daddresses ON daddresstorecord.addressid = daddresses.id)', 'N/A', '0', 'N/A', '0', '0', '-100', '-100', 'NA', 'clients.id = -100', 'clients.company, clients.lastname, clients.firstname', NULL, NULL, NULL, 1, NOW(), 1, NOW());

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

@@ -468 +468 @@
-                $queryresult = $db->query($querystatement);
-                
-statemen
+resul
-                
-                        $updatestatement = "
@@ -485 +485 @@
-                                        state =         '".$therecord["state"]."',
-                                        postalcode ='".$therecord["postalcode"]."',
-,
+
-                                WHERE
-                                        id = ".$therecord["id"];
+
+                                $db->query($updatestatement);
-                
-                }//endwhile - record
+        
+                return true;
-        
-        }//end function - v096updateInvoiceAddresses
@@ -598 +602 @@
-                                addressid,
-                                `primary`,
+                                defaultshipto,
-                                createdby,
-                                creationdate,
@@ -608 +613 @@
-                                ".$variables["primary"].",
-                                ".$variables["defaultshipto"].",
+                                1,
-                                NOW(),
-                                1,
@@ -636 +642 @@
-                                        modifieddate
-                                ) VALUES (
-variables["title"]
+.$variables["title"].
-                                        '".$variables["address1"]."',
-                                        '".$variables["address2"]."',

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

@@ -18 +18 @@
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('2', 'e-mail', 'clients.email', 'left', '', '3', '', '0', '', NULL, '0');
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('2', 'has credit', 'clients.hascredit', 'center', '', '1', '', '0', '', 'boolean', '80');
-
+n
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('2', 'type', 'clients.type', 'left', '', '0', '', '0', '', NULL, '0');
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('2', 'phone', 'IF(clients.workphone != \'\' OR clients.homephone != \'\' OR clients.mobilephone != \'\' OR clients.otherphone != \'\',IF(clients.workphone != \'\', concat(clients.workphone, \' (w)\'), IF(clients.homephone != \'\', concat(clients.homephone, \' (h)\'), IF(clients.mobilephone != \'\', concat(clients.mobilephone, \' (m)\'), IF(clients.otherphone != \'\', concat(clients.otherphone, \' (o)\'), \'\')))) ,\'\')', 'left', '', '4', 'concat(clients.workphone, clients.homephone, clients.mobilephone,clients.otherphone)', '0', '', NULL, '0');
@@ -24 +24 @@
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('18', 'type', 'clients.type', 'left', '', '1', '', '0', '', NULL, '0');
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('18', 'name', 'IF(clients.company != \'\', CONCAT(clients.company,IF(clients.lastname != \'\' OR clients.firstname != \'\', CONCAT(\' (\',if(clients.lastname != \'\', clients.lastname, \'{blank}\'),\', \',if(clients.firstname != \'\', clients.firstname, \'{blank}\'),\')\'), \'\')), IF(clients.lastname != \'\' OR clients.firstname != \'\', CONCAT(if(clients.lastname != \'\', clients.lastname, \'{blank}\'),\', \',if(clients.firstname != \'\', clients.firstname, \'{blank}\')), \'\'))', 'left', '', '2', 'concat(clients.company,clients.lastname,clients.firstname)', '1', '100%', NULL, '0');
-addresses.address1
+IF(addresses.address1!=\'\',addresses.address1,\'\')
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('305', 'default ship to', 'addresstorecord.defaultshipto', 'center', '', '4', '', '0', '', 'boolean', '0');
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('305', 'ship to name', 'addresses.shiptoname', 'left', '', '3', '', '0', '', NULL, '0');

trunk/phpbms/modules/bms/javascript/invoice.js

@@ -210 +210 @@
-        statusChosen: function(e){
-                
-
-
+
+
+
-
-                //update assignedto
@@ -217 +218 @@
-                        
-                        assignedto.value = (statuses[status.value]["firstname"]+" "+statuses[status.value]["lastname"]).replace(/^\s+|\s+$/g,"");
-lastLookup(assignedto);
+assignedtoid.value = statuses[status.value]["userid"]
-                        
-                }//endif

trunk/phpbms/modules/bms/javascript/invoiceaddress.js

@@ -139 +139 @@
-                theButton = e.src();
-                
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-                
-        },//end method - showLoad

trunk/phpbms/modules/bms/products_addedit.php

@@ -66 +66 @@
-                $theinput = new inputCheckbox("taxable",$therecord["taxable"]);
-                $theform->addField($theinput);
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-                $theinput->setAttribute("onchange","checkPartNumber()");
-                $theinput->setAttribute("class","important");
-                $theform->addField($theinput);
-                
+                $theinput = new inputField("upc",$therecord["upc"],"UPC");
+                $theform->addField($theinput);
+
+                $theinput = new inputField("description",$therecord["description"],"description",false,NULL,64,255);
+                $theform->addField($theinput);
+
-                $theinput = new inputCurrency("unitprice", $therecord["unitprice"], "sell price" ,true);
-                $theinput->setAttribute("class","important");
@@ -81 +99 @@
-                $theform->addField($theinput);
-                
-
-                $markup=0;
-{
+
-                        $markup=round(($therecord["unitprice"]/$therecord["unitcost"])-1,4)*100;
-
+
-                $theinput = new inputPercentage("markup", $markup, "mark-up",2);
-                $theinput->setAttribute("size","10");
-                $theform->addField($theinput);
-
-
+
+
+
+
+
-                $theform->addField($theinput);
-
@@ -135 +155 @@
-
-                        <p>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
-                </fieldset>
-                
@@ -158 +168 @@
-                        <legend><label for="memo">memo</label></legend>
-                        <p>
-tabindex="300"
+
-                        </p>
-                </fieldset>
@@ -165 +175 @@
-        <div id="leftsideDiv">
-                <fieldset>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-                        <p>
-                                <br />
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
-                        <p>
-                                <label for="packagesperitem">items per package <span class="notes">(number of product items that can fit in a shipping package)</span></label><br />
@@ -242 +222 @@
-                        </p>
-                </fieldset>
+                
+                <fieldset>
+                        <legend>web</legend>
+                        <p>
+                                <?php $theform->showfield("webenabled");?>
+                        </p>
+                                        
+                        <div style=" <?php if(!$therecord["webenabled"]) echo "display:none;" ?>" id="webstuff">
+                                <p>
+                                        <label for="keywords">keywords <span class="notes">(comma separated key word list)</span></label><br />
+                                        <input type="text" id="keywords" name="keywords" value="<?php echo htmlQuotes($therecord["keywords"])?>" size="40" maxlength="255"/>
+                                </p>
+                                <div class="fauxP">
+                                        <label for="webdescription">web description <span class="notes">(HTML acceptable)</span></label><br />
+                                        
+                                        <div style=" <?php if($therecord["webdescription"]) echo "display:none;"?>" id="webDescEdit">
+                                                <textarea id="webdescription" name="webdescription" cols="60" rows="6"><?php echo $therecord["webdescription"] ?></textarea>
+                                        </div>
+                                        <div style=" <?php if(!$therecord["webdescription"]) echo "display:none;"?>" id="webDescPreview">
+                                        <?php echo $therecord["webdescription"] ?>
+                                        </div>                  
+                                        <div><input id="buttonWebPreview" type="button" class="Buttons" onclick="editPreviewWebDesc(this)" value="<?php if(!$therecord["webdescription"]) echo "preview"; else echo "edit"?>"/></div>
+        
+                                </div>
+                                
+                                <div class="fauxP">
+                                        thumbnail graphic<br />
+                                        <?php if($therecord["thumbnailmime"]) {?>
+                                                <img id="thumbpic" src="<?php echo APP_PATH ?>dbgraphic.php?t=products&f=thumbnail&mf=thumbnailmime&r=<?php echo $therecord["id"]?>" style="border: 1px solid black; display: block; margin: 3px;;" />
+                                        <?php } else {?>
+                                                <div id="noThumb" class="tiny" align="center">no thumbnail</div>
+                                        <?php } ?>
+                                        upload thumbnail<br />
+                                        <input type="hidden" id="thumbchange" name="thumbchange" value="" />
+                                        <div id="thumbdelete" style="display:<?php if($therecord["thumbnailmime"]) echo "block"; else echo "none";?>"><input type="button" class="Buttons" value="delete thumbnail" onclick="deletePicture('thumb')" tabindex="260"/></div>
+                                        <div id="thumbadd" style="display:<?php if($therecord["thumbnailmime"]) echo "none"; else echo "block";?>"><input id="thumbnailupload" name="thumbnailupload" type="file" size="40" onchange="updatePictureStatus('thumb','upload')" tabindex="260" /></div>
+                                </div>
+        
+                                <div class="fauxP">
+                                        main picture<br />
+                                        <?php if($therecord["picturemime"]) {?>
+                                                <img id="picturepic" src="<?php echo APP_PATH ?>dbgraphic.php?t=products&f=picture&mf=picturemime&r=<?php echo $therecord["id"]?>" style="border: 1px solid black; display: block; margin: 3px;;" />
+                                        <?php } else {?>
+                                                <div id="noPicture" class="tiny" align="center">no picture</div>
+                                        <?php } ?>
+                                        upload picture <br />
+                                        <input type="hidden" id="picturechange" name="picturechange" value="" />
+                                        <div id="picturedelete" style="display:<?php if($therecord["picturemime"]) echo "block"; else echo "none";?>"><input type="button" class="Buttons" value="delete picture" onclick="deletePicture('picture')" tabindex="270"/></div>                             
+                                        <div id="pictureadd" style="display:<?php if($therecord["picturemime"]) echo "none"; else echo "block";?>"&