| | |
| | | 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; |
| | | |
| | |
| | | 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 { |
| | |
| | | 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("修改"); |
| | |
| | | return ((CompanyMapper)this.baseMapper).insert(company); |
| | | } |
| | | |
| | | public Company findUser(Company company) throws Exception { |
| | | 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 = new Company(); |
| | | user = (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper); |
| | | // Company user = new Company(); |
| | | // user = (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper); |
| | | QueryWrapper queryWrapper1 = new QueryWrapper(); |
| | | queryWrapper1.eq("phone", DESUtil.decrypt(company.getLoginphone(), DESUtil.key)); |
| | | 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){ |
| | | |
| | |
| | | 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; |
| | |
| | | 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)); |
| | | Company company1=new Company(); |
| | | company1= companyMapper.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", company.getLoginphone()); |
| | | queryWrapper1.eq("phone", compan.getLoginphone()); |
| | | Manager manager = managerMapper.selectOne(queryWrapper1); |
| | | if (manager!=null){ |
| | | if (manager.getJuese().equals("访客")){ |
| | |
| | | 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(); |
| | | } |
| | | } |