Page 1 of 1

Bulk Receiving into a MYSQL Database

Posted: Tue Jun 10, 2008 11:05 pm
by texmansru47
Question: In MS Access (I know the devil itself) you can create a entry screen where there is a set limit (let's say 100) and in that screen you can enter in each unit and the data will be listed on the screen (real time) as you enter it and when you reach 100 it will not let you continue.

In PHP/MySQL is there something similar? Let's say you are to call one table to pull the data from (model type, batch number, qty allowed, etc) and then an entry screen where I can enter the data one by one, and it will list on the screen for me. I know I can create a loop to increment as I receive and once the 100th item is entered the loop will (should is more like it) prevent the user to enter anymore data into that batch.

Getting the data on the main screen as you enter it without going to another page is the main concept I cannot figure out.

Texman

Re: Bulk Receiving into a MYSQL Database

Posted: Wed Jun 11, 2008 12:55 am
by RobertGonzalez
Can you go into a little more detail on this? What feature of access are you talking about? Is it a query view? A form? Please explain a little more.

Re: Bulk Receiving into a MYSQL Database

Posted: Wed Jun 11, 2008 5:27 am
by superdezign
If it's all on one page, give them 100 available entries, and only use those entries.
If it's one entry per page, keep track of the current entry via the database, checking how many entries have been made so far.

Re: Bulk Receiving into a MYSQL Database

Posted: Wed Jun 11, 2008 8:55 pm
by texmansru47
Can you go into a little more detail on this? What feature of access are you talking about? Is it a query view? A form? Please explain a little more.
I wish I could. What I discussed is from an application we had at my old company... when it filed bankruptcy we could not get any of the source code. What it was is fairly simple. It was a single screen that listed all the important data of the batch. In this case a "batch" is an order of X amount of a particular product. So when the user selects a batch number or order number, the particulars on that order are shown on the screen (in MySQL I believe that is a simple SELECT * from rightdatabase where... type thing then populate the portion of the screen where that data is to be posted).

When the proper batch is open and the user has to receive the goods into batch, a popup screen is there where you can scan in the data per item (serial number, asset, SKU, etc) - a simple table like screen. When you enter the data in that table pop up and you click the submit button, the popup window refreshes to be a blank table like screen again and in the back on the main screen the data you just entered is listed in the middle section which on our old system it was a big blank area much list the post screen on this service when you post a comment or a question to the forum.

This action continues until you enter the last unit (in my earlier example I used 100)... then the pop window disappears and the main screen has the list of all data you entered, and a screen message pops up and states that this batch is full.

I'm sorry I cannot provide code or examples, since again I was unable to get copies of the code in time. but I would love to be able to recreate something like this in Linux, PHP, Javascript to see how it will work with MySQL.

I hope this helps a bit more. Again this is more of a hope this is possible but I cannot figure out the following:

1). The main screen detailing the users input and the pop-up returning until the batch is full.
2). The mechanics to post the initial data from one table and process this input to another table and provide the link of the Batch Number between the two tables... I think I have an idea (something like this:

Code: Select all

Run a query to pull something like this:  SELECT * from TABLE1 WHERE Field1 = "'$_POST[Fieldrequested]; then push the correct Batch data to the second table (for each unit received into table 2 - the pop-up screen mechanics)
Again, I'm sorry for the vague details I'm posting but it is really all I can remember.

Thanks,

Texman

Re: Bulk Receiving into a MYSQL Database

Posted: Wed Jun 11, 2008 9:00 pm
by texmansru47
If it's all on one page, give them 100 available entries, and only use those entries.
If it's one entry per page, keep track of the current entry via the database, checking how many entries have been made so far.
The main problem is the available entries will defer from Batch to Batch... One batch may have 100 entries but another may have 450. Could this be processed by an array loop of something like:

Code: Select all

if (mysql_num_rows($results) > 0)
Where the $results is the variable pulled from Table1.Qty???? The Quantity in Table 1 is the amount of entries allowed to be received in this Batch.

Texman

Re: Bulk Receiving into a MYSQL Database

Posted: Wed Jun 11, 2008 9:32 pm
by superdezign
I'm not sure that I follow you anymore... o_O

Are you receiving input or producing output?

Re: Bulk Receiving into a MYSQL Database

Posted: Wed Jun 11, 2008 10:29 pm
by texmansru47
Good question.... let's see if I can answer better.

The output on the screen (details of what the user is entering) is for the user mainly to see that the product is being received) but what is the real reason for this is to have the data being entered into the system are associated to the correct batch. For this operation I'm trying to enter product into a particular batch and keep what is entered into a particular batch stays with that batch, until the work is completed and then shipped out. For this operation I'm trying to process a logistics progression (same in same out).

The batch is created as an in-house reference numbering system, that will help keep and track a customer's bulk order for repair or repackaging (logistics and reverse logistics) since they will require the same type and model of product in the same order they send us.

Additionally this information will be required for the MasterPacking (barcode packaging on the outside of the box, Packing list, and invoicing and reporting for other avenues in the system. The receiving piece is a critical piece of any ERP type system, and I'm trying to see if this able to be created in Linux based solutions.

I'm sure this did not help, but I fear it made it worst. I have the logic of what I need to accomplish but I do not know enough about PHP, JavaScripting and MYSQL to figure out if this action is feasible and possible... I hope it is.

Thanks,

Texman

Re: Bulk Receiving into a MYSQL Database

Posted: Thu Jun 12, 2008 5:58 am
by superdezign
texmansru47 wrote:I'm sure this did not help, but I fear it made it worst.
Only because you are speaking in the abstract. If it is to protect the actual system from being revealed on a public forum, then simply give us hypothetical examples.

i.e.
Customer inputs [data] on a form that creates an order
The form displays [data] to the user for review
The user selects the batch the product belongs to and submits [data]
The the product is added to the batch
The user is able to view all products in the batch, or add another product

We can't help you if we don't know what you are doing, so at least give us some idea beyond formal concepts.

Re: Bulk Receiving into a MYSQL Database

Posted: Thu Jun 12, 2008 7:56 am
by texmansru47
This is not a pre-existing system, but more of a need to create but I'm stuck in trying to see what to use to create it. We had a similar system process at my old location but it was in MS Access... but it worked great, but I'm trying to cut cost and MS loves to tax your overhead with licensing fees. I would perfer PHP/Javascriptingand MySQL.

Your Breakout is spot on:
Customer inputs [data] on a form that creates an order
The form displays [data] to the user for review
The user selects the batch the product belongs to and submits [data]
The the product is added to the batch
The user is able to view all products in the batch, or add another product
with a few corrections:

1) User can either scan in or type in a Batch Number or select it from a previous screen (on the Batch lookup screen it will list all the open batches for that type of order to be received).
2) The form in question will be in two parts... the upper or top part will list the Batch details for the user to review to ensure this is the correct batch to be used.
3) the User can click on an INPUT button to start the data input on the entry portion of this screen (lower section).
4) once the INPUT Button is started a pop up window (can be a php page) that allows the user to input the data for the order (here is where they would enter the details of each unit to be received into the batch in question) and after each unit entered that screen would refresh to a blank screen ready for the next unit while the main screen in the back refreashes to list the units that are being received.
5)when the order is completed, after the final unit allows in that order (i.e. a batch in question has a unit count of 100, and on the 100th unit being entered) the entry window disappear and a message would pop up indicating that the order/batch is complete.
6) the user then can use the main screen to review the data that was inputted into the batch and verify all is well.
7) that data will be in a particular table in the database to be used for reporting, invoicing and will be required for packing the product up for shipping back to the customer.

I'm sorry this is still vague. I'm an IT executive and infrastructure specialist by trade... what developers need (details) I cannot provide on something that does not exist yet. Typically I can convey this information as I did early on (first couple of entries on this forum thread) and the developers who workedfor me had no problem making it happen. I will try to provide as much input as possible.

Thanks,

Texman

Re: Bulk Receiving into a MYSQL Database

Posted: Thu Jun 12, 2008 8:01 am
by superdezign
Okay... You've gotten that far. We can't create that whole thing for you, but we can help you along the way. Now that you're organizing it better in your head, you should start getting it down and begin the development process. That, or hire a programmer to do it for you *ahem* *cough* *cough* *sneeze* *hint* *wink*.

Re: Bulk Receiving into a MYSQL Database

Posted: Thu Jun 12, 2008 8:13 am
by texmansru47
I appericate that offer and I will see what I can do. I was not asking for the section of the program to be developed just whether or not it is feasible in php/javascript/MySQL and maybe some clues as to where I can find some data on the coding syntax for particular actions. Like I indicated earlier on I cannot figure out:
1). The main screen detailing the users input and the pop-up returning until the batch is full.
2). The mechanics to post the initial data from one table and process this input to another table and provide the link of the Batch Number between the two tables.
That is where I cannot get my logic moving since these above listed tasks I have no idea to start to develop the concept since I don't know the functions/commands for PHP. If I can find those commands/functions and see if they will be able to produce the actions I desire then I can complete my thought processes.

Thanks again,

Texman

Re: Bulk Receiving into a MYSQL Database

Posted: Thu Jun 12, 2008 8:40 am
by superdezign
Firstly, I'd suggest you move away from the idea of "having a pop-up." You won't need it, and it'll only make thins more difficult. If you avoid client-side technologies such as JavaScript and stick with the server-side, you'll simplify the production.

A good place to start would be actually drawing out the process, page by page. No need to worry about design of the pages, focus on the actual process of pages that the user will traverse through.