Merge remote-tracking branch 'origin/cwxt_master' into cwxt_master
| New file |
| | |
| | | package com.ruoyi.cwgl.controller; |
| | | |
| | | import java.util.List; |
| | | import org.springframework.security.access.prepost.PreAuthorize; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.PutMapping; |
| | | import org.springframework.web.bind.annotation.DeleteMapping; |
| | | import org.springframework.web.bind.annotation.PathVariable; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | import com.ruoyi.common.utils.file.DownloadExportUtil; |
| | | import com.ruoyi.common.annotation.Log; |
| | | import com.ruoyi.common.core.controller.BaseController; |
| | | import com.ruoyi.common.core.domain.AjaxResult; |
| | | import com.ruoyi.common.enums.BusinessType; |
| | | import com.ruoyi.cwgl.domain.ReceivableFeeManagementLog; |
| | | import com.ruoyi.cwgl.service.IReceivableFeeManagementLogService; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.common.core.page.TableDataInfo; |
| | | |
| | | /** |
| | | * 应收费用管理操作日志Controller |
| | | * |
| | | * @author ruoyi |
| | | * @date 2025-12-22 |
| | | */ |
| | | @RestController |
| | | @RequestMapping("/cwgl/receivableFeeManagementLog") |
| | | public class ReceivableFeeManagementLogController extends BaseController |
| | | { |
| | | @Autowired |
| | | private IReceivableFeeManagementLogService receivableFeeManagementLogService; |
| | | |
| | | |
| | | |
| | | /** |
| | | * 查询应收费用管理操作日志列表 |
| | | */ |
| | | @PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagementLog:list')") |
| | | @GetMapping("/list") |
| | | public TableDataInfo list(ReceivableFeeManagementLog receivableFeeManagementLog) |
| | | { |
| | | startPage(); |
| | | List<ReceivableFeeManagementLog> list = receivableFeeManagementLogService.selectReceivableFeeManagementLogList(receivableFeeManagementLog); |
| | | return getDataTable(list); |
| | | } |
| | | |
| | | /** |
| | | * 导出应收费用管理操作日志列表 |
| | | * @param receivableFeeManagementLog 查询条件对象 |
| | | */ |
| | | @PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagementLog:export')") |
| | | @Log(title = "应收费用管理操作日志", businessType = BusinessType.EXPORT) |
| | | @GetMapping("/export") |
| | | public AjaxResult export(ReceivableFeeManagementLog receivableFeeManagementLog,String exportKey) |
| | | { |
| | | receivableFeeManagementLogService.export(receivableFeeManagementLog,exportKey); |
| | | return AjaxResult.success("导出请求成功,请稍后点击下载...!"); |
| | | } |
| | | |
| | | |
| | | |
| | | /** |
| | | * 获取应收费用管理操作日志详细信息 |
| | | */ |
| | | @PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagementLog:query')") |
| | | @GetMapping(value = "/{id}") |
| | | public AjaxResult getInfo(@PathVariable("id") Integer id) |
| | | { |
| | | return AjaxResult.success(receivableFeeManagementLogService.selectReceivableFeeManagementLogById(id)); |
| | | } |
| | | |
| | | /** |
| | | * 新增应收费用管理操作日志 |
| | | */ |
| | | @PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagementLog:add')") |
| | | @Log(title = "应收费用管理操作日志", businessType = BusinessType.INSERT) |
| | | @PostMapping |
| | | public AjaxResult add(@RequestBody ReceivableFeeManagementLog receivableFeeManagementLog) |
| | | { |
| | | return toAjax(receivableFeeManagementLogService.insertReceivableFeeManagementLog(receivableFeeManagementLog)); |
| | | } |
| | | |
| | | /** |
| | | * 修改应收费用管理操作日志 |
| | | */ |
| | | @PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagementLog:edit')") |
| | | @Log(title = "应收费用管理操作日志", businessType = BusinessType.UPDATE) |
| | | @PutMapping |
| | | public AjaxResult edit(@RequestBody ReceivableFeeManagementLog receivableFeeManagementLog) |
| | | { |
| | | return toAjax(receivableFeeManagementLogService.updateReceivableFeeManagementLog(receivableFeeManagementLog)); |
| | | } |
| | | |
| | | /** |
| | | * 删除应收费用管理操作日志 |
| | | */ |
| | | @PreAuthorize("@ss.hasPermi('cwgl:receivableFeeManagementLog:remove')") |
| | | @Log(title = "应收费用管理操作日志", businessType = BusinessType.DELETE) |
| | | @DeleteMapping("/{ids}") |
| | | public AjaxResult remove(@PathVariable Integer[] ids) |
| | | { |
| | | return toAjax(receivableFeeManagementLogService.deleteReceivableFeeManagementLogByIds(ids)); |
| | | } |
| | | } |
| | |
| | | * 账单类型:0=人民币账单,1=港币账单 |
| | | */ |
| | | private Integer billType; |
| | | |
| | | private String billName; |
| | | |
| | | private String customerName; |
| | | |
| | | private String isInternalSettlement; |
| | | |
| | | private String internalSettlementUnit; |
| | | |
| | | /** |
| | | * 应收费用统计数据 |
| | |
| | | billManagement.setExchangeRate(statisticsVo.getRate()); |
| | | billManagement.setStatus("0"); // 默认草稿状态 |
| | | billManagement.setCreateTime(DateUtils.getNowDate()); |
| | | |
| | | billManagement.setBillName(billCreateVo.getBillName()); |
| | | billManagement.setCustomerName(billCreateVo.getCustomerName()); |
| | | billManagement.setIsInternalSettlement(billCreateVo.getIsInternalSettlement()); |
| | | billManagement.setInternalSettlementUnit(billCreateVo.getInternalSettlementUnit()); |
| | | // 3. 根据账单类型设置币种和总金额 |
| | | if (billType == 0) { |
| | | // 人民币账单 |
| | |
| | | String billSystemNo = billManagement.getSystemNo(); |
| | | |
| | | // 批量更新应收费用主表的关联账单编号 |
| | | List<ReceivableFeeManagement> feeManagements = new ArrayList<>(); |
| | | for (Integer feeId : statisticsVo.getIds()) { |
| | | ReceivableFeeManagement feeManagement = new ReceivableFeeManagement(); |
| | | feeManagement.setId(feeId); |
| | | feeManagement.setRelatedBillNo(billSystemNo); |
| | | feeManagements.add(feeManagement); |
| | | feeManagement.setStatus("1"); |
| | | receivableFeeManagementMapper.updateReceivableFeeManagement(feeManagement); |
| | | } |
| | | |
| | | // 调用批量更新方法 |
| | | updateReceivableFeeManagementBatch(feeManagements); |
| | | |
| | | } |
| | | |
| | | return i; |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ruoyi.cwgl.mapper.ReceivableFeeManagementLogMapper"> |
| | | |
| | | <resultMap type="com.ruoyi.cwgl.domain.ReceivableFeeManagementLog" id="ReceivableFeeManagementLogResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="receivableFeeId" column="receivable_fee_id" /> |
| | | <result property="operator" column="operator" /> |
| | | <result property="operationTime" column="operation_time" /> |
| | | <result property="operationDesc" column="operation_desc" /> |
| | | <result property="createTime" column="create_time" /> |
| | | </resultMap> |
| | | |
| | | <sql id="selectReceivableFeeManagementLogVo"> |
| | | select thisTab.id, thisTab.receivable_fee_id, thisTab.operator, thisTab.operation_time, thisTab.operation_desc, thisTab.create_time from receivable_fee_management_log AS thisTab |
| | | </sql> |
| | | <sql id="selectReceivableFeeManagementLogVoCount"> |
| | | select count(0) from receivable_fee_management_log as thisTab |
| | | </sql> |
| | | |
| | | <sql id="whereCondition"> |
| | | <if test="receivableFeeId != null "> and thisTab.receivable_fee_id = #{receivableFeeId}</if> |
| | | <if test="operator != null and operator != ''"> and thisTab.operator = #{operator}</if> |
| | | <if test="operationTime != null "> and thisTab.operation_time = #{operationTime}</if> |
| | | <if test="operationDesc != null and operationDesc != ''"> and thisTab.operation_desc = #{operationDesc}</if> |
| | | </sql> |
| | | |
| | | <!--查询--> |
| | | <select id="selectReceivableFeeManagementLogById" parameterType="Integer" resultMap="ReceivableFeeManagementLogResult"> |
| | | <include refid="selectReceivableFeeManagementLogVo"/> |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <select id="selectReceivableFeeManagementLogCount" parameterType="com.ruoyi.cwgl.domain.ReceivableFeeManagementLog" resultType="int"> |
| | | <include refid="selectReceivableFeeManagementLogVoCount"/> |
| | | <where> |
| | | <include refid="whereCondition"/> |
| | | </where> |
| | | </select> |
| | | |
| | | <select id="selectReceivableFeeManagementLogList" parameterType="com.ruoyi.cwgl.domain.ReceivableFeeManagementLog" resultMap="ReceivableFeeManagementLogResult"> |
| | | <include refid="selectReceivableFeeManagementLogVo"/> |
| | | <where> |
| | | <include refid="whereCondition"/> |
| | | </where> |
| | | order by thisTab.id desc |
| | | </select> |
| | | |
| | | <!-- 新增 --> |
| | | <insert id="insertReceivableFeeManagementLog" parameterType="com.ruoyi.cwgl.domain.ReceivableFeeManagementLog" useGeneratedKeys="true" keyProperty="id"> |
| | | insert into receivable_fee_management_log |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="receivableFeeId != null">receivable_fee_id,</if> |
| | | <if test="operator != null and operator != ''">operator,</if> |
| | | <if test="operationTime != null">operation_time,</if> |
| | | <if test="operationDesc != null and operationDesc != ''">operation_desc,</if> |
| | | <if test="createTime != null">create_time,</if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="receivableFeeId != null">#{receivableFeeId},</if> |
| | | <if test="operator != null and operator != ''">#{operator},</if> |
| | | <if test="operationTime != null">#{operationTime},</if> |
| | | <if test="operationDesc != null and operationDesc != ''">#{operationDesc},</if> |
| | | <if test="createTime != null">#{createTime},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | | <insert id="insertReceivableFeeManagementLogBatch" parameterType="java.util.List" useGeneratedKeys="true" keyProperty="id"> |
| | | insert into receivable_fee_management_log |
| | | <trim prefix="(" suffix=") values" suffixOverrides=","> |
| | | id,receivable_fee_id,operator,operation_time,operation_desc,create_time, |
| | | </trim> |
| | | <foreach item="item" index="index" collection="list" separator=","> |
| | | <trim prefix="(" suffix=") " suffixOverrides=","> |
| | | #{item.id},#{item.receivableFeeId},#{item.operator},#{item.operationTime},#{item.operationDesc},#{item.createTime}, |
| | | </trim> |
| | | </foreach> |
| | | </insert> |
| | | |
| | | <!-- 修改 --> |
| | | <update id="updateReceivableFeeManagementLog" parameterType="com.ruoyi.cwgl.domain.ReceivableFeeManagementLog"> |
| | | update receivable_fee_management_log |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="receivableFeeId != null">receivable_fee_id = #{receivableFeeId},</if> |
| | | <if test="operator != null and operator != ''">operator = #{operator},</if> |
| | | <if test="operationTime != null">operation_time = #{operationTime},</if> |
| | | <if test="operationDesc != null and operationDesc != ''">operation_desc = #{operationDesc},</if> |
| | | <if test="createTime != null">create_time = #{createTime},</if> |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |
| | | <!-- 修改 --> |
| | | <update id="updateReceivableFeeManagementLogBatch" parameterType="java.util.List"> |
| | | <foreach collection="list" item="item" index="index" separator=";"> |
| | | update receivable_fee_management_log |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="item.receivableFeeId != null">receivable_fee_id = #{item.receivableFeeId},</if> |
| | | <if test="item.operator != null and item.operator != ''">operator = #{item.operator},</if> |
| | | <if test="item.operationTime != null">operation_time = #{item.operationTime},</if> |
| | | <if test="item.operationDesc != null and item.operationDesc != ''">operation_desc = #{item.operationDesc},</if> |
| | | <if test="item.createTime != null">create_time = #{item.createTime},</if> |
| | | </trim> |
| | | where id = #{item.id} |
| | | </foreach> |
| | | </update> |
| | | |
| | | <!--删除--> |
| | | <delete id="deleteReceivableFeeManagementLogById" parameterType="Integer"> |
| | | delete from receivable_fee_management_log where id = #{id} |
| | | </delete> |
| | | <delete id="deleteReceivableFeeManagementLogByIds" parameterType="Integer"> |
| | | delete from receivable_fee_management_log where id in |
| | | <foreach item="id" collection="array" open="(" separator="," close=")"> |
| | | #{id} |
| | | </foreach> |
| | | </delete> |
| | | |
| | | </mapper> |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ruoyi.cwgl.mapper.ReceivableFeeManagementMapper"> |
| | | |
| | | <resultMap type="com.ruoyi.cwgl.domain.ReceivableFeeManagement" id="ReceivableFeeManagementResult"> |
| | |
| | | <result property="isInternalSettlement" column="is_internal_settlement" /> |
| | | <result property="internalSettlementUnit" column="internal_settlement_unit" /> |
| | | <result property="customerName" column="customer_name" /> |
| | | <result property="customerId" column="customer_id" /> |
| | | <result property="projectName" column="project_name" /> |
| | | <result property="businessTime" column="business_time" /> |
| | | <result property="receivableConfirmTime" column="receivable_confirm_time" /> |
| | |
| | | <result property="updateBy" column="update_by" /> |
| | | <result property="updateTime" column="update_time" /> |
| | | <result property="deleted" column="deleted" /> |
| | | <result property="customerId" column="customer_id" /> |
| | | </resultMap> |
| | | |
| | | <sql id="selectReceivableFeeManagementVo"> |
| | | select thisTab.id, thisTab.system_no, thisTab.related_bill_no, thisTab.source_system, thisTab.business_sector, thisTab.document_type, thisTab.document_no, thisTab.is_internal_settlement, thisTab.internal_settlement_unit, thisTab.customer_name, thisTab.customer_id, thisTab.project_name, thisTab.business_time, thisTab.receivable_confirm_time, thisTab.receivable_amount, thisTab.status, thisTab.remark, thisTab.create_by, thisTab.create_time, thisTab.update_by, thisTab.update_time, thisTab.deleted from receivable_fee_management AS thisTab |
| | | select thisTab.id, thisTab.system_no, thisTab.related_bill_no, thisTab.source_system, thisTab.business_sector, thisTab.document_type, thisTab.document_no, thisTab.is_internal_settlement, thisTab.internal_settlement_unit, thisTab.customer_name, thisTab.project_name, thisTab.business_time, thisTab.receivable_confirm_time, thisTab.receivable_amount, thisTab.status, thisTab.remark, thisTab.create_by, thisTab.create_time, thisTab.update_by, thisTab.update_time, thisTab.deleted, thisTab.customer_id from receivable_fee_management AS thisTab |
| | | </sql> |
| | | <sql id="selectReceivableFeeManagementVoCount"> |
| | | select count(0) from receivable_fee_management as thisTab |
| | |
| | | <if test="isInternalSettlement != null and isInternalSettlement != ''"> and thisTab.is_internal_settlement = #{isInternalSettlement}</if> |
| | | <if test="internalSettlementUnit != null and internalSettlementUnit != ''"> and thisTab.internal_settlement_unit = #{internalSettlementUnit}</if> |
| | | <if test="customerName != null and customerName != ''"> and thisTab.customer_name like concat('%', #{customerName}, '%')</if> |
| | | <if test="customerId != null and customerId != ''"> and thisTab.customer_id = #{customerId}</if> |
| | | <if test="projectName != null and projectName != ''"> and thisTab.project_name like concat('%', #{projectName}, '%')</if> |
| | | <if test="businessTime != null "> and thisTab.business_time = #{businessTime}</if> |
| | | <if test="receivableConfirmTime != null "> and thisTab.receivable_confirm_time = #{receivableConfirmTime}</if> |
| | | <if test="receivableAmount != null "> and thisTab.receivable_amount = #{receivableAmount}</if> |
| | | <if test="status != null and status != ''"> and thisTab.status = #{status}</if> |
| | | <if test="deleted != null "> and thisTab.deleted = #{deleted}</if> |
| | | <if test="customerId != null "> and thisTab.customer_id = #{customerId}</if> |
| | | </sql> |
| | | |
| | | <!--查询--> |
| | |
| | | <if test="isInternalSettlement != null and isInternalSettlement != ''">is_internal_settlement,</if> |
| | | <if test="internalSettlementUnit != null">internal_settlement_unit,</if> |
| | | <if test="customerName != null and customerName != ''">customer_name,</if> |
| | | <if test="customerId != null">customer_id,</if> |
| | | <if test="projectName != null">project_name,</if> |
| | | <if test="businessTime != null">business_time,</if> |
| | | <if test="receivableConfirmTime != null">receivable_confirm_time,</if> |
| | |
| | | <if test="updateBy != null">update_by,</if> |
| | | <if test="updateTime != null">update_time,</if> |
| | | <if test="deleted != null">deleted,</if> |
| | | </trim> |
| | | <if test="customerId != null">customer_id,</if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="systemNo != null and systemNo != ''">#{systemNo},</if> |
| | | <if test="relatedBillNo != null and relatedBillNo != ''">#{relatedBillNo},</if> |
| | |
| | | <if test="isInternalSettlement != null and isInternalSettlement != ''">#{isInternalSettlement},</if> |
| | | <if test="internalSettlementUnit != null">#{internalSettlementUnit},</if> |
| | | <if test="customerName != null and customerName != ''">#{customerName},</if> |
| | | <if test="customerId != null">#{customerId},</if> |
| | | <if test="projectName != null">#{projectName},</if> |
| | | <if test="businessTime != null">#{businessTime},</if> |
| | | <if test="receivableConfirmTime != null">#{receivableConfirmTime},</if> |
| | |
| | | <if test="updateBy != null">#{updateBy},</if> |
| | | <if test="updateTime != null">#{updateTime},</if> |
| | | <if test="deleted != null">#{deleted},</if> |
| | | </trim> |
| | | <if test="customerId != null">#{customerId},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | | <!-- 批量新增 --> |
| | | <insert id="insertReceivableFeeManagementBatch" parameterType="com.ruoyi.cwgl.domain.ReceivableFeeManagement" useGeneratedKeys="true" keyProperty="id"> |
| | | insert into receivable_fee_management (system_no, related_bill_no, source_system, business_sector, document_type, document_no, is_internal_settlement, internal_settlement_unit, customer_name, customer_id, project_name, business_time, receivable_confirm_time, receivable_amount, status, remark, create_by, create_time, update_by, update_time, deleted) |
| | | values |
| | | <insert id="insertReceivableFeeManagementBatch" parameterType="java.util.List" useGeneratedKeys="true" keyProperty="id"> |
| | | insert into receivable_fee_management |
| | | <trim prefix="(" suffix=") values" suffixOverrides=","> |
| | | id,system_no,related_bill_no,source_system,business_sector,document_type,document_no,is_internal_settlement,internal_settlement_unit,customer_name,project_name,business_time,receivable_confirm_time,receivable_amount,status,remark,create_by,create_time,update_by,update_time,deleted,customer_id, |
| | | </trim> |
| | | <foreach item="item" index="index" collection="list" separator=","> |
| | | (#{item.systemNo}, #{item.relatedBillNo}, #{item.sourceSystem}, #{item.businessSector}, #{item.documentType}, #{item.documentNo}, #{item.isInternalSettlement}, #{item.internalSettlementUnit}, #{item.customerName}, #{item.customerId}, #{item.projectName}, #{item.businessTime}, #{item.receivableConfirmTime}, #{item.receivableAmount}, #{item.status}, #{item.remark}, #{item.createBy}, #{item.createTime}, #{item.updateBy}, #{item.updateTime}, #{item.deleted}) |
| | | <trim prefix="(" suffix=") " suffixOverrides=","> |
| | | #{item.id},#{item.systemNo},#{item.relatedBillNo},#{item.sourceSystem},#{item.businessSector},#{item.documentType},#{item.documentNo},#{item.isInternalSettlement},#{item.internalSettlementUnit},#{item.customerName},#{item.projectName},#{item.businessTime},#{item.receivableConfirmTime},#{item.receivableAmount},#{item.status},#{item.remark},#{item.createBy},#{item.createTime},#{item.updateBy},#{item.updateTime},#{item.deleted},#{item.customerId}, |
| | | </trim> |
| | | </foreach> |
| | | </insert> |
| | | |
| | |
| | | <if test="isInternalSettlement != null and isInternalSettlement != ''">is_internal_settlement = #{isInternalSettlement},</if> |
| | | <if test="internalSettlementUnit != null">internal_settlement_unit = #{internalSettlementUnit},</if> |
| | | <if test="customerName != null and customerName != ''">customer_name = #{customerName},</if> |
| | | <if test="customerId != null">customer_id = #{customerId},</if> |
| | | <if test="projectName != null">project_name = #{projectName},</if> |
| | | <if test="businessTime != null">business_time = #{businessTime},</if> |
| | | <if test="receivableConfirmTime != null">receivable_confirm_time = #{receivableConfirmTime},</if> |
| | |
| | | <if test="updateBy != null">update_by = #{updateBy},</if> |
| | | <if test="updateTime != null">update_time = #{updateTime},</if> |
| | | <if test="deleted != null">deleted = #{deleted},</if> |
| | | <if test="customerId != null">customer_id = #{customerId},</if> |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |
| | | <!-- 修改 --> |
| | | <update id="updateReceivableFeeManagementBatch" parameterType="java.util.List"> |
| | | <foreach collection="list" item="item" index="index" separator=","> |
| | | <foreach collection="list" item="item" index="index" separator=";"> |
| | | update receivable_fee_management |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="item.systemNo != null and item.systemNo != ''">system_no = #{item.systemNo},</if> |
| | |
| | | <if test="item.isInternalSettlement != null and item.isInternalSettlement != ''">is_internal_settlement = #{item.isInternalSettlement},</if> |
| | | <if test="item.internalSettlementUnit != null">internal_settlement_unit = #{item.internalSettlementUnit},</if> |
| | | <if test="item.customerName != null and item.customerName != ''">customer_name = #{item.customerName},</if> |
| | | <if test="item.customerId != null">customer_id = #{item.customerId},</if> |
| | | <if test="item.projectName != null">project_name = #{item.projectName},</if> |
| | | <if test="item.businessTime != null">business_time = #{item.businessTime},</if> |
| | | <if test="item.receivableConfirmTime != null">receivable_confirm_time = #{item.receivableConfirmTime},</if> |
| | |
| | | <if test="item.updateBy != null">update_by = #{item.updateBy},</if> |
| | | <if test="item.updateTime != null">update_time = #{item.updateTime},</if> |
| | | <if test="item.deleted != null">deleted = #{item.deleted},</if> |
| | | <if test="item.customerId != null">customer_id = #{item.customerId},</if> |
| | | </trim> |
| | | where id = #{item.id} |
| | | where id = #{item.id} |
| | | </foreach> |
| | | </update> |
| | | |
| | |
| | | #{id} |
| | | </foreach> |
| | | </delete> |
| | | |
| | | <!--根据ID数组查询--> |
| | | <select id="selectReceivableFeeManagementByIds" parameterType="Integer" resultMap="ReceivableFeeManagementResult"> |
| | | <include refid="selectReceivableFeeManagementVo"/> |
| | |
| | | #{id} |
| | | </foreach> |
| | | </select> |
| | | |
| | | </mapper> |
| New file |
| | |
| | | import request,{download,requestType} from "@/utils/request"; |
| | | import {BaseEntityInterface} from "@/utils/globalInterface"; |
| | | export interface ReceivableFeeManagementLogI extends BaseEntityInterface{ |
| | | id ?: number , receivableFeeId ?: number , operator ?: string , operationTime ?: string , operationDesc ?: string , createTime ?: string } |
| | | |
| | | |
| | | /** |
| | | * 查询应收费用管理操作日志列表 |
| | | */ |
| | | export const listReceivableFeeManagementLog:requestType = (query) => { |
| | | return request({ |
| | | url: '/cwgl/receivableFeeManagementLog/list', |
| | | method:'get', |
| | | params:query |
| | | }) |
| | | } |
| | | /** |
| | | * 查询应收费用管理操作日志详细 |
| | | */ |
| | | export const getReceivableFeeManagementLog:requestType = (id) => { |
| | | return request({ |
| | | url: '/cwgl/receivableFeeManagementLog/' + id, |
| | | method:'get' |
| | | }) |
| | | } |
| | | |
| | | /** |
| | | * 新增应收费用管理操作日志 |
| | | */ |
| | | export const addReceivableFeeManagementLog:requestType = (data) => { |
| | | return request({ |
| | | url: '/cwgl/receivableFeeManagementLog', |
| | | method: 'post', |
| | | data |
| | | }) |
| | | } |
| | | |
| | | /** |
| | | * 修改应收费用管理操作日志 |
| | | */ |
| | | export const updateReceivableFeeManagementLog:requestType = (data) => { |
| | | return request({ |
| | | url: '/cwgl/receivableFeeManagementLog', |
| | | method: 'put', |
| | | data |
| | | }) |
| | | } |
| | | |
| | | /** |
| | | * 删除应收费用管理操作日志 |
| | | */ |
| | | export const delReceivableFeeManagementLog:requestType = (id) => { |
| | | return request({ |
| | | url: '/cwgl/receivableFeeManagementLog/' + id, |
| | | method: 'delete' |
| | | }) |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 导出应收费用管理操作日志 |
| | | */ |
| | | export const exportReceivableFeeManagementLog:requestType = (query) => { |
| | | return new Promise<any>(()=>{ |
| | | download('/cwgl/receivableFeeManagementLog/export',query); |
| | | }) |
| | | } |
| New file |
| | |
| | | <template> |
| | | <basicContainer > |
| | | <avue-crud |
| | | :option="option" |
| | | :table-loading="pageF.loading" |
| | | :data="tableData" |
| | | :page="page" |
| | | :permission="permissionList" |
| | | :before-open="beforeOpen" |
| | | v-model="form" |
| | | ref="crudRef" |
| | | @row-update="rowUpdate" |
| | | @row-save="rowSave" |
| | | @refresh-change="refreshChange" |
| | | @row-del="rowDel" |
| | | @search-change="searchChange" |
| | | @search-reset="searchReset" |
| | | @selection-change="selectionChange" |
| | | @current-change="currentChange" |
| | | @size-change="sizeChange" |
| | | @on-load="onLoad" |
| | | > |
| | | <template #menu-left> |
| | | <el-button |
| | | type="success" |
| | | icon="Edit" |
| | | :disabled="pageF.single" |
| | | v-hasPermi="['cwgl:receivableFeeManagementLog:edit']" |
| | | @click="handleUpdate">修改 |
| | | </el-button> |
| | | <el-button |
| | | type="danger" |
| | | icon="Delete" |
| | | :disabled="pageF.multiple" |
| | | @click="handleDelete" |
| | | v-hasPermi="['cwgl:receivableFeeManagementLog:remove']" |
| | | >删除 |
| | | </el-button> |
| | | <el-button |
| | | type="warning" |
| | | plain |
| | | icon="Download" |
| | | @click="handleExport" |
| | | v-hasPermi="['cwgl:receivableFeeManagementLog:export']" |
| | | >导出 |
| | | </el-button> |
| | | </template> |
| | | </avue-crud> |
| | | </basicContainer> |
| | | </template> |
| | | |
| | | <script setup name="receivableFeeManagementLog" lang="ts"> |
| | | import {ReceivableFeeManagementLogI,addReceivableFeeManagementLog, delReceivableFeeManagementLog, exportReceivableFeeManagementLog, getReceivableFeeManagementLog, listReceivableFeeManagementLog, updateReceivableFeeManagementLog} from "@/api/cwgl/receivableFeeManagementLog"; |
| | | import useCurrentInstance from "@/utils/useCurrentInstance"; |
| | | import {computed,reactive, ref, toRefs} from "vue"; |
| | | import {PagesInterface, PageQueryInterface} from "@/utils/globalInterface"; |
| | | import {usePagePlus} from "@/hooks/usePagePlus"; |
| | | import {hasPermission} from "@/utils/permissionUtils"; |
| | | |
| | | const { proxy } = useCurrentInstance(); |
| | | const crudRef = ref(); |
| | | |
| | | const permissionList = computed(()=>{ |
| | | return { |
| | | addBtn: hasPermission(["cwgl:receivableFeeManagementLog:add"]), |
| | | delBtn: hasPermission(["cwgl:receivableFeeManagementLog:remove"]), |
| | | editBtn: hasPermission(["cwgl:receivableFeeManagementLog:edit"]), |
| | | viewBtn: hasPermission(["cwgl:receivableFeeManagementLog:query"]), |
| | | } |
| | | }) |
| | | |
| | | const data = reactive({ |
| | | form:<ReceivableFeeManagementLogI>{}, |
| | | queryParams:<ReceivableFeeManagementLogI&PageQueryInterface>{}, |
| | | page: <PagesInterface>{ |
| | | pageSize: 10, |
| | | total: 0, |
| | | currentPage: 1, |
| | | }, |
| | | selectionList:[], |
| | | }) |
| | | const {queryParams,form,page,selectionList} = toRefs(data); |
| | | const option = ref({ |
| | | pageKey: 'ReceivableFeeManagementLog', |
| | | rowKey: 'id', |
| | | column: { |
| | | id: { |
| | | label: '日志ID', |
| | | }, |
| | | receivableFeeId: { |
| | | label: '关联的应收费用管理ID', |
| | | rules: [ |
| | | { |
| | | required: true, |
| | | message: "关联的应收费用管理ID不能为空", trigger: "blur" } |
| | | ], }, |
| | | operator: { |
| | | label: '操作人', |
| | | rules: [ |
| | | { |
| | | required: true, |
| | | message: "操作人不能为空", trigger: "blur" } |
| | | ], }, |
| | | operationTime: { |
| | | label: '操作时间', |
| | | rules: [ |
| | | { |
| | | required: true, |
| | | message: "操作时间不能为空", trigger: "blur" } |
| | | ], }, |
| | | operationDesc: { |
| | | label: '操作描述', |
| | | rules: [ |
| | | { |
| | | required: true, |
| | | message: "操作描述不能为空", trigger: "blur" } |
| | | ], }, |
| | | createTime: { |
| | | label: '记录创建时间', |
| | | rules: [ |
| | | { |
| | | required: true, |
| | | message: "记录创建时间不能为空", trigger: "blur" } |
| | | ] }, |
| | | } |
| | | }) |
| | | |
| | | const { tableData,pageF,rowSave,rowUpdate,rowDel,beforeOpen,searchChange, |
| | | searchReset,selectionChange,onLoad,currentChange,sizeChange,handleDelete,handleExport,handleUpdate,refreshChange} = usePagePlus({ |
| | | form:form, |
| | | option:option, |
| | | queryParams:queryParams, |
| | | idKey:'id', |
| | | page:page.value, |
| | | getListApi:listReceivableFeeManagementLog, |
| | | getDetailApi:getReceivableFeeManagementLog, |
| | | exportApi:exportReceivableFeeManagementLog, |
| | | deleteApi:delReceivableFeeManagementLog, |
| | | addApi:addReceivableFeeManagementLog, |
| | | updateApi:updateReceivableFeeManagementLog, |
| | | handleUpdateFunc:()=>{ |
| | | crudRef.value.rowEdit(selectionList.value[0]); |
| | | }, |
| | | handleSelectionChangeFunc:(selection:any)=>{ |
| | | selectionList.value = selection; |
| | | } |
| | | }) |
| | | |
| | | |
| | | </script> |