| | |
|---|
| | | + " ft.OUT_OPERATOR_NAME,\n" + " ft.OUTPUT_TIME\n" + "FROM l_wh_form_transfer ft\n" |
|---|
| | | + " LEFT JOIN l_wh_procure_model pm ON ft.ID = pm.BUSINESS_ID\n" |
|---|
| | | + " LEFT JOIN base_goods_models bgm ON bgm.id = pm.BASE_GOODS_MODELS_ID\n" |
|---|
| | | + " LEFT JOIN base_goods_template bgt ON bgt.id = bgm.GOODS_TEMPLATES_ID where 1=1 "); |
|---|
| | | + " LEFT JOIN base_goods_template bgt ON bgt.id = bgm.GOODS_TEMPLATES_ID where ft.BUSINESS_TYPE =0 "); |
|---|
| | | if (StringUtils.isNotEmpty(param.getBusinessFormCode())) { |
|---|
| | | sql.append("AND ft.BUSINESS_FORM_CODE = :businessFormCode "); |
|---|
| | | params.put("businessFormCode", param.getBusinessFormCode()); |
|---|
