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 del_user_access()
{
$this->load->model('user_access_model');
$user_id = $this->input->post('id');
$fname = $this->input->post('fname');
$data = $this->user_access_model->delete_user($user_id);
auditrecord("Deleted User " . $fname . "");
echo jcode(array('success' => 1, 'response' => $data));
}
public function save_bank_recon()
{
$this->load->model('bank_recon_model');
$bank_recon_data = $this->input->post('bank');
$err = validates(array($bank_recon_data), array());
if (count($err)) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
$bID = isset($bank_recon_data['bank_id']) ? $bank_recon_data['bank_id'] : '';
$check_id = $this->bank_recon_model->bank_recon_exist($bID);
if ($check_id) {
echo jcode(array('success' => 2));
} else {
$this->bank_recon_model->bank_recon_add($bank_recon_data);
auditrecord("Added New Bank Record");
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 report_tbl()
{
$this->load->model("main_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('main_account' => $this->main_account_model->searc_mainaccount($account_type, $account_code, $account_title)->result());
$html .= $this->load->view('report/main_account_search', $data, true);
$html .= $this->config->item('report_footer');
auditrecord("Generated Chart of Account Summary Report");
pdf_create($html, 'filename');
} else {
redirect('login');
}
}
public function export_sales_detailed()
{
$this->load->model('journal_sj_model');
$this->load->helper('sales_detailed');
$data = $this->journal_sj_model->export_sales_summary();
auditrecord("Export Sales Detailed Report (Excel)");
sales_detailed($data);
}
public function ap_excel_report()
{
$this->load->model('journal_ap_model');
$this->load->helper('ap_excel_report');
$search = $this->input->post('searchAP');
$ap_invoice_no = $this->input->post($search['searchAP_invNo']);
$ap_inv_date_frm = $this->input->post($search['searchAP_date_frm']);
$ap_inv_date_to = $this->input->post($search['searchAP_date_to']);
$data = $this->journal_ap_model->journal_ap_get($ap_invoice_no, $ap_inv_date_frm, $ap_inv_date_to)->result();
// 'accounts_total' => $this->journal_ap_model->journal_ap_get_total($ap_invoice_no,$ap_invoice_date,$ap_master_name,$ap_po_no)->result()
// print_r($this->db->last_query());
auditrecord("Export AP Detailed Report (Excel)");
ap_excel_report($data);
}
public function logout()
{
auditrecord("System Logout");
$this->session->sess_destroy();
redirect(base_url());
}
public function export_summary()
{
$this->load->model('journal_cd_model');
$this->load->helper('check_dis_summary');
$data = $this->journal_cd_model->summary_report_data();
auditrecord("Export Summary Check Disbursement (Excel)");
check_dis_summary($data);
}
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 cr_summary_report()
{
$this->load->model("journal_cr_model");
if ($this->session->userdata('islogged')) {
$cr_or_no = $this->input->get('or');
$cr_or_date_frm = $this->input->get('ordfrm');
$cr_or_date_to = $this->input->get('ordto');
$html = $this->config->item('report_header');
$data = array('accounts' => $this->journal_cr_model->journal_cr_get($cr_or_no, $cr_or_date_frm, $cr_or_date_to)->result(), 'total' => $this->journal_cr_model->journal_cr_get_total($cr_or_no, $cr_or_date_frm, $cr_or_date_to));
$html .= $this->load->view('report/cr_search_report', $data, true);
$html .= $this->config->item('report_footer');
auditrecord("Generated Cash Receipts Summary Report (PDF)");
pdf_create($html, 'filename');
} else {
echo jcode(array('success' => 1));
}
}
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));
}
}
