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