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