@@ -58,7 +58,7 @@ public DlgStokOpname(java.awt.Frame parent, boolean modal) {
setSize(628,674);

Object[] row={"Kode Barang","Nama Barang","Harga Beli","Satuan","Tanggal","Stok","Real",
"Selisih","Nominal Hilang(Rp)","Keterangan","Kode Lokasi","Nama Lokasi"};
"Selisih","Total Real","Nominal Hilang(Rp)","Keterangan","Kode Lokasi","Nama Lokasi"};
tabMode=new DefaultTableModel(null,row){
@Override public boolean isCellEditable(int rowIndex, int colIndex){return false;}
};
@@ -67,7 +67,7 @@ public DlgStokOpname(java.awt.Frame parent, boolean modal) {
tbKamar.setPreferredScrollableViewportSize(new Dimension(500,500));
tbKamar.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

for (int i = 0; i < 12; i++) {
for (int i = 0; i < 13; i++) {
TableColumn column = tbKamar.getColumnModel().getColumn(i);
if(i==0){
column.setPreferredWidth(80);
@@ -88,10 +88,12 @@ public DlgStokOpname(java.awt.Frame parent, boolean modal) {
}else if(i==8){
column.setPreferredWidth(100);
}else if(i==9){
column.setPreferredWidth(120);
column.setPreferredWidth(100);
}else if(i==10){
column.setPreferredWidth(90);
column.setPreferredWidth(120);
}else if(i==11){
column.setPreferredWidth(90);
}else if(i==12){
column.setPreferredWidth(130);
}
}
@@ -112,27 +114,10 @@ public DlgStokOpname(java.awt.Frame parent, boolean modal) {
@Override
public void changedUpdate(DocumentEvent e) {tampil();}
});
}

try {
pstampil=koneksi.prepareStatement("select opname.kode_brng, databarang.nama_brng,opname.h_beli, databarang.kode_sat, opname.tanggal, opname.stok, "+
"opname.real, opname.selisih, opname.nomihilang, opname.keterangan, bangsal.kd_bangsal, bangsal.nm_bangsal "+
"from opname inner join databarang inner join bangsal "+
"on opname.kode_brng=databarang.kode_brng and opname.kd_bangsal=bangsal.kd_bangsal "+
"where opname.tanggal between ? and ? and opname.kode_brng like ? or "+
"opname.tanggal between ? and ? and databarang.nama_brng like ? or "+
"opname.tanggal between ? and ? and opname.kode_brng like ? or "+
"opname.tanggal between ? and ? and bangsal.kd_bangsal like ? or "+
"opname.tanggal between ? and ? and bangsal.nm_bangsal like ? or "+
"opname.tanggal between ? and ? and databarang.kode_sat like ? or "+
"opname.tanggal between ? and ? and opname.keterangan like ? order by opname.tanggal");
} catch (Exception e) {
System.out.println(e);
}

}
private DecimalFormat df2 = new DecimalFormat("###,###,###,###,###,###,###");
double total=0;
double total=0,totalreal=0;


/** This method is called from within the constructor to
@@ -186,6 +171,8 @@ private void initComponents() {
BtnPrint = new widget.Button();
label10 = new widget.Label();
LCount = new widget.Label();
label13 = new widget.Label();
LTotalBeli = new widget.Label();
label12 = new widget.Label();
LTotal = new widget.Label();
BtnKeluar = new widget.Button();
@@ -464,11 +451,11 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

label9.setText("Key Word :");
label9.setName("label9"); // NOI18N
label9.setPreferredSize(new java.awt.Dimension(90, 23));
label9.setPreferredSize(new java.awt.Dimension(100, 23));
panelisi3.add(label9);

TCari.setName("TCari"); // NOI18N
TCari.setPreferredSize(new java.awt.Dimension(250, 23));
TCari.setPreferredSize(new java.awt.Dimension(300, 23));
TCari.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
TCariKeyPressed(evt);
@@ -555,24 +542,35 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

label10.setText("Record :");
label10.setName("label10"); // NOI18N
label10.setPreferredSize(new java.awt.Dimension(90, 30));
label10.setPreferredSize(new java.awt.Dimension(55, 30));
panelisi1.add(label10);

LCount.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
LCount.setText("0");
LCount.setName("LCount"); // NOI18N
LCount.setPreferredSize(new java.awt.Dimension(60, 30));
LCount.setPreferredSize(new java.awt.Dimension(30, 30));
panelisi1.add(LCount);

label12.setText("Total :");
label13.setText("Total Real :");
label13.setName("label13"); // NOI18N
label13.setPreferredSize(new java.awt.Dimension(60, 30));
panelisi1.add(label13);

LTotalBeli.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
LTotalBeli.setText("0");
LTotalBeli.setName("LTotalBeli"); // NOI18N
LTotalBeli.setPreferredSize(new java.awt.Dimension(150, 30));
panelisi1.add(LTotalBeli);

label12.setText("Hilang :");
label12.setName("label12"); // NOI18N
label12.setPreferredSize(new java.awt.Dimension(55, 30));
label12.setPreferredSize(new java.awt.Dimension(45, 30));
panelisi1.add(label12);

LTotal.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
LTotal.setText("0");
LTotal.setName("LTotal"); // NOI18N
LTotal.setPreferredSize(new java.awt.Dimension(175, 30));
LTotal.setPreferredSize(new java.awt.Dimension(105, 30));
panelisi1.add(LTotal);

BtnKeluar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/exit.png"))); // NOI18N
@@ -642,7 +640,7 @@ private void BtnPrintActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRS
param.put("emailrs",var.getemailrs());
param.put("logo",Sequel.cariGambar("select logo from setting"));
Valid.MyReport("rptOpname.jrxml","report","::[ Stok Opname ]::","select opname.kode_brng, databarang.nama_brng,opname.h_beli, databarang.kode_sat, opname.tanggal, opname.stok, "+
"opname.real, opname.selisih, opname.nomihilang, opname.keterangan, bangsal.kd_bangsal, bangsal.nm_bangsal "+
"opname.real, opname.selisih, opname.nomihilang, opname.keterangan, bangsal.kd_bangsal, bangsal.nm_bangsal, (opname.real*opname.h_beli) as totalreal "+
"from opname inner join databarang inner join bangsal "+
"on opname.kode_brng=databarang.kode_brng and opname.kd_bangsal=bangsal.kd_bangsal "+
"where opname.tanggal between '"+Valid.SetTgl(Tgl1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tgl2.getSelectedItem()+"")+"' and opname.kode_brng like '%"+TCari.getText().trim()+"%' or "+
@@ -773,6 +771,7 @@ public void windowClosing(java.awt.event.WindowEvent e) {
private widget.TextBox Keterangan;
private widget.Label LCount;
private widget.Label LTotal;
private widget.Label LTotalBeli;
private widget.TextBox Nmbar;
private widget.TextBox Nominal;
private javax.swing.JPopupMenu Popup;
@@ -790,6 +789,7 @@ public void windowClosing(java.awt.event.WindowEvent e) {
private widget.Label label10;
private widget.Label label11;
private widget.Label label12;
private widget.Label label13;
private widget.Label label17;
private widget.Label label18;
private widget.Label label19;
@@ -811,49 +811,76 @@ public void windowClosing(java.awt.event.WindowEvent e) {

private void tampil() {
Valid.tabelKosong(tabMode);
try{
pstampil.setString(1,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(2,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(3,"%"+TCari.getText().trim()+"%");
pstampil.setString(4,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(5,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(6,"%"+TCari.getText().trim()+"%");
pstampil.setString(7,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(8,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(9,"%"+TCari.getText().trim()+"%");
pstampil.setString(10,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(11,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(12,"%"+TCari.getText().trim()+"%");
pstampil.setString(13,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(14,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(15,"%"+TCari.getText().trim()+"%");
pstampil.setString(16,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(17,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(18,"%"+TCari.getText().trim()+"%");
pstampil.setString(19,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(20,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(21,"%"+TCari.getText().trim()+"%");
rstampil=pstampil.executeQuery();
total=0;
while(rstampil.next()){
total=total+rstampil.getDouble(8);
tabMode.addRow(new Object[]{rstampil.getString(1),
rstampil.getString(2),
df2.format(rstampil.getDouble(3)),
rstampil.getString(4),
rstampil.getString(5),
rstampil.getString(6),
rstampil.getString(7),
rstampil.getString(8),
df2.format(rstampil.getDouble(9)),
rstampil.getString(10),
rstampil.getString(11),
rstampil.getString(12)});
total=0;
totalreal=0;
try{
pstampil=koneksi.prepareStatement("select opname.kode_brng, databarang.nama_brng,opname.h_beli, databarang.kode_sat, opname.tanggal, opname.stok, "+
"opname.real, opname.selisih, (opname.real*opname.h_beli) as totalreal,opname.nomihilang, opname.keterangan, bangsal.kd_bangsal, bangsal.nm_bangsal "+
"from opname inner join databarang inner join bangsal "+
"on opname.kode_brng=databarang.kode_brng and opname.kd_bangsal=bangsal.kd_bangsal "+
"where opname.tanggal between ? and ? and opname.kode_brng like ? or "+
"opname.tanggal between ? and ? and databarang.nama_brng like ? or "+
"opname.tanggal between ? and ? and opname.kode_brng like ? or "+
"opname.tanggal between ? and ? and bangsal.kd_bangsal like ? or "+
"opname.tanggal between ? and ? and bangsal.nm_bangsal like ? or "+
"opname.tanggal between ? and ? and databarang.kode_sat like ? or "+
"opname.tanggal between ? and ? and opname.keterangan like ? order by opname.tanggal");
try {
pstampil.setString(1,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(2,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(3,"%"+TCari.getText().trim()+"%");
pstampil.setString(4,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(5,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(6,"%"+TCari.getText().trim()+"%");
pstampil.setString(7,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(8,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(9,"%"+TCari.getText().trim()+"%");
pstampil.setString(10,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(11,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(12,"%"+TCari.getText().trim()+"%");
pstampil.setString(13,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(14,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(15,"%"+TCari.getText().trim()+"%");
pstampil.setString(16,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(17,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(18,"%"+TCari.getText().trim()+"%");
pstampil.setString(19,Valid.SetTgl(Tgl1.getSelectedItem()+""));
pstampil.setString(20,Valid.SetTgl(Tgl2.getSelectedItem()+""));
pstampil.setString(21,"%"+TCari.getText().trim()+"%");
rstampil=pstampil.executeQuery();
total=0;
while(rstampil.next()){
totalreal=totalreal+rstampil.getDouble(9);
total=total+rstampil.getDouble(10);
tabMode.addRow(new Object[]{rstampil.getString(1),
rstampil.getString(2),
df2.format(rstampil.getDouble(3)),
rstampil.getString(4),
rstampil.getString(5),
rstampil.getString(6),
rstampil.getString(7),
rstampil.getString(8),
df2.format(rstampil.getDouble(9)),
df2.format(rstampil.getDouble(10)),
rstampil.getString(11),
rstampil.getString(12),
rstampil.getString(13)});
}
} catch (Exception e) {
System.out.println("Notif Opname : "+e);
}finally{
if(rstampil!=null){
rstampil.close();
}
if(pstampil!=null){
pstampil.close();
}
}
}catch(SQLException e){
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}
LCount.setText(""+tabMode.getRowCount());
LTotalBeli.setText(df2.format(totalreal));
LTotal.setText(df2.format(total));
}

@@ -1590,7 +1590,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="20-08-2017"/>
<StringItem index="0" value="24-08-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -1678,7 +1678,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="20-08-2017"/>
<StringItem index="0" value="24-08-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -2173,6 +2173,14 @@
</Container>
</SubComponents>
</Container>
<Component class="widget.TextBox" name="NoBalasan">
<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="NoBalasan" noResource="true"/>
</Properties>
</Component>
</NonVisualComponents>
<Properties>
<Property name="defaultCloseOperation" type="int" value="2"/>
@@ -2478,7 +2486,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="20-08-2017"/>
<StringItem index="0" value="24-08-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -2507,7 +2515,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="20-08-2017"/>
<StringItem index="0" value="24-08-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -2685,7 +2693,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="20-08-2017"/>
<StringItem index="0" value="24-08-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -589,6 +589,7 @@ private void initComponents() {
BtnSeek5 = new widget.Button();
CrDokter3 = new widget.TextBox();
jLabel24 = new widget.Label();
NoBalasan = new widget.TextBox();
internalFrame1 = new widget.InternalFrame();
Scroll = new widget.ScrollPane();
tbPetugas = new widget.Table();
@@ -1595,7 +1596,7 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {

TglSakit1.setEditable(false);
TglSakit1.setForeground(new java.awt.Color(50, 70, 50));
TglSakit1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-08-2017" }));
TglSakit1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "24-08-2017" }));
TglSakit1.setDisplayFormat("dd-MM-yyyy");
TglSakit1.setName("TglSakit1"); // NOI18N
TglSakit1.setOpaque(false);
@@ -1643,7 +1644,7 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {

TglSakit2.setEditable(false);
TglSakit2.setForeground(new java.awt.Color(50, 70, 50));
TglSakit2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-08-2017" }));
TglSakit2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "24-08-2017" }));
TglSakit2.setDisplayFormat("dd-MM-yyyy");
TglSakit2.setName("TglSakit2"); // NOI18N
TglSakit2.setOpaque(false);
@@ -1902,6 +1903,9 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {

DlgSakit2.getContentPane().add(internalFrame5, java.awt.BorderLayout.CENTER);

NoBalasan.setHighlighter(null);
NoBalasan.setName("NoBalasan"); // NOI18N

setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setUndecorated(true);
setResizable(false);
@@ -2096,7 +2100,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPCari1.setEditable(false);
DTPCari1.setForeground(new java.awt.Color(50, 70, 50));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-08-2017" }));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "24-08-2017" }));
DTPCari1.setDisplayFormat("dd-MM-yyyy");
DTPCari1.setName("DTPCari1"); // NOI18N
DTPCari1.setOpaque(false);
@@ -2111,7 +2115,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPCari2.setEditable(false);
DTPCari2.setForeground(new java.awt.Color(50, 70, 50));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-08-2017" }));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "24-08-2017" }));
DTPCari2.setDisplayFormat("dd-MM-yyyy");
DTPCari2.setName("DTPCari2"); // NOI18N
DTPCari2.setOpaque(false);
@@ -2204,7 +2208,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPReg.setEditable(false);
DTPReg.setForeground(new java.awt.Color(50, 70, 50));
DTPReg.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-08-2017" }));
DTPReg.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "24-08-2017" }));
DTPReg.setDisplayFormat("dd-MM-yyyy");
DTPReg.setName("DTPReg"); // NOI18N
DTPReg.setOpaque(false);
@@ -2603,7 +2607,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
TStatus.getText(),"Ralan",kdpnj.getText(),umur,sttsumur})==true){
UpdateUmur();
if(!AsalRujukan.getText().equals("")){
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0'","No.Rujuk");
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0','"+AsalRujukan.getText()+"','-','-','-','"+NoBalasan.getText()+"'","No.Rujuk");
}
if(ChkTracker.isSelected()==true){
ctk();
@@ -2619,7 +2623,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
TStatus.getText(),"Ralan",kdpnj.getText(),umur,sttsumur})==true){
UpdateUmur();
if(!AsalRujukan.getText().equals("")){
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0'","No.Rujuk");
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0','"+AsalRujukan.getText()+"','-','-','-','"+NoBalasan.getText()+"'","No.Rujuk");
}
if(ChkTracker.isSelected()==true){
ctk();
@@ -2635,7 +2639,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
TStatus.getText(),"Ralan",kdpnj.getText(),umur,sttsumur})==true){
UpdateUmur();
if(!AsalRujukan.getText().equals("")){
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0'","No.Rujuk");
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0','"+AsalRujukan.getText()+"','-','-','-','"+NoBalasan.getText()+"'","No.Rujuk");
}
if(ChkTracker.isSelected()==true){
ctk();
@@ -2651,7 +2655,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
TStatus.getText(),"Ralan",kdpnj.getText(),umur,sttsumur})==true){
UpdateUmur();
if(!AsalRujukan.getText().equals("")){
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0'","No.Rujuk");
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0','"+AsalRujukan.getText()+"','-','-','-','"+NoBalasan.getText()+"'","No.Rujuk");
}
if(ChkTracker.isSelected()==true){
ctk();
@@ -2667,7 +2671,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
TStatus.getText(),"Ralan",kdpnj.getText(),umur,sttsumur})==true){
UpdateUmur();
if(!AsalRujukan.getText().equals("")){
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0'","No.Rujuk");
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0','"+AsalRujukan.getText()+"','-','-','-','"+NoBalasan.getText()+"'","No.Rujuk");
}
if(ChkTracker.isSelected()==true){
ctk();
@@ -4202,6 +4206,7 @@ public void windowClosing(java.awt.event.WindowEvent e) {
private javax.swing.JMenuItem MnRujuk;
private javax.swing.JMenuItem MnRujukMasuk;
private javax.swing.JMenuItem MnSEP;
private widget.TextBox NoBalasan;
private widget.TextBox NomorSurat;
private javax.swing.JPanel PanelInput;
private widget.ScrollPane Scroll;
@@ -4544,6 +4549,7 @@ public void isCek(){
}

private void isNumber(){
Valid.autoNomer3("select ifnull(MAX(CONVERT(RIGHT(rujuk_masuk.no_rawat,4),signed)),0) from reg_periksa inner join rujuk_masuk on reg_periksa.no_rawat=rujuk_masuk.no_rawat where reg_periksa.tgl_registrasi='"+Valid.SetTgl(DTPReg.getSelectedItem()+"")+"' ","BR/"+dateformat.format(DTPReg.getDate())+"/",4,NoBalasan);
Valid.autoNomer3("select ifnull(MAX(CONVERT(no_reg,signed)),0) from reg_periksa where kd_dokter='"+kddokter.getText()+"' and tgl_registrasi='"+Valid.SetTgl(DTPReg.getSelectedItem()+"")+"'",
"",3,TNoReg);
if(Kd2.getText().equals("")){
@@ -2077,7 +2077,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="20-08-2017"/>
<StringItem index="0" value="24-08-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -2165,7 +2165,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="20-08-2017"/>
<StringItem index="0" value="24-08-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -2660,6 +2660,14 @@
</Container>
</SubComponents>
</Container>
<Component class="widget.TextBox" name="NoBalasan">
<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="NoBalasan" noResource="true"/>
</Properties>
</Component>
</NonVisualComponents>
<Properties>
<Property name="defaultCloseOperation" type="int" value="2"/>
@@ -2965,7 +2973,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="20-08-2017"/>
<StringItem index="0" value="24-08-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -2994,7 +3002,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="20-08-2017"/>
<StringItem index="0" value="24-08-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -3257,7 +3265,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="20-08-2017"/>
<StringItem index="0" value="24-08-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -721,6 +721,7 @@ private void initComponents() {
BtnSeek5 = new widget.Button();
CrDokter3 = new widget.TextBox();
jLabel24 = new widget.Label();
NoBalasan = new widget.TextBox();
internalFrame1 = new widget.InternalFrame();
Scroll = new widget.ScrollPane();
tbPetugas = new widget.Table();
@@ -2046,7 +2047,7 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {

TglSakit1.setEditable(false);
TglSakit1.setForeground(new java.awt.Color(50, 70, 50));
TglSakit1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-08-2017" }));
TglSakit1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "24-08-2017" }));
TglSakit1.setDisplayFormat("dd-MM-yyyy");
TglSakit1.setName("TglSakit1"); // NOI18N
TglSakit1.setOpaque(false);
@@ -2094,7 +2095,7 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {

TglSakit2.setEditable(false);
TglSakit2.setForeground(new java.awt.Color(50, 70, 50));
TglSakit2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-08-2017" }));
TglSakit2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "24-08-2017" }));
TglSakit2.setDisplayFormat("dd-MM-yyyy");
TglSakit2.setName("TglSakit2"); // NOI18N
TglSakit2.setOpaque(false);
@@ -2353,6 +2354,9 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {

DlgSakit2.getContentPane().add(internalFrame5, java.awt.BorderLayout.CENTER);

NoBalasan.setHighlighter(null);
NoBalasan.setName("NoBalasan"); // NOI18N

setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setUndecorated(true);
setResizable(false);
@@ -2547,7 +2551,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPCari1.setEditable(false);
DTPCari1.setForeground(new java.awt.Color(50, 70, 50));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-08-2017" }));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "24-08-2017" }));
DTPCari1.setDisplayFormat("dd-MM-yyyy");
DTPCari1.setName("DTPCari1"); // NOI18N
DTPCari1.setOpaque(false);
@@ -2562,7 +2566,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPCari2.setEditable(false);
DTPCari2.setForeground(new java.awt.Color(50, 70, 50));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-08-2017" }));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "24-08-2017" }));
DTPCari2.setDisplayFormat("dd-MM-yyyy");
DTPCari2.setName("DTPCari2"); // NOI18N
DTPCari2.setOpaque(false);
@@ -2704,7 +2708,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPReg.setEditable(false);
DTPReg.setForeground(new java.awt.Color(50, 70, 50));
DTPReg.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-08-2017" }));
DTPReg.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "24-08-2017" }));
DTPReg.setDisplayFormat("dd-MM-yyyy");
DTPReg.setName("DTPReg"); // NOI18N
DTPReg.setOpaque(false);
@@ -3134,7 +3138,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
TStatus.getText(),"Ralan",kdpnj.getText(),umur,sttsumur})==true){
UpdateUmur();
if(!AsalRujukan.getText().equals("")){
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0'","No.Rujuk");
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0','"+AsalRujukan.getText()+"','-','-','-','"+NoBalasan.getText()+"'","No.Rujuk");
}
if(ChkTracker.isSelected()==true){
ctk();
@@ -3149,7 +3153,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
TStatus.getText(),"Ralan",kdpnj.getText(),umur,sttsumur})==true){
UpdateUmur();
if(!AsalRujukan.getText().equals("")){
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0'","No.Rujuk");
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0','"+AsalRujukan.getText()+"','-','-','-','"+NoBalasan.getText()+"'","No.Rujuk");
}
if(ChkTracker.isSelected()==true){
ctk();
@@ -3164,7 +3168,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
TStatus.getText(),"Ralan",kdpnj.getText(),umur,sttsumur})==true){
UpdateUmur();
if(!AsalRujukan.getText().equals("")){
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0'","No.Rujuk");
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0','"+AsalRujukan.getText()+"','-','-','-','"+NoBalasan.getText()+"'","No.Rujuk");
}
if(ChkTracker.isSelected()==true){
ctk();
@@ -3179,7 +3183,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
TStatus.getText(),"Ralan",kdpnj.getText(),umur,sttsumur})==true){
UpdateUmur();
if(!AsalRujukan.getText().equals("")){
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0'","No.Rujuk");
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0','"+AsalRujukan.getText()+"','-','-','-','"+NoBalasan.getText()+"'","No.Rujuk");
}
if(ChkTracker.isSelected()==true){
ctk();
@@ -3194,7 +3198,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
TStatus.getText(),"Ralan",kdpnj.getText(),umur,sttsumur})==true){
UpdateUmur();
if(!AsalRujukan.getText().equals("")){
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0'","No.Rujuk");
Sequel.menyimpan("rujuk_masuk","'"+TNoRw.getText()+"','"+AsalRujukan.getText()+"','"+alamatperujuk+"','-','0','"+AsalRujukan.getText()+"','-','-','-','"+NoBalasan.getText()+"'","No.Rujuk");
}
if(ChkTracker.isSelected()==true){
ctk();
@@ -5334,6 +5338,7 @@ public void windowClosing(java.awt.event.WindowEvent e) {
private javax.swing.JMenuItem MnRujukMasuk;
private javax.swing.JMenuItem MnSEP;
private javax.swing.JMenuItem MnSJP;
private widget.TextBox NoBalasan;
private widget.TextBox NomorSurat;
private javax.swing.JPanel PanelInput;
private widget.ScrollPane Scroll;
@@ -5786,7 +5791,8 @@ public void isCek(){
ppCatatanPasien.setEnabled(var.getcatatan_pasien());
}

private void isNumber(){
private void isNumber(){
Valid.autoNomer3("select ifnull(MAX(CONVERT(RIGHT(rujuk_masuk.no_rawat,4),signed)),0) from reg_periksa inner join rujuk_masuk on reg_periksa.no_rawat=rujuk_masuk.no_rawat where reg_periksa.tgl_registrasi='"+Valid.SetTgl(DTPReg.getSelectedItem()+"")+"' ","BR/"+dateformat.format(DTPReg.getDate())+"/",4,NoBalasan);
Valid.autoNomer3("select ifnull(MAX(CONVERT(no_reg,signed)),0) from reg_periksa where kd_dokter='"+kddokter.getText()+"' and tgl_registrasi='"+Valid.SetTgl(DTPReg.getSelectedItem()+"")+"'","",3,TNoReg);
if(Kd2.getText().equals("")){
Valid.autoNomer3("select ifnull(MAX(CONVERT(RIGHT(no_rawat,6),signed)),0) from reg_periksa where tgl_registrasi='"+Valid.SetTgl(DTPReg.getSelectedItem()+"")+"' ",dateformat.format(DTPReg.getDate())+"/",6,TNoRw);
@@ -0,0 +1,4 @@
RewriteEngine On
RewriteRule ^home$ /webapps/dinkesdashboard/index.php
RewriteRule ^([^/.]+)$ /dinkesdashboard/module.php?module=$1
RewriteRule ^([^/.]+)/([^/.]+).html$ /dinkesdashboard/module.php?module=$1
@@ -0,0 +1,232 @@
.table {
margin-bottom: 0 !important;
border-bottom: 1px solid #dddddd;
border-collapse: collapse !important;
border-radius: 1px;
}

.fixed-table-container {
position: relative;
clear: both;
border: 1px solid #dddddd;
border-radius: 4px;
-webkit-border-radius: 4px;
-moz-border-radius: 4px;
}

.fixed-table-header {
overflow: hidden;
border-radius: 4px 4px 0 0;
-webkit-border-radius: 4px 4px 0 0;
-moz-border-radius: 4px 4px 0 0;
}

.fixed-table-body {
overflow-x: auto;
overflow-y: auto;
height: 100%;
}

.fixed-table-container table {
width: 100%;
}

.fixed-table-container thead th {
height: 0;
padding: 0;
margin: 0;
border-left: 1px solid #dddddd;
}

.fixed-table-container thead th:first-child {
border-left: none;
}

.fixed-table-container thead th .th-inner {
padding: 8px;
line-height: 24px;
vertical-align: top;
overflow: hidden;
text-overflow: ellipsis;
white-space: nowrap;
}

.fixed-table-container thead th .sortable {
cursor: pointer;
}

.fixed-table-container tbody td {
border-left: 1px solid #dddddd;
}

.fixed-table-container tbody tr:first-child td {
border-top: none;
}

.fixed-table-container tbody td:first-child {
border-left: none;
}

/* the same color with .active */
.fixed-table-container tbody .selected td {
background-color: #f5f5f5;
}

.fixed-table-container .bs-checkbox {
text-align: center;
}

.fixed-table-container .bs-checkbox .th-inner {
padding: 8px 0;
}

.fixed-table-container input[type="radio"],
.fixed-table-container input[type="checkbox"] {
margin: 0 auto !important;
}

.fixed-table-container .no-records-found {
text-align: center;
}


.fixed-table-pagination .pagination,
.fixed-table-pagination .pagination-detail {
margin-top: 10px;
margin-bottom: 10px;
}

.fixed-table-pagination .pagination a {
padding: 6px 12px;
line-height: 1.428571429;
}

.fixed-table-pagination .pagination-info {
line-height: 34px;
margin-right: 5px;
}

.fixed-table-pagination .btn-group {
position: relative;
display: inline-block;
vertical-align: middle;
}

.fixed-table-pagination .dropup .dropdown-menu {
margin-bottom: 0;
}

.fixed-table-pagination .page-list {
display: inline-block;
}

.fixed-table-toolbar .columns {
margin-left: 5px;
}

.fixed-table-toolbar .columns label {
display: block;
padding: 3px 20px;
clear: both;
font-weight: normal;
line-height: 1.428571429;
}

.fixed-table-toolbar .bars,
.fixed-table-toolbar .search,
.fixed-table-toolbar .columns {
position: relative;
margin-top: 10px;
margin-bottom: 10px;
line-height: 34px;
}

.fixed-table-pagination li.disabled a {
pointer-events: none;
cursor: default;
}

.fixed-table-loading {
display: none;
position: absolute;
top: 42px;
right: 0;
bottom: 0;
left: 0;
z-index: 99;
background-color: #fff;
text-align: center;
}

.fixed-table-body .card-view .title {
font-weight: bold;
display: inline-block;
min-width: 30%;
text-align: left !important;
}

/* support bootstrap 2 */
.fixed-table-body thead th .th-inner {
box-sizing: border-box;
}

.table th, .table td {
vertical-align: middle;
box-sizing: border-box;
}

.fixed-table-toolbar .dropdown-menu {
text-align: left;
max-height: 300px;
overflow: auto;
}

.fixed-table-toolbar .btn-group>.btn-group {
display: inline-block;
margin-left: -1px !important;
}

.fixed-table-toolbar .btn-group>.btn-group>.btn {
border-radius: 0;
}

.fixed-table-toolbar .btn-group>.btn-group:first-child>.btn {
border-top-left-radius: 4px;
border-bottom-left-radius: 4px;
}

.fixed-table-toolbar .btn-group>.btn-group:last-child>.btn {
border-top-right-radius: 4px;
border-bottom-right-radius: 4px;
}

.table>thead>tr>th {
vertical-align: bottom;
border-bottom: 2px solid #ddd;
}

/* support bootstrap 3 */
.table thead>tr>th {
padding: 0;
margin: 0;
}

.pull-right .dropdown-menu {
right: 0;
left: auto;
}

/* calculate scrollbar width */
p.fixed-table-scroll-inner {
width: 100%;
height: 200px;
}

div.fixed-table-scroll-outer {
top: 0;
left: 0;
visibility: hidden;
width: 200px;
height: 150px;
overflow: hidden;
}

Large diffs are not rendered by default.

Large diffs are not rendered by default.

@@ -0,0 +1,35 @@
.navbar-static-top {
margin-bottom:20px;
}

i {
font-size:16px;
}

.nav > li > a {
color:#787878;
}

footer {
margin-top:20px;
padding-top:20px;
padding-bottom:20px;
background-color:#efefef;
}

/* count indicator near icons */
.nav>li .count {
position: absolute;
bottom: 12px;
right: 6px;
font-size: 9px;
background: rgba(51,200,51,0.55);
color: rgba(255,255,255,0.9);
line-height: 1em;
padding: 2px 4px;
-webkit-border-radius: 10px;
-moz-border-radius: 10px;
-ms-border-radius: 10px;
-o-border-radius: 10px;
border-radius: 10px;
}
@@ -0,0 +1,206 @@
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta charset="utf-8">
<title>DASHBOARD</title>
<meta name="generator" content="Bootply" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/datepicker.css" rel="stylesheet">
<link href="css/bootstrap-table.css" rel="stylesheet">
<link href="css/styles.css" rel="stylesheet">
<!--[if lt IE 9]>
<script src="//html5shim.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
<link href="css/styles.css" rel="stylesheet">
</head>
<body>
<!-- header -->
<div id="top-nav" class="navbar navbar-inverse navbar-static-top">
<div class="container-fluid">
</div>
<!-- /container -->
</div>
<!-- /Header -->

<!-- Main -->
<div class="container-fluid">
<div class="row">
<div class="col-sm-3">
<!-- Left column -->
<a href="#"><strong><i class="glyphicon glyphicon-wrench"></i> LAPORAN RL</strong></a>

<hr>

<ul class="nav nav-stacked">

<li class="nav-header"> <a href="#" data-toggle="collapse" data-target="#menu1"> Laporan RL 1 - Data Dasar Rumah Sakit <i class="glyphicon glyphicon-chevron-right"></i></a>

<ul class="nav nav-stacked collapse" id="menu1">
<li><a href="?module=1.1">laporan RL 1.1</a>
</li>
<li><a href="?module=1.2">Laporan RL 1.2</a>
</li>
<li><a href="?module=1.3">Laporan RL 1.3</a>
</li>
</ul>
</li>

<li class="nav-header"> <a href="#" data-toggle="collapse" data-target="#menu2"> Laporan RL 2 - Ketenagaan <i class="glyphicon glyphicon-chevron-right"></i></a>

<ul class="nav nav-stacked collapse" id="menu2">
<li><a href="#">laporan RL 2</a>
</li>
</ul>
</li>

<li class="nav-header"> <a href="#" data-toggle="collapse" data-target="#menu3"> Laporan RL 3 - Pelayanan <i class="glyphicon glyphicon-chevron-right"></i></a>

<ul class="nav nav-stacked collapse" id="menu3">
<li><a href="?module=3.1">laporan RL 3.1</a>
</li>
<li><a href="#">Laporan RL 3.2</a>
</li>
<li><a href="#">Laporan RL 3.3</a>
</li>
<li><a href="#">Laporan RL 3.4</a>
</li>
<li><a href="#">Laporan RL 3.5</a>
</li>
<li><a href="#">Laporan RL 3.6</a>
</li>
<li><a href="#">Laporan RL 3.7</a>
</li>
<li><a href="#">Laporan RL 3.8</a>
</li>
<li><a href="#">Laporan RL 3.9</a>
</li>
<li><a href="?module=3.10-">Laporan RL 3.10</a>
</li>
<li><a href="#">Laporan RL 3.11</a>
</li>
<li><a href="#">Laporan RL 3.12</a>
</li>
<li><a href="#">Laporan RL 3.13</a>
</li>
<li><a href="#">Laporan RL 3.14</a>
</li>
<li><a href="?module=3.15">Laporan RL 3.15</a>
</li>
</ul>
</li>

<li class="nav-header"> <a href="#" data-toggle="collapse" data-target="#menu4"> Laporan RL 4 - Morbiditas dan Mortalitas <i class="glyphicon glyphicon-chevron-right"></i></a>

<ul class="nav nav-stacked collapse" id="menu4">
<li><a href="#">laporan RL 4.a</a>
</li>
<li><a href="#">laporan RL 4.b</a>
</li>
</ul>
</li>

<li class="nav-header"> <a href="#" data-toggle="collapse" data-target="#menu5"> Laporan RL 5 - Pengunjung Rumah Sakit <i class="glyphicon glyphicon-chevron-right"></i></a>

<ul class="nav nav-stacked collapse" id="menu5">
<li><a href="?module=5.1">laporan RL 5.1</a>
</li>
<li><a href="?module=5.2">laporan RL 5.2</a>
</li>
<li><a href="?module=5.3">laporan RL 5.3</a>
</li>
<li><a href="?module=5.4">laporan RL 5.4</a>
</li>
</ul>
</li>


</div>
<!-- /col-3 -->
<div class="col-sm-9">
<a href="?module=home"><strong><i class="glyphicon glyphicon-dashboard"></i> My Dashboard</strong></a>
<hr>
<div class="panel panel-default">
<?php include"module.php"; ?>
</div>
<!-- column 2 -->




<!-- /Main -->

<footer class="text-center">DASHBOARD SIMRS_KHANZA</a></footer>

<!-- /.modal -->
<!-- script references -->
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/scripts.js"></script>
<script src="js/jquery.maskedinput.js"></script>
<script src="js/bootstrap-datepicker.js"></script>
<script src="js/bootstrap-table.js"></script>
<script>
$(function () {
$('#hover, #striped, #condensed').click(function () {
var classes = 'table';

if ($('#hover').prop('checked')) {
classes += ' table-hover';
}
if ($('#condensed').prop('checked')) {
classes += ' table-condensed';
}
$('#table-style').bootstrapTable('destroy')
.bootstrapTable({
classes: classes,
striped: $('#striped').prop('checked')
});
});
});

function rowStyle(row, index) {
var classes = ['active', 'success', 'info', 'warning', 'danger'];

if (index % 2 === 0 && index / 2 < classes.length) {
return {
classes: classes[index / 2]
};
}
return {};
}
</script>
<script>
jQuery(function($){
$("#tgl1").mask("99/99/9999",{placeholder:"dd/mm/yyyy"});
$("#tgl2").mask("99/99/9999",{placeholder:"dd/mm/yyyy"});
$("#npwp").mask("99-999-999-9-999-999");
$("#jam").mask("99:99");
$("#jam1").mask("99:99");
});
$('#calender').datepicker({
autoclose:true, orientation:'top right',
'default': 'now'
});
$('#calender1').datepicker({
autoclose:true, orientation:'top right',
'default': 'now'
});
!function ($) {
$(document).on("click", "ul.nav li.parent > a > span.icon", function(){
$(this).find('em:first').toggleClass("glyphicon-minus");
});
$(".sidebar span.icon").find('em:first').addClass("glyphicon-plus");
}(window.jQuery);
$(window).on('resize', function () {
if ($(window).width() > 768) $('#sidebar-collapse').collapse('show')
})
$(window).on('resize', function () {
if ($(window).width() <= 767) $('#sidebar-collapse').collapse('hide')
})
</script>


</body>
</html>

Large diffs are not rendered by default.

Large diffs are not rendered by default.

Large diffs are not rendered by default.

@@ -0,0 +1,182 @@
/*
jQuery Masked Input Plugin
Copyright (c) 2007 - 2014 Josh Bush (digitalbush.com)
Licensed under the MIT license (http://digitalbush.com/projects/masked-input-plugin/#license)
Version: 1.4.0
*/
!function(factory) {
"function" == typeof define && define.amd ? define([ "jquery" ], factory) : factory("object" == typeof exports ? require("jquery") : jQuery);
}(function($) {
var caretTimeoutId, ua = navigator.userAgent, iPhone = /iphone/i.test(ua), chrome = /chrome/i.test(ua), android = /android/i.test(ua);
$.mask = {
definitions: {
"9": "[0-9]",
a: "[A-Za-z]",
"*": "[A-Za-z0-9]"
},
autoclear: !0,
dataName: "rawMaskFn",
placeholder: "_"
}, $.fn.extend({
caret: function(begin, end) {
var range;
if (0 !== this.length && !this.is(":hidden")) return "number" == typeof begin ? (end = "number" == typeof end ? end : begin,
this.each(function() {
this.setSelectionRange ? this.setSelectionRange(begin, end) : this.createTextRange && (range = this.createTextRange(),
range.collapse(!0), range.moveEnd("character", end), range.moveStart("character", begin),
range.select());
})) : (this[0].setSelectionRange ? (begin = this[0].selectionStart, end = this[0].selectionEnd) : document.selection && document.selection.createRange && (range = document.selection.createRange(),
begin = 0 - range.duplicate().moveStart("character", -1e5), end = begin + range.text.length),
{
begin: begin,
end: end
});
},
unmask: function() {
return this.trigger("unmask");
},
mask: function(mask, settings) {
var input, defs, tests, partialPosition, firstNonMaskPos, lastRequiredNonMaskPos, len, oldVal;
if (!mask && this.length > 0) {
input = $(this[0]);
var fn = input.data($.mask.dataName);
return fn ? fn() : void 0;
}
return settings = $.extend({
autoclear: $.mask.autoclear,
placeholder: $.mask.placeholder,
completed: null
}, settings), defs = $.mask.definitions, tests = [], partialPosition = len = mask.length,
firstNonMaskPos = null, $.each(mask.split(""), function(i, c) {
"?" == c ? (len--, partialPosition = i) : defs[c] ? (tests.push(new RegExp(defs[c])),
null === firstNonMaskPos && (firstNonMaskPos = tests.length - 1), partialPosition > i && (lastRequiredNonMaskPos = tests.length - 1)) : tests.push(null);
}), this.trigger("unmask").each(function() {
function tryFireCompleted() {
if (settings.completed) {
for (var i = firstNonMaskPos; lastRequiredNonMaskPos >= i; i++) if (tests[i] && buffer[i] === getPlaceholder(i)) return;
settings.completed.call(input);
}
}
function getPlaceholder(i) {
return settings.placeholder.charAt(i < settings.placeholder.length ? i : 0);
}
function seekNext(pos) {
for (;++pos < len && !tests[pos]; ) ;
return pos;
}
function seekPrev(pos) {
for (;--pos >= 0 && !tests[pos]; ) ;
return pos;
}
function shiftL(begin, end) {
var i, j;
if (!(0 > begin)) {
for (i = begin, j = seekNext(end); len > i; i++) if (tests[i]) {
if (!(len > j && tests[i].test(buffer[j]))) break;
buffer[i] = buffer[j], buffer[j] = getPlaceholder(j), j = seekNext(j);
}
writeBuffer(), input.caret(Math.max(firstNonMaskPos, begin));
}
}
function shiftR(pos) {
var i, c, j, t;
for (i = pos, c = getPlaceholder(pos); len > i; i++) if (tests[i]) {
if (j = seekNext(i), t = buffer[i], buffer[i] = c, !(len > j && tests[j].test(t))) break;
c = t;
}
}
function androidInputEvent() {
var curVal = input.val(), pos = input.caret();
if (curVal.length < oldVal.length) {
for (checkVal(!0); pos.begin > 0 && !tests[pos.begin - 1]; ) pos.begin--;
if (0 === pos.begin) for (;pos.begin < firstNonMaskPos && !tests[pos.begin]; ) pos.begin++;
input.caret(pos.begin, pos.begin);
} else {
for (checkVal(!0); pos.begin < len && !tests[pos.begin]; ) pos.begin++;
input.caret(pos.begin, pos.begin);
}
tryFireCompleted();
}
function blurEvent() {
checkVal(), input.val() != focusText && input.change();
}
function keydownEvent(e) {
if (!input.prop("readonly")) {
var pos, begin, end, k = e.which || e.keyCode;
oldVal = input.val(), 8 === k || 46 === k || iPhone && 127 === k ? (pos = input.caret(),
begin = pos.begin, end = pos.end, end - begin === 0 && (begin = 46 !== k ? seekPrev(begin) : end = seekNext(begin - 1),
end = 46 === k ? seekNext(end) : end), clearBuffer(begin, end), shiftL(begin, end - 1),
e.preventDefault()) : 13 === k ? blurEvent.call(this, e) : 27 === k && (input.val(focusText),
input.caret(0, checkVal()), e.preventDefault());
}
}
function keypressEvent(e) {
if (!input.prop("readonly")) {
var p, c, next, k = e.which || e.keyCode, pos = input.caret();
if (!(e.ctrlKey || e.altKey || e.metaKey || 32 > k) && k && 13 !== k) {
if (pos.end - pos.begin !== 0 && (clearBuffer(pos.begin, pos.end), shiftL(pos.begin, pos.end - 1)),
p = seekNext(pos.begin - 1), len > p && (c = String.fromCharCode(k), tests[p].test(c))) {
if (shiftR(p), buffer[p] = c, writeBuffer(), next = seekNext(p), android) {
var proxy = function() {
$.proxy($.fn.caret, input, next)();
};
setTimeout(proxy, 0);
} else input.caret(next);
pos.begin <= lastRequiredNonMaskPos && tryFireCompleted();
}
e.preventDefault();
}
}
}
function clearBuffer(start, end) {
var i;
for (i = start; end > i && len > i; i++) tests[i] && (buffer[i] = getPlaceholder(i));
}
function writeBuffer() {
input.val(buffer.join(""));
}
function checkVal(allow) {
var i, c, pos, test = input.val(), lastMatch = -1;
for (i = 0, pos = 0; len > i; i++) if (tests[i]) {
for (buffer[i] = getPlaceholder(i); pos++ < test.length; ) if (c = test.charAt(pos - 1),
tests[i].test(c)) {
buffer[i] = c, lastMatch = i;
break;
}
if (pos > test.length) {
clearBuffer(i + 1, len);
break;
}
} else buffer[i] === test.charAt(pos) && pos++, partialPosition > i && (lastMatch = i);
return allow ? writeBuffer() : partialPosition > lastMatch + 1 ? settings.autoclear || buffer.join("") === defaultBuffer ? (input.val() && input.val(""),
clearBuffer(0, len)) : writeBuffer() : (writeBuffer(), input.val(input.val().substring(0, lastMatch + 1))),
partialPosition ? i : firstNonMaskPos;
}
var input = $(this), buffer = $.map(mask.split(""), function(c, i) {
return "?" != c ? defs[c] ? getPlaceholder(i) : c : void 0;
}), defaultBuffer = buffer.join(""), focusText = input.val();
input.data($.mask.dataName, function() {
return $.map(buffer, function(c, i) {
return tests[i] && c != getPlaceholder(i) ? c : null;
}).join("");
}), input.one("unmask", function() {
input.off(".mask").removeData($.mask.dataName);
}).on("focus.mask", function() {
if (!input.prop("readonly")) {
clearTimeout(caretTimeoutId);
var pos;
focusText = input.val(), pos = checkVal(), caretTimeoutId = setTimeout(function() {
writeBuffer(), pos == mask.replace("?", "").length ? input.caret(0, pos) : input.caret(pos);
}, 10);
}
}).on("blur.mask", blurEvent).on("keydown.mask", keydownEvent).on("keypress.mask", keypressEvent).on("input.mask paste.mask", function() {
input.prop("readonly") || setTimeout(function() {
var pos = checkVal(!0);
input.caret(pos), tryFireCompleted();
}, 0);
}), chrome && android && input.off("input.mask").on("input.mask", androidInputEvent),
checkVal();
});
}
});
});

Large diffs are not rendered by default.

@@ -0,0 +1,9 @@

$(document).ready(function(){$(".alert").addClass("in").fadeOut(4500);

/* swap open/close side menu icons */
$('[data-toggle=collapse]').click(function(){
// toggle icon
$(this).find("i").toggleClass("glyphicon-chevron-right glyphicon-chevron-down");
});
});
@@ -0,0 +1,138 @@
<?php
include '../conf/conf.php';
/* header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=LaporanRekapKunjuangnJenisBayar.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";*/
?>
<html>
<body>

<?php
reportsqlinjection();
$tanggal1 = '2017-07-01';
$tanggal2 = '2017-07-28';
date_default_timezone_set("Asia/Jakarta");
$datatime=date("Y-m-d H:i:s");



$_poli="SELECT * FROM poliklinik";
$poli=bukaquery($_poli);



$ppkkode="SELECT * FROM setting";
$ppk_kode=bukaquery($ppkkode);

while($ppk = mysql_fetch_array($ppk_kode)) {
$k_ppk=$ppk['kode_ppk'];
$n_ppk=$ppk['nama_ppk'];
}

//echo $n_ppk;
$_jenis = Array('L','P');
$_instalasi = Array('Instalasi Rawat Jalan','Instalasi Gawat Darurat','Instalasi Rawat Inap');
$myvars="";

foreach($_instalasi as $instansi) {

if('Instalasi Gawat Darurat'==$instansi)
{
foreach($_jenis as $jns_kelamin)
{
$_sql = "SELECT Count(pasien.jk) AS jumlah_pasien
FROM reg_periksa JOIN penjab ON reg_periksa.kd_pj = penjab.kd_pj JOIN pasien ON reg_periksa.no_rkm_medis = pasien.no_rkm_medis WHERE reg_periksa.kd_poli = 'IGDK' AND jk='$jns_kelamin' AND tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2'";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$jml_pasien=$baris['jumlah_pasien'];
}

$post[] = array(

'koders'=>$k_ppk,
'tanggal'=>$tanggal2,
'namainstalasi'=>$instansi,
'jeniskelamin'=>$jns_kelamin,
'jumlahpasien'=>$jml_pasien,
'updatedate'=>$datatime,
);
}}
else if('Instalasi Rawat Jalan'==$instansi)
{
foreach($_jenis as $jns_kelamin)
{
$_sql = "SELECT Count(pasien.jk) AS jumlah_pasien
FROM reg_periksa JOIN penjab ON reg_periksa.kd_pj = penjab.kd_pj JOIN pasien ON reg_periksa.no_rkm_medis = pasien.no_rkm_medis WHERE reg_periksa.kd_poli != 'IGDK' AND jk='$jns_kelamin' AND tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2'";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$jml_pasien=$baris['jumlah_pasien'];
}

$post[] = array(

'koders'=>$k_ppk,
'tanggal'=>$tanggal2,
'namainstalasi'=>$instansi,
'jeniskelamin'=>$jns_kelamin,
'jumlahpasien'=>$jml_pasien,
'updatedate'=>$datatime,
);
}}
else
{
foreach($_jenis as $jns_kelamin)
{
$_sql = "SELECT Count(pasien.jk) AS jumlah_pasien
FROM reg_periksa JOIN penjab ON reg_periksa.kd_pj = penjab.kd_pj JOIN pasien ON reg_periksa.no_rkm_medis = pasien.no_rkm_medis WHERE jk='$jns_kelamin' AND status_lanjut='Ranap' AND tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2' ";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$jml_pasien=$baris['jumlah_pasien'];
}
$post[] = array(

'koders'=>$k_ppk,
'tanggal'=>$tanggal2,
'namainstalasi'=>$instansi,
'jeniskelamin'=>$jns_kelamin,
'jumlahpasien'=>$jml_pasien,
'updatedate'=>$datatime,
);
}}


}
echo json_encode($post);
$myvars=json_encode($post);





?>

<input id = 'content' type='text' name='content' value='<?php echo $myvars; ?>'>
<div id="result"></div>

<script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$.ajax({
url: "http://202.147.199.11/wsdashboarddinkes/wskunjunganpasienjeniskelamin.php",
type: "POST",
data: {
data: $("#content").val()
},
dataType: "JSON",
success: function (jsonStr) {
$("#result").text(JSON.stringify(jsonStr));
}
});
});
</script>

<!-- <button id="submit" name="submit" type="submit">Send</buttton> -->

</body>
</html>
@@ -0,0 +1,110 @@
<?php
error_reporting(E_ALL ^ (E_NOTICE | E_WARNING));
if($_GET['module']=="home"){
?>
<div class="panel-heading">
<h4>WELCOME TO DASHBOARD</h4></div>
<div class="panel-body">
SILAKAN KLIK MENU PILIHAN LAPORAN RL UNTUK MELIHAT DATA.
<p>
<?
}
elseif($_GET['module']=="1.1"){
include "rl_1.1.php";
}
elseif($_GET['module']=="1.2"){
include "rl_1.2.php";
}
elseif($_GET['module']=="1.3"){
include "rl_1.3.php";
}
elseif($_GET['module']=="2"){
include "rl_2.php";
}
elseif($_GET['module']=="3.1"){
include "rl_3.1.php";
}
elseif($_GET['module']=="3.1"){
include "rl_3.2.php";
}
elseif($_GET['module']=="3.3"){
include "rl_3.3.php";
}
elseif($_GET['module']=="3.4"){
include "rl_3.4.php";
}
elseif($_GET['module']=="3.1"){
include "rl_3.1.php";
}
elseif($_GET['module']=="3.1"){
include "rl_3.2.php";
}
elseif($_GET['module']=="3.3"){
include "rl_3.3.php";
}
elseif($_GET['module']=="3.4"){
include "rl_3.4.php";
}
elseif($_GET['module']=="3.5"){
include "rl_3.5.php";
}
elseif($_GET['module']=="3.6"){
include "rl_3.6.php";
}
elseif($_GET['module']=="3.7"){
include "rl_3.7.php";
}
elseif($_GET['module']=="3.8"){
include "rl_3.8.php";
}
elseif($_GET['module']=="3.9"){
include "rl_3.9.php";
}
elseif($_GET['module']=="3.10-"){
include "rl_3.10.php";
}
elseif($_GET['module']=="3.11"){
include "rl_3.11.php";
}
elseif($_GET['module']=="3.12"){
include "rl_3.12.php";
}
elseif($_GET['module']=="3.13"){
include "rl_3.13.php";
}
elseif($_GET['module']=="3.14"){
include "rl_3.14.php";
}
elseif($_GET['module']=="3.15"){
include "rl_3.15.php";
}
elseif($_GET['module']=="4a"){
include "rl_4a.php";
}
elseif($_GET['module']=="4b"){
include "4b.php";
}
elseif($_GET['module']=="5.1"){
include "rl_5.1.php";
}
elseif($_GET['module']=="5.2"){
include "rl_5.2.php";
}
elseif($_GET['module']=="5.3"){
include "rl_5.3.php";
}
elseif($_GET['module']=="5.4"){
include "rl_5.4.php";
}
else {
?>
<div class="panel-heading">
<h4>WELCOME TO DASHBOARD</h4></div>
<div class="panel-body">
SILAKAN KLIK MENU PILIHAN LAPORAN RL UNTUK MELIHAT DATA.
<p>
<?
}
?>


@@ -0,0 +1,65 @@
<?php
include '../conf/conf.php';
/* header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=LaporanRekapKunjuangnJenisBayar.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";*/
?>
<html>
<body>
<div class="panel-heading">
<h4>Laporan RL 1.3</h4></div>
<div class="panel-body">
<?php
switch($_GET[act]){
default:
reportsqlinjection();
date_default_timezone_set("Asia/Jakarta");
$datatime=date("Y-m-d H:i:s");
$date1 = $_POST['tanggal1'];
$date2 = $_POST['tanggal2'];
$date=$_POST['tanggal'];
$tanggal1=date("Y-m-d",strtotime($date1));
$tanggal2=date("Y-m-d",strtotime($date2));
//tampilkan dalam tabel
echo"
<table class='table table-bordered table-hover table-striped'' data-toggle='table'>
<tr>
<thead>
<td>Kode</td>
<td>Nama Ruang Rawat</td>
<td>Jenis Ruang Rawat</td>
<td>Jumlah Tempat Tidur</td>";
$_sql = "SELECT setting.kode_ppk, bangsal.nm_bangsal, aplicare_ketersediaan_kamar.kode_kelas_aplicare, Count(kamar.kd_kamar) AS jumlah
FROM kamar , bangsal , setting , aplicare_ketersediaan_kamar
WHERE kamar.kd_bangsal = bangsal.kd_bangsal AND kamar.kd_bangsal = aplicare_ketersediaan_kamar.kd_bangsal
GROUP BY kamar.kd_bangsal ORDER BY bangsal.nm_bangsal ASC";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$ppk=$baris['kode_ppk'];
$ruang=$baris['nm_bangsal'];
$jenis=$baris['kode_kelas_aplicare'];
$jml=$baris['jumlah'];

echo"
</tr>
</thead>
<td>$ppk</td>
<td>$ruang</td>
<td>$jenis</td>
<td>$jml</td>
</tr>";
}
echo"
</table>";

break ;
}
?>




</body>
</html>
@@ -0,0 +1,69 @@
<?php
include '../conf/conf.php';
/* header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=LaporanRekapKunjuangnJenisBayar.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";*/
?>
<html>
<body>
<div class="panel-heading">
<h4>Laporan RL 3.1</h4></div>
<div class="panel-body">
<?php
switch($_GET[act]){
default:
echo"<form action='?module=3.1&act=tampil' method='post'>
<table>
<tr>
<td>Periode</td><td>:</td><td><input type='text' id='calender1' name='tanggal1' >-S/D-<input type='text' id='calender' name='tanggal2' ></td>
<td align='right'><input type='submit' value='tampilkan' ></td>
</tr>
</table>
</form>";
break;

case "tampil":
reportsqlinjection();
date_default_timezone_set("Asia/Jakarta");
$datatime=date("Y-m-d H:i:s");
$date1 = $_POST['tanggal1'];
$date2 = $_POST['tanggal2'];
$tanggal1=date("Y-m-d",strtotime($date1));
$tanggal2=date("Y-m-d",strtotime($date2));
$datatime=date("Y-m-d H:i:s");
echo"
<input type='button' value='Back' onclick=self.history.go(-1)>
<h3>Periode: $tanggal1 - $tanggal2</h3>
<table class='table table-bordered table-hover table-striped' data-toggle='table'>
<thead>
<tr>
<td>Kode</td>
<td>Tanggal</td>
<td>Nama Instalasi</td>
<td>Nama Ruangan</td>
<td>Jumlah Pasien</td>";
$_sql = "SELECT setting.kode_ppk, poliklinik.nm_poli, Count(poliklinik.kd_poli) AS jumlah_pasien
FROM reg_periksa , poliklinik , setting
WHERE reg_periksa.kd_poli = poliklinik.kd_poli AND reg_periksa.kd_poli != 'IGDK' AND reg_periksa.tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2'
GROUP BY poliklinik.nm_poli";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
echo"
</tr>
</thead>
<td>$baris[kode_ppk]</td>
<td>$tanggal2</td>
<td>Instalasi Rawat Jalan</td>
<td>$baris[nm_poli]</td>
<td>$baris[jumlah_pasien]</td>
</tr>";
}
echo"
<table>";
break ;
}
?>
</body>
</html>
@@ -0,0 +1,72 @@
<?php
include '../conf/conf.php';
/* header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=LaporanRekapKunjuangnJenisBayar.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";*/
?>
<html>
<body>
<div class="panel-heading">
<h4>Laporan RL 3.10</h4></div>
<div class="panel-body">
<?php
switch($_GET[act]){
default:
echo"<form action='?module=3.10-&act=tampil' method='post'>
<table>
<tr>
<td>Periode</td><td>:</td><td><input type='text' id='calender1' name='tanggal1' >-S/D-<input type='text' id='calender' name='tanggal2' ></td>
<td align='right'><input type='submit' value='tampilkan' ></td>
</tr>
</table>
</form>";
break;

case "tampil":
reportsqlinjection();
date_default_timezone_set("Asia/Jakarta");
$datatime=date("Y-m-d H:i:s");
$date1 = $_POST['tanggal1'];
$date2 = $_POST['tanggal2'];
$tanggal1=date("Y-m-d",strtotime($date1));
$tanggal2=date("Y-m-d",strtotime($date2));
$datatime=date("$tanggal2 H:i:s");
$waktu=date("H:i:s");
echo"
<input type='button' value='Back' onclick=self.history.go(-1)>
<h3>Periode: $tanggal1 - $tanggal2</h3>
<table class='table table-bordered table-hover table-striped' data-toggle='table'>
<thead>
<tr>
<td>Kode</td>
<td>Tanggal</td>
<td>Nama Perawatan</td>
<td>Jumlah Pasien</td>";
$_sql = "SELECT setting.kode_ppk, jns_perawatan_radiologi.nm_perawatan, COUNT(periksa_radiologi.kd_jenis_prw) as jumlah
FROM periksa_radiologi , jns_perawatan_radiologi, setting
WHERE periksa_radiologi.kd_jenis_prw = jns_perawatan_radiologi.kd_jenis_prw AND periksa_radiologi.tgl_periksa BETWEEN '$tanggal1' AND '$tanggal2'
GROUP BY periksa_radiologi.kd_jenis_prw";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$ppk=$baris['kode_ppk'];
$jenis=$baris['nm_perawatan'];
$jml=$baris['jumlah'];

echo"
</tr>
</thead>
<td>$ppk</td>
<td>$tanggal2</td>
<td>$jenis</td>
<td>$jml</td>
</tr>";
}
echo"
<table>";
break ;
}
?>
</body>
</html>
@@ -0,0 +1,128 @@
<?php
include '../conf/conf.php';
/* header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=LaporanRekapKunjuangnJenisBayar.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";*/
?>
<html>
<body>
<div class="panel-heading">
<h4>Laporan RL 3.15</h4></div>
<div class="panel-body">
<?php
switch($_GET[act]){
default:
echo"<form action='?module=3.15&act=tampil' method='post'>
<table>
<tr>
<td>Periode</td><td>:</td><td><input type='text' id='calender1' name='tanggal1' >-S/D-<input type='text' id='calender' name='tanggal2' ></td>
<td align='right'><input type='submit' value='tampilkan' ></td>
</tr>
</table>
</form>";
break;

case "tampil":
reportsqlinjection();
date_default_timezone_set("Asia/Jakarta");
$datatime=date("Y-m-d H:i:s");
$date1 = $_POST['tanggal1'];
$date2 = $_POST['tanggal2'];
$tanggal1=date("Y-m-d",strtotime($date1));
$tanggal2=date("Y-m-d",strtotime($date2));
$datatime=date("Y-m-d H:i:s");

//query poliklinik
$_poli="SELECT * FROM poliklinik";
$poli=bukaquery($_poli);

//query setting
$ppkkode="SELECT * FROM setting";
$ppk_kode=bukaquery($ppkkode);

while($ppk = mysql_fetch_array($ppk_kode)) {
$k_ppk=$ppk['kode_ppk'];
$n_ppk=$ppk['nama_ppk'];
}

//echo $n_ppk;
$_jenis = Array('UMUM','BPJS');
$_instalasi = Array('Instalasi Rawat Jalan','Instalasi Gawat Darurat','Instalasi Rawat Inap');
$myvars="";
echo"
<input type='button' value='Back' onclick=self.history.go(-1)>
<h3>Periode: $tanggal1 - $tanggal2</h3>
<table class='table table-bordered table-hover table-striped' data-toggle='table'>
<thead>
<tr>
<td>Kode</td>
<td>Tanggal</td>
<td>Nama Instalasi</td>
<td>Jenis Bayar</td>
<td>Jumlah Pasien</td>
<td>Nama Instalasi</td>
<td>Jenis Bayar</td>
<td>Jumlah Pasien</td>";

foreach($_instalasi as $instansi) {
echo"
</tr>
</thead>
<td>$k_ppk</td>
<td>$tanggal2</td>
";
if('Instalasi Gawat Darurat'==$instansi)
{
foreach($_jenis as $jns_byr)
{
$_sql = "SELECT Count(reg_periksa.kd_pj) AS jumlah_pasien
FROM reg_periksa JOIN penjab ON reg_periksa.kd_pj = penjab.kd_pj WHERE reg_periksa.kd_poli = 'IGD' AND png_jawab='$jns_byr' AND tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2'";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$jml_pasien=$baris['jumlah_pasien'];
}
echo"<td>$instansi</td>
<td>$jns_byr</td>
<td>$jml_pasien</td>";
}}
else if('Instalasi Rawat Jalan'==$instansi)
{
foreach($_jenis as $jns_byr)
{
$_sql = "SELECT Count(reg_periksa.kd_pj) AS jumlah_pasien
FROM reg_periksa JOIN penjab ON reg_periksa.kd_pj = penjab.kd_pj WHERE reg_periksa.kd_poli != 'IGD' AND png_jawab='$jns_byr' AND tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2'";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$jml_pasien=$baris['jumlah_pasien'];
}
echo"<td>$instansi</td>
<td>$jns_byr</td>
<td>$jml_pasien</td>";
}}
else
{
foreach($_jenis as $jns_byr)
{
$_sql = "SELECT Count(reg_periksa.kd_pj) AS jumlah_pasien
FROM reg_periksa JOIN penjab ON reg_periksa.kd_pj = penjab.kd_pj WHERE png_jawab='$jns_byr' AND status_lanjut='Ranap' AND tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2' ";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$jml_pasien=$baris['jumlah_pasien'];
}
echo"<td>$instansi</td>
<td>$jns_byr</td>
<td>$jml_pasien</td>";
}}

echo"
</tr>";
}
echo"
<table>";
break ;
}
?>
</body>
</html>
@@ -0,0 +1,129 @@
<?php
include '../conf/conf.php';
/* header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=LaporanRekapKunjuangnJenisBayar.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";*/
?>
<html>
<body>
<div class="panel-heading">
<h4>Laporan RL 5.1</h4></div>
<div class="panel-body">
<?php
switch($_GET[act]){
default:
echo"<form action='?module=5.1&act=tampil' method='post'>
<table>
<tr>
<td>Periode</td><td>:</td><td><input type='text' id='calender1' name='tanggal1' >-S/D-<input type='text' id='calender' name='tanggal2' ></td>
<td align='right'><input type='submit' value='tampilkan' ></td>
</tr>
</table>
</form>";
break;

case "tampil":
reportsqlinjection();
date_default_timezone_set("Asia/Jakarta");
$datatime=date("Y-m-d H:i:s");
$date1 = $_POST['tanggal1'];
$date2 = $_POST['tanggal2'];
$tanggal1=date("Y-m-d",strtotime($date1));
$tanggal2=date("Y-m-d",strtotime($date2));


//query poliklinik
$_poli="SELECT * FROM poliklinik";
$poli=bukaquery($_poli);


//query seting
$ppkkode="SELECT * FROM setting";
$ppk_kode=bukaquery($ppkkode);

while($ppk = mysql_fetch_array($ppk_kode)) {
$k_ppk=$ppk['kode_ppk'];
$n_ppk=$ppk['nama_ppk'];
}

//echo $n_ppk;
$_stts_daftar = Array('Baru','Lama');
$_instalasi = Array('Instalasi Rawat Jalan','Instalasi Gawat Darurat','Instalasi Rawat Inap');
$myvars="";
echo"
<input type='button' value='Back' onclick=self.history.go(-1)>
<h3>Periode: $tanggal1 - $tanggal2</h3>
<table class='table table-bordered table-hover table-striped' data-toggle='table'>
<thead>
<tr>
<td>Kode</td>
<td>Tanggal</td>
<td>Nama Instalasi</td>
<td>Status Pasien</td>
<td>Jumlah Pasien</td>
<td>Nama Instalasi</td>
<td>Status Pasien</td>
<td>Jumlah Pasien</td>";

foreach($_instalasi as $instansi) {
echo"
</tr>
</thead>
<td>$k_ppk</td>
<td>$tanggal2</td>";

if('Instalasi Gawat Darurat'==$instansi)
{
foreach($_stts_daftar as $status_pasien)
{
$_sql = "SELECT Count(reg_periksa.stts_daftar) AS jumlah_pasien
FROM reg_periksa WHERE reg_periksa.kd_poli = 'IGDK' AND stts_daftar='$status_pasien' AND tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2'";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$jml_pasien=$baris['jumlah_pasien'];
}
echo"<td>$instansi</td>
<td>$status_pasien</td>
<td>$jml_pasien</td>";
}}
else if('Instalasi Rawat Jalan'==$instansi)
{
foreach($_stts_daftar as $status_pasien)
{
$_sql = "SELECT Count(reg_periksa.stts_daftar) AS jumlah_pasien
FROM reg_periksa WHERE reg_periksa.kd_poli != 'IGDK' AND stts_daftar='$status_pasien' AND tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2'";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$jml_pasien=$baris['jumlah_pasien'];
}
echo"<td>$instansi</td>
<td>$status_pasien</td>
<td>$jml_pasien</td>";
}}
else
{
foreach($_stts_daftar as $status_pasien)
{
$_sql = "SELECT Count(reg_periksa.stts_daftar) AS jumlah_pasien
FROM reg_periksa WHERE stts_daftar='$status_pasien' AND status_lanjut='Ranap' AND tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2' ";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$jml_pasien=$baris['jumlah_pasien'];
}
echo"<td>$instansi</td>
<td>$status_pasien</td>
<td>$jml_pasien</td>";
}}

echo"
</tr>";
}
echo"
<table>";
break ;
}
?>
</body>
</html>
@@ -0,0 +1,69 @@
<?php
include '../conf/conf.php';
/* header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=LaporanRekapKunjuangnJenisBayar.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";*/
?>
<html>
<body>
<div class="panel-heading">
<h4>Laporan RL 5.2</h4></div>
<div class="panel-body">
<?php
switch($_GET[act]){
default:
echo"<form action='?module=5.2&act=tampil' method='post'>
<table>
<tr>
<td>Periode</td><td>:</td><td><input type='text' id='calender1' name='tanggal1' >-S/D-<input type='text' id='calender' name='tanggal2' ></td>
<td align='right'><input type='submit' value='tampilkan' ></td>
</tr>
</table>
</form>";
break;

case "tampil":
reportsqlinjection();
date_default_timezone_set("Asia/Jakarta");
$datatime=date("Y-m-d H:i:s");
$date1 = $_POST['tanggal1'];
$date2 = $_POST['tanggal2'];
$tanggal1=date("Y-m-d",strtotime($date1));
$tanggal2=date("Y-m-d",strtotime($date2));
$datatime=date("Y-m-d H:i:s");
echo"
<input type='button' value='Back' onclick=self.history.go(-1)>
<h3>Periode: $tanggal1 - $tanggal2</h3>
<table class='table table-bordered table-hover table-striped' data-toggle='table'>
<thead>
<tr>
<td>Kode</td>
<td>Tanggal</td>
<td>Nama Instalasi</td>
<td>Nama Ruangan</td>
<td>Jumlah Pasien</td>";
$_sql = "SELECT setting.kode_ppk, poliklinik.nm_poli, Count(poliklinik.kd_poli) AS jumlah_pasien
FROM reg_periksa , poliklinik , setting
WHERE reg_periksa.kd_poli = poliklinik.kd_poli AND reg_periksa.kd_poli != 'IGDK' AND reg_periksa.tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2'
GROUP BY poliklinik.nm_poli";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
echo"
</tr>
</thead>
<td>$baris[kode_ppk]</td>
<td>$tanggal2</td>
<td>Instalasi Rawat Jalan</td>
<td>$baris[nm_poli]</td>
<td>$baris[jumlah_pasien]</td>
</tr>";
}
echo"
<table>";
break ;
}
?>
</body>
</html>
@@ -0,0 +1,157 @@
<?php
include '../conf/conf.php';
/* header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=LaporanRekapKunjuangnJenisBayar.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";*/
?>
<html>
<body>
<div class="panel-heading">
<h4>Laporan RL 5.3</h4></div>
<div class="panel-body">
<?php
switch($_GET[act]){
default:
echo"<form action='?module=5.3&act=tampil' method='post'>
<table>
<tr>
<td>Periode</td><td>:</td><td><input type='text' id='calender1' name='tanggal1' >-S/D-<input type='text' id='calender' name='tanggal2' ></td>
<td align='right'><input type='submit' value='tampilkan' ></td>
</tr>
</table>
</form>";
break;

case "tampil":
reportsqlinjection();
date_default_timezone_set("Asia/Jakarta");
$datatime=date("Y-m-d H:i:s");
$date1 = $_POST['tanggal1'];
$date2 = $_POST['tanggal2'];
$tanggal1=date("Y-m-d",strtotime($date1));
$tanggal2=date("Y-m-d",strtotime($date2));
$datatime=date("Y-m-d H:i:s");


//query poliklinik
$_poli="SELECT * FROM poliklinik";
$poli=bukaquery($_poli);


//query setting
$ppkkode="SELECT * FROM setting";
$ppk_kode=bukaquery($ppkkode);

while($ppk = mysql_fetch_array($ppk_kode)) {
$k_ppk=$ppk['kode_ppk'];
$n_ppk=$ppk['nama_ppk'];
}

//echo $n_ppk;
$_stts_daftar = Array('Ralan','Ranap');
$_instalasi = Array('Instalasi Rawat Jalan','Instalasi Gawat Darurat','Instalasi Rawat Inap');
$myvars="";
echo"
<input type='button' value='Back' onclick=self.history.go(-1)>
<h3>Periode: $tanggal1 - $tanggal2</h3>
<table class='table table-bordered table-hover table-striped' data-toggle='table'>
<thead>
<tr>
<td>Kode</td>
<td>Tanggal</td>
<td>Nama Instalasi</td>
<td>Kode Penyakit</td>
<td>Nama Penyakit</td>
<td>Jumlah Pasien</td>
<td>Nama Instalasi</td>
<td>Kode Penyakit</td>
<td>Nama Penyakit</td>
<td>Jumlah Pasien</td>";

foreach($_instalasi as $instansi) {
echo"
<td>Nama Instalasi</td>
<td>Kode Penyakit</td>
<td>Nama Penyakit</td>
<td>Jumlah Pasien</td>
<td>Nama Instalasi</td>
<td>Kode Penyakit</td>
<td>Nama Penyakit</td>
<td>Jumlah Pasien</td>
</tr>
</thead>
<td>$k_ppk</td>
<td>$tanggal2</td>";

if('Instalasi Gawat Darurat'==$instansi)
{
foreach($_stts_daftar as $status_pasien)
{
$_sql = "SELECT diagnosa_pasien.kd_penyakit,penyakit.nm_penyakit, Count(diagnosa_pasien.kd_penyakit) AS jumlah_pasien
FROM diagnosa_pasien ,penyakit ,reg_periksa WHERE diagnosa_pasien.kd_penyakit = penyakit.kd_penyakit AND diagnosa_pasien.no_rawat = reg_periksa.no_rawat AND reg_periksa.kd_poli = 'IGDK' AND
diagnosa_pasien.status = 'Ralan' AND reg_periksa.tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2'
GROUP BY diagnosa_pasien.kd_penyakit";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$kode_penyakit=$baris['kd_penyakit'];
$nama_penyakit=$baris['nm_penyakit'];
$jml_pasien=$baris['jumlah_pasien'];
echo"<td>$instansi</td>
<td>$kode_penyakit</td>
<td>$nama_penyakit</td>
<td>$jml_pasien</td>";
}
}}
else if('Instalasi Rawat Jalan'==$instansi)
{
foreach($_stts_daftar as $status_pasien)
{
$_sql = "SELECT diagnosa_pasien.kd_penyakit,penyakit.nm_penyakit, Count(diagnosa_pasien.kd_penyakit) AS jumlah_pasien
FROM diagnosa_pasien ,penyakit ,reg_periksa WHERE diagnosa_pasien.kd_penyakit = penyakit.kd_penyakit AND
diagnosa_pasien.no_rawat = reg_periksa.no_rawat AND reg_periksa.kd_poli != 'IGDK' AND
diagnosa_pasien.status = 'Ralan' AND reg_periksa.tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2'
GROUP BY diagnosa_pasien.kd_penyakit";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$kode_penyakit=$baris['kd_penyakit'];
$nama_penyakit=$baris['nm_penyakit'];
$jml_pasien=$baris['jumlah_pasien'];
echo"<td>$instansi</td>
<td>$kode_penyakit</td>
<td>$nama_penyakit</td>
<td>$jml_pasien</td>";
}
}}
else
{
foreach($_stts_daftar as $status_pasien)
{
$_sql = "SELECT diagnosa_pasien.kd_penyakit,penyakit.nm_penyakit, Count(diagnosa_pasien.kd_penyakit) AS jumlah_pasien
FROM diagnosa_pasien ,penyakit ,reg_periksa WHERE diagnosa_pasien.kd_penyakit = penyakit.kd_penyakit AND
diagnosa_pasien.no_rawat = reg_periksa.no_rawat AND diagnosa_pasien.status = 'Ranap' AND
reg_periksa.tgl_registrasi BETWEEN '$tanggal1' AND '$tanggal2'
GROUP BY diagnosa_pasien.kd_penyakit ";
$hasil=bukaquery($_sql);
while($baris = mysql_fetch_array($hasil)) {
$kode_penyakit=$baris['kd_penyakit'];
$nama_penyakit=$baris['nm_penyakit'];
$jml_pasien=$baris['jumlah_pasien'];
echo"<td>$instansi</td>
<td>$kode_penyakit</td>
<td>$nama_penyakit</td>
<td>$jml_pasien</td>";
}
}}

echo"
</tr>";
}
echo"
<table>";
break ;
}
?>
</body>
</html>
@@ -2,17 +2,17 @@
require_once('../conf/conf.php');

function getKey() {
$keyRS = "23beec4e4daec451c28dc4d4816bbb2a6d033a0878c91230c21667283dff0bfb";
$keyRS = "d2a382fc9d2dd3cdd000cf4c59fee76b98e536e3811006e89c699c777a4d18ed";
return $keyRS;
}

function getUrlWS() {
$UrlWS = "http://inacbg.rs.uns.ac.id/E-Klaim/ws.php";
$UrlWS = "http://192.168.0.103/E-Klaim/ws.php";
return $UrlWS;
}

function getKelasRS() {
$kelasRS = "CP";
$kelasRS = "BP";
return $kelasRS;
}