<?php require './roots.php'; require $root_path . 'include/care_api_classes/supplier_database_class.php'; global $mode, $supplier_id, $result, $show_result, $results; $mode = $_REQUEST['mode']; $supplier_id = $_REQUEST['supplier_id']; if (!$mode || !$supplier_id) { header('Location:supplier_serach.php'); exit; } $supplier_obj = new supplier(); $supplier_obj->dbconnect(); $supplier_obj->dbselect(); switch ($mode) { case 'show': $result = $supplier_obj->show_supplier_details($supplier_id); $results = 'gui/gui_show_supplier.php'; break; case 'edit': $result = $supplier_obj->show_supplier_details($supplier_id); $results = 'gui/gui_edit_supplier.php'; break; case 'erase': $result = $supplier_obj->show_supplier_details($supplier_id); $results = 'gui/gui_delete_supplier.php'; } while ($show_result = $supplier_obj->fetch_object($result)) { $id = $show_result->Suplier_id; $company = $show_result->Company_Name; $person = $show_result->Contact_Person;
$email = $supplier->getemail(); $supplier->setfax($_POST['fax']); $fax = $supplier->getfax(); $supplier->setbanker($_POST['banker']); $banker = $supplier->getbanker(); $supplier->setbankdetail($_POST['bankDetail']); $bankdetail = $supplier->getbankdetail(); $supplier->setaccountno($_POST['accountNumber']); $accountno = $supplier->getaccountno(); $supplier->setcreditlimit($_POST['creditLimit']); $creditlimit = $supplier->getcreditlimit(); $supplier->setcreditperiod($_POST['creditPeriod']); $creditperiod = $supplier->getcreditperiod(); $supplier_id = $_POST['id']; //make a connection to the database server $connection = $supplier->dbconnect(); $supplier->dbselect(); if (isset($_POST['addsupplier']) && !$_POST['id'] && !$_POST['mode']) { //add supplier information to the database $add = $supplier->addSupplier($companyname, $contactperson, $address1, $address2, $phone1, $phone2, $cell1, $cell2, $email, $fax, $banker, $bankdetail, $accountno, $creditlimit, $creditperiod); if ($add == true) { $message = "Supplier {$companyname} is Saved in the Database!"; } else { echo 'check your query'; } } else { if (isset($_POST['addsupplier']) && $supplier_id && !$_POST['mode']) { //here is where updation goes $edit = $supplier->update_supplier($supplier_id, $companyname, $contactperson, $address1, $address2, $phone1, $phone2, $cell1, $cell2, $email, $fax, $banker, $bankdetail, $accountno, $creditlimit, $creditperiod); if ($edit == true) { $message = "Supplier {$companyname} `s informations modified succesful";