| | |
| | | @ApiModelProperty("是否不合格处理自己新增") |
| | | @TableField(exist = false) |
| | | private Boolean method; |
| | | @TableField(exist = false) |
| | | private String uidNo; |
| | | } |
| | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.ruoyi.stock.pojo.StockInventory; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.time.LocalDate; |
| | | |
| | | @EqualsAndHashCode(callSuper = true) |
| | | @Data |
| | | public class StockInventoryDto extends StockInventory { |
| | | |
| | |
| | | import lombok.Data; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | import java.io.Serializable; |
| | | import java.math.BigDecimal; |
| | | import java.time.LocalDateTime; |
| | | |
| | | @Data |
| | | @TableName("stock_in_record") |
| | | @ApiModel("入库管理") |
| | | public class StockInRecord { |
| | | public class StockInRecord implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | /** |
| | |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ruoyi.common.enums.StockInQualifiedRecordTypeEnum; |
| | | import com.ruoyi.common.enums.StockOutQualifiedRecordTypeEnum; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.framework.web.domain.R; |
| | | import com.ruoyi.sales.mapper.SalesLedgerProductMapper; |
| | |
| | | pm.model, |
| | | si.remark, |
| | | pm.unit, |
| | | pm.uidNo, |
| | | pm.uid_no as uidNo, |
| | | p.product_name |
| | | from stock_inventory si |
| | | left join product_model pm on si.product_model_id = pm.id |
| | |
| | | select sir.*,si.qualitity as current_stock, |
| | | pm.model, |
| | | pm.unit, |
| | | pm.uidNo, |
| | | pm.uid_no as uidNo, |
| | | p.product_name, |
| | | su.nick_name as create_by |
| | | from |
| | |
| | | p.product_name as productName, |
| | | pm.model, |
| | | pm.unit, |
| | | pm.uidNo, |
| | | pm.uid_no as uidNo, |
| | | u.nick_name as createBy |
| | | FROM stock_out_record as sor |
| | | LEFT JOIN product_model as pm on sor.product_model_id = pm.id |