/
savequoteitem.php
66 lines (56 loc) · 2.11 KB
/
savequoteitem.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
<?php
//Include database connection details
require_once('system-db.php');
require_once("sqlprocesstoarray.php");
start_db();
$quoteid = $_POST['quoteid'];
$id = $_POST['id'];
$qty = ($_POST['qty']);
$unitprice = ($_POST['unitprice']);
$vatrate = $_POST['vatrate'];
$vat = $_POST['vat'];
$total = $_POST['total'];
$productid = ($_POST['productid']);
if ($id == "") {
$qry = "INSERT INTO {$_SESSION['DB_PREFIX']}quoteitem " .
"(quoteid, quantity, priceeach, vatrate, vat, linetotal, " .
"productid, metacreateddate, metacreateduserid, metamodifieddate, metamodifieduserid) " .
"VALUES " .
"($quoteid, '$qty', '$unitprice', $vatrate, '$vat', $total, " .
"'$productid', NOW(), " . getLoggedOnMemberID() . ", NOW(), " . getLoggedOnMemberID() . ")";
$result = mysql_query($qry);
if (! $result) {
logError($qry . " - " . mysql_error());
}
} else {
$qry = "UPDATE {$_SESSION['DB_PREFIX']}quoteitems SET " .
"quantity = '$qty', " .
"priceeach = '$unitprice', " .
"vatrate = '$vatrate', " .
"vat = '$vat', " .
"linetotal = $total, " .
"productid = '$productid', metamodifieddate = NOW(), metamodifieduserid = " . getLoggedOnMemberID() . " " .
"WHERE id = $id";
$result = mysql_query($qry);
if (! $result) {
logError($qry . " - " . mysql_error());
}
}
// $qry = "UPDATE {$_SESSION['DB_PREFIX']}quotes SET " .
// "total = (SELECT SUM(B.total) FROM {$_SESSION['DB_PREFIX']}quoteitems B WHERE B.quoteid = $quoteid), " .
// "depositrequired = ((SELECT SUM(B.total) FROM {$_SESSION['DB_PREFIX']}quoteitems B WHERE B.quoteid = $quoteid)), metamodifieddate = NOW(), metamodifieduserid = " . getLoggedOnMemberID() . " " .
// "WHERE id = $quoteid";
// $result = mysql_query($qry);
//
// if (! $result) {
// logError($qry . " - " . mysql_error());
// }
$qry = "SELECT A.*, B.description " .
"FROM {$_SESSION['DB_PREFIX']}quoteitems A " .
"LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}product B " .
"ON B.id = A.productid " .
"WHERE A.quoteid = $quoteid " .
"ORDER BY A.id";
$json = new SQLProcessToArray();
echo json_encode($json->fetch($qry));
?>