Earthshaker/manager-invoice-2.php at master · munsu/Earthshaker · GitHub

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
<html>
	<body>

		<?php
		$con = mysql_connect("localhost", "root", "root") or die('Could not connect: ' . mysql_error());
		mysql_select_db("distribution", $con);
		$result = mysql_query("SELECT i.invoiceno as 'invoiceno',i.invoicedate as 'invoicedate', concat(s.agentlastname,', ',s.agentfirstname) as 'agentname', c.clientname as 'clientname' FROM invoice i, salesagent s, client c WHERE invoice.invoiceno=$_POST['input1'] AND invoice.agentid=salesagent.agentid AND salesagent.clientid=client.clientid LIMIT 1");

		echo "<table border='1'>
		<tr>
		<th>Invoice No.</th>
		<th>Date</th>
		<th>Agent</th>
		<th>Client</th>
		</tr>";

		while($row = mysql_fetch_array($result))
		  {
		  echo "<tr>";
		  echo "<td>" . $row['invoiceno'] . "</td>";
		  echo "<td>" . $row['invoicedate'] . "</td>";
		  echo "<td>" . $row['agentname'] . "</td>";
		  echo "<td>" . $row['clientname'] . "</td>";
		  echo "</tr>";
		  }
		echo "</table>";

		echo "<br>";

		$result2 = mysql_query("SELECT i.itemcode as 'itemcode', i.description as 'desc', ii.quantity as 'quant', i.srp as 'srp', d.amount as 'discount', (ii.quantity*i.srp*(100-d.amount)/100) as 'saleprice' FROM item i, discount d, itemxinvoice ii, salesagent sa, invoice iv WHERE itemxinvoice.invoiceno=$_POST["input1"] AND salesagent.clientid=discount.clientid AND salesagent.agentid=invoice.agentid AND invoice.invoiceno=itemxinvoice.invoiceno AND itemxinvoice.itemcode=item.itemcode");

		echo "<table border='1'>
		<tr>
		<th>Item</th>
		<th>Description</th>
		<th>Qty</th>
		<th>SRP</th>
		<th>Discount</th>
		<th>Sale Price</th>
		</tr>";

		while($row = mysql_fetch_array($result2))
		  {
		  echo "<tr>";
		  echo "<td>" . $row['itemcode'] . "</td>";
		  echo "<td>" . $row['desc'] . "</td>";
		  echo "<td>" . $row['quant'] . "</td>";
		  echo "<td>" . $row['srp'] . "</td>";
		  echo "<td>" . $row['discount'] . "</td>";
		  echo "<td>" . $row['saleprice'] . "</td>";
		  echo "</tr>";
		  }
		echo "</table>";


		mysql_close($con);
		?>

	</body>
</html>