Collaborate on Restaurant Invoice Generator for Product Management with Ease Using airSlate SignNow

Restaurant invoice generator for Product Management

hi friends in the part 1 of this restaurant management system we have seen how we are taken and the set of static menus means there is no scope of changing in the part 2 we have seen because we kept our items in the database so you can change the lunch here i am just clicking the three radio buttons to select a particular category of products or these items so breakfast lunch or dinner whatever it is now we have also seen how we are generated the bills also let just uh see once more this is i'm selecting item these are touch also i can increase we use the touch also to increase or decrease the items now let's have to click get bill so once i click the get the bill so here the bill is generated so this is the 10 percent tax and all now i suppose i have received the cash now i will confirm and reset what happens now is from now onwards this once i click the confirm this entire whatever the bills are generated and all it will be stored in a database so once the database i can generate the invoice of the bill anytime i want even the unique number bill number i will generate and that build number can be used in future also to generate the invoice now let's see how that part works here you can see moment i am confirming fine it has come to the reset mode so flex build but i can generate because now the all the whatever is sold those items with its price this uh tax and all are stored in the database so now i'll just click this bill so here is my invoice so bill number 90 this is the unique bill number here and which date what are the items total tax and total to keep it simple we have just giving this much information only you can further extend it although the discount should be on the product basis or tax how much the tax will be you can change it now this data is stored in the database now let's just close it and see um just remember this bill number is 90 which is a dynamical it's auto increment field which comes from the bill table now let's just close it and see next bill what the number will be i can just change it to dinner let's say it's dinner so all the menu items are reflected the dinner items so now i'm just giving few more items i'm just adding to the menu so these you know this pin boxes and all are created dynamically based on the number of items and all one more let's go here i'll go one more item fine now i'll say get the bill so here it is my bill is this much price quantity total everything now let me just confirm this fine it is okay here is a now the it is reset to the next bill but my invoice is generated or bill is generated so i want to see that i can click this you can see this invoice is generated now specifically what information should go to the invoice you can add up little bits suppose that gst number customer code because we have not used a customer code in this particular so we are not using that now let us see what happens to our database we are inside our phpmyadmin you can use workbrains or any other frontend you are if you are using to manage your mysql database or we will change the source also so that time will discuss further now in the part one we have seen this plus two product table this from this table our all the menu items are collected so these are categories availability so you can background you can connect the and see the other availability if you make it zero then this will not be available if you can category like breakfast is one lunch is two and dinner is three so like that you can manage the price and the unit we keep it this already we have discussed in the in our previous part two we have discussed this so now let's go back here now there are two more tables we have added one is plus two bills and plus two cells what happens when the plus to sell table whenever the bill is generated and we click that conform or reset at that particular time you can see that this items whatever is sold or whatever suppose there are 10 items three items are sold those items will be stored here here in this sl id this just auto increment id product id says what product is sold is the id is stored what's the price and what's the quantity now this you can say that why i am because it is already there in the product table the price why we are storing it here the reason is the price of the product may change at that particular sale time what was the price that we must store it it is 30 rupees here but tomorrow it may be 35 rupees but we cannot charge that again the previous bill so it is 30 rupees here now the bill number is a it suppose 10 night four items are sold in a particular bill so that all will have a common bill number and a bill date you may ask where from that will see because the next table plus two bills we generate this bill number and that we are bringing it here so in a particular bill say in this particular bill there are three items are sold so all the three items have a common bill name so that way any bill we generate we can pull out from that that what are the products sold under this bill name so let's just go to our plus two bills so this particular table here you can see this is the bill number recently the last item whatever we have generated the bill it is here so you can see here it is there so like that 91 it works so all the items we can like that so every first when we uh before storing it into the cell table we generate a bill number and this is the auto increment field so next number will be next digit next suppose it is previous bill was 94. so next bill will be 95. so like that this bill number will go bill date again it is the current date today's date we have taken and here you can say total value and tax why we are storing in fact total and tax both are it's a derived only from the total 10 percent tax you can take now here it is to keep it simple we have just kept it but if you feel that this should go to the sell caller table yes that's fine because what happens is tax rate on products may change and discount on suppose you want to give some discount but you will not give a uniform discount on total value so in that case the these two columns total tax or if you may add a future discount also all those will go to your particularly at the time of cell plus to sell that table it should go just to keep it simple and all this time we are doing it if you go make it more complex and all you can but better the product attributes should go to the cell table and whatever the bill attributes like what is the gst number customer id and all should come to the bill this particular plus two bills table so like that these are all those this three tables are used will have you can download the sql dump of it and it in your system so we'll see now let's just little bit will understand the code this is the two three files we have used this time and then we'll move further this is our main file where earlier also in part one and two we have discussed just change the file name to give you a different different version so you can download and work on it so already one and two source codes are available you can use that this probably will take one or two days because that add the comments and also you can it will be easy for you to understand the code so this is the one but here one difference is was this line number six it is a invoice whatever you have seen that bill is generated that we are keeping it in a separate file and calling it here so that file you will discuss that is there in the as my invoice so here it is now what happens here inside this is the key is this reset now once you confirm it the bill is confirmed now this reset function is triggered that particular button and in the part 1 and 2 we have seen how we have pulled the data from the database and created a dictionary and a tree view we have generated the list now what you are doing moment you click the conform and or reset one first all the items in is deleted from that that display is tree view and then we have appended one into variable created and all the spin boxes are reset to zero this already we have discussed now here some frames are management managed and here what you are doing is inserting the whatever the items were there in that whatever the sold item the list we are storing it into first into sorry that first we are generating a bill number so here it is insert into plus two bills your total tax bill date this these two uh three values we are telling under bill date is that today's date here it is if you want in different format you can't change because mysql stores it in ymd format if you are using excel or something in future you can change the format also so here it is now data i am giving it is passing the total and tax and the data here how i am getting total and all that's because we have already declared total as a global variable above it you can see and that total whatever is calculated in the my bill that total we are taking and note that here you can see the total tax final all this data dll we have declared it as global and here also you can see look at here here also this we are declaring inside the our reset one so those values are available to us and that value we are inserting it here dt is locally calculated and here it is now once it is done what happens this particular line number 16 i get the bill number so this is auto incremented field a dyno system will return me a bill number that i am storing it you can watch our other tutorials how this data is inserted and how a id is taken from the system now once this is done once this then what we do is we create the list also and our list of items whatever is sold you can see here there is a for loop dl is again a global variable which contains the list the items which are sold its price all these details that part we are in started inserting to plus to cell table so here it is quantity bill number builded and values and data is your this list this list is generated once whatever the we have seen the quantity sold the bill is not bill that is that is the list of items sold and all is generated that list now once that is over now we are just showing a button see this button is here this button runs clicks the function my invoice my bill number image at the top that has a function for the keeping the image at the top now this i am passing on the bill number only passing to generate the invoice now what happens the bill number why i am doing this and i am not included in this particular pages the reason is it should be a separate module so what happens from another application say i am just want to reprint the bill i will just key the bill number then the same function i can call it and generate the bill so the key here is i hope this is clear little confusing if you are if you are not acquainted with the inserting and storing from the database getting the in short id and all that you can watch our tutorials how to get those details and all rest everything is simple and for this particular page you have to very very much understand the local variable and global variable many of the global variables we use whatever data is changed inside a function for a google variable that is also available outside the function so we are using that this total this price of the total price tax and all these are part of the global variable now let's just come to the invoice you see now that when the button is clicked here we are just calling the my invoice function now my invoice is something what is we are being importing here or we call connected to here and let's go to my invoice now this file name is my invoice so inside that my invoice is another function this actually we are calling from another file also i can pass this data and call it this again i'll i can generate the uh invoice also that is the purpose why it is kept on a separate file and in a modular way so i can reuse it anyway this is just a child you can say it's a top level it's a child window in our web platforms we call it and this you can see i'm just generating a child window here top level background giving a white you can change it based on that little bit font adjustment now what i am doing i received the bill number this function receives the bill number that we are using and select from plus to bill where bill number then next is we are collecting all the using that particular bill number what are the items sold so that is there in the cell table so here plus to cell table is used now you see product name we don't have in the cell table only product id is there so we are connecting it this to product table and by linking with the id and pulling out the product name so that we are using it for displaying and all these are displayed all these are just display part only whatever the data we got it and here it is whatever the items list and all least price because this has to be generated dynamically because we don't know how many products are sold in particular bill number so we can't have a fixed number of uh items so i have to sell one so that is why inside a loop based on the number of items we have sold in that particular bill we are looping through and generating it these are all dynamically generated and finally rest of the thing is total and all tax calculation and all are just derived functions only it is derived from the data in fact this we have derived it to make it simple but think is there is a problem because here we are using a see this particular point we are using tax rate is 10 percent while generating the bill you cannot sow 20 percent actually this should have been from the table but to keep it simple we have used it like this so you can understand it and further for your practical uses and all you can further integrate it and automate it there was a question how the bill was generated so and why the gst tax rate discount to be fed what the issue here is suppose if the person sitting in the counter should not feed any data because at the background those data should be available if the tax rate is 10 percent it should be available in the system if discount is 12 percent it also should be available in the system because he in the counter if he's asked to select it he may select a wrong also he may not know it's increase of 10 percent it may go to 12 percent why to give a speeded and moreover every product may have a different rate of tax discount or tax also say on food items 20 percent discount then in that case back end the administrator can sit in the product table itself the discount figures can be fed so that way and while coming to the billing area the counter person has nothing to do only to collect the cash see the system how much money he has to collect color the cash generate and print out system will calculate the built discount tax and everything that's all friends so i thought of sharing the third part but follow the part one and two for the third part you must be thorough in the database integration and all and how the system works in the auto mode and all and this all the source source code will be within one or two days will be available to you and please share these videos with your friends and request them to subscribe and you i request one you once again please subscribe to our channel so this sort of projects and beautiful tutorials also we are discussing put your questions doubts suggestions what improvements you want in the comment section below ingly we'll try so thank you for watching and please subscribe to our channel