Ejemplo n.º 1
0
 public static function getMatchedRowsForDt($importDt, PropelPDO $conn = null)
 {
     if (!isset($conn)) {
         $conn = Propel::getConnection();
     }
     $c = new Criteria();
     $c->addJoin(AutoCourseRatingPeer::COURSE_INS_ID, CourseInstructorAssociationPeer::ID);
     $c->addJoin(AutoCourseRatingPeer::FIELD_ID, RatingFieldPeer::ID);
     $crit = $c->getNewCriterion(AutoCourseRatingPeer::IMPORT_DT, $importDt);
     $c->addAnd($crit);
     $c->addAscendingOrderByColumn(CourseInstructorAssociationPeer::YEAR);
     $c->addAscendingOrderByColumn(CourseInstructorAssociationPeer::COURSE_ID);
     $c->addAscendingOrderByColumn(RatingFieldPeer::ID);
     $c->addAscendingOrderByColumn(AutoCourseRatingPeer::RATING);
     return AutoCourseRatingPeer::doSelectJoinAll($c, $conn);
 }