Cancelled

SQL Queries and Simfony PHP work - Simple job

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)

Skills: MySQL, PHP, SQL

See more: work reference, what is job id, what is a personal reference, simfony php, php string to html, php simfony, open source sql, ok job match, job reference page, job for editing, editing job search, common string, common query, where do i want to work, job invoices, sql queries, simfony, php pdf invoice, database html sql, simple notes database, search form php database, php sql pdf, simple php email read, sql created, php table pdf

About the Employer:
( 7 reviews ) Hornsby, Australia

Project ID: #4761327

2 freelancers are bidding on average $35 for this job

farhaoui

Thank you for giving your precious time to review my bid and check PM! Our Reviews speak for us. Thank you

$33 USD in 3 days
(51 Reviews)
5.1
friendsgroupphp

Sir we can do this. But we need some more [url removed, login to view] are group of friend. We do jobs together.

$25 USD in 3 days
(0 Reviews)
0.0
krgsoft

lets discuss the matter

$45 USD in 3 days
(0 Reviews)
0.0