美文网首页
查询整理

查询整理

作者: phoebe_gyq | 来源:发表于2018-05-20 00:10 被阅读0次

AccountEmployeeRepository

1.select * from account_employee ae where ae.ownerId = ? 判断传入的employee的request是不是存在,不存在创建新的employee,存在的话返回到当前employee下

AdminRepository

1.select a from admin a where a.token=? and a.time(token expire_time)=? 判断某个token是否过期时候用的查询,如果admin不存在就创建一个新admin,如果存在就更新session key

2.select a from admin a where a.token=? and a.role =? 还没用到

3.select a from admin a where a.openId=? 微信服务 通过通过openId获取admin的信息

4.select a from admin a where a.companyId=? 将公司名添加到admin中去

BillSourceWorkRepository

1.select bs.* from bill_source_work bs join account_employee ae on bs.id_account = ae.id where ae.id_owner= ?3 and bs.source_type in ?4 and bs.create_time >= ?1 and bs.create_time <= ?2 limit ?5,?6 还没用到

2.select * from bill_source_work bs where bs.accountId=? and sourceType=? and bs.create_time >= ?1 and bs.create_time <= ?2 limit ?5,?6还没用到

CityRepository

1.select * from city 查找区域信息

EmployeeRepository

1.select * from employee where openId=? 通过openId判断是否存在该employee,如果不存在创建新的employee,如果存在更新该employee的sessin key

2.select * from employee where token =?and time=? 验证权限,通过token过期时间和token判断employee是否存在

3.select * from employee where recommenderId=? limit 通过employee的id找到所有recommendId=该employee的id所有用户,也就是该用户所有发展的下线人员

JobFollowRelationRepository(MongoRepository)

1.db.jobFollowRelation.find({"employeeId":?}) 通过employeeId查找到该 employee 所有收藏的 job,再判断与传入的 jobid 是否相同,相同删去,也就是取消关注收藏的job

JobComplainRepository(MongoRepository)

1.db.jobComplain.find({"status":?,"pageable":?}) // 未应用

JobRepository

3.select * from Job j where j.status=? and j.admin=?

4.select j from Job j where j.status = ?1and j.adminId=2 or j.publisherId=?

5.select * from Job j where j.admin=?

6.select * from Job j where j.id=?

7.select j.* from job j inner join district d on d.id=j.id_district join city c on d.id_city=c.id where j.id_job_type in ?1 and c.id=?2 and job_status=?3 and test=0 order by salary_total desc,start_time limit ?4,?5

8.select j.* from job j inner join district d on d.id=j.id_district join city c on d.id_city=c.id where j.id_job_type in ?1 and c.id=?2 and job_status=?3 and test=0 order by start_time,salary_total desc limit ?4,?5

9.select j.* from job j inner join district d on d.id=j.id_district join city c on d.id_city=c.id where j.id_job_type in ?1 and c.id=?2 and job_status=?3 and test=0 order by j.commission_level1 desc limit ?4,?5

10.select * from Job j where j. districtIds=? and j. status=? and j.test=?

11.select * from Job j where j. districtIds=? and j. status=? and j.test=? and j. jobTypeIds=?

12.select j.* from job j inner join district d on d.id=j.id_district join city c on d.id_city=c.id where c.id=?1 and job_status=?2 and test=0 order by salary_total desc,start_time limit ?3,?4

13.select j.* from job j inner join district d on d.id=j.id_district join city c on d.id_city=c.id where c.id=?1 and job_status=?2 and test=0 order by start_time,salary_total desc limit ?3,?4

14.select j.* from job j inner join district d on d.id=j.id_district join city c on d.id_city=c.id where c.id=?1 and job_status=?2 and test=0 order by j.commission_level1 desc limit ?3,?4

JobTypeRepository

1.select * from Job

2.select * from Job j where j.id=?

RegionRepository

1.select * from Region where cityNum=?

2.select *from Region where id=?

SubscribePrincpleRepository(MongoRepository)

1.db.subscribePrincple.find({"jobSymbole":?,"salary":?,"switchOn":?})

2.db.subscribePrincple.find({"subscriberId":?})

WechatUnifiedOrderRepository

1.select * from WechatPay where id=?

WorksRepository

1.select * from Works w where w.id = ?1

2.select w from Works w where w.id = ?1

3.select * from Works w where w. employeeId = ? and w. jobId=?

4.select * from Works w where w. jobId=?

5.select * from Works w where w. jobId=? and w.status=?

6.select * from Works w where w. employeeId = ? and w. jobId=? and w.status=?

相关文章

  • 查询整理

    AccountEmployeeRepository 1.select * from account_employe...

  • App跳转到系统设置

    ------------------------------------------------整理备用,方便查询...

  • 2021-04-12

    Elasticsearch 提供了丰富的查询过滤语句,本文整理了一些常用的查询方法。 ES 有两种查询方式。本文主...

  • iOS ReactiveCocoa 最全常用API整理(可做为手

    iOS ReactiveCocoa 最全常用API整理(可做为手册查询) GitHub

  • CSS媒体查询

    对css的媒体查询整理了相关内容:

  • mongo使用方法整理

    更新某个string字段整理后改为int类型字段 嵌套查询

  • SQL简单教程

    更多整理资料尽在?[一平米小站](http://yipingmi.top/) 数据库的简单查询 1、最简单查询(查...

  • SQL Server_查询整理

    基于 SQL Server的查询整理! SQL 逻辑流 Select 语法 Select语句的From部分将所有数...

  • Mybatis-Plus查询整理

    1、Hibernate是全ORM(对象关系映射)框架,利用完整的javabean对象与数据库映射结构来自动生成sq...

  • DOM总结

    简单整理一下dom操作,备忘。 查询元素 getElementById()getElementsByClassNa...

网友评论

      本文标题:查询整理

      本文链接:https://www.haomeiwen.com/subject/xqcadftx.html