Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- global $db;
- // melakukan update pada data kunjungan per bulan per tahun
- $data_kunjungan_rows = $db->get_result("
- SELECT *
- FROM smis_rg_layananpasien
- WHERE MONTH(tanggal) = 1 AND YEAR(tanggal) = 2019
- LIMIT 0, 100
- ");
- if ($data_kunjungan_rows != null) {
- $nomor = 1;
- foreach ($data_kunjungan_rows as $data_kunjungan_row) {
- $uri = $data_kunjungan_row->uri;
- $ruangan = "";
- if ($uri == 1)
- $ruangan = $data_kunjungan_row->kamar_inap;
- else
- $ruangan = $data_kunjungan_row->jenislayanan;
- $jenis_kegiatan = "";
- if ($ruangan != "")
- $jenis_kegiatan = getSettings($db, "smis-rs-rl52-default-" . $ruangan, "");
- $db->query("
- UPDATE smis_rg_layananpasien
- SET jenis_kegiatan = '" . $jenis_kegiatan . "'
- WHERE id = '" . $data_kunjungan_row->id . "'
- ");
- echo $nomor . ". Data No. Reg. : " . $data_kunjungan_row->id . ", Tanggal Masuk : " . ArrayAdapter::format("date d-m-Y", $data_kunjungan_row->tanggal) . ", Jenis Kegiatan : " . $jenis_kegiatan . "<br/>";
- $nomor++;
- }
- echo "<br/>Total Data Diperbarui : " . ($nomor - 1);
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement