function get_domestic_price($myrow, $stock_id, $qty, $old_std_cost, $old_qty)
{
if ($myrow['type'] == ST_SUPPRECEIVE || $myrow['type'] == ST_SUPPCREDIT) {
$price = $myrow['price'];
if ($myrow['type'] == ST_SUPPRECEIVE) {
// Has the supplier invoice increased the receival price?
$sql = "SELECT DISTINCT act_price FROM " . TB_PREF . "purch_order_details pod INNER JOIN " . TB_PREF . "grn_batch grn ON pod.order_no =\n\t\t\t\tgrn.purch_order_no WHERE grn.id = " . $myrow['trans_no'] . " AND pod.item_code = '{$stock_id}'";
$result = db_query($sql, "Could not retrieve act_price from purch_order_details");
$row = db_fetch_row($result);
if ($row[0] > 0 and $row[0] != $myrow['price']) {
$price = $row[0];
}
}
if ($myrow['person_id'] > 0) {
// Do we have foreign currency?
$supp = get_supplier($myrow['person_id']);
$currency = $supp['curr_code'];
$ex_rate = get_exchange_rate_to_home_currency($currency, sql2date($myrow['tran_date']));
$price /= $ex_rate;
}
} elseif ($myrow['type'] != ST_INVADJUST) {
// calcutale the price from avg. price
$price = ($myrow['standard_cost'] * $qty - $old_std_cost * $old_qty) / $myrow['qty'];
} else {
$price = $myrow['standard_cost'];
}
// Item Adjustments just have the real cost
return $price;
}
start_row();
supplier_list_cells(tr("Select a supplier: "), 'supplier_id', null);
submit_cells('SelectSupplier', tr("Edit Supplier"));
end_row();
end_table();
} else {
hidden('supplier_id', $_POST['supplier_id']);
}
hyperlink_params($_SERVER['PHP_SELF'], tr("Enter a new supplier"), "New=1");
echo "<br>";
//start_table("class='tablestyle2'", 0, 3);
start_table("class='tablestyle'", 3);
table_section_title(tr("Supplier"));
if (isset($_POST['supplier_id']) && !isset($_POST['New'])) {
//SupplierID exists - either passed when calling the form or from the form itself
$myrow = get_supplier($_POST['supplier_id']);
$_POST['supp_name'] = $myrow["supp_name"];
$_POST['address'] = $myrow["address"];
$_POST['email'] = $myrow["email"];
$_POST['bank_account'] = $myrow["bank_account"];
$_POST['dimension_id'] = $myrow["dimension_id"];
$_POST['dimension2_id'] = $myrow["dimension2_id"];
$_POST['curr_code'] = $myrow["curr_code"];
$_POST['payment_terms'] = $myrow["payment_terms"];
$_POST['tax_group_id'] = $myrow["tax_group_id"];
$_POST['payable_account'] = $myrow["payable_account"];
$_POST['purchase_account'] = $myrow["purchase_account"];
$_POST['payment_discount_account'] = $myrow["payment_discount_account"];
} else {
// its a new supplier being added
hidden('New', 'Yes');
function handle_commit_order()
{
$cart =& $_SESSION['PO'];
if (can_commit()) {
copy_to_cart();
if ($cart->trans_type != ST_PURCHORDER) {
// for direct grn/invoice set same dates for lines as for whole document
foreach ($cart->line_items as $line_no => $line) {
$cart->line_items[$line_no]->req_del_date = $cart->orig_order_date;
}
}
if ($cart->order_no == 0) {
// new po/grn/invoice
/*its a new order to be inserted */
$ref = $cart->reference;
if ($cart->trans_type != ST_PURCHORDER) {
$cart->reference = 'auto';
begin_transaction();
// all db changes as single transaction for direct document
}
$order_no = add_po($cart);
new_doc_date($cart->orig_order_date);
$cart->order_no = $order_no;
if ($cart->trans_type == ST_PURCHORDER) {
unset($_SESSION['PO']);
meta_forward($_SERVER['PHP_SELF'], "AddedID={$order_no}");
}
//Direct GRN
if ($cart->trans_type == ST_SUPPRECEIVE) {
$cart->reference = $ref;
}
if ($cart->trans_type != ST_SUPPINVOICE) {
$cart->Comments = $cart->reference;
}
//grn does not hold supp_ref
foreach ($cart->line_items as $key => $line) {
$cart->line_items[$key]->receive_qty = $line->quantity;
}
$grn_no = add_grn($cart);
if ($cart->trans_type == ST_SUPPRECEIVE) {
commit_transaction();
// save PO+GRN
unset($_SESSION['PO']);
meta_forward($_SERVER['PHP_SELF'], "AddedGRN={$grn_no}");
}
// Direct Purchase Invoice
$inv = new supp_trans(ST_SUPPINVOICE);
$inv->Comments = $cart->Comments;
$inv->supplier_id = $cart->supplier_id;
$inv->tran_date = $cart->orig_order_date;
$inv->due_date = $cart->due_date;
$inv->reference = $ref;
$inv->supp_reference = $cart->supp_ref;
$inv->tax_included = $cart->tax_included;
$supp = get_supplier($cart->supplier_id);
$inv->tax_group_id = $supp['tax_group_id'];
$inv->ov_amount = $inv->ov_gst = $inv->ov_discount = 0;
$total = 0;
foreach ($cart->line_items as $key => $line) {
$inv->add_grn_to_trans($line->grn_item_id, $line->po_detail_rec, $line->stock_id, $line->item_description, $line->receive_qty, 0, $line->receive_qty, $line->price, $line->price, true, get_standard_cost($line->stock_id), '');
$inv->ov_amount += round2($line->receive_qty * $line->price, user_price_dec());
}
$inv->tax_overrides = $cart->tax_overrides;
if (!$inv->tax_included) {
$taxes = $inv->get_taxes($inv->tax_group_id, 0, false);
foreach ($taxes as $taxitem) {
$total += isset($taxitem['Override']) ? $taxitem['Override'] : $taxitem['Value'];
}
}
$inv->ex_rate = $cart->ex_rate;
$inv_no = add_supp_invoice($inv);
commit_transaction();
// save PO+GRN+PI
// FIXME payment for cash terms. (Needs cash account selection)
unset($_SESSION['PO']);
meta_forward($_SERVER['PHP_SELF'], "AddedPI={$inv_no}");
} else {
// order modification
$order_no = update_po($cart);
unset($_SESSION['PO']);
meta_forward($_SERVER['PHP_SELF'], "AddedID={$order_no}&Updated=1");
}
}
}
public function delete($rest, $id)
{
$req = $rest->request();
$info = $req->post();
$sup = get_supplier($id);
if ($sup == null) {
api_error(400, 'Invalid Supplier ID');
}
delete_supplier($id);
$sup = null;
$sup = get_supplier($id);
if ($sup != null) {
api_error(500, 'Could Not Delete from Database');
} else {
api_success_response("Supplier has been deleted");
}
}
function supplier_settings(&$supplier_id)
{
start_outer_table(TABLESTYLE2);
table_section(1);
if ($supplier_id) {
//SupplierID exists - either passed when calling the form or from the form itself
$myrow = get_supplier($_POST['supplier_id']);
$_POST['supp_name'] = $myrow["supp_name"];
$_POST['supp_ref'] = $myrow["supp_ref"];
$_POST['address'] = $myrow["address"];
$_POST['supp_address'] = $myrow["supp_address"];
$_POST['gst_no'] = $myrow["gst_no"];
$_POST['website'] = $myrow["website"];
$_POST['supp_account_no'] = $myrow["supp_account_no"];
$_POST['bank_account'] = $myrow["bank_account"];
$_POST['dimension_id'] = $myrow["dimension_id"];
$_POST['dimension2_id'] = $myrow["dimension2_id"];
$_POST['curr_code'] = $myrow["curr_code"];
$_POST['payment_terms'] = $myrow["payment_terms"];
$_POST['credit_limit'] = price_format($myrow["credit_limit"]);
$_POST['tax_group_id'] = $myrow["tax_group_id"];
$_POST['tax_included'] = $myrow["tax_included"];
$_POST['payable_account'] = $myrow["payable_account"];
$_POST['purchase_account'] = $myrow["purchase_account"];
$_POST['payment_discount_account'] = $myrow["payment_discount_account"];
$_POST['notes'] = $myrow["notes"];
$_POST['inactive'] = $myrow["inactive"];
} else {
$_POST['supp_name'] = $_POST['supp_ref'] = $_POST['address'] = $_POST['supp_address'] = $_POST['tax_group_id'] = $_POST['website'] = $_POST['supp_account_no'] = $_POST['notes'] = '';
$_POST['dimension_id'] = 0;
$_POST['dimension2_id'] = 0;
$_POST['tax_included'] = 0;
$_POST['sales_type'] = -1;
$_POST['gst_no'] = $_POST['bank_account'] = '';
$_POST['payment_terms'] = '';
$_POST['credit_limit'] = price_format(0);
$company_record = get_company_prefs();
$_POST['curr_code'] = $company_record["curr_default"];
$_POST['payable_account'] = $company_record["creditors_act"];
$_POST['purchase_account'] = '';
// default/item's cogs account
$_POST['payment_discount_account'] = $company_record['pyt_discount_act'];
}
table_section_title(_("Basic Data"));
text_row(_("Supplier Name:"), 'supp_name', null, 42, 40);
text_row(_("Supplier Short Name:"), 'supp_ref', null, 30, 30);
text_row(_("GSTNo:"), 'gst_no', null, 42, 40);
link_row(_("Website:"), 'website', null, 35, 55);
if ($supplier_id && !is_new_supplier($supplier_id) && (key_in_foreign_table($_POST['supplier_id'], 'supp_trans', 'supplier_id') || key_in_foreign_table($_POST['supplier_id'], 'purch_orders', 'supplier_id'))) {
label_row(_("Supplier's Currency:"), $_POST['curr_code']);
hidden('curr_code', $_POST['curr_code']);
} else {
currencies_list_row(_("Supplier's Currency:"), 'curr_code', null);
}
tax_groups_list_row(_("Tax Group:"), 'tax_group_id', null);
text_row(_("Our Customer No:"), 'supp_account_no', null, 42, 40);
table_section_title(_("Purchasing"));
text_row(_("Bank Name/Account:"), 'bank_account', null, 42, 40);
amount_row(_("Credit Limit:"), 'credit_limit', null);
payment_terms_list_row(_("Payment Terms:"), 'payment_terms', null);
//
// tax_included option from supplier record is used directly in update_average_cost() function,
// therefore we can't edit the option after any transaction waas done for the supplier.
//
if (is_new_supplier($supplier_id)) {
check_row(_("Prices contain tax included:"), 'tax_included');
} else {
hidden('tax_included');
label_row(_("Prices contain tax included:"), $_POST['tax_included'] ? _('Yes') : _('No'));
}
table_section_title(_("Accounts"));
gl_all_accounts_list_row(_("Accounts Payable Account:"), 'payable_account', $_POST['payable_account']);
gl_all_accounts_list_row(_("Purchase Account:"), 'purchase_account', $_POST['purchase_account'], false, false, _("Use Item Inventory/COGS Account"));
gl_all_accounts_list_row(_("Purchase Discount Account:"), 'payment_discount_account', $_POST['payment_discount_account']);
if (!$supplier_id) {
table_section_title(_("Contact Data"));
text_row(_("Phone Number:"), 'phone', null, 32, 30);
text_row(_("Secondary Phone Number:"), 'phone2', null, 32, 30);
}
table_section(2);
$dim = get_company_pref('use_dimension');
if ($dim >= 1) {
table_section_title(_("Dimension"));
dimensions_list_row(_("Dimension") . " 1:", 'dimension_id', null, true, " ", false, 1);
if ($dim > 1) {
dimensions_list_row(_("Dimension") . " 2:", 'dimension2_id', null, true, " ", false, 2);
}
}
if ($dim < 1) {
hidden('dimension_id', 0);
}
if ($dim < 2) {
hidden('dimension2_id', 0);
}
table_section_title(_("Addresses"));
textarea_row(_("Mailing Address:"), 'address', null, 35, 5);
textarea_row(_("Physical Address:"), 'supp_address', null, 35, 5);
table_section_title(_("General"));
textarea_row(_("General Notes:"), 'notes', null, 35, 5);
if ($supplier_id) {
record_status_list_row(_("Supplier status:"), 'inactive');
} else {
table_section_title(_("Contact Data"));
text_row(_("Contact Person:"), 'contact', null, 42, 40);
text_row(_("Fax Number:"), 'fax', null, 32, 30);
email_row(_("E-mail:"), 'email', null, 35, 55);
languages_list_row(_("Document Language:"), 'rep_lang', null, _('System default'));
}
end_outer_table(1);
div_start('controls');
if ($supplier_id) {
submit_center_first('submit', _("Update Supplier"), _('Update supplier data'), @$_REQUEST['popup'] ? true : 'default');
submit_return('select', get_post('supplier_id'), _("Select this supplier and return to document entry."));
submit_center_last('delete', _("Delete Supplier"), _('Delete supplier data if have been never used'), true);
} else {
submit_center('submit', _("Add New Supplier Details"), true, '', 'default');
}
div_end();
}
<?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);
} else {
$OUTPUT = details2($_POST);
}
break;
default:
if (isset($_GET['supid'])) {
$OUTPUT = slctacc($_GET);
} else {
$OUTPUT = "<li> - Invalid use of module.</li>";
}
}
} else {
if (isset($_GET['supid'])) {
$OUTPUT = slctacc($_GET);
} else {
$OUTPUT = get_supplier();
}
}
# get templete
require "../template.php";
function get_supplier()
{
db_connect();
$get_supp = "SELECT * FROM suppliers ORDER BY supname";
$run_supp = db_exec($get_supp) or errDie("Unable to get suppliers information.");
if (pg_numrows($run_supp) < 1) {
return "\n\t\t\t\t\t<li class='err'>No Suppliers Could Be Found.</li>" . mkQuickLinks(ql("../core/trans-new.php", "Journal Transactions"), ql("../cupp-new.php", "New Supplier"), ql("../supp-view.php", "View Suppliers"));
} else {
$supplier_drop = "<select name='supid'>";
while ($sarr = pg_fetch_array($run_supp)) {
$supplier_drop .= "<option value='{$sarr['supid']}'>{$sarr['supname']}</option>";
</div>
</div>
<div class="row">
<div class="col s9 offset-s1">
<!-- Tabel Stok-->
<table id="tabel-supplier" class="tabel centered">
<thead>
<tr>
<th data-field="id-supplier">ID Supplier</th>
<th data-field="nama-supplier">Nama Supplier</th>
<th data-field="nama-perusahaan">Nama Perusahaan</th>
</tr>
</thead>
<tbody>
<?php
foreach (get_supplier() as $data) {
?>
<tr class="data-row">
<td><?php
echo $data['sid'];
?>
</td>
<td><?php
echo $data['nama'];
?>
</td>
<td><?php
echo $data['perusahaan'];
?>
</td>
<td><div class="edit-btn"><a class="waves-effect waves-light btn modal-trigger orange darken-1" href="#edit-modal">Ubah</a></div></td>
