SQL Queries and Simfony PHP work - Simple job

Budget N/A
Bids 3
Average Bid $34

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)

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • krgsoft Profile Picture

    krgsoft

    Kathmandu,  Nepal

    I am working in programming field since last 6 years. I have worked in desktop (vb/vb.net/c#), web technologies (asp.net/mvc) with related technologies (jquery/IIS management) and database (sql server / my sql ). I have complete many projects such as, 1. Complete HRMS System 2. Attendance Management System 3. Payroll System 4. Inventory and Fixed Asset Management System 5. Accounting System 6. Various customized applications

    PHP, ASP, Visual Basic, and .NET

  • friendsgroupphp Profile Picture

    friendsgroupphp

    Kolkata,  India

    We are skilled and experienced AJAX Developer. We are talented and qualified AJAX Developer. we have an excellent CSS skills as well as skills in the areas of HTML and HTML5. We have an excellent interpersonal and communicative skill too.weI have been working as a Javascript Developer for the past few years. We are highly qualified and have keen grasping ability which has earned me many credentials. We are willing to be hired by you.

    PHP, Java, .NET, and Graphic Design