doc/add.sql
@@ -56,3 +56,10 @@ update_user varchar(255) not null comment '更新人', tenant_id bigint not null comment '租户id' ); alter table purchase_ledger add payment_method varchar(255) null; alter table sales_ledger add payment_method varchar(255) null;
@@ -12,6 +12,7 @@ import org.apache.commons.lang3.ArrayUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; import java.util.ArrayList; @@ -66,6 +67,17 @@ deviceLedgerService.export(response, ids); } @PostMapping("import") @ApiModelProperty("导入设备台账") public AjaxResult importData(MultipartFile file) { Boolean b = deviceLedgerService.importData(file); if (b) { return AjaxResult.success("导入成功"); } return AjaxResult.error("导入失败"); } @GetMapping("getDeviceLedger") @ApiModelProperty("获取设备台账") public AjaxResult getDeviceLedger( ) { src/main/java/com/ruoyi/device/service/IDeviceLedgerService.java
@@ -6,6 +6,7 @@ import com.ruoyi.device.dto.DeviceLedgerDto; import com.ruoyi.device.pojo.DeviceLedger; import com.ruoyi.framework.web.domain.AjaxResult; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; import java.util.ArrayList; @@ -18,4 +19,6 @@ AjaxResult updateDeviceLedger(DeviceLedger deviceLedger); void export(HttpServletResponse response, Long[] ids); Boolean importData(MultipartFile file); } src/main/java/com/ruoyi/device/service/impl/DeviceLedgerServiceImpl.java
@@ -16,6 +16,7 @@ import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; import java.util.ArrayList; @@ -88,4 +89,9 @@ } } @Override public Boolean importData(MultipartFile file) { return null; } } src/main/java/com/ruoyi/purchase/dto/ProductRecordDto.java
@@ -1,7 +1,10 @@ package com.ruoyi.purchase.dto; import com.ruoyi.purchase.pojo.ProductRecord; import com.ruoyi.sales.pojo.CommonFile; import lombok.Data; import java.util.List; @Data public class ProductRecordDto extends ProductRecord { @@ -25,4 +28,6 @@ private String invoiceNumber; private String unTicketsPrice; private List<CommonFile> commonFiles; } src/main/java/com/ruoyi/purchase/dto/PurchaseLedgerDto.java
@@ -153,4 +153,8 @@ @TableField(exist = false) private Integer type; @ApiModelProperty(value = "付款方式") private String paymentMethod; } src/main/java/com/ruoyi/purchase/pojo/PurchaseLedger.java
@@ -142,4 +142,8 @@ @ApiModelProperty(value = "付款方式") private String paymentMethod; } src/main/java/com/ruoyi/purchase/service/impl/ProductRecordServiceImpl.java
@@ -4,12 +4,17 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ruoyi.common.enums.FileNameType; import com.ruoyi.purchase.dto.ProductRecordDto; import com.ruoyi.purchase.dto.TicketRegistrationDto; import com.ruoyi.purchase.mapper.ProductRecordMapper; import com.ruoyi.purchase.pojo.ProductRecord; import com.ruoyi.purchase.service.IProductRecordService; import com.ruoyi.sales.mapper.CommonFileMapper; import com.ruoyi.sales.pojo.CommonFile; import io.swagger.annotations.ApiModelProperty; import lombok.AllArgsConstructor; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @@ -24,7 +29,13 @@ @AllArgsConstructor public class ProductRecordServiceImpl extends ServiceImpl<ProductRecordMapper, ProductRecord> implements IProductRecordService { @Autowired private ProductRecordMapper productRecordMapper; @Autowired private CommonFileMapper commonFileMapper; /** @@ -41,8 +52,11 @@ @Override public IPage<ProductRecordDto> productRecordPage(Page page, TicketRegistrationDto ticketRegistrationDto) { return productRecordMapper.productRecordPage(page, ticketRegistrationDto); IPage<ProductRecordDto> productRecordDtoIPage = productRecordMapper.productRecordPage(page, ticketRegistrationDto); productRecordDtoIPage.getRecords().forEach(productRecordDto -> { productRecordDto.setCommonFiles(commonFileMapper.selectList(new LambdaQueryWrapper<CommonFile>().eq(CommonFile::getCommonId, productRecordDto.getTicketRegistrationId()) .eq(CommonFile::getType, FileNameType.PURCHASELEDGER.getValue()))); }); return productRecordDtoIPage; } } src/main/java/com/ruoyi/purchase/service/impl/PurchaseLedgerServiceImpl.java
@@ -372,6 +372,7 @@ } // 创建并填充DTO PurchaseLedgerDto resultDto = new PurchaseLedgerDto(); resultDto.setSalesLedgerId(purchaseLedger.getSalesLedgerId()); resultDto.setSalesContractNoId(purchaseLedger.getSalesLedgerId()); resultDto.setSalesContractNo(purchaseLedger.getSalesContractNo()); resultDto.setSupplierName(purchaseLedger.getSupplierName()); @@ -414,6 +415,7 @@ public PurchaseLedgerDto getPurchaseNoById(Long id) { PurchaseLedgerDto purchaseLedgerDto = new PurchaseLedgerDto(); PurchaseLedger purchaseLedger = purchaseLedgerMapper.selectById(id); BeanUtils.copyProperties(purchaseLedger, purchaseLedgerDto); // TicketRegistration ticketRegistration = ticketRegistrationMapper.selectOne(new LambdaQueryWrapper<TicketRegistration>().eq(TicketRegistration::getPurchaseLedgerId, id)); // if (ticketRegistration != null) { src/main/java/com/ruoyi/sales/dto/SalesLedgerDto.java
@@ -34,4 +34,7 @@ private LocalDate executionDate; private Boolean status; @ApiModelProperty(value = "付款方式") private String paymentMethod; } src/main/java/com/ruoyi/sales/pojo/SalesLedger.java
@@ -110,5 +110,8 @@ @TableField(exist = false) @ApiModelProperty(value = "已开票金额(元)") private BigDecimal invoiceTotal; @ApiModelProperty(value = "付款方式") private String paymentMethod; }
@@ -7,7 +7,6 @@ <select id="productRecordPage" resultType="com.ruoyi.purchase.dto.ProductRecordDto"> SELECT distinct sl.sales_contract_no, sl.customer_contract_no, sl.customer_name, @@ -18,11 +17,10 @@ tr.invoice_number, ROUND(pr.tickets_amount/(1+pr.tax_rate/100),2 ) as un_tickets_price, ROUND(pr.tickets_amount-pr.tickets_amount/(1+pr.tax_rate/100),2 )as invoice_amount FROM product_record pr left join purchase_ledger pl on pl.id = pr.purchase_ledger_id left join sales_ledger sl on sl.id = pl.sales_ledger_id left join ticket_registration tr on tr.purchase_ledger_id = pl.id left join ticket_registration tr on tr.id = pr.ticket_registration_id left join product_model pm on pm.id = pr.product_model_id WHERE type = 2 <if test="c.salesContractNo != null and c.salesContractNo != ''">
