ob_start();
$data = array();
dump($_POST);
$account_id = $_POST['account_id'];
$account_name = getIVal("account_name", "chart_of_account", "account_ref_id = {$account_id}", true);
$year_id = getIVal("year_id", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'", true);
$counter = $_POST['counter'] * 1;
for ($i = 1; $i <= $counter; $i++) {
if (strlen($_POST["account_" . $i]) > 0) {
$cr_acc = $_POST["account_" . $i . "_hidden"];
$amt = stripFormat($_POST["amt_" . $i]) * 1;
$remarks = $_POST["account_" . $i] . " " . $_POST["remarks_" . $i];
$cheque = $_POST["cheque_" . $i];
$vdate = my_sql_date($_POST["date_" . $i]);
$first_colval = "voucher_date = '{$vdate}', voucher_remarks = '{$remarks}', voucher_type = 'JV', voucher_cheque = '{$cheque}'";
$seq = getSequenceNextVal('voucher_master', $selected_company_id);
$first_part = "INSERT INTO voucher_master SET company_ref_id = {$selected_company_id}, year_id = {$year_id}, seq = {$seq}, voucher_by = {$_SESSION['user_id']}, ";
$first_tab_ins = $first_part . $first_colval;
echo $first_tab_ins . "<br/>";
$mysqli->query($first_tab_ins);
$parent_key = $mysqli->insert_id;
$sql = " INSERT INTO voucher_detail SET voucher_id = {$parent_key}, account_ref_id = '{$account_id}', debit_amount = '{$amt}', credit_amount = '0', remarks = concat('{$account_name}',' ','{$remarks}')";
echo $sql . "<br/>";
$mysqli->query($sql);
$sql = " INSERT INTO voucher_detail SET voucher_id = {$parent_key}, account_ref_id = '{$cr_acc}', debit_amount = '0', credit_amount = '{$amt}', remarks = concat('{$account_name}',' ','{$remarks}')";
echo $sql . "<br/>";
$mysqli->query($sql);
$voucher_aud_id = di_mysql_query("INSERT INTO voucher_master_aud SELECT NULL, vm.*, 'add', {$_SESSION['user_id']}, now() FROM voucher_master vm WHERE vm.voucher_id = {$parent_key}", true);
di_mysql_query("INSERT INTO voucher_detail_aud SELECT NULL, vd.*, {$voucher_aud_id} FROM voucher_detail vd WHERE vd.voucher_id = {$parent_key}");
}
}
foreach ($_POST as $key => $val) {
if ($key == "voucher_date" || $key == "voucher_remarks" || $key == "voucher_type" || $key == "voucher_cheque") {
if ($key == 'voucher_date') {
$val = my_sql_date($val);
}
$first_colval = $first_colval . $seprator . $key . " = '" . $val . "'";
$seprator = ',';
} else {
if ($key == "voucher_id") {
$last_part = " WHERE voucher_id = " . $val;
}
}
}
$oper = $_POST['oper'];
if ($oper == 'add') {
$data['seq'] = getSequenceNextVal('voucher_master', $_SESSION['company_id']);
$first_part = " INSERT INTO voucher_master SET company_ref_id = {$_SESSION['company_id']}, year_id = {$year_id}, seq = {$data['seq']}, voucher_by = {$_SESSION['user_id']}, ";
$first_tab_ins = $first_part . $first_colval;
} else {
if ($oper == 'update') {
$first_part = " UPDATE voucher_master SET ";
$last_part = " WHERE voucher_id = {$_POST['voucher_id']}";
$first_tab_ins = $first_part . $first_colval . $last_part;
}
}
if ($_POST['oper'] == 'delete') {
$sale_id = getValue("sale_master_id", "sales_master", "voucher_id = {$_POST['voucher_id']}", true);
if ($sale_id != null && strlen($sale_id) > 0) {
d_mysql_query("INSERT INTO sales_master_aud SELECT *, {$_SESSION['user_id']}, now() FROM sales_master WHERE sale_master_id = {$sale_id}");
d_mysql_query("INSERT INTO sales_detail_aud SELECT * FROM sales_detail WHERE sale_master_id = {$sale_id}");
}
$cash_book_ammount = $_POST["inp3_{$i}"] * 1;
$cash_book_type = "R";
} else {
if (isset($_POST["inp4_{$i}"])) {
$cash_book_ammount = $_POST["inp4_{$i}"] * 1;
$cash_book_type = "P";
}
}
if (strlen($account_code) > 0 && $cash_book_ammount > 0) {
$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 = 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();
}
$data['cash_book_id'] = $parent_key;
$dr_acc = -1;
$cr_acc = -1;
if ($cash_book_type == 'R') {
//Recieve
//Debit - Cash Account (Cash in hand)
$val = "No";
}
}
}
$first_colval = $first_colval . $seprator . $key . " = '" . $val . "'";
$seprator = ',';
} else {
if ($key == "sales_id") {
$last_part = " WHERE sale_master_id = " . $val;
}
}
}
}
$oper = $_POST['oper'];
if ($oper == 'add') {
$data['seq'] = getSequenceNextVal('sales_master', $_SESSION['company_id']);
$first_part = " INSERT INTO sales_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 sales_master SET ";
$last_part = " WHERE sale_master_id = {$_POST['sales_id']}";
$first_tab_ins = $first_part . $first_colval . $last_part;
}
}
$url = "../transaction/sales.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['sales_id'];
$val = "No";
}
}
}
$first_colval = $first_colval . $seprator . $key . " = '" . $val . "'";
$seprator = ',';
} else {
if ($key == "purchase_return_id") {
$last_part = " WHERE pur_ret_master_id = " . $val;
}
}
}
}
$oper = $_POST['oper'];
if ($oper == 'add') {
$data['seq'] = getSequenceNextVal('purchase_return_master', $_SESSION['company_id']);
$first_part = " INSERT INTO purchase_return_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 purchase_return_master SET ";
$last_part = " WHERE pur_ret_master_id = {$_POST['purchase_return_id']}";
$first_tab_ins = $first_part . $first_colval . $last_part;
}
}
$url = "../transaction/purchase_return.php";
$parent_key = -1;
if ($oper != 'delete') {
echo $first_tab_ins . "<br/>";
$result = oci_parse($conn, $first_tab_ins) or die("Couldn t execute query." . oci_error());
oci_execute($result);
}
if ($key == "godown_transfer_billno") {
$key = "billno";
}
$first_colval = $first_colval . $seprator . $key . " = '" . $val . "'";
$seprator = ',';
} else {
if ($key == "godown_transfer_id") {
$last_part = " WHERE tr_id = " . $val;
}
}
}
}
$oper = $_POST['oper'];
if ($oper == 'add') {
$data['seq'] = getSequenceNextVal('godown_trans_master', $_SESSION['company_id']);
$first_part = " INSERT INTO godown_trans_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 godown_trans_master SET ";
$last_part = " WHERE tr_id = {$_POST['godown_transfer_id']}";
$first_tab_ins = $first_part . $first_colval . $last_part;
}
}
$url = "../transaction/godown_transfer.php";
$parent_key = -1;
if ($oper != 'delete') {
$result = mysql_query($first_tab_ins) or die("Couldn t execute query." . mysql_error());
if ($_POST['oper'] == 'update') {
$parent_key = $_POST['godown_transfer_id'];
function createVoucher($p_company_id, $p_year_id, $p_d_acc_code, $p_c_acc_code, $p_amount, $p_remarks, $p_mas_id, $p_flag, $p_trans_date, $p_voucher_by)
{
global $mysqli;
$data = array();
$data['company_ref_id'] = $p_company_id;
$data['year_id'] = $p_year_id;
$data['debit_code'] = $p_d_acc_code;
$data['credit_code'] = $p_c_acc_code;
$data['amount'] = $p_amount;
$data['remarks'] = $p_remarks;
$data['master_id'] = $p_mas_id;
$data['flag'] = $p_flag;
$data['trans_date'] = $p_trans_date;
$data['voucher_by'] = $p_voucher_by;
$data['sqls'] = array();
$mysqli->autocommit(FALSE);
$v_voucher_type = "";
if ($p_flag == 'S') {
//Sales
$v_voucher_type = 'SV';
//Sales Voucher
} else {
if ($p_flag == 'P') {
//Purchase
$v_voucher_type = 'PV';
//Purchase Voucher
} else {
if ($p_flag == 'SR') {
//Sales Return
$v_voucher_type = 'SR';
//Sales Return Voucher
} else {
if ($p_flag == 'PR') {
//Purchase Return
$v_voucher_type = 'PR';
//Purchase Return Voucher
} else {
if ($p_flag == 'CR') {
//Cash Recieve
$v_voucher_type = 'CR';
//Cash Recieve Voucher
} else {
if ($p_flag == 'CP') {
//Cash Payment
$v_voucher_type = 'CP';
//Cash Payment Voucher
} else {
if ($p_flag == 'PI') {
//Purchase Import
$v_voucher_type = 'PV';
//Purchase Voucher
} else {
if ($p_flag == 'CQ') {
//Cheque Post
$v_voucher_type = 'BV';
//Bank Voucher
} else {
if ($p_flag == 'CO') {
//Account Closing
$v_voucher_type = 'CO';
//Account Closing
}
}
}
}
}
}
}
}
}
/* Insert into Voucher Master */
$data['seq'] = getSequenceNextVal('voucher_master', $_SESSION['company_id']);
$sql = "INSERT INTO voucher_master(voucher_date, voucher_type, voucher_remarks, year_id, company_ref_id, voucher_by, seq) " . "VALUES ('{$p_trans_date}', '{$v_voucher_type}' ,'{$p_remarks}', {$p_year_id}, {$p_company_id}, {$p_voucher_by}, {$data['seq']})";
$data['sqls']['voucher_master'] = $sql;
$mysqli->query($sql);
$v_vou_mas_id = $mysqli->insert_id;
/* Insert into Voucher Detail */
$data['sqls']['voucher_detail'] = array();
/* Debit Entry */
$sql = "INSERT INTO voucher_detail(voucher_id, account_ref_id, debit_amount, credit_amount, remarks) " . "VALUES ({$v_vou_mas_id}, {$p_d_acc_code}, {$p_amount}, 0, 'Debit')";
$data['sqls']['voucher_detail']['debit'] = $sql;
$mysqli->query($sql);
/* Insert Discount entry as well */
$p_dis_acc_code = "";
if ($p_flag == 'S') {
//Sales
$p_dis_acc_code = getIVal("code", "sys_codes", "description = 'Sales Discount' AND company_ref_id = {$p_company_id}");
} else {
if ($p_flag == 'P') {
//Purchase
$p_dis_acc_code = getIVal("code", "sys_codes", "description = 'Purchase Discount' AND company_ref_id = {$p_company_id}");
}
}
if (strlen($p_dis_acc_code) > 0) {
//if no discount account code define, don't give any discount
$sql = "INSERT INTO voucher_detail(voucher_id, account_ref_id, debit_amount, credit_amount, remarks) " . "VALUES ({$v_vou_mas_id}, {$p_dis_acc_code}, 0, 0, 'Discount')";
$data['sqls']['voucher_detail']['debit_discount'] = $sql;
$mysqli->query($sql);
}
/* Credit Entry */
$sql = "INSERT INTO voucher_detail(voucher_id, account_ref_id, debit_amount, credit_amount, remarks) " . "VALUES ({$v_vou_mas_id}, {$p_c_acc_code}, 0, {$p_amount}, 'Credit')";
$data['sqls']['voucher_detail']['credit'] = $sql;
$mysqli->query($sql);
$sql = "SELECT 1";
/* Create Refrence */
if ($p_flag == 'S') {
$sql = "UPDATE sales_master SET voucher_id = {$v_vou_mas_id} WHERE sale_master_id = {$p_mas_id}";
} else {
if ($p_flag == 'P') {
$sql = "UPDATE purchase_master SET voucher_id = {$v_vou_mas_id} WHERE p_id = {$p_mas_id}";
} else {
if ($p_flag == 'SR') {
$sql = "UPDATE sales_return_master SET voucher_id = {$v_vou_mas_id} WHERE rsale_master_id = {$p_mas_id}";
} else {
if ($p_flag == 'PR') {
$sql = "UPDATE purchase_return_master SET voucher_id = {$v_vou_mas_id} WHERE pur_ret_master_id = {$p_mas_id}";
} else {
if ($p_flag == 'CR') {
$sql = "UPDATE cash_book SET voucher_id = {$v_vou_mas_id} WHERE cb_id = {$p_mas_id}";
} else {
if ($p_flag == 'CP') {
$sql = "UPDATE cash_book SET voucher_id = {$v_vou_mas_id} WHERE cb_id = {$p_mas_id}";
} else {
if ($p_flag == 'PI') {
$sql = "UPDATE purchase_import_exp SET voucher_id = {$v_vou_mas_id} WHERE pi_id = {$p_mas_id}";
} else {
if ($p_flag == 'CQ') {
$sql = "UPDATE cheque_post SET voucher_id = {$v_vou_mas_id} WHERE cheque_post_id = {$p_mas_id}";
}
}
}
}
}
}
}
}
$data['sqls']['reference'] = $sql;
$mysqli->query($sql);
$mysqli->commit();
$mysqli->autocommit(TRUE);
return $data;
}
}
if ($key == "delivery_remarks") {
$key = "remarks";
}
$first_colval = $first_colval . $seprator . $key . " = '" . $val . "'";
$seprator = ',';
} else {
if ($key == "delivery_id") {
$last_part = " WHERE delivery_master_id = " . $val;
}
}
}
}
$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'];
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
include '../includes/JSON.php';
session_start();
$conn = oci_connect($db_user, $db_pass, $db_host);
ob_start();
dump($_GET);
$oper = "add";
$year_id = getIVal("year_id", "sys_financial_year", "company_ref_id = 3 AND is_active = 'Yes'", true);
$data = array();
$data['purchase_id'] = getIVal("p_id", "purchase_master", "sale_master_id = {$_GET['sales_master_id']}", true);
if ($data['purchase_id'] != null) {
$oper = "update";
}
if ($oper == 'add') {
$data['seq'] = getSequenceNextVal('purchase_master', 3);
$sql = "" . "INSERT INTO purchase_master(shipping_date,party_code,godown_code,p_remarks,receive_date,year_id,purchase_import,company_ref_id,seq,sale_master_id,is_cash,billno)\n" . "SELECT sm.sale_date, 634, 3, 'Purchased from MERAJ', sm.sale_date, {$year_id}, 'No', 3, {$data['seq']}, {$_GET['sales_master_id']}, sm.is_cash, billno FROM sales_master sm WHERE sm.sale_master_id = {$_GET['sales_master_id']}";
$mysqli->query($sql);
$data['purchase_id'] = $mysqli->insert_id;
$sql = "" . "INSERT INTO purchase_detail(i_code,ship_quantity,ship_rate,p_id,cost_rate)\n" . "SELECT (SELECT im.i_code FROM item_master im WHERE im.cno = (SELECT i.cno FROM item_master i WHERE i.i_code = sd.i_code AND i.company_ref_id = 1) AND im.company_ref_id = 3), sd.sales_qty, sd.sales_rate, {$data['purchase_id']}, 0 FROM sales_detail sd WHERE sd.sale_master_id = {$_GET['sales_master_id']}";
$mysqli->query($sql);
$ship_date = getIVal("shipping_date", "purchase_master", "p_id = {$data['purchase_id']}", true);
$purchase = getIVal("sum(ship_quantity * ship_rate) amt", "purchase_detail", "p_id = {$data['purchase_id']}", true);
$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);
