API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 23rd, 2019
140
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 45.83 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. * To change this license header, choose License Headers in Project Properties.
  3. * To change this template file, choose Tools | Templates
  4. * and open the template in the editor.
  5. */
  6. package arya.form;
  7.  
  8. import java.awt.event.KeyEvent;
  9. import java.text.DateFormat;
  10. import java.text.SimpleDateFormat;
  11. import java.util.ArrayList;
  12. import java.util.Calendar;
  13. import java.util.List;
  14. import javax.swing.DefaultCellEditor;
  15. import javax.swing.JCheckBox;
  16. import javax.swing.JOptionPane;
  17. import javax.swing.JTable;
  18. import javax.swing.table.DefaultTableModel;
  19. import javax.swing.table.TableColumn;
  20. import net.sf.jasperreports.engine.JRException;
  21. import net.sf.jasperreports.engine.JasperCompileManager;
  22. import net.sf.jasperreports.engine.JasperFillManager;
  23. import net.sf.jasperreports.engine.JasperPrint;
  24. import net.sf.jasperreports.engine.JasperReport;
  25. import net.sf.jasperreports.view.JasperViewer;
  26. import java.sql.Connection;
  27. import java.sql.DriverManager;
  28. import java.sql.ResultSet;
  29. import java.sql.Statement;
  30. import java.util.Date;
  31. import java.util.HashMap;
  32. import java.util.Map;
  33. import javax.swing.table.AbstractTableModel;
  34. import peminjaman.drm.impl.reportimpl;
  35. import peminjaman.drm.entiti.entitidetailpinjam;
  36. import peminjaman.drm.koneksi.koneksi;
  37. import peminjaman.drm.entiti.entitipengembalian;
  38. /**
  39. *
  40. * @author Rena
  41. */
  42. public class laporan extends javax.swing.JInternalFrame {
  43. private TableModelPeminjaman model;
  44. private List<entitidetailpinjam> peminjam;
  45. private entitidetailpinjam pinjam1;
  46. private TableModelPengembalian model1;
  47. private List<entitipengembalian> pengembalian1;
  48.  
  49. private entitipengembalian kembali1;
  50. Connection con=null;
  51. Statement st=null;
  52. ResultSet rs=null;
  53. String sql=null;
  54.  
  55.  
  56.  
  57.  
  58. public laporan() {
  59. try{
  60. Class.forName("com.mysql.jdbc.Driver");
  61. con=DriverManager.getConnection("jdbc:mysql://localhost:3306/db_peminjamandrm","root","");
  62. st=con.createStatement();
  63. }catch(Exception a){
  64. JOptionPane.showMessageDialog(null, "Koneksi Database Gagal, Terjadi kesalahaan Pada : \n"+a);
  65. }
  66. initComponents();
  67. model = new TableModelPeminjaman();
  68. model1 = new TableModelPengembalian();
  69.  
  70.  
  71. pinjem.setModel(model);
  72. balik.setModel(model1);
  73.  
  74. buttonGroup2.add(peminjaman);
  75. buttonGroup2.add(pengembalian);
  76.  
  77.  
  78. buttonGroup2.add(kurang);
  79. buttonGroup2.add(lebih);
  80. loadData();
  81. loadData1();
  82. }
  83. private void loadData(){
  84. peminjam = koneksi.getpeminjamandao().getAll();
  85. model.setData(peminjam);
  86. }
  87. private void loadData1(){
  88. pengembalian1 = koneksi.getpengembaliandao().getAll();
  89. model1.setData(pengembalian1);
  90. }
  91.  
  92. private void clear(){
  93. buttonGroup2.clearSelection();
  94. tgl1.setDate(new Date());
  95. tgl2.setDate(new Date());
  96. status.setSelectedItem("None");
  97.  
  98. }
  99.  
  100.  
  101. /**
  102. * Creates new form laporan
  103. */
  104.  
  105.  
  106. private void cetakpinjamperiode(){
  107. try{
  108. String tampilan = "yyyy-MM-dd HH:mm:ss";
  109. SimpleDateFormat fm = new SimpleDateFormat(tampilan);
  110. String tanggal = String.valueOf(fm.format(tgl1.getDate()));
  111. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  112. String tampilan1 = "yyyy-MM-dd HH:mm:ss";
  113. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  114. String tanggal1 = String.valueOf(fm1.format(tgl2.getDate()));
  115. SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
  116. String sumber;
  117. String tujuan;
  118. sumber= "C:\\Users\\Rena\\Documents\\NetBeansProjects\\Peminjaman-DRM\\src\\peminjaman\\drm\\report\\report peminjaman periode.jrxml";
  119. Map params = new HashMap(2);
  120. params.put("tgl1", tanggal);
  121. params.put("tgl2", tanggal1);
  122. JasperReport jr = JasperCompileManager.compileReport(sumber);
  123. JasperPrint jp = JasperFillManager.fillReport(jr,params,con);
  124.  
  125. JasperViewer.viewReport(jp,false);
  126. } catch (JRException ex) {
  127. JOptionPane.showMessageDialog(null, "Gagal tampilakn report"+ex);
  128. }
  129. }
  130. private void cetakkembaliperiode(){
  131. try{
  132. String tampilan = "yyyy-MM-dd HH:mm:ss";
  133. SimpleDateFormat fm = new SimpleDateFormat(tampilan);
  134. String tanggal = String.valueOf(fm.format(tgl1.getDate()));
  135. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  136. String tampilan1 = "yyyy-MM-dd HH:mm:ss";
  137. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  138. String tanggal1 = String.valueOf(fm1.format(tgl2.getDate()));
  139. SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
  140. String sumber;
  141. String tujuan;
  142. sumber= "C:\\Users\\Rena\\Documents\\NetBeansProjects\\Peminjaman-DRM\\src\\peminjaman\\drm\\report\\report pengembalian periode.jrxml";
  143. // tujuan = "src/amimarketaplikasi/ReportHasil/kwitansi.html";
  144. Map params = new HashMap(2);
  145. params.put("tgl1", tanggal);
  146. params.put("tgl2", tanggal1);
  147.  
  148. JasperReport jr = JasperCompileManager.compileReport(sumber);
  149. JasperPrint jp = JasperFillManager.fillReport(jr,params,con);
  150. // JasperExportManager.exportReportToHtmlFile(jp, tujuan);
  151. JasperViewer.viewReport(jp,false);
  152. } catch (JRException ex) {
  153. JOptionPane.showMessageDialog(null, "Gagal tampilakn report"+ex);
  154. }
  155. }
  156. private void cetakpeminjamanstatusperiode(){
  157. try{
  158. String tampilan = "yyyy-MM-dd HH:mm:ss";
  159. SimpleDateFormat fm = new SimpleDateFormat(tampilan);
  160. String tanggal = String.valueOf(fm.format(tgl1.getDate()));
  161. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  162. String tampilan1 = "yyyy-MM-dd HH:mm:ss";
  163. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  164. String tanggal1 = String.valueOf(fm1.format(tgl2.getDate()));
  165. SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
  166.  
  167. String sumber;
  168. String tujuan;
  169. sumber= "C:\\Users\\Rena\\Documents\\NetBeansProjects\\Peminjaman-DRM\\src\\peminjaman\\drm\\report\\report peminjaman status periode.jrxml";
  170. // tujuan = "src/amimarketaplikasi/ReportHasil/kwitansi.html";
  171. Map params = new HashMap(3);
  172. params.put("tgl1", tanggal);
  173. params.put("tgl2", tanggal1);
  174. params.put("status", status.getSelectedItem());
  175. JasperReport jr = JasperCompileManager.compileReport(sumber);
  176. JasperPrint jp = JasperFillManager.fillReport(jr,params,con);
  177. // JasperExportManager.exportReportToHtmlFile(jp, tujuan);
  178. JasperViewer.viewReport(jp,false);
  179. } catch (JRException ex) {
  180. JOptionPane.showMessageDialog(null, "Gagal tampilakn report"+ex);
  181. }
  182. }
  183.  
  184. private void cetaklamakembali(){
  185. try{
  186. String tampilan = "yyyy-MM-dd HH:mm:ss";
  187. SimpleDateFormat fm = new SimpleDateFormat(tampilan);
  188. String tanggal = String.valueOf(fm.format(tgl1.getDate()));
  189. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  190. String tampilan1 = "yyyy-MM-dd HH:mm:ss";
  191. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  192. String tanggal1 = String.valueOf(fm1.format(tgl2.getDate()));
  193. SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
  194. String sumber;
  195. String tujuan;
  196. sumber= "C:\\Users\\Rena\\Documents\\NetBeansProjects\\Peminjaman-DRM\\src\\peminjaman\\drm\\report\\report lama kembali.jrxml";
  197. // tujuan = "src/amimarketaplikasi/ReportHasil/kwitansi.html";
  198. Map params = new HashMap(2);
  199. params.put("tgl1", tanggal);
  200. params.put("tgl2", tanggal1);
  201.  
  202. JasperReport jr = JasperCompileManager.compileReport(sumber);
  203. JasperPrint jp = JasperFillManager.fillReport(jr,params,con);
  204. // JasperExportManager.exportReportToHtmlFile(jp, tujuan);
  205. JasperViewer.viewReport(jp,false);
  206. } catch (JRException ex) {
  207. JOptionPane.showMessageDialog(null, "Gagal tampilakn report"+ex);
  208. }
  209. }
  210. private void cetaklamakembali2(){
  211. try{
  212. String tampilan = "yyyy-MM-dd HH:mm:ss";
  213. SimpleDateFormat fm = new SimpleDateFormat(tampilan);
  214. String tanggal = String.valueOf(fm.format(tgl1.getDate()));
  215. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  216. String tampilan1 = "yyyy-MM-dd HH:mm:ss";
  217. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  218. String tanggal1 = String.valueOf(fm1.format(tgl2.getDate()));
  219. SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
  220. String sumber;
  221. String tujuan;
  222. sumber= "C:\\Users\\Rena\\Documents\\NetBeansProjects\\Peminjaman-DRM\\src\\peminjaman\\drm\\report\\report lama kembali 2.jrxml";
  223. // tujuan = "src/amimarketaplikasi/ReportHasil/kwitansi.html";
  224. Map params = new HashMap(2);
  225. params.put("tgl1", tanggal);
  226. params.put("tgl2", tanggal1);
  227.  
  228. JasperReport jr = JasperCompileManager.compileReport(sumber);
  229. JasperPrint jp = JasperFillManager.fillReport(jr,params,con);
  230. // JasperExportManager.exportReportToHtmlFile(jp, tujuan);
  231. JasperViewer.viewReport(jp,false);
  232. } catch (JRException ex) {
  233. JOptionPane.showMessageDialog(null, "Gagal tampilakn report"+ex);
  234. }
  235. }
  236. private void cetakgrafikstatus(){
  237. try{
  238. String tampilan = "yyyy-MM-dd HH:mm:ss";
  239. SimpleDateFormat fm = new SimpleDateFormat(tampilan);
  240. String tanggal = String.valueOf(fm.format(tgl1.getDate()));
  241. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  242. String tampilan1 = "yyyy-MM-dd HH:mm:ss";
  243. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  244. String tanggal1 = String.valueOf(fm1.format(tgl2.getDate()));
  245. SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
  246.  
  247. String sumber;
  248. String tujuan;
  249. sumber= "C:\\Users\\Rena\\Documents\\NetBeansProjects\\Peminjaman-DRM\\src\\peminjaman\\drm\\report\\report grafik peminjaman status.jrxml";
  250. // tujuan = "src/amimarketaplikasi/ReportHasil/kwitansi.html";
  251. Map params = new HashMap(3);
  252. params.put("tgl1", tanggal);
  253. params.put("tgl2", tanggal1);
  254. params.put("status", status.getSelectedItem());
  255. JasperReport jr = JasperCompileManager.compileReport(sumber);
  256. JasperPrint jp = JasperFillManager.fillReport(jr,params,con);
  257. // JasperExportManager.exportReportToHtmlFile(jp, tujuan);
  258. JasperViewer.viewReport(jp,false);
  259. } catch (JRException ex) {
  260. JOptionPane.showMessageDialog(null, "Gagal tampilakn report"+ex);
  261. }
  262. }
  263. private void cetakgrafikpinjam(){
  264. try{
  265. String tampilan = "yyyy-MM-dd HH:mm:ss";
  266. SimpleDateFormat fm = new SimpleDateFormat(tampilan);
  267. String tanggal = String.valueOf(fm.format(tgl1.getDate()));
  268. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  269. String tampilan1 = "yyyy-MM-dd HH:mm:ss";
  270. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  271. String tanggal1 = String.valueOf(fm1.format(tgl2.getDate()));
  272. SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
  273. String sumber;
  274. String tujuan;
  275. sumber= "C:\\Users\\Rena\\Documents\\NetBeansProjects\\Peminjaman-DRM\\src\\peminjaman\\drm\\report\\report grafik peminjaman.jrxml";
  276. // tujuan = "src/amimarketaplikasi/ReportHasil/kwitansi.html";
  277. Map params = new HashMap(2);
  278. params.put("tgl1", tanggal);
  279. params.put("tgl2", tanggal1);
  280.  
  281. JasperReport jr = JasperCompileManager.compileReport(sumber);
  282. JasperPrint jp = JasperFillManager.fillReport(jr,params,con);
  283. // JasperExportManager.exportReportToHtmlFile(jp, tujuan);
  284. JasperViewer.viewReport(jp,false);
  285. } catch (JRException ex) {
  286. JOptionPane.showMessageDialog(null, "Gagal tampilakn report"+ex);
  287. }
  288. }
  289. private void cetakgrafikkembali(){
  290. try{
  291. String tampilan = "yyyy-MM-dd HH:mm:ss";
  292. SimpleDateFormat fm = new SimpleDateFormat(tampilan);
  293. String tanggal = String.valueOf(fm.format(tgl1.getDate()));
  294. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  295. String tampilan1 = "yyyy-MM-dd HH:mm:ss";
  296. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  297. String tanggal1 = String.valueOf(fm1.format(tgl2.getDate()));
  298. SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
  299. String sumber;
  300. String tujuan;
  301. sumber= "C:\\Users\\Rena\\Documents\\NetBeansProjects\\Peminjaman-DRM\\src\\peminjaman\\drm\\report\\report grafik pengembalian.jrxml";
  302. // tujuan = "src/amimarketaplikasi/ReportHasil/kwitansi.html";
  303. Map params = new HashMap(2);
  304. params.put("tgl1", tanggal);
  305. params.put("tgl2", tanggal1);
  306.  
  307. JasperReport jr = JasperCompileManager.compileReport(sumber);
  308. JasperPrint jp = JasperFillManager.fillReport(jr,params,con);
  309. // JasperExportManager.exportReportToHtmlFile(jp, tujuan);
  310. JasperViewer.viewReport(jp,false);
  311. } catch (JRException ex) {
  312. JOptionPane.showMessageDialog(null, "Gagal tampilakn report"+ex);
  313. }
  314. }
  315. private void cetakgrafikdalam(){
  316. try{
  317. String tampilan = "yyyy-MM-dd HH:mm:ss";
  318. SimpleDateFormat fm = new SimpleDateFormat(tampilan);
  319. String tanggal = String.valueOf(fm.format(tgl1.getDate()));
  320. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  321. String tampilan1 = "yyyy-MM-dd HH:mm:ss";
  322. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  323. String tanggal1 = String.valueOf(fm1.format(tgl2.getDate()));
  324. SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
  325. String sumber;
  326. String tujuan;
  327. sumber= "C:\\Users\\Rena\\Documents\\NetBeansProjects\\Peminjaman-DRM\\src\\peminjaman\\drm\\report\\repor grafik kurang kembali.jrxml";
  328. // tujuan = "src/amimarketaplikasi/ReportHasil/kwitansi.html";
  329. Map params = new HashMap(2);
  330. params.put("tgl1", tanggal);
  331. params.put("tgl2", tanggal1);
  332.  
  333. JasperReport jr = JasperCompileManager.compileReport(sumber);
  334. JasperPrint jp = JasperFillManager.fillReport(jr,params,con);
  335. // JasperExportManager.exportReportToHtmlFile(jp, tujuan);
  336. JasperViewer.viewReport(jp,false);
  337. } catch (JRException ex) {
  338. JOptionPane.showMessageDialog(null, "Gagal tampilakn report"+ex);
  339. }
  340. }
  341. private void cetakgrafiklebih(){
  342. try{
  343. String tampilan = "yyyy-MM-dd HH:mm:ss";
  344. SimpleDateFormat fm = new SimpleDateFormat(tampilan);
  345. String tanggal = String.valueOf(fm.format(tgl1.getDate()));
  346. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  347. String tampilan1 = "yyyy-MM-dd HH:mm:ss";
  348. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  349. String tanggal1 = String.valueOf(fm1.format(tgl2.getDate()));
  350. SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
  351. String sumber;
  352. String tujuan;
  353. sumber= "C:\\Users\\Rena\\Documents\\NetBeansProjects\\Peminjaman-DRM\\src\\peminjaman\\drm\\report\\report grafik kembali lebih.jrxml";
  354. // tujuan = "src/amimarketaplikasi/ReportHasil/kwitansi.html";
  355. Map params = new HashMap(2);
  356. params.put("tgl1", tanggal);
  357. params.put("tgl2", tanggal1);
  358.  
  359. JasperReport jr = JasperCompileManager.compileReport(sumber);
  360. JasperPrint jp = JasperFillManager.fillReport(jr,params,con);
  361. // JasperExportManager.exportReportToHtmlFile(jp, tujuan);
  362. JasperViewer.viewReport(jp,false);
  363. } catch (JRException ex) {
  364. JOptionPane.showMessageDialog(null, "Gagal tampilakn report"+ex);
  365. }
  366. }
  367. private class TableModelPeminjaman extends AbstractTableModel{
  368. private List<entitidetailpinjam> list = new ArrayList<>();
  369.  
  370. public void setData(List<entitidetailpinjam> list){
  371. this.list = list;
  372. fireTableDataChanged();
  373. }
  374. public int getRowCount() {
  375. return list.size();
  376. }
  377.  
  378. public int getColumnCount() {
  379. return 11;
  380. }
  381.  
  382. public Object getValueAt(int rowIndex, int columnIndex) {
  383. switch(columnIndex){
  384.  
  385. case 0 : return list.get(rowIndex).gettgl();
  386. case 1 : return list.get(rowIndex).gettgljtntempo();
  387. case 2 : return list.get(rowIndex).getnippeminjam();
  388. case 3 : return list.get(rowIndex).getnamapeminjam();
  389. case 4 : return list.get(rowIndex).getnorm();
  390. case 5 : return list.get(rowIndex).getnamapasien();
  391. case 6 : return list.get(rowIndex).getnippetugas();
  392. case 7 : return list.get(rowIndex).getpetugas();
  393. case 8 : return list.get(rowIndex).getkeperluan();
  394. case 9 : return list.get(rowIndex).getstatus();
  395. case 10 : return list.get(rowIndex).getketerangan();
  396.  
  397. default: return null;
  398. }
  399. }
  400.  
  401. @Override
  402. public String getColumnName(int columnIndex) {
  403. switch(columnIndex){
  404.  
  405.  
  406. case 0 : return "Tanggal Peminjaman";
  407. case 1 : return "Tanggal Jatuh Tempo";
  408. case 2 : return "NIP Peminjam";
  409. case 3 : return "Nama Peminjam";
  410. case 4 : return "No RM";
  411. case 5 : return "Nama Pasien";
  412. case 6 : return "NIP Petugas";
  413. case 7 : return "Nama Petugas";
  414. case 8 : return "Keperluan";
  415. case 9 : return "Status";
  416. case 10: return "Keterangan";
  417.  
  418. default: return null;
  419. }
  420. }
  421. public void insertTable(entitidetailpinjam pasien){
  422. list.add(pasien);
  423. fireTableDataChanged();
  424. }
  425. public void updateTable(entitidetailpinjam pasien,int rowIndex){
  426. list.set(rowIndex, pasien);
  427. fireTableDataChanged();
  428. }
  429. public entitidetailpinjam get(int rowIndex){
  430. return list.get(rowIndex);
  431. }
  432. }
  433. private class TableModelPengembalian extends AbstractTableModel{
  434. private List<entitipengembalian> list = new ArrayList<>();
  435.  
  436. public void setData(List<entitipengembalian> list){
  437. this.list = list;
  438. fireTableDataChanged();
  439. }
  440. public int getRowCount() {
  441. return list.size();
  442. }
  443.  
  444. public int getColumnCount() {
  445. return 6;
  446. }
  447.  
  448. public Object getValueAt(int rowIndex, int columnIndex) {
  449. switch(columnIndex){
  450. case 0 : return list.get(rowIndex).gettglkembali();
  451. case 1 : return list.get(rowIndex).getidpinjam();
  452. case 2 : return list.get(rowIndex).getlamapinjam();
  453. case 3 : return list.get(rowIndex).getnip();
  454. case 4 : return list.get(rowIndex).getnama();
  455. case 5 : return list.get(rowIndex).getketerangan();
  456. default: return null;
  457. }
  458. }
  459.  
  460. @Override
  461. public String getColumnName(int columnIndex) {
  462. switch(columnIndex){
  463. case 0 : return "Tanggal Kembali";
  464. case 1 : return "ID Peminjam";
  465. case 2 : return "Lama Pinjam";
  466. case 3 : return "Petugas";
  467. case 4 : return "Nama Petugas";
  468. case 5: return "Keterangan";
  469. default: return null;
  470. }
  471. }
  472. public void insertTable(entitipengembalian pegawai){
  473. list.add(pegawai);
  474. fireTableDataChanged();
  475. }
  476. public void updateTable(entitipengembalian pegawai,int rowIndex){
  477. list.set(rowIndex, pegawai);
  478. fireTableDataChanged();
  479. }
  480. public entitipengembalian get(int rowIndex){
  481. return list.get(rowIndex);
  482. }
  483. }
  484. /**
  485. * This method is called from within the constructor to initialize the form.
  486. * WARNING: Do NOT modify this code. The content of this method is always
  487. * regenerated by the Form Editor.
  488. */
  489. @SuppressWarnings("unchecked")
  490. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  491. private void initComponents() {
  492.  
  493. buttonGroup2 = new javax.swing.ButtonGroup();
  494. buttonGroup4 = new javax.swing.ButtonGroup();
  495. jPanel1 = new javax.swing.JPanel();
  496. jLabel1 = new javax.swing.JLabel();
  497. jLabel2 = new javax.swing.JLabel();
  498. jLabel3 = new javax.swing.JLabel();
  499. jLabel17 = new javax.swing.JLabel();
  500. jLabel18 = new javax.swing.JLabel();
  501. jLabel19 = new javax.swing.JLabel();
  502. jLayeredPane1 = new javax.swing.JLayeredPane();
  503. pengembalian = new javax.swing.JRadioButton();
  504. kurang = new javax.swing.JRadioButton();
  505. lebih = new javax.swing.JRadioButton();
  506. jScrollPane2 = new javax.swing.JScrollPane();
  507. pinjem = new javax.swing.JTable();
  508. jButton1 = new javax.swing.JButton();
  509. jButton2 = new javax.swing.JButton();
  510. jLayeredPane2 = new javax.swing.JLayeredPane();
  511. peminjaman = new javax.swing.JRadioButton();
  512. jLabel5 = new javax.swing.JLabel();
  513. status = new javax.swing.JComboBox<>();
  514. tgl1 = new com.toedter.calendar.JDateChooser();
  515. tgl2 = new com.toedter.calendar.JDateChooser();
  516. jLabel4 = new javax.swing.JLabel();
  517. jLabel10 = new javax.swing.JLabel();
  518. jLabel11 = new javax.swing.JLabel();
  519. jScrollPane1 = new javax.swing.JScrollPane();
  520. balik = new javax.swing.JTable();
  521. jButton3 = new javax.swing.JButton();
  522. jButton4 = new javax.swing.JButton();
  523. jButton5 = new javax.swing.JButton();
  524. jButton6 = new javax.swing.JButton();
  525.  
  526. setClosable(true);
  527. setTitle("Aplikasi Peminjaman Rekam Medis RSP Dr. H. A. Rotinsulu Bandung");
  528. setFrameIcon(new javax.swing.ImageIcon(getClass().getResource("/peminjaman/drm/icon/images.jpg"))); // NOI18N
  529. setMinimumSize(new java.awt.Dimension(1365, 715));
  530. setPreferredSize(new java.awt.Dimension(1365, 715));
  531. getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
  532.  
  533. jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
  534.  
  535. jLabel1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/peminjaman/drm/icon/download.png"))); // NOI18N
  536.  
  537. jLabel2.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
  538. jLabel2.setText("Laporan Peminjaman dan Pengembalian Rekam Medis ");
  539.  
  540. jLabel3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/peminjaman/drm/icon/images.jpg"))); // NOI18N
  541.  
  542. jLabel17.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
  543. jLabel17.setText("RSP Dr. H. A. Rotinsulu Bandung");
  544.  
  545. jLabel18.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
  546. jLabel18.setText("Cidadap, Kota Bandung, Jawa Barat 40141");
  547.  
  548. jLabel19.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
  549. jLabel19.setText("Jl. Bukit Jarian No.40, Hegarmanah ");
  550.  
  551. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  552. jPanel1.setLayout(jPanel1Layout);
  553. jPanel1Layout.setHorizontalGroup(
  554. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  555. .addGroup(jPanel1Layout.createSequentialGroup()
  556. .addGap(29, 29, 29)
  557. .addComponent(jLabel1)
  558. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 340, Short.MAX_VALUE)
  559. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  560. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
  561. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  562. .addGroup(jPanel1Layout.createSequentialGroup()
  563. .addGap(20, 20, 20)
  564. .addComponent(jLabel17))
  565. .addComponent(jLabel18)
  566. .addGroup(jPanel1Layout.createSequentialGroup()
  567. .addGap(10, 10, 10)
  568. .addComponent(jLabel19)))
  569. .addGap(147, 147, 147))
  570. .addComponent(jLabel2, javax.swing.GroupLayout.Alignment.TRAILING))
  571. .addGap(314, 314, 314)
  572. .addComponent(jLabel3)
  573. .addGap(42, 42, 42))
  574. );
  575. jPanel1Layout.setVerticalGroup(
  576. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  577. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
  578. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  579. .addComponent(jLabel1)
  580. .addContainerGap())
  581. .addGroup(jPanel1Layout.createSequentialGroup()
  582. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  583. .addComponent(jLabel3)
  584. .addGroup(jPanel1Layout.createSequentialGroup()
  585. .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE)
  586. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  587. .addComponent(jLabel17)
  588. .addGap(6, 6, 6)
  589. .addComponent(jLabel18)
  590. .addGap(6, 6, 6)
  591. .addComponent(jLabel19)))
  592. .addGap(0, 0, Short.MAX_VALUE))
  593. );
  594.  
  595. getContentPane().add(jPanel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 1360, 90));
  596.  
  597. jLayeredPane1.setBorder(javax.swing.BorderFactory.createTitledBorder("Pilih Laporan Pengembalian"));
  598.  
  599. pengembalian.setText("Pengembalian");
  600. pengembalian.addActionListener(new java.awt.event.ActionListener() {
  601. public void actionPerformed(java.awt.event.ActionEvent evt) {
  602. pengembalianActionPerformed(evt);
  603. }
  604. });
  605.  
  606. kurang.setText("<= 2");
  607. kurang.addActionListener(new java.awt.event.ActionListener() {
  608. public void actionPerformed(java.awt.event.ActionEvent evt) {
  609. kurangActionPerformed(evt);
  610. }
  611. });
  612.  
  613. lebih.setText("> 2");
  614. lebih.addActionListener(new java.awt.event.ActionListener() {
  615. public void actionPerformed(java.awt.event.ActionEvent evt) {
  616. lebihActionPerformed(evt);
  617. }
  618. });
  619.  
  620. jLayeredPane1.setLayer(pengembalian, javax.swing.JLayeredPane.DEFAULT_LAYER);
  621. jLayeredPane1.setLayer(kurang, javax.swing.JLayeredPane.DEFAULT_LAYER);
  622. jLayeredPane1.setLayer(lebih, javax.swing.JLayeredPane.DEFAULT_LAYER);
  623.  
  624. javax.swing.GroupLayout jLayeredPane1Layout = new javax.swing.GroupLayout(jLayeredPane1);
  625. jLayeredPane1.setLayout(jLayeredPane1Layout);
  626. jLayeredPane1Layout.setHorizontalGroup(
  627. jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  628. .addGroup(jLayeredPane1Layout.createSequentialGroup()
  629. .addContainerGap()
  630. .addComponent(pengembalian)
  631. .addGap(18, 18, 18)
  632. .addComponent(kurang)
  633. .addGap(10, 10, 10)
  634. .addComponent(lebih)
  635. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  636. );
  637. jLayeredPane1Layout.setVerticalGroup(
  638. jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  639. .addGroup(jLayeredPane1Layout.createSequentialGroup()
  640. .addContainerGap()
  641. .addGroup(jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  642. .addComponent(kurang)
  643. .addComponent(pengembalian)
  644. .addComponent(lebih))
  645. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  646. );
  647.  
  648. getContentPane().add(jLayeredPane1, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 150, 1360, 60));
  649.  
  650. pinjem.setModel(new javax.swing.table.DefaultTableModel(
  651. new Object [][] {
  652. {null, null, null, null},
  653. {null, null, null, null},
  654. {null, null, null, null},
  655. {null, null, null, null}
  656. },
  657. new String [] {
  658. "Title 1", "Title 2", "Title 3", "Title 4"
  659. }
  660. ));
  661. jScrollPane2.setViewportView(pinjem);
  662.  
  663. getContentPane().add(jScrollPane2, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 240, 1360, 210));
  664.  
  665. jButton1.setText("Grafik");
  666. jButton1.addActionListener(new java.awt.event.ActionListener() {
  667. public void actionPerformed(java.awt.event.ActionEvent evt) {
  668. jButton1ActionPerformed(evt);
  669. }
  670. });
  671. getContentPane().add(jButton1, new org.netbeans.lib.awtextra.AbsoluteConstraints(1210, 210, -1, -1));
  672.  
  673. jButton2.setText("Cetak");
  674. jButton2.addActionListener(new java.awt.event.ActionListener() {
  675. public void actionPerformed(java.awt.event.ActionEvent evt) {
  676. jButton2ActionPerformed(evt);
  677. }
  678. });
  679. getContentPane().add(jButton2, new org.netbeans.lib.awtextra.AbsoluteConstraints(1140, 210, -1, -1));
  680.  
  681. jLayeredPane2.setBorder(javax.swing.BorderFactory.createTitledBorder("Pilih Laporan Peminjaman"));
  682.  
  683. peminjaman.setText("Peminjaman");
  684. peminjaman.addActionListener(new java.awt.event.ActionListener() {
  685. public void actionPerformed(java.awt.event.ActionEvent evt) {
  686. peminjamanActionPerformed(evt);
  687. }
  688. });
  689.  
  690. jLabel5.setText("Status : ");
  691.  
  692. status.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "None", "Sudah Kembali", "Belum Kembali" }));
  693. status.addActionListener(new java.awt.event.ActionListener() {
  694. public void actionPerformed(java.awt.event.ActionEvent evt) {
  695. statusActionPerformed(evt);
  696. }
  697. });
  698.  
  699. jLayeredPane2.setLayer(peminjaman, javax.swing.JLayeredPane.DEFAULT_LAYER);
  700. jLayeredPane2.setLayer(jLabel5, javax.swing.JLayeredPane.DEFAULT_LAYER);
  701. jLayeredPane2.setLayer(status, javax.swing.JLayeredPane.DEFAULT_LAYER);
  702.  
  703. javax.swing.GroupLayout jLayeredPane2Layout = new javax.swing.GroupLayout(jLayeredPane2);
  704. jLayeredPane2.setLayout(jLayeredPane2Layout);
  705. jLayeredPane2Layout.setHorizontalGroup(
  706. jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  707. .addGroup(jLayeredPane2Layout.createSequentialGroup()
  708. .addContainerGap()
  709. .addComponent(peminjaman)
  710. .addGap(18, 18, 18)
  711. .addComponent(jLabel5)
  712. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  713. .addComponent(status, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  714. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  715. );
  716. jLayeredPane2Layout.setVerticalGroup(
  717. jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  718. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jLayeredPane2Layout.createSequentialGroup()
  719. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  720. .addGroup(jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  721. .addComponent(peminjaman)
  722. .addComponent(jLabel5)
  723. .addComponent(status, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  724. .addGap(19, 19, 19))
  725. );
  726.  
  727. getContentPane().add(jLayeredPane2, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 90, 1360, 60));
  728. getContentPane().add(tgl1, new org.netbeans.lib.awtextra.AbsoluteConstraints(610, 210, 130, 20));
  729. getContentPane().add(tgl2, new org.netbeans.lib.awtextra.AbsoluteConstraints(750, 210, 130, 20));
  730.  
  731. jLabel4.setText("Tanggal :");
  732. getContentPane().add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(550, 210, -1, 20));
  733.  
  734. jLabel10.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  735. jLabel10.setText("Data Peminjaman Rekam Medis : ");
  736. getContentPane().add(jLabel10, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 210, 210, 30));
  737.  
  738. jLabel11.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  739. jLabel11.setText("Data Pengembalian Rekam Medis : ");
  740. getContentPane().add(jLabel11, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 450, 230, 40));
  741.  
  742. balik.setModel(new javax.swing.table.DefaultTableModel(
  743. new Object [][] {
  744. {null, null, null, null},
  745. {null, null, null, null},
  746. {null, null, null, null},
  747. {null, null, null, null}
  748. },
  749. new String [] {
  750. "Title 1", "Title 2", "Title 3", "Title 4"
  751. }
  752. ));
  753. jScrollPane1.setViewportView(balik);
  754.  
  755. getContentPane().add(jScrollPane1, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 490, 1360, 280));
  756.  
  757. jButton3.setText("Batal");
  758. jButton3.addActionListener(new java.awt.event.ActionListener() {
  759. public void actionPerformed(java.awt.event.ActionEvent evt) {
  760. jButton3ActionPerformed(evt);
  761. }
  762. });
  763. getContentPane().add(jButton3, new org.netbeans.lib.awtextra.AbsoluteConstraints(1280, 210, -1, -1));
  764.  
  765. jButton4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/peminjaman/drm/icon/refresh.png"))); // NOI18N
  766. jButton4.addActionListener(new java.awt.event.ActionListener() {
  767. public void actionPerformed(java.awt.event.ActionEvent evt) {
  768. jButton4ActionPerformed(evt);
  769. }
  770. });
  771. getContentPane().add(jButton4, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 210, 20, 20));
  772.  
  773. jButton5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/peminjaman/drm/icon/refresh.png"))); // NOI18N
  774. jButton5.addActionListener(new java.awt.event.ActionListener() {
  775. public void actionPerformed(java.awt.event.ActionEvent evt) {
  776. jButton5ActionPerformed(evt);
  777. }
  778. });
  779. getContentPane().add(jButton5, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 460, 20, 20));
  780.  
  781. jButton6.setText("Cari");
  782. jButton6.addActionListener(new java.awt.event.ActionListener() {
  783. public void actionPerformed(java.awt.event.ActionEvent evt) {
  784. jButton6ActionPerformed(evt);
  785. }
  786. });
  787. getContentPane().add(jButton6, new org.netbeans.lib.awtextra.AbsoluteConstraints(890, 210, -1, -1));
  788.  
  789. pack();
  790. }// </editor-fold>
  791.  
  792. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  793. if (peminjaman.isSelected()){
  794. cetakpinjamperiode();
  795. }else if
  796. (pengembalian.isSelected()){
  797. cetakkembaliperiode();
  798. }else if
  799. (kurang.isSelected()){
  800. cetaklamakembali();
  801. }else if
  802. (lebih.isSelected()){
  803. cetaklamakembali2();
  804. }else {
  805. }
  806. String kode_tiket = (String) status.getSelectedItem();
  807. if (kode_tiket == "Sudah Kembali") {
  808. cetakpeminjamanstatusperiode();
  809. } else if (kode_tiket == "Belum Kembali") {
  810. cetakpeminjamanstatusperiode();
  811. }else {
  812.  
  813. }
  814.  
  815. }
  816.  
  817. private void statusActionPerformed(java.awt.event.ActionEvent evt) {
  818. String cari1 = (String) status.getSelectedItem();
  819. if (cari1=="Sudah Kembali"){
  820. List<entitidetailpinjam> result=koneksi.getpeminjamandao().getstatus();
  821. model.setData(result);
  822. }else if(cari1=="Belum Kembali"){
  823. List<entitidetailpinjam> result=koneksi.getpeminjamandao().getbelum();
  824. model.setData(result);
  825. } // TODO add your handling code here:
  826. }
  827.  
  828. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  829. if (peminjaman.isSelected()){
  830. cetakgrafikpinjam();
  831. }else if
  832. (pengembalian.isSelected()){
  833. cetakgrafikkembali();
  834. }else if
  835. (kurang.isSelected()){
  836. cetakgrafikdalam();
  837. }else if
  838. (lebih.isSelected()){
  839. cetakgrafiklebih();
  840. }else {
  841. }
  842.  
  843. String kode_tiket = (String) status.getSelectedItem();
  844. if (kode_tiket == "Sudah Kembali") {
  845. cetakgrafikstatus();
  846. } else if (kode_tiket == "Belum Kembali") {
  847. cetakgrafikstatus();
  848. }else {
  849.  
  850. } // TODO add your handling code here:
  851. }
  852.  
  853. private void pengembalianActionPerformed(java.awt.event.ActionEvent evt) {
  854. // TODO add your handling code here:
  855. }
  856.  
  857. private void kurangActionPerformed(java.awt.event.ActionEvent evt) {
  858.  
  859. if (kurang.isSelected()){
  860. List<entitipengembalian> result=koneksi.getpengembaliandao().carinip();
  861. model1.setData(result);
  862. }else if(lebih.isSelected()){
  863. List<entitipengembalian> result=koneksi.getpengembaliandao().carinama();
  864. model1.setData(result);
  865. } // TODO add your handling code here: // TODO add your handling code here: // TODO add your handling code here:
  866. // TODO add your handling code here:
  867. }
  868.  
  869. private void peminjamanActionPerformed(java.awt.event.ActionEvent evt) {
  870. // TODO add your handling code here:
  871. }
  872.  
  873. private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
  874. clear(); // TODO add your handling code here:
  875. }
  876.  
  877. private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
  878. loadData(); // TODO add your handling code here:
  879. }
  880.  
  881. private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
  882. loadData1(); // TODO add your handling code here:
  883. }
  884.  
  885. private void lebihActionPerformed(java.awt.event.ActionEvent evt) {
  886. if (kurang.isSelected()){
  887. List<entitipengembalian> result=koneksi.getpengembaliandao().carinip();
  888. model1.setData(result);
  889. }else if(lebih.isSelected()){
  890. List<entitipengembalian> result=koneksi.getpengembaliandao().carinama();
  891. model1.setData(result);
  892. } // TODO add your handling code here: // TODO add your handling code here: // TODO add your handling code here:
  893. // TODO add your handling code here: // TODO add your handling code here:
  894. }
  895.  
  896. private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
  897. if (peminjaman.isSelected()){
  898. String tampilan1 = "yyyy-MM-dd";
  899. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  900. SimpleDateFormat fm2 = new SimpleDateFormat(tampilan1);
  901. String tanggal1 = String.valueOf(fm1.format(tgl1.getDate()));
  902. String tanggal2 = String.valueOf(fm2.format(tgl2.getDate()));
  903.  
  904. List<entitidetailpinjam> result=koneksi.getpeminjamandao().gettgl(tanggal1,tanggal2 );
  905. model.setData(result);
  906. }else if(pengembalian.isSelected()){
  907. String tampilan1 = "yyyy-MM-dd";
  908. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  909. SimpleDateFormat fm2 = new SimpleDateFormat(tampilan1);
  910. String tanggal1 = String.valueOf(fm1.format(tgl1.getDate()));
  911. String tanggal2 = String.valueOf(fm2.format(tgl2.getDate()));
  912.  
  913. List<entitipengembalian> result=koneksi.getpengembaliandao().gettgl(tanggal1,tanggal2 );
  914. model1.setData(result);
  915. }else if
  916. (kurang.isSelected()){
  917. String tampilan1 = "yyyy-MM-dd";
  918. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  919. SimpleDateFormat fm2 = new SimpleDateFormat(tampilan1);
  920. String tanggal1 = String.valueOf(fm1.format(tgl1.getDate()));
  921. String tanggal2 = String.valueOf(fm2.format(tgl2.getDate()));
  922.  
  923. List<entitipengembalian> result=koneksi.getpengembaliandao().getkurang(tanggal1,tanggal2 );
  924. model1.setData(result);
  925. }else if
  926. (lebih.isSelected()){
  927. String tampilan1 = "yyyy-MM-dd";
  928. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  929. SimpleDateFormat fm2 = new SimpleDateFormat(tampilan1);
  930. String tanggal1 = String.valueOf(fm1.format(tgl1.getDate()));
  931. String tanggal2 = String.valueOf(fm2.format(tgl2.getDate()));
  932.  
  933. List<entitipengembalian> result=koneksi.getpengembaliandao().getlebih(tanggal1,tanggal2 );
  934. model1.setData(result);
  935. }else {
  936. String kode_tiket = (String) status.getSelectedItem();
  937. if (kode_tiket == "Sudah Kembali") {
  938. String tampilan1 = "yyyy-MM-dd";
  939. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  940. SimpleDateFormat fm2 = new SimpleDateFormat(tampilan1);
  941. String tanggal1 = String.valueOf(fm1.format(tgl1.getDate()));
  942. String tanggal2 = String.valueOf(fm2.format(tgl2.getDate()));
  943.  
  944. List<entitidetailpinjam> result=koneksi.getpeminjamandao().getstatusperiode(tanggal1,tanggal2 );
  945. model.setData(result);
  946. } else if (kode_tiket == "Belum Kembali") {
  947. String tampilan1 = "yyyy-MM-dd";
  948. SimpleDateFormat fm1 = new SimpleDateFormat(tampilan1);
  949. SimpleDateFormat fm2 = new SimpleDateFormat(tampilan1);
  950. String tanggal1 = String.valueOf(fm1.format(tgl1.getDate()));
  951. String tanggal2 = String.valueOf(fm2.format(tgl2.getDate()));
  952.  
  953. List<entitidetailpinjam> result=koneksi.getpeminjamandao().getstatusperiodebelum(tanggal1,tanggal2 );
  954. model.setData(result);
  955. }else {
  956. }
  957. }
  958. // TODO add your handling code here:
  959. }
  960.  
  961.  
  962. // Variables declaration - do not modify
  963. private javax.swing.JTable balik;
  964. private javax.swing.ButtonGroup buttonGroup2;
  965. private javax.swing.ButtonGroup buttonGroup4;
  966. private javax.swing.JButton jButton1;
  967. private javax.swing.JButton jButton2;
  968. private javax.swing.JButton jButton3;
  969. private javax.swing.JButton jButton4;
  970. private javax.swing.JButton jButton5;
  971. private javax.swing.JButton jButton6;
  972. private javax.swing.JLabel jLabel1;
  973. private javax.swing.JLabel jLabel10;
  974. private javax.swing.JLabel jLabel11;
  975. private javax.swing.JLabel jLabel17;
  976. private javax.swing.JLabel jLabel18;
  977. private javax.swing.JLabel jLabel19;
  978. private javax.swing.JLabel jLabel2;
  979. private javax.swing.JLabel jLabel3;
  980. private javax.swing.JLabel jLabel4;
  981. private javax.swing.JLabel jLabel5;
  982. private javax.swing.JLayeredPane jLayeredPane1;
  983. private javax.swing.JLayeredPane jLayeredPane2;
  984. private javax.swing.JPanel jPanel1;
  985. private javax.swing.JScrollPane jScrollPane1;
  986. private javax.swing.JScrollPane jScrollPane2;
  987. private javax.swing.JRadioButton kurang;
  988. private javax.swing.JRadioButton lebih;
  989. private javax.swing.JRadioButton peminjaman;
  990. private javax.swing.JRadioButton pengembalian;
  991. private javax.swing.JTable pinjem;
  992. private javax.swing.JComboBox<String> status;
  993. private com.toedter.calendar.JDateChooser tgl1;
  994. private com.toedter.calendar.JDateChooser tgl2;
  995. // End of variables declaration
  996. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!