public static function getByEmployer($userSID, $orderInfo, $score = false, $subuser = false, $limit = false)
{
$order = SJB_Applications::generateOrderAndJoin($orderInfo);
$subuserFilter = '';
if ($subuser !== false) {
$subuserFilter = ' and `l`.`subuser_sid` = ' . SJB_DB::quote($subuser);
}
$limitFilter = '';
if (!empty($limit)) {
$limitFilter = "LIMIT {$limit['startRow']}, {$limit['countRows']}";
}
$scoreFilter['case'] = '';
$scoreFilter['inner_join'] = '';
$scoreFilter['score'] = '';
if (!empty($score)) {
$scoreFilter = self::getScoredApplications($score);
}
$apps = SJB_DB::query("\n\t\t\tSELECT `a`.*\n\t\t\t\t{$scoreFilter['case']}\n\t\t\tFROM\n\t\t\t\t`applications` `a`\n\t\t\tINNER JOIN `listings` l ON\n\t\t\t\t`l`.`sid` = `a`.`listing_id`\n\t\t\t\t{$scoreFilter['inner_join']}\n\t\t\t\t{$order['join']}\n\t\t\tWHERE `l`.`user_sid` = ?s AND `a`.`show_emp` = 1 {$scoreFilter['score']} {$subuserFilter} {$order['order']} {$limitFilter}", $userSID);
return $apps;
}
