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 +12.3 KB (100%) dist/SIMRSKhanza.jar
Binary file not shown.
171 sik.sql

Large diffs are not rendered by default.

@@ -77,7 +77,8 @@ public final class var {
hutang_barang_non_medis=false,rekap_pemesanan_non_medis=false,insiden_keselamatan=false,insiden_keselamatan_pasien=false,grafik_ikp_pertahun=false,
grafik_ikp_perbulan=false,grafik_ikp_pertanggal=false,riwayat_data_batch=false,grafik_ikp_jenis=false,grafik_ikp_dampak=false,piutang_akun_piutang=false,
grafik_kunjungan_per_agama=false,grafik_kunjungan_per_umur=false,suku_bangsa=false,bahasa_pasien=false,golongan_tni=false,satuan_tni=false,
jabatan_tni=false,pangkat_tni=false,golongan_polri=false,satuan_polri=false,jabatan_polri=false,pangkat_polri=false,cacat_fisik=false;
jabatan_tni=false,pangkat_tni=false,golongan_polri=false,satuan_polri=false,jabatan_polri=false,pangkat_polri=false,cacat_fisik=false,
grafik_kunjungan_suku=false;

public static void setData(String user, String pass) {
try {
@@ -449,6 +450,7 @@ public static void setData(String user, String pass) {
var.jabatan_polri=true;
var.pangkat_polri=true;
var.cacat_fisik=true;
var.grafik_kunjungan_suku=true;
}else if(rs2.getRow()>=1){
rs2.beforeFirst();
rs2.next();
@@ -804,6 +806,7 @@ public static void setData(String user, String pass) {
var.jabatan_polri=rs2.getBoolean("jabatan_polri");
var.pangkat_polri=rs2.getBoolean("pangkat_polri");
var.cacat_fisik=rs2.getBoolean("cacat_fisik");
var.grafik_kunjungan_suku=rs2.getBoolean("grafik_kunjungan_suku");
}else if((rs.getRow()==0)&&(rs2.getRow()==0)){
var.kode="";
var.penyakit= false;
@@ -1157,6 +1160,7 @@ public static void setData(String user, String pass) {
var.jabatan_polri=false;
var.pangkat_polri=false;
var.cacat_fisik=false;
var.grafik_kunjungan_suku=false;
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
@@ -1558,4 +1562,5 @@ public static void setData(String user, String pass) {
public static boolean getjabatan_polri(){return var.jabatan_polri;}
public static boolean getpangkat_polri(){return var.pangkat_polri;}
public static boolean getcacat_fisik(){return var.cacat_fisik;}
public static boolean getgrafik_kunjungan_suku(){return var.grafik_kunjungan_suku;}
}
@@ -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 Registrasi Per Suku/Bangsa ]::">
<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="64" green="64" red="82" 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="26-07-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="26-07-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,323 @@
/*
* 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 GrafikKunjunganPerSuku 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 GrafikKunjunganPerSuku(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 Registrasi Per Suku/Bangsa ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(130, 100, 100))); // 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[] { "26-07-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[] { "26-07-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 suku_bangsa.nama_suku_bangsa,count(suku_bangsa.nama_suku_bangsa) as jumlah "+
"from reg_periksa inner join suku_bangsa inner join pasien on pasien.suku_bangsa=suku_bangsa.id and reg_periksa.no_rkm_medis=pasien.no_rkm_medis "+
"where tgl_registrasi between '"+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tanggal2.getSelectedItem()+"")+"' group by suku_bangsa.nama_suku_bangsa").executeQuery();
while(rs.next()) {
dcd.setValue(rs.getDouble(2),rs.getString(1)+"("+rs.getString(2)+")",rs.getString(1));
}
} catch (Exception e) {
System.out.println("Notifikasi : " + e);
}

JFreeChart freeChart = ChartFactory.createBarChart("Grafik Periksa Per Suku/Bangsa Tanggal "+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+" S.D. "+Valid.SetTgl(Tanggal2.getSelectedItem()+""),"Suku/Bangsa","Jumlah Pasien", dcd, PlotOrientation.VERTICAL,true, true,true);
ChartFrame cf = new ChartFrame("Grafik Periksa Per Suku/Bangsa",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_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 Periksa Per Suku/Bangsa Tanggal "+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+" S.D. "+Valid.SetTgl(Tanggal2.getSelectedItem()+""),
"select suku_bangsa.nama_suku_bangsa,count(suku_bangsa.nama_suku_bangsa) as jumlah "+
"from reg_periksa inner join suku_bangsa inner join pasien on pasien.suku_bangsa=suku_bangsa.id and reg_periksa.no_rkm_medis=pasien.no_rkm_medis "+
"where tgl_registrasi between '"+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tanggal2.getSelectedItem()+"")+"' group by suku_bangsa.nama_suku_bangsa","Suku/Bangsa");
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 suku_bangsa.nama_suku_bangsa,count(suku_bangsa.nama_suku_bangsa) as jumlah "+
"from reg_periksa inner join suku_bangsa inner join pasien on pasien.suku_bangsa=suku_bangsa.id and reg_periksa.no_rkm_medis=pasien.no_rkm_medis "+
"where tgl_registrasi between '"+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tanggal2.getSelectedItem()+"")+"' group by suku_bangsa.nama_suku_bangsa").executeQuery();
while(rs.next()) {
dpd.setValue(rs.getString(1)+"("+rs.getString(2)+")",rs.getDouble(2));
}
} catch (Exception e) {
System.out.println("Notifikasi : " + e);
}

JFreeChart freeChart = ChartFactory.createPieChart("Grafik Periksa Per Suku/Bangsa Tanggal "+Valid.SetTgl(Tanggal1.getSelectedItem()+"")+" S.D. "+Valid.SetTgl(Tanggal2.getSelectedItem()+""),dpd,true,true, false);
ChartFrame cf = new ChartFrame("Grafik Periksa Per Suku/Bangsa",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_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(() -> {
GrafikKunjunganPerSuku dialog = new GrafikKunjunganPerSuku(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

}
@@ -109,7 +109,7 @@ public DlgUser(java.awt.Frame parent, boolean modal) {
"[C]Riwayat Penelitian","[E]Penerimaan Barang Non Medis","[J]Bayar Pesan Non Medis","[J]Hutang Barang Non Medis","[E]Rekap Penerimaan Non Medis","[I]Insiden Keselamatan",
"[L]Insiden Keselamatan Pasien","[N]Kejadian IKP Per Tahun","[N]Kejadian IKP Per Bulan","[N]Kejadian IKP Per Tanggal","[D]Riwayat Batch","[N]Kejadian IKP Per Jenis",
"[N]Kejadian IKP Per Dampak","[H]Piutang Per Akun Piutang","[N]Kunjungan Reg Per Agama","[N]Kunjungan Reg Per Umur","[L]Suku/Bangsa Pasien","[L]Bahasa Pasien","[L]Golongan TNI",
"[L]Satuan TNI","[L]Jabatan TNI","[L]Pangkat TNI","[L]Golongan POLRI","[L]Satuan POLRI","[L]Jabatan POLRI","[L]Pangkat POLRI","[L]Cacat Fisik"
"[L]Satuan TNI","[L]Jabatan TNI","[L]Pangkat TNI","[L]Golongan POLRI","[L]Satuan POLRI","[L]Jabatan POLRI","[L]Pangkat POLRI","[L]Cacat Fisik","[N]Kunjungan Reg Per Suku/Bangsa"
};

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

for (i = 0; i < 351;i++) {
for (i = 0; i < 352;i++) {
TableColumn column = tbUser.getColumnModel().getColumn(i);
if(i==0){
column.setPreferredWidth(130);
@@ -563,6 +563,8 @@ public Class getColumnClass(int columnIndex) {
column.setPreferredWidth(90);
}else if(i==350){
column.setPreferredWidth(70);
}else if(i==351){
column.setPreferredWidth(178);
}else{
column.setPreferredWidth(130);
}
@@ -998,7 +1000,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','false','false','false','false','false','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','false','false','false','false','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){
tampil();
emptTeks();
}
@@ -1391,7 +1393,8 @@ private void BtnEditActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST
"satuan_polri='"+tbUser.getValueAt(i,347).toString()+"',"+
"jabatan_polri='"+tbUser.getValueAt(i,348).toString()+"',"+
"pangkat_polri='"+tbUser.getValueAt(i,349).toString()+"',"+
"cacat_fisik='"+tbUser.getValueAt(i,350).toString()+"'");
"cacat_fisik='"+tbUser.getValueAt(i,350).toString()+"',"+
"grafik_kunjungan_suku='"+tbUser.getValueAt(i,351).toString()+"'");
}
tampil();
emptTeks();
@@ -1677,7 +1680,7 @@ private void tampil() {
"grafik_ikp_perbulan,grafik_ikp_pertanggal,riwayat_data_batch,grafik_ikp_jenis,grafik_ikp_dampak,"+
"piutang_akun_piutang,grafik_kunjungan_per_agama,grafik_kunjungan_per_umur,suku_bangsa,bahasa_pasien,"+
"golongan_tni,satuan_tni,jabatan_tni,pangkat_tni,golongan_polri,satuan_polri,jabatan_polri,pangkat_polri, "+
"cacat_fisik from user order by AES_DECRYPT(id_user,'nur')");
"cacat_fisik,grafik_kunjungan_suku from user order by AES_DECRYPT(id_user,'nur')");
try {
rs=ps.executeQuery();
while(rs.next()){
@@ -2039,7 +2042,8 @@ private void tampil() {
rs.getBoolean("satuan_polri"),
rs.getBoolean("jabatan_polri"),
rs.getBoolean("pangkat_polri"),
rs.getBoolean("cacat_fisik")
rs.getBoolean("cacat_fisik"),
rs.getBoolean("grafik_kunjungan_suku")
});
}
} catch (Exception e) {
@@ -2391,7 +2395,8 @@ private void tampil() {
rs.getBoolean("satuan_polri"),
rs.getBoolean("jabatan_polri"),
rs.getBoolean("pangkat_polri"),
rs.getBoolean("cacat_fisik")
rs.getBoolean("cacat_fisik"),
rs.getBoolean("grafik_kunjungan_suku")
});
}
}
@@ -6152,6 +6152,22 @@
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="btnCacatFisikActionPerformed"/>
</Events>
</Component>
<Component class="widget.ButtonBig" name="btnGrafikKunjunganPerSuku">
<Properties>
<Property name="icon" type="javax.swing.Icon" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/48x48/1491582080_6.png"/>
</Property>
<Property name="text" type="java.lang.String" value="Kunjungan Reg Per Suku/Bangsa"/>
<Property name="iconTextGap" type="int" value="0"/>
<Property name="name" type="java.lang.String" value="btnGrafikKunjunganPerSuku" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[200, 90]"/>
</Property>
</Properties>
<Events>
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="btnGrafikKunjunganPerSukuActionPerformed"/>
</Events>
</Component>
</SubComponents>
</Container>
</SubComponents>
@@ -6168,7 +6184,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="23/07/2018"/>
<StringItem index="0" value="26/07/2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd/MM/yyyy"/>
@@ -206,6 +206,7 @@
import grafikanalisa.GrafikKunjunganPerPekerjaan;
import grafikanalisa.GrafikKunjunganPerPendidikan;
import grafikanalisa.GrafikKunjunganPerPerujuk;
import grafikanalisa.GrafikKunjunganPerSuku;
import grafikanalisa.GrafikKunjunganPerTahun;
import grafikanalisa.GrafikKunjunganPerTanggal;
import grafikanalisa.GrafikKunjunganPerUmur;
@@ -871,6 +872,7 @@ private void initComponents() {
btnJabatanPolri = new widget.ButtonBig();
btnPangkatPolri = new widget.ButtonBig();
btnCacatFisik = new widget.ButtonBig();
btnGrafikKunjunganPerSuku = new widget.ButtonBig();
tanggal = new widget.Tanggal();
btnDataPenjualan = new widget.ButtonBig();
btnInputPenjualan = new widget.ButtonBig();
@@ -5354,6 +5356,18 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {
});
Panelmenu.add(btnCacatFisik);

btnGrafikKunjunganPerSuku.setIcon(new javax.swing.ImageIcon(getClass().getResource("/48x48/1491582080_6.png"))); // NOI18N
btnGrafikKunjunganPerSuku.setText("Kunjungan Reg Per Suku/Bangsa");
btnGrafikKunjunganPerSuku.setIconTextGap(0);
btnGrafikKunjunganPerSuku.setName("btnGrafikKunjunganPerSuku"); // NOI18N
btnGrafikKunjunganPerSuku.setPreferredSize(new java.awt.Dimension(200, 90));
btnGrafikKunjunganPerSuku.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnGrafikKunjunganPerSukuActionPerformed(evt);
}
});
Panelmenu.add(btnGrafikKunjunganPerSuku);

scrollPane2.setViewportView(Panelmenu);

panelMenu.add(scrollPane2, java.awt.BorderLayout.CENTER);
@@ -5362,7 +5376,7 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {

tanggal.setEditable(false);
tanggal.setForeground(new java.awt.Color(50, 70, 50));
tanggal.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "23/07/2018" }));
tanggal.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "26/07/2018" }));
tanggal.setDisplayFormat("dd/MM/yyyy");
tanggal.setName("tanggal"); // NOI18N
tanggal.setOpaque(false);
@@ -11233,6 +11247,17 @@ private void btnCacatFisikActionPerformed(java.awt.event.ActionEvent evt) {//GEN
this.setCursor(Cursor.getDefaultCursor());
}//GEN-LAST:event_btnCacatFisikActionPerformed

private void btnGrafikKunjunganPerSukuActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnGrafikKunjunganPerSukuActionPerformed
isTutup();
DlgHome.dispose();
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
GrafikKunjunganPerSuku aplikasi=new GrafikKunjunganPerSuku(this,true);
aplikasi.setSize(PanelUtama.getWidth(), PanelUtama.getHeight());
aplikasi.setLocationRelativeTo(PanelUtama);
aplikasi.setVisible(true);
this.setCursor(Cursor.getDefaultCursor());
}//GEN-LAST:event_btnGrafikKunjunganPerSukuActionPerformed

/**
* @param args the command line arguments
*/
@@ -11371,6 +11396,7 @@ public static void main(String args[]) {
private widget.ButtonBig btnGrafikKunjunganPerDokter;
private widget.ButtonBig btnGrafikKunjunganPerPekerjaan;
private widget.ButtonBig btnGrafikKunjunganPerPendidikan;
private widget.ButtonBig btnGrafikKunjunganPerSuku;
private widget.ButtonBig btnGrafikKunjunganPerTahun;
private widget.ButtonBig btnGrafikKunjunganPerTanggal;
private widget.ButtonBig btnGrafikKunjunganPerUmur;
@@ -13633,6 +13659,11 @@ private void isCombo() {
Panelmenu.add(btnGrafikKunjunganPerUmur);
jmlmenu++;
}

if(var.getgrafik_kunjungan_suku()==true){
Panelmenu.add(btnGrafikKunjunganPerSuku);
jmlmenu++;
}
}else if(cmbMenu.getSelectedIndex()==14){
jmlmenu=0;
if(var.getaplikasi()==true){
@@ -15374,6 +15405,11 @@ private void isCariKosong() {
Panelmenu.add(btnGrafikKunjunganPerUmur);
jmlmenu++;
}

if(var.getgrafik_kunjungan_suku()==true){
Panelmenu.add(btnGrafikKunjunganPerSuku);
jmlmenu++;
}

if(var.getaplikasi()==true){
Panelmenu.add(btnSetupAplikasi);
@@ -17766,6 +17802,13 @@ private void isCariIsi() {
}
}

if(var.getgrafik_kunjungan_suku()==true){
if(btnGrafikKunjunganPerSuku.getText().toLowerCase().trim().contains(TCari.getText().toLowerCase().trim())){
Panelmenu.add(btnGrafikKunjunganPerSuku);
jmlmenu++;
}
}

if(var.getaplikasi()==true){
if(btnSetupAplikasi.getText().toLowerCase().trim().contains(TCari.getText().toLowerCase().trim())){
Panelmenu.add(btnSetupAplikasi);