function tgl_indo($tgl)
{
$ubah = gmdate($tgl, time() + 60 * 60 * 8);
$pecah = explode("-", $ubah);
$tanggal = $pecah[2];
$bulan = bulan($pecah[1]);
$tahun = $pecah[0];
return $tanggal . ' ' . $bulan . ' ' . $tahun;
}
function deadline()
{
$CI =& get_instance();
$dead = $CI->config->item('deadline');
$next = strtotime("+" . $dead . " day");
$tanggale = mdate('%j', $next);
$bulane = bulan(mdate('%n', $next));
$tahune = mdate('%Y', $next);
return $tanggale . ' ' . $bulane . ' ' . $tahune;
}
function tgl_jam_indo($tgl_jam)
{
$rubah = gmdate($tgl_jam);
$cacah = multiexplode(array("-", " ", ":"), $rubah);
$tanggal = $cacah[2];
$bulan = bulan($cacah[1]);
$tahun = $cacah[0];
$jam = $cacah[3];
$menit = $cacah[4];
$detik = $cacah[5];
return $tanggal . ' ' . $bulan . ' ' . $tahun . ' ' . $jam . ':' . $menit . ':' . $detik;
}
function tgl_indo($tgl)
{
if ($tgl == "0000-00-00 00:00:00") {
$tanggal = "01";
$bulan = "1";
$tahun = "2013";
} else {
$ubah = gmdate($tgl, time() + 60 * 60 * 8);
$pecah = explode("-", $ubah);
$tanggal = $pecah[2];
$bulan = bulan($pecah[1]);
$tahun = $pecah[0];
}
return $tanggal . ' ' . $bulan . ' ' . $tahun;
}
public function index()
{
if ($this->input->post('bulan') == '') {
$bln = date("m");
$bulan = bulan($bln);
$tahun = date("Y");
} else {
$bulan = $this->input->post('bulan');
$tahun = $this->input->post('tahun');
}
$this->mTitle = "Data Produksi";
$this->mViewFile = 'data_produksi';
$this->mViewData['data_produksi'] = $this->Komoditas_model->get_dataproduksi($bulan, $tahun);
$this->mViewData['luas_lahan'] = $this->Komoditas_model->get_luaslahan($bulan, $tahun);
$this->mViewData['bulan'] = $bulan;
$this->mViewData['tahun'] = $tahun;
}
function tgl_indo_timestamp($tgl)
{
$inttime = date('Y-m-d H:i:s', $tgl);
//mengubah format menjadi tanggal biasa
$tglBaru = explode(" ", $inttime);
//memecah berdasarkan spaasi
$tglBaru1 = $tglBaru[0];
//mendapatkan variabel format yyyy-mm-dd
$tglBaru2 = $tglBaru[1];
//mendapatkan fotmat hh:ii:ss
$tglBarua = explode("-", $tglBaru1);
//lalu memecah variabel berdasarkan -
$tgl = $tglBarua[2];
$bln = $tglBarua[1];
$thn = $tglBarua[0];
$bln = bulan($bln);
//mengganti bulan angka menjadi text dari fungsi bulan
$ubahTanggal = "{$tgl} {$bln} {$thn} | {$tglBaru2} ";
//hasil akhir tanggal
return $ubahTanggal;
}
function nama_hari($tanggal)
{
$ubah = gmdate($tanggal, time());
$pecah2 = explode(" ", $ubah);
$pecah = explode("-", $pecah2[0]);
$tgl = $pecah[2];
$bln = bulan($pecah[1]);
$thn = $pecah[0];
$nama = date("l", mktime(0, 0, 0, $pecah[1], $tgl, $thn));
$nama_hari = "";
if ($nama == "Sunday") {
$nama_hari = "Minggu";
} else {
if ($nama == "Monday") {
$nama_hari = "Senin";
} else {
if ($nama == "Tuesday") {
$nama_hari = "Selasa";
} else {
if ($nama == "Wednesday") {
$nama_hari = "Rabu";
} else {
if ($nama == "Thursday") {
$nama_hari = "Kamis";
} else {
if ($nama == "Friday") {
$nama_hari = "Jumat";
} else {
if ($nama == "Saturday") {
$nama_hari = "Sabtu";
}
}
}
}
}
}
}
return $nama_hari;
}
<div class="container">
</div>
<script>
$(function () {
$('#grafik').highcharts({
chart: {
type: 'line'
},
title: {
text: 'GRAFIK HARGA BULAN <?php
echo bulan($bln);
?>
'
},
xAxis: {
categories: [<?php
foreach ($data_tanggal as $row_tanggal) {
?>
'<?php
echo $row_tanggal->tgl_update;
?>
', <?php
}
?>
]
},
case 9:
$bulan = "SEPTEMBER";
break;
case 10:
$bulan = "OKTOBER";
break;
case 11:
$bulan = "NOVEMBER";
break;
case 12:
$bulan = "DESEMBER";
break;
}
return $bulan;
}
$bulan = bulan(date("m"));
?>
<table width="326">
<tr><th colspan="9">DINAS PERHUBUNGAN, KEBUDAYAAN, PARIWISATA, POS DAN TELEKOMUNIKASI</th></tr>
<tr><th colspan="9">{{$dataInstansi->kabkota()->first()->name}}</th></tr>
<tr><th colspan="9">BULAN <?php
echo $bulan;
?>
<?php
echo date("Y");
?>
</th></tr>
<tr></tr>
</table>
<table border="1">
function tanggal($tgl = "", $type = "", $aktif_bln = "y", $pemisah = "-")
{
switch ($type) {
case 'indo-eng':
$tahun = substr($tgl, 6, 4);
$bulan = substr($tgl, 3, 2);
$tanggal = substr($tgl, 0, 2);
return $tahun . $pemisah . $bulan . $pemisah . $tanggal;
break;
case 'eng-indo':
$tahun = substr($tgl, 0, 4);
$bulan = substr($tgl, 5, 2);
$tanggal = substr($tgl, 8, 2);
$bl = $aktif_bln == "y" ? bulan($bulan) : $bulan;
return $tanggal . $pemisah . $bl . $pemisah . $tahun;
break;
default:
$tanggal = date("Y-m-d");
return $tanggal;
break;
}
}
function donasi($sort, $limit, $order)
{
$sql = "SELECT * FROM donasi ORDER BY {$order} {$sort} LIMIT {$limit}";
$command = mysql_query($sql) or die("<meta http-equiv='refresh' content='0;url=index.php'>");
while ($donasi = mysql_fetch_array($command)) {
echo "<tr><td>Donasi " . bulan($donasi['bulan']) . " " . $donasi['tahun'] . "</td><td><a href='donasi-detail.php?order=tanggal_donasi&sort=DESC&limit=10&bulan=" . bulan($donasi['bulan']) . "&tahun=" . $donasi['tahun'] . "'>Buka</a> | <a href='donasi/index.php?bulan=" . bulan($donasi['bulan']) . "&tahun=" . $donasi['tahun'] . "'> Print </a></td></tr>";
}
}
public function export_per_pendidikan()
{
$result = $this->rekap_model->getRekapPerPendidikan();
if ($result) {
foreach ($result['rows'] as $row) {
$dataLaporan[] = array('UNOR' => $row['UNOR'], 'L_SD' => (string) $row['L_SD'], 'L_SMP' => (string) $row['L_SMP'], 'L_SMA' => (string) $row['L_SMA'], 'L_D1' => (string) $row['L_D1'], 'L_D2' => (string) $row['L_D2'], 'L_D3' => (string) $row['L_D3'], 'L_D4' => (string) $row['L_D4'], 'L_S1' => (string) $row['L_S1'], 'L_S2' => (string) $row['L_S2'], 'L_S3' => (string) $row['L_S3'], 'L_TOTAL' => (string) $row['L_TOTAL'], 'P_SD' => (string) $row['P_SD'], 'P_SMP' => (string) $row['P_SMP'], 'P_SMA' => (string) $row['P_SMA'], 'P_D1' => (string) $row['P_D1'], 'P_D2' => (string) $row['P_D2'], 'P_D3' => (string) $row['P_D3'], 'P_D4' => (string) $row['P_D4'], 'P_S1' => (string) $row['P_S1'], 'P_S2' => (string) $row['P_S2'], 'P_S3' => (string) $row['P_S3'], 'P_TOTAL' => (string) $row['P_TOTAL']);
}
foreach ((array) $result['footer'] as $foot) {
$dataLaporan[] = array('UNOR' => 'TOTAL', 'L_SD' => (string) $foot['L_SD'], 'L_SMP' => (string) $foot['L_SMP'], 'L_SMA' => (string) $foot['L_SMA'], 'L_D1' => (string) $foot['L_D1'], 'L_D2' => (string) $foot['L_D2'], 'L_D3' => (string) $foot['L_D3'], 'L_D4' => (string) $foot['L_D4'], 'L_S1' => (string) $foot['L_S1'], 'L_S2' => (string) $foot['L_S2'], 'L_S3' => (string) $foot['L_S3'], 'L_TOTAL' => (string) $foot['L_TOTAL'], 'P_SD' => (string) $foot['P_SD'], 'P_SMP' => (string) $foot['P_SMP'], 'P_SMA' => (string) $foot['P_SMA'], 'P_D1' => (string) $foot['P_D1'], 'P_D2' => (string) $foot['P_D2'], 'P_D3' => (string) $foot['P_D3'], 'P_D4' => (string) $foot['P_D4'], 'P_S1' => (string) $foot['P_S1'], 'P_S2' => (string) $foot['P_S2'], 'P_S3' => (string) $foot['P_S3'], 'P_TOTAL' => (string) $foot['P_TOTAL']);
}
$filename = "REKAP_PEGAWAI_PER_PENDIDIKAN_" . date('d-m-Y') . ".xls";
$count = count($result['rows']) + 6;
$header = array('UNOR', 'SD', 'SMP', 'SMA', 'D1', 'D2', 'D3', 'D4', 'S1', 'S2', 'S3', 'TOTAL', 'SD', 'SMP', 'SMA', 'D1', 'D2', 'D3', 'D4', 'S1', 'S2', 'S3', 'TOTAL');
$alphas = range('A', 'Z');
$this->load->library('excel');
$rangeBorder = 'A4:' . 'AC' . $count;
$styleArray = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
// for ($i = 0; $i <= 3; $i++) {
// $koordinatAbjad = $alphas[$i];
// $this->excel->getActiveSheet()->getColumnDimension($koordinatAbjad)->setAutoSize(true);
// }
$this->excel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$keadaan = strtoupper(bulan(date('m'))) . " " . date('Y');
$this->excel->getActiveSheet()->setCellValue('A1', 'REKAP PEGAWAI PER PENDIDIKAN');
$this->excel->getActiveSheet()->setCellValue('A2', 'KEADAAN BULAN : ' . $keadaan);
$this->excel->setActiveSheetIndex(0)->mergeCells('A4:A5');
$this->excel->setActiveSheetIndex(0)->mergeCells('B4:N4');
$this->excel->setActiveSheetIndex(0)->mergeCells('P4:AB4');
$this->excel->setActiveSheetIndex(0)->mergeCells('O4:O5');
$this->excel->setActiveSheetIndex(0)->mergeCells('AC4:AC5');
$this->excel->getActiveSheet()->getStyle('B4:N4')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$this->excel->getActiveSheet()->getStyle('P4:AB4')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$this->excel->getActiveSheet()->getStyle('B5:N5')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$this->excel->getActiveSheet()->getStyle('P5:AB5')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$this->excel->getActiveSheet()->setCellValue('A4', 'UNOR');
$this->excel->getActiveSheet()->setCellValue('B4', 'LAKI LAKI');
$this->excel->getActiveSheet()->setCellValue('P4', 'PEREMPUAN');
$this->excel->getActiveSheet()->setCellValue('O4', 'TOTAL');
$this->excel->getActiveSheet()->setCellValue('AC4', 'TOTAL');
$max = $count;
$cell_bold = "A" . $max . ":K" . $max;
$this->excel->getActiveSheet()->getStyle($cell_bold)->getFont()->setBold(true);
$this->excel->getActiveSheet()->getStyle('A4:AC4')->getFont()->setBold(true);
$this->excel->getActiveSheet()->getStyle('A5:AC5')->getFont()->setBold(true);
$this->excel->getActiveSheet()->getStyle('A1:C1')->getFont()->setBold(true);
$this->excel->getActiveSheet()->getStyle('A2:C2')->getFont()->setBold(true);
$this->excel->getActiveSheet()->getStyle('A5:AC3')->getFont()->setBold(true);
$this->excel->getActiveSheet()->getStyle('A5:AC3')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$this->excel->getActiveSheet()->getStyle($rangeBorder)->applyFromArray($styleArray);
$this->excel->getActiveSheet()->setTitle('REKAP PEGAWAI PER PENDIDIKAN');
$this->excel->getActiveSheet()->fromArray($header, NULL, 'A5');
$this->excel->getActiveSheet()->fromArray($dataLaporan, NULL, 'A6');
#Footer
header('Set-Cookie: fileDownload=true; path=/');
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="' . $filename . '"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel5');
$objWriter->save('php://output');
die;
}
}
</p>
<p style="width:100%;text-align:justify">
Untuk itu, kami beritahukan agar Saudara segera melaporkan Pajak dengan mengisi dan menyampaikan SPTPD <b> paling lambat Tanggal 20 <?php
echo bulan(date('m')) . " " . date('Y');
?>
</b>. Apabila sampai dengan batas waktu tersebut dipenuhi, maka sesuai dengan Undang-Undang No. 28 Tahun 2009 tentang Pajak Daerah dan Retribusi dan Perda Kota Salatiga No.11 Tahun 2011 tentang Pajak daerah, maka SPTPD saudara <b><u>tidak dapat</u></b> kami terima dan selanjutnya akan <b><u>ditetapkan oleh petugas</u></b> sesuai dengan Peraturan Perundangan yang berlaku.
</p>
<p style="width:100%;text-align:justify">
Demikian atas perhatian dan kerjasamanya, kami mengucapkan terima kasih.
</p>
<br/>
<br/>
<div style="width:100%;margin-left:400px;">
Salatiga, <?php
echo date('d') . " " . bulan(date('m')) . " " . date('Y');
?>
</div>
<div style="width:100%;margin-left:400px;">
a.n Ka. DPPKAD Kota Salatiga
</div>
<table class="myTable" width="100%" cellpadding="0" border="0" >
<tr>
<td align="center" width="70px">Penerima</td><td align="center" width="100px">Kabid. Pendaftaran dan Pendataan</td>
</tr>
</table>
<br/>
<br/>
<br/>
while ($data = mysql_fetch_array($data_cetak)) {
++$no;
$bulan = date("m", strtotime($data['tanggal']));
$data_biaya = db_cetak_biaya_pertahun_bln($nip, $tahun, $bulan);
while ($datax = mysql_fetch_array($data_biaya)) {
$totna = "Rp. " . number_format($datax['totbiaya']);
$tot += $datax['totbiaya'];
}
?>
<tr>
<td style="text-align:center"><?php
echo $no . ".";
?>
</td>
<td style="text-align:left"><?php
echo bulan($bulan);
?>
</td>
<td><?php
echo $totna;
?>
</td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<td>
<th>Jumlah </th>
<th style="text-align:right"><?php
<?php
$bln = date("m");
$bulan = bulan($bln);
$id_jenisbahanpokok = $this->uri->segment(3);
?>
<div class="content-block">
<div class="container cont-pad-t-sm">
<div class="content-header">
<h1><?php
echo $data_komoditas[0]->nama_jenis_bahan_pokok;
?>
</h1>
</div>
<div class="row">
<div class="col-md-3">
<img style="min-width:100%;" class="img-responsive img-thumbnail" src="<?php
echo base_url('assets/uploads/' . $data_komoditas[0]->foto_jenis_bahan_pokok);
?>
">
</div>
<div class="col-md-3 text-center">
<div class="panel panel-danger">
<div class="panel-heading">
<h3 class="panel-title">Harga Maksimum</h3>
<span>Bulan <?php
echo $bulan;
?>
</span>
</div>
function get_employee_per_branch()
{
sleep(1);
$arr = array();
$bln = array();
$query = $this->db->query("SELECT DISTINCT DATE_FORMAT(created_at, '%Y-%m') \n AS Month, COUNT(staff_id)\n AS iCount FROM staffs GROUP BY Month ORDER BY Month ASC");
foreach ($query->result() as $row) {
$arr[] = $row->iCount;
$bln[] = bulan($row->Month);
}
$b = json_encode($bln);
$x = json_encode($arr);
$y = str_replace('"', '', $x);
$result = array($y, $b);
echo json_encode($bln);
}
