$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;
}
