I am currently using the Siwapp Open Source invoicing software, and wish to make a couple very simple PHP/SQL Customisations. Also one small modification to dompdf.
#1 SEARCH FOR INVOICE/ESTIMATE/EXPENSE BY NUMBER
HTML Form Fields:
Series Drop Down: What sort of record is it?(invoice, estimate etc) List Options Taken From Below Query
Taken from SELECT * FROM `series` LIMIT 0 , 30
Number Text Field: what number invoice/estimate/etc are we looking for
Submit Button: Lookup result and forward to requested inovice/estimate/expense for editing.
SELECT * FROM `common` WHERE `series_id` =$SERIESDROPDOWN AND `number` =$NUMBER LIMIT 0 , 30
This should then re-direct me to the equivilant editing page of that invoice. EG http://pcaustralia.com/invoice/invoices/edit/16
If Series = Invoice OR Expenses Then forward to http://pcaustralia.com/invoice/invoices/edit/$common.ID
If Series = Estimated Then forward to http://pcaustralia.com/invoice/estimates/edit/$common.ID
#2 I want to be able to do an extensive (Not a simple: if xyz LIKE xyz) search on Customer Notes, Personal notes, Product reference, product description, then return a table with the date, order number, client name, and the final column showing the Database field that was matched (EG, if it matched the product description, show the content of the product description in the "match" collumn.
This should be able to either match the exact string enter
siwapp_pcaustralia_com - product.reference, product.description, common.terms (Customer Notes), common.notes (Personal notes).
#3 I WANT THE GAP/MARGIN ON THE ATTACHED PDF EMAIL INVOICE THAT IS EMAILED TO BE SMALLER UP THE TOP AND DOWN THE BOTTOM (margins not so big)
Further customization to come in future.