Suljettu

Solve my Code - PHP, JQuery, Ajax

I want to create a dynamic form which will have the following fields:

Date | Client | Station

Product | Batch No | Quantity | Add / Remove Button

----------------------------SUBMIT 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

Output table:

Should be:

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.

Taidot: PHP, AJAX, Javascript, jQuery / Prototype, MySQL

Näytä lisää: php jquery ajax file manager, ecommerce cart php jquery ajax script, file upload php jquery ajax mysql, php jquery ajax oracle, php jquery ajax rating, comment section php jquery ajax, php jquery ajax quiz, php jquery ajax coupon, php jquery ajax optimization, php jquery ajax order item, php jquery ajax login form database, tic tac toe example php jquery ajax, php jquery ajax widget

Tietoa työnantajasta:
( 0 arvostelua ) Muscat, Oman

Projektin tunnus: #24088463

22 freelanceria on tarjonnut keskimäärin 108$ tähän työhön

jamesmartin81

Hi, I've carefully checked your "Solve my Code - PHP, JQuery, Ajax "and really interested in this job. I am expert in I am ready to start right away. I have reviewed your job description as well and very confident to Lisää

$60 USD 1 päivässä
(191 arvostelua)
6.3
irfankhokhar1986

I have gone through your project description. ***You will just see my reviews..!!! My skill PHP, Laravel, Symfony, CakePhp, Zend, Yil, CodeIgniter, Lithium, osCommerce, Wordpress, Joomla, Drupal,Magento, Smarty, Mas Lisää

$50 USD 2 päivässä
(105 arvostelua)
5.7
WordpressGirl

Greetings, We has significant experience in development and has a successful track record with similar clients and projects. We pride ourselves on delivering only the best results for our clients so that they see an i Lisää

$130 USD 7 päivässä
(36 arvostelua)
5.8
sodiqa32

Hello, I am pleasure with your job as detailed. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do have a couple of questions, but first I’d like Lisää

$30 USD 1 päivässä
(21 arvostelua)
5.2
Rashedmallick

Hi Sir, I have read the job description and very interested in this job. I have 9+ years of experience in the web development field. So, I have a lot of experience in PHP, Mysql, Jquery, Ajax etc. Please leave a messa Lisää

$100 USD 2 päivässä
(7 arvostelua)
5.1
milosjovanovic88

Hi, My name is Milos from Serbia who is specialized in Web. I am familiar with PHP/Javascript. I estimate to complete your project within a short time after clarifying all requirements, project details. I would appreci Lisää

$100 USD 1 päivässä
(3 arvostelua)
4.4
csuciu38

Hi! Your project seems very interesting to me. I have the experience and all the skills in need to accomplish all requirements. I am available and ready to start working. We can discusse on private about the technolog Lisää

$100 USD 7 päivässä
(6 arvostelua)
4.4
sejaltanna

Dear Client, I am glad to inform you that I can create an elegant website for you in short time. I have 8+ years of experience in technologies like PHP, HTML, CSS, Wordpress, Codeigniter, Prestashop, Laravel, Angu Lisää

$200 USD 5 päivässä
(30 arvostelua)
4.5
olegprokopiv39

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.

$100 USD 2 päivässä
(3 arvostelua)
3.6
bakulsinha

Hi there, I'm interested in this job as you described initially. I am here to help you out. You can use my experiences. This is Bakul Sinha Full Stack Developer having 8 years of experience in web design and developme Lisää

$200 USD 7 päivässä
(12 arvostelua)
3.7
femisorinolu

Hello, I am a computer science grad (Master's degree) and a Java/Php expert with 5 years of experience. I have read through your project description and I can confidently help you with your task. I have a track rec Lisää

$140 USD 7 päivässä
(10 arvostelua)
3.3
nemanjadj20

Hello? I have worked on LAMP STACK projects to what you are looking for, and I am confident I can exceed your expectations. Thank you for your time. I have attached samples of work very similar to what you are seeki Lisää

$100 USD 1 päivässä
(1 arvostelu)
2.7
salmanpml

hi. i understand all of your requirements. i have much experience of these kind of projects. POS and inventory Management Having Experience of Web Development More than 8 Years, Expert in HTML, CSS, jQuery, JavaScri Lisää

$30 USD 1 päivässä
(6 arvostelua)
2.6
umairali8062

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

$140 USD 7 päivässä
(4 arvostelua)
2.3
effort2worke

HI Sir/Madam, As i can see the your requirement. according to your requirement you need a search functionality with submit button, so that user can search station. data selection, reporting process form backed, view re Lisää

$120 USD 15 päivässä
(6 arvostelua)
1.8
Pluton1

I CAN COMPLETE YOUR PROJECT Perfectly! I have enough experience in Java, C#/.NET, QT/C++ for over 7 years. I can design the architecture by your requirements and following the software development process. I am designi Lisää

$140 USD 7 päivässä
(1 arvostelu)
1.3
DenisDrozdov

Hello, how are you? Thank you for your opportunity to bid on the project. I have developed web sites for five years, including web scraps, shopping sites, business web apps, and web API integration. And I have mainl Lisää

$50 USD 7 päivässä
(1 arvostelu)
1.4
chintanSanghani

Hello there, I have just read your job description carefully and i am very interesting on your project. I have 5+ years of professional experience in PHP/Mysql/Mongodb programming. i also have sound knowledge of workin Lisää

$100 USD 2 päivässä
(2 arvostelua)
1.4
Sanjana6291

Hello, I have read your project description. I understand the all procedure you explained in your project description. It's easy for me. I can complete this project in short time. I have 3 years experience in PHP, J Lisää

$120 USD 4 päivässä
(4 arvostelua)
1.2
muhammedahmad

Hi, I have read the requirements. I just mentioned the maximum number of days. I believe the amount I mentioned is reasonable. It has the export features as well. But before proceeding further I would like to clarify Lisää

$200 USD 5 päivässä
(2 arvostelua)
0.9