供应商功能开发

chenrui

2025-05-08 e068f7ec339ea610c28bcf17d34739f391e72498

供应商功能开发

 src/main/java/com/ruoyi/basic/controller/SupplierManageController.java

@@ -8,6 +8,8 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;

@RestController
@RequestMapping("/system/supplier")
public class SupplierManageController {
@@ -67,4 +69,14 @@
    public AjaxResult supplierListPage(Page page, SupplierManageDto supplierManageDto) {
        return AjaxResult.success(supplierService.supplierListPage(page, supplierManageDto));
    }

    /**
     * ä¾›åº”商导出
     * @param response
     * @param supplierManageDto
     */
    @GetMapping("/export")
    public void supplierExport(HttpServletResponse response, SupplierManageDto supplierManageDto) {
        supplierService.supplierExport(response, supplierManageDto);
    }
}

 src/main/java/com/ruoyi/basic/dto/SupplierManageDto.java

@@ -1,8 +1,12 @@
package com.ruoyi.basic.dto;

import com.ruoyi.basic.pojo.SupplierManage;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
public class SupplierManageDto extends SupplierManage {

    @ApiModelProperty(value = "维护人员名称")
    private String maintainUserName;
}

 src/main/java/com/ruoyi/basic/excel/SupplierManageExcelDto.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,44 @@
package com.ruoyi.basic.excel;

import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.ruoyi.framework.aspectj.lang.annotation.Excel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.time.LocalDateTime;

@Data
public class SupplierManageExcelDto {

    @Excel(name = "供应商名称")
    private String supplierName;

    @Excel(name = "纳税人识别号")
    private String taxpayerIdentificationNum;

    @Excel(name = "公司地址")
    private String companyAddress;

    @Excel(name = "公司电话")
    private String companyPhone;

    @Excel(name = "开户行")
    private String bankAccountName;

    @Excel(name = "账号")
    private String bankAccountNum;

    @Excel(name = "联系人")
    private String contactUserName;

    @Excel(name = "联系电话")
    private String contactUserPhone;

    @Excel(name = "维护人ID")
    private Integer maintainUserId;

    @Excel(name = "维护时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime maintainTime;
}

 src/main/java/com/ruoyi/basic/mapper/SupplierManageMapper.java

@@ -4,12 +4,17 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.basic.dto.SupplierManageDto;
import com.ruoyi.basic.excel.SupplierManageExcelDto;
import com.ruoyi.basic.pojo.SupplierManage;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface SupplierManageMapper extends BaseMapper<SupplierManage> {

    IPage<SupplierManage> supplierListPage(Page page, @Param("supplierManageDto") SupplierManageDto supplierManageDto);

    List<SupplierManageExcelDto> supplierExportList(@Param("supplierManageDto") SupplierManageDto supplierManageDto);
}

 src/main/java/com/ruoyi/basic/pojo/SupplierManage.java

@@ -1,6 +1,7 @@
package com.ruoyi.basic.pojo;

import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@@ -41,6 +42,7 @@
    private Integer maintainUserId;

    @ApiModelProperty(value = "维护时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime maintainTime;

    @ApiModelProperty(value = "创建时间")

 src/main/java/com/ruoyi/basic/service/ISupplierService.java

@@ -5,6 +5,8 @@
import com.ruoyi.basic.dto.SupplierManageDto;
import com.ruoyi.basic.pojo.SupplierManage;

import javax.servlet.http.HttpServletResponse;

public interface ISupplierService {

    /**
@@ -42,4 +44,11 @@
     * @return
     */
    IPage<SupplierManage> supplierListPage(Page page, SupplierManageDto supplierManageDto);

    /**
     * ä¾›åº”商导出
     * @param response
     * @param supplierManageDto
     */
    void supplierExport(HttpServletResponse response, SupplierManageDto supplierManageDto);
}

 src/main/java/com/ruoyi/basic/service/impl/SupplierServiceImpl.java

@@ -4,11 +4,17 @@
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.basic.dto.SupplierManageDto;
import com.ruoyi.basic.excel.SupplierManageExcelDto;
import com.ruoyi.basic.mapper.SupplierManageMapper;
import com.ruoyi.basic.pojo.Customer;
import com.ruoyi.basic.pojo.SupplierManage;
import com.ruoyi.basic.service.ISupplierService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.servlet.http.HttpServletResponse;
import java.util.List;

@Service
public class SupplierServiceImpl extends ServiceImpl<SupplierManageMapper,SupplierManage> implements ISupplierService {
@@ -66,4 +72,16 @@
    public IPage<SupplierManage> supplierListPage(Page page, SupplierManageDto supplierManageDto) {
        return supplierMapper.supplierListPage(page,supplierManageDto);
    }

    /**
     * ä¾›åº”商导出
     * @param response
     * @param supplierManageDto
     */
    @Override
    public void supplierExport(HttpServletResponse response, SupplierManageDto supplierManageDto) {
        List<SupplierManageExcelDto> supplierManageList = supplierMapper.supplierExportList(supplierManageDto);
        ExcelUtil<SupplierManageExcelDto> util = new ExcelUtil<SupplierManageExcelDto>(SupplierManageExcelDto.class);
        util.exportExcel(response, supplierManageList, "供应商导出");
    }
}

 src/main/java/com/ruoyi/project/system/controller/SysUserController.java

@@ -253,4 +253,15 @@
    {

        return success(deptService.selectDeptTreeList(dept));

    }



    /**

     * ä¸åˆ†é¡µç”¨æˆ·æŸ¥è¯¢

     * @param user

     * @return

     */

    @GetMapping("/userListNoPage")

    public AjaxResult userListNoPage(SysUser user){

        List<SysUser> sysUserList = userService.userListNoPage(user);

        return AjaxResult.success(sysUserList);

    }

}


 src/main/java/com/ruoyi/project/system/service/ISysUserService.java

@@ -203,4 +203,11 @@
     * @return ç»“æžœ

     */

    public String importUser(List<SysUser> userList, Boolean isUpdateSupport, String operName);



    /**

     * ä¸åˆ†é¡µç”¨æˆ·æŸ¥è¯¢

     * @param user

     * @return

     */

    List<SysUser> userListNoPage(SysUser user);

}


 src/main/java/com/ruoyi/project/system/service/impl/SysUserServiceImpl.java

@@ -1,6 +1,7 @@
package com.ruoyi.project.system.service.impl;



import java.util.ArrayList;

import java.util.Collections;

import java.util.List;

import java.util.stream.Collectors;

import javax.validation.Validator;

@@ -547,4 +548,14 @@
        }

        return successMsg.toString();

    }



    /**

     * ä¸åˆ†é¡µç”¨æˆ·æŸ¥è¯¢

     * @param user

     * @return

     */

    @Override

    public List<SysUser> userListNoPage(SysUser user) {

        return userMapper.selectUserList(user);

    }

}


 src/main/resources/mapper/basic/SupplierManageMapper.xml

@@ -21,12 +21,41 @@
        T1.create_user,
        T1.update_time,
        T1.update_user,
        T1.tenant_id
        T1.tenant_id,
        T2.user_name AS maintainUserName
        FROM supplier_manage T1
        LEFT JOIN sys_user T2 ON T1.maintain_user_id = T2.user_id
        <where>
            <if test="supplierManageDto.supplierName != null and supplierManageDto.supplierName != '' ">
                AND supplier_name = #{supplierManageDto.supplierName}
                AND T1.supplier_name LIKE CONCAT('%',#{supplierManageDto.supplierName},'%')
            </if>
        </where>
    </select>

    <select id="supplierExportList" resultType="com.ruoyi.basic.excel.SupplierManageExcelDto">
        SELECT
        T1.id,
        T1.supplier_name,
        T1.taxpayer_identification_num,
        T1.company_address,
        T1.company_phone,
        T1.bank_account_name,
        T1.bank_account_num,
        T1.contact_user_name,
        T1.contact_user_phone,
        T1.maintain_user_id,
        T1.maintain_time,
        T1.create_time,
        T1.create_user,
        T1.update_time,
        T1.update_user,
        T1.tenant_id,
        T2.user_name AS maintainUserName
        FROM supplier_manage T1
        LEFT JOIN sys_user T2 ON T1.maintain_user_id = T2.user_id
        <where>
            <if test="supplierManageDto.supplierName != null and supplierManageDto.supplierName != '' ">
                AND T1.supplier_name LIKE CONCAT('%',#{supplierManageDto.supplierName},'%')
            </if>
        </where>
    </select>