$arr['purchase_rate'] = zeroTrim($row[3]);
$arr['unit_id'] = $row[4];
$arr['item_discount'] = zeroTrim($row[5]);
$arr['i_name'] = $row[6];
$arr['valT'] = zeroTrim($row[7]);
$purchase_detail[] = $arr;
}
$sql = "" . " SELECT pi_id, " . " exp_code, " . " sys_codes.description, " . "\t amount, " . "\t purchase_import_exp.account_ref_id, " . " chart_of_account.account_name, " . " remarks " . " FROM purchase_import_exp " . " LEFT OUTER JOIN sys_codes ON purchase_import_exp.exp_code = sys_codes.sys_codes_ref_id " . " LEFT OUTER JOIN chart_of_account ON purchase_import_exp.account_ref_id = chart_of_account.account_ref_id " . " WHERE p_id = {$_GET['purchase_id']} " . "ORDER BY pi_id";
$purchase_search = oci_parse($conn, $sql);
oci_execute($purchase_search);
while ($row = oci_fetch_array($purchase_search)) {
$arr = array();
$arr['purchase_import_id'] = $row[0];
$arr['e_code'] = $row[1];
$arr['e_name'] = $row[2];
$arr['amt'] = zeroTrim($row[3]);
$arr['coa'] = $row[4];
$arr['account_name'] = $row[5];
$arr['remarks'] = $row[6];
$purchase_import[] = $arr;
}
}
}
$discountAvailable = strlen(getValue("code", "sys_codes", "description = 'Purchase Discount' AND company_ref_id = {$selected_company_id}")) > 0;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title><?php
$sales_return_master['fyc'] = $row[9];
if (strlen($sales_return_master['seq']) < 1) {
header("Location: ../transaction/sales_return.php");
}
$sql = "" . " SELECT sd.rsales_detail_id,\n" . " im.i_code,\n" . " sd.rsales_qty,\n" . "\t sd.rsales_rate,\n" . "\t sd.unit_id,\n" . " CONCAT(im.cno, IFNULL(concat(' -- ', manufacturer_no), ''), ' -- ', description) description,\n" . " IFNULL(t.tax_rate, 0) tax_rate\n" . " FROM sales_return_detail sd\n" . " LEFT OUTER JOIN item_master im ON sd.i_code = im.i_code\n" . " LEFT OUTER JOIN vu_item_tax_rate t ON t.i_code = im.i_code\n" . " INNER JOIN sales_return_master sm ON sm.rsale_master_id = sd.rsale_master_id\n" . " INNER JOIN sys_financial_year y ON sm.year_id = y.year_id AND IFNULL(y.is_close, 'No') = 'No'\n" . " WHERE sm.rsale_master_id = {$_GET['sales_return_id']}\n" . " AND sm.company_ref_id = {$selected_company_id}\n" . "ORDER BY sd.rsales_detail_id";
$sales_return_search = oci_parse($conn, $sql);
oci_execute($sales_return_search);
while ($row = oci_fetch_array($sales_return_search)) {
$arr = array();
$arr['sales_return_detail_id'] = $row[0];
$arr['i_code'] = $row[1];
$arr['sales_return_qty'] = $row[2];
$arr['sales_return_rate'] = $row[3];
$arr['unit_id'] = $row[4];
$arr['i_name'] = $row[5];
$arr['valT'] = zeroTrim($row[6] * 1, '0');
$sales_return_detail[] = $arr;
}
}
}
//echo "<pre style='text-align:left;'>"; print_r($sales_return_detail); echo "</pre>";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title><?php
echo $_SESSION['companyname'];
?>
include '../includes/connect.php';
include '../includes/JSON.php';
include '../includes/funcs.inc.php';
$data = array();
$data['date'] = "";
$data['rate'] = "";
if (isset($_GET['tax']) && $_GET['tax'] == 'true') {
$data['rate'] = "0%";
$isTax = getValue("tax", "party", "party_code = {$_GET['party']}");
if ($isTax == 'Yes') {
$tax = getValue("sum(t.tax_rate)", "vu_item_tax it INNER JOIN taxonomy t ON it.tax_id = t.tax_id", "it.i_code = {$_GET['i_code']}");
if (strlen($tax) < 1) {
$tax = "0";
}
$data['rate'] = zeroTrim($tax) . "%";
}
} else {
if (isset($_GET['i_code'])) {
$where = "";
if (isset($_GET['party']) && strlen($_GET['party']) > 0) {
$where = " AND m.party_code = {$_GET['party']}\n";
}
$sql = "";
if (isset($_GET['purchase']) && $_GET['purchase'] == 'true') {
$sql = "" . "SELECT DATE_FORMAT(m.shipping_date, '%d-%b-%y') shipping_date, d.ship_rate\n" . " FROM purchase_detail d\n" . " INNER JOIN purchase_master m ON m.p_id = d.p_id\n" . " WHERE d.i_code = {$_GET['i_code']}\n" . $where . "ORDER BY m.shipping_date DESC LIMIT 0, 1";
} else {
$sql = "" . "SELECT DATE_FORMAT(m.sale_date, '%d-%b-%y') sale_date, d.sales_rate\n" . " FROM sales_detail d\n" . " INNER JOIN sales_master m ON m.sale_master_id = d.sale_master_id\n" . " WHERE d.i_code = {$_GET['i_code']}\n" . $where . "ORDER BY m.sale_date DESC LIMIT 0, 1";
}
$ret = mysql_query($sql);
if ($ret !== false) {
