Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
BIN +26.2 KB (100%) dist/SIMRSKhanza.jar
Binary file not shown.
@@ -3,8 +3,10 @@
<editor-bookmarks xmlns="http://www.netbeans.org/ns/editor-bookmarks/2" lastBookmarkId="1"/>
<open-files xmlns="http://www.netbeans.org/ns/projectui-open-files/2">
<group>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/keuangan/DlgPembayaranRalan.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/keuangan/DlgRekapPerShift.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/grafikanalisa/GrafikLabRalanPerTahun.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/setting/DlgUser.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/simrskhanza/frmUtama.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/fungsi/var.java</file>
</group>
</open-files>
</project-private>
@@ -9850,6 +9850,8 @@ CREATE TABLE `user` (
`ipsrs_stokkeluar_pertanggal` enum('true','false') DEFAULT NULL,
`grafik_kunjungan_ranaptahun` enum('true','false') DEFAULT NULL,
`pcare_cek_rujukan` enum('true','false') DEFAULT NULL,
`grafik_lab_ralantahun` enum('true','false') DEFAULT NULL,
`grafik_rad_ralantahun` enum('true','false') DEFAULT NULL,
PRIMARY KEY (`id_user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -9860,7 +9862,7 @@ CREATE TABLE `user` (

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES ('$GæË_{\"—2 M‰ëÁÓ','†vc“†Á+ݘIÁ|{9(','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','true'),(']hÖã¸ã44y t»Tœý','BÃ#éê›L¾\"ûà˦5','true','true','false','false','false','false','true','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','true','false','false','false','false','false','false','false','false','false','false','false','false','true','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','true',NULL,NULL,NULL,NULL,NULL,NULL),('¦ÓVQhÛT·*úóˆ*','|†·Ö¾@Œ5Üõhî1C>ä','false','false','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `user` VALUES ('$GæË_{\"—2 M‰ëÁÓ','†vc“†Á+ݘIÁ|{9(','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','true','true'),(']hÖã¸ã44y t»Tœý','BÃ#éê›L¾\"ûà˦5','true','true','false','false','false','false','true','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','true','false','false','false','false','false','false','false','false','false','false','false','false','true','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','true',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('¦ÓVQhÛT·*úóˆ*','|†·Ö¾@Œ5Üõhî1C>ä','false','false','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

@@ -10493,4 +10495,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-01-10 23:07:01
-- Dump completed on 2018-01-12 10:34:06
@@ -65,7 +65,7 @@ public final class var {
pcare_cek_penyakit=false,grafik_kunjungan_statusbataltanggal=false,kategori_barang=false,golongan_barang=false,pemberian_obat_pertanggal=false,
penjualan_obat_pertanggal=false,pcare_cek_kesadaran=false,pembatalan_periksa_dokter=false,pembayaran_per_unit=false,rekap_pembayaran_per_unit=false,
grafik_kunjungan_percarabayar=false,ipsrs_pengadaan_pertanggal=false,ipsrs_stokkeluar_pertanggal=false,grafik_kunjungan_ranaptahun=false,
pcare_cek_rujukan=false;
pcare_cek_rujukan=false,grafik_lab_ralantahun=false,grafik_rad_ralantahun=false;

public static void setData(String user, String pass) {
try {
@@ -367,6 +367,8 @@ public static void setData(String user, String pass) {
var.ipsrs_stokkeluar_pertanggal=true;
var.grafik_kunjungan_ranaptahun=true;
var.pcare_cek_rujukan=true;
var.grafik_lab_ralantahun=true;
var.grafik_rad_ralantahun=true;
}else */
if(rs.getRow()>=1){
var.kode="Admin Utama";
@@ -650,6 +652,8 @@ public static void setData(String user, String pass) {
var.ipsrs_stokkeluar_pertanggal=true;
var.grafik_kunjungan_ranaptahun=true;
var.pcare_cek_rujukan=true;
var.grafik_lab_ralantahun=true;
var.grafik_rad_ralantahun=true;
}else if(rs2.getRow()>=1){
rs2.beforeFirst();
rs2.next();
@@ -934,6 +938,8 @@ public static void setData(String user, String pass) {
var.ipsrs_stokkeluar_pertanggal=rs2.getBoolean("ipsrs_stokkeluar_pertanggal");
var.grafik_kunjungan_ranaptahun=rs2.getBoolean("grafik_kunjungan_ranaptahun");
var.pcare_cek_rujukan=rs2.getBoolean("pcare_cek_rujukan");
var.grafik_lab_ralantahun=rs2.getBoolean("grafik_lab_ralantahun");
var.grafik_rad_ralantahun=rs2.getBoolean("grafik_rad_ralantahun");
}else if((rs.getRow()==0)&&(rs2.getRow()==0)){
var.kode="";
var.penyakit= false;
@@ -1216,6 +1222,8 @@ public static void setData(String user, String pass) {
var.ipsrs_stokkeluar_pertanggal=false;
var.grafik_kunjungan_ranaptahun=false;
var.pcare_cek_rujukan=false;
var.grafik_lab_ralantahun=false;
var.grafik_rad_ralantahun=false;
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
@@ -1545,4 +1553,6 @@ public static void setData(String user, String pass) {
public static boolean getipsrs_stokkeluar_pertanggal(){return var.ipsrs_stokkeluar_pertanggal;}
public static boolean getgrafik_kunjungan_ranaptahun(){return var.grafik_kunjungan_ranaptahun;}
public static boolean getpcare_cek_rujukan(){return var.pcare_cek_rujukan;}
public static boolean getgrafik_lab_ralantahun(){return var.grafik_lab_ralantahun;}
public static boolean getgrafik_rad_ralantahun(){return var.grafik_rad_ralantahun;}
}
@@ -0,0 +1,235 @@
<?xml version="1.0" encoding="UTF-8" ?>

<Form version="1.5" maxVersion="1.7" type="org.netbeans.modules.form.forminfo.JDialogFormInfo">
<Properties>
<Property name="defaultCloseOperation" type="int" value="2"/>
<Property name="undecorated" type="boolean" value="true"/>
<Property name="resizable" type="boolean" value="false"/>
</Properties>
<SyntheticProperties>
<SyntheticProperty name="formSizePolicy" type="int" value="1"/>
<SyntheticProperty name="generateCenter" type="boolean" value="false"/>
</SyntheticProperties>
<Events>
<EventHandler event="windowActivated" listener="java.awt.event.WindowListener" parameters="java.awt.event.WindowEvent" handler="formWindowActivated"/>
<EventHandler event="windowOpened" listener="java.awt.event.WindowListener" parameters="java.awt.event.WindowEvent" handler="formWindowOpened"/>
</Events>
<AuxValues>
<AuxValue name="FormSettings_autoResourcing" type="java.lang.Integer" value="0"/>
<AuxValue name="FormSettings_autoSetComponentName" type="java.lang.Boolean" value="true"/>
<AuxValue name="FormSettings_generateFQN" type="java.lang.Boolean" value="true"/>
<AuxValue name="FormSettings_generateMnemonicsCode" type="java.lang.Boolean" value="false"/>
<AuxValue name="FormSettings_i18nAutoMode" type="java.lang.Boolean" value="false"/>
<AuxValue name="FormSettings_layoutCodeTarget" type="java.lang.Integer" value="1"/>
<AuxValue name="FormSettings_listenerGenerationStyle" type="java.lang.Integer" value="0"/>
<AuxValue name="FormSettings_variablesLocal" type="java.lang.Boolean" value="false"/>
<AuxValue name="FormSettings_variablesModifier" type="java.lang.Integer" value="2"/>
<AuxValue name="designerSize" type="java.awt.Dimension" value="-84,-19,0,5,115,114,0,18,106,97,118,97,46,97,119,116,46,68,105,109,101,110,115,105,111,110,65,-114,-39,-41,-84,95,68,20,2,0,2,73,0,6,104,101,105,103,104,116,73,0,5,119,105,100,116,104,120,112,0,0,1,48,0,0,3,-65"/>
</AuxValues>

<Layout class="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout"/>
<SubComponents>
<Container class="widget.InternalFrame" name="internalFrame1">
<Properties>
<Property name="border" type="javax.swing.border.Border" editor="org.netbeans.modules.form.editors2.BorderEditor">
<Border info="org.netbeans.modules.form.compat2.border.TitledBorderInfo">
<TitledBorder title="::[ Grafik Kunjungan Laboratorium Rawat Jalan Per Tahun ]::">
<Border PropertyName="innerBorder" info="org.netbeans.modules.form.compat2.border.LineBorderInfo">
<LineBorder>
<Color PropertyName="color" blue="eb" green="f5" red="f0" type="rgb"/>
</LineBorder>
</Border>
<Font PropertyName="font" name="Tahoma" size="11" style="0"/>
<Color PropertyName="color" blue="50" green="78" red="5a" type="rgb"/>
</TitledBorder>
</Border>
</Property>
<Property name="name" type="java.lang.String" value="internalFrame1" noResource="true"/>
</Properties>
<Constraints>
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout" value="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout$BorderConstraintsDescription">
<BorderConstraints direction="Center"/>
</Constraint>
</Constraints>

<Layout class="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout">
<Property name="horizontalGap" type="int" value="1"/>
<Property name="verticalGap" type="int" value="1"/>
</Layout>
<SubComponents>
<Container class="widget.PanelBiasa" name="panelBiasa3">
<Properties>
<Property name="name" type="java.lang.String" value="panelBiasa3" noResource="true"/>
</Properties>
<Constraints>
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout" value="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout$BorderConstraintsDescription">
<BorderConstraints direction="Center"/>
</Constraint>
</Constraints>

<Layout class="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout">
<Property name="useNullLayout" type="boolean" value="true"/>
</Layout>
</Container>
<Container class="widget.panelisi" name="panelGlass5">
<Properties>
<Property name="name" type="java.lang.String" value="panelGlass5" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[55, 55]"/>
</Property>
</Properties>
<Constraints>
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout" value="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout$BorderConstraintsDescription">
<BorderConstraints direction="Last"/>
</Constraint>
</Constraints>

<Layout class="org.netbeans.modules.form.compat2.layouts.DesignFlowLayout">
<Property name="alignment" type="int" value="0"/>
<Property name="verticalGap" type="int" value="9"/>
</Layout>
<SubComponents>
<Component class="widget.Label" name="jLabel33">
<Properties>
<Property name="text" type="java.lang.String" value="Periode Kunjungan :"/>
<Property name="name" type="java.lang.String" value="jLabel33" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[105, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.Tanggal" name="Tanggal1">
<Properties>
<Property name="editable" type="boolean" value="false"/>
<Property name="foreground" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor">
<Color blue="32" green="46" red="32" type="rgb"/>
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="12-01-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
<Property name="name" type="java.lang.String" value="Tanggal1" noResource="true"/>
<Property name="opaque" type="boolean" value="false"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.Label" name="jLabel32">
<Properties>
<Property name="horizontalAlignment" type="int" value="0"/>
<Property name="text" type="java.lang.String" value="s/d"/>
<Property name="name" type="java.lang.String" value="jLabel32" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[25, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.Tanggal" name="Tanggal2">
<Properties>
<Property name="editable" type="boolean" value="false"/>
<Property name="foreground" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor">
<Color blue="32" green="46" red="32" type="rgb"/>
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="12-01-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
<Property name="name" type="java.lang.String" value="Tanggal2" noResource="true"/>
<Property name="opaque" type="boolean" value="false"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.Label" name="jLabel34">
<Properties>
<Property name="horizontalAlignment" type="int" value="0"/>
<Property name="name" type="java.lang.String" value="jLabel34" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[25, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.Button" name="BtnPrint4">
<Properties>
<Property name="icon" type="javax.swing.Icon" noResource="true" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/picture/Bar Chart (copy).png"/>
</Property>
<Property name="mnemonic" type="int" value="71"/>
<Property name="text" type="java.lang.String" value="Plot"/>
<Property name="toolTipText" type="java.lang.String" value="Alt+G"/>
<Property name="name" type="java.lang.String" value="BtnPrint4" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 30]"/>
</Property>
</Properties>
<Events>
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="BtnPrint4ActionPerformed"/>
<EventHandler event="keyPressed" listener="java.awt.event.KeyListener" parameters="java.awt.event.KeyEvent" handler="BtnPrint4KeyPressed"/>
</Events>
</Component>
<Component class="widget.Button" name="BtnPrint3">
<Properties>
<Property name="icon" type="javax.swing.Icon" noResource="true" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/picture/Bar Chart (copy).png"/>
</Property>
<Property name="mnemonic" type="int" value="71"/>
<Property name="text" type="java.lang.String" value="Batang"/>
<Property name="toolTipText" type="java.lang.String" value="Alt+G"/>
<Property name="name" type="java.lang.String" value="BtnPrint3" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 30]"/>
</Property>
</Properties>
<Events>
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="BtnPrint3ActionPerformed"/>
<EventHandler event="keyPressed" listener="java.awt.event.KeyListener" parameters="java.awt.event.KeyEvent" handler="BtnPrint3KeyPressed"/>
</Events>
</Component>
<Component class="widget.Button" name="BtnPrint5">
<Properties>
<Property name="icon" type="javax.swing.Icon" noResource="true" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/picture/Bar Chart (copy).png"/>
</Property>
<Property name="mnemonic" type="int" value="71"/>
<Property name="text" type="java.lang.String" value="Pie"/>
<Property name="toolTipText" type="java.lang.String" value="Alt+G"/>
<Property name="name" type="java.lang.String" value="BtnPrint5" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 30]"/>
</Property>
</Properties>
<Events>
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="BtnPrint5ActionPerformed"/>
<EventHandler event="keyPressed" listener="java.awt.event.KeyListener" parameters="java.awt.event.KeyEvent" handler="BtnPrint5KeyPressed"/>
</Events>
</Component>
<Component class="widget.Button" name="BtnKeluar3">
<Properties>
<Property name="icon" type="javax.swing.Icon" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/picture/exit.png"/>
</Property>
<Property name="mnemonic" type="int" value="75"/>
<Property name="text" type="java.lang.String" value="Keluar"/>
<Property name="toolTipText" type="java.lang.String" value="Alt+K"/>
<Property name="name" type="java.lang.String" value="BtnKeluar3" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 30]"/>
</Property>
</Properties>
<Events>
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="BtnKeluar3ActionPerformed"/>
<EventHandler event="keyPressed" listener="java.awt.event.KeyListener" parameters="java.awt.event.KeyEvent" handler="BtnKeluar3KeyPressed"/>
</Events>
</Component>
</SubComponents>
</Container>
</SubComponents>
</Container>
</SubComponents>
</Form>
@@ -0,0 +1,329 @@
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

/*
* DlgSpesialis.java
*
* Created on May 23, 2010, 1:25:13 AM
*/

package grafikanalisa;

import fungsi.koneksiDB;
import fungsi.sekuel;
import fungsi.validasi;
import java.sql.Connection;
import java.sql.ResultSet;
import javax.swing.ImageIcon;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartFrame;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.plot.PlotOrientation;
import org.jfree.data.category.DefaultCategoryDataset;
import org.jfree.data.general.DefaultPieDataset;

/**
*
* @author dosen
*/
public class GrafikLabRalanPerTahun extends javax.swing.JDialog {
private final Connection koneksi=koneksiDB.condb();
private final validasi Valid=new validasi();
private ResultSet rs;

/** Creates new form DlgSpesialis
* @param parent
* @param modal */
public GrafikLabRalanPerTahun(java.awt.Frame parent, boolean modal) {
super(parent, modal);
initComponents();


}

/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
private void initComponents() {

internalFrame1 = new widget.InternalFrame();
panelBiasa3 = new widget.PanelBiasa();
panelGlass5 = new widget.panelisi();
jLabel33 = new widget.Label();
Tanggal1 = new widget.Tanggal();
jLabel32 = new widget.Label();
Tanggal2 = new widget.Tanggal();
jLabel34 = new widget.Label();
BtnPrint4 = new widget.Button();
BtnPrint3 = new widget.Button();
BtnPrint5 = new widget.Button();
BtnKeluar3 = new widget.Button();

setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setUndecorated(true);
setResizable(false);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowActivated(java.awt.event.WindowEvent evt) {
formWindowActivated(evt);
}
public void windowOpened(java.awt.event.WindowEvent evt) {
formWindowOpened(evt);
}
});

internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Grafik Kunjungan Laboratorium Rawat Jalan Per Tahun ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));

panelBiasa3.setName("panelBiasa3"); // NOI18N
panelBiasa3.setLayout(null);
internalFrame1.add(panelBiasa3, java.awt.BorderLayout.CENTER);

panelGlass5.setName("panelGlass5"); // NOI18N
panelGlass5.setPreferredSize(new java.awt.Dimension(55, 55));
panelGlass5.setLayout(new java.awt.FlowLayout(java.awt.FlowLayout.LEFT, 5, 9));

jLabel33.setText("Periode Kunjungan :");
jLabel33.setName("jLabel33"); // NOI18N
jLabel33.setPreferredSize(new java.awt.Dimension(105, 23));
panelGlass5.add(jLabel33);

Tanggal1.setEditable(false);
Tanggal1.setForeground(new java.awt.Color(50, 70, 50));
Tanggal1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "12-01-2018" }));
Tanggal1.setDisplayFormat("dd-MM-yyyy");
Tanggal1.setName("Tanggal1"); // NOI18N
Tanggal1.setOpaque(false);
Tanggal1.setPreferredSize(new java.awt.Dimension(100, 23));
panelGlass5.add(Tanggal1);

jLabel32.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel32.setText("s/d");
jLabel32.setName("jLabel32"); // NOI18N
jLabel32.setPreferredSize(new java.awt.Dimension(25, 23));
panelGlass5.add(jLabel32);

Tanggal2.setEditable(false);
Tanggal2.setForeground(new java.awt.Color(50, 70, 50));
Tanggal2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "12-01-2018" }));
Tanggal2.setDisplayFormat("dd-MM-yyyy");
Tanggal2.setName("Tanggal2"); // NOI18N
Tanggal2.setOpaque(false);
Tanggal2.setPreferredSize(new java.awt.Dimension(100, 23));
panelGlass5.add(Tanggal2);

jLabel34.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel34.setName("jLabel34"); // NOI18N
jLabel34.setPreferredSize(new java.awt.Dimension(25, 23));
panelGlass5.add(jLabel34);

BtnPrint4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Bar Chart (copy).png"))); // NOI18N
BtnPrint4.setMnemonic('G');
BtnPrint4.setText("Plot");
BtnPrint4.setToolTipText("Alt+G");
BtnPrint4.setName("BtnPrint4"); // NOI18N
BtnPrint4.setPreferredSize(new java.awt.Dimension(100, 30));
BtnPrint4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnPrint4ActionPerformed(evt);
}
});
BtnPrint4.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
BtnPrint4KeyPressed(evt);
}
});
panelGlass5.add(BtnPrint4);

BtnPrint3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Bar Chart (copy).png"))); // NOI18N
BtnPrint3.setMnemonic('G');
BtnPrint3.setText("Batang");
BtnPrint3.setToolTipText("Alt+G");
BtnPrint3.setName("BtnPrint3"); // NOI18N
BtnPrint3.setPreferredSize(new java.awt.Dimension(100, 30));
BtnPrint3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnPrint3ActionPerformed(evt);
}
});
BtnPrint3.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
BtnPrint3KeyPressed(evt);
}
});
panelGlass5.add(BtnPrint3);

BtnPrint5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Bar Chart (copy).png"))); // NOI18N
BtnPrint5.setMnemonic('G');
BtnPrint5.setText("Pie");
BtnPrint5.setToolTipText("Alt+G");
BtnPrint5.setName("BtnPrint5"); // NOI18N
BtnPrint5.setPreferredSize(new java.awt.Dimension(100, 30));
BtnPrint5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnPrint5ActionPerformed(evt);
}
});
BtnPrint5.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
BtnPrint5KeyPressed(evt);
}
});
panelGlass5.add(BtnPrint5);

BtnKeluar3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/exit.png"))); // NOI18N
BtnKeluar3.setMnemonic('K');
BtnKeluar3.setText("Keluar");
BtnKeluar3.setToolTipText("Alt+K");
BtnKeluar3.setName("BtnKeluar3"); // NOI18N
BtnKeluar3.setPreferredSize(new java.awt.Dimension(100, 30));
BtnKeluar3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnKeluar3ActionPerformed(evt);
}
});
BtnKeluar3.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
BtnKeluar3KeyPressed(evt);
}
});
panelGlass5.add(BtnKeluar3);

internalFrame1.add(panelGlass5, java.awt.BorderLayout.PAGE_END);

getContentPane().add(internalFrame1, java.awt.BorderLayout.CENTER);

pack();
}// </editor-fold>//GEN-END:initComponents

private void formWindowOpened(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowOpened

}//GEN-LAST:event_formWindowOpened

private void formWindowActivated(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowActivated

}//GEN-LAST:event_formWindowActivated

private void BtnPrint3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPrint3ActionPerformed
DefaultCategoryDataset dcd = new DefaultCategoryDataset();
try {
rs = koneksi.prepareStatement("select year(reg_periksa.tgl_registrasi),count(distinct reg_periksa.no_rawat) as jumlah from reg_periksa inner join periksa_lab on reg_periksa.no_rawat=periksa_lab.no_rawat "+
"where reg_periksa.tgl_registrasi between '"+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tanggal2.getSelectedItem()+"")+"' and reg_periksa.status_lanjut='Ralan' "+
"group by year(reg_periksa.tgl_registrasi)").executeQuery();
while(rs.next()) {
dcd.setValue(rs.getDouble(2),rs.getString(1)+"("+rs.getString(2)+")",rs.getString(1));
}

if(rs!=null){
rs.close();
}
} catch (Exception e) {
System.out.println("Notifikasi : " + e);
}
JFreeChart freeChart = ChartFactory.createBarChart("Grafik Kunjungan Lab Rawat Jalan Per Tahun Tanggal "+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+" S.D. "+Valid.SetTgl(Tanggal2.getSelectedItem()+""),"Tahun","Jumlah Pasien", dcd, PlotOrientation.VERTICAL,true, true,true);
ChartFrame cf = new ChartFrame("Grafik Kunjungan Lab Rawat Jalan Per Tahun",freeChart);
cf.setSize(panelBiasa3.getWidth(),panelBiasa3.getHeight());
cf.setModalExclusionType(ModalExclusionType.APPLICATION_EXCLUDE);
cf.setLocationRelativeTo(panelBiasa3);
cf.setAlwaysOnTop(true);
cf.setIconImage(new ImageIcon(super.getClass().getResource("/picture/addressbook-edit24.png")).getImage());
cf.setVisible(true);
}//GEN-LAST:event_BtnPrint3ActionPerformed

private void BtnPrint3KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnPrint3KeyPressed

}//GEN-LAST:event_BtnPrint3KeyPressed

private void BtnKeluar3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnKeluar3ActionPerformed
dispose();
}//GEN-LAST:event_BtnKeluar3ActionPerformed

private void BtnKeluar3KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnKeluar3KeyPressed

}//GEN-LAST:event_BtnKeluar3KeyPressed

private void BtnPrint4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPrint4ActionPerformed
grafiksql2 kas=new grafiksql2("Grafik Kunjungan Lab Rawat Jalan Per Tahun Tanggal "+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+" S.D. "+Valid.SetTgl(Tanggal2.getSelectedItem()+""),
"select year(reg_periksa.tgl_registrasi),count(distinct reg_periksa.no_rawat) as jumlah from reg_periksa inner join periksa_lab on reg_periksa.no_rawat=periksa_lab.no_rawat "+
"where reg_periksa.tgl_registrasi between '"+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tanggal2.getSelectedItem()+"")+"' and reg_periksa.status_lanjut='Ralan' "+
"group by year(reg_periksa.tgl_registrasi)","Tahun");
kas.setSize(panelBiasa3.getWidth(),panelBiasa3.getHeight());
kas.setModal(true);
kas.setAlwaysOnTop(true);
kas.setLocationRelativeTo(panelBiasa3);
kas.setVisible(true);
}//GEN-LAST:event_BtnPrint4ActionPerformed

private void BtnPrint4KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnPrint4KeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_BtnPrint4KeyPressed

private void BtnPrint5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPrint5ActionPerformed
DefaultPieDataset dpd = new DefaultPieDataset();
try {
rs = koneksi.prepareStatement("select year(reg_periksa.tgl_registrasi),count(distinct reg_periksa.no_rawat) as jumlah from reg_periksa inner join periksa_lab on reg_periksa.no_rawat=periksa_lab.no_rawat "+
"where reg_periksa.tgl_registrasi between '"+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tanggal2.getSelectedItem()+"")+"' and reg_periksa.status_lanjut='Ralan' "+
"group by year(reg_periksa.tgl_registrasi)").executeQuery();
while(rs.next()) {
dpd.setValue(rs.getString(1)+"("+rs.getString(2)+")",rs.getDouble(2));
}

if(rs!=null){
rs.close();
}
} catch (Exception e) {
System.out.println("Notifikasi : " + e);
}

JFreeChart freeChart = ChartFactory.createPieChart("Grafik Kunjungan Lab Rawat Jalan Per Tahun Tanggal "+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+" S.D. "+Valid.SetTgl(Tanggal2.getSelectedItem()+""),dpd,true,true, false); //String title,PieDatasheet datasheet,boolean legends,boolean tooltips,boolean url
ChartFrame cf = new ChartFrame("Grafik Kunjungan Lab Rawat Jalan Per Tahun",freeChart);
cf.setSize(panelBiasa3.getWidth(),panelBiasa3.getHeight());
cf.setLocationRelativeTo(panelBiasa3);
cf.setModalExclusionType(ModalExclusionType.APPLICATION_EXCLUDE);
cf.setAlwaysOnTop(true);
cf.setIconImage(new ImageIcon(super.getClass().getResource("/picture/addressbook-edit24.png")).getImage());
cf.setVisible(true);
}//GEN-LAST:event_BtnPrint5ActionPerformed

private void BtnPrint5KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnPrint5KeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_BtnPrint5KeyPressed

/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(() -> {
GrafikLabRalanPerTahun dialog = new GrafikLabRalanPerTahun(new javax.swing.JFrame(), true);
dialog.addWindowListener(new java.awt.event.WindowAdapter() {
@Override
public void windowClosing(java.awt.event.WindowEvent e) {
System.exit(0);
}
});
dialog.setVisible(true);
});
}

// Variables declaration - do not modify//GEN-BEGIN:variables
private widget.Button BtnKeluar3;
private widget.Button BtnPrint3;
private widget.Button BtnPrint4;
private widget.Button BtnPrint5;
private widget.Tanggal Tanggal1;
private widget.Tanggal Tanggal2;
private widget.InternalFrame internalFrame1;
private widget.Label jLabel32;
private widget.Label jLabel33;
private widget.Label jLabel34;
private widget.PanelBiasa panelBiasa3;
private widget.panelisi panelGlass5;
// End of variables declaration//GEN-END:variables

}
@@ -0,0 +1,235 @@
<?xml version="1.0" encoding="UTF-8" ?>

<Form version="1.5" maxVersion="1.7" type="org.netbeans.modules.form.forminfo.JDialogFormInfo">
<Properties>
<Property name="defaultCloseOperation" type="int" value="2"/>
<Property name="undecorated" type="boolean" value="true"/>
<Property name="resizable" type="boolean" value="false"/>
</Properties>
<SyntheticProperties>
<SyntheticProperty name="formSizePolicy" type="int" value="1"/>
<SyntheticProperty name="generateCenter" type="boolean" value="false"/>
</SyntheticProperties>
<Events>
<EventHandler event="windowActivated" listener="java.awt.event.WindowListener" parameters="java.awt.event.WindowEvent" handler="formWindowActivated"/>
<EventHandler event="windowOpened" listener="java.awt.event.WindowListener" parameters="java.awt.event.WindowEvent" handler="formWindowOpened"/>
</Events>
<AuxValues>
<AuxValue name="FormSettings_autoResourcing" type="java.lang.Integer" value="0"/>
<AuxValue name="FormSettings_autoSetComponentName" type="java.lang.Boolean" value="true"/>
<AuxValue name="FormSettings_generateFQN" type="java.lang.Boolean" value="true"/>
<AuxValue name="FormSettings_generateMnemonicsCode" type="java.lang.Boolean" value="false"/>
<AuxValue name="FormSettings_i18nAutoMode" type="java.lang.Boolean" value="false"/>
<AuxValue name="FormSettings_layoutCodeTarget" type="java.lang.Integer" value="1"/>
<AuxValue name="FormSettings_listenerGenerationStyle" type="java.lang.Integer" value="0"/>
<AuxValue name="FormSettings_variablesLocal" type="java.lang.Boolean" value="false"/>
<AuxValue name="FormSettings_variablesModifier" type="java.lang.Integer" value="2"/>
<AuxValue name="designerSize" type="java.awt.Dimension" value="-84,-19,0,5,115,114,0,18,106,97,118,97,46,97,119,116,46,68,105,109,101,110,115,105,111,110,65,-114,-39,-41,-84,95,68,20,2,0,2,73,0,6,104,101,105,103,104,116,73,0,5,119,105,100,116,104,120,112,0,0,1,48,0,0,3,-65"/>
</AuxValues>

<Layout class="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout"/>
<SubComponents>
<Container class="widget.InternalFrame" name="internalFrame1">
<Properties>
<Property name="border" type="javax.swing.border.Border" editor="org.netbeans.modules.form.editors2.BorderEditor">
<Border info="org.netbeans.modules.form.compat2.border.TitledBorderInfo">
<TitledBorder title="::[ Grafik Kunjungan Radiologi Rawat Jalan Per Tahun ]::">
<Border PropertyName="innerBorder" info="org.netbeans.modules.form.compat2.border.LineBorderInfo">
<LineBorder>
<Color PropertyName="color" blue="eb" green="f5" red="f0" type="rgb"/>
</LineBorder>
</Border>
<Font PropertyName="font" name="Tahoma" size="11" style="0"/>
<Color PropertyName="color" blue="50" green="78" red="5a" type="rgb"/>
</TitledBorder>
</Border>
</Property>
<Property name="name" type="java.lang.String" value="internalFrame1" noResource="true"/>
</Properties>
<Constraints>
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout" value="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout$BorderConstraintsDescription">
<BorderConstraints direction="Center"/>
</Constraint>
</Constraints>

<Layout class="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout">
<Property name="horizontalGap" type="int" value="1"/>
<Property name="verticalGap" type="int" value="1"/>
</Layout>
<SubComponents>
<Container class="widget.PanelBiasa" name="panelBiasa3">
<Properties>
<Property name="name" type="java.lang.String" value="panelBiasa3" noResource="true"/>
</Properties>
<Constraints>
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout" value="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout$BorderConstraintsDescription">
<BorderConstraints direction="Center"/>
</Constraint>
</Constraints>

<Layout class="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout">
<Property name="useNullLayout" type="boolean" value="true"/>
</Layout>
</Container>
<Container class="widget.panelisi" name="panelGlass5">
<Properties>
<Property name="name" type="java.lang.String" value="panelGlass5" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[55, 55]"/>
</Property>
</Properties>
<Constraints>
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout" value="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout$BorderConstraintsDescription">
<BorderConstraints direction="Last"/>
</Constraint>
</Constraints>

<Layout class="org.netbeans.modules.form.compat2.layouts.DesignFlowLayout">
<Property name="alignment" type="int" value="0"/>
<Property name="verticalGap" type="int" value="9"/>
</Layout>
<SubComponents>
<Component class="widget.Label" name="jLabel33">
<Properties>
<Property name="text" type="java.lang.String" value="Periode Kunjungan :"/>
<Property name="name" type="java.lang.String" value="jLabel33" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[105, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.Tanggal" name="Tanggal1">
<Properties>
<Property name="editable" type="boolean" value="false"/>
<Property name="foreground" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor">
<Color blue="32" green="46" red="32" type="rgb"/>
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="12-01-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
<Property name="name" type="java.lang.String" value="Tanggal1" noResource="true"/>
<Property name="opaque" type="boolean" value="false"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.Label" name="jLabel32">
<Properties>
<Property name="horizontalAlignment" type="int" value="0"/>
<Property name="text" type="java.lang.String" value="s/d"/>
<Property name="name" type="java.lang.String" value="jLabel32" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[25, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.Tanggal" name="Tanggal2">
<Properties>
<Property name="editable" type="boolean" value="false"/>
<Property name="foreground" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor">
<Color blue="32" green="46" red="32" type="rgb"/>
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="12-01-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
<Property name="name" type="java.lang.String" value="Tanggal2" noResource="true"/>
<Property name="opaque" type="boolean" value="false"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.Label" name="jLabel34">
<Properties>
<Property name="horizontalAlignment" type="int" value="0"/>
<Property name="name" type="java.lang.String" value="jLabel34" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[25, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.Button" name="BtnPrint4">
<Properties>
<Property name="icon" type="javax.swing.Icon" noResource="true" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/picture/Bar Chart (copy).png"/>
</Property>
<Property name="mnemonic" type="int" value="71"/>
<Property name="text" type="java.lang.String" value="Plot"/>
<Property name="toolTipText" type="java.lang.String" value="Alt+G"/>
<Property name="name" type="java.lang.String" value="BtnPrint4" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 30]"/>
</Property>
</Properties>
<Events>
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="BtnPrint4ActionPerformed"/>
<EventHandler event="keyPressed" listener="java.awt.event.KeyListener" parameters="java.awt.event.KeyEvent" handler="BtnPrint4KeyPressed"/>
</Events>
</Component>
<Component class="widget.Button" name="BtnPrint3">
<Properties>
<Property name="icon" type="javax.swing.Icon" noResource="true" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/picture/Bar Chart (copy).png"/>
</Property>
<Property name="mnemonic" type="int" value="71"/>
<Property name="text" type="java.lang.String" value="Batang"/>
<Property name="toolTipText" type="java.lang.String" value="Alt+G"/>
<Property name="name" type="java.lang.String" value="BtnPrint3" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 30]"/>
</Property>
</Properties>
<Events>
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="BtnPrint3ActionPerformed"/>
<EventHandler event="keyPressed" listener="java.awt.event.KeyListener" parameters="java.awt.event.KeyEvent" handler="BtnPrint3KeyPressed"/>
</Events>
</Component>
<Component class="widget.Button" name="BtnPrint5">
<Properties>
<Property name="icon" type="javax.swing.Icon" noResource="true" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/picture/Bar Chart (copy).png"/>
</Property>
<Property name="mnemonic" type="int" value="71"/>
<Property name="text" type="java.lang.String" value="Pie"/>
<Property name="toolTipText" type="java.lang.String" value="Alt+G"/>
<Property name="name" type="java.lang.String" value="BtnPrint5" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 30]"/>
</Property>
</Properties>
<Events>
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="BtnPrint5ActionPerformed"/>
<EventHandler event="keyPressed" listener="java.awt.event.KeyListener" parameters="java.awt.event.KeyEvent" handler="BtnPrint5KeyPressed"/>
</Events>
</Component>
<Component class="widget.Button" name="BtnKeluar3">
<Properties>
<Property name="icon" type="javax.swing.Icon" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/picture/exit.png"/>
</Property>
<Property name="mnemonic" type="int" value="75"/>
<Property name="text" type="java.lang.String" value="Keluar"/>
<Property name="toolTipText" type="java.lang.String" value="Alt+K"/>
<Property name="name" type="java.lang.String" value="BtnKeluar3" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 30]"/>
</Property>
</Properties>
<Events>
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="BtnKeluar3ActionPerformed"/>
<EventHandler event="keyPressed" listener="java.awt.event.KeyListener" parameters="java.awt.event.KeyEvent" handler="BtnKeluar3KeyPressed"/>
</Events>
</Component>
</SubComponents>
</Container>
</SubComponents>
</Container>
</SubComponents>
</Form>
@@ -0,0 +1,329 @@
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

/*
* DlgSpesialis.java
*
* Created on May 23, 2010, 1:25:13 AM
*/

package grafikanalisa;

import fungsi.koneksiDB;
import fungsi.sekuel;
import fungsi.validasi;
import java.sql.Connection;
import java.sql.ResultSet;
import javax.swing.ImageIcon;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartFrame;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.plot.PlotOrientation;
import org.jfree.data.category.DefaultCategoryDataset;
import org.jfree.data.general.DefaultPieDataset;

/**
*
* @author dosen
*/
public class GrafikRadRalanPerTahun extends javax.swing.JDialog {
private final Connection koneksi=koneksiDB.condb();
private final validasi Valid=new validasi();
private ResultSet rs;

/** Creates new form DlgSpesialis
* @param parent
* @param modal */
public GrafikRadRalanPerTahun(java.awt.Frame parent, boolean modal) {
super(parent, modal);
initComponents();


}

/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
private void initComponents() {

internalFrame1 = new widget.InternalFrame();
panelBiasa3 = new widget.PanelBiasa();
panelGlass5 = new widget.panelisi();
jLabel33 = new widget.Label();
Tanggal1 = new widget.Tanggal();
jLabel32 = new widget.Label();
Tanggal2 = new widget.Tanggal();
jLabel34 = new widget.Label();
BtnPrint4 = new widget.Button();
BtnPrint3 = new widget.Button();
BtnPrint5 = new widget.Button();
BtnKeluar3 = new widget.Button();

setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setUndecorated(true);
setResizable(false);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowActivated(java.awt.event.WindowEvent evt) {
formWindowActivated(evt);
}
public void windowOpened(java.awt.event.WindowEvent evt) {
formWindowOpened(evt);
}
});

internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Grafik Kunjungan Radiologi Rawat Jalan Per Tahun ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));

panelBiasa3.setName("panelBiasa3"); // NOI18N
panelBiasa3.setLayout(null);
internalFrame1.add(panelBiasa3, java.awt.BorderLayout.CENTER);

panelGlass5.setName("panelGlass5"); // NOI18N
panelGlass5.setPreferredSize(new java.awt.Dimension(55, 55));
panelGlass5.setLayout(new java.awt.FlowLayout(java.awt.FlowLayout.LEFT, 5, 9));

jLabel33.setText("Periode Kunjungan :");
jLabel33.setName("jLabel33"); // NOI18N
jLabel33.setPreferredSize(new java.awt.Dimension(105, 23));
panelGlass5.add(jLabel33);

Tanggal1.setEditable(false);
Tanggal1.setForeground(new java.awt.Color(50, 70, 50));
Tanggal1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "12-01-2018" }));
Tanggal1.setDisplayFormat("dd-MM-yyyy");
Tanggal1.setName("Tanggal1"); // NOI18N
Tanggal1.setOpaque(false);
Tanggal1.setPreferredSize(new java.awt.Dimension(100, 23));
panelGlass5.add(Tanggal1);

jLabel32.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel32.setText("s/d");
jLabel32.setName("jLabel32"); // NOI18N
jLabel32.setPreferredSize(new java.awt.Dimension(25, 23));
panelGlass5.add(jLabel32);

Tanggal2.setEditable(false);
Tanggal2.setForeground(new java.awt.Color(50, 70, 50));
Tanggal2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "12-01-2018" }));
Tanggal2.setDisplayFormat("dd-MM-yyyy");
Tanggal2.setName("Tanggal2"); // NOI18N
Tanggal2.setOpaque(false);
Tanggal2.setPreferredSize(new java.awt.Dimension(100, 23));
panelGlass5.add(Tanggal2);

jLabel34.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel34.setName("jLabel34"); // NOI18N
jLabel34.setPreferredSize(new java.awt.Dimension(25, 23));
panelGlass5.add(jLabel34);

BtnPrint4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Bar Chart (copy).png"))); // NOI18N
BtnPrint4.setMnemonic('G');
BtnPrint4.setText("Plot");
BtnPrint4.setToolTipText("Alt+G");
BtnPrint4.setName("BtnPrint4"); // NOI18N
BtnPrint4.setPreferredSize(new java.awt.Dimension(100, 30));
BtnPrint4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnPrint4ActionPerformed(evt);
}
});
BtnPrint4.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
BtnPrint4KeyPressed(evt);
}
});
panelGlass5.add(BtnPrint4);

BtnPrint3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Bar Chart (copy).png"))); // NOI18N
BtnPrint3.setMnemonic('G');
BtnPrint3.setText("Batang");
BtnPrint3.setToolTipText("Alt+G");
BtnPrint3.setName("BtnPrint3"); // NOI18N
BtnPrint3.setPreferredSize(new java.awt.Dimension(100, 30));
BtnPrint3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnPrint3ActionPerformed(evt);
}
});
BtnPrint3.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
BtnPrint3KeyPressed(evt);
}
});
panelGlass5.add(BtnPrint3);

BtnPrint5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Bar Chart (copy).png"))); // NOI18N
BtnPrint5.setMnemonic('G');
BtnPrint5.setText("Pie");
BtnPrint5.setToolTipText("Alt+G");
BtnPrint5.setName("BtnPrint5"); // NOI18N
BtnPrint5.setPreferredSize(new java.awt.Dimension(100, 30));
BtnPrint5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnPrint5ActionPerformed(evt);
}
});
BtnPrint5.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
BtnPrint5KeyPressed(evt);
}
});
panelGlass5.add(BtnPrint5);

BtnKeluar3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/exit.png"))); // NOI18N
BtnKeluar3.setMnemonic('K');
BtnKeluar3.setText("Keluar");
BtnKeluar3.setToolTipText("Alt+K");
BtnKeluar3.setName("BtnKeluar3"); // NOI18N
BtnKeluar3.setPreferredSize(new java.awt.Dimension(100, 30));
BtnKeluar3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnKeluar3ActionPerformed(evt);
}
});
BtnKeluar3.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
BtnKeluar3KeyPressed(evt);
}
});
panelGlass5.add(BtnKeluar3);

internalFrame1.add(panelGlass5, java.awt.BorderLayout.PAGE_END);

getContentPane().add(internalFrame1, java.awt.BorderLayout.CENTER);

pack();
}// </editor-fold>//GEN-END:initComponents

private void formWindowOpened(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowOpened

}//GEN-LAST:event_formWindowOpened

private void formWindowActivated(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowActivated

}//GEN-LAST:event_formWindowActivated

private void BtnPrint3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPrint3ActionPerformed
DefaultCategoryDataset dcd = new DefaultCategoryDataset();
try {
rs = koneksi.prepareStatement("select year(reg_periksa.tgl_registrasi),count(distinct reg_periksa.no_rawat) as jumlah from reg_periksa inner join periksa_radiologi on reg_periksa.no_rawat=periksa_radiologi.no_rawat "+
"where reg_periksa.tgl_registrasi between '"+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tanggal2.getSelectedItem()+"")+"' and reg_periksa.status_lanjut='Ralan' "+
"group by year(reg_periksa.tgl_registrasi)").executeQuery();
while(rs.next()) {
dcd.setValue(rs.getDouble(2),rs.getString(1)+"("+rs.getString(2)+")",rs.getString(1));
}

if(rs!=null){
rs.close();
}
} catch (Exception e) {
System.out.println("Notifikasi : " + e);
}
JFreeChart freeChart = ChartFactory.createBarChart("Grafik Kunjungan Rad Rawat Jalan Per Tahun Tanggal "+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+" S.D. "+Valid.SetTgl(Tanggal2.getSelectedItem()+""),"Tahun","Jumlah Pasien", dcd, PlotOrientation.VERTICAL,true, true,true);
ChartFrame cf = new ChartFrame("Grafik Kunjungan Rad Rawat Jalan Per Tahun",freeChart);
cf.setSize(panelBiasa3.getWidth(),panelBiasa3.getHeight());
cf.setModalExclusionType(ModalExclusionType.APPLICATION_EXCLUDE);
cf.setLocationRelativeTo(panelBiasa3);
cf.setAlwaysOnTop(true);
cf.setIconImage(new ImageIcon(super.getClass().getResource("/picture/addressbook-edit24.png")).getImage());
cf.setVisible(true);
}//GEN-LAST:event_BtnPrint3ActionPerformed

private void BtnPrint3KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnPrint3KeyPressed

}//GEN-LAST:event_BtnPrint3KeyPressed

private void BtnKeluar3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnKeluar3ActionPerformed
dispose();
}//GEN-LAST:event_BtnKeluar3ActionPerformed

private void BtnKeluar3KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnKeluar3KeyPressed

}//GEN-LAST:event_BtnKeluar3KeyPressed

private void BtnPrint4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPrint4ActionPerformed
grafiksql2 kas=new grafiksql2("Grafik Kunjungan Rad Rawat Jalan Per Tahun Tanggal "+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+" S.D. "+Valid.SetTgl(Tanggal2.getSelectedItem()+""),
"select year(reg_periksa.tgl_registrasi),count(distinct reg_periksa.no_rawat) as jumlah from reg_periksa inner join periksa_radiologi on reg_periksa.no_rawat=periksa_radiologi.no_rawat "+
"where reg_periksa.tgl_registrasi between '"+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tanggal2.getSelectedItem()+"")+"' and reg_periksa.status_lanjut='Ralan' "+
"group by year(reg_periksa.tgl_registrasi)","Tahun");
kas.setSize(panelBiasa3.getWidth(),panelBiasa3.getHeight());
kas.setModal(true);
kas.setAlwaysOnTop(true);
kas.setLocationRelativeTo(panelBiasa3);
kas.setVisible(true);
}//GEN-LAST:event_BtnPrint4ActionPerformed

private void BtnPrint4KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnPrint4KeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_BtnPrint4KeyPressed

private void BtnPrint5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPrint5ActionPerformed
DefaultPieDataset dpd = new DefaultPieDataset();
try {
rs = koneksi.prepareStatement("select year(reg_periksa.tgl_registrasi),count(distinct reg_periksa.no_rawat) as jumlah from reg_periksa inner join periksa_radiologi on reg_periksa.no_rawat=periksa_radiologi.no_rawat "+
"where reg_periksa.tgl_registrasi between '"+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tanggal2.getSelectedItem()+"")+"' and reg_periksa.status_lanjut='Ralan' "+
"group by year(reg_periksa.tgl_registrasi)").executeQuery();
while(rs.next()) {
dpd.setValue(rs.getString(1)+"("+rs.getString(2)+")",rs.getDouble(2));
}

if(rs!=null){
rs.close();
}
} catch (Exception e) {
System.out.println("Notifikasi : " + e);
}

JFreeChart freeChart = ChartFactory.createPieChart("Grafik Kunjungan Rad Rawat Jalan Per Tahun Tanggal "+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+" S.D. "+Valid.SetTgl(Tanggal2.getSelectedItem()+""),dpd,true,true, false); //String title,PieDatasheet datasheet,boolean legends,boolean tooltips,boolean url
ChartFrame cf = new ChartFrame("Grafik Kunjungan Rad Rawat Jalan Per Tahun",freeChart);
cf.setSize(panelBiasa3.getWidth(),panelBiasa3.getHeight());
cf.setLocationRelativeTo(panelBiasa3);
cf.setModalExclusionType(ModalExclusionType.APPLICATION_EXCLUDE);
cf.setAlwaysOnTop(true);
cf.setIconImage(new ImageIcon(super.getClass().getResource("/picture/addressbook-edit24.png")).getImage());
cf.setVisible(true);
}//GEN-LAST:event_BtnPrint5ActionPerformed

private void BtnPrint5KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnPrint5KeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_BtnPrint5KeyPressed

/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(() -> {
GrafikRadRalanPerTahun dialog = new GrafikRadRalanPerTahun(new javax.swing.JFrame(), true);
dialog.addWindowListener(new java.awt.event.WindowAdapter() {
@Override
public void windowClosing(java.awt.event.WindowEvent e) {
System.exit(0);
}
});
dialog.setVisible(true);
});
}

// Variables declaration - do not modify//GEN-BEGIN:variables
private widget.Button BtnKeluar3;
private widget.Button BtnPrint3;
private widget.Button BtnPrint4;
private widget.Button BtnPrint5;
private widget.Tanggal Tanggal1;
private widget.Tanggal Tanggal2;
private widget.InternalFrame internalFrame1;
private widget.Label jLabel32;
private widget.Label jLabel33;
private widget.Label jLabel34;
private widget.PanelBiasa panelBiasa3;
private widget.panelisi panelGlass5;
// End of variables declaration//GEN-END:variables

}
@@ -98,7 +98,7 @@ public DlgUser(java.awt.Frame parent, boolean modal) {
"[N]Reg Lama Per Tanggal","[N]Reg Baru Per Tanggal","[N]Batal Periksa Per Tahun","[N]Batal Periksa Per Bulan","[K]Referensi Diagnosa Pcare","[N]Batal Periksa Per Tanggal",
"[D]Kategori Obat/Alkes/BHP","[D]Golongan Obat/Alkes/BHP","[D]Obat/Alkes/BHP Per Tanggal","[D]Penjualan Bebas Per Tanggal","[K]Referensi Kesadaran Pcare","[I]Pembatalan Periksa Per Dokter",
"[H]Pembayaran Per Unit","[H]Rekap Pembayaran Per Unit","[N]Kunjungan Reg Per Cara Bayar","[E]Pengadaan Non Medis Per Tanggal","[E]Stok Keluar Non Medis Per Tanggal",
"[N]Kunjungan Ranap Per Tahun","[K]Cek Rujukan PCare"
"[N]Kunjungan Ranap Per Tahun","[K]Cek Rujukan PCare","[N]Kunjungan Lab Ralan Per Tahun","[N]Kunjungan Rad Ralan Per Tahun"
};

tabMode=new DefaultTableModel(null,row){
@@ -193,7 +193,7 @@ public Class getColumnClass(int columnIndex) {
tbUser.setPreferredScrollableViewportSize(new Dimension(500,500));
tbUser.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

for (i = 0; i < 280;i++) {
for (i = 0; i < 282;i++) {
TableColumn column = tbUser.getColumnModel().getColumn(i);
if(i==0){
column.setPreferredWidth(130);
@@ -389,6 +389,10 @@ public Class getColumnClass(int columnIndex) {
column.setPreferredWidth(159);
}else if(i==279){
column.setPreferredWidth(112);
}else if(i==280){
column.setPreferredWidth(175);
}else if(i==281){
column.setPreferredWidth(176);
}else{
column.setPreferredWidth(120);
}
@@ -823,7 +827,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false',"+
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false',"+
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false',"+
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false'","User")==true){
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false'","User")==true){
tampil();
emptTeks();
}
@@ -1145,7 +1149,9 @@ private void BtnEditActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST
"ipsrs_pengadaan_pertanggal='"+tbUser.getValueAt(i,276).toString()+"',"+
"ipsrs_stokkeluar_pertanggal='"+tbUser.getValueAt(i,277).toString()+"',"+
"grafik_kunjungan_ranaptahun='"+tbUser.getValueAt(i,278).toString()+"',"+
"pcare_cek_rujukan='"+tbUser.getValueAt(i,279).toString()+"'");
"pcare_cek_rujukan='"+tbUser.getValueAt(i,279).toString()+"',"+
"grafik_lab_ralantahun='"+tbUser.getValueAt(i,280).toString()+"',"+
"grafik_rad_ralantahun='"+tbUser.getValueAt(i,281).toString()+"'");
}
tampil();
emptTeks();
@@ -1418,7 +1424,7 @@ private void tampil() {
"pcare_cek_penyakit,grafik_kunjungan_statusbataltanggal,kategori_barang,golongan_barang,pemberian_obat_pertanggal,"+
"penjualan_obat_pertanggal,pcare_cek_kesadaran,pembatalan_periksa_dokter,pembayaran_per_unit,rekap_pembayaran_per_unit, "+
"grafik_kunjungan_percarabayar,ipsrs_pengadaan_pertanggal,ipsrs_stokkeluar_pertanggal,grafik_kunjungan_ranaptahun,"+
"pcare_cek_rujukan from user order by AES_DECRYPT(id_user,'nur')");
"pcare_cek_rujukan,grafik_lab_ralantahun,grafik_rad_ralantahun from user order by AES_DECRYPT(id_user,'nur')");
try {
rs=ps.executeQuery();
while(rs.next()){
@@ -1709,7 +1715,9 @@ private void tampil() {
rs.getBoolean("ipsrs_pengadaan_pertanggal"),
rs.getBoolean("ipsrs_stokkeluar_pertanggal"),
rs.getBoolean("grafik_kunjungan_ranaptahun"),
rs.getBoolean("pcare_cek_rujukan")
rs.getBoolean("pcare_cek_rujukan"),
rs.getBoolean("grafik_lab_ralantahun"),
rs.getBoolean("grafik_rad_ralantahun")
});
}
} catch (Exception e) {
@@ -1990,7 +1998,9 @@ private void tampil() {
rs.getBoolean("ipsrs_pengadaan_pertanggal"),
rs.getBoolean("ipsrs_stokkeluar_pertanggal"),
rs.getBoolean("grafik_kunjungan_ranaptahun"),
rs.getBoolean("pcare_cek_rujukan")
rs.getBoolean("pcare_cek_rujukan"),
rs.getBoolean("grafik_lab_ralantahun"),
rs.getBoolean("grafik_rad_ralantahun")
});
}
}
@@ -3960,7 +3960,7 @@
<AuxValue name="FormSettings_listenerGenerationStyle" type="java.lang.Integer" value="0"/>
<AuxValue name="FormSettings_variablesLocal" type="java.lang.Boolean" value="false"/>
<AuxValue name="FormSettings_variablesModifier" type="java.lang.Integer" value="2"/>
<AuxValue name="designerSize" type="java.awt.Dimension" value="-84,-19,0,5,115,114,0,18,106,97,118,97,46,97,119,116,46,68,105,109,101,110,115,105,111,110,65,-114,-39,-41,-84,95,68,20,2,0,2,73,0,6,104,101,105,103,104,116,73,0,5,119,105,100,116,104,120,112,0,0,1,-85,0,0,3,-118"/>
<AuxValue name="designerSize" type="java.awt.Dimension" value="-84,-19,0,5,115,114,0,18,106,97,118,97,46,97,119,116,46,68,105,109,101,110,115,105,111,110,65,-114,-39,-41,-84,95,68,20,2,0,2,73,0,6,104,101,105,103,104,116,73,0,5,119,105,100,116,104,120,112,0,0,1,-85,0,0,3,-128"/>
</AuxValues>

<Layout class="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout"/>
@@ -4240,7 +4240,7 @@
<Property name="editable" type="boolean" value="false"/>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="30-12-2017"/>
<StringItem index="0" value="12-01-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -4269,7 +4269,7 @@
<Property name="editable" type="boolean" value="false"/>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="30-12-2017"/>
<StringItem index="0" value="12-01-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -4318,22 +4318,6 @@
</Container>
</SubComponents>
</Container>
<Container class="javax.swing.JPanel" name="PanelInput">
<Properties>
<Property name="name" type="java.lang.String" value="PanelInput" noResource="true"/>
<Property name="opaque" type="boolean" value="false"/>
</Properties>
<Constraints>
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout" value="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout$BorderConstraintsDescription">
<BorderConstraints direction="First"/>
</Constraint>
</Constraints>

<Layout class="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout">
<Property name="horizontalGap" type="int" value="1"/>
<Property name="verticalGap" type="int" value="1"/>
</Layout>
</Container>
<Container class="javax.swing.JTabbedPane" name="TabRawat">
<Properties>
<Property name="background" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor">
@@ -4435,6 +4419,109 @@
</Container>
</SubComponents>
</Container>
<Container class="widget.panelisi" name="panelGlass9">
<Properties>
<Property name="name" type="java.lang.String" value="panelGlass9" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[44, 44]"/>
</Property>
</Properties>
<Constraints>
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout" value="org.netbeans.modules.form.compat2.layouts.DesignBorderLayout$BorderConstraintsDescription">
<BorderConstraints direction="First"/>
</Constraint>
</Constraints>

<Layout class="org.netbeans.modules.form.compat2.layouts.DesignFlowLayout">
<Property name="alignment" type="int" value="0"/>
<Property name="verticalGap" type="int" value="9"/>
</Layout>
<SubComponents>
<Component class="widget.Label" name="jLabel4">
<Properties>
<Property name="text" type="java.lang.String" value="No. Rawat :"/>
<Property name="name" type="java.lang.String" value="jLabel4" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[70, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.TextBox" name="TNoRw1">
<Properties>
<Property name="highlighter" type="javax.swing.text.Highlighter" editor="org.netbeans.modules.form.ComponentChooserEditor">
<ComponentRef name="null"/>
</Property>
<Property name="name" type="java.lang.String" value="TNoRw1" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[140, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.Label" name="jLabel5">
<Properties>
<Property name="text" type="java.lang.String" value="No. Reg. :"/>
<Property name="name" type="java.lang.String" value="jLabel5" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[70, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.TextBox" name="TNoReg">
<Properties>
<Property name="highlighter" type="javax.swing.text.Highlighter" editor="org.netbeans.modules.form.ComponentChooserEditor">
<ComponentRef name="null"/>
</Property>
<Property name="name" type="java.lang.String" value="TNoReg" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[70, 23]"/>
</Property>
</Properties>
<Events>
<EventHandler event="keyPressed" listener="java.awt.event.KeyListener" parameters="java.awt.event.KeyEvent" handler="TNoRegKeyPressed"/>
</Events>
</Component>
<Component class="widget.Label" name="jLabel7">
<Properties>
<Property name="text" type="java.lang.String" value="No.R.M. :"/>
<Property name="name" type="java.lang.String" value="jLabel7" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[65, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.TextBox" name="TNoRM">
<Properties>
<Property name="highlighter" type="javax.swing.text.Highlighter" editor="org.netbeans.modules.form.ComponentChooserEditor">
<ComponentRef name="null"/>
</Property>
<Property name="name" type="java.lang.String" value="TNoRM" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[100, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.Label" name="jLabel8">
<Properties>
<Property name="text" type="java.lang.String" value="Nama Pasien :"/>
<Property name="name" type="java.lang.String" value="jLabel8" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[85, 23]"/>
</Property>
</Properties>
</Component>
<Component class="widget.TextBox" name="TPasien">
<Properties>
<Property name="highlighter" type="javax.swing.text.Highlighter" editor="org.netbeans.modules.form.ComponentChooserEditor">
<ComponentRef name="null"/>
</Property>
<Property name="name" type="java.lang.String" value="TPasien" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[200, 23]"/>
</Property>
</Properties>
</Component>
</SubComponents>
</Container>
</SubComponents>
</Container>
</SubComponents>