-
Notifications
You must be signed in to change notification settings - Fork 9
/
pro_add.php
85 lines (79 loc) · 3.18 KB
/
pro_add.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<?php
require 'config.php';
// $name = $_POST['name'];
// $des = $_POST['des'];
$firm_id = $_POST['firm_id'];
$grp = $_POST['grp'];
$ty = $_POST['ty'];
$price = $_POST['price'];
$cgst = $_POST['cgst'];
$igst = $_POST['igst'];
$sgst = $_POST['sgst'];
$qty = $_POST['qty'];
$conn = connection();
$check = "SELECT * FROM `product` WHERE `pro_firmid` = $firm_id AND `pro_grpid` = $grp AND `pro_typeid` = $ty" ;
$check = $conn->query($check);
// echo $check->rowCount();
if ($check->rowCount() > 0) {
echo "<span style='font-size:20px;color:red;' class=\"splash-description\">Product already exist.</span></br>";
// $conn=null;
}else{
$sql = "INSERT INTO `product` (`pro_typeid`, `pro_grpid`, `pro_firmid`, `pro_price`, `cgst`, `igst`, `sgst`, `pro_qty`) VALUES ('$ty', '$grp', '$firm_id', '$price', '$cgst', '$igst', '$sgst', '$qty');";
$conn = connection();
$conn->query($sql);
// $conn=null;
echo "<span style='font-size:20px;color:green;' class=\"splash-description\">Product added.</span></br>";
}
$sql = "SELECT * FROM product p inner join category c on c.cat_id=p.pro_grpid inner join type t on t.ty_id=p.pro_typeid inner join firm f on f.firm_id=p.pro_firmid
ORDER BY cat_name ASC";
$data = $conn->query($sql);
$conn=null;
?>
<table class="table table-condensed table-hover table-bordered table-striped">
<thead>
<tr>
<th><center>S. no.</center></th>
<!-- <th><center>Name</center></th> -->
<th><center>Firm</center></th>
<!-- <th><center>Description</center></th> -->
<th><center>Category</center></th>
<th><center>Type</center></th>
<th><center>Stock Price</center></th>
<th><center>Seller Price</center></th>
<th><center>CGST</center></th>
<th><center>IGST</center></th>
<th><center>SGST</center></th>
<th><center>Quantity</center></th>
<th><center>Status</center></th>
<th><center>Edit</center></th>
</tr>
</thead>
<tbody style="color:black;">
<?php $s=0;
foreach ($data as $row){ $s++; ?>
<tr>
<td><center><?php echo $s; ?></center></td>
<!-- <td><?php echo ucwords($row['pro_name']); ?></td> -->
<td><?php echo ucwords($row['firm_name']); ?></td>
<!-- <td><?php echo ucwords($row['pro_des']); ?></td> -->
<td><?php echo ucwords($row['cat_name']); ?></td>
<td><?php echo ucwords($row['ty_name']); ?></td>
<td><?php echo ucwords($row['pro_price']); ?></td>
<td><input type="text" id="sell_price" value="<?php echo $row['pro_sell_price']; ?>" style="width: 80px; padding: 3px;" onkeyup="add_sell_price(this.value, this.id);">
</td>
<td><?php echo ucwords($row['cgst'])."%"; ?></td>
<td><?php echo ucwords($row['igst'])."%"; ?></td>
<td><?php echo ucwords($row['sgst'])."%"; ?></td>
<td><?php echo ucwords($row['pro_qty']); ?></td>
<td><?php
if ($row['pro_qty'] > 0) {
echo "Available";
}else{
echo "<span style='color:red;'>Out of stock</span>";
}
?></td>
<td><center><button data-toggle="modal" data-target="#edit-product" class="btn btn-space md-trigger btn-danger" onclick="edit_pro(<?php echo $row['pro_id']; ?>);"><i class="icon icon-left mdi mdi-eyedropper"></i> EDIT</button></center></td>
</tr>
<?php } ?>
</tbody>
</table>