Find Jobs
Hire Freelancers

PHP/MySQL - Add automatic lot sequencing to existing data entry form

$30-250 USD

Slutfört
Publicerad över fyra år sedan

$30-250 USD

Betalning vid leverans
We have an existing PHP data entry form that accepts a few values from users (Item, Lot Number, Label Qty, etc). Currently the Lot Number field is defined by the user for all items. When a user enters an item number and a label quantity, the defined lot number repeats on every label in that print job (Example: 10 labels with Lot Number 12345) Items are currently being displayed in a drop down menu which is generated from a MySQL table. We would like to add a feature to this form so when an item is selected, the page knows if it is a "Kit" item or not (this value is defined in the item table along with every item number). If kit_item = 'Y' then the Lot Number field should be hidden from the form (or disabled) and the lot numbers for the requested labels should be generated dynamically from a sequence. Both scenario examples: Method 1: Non-Kit Items (current functionality) User defines a label qty of 10 User defines a non-kit item (Item1234) User defines Lot Number (9876) 10 labels print for Item1234 all containing lot number 9876 Method 2: Kit Items (New functionality) User defines a label qty of 10 User defines a kit item (KitItem4567) Lot Number field is disabled automatically when item is selected 10 labels print for KitItem4567 - each with a unique Lot Number 001 - 010 We can define a table for this that can hold the starting sequence number and use for tracking of these numbers going forward. Or if you have a better way of doing this, we are open to suggestions. The simplest and most elegant solutions are best. With the existing functionality (Method 1), a single record gets inserted into a MySQL table since the lot number is the same for all labels in the request. For Method 2, I expect a loop will need to be used to insert a single row for EACH label in the request, each with its own unique sequenced lot number.
Project ID: 22715301

Om projektet

25 anbud
Distansprojekt
Senaste aktivitet fyra år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
hello! I can do the feature you've requested. I'll be using a loop as you've described and an incrementing number for the lot number. also regarding the disable of the field, I'll be using ajax calls in order to get the kit value as well. oh yea, I can take a look at the code and clean it out a bit. will be waiting :)
$166 USD Om 1 dag
5,0 (53 omdömen)
5,9
5,9
25 frilansar lägger i genomsnitt anbud på $146 USD för detta uppdrag
Använd avatar
Hello, which framework are you using for this? It seems using jquery will do this job. If you provide me cpanel I can handle today.
$80 USD Om 1 dag
5,0 (1321 omdömen)
8,7
8,7
Använd avatar
HI, I can assist you with PHP/MySQL . Here is a sampling of the few of my work contained at my portfolio: https://www.freelancer.com/u/extreamcode.html This is a placehoolder bid, I would be able to quote final price and time after discussion. I highly value professionalism and hold myself strictly accountable to my clients. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Asad Sajjad
$140 USD Om 7 dagar
4,9 (113 omdömen)
8,0
8,0
Använd avatar
Thank you for your posted project and hope you are doing great. I am Neeraj and very happy to have a chance of bidding your project. I've read your project description carefully and would love to work on this project with my experience in the development activities. ******Please send me a message so that we can discuss more.****** Gladly waiting to serve you with my extensive skills. Thank you for reading my proposal.
$100 USD Om 10 dagar
4,9 (425 omdömen)
7,6
7,6
Använd avatar
Hello, i am ready to help you update/make changes to your existing data entry form as per requirement. I have gone thro the details and confident to implement the task. I am PHP expert and assure you quality work and long term support. Please open message board for further discussion. Thanks Ramesh
$140 USD Om 5 dagar
4,8 (108 omdömen)
6,6
6,6
Använd avatar
I am expert in php/MySQL and well suited for this job. It will require ajax validations for doing this job. Are you using any ecommcerce platform or it is purely custom php based site. Please provide me details over chat. Keen to discuss this project with you.
$100 USD Om 2 dagar
4,9 (159 omdömen)
6,2
6,2
Använd avatar
Hi, I am very interested to your project and ready to start right now. I have read your project requirement carefully. I have 10 years plus experience in web developing I can meet your requirement Give me one chance to work for you, will sure give you 100% high quality and exact that you want. I can finish your job within the necessary time frame, Will wait for your replay Thank you Regards: Shahzaib
$50 USD Om 4 dagar
4,9 (85 omdömen)
6,3
6,3
Använd avatar
Hi there !!, I have 9+ years of experience in Software Development, acting in national and international projects in many areas like: analysis, Architecture, Development and Testing. *** 300+ projects with 100% feedback *** 9+ years of experience (Web Development & Software Development) *** Best price with 100% satisfaction. *** Working 6 days : Support for 7 days a week. I can Start Immediately.
$60 USD Om 3 dagar
5,0 (43 omdömen)
5,5
5,5
Använd avatar
I will do it for you. How much time do you have. Please let me know if more details on chat. Already completed many projects
$30 USD Om 1 dag
4,8 (61 omdömen)
5,0
5,0
Använd avatar
Hello, how are you? As a php expert with abundant experience, I'm glad to see your project. I can do my best to help you. Your project is very suitable for me, hope your good response. Thanks.
$250 USD Om 7 dagar
5,0 (12 omdömen)
4,5
4,5
Använd avatar
Hello Sir/Madam, We will do this job as per your expectation, We have more than 8 year of experience in Web Design & Development, Mobile Application Development. We are the ones you are looking for your project development. You will get 100% satisfaction on complete Looking forward to hear from you Cybersify
$140 USD Om 7 dagar
4,4 (22 omdömen)
4,5
4,5
Använd avatar
Hello. I have just reviewed your job description carefully. ALL SKILLS you need have never been problem for me. Anyhow, I can solve any problem there as I have long years of experience in web development. I'll be great for an interview and can offer better estimate of time frames and costs. I assure that you will get high quality result in a short period of time. Honest and Trust, Never give up Ready for anything Looking forward to hearing from you soon. Thanks!
$140 USD Om 7 dagar
5,0 (5 omdömen)
3,9
3,9
Använd avatar
Hi, I have checked description carefully. When is your deadline? Could you call me now? If you want to perfect the result, please hire me. I will complete in a short time.
$250 USD Om 7 dagar
5,0 (3 omdömen)
3,0
3,0
Använd avatar
Hi there. Nice to meet you. I'm a Website design expert and FULL Time Developer. I have checked your requirements carefully. I have the rich experience in Website design, PHP, CSS, Javascript, WordPress, Anglarjs, Vuejs, Shopify, etc. After I had been majored the mathematics, I am working in the web development filed for about 9 years. My main skills owned in the process is C/C++, PHP, HTML, CSS, JavaScript, Nodejs, Vuejs, etc. If you can employee me to improvement this project , I can get a cool result that you want within the quick turnaround times. I hope to keep relationship with you, and help with all your IDEA*s come true. Goodbye while looking forward to a successful reunion with you immediately.
$140 USD Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hello mate, I very well understand the concern and request you to provide me with cPanel so that I can review and adjust the automatic lot sequencing issue accordingly. To give a brief about me, I am a PHP developer with over 6 years of experience and have worked on similar issues before, therefore you can totally rely on me with this job. It will be fruitful if we come in chat for further disscussion post which I can showcase some of my past works as well. Warm Regards, Rachit
$250 USD Om 1 dag
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för CANADA
huntley, Canada
5,0
162
Verifierad betalningsmetod
Medlem sedan aug. 24, 2005

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.