外购下单、检验任务、报告编织页面添加供应商、零件描述等字段
| | |
| | | @ApiModelProperty(value = "更新后的ifs批次号") |
| | | private String updateBatchNo; |
| | | |
| | | @ApiModelProperty("零件描述") |
| | | private String partDesc; |
| | | |
| | | @ApiModelProperty("供应商名称") |
| | | private String supplierName; |
| | | |
| | | } |
| | |
| | | @ApiModelProperty("样品名称") |
| | | private String sample; |
| | | |
| | | @ApiModelProperty("零件描述") |
| | | private String partDesc; |
| | | |
| | | @ApiModelProperty("样品型号") |
| | | private String sampleModel; |
| | | |
| | |
| | | io.ifs_inventory_id, |
| | | iiq.is_copper, |
| | | ip.son_laboratory, |
| | | iiq.update_batch_no |
| | | iiq.update_batch_no, |
| | | iiq.part_desc, |
| | | iiq.supplier_name |
| | | from ins_report ir |
| | | left join ins_order io on io.id = ir.ins_order_id |
| | | LEFT JOIN ifs_inventory_quantity iiq ON iiq.id = io.ifs_inventory_id |
| | |
| | | ira.temp_url_pdf, |
| | | iiq.is_copper, |
| | | iiq.is_split_order, |
| | | iiq.update_batch_no |
| | | iiq.update_batch_no, |
| | | iiq.part_desc |
| | | FROM |
| | | ins_order io |
| | | LEFT JOIN ins_sample isa ON isa.ins_order_id = io.id |