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