PLEASE READ CAREFULLY BEFORE BIDDING
I am currently using the Siwapp Open Source invoicing software ([url removed, login to view]), and wish to have a seperate page created with a couple search forms and the query results... These pages must include a security check to see if person visiting the page has already logged into the siwapp invoice software (using the simfony php framework)
SEARCH FORM Requirements
#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 [url removed, login to view]
If Series = Invoice OR Expenses Then forward to [url removed, login to view]$[url removed, login to view]
If Series = Estimated Then forward to [url removed, login to view]$[url removed, login to view]
#2 I want to be able to do an extensive (Not a simple: if xyz LIKE xyz) search on Customer Address, 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 entered or part of the string
siwapp_pcaustralia_com - [url removed, login to view], [url removed, login to view], [url removed, login to view] (Customer Notes), [url removed, login to view] (Personal notes), [url removed, login to view] address1&2.
#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)