Guest User

Untitled

a guest
Feb 1st, 2019
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.67 KB | None | 0 0
  1. jasper = require('node-jasper')({
  2. path: '../lib/jasperreports-5.6.0',
  3. reports: {
  4. hw: {
  5. jasper: '../jasperFiles/NodeIreportTest.jasper'
  6. }
  7. },
  8. drivers: {
  9. mysql: {
  10. path: '../lib/com.mysql.jdbc_5.1.5.jar',
  11. class: 'com.mysql.jdbc.Driver', //odbc driver//sun.jdbc.odbc.JdbcOdbcDriver //mysqlDriver// com.mysql.jdbc.Driver
  12. type: 'mysql'
  13. }
  14. },
  15. conns: {
  16. dbserver1: {
  17. host: '192.168.1.164',
  18. port: 3306,
  19. dbname: 'dbname',
  20. user: 'user',
  21. pass: '1234',
  22. driver: 'mysql'
  23. }
  24. },
  25. defaultConn: 'dbserver1'
  26. });
  27.  
  28. class ReportModel {
  29. constructor(strJasperPath, objDataObject, intClientIP) {
  30. this.strJasperPath = strJasperPath;
  31. this.objDataObject = objDataObject;
  32. this.intClientIP = intClientIP;
  33. }
  34.  
  35. makeReport() {
  36.  
  37. return new Promise ((resolve, reject) => {
  38. jasper = require('node-jasper')({
  39. path: '../lib/jasperreports-5.6.0',
  40. reports: {
  41. hw: {
  42. //jasper: '../jasperFiles/NodeIreportTest.jasper'
  43. jasper: '../jasperFiles/' + this.strJasperPath + '.jasper' //path to report
  44. }
  45. },
  46. drivers: {
  47. mysql: {
  48. path: '../lib/com.mysql.jdbc_5.1.5.jar',
  49. class: 'com.mysql.jdbc.Driver', //odbc driver//sun.jdbc.odbc.JdbcOdbcDriver //mysqlDriver// com.mysql.jdbc.Driver
  50. type: 'mysql'
  51. }
  52. },
  53. conns: {
  54. dbserver1: {
  55. host: '192.168.1.164',
  56. port: 3306,
  57. dbname: 'dbname',
  58. user: 'user',
  59. pass: '1234',
  60. driver: 'mysql'
  61. }
  62. },
  63. defaultConn: 'dbserver1'
  64. });
  65.  
  66.  
  67.  
  68. var report = {
  69. report: 'hw',
  70. data: this.objDataObject
  71. }
  72. var pdf = jasper.pdf(report);
  73.  
  74.  
  75. var strReportName = this.strJasperPath + intClientIP + '.pdf'
  76. var filepath = "./reports/" + strReportName
  77.  
  78. var filename = {
  79. "filepath": serverConfig.reporthost + path.basename(filepath)
  80. };
  81.  
  82. //check if file is present or not
  83. fs.access(filepath, fs.constants.F_OK | fs.constants.W_OK, (err) => {
  84. if (err) {
  85. //file is not present
  86. fs.writeFile("./reports/" + strReportName, new Buffer(pdf, 'binary'), (err) => {
  87. if (err) {
  88. reject(err);
  89. }
  90. resolve(filename);
  91. });
  92. } else {
  93. //file is present then delete it and then create it
  94. fs.unlink(filepath, (err) => {
  95. if (err) {
  96. reject(err);
  97. } else {
  98.  
  99. fs.writeFile("./reports/" + strReportName, new Buffer(pdf, 'binary'), (err) => {
  100. if (err) {
  101. console.log('WriteFile', err)
  102. }
  103. resolve(filename);
  104. });
  105. }
  106.  
  107. });
  108.  
  109. }
  110. });
  111. });
  112.  
  113.  
  114. }
  115. }
Add Comment
Please, Sign In to add comment