} 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;