Untitled

mail@pastecode.io avatar
unknown
plain_text
2 months ago
1.2 kB
4
Indexable
Never
    $sql_amount = "SELECT follow.cm_id FROM follow WHERE follow.user_id = $user_id AND follow.comp_id = {$_company['comp_id']} AND $query_fl_group follow.fl_date_create BETWEEN '$sdate' AND '$edate' GROUP BY follow.fl_group,follow.user_id,follow.cm_id";
    $sql_tel = "SELECT follow.cm_id FROM follow WHERE follow.user_id = $user_id AND follow.comp_id = {$_company['comp_id']} AND $query_fl_group follow.fl_status = 1 AND follow.fl_date_follow IS NOT NULL AND follow.fl_date_create BETWEEN '$sdate' AND '$edate' GROUP BY follow.fl_group,follow.user_id,follow.cm_id";
    $sql_telnot_call = "SELECT follow.fl_group,follow.user_id,follow.cm_id FROM follow WHERE follow.user_id = $user_id AND follow.comp_id = {$_company['comp_id']} AND $query_fl_group follow.fl_status = 0 AND follow.fl_date_follow IS NULL AND follow.".$date_type." BETWEEN '$sdate' AND '$edate' GROUP BY follow.fl_group,follow.user_id,follow.cm_id";
    $sql_con = "SELECT follow.fl_group,follow.user_id,follow.cm_id FROM follow WHERE follow.flr_id NOT IN ($in_flr_notcontact) AND follow.user_id = $user_id AND follow.comp_id = {$_company['comp_id']} AND $query_fl_group follow.".$date_type." BETWEEN '$sdate' AND '$edate' GROUP BY follow.fl_group,follow.user_id,follow.cm_id";
Leave a Comment