yys 1.回款登记台账页面，增加一个开票日期列，和开票日期时间段查询 2.开票登记台账页面，增加合同录入日期列，和合同录入日期时间段查询

maven

2025-09-23 34993855d43464975517e812e6bb0538bc2dc926

yys
1.回款登记台账页面，增加一个开票日期列，和开票日期时间段查询
2.开票登记台账页面，增加合同录入日期列，和合同录入日期时间段查询

 src/main/java/com/ruoyi/sales/dto/ReceiptPaymentDto.java

@@ -29,6 +29,11 @@
    @ApiModelProperty(value = "开票日期")
    private Date invoiceDate;

    @TableField(exist = false)
    private String invoiceDateStart;
    @TableField(exist = false)
    private String invoiceDateEnd;

    @ApiModelProperty(value = "查询文本")
    private String searchText;


 src/main/java/com/ruoyi/sales/mapper/ReceiptPaymentMapper.java

@@ -26,7 +26,7 @@
     * @param receiptPaymentDto
     * @return
     */
    IPage<ReceiptPaymentDto> bindInvoiceNoRegPage(Page page, @Param("c") ReceiptPaymentDto receiptPaymentDto);
    IPage<ReceiptPaymentDto> bindInvoiceNoRegPage(Page page, @Param("req") ReceiptPaymentDto receiptPaymentDto);

    /**
     * 开票台账详情

 src/main/resources/mapper/sales/ReceiptPaymentMapper.xml

@@ -95,17 +95,23 @@
        BY invoice_ledger_id
        ) T6 ON T1.id = T6.invoice_ledger_id
        <where>
            <if test="c.customerName != null and c.customerName !=''">
                AND T3.customer_name LIKE CONCAT('%',#{c.customerName},'%')
            <if test="req.customerName != null and req.customerName !=''">
                AND T3.customer_name LIKE CONCAT('%',#{req.customerName},'%')
            </if>
            <if test="c.invoiceLedgerId != null">
                AND T1.id = #{c.invoiceLedgerId}
            <if test="req.invoiceLedgerId != null">
                AND T1.id = #{req.invoiceLedgerId}
            </if>
            <if test="c.customerContractNo != null and c.customerContractNo !=''">
                AND T3.customer_contract_no LIKE CONCAT('%',#{c.customerContractNo},'%')
            <if test="req.customerContractNo != null and req.customerContractNo !=''">
                AND T3.customer_contract_no LIKE CONCAT('%',#{req.customerContractNo},'%')
            </if>
            <if test="c.projectName != null and c.projectName !=''">
                AND T3.project_name LIKE CONCAT('%',#{c.projectName},'%')
            <if test="req.projectName != null and req.projectName !=''">
                AND T3.project_name LIKE CONCAT('%',#{req.projectName},'%')
            </if>
            <if test="req.invoiceDateStart != null and req.invoiceDateStart != '' ">
                AND T1.invoice_date &gt;= DATE_FORMAT(#{req.invoiceDateStart},'%Y-%m-%d')
            </if>
            <if test="req.invoiceDateEnd != null and req.invoiceDateEnd != '' ">
                AND  T1.invoice_date &lt;= DATE_FORMAT(#{req.invoiceDateEnd},'%Y-%m-%d')
            </if>
        </where>
        ORDER BY T2.create_time DESC