Esempio n. 1
0
 public function inscribirme()
 {
     $crit = new Criteria();
     $crit->add(CourseRelUserPeer::USER_ID, Session::get('id'));
     $crit->addDescendingOrderByColumn(CourseRelUserPeer::SORT);
     $curso = CourseRelUserPeer::doSelectOne($crit);
     $sort = $curso->getSort() + 1;
     $inscripcion = new CourseRelUser();
     $inscripcion->setCourseCode(Session::get('curso_sel'));
     $inscripcion->setUserId(Session::get('id'));
     // Por defecto para alumnos ?? creo!
     $inscripcion->setStatus(5);
     $inscripcion->setRole(null);
     $inscripcion->setGroupId(0);
     $inscripcion->setTutorId(0);
     $inscripcion->setSort($sort);
     $inscripcion->setUserCourseCat(0);
     $inscripcion->save();
     return Router::redirect('cursos/mis_cursos', 0);
 }
 /**
  * Retrieve object using using composite pkey values.
  * @param      string $course_code
  * @param      int $user_id
  * @param      PropelPDO $con
  * @return     CourseRelUser
  */
 public static function retrieveByPK($course_code, $user_id, PropelPDO $con = null)
 {
     $_instancePoolKey = serialize(array((string) $course_code, (string) $user_id));
     if (null !== ($obj = CourseRelUserPeer::getInstanceFromPool($_instancePoolKey))) {
         return $obj;
     }
     if ($con === null) {
         $con = Propel::getConnection(CourseRelUserPeer::DATABASE_NAME, Propel::CONNECTION_READ);
     }
     $criteria = new Criteria(CourseRelUserPeer::DATABASE_NAME);
     $criteria->add(CourseRelUserPeer::COURSE_CODE, $course_code);
     $criteria->add(CourseRelUserPeer::USER_ID, $user_id);
     $v = CourseRelUserPeer::doSelect($criteria, $con);
     return !empty($v) ? $v[0] : null;
 }
 /**
  * Find object by primary key
  * <code>
  * $obj = $c->findPk(array(12, 34), $con);
  * </code>
  * @param     array[$course_code, $user_id] $key Primary key to use for the query
  * @param     PropelPDO $con an optional connection object
  *
  * @return    CourseRelUser|array|mixed the result, formatted by the current formatter
  */
 public function findPk($key, $con = null)
 {
     if (null !== ($obj = CourseRelUserPeer::getInstanceFromPool(serialize(array((string) $key[0], (string) $key[1])))) && $this->getFormatter()->isObjectFormatter()) {
         // the object is alredy in the instance pool
         return $obj;
     } else {
         // the object has not been requested yet, or the formatter is not an object formatter
         $criteria = $this->isKeepQuery() ? clone $this : $this;
         $stmt = $criteria->filterByPrimaryKey($key)->getSelectStatement($con);
         return $criteria->getFormatter()->init($criteria)->formatOne($stmt);
     }
 }