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