public static function doSelectCounselingTutorsFiltered(Criteria $criteria, $con = null) { $criteria->add(EmployeePeer::STAFF_TYPE_ID, 24, Criteria::IN); $dept = sfContext::getInstance()->getUser()->getAttribute('department', null, 'bo'); $depts = $dept->getChildRecurs(array()); $criteria->add(EmployeePeer::DEPARTMENT_ID, $depts, Criteria::IN); $criteria->addAscendingOrderByColumn(EmployeePeer::EMP_NO); return EmployeePeer::populateObjects(EmployeePeer::doSelectRS($criteria, $con)); }
public static function doSelectComprehensiveReviewersFiltered(Criteria $criteria, $con = null) { $criteria->add(EmployeePeer::IS_COMPREHENSIVE_REVIEWER, '1'); $criteria->add(EmployeePeer::EMP_NO, 'XXXXXX%', Criteria::NOT_LIKE); $dept = sfContext::getInstance()->getUser()->getAttribute('department', null, 'bo'); $depts = $dept->getChildRecurs(array()); $criteria->add(EmployeePeer::DEPARTMENT_ID, $depts, Criteria::IN); $criteria->addAscendingOrderByColumn(EmployeePeer::EMP_NO); return EmployeePeer::populateObjects(EmployeePeer::doSelectRS($criteria, $con)); }
public static function doSelect(Criteria $criteria, $con = null) { return EmployeePeer::populateObjects(EmployeePeer::doSelectRS($criteria, $con)); }