Cara Flashing Receiver KII Pro Dengan Menggunakan USB Burn Tool (Amlogic S905)

Karena tidak puas dengan firmware bawaan dari receiver KII Pro yang bermasalah di salah satu fitur, saya pun ingin mencoba menggunakan firmware lain yang sama hardwarenya cuma berbeda merk yang mengeluarkan aja, yaitu Acemax. Berikut langkah-langkah tutorialnya:

1. Download USB Burning Tool lalu install

2. Download Firmware Acemax KII_PRO_DTV-LMY47V-20160715.175256.V1031P3.img

Colokin KII Pro

2. Jalankan aplikasi USB Burning Tool

Semoga berguna

Read More

Libreelec 7.0.2 Untuk Receiver KII PRO Hybird (Amlogic S905) STB DVB-T2 DVB-S2

LibreELEC is ‘Just enough OS’ for Kodi, a Linux distribution built to run Kodi on current and popular mediacentre hardware. We are an evolution of the popular OpenELEC project. LibreELEC software will be familiar to OpenELEC users, but the project follows its own path and has intentional differences:
Download
LibreELEC-Amlogic.aarch64-KII_Pro-7.0.2.004.1

hi 
after test image LibreELEC-Amlogic.aarch64-KI_Plus-7.0.2.004.1.img.gz 
very stable
wifi .... OK
VDR .... OK
 tuner dvbs2 ..... Ok
cccam in OsCAM  ....... OK  Very fast to open an encrypted 
All HD audio formats are supported.

For HDMI:
Passthrough: DD, DD+, TrueHD, DTS, DTS96, DTS-HD, DTS-HR, Multichannel PCM
Transcoding to Multichannel PCM: DD, DD+, TrueHD, DTS, DTS96, DTS-HD, DTS-HR, DSD
Transcoding to DD:  TrueHD, DTS, DTS96, DTS-HD, DTS-HR, DSD

For SPDIF:
Passthrough: DD, DD+, DTS, DTS96
Transcoding to DD:  TrueHD, DTS, DTS96, DTS-HD, DTS-HR, Multichannel PCM, DSD




Cara Instalasi:

[sudo] password for netrunner:
/dev/sda1: UUID="161079E41079CB6F" TYPE="ntfs"
/dev/sda2: UUID="a021b31c-30c8-4bb9-8f5f-8ca150388c7d" TYPE="ext4"
/dev/sda5: UUID="1c8e9e69-e7e5-4ad9-8f84-6462fee91859" TYPE="swap"
/dev/sda6: LABEL="data" UUID="4679E7E5373CEAD5" TYPE="ntfs"
/dev/sda7: LABEL="raw" UUID="045A539A55C2705B" TYPE="ntfs"
/dev/sda8: LABEL="reencoding" UUID="5FF5375B7F8ADC7F" TYPE="ntfs"
/dev/sda9: LABEL="siapdiupload" UUID="edaf7af8-7af5-47bf-b9d3-e61627237d1a" TYPE="ext4"
/dev/zram0: UUID="409690de-3767-4bac-a2a5-7d521123ba1d" TYPE="swap"
/dev/zram1: UUID="a8554f6b-8e75-478f-a785-d796d7c225aa" TYPE="swap"
/dev/zram2: UUID="008967a2-70e7-4e64-ae99-0c437c83de83" TYPE="swap"
/dev/zram3: UUID="df7140e5-1dac-49bf-876d-2d262a1661a0" TYPE="swap"
/dev/sdb1: UUID="704D-153A" TYPE="vfat"
netrunner@netrunner-X455LA:~/KIIPro/Libreelec$ umount /dev/sdb
umount: /dev/sdb is not mounted (according to mtab)
netrunner@netrunner-X455LA:~/KIIPro/Libreelec$ sudo dd if=LibreELEC-Amlogic.aarch64-KII_Pro-7.0.2.004.1.img of=/dev/sdb bs=4M

SukaTunjukkan lebih banyak tanggapan

KomentariBagikan

5Riki Kurniawan, Arjuno Empat Mata, dan 3 lainnya

Komentar

Salim Mulyana 73+0 records in
73+0 records out
306184192 bytes (306 MB) copied, 55,7815 s, 5,5 MB/s

Suka · Balas · 6 Oktober pukul 19:09

Salim Mulyana To boot the system for the first time you have to use one of the following:
toothpick method: disconnect the power supply, insert card/drive, use a toothpick to push reset button and connect the power while holding the button. Wait until LibreELEC logo...Lihat Selengkapnya

Suka · Balas · 6 Oktober pukul 19:13

Cara booting KII Pro

Colok tombol recoveri dengan tusuk gigi lalu sambungkan kabel power

Cara Mencari channel

Read More

Cara Upgrade SIMRS Khanza HMS Dari Versi Agustus 2016 Ke Versi 16 September 2016

Aplikasi SIMRS (Sistem Informasi Managemen Rumah Sakit) Khanza HMS meskipun aplikasi gratisan ternyata pengembangannya sangat aktif, tiap bulan muncul update terbaru. Berikut cara update ke versi 16 september 2016.

Download file-file berikut ini:
Segera diupload nanti jam pocong

Cara Update:
1. Ekstrak file yang didownload tadi dan replace ke folder aplikasi Khanza, kalau saya letaknya di /opt/KhanzaHmsLinux (Saya menggunakan Netrunner Linux Frontier).
2. Update database Mysql: Buka browser dan navigasi ke phpmyadmin --> Pilih database sik --> sql

3. Paste script berikut ke kotak tersebut
DROP TABLE IF EXISTS `master_aturan_pakai`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `master_aturan_pakai` (
  `aturan` varchar(40) NOT NULL,
  PRIMARY KEY (`aturan`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `master_aturan_pakai`
--

LOCK TABLES `master_aturan_pakai` WRITE;
/*!40000 ALTER TABLE `master_aturan_pakai` DISABLE KEYS */;
INSERT INTO `master_aturan_pakai` VALUES ('3 x 1 Sehari'),('3 x 2 Sehari'),('3 x 3 Sehari Sebelum Makan');
/*!40000 ALTER TABLE `master_aturan_pakai` ENABLE KEYS */;
UNLOCK TABLES;



CREATE TABLE `set_alamat_pasien` (
`kelurahan` ENUM('true','false') NULL DEFAULT NULL,
`kecamatan` ENUM('true','false') NULL DEFAULT NULL,
`kabupaten` ENUM('true','false') NULL DEFAULT NULL
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
;


ALTER TABLE `operasi`
ADD COLUMN `dokter_pjanak` VARCHAR(20) NULL DEFAULT NULL AFTER `omloop3`,
ADD COLUMN `dokter_umum` VARCHAR(20) NULL DEFAULT NULL AFTER `dokter_pjanak`,
ADD COLUMN `biaya_dokter_pjanak` DOUBLE NULL DEFAULT NULL AFTER `biayasarpras`,
ADD COLUMN `biaya_dokter_umum` DOUBLE NULL DEFAULT NULL AFTER `biaya_dokter_pjanak`;

ALTER TABLE `operasi`
ADD CONSTRAINT `operasi_ibfk_50` FOREIGN KEY (`dokter_pjanak`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_51` FOREIGN KEY (`dokter_umum`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `operasi`
DROP FOREIGN KEY `operasi_ibfk_32`,
DROP FOREIGN KEY `operasi_ibfk_33`,
DROP FOREIGN KEY `operasi_ibfk_34`,
DROP FOREIGN KEY `operasi_ibfk_35`,
DROP FOREIGN KEY `operasi_ibfk_36`,
DROP FOREIGN KEY `operasi_ibfk_37`,
DROP FOREIGN KEY `operasi_ibfk_38`,
DROP FOREIGN KEY `operasi_ibfk_39`,
DROP FOREIGN KEY `operasi_ibfk_40`,
DROP FOREIGN KEY `operasi_ibfk_41`,
DROP FOREIGN KEY `operasi_ibfk_42`,
DROP FOREIGN KEY `operasi_ibfk_43`,
DROP FOREIGN KEY `operasi_ibfk_44`,
DROP FOREIGN KEY `operasi_ibfk_45`,
DROP FOREIGN KEY `operasi_ibfk_46`,
DROP FOREIGN KEY `operasi_ibfk_47`,
DROP FOREIGN KEY `operasi_ibfk_48`,
DROP FOREIGN KEY `operasi_ibfk_49`;
ALTER TABLE `operasi`
ADD CONSTRAINT `operasi_ibfk_32` FOREIGN KEY (`operator1`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_33` FOREIGN KEY (`operator2`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_34` FOREIGN KEY (`operator3`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_35` FOREIGN KEY (`asisten_operator1`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_36` FOREIGN KEY (`asisten_operator2`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_37` FOREIGN KEY (`instrumen`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_38` FOREIGN KEY (`dokter_anak`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_39` FOREIGN KEY (`perawaat_resusitas`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_40` FOREIGN KEY (`dokter_anestesi`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_41` FOREIGN KEY (`asisten_anestesi`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_42` FOREIGN KEY (`bidan`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_43` FOREIGN KEY (`perawat_luar`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_44` FOREIGN KEY (`kode_paket`) REFERENCES `paket_operasi` (`kode_paket`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_45` FOREIGN KEY (`bidan2`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_46` FOREIGN KEY (`bidan3`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_47` FOREIGN KEY (`omloop`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_48` FOREIGN KEY (`omloop2`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_49` FOREIGN KEY (`omloop3`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `user`
ADD COLUMN `temporary_presensi` ENUM('true','false') NULL DEFAULT NULL AFTER `retensi_rm`,
ADD COLUMN `jurnal_harian` ENUM('true','false') NULL DEFAULT NULL AFTER `temporary_presensi`,
ADD COLUMN `sirkulasi_obat2` ENUM('true','false') NULL DEFAULT NULL AFTER `jurnal_harian`,
ADD COLUMN `edit_registrasi` ENUM('true','false') NULL DEFAULT NULL AFTER `sirkulasi_obat2`;


ALTER TABLE `paket_operasi`
ADD COLUMN `dokter_pjanak` DOUBLE NULL DEFAULT NULL AFTER `sarpras`,
ADD COLUMN `dokter_umum` DOUBLE NULL DEFAULT NULL AFTER `dokter_pjanak`,
ADD COLUMN `kd_pj` CHAR(3) NULL DEFAULT NULL AFTER `dokter_umum`,
ADD COLUMN `status` ENUM('0','1') NULL DEFAULT NULL AFTER `kd_pj`,
ADD CONSTRAINT `paket_operasi_ibfk_1` FOREIGN KEY (`kd_pj`) REFERENCES `penjab` (`kd_pj`) ON UPDATE CASCADE;

ALTER TABLE `databarang`
ADD COLUMN `status` ENUM('0','1') NULL AFTER `expire`;

ALTER TABLE `detailbeli`
ADD COLUMN `no_batch` VARCHAR(10) NOT NULL AFTER `total`;

ALTER TABLE `detailpesan`
ADD COLUMN `no_batch` VARCHAR(10) NOT NULL AFTER `total`;

ALTER TABLE `detreturbeli`
ADD COLUMN `no_batch` VARCHAR(10) NOT NULL AFTER `total`;

ALTER TABLE `detreturjual`
DROP PRIMARY KEY;

ALTER TABLE `dokter`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `no_ijn_praktek`;

ALTER TABLE `dpjp_ranap`
DROP FOREIGN KEY `dpjp_ranap_ibfk_2`;
ALTER TABLE `dpjp_ranap`
ADD CONSTRAINT `dpjp_ranap_ibfk_2` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `gudangbarang`
DROP FOREIGN KEY `gudangbarang_ibfk_2`;
ALTER TABLE `gudangbarang`
ADD CONSTRAINT `gudangbarang_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `hemodialisa`
DROP FOREIGN KEY `hemodialisa_ibfk_3`;
ALTER TABLE `hemodialisa`
ADD CONSTRAINT `hemodialisa_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `jns_perawatan`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `kd_poli`;

ALTER TABLE `jns_perawatan_inap`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `kd_bangsal`;

ALTER TABLE `jns_perawatan_lab`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `kd_pj`;

ALTER TABLE `jns_perawatan_radiologi`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `kd_pj`;

ALTER TABLE `mutasibarang`
DROP FOREIGN KEY `mutasibarang_ibfk_1`;
ALTER TABLE `mutasibarang`
ADD CONSTRAINT `mutasibarang_ibfk_1` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `obat_penyakit`
DROP FOREIGN KEY `obat_penyakit_ibfk_2`;
ALTER TABLE `obat_penyakit`
ADD CONSTRAINT `obat_penyakit_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `opname`
DROP FOREIGN KEY `opname_ibfk_1`;
ALTER TABLE `opname`
ADD CONSTRAINT `opname_ibfk_1` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `paket_operasi`
DROP FOREIGN KEY `paket_operasi_ibfk_1`;
ALTER TABLE `paket_operasi`
ADD CONSTRAINT `paket_operasi_ibfk_1` FOREIGN KEY (`kd_pj`) REFERENCES `penjab` (`kd_pj`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `parkir`
DROP FOREIGN KEY `parkir_ibfk_1`,
DROP FOREIGN KEY `parkir_ibfk_2`;
ALTER TABLE `parkir`
ADD CONSTRAINT `parkir_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `parkir_ibfk_2` FOREIGN KEY (`kd_parkir`) REFERENCES `parkir_jenis` (`kd_parkir`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `pemasukan_lain`
DROP FOREIGN KEY `pemasukan_lain_ibfk_1`,
DROP FOREIGN KEY `pemasukan_lain_ibfk_2`;
ALTER TABLE `pemasukan_lain`
ADD CONSTRAINT `pemasukan_lain_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pemasukan_lain_ibfk_2` FOREIGN KEY (`kode_kategori`) REFERENCES `kategori_pemasukan_lain` (`kode_kategori`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `pembelian`
DROP FOREIGN KEY `pembelian_ibfk_1`,
DROP FOREIGN KEY `pembelian_ibfk_2`,
DROP FOREIGN KEY `pembelian_ibfk_3`,
DROP FOREIGN KEY `pembelian_ibfk_4`;
ALTER TABLE `pembelian`
ADD CONSTRAINT `pembelian_ibfk_1` FOREIGN KEY (`kode_suplier`) REFERENCES `datasuplier` (`kode_suplier`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pembelian_ibfk_2` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pembelian_ibfk_3` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pembelian_ibfk_4` FOREIGN KEY (`kd_rek`) REFERENCES `akun_bayar` (`kd_rek`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `pemesanan`
DROP FOREIGN KEY `pemesanan_ibfk_1`,
DROP FOREIGN KEY `pemesanan_ibfk_2`;
ALTER TABLE `pemesanan`
ADD CONSTRAINT `pemesanan_ibfk_1` FOREIGN KEY (`kode_suplier`) REFERENCES `datasuplier` (`kode_suplier`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pemesanan_ibfk_2` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `peminjaman_berkas`
DROP FOREIGN KEY `peminjaman_berkas_ibfk_2`,
DROP FOREIGN KEY `peminjaman_berkas_ibfk_3`;
ALTER TABLE `peminjaman_berkas`
ADD CONSTRAINT `peminjaman_berkas_ibfk_2` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `peminjaman_berkas_ibfk_3` FOREIGN KEY (`id_ruang`) REFERENCES `inventaris_ruang` (`id_ruang`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `pengeluaran_harian`
DROP FOREIGN KEY `pengeluaran_harian_ibfk_1`,
DROP FOREIGN KEY `pengeluaran_harian_ibfk_2`;
ALTER TABLE `pengeluaran_harian`
ADD CONSTRAINT `pengeluaran_harian_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pengeluaran_harian_ibfk_2` FOREIGN KEY (`kode_kategori`) REFERENCES `kategori_pengeluaran_harian` (`kode_kategori`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `penjualan`
DROP FOREIGN KEY `penjualan_ibfk_11`,
DROP FOREIGN KEY `penjualan_ibfk_12`,
DROP FOREIGN KEY `penjualan_ibfk_9`;
ALTER TABLE `penjualan`
ADD CONSTRAINT `penjualan_ibfk_11` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `penjualan_ibfk_12` FOREIGN KEY (`kd_rek`) REFERENCES `akun_bayar` (`kd_rek`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `penjualan_ibfk_9` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `periksa_lab`
DROP FOREIGN KEY `periksa_lab_ibfk_10`,
DROP FOREIGN KEY `periksa_lab_ibfk_11`,
DROP FOREIGN KEY `periksa_lab_ibfk_12`,
DROP FOREIGN KEY `periksa_lab_ibfk_13`;
ALTER TABLE `periksa_lab`
ADD CONSTRAINT `periksa_lab_ibfk_10` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_lab_ibfk_11` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_lab` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_lab_ibfk_12` FOREIGN KEY (`dokter_perujuk`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_lab_ibfk_13` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `periksa_radiologi`
DROP FOREIGN KEY `periksa_radiologi_ibfk_5`,
DROP FOREIGN KEY `periksa_radiologi_ibfk_6`,
DROP FOREIGN KEY `periksa_radiologi_ibfk_7`,
DROP FOREIGN KEY `periksa_radiologi_ibfk_8`;
ALTER TABLE `periksa_radiologi`
ADD CONSTRAINT `periksa_radiologi_ibfk_5` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_radiologi_ibfk_6` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_radiologi` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_radiologi_ibfk_7` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_radiologi_ibfk_8` FOREIGN KEY (`dokter_perujuk`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `petugas`
CHANGE COLUMN `password` `status` ENUM('0','1') NULL DEFAULT NULL AFTER `no_telp`;

ALTER TABLE `piutang`
DROP FOREIGN KEY `piutang_ibfk_1`,
DROP FOREIGN KEY `piutang_ibfk_3`;
ALTER TABLE `piutang`
ADD CONSTRAINT `piutang_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `piutang_ibfk_3` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `rawat_inap_dr`
DROP FOREIGN KEY `rawat_inap_dr_ibfk_3`,
DROP FOREIGN KEY `rawat_inap_dr_ibfk_6`;
ALTER TABLE `rawat_inap_dr`
ADD CONSTRAINT `rawat_inap_dr_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_inap_dr_ibfk_6` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_inap` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `rawat_inap_drpr`
DROP FOREIGN KEY `rawat_inap_drpr_ibfk_2`,
DROP FOREIGN KEY `rawat_inap_drpr_ibfk_3`,
DROP FOREIGN KEY `rawat_inap_drpr_ibfk_4`;
ALTER TABLE `rawat_inap_drpr`
ADD CONSTRAINT `rawat_inap_drpr_ibfk_2` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_inap` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_inap_drpr_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_inap_drpr_ibfk_4` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `rawat_inap_pr`
DROP FOREIGN KEY `rawat_inap_pr_ibfk_3`,
DROP FOREIGN KEY `rawat_inap_pr_ibfk_6`;
ALTER TABLE `rawat_inap_pr`
ADD CONSTRAINT `rawat_inap_pr_ibfk_3` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_inap_pr_ibfk_6` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_inap` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `rawat_jl_dr`
DROP FOREIGN KEY `rawat_jl_dr_ibfk_2`,
DROP FOREIGN KEY `rawat_jl_dr_ibfk_3`;
ALTER TABLE `rawat_jl_dr`
ADD CONSTRAINT `rawat_jl_dr_ibfk_2` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_jl_dr_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `rawat_jl_drpr`
DROP FOREIGN KEY `rawat_jl_drpr_ibfk_2`,
DROP FOREIGN KEY `rawat_jl_drpr_ibfk_3`,
DROP FOREIGN KEY `rawat_jl_drpr_ibfk_4`;
ALTER TABLE `rawat_jl_drpr`
ADD CONSTRAINT `rawat_jl_drpr_ibfk_2` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_jl_drpr_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_jl_drpr_ibfk_4` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `rawat_jl_pr`
DROP FOREIGN KEY `rawat_jl_pr_ibfk_10`,
DROP FOREIGN KEY `rawat_jl_pr_ibfk_9`;
ALTER TABLE `rawat_jl_pr`
ADD CONSTRAINT `rawat_jl_pr_ibfk_10` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_jl_pr_ibfk_9` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `reg_periksa`
DROP FOREIGN KEY `reg_periksa_ibfk_3`,
DROP FOREIGN KEY `reg_periksa_ibfk_4`,
DROP FOREIGN KEY `reg_periksa_ibfk_6`;
ALTER TABLE `reg_periksa`
ADD CONSTRAINT `reg_periksa_ibfk_3` FOREIGN KEY (`kd_poli`) REFERENCES `poliklinik` (`kd_poli`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `reg_periksa_ibfk_4` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `reg_periksa_ibfk_6` FOREIGN KEY (`kd_pj`) REFERENCES `penjab` (`kd_pj`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `resep_obat`
DROP FOREIGN KEY `resep_obat_ibfk_4`;
ALTER TABLE `resep_obat`
ADD CONSTRAINT `resep_obat_ibfk_4` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `resep_pulang`
DROP FOREIGN KEY `resep_pulang_ibfk_2`;
ALTER TABLE `resep_pulang`
ADD CONSTRAINT `resep_pulang_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `returbeli`
DROP FOREIGN KEY `returbeli_ibfk_2`,
DROP FOREIGN KEY `returbeli_ibfk_3`,
DROP FOREIGN KEY `returbeli_ibfk_4`;
ALTER TABLE `returbeli`
ADD CONSTRAINT `returbeli_ibfk_2` FOREIGN KEY (`kode_suplier`) REFERENCES `datasuplier` (`kode_suplier`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `returbeli_ibfk_3` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `returbeli_ibfk_4` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `returpasien`
DROP FOREIGN KEY `returpasien_ibfk_4`;
ALTER TABLE `returpasien`
ADD CONSTRAINT `returpasien_ibfk_4` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `returpiutang`
DROP FOREIGN KEY `returpiutang_ibfk_3`,
DROP FOREIGN KEY `returpiutang_ibfk_5`;
ALTER TABLE `returpiutang`
ADD CONSTRAINT `returpiutang_ibfk_3` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `returpiutang_ibfk_5` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `rujuk`
DROP FOREIGN KEY `rujuk_ibfk_2`;
ALTER TABLE `rujuk`
ADD CONSTRAINT `rujuk_ibfk_2` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `rujukanranap_dokter_rs`
DROP FOREIGN KEY `rujukanranap_dokter_rs_ibfk_1`;
ALTER TABLE `rujukanranap_dokter_rs`
ADD CONSTRAINT `rujukanranap_dokter_rs_ibfk_1` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `set_nota`
ADD COLUMN `tampilkan_tombol_nota_ralan` ENUM('Yes','No') NULL DEFAULT NULL AFTER `tampilkan_ppnobat_ranap`,
ADD COLUMN `tampilkan_tombol_nota_ranap` ENUM('Yes','No') NULL DEFAULT NULL AFTER `tampilkan_tombol_nota_ralan`;

ALTER TABLE `set_tarif`
ADD COLUMN `cara_bayar_operasi` ENUM('Yes','No') NULL DEFAULT NULL AFTER `cara_bayar_radiologi`;

ALTER TABLE `stok_obat_pasien`
DROP FOREIGN KEY `stok_obat_pasien_ibfk_2`;
ALTER TABLE `stok_obat_pasien`
ADD CONSTRAINT `stok_obat_pasien_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `tampreturbeli`
ADD COLUMN `no_batch` VARCHAR(10) NOT NULL AFTER `total`;
ALTER TABLE `tampreturbeli`
DROP FOREIGN KEY `tampreturbeli_ibfk_2`;
ALTER TABLE `tampreturbeli`
ADD CONSTRAINT `tampreturbeli_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `tampreturjual`
DROP FOREIGN KEY `tampreturjual_ibfk_3`;
ALTER TABLE `tampreturjual`
ADD CONSTRAINT `tampreturjual_ibfk_3` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE `tampreturpiutang`
DROP FOREIGN KEY `tampreturpiutang_ibfk_2`;
ALTER TABLE `tampreturpiutang`
ADD CONSTRAINT `tampreturpiutang_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;

update dokter set status='1';
update paket_operasi set status='1';
update databarang set status='1';
update jns_perawatan set status='1';
update jns_perawatan_inap set status='1';
update jns_perawatan_lab set status='1';
update jns_perawatan_radiologi set status='1';
update petugas set status='1';

3. Klik go, tunggu sampai selesai

Semoga berguna

Read More

Cara Update Firmware KII PRO Hybird STB DVB-T2 DVB-S2 TV BOX Android 5.1.1 S905 2G/16G 802.11AC WIFI LAN KODI Bluetooth

Download firmware 1 September 2016






Firmware lainnya:
18 Mei 2016
15 Juli 2016 
IMG

Read More

Review KII PRO Hybird STB DVB-T2 DVB-S2 TV BOX Android 5.1.1 S905 2G/16G 802.11AC WIFI LAN KODI Bluetooth

Akhirnya barang saya yang dibeli via geekbuying.com dari Hong Kong yang berupa receiver Android combo DVB-T2 dan DVB-S2 yaitu KII Pro Hybird STB DVB-T2 DVB-S2 TV BOX Android 5.1.1 S905 2G/16G 802.11AC WIFI LAN KODI Bluetooth. 

Proses pengiriman dari Hong Kong sampai ke rumah memakan waktu sekitar 17 harian, inilah penampakan barangnya

Penampilan dus nya

Fiturnya:
OS Android 5.1.1
Prosesor Amlogic S905 QuadCore
GPU Penta Core Mali
Ram 2 GB DDR3
Internal Memory 16 GB
Support resolusi 4K
Support Codec HEVC/ H265
LAN

Dalam paket pembeliannya disertakan:
Receiver KII Pro
Remote Control
Buku Manual
Adaptor dengan konektor 3 macam

Penampilan panel belakang
Ada port LNB
Port Antenna UHF
LAN
HDMI

Di body samping disediakan port USB 4, dan slot micro SD

Tampilan pas masuk menu TV

Semoga berguna

Read More

Cara Install Oracle Java 8U5 Secara Manual Pada Netrunner Linux Frontier 64 Bit (Ubuntu 14.04)

Untuk menjalankan secara benar aplikasi SIMRS saya membutuhkan aplikasi Oracle Java 8U5 terinstall di system Netrunner Linux Frontier 64 Bit. Beginilah langkah-langkahnya:

Jalankan terminal, lalu ketik perintah-perintah berikut ini:

wget --header "Cookie: oraclelicense=accept-securebackup-cookie" http://download.oracle.com/otn-pub/java/jdk/8u5-b13/jdk-8u5-linux-x64.tar.gz

 sudo su

 mkdir /opt/jdk

  tar -zxf jdk-8u5-linux-x64.tar.gz -C /opt/jdk

  ls /opt/jdk

  update-alternatives --install /usr/bin/java java /opt/jdk/jdk1.8.0_05/bin/java 100

  update-alternatives --install /usr/bin/javac javac /opt/jdk/jdk1.8.0_05/bin/javac 100

Sumber:
https://www.digitalocean.com/community/tutorials/how-to-manually-install-oracle-java-on-a-debian-or-ubuntu-vps

Read More

Cara Mengatasi Notifikasi : java.lang.UnsupportedOperationException: The BROWSE action is not supported on the current platform! Pada Aplikasi SIMRS Khanza HMS 16 September 2016

Pada saat akan memcetak resume pasien di aplikasi SIMRS Khanza HMS ternyata tidak bisa, dan muncul error di kotak hitamnya yaitu

Notifikasi : java.lang.UnsupportedOperationException: The BROWSE action is not supported on the current platform!

Komputer yang saya gunakan bersistem Operasi Netrunner Linux Frontier dengan java versi:
java version "1.8.0_101"
Java(TM) SE Runtime Environment (build 1.8.0_101-b13)
Java HotSpot(TM) 64-Bit Server VM (build 25.101-b13, mixed mode)

Solusinya: Downgrade versi javanya ke versi Oracle Java 8U5, tutornya di http://drsalimmulyana.blogspot.com/2016/10/cara-install-oracle-java-8u5-secara.html

Semoga berguna

Read More

Pengalaman Berbelanja Receiver DVB-S2 dan T2 Combo KII Pro Dari Geekbuying

Awalnya saya melihat postingan facebook dari fan page MMP - Mitra Media Perkasa, PT yang mempromosikan produk terbaru mereka yaitu Jakarta Triple Combo Box lengkap dengan spesifikasinya, tetapi ada yang komentar bahwa ramnya cuma 1 giga. Akhirnya saya mencari alternatif lain Combo Box yang RAM nya 2 giga, jatuhlah pilihan saya pada produk KII Pro, kebetulan produk ini di jual di situs geekbuying.com http://www.geekbuying.com/item/KII-PRO-Hybird-STB-DVB-T2-S2-TV-BOX-370527.html, harga lumayan murah cuma 85 dollar, gratis ongkos kirim

Saya membeli barang tersebut menggunakan saldo paypal yang saya punya pada tanggal 15 agustus 2016, barang sampai ke rumah dengan aman tanggal 01 Oktober 2016 dengan membayar 50 ribu saja ke pak pos, beginilah hasil tracking selama 15 hari perjalanan.
Beginilah penampakan barangnya

Hasil tracking dari situs http://www.17track.net/en

2016-10-01 12:37

KARAWANG 41300, Final delivery

2016-10-01 06:33

Karawang 41300, Attempted to deliver

2016-10-01 06:30

KARAWANG 41300, Arrival at delivery/Transit Office

2016-09-30 10:15

KARAWANG 41300, Departure from inward OE Adpis : 41385

2016-09-30 08:41

Karawang 41300, Arrival at delivery/Transit Office

2016-09-29 09:10

MPCBANDUNG 40400, Departure from inward OE Adpis : 41300

2016-09-27 16:41

MPCBandung 40400, Release / Release by custom

2016-09-24 10:33

MPCBANDUNG 40400, Arrival at delivery/Transit Office

2016-09-23 14:53

MPCJakarta 10900, Departure from inward OE Adpis : 40400

2016-09-23 10:11

MPC Jakarta IDJKTC, Airport Handling

2016-09-23 09:41

MPC Jakarta IDJKTC, Arrival at inward OE

2016-09-20 13:28

HONG KONG HK, Departure from outward OE

2016-09-17 14:23

HONG KONG HK, Posting/Collection

Origin Country - Tracking Consuming: 357 ms

2016-10-01 00:00

Indonesia, The item (RT328498080HK) was delivered on 1-Oct-2016.

Tracking dari posindonesia.com

THE STATUS OF THE SHIPMENT

The Shipment Barcode RT328498080HK Service Registered / Tercatat Internasional From HONG KONG - HK To ID Detail Status No. Office Date Time Status 1 HONG KONG - HK 2016-09-17 14:23 Posting/Collection 2 HONG KONG - HK 2016-09-20 13:28 Departure from outward OE 3 MPC JAKARTA - IDJKTC 2016-09-23 09:41 Arrival at inward OE 4 MPC JAKARTA - IDJKTC 2016-09-23 10:11 Airport Handling 5 MPCJAKARTA - 10900 2016-09-23 14:53 Departure from inward OE 6 MPCBANDUNG - 40400 2016-09-24 10:33 Arrival at delivery/Transit Office 7 MPCBANDUNG - 40400 2016-09-27 16:41 Release / Release by custom 8 MPCBANDUNG - 40400 2016-09-29 09:10 Departure from inward OE 9 KARAWANG - 41300 2016-09-30 08:41 Arrival at delivery/Transit Office 10 KARAWANG - 41300 2016-09-30 10:15 Departure from inward OE 11 KARAWANG - 41300 2016-10-01 06:30 Arrival at delivery/Transit Office 12 KARAWANG - 41300 2016-10-01 06:33 Attempted to deliver 13 KARAWANG - 41300 2016-10-01 12:37 Final delivery, Received By : SUGIARTI

Read More