Create the Perfect Invoice HTML Template for PDF for Product Management

Invoice html template for pdf for Product Management

hey guys welcome back so guys we are continuing our POS system in PHP so now guys in this video we are going to do the print option okay so basically we are going to create one order view print.php file and inside that we are going to design the billing format and that bilding format will be printed as PDF or you can use a control P to print that so now guys let's get started so in previous two three videos we have already made that uh format okay so while if you create the order and let me add some items here while creating the order okay let's select online payment let me add some phone number proceed okay customer not found let me add this new number as with user 3@gmail.com and you can make it as user three or with and now let's click on Save okay done let's proceed again so this is our view guys okay this order summary. PHP code we are going to copy and paste for the print option okay and let me save this order so once you click on Save okay and here also we have print option right so we are going to do that functionality here also print and download part so guys now let me close this everything and let's get started here so first let's move to our ord. PHP so let's close everything and let me Zoom it so it will be more clear and this is my admin folder inside admin folder we need to go on orders. PHP file and here is our TD tag for the print button okay let me Zoom it more okay so and let's add the file name here like to read direct orders view print.php file and we need to give the tracking number also so let me copy from top and paste here that's it guys so now let us copy this file name and create inside the admin folder so I have created it now and now guys you need to import the basic header and footer part so let us copy from the orders table itself let's copy this paste here let's move below at the last and with some ending tags let us copy and paste all set so now guys you just need to add a a tag here for the back button us a class danger float and let's make this button as small and which will be redirected on orders. PHP and let's sh this heading print order okay so now guys let us see this output first let's move back refresh and let's click on the print button perfect so you are on orders view print.php with the tracking number cool so now guys let's get started with the coding so now guys let's open PHP close PHP check with the if condition and in the else you can tell no such parameter found so in this if condition we are going to check that our get method of your tracking parameter is found or not okay so if it is found then you're going to paste here if it's not found then you're going to show some like no tracking number parameter found so let me copy from the previous video code in the orders view we have that structure design let me copy this so I don't need to redesign it again okay so here I paste parameter found okay so if it is found then you're coming in getting the tracking number tracking number equal to use a validate function to validate the tracking number so Dr SEC track okay so now guys you need to check if this is not empty if double equal to null then you can show this again same message no tracking number F okay or you can tell like please provide tracking number done guys so this was about the validation and now here your main query starts dollar order query equal to where you can tell select orders do star comma customer. star from orders table o and customers table C where customer. ID equal to customer undor ID so from where it is it is coming from orders table so just mention order. customer ID okay so your customer table ID which is equal to your order customer ID get only those records let me break it down use and TR c k i tracking number equal to insert single quotes add a limit that only one record should come so what is the tracking number here we got it so if the data is there then it's going to get the data and now guys let's run this query order query result equal to with the mysqliquery function first connection and then your order query and now guys let check it is true or false if it's not true you can just show that message like something went wrong or you can print this itself no worries let's echo in a H5 tag and tell something went wrong just return return false if it is correct then you're going to check that it is having some data or not so what we'll do let's copy this let's use masculine number of row function to check the data is there at least more than one else you can tell no record available so let me copy this condition and paste here and no data found and now guys if the data is found get row data okay so let's tell order data row equal to where myli fetch associate data and your order result so your executed value you have to take and paste Here and Now guys let us just divide the PHP here open and close PHP and here your table structure starts so we have already done the table designing in order summary. PHP let me just copy from there okay so this is my table view guys let me copy this completely and paste here so let me align it and guys I'll just show you the first TD with some random data okay then second TD where your customer details comes and then the third DD is about the invoice data okay so now we'll be getting all that details order data row let's copy that variable and use in each of the detail so here customer name order data of name okay so guys let me just print and show you this what you are getting here Echo and just get back and you need to comment this guys let me comment this table so it will not give an error let's refresh okay array to string conversion let's use printor R function refresh so here you see we have all the details okay let me comment comment that print and uncomment this table body and now guys you need to paste here so order data row of phone and Order data of email we get all these details and here is the invoice number invoice number is nothing but the tracking number guys okay so order data of TRS c k _ n no number and this will be the today date and now we can get back refresh perfect so here we have got the details guys and now let us uh execute the items of it so let's get back so let's get back on the order summary and move below here is our order table guys okay let me just copy this so this is my complete div you can copy it get back paste it after this if condition you have to start the code so basically I'll just show you this is my tracking if first condition and inside this if condition I'm still there so inside that you can just start directly dollar your order item query equal to okay so now guys let's type the query here select and you need to get three tables data that is your orders table order items and then your product table datas okay orders table dot all details comma then order item dot all detail comma and product table dot all details that is Star from orders table we'll understand as O then order _ items table understand as oi and products table understand as P okay and then use a we condition let me break so it will be more clear and yep where order item from the order item table get order _ ID column which will be equal to order table do ID primary key ID okay use and operator product table do ID ID equal to order item table of product _ ID okay and then again use and from order table TR r c k iing tracking undor number equal to your tracking number here okay so we have already got at the top let me fold this so here is our tracking number let's copy this and just call that perfect so we have got all the details and now guys we'll be modifying few things in this query again so let's execute the above query order item query result equal to Mysore query function where get the connection and then your order item query so we got it and now guys you need to check whether this is true or false so if it's true then you come in else you can mention like something went wrong so let's copy and paste mention here something went wrong and then if it is true you're going to get all the data else you tell no data found user myi number of row to check the data is there or not so what is the result here let's copy this you need to check whether it is greater than zero then come in and here you need to paste your HTML table so what we have copied from here let me show you from the beginning so this is my file here Order summary. PHP so here is order summary if you have not watched please watch this video I have given the link in description okay so this is my card body and this is the first if condition which we don't require in the second if condition product items we have a table design structure okay so we are going to copy this let me copy this completely and we need to modify few things here let's paste yep so let me show you this complete table row ID product name then price quantity and total price now let's move Below on this table body and you don't need the total amount just remove that and you do not require this total amount also just use for each Loop and you have to get the data so what is that data guys we are taking this result right executed query let's copy that and paste here order item query result as dollar row you're taking it and looping all this data so once your looping is started here and here the loop ends for each Loop so guys first incrementing the 1 2 3 4 okay and then the product name and now guys you need to get the price so price is nothing but your order item price not your product table price so let's tell order item price so let's copy this and you need to add it so let's modify our query here order item price so from where is this order item order item. price as order item price okay so we are telling that just understand your order item price column as order item price now you can utilize here okay as simple same way guys you need to get this quantity also let me paste here order item quantity copy and just modify the query again give comma let me copy this and paste here as your order item quantity column as order item quantity and now guys the total price here let's copy this your price and then your order item quantity done so it gives the calculation and gives you the output and now guys at this table row you have to get the total amount so total amount we have already stored in our orders table dollar row of total underscore amount column name that's it and the payment mode Let's copy this dollar row of your payment mode okay so let me just show you in that database in the orders table let's move so here we have tracking number total amount and the payment underscore mode perfect guys so now guys let us see the output get back refresh perfect so let's go back now guys let print with third Al okay so guys this video is already extended so here we have shown how to make the printing bable format and let's continue next video guys about how to add the print button and print the download PDF button for printing this bill okay so guys in this video that's it thank you for watching this video please subscribe like and share