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