Transform Your Workflow with Invoice Bootstrap for Operations

Invoice bootstrap for Operations

hello friends welcome back so in this video we'll continue but before that I have given some restriction here read-only because I don't want user put something here and I have never leave this filled only discount because if he can if you want he can place discount value as well as aid amount how much customer is giving him and customer name is and rest of the period with restricted with read only option and the issue in the last video is whenever user pays order the record is inserted in two different tables right but when he pressed again the same record will be again inserted without any different unique ID or anything so we should restrict it this should not happen this is a bug we can fix this and by mistake I have deleted my products from the upper table so we don't have so much product I have inserted two products and K X will we can continue our work but before that we have invoice I cleared my tables also invoice details we have only four products here and in this video we will work on this stock once user place the order really decrease our amount sorry stock okay so we have given read-only here as you can place like this or in all the inputs and I want all of you write some PHP code for validation of the input field in order invoice until all the fields are filled then only you will allow otherwise you will not allow for the insertion of their card so I want you write for the code for this customer name and discount as well as for paid when these fields are filled then only you will allow otherwise you will not allow until then we have seen codes like this for validation in registration as well as in login so you can do this and you can take from them there also okay so let's begin here is our order or jeaious paid and once the user click on this order button I will send the request to the process state and process available for this in the Refresh to the okay so here I will send the request process to it and it will create the object for the managed class and do the operation but before that what I want I want the user to store the in your form information right then we will create the PDF of the PDF of the invoice right so I will create a variable invoice equals $2 hash and get order data this is the form ID don't forget and use serialize function of jQuery so it's a JavaScript and then we will have invoice folder list and then we can input your form if you want you can use the functions like we can use JavaScript jQuery functions dollar hash get order data dot trigger and trigger form research so it will reset or form after insertion of the record so let's see this choose product something else yeah add one more white custom name Swan and the count is okay give it is count of 500 paid amount will be one of seven triple zero order and you say order completed place okay it is not working I saved it sure my cache memory is the problem killing open sources that's what it'll chase and of course it is cache memory so let me refresh again it's happen with you in your browser tell me in the comment section otherwise I have to change a browser instead of for Chrome I will use Firefox okay fine now again I have to login in the order and play if this time different Russian harder or a completed and you can see our form is cleared once the order is inserted right but if you will press this button once again it will insert the MPD record so that's why I want you to write some PHP code on as well as jQuery code to prevent this condition after after all you learn a lot okay so let's say in your manager PHP and here the for statement Paulo and we have by luck I have total quantity as well as content quantity available so I'm just using this within the for loop and one thing know about the other databases we have constrained as well as we have constructed my scale but that constraint not working mask you'll if you want you can disallow any columns in your table and to store the negative value or any value less than 0 I tried in my skill but the problem is it executes our SQL query but its effect is not here no effect at all you are after giving constraint you can insert negative record so it doesn't affect anymore that's why I'm writing in a hard code dollar and remaining quantity equals $2 Q till its array array total quantity the dollar I subtract taller here quantity taller I so we have remaining quantities once for example a total quantity is 100 and user has taken three item so after subtract subtraction there will be 97 item remaining okay I'm going to write some comment that will help you to for in future there you're finding the remaining quantity after giving question 1 so we have remaining quantity and it is as I give an example so it should be a 97 if we'll remaining quantity so it's frame quantity less than 0 then we cannot sort that item here we will return order fail to complete or a failed complete else it is not 0 means we have products available in our database we can sold it so we can further solder so have to update the quantity taller-how I'm just using the simple tip we have query we are not using prepared external because here we do not require and this connection arrow query right here update name of the table the table spellings are a well write date table and it is products set I think something wrong oh my dear date paper star after there is no keywords like table update product set product stock equals $2 in quantity this will remain quantity where what unique thing we have we have name of the okay we have not unique we have we can figure it out or you can figure it out we have product ID product name yeah we have ID as well as you have product name so product ID is primary key we can use this for a tidy but here we have product name and this is also a unique it cannot repeat some using this product name because we have ratney here you can see now area we have correctly your product name tight where product name equals 2 dot dot here company and top of pie that's fine the query will execute and the record is updated update product it stock or if there's a problem first is all tie follow this and connection error fine hope it will work ah let's see before that I am going to clear my truncate people and name of the table is the invoice details page is clear where is table going live clear this one yes first point let's see okay before director we have to see that quantity managed now the for Samsung Galaxy si si we have 1000 stock right now let's see this the order extra money and then Galaxy s8 let's take one more and final quantity pi is also 5 now that will quantity EE you can see here also the total quantity thousand and five problem should be deducted from their account the very discount of 1008 amount is four four five plus zero place order you have an error in your ethical syntax and what it says Price Index to use neo galaxy-eyes a deadline 1 what does it mean who I'm sure it is about my query rate products safe product stop their product name I think did not work with query the elevator I want the new columns put it a stock product mean you I think because of this you have problem save it fine take this and refresh stony there is another problem negative 20 so it depends upon administrator also what he is writing but we should also write code for that you can like write code like if less than 0 then you can give a warning we were sent to the stands it till double zero order completed that's the reason K point is completed and it's your invoice we have 25mm we have inserted and there so this is the order date is not inserted our game and do is zero knowledge scene was details we have something a let's see price quantity 1 so we have taken one product should be nine nine nine okay it's also not decreased very happening you you you Jennifer here we're done a is working on watch five stones so it's working nine line pipe right now let's see you this though a scale statement is right or not always chair you he referred name collide I put ugly so they look at it they're done I think they've only one item tools kill analyst distance code orienting time too much powder in this filter is update perhaps a pair of the stock goes to nine nine five preferred name which is down the next is that's fine wide is not working it should work so various fine maybe the reason is this is not under the string key let's try this okay save this whistle final test refresh 5 4 double zero and order order completed yes 9 9 pipe the stock they have decreased amount finally it is good so I told you just work for these inputs and I have already taken so much time because of errors and in the next video we will work on PDF right oh thanks for watching and if you liked it so liked it and subscribe my channel I know all of you you watching this video not already subscribed but I am telling forward those who are new to this here ok bye