Changeset Navigation

Changeset 323

Timestamp:

10/12/07 17:29:31

Author:

brieb

Message:

Updated ChangeLog? for v0.9.
Fixed sales order status changing to update the status date automatically.
Added groupings for AR items and receipts.

Files:

r301	r323
	1	phpBMS v0.9
	2	http://phpbms.org/browser/tags/phpbms-0.9
	3	* Accounts Receivable
	4	* iCal formatted access to Events
	5	* enhanced User Interface
	6	* Switched over JavaScript programming style (more MochiKit Like)
	7	* E-Mail Client Inovice/Quote PDFs
	8	* New Recurring Invoice/Task/Event System
	9	* Added Ordering of Table Def Options
	10	* Recoded/formatted Sales Order PDFs
	11
	12	The complete list of closed tickets can be found here: http://phpbms.org/query?status=closed&milestone=0.8
	13
1	14	phpBMS v0.8
2	15	http://phpbms.org/browser/tags/phpbms-0.8

r308	r323
4	4	INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES (8,'concat(products.partnumber,\' - \',products.partname)',1,1,'',0);
5	5	INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES (22,'if(clientemailprojects.userid=0, \"global\", concat( users.firstname,\" \", users.lastname))',1,1,'',0);
	6	INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('303', 'if(clients.lastname!=\"\",concat(clients.lastname,\", \",clients.firstname,if(clients.company!=\"\",concat(\" (\",clients.company,\")\"),\"\")),clients.company)', '1', '1', '', '0');
	7	INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('304', 'if(clients.lastname!=\"\",concat(clients.lastname,\", \",clients.firstname,if(clients.company!=\"\",concat(\" (\",clients.company,\")\"),\"\")),clients.company)', '1', '1', '', '0');

r321	r323
162	162	INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES (304,'date','receipts.receiptdate','left','',3,'',0,'','date',0);
163	163	INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES (304,'status','receipts.status','left','',2,'',0,'',NULL,0);
	164	INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('303', 'if(clients.lastname!=\"\",concat(clients.lastname,\", \",clients.firstname,if(clients.company!=\"\",concat(\" (\",clients.company,\")\"),\"\")),clients.company)', '1', '1', '', '0');
	165	INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('304', 'if(clients.lastname!=\"\",concat(clients.lastname,\", \",clients.firstname,if(clients.company!=\"\",concat(\" (\",clients.company,\")\"),\"\")),clients.company)', '1', '1', '', '0');
164	166	INSERT INTO `tablefindoptions` (`tabledefid`, `name`, `search`, `displayorder`, `roleid`) VALUES (303,'All Records','aritems.id!=-1',3,0);
165	167	INSERT INTO `tablefindoptions` (`tabledefid`, `name`, `search`, `displayorder`, `roleid`) VALUES (303,'open items','aritems.status = \'open\'',0,0);