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