Advertisement
Guest User

Untitled

a guest
Apr 29th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.85 KB | None | 0 0
  1. $criteria = new CDbCriteria();
  2. $criteria->addNotInCondition('name', BasicFunctions::getPremiumPlayerInZone($user->zone));
  3. $criteria->order = BasicFunctions::sortPlayers('premium');
  4. $premiumPlayers = StartPremiumPlayers::model()->findAll($criteria);
  5.  
  6. ...
  7.  
  8.     public static function sortPlayers($type = Players::SORT_BY_POSITION, $premium = null)
  9.     {
  10.         switch ($type) {
  11.             case Players::SORT_BY_NUMBER:
  12.                 $sort = 't.nomer ASC';
  13.                 break;
  14.             default:
  15.                 $pos = array(1, 2, 13, 5, 6, 7, 8, 18, 22, 20, 25, 12, 23, 26);
  16.                 $pos = implode(', ', $pos);
  17.                 $sort = "FIELD(t.pos, {$pos}) ASC, t.name ASC";
  18.  
  19.                 if ($premium) {
  20.                     $sort = "FIELD(t.position, {$pos}), name ASC";
  21.                 }
  22.         }
  23.  
  24.         return $sort;
  25.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement