} } else { $parent_key = $_POST['sales_id']; } /* start auditing on add, update, delete */ $voucher_id = getValue("voucher_id", "sales_master", "sale_master_id = {$parent_key}", true); $voucher_aud_id = d_mysql_query("INSERT INTO voucher_master_aud SELECT NULL, vm.*, '{$oper}', {$_SESSION['user_id']}, now() FROM voucher_master vm WHERE vm.voucher_id = {$voucher_id}", true); d_mysql_query("INSERT INTO voucher_detail_aud SELECT NULL, vd.*, {$voucher_aud_id} FROM voucher_detail vd WHERE vd.voucher_id = {$voucher_id}"); $sales_aud_id = d_mysql_query("INSERT INTO sales_master_aud SELECT NULL, sm.*, {$voucher_aud_id}, '{$oper}', {$_SESSION['user_id']}, now() FROM sales_master sm WHERE sale_master_id = {$parent_key}", true); d_mysql_query("INSERT INTO sales_detail_aud SELECT NULL, sd.*, {$sales_aud_id} FROM sales_detail sd WHERE sd.sale_master_id = {$parent_key}"); /* end auditing on add, update, delete */ if ($oper == 'delete') { d_mysql_query("DELETE FROM sales_detail WHERE sale_master_id = {$_POST['sales_id']}"); d_mysql_query("DELETE FROM sales_master WHERE sale_master_id = {$_POST['sales_id']}"); d_mysql_query("DELETE FROM voucher_detail WHERE voucher_id = {$voucher_id}"); d_mysql_query("DELETE FROM voucher_master WHERE voucher_id = {$voucher_id}"); $data['key'] = $_POST['sales_id']; } $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) { $fp = fopen('sales_cud.htm', 'w'); fwrite($fp, "<html><head><title>SALES CUD</title></head><body>"); fwrite($fp, $out); fwrite($fp, "</body></html>"); fclose($fp); } print $output;
} echo $sql . "<br/>"; $result = mysql_query($sql) or die("Couldn t execute query." . mysql_error()); $_key = -1; if (strlen($voucher_detail_id) > 0) { $_key = $voucher_detail_id; } else { $_key = mysql_insert_id(); } $data["id_" . $i] = $_key; } } /* start auditing on add, update, delete */ $voucher_id = $parent_key; $voucher_aud_id = d_mysql_query("INSERT INTO voucher_master_aud SELECT NULL, vm.*, '{$oper}', {$_SESSION['user_id']}, now() FROM voucher_master vm WHERE vm.voucher_id = {$voucher_id}", true); d_mysql_query("INSERT INTO voucher_detail_aud SELECT NULL, vd.*, {$voucher_aud_id} FROM voucher_detail vd WHERE vd.voucher_id = {$voucher_id}"); /* end auditing on add, update, delete */ } $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) { $fp = fopen('voucher_cud.htm', 'w'); fwrite($fp, "<html><head><title>VOUCHER CUD</title></head><body>"); fwrite($fp, $out); fwrite($fp, "</body></html>"); fclose($fp); } print $output;
//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; $cr_acc = $v_cash_acc_id; } if (strlen($cash_book_id) > 0) { $voucher_id = getValue("voucher_id", "voucher_detail", "voucher_id = (SELECT voucher_id FROM cash_book WHERE cb_id = {$cash_book_id})", true); d_mysql_query("UPDATE voucher_detail SET debit_amount = {$cash_book_ammount}, account_ref_id = {$dr_acc} WHERE voucher_id = {$voucher_id} AND remarks = 'Debit'"); d_mysql_query("UPDATE voucher_detail SET credit_amount = {$cash_book_ammount}, account_ref_id = {$cr_acc} WHERE voucher_id = {$voucher_id} AND remarks = 'Credit'"); d_mysql_query("UPDATE voucher_master SET voucher_remarks = '{$remarks}' WHERE voucher_id = {$voucher_id}"); } else { $createVoucher = createVoucher($selected_company_id, $year_id, $dr_acc, $cr_acc, $cash_book_ammount, $remarks, $parent_key, 'CR', $cash_book_date, $_SESSION['user_id']); dump($createVoucher); } } } } dump($data); $mysqli->close(); $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) {
$sum = $_POST['totalSum']; if ($sum == $sale) { d_mysql_query("UPDATE voucher_detail SET debit_amount = 0 WHERE voucher_id = {$voucher_id} AND remarks = 'Discount'"); } else { if ($sum < $sale) { $dis = $sale - $sum; d_mysql_query("UPDATE voucher_detail SET debit_amount = {$sum} WHERE voucher_id = {$voucher_id} AND remarks = 'Debit'"); d_mysql_query("UPDATE voucher_detail SET debit_amount = {$dis} WHERE voucher_id = {$voucher_id} AND remarks = 'Discount'"); } } d_mysql_query("DELETE FROM sales_detail WHERE sales_detail_id = {$_POST['sales_item_id']}"); /* start auditing on add, update, delete */ $voucher_aud_id = d_mysql_query("INSERT INTO voucher_master_aud SELECT NULL, vm.*, 'update', {$_SESSION['user_id']}, now() FROM voucher_master vm WHERE vm.voucher_id = {$voucher_id}", true); d_mysql_query("INSERT INTO voucher_detail_aud SELECT NULL, vd.*, {$voucher_aud_id} FROM voucher_detail vd WHERE vd.voucher_id = {$voucher_id}"); $sales_aud_id = d_mysql_query("INSERT INTO sales_master_aud SELECT NULL, sm.*, {$voucher_aud_id}, 'update', {$_SESSION['user_id']}, now() FROM sales_master sm WHERE sale_master_id = {$_POST['sales_id']}", true); d_mysql_query("INSERT INTO sales_detail_aud SELECT NULL, sd.*, {$sales_aud_id} FROM sales_detail sd WHERE sd.sale_master_id = {$_POST['sales_id']}"); /* end auditing on add, update, delete */ $data['key'] = $_POST['counter']; $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) { $fp = fopen('sales_del.htm', 'w'); fwrite($fp, "<html><head><title>SALES DEL</title></head><body>"); fwrite($fp, $out); fwrite($fp, "</body></html>"); fclose($fp); } print $output;
$dis = $purchase - $sum; d_mysql_query("UPDATE voucher_detail SET debit_amount = {$sum} WHERE voucher_id = {$voucher_id} AND remarks = 'Debit'"); d_mysql_query("UPDATE voucher_detail SET debit_amount = {$dis} WHERE voucher_id = {$voucher_id} AND remarks = 'Discount'"); } } /* start auditing on add, update, delete */ $voucher_aud_id = d_mysql_query("INSERT INTO voucher_master_aud SELECT NULL, vm.*, 'update', {$_SESSION['user_id']}, now() FROM voucher_master vm WHERE vm.voucher_id = {$voucher_id}", true); d_mysql_query("INSERT INTO voucher_detail_aud SELECT NULL, vd.*, {$voucher_aud_id} FROM voucher_detail vd WHERE vd.voucher_id = {$voucher_id}"); echo "Purchase Import Exp"; $evoucher_id = getValue("voucher_id", "purchase_import_exp", "p_id = {$_POST['purchase_id']}", true); if ($evoucher_id != null) { $evoucher_aud_id = d_mysql_query("INSERT INTO voucher_master_aud SELECT NULL, vm.*, 'update', {$_SESSION['user_id']}, now() FROM voucher_master vm WHERE vm.voucher_id = {$evoucher_id}", true); d_mysql_query("INSERT INTO voucher_detail_aud SELECT NULL, vd.*, {$evoucher_aud_id} FROM voucher_detail vd WHERE vd.voucher_id = {$evoucher_id}"); } /* end auditing on add, update, delete */ } d_mysql_query("DELETE FROM purchase_detail WHERE pd_id = {$_POST['sales_item_id']}"); $data['key'] = $_POST['counter']; $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) { $fp = fopen('purchase_del.htm', 'w'); fwrite($fp, "<html><head><title>PURCHASE DELETE</title></head><body>"); fwrite($fp, $out); fwrite($fp, "</body></html>"); fclose($fp); } print $output;
<?php include '../includes/db.php'; require_once '../includes/funcs.inc.php'; include '../includes/JSON.php'; session_start(); $conn = oci_connect($db_user, $db_pass, $db_host); $selected_company_id = $_SESSION['company_id']; ob_start(); dump($_POST); $data = array(); d_mysql_query("DELETE FROM order_detail WHERE od_id = {$_POST['o_item_id']}"); $data['key'] = $_POST['counter']; $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) { $fp = fopen('order_del.htm', 'w'); fwrite($fp, "<html><head><title>ORDER CUD</title></head><body>"); fwrite($fp, $out); fwrite($fp, "</body></html>"); fclose($fp); } print $output;
if (strlen($order_detail_id) > 0) { $_key = $order_detail_id; } else { $_key = mysql_insert_id(); } $data["id_" . $i] = $_key; } } $url .= "?order_id={$parent_key}"; } else { $parent_key = $_POST['o_id']; } if ($oper == 'delete') { $data['key'] = $_POST['o_id']; d_mysql_query("DELETE FROM order_detail WHERE o_id = {$parent_key}"); d_mysql_query("DELETE FROM order_master WHERE o_id = {$parent_key}"); } echo "<a href='{$url}'>{$url}</a><br/>"; $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) { $fp = fopen('order_cud.htm', 'w'); fwrite($fp, "<html><head><title>ORDER CUD</title></head><body>"); fwrite($fp, $out); fwrite($fp, "</body></html>"); fclose($fp); } print $output;
if (strlen($godown_transfer_detail_id) > 0) { $_key = $godown_transfer_detail_id; } else { $_key = mysql_insert_id(); } $data["id_" . $i] = $_key; } } $url .= "?godown_transfer_id={$parent_key}"; } else { $parent_key = $_POST['godown_transfer_id']; } if ($oper == 'delete') { $data['key'] = $_POST['godown_transfer_id']; d_mysql_query("DELETE FROM godown_trans_detail WHERE tr_id = {$parent_key}"); d_mysql_query("DELETE FROM godown_trans_master WHERE tr_id = {$parent_key}"); } echo "<a href='{$url}'>{$url}</a><br/>"; $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) { $fp = fopen('gtransfer_cud.htm', 'w'); fwrite($fp, "<html><head><title>GODOWN TRANSFER CUD</title></head><body>"); fwrite($fp, $out); fwrite($fp, "</body></html>"); fclose($fp); } print $output;
$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); } else { //Credit Purchase Return //Debit - Party //Credit - Purchase Return $dr_acc = getValue("account_ref_id", "party", "party_code = {$_POST['purchase_return_party_hidden']}", true); $cr_acc = getValue("code", "sys_codes", "description = 'Purchase Return' AND company_ref_id = {$selected_company_id}", true); } $voucher_id = getValue("voucher_id", "purchase_return_master", "pur_ret_master_id = {$_POST['purchase_return_id']}", true); d_mysql_query("UPDATE voucher_detail SET debit_amount = {$sum}, account_ref_id = {$dr_acc} WHERE voucher_id = {$voucher_id} AND debit_amount > 0"); d_mysql_query("UPDATE voucher_detail SET credit_amount = {$sum}, account_ref_id = {$cr_acc} WHERE voucher_id = {$voucher_id} AND credit_amount > 0"); /* start auditing on add, update, delete */ $voucher_aud_id = d_mysql_query("INSERT INTO voucher_master_aud SELECT NULL, vm.*, 'update', {$_SESSION['user_id']}, now() FROM voucher_master vm WHERE vm.voucher_id = {$voucher_id}", true); d_mysql_query("INSERT INTO voucher_detail_aud SELECT NULL, vd.*, {$voucher_aud_id} FROM voucher_detail vd WHERE vd.voucher_id = {$voucher_id}"); /* end auditing on add, update, delete */ d_mysql_query("DELETE FROM purchase_return_detail WHERE pur_ret_detail_id = {$_POST['sales_item_id']}"); $data['key'] = $_POST['counter']; $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) { $fp = fopen('purchase_return_del.htm', 'w'); fwrite($fp, "<html><head><title>PURCHASE RETURN DELETE</title></head><body>"); fwrite($fp, $out); fwrite($fp, "</body></html>"); fclose($fp); } print $output;
<?php include '../includes/db.php'; require_once '../includes/funcs.inc.php'; include '../includes/JSON.php'; session_start(); $conn = oci_connect($db_user, $db_pass, $db_host); $selected_company_id = $_SESSION['company_id']; ob_start(); dump($_POST); $data = array(); $voucher_aud_id = d_mysql_query("INSERT INTO voucher_master_aud SELECT NULL, vm.*, 'delete', {$_SESSION['user_id']}, now() FROM voucher_master vm WHERE vm.voucher_id = {$_POST['voucher_id']}", true); d_mysql_query("INSERT INTO voucher_detail_aud SELECT NULL, vd.*, {$voucher_aud_id} FROM voucher_detail vd WHERE vd.voucher_id = {$_POST['voucher_id']}"); d_mysql_query("DELETE FROM voucher_detail WHERE voucher_detail_id = {$_POST['voucher_detail_id']}"); $data['key'] = $_POST['counter']; $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) { $fp = fopen('voucher_del.htm', 'w'); fwrite($fp, "<html><head><title>VOUCHER DEL</title></head><body>"); fwrite($fp, $out); fwrite($fp, "</body></html>"); fclose($fp); } print $output;
$oper = $_POST['oper']; if ($oper == 'add') { $data['seq'] = getSequenceNextVal('delivery_master', $_SESSION['company_id']); $first_part = " INSERT INTO delivery_master SET company_ref_id = {$_SESSION['company_id']}, year_id = {$year_id}, seq = {$data['seq']}, "; $first_tab_ins = $first_part . $first_colval; } else { if ($oper == 'update') { $first_part = " UPDATE delivery_master SET "; $last_part = " WHERE delivery_master_id = {$_POST['delivery_id']}"; $first_tab_ins = $first_part . $first_colval . $last_part; } } $url = "../transaction/delivery_chalan.php"; $parent_key = -1; if ($oper != 'delete') { $result = d_mysql_query($first_tab_ins) or die("Couldn't execute query1." . mysql_errno() . ": " . mysql_error()); if ($_POST['oper'] == 'update') { $parent_key = $_POST['delivery_id']; $data['seq'] = $_POST['sequence_id']; } else { if ($_POST['oper'] == 'add') { $parent_key = mysql_insert_id(); } } echo "Parent: " . $parent_key . "<br/>"; $data['key'] = $parent_key; $data['counter'] = $_POST['counter'] * 1; $counter = $_POST['counter'] * 1; for ($i = 1; $i <= $counter; $i++) { $i_code = $_POST["item_" . $i . "_hidden"]; if (strlen($i_code) > 0) {
//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; $cr_acc = $v_cash_acc_id; } if (strlen($cash_book_id) > 0) { $voucher_id = getValue("voucher_id", "voucher_detail", "voucher_id = (SELECT voucher_id FROM cash_book WHERE cb_id = {$cash_book_id})"); d_mysql_query("UPDATE voucher_detail SET debit_amount = {$cash_book_ammount}, account_ref_id = {$dr_acc} WHERE voucher_id = {$voucher_id} AND remarks = 'Debit'"); d_mysql_query("UPDATE voucher_detail SET credit_amount = {$cash_book_ammount}, account_ref_id = {$cr_acc} WHERE voucher_id = {$voucher_id} AND remarks = 'Credit'"); d_mysql_query("UPDATE voucher_master SET voucher_date = '{$cash_book_date}', voucher_remarks = '{$remarks}' WHERE voucher_id = {$voucher_id}"); } else { $createVoucher = createVoucher($selected_company_id, $year_id, $dr_acc, $cr_acc, $cash_book_ammount, $remarks, $parent_key, 'CR', $cash_book_date, $_SESSION['user_id']); dump($createVoucher); } } } } dump($data); $mysqli->close(); $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) {
$sum = getIVal("sum((ship_quantity * ship_rate) - IFNULL(discount_rate, 0)) amt", "purchase_detail", "p_id = {$data['purchase_id']}", true); $dr_acc = getIVal("code", "sys_codes", "description = 'Credit Purchase' AND company_ref_id = 3", true); $cr_acc = getIVal("account_ref_id", "party", "party_code = 634", true); dump($purchase); dump($sum); $createVoucher = createVoucher(3, $year_id, $dr_acc, $cr_acc, $purchase, 'Purchased from MERAJ', $data['purchase_id'], 'P', $ship_date, $_SESSION['user_id']); dump($createVoucher); $voucher_id = getIVal("voucher_id", "purchase_master", "p_id = {$data['purchase_id']}", true); if ($sum == $purchase) { $mysqli->query("UPDATE voucher_detail SET debit_amount = 0 WHERE voucher_id = {$voucher_id} AND remarks = 'Discount'"); } /* start auditing on add, update, delete */ $voucher_aud_id = d_mysql_query("INSERT INTO voucher_master_aud SELECT NULL, vm.*, '{$oper}', {$_SESSION['user_id']}, now() FROM voucher_master vm WHERE vm.voucher_id = {$voucher_id}", true); d_mysql_query("INSERT INTO voucher_detail_aud SELECT NULL, vd.*, {$voucher_aud_id} FROM voucher_detail vd WHERE vd.voucher_id = {$voucher_id}"); $purchase_aud_id = d_mysql_query("INSERT INTO purchase_master_aud SELECT NULL, pm.*, {$voucher_aud_id}, '{$oper}', {$_SESSION['user_id']}, now() FROM purchase_master pm WHERE p_id = {$data['purchase_id']}", true); d_mysql_query("INSERT INTO purchase_detail_aud SELECT NULL, pd.*, {$purchase_aud_id} FROM purchase_detail pd WHERE pd.p_id = {$data['purchase_id']}"); /* end auditing on add, update, delete */ } else { if ($oper == 'update') { //do nothing in case of update } } $mysqli->close(); $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) { $fp = fopen('sales_purchase_cud.htm', 'w'); fwrite($fp, "<html><head><title>SALES PURCHASE CUD</title></head><body>");
function dd_mysql_query($str) { d_mysql_query($str); return mysql_query($str); }
if (strlen($voucher_id) > 0) { d_mysql_query("UPDATE voucher_detail SET debit_amount = {$purchase}, account_ref_id = {$dr_acc} WHERE voucher_id = {$voucher_id} AND remarks = 'Debit'"); d_mysql_query("UPDATE voucher_detail SET credit_amount = {$purchase}, account_ref_id = {$cr_acc} WHERE voucher_id = {$voucher_id} AND remarks = 'Credit'"); } } else { $createVoucher = createVoucher($selected_company_id, $year_id, $dr_acc, $cr_acc, $purchase, $_POST['purchase_remarks'], $parent_key, 'P', my_sql_date($_POST['purchase_receive_date']), $_SESSION['user_id']); dump($createVoucher); } $voucher_id = getValue("voucher_id", "purchase_master", "p_id = {$parent_key}", true); if ($sum == $purchase) { d_mysql_query("UPDATE voucher_detail SET debit_amount = 0 WHERE voucher_id = {$voucher_id} AND remarks = 'Discount'"); } else { if ($sum < $purchase) { $dis = $purchase - $sum; d_mysql_query("UPDATE voucher_detail SET debit_amount = {$sum} WHERE voucher_id = {$voucher_id} AND remarks = 'Debit'"); d_mysql_query("UPDATE voucher_detail SET debit_amount = {$dis} WHERE voucher_id = {$voucher_id} AND remarks = 'Discount'"); } } $mysqli->close(); $url = "../transaction/purchase.php?purchase_id={$parent_key}"; echo "<a href='{$url}'>{$url}</a><br/>"; $json = new Services_JSON(); $output = $json->encode($data); print $output; $out = ob_get_contents(); ob_end_clean(); if (!isLive()) { $fp = fopen('purchase_cud.htm', 'w'); fwrite($fp, "<html><head><title>PURCHASE CUD</title></head><body>"); fwrite($fp, $out); fwrite($fp, "</body></html>");