Some simple PHP, SQL and DOMPDF work

In Progress

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 [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 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 - [url removed, login to view], [url removed, login to view], [url removed, login to view] (Customer Notes), [url removed, login to view] (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: HTML, PDF, PHP, SQL

See more: dompdf table sql html pdf, what is a personal reference, some search string, php string to html, open source sql, common string, common query, sql and c, php sql, php pdf invoice, dompdf, database html sql, simple notes database, php sql pdf, php table pdf, sql final, pdf form drop list, gap php, submit button pdf work, php lookup, simple invoice database, pdf text php php, sql select order, invoices html, query php product

Project ID: #4729951

Awarded to:

ideahamster

I can do this project.

$25 USD in 3 days
(1 Review)
1.1

3 freelancers are bidding on average $29 for this job

bdphpguru

Sir, I hope I am able to help you. I have more than 2 years experiences in web development. Details given upon discussion. Regards, Bdphpguru

$30 USD in 0 days
(4 Reviews)
2.8
TipMeSolutions

Experienced Web Developers here.. check PM

$33 USD in 10 days
(0 Reviews)
0.0
geocity

Hello, I am interested in the project. Thank you.

$25 USD in 2 days
(0 Reviews)
0.0