$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) {