fei.wang
7 天以前 e15f561a1f9eddfde503d59baf45a860b131928e
src/main/java/com/flow/service/impl/CompanyServiceImpl.java
@@ -8,14 +8,22 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.flow.mapper.CompanyMapper;
import com.flow.pojo.Card;
import com.flow.pojo.Company;
import com.flow.mapper.ManagerMapper;
import com.flow.mapper.TbFuwuqiMapper;
import com.flow.pojo.*;
import com.flow.service.CompanyService;
import com.flow.service.OperationLogService;
import com.flow.util.DESUtil;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import java.sql.SQLOutput;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Objects;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -25,14 +33,27 @@
    @Autowired
    CompanyMapper companyMapper;
    @Autowired
    ManagerMapper managerMapper;
    @Autowired
    OperationLogService operationLogService;
    public CompanyServiceImpl() {
    }
    public PageInfo<Company> FindCompany(Integer page, Integer limit) throws Exception {
    public PageInfo<Company> FindCompany(Integer page, Integer limit,String entry) throws Exception {
        PageHelper.startPage(page, limit);
        List<Company> cardList = this.companyMapper.findAllcompany();
        PageInfo<Company> info = new PageInfo(cardList);
        return info;
        if (entry!=null&& entry!=""){
            List<Company> cardList = this.companyMapper.findAllcompany(entry);
            PageInfo<Company> info = new PageInfo(cardList);
            return info;
        }else{
            List<Company> cardList = this.companyMapper.findAllcompany1();
            PageInfo<Company> info = new PageInfo(cardList);
            return info;
        }
    }
    public PageInfo<Company> FindCompanyZi(String Zong, Integer page, Integer limit) throws Exception {
@@ -47,6 +68,12 @@
        queryWrapper.eq("companyId", companyId);
        Company company = new Company();
        company.setNone("1");
        Company company1 = (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper);
        OperationLog operationLog = new OperationLog();
        operationLog.setCaozuotype("删除");
        operationLog.setCaozuocontent("删除公司:"+company1.getCompanyname());
        operationLog.setCaozuoname(company1.getCaozuoname());
        operationLogService.addOperationLog(operationLog);
        return ((CompanyMapper)this.baseMapper).update(company, queryWrapper);
    }
@@ -92,9 +119,20 @@
        company1.setCompanyabbname(company.getCompanyabbname());
        company1.setCompanyname(company.getCompanyname());
        company1.setPhone(DESUtil.encrypt(company.getPhone(), this.key));
        company1.setLoginphone(DESUtil.encrypt(company.getLoginphone(), this.key));
        company1.setAccountbank(DESUtil.encrypt(company.getAccountbank(), this.key));
        company1.setShuinum(DESUtil.encrypt(company.getShuinum(), this.key));
        company1.setPassword(company.getPassword());
        System.out.println(company1);
        OperationLog operationLog = new OperationLog();
        operationLog.setCaozuotype("修改");
        operationLog.setCaozuocontent("修改公司:"+company.getCompanyname());
        operationLog.setCaozuoname(company.getCaozuoname());
        operationLogService.addOperationLog(operationLog);
        Date date = new Date();
        SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        company1.setEnterdate(formatter.format(date));
        return ((CompanyMapper)this.baseMapper).update(company1, queryWrapper);
    }
@@ -108,25 +146,95 @@
        company.setLoginphone(DESUtil.encrypt(company.getLoginphone(), this.key));
        company.setAccountbank(DESUtil.encrypt(company.getAccountbank(), this.key));
        company.setShuinum(DESUtil.encrypt(company.getShuinum(), this.key));
//        Company company1 = (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper);
        OperationLog operationLog = new OperationLog();
        operationLog.setCaozuotype("新增");
        operationLog.setCaozuocontent("新增公司:"+company.getCompanyname());
        operationLog.setCaozuoname(company.getCaozuoname());
        operationLogService.addOperationLog(operationLog);
        Date date = new Date();
        SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        company.setEnterdate(formatter.format(date));
        return ((CompanyMapper)this.baseMapper).insert(company);
    }
    public Company findUser(Company company) {
    public Company findUser(Company compan) throws Exception {
        QueryWrapper queryWrapper = new QueryWrapper();
        if (company.getPassword()!=null){
            queryWrapper.eq("password", company.getPassword());
        if (compan.getPassword()!=null){
            queryWrapper.eq("loginPhone", DESUtil.encrypt(compan.getLoginphone(), DESUtil.key));
            queryWrapper.eq("password", compan.getPassword());
        }else{
            queryWrapper.eq("companyabbName", company.getCompanyabbname());
            queryWrapper.eq("companyabbName", compan.getCompanyabbname());
        }
//        queryWrapper.eq("loginPhone", compan.getLoginphone());
//        Company company1 = new Company();
//        QueryWrapper queryWrapper = new QueryWrapper();
        queryWrapper.eq("none", 0);
        List<Company> company = this.companyMapper.selectList(queryWrapper);
        Company user = new Company();
        user = (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper);
        for (int i = 0; i < company.size(); i++) {
            String loginphone = DESUtil.decrypt(company.get(i).getLoginphone(), DESUtil.key);
//            DESUtil.decrypt(company.get(i).getLoginphone(), DESUtil.key).split(",")
            System.out.println(loginphone.split("[,,]").length);
//            if (loginphone.split(",").length>1) {
            for (int j = 0; j < loginphone.split("[,,]").length; j++) {
                System.out.println( loginphone.split("[,,]")[j]);
                if (Objects.equals(loginphone.split("[,,]")[j], compan.getLoginphone())) {
                    user = company.get(i);
                }
            }
//            }else{
//                if (loginphone.equals(phone)) {
//                    name = company.get(i).getCompanyname();
//                }
//            }
        }
        queryWrapper.eq("loginPhone", company.getLoginphone());
        Company user = (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper);
//        Company user = new Company();
//         user = (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper);
        QueryWrapper queryWrapper1 = new QueryWrapper();
        if (compan.getPassword()!=null){
            queryWrapper1.eq("phone", compan.getLoginphone());
            queryWrapper1.eq("password", compan.getPassword());
        }else{
            queryWrapper1.eq("phone", compan.getLoginphone());
        }
        Manager manager = managerMapper.selectOne(queryWrapper1);
        if (user==null){
            if (manager!=null){
                QueryWrapper queryWrapper2 = new QueryWrapper();
                queryWrapper2.eq("company", "北京华星北斗智控技术有限公司");
                user = (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper2);
                if (manager.getJuese().equals("访客")){
                    user.setRudq("访客");
                }else if (manager.getJuese().equals("普通管理员")){
                    user.setRudq(manager.getJuese()+","+manager.getUadd()+","+manager.getUupdate()+","+manager.getUdelete()+","+manager.getName());
                }else{
                    user.setRudq(manager.getJuese()+","+manager.getUadd()+","+manager.getUupdate()+","+manager.getUdelete()+","+manager.getName()+",");
                }
            }
        }else{
            if (manager!=null){
                user.setRudq(manager.getJuese()+","+manager.getUadd()+","+manager.getUupdate()+","+manager.getUdelete()+","+manager.getName());
            }
        }
        return user;
    }
    public String chaZi(String Zong) throws Exception {
        QueryWrapper queryWrapper = new QueryWrapper();
        queryWrapper.eq("companyname", Zong);
        queryWrapper.eq("companyName", Zong);
        Company company = (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper);
        String zi = company.getCompanyname();
        return zi;
@@ -165,21 +273,62 @@
        return ((CompanyMapper)this.baseMapper).selectList(queryWrapper);
    }
    public Company HuoPhone(Company company) throws Exception {
    public Company HuoPhone(Company compan) throws Exception {
//        QueryWrapper queryWrapper = new QueryWrapper();
        Company company1 = null;
        QueryWrapper queryWrapper = new QueryWrapper();
        queryWrapper.eq("loginPhone", DESUtil.encrypt(company.getLoginphone(), DESUtil.key));
        return (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper);
        queryWrapper.eq("none", 0);
        List<Company> company = this.companyMapper.selectList(queryWrapper);
        for (int i = 0; i < company.size(); i++) {
            String loginphone = DESUtil.decrypt(company.get(i).getLoginphone(), DESUtil.key);
            for (int j = 0; j < loginphone.split("[,,]").length; j++) {
                if (Objects.equals(loginphone.split("[,,]")[j], compan.getLoginphone())) {
//                    Company company1 = new Company();
                    company1 = company.get(i);
                }
            }
        }
//        queryWrapper.eq("loginPhone", DESUtil.encrypt(company.getLoginphone(), DESUtil.key));
//        Company company1=new Company();
//         company1= companyMapper.selectOne(queryWrapper);
        System.out.println(company1);
        if (company1==null){
            Company company2=new Company();
            QueryWrapper queryWrapper1 = new QueryWrapper();
            queryWrapper1.eq("phone", compan.getLoginphone());
            Manager manager = managerMapper.selectOne(queryWrapper1);
            if (manager!=null){
                if (manager.getJuese().equals("访客")){
                    company2.setCompany("访客");
                    company2.setCompanyabbname("访客");
                }else{
                    company2.setCompanyname("北京华星北斗智控技术有限公司");
                    company2.setCompanyabbname("华星智控");
                }
            }
            return company2;
        }else{
            return company1;
        }
//
    }
    public Company findC(String companyName) throws Exception {
        System.out.println(companyName);
        QueryWrapper queryWrapper = new QueryWrapper();
        queryWrapper.eq("company", companyName);
        Company company = (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper);
        System.out.println(company);
        company.setAccount(DESUtil.decrypt(company.getAccount(), DESUtil.key));
        company.setAccountbank(DESUtil.decrypt(company.getAccountbank(), DESUtil.key));
        company.setAddress(DESUtil.decrypt(company.getAddress(), DESUtil.key));
        company.setShuinum(DESUtil.decrypt(company.getShuinum(), DESUtil.key));
        company.setPhone(DESUtil.decrypt(company.getPhone(), DESUtil.key));
        System.out.println(company);
        return company;
    }
@@ -194,4 +343,38 @@
        company.setCompanyname(company.getCompanyname());
        return ((CompanyMapper)this.baseMapper).update(company, queryWrapper);
    }
    public String findcomPnone(String company) throws Exception {
        Company companyList = this.companyMapper.findAllcompanycompany(company);
        return DESUtil.decrypt(companyList.getLoginphone(), DESUtil.key);
    }
    public String findPnone(String phone,String companyId) throws Exception {
        String name = "";
        QueryWrapper queryWrapper = new QueryWrapper();
        if (!Objects.equals(companyId, "")){
            queryWrapper.ne("companyId", companyId);
        }
        queryWrapper.eq("none", 0);
        List<Company> company = this.companyMapper.selectList(queryWrapper);
        for (int i = 0; i < company.size(); i++) {
            String loginphone = DESUtil.decrypt(company.get(i).getLoginphone(), DESUtil.key);
                for (int j = 0; j < loginphone.split("[,,]").length; j++) {
                    if (Objects.equals(loginphone.split("[,,]")[j], phone)) {
                        name = company.get(i).getCompanyname();
                    }
                }
        }
//        Company companyList = this.companyMapper.findAllcompanycompany(company);
        return name;
    }
    public String findCompanyname(String companyname) throws Exception {
        QueryWrapper queryWrapper = new QueryWrapper();
        queryWrapper.eq("companyName", companyname);
        queryWrapper.eq("none", 0);
        Company company = (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper);
//        Company companyList = this.companyMapper.findAllcompanycompany(company);
        return company.getCompanyname();
    }
}