public function post($rest)
{
$req = $rest->request();
$info = $req->post();
// Validate Required Fields
if (!isset($info['supp_name'])) {
api_error(412, 'Supplier Name is required [supp_name]');
}
if (!isset($info['supp_ref'])) {
api_error(412, 'Supplier Reference is required [supp_ref]');
}
if (!isset($info['address'])) {
api_error(412, 'Address is required [address]');
}
if (!isset($info['supp_address'])) {
api_error(412, 'Supplier Address 2 is required [supp_address]');
}
if (!isset($info['gst_no'])) {
api_error(412, 'GST No. is required [gst_no]');
}
if (!isset($info['supp_account_no'])) {
api_error(412, 'Supplier Account Number is required [supp_account_no]');
}
if (!isset($info['bank_account'])) {
api_error(412, 'Bank Account is required [bank_account]');
}
if (!isset($info['credit_limit'])) {
api_error(412, 'Credit Limir is required [credit_limit]');
}
if (!isset($info['curr_code'])) {
api_error(412, 'Currency Code is required [curr_code]');
}
if (!isset($info['payment_terms'])) {
api_error(412, 'Payment Terms is required [payment_terms]');
}
if (!isset($info['payable_account'])) {
api_error(412, 'Payable Account is required [payable_account]');
}
if (!isset($info['purchase_account'])) {
api_error(412, 'Purchase Account is required [purchase_account]');
}
if (!isset($info['payment_discount_account'])) {
api_error(412, 'Payment Discount Account is required [payment_discount]');
}
if (!isset($info['tax_group_id'])) {
api_error(412, 'Tax Group Id is required [tax_group_id]');
}
if (!isset($info['tax_included'])) {
api_error(412, 'Tax Included is required [tax_included]');
}
if (!isset($info['website'])) {
$info['website'] = '';
}
if (!isset($info['notes'])) {
$info['notes'] = '';
}
/*
* $supp_name, $supp_ref, $address, $supp_address, $gst_no, $website, $supp_account_no, $bank_account,
* $credit_limit, $dimension_id, $dimension2_id, $curr_code, $payment_terms, $payable_account,
* $purchase_account, $payment_discount_account, $notes, $tax_group_id, $tax_included
*/
add_supplier($info['supp_name'], $info['supp_ref'], $info['address'], $info['supp_address'], $info['gst_no'], $info['website'], $info['supp_account_no'], $info['bank_account'], $info['credit_limit'], 0, 0, $info['curr_code'], $info['payment_terms'], $info['payable_account'], $info['purchase_account'], $info['payment_discount_account'], $info['notes'], $info['tax_group_id'], $info['tax_included']);
$id = db_insert_id();
$sup = get_supplier($id);
if ($sup != null) {
api_create_response(json_encode($sup));
} else {
api_error(500, 'Could Not Save to Database');
}
}
<?php
switch ($_GET['action']) {
case 'add_supplier':
add_supplier();
break;
case 'get_supplier':
get_supplier();
break;
case 'edit_product':
edit_product();
break;
case 'get_suppliers':
get_suppliers();
break;
case 'delete_product':
delete_product();
break;
case 'update_product':
update_product();
break;
}
function add_supplier()
{
$data = json_decode(file_get_contents("php://input"));
$suppliername = mysql_real_escape_string($data->suppliername);
$supplieraddress = mysql_real_escape_string($data->supplieraddress);
$supplierphone = mysql_real_escape_string($data->supplierphone);
$supplieremail = mysql_real_escape_string($data->supplieremail);
$supplieritem = mysql_real_escape_string($data->supplieritem);
$supplierunitprice = mysql_real_escape_string($data->supplierunitprice);
}
if (strlen($_POST['supp_ref']) == 0 || $_POST['supp_ref'] == "") {
$input_error = 1;
display_error(_("The supplier short name must be entered."));
set_focus('supp_ref');
}
if ($input_error != 1) {
begin_transaction();
if ($supplier_id) {
update_supplier($_POST['supplier_id'], $_POST['supp_name'], $_POST['supp_ref'], $_POST['address'], $_POST['supp_address'], $_POST['gst_no'], $_POST['website'], $_POST['supp_account_no'], $_POST['bank_account'], input_num('credit_limit', 0), $_POST['dimension_id'], $_POST['dimension2_id'], $_POST['curr_code'], $_POST['payment_terms'], $_POST['payable_account'], $_POST['purchase_account'], $_POST['payment_discount_account'], $_POST['notes'], $_POST['tax_group_id'], get_post('tax_included', 0));
update_record_status($_POST['supplier_id'], $_POST['inactive'], 'suppliers', 'supplier_id');
$Ajax->activate('supplier_id');
// in case of status change
display_notification(_("Supplier has been updated."));
} else {
add_supplier($_POST['supp_name'], $_POST['supp_ref'], $_POST['address'], $_POST['supp_address'], $_POST['gst_no'], $_POST['website'], $_POST['supp_account_no'], $_POST['bank_account'], input_num('credit_limit', 0), $_POST['dimension_id'], $_POST['dimension2_id'], $_POST['curr_code'], $_POST['payment_terms'], $_POST['payable_account'], $_POST['purchase_account'], $_POST['payment_discount_account'], $_POST['notes'], $_POST['tax_group_id'], check_value('tax_included'));
$supplier_id = $_POST['supplier_id'] = db_insert_id();
add_crm_person($_POST['supp_ref'], $_POST['contact'], '', $_POST['address'], $_POST['phone'], $_POST['phone2'], $_POST['fax'], $_POST['email'], $_POST['rep_lang'], '');
add_crm_contact('supplier', 'general', $supplier_id, db_insert_id());
display_notification(_("A new supplier has been added."));
$Ajax->activate('_page_body');
}
commit_transaction();
}
} elseif (isset($_POST['delete']) && $_POST['delete'] != "") {
//the link to delete a selected record was clicked instead of the submit button
$cancel_delete = 0;
// PREVENT DELETES IF DEPENDENT RECORDS IN 'supp_trans' , purch_orders
if (key_in_foreign_table($_POST['supplier_id'], 'supp_trans', 'supplier_id')) {
$cancel_delete = 1;
display_error(_("Cannot delete this supplier because there are transactions that refer to this supplier."));
<html>
<title> Add Supplier </title>
<?php
function add_supplier($fname, $lname, $address, $contact, $details)
{
$dbc = mysql_connect('localhost', 'root', 'rishi');
if (!$dbc) {
die('NOT CONNECTED:' . mysql_error());
}
$db_selected = mysql_select_db("restaurant", $dbc);
if (!$db_selected) {
die('NOT CONNECTED TO DATABASE:' . mysql_error());
}
$items = "\"" . $fname . "\",\"" . $lname . "\",\"" . $address . "\",\"" . $contact . "\",\"" . $details . "\"";
$query = "insert into `SUPPLIER`(`Fname`,`Lname`,`Address`,`Contact`,`Details`)values (" . $items . ");";
$result = mysql_query($query);
}
add_supplier($_POST["Fname"], $_POST["Lname"], $_POST["Address"], $_POST["Contact"], $_POST["Details"]);
?>
<script type="text/javascript">
function done()
{
alert("New Supplier Added!!!");
}
</script>
<body onload="done()" background = "1.png">
<meta HTTP-EQUIV="REFRESH" content="0; url=admin.html">
</body>
</html>
