$sqlstr = "select distinct a.* from {pre}customer a left join {pre}person b on a.id=b.cid where 1=1 "; $industry = getvar('industry'); $managerid = getvar('managerid'); $username = getvar('username'); $username = empty($username) ? $_SESSION['username'] : $username; $userId = getUserIDbyName($username); if (!empty($industry)) { $sqlstr = $sqlstr . " and industry=" . $industry; } if ($managerid == 'public') { $sqlstr = $sqlstr . " and managerid=''"; } elseif ($managerid == 'my') { $sqlstr = $sqlstr . " and managerid='" . $username . "'"; } else { //看所有下属 $sqlstr = $sqlstr . " and managerid in ('" . $username . "'" . getsubmanager($userId) . ")"; //$sqlstr=$sqlstr." and managerid='" . $username . "'"; } $queryname = getvar(queryname); if (!empty($queryname) && $queryname != "可以输入客户|联系人名称、地址、电话和手机或电子邮件来查询") { $sqlstr = $sqlstr . " and (managerid = '" . $queryname . "' or a.name like '%" . $queryname . "%' or a.addr like '%" . $queryname . "%' or a.tel like '%" . $queryname . "%' or a.mobile like '%" . $queryname . "%' or a.qq like '%" . $queryname . "%' or a.email like '%" . $queryname . "%' or b.email like '%" . $queryname . "%' or b.name like '%" . $queryname . "%')"; } $source = getvar("source"); if (!empty($source)) { $sqlstr = $sqlstr . " and (a.source='" . $source . "')"; } $level = getvar("level"); if (!empty($level)) { $sqlstr = $sqlstr . " and (a.level='" . $level . "')"; } $area = getvar("area");
function getsubmanager($mId = 0) { global $db; if ($mId == "") { $mId = 0; } $sqlstr = get_sql("select id,username from {pre}manager where pid=" . $mId . " order by id desc"); //echo $sqlstr; //exit; $s_list = $db->getlist($sqlstr); $tabStr = ""; foreach ($s_list as $vo) { $tabStr = $tabStr . ",'" . $vo['username'] . "'"; $tabStr = $tabStr . getsubmanager($vo['id']); } return $tabStr; }