Examples with TaxRegisterCertExample com.itrus.portal.db.TaxRegisterCertExample used on opensource projects

Example 1 with TaxRegisterCertExample

use of com.itrus.portal.db.TaxRegisterCertExample in project portal by ixinportal.

the class TaxCertServiceImpl method getTaxRegisterCertsNews2.

/**
 * 查询数据库中是否存在该用户,该企业,未关联订单和增值订单.并且认证通过的信息,按生成时间降序排序
 *
 * @param enterpriseId
 * @return
 */
public TaxRegisterCert getTaxRegisterCertsNews2(Long enterpriseId, Long userinfoId) {
    List<TaxRegisterCert> taxRegisterCerts = new ArrayList<TaxRegisterCert>();
    TaxRegisterCertExample example = new TaxRegisterCertExample();
    example.setOrderByClause("create_time DESC");
    TaxRegisterCertExample.Criteria criteria = example.or();
    criteria.andEnterpriseEqualTo(enterpriseId);
    criteria.andUserInfoEqualTo(userinfoId);
    criteria.andBillIsNull();
    criteria.andExtraBillIsNull();
    taxRegisterCerts = sqlSession.selectList("com.itrus.portal.db.TaxRegisterCertMapper.selectByExample", example);
    if (null == taxRegisterCerts || taxRegisterCerts.isEmpty()) {
        return null;
    }
    return taxRegisterCerts.get(0);
}

Example 2 with TaxRegisterCertExample

use of com.itrus.portal.db.TaxRegisterCertExample in project portal by ixinportal.

the class BillWebController method loadImg.

/**
 * 得到图片
 *
 * @param type
 * @param id
 * @param num
 * @param response
 * @return
 */
@RequestMapping(value = "/img/{type}/{id}/{num}/{eid}")
public String loadImg(@PathVariable("type") int type, @PathVariable("id") Long id, @PathVariable("num") Long num, @PathVariable("eid") Long eid, HttpServletResponse response, HttpServletRequest request) {
    HttpSession session = request.getSession();
    Boolean verifyCodeStatus = (Boolean) session.getAttribute("webverifyCodeStatus");
    UserInfo webuserInfo = (UserInfo) session.getAttribute("webuserInfo");
    Enterprise enterprise = (Enterprise) session.getAttribute("webenterprise");
    if (null == verifyCodeStatus || !verifyCodeStatus || null == webuserInfo || !eid.equals(enterprise.getId())) {
        // 登录状态失效,跳转到登录页面
        return "redirect:/userInfoWeb/denglu.html";
    }
    String img = null;
    Long trueInfo = null;
    Long userid = null;
    UserInfo userInfo = null;
    OutputStream os = null;
    FileInputStream fis = null;
    try {
        response.setHeader("Pragma", "no-cache");
        response.setHeader("Cache-Control", "no-cache");
        response.setDateHeader("Expires", 0);
        if (type == 1) {
            BusinessLicenseExample bl = new BusinessLicenseExample();
            BusinessLicenseExample.Criteria criteria = bl.createCriteria();
            criteria.andIdEqualTo(id);
            BusinessLicense license = sqlSession.selectOne("com.itrus.portal.db.BusinessLicenseMapper.selectByExample", bl);
            if (license == null) {
                return "status403";
            }
            img = license.getImgFile();
            trueInfo = license.getEnterprise();
        } else if (type == 2) {
            OrgCodeExample bl = new OrgCodeExample();
            OrgCodeExample.Criteria criteria = bl.createCriteria();
            criteria.andIdEqualTo(id);
            OrgCode code = sqlSession.selectOne("com.itrus.portal.db.OrgCodeMapper.selectByExample", bl);
            if (code == null) {
                return "status403";
            }
            img = code.getImgFile();
            trueInfo = code.getEnterprise();
        } else if (type == 3) {
            TaxRegisterCertExample bl = new TaxRegisterCertExample();
            TaxRegisterCertExample.Criteria criteria = bl.createCriteria();
            criteria.andIdEqualTo(id);
            TaxRegisterCert cert = sqlSession.selectOne("com.itrus.portal.db.TaxRegisterCertMapper.selectByExample", bl);
            if (cert == null) {
                return "status403";
            }
            img = cert.getImgFile();
            trueInfo = cert.getEnterprise();
        } else if (type == 4) {
            IdentityCardExample bl = new IdentityCardExample();
            IdentityCardExample.Criteria criteria = bl.createCriteria();
            criteria.andIdEqualTo(id);
            IdentityCard card = sqlSession.selectOne("com.itrus.portal.db.IdentityCardMapper.selectByExample", bl);
            if (card == null) {
                return "status403";
            }
            if (num == 0) {
                img = card.getFrontImg();
            } else {
                img = card.getBackImg();
            }
            trueInfo = card.getEnterprise();
        } else if (type == 7) {
            AgentExample bl = new AgentExample();
            AgentExample.Criteria criteria = bl.createCriteria();
            criteria.andIdEqualTo(id);
            Agent at = sqlSession.selectOne("com.itrus.portal.db.AgentMapper.selectByExample", bl);
            if (at == null) {
                return "status403";
            }
            if (num == 0) {
                img = at.getFrontImg();
            } else {
                img = at.getBackImg();
            }
            trueInfo = at.getEnterprise();
        } else if (type == 5) {
            ProxyExample pe = new ProxyExample();
            ProxyExample.Criteria criteria = pe.createCriteria();
            criteria.andIdEqualTo(id);
            Proxy proxy = sqlSession.selectOne("com.itrus.portal.db.ProxyMapper.selectByExample", pe);
            if (proxy == null) {
                return "status403";
            }
            img = proxy.getImgFile();
            userInfo = sqlSession.selectOne("com.itrus.portal.db.UserInfoMapper.selectByPrimaryKey", proxy.getUserInfo());
            trueInfo = proxy.getEnterprise();
        }
        if (img == null || trueInfo == null) {
            return "status403";
        }
        Enterprise info = sqlSession.selectOne("com.itrus.portal.db.EnterpriseMapper.selectByPrimaryKey", trueInfo);
        File file = new File(systemConfigService.getTrustDir().getPath() + File.separator + (type == 5 ? userInfo.getUniqueId() : info.getEnterpriseSn()));
        if (!file.exists()) {
            file.mkdir();
        }
        File imgFile = new File(file, img);
        fis = new FileInputStream(imgFile);
        byte[] bb = IOUtils.toByteArray(fis);
        os = response.getOutputStream();
        os.write(bb);
        os.flush();
    } catch (IOException e) {
        // 未找到
        e.printStackTrace();
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        // 关闭流！
        try {
            if (null != fis) {
                fis.close();
            }
            if (null != os) {
                os.close();
            }
        } catch (IOException e) {
        }
    }
    return null;
}

Example 3 with TaxRegisterCertExample

use of com.itrus.portal.db.TaxRegisterCertExample in project portal by ixinportal.

the class TaxCertServiceImpl method getTaxRegisterCertByExtraBillId.

/**
 * 根据订单id获取订单的税务等级信息
 *
 * @param billId
 * @param itemStatus
 * @return
 */
public TaxRegisterCert getTaxRegisterCertByExtraBillId(Long billId, Integer itemStatus) {
    TaxRegisterCertExample example = new TaxRegisterCertExample();
    TaxRegisterCertExample.Criteria criteria = example.or();
    criteria.andExtraBillEqualTo(billId);
    if (null != itemStatus) {
        criteria.andItemStatusEqualTo(itemStatus);
    }
    return sqlSession.selectOne("com.itrus.portal.db.TaxRegisterCertMapper.selectByExample", example);
}

Example 4 with TaxRegisterCertExample

use of com.itrus.portal.db.TaxRegisterCertExample in project portal by ixinportal.

the class TaxCertServiceImpl method getTaxRegisterCertByBillId.

/**
 * 根据订单id获取订单的税务等级信息
 *
 * @param billId
 * @param itemStatus
 * @return
 */
public TaxRegisterCert getTaxRegisterCertByBillId(Long billId, Integer itemStatus) {
    TaxRegisterCertExample example = new TaxRegisterCertExample();
    TaxRegisterCertExample.Criteria criteria = example.or();
    criteria.andBillEqualTo(billId);
    if (null != itemStatus) {
        criteria.andItemStatusEqualTo(itemStatus);
    }
    return sqlSession.selectOne("com.itrus.portal.db.TaxRegisterCertMapper.selectByExample", example);
}

Example 5 with TaxRegisterCertExample

use of com.itrus.portal.db.TaxRegisterCertExample in project portal by ixinportal.

the class TaxCertServiceImpl method getTaxRegisterCertsNews.

/**
 * 根据企业名称查找税务登记信息,按生成时间降序排序
 *
 * @param enterpriseId
 * @return
 */
public List<TaxRegisterCert> getTaxRegisterCertsNews(Long enterpriseId) {
    List<TaxRegisterCert> taxRegisterCerts = new ArrayList<TaxRegisterCert>();
    TaxRegisterCertExample example = new TaxRegisterCertExample();
    example.setOrderByClause("create_time DESC");
    TaxRegisterCertExample.Criteria criteria = example.or();
    criteria.andEnterpriseEqualTo(enterpriseId);
    taxRegisterCerts = sqlSession.selectList("com.itrus.portal.db.TaxRegisterCertMapper.selectByExample", example);
    return taxRegisterCerts;
}