/**
  * sets the criteria and returns the few columns needed for concept property search results
  *
  * @param Criteria $criteria The Criteria object used to build the SELECT statement.
  * @param Connection $con
  * @return array Array of selected Objects
  * @throws PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function doSelectSearchResults(Criteria $c, $con = null)
 {
     $c = clone $c;
     $c->clearSelectColumns();
     $c->addSelectColumn(ConceptPropertyPeer::ID);
     $c->addSelectColumn(ConceptPropertyPeer::LANGUAGE);
     $c->addSelectColumn(ConceptPropertyPeer::OBJECT);
     $c->addSelectColumn(ConceptPropertyPeer::SKOS_PROPERTY_ID);
     $c->addSelectColumn(ConceptPeer::ID);
     $c->addSelectColumn(ConceptPeer::PREF_LABEL);
     $c->addSelectColumn(ConceptPeer::VOCABULARY_ID);
     $c->addSelectColumn(VocabularyPeer::NAME);
     $c->addSelectColumn(SkosPropertyPeer::LABEL);
     $c->addJoin(ConceptPeer::VOCABULARY_ID, VocabularyPeer::ID);
     $c->addJoin(ConceptPropertyPeer::CONCEPT_ID, ConceptPeer::ID);
     $c->addJoin(ConceptPropertyPeer::SKOS_PROPERTY_ID, SkosPropertyPeer::ID);
     //populateObjects(ResultSet $rs)
     $rs = self::doSelectRS($c);
     $results = array();
     // set the class once to avoid overhead in the loop
     $cls = self::getOMClass();
     $cls = Propel::import($cls);
     // populate the object(s)
     while ($rs->next()) {
         $startcol = 1;
         $obj = new $cls();
         try {
             $obj->setId($rs->getInt($startcol + 0));
             $obj->setLanguage($rs->getString($startcol + 1));
             $obj->setObject($rs->getString($startcol + 2));
             $obj->setSkosPropertyId($rs->getInt($startcol + 3));
             $obj->setConceptId($rs->getInt($startcol + 4));
             $obj->setConceptPrefLabel($rs->getString($startcol + 5));
             $obj->setVocabularyId($rs->getInt($startcol + 6));
             $obj->setVocabularyName($rs->getString($startcol + 7));
             $obj->setSkosPropertyName($rs->getString($startcol + 8));
         } catch (Exception $e) {
             throw new PropelException("Error populating Concept Search Results", $e);
         }
         $results[] = $obj;
     }
     //while($rs->next())
     return $results;
 }
예제 #2
0
 public static function doSelectWithI18n(Criteria $c, $culture = null, $con = null)
 {
     if ($culture === null) {
         $culture = sfPropel::getDefaultCulture();
     }
     foreach (sfMixer::getCallables('BaseFakeForumPeer:doSelectJoin:doSelectJoin') as $callable) {
         call_user_func($callable, 'BaseFakeForumPeer', $c, $con);
     }
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     FakeForumPeer::addSelectColumns($c);
     $startcol = FakeForumPeer::NUM_COLUMNS - FakeForumPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     FakeForumI18nPeer::addSelectColumns($c);
     $c->addJoin(FakeForumPeer::ID, FakeForumI18nPeer::ID);
     $c->add(FakeForumI18nPeer::CULTURE, $culture);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = FakeForumPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $obj1->setCulture($culture);
         $omClass = FakeForumI18nPeer::getOMClass($rs, $startcol);
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol);
         $obj1->setFakeForumI18nForCulture($obj2, $culture);
         $obj2->setFakeForum($obj1);
         $results[] = $obj1;
     }
     return $results;
 }
 /**
  * The returned array will contain objects of the default type or
  * objects that inherit from the default.
  *
  * @throws     PropelException Any exceptions caught during processing will be
  *       rethrown wrapped into a PropelException.
  */
 public static function populateObjects(ResultSet $rs)
 {
     $results = array();
     // set the class once to avoid overhead in the loop
     $cls = BpmnProjectPeer::getOMClass();
     $cls = Propel::import($cls);
     // populate the object(s)
     while ($rs->next()) {
         $obj = new $cls();
         $obj->hydrate($rs);
         $results[] = $obj;
     }
     return $results;
 }
 public static function doSelectJoinAllExceptCampus(Criteria $c, $con = null)
 {
     foreach (sfMixer::getCallables('BaseProjectApplicationPeer:doSelectJoinAllExcept:doSelectJoinAllExcept') as $callable) {
         call_user_func($callable, 'BaseProjectApplicationPeer', $c, $con);
     }
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     ProjectApplicationPeer::addSelectColumns($c);
     $startcol2 = ProjectApplicationPeer::NUM_COLUMNS - ProjectApplicationPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     sfGuardUserPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + sfGuardUserPeer::NUM_COLUMNS;
     sfGuardUserPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + sfGuardUserPeer::NUM_COLUMNS;
     DepartmentPeer::addSelectColumns($c);
     $startcol5 = $startcol4 + DepartmentPeer::NUM_COLUMNS;
     $c->addJoin(ProjectApplicationPeer::CREATED_BY, sfGuardUserPeer::ID);
     $c->addJoin(ProjectApplicationPeer::OWNER_ID, sfGuardUserPeer::ID);
     $c->addJoin(ProjectApplicationPeer::DEPARTMENT_ID, DepartmentPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = ProjectApplicationPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = sfGuardUserPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getsfGuardUserRelatedByCreatedBy();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addProjectApplicationRelatedByCreatedBy($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initProjectApplicationsRelatedByCreatedBy();
             $obj2->addProjectApplicationRelatedByCreatedBy($obj1);
         }
         $omClass = sfGuardUserPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getsfGuardUserRelatedByOwnerId();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addProjectApplicationRelatedByOwnerId($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initProjectApplicationsRelatedByOwnerId();
             $obj3->addProjectApplicationRelatedByOwnerId($obj1);
         }
         $omClass = DepartmentPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj4 = new $cls();
         $obj4->hydrate($rs, $startcol4);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj4 = $temp_obj1->getDepartment();
             if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj4->addProjectApplication($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj4->initProjectApplications();
             $obj4->addProjectApplication($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #5
0
 public static function doSelectJoinAll(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     SmCheckPeer::addSelectColumns($c);
     $startcol2 = SmCheckPeer::NUM_COLUMNS - SmCheckPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     SmTemplatePeer::addSelectColumns($c);
     $startcol3 = $startcol2 + SmTemplatePeer::NUM_COLUMNS;
     $c->addJoin(SmCheckPeer::SM_TEMPLATE_ID, SmTemplatePeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = SmCheckPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = SmTemplatePeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getSmTemplate();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addSmCheck($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initSmChecks();
             $obj2->addSmCheck($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #6
0
 public static function doSelectJoinAllExceptEmployeeDivision(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     EmployeeDetailPeer::addSelectColumns($c);
     $startcol2 = EmployeeDetailPeer::NUM_COLUMNS - EmployeeDetailPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     EmployeePeer::addSelectColumns($c);
     $startcol3 = $startcol2 + EmployeePeer::NUM_COLUMNS;
     ReligionPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + ReligionPeer::NUM_COLUMNS;
     ReligionPeer::addSelectColumns($c);
     $startcol5 = $startcol4 + ReligionPeer::NUM_COLUMNS;
     EmployeeLevelPeer::addSelectColumns($c);
     $startcol6 = $startcol5 + EmployeeLevelPeer::NUM_COLUMNS;
     MaritalStatusPeer::addSelectColumns($c);
     $startcol7 = $startcol6 + MaritalStatusPeer::NUM_COLUMNS;
     $c->addJoin(EmployeeDetailPeer::EMPLOYEE_ID, EmployeePeer::ID);
     $c->addJoin(EmployeeDetailPeer::RELIGION_ID, ReligionPeer::ID);
     $c->addJoin(EmployeeDetailPeer::SPOUSE_RELIGION_ID, ReligionPeer::ID);
     $c->addJoin(EmployeeDetailPeer::EMPLOYEE_LEVEL_ID, EmployeeLevelPeer::ID);
     $c->addJoin(EmployeeDetailPeer::MARITAL_STATUS_ID, MaritalStatusPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = EmployeeDetailPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = EmployeePeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getEmployee();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addEmployeeDetail($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initEmployeeDetails();
             $obj2->addEmployeeDetail($obj1);
         }
         $omClass = ReligionPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getReligionRelatedByReligionId();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addEmployeeDetailRelatedByReligionId($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initEmployeeDetailsRelatedByReligionId();
             $obj3->addEmployeeDetailRelatedByReligionId($obj1);
         }
         $omClass = ReligionPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj4 = new $cls();
         $obj4->hydrate($rs, $startcol4);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj4 = $temp_obj1->getReligionRelatedBySpouseReligionId();
             if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj4->addEmployeeDetailRelatedBySpouseReligionId($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj4->initEmployeeDetailsRelatedBySpouseReligionId();
             $obj4->addEmployeeDetailRelatedBySpouseReligionId($obj1);
         }
         $omClass = EmployeeLevelPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj5 = new $cls();
         $obj5->hydrate($rs, $startcol5);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj5 = $temp_obj1->getEmployeeLevel();
             if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj5->addEmployeeDetail($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj5->initEmployeeDetails();
             $obj5->addEmployeeDetail($obj1);
         }
         $omClass = MaritalStatusPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj6 = new $cls();
         $obj6->hydrate($rs, $startcol6);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj6 = $temp_obj1->getMaritalStatus();
             if ($temp_obj6->getPrimaryKey() === $obj6->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj6->addEmployeeDetail($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj6->initEmployeeDetails();
             $obj6->addEmployeeDetail($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #7
0
 public static function doSelectJoinAllExceptColLocation(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     VOpacPeer::addSelectColumns($c);
     $startcol2 = VOpacPeer::NUM_COLUMNS - VOpacPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     CatalogPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + CatalogPeer::NUM_COLUMNS;
     DepartmentPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + DepartmentPeer::NUM_COLUMNS;
     CatCategoryPeer::addSelectColumns($c);
     $startcol5 = $startcol4 + CatCategoryPeer::NUM_COLUMNS;
     ColStatusPeer::addSelectColumns($c);
     $startcol6 = $startcol5 + ColStatusPeer::NUM_COLUMNS;
     $c->addJoin(VOpacPeer::CATALOG_ID, CatalogPeer::ID);
     $c->addJoin(VOpacPeer::DEPARTMENT_ID, DepartmentPeer::ID);
     $c->addJoin(VOpacPeer::CAT_CATEGORY_ID, CatCategoryPeer::ID);
     $c->addJoin(VOpacPeer::COL_STATUS_ID, ColStatusPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = VOpacPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = CatalogPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getCatalog();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addVOpac($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initVOpacs();
             $obj2->addVOpac($obj1);
         }
         $omClass = DepartmentPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getDepartment();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addVOpac($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initVOpacs();
             $obj3->addVOpac($obj1);
         }
         $omClass = CatCategoryPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj4 = new $cls();
         $obj4->hydrate($rs, $startcol4);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj4 = $temp_obj1->getCatCategory();
             if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj4->addVOpac($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj4->initVOpacs();
             $obj4->addVOpac($obj1);
         }
         $omClass = ColStatusPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj5 = new $cls();
         $obj5->hydrate($rs, $startcol5);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj5 = $temp_obj1->getColStatus();
             if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj5->addVOpac($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj5->initVOpacs();
             $obj5->addVOpac($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
 public static function doSelectJoinAllExceptTalent(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     TestApplicantAchievementPeer::addSelectColumns($c);
     $startcol2 = TestApplicantAchievementPeer::NUM_COLUMNS - TestApplicantAchievementPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     TestApplicantPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + TestApplicantPeer::NUM_COLUMNS;
     $c->addJoin(TestApplicantAchievementPeer::TEST_APPLICANT_ID, TestApplicantPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = TestApplicantAchievementPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = TestApplicantPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getTestApplicant();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addTestApplicantAchievement($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initTestApplicantAchievements();
             $obj2->addTestApplicantAchievement($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #9
0
 public static function doSelectJoinAllExceptDepartment(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     CirRegulationPeer::addSelectColumns($c);
     $startcol2 = CirRegulationPeer::NUM_COLUMNS - CirRegulationPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     MemberTypePeer::addSelectColumns($c);
     $startcol3 = $startcol2 + MemberTypePeer::NUM_COLUMNS;
     CatCategoryPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + CatCategoryPeer::NUM_COLUMNS;
     $c->addJoin(CirRegulationPeer::MEMBER_TYPE_ID, MemberTypePeer::ID);
     $c->addJoin(CirRegulationPeer::CAT_CATEGORY_ID, CatCategoryPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = CirRegulationPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = MemberTypePeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getMemberType();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addCirRegulation($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initCirRegulations();
             $obj2->addCirRegulation($obj1);
         }
         $omClass = CatCategoryPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getCatCategory();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addCirRegulation($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initCirRegulations();
             $obj3->addCirRegulation($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #10
0
 public static function doSelectJoinAllExceptDepartment(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     VAcademicCalendarPeer::addSelectColumns($c);
     $startcol2 = VAcademicCalendarPeer::NUM_COLUMNS - VAcademicCalendarPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     AcademicCalendarPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + AcademicCalendarPeer::NUM_COLUMNS;
     CurriculumPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + CurriculumPeer::NUM_COLUMNS;
     ClassGroupPeer::addSelectColumns($c);
     $startcol5 = $startcol4 + ClassGroupPeer::NUM_COLUMNS;
     CurrSystemPeer::addSelectColumns($c);
     $startcol6 = $startcol5 + CurrSystemPeer::NUM_COLUMNS;
     $c->addJoin(VAcademicCalendarPeer::PARENT, AcademicCalendarPeer::ID);
     $c->addJoin(VAcademicCalendarPeer::CURRICULUM_ID, CurriculumPeer::ID);
     $c->addJoin(VAcademicCalendarPeer::CLASS_GROUP_ID, ClassGroupPeer::ID);
     $c->addJoin(VAcademicCalendarPeer::CURR_SYSTEM_ID, CurrSystemPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = VAcademicCalendarPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = AcademicCalendarPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getAcademicCalendar();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addVAcademicCalendar($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initVAcademicCalendars();
             $obj2->addVAcademicCalendar($obj1);
         }
         $omClass = CurriculumPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getCurriculum();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addVAcademicCalendar($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initVAcademicCalendars();
             $obj3->addVAcademicCalendar($obj1);
         }
         $omClass = ClassGroupPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj4 = new $cls();
         $obj4->hydrate($rs, $startcol4);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj4 = $temp_obj1->getClassGroup();
             if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj4->addVAcademicCalendar($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj4->initVAcademicCalendars();
             $obj4->addVAcademicCalendar($obj1);
         }
         $omClass = CurrSystemPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj5 = new $cls();
         $obj5->hydrate($rs, $startcol5);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj5 = $temp_obj1->getCurrSystem();
             if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj5->addVAcademicCalendar($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj5->initVAcademicCalendars();
             $obj5->addVAcademicCalendar($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #11
0
 public static function doSelectJoinAllExceptEmployee(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     AbsenceEkskulPeer::addSelectColumns($c);
     $startcol2 = AbsenceEkskulPeer::NUM_COLUMNS - AbsenceEkskulPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     StudentPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + StudentPeer::NUM_COLUMNS;
     AcademicCalendarPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + AcademicCalendarPeer::NUM_COLUMNS;
     ClassGroupPeer::addSelectColumns($c);
     $startcol5 = $startcol4 + ClassGroupPeer::NUM_COLUMNS;
     SchedulePeer::addSelectColumns($c);
     $startcol6 = $startcol5 + SchedulePeer::NUM_COLUMNS;
     ScheduleDetailPeer::addSelectColumns($c);
     $startcol7 = $startcol6 + ScheduleDetailPeer::NUM_COLUMNS;
     GradeComponentPeer::addSelectColumns($c);
     $startcol8 = $startcol7 + GradeComponentPeer::NUM_COLUMNS;
     $c->addJoin(AbsenceEkskulPeer::STUDENT_ID, StudentPeer::ID);
     $c->addJoin(AbsenceEkskulPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID);
     $c->addJoin(AbsenceEkskulPeer::CLASS_GROUP_ID, ClassGroupPeer::ID);
     $c->addJoin(AbsenceEkskulPeer::SCHEDULE_ID, SchedulePeer::ID);
     $c->addJoin(AbsenceEkskulPeer::SCHEDULE_DETAIL_ID, ScheduleDetailPeer::ID);
     $c->addJoin(AbsenceEkskulPeer::GRADE_COMPONENT_ID, GradeComponentPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = AbsenceEkskulPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = StudentPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getStudent();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addAbsenceEkskul($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initAbsenceEkskuls();
             $obj2->addAbsenceEkskul($obj1);
         }
         $omClass = AcademicCalendarPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getAcademicCalendar();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addAbsenceEkskul($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initAbsenceEkskuls();
             $obj3->addAbsenceEkskul($obj1);
         }
         $omClass = ClassGroupPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj4 = new $cls();
         $obj4->hydrate($rs, $startcol4);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj4 = $temp_obj1->getClassGroup();
             if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj4->addAbsenceEkskul($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj4->initAbsenceEkskuls();
             $obj4->addAbsenceEkskul($obj1);
         }
         $omClass = SchedulePeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj5 = new $cls();
         $obj5->hydrate($rs, $startcol5);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj5 = $temp_obj1->getSchedule();
             if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj5->addAbsenceEkskul($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj5->initAbsenceEkskuls();
             $obj5->addAbsenceEkskul($obj1);
         }
         $omClass = ScheduleDetailPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj6 = new $cls();
         $obj6->hydrate($rs, $startcol6);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj6 = $temp_obj1->getScheduleDetail();
             if ($temp_obj6->getPrimaryKey() === $obj6->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj6->addAbsenceEkskul($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj6->initAbsenceEkskuls();
             $obj6->addAbsenceEkskul($obj1);
         }
         $omClass = GradeComponentPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj7 = new $cls();
         $obj7->hydrate($rs, $startcol7);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj7 = $temp_obj1->getGradeComponent();
             if ($temp_obj7->getPrimaryKey() === $obj7->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj7->addAbsenceEkskul($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj7->initAbsenceEkskuls();
             $obj7->addAbsenceEkskul($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #12
0
 public static function doSelectJoinAllExceptStudentDetail(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     VMemberStudentPeer::addSelectColumns($c);
     $startcol2 = VMemberStudentPeer::NUM_COLUMNS - VMemberStudentPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     MemberDetailPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + MemberDetailPeer::NUM_COLUMNS;
     DepartmentPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + DepartmentPeer::NUM_COLUMNS;
     AcademicCalendarPeer::addSelectColumns($c);
     $startcol5 = $startcol4 + AcademicCalendarPeer::NUM_COLUMNS;
     ClassGroupPeer::addSelectColumns($c);
     $startcol6 = $startcol5 + ClassGroupPeer::NUM_COLUMNS;
     StudentPeer::addSelectColumns($c);
     $startcol7 = $startcol6 + StudentPeer::NUM_COLUMNS;
     $c->addJoin(VMemberStudentPeer::MEMBER_DETAIL_ID, MemberDetailPeer::ID);
     $c->addJoin(VMemberStudentPeer::DEPARTMENT_ID, DepartmentPeer::ID);
     $c->addJoin(VMemberStudentPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID);
     $c->addJoin(VMemberStudentPeer::CLASS_GROUP_ID, ClassGroupPeer::ID);
     $c->addJoin(VMemberStudentPeer::STUDENT_ID, StudentPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = VMemberStudentPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = MemberDetailPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getMemberDetail();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addVMemberStudent($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initVMemberStudents();
             $obj2->addVMemberStudent($obj1);
         }
         $omClass = DepartmentPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getDepartment();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addVMemberStudent($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initVMemberStudents();
             $obj3->addVMemberStudent($obj1);
         }
         $omClass = AcademicCalendarPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj4 = new $cls();
         $obj4->hydrate($rs, $startcol4);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj4 = $temp_obj1->getAcademicCalendar();
             if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj4->addVMemberStudent($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj4->initVMemberStudents();
             $obj4->addVMemberStudent($obj1);
         }
         $omClass = ClassGroupPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj5 = new $cls();
         $obj5->hydrate($rs, $startcol5);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj5 = $temp_obj1->getClassGroup();
             if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj5->addVMemberStudent($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj5->initVMemberStudents();
             $obj5->addVMemberStudent($obj1);
         }
         $omClass = StudentPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj6 = new $cls();
         $obj6->hydrate($rs, $startcol6);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj6 = $temp_obj1->getStudent();
             if ($temp_obj6->getPrimaryKey() === $obj6->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj6->addVMemberStudent($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj6->initVMemberStudents();
             $obj6->addVMemberStudent($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #13
0
 public static function doSelectJoinAllExceptDepartment(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     ColLocationPeer::addSelectColumns($c);
     $startcol2 = ColLocationPeer::NUM_COLUMNS - ColLocationPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = ColLocationPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $results[] = $obj1;
     }
     return $results;
 }
예제 #14
0
 public static function doSelectJoinAllExceptLocation(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     NgTestSchedulePeer::addSelectColumns($c);
     $startcol2 = NgTestSchedulePeer::NUM_COLUMNS - NgTestSchedulePeer::NUM_LAZY_LOAD_COLUMNS + 1;
     NgRegTestPeriodPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + NgRegTestPeriodPeer::NUM_COLUMNS;
     $c->addJoin(NgTestSchedulePeer::NG_REG_TEST_PERIOD_ID, NgRegTestPeriodPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = NgTestSchedulePeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = NgRegTestPeriodPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getNgRegTestPeriod();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addNgTestSchedule($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initNgTestSchedules();
             $obj2->addNgTestSchedule($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #15
0
 public static function doSelectJoinAllExceptCountry(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     TestApplicantDetailPeer::addSelectColumns($c);
     $startcol2 = TestApplicantDetailPeer::NUM_COLUMNS - TestApplicantDetailPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     RegionPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + RegionPeer::NUM_COLUMNS;
     ReligionPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + ReligionPeer::NUM_COLUMNS;
     AcademicCalendarPeer::addSelectColumns($c);
     $startcol5 = $startcol4 + AcademicCalendarPeer::NUM_COLUMNS;
     $c->addJoin(TestApplicantDetailPeer::REGION_ID, RegionPeer::ID);
     $c->addJoin(TestApplicantDetailPeer::RELIGION_ID, ReligionPeer::ID);
     $c->addJoin(TestApplicantDetailPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = TestApplicantDetailPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = RegionPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getRegion();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addTestApplicantDetail($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initTestApplicantDetails();
             $obj2->addTestApplicantDetail($obj1);
         }
         $omClass = ReligionPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getReligion();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addTestApplicantDetail($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initTestApplicantDetails();
             $obj3->addTestApplicantDetail($obj1);
         }
         $omClass = AcademicCalendarPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj4 = new $cls();
         $obj4->hydrate($rs, $startcol4);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj4 = $temp_obj1->getAcademicCalendar();
             if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj4->addTestApplicantDetail($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj4->initTestApplicantDetails();
             $obj4->addTestApplicantDetail($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #16
0
 public static function doSelectJoinAllExceptAcademicCost(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     PaymentHistoryPeer::addSelectColumns($c);
     $startcol2 = PaymentHistoryPeer::NUM_COLUMNS - PaymentHistoryPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     PaymentJournalPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + PaymentJournalPeer::NUM_COLUMNS;
     $c->addJoin(PaymentHistoryPeer::PAYMENT_JOURNAL_ID, PaymentJournalPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = PaymentHistoryPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = PaymentJournalPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getPaymentJournal();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addPaymentHistory($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initPaymentHistorys();
             $obj2->addPaymentHistory($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #17
0
 public static function doSelectJoinAllExceptCourseSchedule(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     CourseScheduleTutorPeer::addSelectColumns($c);
     $startcol2 = CourseScheduleTutorPeer::NUM_COLUMNS - CourseScheduleTutorPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     EmployeePeer::addSelectColumns($c);
     $startcol3 = $startcol2 + EmployeePeer::NUM_COLUMNS;
     $c->addJoin(CourseScheduleTutorPeer::EMPLOYEE_ID, EmployeePeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = CourseScheduleTutorPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = EmployeePeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getEmployee();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addCourseScheduleTutor($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initCourseScheduleTutors();
             $obj2->addCourseScheduleTutor($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #18
0
 public static function doSelectJoinAllExceptAcademicCalendar(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     VStudentCoursePeer::addSelectColumns($c);
     $startcol2 = VStudentCoursePeer::NUM_COLUMNS - VStudentCoursePeer::NUM_LAZY_LOAD_COLUMNS + 1;
     StudentPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + StudentPeer::NUM_COLUMNS;
     SubjectAccalPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + SubjectAccalPeer::NUM_COLUMNS;
     SubjectCurrPeer::addSelectColumns($c);
     $startcol5 = $startcol4 + SubjectCurrPeer::NUM_COLUMNS;
     ClassGroupPeer::addSelectColumns($c);
     $startcol6 = $startcol5 + ClassGroupPeer::NUM_COLUMNS;
     $c->addJoin(VStudentCoursePeer::STUDENT_ID, StudentPeer::ID);
     $c->addJoin(VStudentCoursePeer::SUBJECT_ACCAL_ID, SubjectAccalPeer::ID);
     $c->addJoin(VStudentCoursePeer::SUBJECT_CURR_ID, SubjectCurrPeer::ID);
     $c->addJoin(VStudentCoursePeer::CLASS_GROUP_ID, ClassGroupPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = VStudentCoursePeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = StudentPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getStudent();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addVStudentCourse($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initVStudentCourses();
             $obj2->addVStudentCourse($obj1);
         }
         $omClass = SubjectAccalPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getSubjectAccal();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addVStudentCourse($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initVStudentCourses();
             $obj3->addVStudentCourse($obj1);
         }
         $omClass = SubjectCurrPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj4 = new $cls();
         $obj4->hydrate($rs, $startcol4);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj4 = $temp_obj1->getSubjectCurr();
             if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj4->addVStudentCourse($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj4->initVStudentCourses();
             $obj4->addVStudentCourse($obj1);
         }
         $omClass = ClassGroupPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj5 = new $cls();
         $obj5->hydrate($rs, $startcol5);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj5 = $temp_obj1->getClassGroup();
             if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj5->addVStudentCourse($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj5->initVStudentCourses();
             $obj5->addVStudentCourse($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #19
0
 public static function doSelectJoinAllExceptUser(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     AnswerPeer::addSelectColumns($c);
     $startcol2 = AnswerPeer::NUM_COLUMNS - AnswerPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     QuestionPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + QuestionPeer::NUM_COLUMNS;
     $c->addJoin(AnswerPeer::QUESTION_ID, QuestionPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = AnswerPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = QuestionPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getQuestion();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addAnswer($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initAnswers();
             $obj2->addAnswer($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #20
0
 public static function doSelectJoinAllExceptCurriculum(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     VTestApplicantPeer::addSelectColumns($c);
     $startcol2 = VTestApplicantPeer::NUM_COLUMNS - VTestApplicantPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     RegTestPeriodPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + RegTestPeriodPeer::NUM_COLUMNS;
     RegTestPeriodPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + RegTestPeriodPeer::NUM_COLUMNS;
     $c->addJoin(VTestApplicantPeer::REG_TEST_PERIOD1, RegTestPeriodPeer::ID);
     $c->addJoin(VTestApplicantPeer::REG_TEST_PERIOD2, RegTestPeriodPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = VTestApplicantPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = RegTestPeriodPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getRegTestPeriodRelatedByRegTestPeriod1();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addVTestApplicantRelatedByRegTestPeriod1($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initVTestApplicantsRelatedByRegTestPeriod1();
             $obj2->addVTestApplicantRelatedByRegTestPeriod1($obj1);
         }
         $omClass = RegTestPeriodPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getRegTestPeriodRelatedByRegTestPeriod2();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addVTestApplicantRelatedByRegTestPeriod2($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initVTestApplicantsRelatedByRegTestPeriod2();
             $obj3->addVTestApplicantRelatedByRegTestPeriod2($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #21
0
 public static function doSelectJoinAllExceptMonth(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     AccalPeriodPeer::addSelectColumns($c);
     $startcol2 = AccalPeriodPeer::NUM_COLUMNS - AccalPeriodPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     AcademicCalendarPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + AcademicCalendarPeer::NUM_COLUMNS;
     $c->addJoin(AccalPeriodPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = AccalPeriodPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = AcademicCalendarPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getAcademicCalendar();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addAccalPeriod($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initAccalPeriods();
             $obj2->addAccalPeriod($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
 public static function doSelectJoinAllExceptAcademicCalendar(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     ExpenditureJournalTaPeer::addSelectColumns($c);
     $startcol2 = ExpenditureJournalTaPeer::NUM_COLUMNS - ExpenditureJournalTaPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     BankAccountPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + BankAccountPeer::NUM_COLUMNS;
     $c->addJoin(ExpenditureJournalTaPeer::BANK_ACCOUNT_ID, BankAccountPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = ExpenditureJournalTaPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = BankAccountPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getBankAccount();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addExpenditureJournalTa($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initExpenditureJournalTas();
             $obj2->addExpenditureJournalTa($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #23
0
 public static function doSelectJoinAllExceptBankAccount(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     VAcademicCostTaPeer::addSelectColumns($c);
     $startcol2 = VAcademicCostTaPeer::NUM_COLUMNS - VAcademicCostTaPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     AcademicCalendarPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + AcademicCalendarPeer::NUM_COLUMNS;
     AcademicCostComponentPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + AcademicCostComponentPeer::NUM_COLUMNS;
     AcademicProcessPeer::addSelectColumns($c);
     $startcol5 = $startcol4 + AcademicProcessPeer::NUM_COLUMNS;
     $c->addJoin(VAcademicCostTaPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID);
     $c->addJoin(VAcademicCostTaPeer::ACADEMIC_COST_COMPONENT_ID, AcademicCostComponentPeer::ID);
     $c->addJoin(VAcademicCostTaPeer::ACADEMIC_PROCESS_ID, AcademicProcessPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = VAcademicCostTaPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = AcademicCalendarPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getAcademicCalendar();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addVAcademicCostTa($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initVAcademicCostTas();
             $obj2->addVAcademicCostTa($obj1);
         }
         $omClass = AcademicCostComponentPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getAcademicCostComponent();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addVAcademicCostTa($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initVAcademicCostTas();
             $obj3->addVAcademicCostTa($obj1);
         }
         $omClass = AcademicProcessPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj4 = new $cls();
         $obj4->hydrate($rs, $startcol4);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj4 = $temp_obj1->getAcademicProcess();
             if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj4->addVAcademicCostTa($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj4->initVAcademicCostTas();
             $obj4->addVAcademicCostTa($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #24
0
 public static function doSelectJoinAllExceptGradeConversionTemplate(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     Cur13TermPeer::addSelectColumns($c);
     $startcol2 = Cur13TermPeer::NUM_COLUMNS - Cur13TermPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     Cur13KiPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + Cur13KiPeer::NUM_COLUMNS;
     CourseSchedulePeer::addSelectColumns($c);
     $startcol4 = $startcol3 + CourseSchedulePeer::NUM_COLUMNS;
     $c->addJoin(Cur13TermPeer::CUR13_KI_ID, Cur13KiPeer::ID);
     $c->addJoin(Cur13TermPeer::COURSE_SCHEDULE_ID, CourseSchedulePeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = Cur13TermPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = Cur13KiPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getCur13Ki();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addCur13Term($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initCur13Terms();
             $obj2->addCur13Term($obj1);
         }
         $omClass = CourseSchedulePeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getCourseSchedule();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addCur13Term($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initCur13Terms();
             $obj3->addCur13Term($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #25
0
 public static function doSelectJoinAllExceptDepartment(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     GradeComponentPeer::addSelectColumns($c);
     $startcol2 = GradeComponentPeer::NUM_COLUMNS - GradeComponentPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     GradeSpecPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + GradeSpecPeer::NUM_COLUMNS;
     $c->addJoin(GradeComponentPeer::GRADE_SPEC_ID, GradeSpecPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = GradeComponentPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = GradeSpecPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getGradeSpec();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addGradeComponent($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initGradeComponents();
             $obj2->addGradeComponent($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #26
0
 public static function doSelectJoinAllExceptClassType(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     CounselingPeer::addSelectColumns($c);
     $startcol2 = CounselingPeer::NUM_COLUMNS - CounselingPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     EmployeePeer::addSelectColumns($c);
     $startcol3 = $startcol2 + EmployeePeer::NUM_COLUMNS;
     AcademicCalendarPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + AcademicCalendarPeer::NUM_COLUMNS;
     ClassGroupPeer::addSelectColumns($c);
     $startcol5 = $startcol4 + ClassGroupPeer::NUM_COLUMNS;
     $c->addJoin(CounselingPeer::EMPLOYEE_ID, EmployeePeer::ID);
     $c->addJoin(CounselingPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID);
     $c->addJoin(CounselingPeer::CLASS_GROUP_ID, ClassGroupPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = CounselingPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = EmployeePeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getEmployee();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addCounseling($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initCounselings();
             $obj2->addCounseling($obj1);
         }
         $omClass = AcademicCalendarPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getAcademicCalendar();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addCounseling($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initCounselings();
             $obj3->addCounseling($obj1);
         }
         $omClass = ClassGroupPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj4 = new $cls();
         $obj4->hydrate($rs, $startcol4);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj4 = $temp_obj1->getClassGroup();
             if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj4->addCounseling($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj4->initCounselings();
             $obj4->addCounseling($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #27
0
 public static function doSelectJoinAll(Criteria $c, $con = null)
 {
     foreach (sfMixer::getCallables('BasenahoWikiPagePeer:doSelectJoinAll:doSelectJoinAll') as $callable) {
         call_user_func($callable, 'BasenahoWikiPagePeer', $c, $con);
     }
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     nahoWikiPagePeer::addSelectColumns($c);
     $startcol2 = nahoWikiPagePeer::NUM_COLUMNS - nahoWikiPagePeer::NUM_LAZY_LOAD_COLUMNS + 1;
     nahoWikiWikiPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + nahoWikiWikiPeer::NUM_COLUMNS;
     $c->addJoin(nahoWikiPagePeer::WIKI_ID, nahoWikiWikiPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = nahoWikiPagePeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = nahoWikiWikiPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getnahoWikiWiki();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addnahoWikiPage($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initnahoWikiPages();
             $obj2->addnahoWikiPage($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #28
0
 public static function doSelectJoinAllExceptAcademicCalendar(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     LocationPeer::addSelectColumns($c);
     $startcol2 = LocationPeer::NUM_COLUMNS - LocationPeer::NUM_LAZY_LOAD_COLUMNS + 1;
     LocationCategoryPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + LocationCategoryPeer::NUM_COLUMNS;
     LocationConditionPeer::addSelectColumns($c);
     $startcol4 = $startcol3 + LocationConditionPeer::NUM_COLUMNS;
     DepartmentPeer::addSelectColumns($c);
     $startcol5 = $startcol4 + DepartmentPeer::NUM_COLUMNS;
     $c->addJoin(LocationPeer::LOCATION_CATEGORY_ID, LocationCategoryPeer::ID);
     $c->addJoin(LocationPeer::LOCATION_CONDITION_ID, LocationConditionPeer::ID);
     $c->addJoin(LocationPeer::DEPARTMENT_ID, DepartmentPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = LocationPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = LocationCategoryPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getLocationCategory();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addLocation($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initLocations();
             $obj2->addLocation($obj1);
         }
         $omClass = LocationConditionPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj3 = new $cls();
         $obj3->hydrate($rs, $startcol3);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj3 = $temp_obj1->getLocationCondition();
             if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj3->addLocation($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj3->initLocations();
             $obj3->addLocation($obj1);
         }
         $omClass = DepartmentPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj4 = new $cls();
         $obj4->hydrate($rs, $startcol4);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj4 = $temp_obj1->getDepartment();
             if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj4->addLocation($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj4->initLocations();
             $obj4->addLocation($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }
예제 #29
0
 public static function populateObjects(ResultSet $rs)
 {
     $results = array();
     $cls = LorfieldsPeer::getOMClass();
     $cls = Propel::import($cls);
     while ($rs->next()) {
         $obj = new $cls();
         $obj->hydrate($rs);
         $results[] = $obj;
     }
     return $results;
 }
예제 #30
0
 public static function doSelectJoinAllExceptCur13TermSpec(Criteria $c, $con = null)
 {
     $c = clone $c;
     if ($c->getDbName() == Propel::getDefaultDB()) {
         $c->setDbName(self::DATABASE_NAME);
     }
     Cur13GradePeer::addSelectColumns($c);
     $startcol2 = Cur13GradePeer::NUM_COLUMNS - Cur13GradePeer::NUM_LAZY_LOAD_COLUMNS + 1;
     StudentAccalPeer::addSelectColumns($c);
     $startcol3 = $startcol2 + StudentAccalPeer::NUM_COLUMNS;
     $c->addJoin(Cur13GradePeer::STUDENT_ACCAL_ID, StudentAccalPeer::ID);
     $rs = BasePeer::doSelect($c, $con);
     $results = array();
     while ($rs->next()) {
         $omClass = Cur13GradePeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj1 = new $cls();
         $obj1->hydrate($rs);
         $omClass = StudentAccalPeer::getOMClass();
         $cls = Propel::import($omClass);
         $obj2 = new $cls();
         $obj2->hydrate($rs, $startcol2);
         $newObject = true;
         for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
             $temp_obj1 = $results[$j];
             $temp_obj2 = $temp_obj1->getStudentAccal();
             if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
                 $newObject = false;
                 $temp_obj2->addCur13Grade($obj1);
                 break;
             }
         }
         if ($newObject) {
             $obj2->initCur13Grades();
             $obj2->addCur13Grade($obj1);
         }
         $results[] = $obj1;
     }
     return $results;
 }