function index() { $offset = $this->lib_general->value_get('offset', 0); $limit = $this->lib_general->value_get('limit', 10); $data['title'] = 'ACS - Barang Keluar'; $data['action'] = site_url('barang_keluar/search' . $this->_filter()); $data['action_add'] = site_url('barang_keluar/add' . $this->_filter()); $data['export_btn'] = anchor('barang_keluar/export' . $this->_filter(), '<span class="glyphicon glyphicon-export"></span> Export Excel 2007', array('class' => 'btn btn-primary btn-sm')); $this->table->set_template(tbl_tmp()); $head_data = array('barang_name' => 'Nama Barang', 'tanggal' => 'Tanggal', 'banyak' => 'Banyak', 'retur' => 'Retur', 'vendor_name' => 'Vendor', 'operator' => 'Operator', 'keterangan' => 'Keterangan'); $heading[] = 'No'; foreach ($head_data as $r => $value) { $heading[] = anchor('barang_keluar' . $this->_filter(array('order_column' => $r, 'order_type' => $this->lib_general->order_type($r))), $value . " " . $this->lib_general->order_icon($r)); } $heading[] = 'Action'; $this->table->set_heading($heading); $result = $this->mdl_barang_keluar->get()->result(); $i = 1 + $offset; foreach ($result as $r) { $this->table->add_row($i++, anchor('barang_keluar/edit/' . $r->id . $this->_filter(), $r->barang_name), format_tanggal($r->tanggal), $r->banyak, $r->retur, $r->vendor_name, $r->operator, $r->keterangan, anchor('barang_keluar/edit/' . $r->id . $this->_filter(), '<span class="glyphicon glyphicon-edit"></span> Edit') . " | " . anchor('barang_keluar/delete/' . $r->id . $this->_filter(), '<span class="glyphicon glyphicon-trash"></span> Delete', array('onclick' => "return confirm('Are you sure')"))); } $data['table'] = $this->table->generate(); $total = $this->mdl_barang_keluar->count_all(); $config = pag_tmp(); $config['base_url'] = site_url("barang_keluar" . $this->_filter()); $config['total_rows'] = $total; $config['per_page'] = $limit; $this->pagination->initialize($config); $data['pagination'] = $this->pagination->create_links(); $data['total'] = 'Showing ' . ($offset + 1) . ' to ' . ($offset + $limit) . ' of ' . number_format($total) . ' entries'; $this->template->display('barang_keluar', $data); }
function detail_surat_masuk() { $this->load->model('surat_masuk/surat_masuks'); if ($this->input->post('nilai')) { $data = $this->surat_masuks->get_one($this->input->post('nilai')); $disposisi = $this->surat_masuks->get_disposisi_detail($data['disposisi_id']); if ($data) { $table = '<h4>Surat Masuk</h4><br/>'; $table .= '<table class="table table-condensed table-striped">'; $table .= '<tr><td width="200">SKPD Pengirim</td><td>' . $data['skpd_pengirim'] . '</td></tr>'; $table .= '<tr><td>Tanggal Surat</td><td>' . format_tanggal($data['tanggal_surat']) . '</td></tr>'; $table .= '<tr><td>Nomor Surat</td><td>' . $data['nomor_surat'] . '</td></tr>'; $table .= '<tr><td>Perihal</td><td>' . $data['perihal'] . '</td></tr>'; $table .= '<tr><td>Nomor Agenda</td><td>' . $data['nomor_agenda'] . '</td></tr>'; $table .= '<tr><td>Tanggal diterima</td><td>' . format_tanggal($data['tanggal_diterima']) . '</td></tr>'; $table .= '<tr><td>Disposisi</td><td>' . $data['disposisi'] . '</td></tr>'; if ($disposisi) { $no = 1; foreach ($disposisi as $key => $val) { $table .= '<tr><td></td><td>   ' . $no++ . '. ' . $val['deskripsi'] . '</td></tr>'; } } $file = $data['file_surat'] ? anchor(base_url('file/surat_masuk/' . $data['file_surat']), $data['file_surat'], 'target="_blank"') : '..'; //$file = (file_exists($file) ? $file : '..'); $table .= '<tr><td>Catatan</td><td>' . $data['catatan'] . '</td></tr>'; $table .= '<tr><td>File Surat</td><td>' . $file . '</td></tr>'; $table .= '</table>'; echo $table; } } }
function index() { $offset = $this->lib_general->value_get('offset', 0); $limit = $this->lib_general->value_get('limit', 10); $data['title'] = 'ACS - Campaign'; $data['action'] = site_url('campaign/search' . $this->_filter()); $data['add_btn'] = anchor('campaign/add' . $this->_filter(), '<span class="glyphicon glyphicon-plus"></span> New', array('class' => 'btn btn-primary btn-sm')); $this->table->set_template(tbl_tmp()); $head_data = array('name' => 'Campaign', 'brand' => 'Brand', 'start' => 'Start', 'end' => 'End', 'status' => 'Status'); $heading[] = 'No'; foreach ($head_data as $r => $value) { $heading[] = anchor('campaign' . $this->_filter(array('order_column' => $r, 'order_type' => $this->lib_general->order_type($r))), $value . " " . $this->lib_general->order_icon($r)); } $heading[] = 'Action'; $this->table->set_heading($heading); $result = $this->mdl_campaign->get()->result(); $i = 1 + $offset; foreach ($result as $r) { $this->table->add_row($i++, anchor('campaign/edit/' . $r->id . $this->_filter(), $r->name), $r->brand, format_tanggal($r->start), format_tanggal($r->end), get_campaign_status($r->status), anchor('campaign/edit/' . $r->id . $this->_filter(), '<span class="glyphicon glyphicon-edit"></span> Edit') . " | " . anchor('campaign/delete/' . $r->id . $this->_filter(), '<span class="glyphicon glyphicon-trash"></span> Delete', array('onclick' => "return confirm('Are you sure')"))); } $data['table'] = $this->table->generate(); $total = $this->mdl_campaign->count_all(); $config = pag_tmp(); $config['base_url'] = site_url("campaign" . $this->_filter()); $config['total_rows'] = $total; $config['per_page'] = $limit; $this->pagination->initialize($config); $data['pagination'] = $this->pagination->create_links(); $data['total'] = page_total($offset, $limit, $total); $this->template->display('campaign', $data); }
function day() { $this->ci->table->set_template(tbl_tmp()); $this->ci->table->add_row(array('data' => 'Periode', 'rowspan' => 2, 'class' => 'table-header'), array('data' => 'Jumlah Data Masuk', 'rowspan' => 2, 'class' => 'table-header', 'style' => 'vertical-align:middle'), array('data' => 'Verified Online', 'rowspan' => 2, 'class' => 'table-header'), array('data' => 'Verified Webmail', 'rowspan' => 2, 'class' => 'table-header'), array('data' => 'Unverified', 'colspan' => 5, 'class' => 'table-header')); $this->ci->table->add_row(array('data' => 'GIID copy is not legible', 'class' => 'table-header'), array('data' => 'GIID doesn\'t match', 'class' => 'table-header'), array('data' => 'Image is not ID', 'class' => 'table-header'), array('data' => 'Did not attach image', 'class' => 'table-header'), array('data' => 'Jumlah unverified', 'class' => 'table-header')); $result = $this->ci->mdl_report_online->day()->result(); $i = 1; $total = array(1 => 0, 2 => 0, 3 => 0, 4 => 0, 5 => 0, 6 => 0, 7 => 0, 8 => 0); foreach ($result as $r) { $this->ci->table->add_row(format_tanggal($r->entry_date), number_format($r->count), number_format($r->vo), number_format($r->vw), number_format($r->leg), number_format($r->mat), number_format($r->id), number_format($r->img), number_format($r->un)); $total[1] += $r->count; $total[2] += $r->vo; $total[3] += $r->vw; $total[4] += $r->leg; $total[5] += $r->mat; $total[6] += $r->id; $total[7] += $r->img; $total[8] += $r->un; $i++; } $tot[] = array('data' => 'Total', 'class' => 'table-footer'); for ($i = 1; $i <= 8; $i++) { $tot[$i] = array('data' => number_format($total[$i]), 'class' => 'table-footer'); } $this->ci->table->add_row($tot); return $this->ci->table->generate(); }
// pr($result); // exit; //set gambar untuk laporan $gambar = $FILE_GAMBAR_KABUPATEN; if($tglcetak != ''){ $tanggalCetak = format_tanggal($tglcetak); $thnPejabat =substr($tglcetak,0,4); }else{ $tglcetak = date("Y-m-d"); $tanggalCetak = format_tanggal($tglcetak); $thnPejabat =substr($tglcetak,0,4); } if($tglawalperolehan != '' && $tglakhirperolehan){ $tanggalAwal = format_tanggal($tglawalperolehan); $tanggalAkhir = format_tanggal($tglakhirperolehan); } // pr($result); // exit; $html=$REPORT->retrieve_html_laporan_mutasi($result,$skpd_id,$gambar,$tanggalAwal,$tanggalAkhir,$tanggalCetak,$thnPejabat); /*$count = count($html); for ($i = 0; $i < $count; $i++) { echo $html[$i]; } exit;*/ if($tipe==1){ $REPORT->show_status_download_kib(); $mpdf=new mPDF('','','','',15,15,16,16,9,9,'L');
echo form_label('Start', 'start', array('class' => 'control-label')); ?> <?php echo form_input(array('name' => 'start', 'class' => 'form-control input-sm tanggal', 'maxlength' => '10', 'autocomplete' => 'off', 'value' => set_value('start', isset($row->start) ? format_tanggal($row->start) : ''), 'required' => 'required')); ?> <small><?php echo form_error('start'); ?> </small> </div> <div class="form-group form-inline"> <?php echo form_label('End', 'end', array('class' => 'control-label')); ?> <?php echo form_input(array('name' => 'end', 'class' => 'form-control input-sm tanggal', 'maxlength' => '10', 'autocomplete' => 'off', 'value' => set_value('end', isset($row->end) ? format_tanggal($row->end) : ''), 'required' => 'required')); ?> <small><?php echo form_error('end'); ?> </small> </div> <div class="form-group form-inline"> <?php echo form_label('Status', 'status', array('class' => 'control-label')); ?> <?php echo form_dropdown('status', campaign_status_dropdown(), set_value('status', isset($row->status) ? $row->status : ''), 'required=required class="form-control input-sm"'); ?> <small><?php echo form_error('status');
//mengenerate query // $result_query=$REPORT->retrieve_query($query); $table_name = "mesin"; $result_query=$REPORT->QueryKib($query,$table_name); $result = arrayToObject($result_query); // pr($result); // exit; //set gambar untuk laporan $gambar = $FILE_GAMBAR_KABUPATEN; if($tglcetak != ''){ $tanggalCetak = format_tanggal($tglcetak); $thnPejabat =substr($tglcetak,0,4); }else{ $tglcetak = date("Y-m-d"); $tanggalCetak = format_tanggal($tglcetak); $thnPejabat =substr($tglcetak,0,4); } //retrieve html $html=$REPORT->retrieve_html_kib_b($result, $gambar,$tanggalCetak,$thnPejabat,$tipe); /*$count = count($html); for ($i = 0; $i < $count; $i++) { echo $html[$i]; } exit;*/ if($tipe!="2"){ $REPORT->show_status_download_kib(); $mpdf=new mPDF('','','','',15,15,16,16,9,9,'L');
background: #FFF none repeat scroll 0% 0%; margin-top: 10px; } </style> <div id="slide"> <div class="container"> <div class="row"> <div class="col-sm-12"> <div class="col-sm-12"> <?php echo "<h3>" . $slide['title_slide'] . "</h3>"; ?> <div class="row"> <div class="col-sm-12"> <?php $tgl = format_tanggal($slide['update_at']); ?> <?php echo " {$tgl} WIB"; ?> </div> </div> <br> <img class="img-thumbnail" src="<?php echo base_url('assets/img/slide/' . $slide['image']); ?> " height="350px" width="700px"> <?php echo "<p>" . $slide['article_slide'] . "</p>"; ?> </div>
echo form_label('Entry Date', 'entry_date', array('class' => 'control-label')); ?> <?php echo form_input(array('name' => 'entry_date', 'class' => 'form-control input-sm tanggal', 'maxlength' => '10', 'size' => '40', 'autocomplete' => 'off', 'value' => set_value('entry_date', isset($row->entry_date) ? format_tanggal($row->entry_date) : ''))); ?> <small><?php echo form_error('entry_date'); ?> </small> </div> <div class="form-group form-inline"> <?php echo form_label('Verification Date', 'verifikasi_date', array('class' => 'control-label')); ?> <?php echo form_input(array('name' => 'verifikasi_date', 'class' => 'form-control input-sm tanggal', 'maxlength' => '10', 'size' => '40', 'autocomplete' => 'off', 'value' => set_value('verifikasi_date', isset($row->verifikasi_date) ? format_tanggal($row->verifikasi_date) : ''))); ?> <small><?php echo form_error('verifikasi_date'); ?> </small> </div> <div class="form-group form-inline"> <?php echo form_label('Referred by', 'referred', array('class' => 'control-label')); ?> <?php echo form_input(array('name' => 'referred', 'class' => 'form-control input-sm', 'maxlength' => '50', 'size' => '40', 'autocomplete' => 'off', 'value' => set_value('referred', isset($row->referred) ? $row->referred : ''))); ?> <small><?php echo form_error('referred');
$view = new Peminjaman; $view->connect(); $view->get_pembayaran_detil($idBn); $row=0; while($result=$view->get_array()){ $number=$row+1; if ($number % 2 ==0){ $class_name='table-common-even'; }else{ $class_name=''; } $disp[$row]=array('NO'=>$number, 'IDBYR'=>$result['IDBYR'], 'TANGGAL'=>format_tanggal($result['TANGGAL']), 'NOMINAL'=>number_format($result['NOMINAL'],2,',','.'), 'CLASS_NAME'=>$class_name); $row++; } #print_r($disp); foreach ($disp as $data){ $param="module=pengeluaran_bon&file=edit_detil_view&idByr=".$data['IDBYR']; $urlEd=$crypt->paramEncrypt($param); $tmpl->addVars("data", $data); $tmpl->addVar("data", "URL_EDIT", "index.php?".$urlEd); $tmpl->parseTemplate("data","a"); } ?>
public function retrieve_html_bukubarangpakaihabis($dataArr,$gambar){ if($dataArr!="") { include ('../../../function/tanggal/tanggal.php'); $head = " <html> <head> <style> table { font-size:10pt; font-family:Arial; border-collapse: collapse; border-spacing:0; } h3 { font-family:Arial; font-size:13pt; color:#000; } p { font-size:10pt; font-family:Arial; font-weight:bold; } </style> </head> "; /*foreach ($dataArr['data_pejabat'] as $value) { foreach ($value as $data) { //echo $data->NamaJabatan.'<br>'; //echo $data->NamaPejabat; } }*/ $no=1; $skpdeh=""; $status_print=0; $jumlahTotal=0; $satuanTotal=0; foreach ($dataArr as $row) { if ($skpdeh == "" && $no==1){ $body=""; $skpdeh = $row->NamaSatker; $satker_id=$row->LastSatker_ID; list($nip_atasan,$nama_jabatan_atasan)=$this->get_jabatan($satker_id,"1"); list($nip_penyimpan,$nama_jabatan_penyimpan)=$this->get_jabatan($satker_id,"2"); if($nip_atasan!="") { $nip_atasan_fix=$nip_atasan; } else { $nip_atasan_fix='........................................'; } if($nip_penyimpan!="") { $nip_penyimpan_fix=$nip_penyimpan; } else { $nip_penyimpan_fix='........................................'; } if($nama_jabatan_atasan!="") { $nama_jabatan_atasan_fix=$nama_jabatan_atasan; } else { $nama_jabatan_atasan_fix='........................................'; } if($nama_jabatan_penyimpan!="") { $nama_jabatan_penyimpan_fix=$nama_jabatan_penyimpan; } else { $nama_jabatan_penyimpan_fix='........................................'; } $body=" <body> <table style=\"text-align: left; width: 100%;\" border=\"0\" cellpadding=\"2\" cellspacing=\"2\"> <tbody> <tr> <td style=\"width: 150px;\"><img style=\"width: 80px; height: 85px;\" alt=\"\" src=\"$gambar\"></td> <td style=\"width: 902px; text-align: center;\"> <h3>BUKU BARANG PAKAI HABIS</h3> </td> </tr> </tbody> </table> <br> <table style=\"text-align: left; width: 100%;\" border=\"0\" cellpadding=\"2\" cellspacing=\"2\"> <tbody> <tr> <td style=\"font-weight: bold; text-align: left; width: 19%;\">SKPD</td> <td style=\"text-align: left; font-weight: bold; width: 81%;\">: $skpdeh</td> </tr> <tr> <td style=\"font-weight: bold; text-align: left; width: 19%;\">KABUPATEN / KOTA</td> <td style=\"text-align: left; font-weight: bold; width: 81%;\">: $this->NAMA_KABUPATEN</td> </tr> <tr> <td style=\"font-weight: bold; width: 19%;\">PROVINSI</td> <td style=\"text-align: left; font-weight: bold; width: 81%;\">: $this->NAMA_PROVINSI</td> </tr> </tbody> </table> <br> <body> <table style=\"text-align: left; width: 100%;\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\"> <thead> <tr> <td colspan=\"1\" rowspan=\"1\" style=\"text-align: center; font-weight: bold; width: 30px;\"></td> <td style=\"text-align: center; font-weight: bold; width: 741px;\"rowspan=\"1\" colspan=\"8\">PENERIMAAN</td> <td style=\"font-weight: bold; text-align: center; width: 343px;\"rowspan=\"1\" colspan=\"4\">PENGELUARAN<br> </td> <td> </td> </tr> <tr> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 30px;\">No</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 60px;\">Tanggal</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 170px;\">Nama / Jenis Barang</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 100px;\">Merk / Ukuran</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 83px;\">Thn<br> Pembuatan</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 60px;\">Jumlah / <br> Satuan</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 108px;\">Tgl/No.<br> Kontrak/SP/SPK</td> <td colspan=\"2\" rowspan=\"1\" style=\"text-align: center; font-weight: bold; width: 160px;\">Berita Acara<br>Pemeriksaan</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold;\">Tanggal<br>Dikeluarkan</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold;\">Diserahkan <br>Kepada</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 85px;\">Jumlah Sat / Barang </td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 87px;\">Tgl / No. Penyerahan</td> <td style=\"text-align: center; font-weight: bold;\"colspan=\"1\" rowspan=\"2\">Keterangan</td> </tr> <tr> <td style=\"text-align: center; font-weight: bold; width: 80px;\">Tanggal</td> <td style=\"text-align: center; font-weight: bold; width: 80px;\">Nomor</td> </tr> <tr> <td style=\"width: 30px; text-align: center; font-weight: bold;\">1</td> <td style=\"width: 60px; text-align: center; font-weight: bold;\">2</td> <td style=\"width: 170px; text-align: center; font-weight: bold;\">3</td> <td style=\"width: 100px; text-align: center; font-weight: bold;\">4</td> <td style=\"width: 83px; text-align: center; font-weight: bold;\">5</td> <td style=\"width: 60px; text-align: center; font-weight: bold;\">6</td> <td style=\"width: 108px; text-align: center; font-weight: bold;\">7</td> <td style=\"width: 80px; text-align: center; font-weight: bold;\">8</td> <td style=\"width: 80px; text-align: center; font-weight: bold;\">9</td> <td style=\"width: 100px; text-align: center; font-weight: bold;\">10</td> <td style=\"width: 85px; text-align: center; font-weight: bold;\">11</td> <td style=\"width: 87px; text-align: center; font-weight: bold;\">12</td> <td style=\"width: 85px; text-align: center; font-weight: bold;\">13</td> <td style=\"width: 87px; text-align: center; font-weight: bold;\">14</td> </tr> </thead> "; } //uda dites footer disini if ($skpdeh != $row->NamaSatker && $no>1){ $printjumlahTotal= number_format($jumlahTotal); $printsatuanTotal= number_format($satuanTotal); $tabletotal=" <tr> <td colspan=\"5\" align=\"center\">TOTAL</td> <td align=\"center\">$printjumlahTotal</td> <td colspan=\"5\"></td> <td align=\"center\">$printsatuanTotal</td> <td colspan=\"2\"></td> </tr> </table> "; $no=1; $jumlahTotal=0; $satuanTotal=0; $foot=" </tbody> </table>"; $foot.="<table border=\"0\"> <tr> <td colspan=\"13\"> </td> </tr> </table>"; $footer=" <table style=\"text-align: left; width: 1024px; height: 90px;\" border=\"0\" cellpadding=\"2\" cellspacing=\"2\"> <tbody> <tr> <td style=\"text-align: center;\" colspan=\"3\" width=\"300px\">Mengetahui</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td style=\"text-align: center;\" colspan=\"3\" width=\"140px\">$f_tanggal $f_bulan $f_tahun</td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">Atasan langsung</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td style=\"text-align: center;\" colspan=\"3\">Penyimpan Barang</td> </tr> <tr> <td colspan=\"11\" style=\"height: 80px\"></td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">$nama_jabatan_atasan_fix</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td style=\"text-align: center;\" colspan=\"3\">$nama_jabatan_penyimpan_fix</td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">______________________________</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td style=\"text-align: center;\" colspan=\"3\">______________________________</td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">NIP. $nip_atasan_fix</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td style=\"text-align: center;\" colspan=\"3\">NIP. $nip_penyimpan_fix</td> </tr> </table>"; $footer= $this->set_footer_to_png($this->path, $this->url_rewrite, $footer); $footer.=" </body> </html>"; //udah dites footer $no=1; $jumlahTotal=0; $satuanTotal=0; if($status_print==0) $html[]=$head.$body.$tabletotal.$foot.$footer; else $html[]=$body.$tabletotal.$foot.$footer; $skpdeh = $row->NamaSatker; $satker_id=$row->LastSatker_ID; list($nip_atasan,$nama_jabatan_atasan)=$this->get_jabatan($satker_id,"1"); list($nip_penyimpan,$nama_jabatan_penyimpan)=$this->get_jabatan($satker_id,"2"); $body=""; $body.=" <body> <table style=\"text-align: left; width: 100%;\" border=\"0\" cellpadding=\"2\" cellspacing=\"2\"> <tbody> <tr> <td style=\"width: 150px;\"><img style=\"width: 80px; height: 85px;\" alt=\"\" src=\"$gambar\"></td> <td style=\"width: 902px; text-align: center;\"> <h3>BUKU BARANG PAKAI HABIS</h3> </td> </tr> </tbody> </table> <br> <table style=\"text-align: left; width: 100%;\" border=\"0\" cellpadding=\"2\" cellspacing=\"2\"> <tbody> <tr> <td style=\"font-weight: bold; text-align: left; width: 19%;\">SKPD</td> <td style=\"text-align: left; font-weight: bold; width: 81%;\">: $skpdeh</td> </tr> <tr> <td style=\"font-weight: bold; text-align: left; width: 19%;\">KABUPATEN / KOTA</td> <td style=\"text-align: left; font-weight: bold; width: 81%;\">: $this->NAMA_KABUPATEN</td> </tr> <tr> <td style=\"font-weight: bold; width: 19%;\">PROVINSI</td> <td style=\"text-align: left; font-weight: bold; width: 81%;\">: $this->NAMA_PROVINSI</td> </tr> </tbody> </table> <br> <body> <table style=\"text-align: left; width: 100%;\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\"> <thead> <tr> <td colspan=\"1\" rowspan=\"1\" style=\"text-align: center; font-weight: bold; width: 30px;\"></td> <td style=\"text-align: center; font-weight: bold; width: 741px;\"rowspan=\"1\" colspan=\"8\">PENERIMAAN</td> <td style=\"font-weight: bold; text-align: center; width: 343px;\"rowspan=\"1\" colspan=\"4\">PENGELUARAN<br> </td> <td> </td> </tr> <tr> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 30px;\">No</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 60px;\">Tanggal</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 170px;\">Nama / Jenis Barang</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 100px;\">Merk / Ukuran</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 83px;\">Thn<br> Pembuatan</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 60px;\">Jumlah / <br> Satuan</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 108px;\">Tgl/No.<br> Kontrak/SP/SPK</td> <td colspan=\"2\" rowspan=\"1\" style=\"text-align: center; font-weight: bold; width: 160px;\">Berita Acara<br>Pemeriksaan</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold;\">Tanggal<br>Dikeluarkan</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold;\">Diserahkan <br>Kepada</td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 85px;\">Jumlah Sat / Barang </td> <td colspan=\"1\" rowspan=\"2\" style=\"text-align: center; font-weight: bold; width: 87px;\">Tgl / No. Penyerahan</td> <td style=\"text-align: center; font-weight: bold;\"colspan=\"1\" rowspan=\"2\">Keterangan</td> </tr> <tr> <td style=\"text-align: center; font-weight: bold; width: 80px;\">Tanggal</td> <td style=\"text-align: center; font-weight: bold; width: 80px;\">Nomor</td> </tr> <tr> <td style=\"width: 30px; text-align: center; font-weight: bold;\">1</td> <td style=\"width: 60px; text-align: center; font-weight: bold;\">2</td> <td style=\"width: 170px; text-align: center; font-weight: bold;\">3</td> <td style=\"width: 100px; text-align: center; font-weight: bold;\">4</td> <td style=\"width: 83px; text-align: center; font-weight: bold;\">5</td> <td style=\"width: 60px; text-align: center; font-weight: bold;\">6</td> <td style=\"width: 108px; text-align: center; font-weight: bold;\">7</td> <td style=\"width: 80px; text-align: center; font-weight: bold;\">8</td> <td style=\"width: 80px; text-align: center; font-weight: bold;\">9</td> <td style=\"width: 100px; text-align: center; font-weight: bold;\">10</td> <td style=\"width: 85px; text-align: center; font-weight: bold;\">11</td> <td style=\"width: 87px; text-align: center; font-weight: bold;\">12</td> <td style=\"width: 85px; text-align: center; font-weight: bold;\">13</td> <td style=\"width: 87px; text-align: center; font-weight: bold;\">14</td> </tr> </thead> "; //udah dites disini footer $skpdeh = $row->NamaSatker; $status_print++; } //udah dites $jumlahTotal = $jumlahTotal + $row->Kuantitas; $satuanTotal = $satuanTotal + $row->Kuantitas; $kuantitas = $row->Kuantitas; $kuantitas_rp = number_format($kuantitas); $change=$row->TglPenerimaan; $change2=format_tanggal($change); $change3=$row->TglPemeriksaan; $change4=format_tanggal($change3); $change5=$row->TglBAST; $change6=format_tanggal($change5); ($row->NoBAPemeriksaan == '') ? $NoBA = "-" : $NoBA = $row->NoBAPemeriksaan; ($row->NoBAST == '') ? $NoBAST = "-" : $NoBAST = $row->NoBAST; ($row->KeteranganPenerimaan == '') ? $ket = "-" : $ket = $row->KeteranganPenerimaan; ($row->Merk == '') ? $merk = "-" : $merk = $row->Merk; ($row->NoKontrak == '') ? $nokontrak = "-" : $nokontrak = $row->NoKontrak; $body.=" <tr> <td style=\"width: 30px;font-weight: \" align=\"center\">$no</td> <td style=\"width: 120px;font-weight: \" align=\"center\">$change2</td> <td style=\"width: 100px;font-weight: \">$row->NamaAset</td> <td style=\"width: 100px;font-weight: \" align=\"center\">$merk</td> <td style=\"width: 100px;font-weight: \" align=\"center\">$row->Tahun</td> <td style=\"width: 200px;font-weight: \" align=\"center\">$kuantitas_rp</td> <td style=\"width: 100px;font-weight: \" align=\"center\">$nokontrak</td> <td style=\"width: 100px;font-weight: \" align=\"center\">$change4</td> <td style=\"width: 100px;font-weight: \" align=\"center\">$NoBA</td> <td style=\"width: 200px;font-weight: \" align=\"center\">$change6</td> <td style=\"width: 100px;font-weight: \" align=\"center\">-</td> <td style=\"width: 100px;font-weight: \" align=\"center\">$kuantitas_rp</td> <td style=\"width: 200px;font-weight: \" align=\"center\">$change6</td> <td style=\"width: 200px;font-weight: \" align=\"center\">$ket</td> </tr> "; $no++; //coba } //udah dicoba ga muncul $printjumlahTotal= number_format($jumlahTotal); $printsatuanTotal= number_format($satuanTotal); $tabletotal=" <tr> <td colspan=\"5\" align=\"center\">TOTAL</td> <td align=\"center\">$printjumlahTotal</td> <td colspan=\"5\"></td> <td align=\"center\">$printsatuanTotal</td> <td colspan=\"2\"></td> </tr> </table> "; $foot=" </tbody> </table>"; $foot.="<table border=\"0\"> <tr> <td colspan=\"13\"> </td> </tr> </table>"; $footer=" <table style=\"text-align: left; width: 1024px; height: 90px;\" border=\"0\" cellpadding=\"2\" cellspacing=\"2\"> <tbody> <tr> <td style=\"text-align: center;\" colspan=\"3\" width=\"300px\">Mengetahui</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td style=\"text-align: center;\" colspan=\"3\" width=\"140px\">$f_tanggal $f_bulan $f_tahun</td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">Atasan langsung</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td style=\"text-align: center;\" colspan=\"3\">Penyimpan Barang</td> </tr> <tr> <td colspan=\"11\" style=\"height: 80px\"></td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">$nama_jabatan_atasan_fix</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td style=\"text-align: center;\" colspan=\"3\">$nama_jabatan_penyimpan_fix</td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">______________________________</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td style=\"text-align: center;\" colspan=\"3\">______________________________</td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">NIP. $nip_atasan_fix</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td style=\"text-align: center;\" colspan=\"3\">NIP. $nip_penyimpan_fix</td> </tr> </table>"; $footer= $this->set_footer_to_png($this->path, $this->url_rewrite, $footer); $footer.=" </body> </html>"; if($status_print==0){ $html[]=$head.$body.$tabletotal.$foot.$footer; }else{ $html[]=$body.$tabletotal.$foot.$footer; } return $html; } }
$tmpl->addVar("article", "NIS", $siswa['NIS']); $tmpl->addVar("article", "NAMA", $siswa['NAMA']); $tmpl->addVar("article", "KELAS", $siswa['JENJANG']." - ".$siswa['KELAS']); $view->get_list_transaksi($nis); while($result=$view->get_array()){ $number=$row+1; if ($number % 2 ==0){ $class_name='table-common-even'; }else{ $class_name=''; } $disp[$row]=array('NO_TRANS'=>$number, 'TGL_TRANS'=>format_tanggal($result['TANGGAL']), 'JNS_TRANS'=>$result['TRANSAKSI'], 'TOTAL_TRANS'=>number_format($result['TOTAL'],2,',','.'), 'ID_TRANS'=>$result['ID_TRANS'], 'CLASS_NAME'=>$class_name); $row++; } #print_r($disp); foreach ($disp as $data){ $param="module=rekap_siswa&file=edit_siswa_view&idTr=".$data[ID_TRANS]; $urlEd=$crypt->paramEncrypt($param); $tmpl->addVars("data_trans", $data); $tmpl->addVar("data_trans", "URL_EDIT", "index.php?".$urlEd); $tmpl->parseTemplate("data_trans","a"); }
$view->connect(); $view->get_rekap_umum($tanggal_mulai, $tanggal_selesai); $row=0; $Acc=0; while($result=$view->get_array()) { $number=$row+1; if ($number % 2 ==0){ $class_name='table-common-even'; }else{ $class_name=''; } $Acc = $Acc + $result['SALDO']; $disp[$row]=array('NO'=>$number, 'TANGGAL'=>format_tanggal($result['TANGGAL_TRANSAKSI']), 'TOTAL_IURAN'=>number_format($result['TOTAL_IURAN'],2,',','.'), 'TOTAL_PENGEMBALIAN'=>number_format($result['TOTAL_PENGEMBALIAN'],2,',','.'), 'TOTAL_SETORAN'=>number_format($result['TOTAL_SETORAN'],2,',','.'), 'TOTAL_PEMINJAMAN'=>number_format($result['TOTAL_PEMINJAMAN'],2,',','.'), 'SALDO'=>number_format($Acc,2,',','.'), 'CLASS_NAME'=>$class_name); $row++; } foreach ($disp as $data){ $param="module=rekap_siswa&file=detil_siswa_view&nis=".$data[TANGGAL]; $urlDtl=$crypt->paramEncrypt($param); $tmpl->addVars("data", $data); $tmpl->addVar("data", "URL_DETIL", "index.php?".$urlDtl);
$worksheet->merge_cells(6, 4, 6, 4); $worksheet->write_string(6, 4, 'Setoran', $h4); $worksheet->merge_cells(6, 5, 6, 5); $worksheet->write_string(6, 5, 'Pinjaman', $h4); $worksheet->merge_cells(5, 6, 6, 6); $worksheet->write_string(5, 6, 'Saldo', $h4); $view = new rekap_umum; $view->connect(); $view->get_rekap_umum($tanggal_mulai, $tanggal_selesai); $row=7; $Acc=0; $number=1; while($result=$view->get_array()) { $Acc = $Acc + $result['SALDO']; $worksheet->write_string($row, 0, $number, $content); $worksheet->write_string($row, 1, format_tanggal($result['TANGGAL_TRANSAKSI']), $content); $worksheet->write_string($row, 2, number_format($result['TOTAL_IURAN'],2,',','.'), $content); $worksheet->write_string($row, 3, number_format($result['TOTAL_PENGEMBALIAN'],2,',','.'), $content); $worksheet->write_string($row, 4, number_format($result['TOTAL_SETORAN'],2,',','.'), $content); $worksheet->write_string($row, 5, number_format($result['TOTAL_PEMINJAMAN'],2,',','.'), $content); $worksheet->write_string($row, 6, number_format($Acc,2,',','.'), $content); $row++;$number++; } $workbook->close(); ?>
$no = 1; foreach($get_data_regrouping as $val){ $text_status=array("0"=>"Belum regrouping", "1"=>"Sedang regrouping", "2"=>"Telah regrouping") ?> <tr class="gradeA"> <td><?=$no?></td> <td><?=$val['satker_lama']?></td> <td><?=$val['nama_satker_lama']?></td> <td><?=$val['satker_baru']?></td> <td><?=$val['nama_satker_baru']?></td> <td><?= format_tanggal($val['tgl_proses'])?></td> <td><?=$val['informasi']?></td> <td><?=$text_status[$val['status_proses']]?></td> <td> <?php switch ($val['status_proses']) { case 0: echo "<a href=\"running_regrouping.php?regrouping={$val['id_regrouping']}\" class=\"btn btn-info\">Lakukan Regrouping</a>"; echo "<a href=\"proses_regrouping.php?hregrouping={$val['id_regrouping']}\" class=\"btn btn-warning\">Hapus Regrouping</a>"; break; default: echo "-"; break; } ?>