Changeset 430

Timestamp:

08/13/08 13:59:51

Author:

nate

Message:

• Fixes table find options in the client duplicate's page.
  

Files:

• trunk/phpbms/modules/bms/install/tablefindoptions.sql (modified) (1 diff)
• trunk/phpbms/modules/bms/install/updatev0.98.sql (modified) (1 diff)

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

@@ -50 +50 @@
-INSERT INTO `tablefindoptions` (`tabledefid`, `name`, `search`, `displayorder`, `roleid`) VALUES ('8', 'All Records', 'prerequisites.id != 0', '1', '0');
-INSERT INTO `tablefindoptions` (`tabledefid`, `name`, `search`, `displayorder`, `roleid`) VALUES ('18', 'match names', 'clients.firstname=dclients.firstname AND clients.lastname=dclients.lastname AND clients.lastname != \'\' AND clients.firstname != \'\' AND  clients.id<>dclients.id', '1', '0');
-
-addresses.
+c
+daddresses
-INSERT INTO `tablefindoptions` (`tabledefid`, `name`, `search`, `displayorder`, `roleid`) VALUES ('22', 'all records', 'clientemailprojects.id!=-1', '0', '0');
-INSERT INTO `tablefindoptions` (`tabledefid`, `name`, `search`, `displayorder`, `roleid`) VALUES ('22', 'global projects', 'clientemailprojects.userid=0', '1', '0');

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

@@ -45 +45 @@
-INSERT INTO `tablefindoptions` (`tabledefid`, `name`, `search`, `displayorder`, `roleid`) VALUES ('25', 'Active Records', 'discounts.inactive=0', '0', '0');
-UPDATE `tablefindoptions` SET `displayorder` = 0 WHERE `tabledefid` = 25 AND `name` = 'all records';
+UPDATE `tablefindoptions` SET `search`= 'clients.firstname=dclients.firstname AND clients.lastname=dclients.lastname AND addresses.postalcode = daddresses.postalcode AND clients.lastname != \'\' AND clients.firstname != \'\' AND addresses.postalcode != \'\' AND clients.id<>dclients.ID' WHERE `name` = 'match names and postal code' AND `tabledefid` = '18';
+UPDATE `tablefindoptions` SET `search`= 'addresses.address1=daddresses.address1 AND clients.id<>dclients.id' WHERE `name` = 'match addresses' AND `tabledefid` = '18';