query($sqlStr);
header("Location: ?Keys=" . $keys . "&Page=" . $page);
exit;
}
}
$keys = $_GET['Keys'] ?? '';
$keyscode = textEncode($keys);
$page = $_GET['Page'] ?? '';
$filterCountry = $_GET['fliterCountry'] ?? '';
$filterQudao = $_GET['fliterQudao'] ?? '';
$filterDeal = $_GET['fliterDeal'] ?? '';
$filterBusiness = $_GET['fliterBusiness'] ?? '';
$filterContact = $_GET['fliterContact'] ?? '';
$filterStr = "";
$urlStr = "";
if (!empty($filterCountry)) {
$filterStr .= " AND c.cs_country=" . (int)$filterCountry;
$urlStr .= "&fliterCountry=" . $filterCountry;
}
if (!empty($filterQudao)) {
$filterStr .= " AND c.cs_from=" . (int)$filterQudao;
$urlStr .= "&fliterQudao=" . $filterQudao;
}
if (!empty($filterDeal)) {
$filterStr .= " AND c.cs_deal=" . (int)$filterDeal;
$urlStr .= "&fliterDeal=" . $filterDeal;
}
if (!empty($filterBusiness)) {
$filterStr .= " AND c.cs_type=" . (int)$filterBusiness;
$urlStr .= "&fliterBusiness=" . $filterBusiness;
}
if (!empty($filterContact)) {
switch ($filterContact) {
case "1": $filterStr .= " AND (cc.tel_1 IS NOT NULL AND cc.tel_1 <> '' OR cc.tel_2 IS NOT NULL AND cc.tel_2 <> '' OR cc.tel_3 IS NOT NULL AND cc.tel_3 <> '')"; break;
case "2": $filterStr .= " AND (cc.wechat_1 IS NOT NULL AND cc.wechat_1 <> '' OR cc.wechat_2 IS NOT NULL AND cc.wechat_2 <> '' OR cc.wechat_3 IS NOT NULL AND cc.wechat_3 <> '')"; break;
case "3": $filterStr .= " AND (cc.whatsapp_1 IS NOT NULL AND cc.whatsapp_1 <> '' OR cc.whatsapp_2 IS NOT NULL AND cc.whatsapp_2 <> '' OR cc.whatsapp_3 IS NOT NULL AND cc.whatsapp_3 <> '')"; break;
case "4": $filterStr .= " AND (cc.email_1 IS NOT NULL AND cc.email_1 <> '' OR cc.email_2 IS NOT NULL AND cc.email_2 <> '' OR cc.email_3 IS NOT NULL AND cc.email_3 <> '')"; break;
case "5": $filterStr .= " AND (cc.linkedin_1 IS NOT NULL AND cc.linkedin_1 <> '' OR cc.linkedin_2 IS NOT NULL AND cc.linkedin_2 <> '' OR cc.linkedin_3 IS NOT NULL AND cc.linkedin_3 <> '')"; break;
case "6": $filterStr .= " AND (cc.facebook_1 IS NOT NULL AND cc.facebook_1 <> '' OR cc.facebook_2 IS NOT NULL AND cc.facebook_2 <> '' OR cc.facebook_3 IS NOT NULL AND cc.facebook_3 <> '')"; break;
default: $filterStr .= " AND (cc.alibaba_1 IS NOT NULL AND cc.alibaba_1 <> '' OR cc.alibaba_2 IS NOT NULL AND cc.alibaba_2 <> '' OR cc.alibaba_3 IS NOT NULL AND cc.alibaba_3 <> '')";
}
$urlStr .= "&fliterContact=" . $filterContact;
}
$keys = urlencode($keys);
$hrefstr = "?keys=" . $keys;
?>