-
Notifications
You must be signed in to change notification settings - Fork 2
/
vendors1.php
77 lines (75 loc) · 3.53 KB
/
vendors1.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
<?php
/*****************************************************************
* DO NOT REMOVE *
* ============= *
*PetClinic Management Software *
*Copyrighted 2015-2016 by Michael Avila *
*Distributed under the terms of the GNU General Public License *
*This program is distributed in the hope that it will be useful, *
* but WITHOUT ANY WARRANTY; without even the implied warranty of *
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. *
*****************************************************************/
session_start();
$logFileName = "user";
$headerTitle="USER LOG";
require_once "includes/common.inc";
if(isset($_POST["editvendornum"])) {
$editvendornum = $_SESSION["editvendornum"];
} else {
put_errormsg("SESSION editvendornum not set");
redirect("vendors.php");
exit(1);
}
if(isset($_POST["emplnumber"])) {
$emplnumber=$_POST["emplnumber"];
} else {
put_errormsg("POST emplnum not set");
redirect("vendors.php");
exit(1);
}
$vendorid=$_POST["vendorid"];
$vendorname=$_POST["vendorname"];
$vendorshortname=$_POST["vendorshortname"];
$vendorcontact=$_POST["vendorcontact"];
$vendoraddress1=$_POST["vendoraddress1"];
$vendoraddress1 = mc_encrypt($vendoraddress1, ENCRYPTION_KEY);
$vendoraddress2=$_POST["vendoraddress2"];
if ($vendoraddress2 <> "")
$vendoraddress2 = mc_encrypt($vendoraddress2, ENCRYPTION_KEY);
$vendorcity=$_POST["vendorcity"];
$vendorcity = mc_encrypt($vendorcity, ENCRYPTION_KEY);
$vendorstate=$_POST["vendorstate"];
$vendorzipcode=$_POST["vendorzipcode"];
$vendortele=$_POST["vendortele"];
$vendorfax=$_POST["vendorfax"];
$vendoremail=$_POST["vendoremail"];
$vendoremail = mc_encrypt($vendoremail, ENCRYPTION_KEY);
$vendorstatus=$_POST["vendorstatus"];
$emplnumber = $_SESSION['employeenumber'];
$mysqli = new mysqli('localhost', $_SESSION["user"], mc_decrypt($_SESSION["up"], ps_key), '');
if ($editvendornum <> "new")
{
$sql = "UPDATE `petclinicinv`.`vendor` SET `vendorname` = \"".$vendorname."\", `vendorshortname` = \"".$vendorshortname."\", `vendorcontact` = \"".$vendorcontact."\", ";
$sql = $sql."`vendoraddress1` = \"".$vendoraddress1."\", `vendoraddress2` = \"".$vendoraddress2."\", `vendorcity` = \"".$vendorcity."\", `vendorstate` = \"".$vendorstate."\", `vendorzipcode` = \"".$vendorzipcode."\", ";
$sql = $sql."`vendortele` = \"".$vendortele."\", `vendorfax` = \"".$vendorfax."\", `vendoremail` = \"".$vendoremail."\", `vendorstatus` = \"".$vendorstatus."\" WHERE vendorid = \"".$editvendornum."\";";
if ($mysqli->query($sql) === TRUE) {
} else {
put_errormsg("Table vendor data update failed" . $mysqli->error);
redirect("vendors.php");
exit(1);
}
} else{
$sql = "INSERT INTO `petclinicinv`.`vendor` (`vendorname`, `vendorshortname`, `vendorcontact`, `vendoraddress1`, `vendoraddress2`, `vendorcity`, `vendorstate`, `vendorzipcode`, `vendortele`, `vendorfax`, `vendoremail`, `vendorstatus`)
VALUES (\"$vendorname\", \"$vendorshortname\", \"$vendorcontact\", \"$vendoraddress1\", \"$vendoraddress2\", \"$vendorcity\", \"$vendorstate\", \"$vendorzipcode\", \"$vendortele\", \"$vendorfax\", \"$vendoremail\", \"$vendorstatus\");";
if ($mysqli->query($sql) === TRUE) {
} else {
put_errormsg("Table vendor data insertion failed" . $mysqli->error);
redirect("vendors.php");
exit(1);
}
}
$mysqli->close();
put_errormsg("Vendor Added/Modified");
unset ($_SESSION["editvendornum"]);
redirect("vendors.php");
?>