新增字段

wujianwei

2026-01-06 67ed08fdbc54408e2e6f29bc72b2f548a8d91290

新增字段

 service/src/main/java/com/ruoyi/cwgl/domain/InvoiceManage.java

@@ -91,6 +91,10 @@
        @TableField("invoice_operating_license_address")
    private String invoiceOperatingLicenseAddress;

    @Excel(name = "销售方地址")
    @TableField("invoice_seller_address")
    private String invoiceSellerAddress;


    /** 注册固定电话 */
    @Excel(name = "注册固定电话")
@@ -98,6 +102,10 @@
        @TableField("invoice_operating_license_phone")
    private String invoiceOperatingLicensePhone;

    @Excel(name = "销售方固定电话")
    @TableField("invoice_seller_phone")
    private String invoiceSellerPhone;


    /** 邮箱 */
    @Excel(name = "邮箱")

 service/src/main/resources/mapper/cwgl/InvoiceManageMapper.xml

@@ -17,6 +17,8 @@
        <result property="invoiceBankNo"    column="invoice_bank_no"    />
        <result property="invoiceOperatingLicenseAddress"    column="invoice_operating_license_address"    />
        <result property="invoiceOperatingLicensePhone"    column="invoice_operating_license_phone"    />
        <result property="invoiceSellerAddress"    column="invoice_seller_address"    />
        <result property="invoiceSellerPhone"    column="invoice_seller_phone"    />
        <result property="invoiceOperatingLicenseEmail"    column="invoice_operating_license_email"    />
        <result property="status"    column="status"    />
        <result property="invoiceNo"    column="invoice_no"    />
@@ -51,7 +53,7 @@
    </resultMap>

    <sql id="selectInvoiceManageVo">
        select thisTab.id, thisTab.invoice_info_id, thisTab.invoice_seller_id, thisTab.customer_name, thisTab.invoice_seller_name, thisTab.invoice_company_name, thisTab.invoice_credit_code, thisTab.invoice_seller_credit_code, thisTab.invoice_bank_name, thisTab.invoice_bank_no, thisTab.invoice_operating_license_address, thisTab.invoice_operating_license_phone, thisTab.invoice_operating_license_email, thisTab.status, thisTab.invoice_no, thisTab.invoice_date, thisTab.invoice_amount, thisTab.related_bill_billed_amount, thisTab.create_by, thisTab.update_by, thisTab.create_time, thisTab.update_time, thisTab.deleted, thisTab.invoice_type, thisTab.enterprise_type from invoice_manage AS thisTab
        select thisTab.id, thisTab.invoice_info_id, thisTab.invoice_seller_id, thisTab.customer_name, thisTab.invoice_seller_name, thisTab.invoice_company_name, thisTab.invoice_credit_code, thisTab.invoice_seller_credit_code, thisTab.invoice_bank_name, thisTab.invoice_bank_no, thisTab.invoice_operating_license_address, thisTab.invoice_operating_license_phone, thisTab.invoice_seller_address, thisTab.invoice_seller_phone, thisTab.invoice_operating_license_email, thisTab.status, thisTab.invoice_no, thisTab.invoice_date, thisTab.invoice_amount, thisTab.related_bill_billed_amount, thisTab.create_by, thisTab.update_by, thisTab.create_time, thisTab.update_time, thisTab.deleted, thisTab.invoice_type, thisTab.enterprise_type from invoice_manage AS thisTab
    </sql>
    <sql id="selectInvoiceManageVoCount">
        select count(0) from invoice_manage as thisTab
@@ -69,6 +71,8 @@
        <if test="invoiceBankNo != null  and invoiceBankNo != ''"> and thisTab.invoice_bank_no = #{invoiceBankNo}</if>
        <if test="invoiceOperatingLicenseAddress != null  and invoiceOperatingLicenseAddress != ''"> and thisTab.invoice_operating_license_address = #{invoiceOperatingLicenseAddress}</if>
        <if test="invoiceOperatingLicensePhone != null  and invoiceOperatingLicensePhone != ''"> and thisTab.invoice_operating_license_phone = #{invoiceOperatingLicensePhone}</if>
        <if test="invoiceSellerAddress != null  and invoiceSellerAddress != ''"> and thisTab.invoice_seller_address = #{invoiceSellerAddress}</if>
        <if test="invoiceSellerPhone != null  and invoiceSellerPhone != ''"> and thisTab.invoice_seller_phone = #{invoiceSellerPhone}</if>
        <if test="invoiceOperatingLicenseEmail != null  and invoiceOperatingLicenseEmail != ''"> and thisTab.invoice_operating_license_email = #{invoiceOperatingLicenseEmail}</if>
        <if test="status != null "> and thisTab.status = #{status}</if>
        <if test="invoiceNo != null  and invoiceNo != ''"> and thisTab.invoice_no = #{invoiceNo}</if>
@@ -81,7 +85,7 @@

    <!--查询-->
    <select id="selectInvoiceManageById" parameterType="Integer" resultMap="InvoiceManageInvoiceDetailResult">
        select a.id, a.invoice_info_id, a.invoice_seller_id, a.customer_name, a.invoice_seller_name, a.invoice_company_name, a.invoice_credit_code, a.invoice_seller_credit_code, a.invoice_bank_name, a.invoice_bank_no, a.invoice_operating_license_address, a.invoice_operating_license_phone, a.invoice_operating_license_email, a.status, a.invoice_no, a.invoice_date, a.invoice_amount, a.related_bill_billed_amount, a.create_by, a.update_by, a.create_time, a.update_time, a.deleted, a.invoice_type, a.enterprise_type,
        select a.id, a.invoice_info_id, a.invoice_seller_id, a.customer_name, a.invoice_seller_name, a.invoice_company_name, a.invoice_credit_code, a.invoice_seller_credit_code, a.invoice_bank_name, a.invoice_bank_no, a.invoice_operating_license_address, a.invoice_operating_license_phone, a.invoice_seller_address, a.invoice_seller_phone, a.invoice_operating_license_email, a.status, a.invoice_no, a.invoice_date, a.invoice_amount, a.related_bill_billed_amount, a.create_by, a.update_by, a.create_time, a.update_time, a.deleted, a.invoice_type, a.enterprise_type,
             b.id as sub_id, b.invoice_manage_id as sub_invoice_manage_id, b.receivable_bill_no as sub_receivable_bill_no, b.receivable_bill_amount as sub_receivable_bill_amount, b.receivable_bill_currency as sub_receivable_bill_currency, b.billed_amount as sub_billed_amount, b.unbilled_amount as sub_unbilled_amount, b.current_billed_amount as sub_current_billed_amount, b.create_time as sub_create_time, b.update_time as sub_update_time, b.deleted as sub_deleted        from invoice_manage a
        left join invoice_detail b on b.invoice_manage_id = a.id
        where a.id = #{id}
@@ -117,6 +121,8 @@
            <if test="invoiceBankNo != null">invoice_bank_no,</if>
            <if test="invoiceOperatingLicenseAddress != null">invoice_operating_license_address,</if>
            <if test="invoiceOperatingLicensePhone != null">invoice_operating_license_phone,</if>
            <if test="invoiceSellerAddress != null">invoice_seller_address,</if>
            <if test="invoiceSellerPhone != null">invoice_seller_phone,</if>
            <if test="invoiceOperatingLicenseEmail != null">invoice_operating_license_email,</if>
            <if test="status != null">status,</if>
            <if test="invoiceNo != null">invoice_no,</if>
@@ -143,6 +149,8 @@
            <if test="invoiceBankNo != null">#{invoiceBankNo},</if>
            <if test="invoiceOperatingLicenseAddress != null">#{invoiceOperatingLicenseAddress},</if>
            <if test="invoiceOperatingLicensePhone != null">#{invoiceOperatingLicensePhone},</if>
            <if test="invoiceSellerAddress != null">#{invoiceSellerAddress},</if>
            <if test="invoiceSellerPhone != null">#{invoiceSellerPhone},</if>
            <if test="invoiceOperatingLicenseEmail != null">#{invoiceOperatingLicenseEmail},</if>
            <if test="status != null">#{status},</if>
            <if test="invoiceNo != null">#{invoiceNo},</if>
@@ -162,11 +170,11 @@
    <insert id="insertInvoiceManageBatch" parameterType="java.util.List"  useGeneratedKeys="true" keyProperty="id">
        insert into invoice_manage
        <trim prefix="(" suffix=") values" suffixOverrides=",">
            id,invoice_info_id,invoice_seller_id,customer_name,invoice_seller_name,invoice_company_name,invoice_credit_code,invoice_seller_credit_code,invoice_bank_name,invoice_bank_no,invoice_operating_license_address,invoice_operating_license_phone,invoice_operating_license_email,status,invoice_no,invoice_date,invoice_amount,related_bill_billed_amount,create_by,update_by,create_time,update_time,deleted,invoice_type,enterprise_type,
            id,invoice_info_id,invoice_seller_id,customer_name,invoice_seller_name,invoice_company_name,invoice_credit_code,invoice_seller_credit_code,invoice_bank_name,invoice_bank_no,invoice_operating_license_address,invoice_operating_license_phone,invoice_seller_address,invoice_seller_phone,invoice_operating_license_email,status,invoice_no,invoice_date,invoice_amount,related_bill_billed_amount,create_by,update_by,create_time,update_time,deleted,invoice_type,enterprise_type,
        </trim>
        <foreach item="item" index="index" collection="list" separator=",">
            <trim prefix="(" suffix=") " suffixOverrides=",">
                #{item.id},#{item.invoiceInfoId},#{item.invoiceSellerId},#{item.customerName},#{item.invoiceSellerName},#{item.invoiceCompanyName},#{item.invoiceCreditCode},#{item.invoiceSellerCreditCode},#{item.invoiceBankName},#{item.invoiceBankNo},#{item.invoiceOperatingLicenseAddress},#{item.invoiceOperatingLicensePhone},#{item.invoiceOperatingLicenseEmail},#{item.status},#{item.invoiceNo},#{item.invoiceDate},#{item.invoiceAmount},#{item.relatedBillBilledAmount},#{item.createBy},#{item.updateBy},#{item.createTime},#{item.updateTime},#{item.deleted},#{item.invoiceType},#{item.enterpriseType},
                #{item.id},#{item.invoiceInfoId},#{item.invoiceSellerId},#{item.customerName},#{item.invoiceSellerName},#{item.invoiceCompanyName},#{item.invoiceCreditCode},#{item.invoiceSellerCreditCode},#{item.invoiceBankName},#{item.invoiceBankNo},#{item.invoiceOperatingLicenseAddress},#{item.invoiceOperatingLicensePhone},#{item.invoiceSellerAddress},#{item.invoiceSellerPhone},#{item.invoiceOperatingLicenseEmail},#{item.status},#{item.invoiceNo},#{item.invoiceDate},#{item.invoiceAmount},#{item.relatedBillBilledAmount},#{item.createBy},#{item.updateBy},#{item.createTime},#{item.updateTime},#{item.deleted},#{item.invoiceType},#{item.enterpriseType},
            </trim>
        </foreach>
    </insert>
@@ -186,6 +194,8 @@
            <if test="invoiceBankNo != null">invoice_bank_no = #{invoiceBankNo},</if>
            <if test="invoiceOperatingLicenseAddress != null">invoice_operating_license_address = #{invoiceOperatingLicenseAddress},</if>
            <if test="invoiceOperatingLicensePhone != null">invoice_operating_license_phone = #{invoiceOperatingLicensePhone},</if>
            <if test="invoiceSellerAddress != null">invoice_seller_address = #{invoiceSellerAddress},</if>
            <if test="invoiceSellerPhone != null">invoice_seller_phone = #{invoiceSellerPhone},</if>
            <if test="invoiceOperatingLicenseEmail != null">invoice_operating_license_email = #{invoiceOperatingLicenseEmail},</if>
            <if test="status != null">status = #{status},</if>
            <if test="invoiceNo != null">invoice_no = #{invoiceNo},</if>
@@ -218,6 +228,8 @@
                <if test="item.invoiceBankNo != null">invoice_bank_no = #{item.invoiceBankNo},</if>
                <if test="item.invoiceOperatingLicenseAddress != null">invoice_operating_license_address = #{item.invoiceOperatingLicenseAddress},</if>
                <if test="item.invoiceOperatingLicensePhone != null">invoice_operating_license_phone = #{item.invoiceOperatingLicensePhone},</if>
                <if test="item.invoiceSellerAddress != null">invoice_seller_address = #{item.invoiceSellerAddress},</if>
                <if test="item.invoiceSellerPhone != null">invoice_seller_phone = #{item.invoiceSellerPhone},</if>
                <if test="item.invoiceOperatingLicenseEmail != null">invoice_operating_license_email = #{item.invoiceOperatingLicenseEmail},</if>
                <if test="item.status != null">status = #{item.status},</if>
                <if test="item.invoiceNo != null">invoice_no = #{item.invoiceNo},</if>