public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(TempApplicantPeer::ID);
$criteria->addSelectColumn(TempApplicantPeer::TEST_APPLICANT_ID);
$criteria->addSelectColumn(TempApplicantPeer::REG_PERIOD_ID);
$criteria->addSelectColumn(TempApplicantPeer::TEST_SCHEDULE_ID);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(AngketpmbSoalPeer::ID);
$criteria->addSelectColumn(AngketpmbSoalPeer::ORDERING);
$criteria->addSelectColumn(AngketpmbSoalPeer::CODE);
$criteria->addSelectColumn(AngketpmbSoalPeer::TEXT);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(PaisPeer::ID);
$criteria->addSelectColumn(PaisPeer::NOMBRE_LARGO);
$criteria->addSelectColumn(PaisPeer::NOMBRE_CORTO);
$criteria->addSelectColumn(PaisPeer::ORDEN);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(VTestApplicantPeer::ID);
$criteria->addSelectColumn(VTestApplicantPeer::REG_TEST_PERIOD1);
$criteria->addSelectColumn(VTestApplicantPeer::REG_TEST_PERIOD2);
$criteria->addSelectColumn(VTestApplicantPeer::CURRICULUM_ID);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(AccalPeriodPeer::ID);
$criteria->addSelectColumn(AccalPeriodPeer::ACADEMIC_CALENDAR_ID);
$criteria->addSelectColumn(AccalPeriodPeer::MONTH_ID);
$criteria->addSelectColumn(AccalPeriodPeer::YEAR);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(sfGuardRememberKeyPeer::USER_ID);
$criteria->addSelectColumn(sfGuardRememberKeyPeer::REMEMBER_KEY);
$criteria->addSelectColumn(sfGuardRememberKeyPeer::IP_ADDRESS);
$criteria->addSelectColumn(sfGuardRememberKeyPeer::CREATED_AT);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(SubdistrictPeer::ID);
$criteria->addSelectColumn(SubdistrictPeer::NAME);
$criteria->addSelectColumn(SubdistrictPeer::DISTRICT_ID);
$criteria->addSelectColumn(SubdistrictPeer::CREATED);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(CatalogPeer::ID);
$criteria->addSelectColumn(CatalogPeer::CODE);
$criteria->addSelectColumn(CatalogPeer::CAT_LANGUAGE_ID);
$criteria->addSelectColumn(CatalogPeer::CAT_CATEGORY_ID);
$criteria->addSelectColumn(CatalogPeer::CAT_SUBJECT_ID);
$criteria->addSelectColumn(CatalogPeer::TITLE);
$criteria->addSelectColumn(CatalogPeer::SUBTITLE);
$criteria->addSelectColumn(CatalogPeer::PUBLISHER_ID);
$criteria->addSelectColumn(CatalogPeer::PUBLISHED_YEAR);
$criteria->addSelectColumn(CatalogPeer::PUBLISHED_LOCATION);
$criteria->addSelectColumn(CatalogPeer::ISBN);
$criteria->addSelectColumn(CatalogPeer::STUDENT_NO);
$criteria->addSelectColumn(CatalogPeer::STUDENT_NAME);
$criteria->addSelectColumn(CatalogPeer::STUDENT_MAJOR);
$criteria->addSelectColumn(CatalogPeer::STUDENT_TUTOR);
$criteria->addSelectColumn(CatalogPeer::VERSION);
$criteria->addSelectColumn(CatalogPeer::EDITION);
$criteria->addSelectColumn(CatalogPeer::PRINT_NO);
$criteria->addSelectColumn(CatalogPeer::PART);
$criteria->addSelectColumn(CatalogPeer::VOLUME);
$criteria->addSelectColumn(CatalogPeer::MONTH);
$criteria->addSelectColumn(CatalogPeer::YEAR);
$criteria->addSelectColumn(CatalogPeer::NO);
$criteria->addSelectColumn(CatalogPeer::BONUS);
$criteria->addSelectColumn(CatalogPeer::PAGES);
$criteria->addSelectColumn(CatalogPeer::HEIGHT);
$criteria->addSelectColumn(CatalogPeer::SYNOPSIS);
$criteria->addSelectColumn(CatalogPeer::ABSTRACTS);
$criteria->addSelectColumn(CatalogPeer::SEARCH_KEYWORDS);
$criteria->addSelectColumn(CatalogPeer::CREATED_AT);
$criteria->addSelectColumn(CatalogPeer::UPDATED_AT);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(VTotalUploadPeer::EMPLOYEE_ID);
$criteria->addSelectColumn(VTotalUploadPeer::CAT_CATEGORY_ID);
$criteria->addSelectColumn(VTotalUploadPeer::DEPARTMENT_ID);
$criteria->addSelectColumn(VTotalUploadPeer::TOTAL_CATALOG);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(QubitTermI18n::NAME);
$criteria->addSelectColumn(QubitTermI18n::ID);
$criteria->addSelectColumn(QubitTermI18n::CULTURE);
return $criteria;
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(VPayerTypePeer::ID);
$criteria->addSelectColumn(VPayerTypePeer::CODE);
$criteria->addSelectColumn(VPayerTypePeer::DESCRIPTION);
$criteria->addSelectColumn(VPayerTypePeer::PARENT);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(ProductCategoryI18nPeer::NAME);
$criteria->addSelectColumn(ProductCategoryI18nPeer::DESCRIPTION);
$criteria->addSelectColumn(ProductCategoryI18nPeer::ID);
$criteria->addSelectColumn(ProductCategoryI18nPeer::CULTURE);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(EmployeeDivisionPeer::ID);
$criteria->addSelectColumn(EmployeeDivisionPeer::DEPARTMENT_ID);
$criteria->addSelectColumn(EmployeeDivisionPeer::CODE);
$criteria->addSelectColumn(EmployeeDivisionPeer::NAME);
}
function getCalendarBusinessHours($CalendarUid)
{
$Criteria = new Criteria('workflow');
$Criteria->clearSelectColumns();
$Criteria->addSelectColumn(CalendarBusinessHoursPeer::CALENDAR_UID);
$Criteria->addSelectColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_DAY);
$Criteria->addSelectColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_START);
$Criteria->addSelectColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_END);
$Criteria->add(CalendarBusinessHoursPeer::CALENDAR_UID, $CalendarUid, CRITERIA::EQUAL);
$Criteria->addDescendingOrderByColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_DAY);
$Criteria->addAscendingOrderByColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_START);
//$Criteria->addDescendingOrderByColumn ( CalendarBusinessHoursPeer::CALENDAR_BUSINESS_START );
$rs = CalendarBusinessHoursPeer::doSelectRS($Criteria);
$rs->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$rs->next();
$row = $rs->getRow();
$fields = array();
$count = 0;
while (is_array($row)) {
$count++;
$fields[$count] = $row;
$rs->next();
$row = $rs->getRow();
}
return $fields;
}
public static function getEquipmentMileage($userId, $bikeId)
{
$c = new Criteria();
$c->clearSelectColumns();
$c->addSelectColumn('SUM(' . UserStatsPeer::MILEAGE . ')');
$c->addSelectColumn(UserEquipementPeer::EQUIPMENT_ID);
//$c->addGroupByColumn(UserRidesPeer::MILEAGE);
$c->add(UserEquipementPeer::USER_ID, $userId);
$c->add(UserEquipementPeer::BIKE_ID, $bikeId);
$c->addJoin(UserEquipementPeer::EQUIPMENT_ID, UserStatEquipPeer::USER_EQUIP_ID, Criteria::INNER_JOIN);
$c->addJoin(UserStatEquipPeer::USER_STAT_ID, UserStatsPeer::STAT_NO, Criteria::INNER_JOIN);
//$c->addJoin(UserStatsPeer::RIDE_KEY,UserRidesPeer::USER_RIDE_ID, Criteria::INNER_JOIN);
$c->addGroupByColumn(UserEquipementPeer::EQUIPMENT_ID);
$stmt = UserStatsPeer::doSelectStmt($c);
$hashmap = array();
if ($stmt) {
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
if ($row) {
$sum = $row[0];
$eqId = $row[1];
//echo 'Mil '.$sum.' '.$eqId;
$hashmap[$eqId] = $sum;
// array_push($hashmap, $eqId=>$sum);
}
}
}
return $hashmap;
}
public static function getMakeoverEntries($subp_id, $puser_id, $puser_ids)
{
$c = new Criteria();
$c->add(entryPeer::TYPE, entryType::MEDIA_CLIP);
$c->add(entryPeer::STATUS, entryStatus::READY);
$c->addSelectColumn("MAX(" . entryPeer::ID . ")");
$c->addSelectColumn(PuserRolePeer::PUSER_ID);
$c->addGroupByColumn(PuserRolePeer::KSHOW_ID);
$c->addJoin(entryPeer::KSHOW_ID, PuserRolePeer::KSHOW_ID);
$c->add(PuserRolePeer::SUBP_ID, $subp_id);
$c->add(PuserRolePeer::ROLE, PuserRole::PUSER_ROLE_RECIPIENT);
$c->add(PuserRolePeer::PUSER_ID, explode(",", $puser_ids . ',' . $puser_id), Criteria::IN);
$rs = entryPeer::doSelectStmt($c);
$entry_ids = array();
$entry_puser_ids = array();
$res = $rs->fetchAll();
foreach ($res as $record) {
$entry_ids[] = $record[0];
$entry_puser_ids[] = $record[1];
}
// // old code from doSelectRs
// while($rs->next())
// {
// $entry_ids[] = $rs->getInt(1);
// $entry_puser_ids[] = $rs->getString(2);
// }
return array($entry_ids, $entry_puser_ids);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(VTotalMemberPeer::DEPARTMENT_ID);
$criteria->addSelectColumn(VTotalMemberPeer::TYPE);
$criteria->addSelectColumn(VTotalMemberPeer::STATUS);
$criteria->addSelectColumn(VTotalMemberPeer::TOTAL_MEMBER);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(VMemberPeer::ID);
$criteria->addSelectColumn(VMemberPeer::CODE);
$criteria->addSelectColumn(VMemberPeer::NAME);
$criteria->addSelectColumn(VMemberPeer::DEPARTMENT_ID);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(AngketpmbSessionAnswerPeer::ID);
$criteria->addSelectColumn(AngketpmbSessionAnswerPeer::SESSION_ID);
$criteria->addSelectColumn(AngketpmbSessionAnswerPeer::SOAL_ID);
$criteria->addSelectColumn(AngketpmbSessionAnswerPeer::OPTION_ID);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(VStudentTypePeer::ACADEMIC_CALENDAR_ID);
$criteria->addSelectColumn(VStudentTypePeer::PAYER_TYPE_ID);
$criteria->addSelectColumn(VStudentTypePeer::DEPARTMENT_ID);
$criteria->addSelectColumn(VStudentTypePeer::TOTAL_STUDENT);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(Cur13TermSpecPeer::ID);
$criteria->addSelectColumn(Cur13TermSpecPeer::CUR13_TERM_ID);
$criteria->addSelectColumn(Cur13TermSpecPeer::GRADE_SPEC_ID);
$criteria->addSelectColumn(Cur13TermSpecPeer::BOBOT);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(VTotalCollectionPeer::DEPARTMENT_ID);
$criteria->addSelectColumn(VTotalCollectionPeer::COL_LOCATION_ID);
$criteria->addSelectColumn(VTotalCollectionPeer::CAT_CATEGORY_ID);
$criteria->addSelectColumn(VTotalCollectionPeer::TOTAL_COL_ITEM);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(VEmployeeAbsencePeer::ACADEMIC_CALENDAR_ID);
$criteria->addSelectColumn(VEmployeeAbsencePeer::TOTAL_ABSENCE);
$criteria->addSelectColumn(VEmployeeAbsencePeer::DATE);
$criteria->addSelectColumn(VEmployeeAbsencePeer::ID);
}
/**
* Returns the list of updated applications
* array of Entity_AppSolrQueue
*/
public function getListUpdatedApplications()
{
$updatedApplications = array();
try {
$c = new Criteria();
$c->addSelectColumn(AppSolrQueuePeer::APP_UID);
$c->addSelectColumn(AppSolrQueuePeer::APP_UPDATED);
//"WHERE
$c->add(AppSolrQueuePeer::APP_UPDATED, 0, Criteria::NOT_EQUAL);
$rs = AppSolrQueuePeer::doSelectRS($c);
$rs->setFetchmode(ResultSet::FETCHMODE_ASSOC);
//echo $c->toString();
$rs->next();
$row = $rs->getRow();
while (is_array($row)) {
$appSolrQueue = Entity_AppSolrQueue::createEmpty();
$appSolrQueue->appUid = $row['APP_UID'];
$appSolrQueue->appUpdated = $row['APP_UPDATED'];
$updatedApplications[] = $appSolrQueue;
$rs->next();
$row = $rs->getRow();
}
return $updatedApplications;
} catch (Exception $e) {
$con->rollback();
throw $e;
}
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(SubjectCurrPeer::ID);
$criteria->addSelectColumn(SubjectCurrPeer::SUBJECT_ID);
$criteria->addSelectColumn(SubjectCurrPeer::CURRICULUM_ID);
$criteria->addSelectColumn(SubjectCurrPeer::CODE);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(MemberPhotoPeer::ID);
$criteria->addSelectColumn(MemberPhotoPeer::MEMBER_ID);
$criteria->addSelectColumn(MemberPhotoPeer::PHOTO);
$criteria->addSelectColumn(MemberPhotoPeer::THUMBNAIL);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(QubitNoteI18n::CONTENT);
$criteria->addSelectColumn(QubitNoteI18n::ID);
$criteria->addSelectColumn(QubitNoteI18n::CULTURE);
return $criteria;
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(RelevancyPeer::ANSWER_ID);
$criteria->addSelectColumn(RelevancyPeer::USER_ID);
$criteria->addSelectColumn(RelevancyPeer::SCORE);
$criteria->addSelectColumn(RelevancyPeer::CREATED_AT);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(nahoWikiPagePeer::ID);
$criteria->addSelectColumn(nahoWikiPagePeer::WIKI_ID);
$criteria->addSelectColumn(nahoWikiPagePeer::NAME);
$criteria->addSelectColumn(nahoWikiPagePeer::LATEST_REVISION);
}
public static function addSelectColumns(Criteria $criteria)
{
$criteria->addSelectColumn(TestScorePeer::ID);
$criteria->addSelectColumn(TestScorePeer::GRADE);
$criteria->addSelectColumn(TestScorePeer::TEST_APPLICANT_ID);
$criteria->addSelectColumn(TestScorePeer::TEST_SUBJECT_ID);
}
