YOS_PRSX/src/custom/restcontroller/webmanage/sale/salearea/SQL/业务员列表查询.sql

select t4.sa_salearea_hrid,
       t4.discountrate,
       t4.iseditprice,
       t1.hrid,
       t1.hrcode,
       t1.name,
       t1.sex,
       t1.phonenumber,
       t1.position,
       t1.email,
       t1.status,
       t5.sa_saleareaid,
       t5.areaname,
       t5.areafullname,
       t2.depname,
       t2.depfullname,
       t3.name as reporthrname,
       t6.userid,
       t6.accountno,
       t1.officetelephone,
       t6.phonenumber userphonenumber
from sys_hr t1
         inner join sys_department t2 on t1.siteid = t2.siteid and t1.departmentid = t2.departmentid
         left join sys_hr t3 on t1.siteid = t3.siteid and t1.reporthrid = t3.hrid
         inner join sa_salearea_hr t4 on t1.siteid = t4.siteid and t1.hrid = t4.hrid
         inner join sa_salearea t5 on t4.siteid = t5.siteid and t4.sa_saleareaid = t5.sa_saleareaid
         left join sys_users t6 on t1.userid = t6.userid
where t1.siteid = $siteid$
  and t5.sa_saleareaid in $sa_saleareaid$ and $where$