pipIrr-SV.git - Gitblit

			@@ -344,8 +344,9 @@
			SELECT
			COUNT(*) AS recordCount
			FROM se_client_card card
			INNER JOIN se_client cli ON card.clientId = cli.id
			INNER JOIN se_client cli ON card.clientId = cli.id
			<where>
			AND card.state = 1
			<if test = "clientNum != null and clientNum !=''">
			AND cli.clientNum like CONCAT('%',#{clientNum},'%')
			</if>
			@@ -418,15 +419,14 @@
			SELECT
			cli.clientNum,
			cli.name AS clientName,
			card.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,
			cli.phone,
			cli.idCard,
			card.state AS cardState,
			(CASE
			WHEN card.state = 1 THEN '正常'
			WHEN card.state = 2 THEN '已注销'
			WHEN card.state = 3 THEN '已挂失'
			End) AS stateName,
			'已挂失' AS stateName,
			'农户卡' AS cardType,
			FORMAT(card.money,2) AS money
			FROM se_client_card card

			@@ -173,11 +173,13 @@
			public BaseResponse<QueryResultVo<List<VoCards>>> getUnreplaced(QoCards vo){
			try {
			QueryResultVo<List<VoCards>> res = clientCardSv.getUnreplaced(vo);
			if(res.itemTotal != null && res.itemTotal > 0) {
			return BaseResponseUtils.buildSuccess(res);
			}else {
			return BaseResponseUtils.buildFail(SellResultCode.THE_CARD_NOT_EXIST.getMessage());
			}
			return BaseResponseUtils.buildSuccess(res);

			//if(res.itemTotal != null && res.itemTotal > 0) {
			// return BaseResponseUtils.buildSuccess(res);
			//}else {
			// return BaseResponseUtils.buildFail(SellResultCode.THE_CARD_NOT_EXIST.getMessage());
			//}
			} catch (Exception e) {
			log.error("查询农户异常", e);
			return BaseResponseUtils.buildException(e.getMessage()) ;

	pipIrr-platform/pipIrr-global/src/main/resources/mapper/SeClientCardMapper.xml	14 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	pipIrr-platform/pipIrr-web/pipIrr-web-sell/src/main/java/com/dy/pipIrrSell/clientCard/ClientCardCtrl.java	12 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史