| | |
| | | Payment savedPayment = service.add(payment); |
| | | createResponse(savedPayment); |
| | | } |
| | | redisUtil.remove(INVOICE_DATA); |
| | | |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | |
| | | @ResponseBody |
| | | public Object exportQuickBooks(){ |
| | | List<Map<String,Object>> orders = orderService.queryAllOrderDatas(); |
| | | redisUtil.setStrValue(INVOICE_DATA+"",orders.toString()); |
| | | redisUtil.setStrValue(INVOICE_DATA,orders.toString()); |
| | | try { |
| | | View view = InvoicesDataUploadUtil.connectToQuickBooks(); |
| | | log.info("view:{}",view); |
| | |
| | | tc.`name`, |
| | | too.s_email as mailAddr, |
| | | tp.car_price as amount, |
| | | too.paid as unitPrice |
| | | tp.price as unitPrice |
| | | FROM `t_order` AS too |
| | | JOIN t_user tu ON too.user_id = tu.id |
| | | JOIN t_company tc ON too.company_id = tc.id |