API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 9th, 2017
96
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 52.94 KB | None | 0 0
raw download clone embed print report
  1. 03:44:40,167 [DEBUG,getOpenPayPointsWithDrawer,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE completed_at IS NULL AND period_type_id = 3 AND drawer_id IS NOT NULL
  2. 03:44:40,168 [DEBUG,getOpenPayPointsWithDrawer,JavaFX Application Thread]:142 - ==> Parameters:
  3. 03:44:40,169 [DEBUG,getOpenPayPointsWithDrawer,JavaFX Application Thread]:142 - <== Total: 0
  4. 03:44:40,170 [DEBUG,SettingService,JavaFX Application Thread]:60 - Read setting DAY_AUTOCLOSING_ENABLED=0
  5. 03:44:40,170 [DEBUG,SettingService,JavaFX Application Thread]:60 - Read setting VIRT_DRAWERS_QTY=1
  6. 03:44:40,177 [DEBUG,getOpenPayPointsWithDrawer,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE completed_at IS NULL AND period_type_id = 3 AND drawer_id IS NOT NULL
  7. 03:44:40,178 [DEBUG,getOpenPayPointsWithDrawer,JavaFX Application Thread]:142 - ==> Parameters:
  8. 03:44:40,179 [DEBUG,getOpenPayPointsWithDrawer,JavaFX Application Thread]:142 - <== Total: 0
  9. 03:44:40,188 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  10. 03:44:40,188 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  11. 03:44:40,188 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), 3(Integer)
  12. 03:44:40,189 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 0
  13. 03:44:40,190 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  14. 03:44:40,191 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:40.188(Timestamp), 4(Integer)
  15. 03:44:40,197 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  16. 03:44:40,197 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 1(Integer)
  17. 03:44:40,198 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  18. 03:44:40,199 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Parameters: 1(Integer)
  19. 03:44:40,200 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <====== Total: 20
  20. 03:44:40,201 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  21. 03:44:40,201 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  22. 03:44:40,202 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  23. 03:44:40,237 [DEBUG,getAllUsers,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM pos_users WHERE enabled = 1 AND is_fuel = 0 ORDER BY is_clockin DESC, username
  24. 03:44:40,238 [DEBUG,getAllUsers,JavaFX Application Thread]:142 - ==> Parameters:
  25. 03:44:40,248 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM role r WHERE r.id = ?
  26. 03:44:40,253 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 21(Integer)
  27. 03:44:40,257 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  28. 03:44:40,258 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  29. 03:44:40,258 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Parameters: 20(Integer)
  30. 03:44:40,260 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <==== Total: 15
  31. 03:44:40,261 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  32. 03:44:40,261 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Parameters: 1(Integer)
  33. 03:44:40,263 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <==== Total: 20
  34. 03:44:40,264 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM role r WHERE r.id = ?
  35. 03:44:40,265 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 22(Integer)
  36. 03:44:40,266 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  37. 03:44:40,266 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  38. 03:44:40,267 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Parameters: 21(Integer)
  39. 03:44:40,269 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <==== Total: 15
  40. 03:44:40,272 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM role r WHERE r.id = ?
  41. 03:44:40,273 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 24(Integer)
  42. 03:44:40,275 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  43. 03:44:40,276 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  44. 03:44:40,277 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Parameters: 19(Integer)
  45. 03:44:40,279 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <==== Total: 20
  46. 03:44:40,280 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  47. 03:44:40,280 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Parameters: 18(Integer)
  48. 03:44:40,282 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <==== Total: 20
  49. 03:44:40,283 [DEBUG,getAllUsers,JavaFX Application Thread]:142 - <== Total: 5
  50. 03:44:40,283 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  51. 03:44:40,283 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  52. 03:44:40,284 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), 3(Integer)
  53. 03:44:40,285 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 0
  54. 03:44:40,286 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  55. 03:44:40,286 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:40.283(Timestamp), 4(Integer)
  56. 03:44:40,288 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  57. 03:44:40,289 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 1(Integer)
  58. 03:44:40,290 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  59. 03:44:40,291 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  60. 03:44:40,291 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  61. 03:44:40,291 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  62. 03:44:40,292 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  63. 03:44:40,292 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 1(Integer), 3(Integer)
  64. 03:44:40,297 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 1
  65. 03:44:40,297 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  66. 03:44:40,298 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:40.297(Timestamp), 4(Integer)
  67. 03:44:40,300 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  68. 03:44:40,300 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  69. 03:44:40,300 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  70. 03:44:40,301 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  71. 03:44:40,301 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 21(Integer), 3(Integer)
  72. 03:44:40,303 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  73. 03:44:40,303 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 21(Integer)
  74. 03:44:40,305 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  75. 03:44:40,306 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 1
  76. 03:44:40,307 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  77. 03:44:40,308 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:40.307(Timestamp), 4(Integer)
  78. 03:44:40,314 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  79. 03:44:40,314 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  80. 03:44:40,315 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  81. 03:44:40,315 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  82. 03:44:40,315 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 19(Integer), 3(Integer)
  83. 03:44:40,317 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 0
  84. 03:44:40,317 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  85. 03:44:40,318 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:40.315(Timestamp), 4(Integer)
  86. 03:44:40,320 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  87. 03:44:40,320 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  88. 03:44:40,320 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  89. 03:44:40,321 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  90. 03:44:40,321 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 18(Integer), 3(Integer)
  91. 03:44:40,322 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 0
  92. 03:44:40,323 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  93. 03:44:40,324 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:40.32(Timestamp), 4(Integer)
  94. 03:44:40,326 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  95. 03:44:40,327 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  96. 03:44:40,365 [DEBUG,hasPermission,JavaFX Application Thread]:142 - ==> Preparing: SELECT permission_value FROM user_permission WHERE user_id = ? AND permission_name = ?
  97. 03:44:40,366 [DEBUG,hasPermission,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), pospro.user.is_cashier(String)
  98. 03:44:40,367 [DEBUG,hasPermission,JavaFX Application Thread]:142 - <== Total: 1
  99. 03:44:40,392 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  100. 03:44:40,393 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  101. 03:44:40,393 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), 3(Integer)
  102. 03:44:40,396 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 0
  103. 03:44:40,397 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  104. 03:44:40,398 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:40.393(Timestamp), 4(Integer)
  105. 03:44:40,400 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  106. 03:44:40,400 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 1(Integer)
  107. 03:44:40,402 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  108. 03:44:40,403 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Parameters: 1(Integer)
  109. 03:44:40,404 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <====== Total: 20
  110. 03:44:40,405 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  111. 03:44:40,405 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  112. 03:44:40,405 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  113. 03:44:43,395 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  114. 03:44:43,396 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - ==> Parameters: 3(Integer)
  115. 03:44:43,400 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  116. 03:44:43,400 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 1(Integer)
  117. 03:44:43,402 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  118. 03:44:43,403 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Parameters: 1(Integer)
  119. 03:44:43,405 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <====== Total: 20
  120. 03:44:43,406 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  121. 03:44:43,406 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - <== Total: 1
  122. 03:44:43,423 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM reports WHERE report_type = ? ORDER BY id DESC LIMIT 1
  123. 03:44:43,423 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - ==> Parameters: 3(Integer)
  124. 03:44:43,436 [DEBUG,getByReportId,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM report_details WHERE report_id = ?
  125. 03:44:43,436 [DEBUG,getByReportId,JavaFX Application Thread]:142 - ====> Parameters: 34(Integer)
  126. 03:44:43,449 [DEBUG,getByReportId,JavaFX Application Thread]:142 - <==== Total: 0
  127. 03:44:43,450 [DEBUG,getByReportId,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM report_pay_roll_details WHERE report_id = ?
  128. 03:44:43,451 [DEBUG,getByReportId,JavaFX Application Thread]:142 - ====> Parameters: 34(Integer)
  129. 03:44:43,457 [DEBUG,getByReportId,JavaFX Application Thread]:142 - <==== Total: 0
  130. 03:44:43,458 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - <== Total: 1
  131. 03:44:43,469 [DEBUG,getNrgt,JavaFX Application Thread]:142 - ==> Preparing: SELECT quantity FROM nrgt WHERE id = 1
  132. 03:44:43,469 [DEBUG,getNrgt,JavaFX Application Thread]:142 - ==> Parameters:
  133. 03:44:43,472 [DEBUG,getNrgt,JavaFX Application Thread]:142 - <== Total: 1
  134. 03:44:43,473 [DEBUG,getLast,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM cash_accounting ORDER BY id DESC LIMIT 1
  135. 03:44:43,474 [DEBUG,getLast,JavaFX Application Thread]:142 - ==> Parameters:
  136. 03:44:43,479 [DEBUG,getLast,JavaFX Application Thread]:142 - <== Total: 1
  137. 03:44:43,480 [DEBUG,create,JavaFX Application Thread]:142 - ==> Preparing: INSERT INTO cash_accounting (user_id, transaction_type, amount, total_amount, created_at, currency, register_id, drawer_id, vendor_id, paid, sent_to_cso) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  138. 03:44:43,482 [DEBUG,create,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), 5(Integer), 0(Integer), 0(Integer), 2017-03-09 03:44:43.48(Timestamp), USD(String), null, null, null, false(Boolean), false(Boolean)
  139. 03:44:43,487 [DEBUG,create,JavaFX Application Thread]:142 - <== Updates: 1
  140. 03:44:43,488 [DEBUG,SettingService,JavaFX Application Thread]:60 - Read setting SAFE_DROPS_AMOUNT=50000
  141. 03:44:43,488 [DEBUG,SettingService,JavaFX Application Thread]:60 - Read setting VIRT_DRAWERS_QTY=1
  142. 03:44:43,489 [DEBUG,getOpenPayPointsWithDrawer,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE completed_at IS NULL AND period_type_id = 3 AND drawer_id IS NOT NULL
  143. 03:44:43,489 [DEBUG,getOpenPayPointsWithDrawer,JavaFX Application Thread]:142 - ==> Parameters:
  144. 03:44:43,490 [DEBUG,getOpenPayPointsWithDrawer,JavaFX Application Thread]:142 - <== Total: 0
  145. 03:44:43,491 [DEBUG,create,JavaFX Application Thread]:142 - ==> Preparing: INSERT INTO report_periods (period_type_id, number, started_at, user_id, cashier_id, total_mops, total_sales, cashiers_count, opening_cash, closing_cash, total_cash, cash_over, sales_over, currency, open_nrgt, close_nrgt, total_taxes, total_refund, status, total_cash_mops, file_name, upload_status, scan_rate, total_voids, total_nosale, error_correct, transactions_count, drawer_id, total_cash_pay_in) VALUES (?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  146. 03:44:43,493 [DEBUG,create,JavaFX Application Thread]:142 - ==> Parameters: 3(Integer), 10(Integer), 2017-03-09 03:44:43.395(Timestamp), 20(Integer), 20(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), USD(String), 651(Long), 0(Long), 0(Integer), 0(Integer), 0(Integer), 0(Integer), null, 0(Short), null, 0(Integer), 0(Integer), 0(Integer), 0(Integer), 1(Integer), 0(Integer)
  147. 03:44:43,508 [DEBUG,create,JavaFX Application Thread]:142 - <== Updates: 1
  148. 03:44:43,510 [DEBUG,create,JavaFX Application Thread]:142 - ==> Preparing: INSERT INTO transaction_log SET transaction_event = ?, entity_id = ?, initiator = ?, initiator_right = ?, data_set = ?, sale_id = ?, user_id = ?, is_bookmark = ?, has_screen_shot = ?, created_at = now(), processed_for_clean = ?
  149. 03:44:43,511 [DEBUG,create,JavaFX Application Thread]:142 - ==> Parameters: PAY_POINT_OPEN(String), 51(Integer), 0(Integer), 0(Integer), (String), null, 20(Integer), false(Boolean), 0(Integer), false(Boolean)
  150. 03:44:43,518 [DEBUG,create,JavaFX Application Thread]:142 - <== Updates: 1
  151. 03:44:43,524 [DEBUG,DataReportManagementService,JavaFX Application Thread]:900 - Start creating DataReport
  152. 03:44:43,525 [DEBUG,getOpenReportsByType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE completed_at IS NULL AND period_type_id = ? ORDER BY number DESC
  153. 03:44:43,525 [DEBUG,getOpenReportsByType,JavaFX Application Thread]:142 - ==> Parameters: 3(Integer)
  154. 03:44:43,527 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  155. 03:44:43,528 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 20(Integer)
  156. 03:44:43,530 [DEBUG,getById,JavaFX Application Thread]:142 - ======> Preparing: SELECT * FROM role r WHERE r.id = ?
  157. 03:44:43,530 [DEBUG,getById,JavaFX Application Thread]:142 - ======> Parameters: 21(Integer)
  158. 03:44:43,534 [DEBUG,getById,JavaFX Application Thread]:142 - <====== Total: 1
  159. 03:44:43,535 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  160. 03:44:43,536 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Parameters: 20(Integer)
  161. 03:44:43,537 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <====== Total: 15
  162. 03:44:43,538 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  163. 03:44:43,539 [DEBUG,getOpenReportsByType,JavaFX Application Thread]:142 - <== Total: 1
  164. 03:44:43,540 [DEBUG,getLastByType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM reports WHERE report_type = ? AND started_at is null ORDER BY report_number DESC LIMIT 1
  165. 03:44:43,540 [DEBUG,getLastByType,JavaFX Application Thread]:142 - ==> Parameters: 4(Integer)
  166. 03:44:43,544 [DEBUG,getLastByType,JavaFX Application Thread]:142 - <== Total: 0
  167. 03:44:43,545 [DEBUG,DataReportManagementService,JavaFX Application Thread]:900 - Start creating DataReport
  168. 03:44:43,545 [DEBUG,getOpenReportsByType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE completed_at IS NULL AND period_type_id = ? ORDER BY number DESC
  169. 03:44:43,545 [DEBUG,getOpenReportsByType,JavaFX Application Thread]:142 - ==> Parameters: 4(Integer)
  170. 03:44:43,546 [DEBUG,getOpenReportsByType,JavaFX Application Thread]:142 - <== Total: 0
  171. 03:44:43,554 [ERROR,LoginReportController,JavaFX Application Thread]:260 - open submit error
  172. com.petrosoftinc.pos.core.services.exception.ServiceException: java.lang.NullPointerException
  173. at com.petrosoftinc.pos.core.services.enterprise.ReportPeriodManagementService.createNewReport(ReportPeriodManagementService.java:325)
  174. at com.petrosoftinc.pos.core.services.enterprise.ReportPeriodManagementService$$FastClassBySpringCGLIB$$2a126734.invoke(<generated>)
  175. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  176. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
  177. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  178. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  179. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
  180. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  181. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  182. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
  183. at com.petrosoftinc.pos.core.services.enterprise.ReportPeriodManagementService$$EnhancerBySpringCGLIB$$1e28465e.createNewReport(<generated>)
  184. at com.petrosoftinc.pos.gui.screens.login.controllers.LoginReportController.openSubmit(LoginReportController.java:257)
  185. at com.petrosoftinc.pos.gui.screens.login.controllers.LoginReportController.submit(LoginReportController.java:279)
  186. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  187. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  188. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  189. at java.lang.reflect.Method.invoke(Method.java:497)
  190. at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:71)
  191. at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
  192. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  193. at java.lang.reflect.Method.invoke(Method.java:497)
  194. at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:275)
  195. at javafx.fxml.FXMLLoader$MethodHandler.invoke(FXMLLoader.java:1771)
  196. at javafx.fxml.FXMLLoader$ControllerMethodEventHandler.handle(FXMLLoader.java:1657)
  197. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
  198. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  199. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  200. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  201. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  202. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  203. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  204. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  205. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  206. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  207. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  208. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  209. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  210. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
  211. at javafx.event.Event.fireEvent(Event.java:198)
  212. at javafx.scene.Scene$ClickGenerator.postProcess(Scene.java:3470)
  213. at javafx.scene.Scene$ClickGenerator.access$8100(Scene.java:3398)
  214. at javafx.scene.Scene$MouseHandler.process(Scene.java:3766)
  215. at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
  216. at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
  217. at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
  218. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:352)
  219. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:275)
  220. at java.security.AccessController.doPrivileged(Native Method)
  221. at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$355(GlassViewEventHandler.java:388)
  222. at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
  223. at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:387)
  224. at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
  225. at com.sun.glass.ui.View.notifyMouse(View.java:937)
  226. Caused by: java.lang.NullPointerException
  227. at com.petrosoftinc.pos.core.services.enterprise.DataReportManagementService.createNewByType(DataReportManagementService.java:903)
  228. at com.petrosoftinc.pos.core.services.enterprise.DataReportManagementService.createNewByType(DataReportManagementService.java:916)
  229. at com.petrosoftinc.pos.core.services.enterprise.DataReportManagementService$$FastClassBySpringCGLIB$$519586ab.invoke(<generated>)
  230. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  231. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:651)
  232. at com.petrosoftinc.pos.core.services.enterprise.DataReportManagementService$$EnhancerBySpringCGLIB$$89fac5f5.createNewByType(<generated>)
  233. at com.petrosoftinc.pos.core.services.enterprise.ReportPeriodManagementService.createNewReport(ReportPeriodManagementService.java:319)
  234. ... 52 more
  235. ERROR 2017-03-09 03:44:43,554 [JavaFX Application Thread][LoginReportController.java:260] : open submit error
  236. com.petrosoftinc.pos.core.services.exception.ServiceException: java.lang.NullPointerException
  237. at com.petrosoftinc.pos.core.services.enterprise.ReportPeriodManagementService.createNewReport(ReportPeriodManagementService.java:325)
  238. at com.petrosoftinc.pos.core.services.enterprise.ReportPeriodManagementService$$FastClassBySpringCGLIB$$2a126734.invoke(<generated>)
  239. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  240. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
  241. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  242. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  243. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
  244. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  245. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  246. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
  247. at com.petrosoftinc.pos.core.services.enterprise.ReportPeriodManagementService$$EnhancerBySpringCGLIB$$1e28465e.createNewReport(<generated>)
  248. at com.petrosoftinc.pos.gui.screens.login.controllers.LoginReportController.openSubmit(LoginReportController.java:257)
  249. at com.petrosoftinc.pos.gui.screens.login.controllers.LoginReportController.submit(LoginReportController.java:279)
  250. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  251. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  252. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  253. at java.lang.reflect.Method.invoke(Method.java:497)
  254. at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:71)
  255. at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
  256. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  257. at java.lang.reflect.Method.invoke(Method.java:497)
  258. at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:275)
  259. at javafx.fxml.FXMLLoader$MethodHandler.invoke(FXMLLoader.java:1771)
  260. at javafx.fxml.FXMLLoader$ControllerMethodEventHandler.handle(FXMLLoader.java:1657)
  261. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
  262. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  263. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  264. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  265. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  266. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  267. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  268. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  269. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  270. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  271. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  272. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  273. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  274. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
  275. at javafx.event.Event.fireEvent(Event.java:198)
  276. at javafx.scene.Scene$ClickGenerator.postProcess(Scene.java:3470)
  277. at javafx.scene.Scene$ClickGenerator.access$8100(Scene.java:3398)
  278. at javafx.scene.Scene$MouseHandler.process(Scene.java:3766)
  279. at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
  280. at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
  281. at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
  282. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:352)
  283. at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:275)
  284. at java.security.AccessController.doPrivileged(Native Method)
  285. at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$355(GlassViewEventHandler.java:388)
  286. at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
  287. at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:387)
  288. at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
  289. at com.sun.glass.ui.View.notifyMouse(View.java:937)
  290. Caused by: java.lang.NullPointerException
  291. at com.petrosoftinc.pos.core.services.enterprise.DataReportManagementService.createNewByType(DataReportManagementService.java:903)
  292. at com.petrosoftinc.pos.core.services.enterprise.DataReportManagementService.createNewByType(DataReportManagementService.java:916)
  293. at com.petrosoftinc.pos.core.services.enterprise.DataReportManagementService$$FastClassBySpringCGLIB$$519586ab.invoke(<generated>)
  294. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  295. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:651)
  296. at com.petrosoftinc.pos.core.services.enterprise.DataReportManagementService$$EnhancerBySpringCGLIB$$89fac5f5.createNewByType(<generated>)
  297. at com.petrosoftinc.pos.core.services.enterprise.ReportPeriodManagementService.createNewReport(ReportPeriodManagementService.java:319)
  298. ... 52 more
  299. 03:44:43,567 [DEBUG,getAllUsers,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM pos_users WHERE enabled = 1 AND is_fuel = 0 ORDER BY is_clockin DESC, username
  300. 03:44:43,568 [DEBUG,getAllUsers,JavaFX Application Thread]:142 - ==> Parameters:
  301. 03:44:43,575 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM role r WHERE r.id = ?
  302. 03:44:43,576 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 21(Integer)
  303. 03:44:43,577 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  304. 03:44:43,578 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  305. 03:44:43,578 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Parameters: 20(Integer)
  306. 03:44:43,579 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <==== Total: 15
  307. 03:44:43,580 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  308. 03:44:43,580 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Parameters: 1(Integer)
  309. 03:44:43,582 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <==== Total: 20
  310. 03:44:43,582 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM role r WHERE r.id = ?
  311. 03:44:43,583 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 22(Integer)
  312. 03:44:43,585 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  313. 03:44:43,585 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  314. 03:44:43,586 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Parameters: 21(Integer)
  315. 03:44:43,587 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <==== Total: 15
  316. 03:44:43,587 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM role r WHERE r.id = ?
  317. 03:44:43,588 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 24(Integer)
  318. 03:44:43,589 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  319. 03:44:43,589 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  320. 03:44:43,589 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Parameters: 19(Integer)
  321. 03:44:43,590 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <==== Total: 20
  322. 03:44:43,591 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  323. 03:44:43,591 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ====> Parameters: 18(Integer)
  324. 03:44:43,592 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <==== Total: 20
  325. 03:44:43,593 [DEBUG,getAllUsers,JavaFX Application Thread]:142 - <== Total: 5
  326. 03:44:43,593 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  327. 03:44:43,593 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  328. 03:44:43,594 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), 3(Integer)
  329. 03:44:43,595 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 0
  330. 03:44:43,595 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  331. 03:44:43,596 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:43.593(Timestamp), 4(Integer)
  332. 03:44:43,597 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  333. 03:44:43,597 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 1(Integer)
  334. 03:44:43,599 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  335. 03:44:43,599 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  336. 03:44:43,599 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  337. 03:44:43,600 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  338. 03:44:43,600 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  339. 03:44:43,600 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 1(Integer), 3(Integer)
  340. 03:44:43,602 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 1
  341. 03:44:43,603 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  342. 03:44:43,604 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:43.603(Timestamp), 4(Integer)
  343. 03:44:43,605 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  344. 03:44:43,606 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  345. 03:44:43,606 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  346. 03:44:43,607 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  347. 03:44:43,607 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 21(Integer), 3(Integer)
  348. 03:44:43,609 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  349. 03:44:43,609 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 21(Integer)
  350. 03:44:43,611 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  351. 03:44:43,612 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 1
  352. 03:44:43,612 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  353. 03:44:43,613 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:43.612(Timestamp), 4(Integer)
  354. 03:44:43,615 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  355. 03:44:43,616 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  356. 03:44:43,616 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  357. 03:44:43,616 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  358. 03:44:43,617 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 19(Integer), 3(Integer)
  359. 03:44:43,618 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 0
  360. 03:44:43,619 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  361. 03:44:43,619 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:43.616(Timestamp), 4(Integer)
  362. 03:44:43,621 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  363. 03:44:43,622 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  364. 03:44:43,622 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  365. 03:44:43,623 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  366. 03:44:43,623 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 18(Integer), 3(Integer)
  367. 03:44:43,624 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 0
  368. 03:44:43,624 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  369. 03:44:43,625 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:43.623(Timestamp), 4(Integer)
  370. 03:44:43,626 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  371. 03:44:43,627 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  372. 03:44:43,648 [DEBUG,hasPermission,JavaFX Application Thread]:142 - ==> Preparing: SELECT permission_value FROM user_permission WHERE user_id = ? AND permission_name = ?
  373. 03:44:43,649 [DEBUG,hasPermission,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), pospro.user.is_cashier(String)
  374. 03:44:43,654 [DEBUG,hasPermission,JavaFX Application Thread]:142 - <== Total: 1
  375. 03:44:43,666 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  376. 03:44:43,666 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  377. 03:44:43,667 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), 3(Integer)
  378. 03:44:43,668 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 0
  379. 03:44:43,668 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  380. 03:44:43,669 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:43.666(Timestamp), 4(Integer)
  381. 03:44:43,670 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  382. 03:44:43,671 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 1(Integer)
  383. 03:44:43,676 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  384. 03:44:43,677 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Parameters: 1(Integer)
  385. 03:44:43,682 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <====== Total: 20
  386. 03:44:43,683 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  387. 03:44:43,683 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  388. 03:44:43,683 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  389. 03:44:43,695 [DEBUG,getCheckedIn,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM pos_users WHERE is_checkin = 1 AND is_fuel = 0 LIMIT 1
  390. 03:44:43,695 [DEBUG,getCheckedIn,JavaFX Application Thread]:142 - ==> Parameters:
  391. 03:44:43,701 [DEBUG,getCheckedIn,JavaFX Application Thread]:142 - <== Total: 0
  392. 03:44:43,719 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:204 - Get paypoint status
  393. 03:44:43,720 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  394. 03:44:43,720 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), 3(Integer)
  395. 03:44:43,723 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 0
  396. 03:44:43,723 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  397. 03:44:43,724 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-09 03:44:43.719(Timestamp), 4(Integer)
  398. 03:44:43,726 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  399. 03:44:43,727 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 1(Integer)
  400. 03:44:43,728 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  401. 03:44:43,729 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Parameters: 1(Integer)
  402. 03:44:43,731 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <====== Total: 20
  403. 03:44:43,732 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  404. 03:44:43,732 [DEBUG,getLastShiftNumber,JavaFX Application Thread]:142 - <== Total: 1
  405. 03:44:43,733 [DEBUG,ReportPeriodManagementService,JavaFX Application Thread]:241 - Get paypoint status end
  406. 03:44:43,742 [DEBUG,update,JavaFX Application Thread]:142 - ==> Preparing: UPDATE pos_users SET username = ?, username_canonical = ?, first_name = ?, last_name = ?, pos_pin = ?, pin_length = ?, is_checkin = ?, is_clockin = ?, password = ?, salt = ?, enabled = ?, remote_id = ?, role_id = ?, come_back = ? WHERE id = ?
  407. 03:44:43,743 [DEBUG,update,JavaFX Application Thread]:142 - ==> Parameters: Chekanova Aleksandra(String), Chekanova Aleksandra(String), Chekanova(String), Aleksandra(String), 1111(String), 4(Integer), true(Boolean), true(Boolean), OTkFN/FxPviawJ9B5F6ovLqaRCmjKYrdfYLzLF5M9xMfIbOBHwEZabOvlRmWRqbZPTfbWM83ucDxxjHXxLly5g==(String), qqFKXdxQpWrUoFyualRr(String), true(Boolean), 72107(Integer), 21(Integer), 0(Integer), 20(Integer)
  408. 03:44:43,751 [DEBUG,update,JavaFX Application Thread]:142 - <== Updates: 1
  409. 03:44:43,752 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE cashier_id = ? AND started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  410. 03:44:43,753 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), 3(Integer)
  411. 03:44:43,756 [DEBUG,getLastReportByUserAndType,JavaFX Application Thread]:142 - <== Total: 0
  412. 03:44:43,757 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  413. 03:44:43,758 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - ==> Parameters: 4(Integer)
  414. 03:44:43,761 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  415. 03:44:43,762 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 1(Integer)
  416. 03:44:43,765 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  417. 03:44:43,766 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Parameters: 1(Integer)
  418. 03:44:43,769 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <====== Total: 20
  419. 03:44:43,770 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  420. 03:44:43,770 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - <== Total: 1
  421. 03:44:43,772 [DEBUG,ApplicationEventPublisherWrapper,JavaFX Application Thread]:31 - Event<com.petrosoftinc.pos.peripherals.devices.pinpad.entities.PinpadServiceRequestEvent[source=PinpadServiceData{eventType=SERVICE_REQUEST, serviceRequestType=LOGIN, responseCode='null'}]>, async<true> was sent by class<com.petrosoftinc.pos.core.services.enterprise.delegate.PinPadDataDelegateService> and method<sendPinPadData>
  422. 03:44:43,773 [DEBUG,create,JavaFX Application Thread]:142 - ==> Preparing: INSERT INTO transaction_log SET transaction_event = ?, entity_id = ?, initiator = ?, initiator_right = ?, data_set = ?, sale_id = ?, user_id = ?, is_bookmark = ?, has_screen_shot = ?, created_at = now(), processed_for_clean = ?
  423. 03:44:43,774 [DEBUG,create,JavaFX Application Thread]:142 - ==> Parameters: USER_CHECK_IN(String), 20(Integer), 0(Integer), 0(Integer), (String), null, 20(Integer), false(Boolean), 0(Integer), false(Boolean)
  424. 03:44:43,774 [INFO,PinpadServiceProxy,Thread-66]:63 - event service request -> PinpadServiceData{eventType=SERVICE_REQUEST, serviceRequestType=LOGIN, responseCode='null'}
  425. 03:44:43,776 [DEBUG,FusionEpsHardwareService,Thread-66]:436 - performServiceRequest start
  426. 03:44:43,776 [DEBUG,FusionEpsHardwareService,Thread-66]:437 - Incoming service request type: LOGIN
  427. 03:44:43,777 [DEBUG,create,JavaFX Application Thread]:142 - <== Updates: 1
  428. 03:44:43,778 [DEBUG,ApplicationEventPublisherWrapper,JavaFX Application Thread]:31 - Event<com.petrosoftinc.pos.core.entities.dto.UserCheckinEvent[source=com.petrosoftinc.pos.core.entities.domain.PosUser@4e548109]>, async<true> was sent by class<com.petrosoftinc.pos.core.services.enterprise.UserManagementService> and method<userCheckIn>
  429. 03:44:43,786 [INFO,AbstractMessageHandler,Thread-67]:31 - Broadcasting message: {"message_id":"a7d171bb-d72e-40c2-9634-3e0316c38023","command":"user_checkin","data":{"id":72107}}
  430. 03:44:43,791 [DEBUG,hasPermission,JavaFX Application Thread]:142 - ==> Preparing: SELECT permission_value FROM user_permission WHERE user_id = ? AND permission_name = ?
  431. 03:44:43,791 [DEBUG,hasPermission,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), pospro.user.is_reports_manager(String)
  432. 03:44:43,792 [DEBUG,hasPermission,JavaFX Application Thread]:142 - <== Total: 1
  433. 03:44:43,802 [DEBUG,hasPermission,JavaFX Application Thread]:142 - ==> Preparing: SELECT permission_value FROM user_permission WHERE user_id = ? AND permission_name = ?
  434. 03:44:43,802 [DEBUG,hasPermission,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), pospro.video_journal.access(String)
  435. 03:44:43,803 [DEBUG,hasPermission,JavaFX Application Thread]:142 - <== Total: 1
  436. 03:44:43,813 [DEBUG,hasPermission,JavaFX Application Thread]:142 - ==> Preparing: SELECT permission_value FROM user_permission WHERE user_id = ? AND permission_name = ?
  437. 03:44:43,813 [DEBUG,hasPermission,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), pospro.user.is_pricebook_manager(String)
  438. 03:44:43,815 [DEBUG,hasPermission,JavaFX Application Thread]:142 - <== Total: 1
  439. 03:44:43,816 [DEBUG,SettingService,JavaFX Application Thread]:60 - Read setting MODULE_LOTTERY=0
  440. 03:44:43,821 [DEBUG,hasPermission,JavaFX Application Thread]:142 - ==> Preparing: SELECT permission_value FROM user_permission WHERE user_id = ? AND permission_name = ?
  441. 03:44:43,821 [DEBUG,hasPermission,JavaFX Application Thread]:142 - ==> Parameters: 20(Integer), pospro.user.is_system_manager(String)
  442. 03:44:43,822 [DEBUG,hasPermission,JavaFX Application Thread]:142 - <== Total: 1
  443. 03:44:43,824 [DEBUG,SettingService,JavaFX Application Thread]:60 - Read setting INACTIVITY_TIMEOUT=THIRTY
  444. 03:44:43,825 [DEBUG,SceneController,JavaFX Application Thread]:792 - SET SCREEN: report
  445. 03:44:44,040 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  446. 03:44:44,040 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - ==> Parameters: 5(Integer)
  447. 03:44:44,043 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  448. 03:44:44,043 [DEBUG,getById,JavaFX Application Thread]:142 - ====> Parameters: 1(Integer)
  449. 03:44:44,047 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  450. 03:44:44,048 [DEBUG,getByUserId,JavaFX Application Thread]:142 - ======> Parameters: 1(Integer)
  451. 03:44:44,064 [DEBUG,getByUserId,JavaFX Application Thread]:142 - <====== Total: 20
  452. 03:44:44,064 [DEBUG,getById,JavaFX Application Thread]:142 - <==== Total: 1
  453. 03:44:44,065 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - <== Total: 1
  454. 03:44:44,065 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at IS NOT NULL AND period_type_id = ? ORDER BY number DESC LIMIT 1
  455. 03:44:44,065 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - ==> Parameters: 4(Integer)
  456. 03:44:44,067 [DEBUG,getLastReportByType,JavaFX Application Thread]:142 - <== Total: 1
  457. 03:44:44,068 [DEBUG,getReportsByTypeAndDateWithoutOutdoor,JavaFX Application Thread]:142 - ==> Preparing: SELECT rp.* FROM report_periods AS rp LEFT JOIN pos_users AS u ON u.id = rp.user_id WHERE rp.started_at >= ? AND rp.period_type_id = ? AND u.is_fuel = FALSE ORDER BY rp.status ASC, rp.started_at DESC
  458. 03:44:44,069 [DEBUG,getReportsByTypeAndDateWithoutOutdoor,JavaFX Application Thread]:142 - ==> Parameters: 2017-03-06 14:05:28.0(Timestamp), 3(Integer)
  459. 03:44:44,073 [DEBUG,getReportsByTypeAndDateWithoutOutdoor,JavaFX Application Thread]:142 - <== Total: 0
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!