-
Notifications
You must be signed in to change notification settings - Fork 23
/
pl.php
105 lines (98 loc) · 3.18 KB
/
pl.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
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
<?php
session_start();
if(!isset($_SESSION['doctor']))
{
header("Location: index.html");
exit();
};
$d1 = $_POST['date1'];
$m1 = $_POST['month1'];
$y1 = $_POST['year1'];
$d2 = $_POST['date2'];
$m2 = $_POST['month2'];
$y2 = $_POST['year2'];
if(checkdate($m1,$d1,$y1) && checkdate($m2,$d2,$y2))
{
include 'config.php';
if(!($dbconn = @mysql_connect($dbhost, $dbuser, $dbpass))) exit('Error connecting to database.');
mysql_select_db($db);
$sqlq = "SELECT id,qty_buy_sell*sp AS SP FROM transaction AS a NATURAL JOIN txn_on NATURAL JOIN medicine WHERE txn_timestamp>='".$y1."-".sprintf("%02d",$m1)."-".sprintf("%02d",$d1)." 00:00:00' AND txn_timestamp<='".$y2."-".sprintf("%02d",$m2)."-".sprintf("%02d",$d2)." 23:59:59' AND buy_sell='S';";
$sqlq = mysql_query($sqlq);
if(!$sqlq)
{
echo "Query Failed.<br />";
exit;
}
$num_rows = mysql_num_rows($sqlq);
echo "<pre>Sale Transactions:<br /><br />";
echo "<table border=1><tr>";
for($i = 0; $i < mysql_num_fields($sqlq); $i++)
{
$field_info = mysql_fetch_field($sqlq, $i);
echo "<th>{$field_info->name}</th>";
}
echo "</tr>";
while($row = mysql_fetch_row($sqlq))
{
echo "<tr>";
foreach($row as $_column)
{
echo "<td>{$_column}</td>";
}
echo "</tr>";
}
echo "</table></pre>";
$sqlq = "SELECT id,qty_buy_sell*cp AS CP FROM transaction AS a NATURAL JOIN txn_on NATURAL JOIN medicine WHERE txn_timestamp>='".$y1."-".sprintf("%02d",$m1)."-".sprintf("%02d",$d1)." 00:00:00' AND txn_timestamp<='".$y2."-".sprintf("%02d",$m2)."-".sprintf("%02d",$d2)." 23:59:59' AND buy_sell='B';";
$sqlq = mysql_query($sqlq);
if(!$sqlq)
{
echo "Query Failed.<br />";
exit;
}
$num_rows = mysql_num_rows($sqlq);
echo "<pre>Purchase Transactions:<br /><br />";
echo "<table border=1><tr>";
for($i = 0; $i < mysql_num_fields($sqlq); $i++)
{
$field_info = mysql_fetch_field($sqlq, $i);
echo "<th>{$field_info->name}</th>";
}
echo "</tr>";
while($row = mysql_fetch_row($sqlq))
{
echo "<tr>";
foreach($row as $_column)
{
echo "<td>{$_column}</td>";
}
echo "</tr>";
}
echo "</table></pre>";
$sqlq = "SELECT SUM(qty_buy_sell*cp) AS CP FROM transaction AS a NATURAL JOIN txn_on NATURAL JOIN medicine WHERE txn_timestamp>='".$y1."-".sprintf("%02d",$m1)."-".sprintf("%02d",$d1)." 00:00:00' AND txn_timestamp<='".$y2."-".sprintf("%02d",$m2)."-".sprintf("%02d",$d2)." 23:59:59' AND buy_sell='B';";
$sqlq = mysql_query($sqlq);
if(!$sqlq)
{
echo "Query Failed.<br />";
exit;
}
echo "<pre>Total expenses: Rs. ";
$cp = mysql_fetch_array($sqlq);
echo $cp['CP'];
echo "<br />";
$sqlq = "SELECT SUM(qty_buy_sell*sp) AS SP FROM transaction AS a NATURAL JOIN txn_on NATURAL JOIN medicine WHERE txn_timestamp>='".$y1."-".sprintf("%02d",$m1)."-".sprintf("%02d",$d1)." 00:00:00' AND txn_timestamp<='".$y2."-".sprintf("%02d",$m2)."-".sprintf("%02d",$d2)." 23:59:59' AND buy_sell='S';";
$sqlq = mysql_query($sqlq);
if(!$sqlq)
{
echo "Query Failed.<br />";
exit;
}
echo "Total income: Rs. ";
$sp = mysql_fetch_array($sqlq);
echo $sp['SP'];
echo "<br />";
echo "Total profits: Rs. ";
echo $sp['SP']-$cp['CP'];
echo "</pre>";
}
else echo "Dates are Invalid";
?>