packagecom.cwl.datacomparison.dao.hive;importcom.cwl.datacomparison.entity.hive.Lottery;importcom.cwl.datacomparison.vo.sale.audit.DetailParam;importorg.apache.ibatis.annotations.Param;importjava.util.List;/**
* @author ljq
* @date 2020-09-17 15:04
* @describe
*/publicinterfaceHiveMapper{/**
* 根据选项从hive中获取详情信息
* @param detailParam 选择类
* @param provinceId 省份编码
* @return com.cwl.datacomparison.entity.hive.Lottery
*/List<Lottery>getLotteries(@Param(value ="detailParam")DetailParam detailParam,@Param(value ="provinceId")String provinceId);}<?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.cwl.datacomparison.dao.hive.HiveMapper"><select id="getLotteries" resultType="com.cwl.datacomparison.entity.hive.Lottery">
select
<if test="detailParam.ticketNumber == true">
error_lottery_audittime.ticketid as ticketId,</if><if test="detailParam.saleDrawNumber == true">
error_lottery_audittime.sale_saledrawnumber as saleSaleDrawNumber,</if><if test="detailParam.serialNumber == true">
error_lottery_audittime.sale_serialnumber as saleSerialNumber,</if><if test="detailParam.saleTime == true">
error_lottery_audittime.sale_saletime as saleSaleTime,</if><if test="detailParam.saleAmount == true">
error_lottery_audittime.sale_bettotal as saleBetTotal,</if><if test="detailParam.codeAnnotation == true">
error_lottery_audittime.sale_selectiondetail as saleSelectionDetail,</if>case
when error_lottery_audittime.revoke_serialnumber is null then '否'else'是' end as revokeSerialNumber,case
when error_lottery_audittime.restore_serialnumber is null then '否'else'是' end as restoreSerialNumber
from error_lottery_audittime
where error_lottery_audittime.province_id = #{provinceId}
and error_lottery_audittime.game_id = #{detailParam.gameId}<if test="detailParam.gameId != '23004' and detailParam.gameId !='23005'">
and error_lottery_audittime.draw_number = #{detailParam.drawNumber}</if><if test="detailParam.gameId == '23004' or detailParam.gameId =='23005'">
and error_lottery_audittime.sale_saledrawnumber = #{detailParam.drawNumber}</if></select></mapper>
packagecom.cwl.datacomparison.dao.gp;importcom.cwl.datacomparison.entity.Account;/**
* @author ljq
* @date 2020-01-11 11:49
* @describe
*/publicinterfaceAccountMapper{AccountgetAccountByPassword(Account account);booleanupdatePassword(Account account);}<?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.cwl.datacomparison.dao.gp.AccountMapper"><select id="getAccountByPassword" resultType="com.cwl.datacomparison.entity.Account">
select ua.id as id,
ua.username as username,
ua.password as password,
ua.province_id as provinceId,
ua.province_name as provinceName,
ua.role as role
from ud_account ua
where ua.username = #{username}
and ua.password = #{password}</select><update id="updatePassword">
update ud_account
set password = #{password}
where id = #{id}</update></mapper>
packagecom.cwl.datacomparison.dao.phoenix;importcom.cwl.datacomparison.entity.SaleAudit;importorg.apache.ibatis.annotations.Param;/**
* @author ljq
* @date 2020-09-17 16:39
* @describe
*/publicinterfaceHBaseMapper{/**
* 从hbase中获取期号及其销量
*
* @param drawNumber 期号
* @param length 期号长度
* @return com.cwl.datacomparison.entity.SaleAudit
*/SaleAuditgetSaleAudit(@Param(value ="drawNumber")String drawNumber,@Param(value ="length")int length);}<?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.cwl.datacomparison.dao.phoenix.HBaseMapper"><select id="getSaleAudit" resultType="com.cwl.datacomparison.entity.SaleAudit">
select sum(to_number("betTotal")) as "actulSaleTotal", #{drawNumber} as "key"
from "lottery_sales_audit"
where substr("ROW",0, #{length})= #{drawNumber}
and "status"='1'
and ("rvSerialNumber" is null or
("rvSerialNumber" is not null and "rsSerialNumber" is not null and "revokeTime"<"restoreTime"))</select></mapper>