mySql查询-系统公告发布接收人情况
-- display_name NZ分部所有用户
SELECT user_code,display_name FROM scy_user WHERE ou_id=1627 AND is_deleted=0
-- NZ第二分部下用户
SELECT user_code,display_name FROM scy_user WHERE ou_id=1629 AND is_deleted=0
-- NZ分部下所有店铺关联职员及关联用户 d.display_name,c.employee_name,a.shop_name,a.shop_code
SELECT d.`user_code`,d.`display_name`,d.`employee_name`,a.`shop_name` FROM bas_shop a
LEFT JOIN
bas_employee_shop b ON a.id = b.shop_id
LEFT JOIN
bas_employee c ON b.employee_id =c.id
LEFT JOIN
scy_user d ON c.id = d.employee_id
WHERE
a.ou_id=1627 AND a.is_deleted=0 AND b.is_deleted=0 AND c.is_deleted=0
SELECT * FROM bas_shop WHERE ou_id=1627 AND is_deleted=0
SELECT * FROM bas_employee_shop WHERE ou_id=1627 AND is_deleted=0
SELECT * FROM bas_employee WHERE is_deleted=0 AND group_id=61
SELECT employee_id FROM scy_user WHERE ou_id=1627 AND is_deleted=0
-- NZ第二分部下所有店铺关联职员及关联用户
SELECT * FROM bas_shop a
LEFT JOIN
bas_employee_shop b ON a.id = b.shop_id
LEFT JOIN
bas_employee c ON b.employee_id =c.id
LEFT JOIN
scy_user d ON c.id = d.employee_id
WHERE
a.ou_id=1629 AND a.is_deleted=0 AND b.is_deleted=0 AND c.is_deleted=0
-- NZ分部下单个店铺关联职员及关联用户
SELECT * FROM bas_shop a
LEFT JOIN
bas_employee_shop b ON a.id = b.shop_id
LEFT JOIN
bas_employee c ON b.employee_id =c.id
LEFT JOIN
scy_user d ON c.id = d.employee_id
WHERE
a.ou_id=1627 AND a.is_deleted=0 AND b.is_deleted=0 AND c.is_deleted=0 AND shop_name='华西总店'
-- NZ分部下所有部门关联职员及关联用户
SELECT a.user_code,a.display_name,a.employee_name,d.dept_name FROM scy_user a
LEFT JOIN
bas_employee b ON a.employee_id = b.id
LEFT JOIN
bas_employee_dept c ON b.id=c.employee_id
LEFT JOIN
bas_dept d ON c.dept_id = d.id
WHERE
a.ou_id=1627 AND a.is_deleted=0
-- NZ第二分部下所有部门关联职员及关联用户
SELECT a.display_name,a.employee_name,d.dept_name FROM scy_user a
LEFT JOIN
bas_employee b ON a.employee_id = b.id
LEFT JOIN
bas_employee_dept c ON b.id=c.employee_id
LEFT JOIN
bas_dept d ON c.dept_id = d.id
WHERE
a.group_id=1629 AND a.is_deleted=0
最新文章
- 用java实现文件下载,提示java.lang.IllegalStateException: getOutputStream() has already been called for this response
- 获取dll中根目录
- 初次学习c语言
- iOS新加速计事件(陀螺仪和加速计)
- ZeroMQ(java)中对IO的封装(StreamEngine)
- mini6410-JNI-led
- ZOJ3554 A Miser Boss(dp)
- Java经典算法四十例编程详解+程序实例
- 【风马一族_xml】xml语法
- 【iOS-Cocos2d游戏开发之四】独自收集Cocos2d提供的字体!共57种(有对照的字体图)
- Altium Designer 14(或者其他版本)里更改PCB板(图纸)大小
- java动态代理和cglib动态代理
- spring定时器的使用
- Java JVM使用哪种编码格式
- mip-link 组件功能升级说明
- Ajax的面试题
- C# -- 使用FileInfo获取文件信息
- Go基础系列:Go接口
- dbc file
- java操作csv文档通用工具类