I want to create a dynamic form which will have the following fields:
Date | Client | Station
Product | Batch No | Quantity | Add / Remove Button
Date: Can only select current and future date. You cannot back date when selecting date on the form.
Client: This is a dropdown field which should get Client Name from clients table
Station: This is also a dropdown select field which should populate Station Name based on previous dropdown field selected in the Client dropdown. This filed should get data from station table.
The above fields should be inline in the same line.
Then will follow Product | Batch No | Quantity fields with Add / Remove buttons
Product: This is a dropdown field which should get Product Name from products table
Batch No: This is also a dropdown select field which should populate Batch Nos based on previous dropdown field selected in the Product dropdown. This filed should get data from batch table with batch no balance of > 0. Meaning if the batch no has a 0 balance it should not show in the dropdown options.
Quantity: Quantity can only be selected based on the stock balance available in the batch table in the column named balance, User cannot input quantity value of more than balance value.
Whenever we add rows, all quantities total also cannot be more than the balance available in stock in the batch table.
We should have the following tables:
client table with the following columns:
c_id: client id int(11) Auto Increment
client: This is client name varchar(50)
c_add: Client Address text
station table with the following columns:
s_id: This is station id int(11) Auto Increment
c_id: This is indexed related client id int(11) from the clients table c_id column
station: This is station name varchar(50)
products table with the following columns:
p_id: This is product id int(11) Auto Increment
product: This is the product name varchar(50)
batch table with the following columns:
b_id: This is station id int(11) Auto Increment
p_id: This is indexed related p id int(11) from the product table c_id column
batch: This is batch number double example 012345.23451
receivedqty: This is the quantity received of this batch
deliveredqty: This is the quantity delivered of this batch.
balance: This is the balance remaining of this batch
Once the form is submitted: it will update orders table
Order table will have the following column fields:
order no: To be pre defined number like TLS_2002_0001 and keeps adding value at the end.
date: Date captured from the form
client: Client selected from the form
station: Station selected from the form
product: Product name selected from the form
batch: Batch number selected from the form
quantity: Quantity selected from the form and this should add the balance value from in the deliveredqty column in the batch table.
if the User selected Add Rows button to capture multiple data, then we need to have additional columns added like for example the product,2 batch2 and quantity2 and this could be upto 10 different Added rows which means the columns can extend upto product10, batch10, qty10
order no | date | client | station | product | batch | quantity | .Totals at the side and at the bottom
if more than one product or batch number rows was added by user then we should be able to see all the added products eg product2, batch2, qty and so on.
Should be able to filter by Year and Month and Day
Should also be able to filter by order no asc or dsc
Should be able to filter by client or station
Should be able to preview the order on display and also to download excel and pdf formats.
Your input and creativity is also welcomed. Selection of the bidding process will be mainly onthe following:
Cheapest Bidder with Lesser delivery time and on first come basis.
22 freelanceria on tarjonnut keskimäärin 108$ tähän työhön
hello there! AS a senior web developer, I am very interested in your project. I have a lot of experiences about php, jquery and ajax. If you give me a chance, I can finish it in short time. THanks for your job posting.
I have read your project and I am an expert in this field. I can do this for you within due time and honestly. I also have a few questions to discuss. Kindly contact me and we will discuss time and budget. Thanks