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