Devam Ediyor

481245 Inspection Form - Project

** posted on March 1st

What do I need?

=================

A simple script wrote in PHP that allow fill a form and storage the results in a MySQL database.

Where does the scripts and files should be placed?

=======================================

All the scripts and files should be paleced at [url removed, login to view] (I can do that, once received the source)

- [url removed, login to view]: script that allow fill anew form, using the information at [url removed, login to view] file

- [url removed, login to view]: script that allow search at planette_abook database / address_book table and select ONE customer from the table.

Data base structure and details:

Database name: planette_abook

username: planette_abook

Password: wp47shwn53

location: localhost

table: address_book

Fields:

customer_id: Unique ID

company: Customer Company Name (text)

address: Customer address (text)

tel: Customer Telephone (text)

mobile: Customer Mobile phone (text)

contact: Customer contact name(text)

e-mail: Customer e-mail (text)

type: Customer type (text)

table: insp_generals

Fields:

date: date of the inspection

insp_id: Inspection ID

customer_id: Customer Id (linked with ID at address_book table)

inspector: Inspector name

ticket; ticket number

notes: Inspection note

table: insp_details

Fields:

insp_id: Inspection ID

item_detail: Item detail

item_cost: Item cost

item_qty: Item qty

item_total: Item total cost (cost*qty)

[url removed, login to view] description.

====================

This script should allow fill a new, save or retrive an Inspection form, search and select a customer from addres_book table, update customer information (Company name and Contact name do not be changed). This script should use the information [url removed, login to view] to show the appropiates field in the form.

- Search Customer: Should browse fields company and contacts from adress_nbook table ordered by company + customer, allow a simple search text box where customer can refine the search with an string as part of company or contact. Customer must be able to select ONE record and return to the main screen.

- Fields company and contact must not be editable, the other fields shon should be edited and Updated at the addres_book table when "Save & Sent by e-mail" is pressed at the end of the process.

- No. es the Insp_Id and must be an unique refrence generetade by the script, it is not an editable field.

- The body of the form should be retrived from the [url removed, login to view] where is storage the caption and the price (both of them not editable). The script should calculate qty * cost in each item and totalize this at the end of the screen.

- The Search text box at the up right side of the screen is used to search this string as part of any of each fields of the table insp_generals, allowing to select one of the shown records an refresh the result in the main screen. All the refresh items should be editable (NOT Company, NOT contact). If Saved, insp_general fields, insp_details field and address-book fields must be updated

NOTE that when ever Save & Sent by e-mail be pressed insp_general fields, insp_details field and address-book fields must be updated.

Add Customer button should execute the screen [url removed, login to view] not developed at this project (this script allow to insert a new record to the address_book table)

[url removed, login to view] Syntax description

=============================

This file should be used to generate the form information that is not static, at th middle section of the screen.

- If the line begins with < the script should also show the content as the line as reference, this is not a field of the form, is only a line label.

- Other case the first part of the line is the caption, the second (after a colom) is the cost.

- The section finish with <>.

- After that there is a final line with the e-mail address where the form should be sent.

What we expect to receive:

=======================

- [url removed, login to view]

- [url removed, login to view]

- other files (if needed)

- written instructions about how to install

Attached files:

Inspection [url removed, login to view] that includes:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Inspection [url removed, login to view]

[url removed, login to view]

[url removed, login to view] (sample file for testing the script)

Beceriler: Her şey Kabul, HTML, MySQL, PHP, Kabuk Betiği

Daha fazlasını görün: what is record in data structure, what is a search string, use case includes, update data base by form & php, table data structure, string in data structure, string data structure, search text string, sample received form, php form search mysql database, phone book data structure, how to process the data base, gif to txt, finish line com, data structure reference book, data structure in c notes, data structure book, book on data structure, book of data structure, book for data structure, book data structure, source inspection, pa id, how do i save, ticket id

İşveren Hakkında:
( 3 değerlendirme ) Panama, United States

Proje NO: #2227155

Seçilen:

bhupal123

====== will do it for u.. Let me know Juan... Thanks. ======

3 gün içinde 120$ USD
(570 Değerlendirme)
6.5