-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmonthly.php
83 lines (82 loc) · 9.97 KB
/
monthly.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
<?php
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
require 'config.php';
$sql = "SELECT `empid`,`empname`,`designation`,`office` from `employeedetails` where uid=\"".$_POST['uid']."\"";
$sql2 = "SELECT *,monthname(paydate),year(paydate) from `salarydetails` where uid=\"".$_POST['uid']."\" and month(paydate)=".(int)$_POST['date']." order by paydate";
$result1=mysqli_query($conn,$sql);
$row1=mysqli_fetch_array($result1);
$result=mysqli_query($conn,$sql2);
if ($row=mysqli_fetch_array($result))
{
do{
$string = "
<div class=\"row\"><div class=\"col-1\"></div><div class=\"col-2\"></div><div class=\"col-6 i\"><h2><strong>Details for the month ".$row[11]." ".$row[12]."</strong></h2></div><div class=\"col-3\"></div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">Employee ID </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">".$row1[0]."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">Employee Name </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">".$row1[1]."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">Designation </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">".$row1[2]."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">Office </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">".$row1[3]."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\"></div><div class=\"col-2 i\"><h3><strong>Earnings</strong></h3></div><div class=\"col-4\"></div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">Basic Pay </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">₹ ".$row[4]."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">Dearness Allowance </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">₹ ".(float)$row[5]*(float)$row[4]*0.01."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">House Rent Allowance </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">₹ ".(float)$row[6]*(float)$row[4]*0.01."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">CCA </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">₹ ".(float)$row[7]*(float)$row[4]*0.01."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\"></div><div class=\"col-2 i\"><h3><strong>Deductions</strong></h3></div><div class=\"col-4\"></div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">LIC </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">₹ ".(float)$row[8]*(float)$row[4]*0.01."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">SLI </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">₹ ".(float)$row[9]*(float)$row[4]*0.01."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">GPF </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">₹ ".(float)$row[10]*(float)$row[4]*0.01."</div></div>";
// $string = "
// <span style=\"font-weight: 700;\">Salary Details for the month ".$row[11]." ".$row[12]."</span>
// <br>
// Employee ID : ".$row1[0]."</span><br>
// Employee Name : ".$row1[1]."<br>
// Designation : ".$row1[2]."<br>
// Office : ".$row1[3]."<br>
// <strong>Earnings</strong><br>
// Basic Pay : ₹ ".$row[4]."<br>
// DA : ₹ ".(float)$row[5]*(float)$row[4]*0.01."<br>
// HRA : ₹ ".(float)$row[6]*(float)$row[4]*0.01."<br>
// CCA : ₹ ".(float)$row[7]*(float)$row[4]*0.01."<br>
// <strong>Deductions</strong><br>
// LIC : ₹ ".(float)$row[8]*(float)$row[4]*0.01."<br>
// SLI : ₹ ".(float)$row[9]*(float)$row[4]*0.01."<br>
// GPF : ₹ ".(float)$row[10]*(float)$row[4]*0.01."<br>";
echo $string;
}while($row=mysqli_fetch_array($result));
}else{
// $string = "
// <span style=\"font-weight: 700;\">Salary Details</span>
// <br>
// Employee ID : ".$row1[0]."<br>
// Employee Name : ".$row1[1]."<br>
// Designation : ".$row1[2]."<br>
// Office : ".$row1[3]."<br>
// <strong>Earnings</strong><br>
// Basic Pay : not paid<br>
// DA : not paid<br>
// HRA : not paid<br>
// CCA : not paid<br>
// <strong>Deductions</strong><br>
// LIC : not paid<br>
// SLI : not paid<br>
// GPF : not paid<br>";
$string = "
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\"></div><div class=\"col-3\"><h2><strong>Salary Details</strong></h2></div><div class=\"col-4\"></div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">Employee ID </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">".$row1[0]."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">Employee Name </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">".$row1[1]."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">Designation </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">".$row1[2]."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">Office </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">".$row1[3]."</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\"></div><div class=\"col-2 i\"><h3><strong>Earnings</strong></h3></div><div class=\"col-4\"></div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">Basic Pay </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">Not Paid</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">Dearness Allowance </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">Not Paid</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">House Rent Allowance </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">Not Paid</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">CCA </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">Not Paid</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\"></div><div class=\"col-2 i\"><h3><strong>Deductions</strong></h3></div><div class=\"col-4\"></div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">LIC </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">Not Paid</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">SLI </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">Not Paid</div></div>
<div class=\"row\"><div class=\"col-2\"></div><div class=\"col-3\">GPF </div><div class=\"col-2 i\"> : </div><div class=\"col-1\"></div><div class=\"col-4\">Not Paid</div></div>";
echo $string;
}
}else{
echo "<h1>entha mone hacking aano<h1><br><img src=\"./images/shammi.jpg\" alt=\"parayenne\">";
}
?>