";
var_dump($_POST);
echo "
";
// echo "
stock_no: $stock_no";
// echo "
stock_type: {$_POST['stock_type']}";
// echo "
status: {$_POST['status']}";
$supplier_id = $_POST['supplier_id'];
// echo "
supplier_id: {$_POST['supplier_id']}";
// echo "
";
// echo "INSERT INTO `stock_control`(`stock_no`, `stock_type`, `supplier_id`, `status`) VALUES ('$stock_no','{$_POST['stock_type']}','{$supplier_id}','{$_POST['status']}')";
$stock_res = $db->query("stock", "SELECT * FROM stock ORDER BY stock_no DESC LIMIT 1");
if ($stock = $stock_res->fetch_assoc()) {
//get the last 3 digits in the stock_id
$last_three_digits = substr($stock["stock_no"], -3);
$next_three_digits = $last_three_digits + 1;
$stock_no = "ST" . str_pad($next_three_digits, 3, "0", STR_PAD_LEFT);
} else {
$stock_no = "ST001";
}
// $stock_record_id = $db->query("stock_control", "INSERT INTO `stock_control`(`stock_no`, `stock_type`, `supplier_id`, `status`) VALUES ('$stock_no','{$_POST['stock_type']}','{$supplier_id}','{$_POST['status']}')");
if ($_POST['stock_type'] == "1") {
// echo "
";
// echo "
stock_record_id: {$stock_record_id}";
// echo "
item_name: {$_POST['item_name']}";
// echo "
stock_type: {$_POST['stock_type']}";
// echo "
supplier_id: {$supplier_id}";
// echo "
item_price: {$_POST['item_price']}";
// echo "
unit_of_measure: {$_POST['unit_of_measure']}";
// echo "
status: {$_POST['status']}";
// echo "
quantity: {$_POST['quantity']}";
// echo "
vehicle_type: {$_POST['vehicle_type']}";
// echo "
";
// echo "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`,`vehicle_type`, `status`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['vehicle_type']}','{$_POST['status']}')";
$stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`,`vehicle_type`, `status`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['vehicle_type']}','{$_POST['status']}')");
// echo "
";
// echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['quantity']}')";
$stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['quantity']}')");
// echo "
";
} else if ($_POST['stock_type'] == "2") {
// echo "
";
// echo "
stock_record_id: {$stock_record_id}";
// echo "
item_name: {$_POST['item_name']}";
// echo "
stock_type: {$_POST['stock_type']}";
// echo "
supplier_id: {$supplier_id}";
// echo "
item_price: {$_POST['item_price']}";
// echo "
unit_of_measure: {$_POST['unit_of_measure']}";
// echo "
status: {$_POST['status']}";
// echo "
quantity: {$_POST['quantity']}";
// echo "
pipe_size: {$_POST['pipe_size']}";
// echo "
collar_size: {$_POST['collar_size']}";
// echo "
type_size: {$_POST['type_size']}";
// echo "
";
if ($_POST['type'] == "Pipe") {
// echo "
pipe_size: {$_POST['pipe_size']}";
$item_name = $_POST['pipe_size'] . " " . $_POST['type'];
// echo "
";
// echo "INSERT INTO `stock`(`stock_no`, `stock_type_id`, `item_name`, `type`, `size`,`supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('$stock_no','{$_POST['stock_type']}','{$item_name}','{$_POST['type']}','{$_POST['pipe_size']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')";
$stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `stock_type_id`, `item_name`, `type`, `size`,`supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('$stock_no','{$_POST['stock_type']}','{$item_name}','{$_POST['type']}','{$_POST['pipe_size']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')");
// echo "
";
// echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','{$item_name}','{$_POST['quantity']}')";
$stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','{$item_name}','{$_POST['quantity']}')");
} else {
// echo "
collar_size: {$_POST['collar_size']}";
// echo "
type_size: {$_POST['type_size']}";
$item_name = $_POST['collar_size'] . " " . $_POST['type_size'];
// echo "
";
// echo "INSERT INTO `stock`(`stock_no`, `stock_type_id`,`item_name`, `type`, `size`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('$stock_no','{$_POST['stock_type']}', '$item_name', '{$_POST['type_size']}', '{$_POST['collar_size']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')";
$stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `stock_type_id`,`item_name`, `type`, `size`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('$stock_no','{$_POST['stock_type']}', '$item_name', '{$_POST['type_size']}', '{$_POST['collar_size']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')");
// echo "
";
// echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','$item_name','{$_POST['quantity']}')";
$stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','$item_name','{$_POST['quantity']}')");
}
} else if ($_POST['stock_type'] == "3") {
// echo "
stock_record_id: {$stock_record_id}";
// echo "
item_name: {$_POST['item_name']}";
// echo "
stock_type: {$_POST['stock_type']}";
// echo "
supplier_id: {$supplier_id}";
// echo "
status: {$_POST['status']}";
$quantity = 1;
// echo "
";
// echo "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `status`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['status']}')";
$stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `pump_code`, `status`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['pump_code']}','{$_POST['status']}')");
// echo "
";
// echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','{$_POST['item_name']}','{$quantity}')";
$stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','{$_POST['item_name']}','{$quantity}')");
} else if ($_POST['stock_type'] == "4") {
// echo "
";
// echo "
stock_record_id: {$stock_record_id}";
// echo "
item_name: {$_POST['item_name']}";
// echo "
stock_type: {$_POST['stock_type']}";
// echo "
supplier_id: {$supplier_id}";
// echo "
item_price: {$_POST['item_price']}";
// echo "
unit_of_measure: {$_POST['unit_of_measure']}";
// echo "
status: {$_POST['status']}";
// echo "
quantity: {$_POST['quantity']}";
// echo "
serial_number: {$_POST['serial_number']}";
// echo "
";
// echo "INSERT INTO `stock`(`stock_no`, `item_name`, `serial_number`,`stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['serial_number']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')";
$stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `item_name`, `serial_number`,`stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['serial_number']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')");
// echo "
";
// echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['quantity']}')";
$stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['quantity']}')");
} else if ($_POST['stock_type'] == "5") {
// echo "
";
// echo "
stock_record_id: {$stock_record_id}";
// echo "
item_name: {$_POST['item_name']}";
// echo "
stock_type: {$_POST['stock_type']}";
// echo "
supplier_id: {$supplier_id}";
// echo "
item_price: {$_POST['item_price']}";
// echo "
unit_of_measure: {$_POST['unit_of_measure']}";
// echo "
status: {$_POST['status']}";
// echo "
quantity: {$_POST['quantity']}";
// echo "
";
// echo "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')";
$item_name = $_POST['bn_type'] . " X " . $_POST['bn_size'];
$stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `item_name`, `type`, `size`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('$stock_no','{$item_name}','{$_POST['bn_type']}','{$_POST['bn_size']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')");
// echo "
";
// echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['quantity']}')";
$stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['quantity']}')");
} else if ($_POST['stock_type'] == "6") {
// echo "
";
// echo "
stock_record_id: {$stock_record_id}";
// echo "
item_name: {$_POST['item_name']}";
// echo "
stock_type: {$_POST['stock_type']}";
// echo "
supplier_id: {$supplier_id}";
// echo "
item_price: {$_POST['item_price']}";
// echo "
unit_of_measure: {$_POST['unit_of_measure']}";
// echo "
status: {$_POST['status']}";
// echo "
quantity: {$_POST['quantity']}";
// echo "
";
// echo "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')";
$stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')");
// echo "
";
// echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['quantity']}')";
$stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('$stock_no','{$_POST['item_name']}','{$_POST['quantity']}')");
}
?>
";
echo "";
public function __construct($host = "ewg.dedicated.co.za", $user = 'elegaysv_Code2', $password = 'EWG2Cod!@#', $dbname = 'elegaysv_savuki')
{
$this->connection = mysqli_connect($host, $user, $password, $dbname);
if (!$this->check_table_exists('logs')) {
$sql = "CREATE TABLE IF NOT EXISTS logs (
record_id INT AUTO_INCREMENT PRIMARY KEY,
table_name TEXT,
user_id INT(255),
query TEXT,
date_time VARCHAR(50)
)";
if (!mysqli_query($this->connection, $sql)) {
return "Error creating table: " . mysqli_error($this->connection);
exit();
}
}
if (!$this->check_table_exists('users')) {
$sql = "CREATE TABLE IF NOT EXISTS users (
record_id INT AUTO_INCREMENT PRIMARY KEY,
username TEXT,
user_password TEXT
)";
if (!mysqli_query($this->connection, $sql)) {
return "Error creating table: " . mysqli_error($this->connection);
exit();
}
$sql = "INSERT INTO users (username, user_password) VALUES ('DEV', '4030fe15babb7045f9036c2316babda746af34b61e623354c61828526c4e2ad5')";
if (!mysqli_query($this->connection, $sql)) {
return "Error inserting first user: " . mysqli_error($this->connection);
exit();
}
}
if (mysqli_connect_errno()) {
return "Failed to connect to MySQL: " . mysqli_connect_error();
exit();
}
}
function check_table_exists($table)
{
$this->table_name = $table;
$sql = "SHOW TABLES LIKE '$table' ";
$result = mysqli_query($this->connection, $sql);
if (mysqli_num_rows($result) > 0) {
return true;
} else {
return false;
}
}