public function scopes()
{
return array('withActive' => array('condition' => 'is_active = 1', 'order' => 'firstname ASC'), 'withNewHire' => array('condition' => 'DATE_FORMAT(hiredate, "%Y%m") = "' . date('Ym') . '"', 'order' => 'firstname ASC'), 'withNewResign' => array('condition' => 'status = "resign" AND is_active = 0 AND DATE_FORMAT(resigndate, "%Y%m") = "' . date('Ym') . '"', 'order' => 'firstname ASC'), 'getRM' => array('condition' => 'position_id IN (' . MyHelper::getSettingVal('outlet-leader-pos') . ')', 'order' => 'firstname ASC'));
}
