}
if ($_POST['oper'] == 'update') {
$sum = getValue("sum(pr_qty * pr_rate) amt", "purchase_return_detail", "pur_ret_master_id = {$parent_key}");
$voucher_id = getValue("voucher_id", "purchase_return_master", "pur_ret_master_id = {$parent_key}");
dd_mysql_query("UPDATE voucher_detail SET debit_amount = {$sum} WHERE voucher_id = {$voucher_id} AND debit_amount > 0");
dd_mysql_query("UPDATE voucher_detail SET credit_amount = {$sum} WHERE voucher_id = {$voucher_id} AND credit_amount > 0");
if ($_POST['purchase_return_type'] == 'C') {
$v_cash_acc_id = getValue("code", "sys_codes", "description = 'CASH ACCOUNT'");
$v_ch_pur_acc_id = getValue("code", "sys_codes", "description = 'PURCHASE RETURN'");
dd_mysql_query("UPDATE voucher_detail SET account_code = {$v_cash_acc_id}, remarks = '0' WHERE voucher_id = {$voucher_id} AND debit_amount > 0");
dd_mysql_query("UPDATE voucher_detail SET account_code = {$v_ch_pur_acc_id}, remarks = '1' WHERE voucher_id = {$voucher_id} AND credit_amount > 0");
} else {
$v_cr_pur_acc_id = getValue("code", "sys_codes", "description = 'CREDIT PURCHASE'");
$v_party_acc_code = getValue("account_code", "party", "party_code = {$_POST['purchase_return_party_hidden']}");
dd_mysql_query("UPDATE voucher_detail SET account_code = {$v_cr_pur_acc_id}, remarks = '2-1' WHERE voucher_id = {$voucher_id} AND debit_amount > 0");
dd_mysql_query("UPDATE voucher_detail SET account_code = {$v_party_acc_code}, remarks = '3-1' WHERE voucher_id = {$voucher_id} AND credit_amount > 0");
}
} else {
$sum = getValue("sum(pr_qty * pr_rate) amt", "purchase_return_detail", "pur_ret_master_id = {$parent_key}");
$v_ch_pur_acc_id = getValue("code", "sys_codes", "description = 'PURCHASE RETURN'");
$v_cash_acc_id = getValue("code", "sys_codes", "description = 'CASH ACCOUNT'");
$v_party_acc_code = getValue("account_code", "party", "party_code = {$_POST['purchase_return_party_hidden']}");
require_once '../includes/connecti.php';
if ($_POST['purchase_return_type'] == 'C') {
createVoucher($selected_company_id, $year_id, $v_cash_acc_id, $v_ch_pur_acc_id, $sum, $_POST['purchase_return_remarks'], $parent_key, 'PR', my_sql_date($_POST['purchase_return_date']));
} else {
createVoucher($selected_company_id, $year_id, $v_ch_pur_acc_id, $v_party_acc_code, $sum, $_POST['purchase_return_remarks'], $parent_key, 'PR', my_sql_date($_POST['purchase_return_date']));
}
$mysqli->close();
}
$url = "../transaction/purchase_return.php?purchase_return_id={$parent_key}";
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}, {$sql}";
}
$result = mysql_query($sql) or die("Couldn t execute query." . mysql_error());
$parent_key = -1;
if (strlen($cash_book_id) > 0) {
$parent_key = $cash_book_id;
} else {
$parent_key = mysql_insert_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})");
dd_mysql_query("DELETE FROM voucher_detail WHERE voucher_id = {$voucher_id}");
dd_mysql_query("DELETE FROM voucher_master WHERE voucher_id = {$voucher_id}");
}
$v_cash_acc_id = getValue("code", "sys_codes", "description = 'CASH ACCOUNT'");
$call = "";
if ($cash_book_type == 'R') {
$call = "CALL Create_Voucher({$selected_company_id}, {$year_id}, {$v_cash_acc_id}, {$account_code}, '{$cash_book_ammount}', '{$remarks}', {$parent_key}, 'CR', '" . $cash_book_date . "')";
} else {
$call = "CALL Create_Voucher({$selected_company_id}, {$year_id}, {$account_code}, {$v_cash_acc_id}, '{$cash_book_ammount}', '{$remarks}', {$parent_key}, 'CP', '" . $cash_book_date . "')";
}
$mysqli->query($call);
}
}
}
$mysqli->close();
$url = "../transaction/cash_book.php?cash_date=" . locale_date($cash_book_date);
//echo "<a href='$url'>$url</a><br/>";
if ($_POST['oper'] == 'update') {
$voucher_id = getValue("voucher_id", "sales_master", "sale_master_id = {$_POST['sales_id']}");
dd_mysql_query("UPDATE voucher_detail SET debit_amount = {$sum} WHERE voucher_id = {$voucher_id} AND debit_amount > 0");
dd_mysql_query("UPDATE voucher_detail SET credit_amount = {$sum} WHERE voucher_id = {$voucher_id} AND credit_amount > 0");
if ($_POST['sales_type'] == 'C') {
$v_cash_acc_id = getValue("code", "sys_codes", "description = 'CASH ACCOUNT'");
$v_ch_sal_acc_id = getValue("code", "sys_codes", "description = 'SALES RETURN'");
dd_mysql_query("UPDATE voucher_detail SET account_code = {$v_ch_sal_acc_id}, remarks = '0' WHERE voucher_id = {$voucher_id} AND debit_amount > 0");
dd_mysql_query("UPDATE voucher_detail SET account_code = {$v_cash_acc_id}, remarks = '1' WHERE voucher_id = {$voucher_id} AND credit_amount > 0");
} else {
$v_cr_sal_acc_id = getValue("code", "sys_codes", "description = 'CREDIT SALES'");
$v_party_acc_code = getValue("account_code", "party", "party_code = {$_POST['sales_party_hidden']}");
dd_mysql_query("UPDATE voucher_detail SET account_code = {$v_party_acc_code}, remarks = '2-1' WHERE voucher_id = {$voucher_id} AND debit_amount > 0");
dd_mysql_query("UPDATE voucher_detail SET account_code = {$v_cr_sal_acc_id}, remarks = '3-1' WHERE voucher_id = {$voucher_id} AND credit_amount > 0");
}
dd_mysql_query("UPDATE voucher_master SET voucher_date = '" . my_sql_date($_POST['sales_date']) . "' WHERE voucher_id = {$voucher_id}");
} else {
$v_ch_sale_acc_id = getValue("code", "sys_codes", "description = 'CASH SALES'");
$v_cash_acc_id = getValue("code", "sys_codes", "description = 'CASH ACCOUNT'");
$v_cr_sale_acc_id = getValue("code", "sys_codes", "description = 'CREDIT SALES'");
$v_party_acc_code = getValue("account_code", "party", "party_code = {$_POST['sales_party_hidden']}");
require_once '../includes/connecti.php';
if (isset($_POST['sales_type']) && $_POST['sales_type'] == 'C') {
createVoucher($selected_company_id, $year_id, $v_cash_acc_id, $v_ch_sale_acc_id, $sum, $_POST['sales_remarks'], $parent_key, 'S', my_sql_date($_POST['sales_date']));
} else {
createVoucher($selected_company_id, $year_id, $v_party_acc_code, $v_cr_sale_acc_id, $sum, $_POST['sales_remarks'], $parent_key, 'S', my_sql_date($_POST['sales_date']));
}
$mysqli->close();
}
$url .= "?sales_id={$parent_key}";
}
}
}
$url = "../transaction/voucher.php";
if ($_POST['oper'] == 'delete') {
$sale_id = getValue("sale_master_id", "sales_master", "voucher_id = {$_POST['voucher_id']}");
dd_mysql_query("INSERT INTO voucher_master_aud SELECT * FROM voucher_master WHERE voucher_id = {$_POST['voucher_id']}");
dd_mysql_query("INSERT INTO voucher_detail_aud SELECT * FROM voucher_detail WHERE voucher_id = {$_POST['voucher_id']}");
if ($sale_id != null && strlen($sale_id) > 0) {
dd_mysql_query("INSERT INTO sales_master_aud SELECT *, {$_SESSION['user_id']}, now() FROM sales_master WHERE sale_master_id = {$sale_id}");
dd_mysql_query("INSERT INTO sales_detail_aud SELECT * FROM sales_detail WHERE sale_master_id = {$sale_id}");
}
dd_mysql_query("DELETE FROM voucher_detail WHERE voucher_id = {$_POST['voucher_id']}");
dd_mysql_query("DELETE FROM voucher_master WHERE voucher_id = {$_POST['voucher_id']}");
if ($sale_id != null && strlen($sale_id) > 0) {
dd_mysql_query("DELETE FROM sales_detail WHERE sale_master_id = {$sale_id}");
dd_mysql_query("DELETE FROM sales_master WHERE sale_master_id = {$sale_id}");
}
$data['key'] = $_POST['voucher_id'];
} else {
echo $first_tab_ins . "<br/>";
$result = mysql_query($first_tab_ins) or die("Couldn t execute query." . mysql_error());
$parent_key = -1;
if ($oper == 'update') {
$parent_key = $_POST['voucher_id'];
} else {
if ($oper == 'add') {
$parent_key = mysql_insert_id();
}
}
//echo $parent_key . "<br/>";
$data['key'] = $parent_key;
