Some simple PHP, SQL and DOMPDF work

IN PROGRESS
Bids
3
Avg Bid (USD)
$29
Project Budget (USD)
$10 - $30

Project Description:
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.

Skills required:
HTML, PDF, PHP, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 0 days
$ 25
in 3 days
Hire TipMeSolutions
$ 33
in 10 days
$ 25
in 2 days