<center><?php
echo strtoupper($title);
?>
<br/><?php
echo strtoupper(get_day($tanggal)) . ', ' . strtoupper(indo_tgl($tanggal));
?>
</center>
<div id='box'>
<div id="holder">
<div class="boxes">
<table style="min-width: 100%;" class="daily-program">
<tr>
<th width="10%" style="text-align: center;"><?php
echo datefmysql($tanggal);
?>
</th>
<th width="80%">
<div id="trackWrapper">
<div class='slider1'></div>
<div class='slider2'></div>
<ul class='track'>
<?php
$range = array('00:00', '01:00', '02:00', '03:00', '04:00', '05:00', '06:00', '07:00', '08:00', '09:00', '10:00', '11:00', '12:00', '13:00', '14:00', '15:00', '16:00', '17:00', '18:00', '19:00', '20:00', '21:00', '22:00', '23:00');
//foreach ($range as $i => $time) {
$awal = array_search($time_range->awal, $range);
$akhir = array_search($time_range->akhir, $range);
//echo (100/($akhir-$awal)).'<br/>';
for ($i = $awal; $i <= $akhir; $i++) {
?>
?>
</td>
<td align="center"><?php
echo $rows->id;
?>
</td>
<td align="center"><?php
echo $rows->id_transaksi;
?>
</td>
<td><?php
echo $rows->anggota;
?>
</td>
<td align="center"><?php
echo datefmysql($rows->tgl_bayar);
?>
</td>
<td><?php
echo $rows->nama;
?>
</td>
<td align="right"><?php
echo rupiah($rows->jml_tagihan);
?>
</td>
</tr>
<?php
}
?>
</table>
function get_list_rencana_penggunaan_jt($limit, $start, $search)
{
$limitation = NULL;
if ($limit !== NULL) {
$limitation = " limit {$start} , {$limit}";
}
$q = NULL;
if ($search['bulan'] !== '') {
$q .= " and tanggal like ('%" . $search['bulan'] . "%')";
}
$select = " select *, SUBSTR(sas,1,5) as sas, SUBSTR(laks,1,5) as laks, TIMEDIFF(laks, sas) AS selisih, \r\n TIME_TO_SEC(laks)-TIME_TO_SEC(sas) as status, TIME_TO_SEC(laks) as sec_laks\r\n ";
$count = "select count(id) as count ";
$sql = "from tb_rencana_penggunaan_jt\r\n where id is not NULL\r\n {$q}";
$order = " order by tanggal asc";
$query = $this->db->query($select . $sql . $order . $limitation)->result();
$result = array();
foreach ($query as $key => $data) {
$sql_sorties = "select count(c.id) as total \r\n from tb_configuration c\r\n join tb_flight_formasi f on (c.id_flight_formasi = f.id)\r\n where f.tanggal = '" . $data->tanggal . "' \r\n and c.jam_ops_total is not NULL\r\n and c.jam_ops_total != '00:00:00'";
$sorties = $this->db->query($sql_sorties)->row()->total;
$sql_laks = "select IFNULL(SUBSTR(SEC_TO_TIME(sum(TIME_TO_SEC(c.jam_ops_total))),1,5),'00:00') as total \r\n from tb_configuration c\r\n join tb_flight_formasi ff on (c.id_flight_formasi = ff.id)\r\n where ff.tanggal = '" . $data->tanggal . "' \r\n and c.jam_ops_total is not NULL\r\n ";
$laks = $this->db->query($sql_laks)->row()->total;
$result[] = array('id' => $data->id, 'date' => $data->tanggal, 'tanggal' => datefmysql($data->tanggal), 'hari' => get_day($data->tanggal), 'rencana' => isset($data->sas) ? $data->sas : '00:00', 'sas' => $data->sas, 'laks' => $laks, 'selisih' => $data->is_update === 'Sudah' ? $data->selisih : '<span class="label label-warning">Belum Update</span>', 'status' => $data->status !== NULL ? $data->status : 0, 'hasil' => abs($data->status), 'sec_laks' => $data->sec_laks !== NULL ? $data->sec_laks : 0, 'sorties' => $sorties, 'report_laks' => $data->laks, 'is_update' => $data->is_update);
$return['data'] = $result;
}
$return['sas_bulan_ini'] = $this->db->query("select IFNULL(SEC_TO_TIME(SUM(TIME_TO_SEC(sas))),'00:00') as total_sas from tb_rencana_penggunaan_jt where tanggal like ('%" . $search['bulan'] . "%')")->row()->total_sas;
$sql_yll = "select IFNULL(SUM(TIME_TO_SEC(laks))-SUM(TIME_TO_SEC(sas)),0) as total \r\n from tb_rencana_penggunaan_jt \r\n where tanggal < '" . $search['bulan'] . "-01' \r\n and YEAR(tanggal) = SUBSTR('" . $search['bulan'] . "',1,4)";
$return['pm_bln_yll'] = $this->db->query($sql_yll)->row()->total;
$sql_total_yll = "select IFNULL(SUM(TIME_TO_SEC(laks)),0) as total \r\n from tb_rencana_penggunaan_jt \r\n where tanggal < '" . $search['bulan'] . "-01' \r\n and YEAR(tanggal) = SUBSTR('" . $search['bulan'] . "',1,4)";
$return['ttl_thn_yll'] = $this->db->query($sql_total_yll)->row()->total;
$sql_sort_ly = "select count(c.id) as total \r\n from tb_configuration c\r\n join tb_flight_formasi f on (c.id_flight_formasi = f.id)\r\n where f.tanggal < '" . $search['bulan'] . "-01' and YEAR(f.tanggal) = SUBSTR('" . $search['bulan'] . "',1,4)\r\n and c.jam_ops_total is not NULL\r\n and c.jam_ops_total != '00:00:00'\r\n ";
$return['ttl_sor_tyll'] = $this->db->query($sql_sort_ly)->row()->total;
$return['jumlah'] = $this->db->query($count . $sql . $q)->row()->count;
//die(json_encode($return));
return $return;
}
?>
</td>
<td><?php
echo $value->no_pendaftaran;
?>
</td>
<td><?php
echo $value->nama;
?>
</td>
<td><?php
echo $value->tempat;
?>
</td>
<td><?php
echo datefmysql($value->tanggal_lahir);
?>
</td>
<td><?php
echo $value->agama;
?>
</td>
<td><?php
echo $value->jekel;
?>
</td>
<td><?php
echo $value->alamat;
?>
</td>
<td><?php
<th width="10%" class="left">Tanggal</th>
<th width="30%" class="left">Judul</th>
<th width="50%" class="left">Keterangan</th>
</tr>
</thead>
<tbody>
<?php
foreach ($data as $key => $value) {
?>
<tr>
<td align="center"><?php
echo ++$key;
?>
</td>
<td><?php
echo datefmysql($value->tanggal);
?>
</td>
<td><?php
echo $value->judul;
?>
</td>
<td><?php
echo $value->keterangan;
?>
</td>
</tr>
<?php
}
?>
</tbody>
foreach ($data as $key => $value) {
?>
<tr valign="top">
<td align="center"><?php
echo ++$key;
?>
</td>
<td><?php
echo $value->nama;
?>
</td>
<?php
foreach ($value->penerbang as $value2) {
$nilai = array();
foreach ($value2->tanggal as $value3) {
$nilai[] = datefmysql($value3->tanggal) . ' ';
}
$hasil = implode('<br/>', $nilai);
?>
<td align="center"><?php
echo count($nilai);
?>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
?>
">
<td align="center"><?php
echo ++$key;
?>
</td>
<td align="center"><?php
echo datefmysql($data->tanggal);
?>
</td>
<td align="center"><?php
echo $data->faktur;
?>
</td>
<td align="center"><?php
echo datefmysql($data->jatuh_tempo);
?>
</td>
<td><?php
echo $data->supplier;
?>
</td>
<td align="right"><?php
echo rupiah($data->total);
?>
</td>
<td align="right"><?php
echo rupiah($data->terbayar);
?>
</td>
?>
">
<td align="center"><?php
echo ++$key;
?>
</td>
<td align="center"><?php
echo $data->no_ref;
?>
</td>
<td align="center"><?php
echo $data->faktur;
?>
</td>
<td align="center"><?php
echo datefmysql($data->tanggal);
?>
</td>
<td><?php
echo $data->supplier;
?>
</td>
<td align="center"><?php
echo $data->cara_bayar;
?>
</td>
<td><?php
echo $data->bank;
?>
</td>
<td align="center"><?php
<tbody>
<?php
$limit = 10;
$page = $_GET['page'];
if ($_GET['page'] === '') {
$page = 1;
$offset = 0;
} else {
$offset = ($page - 1) * $limit;
}
$param = array('id' => $_GET['id_karyawan'], 'limit' => $limit, 'start' => $offset, 'search' => $_GET['search']);
$list_data = load_data_karyawan($param);
$master_barang = $list_data['data'];
$total_data = $list_data['total'];
foreach ($master_barang as $key => $data) {
$str = $data->id . '#' . $data->nama . '#' . $data->kelamin . '#' . $data->tempat_lahir . '#' . datefmysql($data->tanggal_lahir) . '#' . $data->alamat . '#' . $data->kabupaten . '#' . $data->propinsi . '#' . $data->telp . '#' . $data->email . '#' . $data->jabatan . '#' . $data->no_sipa;
?>
<tr class="<?php
echo $key % 2 == 0 ? 'even' : 'odd';
?>
">
<td align="center"><?php
echo ++$key + $offset;
?>
</td>
<td><?php
echo $data->nama;
?>
</td>
<td align="center"><?php
echo $data->kelamin;
echo $profile->nama_depan;
?>
" class="form-control" />
</div>
<div class="col-md-4">
<input type="text" name="nama_belakang" id="nama_belakang" value="<?php
echo $profile->nama_belakang;
?>
" class="form-control" />
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3">Tanggal Lahir</label>
<div class="col-md-8">
<input type="text" name="tanggal_lahir" id="tanggal_lahir" value="<?php
echo datefmysql($profile->tanggal_lahir);
?>
" class="form-control" />
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3">Nomor HP</label>
<div class="col-md-8">
<input type="text" name="telp" id="telp" value="<?php
echo $profile->telp;
?>
" class="form-control" />
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3">Jenis Kelamin*</label>
?>
</td>
<td align="center"><?php
echo datetimefmysql($data->waktu);
?>
</td>
<td><?php
echo $data->nama . ' ' . $data->kekuatan . ' ' . $data->satuan_kekuatan;
?>
</td>
<td><?php
echo $data->nobatch;
?>
</td>
<td align="center"><?php
echo datefmysql($data->ed);
?>
</td>
<td align="center"><?php
echo isset($awalnya->awal) ? $awalnya->awal : '0';
?>
</td>
<td align="center"><?php
echo $data->masuk;
?>
</td>
<td align="center"><?php
echo $data->keluar;
?>
</td>
<td align="center"><?php
?>
</div>
</div>
<div class="form-group">
<label class="col-lg-3 control-label">Tanggal Lahir:</label>
<div class="col-lg-8">
<?php
echo form_input('tgllahir', isset($rows->tgl_lahir) ? datefmysql($rows->tgl_lahir) : null, 'id=tgllahir class="special form-control"');
?>
</div>
</div>
<div class="form-group">
<label class="col-lg-3 control-label">Tanggal Daftar:</label>
<div class="col-lg-8">
<?php
echo form_input('tgldaftar', isset($rows->tgl_masuk) ? datefmysql($rows->tgl_masuk) : null, 'id=tgldaftar class="special form-control"');
?>
</div>
</div>
<div class="form-group">
<label class="col-lg-3 control-label">Sewa:</label>
<div class="col-lg-8">
<?php
echo form_dropdown('sewa', $boolean, isset($rows->sewa) ? $rows->sewa : null, ' class="form-control"');
?>
</div>
</div>
<div class="form-group">
<label class="col-lg-3 control-label">Status:</label>
<div class="col-lg-8">
<?php
?>
</td>
<td><?php
echo $rows->kd_buku;
?>
</td>
<td><?php
echo $rows->judul;
?>
</td>
<td align="right"><?php
echo number_format($rows->hrg_sewa);
?>
</td>
<td align="center"><?php
echo datefmysql($rows->tgl_kembali);
?>
</td>
<td align="center"><?php
echo $rows->lama_sewa;
?>
</td>
<td align="center"><?php
echo $checked;
?>
</td>
<td align="center"><?php
echo $rows->selisih;
?>
</td>
<td align="right"><?php
?>
</td>
<td><?php
echo isset($data->nama) ? $data->nama : NULL;
?>
</td>
<td align="center"><?php
echo $data->no_antri;
?>
</td>
<td><?php
echo $data->spesialisasi;
?>
</td>
<td align="center"><?php
echo datefmysql($data->waktu_pelayanan, 'yes');
?>
</td>
<td><?php
echo $data->dokter;
?>
</td>
<td>
<ul>
<?php
foreach ($rek_tindakan as $rows) {
?>
<li><?php
echo $rows->nama;
?>
</li>
?>
</td>
<td align="center"><?php
echo datefmysql($data->tanggal);
?>
</td>
<td><?php
echo $data->barang . ' ' . $data->kekuatan . ' ' . $data->satuan;
?>
</td>
<td align="center"><?php
echo $data->kemasan;
?>
</td>
<td align="center"><?php
echo datefmysql($data->expired);
?>
</td>
<td align="center"><?php
echo $data->jumlah;
?>
</td>
<td class='aksi' align='center'>
<!--<a class='edition' onclick="edit_retur_penerimaan('<?php
echo $str;
?>
');" title="Klik untuk edit retur_penerimaan"> </a>-->
<a class='deletion' onclick="delete_retur_penerimaan('<?php
echo $data->id;
?>
','<?php
?>
</td>
<td><?php
echo $value->satuan;
?>
</td>
<td align="center"><?php
echo $value->volume;
?>
</td>
<td align="right"><?php
echo formatcurrency($value->nominal);
?>
</td>
<td align="center"><?php
echo datefmysql($value->tanggal_kegiatan);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<br/>
<table align="right" width="100%">
<!--<tr><td width="100%" colspan="3" align="right"><?php
echo $attr->kabupaten;
?>
, <?php
<tbody>
<?php
$limit = 10;
$page = $_GET['page'];
if ($_GET['page'] === '') {
$page = 1;
$offset = 0;
} else {
$offset = ($page - 1) * $limit;
}
$param = array('id' => $_GET['id_dokter'], 'limit' => $limit, 'start' => $offset, 'search' => $_GET['search']);
$list_data = load_data_dokter($param);
$master_dokter = $list_data['data'];
$total_data = $list_data['total'];
foreach ($master_dokter as $key => $data) {
$str = $data->id . '#' . $data->nama . '#' . $data->kelamin . '#' . $data->alamat . '#' . $data->telp . '#' . $data->profesi . '#' . $data->no_str . '#' . $data->spesialis . '#' . datefmysql($data->tgl_mulai_praktek) . '#' . $data->fee;
?>
<tr class="<?php
echo $key % 2 == 0 ? 'even' : 'odd';
?>
">
<td align="center"><?php
echo ++$key + $offset;
?>
</td>
<td><?php
echo $data->nama;
?>
</td>
<td align="center"><?php
echo $data->kelamin;
<tbody>
<?php
$limit = 10;
$page = $_GET['page'];
if ($_GET['page'] === '') {
$page = 1;
$offset = 0;
} else {
$offset = ($page - 1) * $limit;
}
$param = array('id' => $_GET['id_pelanggan'], 'limit' => $limit, 'start' => $offset, 'search' => $_GET['search']);
$list_data = load_data_customer($param);
$master_barang = $list_data['data'];
$total_data = $list_data['total'];
foreach ($master_barang as $key => $data) {
$str = $data->id . '#' . $data->nama . '#' . $data->jenis . '#' . $data->kelamin . '#' . $data->tempat_lahir . '#' . datefmysql($data->tanggal_lahir) . '#' . $data->alamat . '#' . $data->telp . '#' . $data->email . '#' . $data->diskon . '#' . $data->catatan . '#' . $data->id_asuransi . '#' . $data->nopolish . '#' . $data->kabupaten . '#' . $data->provinsi;
?>
<tr class="<?php
echo $key % 2 == 0 ? 'even' : 'odd';
?>
">
<td align="center"><?php
echo ++$key + $offset;
?>
</td>
<td align="center"><?php
echo $data->id;
?>
</td>
<td><span title="<img src='img/pelanggan/<?php
echo $data->foto;
