} else {
$unit_id = "'{$unit_id}'";
}
$sql = "i_code = '{$i_code}', pr_qty = '{$purchase_return_qty}', pr_rate = '{$purchase_return_rate}', unit_id = {$unit_id}";
if (strlen($purchase_return_detail_id) > 0) {
$sql = " UPDATE purchase_return_detail SET {$sql} WHERE pur_ret_detail_id = {$purchase_return_detail_id}";
} else {
$sql = " INSERT INTO purchase_return_detail SET pur_ret_master_id = {$parent_key}, {$sql}";
}
echo $sql . "<br/>";
oci_parse($conn, $sql) or die("Couldn t execute query." . oci_error());
$_key = -1;
if (strlen($purchase_return_detail_id) > 0) {
$_key = $purchase_return_detail_id;
} else {
$_key = seq_guid . nextval();
}
$data["id_" . $i] = $_key;
}
}
$purchase = $_POST['totalPurchase'];
$sum = $_POST['totalSum'];
$tax = $_POST['totalTax'];
$dr_acc = -1;
$cr_acc = -1;
if ($_POST['purchase_return_type'] == 'C') {
//Cash Purchase Return
//Debit - Purchase Return
//Credit - Cash Account (Cash in hand)
$dr_acc = getValue("code", "sys_codes", "description = 'Purchase Return' AND company_ref_id = {$selected_company_id}", true);
$cr_acc = getValue("code", "sys_codes", "description = 'Cash in Hand' AND company_ref_id = {$selected_company_id}", true);
function d_mysql_query($str, $insert = false)
{
echo "<pre>{$str}</pre>";
$result = oci_parse($GLOBALS['conn'], $str);
oci_execute($result);
if ($insert === true) {
return seq_guid . nextval();
}
return $result;
}
}
}
}
$finalcurd = $firstpart . $colval . $lastpart;
if (strlen($finalcurd) > 0) {
dumpFile($finalcurd, 'Final SQL', 'a');
$result = oci_parse($conn, $finalcurd);
oci_execute($result);
dumpFile($result, 'Final Result');
$error = oci_error();
dumpFile($error, 'Final Error');
if ($table == 'cheque_post' && $_POST['cheque_status'] == 'Clear') {
include_once 'connecti.php';
$master = $_POST['id'];
if ($oper == 'add') {
$master = seq_guid . nextval();
}
$voucher_id = getValue("voucher_id", "cheque_post", "cheque_post_id = {$master}");
if (strlen($voucher_id) > 0) {
$db = "UPDATE voucher_detail SET debit_amount = {$_POST['cheque_amount']}, account_ref_id = {$_POST['bank_ref_id']} WHERE voucher_id = {$voucher_id} AND remarks = 'Debit'";
dumpFile($db, 'Debit', 'a');
oci_parse($conn, $db);
$cr = "UPDATE voucher_detail SET credit_amount = {$_POST['cheque_amount']}, account_ref_id = {$_POST['party_ref_id']} WHERE voucher_id = {$voucher_id} AND remarks = 'Credit'";
dumpFile($cr, 'Credit', 'a');
oci_parse($conn, $cr);
} else {
$year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$_GET['comp']} AND is_active = 'Yes'");
$debug = createVoucher($_GET['comp'], $year_id, $_POST['bank_ref_id'], $_POST['party_ref_id'], $_POST['cheque_amount'], 'Cheque Cleared', $master, 'CQ', $_POST['cheque_date'], $_SESSION['user_id']);
dumpFile($debug, 'Create Voucher', 'a');
}
}
$cash_book_id = $_POST["id_" . $i];
$remarks = $_POST["inp2_{$i}"];
$sql = "account_ref_id = '{$account_code}', cb_date = '{$cash_book_date}', cb_type = '{$cash_book_type}', cb_amount = '{$cash_book_ammount}', cb_remarks = '{$remarks}', book_id = '{$v_cash_acc_id}'";
if (strlen($cash_book_id) > 0) {
$sql = " UPDATE cash_book SET {$sql} WHERE cb_id = {$cash_book_id}";
} else {
$sql = " INSERT INTO cash_book SET company_ref_id = {$selected_company_id}, year_id = {$year_id}, seq = " . getSequenceNextVal('cash_book', $_SESSION['company_id']) . ", {$sql}";
}
dump($sql);
$result = oci_parse($conn, $sql) or die("Couldn t execute query." . oci_error());
oci_execute($result);
$parent_key = -1;
if (strlen($cash_book_id) > 0) {
$parent_key = $cash_book_id;
} else {
$parent_key = seq_guid . nextval();
}
$data['cash_book_id'] = $parent_key;
$dr_acc = -1;
$cr_acc = -1;
if ($cash_book_type == 'R') {
//Recieve
//Debit - Cash Account (Cash in hand)
//Credit - $account_code
$dr_acc = $v_cash_acc_id;
$cr_acc = $account_code;
} else {
//Payment
//Debit - $account_code
//Credit - Cash Account (Cash in hand)
$dr_acc = $account_code;
