| | |
|---|
| | | public ResponseValue queryDepartmentTransferOrder(Long agencyId) { |
|---|
| | | |
|---|
| | | TransferInfoVO transferInfoVO = new TransferInfoVO(); |
|---|
| | | String sql = "SELECT ft.id,\n" |
|---|
| | | + " ft.BUSINESS_FORM_CODE,\n" |
|---|
| | | + " gr.GOODS_TEMPLATE_NAME,\n" |
|---|
| | | + " gr.BASE_GOODS_TEMPLATE_ID,\n" |
|---|
| | | + " ft.CREATE_TIME\n" |
|---|
| | | + "\n" |
|---|
| | | + "FROM l_wh_form_transfer ft\n" |
|---|
| | | + " LEFT JOIN L_WAREHOUSE_FLOW wf ON ft.id = wf.BUSINESS_FORM_ID\n" |
|---|
| | | + " left join L_WH_GOODS_RECORD gr on gr.WAREHOUSE_FLOW_ID = wf.id\n" |
|---|
| | | + " LEFT JOIN L_GOODS_WH_RECORD gwr on gwr.WAREHOUSE_FLOW_ID = wf.id\n" |
|---|
| | | + " left join L_WH_GOODS g on g.id = gwr.WH_GOODS_ID\n" |
|---|
| | | + "\n" |
|---|
| | | + "\n" |
|---|
| | | + "\n" |
|---|
| | | + "\n"; |
|---|
| | | |
|---|
| | | lWhFormTransferService.queryDepartmentTransferOrder(); |
|---|
| | | return ResponseValue.success(transferInfoVO); |
|---|
| | | } |
|---|
| | | } |
|---|
