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