public function index() { if ($this->session->userdata('logged_in')) { //Cek User Login Branch $user_branch = $this->session->userdata('user_branch'); $branch = $this->branch_model->get_all()->result(); $date_start = $this->input->post('date_start'); $date_end = $this->input->post('date_end'); if (!$date_start and !$date_end) { $date = date("Y-m-d"); $date_day = date('l', strtotime($date)); if ($date_day == "Monday") { function week_range($date) { $ts = strtotime($date); $start = strtotime("-7 day", $ts); //$start = date('Y-m-d', $start); echo $start; return array(date('Y-m-d', $start), date('Y-m-d', strtotime('next saturday', $start))); } list($date_start, $date_end) = week_range($date); } else { function week_range($date) { $ts = strtotime($date); $start = date('w', $ts) == 0 ? $ts : strtotime('last monday', $ts); return array(date('Y-m-d', $start), date('Y-m-d', strtotime('next saturday', $start))); } list($date_start, $date_end) = week_range($date); } } //Build $this->template->set('menu_title', 'Presence Report')->set('menu_report', 'active')->set('branch', $branch)->set('date_start', $date_start)->set('date_end', $date_end)->build('presence/presence'); } else { redirect('login', 'refresh'); } }
public function tsdaily_apel() { if ($this->session->userdata('logged_in')) { $user_branch = $this->session->userdata('user_branch'); $total_rows = $this->tsdaily_model->count_all($this->input->get('q'), $user_branch); //pagination $config['base_url'] = site_url($this->module . '/tsdaily'); $config['total_rows'] = $total_rows; $config['per_page'] = 15; $config['uri_segment'] = 3; $config['suffix'] = '?' . http_build_query($_GET, '', "&"); $config['first_url'] = $config['base_url'] . $config['suffix']; $config['num_links'] = 2; $config['full_tag_open'] = '<li>'; $config['full_tag_close'] = '</li>'; $config['cur_tag_open'] = '<li><a href="#"><b>'; $config['cur_tag_close'] = '</b></a></li>'; $config['num_tag_open'] = '<li>'; $config['num_tag_close'] = '</li>'; $config['first_tag_open'] = '<li>'; $config['first_tag_close'] = '</li>'; $config['last_tag_open'] = '<li>'; $config['last_tag_close'] = '</li>'; $config['next_tag_open'] = '<li>'; $config['next_tag_close'] = '</li>'; $config['prev_tag_open'] = '<li>'; $config['prev_tag_close'] = '</li>'; //$this->pagination->initialize($config); $no = $this->uri->segment(3); if ($user_branch == 0) { $user_branch = ""; } //FILTER DATE $date_start = $this->input->post('date_start'); $date_end = $this->input->post('date_end'); if ($date_start and $date_end) { $date_start = $this->input->post('date_start'); $date_end = $this->input->post('date_end'); } else { $date = date("Y-m-d"); $date_day = date('l', strtotime($date)); if ($date_day == "Monday") { function week_range($date) { $ts = strtotime($date); $start = strtotime("-7 day", $ts); //$start = date('Y-m-d', $start); echo $start; return array(date('Y-m-d', $start), date('Y-m-d', strtotime('next saturday', $start))); } list($date_start, $date_end) = week_range($date); } else { function week_range($date) { $ts = strtotime($date); $start = date('w', $ts) == 0 ? $ts : strtotime('last monday', $ts); return array(date('Y-m-d', $start), date('Y-m-d', strtotime('next saturday', $start))); } list($date_start, $date_end) = week_range($date); } } $tsdaily = $this->tsdaily_model->get_all_by_week($user_branch, $date_start, $date_end); $this->template->set('menu_title', 'Rekap Topsheet')->set('menu_transaksi', 'active')->set('group_total', $config['total_rows'])->set('tsdaily', $tsdaily)->set('no', $no)->build('tsdaily_apel'); } else { //If no session, redirect to login page redirect('login', 'refresh'); } }
public function tsdaily_apel_download() { if ($this->session->userdata('logged_in')) { $user_branch = $this->session->userdata('user_branch'); $total_rows = $this->tsdaily_model->count_all($this->input->get('q'), $user_branch); $branch_name = str_replace(' ', '', $this->session->userdata('user_branch_name')); $no = $this->uri->segment(3); if ($user_branch == 0) { $user_branch = ""; } //FILTER DATE $date_start = $this->uri->segment(3); $date_end = $this->uri->segment(4); if ($date_start and $date_end) { $date_start = $this->uri->segment(3); $date_end = $this->uri->segment(4); } else { $date = date("Y-m-d"); $date_day = date('l', strtotime($date)); if ($date_day == "Monday") { function week_range($date) { $ts = strtotime($date); $start = strtotime("-7 day", $ts); //$start = date('Y-m-d', $start); echo $start; return array(date('Y-m-d', $start), date('Y-m-d', strtotime('next saturday', $start))); } list($date_start, $date_end) = week_range($date); } else { function week_range($date) { $ts = strtotime($date); $start = date('w', $ts) == 0 ? $ts : strtotime('last monday', $ts); return array(date('Y-m-d', $start), date('Y-m-d', strtotime('next saturday', $start))); } list($date_start, $date_end) = week_range($date); } } $tsdaily = $this->tsdaily_model->get_all_by_week($user_branch, $date_start, $date_end); //load our new PHPExcel library $this->load->library('excel'); $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setCreator("Amartha MIS"); $objPHPExcel->getProperties()->setLastModifiedBy("Amartha MIS"); $objPHPExcel->getProperties()->setTitle("Rekap Topsheet"); $objPHPExcel->getProperties()->setSubject("Rekap Topsheet"); $objPHPExcel->getProperties()->setDescription("Rekap Topsheet"); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->setTitle('Rekap Topsheet'); //TITLE $objPHPExcel->getActiveSheet()->setCellValue("A1", "Amartha Microfinance"); $objPHPExcel->getActiveSheet()->setCellValue("A2", "Cabang {$branch_name}"); $objPHPExcel->getActiveSheet()->mergeCells("A1:O1"); $objPHPExcel->getActiveSheet()->mergeCells("A2:O2"); $objPHPExcel->getActiveSheet()->getStyle("A1")->applyFromArray(array("font" => array("bold" => true, 'size' => 16))); $objPHPExcel->getActiveSheet()->getStyle("A2")->applyFromArray(array("font" => array("bold" => true))); //TOP ROW $objPHPExcel->getActiveSheet()->getStyle("A4:O5")->applyFromArray(array("font" => array("bold" => true))); $objPHPExcel->getActiveSheet()->getStyle("C4:J5")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->setCellValue("A4", "NO"); $objPHPExcel->getActiveSheet()->getColumnDimension("A")->setWidth(4); $objPHPExcel->getActiveSheet()->mergeCells("A4:A5"); $objPHPExcel->getActiveSheet()->setCellValue("B4", "MAJELIS"); $objPHPExcel->getActiveSheet()->getColumnDimension("B")->setWidth(15); $objPHPExcel->getActiveSheet()->mergeCells("B4:B5"); $objPHPExcel->getActiveSheet()->setCellValue("C4", "ANGSURAN POKOK"); $objPHPExcel->getActiveSheet()->getColumnDimension("C")->setWidth(15); $objPHPExcel->getActiveSheet()->mergeCells("C4:C5"); $objPHPExcel->getActiveSheet()->setCellValue("D4", "ANGSURAN PROFIT"); $objPHPExcel->getActiveSheet()->getColumnDimension("D")->setWidth(15); $objPHPExcel->getActiveSheet()->mergeCells("D4:D5"); $objPHPExcel->getActiveSheet()->setCellValue("E4", "TABUNGAN WAJIB"); $objPHPExcel->getActiveSheet()->getColumnDimension("E")->setWidth(15); $objPHPExcel->getActiveSheet()->mergeCells("E4:E5"); $objPHPExcel->getActiveSheet()->setCellValue("F4", "TABUNGAN SUKARELA"); $objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(15); $objPHPExcel->getActiveSheet()->mergeCells("F4:G4"); $objPHPExcel->getActiveSheet()->setCellValue("F5", "KREDIT"); $objPHPExcel->getActiveSheet()->setCellValue("G5", "DEBET"); $objPHPExcel->getActiveSheet()->setCellValue("H4", "TOTAL RF"); $objPHPExcel->getActiveSheet()->getColumnDimension("H")->setWidth(15); $objPHPExcel->getActiveSheet()->mergeCells("H4:H5"); $objPHPExcel->getActiveSheet()->setCellValue("I4", "TOTAL TABUNGAN"); $objPHPExcel->getActiveSheet()->getColumnDimension("I")->setWidth(15); $objPHPExcel->getActiveSheet()->mergeCells("I4:I5"); $objPHPExcel->getActiveSheet()->setCellValue("J4", "GRAND TOTAL"); $objPHPExcel->getActiveSheet()->getColumnDimension("J")->setWidth(15); $objPHPExcel->getActiveSheet()->mergeCells("J4:J5"); $objPHPExcel->getActiveSheet()->setCellValue("K4", "ABSENSI"); $objPHPExcel->getActiveSheet()->getColumnDimension("K")->setWidth(4); $objPHPExcel->getActiveSheet()->getColumnDimension("L")->setWidth(4); $objPHPExcel->getActiveSheet()->getColumnDimension("M")->setWidth(4); $objPHPExcel->getActiveSheet()->getColumnDimension("N")->setWidth(4); $objPHPExcel->getActiveSheet()->getColumnDimension("O")->setWidth(4); $objPHPExcel->getActiveSheet()->mergeCells("K4:O4"); $objPHPExcel->getActiveSheet()->setCellValue("K5", "H"); $objPHPExcel->getActiveSheet()->setCellValue("L5", "S"); $objPHPExcel->getActiveSheet()->setCellValue("M5", "C"); $objPHPExcel->getActiveSheet()->setCellValue("N5", "I"); $objPHPExcel->getActiveSheet()->setCellValue("O5", "A"); $objPHPExcel->getActiveSheet()->getStyle('A4:O5')->getAlignment()->setWrapText(true); $objPHPExcel->getActiveSheet()->getStyle("K4:O5")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $no = 1; $cell_no = 6; foreach ($tsdaily as $c) { $tgl_start = $c->tsdaily_date; if ($tgl_start != $tgl_end and $no == 1) { $objPHPExcel->getActiveSheet()->mergeCells("B{$cell_no}:O{$cell_no}"); $header_day = $this->namahari($c->tsdaily_date); $header = $header_day . ", " . date('d-M-Y', strtotime($c->tsdaily_date)); $objPHPExcel->getActiveSheet()->setCellValue("B{$cell_no}", $header); $objPHPExcel->getActiveSheet()->getStyle("B{$cell_no}")->applyFromArray(array("font" => array("bold" => true))); $cell_no++; } elseif ($tgl_start != $tgl_end and $no != 1) { $objPHPExcel->getActiveSheet()->setCellValue("B{$cell_no}", ""); $objPHPExcel->getActiveSheet()->setCellValue("C{$cell_no}", $total_angsuranpokok); $objPHPExcel->getActiveSheet()->setCellValue("D{$cell_no}", $total_profit); $objPHPExcel->getActiveSheet()->setCellValue("E{$cell_no}", $total_tabwajib); $objPHPExcel->getActiveSheet()->setCellValue("F{$cell_no}", $total_tabungan_debet); $objPHPExcel->getActiveSheet()->setCellValue("G{$cell_no}", $total_tabungan_credit); $objPHPExcel->getActiveSheet()->setCellValue("H{$cell_no}", $total_total_rf); $objPHPExcel->getActiveSheet()->setCellValue("I{$cell_no}", $total_total_tabungan); $objPHPExcel->getActiveSheet()->setCellValue("J{$cell_no}", $total_total_tabungan + $total_total_rf); $objPHPExcel->getActiveSheet()->setCellValue("K{$cell_no}", $total_absen_h); $objPHPExcel->getActiveSheet()->setCellValue("L{$cell_no}", $total_absen_s); $objPHPExcel->getActiveSheet()->setCellValue("M{$cell_no}", $total_absen_c); $objPHPExcel->getActiveSheet()->setCellValue("N{$cell_no}", $total_absen_i); $objPHPExcel->getActiveSheet()->setCellValue("O{$cell_no}", $total_absen_a); $objPHPExcel->getActiveSheet()->getStyle("B{$cell_no}:O{$cell_no}")->applyFromArray(array("font" => array("bold" => true))); $objPHPExcel->getActiveSheet()->getStyle("C{$cell_no}:J{$cell_no}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle("K{$cell_no}:O{$cell_no}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $cell_no++; $objPHPExcel->getActiveSheet()->mergeCells("B{$cell_no}:O{$cell_no}"); $header_day = $this->namahari($c->tsdaily_date); $header = $header_day . ", " . date('d-M-Y', strtotime($c->tsdaily_date)); $objPHPExcel->getActiveSheet()->setCellValue("B{$cell_no}", $header); $objPHPExcel->getActiveSheet()->getStyle("B{$cell_no}")->applyFromArray(array("font" => array("bold" => true))); $cell_no++; $total_angsuranpokok = 0; $total_profit = 0; $total_tabwajib = 0; $total_tabungan_debet = 0; $total_tabungan_credit = 0; $total_total_rf = 0; $total_total_tabungan = 0; $total_absen_h = 0; $total_absen_s = 0; $total_absen_c = 0; $total_absen_i = 0; $total_absen_a = 0; } $total_angsuranpokok += $c->tsdaily_angsuranpokok; $total_profit += $c->tsdaily_profit; $total_tabwajib += $c->tsdaily_tabwajib; $total_tabungan_debet += $c->tsdaily_tabungan_debet; $total_tabungan_credit += $c->tsdaily_tabungan_credit; $total_total_rf += $c->tsdaily_total_rf; $total_total_tabungan += $c->tsdaily_total_tabungan; $total_absen_h += $c->tsdaily_absen_h; $total_absen_s += $c->tsdaily_absen_s; $total_absen_c += $c->tsdaily_absen_c; $total_absen_i += $c->tsdaily_absen_i; $total_absen_a += $c->tsdaily_absen_a; $objPHPExcel->getActiveSheet()->setCellValue("A{$cell_no}", $no); $objPHPExcel->getActiveSheet()->setCellValue("B{$cell_no}", $c->tsdaily_group); $objPHPExcel->getActiveSheet()->setCellValue("C{$cell_no}", $c->tsdaily_angsuranpokok); $objPHPExcel->getActiveSheet()->setCellValue("D{$cell_no}", $c->tsdaily_profit); $objPHPExcel->getActiveSheet()->setCellValue("E{$cell_no}", $c->tsdaily_tabwajib); $objPHPExcel->getActiveSheet()->setCellValue("F{$cell_no}", $c->tsdaily_tabungan_debet); $objPHPExcel->getActiveSheet()->setCellValue("G{$cell_no}", $c->tsdaily_tabungan_credit); $objPHPExcel->getActiveSheet()->setCellValue("H{$cell_no}", $c->tsdaily_total_rf); $objPHPExcel->getActiveSheet()->setCellValue("I{$cell_no}", $c->tsdaily_total_tabungan); $objPHPExcel->getActiveSheet()->setCellValue("J{$cell_no}", $c->tsdaily_total_tabungan + $c->tsdaily_total_rf); $objPHPExcel->getActiveSheet()->setCellValue("K{$cell_no}", $c->tsdaily_absen_h); $objPHPExcel->getActiveSheet()->setCellValue("L{$cell_no}", $c->tsdaily_absen_s); $objPHPExcel->getActiveSheet()->setCellValue("M{$cell_no}", $c->tsdaily_absen_c); $objPHPExcel->getActiveSheet()->setCellValue("N{$cell_no}", $c->tsdaily_absen_i); $objPHPExcel->getActiveSheet()->setCellValue("O{$cell_no}", $c->tsdaily_absen_a); $objPHPExcel->getActiveSheet()->getStyle("C{$cell_no}:J{$cell_no}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle("K{$cell_no}:O{$cell_no}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $cell_no++; $tgl_end = $c->tsdaily_date; $no++; } $objPHPExcel->getActiveSheet()->setCellValue("B{$cell_no}", ""); $objPHPExcel->getActiveSheet()->setCellValue("C{$cell_no}", $total_angsuranpokok); $objPHPExcel->getActiveSheet()->setCellValue("D{$cell_no}", $total_profit); $objPHPExcel->getActiveSheet()->setCellValue("E{$cell_no}", $total_tabwajib); $objPHPExcel->getActiveSheet()->setCellValue("F{$cell_no}", $total_tabungan_debet); $objPHPExcel->getActiveSheet()->setCellValue("G{$cell_no}", $total_tabungan_credit); $objPHPExcel->getActiveSheet()->setCellValue("H{$cell_no}", $total_total_rf); $objPHPExcel->getActiveSheet()->setCellValue("I{$cell_no}", $total_total_tabungan); $objPHPExcel->getActiveSheet()->setCellValue("J{$cell_no}", $total_total_tabungan + $total_total_rf); $objPHPExcel->getActiveSheet()->setCellValue("K{$cell_no}", $total_absen_h); $objPHPExcel->getActiveSheet()->setCellValue("L{$cell_no}", $total_absen_s); $objPHPExcel->getActiveSheet()->setCellValue("M{$cell_no}", $total_absen_c); $objPHPExcel->getActiveSheet()->setCellValue("N{$cell_no}", $total_absen_i); $objPHPExcel->getActiveSheet()->setCellValue("O{$cell_no}", $total_absen_a); $objPHPExcel->getActiveSheet()->getStyle("B{$cell_no}:O{$cell_no}")->applyFromArray(array("font" => array("bold" => true))); $objPHPExcel->getActiveSheet()->getStyle("C{$cell_no}:J{$cell_no}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle("K{$cell_no}:O{$cell_no}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $cell_no++; //Set Column Format Accounting $objPHPExcel->getActiveSheet()->getStyle("C7:J{$cell_no}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_ACCOUNTING); //Set Column Auto Width foreach (range('B', 'J') as $columnID) { $objPHPExcel->getActiveSheet()->getColumnDimension($columnID)->setAutoSize(true); } //EXPORT $filename = "Rekap_Topsheet_" . $branch_name . "_" . time() . '.xls'; //save our workbook as this file name header('Content-Type: application/vnd.ms-excel'); //mime type header('Content-Disposition: attachment;filename="' . $filename . '"'); //tell browser what's the file name header('Cache-Control: max-age=0'); //no cache $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); redirect('accounting/neraca', 'refresh'); } else { //If no session, redirect to login page redirect('login', 'refresh'); } }
<th>Pendamping</th> <th>Jam</th> <th><i class='fa fa-check '></i></th> <th><i class='fa fa-bookmark-o '></i></th> </tr> </thead> <tbody> <?php $date = date("Y-m-d"); function week_range($date) { $ts = strtotime($date); $start = date('w', $ts) == 0 ? $ts : strtotime('last sunday', $ts); return array(date('Y-m-d', $start), date('Y-m-d', strtotime('next saturday', $start))); } list($date_start, $date_end) = week_range($date); ?> <?php $no = 1; $tsdownload = 1; foreach ($group_senin as $c) { ?> <?php $check = $this->tsdaily_model->check_entry_topsheet($c->group_id, $date_start, $date_end); ?> <tr> <td align="center"><?php echo $no; ?> </td> <td><?php
public function tsdaily_report_download() { if ($this->session->userdata('logged_in')) { $user_branch = $this->session->userdata('user_branch'); $branch_name = str_replace(' ', '', $this->session->userdata('user_branch_name')); //FILTER DATE $date_start = $this->input->post('date_start'); $date_end = $this->input->post('date_end'); if ($date_start and $date_end) { $date_start = $this->input->post('date_start'); $date_end = $this->input->post('date_end'); } else { $date = date("Y-m-d"); $date_day = date('l', strtotime($date)); if ($date_day == "Monday") { function week_range($date) { $ts = strtotime($date); $start = strtotime("-7 day", $ts); //$start = date('Y-m-d', $start); echo $start; return array(date('Y-m-d', $start), date('Y-m-d', strtotime('next saturday', $start))); } list($date_start, $date_end) = week_range($date); } else { function week_range($date) { $ts = strtotime($date); $start = date('w', $ts) == 0 ? $ts : strtotime('last monday', $ts); return array(date('Y-m-d', $start), date('Y-m-d', strtotime('next saturday', $start))); } list($date_start, $date_end) = week_range($date); } } if ($user_branch == 0) { $user_branch = ""; } $tsdaily = $this->tsdaily_model->get_all_daily_report_by_date($user_branch, $date_start, $date_end); //load our new PHPExcel library $this->load->library('excel'); $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setCreator("Amartha MIS"); $objPHPExcel->getProperties()->setLastModifiedBy("Amartha MIS"); $objPHPExcel->getProperties()->setTitle("Rekap Harian"); $objPHPExcel->getProperties()->setSubject("Rekap Harian"); $objPHPExcel->getProperties()->setDescription("Rekap Harian"); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->setTitle('Rekap Harian'); //TITLE $objPHPExcel->getActiveSheet()->setCellValue("A1", "Amartha Microfinance"); $objPHPExcel->getActiveSheet()->setCellValue("A2", "Cabang {$branch_name}"); $objPHPExcel->getActiveSheet()->mergeCells("A1:O1"); $objPHPExcel->getActiveSheet()->mergeCells("A2:O2"); $objPHPExcel->getActiveSheet()->getStyle("A1")->applyFromArray(array("font" => array("bold" => true, 'size' => 16))); $objPHPExcel->getActiveSheet()->getStyle("A2")->applyFromArray(array("font" => array("bold" => true))); //TOP ROW $objPHPExcel->getActiveSheet()->getStyle("A4:Q5")->applyFromArray(array("font" => array("bold" => true))); $objPHPExcel->getActiveSheet()->getStyle("E4:O5")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); $objPHPExcel->getActiveSheet()->getStyle("A4:D5")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->setCellValue("A4", "NO"); $objPHPExcel->getActiveSheet()->getColumnDimension("A")->setWidth(4); $objPHPExcel->getActiveSheet()->mergeCells("A4:A5"); $objPHPExcel->getActiveSheet()->setCellValue("B4", "TS CODE"); $objPHPExcel->getActiveSheet()->getColumnDimension("B")->setWidth(20); $objPHPExcel->getActiveSheet()->mergeCells("B4:B5"); $objPHPExcel->getActiveSheet()->setCellValue("C4", "TANGGAL"); $objPHPExcel->getActiveSheet()->getColumnDimension("C")->setWidth(20); $objPHPExcel->getActiveSheet()->mergeCells("C4:C5"); $objPHPExcel->getActiveSheet()->setCellValue("D4", "HARI"); $objPHPExcel->getActiveSheet()->getColumnDimension("D")->setWidth(20); $objPHPExcel->getActiveSheet()->mergeCells("D4:D5"); $objPHPExcel->getActiveSheet()->setCellValue("E4", "ANGSURAN POKOK"); $objPHPExcel->getActiveSheet()->getColumnDimension("E")->setWidth(22); $objPHPExcel->getActiveSheet()->mergeCells("E4:E5"); $objPHPExcel->getActiveSheet()->setCellValue("F4", "PROFIT"); $objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(20); $objPHPExcel->getActiveSheet()->mergeCells("F4:F5"); $objPHPExcel->getActiveSheet()->setCellValue("G4", "TAB WAJIB"); $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(15); $objPHPExcel->getActiveSheet()->setCellValue("H4", "TAB SUKARELA"); $objPHPExcel->getActiveSheet()->mergeCells("H4:I4"); $objPHPExcel->getActiveSheet()->setCellValue("H5", "DEBET"); $objPHPExcel->getActiveSheet()->getColumnDimension("H")->setWidth(15); $objPHPExcel->getActiveSheet()->setCellValue("I5", "KREDIT"); $objPHPExcel->getActiveSheet()->getColumnDimension("I")->setWidth(15); $objPHPExcel->getActiveSheet()->setCellValue("J4", "TAB BERJANGKA"); $objPHPExcel->getActiveSheet()->mergeCells("J4:K4"); $objPHPExcel->getActiveSheet()->setCellValue("J5", "DEBET"); $objPHPExcel->getActiveSheet()->getColumnDimension("J")->setWidth(15); $objPHPExcel->getActiveSheet()->setCellValue("K5", "KREDIT"); $objPHPExcel->getActiveSheet()->getColumnDimension("K")->setWidth(15); $objPHPExcel->getActiveSheet()->setCellValue("L4", "TOTAL RF"); $objPHPExcel->getActiveSheet()->getColumnDimension("L")->setWidth(15); $objPHPExcel->getActiveSheet()->mergeCells("L4:L5"); $objPHPExcel->getActiveSheet()->setCellValue("M4", "TOTAL TABUNGAN"); $objPHPExcel->getActiveSheet()->getColumnDimension("M")->setWidth(17); $objPHPExcel->getActiveSheet()->mergeCells("M4:M5"); $objPHPExcel->getActiveSheet()->setCellValue("N4", "GRAND TOTAL"); $objPHPExcel->getActiveSheet()->getColumnDimension("N")->setWidth(17); $objPHPExcel->getActiveSheet()->mergeCells("N4:N5"); $no = 1; $cell_no = 6; foreach ($tsdaily as $c) { $date = "{$c->tsdaily_date}"; $day = date('l', strtotime($date)); if ($day == "Sunday") { $day = "Minggu"; } elseif ($day == "Monday") { $day = "Senin"; } elseif ($day == "Tuesday") { $day = "Selasa"; } elseif ($day == "Wednesday") { $day = "Rabu"; } elseif ($day == "Thursday") { $day = "Kamis"; } elseif ($day == "Friday") { $day = "Jumat"; } elseif ($day == "Saturday") { $day = "Sabtu"; } $objPHPExcel->getActiveSheet()->setCellValue("A{$cell_no}", $no); $objPHPExcel->getActiveSheet()->setCellValue("B{$cell_no}", "TS" . $c->tsdaily_topsheet_code); $objPHPExcel->getActiveSheet()->setCellValue("C{$cell_no}", $c->tsdaily_date); $objPHPExcel->getActiveSheet()->setCellValue("D{$cell_no}", $day); $objPHPExcel->getActiveSheet()->setCellValue("E{$cell_no}", $c->total_angsuranpokok); $objPHPExcel->getActiveSheet()->setCellValue("F{$cell_no}", $c->total_profit); $objPHPExcel->getActiveSheet()->setCellValue("G{$cell_no}", $c->total_tabwajib); $objPHPExcel->getActiveSheet()->setCellValue("H{$cell_no}", $c->total_tabungan_debet); $objPHPExcel->getActiveSheet()->setCellValue("I{$cell_no}", $c->total_tabungan_credit); $objPHPExcel->getActiveSheet()->setCellValue("J{$cell_no}", $c->total_tabungan_berjangka_debet); $objPHPExcel->getActiveSheet()->setCellValue("K{$cell_no}", $c->total_tabungan_berjangka_credit); $objPHPExcel->getActiveSheet()->setCellValue("L{$cell_no}", $c->total_total_rf); $objPHPExcel->getActiveSheet()->setCellValue("M{$cell_no}", $c->total_total_tabungan); $objPHPExcel->getActiveSheet()->setCellValue("N{$cell_no}", $c->total_total_tabungan + $c->total_total_rf); $cell_no++; $no++; } $objPHPExcel->getActiveSheet()->getStyle("E6:O{$cell_no}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_ACCOUNTING); //Set Column Auto Width foreach (range('B', 'J') as $columnID) { $objPHPExcel->getActiveSheet()->getColumnDimension($columnID)->setAutoSize(true); } //EXPORT $filename = "Rekap_Harian_" . $branch_name . "_" . time() . '.xls'; //save our workbook as this file name header('Content-Type: application/vnd.ms-excel'); //mime type header('Content-Disposition: attachment;filename="' . $filename . '"'); //tell browser what's the file name header('Cache-Control: max-age=0'); //no cache $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); $this->template->set('menu_title', 'Rekap Harian')->set('menu_transaksi', 'active')->set('group_total', $config['total_rows'])->set('tsdaily', $tsdaily)->set('no', $no)->set('config', $config)->build('tsdaily_report'); } else { //If no session, redirect to login page redirect('login', 'refresh'); } }
function tasks_loader() { if ($this->input->is_ajax_request()) { $token = $this->session->userdata('token'); if (isset($_POST['change_week_submit']) || isset($_POST['prev_week_submit']) || isset($_POST['current_week_submit']) || isset($_POST['next_week_submit'])) { if (isset($_POST['change_week_submit'])) { $selected_date = $this->input->post('selected_date'); } if (isset($_POST['prev_week_submit'])) { $selected_date = strtotime(week_range($this->input->post('selected_date'), 'start_day')); $selected_date = strtotime('-7 day', $selected_date); $selected_date = date('d.m.Y', $selected_date); } if (isset($_POST['current_week_submit'])) { $selected_date = date('d.m.Y'); } if (isset($_POST['next_week_submit'])) { $selected_date = strtotime(week_range($this->input->post('selected_date'), 'start_day')); $selected_date = strtotime('+7 day', $selected_date); $selected_date = date('d.m.Y', $selected_date); } $selected_task_week_cookie = $this->input->cookie('selected_task_week'); if (is($selected_date)) { $start_day = week_range($selected_date, 'start_day'); $end_day = week_range($selected_date, 'end_day'); } else { if (is($selected_task_week_cookie)) { $start_day = week_range($selected_task_week_cookie, 'start_day'); $end_day = week_range($selected_task_week_cookie, 'end_day'); } else { $start_day = week_range(date('d.m.Y'), 'start_day'); $end_day = week_range(date('d.m.Y'), 'end_day'); } } $selected_task_week_cookie = array('name' => 'selected_task_week', 'value' => $selected_date, 'expire' => 86400); $this->input->set_cookie($selected_task_week_cookie); } else { $selected_task_week_cookie = $this->input->cookie('selected_task_week'); if (is($selected_task_week_cookie)) { $start_day = week_range($selected_task_week_cookie, 'start_day'); $end_day = week_range($selected_task_week_cookie, 'end_day'); } else { $start_day = week_range(date('d.m.Y'), 'start_day'); $end_day = week_range(date('d.m.Y'), 'end_day'); } } $post_data = array('t' => $token, 'date_start' => $start_day, 'date_end' => $end_day, 'filter_task_types' => NULL); if (isset($_POST['filter_performers'])) { $post_data['filter_performers'] = json_encode($this->input->post('filter_performers')); } else { $post_data['filter_performers'] = NULL; } $tasks_list = server_data($this->config->item('api_url') . 'tasks/list.php', $post_data); $data['tasks_list'] = $tasks_list['response']['data']; $data['selected_date'] = $selected_date; $data['time_start'] = '06:00'; $data['time_end'] = '23:00'; $data['time_step'] = '00:30'; $notifies[] = $tasks_list['result']; if (is($notifies)) { $this->template->set_data('notifies', $notifies); $this->template->load_file('notifies'); } $this->template->set_data('tasks_loader', $data); $this->template->load_file('tasks/tasks_loader'); } else { $this->error_404(); } }