query( $s ); $r = $h->fetchAll()[0]; $sql ='SELECT nama_kota as kabupaten from m_kota where idprovinsi=\'' . $r['idprovinsi'] . '\' order by nama_kota'; $hasil = $db->query( $sql ); foreach($hasil->fetchAll() as $row) { extract( $row ); echo' '; } } ///////////////// AWAL RL2 //////////////////// if ($reqdata == 'save_rl2') { $sql3 = $db->query('SELECT code_list as kode from m_rl2 where description=\'' . $tenaga . '\'' ); $r3 = $sql3->fetchAll()[0]; extract( $r3 ); $sql = $db->query('SELECT code_list from rl2 where kode_rs=\'' . $koders . '\' and code_list=\'' . $kode . '\' and smt=\'' . $smt . '\' and tahun=\'' . $tahun . '\'' ); $r = $sql->numRows(); if (1 <= $r) { if (!empty( $kode )) { $sql = $db->query('update RL2 set tetap=\'' . $tetap . '\',tidak_tetap=\'' . $t_tetap . '\',tahun=\'' . $tahun . '\' where code_list=\'' . $kode . '\' and tahun=\'' . $tahun1 . '\' and smt=\'' . $smt1 . '\'' ); } else { echo 'Data Tenaga ' . $tenaga . ' Sudah ada, silahkan klik icon update pada tabel untuk Update Data'; } } else { $sql = $db->query('INSERT INTO rl2 (code_list,tetap,tidak_tetap,kode_rs,smt,tahun) values(\'' . $kode . '\',\'' . $tetap . '\',\'' . $t_tetap . '\',\'' . $koders . '\',\'' . $smt . '\',\'' . $tahun . '\')' ); echo 'Data Tenaga ' . $tenaga . ' Sudah Tersimpan'; } $sql2 = $db->query('SELECT a.code_list,a.tetap,a.tidak_tetap,a.kode_rs,a.smt,a.tahun,b.description from rl2 a left join m_rl2 b on b.code_list=a.code_list where kode_rs=\'' . $koders . '\'' ); echo ''; foreach ($sql2->fetchAll() as $row) { extract( $row ); $total = $tetap + $tidak_tetap; if ($smt == 1) { $semt = 'I'; } else { $semt = 'II'; } echo ' '; } $sql_s = $db->query('SELECT SUM(tetap) as tetap1, SUM(tidak_tetap) as t_tetap1 from rl2 where kode_rs=\'' . $koders . '\' and smt=\'1\'' ); $r_s = $sql_s->fetchAll()[0]; extract( $r_s ); $total_1 = $tetap1 + $t_tetap1; $sql_s2 = $db->query('SELECT SUM(tetap) as tetap2, SUM(tidak_tetap) as t_tetap2 from rl2 where kode_rs=\'' . $koders . '\' and smt=\'2\'' ); $r_s2 = $sql_s2->fetchAll()[0]; extract( $r_s2 ); $total_2 = $tetap2 + $t_tetap2; echo' '; echo '
KodeTenagaJumlah TenagaTetapTidak TetapSemesterTahun-
' . $code_list . '' . $description . '' . $total . '' . $tetap . '' . $tidak_tetap . '' . $semt . '' . $tahun . ' 
Jumlah Tenaga Semester I : ' . $total_1 . '' . $tetap1 . '' . $t_tetap1 . ' 
Jumlah Tenaga Semester II : ' . $total_2 . '' . $tetap2 . '' . $t_tetap2 . ' 
'; } if ($reqdata == 'pencarian_rl2') { if (empty( $nama )) { $sql = $db->query('SELECT a.code_list,a.tetap,a.tidak_tetap,a.kode_rs,a.smt,a.tahun,b.description from rl2 a left join m_rl2 b on b.code_list=a.code_list where a.kode_rs=\'' . $koders . '\'' );; } else { if (!empty( $nama )) { $sql3 = $db->query('SELECT code_list as kode from m_rl2 where description=\'' . $nama . '\'' );; $r3 = $sql3->fetchAll()[0]; extract( $r3 ); $sql = $db->query('SELECT a.code_list,a.tetap,a.tidak_tetap,a.kode_rs,a.smt,a.tahun,b.description from rl2 a left join m_rl2 b on b.code_list=a.code_list where a.code_list=\'' . $kode . '\' and a.kode_rs=\'' . $koders . '\'' ); } } echo ' '; foreach ($sql->fetchAll() as $row) { extract( $row ); $total = $tetap + $tidak_tetap; if ($smt == 1) { $semt = 'I'; } else { $semt = 'II'; } echo' '; } $sql_s = $db->query('SELECT SUM(tetap) as tetap1, SUM(tidak_tetap) as t_tetap1 from rl2 where kode_rs=\'' . $koders . '\' and smt=\'1\'' ); $r_s = $sql_s->fetchAll()[0]; extract( $r_s ); $total_1 = $tetap1 + $t_tetap1; $sql_s2 = $db->query('SELECT SUM(tetap) as tetap2, SUM(tidak_tetap) as t_tetap2 from rl2 where kode_rs=\'' . $koders . '\' and smt=\'2\'' ); $r_s2 = $sql_s2->fetchAll()[0]; extract( $r_s2 ); $total_2 = $tetap2 + $t_tetap2; echo' '; echo '
KodeTenagaJumlah TenagaTetapTidak TetapSemesterTahun-
' . $code_list . '' . $description . '' . $total . '' . $tetap . '' . $tidak_tetap . '' . $semt . '' . $tahun . ' 
Jumlah Tenaga Semester I : ' . $total_1 . '' . $tetap1 . '' . $t_tetap1 . ' 
Jumlah Tenaga Semester II : ' . $total_2 . '' . $tetap2 . '' . $t_tetap2 . ' 
'; } if ($reqdata == 'xml_rl2') { if (( empty( $bln ) && empty( $tahun ) )) { $sql2 = $db->query('SELECT a.kode_rs,a.code_list,a.tetap,a.tidak_tetap,a.smt,a.tahun from rl2 a left join m_rl2 b on b.code_list=a.code_list where kode_rs=\'' . $koders . '\' order by a.code_list Asc' ); } else { if (( empty( $bln ) && !empty( $tahun ) )) { $sql2 = $db->query('SELECT a.kode_rs,a.code_list,a.tetap,a.tidak_tetap,a.smt,a.tahun from rl2 a left join m_rl2 b on b.code_list=a.code_list where kode_rs=\'' . $koders . '\' and tahun=\'' . $tahun . '\' order by a.code_list Asc' ); } else { if (( !empty( $bln ) && empty( $tahun ) )) { $sql2 = $db->query('SELECT a.kode_rs,a.code_list,a.tetap,a.tidak_tetap,a.smt,a.tahun from rl2 a left join m_rl2 b on b.code_list=a.code_list where kode_rs=\'' . $koders . '\' and smt=\'' . $bln . '\' order by a.code_list Asc' ); } else { if (( !empty( $bln ) && !empty( $tahun ) )) { $sql2 = $db->query('SELECT a.kode_rs,a.code_list,a.tetap,a.tidak_tetap,a.smt,a.tahun from rl2 a left join m_rl2 b on b.code_list=a.code_list where kode_rs=\'' . $koders . '\' and tahun=\'' . $tahun . '\' and smt=\'' . $bln . '\' order by a.code_list Asc' ); } } } } $xml = new SimpleXMLElement( '' ); foreach ($sql2->fetchAll() as $r) { extract( $r ); $data = $xml->addChild( 'data' ); $data->addChild( 'code', $code_list ); $data->addChild( 'tetap', $tetap ); $data->addChild( 'tidak_tetap', $tidak_tetap ); $data->addChild( 'smt', $smt ); $data->addChild( 'tahun', $tahun ); } $fp = fopen( 'xml/rl2_' . $bln . '_' . $tahun . '.xml', 'wb' ); fwrite( $fp, $xml->asXML( ) ); fclose( $fp ); $file = 'rl2_' . $bln . '_' . $tahun . '.xml'; echo'' . $file . ''; } //////////////////////////AKHIR RL2///////////// //////////////AWAL BATAS RL41//////////////// if ($reqdata == 'cari_rl41') { echo ' '; if (( empty( $bln ) && empty( $tahun ) )) { $tanggal1 = " AND a.TGLMASUK::varchar(10) LIKE '".date('Y')."-%' "; $tanggal2 = " AND a.TGLMASUK::varchar(10) LIKE '%-".date('m')."-%' "; } else { if (( empty( $bln ) && !empty( $tahun ) )) { $tanggal1 = " AND a.TGLMASUK::varchar(10) LIKE '".$tahun."-%' "; $tanggal2 = ""; }else { if (( !empty( $bln ) && empty( $tahun ) )) { $tanggal1 = ""; $tanggal2 = " AND a.TGLMASUK::varchar(10) LIKE '%-".$bln."-%' "; }else { if (( !empty( $bln ) && !empty( $tahun ) )) { $tanggal1 = " AND a.TGLMASUK::varchar(10) LIKE '".$tahun."-%' "; $tanggal2 = " AND a.TGLMASUK::varchar(10) LIKE '%-".$bln."-%' "; } } } } $sql2 = $db->query("SELECT DISTINCT b2.icd_code FROM t_resumepulang a LEFT JOIN t_icd b ON a.idadmission=b.idxdaftar join icd b2 on b.icd = b2.icd_code JOIN t_admission c ON a.idadmission=c.id_admission JOIN m_pasien d ON d.NOMR=a.NOMR WHERE b.status_rajal = 0 and $tanggal1 $tanggal2 "); //SELECT ? FROM ? $kondisi_SELECT = " a.ICDKELUAR FROM t_resumepulang a LEFT JOIN icd b ON a.ICDKELUAR=b.icd_code INNER JOIN t_admission c ON a.IDADMISSION=c.id_admission INNER JOIN m_pasien d ON d.NOMR=a.NOMR "; //WHERE NIP STATUS JENIS KELAMIN L $nip_status_jkL = "AND a.NIP='rekammedik' AND a.JENISKELAMIN='L' "; //WHERE NIP STATUS JENIS KELAMIN P $nip_status_jkP = "AND a.NIP='rekammedik' AND a.JENISKELAMIN='P' "; foreach ($sql2->fetchAll() as $r) { extract( $r ); $bln = m_to_id($bln); echo''; echo ''; } echo' '; echo ''; echo '
No. DTD No. Daftar Terperinci Golongan Sebab Penyakit Jumlah Pasien Hidup/Mati Menurut Umur dan Jenis Kelamin Jumlah Pasien Keluar (Hidup & Mati) Menurut Jenis Kelamin Jumlah Pasien Keluar (Hidup & Mati) Jumlah Pasien Keluar Mati BulanTahun
0-6hr 7-28hr 29hr-<1th 1-4th 5-14th 15-24th 25-44th 45-64th >65th
L P L P L P L P L P L P L P L P L P L P
'; $sqldtd = $db->query("SELECT dtd FROM icd WHERE icd_code ='$icd_code' ")->fetchAll()[0];extract( $sqldtd );echo $dtd; echo ' ' . $icd_code . ' '; $sqlsebabpenyakit = $db->query("SELECT sebabpenyakit FROM icd WHERE icd_code ='$icd_code' ")->fetchAll()[0];extract( $sqlsebabpenyakit );echo $sebabpenyakit; echo ' '; $jml6L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('d.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('d.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml6L; echo ' '; $jml6P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('d.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('d.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml6P; echo ' '; $jml28L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('d.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('d.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml28L; echo ' '; $jml28P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('d.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('d.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml28P; echo ' '; $jml1L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('d.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<'1' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml1L; echo ' '; $jml1P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('d.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<'1' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml1P; echo ' '; $jml4L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='4' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml4L; echo ' '; $jml4P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='4' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml4P; echo ' '; $jml14L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='14' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml14L; echo ' '; $jml14P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='14' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml14P; echo ' '; $jml24L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='24' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml24L; echo ' '; $jml24P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='24' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml24P; echo ' '; $jml44L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<'44' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml44L; echo ' '; $jml44P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<'44' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml44P; echo ' '; $jml64L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='64' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml64L; echo ' '; $jml64P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='64' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml64P; echo ' '; $jml65_L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">'65' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml64_L; echo ' '; $jml65_P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">'65' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml64_P; echo ' '; $jmlTL = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jmlTL; echo ' '; $jmlTP = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jmlTP; echo ' '; $jmlT = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND a.NIP='rekammedik' $tanggal1 $tanggal2 ")->numRows(); echo $jmlT; echo ' '; $jmlTM = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND a.NIP='rekammedik' AND a.STATUSPULANG ='7' $tanggal1 $tanggal2 ")->numRows(); echo $jmlTM; echo ' ' . $bln . ' ' . $tahun . '
Total Bulan ' . $bln . ' Tahun ' . $tahun . ' '; $jml6L = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('d.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('d.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml6L; echo ' '; $jml6P = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('d.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('d.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml6P; echo ' '; $jml28L = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('d.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('d.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml28L; echo ' '; $jml28p = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('d.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('d.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml28P; echo ' '; $jml1L = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('d.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<'1' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml1L; echo ' '; $jml1P = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('d.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<'1' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml1P; echo ' '; $jml4L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('d.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='4' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml4L; echo ' '; $jml4P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('d.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='4' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml4P; echo ' '; $jml14L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('d.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='14' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml14L; echo ' '; $jml14P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('d.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='14' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml14P; echo ' '; $jml24L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('d.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='24' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml24L; echo ' '; $jml24P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('d.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='24' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml24P; echo ' '; $jml44L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('d.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<'44' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml44L; echo ' '; $jml44P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('d.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<'44' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml44P; echo ' '; $jml64L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('d.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='64' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml64L; echo ' '; $jml64P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('d.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='64' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml64P; echo ' '; $jml64_L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('d.tgllahir','year').">'65' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml64_L; echo ' '; $jml64_P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('d.tgllahir','year').">'65' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml64_P; echo ' '; $jmlSTL = $db->query("SELECT $kondisi_SELECT WHERE a.NIP='rekammedik' AND a.JENISKELAMIN='L' $tanggal1 $tanggal2 ")->numRows(); echo $jmlSTL; echo ' '; $jmlSTP = $db->query("SELECT $kondisi_SELECT WHERE a.NIP='rekammedik' AND a.JENISKELAMIN='P' $tanggal1 $tanggal2 ")->numRows(); echo $jmlSTP; echo ' '; $jmlST = $db->query("SELECT $kondisi_SELECT WHERE a.NIP='rekammedik' $tanggal1 $tanggal2 ")->numRows(); echo $jmlST; echo ' '; $jmlST = $db->query("SELECT $kondisi_SELECT WHERE a.NIP='rekammedik' AND a.STATUSPULANG ='7' $tanggal1 $tanggal2 ")->numRows(); echo $jmlST; echo ' -
'; } if ($reqdata == 'xml_rl41') { if (( empty( $bln ) && empty( $tahun ) )) { $tanggal1 = " AND a.TGLMASUK::varchar(10) LIKE '".date('Y')."-%' "; $tanggal2 = " AND a.TGLMASUK::varchar(10) LIKE '%-".date('m')."-%' "; } else { if (( empty( $bln ) && !empty( $tahun ) )) { $tanggal1 = " AND a.TGLMASUK::varchar(10) LIKE '".$tahun."-%' "; $tanggal2 = ""; }else { if (( !empty( $bln ) && empty( $tahun ) )) { $tanggal1 = ""; $tanggal2 = " AND a.TGLMASUK::varchar(10) LIKE '%-".$bln."-%' "; }else { if (( !empty( $bln ) && !empty( $tahun ) )) { $tanggal1 = " AND a.TGLMASUK::varchar(10) LIKE '".$tahun."-%' "; $tanggal2 = " AND a.TGLMASUK::varchar(10) LIKE '%-".$bln."-%' "; } } } } $sql2 = $db->query("SELECT DISTINCT b.icd_code FROM t_resumepulang a LEFT JOIN icd b ON a.ICDKELUAR=b.icd_code INNER JOIN t_admission c ON a.IDADMISSION=c.id_admission INNER JOIN m_pasien d ON d.NOMR=a.NOMR WHERE a.NIP='rekammedik' $tanggal1 $tanggal2 "); //SELECT ? FROM ? $kondisi_SELECT = " a.ICDKELUAR FROM t_resumepulang a LEFT JOIN icd b ON a.ICDKELUAR=b.icd_code INNER JOIN t_admission c ON a.IDADMISSION=c.id_admission INNER JOIN m_pasien d ON d.NOMR=a.NOMR "; //WHERE NIP STATUS JENIS KELAMIN L $nip_status_jkL = "AND a.NIP='rekammedik' AND a.JENISKELAMIN='L' "; //WHERE NIP STATUS JENIS KELAMIN P $nip_status_jkP = "AND a.NIP='rekammedik' AND a.JENISKELAMIN='P' "; $xml = new SimpleXMLElement( '' ); foreach ($sql2->fetchAll() as $r) { extract( $r ); $jml6L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('d.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('d.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml6P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('d.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('d.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml28L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('d.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('d.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml28P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('d.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('d.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml1L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('d.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<'1' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml1P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('d.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<'1' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml4L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='4' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml4P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='4' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml14L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='14' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml14P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='14' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml24L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='24' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml24P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='24' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml44L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<'44' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml44P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<'44' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml64L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='64' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml64P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('d.tgllahir','year')."<='64' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml64_L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">'65' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml64_P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('d.tgllahir','year').">'65' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $data = $xml->addChild( 'data' ); $data->addChild( 'code', $icd_code ); $data->addChild( 'j_1_6hr_L', $jml6L ); $data->addChild( 'j_1_6hr_P', $jml6P ); $data->addChild( 'j_7_28hr_L', $jml28L ); $data->addChild( 'j_7_28hr_P', $jml28P ); $data->addChild( 'j_28hr_1th_L', $jml1L ); $data->addChild( 'j_28hr_1th_P', $jml1P ); $data->addChild( 'j_1_4th_L', $jml4L ); $data->addChild( 'j_1_4th_P', $jml4P ); $data->addChild( 'j_5_14th_L', $jml14L ); $data->addChild( 'j_5_14th_P', $jml14P ); $data->addChild( 'j_15_24th_L', $jml24L ); $data->addChild( 'j_15_24th_P', $jml24P ); $data->addChild( 'j_25_44th_L', $jml44L ); $data->addChild( 'j_25_44th_P', $jml44P ); $data->addChild( 'j_45_64th_L', $jml64L ); $data->addChild( 'j_45_64th_P', $jml64P ); $data->addChild( 'j_65th_L', $jml64_L ); $data->addChild( 'j_65th_P', $jml64_P ); $data->addChild( 'bulan', $bln ); $data->addChild( 'tahun', $tahun ); } $fp = fopen( 'xml/rl41_' . $bln . '_' . $tahun . '.xml', 'wb' ); fwrite( $fp, $xml->asXML( ) ); fclose( $fp ); $file = 'rl41_' . $bln . '_' . $tahun . '.xml'; echo "
"; echo'' . $file . ''; echo ' | '; echo "
"; } /////////////AKHIR BATAS RL41/////////// ///////////////////////AWAL BATAS RL42//////////////////// if ($reqdata == 'cari_rl42') { echo ' '; if (( empty( $bln ) && empty( $tahun ) )) { $tanggal1 = " AND a.TANGGAL::varchar(10) LIKE '".date('Y')."-%' "; $tanggal2 = " AND a.TANGGAL::varchar(10) LIKE '%-".date('m')."-%' "; } else { if (( empty( $bln ) && !empty( $tahun ) )) { $tanggal1 = " AND a.TANGGAL::varchar(10) LIKE '".$tahun."-%' "; $tanggal2 = ""; }else { if (( !empty( $bln ) && empty( $tahun ) )) { $tanggal1 = ""; $tanggal2 = " AND a.TANGGAL::varchar(10) LIKE '%-".$bln."-%' "; }else { if (( !empty( $bln ) && !empty( $tahun ) )) { $tanggal1 = " AND a.TANGGAL::varchar(10) LIKE '".$tahun."-%' "; $tanggal2 = " AND a.TANGGAL::varchar(10) LIKE '%-".$bln."-%' "; } } } } echo $nip_jk_status; $sql2 = $db->query("SELECT DISTINCT b2.icd_code FROM t_diagnosadanterapi a LEFT JOIN t_icd b ON a.idxdaftar=b.idxdaftar JOIN icd b2 on b.icd = b2.icd_code JOIN m_pasien c ON a.NOMR=c.NOMR JOIN t_pendaftaran d ON a.NOMR=d.NOMR WHERE b.status_rajal = 1 and d.STATUS !='0' $tanggal1 $tanggal2 "); //SELECT ? FROM ? $kondisi_SELECT = "b2.icd_code FROM t_diagnosadanterapi a LEFT JOIN t_icd b ON a.idxdaftar=b.idxdaftar JOIN icd b2 ON b.icd=b2.icd_code JOIN m_pasien c ON a.NOMR=c.NOMR JOIN t_pendaftaran d ON a.NOMR=d.NOMR"; //WHERE NIP STATUS JENIS KELAMIN L $nip_status_jkL = "AND b.status_rajal = 1 and c.JENISKELAMIN='L' AND d.STATUS!='0'"; //WHERE NIP STATUS JENIS KELAMIN P $nip_status_jkP = "AND b.status_rajal = 1 and c.JENISKELAMIN='P' AND d.STATUS!='0'"; foreach ($sql2->fetchAll() as $r) { extract( $r ); $bln = m_to_id($bln); echo''; echo ''; } echo' '; echo ''; echo '
No. DTDNo. Daftar TerperinciGolongan Sebab Penyakit Jumlah Pasien Hidup/Mati Menurut Umur dan Jenis Kelamin Jumlah Pasien Keluar (Hidup & Mati) Menurut Jenis Kelamin Jumlah Pasien Keluar (Hidup & Mati) Jumlah Pasien Keluar Mati BulanTahun
0-6hr 7-28hr 29hr-<1th 1-4th 5-14th 15-24th 25-44th 45-64th >65th
L P L P L P L P L P L P L P L P L P L P
'; $sqldtd = $db->query("SELECT dtd FROM icd WHERE icd_code ='$icd_code' ")->fetchAll()[0];extract( $sqldtd );echo $dtd; echo ' ' . $icd_code . ' '; $sqlsebabpenyakit = $db->query("SELECT sebabpenyakit FROM icd WHERE icd_code ='$icd_code' ")->fetchAll()[0];extract( $sqlsebabpenyakit );echo $sebabpenyakit; echo ' '; $jml6L = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml6L; echo ' '; $jml6P = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml6P; echo ' '; $jml28L = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml28L; echo ' '; $jml28P = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml28P; echo ' '; $jml1L = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'1' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml1L; echo ' '; $jml1P = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'1' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml1P; echo ' '; $jml4L = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='4' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml4L; echo ' '; $jml4P = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='4' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml4P; echo ' '; $jml14L = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='14' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml14L; echo ' '; $jml14P = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='14' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml14P; echo ' '; $jml24L = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='24' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml24L; echo ' '; $jml24P = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='24' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml24P; echo ' '; $jml44L = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'44' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml44L; echo ' '; $jml44P = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'44' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml44P; echo ' '; $jml64L = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='64' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml64L; echo ' '; $jml64P = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='64' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml64P; echo ' '; $jml64_L = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'65' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml64_L; echo ' '; $jml64_P = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'65' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml64_P; echo ' '; $jmlTL = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jmlTL; echo ' '; $jmlTP = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jmlTP; echo ' '; $jmlT = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND a.NIP='rekammedik' AND d.STATUS!='0' $tanggal1 $tanggal2 ")->numRows(); echo $jmlT; echo ' '; $jmlTM = $db->query("SELECT $kondisi_SELECT WHERE b2.icd_code='$icd_code' AND a.NIP='rekammedik' AND d.STATUS='8' $tanggal1 $tanggal2 ")->numRows(); echo $jmlTM; echo ' ' . $bln . ' ' . $tahun . '
Total Bulan ' . $bln . ' Tahun ' . $tahun . ' '; $jml6L = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('c.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml6L; echo ' '; $jml6P = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('c.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml6P; echo ' '; $jml28L = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('c.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml28L; echo ' '; $jml28p = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('c.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml28P; echo ' '; $jml1L = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('c.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'1' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml1L; echo ' '; $jml1P = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('c.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'1' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml1P; echo ' '; $jml4L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='4' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml4L; echo ' '; $jml4P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='4' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml4P; echo ' '; $jml14L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='14' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml14L; echo ' '; $jml14P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='14' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml14P; echo ' '; $jml24L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='24' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml24L; echo ' '; $jml24P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='24' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml24P; echo ' '; $jml44L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'44' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml44L; echo ' '; $jml44P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'44' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml44P; echo ' '; $jml64L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='64' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml64L; echo ' '; $jml64P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='64' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml64P; echo ' '; $jml64_L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">'65' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml64_L; echo ' '; $jml64_P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">'65' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml64_P; echo ' '; $jmlSTL = $db->query("SELECT $kondisi_SELECT WHERE a.NIP='rekammedik' AND d.STATUS!='0' AND c.JENISKELAMIN='L' $tanggal1 $tanggal2 ")->numRows(); echo $jmlSTL; echo ' '; $jmlSTP = $db->query("SELECT $kondisi_SELECT WHERE a.NIP='rekammedik' AND d.STATUS!='0' AND c.JENISKELAMIN='P' $tanggal1 $tanggal2 ")->numRows(); echo $jmlSTP; echo ' '; $jmlST = $db->query("SELECT $kondisi_SELECT WHERE a.NIP='rekammedik' AND d.STATUS!='0' $tanggal1 $tanggal2 ")->numRows(); echo $jmlST; echo ' '; $jmlSTM = $db->query("SELECT $kondisi_SELECT WHERE a.NIP='rekammedik' AND d.STATUS='8' $tanggal1 $tanggal2 ")->numRows(); echo $jmlSTM; echo ' -
'; } if ($reqdata == 'xml_rl42') { if (( empty( $bln ) && empty( $tahun ) )) { $tanggal1 = " AND a.TANGGAL::varchar(10) LIKE '".date('Y')."-%' "; $tanggal2 = " AND a.TANGGAL::varchar(10) LIKE '%-".date('m')."-%' "; $bln = date('m'); $tahun = date('Y'); } else { if (( empty( $bln ) && !empty( $tahun ) )) { $tanggal1 = " AND a.TANGGAL::varchar(10) LIKE '".$tahun."-%' "; $tanggal2 = ""; //$bln = date('m'); }else { if (( !empty( $bln ) && empty( $tahun ) )) { $tanggal1 = ""; $tanggal2 = " AND a.TANGGAL::varchar(10) LIKE '%-".$bln."-%' "; $tahun = date('Y'); }else { if (( !empty( $bln ) && !empty( $tahun ) )) { $tanggal1 = " AND a.TANGGAL::varchar(10) LIKE '".$tahun."-%' "; $tanggal2 = " AND a.TANGGAL::varchar(10) LIKE '%-".$bln."-%' "; } } } } $sql2 = $db->query("SELECT DISTINCT b.icd_code FROM t_diagnosadanterapi a LEFT JOIN icd b ON a.ICD_CODE=b.icd_code INNER JOIN m_pasien c ON a.NOMR=c.NOMR INNER JOIN t_pendaftaran d ON a.NOMR=d.NOMR WHERE a.NIP='rekammedik' AND d.STATUS!='0' $tanggal1 $tanggal2 "); //SELECT ? FROM ? $kondisi_SELECT = "a.ICD_CODE FROM t_diagnosadanterapi a LEFT JOIN icd b ON a.ICD_CODE=b.icd_code INNER JOIN m_pasien c ON a.NOMR=c.NOMR INNER JOIN t_pendaftaran d ON a.NOMR=d.NOMR"; //WHERE NIP STATUS JENIS KELAMIN L $nip_status_jkL = "AND a.NIP='rekammedik' AND c.JENISKELAMIN='L' AND d.STATUS!='0'"; //WHERE NIP STATUS JENIS KELAMIN P $nip_status_jkP = "AND a.NIP='rekammedik' AND c.JENISKELAMIN='P' AND d.STATUS!='0'"; $xml = new SimpleXMLElement ( '' ); foreach ($sql2->fetchAll() as $r) { extract( $r ); $date1 = new DateTime(date('Y-m-d', strtotime($TGLLAHIR))); $date2 = new DateTime(date('Y-m-d')); $interval = $date1->diff($date2); $jml6L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml6P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml28L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml28P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml1L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'1' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml1P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'1' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml4L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='4' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml4P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='4' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml14L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='14' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml14P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='14' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml24L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='24' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml24P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='24' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml44L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'44' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml44P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'44' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml64L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='64' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml64P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='64' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml64_L = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'65' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml64_P = $db->query("SELECT $kondisi_SELECT WHERE a.ICDKELUAR='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'65' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $data = $xml->addChild( 'data' ); $data->addChild( 'code', $icd_code ); $data->addChild( 'j_1_6hr_L', $jml6L ); $data->addChild( 'j_1_6hr_P', $jml6P ); $data->addChild( 'j_7_28hr_L', $jml28L ); $data->addChild( 'j_7_28hr_P', $jml28P ); $data->addChild( 'j_28hr_1th_L', $jml1L ); $data->addChild( 'j_28hr_1th_P', $jml1P ); $data->addChild( 'j_1_4th_L', $jml4L ); $data->addChild( 'j_1_4th_P', $jml4P ); $data->addChild( 'j_5_14th_L', $jml14L ); $data->addChild( 'j_5_14th_P', $jml14P ); $data->addChild( 'j_15_24th_L', $jml24L ); $data->addChild( 'j_15_24th_P', $jml24P ); $data->addChild( 'j_25_44th_L', $jml44L ); $data->addChild( 'j_25_44th_P', $jml44P ); $data->addChild( 'j_45_64th_L', $jml64L ); $data->addChild( 'j_45_64th_P', $jml64P ); $data->addChild( 'j_65th_L', $jml64_L ); $data->addChild( 'j_65th_P', $jml64_P ); $data->addChild( 'bulan', $bln ); $data->addChild( 'tahun', $tahun ); } $fp = fopen( 'xml/rl42_' . $bln . '_' . $tahun . '.xml', 'wb' ); fwrite( $fp, $xml->asXML( ) ); fclose( $fp ); $file = 'rl42_' . $bln . '_' . $tahun . '.xml'; echo "
"; echo'' . $file . ''; echo ' | '; echo "
"; } /////////////////BATAS AKHIR RL42//////////////////// ////////////////BATAS AWAL RL43//////// if ($reqdata == 'cari_rl43') { echo ' '; if (( empty( $bln ) && empty( $tahun ) )) { $tanggal1 = " AND a.TANGGAL::varchar(10) LIKE '".date('Y')."-%' "; $tanggal2 = " AND a.TANGGAL::varchar(10) LIKE '%-".date('m')."-%' "; } else { if (( empty( $bln ) && !empty( $tahun ) )) { $tanggal1 = " AND a.TANGGAL::varchar(10) LIKE '".$tahun."-%' "; $tanggal2 = ""; }else { if (( !empty( $bln ) && empty( $tahun ) )) { $tanggal1 = ""; $tanggal2 = " AND a.TANGGAL::varchar(10) LIKE '%-".$bln."-%' "; }else { if (( !empty( $bln ) && !empty( $tahun ) )) { $tanggal1 = " AND a.TANGGAL::varchar(10) LIKE '".$tahun."-%' "; $tanggal2 = " AND a.TANGGAL::varchar(10) LIKE '%-".$bln."-%' "; } } } } $sql2 = $db->query("SELECT DISTINCT b.icd_code FROM t_diagnosadanterapi a LEFT JOIN icd b ON a.ICD_CODE=b.icd_code INNER JOIN m_pasien c ON a.NOMR=c.NOMR INNER JOIN t_pendaftaran d ON a.NOMR=d.NOMR WHERE a.NIP='rekammedik' AND d.STATUS='8' $tanggal1 $tanggal2 "); //SELECT ? FROM ? $kondisi_SELECT = "a.ICD_CODE FROM t_diagnosadanterapi a LEFT JOIN icd b ON a.ICD_CODE=b.icd_code INNER JOIN m_pasien c ON a.NOMR=c.NOMR INNER JOIN t_pendaftaran d ON a.NOMR=d.NOMR"; //WHERE NIP STATUS JENIS KELAMIN L $nip_status_jkL = "AND a.NIP='rekammedik' AND c.JENISKELAMIN='L' AND d.STATUS='8'"; //WHERE NIP STATUS JENIS KELAMIN P $nip_status_jkP = "AND a.NIP='rekammedik' AND c.JENISKELAMIN='P' AND d.STATUS='8'"; foreach ($sql2->fetchAll() as $r) { extract( $r ); $bln = m_to_id($bln); echo''; echo ''; } echo' '; echo ''; echo '
No. DTDNo. Daftar TerperinciGolongan Sebab PenyakitJumlah Pasien Keluar Mati Menurut Umur dan Jenis KelaminJumlah Pasien Keluar Mati Menurut Jenis KelaminJumlah Pasien Keluar MatiBulanTahun
0-6hr 7-28hr 29hr-<1th 1-4th 5-14th 15-24th 25-44th 45-64th >65th
L P L P L P L P L P L P L P L P L P L P
'; $sqldtd = $db->query("SELECT dtd FROM icd WHERE icd_code ='$icd_code' ")->fetchAll()[0];extract( $sqldtd );echo $dtd; echo ' ' . $icd_code . ' '; $sqlsebabpenyakit = $db->query("SELECT sebabpenyakit FROM icd WHERE icd_code ='$icd_code' ")->fetchAll()[0];extract( $sqlsebabpenyakit );echo $sebabpenyakit; echo ' '; $jml6L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml6L; echo ' '; $jml6P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml6P; echo ' '; $jml28L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml28L; echo ' '; $jml28P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml28P; echo ' '; $jml1L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'1' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml1L; echo ' '; $jml1P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'1' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml1P; echo ' '; $jml4L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='4' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml4L; echo ' '; $jml4P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='4' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml4P; echo ' '; $jml14L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='14' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml14L; echo ' '; $jml14P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='14' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml14P; echo ' '; $jml24L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='24' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml24L; echo ' '; $jml24P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='24' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml24P; echo ' '; $jml44L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'44' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml44L; echo ' '; $jml44P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'44' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml44P; echo ' '; $jml64L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='64' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml64L; echo ' '; $jml64P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='64' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml64P; echo ' '; $jml64_L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'65' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml64_L; echo ' '; $jml64_P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'65' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml64_P; echo ' '; $jmlTL = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jmlTL; echo ' '; $jmlTP = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jmlTP; echo ' '; $jmlT = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND a.NIP='rekammedik' AND d.STATUS='8' $tanggal1 $tanggal2 ")->numRows(); echo $jmlT; echo ' ' . $bln . ' ' . $tahun . '
Total Bulan ' . $bln . ' Tahun ' . $tahun . ' '; $jml6L = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('c.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml6L; echo ' '; $jml6P = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('c.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml6P; echo ' '; $jml28L = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('c.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml28L; echo ' '; $jml28p = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('c.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml28P; echo ' '; $jml1L = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('c.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'1' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml1L; echo ' '; $jml1P = $db->query("SELECT $kondisi_SELECT WHERE ".date('d')." - ".extract_sql('c.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'1' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml1P; echo ' '; $jml4L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='4' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml4L; echo ' '; $jml4P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='4' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml4P; echo ' '; $jml14L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='14' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml14L; echo ' '; $jml14P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='14' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml14P; echo ' '; $jml24L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='24' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml24L; echo ' '; $jml24P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='24' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml24P; echo ' '; $jml44L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'44' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml44L; echo ' '; $jml44P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'44' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml44P; echo ' '; $jml64L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='64' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml64L; echo ' '; $jml64P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='64' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml64P; echo ' '; $jml64_L = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">'65' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); echo $jml64_L; echo ' '; $jml64_P = $db->query("SELECT $kondisi_SELECT WHERE ".date('Y')." - ".extract_sql('c.tgllahir','year').">'65' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); echo $jml64_P; echo ' '; $jmlSTL = $db->query("SELECT $kondisi_SELECT WHERE a.NIP='rekammedik' AND d.STATUS='8' AND c.JENISKELAMIN='L' $tanggal1 $tanggal2 ")->numRows(); echo $jmlSTL; echo ' '; $jmlSTP = $db->query("SELECT $kondisi_SELECT WHERE a.NIP='rekammedik' AND d.STATUS='8' AND c.JENISKELAMIN='P' $tanggal1 $tanggal2 ")->numRows(); echo $jmlSTP; echo ' '; $jmlST = $db->query("SELECT $kondisi_SELECT WHERE a.NIP='rekammedik' AND d.STATUS='8' $tanggal1 $tanggal2 ")->numRows(); echo $jmlST; echo ' -
'; } if ($reqdata == 'xml_rl43') { if (( empty( $bln ) && empty( $tahun ) )) { $tanggal1 = " AND a.TANGGAL::varchar(10) LIKE '".date('Y')."-%' "; $tanggal2 = " AND a.TANGGAL::varchar(10) LIKE '%-".date('m')."-%' "; $bln = date('m'); $tahun = date('Y'); } else { if (( empty( $bln ) && !empty( $tahun ) )) { $tanggal1 = " AND a.TANGGAL::varchar(10) LIKE '".$tahun."-%' "; $tanggal2 = ""; //$bln = date('m'); }else { if (( !empty( $bln ) && empty( $tahun ) )) { $tanggal1 = ""; $tanggal2 = " AND a.TANGGAL::varchar(10) LIKE '%-".$bln."-%' "; $tahun = date('Y'); }else { if (( !empty( $bln ) && !empty( $tahun ) )) { $tanggal1 = " AND a.TANGGAL::varchar(10) LIKE '".$tahun."-%' "; $tanggal2 = " AND a.TANGGAL::varchar(10) LIKE '%-".$bln."-%' "; } } } } $sql2 = $db->query("SELECT DISTINCT b.icd_code FROM t_diagnosadanterapi a LEFT JOIN icd b ON a.ICD_CODE=b.icd_code INNER JOIN m_pasien c ON a.NOMR=c.NOMR INNER JOIN t_pendaftaran d ON a.NOMR=d.NOMR WHERE a.NIP='rekammedik' AND d.STATUS='8' $tanggal1 $tanggal2 "); //SELECT ? FROM ? $kondisi_SELECT = "a.ICD_CODE FROM t_diagnosadanterapi a LEFT JOIN icd b ON a.ICD_CODE=b.icd_code INNER JOIN m_pasien c ON a.NOMR=c.NOMR INNER JOIN t_pendaftaran d ON a.NOMR=d.NOMR"; //WHERE NIP STATUS JENIS KELAMIN L $nip_status_jkL = "AND a.NIP='rekammedik' AND c.JENISKELAMIN='L' AND d.STATUS='8'"; //WHERE NIP STATUS JENIS KELAMIN P $nip_status_jkP = "AND a.NIP='rekammedik' AND c.JENISKELAMIN='P' AND d.STATUS='8'"; $xml = new SimpleXMLElement ( '' ); foreach ($sql2->fetchAll() as $r) { extract( $r ); $jml6L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml6P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='0' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='6' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml28L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml28P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='7' AND ".date('d')." - ".extract_sql('c.tgllahir','day')."<='28' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."='0' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml1L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'1' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml1P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('d')." - ".extract_sql('c.tgllahir','day').">='29' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'1' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml4L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='4' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml4P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='1' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='4' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml14L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='14' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml14P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='5' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='14' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml24L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='24' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml24P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='15' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='24' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml44L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'44' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml44P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'25' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<'44' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml64L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='64' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml64P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">='45' AND ".date('Y')." - ".extract_sql('c.tgllahir','year')."<='64' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $jml64_L = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'65' $nip_status_jkL $tanggal1 $tanggal2 ")->numRows(); $jml64_P = $db->query("SELECT $kondisi_SELECT WHERE a.ICD_CODE='$icd_code' AND ".date('Y')." - ".extract_sql('c.tgllahir','year').">'65' $nip_status_jkP $tanggal1 $tanggal2 ")->numRows(); $data = $xml->addChild( 'data' ); $data->addChild( 'code', $icd_code ); $data->addChild( 'j_1_6hr_L', $jml6L ); $data->addChild( 'j_1_6hr_P', $jml6P ); $data->addChild( 'j_7_28hr_L', $jml28L ); $data->addChild( 'j_7_28hr_P', $jml28P ); $data->addChild( 'j_28hr_1th_L', $jml1L ); $data->addChild( 'j_28hr_1th_P', $jml1P ); $data->addChild( 'j_1_4th_L', $jml4L ); $data->addChild( 'j_1_4th_P', $jml4P ); $data->addChild( 'j_5_14th_L', $jml14L ); $data->addChild( 'j_5_14th_P', $jml14P ); $data->addChild( 'j_15_24th_L', $jml24L ); $data->addChild( 'j_15_24th_P', $jml24P ); $data->addChild( 'j_25_44th_L', $jml44L ); $data->addChild( 'j_25_44th_P', $jml44P ); $data->addChild( 'j_45_64th_L', $jml64L ); $data->addChild( 'j_45_64th_P', $jml64P ); $data->addChild( 'j_65th_L', $jml64_L ); $data->addChild( 'j_65th_P', $jml64_P ); $data->addChild( 'bulan', $bln ); $data->addChild( 'tahun', $tahun ); } $fp = fopen( 'xml/rl43_' . $bln . '_' . $tahun . '.xml', 'wb' ); fwrite( $fp, $xml->asXML( ) ); fclose( $fp ); $file = 'rl43_' . $bln . '_' . $tahun . '.xml'; echo "
"; echo'' . $file . ''; echo ' | '; echo "
"; } /////////////BATAS AKHIR RL43//////////// } ?>