pipIrr-SV.git - Gitblit

			@@ -48,8 +48,10 @@
			*/
			private Float money;

			@Schema(title = "水卡编号")
			private String cardNum;
			@JSONField(serializeUsing= ObjectWriterImplToString.class)
			private Long cardNum;

			private Integer cardCost;

			@Schema(title = "充值金额")
			private Float amount;

			@@ -266,7 +266,6 @@
			<!--根据指定条件获取充值记录-->
			<select id="getRecharges" resultType="com.dy.pipIrrGlobal.voSe.VoRecharge">
			SELECT
			<!-- CAST(ope.id AS char) AS id,-->
			ope.id AS opeId,
			card.id AS cardId,
			cli.name AS clientName,
			@@ -275,11 +274,14 @@
			cli.clientNum,
			cli.address,
			card.money,
			CAST(card.cardNum AS char) AS cardNum,
			CASE
			WHEN card.cardNum LIKE '10%' THEN CONCAT(SUBSTRING(card.cardNum, 7, 6),SUBSTRING(card.cardNum, 14, 4))
			ELSE card.cardNum
			END AS cardNum,
			ope2.card_cost AS cardCost,
			IFNULL(ope.trade_amount, 0) AS amount,
			IFNULL(ope.refund_amount, 0) AS refundAmount,
			(IFNULL(ope.money, 0) + IFNULL(ope.trade_amount, 0)) AS afterRecharge,
			-- ope.payment_id AS paymentId,
			pay.name AS paymentName,
			ope.price,
			us.name AS opr,
			@@ -292,9 +294,11 @@
			INNER JOIN se_client_card card ON ope.card_id = card.id
			INNER JOIN se_client cli ON ope.client_id = cli.id
			INNER JOIN ba_user us ON ope.operator = us.id
			INNER JOIN se_card_operate ope2 ON ope2.card_id = ope.card_id
			Left JOIN se_payment_method pay ON ope.payment_id = pay.id
			<where>
			AND ope.operate_type in(2, 5)
			AND ope2.operate_type = 1
			<if test = "clientName != null and clientName !=''">
			AND cli.name like CONCAT('%',#{clientName},'%')
			</if>

	pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voSe/VoRecharge.java	6 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	pipIrr-platform/pipIrr-global/src/main/resources/mapper/SeCardOperateMapper.xml	10 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史