0:01
Hi friends, welcome to Pluto channel. Uh
0:04
in this uh last tutorial we'll discuss
0:08
about up to the product section. Let's
0:11
continue the renaming uh remaining parts
0:14
of the videos. So here another table you
0:17
have to create the sales table. Okay. So
0:19
this is the sales table. So we are go to
0:21
here this a database. So sales table we
0:25
have consist of the sales id invoice
0:28
number is must after that total amount
0:34
and grand total and paid and balance.
0:38
Okay. So the sales table sales item
0:40
table you have to consist of the
0:43
uh here is the sales table ID which is
0:46
goes to that sales item table. sales ID
0:50
after that product ID quantity price
0:53
subtotal so you have to refer uh refer
0:56
as a sales ID which is a which is coming
0:59
from the sales table it is coming to the
1:01
sales item table it's called as a
1:03
foreign key another key which is a
1:05
product table there ID is ID
1:10
same ID available in the sales table
1:16
foreign key okay These are the two
1:20
Okay. These are the two tables we have
1:25
implemented. So the sales table and
1:27
sales item table. This is must. Okay.
1:30
This is the must. Okay. This is the
1:33
uh inventory management system very
1:36
crucial part. This is very important
1:37
part. Okay. This is we have any
1:39
implemented we have to focus on this.
1:42
Okay. So that ID this is a sales ID.
1:45
Invoice number. Each and every sale we
1:47
have to identify by this invoice number.
1:52
complete total. So discount amount if it
1:54
is if you are giving the discount grand
1:56
total. Okay. So final total is a paid
1:59
amount balance and credit date. Date
2:02
also important. Someone uh want to
2:05
change the item they bring their item to
2:07
your shop. So you can see identify the
2:09
date which date they bought and which
2:11
time they bought and everything you can
2:13
details. You will be able to find it
2:16
So here this one this auto ID is a sales
2:18
ID product ID is a sales ID the same
2:20
table the sales ID this sales ID is
2:25
coming to another table sales ID this ID
2:28
goes to another table sales side because
2:30
uh imagine this is this table show us
2:34
the complete entire total. So here this
2:38
this table show us the each and every
2:40
item if you if you bought the item toys
2:42
and shoes a pair of shoes and dresses
2:46
all the item one by one of this table.
2:49
Okay all the amount what is the toy
2:51
amount what is the doll amount what is
2:53
the uh dress amount and amount has been
2:58
calculated and put into this total
3:01
amount column. Okay, that's the
3:03
difference. So, let's copy this
3:17
Sal table has been created successfully.
3:31
sales sales site both table has been
3:33
created. Okay. So it's very
3:36
successfully. So we'll be able to do the
3:40
things. Okay. So here after you add the
3:44
update the product quantity you have to
3:47
uh we have to update the product
3:49
quantity and everything you can check by
3:51
here. When the sales is completed mean
3:53
quantity is reduced. Okay. So these are
3:56
the things you can check on it. This one
3:59
you can check by uh here
4:03
here this query part you can go and put
4:05
it according to you can implement the
4:08
sales ID product ID based on the
4:12
product. So this a quantity of that
4:15
product and you will be able to
4:18
reduce the quantity once a purchase is
4:20
done sorry once the sales is done
4:23
quantity should be reduced. Okay, this
4:26
is the process completed by this query.
4:29
So this all the process are done by the
4:31
query. Okay, the query is very important
4:33
part while you doing any software
4:35
project. After that when you make the
4:38
system you have to follow this
4:40
implementation process. This is very
4:42
must how the implementation process you
4:45
can must follow this. Okay. So
4:48
everything are indeed. Okay. So what you
4:51
going to do is first I'm going to go to
4:56
I'm going to go to go to my type
5:02
make the folder here. I'm going to make
5:05
the folder is inventory system. So it's
5:09
not here. I'm going to go to the C drive
5:37
here. This is my product name.
5:44
Here I have to make this these are the
5:46
folder structures. Okay. So you have to
5:48
make a folders like this way.
5:55
I'm going to make the folder config.
6:01
That's what I'm going to make
6:43
That's it. These are the folder you have
6:44
to make. You have to go to the address
6:47
bar and type cmd and open it on the
7:06
It successfully open on the VS code
7:11
You have to open up the VS code editor
7:25
Now what I'm going to do is this
7:28
successfully open on the editor here.
7:31
Inside here we have create this files.
7:34
Okay. So what are the files we have
7:41
get create get the files. So what are
7:43
the files we need to create?
7:47
Go to the doc. These are the files you
7:53
get simply one by one
8:06
Select this one. Click on this file. New
8:16
Go to the category section.
8:30
Click on it. The file
8:50
Okay, the same thing you have to create
8:52
this files for uh brand as well. You can
8:55
implement the brand as well. The same
8:58
files you have to the files
9:11
brand also the same process are there.
9:15
Now after that what I'm going to do is
9:17
I'm going to go to the product table
9:20
also the same thing you have to paste
9:21
also another one product also we have to
9:24
paste the same thing edit and uh
9:30
index page everything is product page
9:31
also needed so product is there so after
9:38
sales you have to say what are the files
9:40
you have included postphp Click.
10:01
report receipt. This a receipt sheet.
10:07
These are the parts. Okay. Okay. These
10:10
are the implementation process under
10:12
report section. You have to go to the
10:14
report section. You have to select this
10:16
report. Select the report and click on
10:47
These are the files.
10:53
another column assets. assets also we
10:56
have write that uh we can write this uh
11:00
the folder here you can include the CSS
11:03
and CSS everything uh so here
11:07
at the outside you have to create the
11:09
main page which is a index ph
11:15
okay these are the files you have to
11:17
create thank you for watching I'll be
11:20
catching my next video tutorial
