public function search_records()
{
$this->load->model('audit_trail_model');
$a_search = $this->input->post('searchAudit');
$date_frm = $a_search['searchAudit_dateFRM'];
$date_to = $a_search['searchAudit_dateTO'];
$date_frm_format = date_format(new DateTime($date_frm), "Y/m/d");
$date_to_format = date_format(new DateTime($date_to), "Y/m/d");
$data = $this->audit_trail_model->search($a_search['searchAudit_user'], $date_frm_format, $date_to_format);
$html = "";
$err = validates(array($a_search), array());
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td class=''>" . $key->full_name . "</td>\n\t\t\t\t\t\t<td class=''>" . $key->user_type . "</td>\n\t\t\t\t\t\t<td class=''>" . $key->a_action . "</td>\n\t\t\t\t\t\t<td class=''>" . $key->a_date . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t";
}
auditrecord("Searched Records in Audit Trail.");
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
public function load_page()
{
if ($this->session->userdata('islogged')) {
$this->load->view('modules/sales_expense');
} else {
echo jcode(array('success' => 1));
}
}
public function load_all_user()
{
$this->load->model('user_access_model');
$data = $this->user_access_model->show_user_access();
$html = "";
foreach ($data->result() as $key) {
$html .= "\n\t\t\t<tr>\n\t\t\t\t<td>" . $key->fname . "</td>\n\t\t\t\t<td>" . $key->lname . "</td>\n\t\t\t\t<td>" . $key->uname . "</td>\n\t\t\t\t<td>" . $key->pwd . "</td>\n\t\t\t\t<td>" . $key->user_type . "</td>\n\t\t\t\t<td>\n\t\t\t\t\t<span class='action'><a href='#' class='' id='alert' data-toggle='modal' data-target='.userAccess'><i class='fa fa-edit' data-item='" . $key->id . "'></i> Update</a></span> |\n\t\t\t\t\t<span class='action'> <a href='#' class='btn_deluser' data-id='" . $key->id . "' data-id='" . $key->fname . "'><i class='fa fa-trash-o' data-item=''></i> Delete</a></span>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $html));
}
public function load_page()
{
if ($this->session->userdata('islogged')) {
$this->session->set_userdata('page_tab', 'Administrator');
$this->session->set_userdata('page_title', 'Account Settings');
$this->session->set_userdata('current_page', 'account_settings');
$this->load->view('modules/account_settings');
} else {
echo jcode(array('success' => 1));
}
}
public function get_accountgroup()
{
$this->load->model("system_settings_model");
$type = $this->input->post('type');
$data = $this->system_settings_model->account_group_get($type);
$response = "";
foreach ($data->result() as $key) {
$response .= "<option>" . $key->account_groupname . "</option>";
}
echo jcode(array('success' => 1, 'response' => $response));
}
public function load_page()
{
if ($this->session->userdata('islogged')) {
$this->session->set_userdata('page_tab', 'Dashboard');
$this->session->set_userdata('page_title', 'Dashboard');
$this->session->set_userdata('current_page', 'dashboard');
$this->load->view('modules/dashboard');
} else {
echo jcode(array('success' => 1));
}
}
public function login_user()
{
$this->load->model('login_model');
$count = $this->login_model->login_process($this->input->post('username'), $this->input->post('pwd'), $this->input->post('project_id'));
if ($count->num_rows()) {
$data = $this->login_model->login_process($this->input->post('username'), $this->input->post('pwd'), $this->input->post('project_id'))->result_array();
$sessiondata = $this->login_model->session_data($data[0]['project_id'], $data[0]['user_id']);
$this->session->set_userdata($sessiondata);
echo jcode(array('success' => 1));
} else {
echo jcode(array('success' => 2));
}
}
public function ar_summary_report()
{
$this->load->model("accounts_receivable_model");
if ($this->session->userdata('islogged')) {
$ar_customer = $this->input->get('ar');
$html = $this->config->item('report_header');
$data = array('ar' => $this->accounts_receivable_model->summary_ar($ar_customer)->result(), 'ar_tot' => $this->accounts_receivable_model->search_ar_tot($ar_customer)->result());
$html .= $this->load->view('report/ar_summary_report', $data, true);
$html .= $this->config->item('report_footer');
pdf_create($html, 'Accounts-Receivable');
} else {
echo jcode(array('success' => 1));
}
}
public function report()
{
if ($this->session->userdata('islogged')) {
$report_type = $this->input->get('rt');
$html = $this->config->item('report_header');
if ($report_type == 1) {
$viewData = array();
$html .= $this->load->view('report/aging_payables_report', $viewData, true);
} elseif ($report_type == 2) {
$viewData = array();
$html .= $this->load->view('report/aging_receivables_report', $viewData, true);
}
$html .= $this->config->item('report_footer');
pdf_create($html, 'EPS-Accounting-Report');
} else {
echo jcode(array('success' => 1));
}
}
public function save_user_access()
{
$this->load->model("user_access_model");
$user_access_data = $this->input->post('ua');
$err = validates(array($user_access_data), array());
if (count($err)) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
$fname = isset($user_access_data['fname']) ? $user_access_data['fname'] : '';
$check_id = $this->user_access_model->user_exist($fname);
if ($check_id) {
echo jcode(array('success' => 2));
} else {
$id = $this->user_access_model->add_user_access($user_access_data);
$html = "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $user_access_data['fname'] . "</td>\n\t\t\t\t\t\t<td>" . $user_access_data['lname'] . "</td>\n\t\t\t\t\t\t<td>" . $user_access_data['uname'] . "</td>\n\t\t\t\t\t\t<td>" . $user_access_data['pwd'] . "</td>\n\t\t\t\t\t\t<td>" . $user_access_data['user_type'] . "</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<span class='action'><a href='#' class='' id='alert' data-toggle='modal' data-target='.userAccess'><i class='fa fa-edit' data-item='" . $id . "'></i> Update</a></span> |\n\t\t\t\t\t\t <span class='action'><i class='fa fa-trash-o' data-item='" . $id . "'></i> <a href='#' class='' id='alert' data-toggle='modal' data-target='.deleteAccess'>Delete</a></span>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t";
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
public function search_ap()
{
$this->load->model('journal_ap_model');
$account_search = $this->input->post('searchAP');
$data = $this->journal_ap_model->journal_ap_get($account_search['searchAP_invNo'], $account_search['searchAP_date'], $account_search['searchAP_suppName'], $account_search['searchAP_po']);
$html = "";
$err = validates(array($account_search), array());
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $key->ap_invoice_no . "</td>\n\t\t\t\t\t\t<td>" . $key->ap_invoice_date . "</td>\n\t\t\t\t\t\t<td>" . $key->ap_master_name . "</td>\n\t\t\t\t\t\t<td>" . $key->ap_particulars . "</td>\n\t\t\t\t\t\t<td>" . $key->ap_invoice_amount . "</td>\n\t\t\t\t\t\t<td><a href='#' data-id='{$key->ap_id}' class='btn-style-1 animate-4 pull-left account-report-print'><i class='fa fa-print'></i></a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
public function search_accountcode()
{
$this->load->model("main_account_model");
$account_search = $this->input->post('search_account');
$data = $this->main_account_model->main_account_get($account_search['searchaccount_code'], $account_search['searchaccount_title'], $account_search['search_accountgroup']);
$html = "";
$err = validates(array($account_search), array());
if (count($err)) {
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>" . $key->account_type . "</td>\n\t\t\t\t\t\t\t<td>" . $key->account_code . "</td>\n\t\t\t\t\t\t\t<td>" . $key->account_title . "</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
}
public function search_master()
{
$this->load->model("master_account_model");
$account_search = $this->input->post('searchMaster');
$data = $this->master_account_model->master_account_get($account_search['searchMaster_name'], $account_search['searchMaster_type']);
$html = "";
$err = validates(array($account_search), array());
if (count($err)) {
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->master_name . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->master_add . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->master_contact_person . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->master_tel_no . "</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
}
public function search_bank()
{
$this->load->model("bank_recon_model");
$account_search = $this->input->post('searchBank');
$data = $this->bank_recon_model->bank_recon_get($account_search['searchBank_name'], $account_search['searchBank_month'], $account_search['searchBank_year'], $account_search['searchBank_balance']);
$html = "";
$err = validates(array($account_search), array());
if (count($err)) {
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->bank_name . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->bank_month . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->bank_year . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->bank_balance . "</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
}
public function report()
{
$this->load->model('management_model');
if ($this->session->userdata('islogged')) {
$report_type = $this->input->get('rt');
$mgt = $this->input->get('mgt');
$date_from = $this->input->get('fr');
$date_to = $this->input->get('to');
$html = $this->config->item('report_header');
if ($report_type == 1) {
$viewData = array('fs_bank' => $this->management_model->get_fs_bank($date_from, $date_to), 'fs_bank_tot' => $this->management_model->get_fs_bank_tot($date_from, $date_to), 'fs_ar' => $this->management_model->get_fs_ar($date_from, $date_to), 'fs_ar_tot' => $this->management_model->get_fs_ar_tot($date_from, $date_to), 'fs_ap' => $this->management_model->get_fs_ap($date_from, $date_to), 'fs_ap_tot' => $this->management_model->get_fs_ap_tot($date_from, $date_to));
$html .= $this->load->view('report/financial_statement', $viewData, true);
} elseif ($report_type == 2) {
$viewData = array('bs_assets' => $this->management_model->bs_assets_report(), 'bs_nonAssets' => $this->management_model->bs_nonAssets_report(), 'bs_otherAssets' => $this->management_model->bs_otherAssets_report(), 'bs_liabilities' => $this->management_model->bs_liabilities_report(), 'bs_equity' => $this->management_model->bs_equity_report());
$html .= $this->load->view('report/balance_sheet', $viewData, true);
} elseif ($report_type == 3) {
$viewData = array();
$html .= $this->load->view('report/bank_recon', $viewData, true);
} elseif ($report_type == 4) {
$viewData = array();
$html .= $this->load->view('report/cash_position', $viewData, true);
} elseif ($report_type == 5) {
$viewData = array('income_statement' => $this->management_model->income_statement_report());
$html .= $this->load->view('report/income_statement', $viewData, true);
} elseif ($report_type == 6) {
$viewData = array();
$html .= $this->load->view('report/profit_loss', $viewData, true);
} elseif ($report_type == 7) {
$viewData = array('ap_trade' => $this->management_model->get_ap_trade($date_from, $date_to), 'ap_trade_tot' => $this->management_model->get_ap_trade_tot($date_from, $date_to));
$html .= $this->load->view('report/ap_trade_report', $viewData, true);
} elseif ($report_type == 8) {
$viewData = array('ap_Ntrade' => $this->management_model->get_ap_Ntrade($date_from, $date_to), 'ap_Ntrade_tot' => $this->management_model->get_ap_Ntrade_tot($date_from, $date_to));
$html .= $this->load->view('report/ap_nTrade_report', $viewData, true);
} elseif ($report_type == 9) {
$viewData = array('ap_other' => $this->management_model->get_ap_other($date_from, $date_to), 'ap_other_tot' => $this->management_model->get_ap_other_tot($date_from, $date_to));
$html .= $this->load->view('report/ap_others_report', $viewData, true);
} elseif ($report_type == 10) {
$viewData = array();
$html .= $this->load->view('report/ar_trade_report', $viewData, true);
} elseif ($report_type == 11) {
$viewData = array();
$html .= $this->load->view('report/ar_nTrade_report', $viewData, true);
} elseif ($report_type == 12) {
$viewData = array();
$html .= $this->load->view('report/ar_others_report', $viewData, true);
} elseif ($report_type == 13) {
$viewData = array();
$html .= $this->load->view('report/emp_advances_report', $viewData, true);
} elseif ($report_type == 14) {
$viewData = array();
$html .= $this->load->view('report/officer_advances_report', $viewData, true);
} elseif ($report_type == 15) {
$viewData = array();
$html .= $this->load->view('report/cash_flow', $viewData, true);
} elseif ($report_type == 16) {
$viewData = array('expense' => $this->management_model->get_expenses($date_from, $date_to));
$html .= $this->load->view('report/operating_expenses', $viewData, true);
} elseif ($report_type == 17) {
$viewData = array('trial_report' => $this->management_model->trial_balance_report());
$html .= $this->load->view('report/trial_balance', $viewData, true);
} elseif ($report_type == 18) {
$viewData = array();
$html .= $this->load->view('report/taxes_report', $viewData, true);
} elseif ($report_type == 19) {
$viewData = array();
$html .= $this->load->view('report/prepaid_expenses', $viewData, true);
} elseif ($report_type == 20) {
$viewData = array();
$html .= $this->load->view('report/security_deposit', $viewData, true);
} elseif ($report_type == 21) {
$viewData = array();
$html .= $this->load->view('report/prepaid_rent', $viewData, true);
} elseif ($report_type == 22) {
$viewData = array();
$html .= $this->load->view('report/computer_equipment', $viewData, true);
} elseif ($report_type == 23) {
$viewData = array();
$html .= $this->load->view('report/office_furnitures', $viewData, true);
} elseif ($report_type == 24) {
$viewData = array();
$html .= $this->load->view('report/intagible_assets', $viewData, true);
} elseif ($report_type == 25) {
$viewData = array();
$html .= $this->load->view('report/leashold_improvement', $viewData, true);
}
$html .= $this->config->item('report_footer');
pdf_create($html, 'EPS-Accounting-Report');
} else {
echo jcode(array('success' => 1));
}
}
public function search_chartaccount()
{
$this->load->model('site_model');
$chart_search = $this->input->post('chart');
$data = $this->site_model->search_chartaccount($chart_search['account_code'], $chart_search['account_title'], $chart_search['sub_code'], $chart_search['sub_name']);
$html = "";
// echo $this->db->last_query();
$err = validates(array($chart_search), array());
if (count($err)) {
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td><label><input type='checkbox' class='' value='0' id='check' data-subcode='" . $key->sub_code . "' data-subname='" . $key->sub_name . "'><label>\t</td>\n\t\t\t\t\t\t\t<td>" . $key->account_code . "</td>\n\t\t\t\t\t\t\t<td>" . $key->account_title . "</td>\n\t\t\t\t\t\t\t<td>" . $key->sub_code . "</td>\n\t\t\t\t\t\t\t<td>" . $key->sub_name . "</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
}
public function trial_summary_report()
{
$this->load->model("trial_balance_model");
if ($this->session->userdata('islogged')) {
$account_code = $this->input->get('in');
$date_fr = $this->input->get('invd');
$date_to = $this->input->get('mn');
$trans = $this->input->get('trans');
$html = '';
$data = $this->trial_data($trans, $date_fr, $date_to, $account_code);
$trial = array_merge($data);
$html = $this->config->item('report_header');
$viewData = array('trial' => $trial);
$html .= $this->load->view('report/trial_balance', $viewData, true);
$html .= $this->config->item('report_footer');
auditrecord("Generated Trial Balance Report.");
pdf_create($html, 'filename');
} else {
echo jcode(array('success' => 1));
}
}
public function del_acctinfo()
{
$this->load->model('main_account_model');
$account_code = $this->input->post('account_code');
$data = $this->main_account_model->delete_acctinfo($account_code);
auditrecord("Deleted Chart of Account (Acct-code:" . $account_code . ")");
echo jcode(array('success' => 1, 'response' => $data));
}
public function show_sjinfo()
{
$this->load->model('journal_sj_model');
$id = $this->input->post('sj_id');
$data = $this->journal_sj_model->show_sjinfo($id);
// print_r($this->db->last_query());
$html = "";
foreach ($data as $key) {
$html .= "\n\t\t\t<tr>\n\t\t\t\t<td>" . $key->sub_code . "</td>\n\t\t\t\t<td>" . $key->account_name . "</td>\n\t\t\t\t<td><input type='text' class='form-control text-right' value='" . number_format($key->trans_dr, 2) . "'></td>\n\t\t\t\t<td><input type='text' class='form-control text-right' value='" . number_format($key->trans_cr, 2) . "'></td>\n\t\t\t</tr>\n\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $data, 'html' => $html));
}
public function report_tbl()
{
$this->load->model('master_account_model');
if ($this->session->userdata('islogged')) {
$master_name = $this->input->get('mn');
$master_add = $this->input->get('ma');
$master_con_person = $this->input->get('mcp');
$master_con_num = $this->input->get('mcn');
$html = $this->config->item('report_header');
$data = array('master_account' => $this->master_account_model->master_account_get($master_name, $master_add, $master_con_person, $master_con_num)->result());
$html .= $this->load->view('report/master_account_search', $data, true);
$html .= $this->config->item('report_footer');
auditrecord("Generated Master Account Summary Report");
pdf_create($html, 'filename');
} else {
echo jcode(array('success' => 1));
}
}
public function load_acct_group()
{
$this->load->model('system_settings_model');
$data = $this->system_settings_model->account_group_show();
$html = "";
foreach ($data->result() as $key) {
$html .= "\n\t\t\t<tr>\n\t\t\t\t<td>" . $key->account_type . "</td>\n\t\t\t\t<td>" . $key->account_groupname . "</td>\n\t\t\t\t<td><i class='fa fa-trash-o btn-style-2 animate-4 accountgroup-item btn_delgroup' data-item='" . $key->id . "'></i></td>\n\t\t\t</tr>\n\t\t\t";
}
auditrecord("Searched Record in Account Group");
echo jcode(array('success' => 1, 'response' => $html));
}
public function reset_all_accounts()
{
$this->load->model('site_model');
$data = $this->site_model->load_all_accounts();
$html = "";
foreach ($data->result() as $key) {
$html .= "\n\t\t\t<tr>\n\t\t\t\t<td class='col-md-1'><label><input type='checkbox' class='' value='0' id='check' data-subcode='" . $key->sub_code . "' data-subname='" . $key->sub_name . "'><label></td>\n\t\t\t\t<td class='col-md-1'>" . $key->account_code . "</td>\n\t\t\t\t<td class='col-md-3'>" . $key->account_title . "</td>\n\t\t\t\t<td class='col-md-2'>" . $key->sub_code . "</td>\n\t\t\t\t<td class='col-md-4' colspan='2'>" . $key->sub_name . "</td>\n\t\t\t</tr>\n\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $data, 'html' => $html));
}
public function search_list()
{
$this->load->model('general_ledger_model');
if ($this->session->userdata('islogged')) {
$search = $this->input->post('gl-search');
$search_type = $this->input->post('gl-search[journal]');
$subs = $search['sub_account'];
if ($search_type == 1) {
//Search Journal: ALL Journals
$search = $this->input->post('gl-search');
$data = $this->general_ledger_model->search_gl_all($search['main_account'], $search['from_date'], $search['to_date']);
// print_r($this->db->last_query());
// $tot_data = $this->general_ledger_model->sglall_total($search['main_account'],$search['from_date'],$search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->date . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->masterm . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->transcode . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>0</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_amount . "</td>\n\t\t\t\t\t\t\t</tr>";
}
// foreach ($tot_data->result() as $key) {
// $html.="
// <tr>
// <td class=''>TOTAL</td>
// <td></td>
// <td></td>
// <td></td>
// <td class='text-right '>".$key->totdr."</td>
// <td class='text-right '>".$key->totcr."</td>
// </tr>
// ";
// }
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 2) {
//Search Journal: Cash Receipts
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_cash($subs, $search['from_date'], $search['to_date']);
$tot_data = $this->general_ledger_model->sglc_total($subs, $search['from_date'], $search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->date . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->description . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->transcode . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_amount . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>0.00</td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class=''>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->tot_amount . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right '>0.00</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 3) {
// Search Journal: Acconts Payable
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_ap($subs, $search['from_date'], $search['to_date']);
$tot_data = $this->general_ledger_model->sglap_total($subs, $search['from_date'], $search['to_date']);
// print_r($this->db->last_query());
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->invDate . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->mastername . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->transcode . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>0</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_amount . "</td>\n\t\t\t\t\t\t\t\t<td><a href=# class='btn btn-style-1'><i class='fa fa-file-text'></i></a></td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class=''>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right '>0</td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->tot_amount . "</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 4) {
//Search Journal:Check Disbursement
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_cd($subs, $search['from_date'], $search['to_date']);
// print_r($this->db->last_query());
$tot_data = $this->general_ledger_model->sglcd_total($subs, $search['from_date'], $search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->date . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->mastername . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->transcode . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->cr . "</td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class=''>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->totdr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->totcr . "</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 5) {
//Search Journal:Sales Journal
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_sj($subs, $search['from_date'], $search['to_date']);
$tot_data = $this->general_ledger_model->sglsj_total($search['main_account'], $subs, $search['from_date'], $search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->date . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->masterm . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->transcode . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->cr . "</td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class=''>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->totdr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->totcr . "</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 6) {
//Search Journal:General Journal
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_gj($subs, $search['from_date'], $search['to_date']);
$tot_data = $this->general_ledger_model->sglgj_total($search['main_account'], $subs, $search['from_date'], $search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->date . "</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td>" . $key->particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->transcode . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->cr . "</td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class=''>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->totdr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->totcr . "</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
}
} else {
redirect('login');
}
}
public function report_tbl()
{
$this->load->model("bank_recon_model");
if ($this->session->userdata('islogged')) {
$bank_name = $this->input->get('bn');
$bank_month = $this->input->get('bm');
$bank_year = $this->input->get('byr');
$bank_balance = $this->input->get('bal');
$data = array('bank_data' => $this->bank_recon_model->bank_recon_get($bank_name, $bank_month, $bank_year, $bank_balance)->result());
$html = $this->config->item('report_header');
$html .= $this->load->view('report/bankrecon', $data, true);
$html .= $this->config->item('report_footer');
pdf_create($html, 'Bank-Recon');
} else {
echo jcode(array('success' => 1));
}
}
public function summary_report()
{
$this->load->model("general_ledger_model");
if ($this->session->userdata('islogged')) {
$ctr_acct = $this->input->get('ctr');
$sub_acct = $this->input->get('sub');
$from = $this->input->get('fr');
$to = $this->input->get('to');
$html = $this->config->item('report_header');
$data = array('ledger' => $this->general_ledger_model->search_gl_cash($ctr_acct, $sub_acct, $from, $to)->result());
$html .= $this->load->view('report/gl_search_report', $data, true);
$html .= $this->config->item('report_footer');
pdf_create($html, 'filename');
} else {
echo jcode(array('success' => 1));
}
}
public function report_tbl()
{
$this->load->model("subsidiary_account_model");
if ($this->session->userdata('islogged')) {
$account_type = $this->input->get('at');
$account_code = $this->input->get('ac');
$account_title = $this->input->get('atits');
$html = $this->config->item('report_header');
$data = array('account_type' => $this->subsidiary_account_model->search_subsidiarymainaccount($account_type, $account_code, $account_title)->result());
$html .= $this->load->view('report/sub_search_result', $data, true);
$html .= $this->config->item('report_footer');
auditrecord("Generated Subsidiary Summary Report");
pdf_create($html, 'filename');
} else {
echo jcode(array('success' => 1));
}
}
public function update_cd_trans()
{
$this->load->model('journal_cd_model');
$u_cd = $this->input->post('u_cd');
$err = validates(array($u_cd), array());
if (count($err)) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
$this->journal_cd_model->update_cd($u_cd['vdate'], $u_cd['vnum'], $u_cd['payee'], $u_cd['chcknum'], $u_cd['master'], $u_cd['chckamt'], $u_cd['part'], $u_cd['cd_id']);
// print_r($this->db->last_query());
echo jcode(array('success' => 1));
}
}
