<!--categories-->
<p><br /><br />
What subjects are you comfortable teaching?</p>
<br />
<?php
$usrid = $sf_user->getRaykuUser()->getId();
$usrdataq = mysql_query("SELECT * FROM tutor_profile WHERE user_id='" . $usrid . "'") or die(mysql_error());
$usrdata = mysql_fetch_array($usrdataq);
?>
<input type="hidden" name="usrid" id="usrid" value="<?php
echo $usrid;
?>
" />
<div class="categories">
<?php
$courses = CoursesPeer::getAllForCategoryStatus(1);
$e = 1;
$course = $usrdata['course_id'];
$course = explode("-", $course);
foreach ($courses as $oneCourse) {
if (in_array($oneCourse->getId(), $course)) {
$checked = 'checked';
} else {
$checked = '';
}
echo '<label>';
echo '<input name="catcheck[]" type="checkbox" value="' . $oneCourse->getId() . '" ', $checked, ' />';
echo '<input type="hidden" name="category" id="category" value="' . $oneCourse->getCategoryId() . '" />';
echo $oneCourse->getCourseName();
echo '</label>';
if ($e % 2 == 0) {
public static function getAllForCategoryStatus($status)
{
$c = new Criteria();
$c->add(CategoryPeer::STATUS, $status);
return CoursesPeer::doSelectJoinCategory($c);
}
<div id="tutorlist_ajax">
<div class="body" >
<div id="cn-body">
<div class="body-connect-left">
<div class="cn-left-bg" style="margin-top: 25px;">
<div class="cn-left-top"></div>
<h3 style="margin-bottom:8px;">Subject:</h3>
<label>
<form name="form1" id="form1" method="post">
<select name="course" onchange="alert('TODO')">
<option value="">--- SELECT ---</option>
<?php
/* @var $courses Courses[] */
$courses = CoursesPeer::doSelect(new Criteria());
foreach ($courses as $course) {
echo '<option value="' . $course->getId() . '" >' . $course->getCourseName() . ' </option>';
}
?>
</select>
</form>
</label>
<div class="cn-spacer"></div>
<h3>Filtering Options:</h3>
<h4>Expert Status: <img src="../images/greyarrow-down.jpg" width="10" height="11" alt="" /></h4>
<p><a href="" onClick="alert('TODO')">Online</a></p>
<p><a href="" onClick="alert('TODO')">Offline</a></p>
<h4>School: <img src="../images/greyarrow-down.jpg" width="10" height="11" alt="" /></h4>
<select name="school" onchange="alert('TODO')" style="background:none;padding:4px;height:auto;border:1px solid #CCC">
<option value="">---- SELECT ----</option>
/**
* Get the associated Courses object
*
* @param PropelPDO Optional Connection object.
* @return Courses The associated Courses object.
* @throws PropelException
*/
public function getCourses(PropelPDO $con = null)
{
if ($this->aCourses === null && $this->course_id !== null) {
$c = new Criteria(CoursesPeer::DATABASE_NAME);
$c->add(CoursesPeer::ID, $this->course_id);
$this->aCourses = CoursesPeer::doSelectOne($c, $con);
/* The following can be used additionally to
guarantee the related object contains a reference
to this object. This level of coupling may, however, be
undesirable since it could result in an only partially populated collection
in the referenced object.
$this->aCourses->addUserQuestionTags($this);
*/
}
return $this->aCourses;
}
</div>
<!--recent questions-->
<?php
} else {
?>
<input type="hidden" name="dummycount" id="dummycount" value="0" />
<?php
}
?>
<div id="hideload_course_category">
<select id="course_category" name="course_category">
<option value="0">Choose subject category</option>
<?php
$courses = CoursesPeer::getAllForCategoryId(1);
if ($courses) {
foreach ($courses as $course) {
echo '<option value="' . $course->getId() . '">' . $course->getCourseName() . '</option>';
}
}
?>
</select>
</div>
<input type="hidden" name="course_category_hidden" id="course_category_hidden" value="" />
</div>
<!--question form container-->
<!--question form container-->
<div id="personal-info" class="question-form-container">
<p class="education">
/**
* Returns the number of related Courses objects.
*
* @param Criteria $criteria
* @param boolean $distinct
* @param PropelPDO $con
* @return int Count of related Courses objects.
* @throws PropelException
*/
public function countCoursess(Criteria $criteria = null, $distinct = false, PropelPDO $con = null)
{
if ($criteria === null) {
$criteria = new Criteria(CategoryPeer::DATABASE_NAME);
} else {
$criteria = clone $criteria;
}
if ($distinct) {
$criteria->setDistinct();
}
$count = null;
if ($this->collCoursess === null) {
if ($this->isNew()) {
$count = 0;
} else {
$criteria->add(CoursesPeer::CATEGORY_ID, $this->id);
$count = CoursesPeer::doCount($criteria, $con);
}
} else {
// criteria has no effect for a new object
if (!$this->isNew()) {
// the following code is to determine if a new query is
// called for. If the criteria is the same as the last
// one, just return count of the collection.
$criteria->add(CoursesPeer::CATEGORY_ID, $this->id);
if (!isset($this->lastCoursesCriteria) || !$this->lastCoursesCriteria->equals($criteria)) {
$count = CoursesPeer::doCount($criteria, $con);
} else {
$count = count($this->collCoursess);
}
} else {
$count = count($this->collCoursess);
}
}
return $count;
}
/**
* Populates the object using an array.
*
* This is particularly useful when populating an object from one of the
* request arrays (e.g. $_POST). This method goes through the column
* names, checking to see whether a matching key exists in populated
* array. If so the setByName() method is called for that column.
*
* You can specify the key type of the array by additionally passing one
* of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME,
* BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM.
* The default key type is the column's phpname (e.g. 'AuthorId')
*
* @param array $arr An array to populate the object from.
* @param string $keyType The type of keys the array uses.
* @return void
*/
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = CoursesPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setCategoryId($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setCourseName($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setDescription($arr[$keys[3]]);
}
}
?>
<li><img src="<?php
echo image_path('tag.jpg', false);
?>
" alt="tag" class="tag" />
<!--<a href="#" style="a:hover{text-decoration:none;}" id="<?php
echo $userQuestionTag->getId();
?>
" class="waste" > -->
<small style="a:hover{text-decoration:none;};cursor:pointer;" id="clicktag_<?php
echo $userQuestionTag->getId();
?>
" class="clicktag waste" >
<?php
$course = CoursesPeer::retrieveByPK($userQuestionTag->getCourseId());
?>
<span id="course_category_<?php
echo $userQuestionTag->getId();
?>
" class="<?php
echo $course->getId();
?>
" > <?php
echo $course->getCourseName();
?>
</span>
<?php
if ($userQuestionTag->getYear() != 'Choose year') {
/**
* Selects a collection of UserQuestionTag objects pre-filled with all related objects except Category.
*
* @param Criteria $c
* @param PropelPDO $con
* @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN
* @return array Array of UserQuestionTag objects.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelectJoinAllExceptCategory(Criteria $c, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
$c = clone $c;
// Set the correct dbName if it has not been overridden
// $c->getDbName() will return the same object if not set to another value
// so == check is okay and faster
if ($c->getDbName() == Propel::getDefaultDB()) {
$c->setDbName(self::DATABASE_NAME);
}
UserQuestionTagPeer::addSelectColumns($c);
$startcol2 = UserQuestionTagPeer::NUM_COLUMNS - UserQuestionTagPeer::NUM_LAZY_LOAD_COLUMNS;
UserPeer::addSelectColumns($c);
$startcol3 = $startcol2 + (UserPeer::NUM_COLUMNS - UserPeer::NUM_LAZY_LOAD_COLUMNS);
CoursesPeer::addSelectColumns($c);
$startcol4 = $startcol3 + (CoursesPeer::NUM_COLUMNS - CoursesPeer::NUM_LAZY_LOAD_COLUMNS);
$c->addJoin(array(UserQuestionTagPeer::USER_ID), array(UserPeer::ID), $join_behavior);
$c->addJoin(array(UserQuestionTagPeer::COURSE_ID), array(CoursesPeer::ID), $join_behavior);
$stmt = BasePeer::doSelect($c, $con);
$results = array();
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$key1 = UserQuestionTagPeer::getPrimaryKeyHashFromRow($row, 0);
if (null !== ($obj1 = UserQuestionTagPeer::getInstanceFromPool($key1))) {
// We no longer rehydrate the object, since this can cause data loss.
// See http://propel.phpdb.org/trac/ticket/509
// $obj1->hydrate($row, 0, true); // rehydrate
} else {
$omClass = UserQuestionTagPeer::getOMClass();
$cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1);
$obj1 = new $cls();
$obj1->hydrate($row);
UserQuestionTagPeer::addInstanceToPool($obj1, $key1);
}
// if obj1 already loaded
// Add objects for joined User rows
$key2 = UserPeer::getPrimaryKeyHashFromRow($row, $startcol2);
if ($key2 !== null) {
$obj2 = UserPeer::getInstanceFromPool($key2);
if (!$obj2) {
$omClass = UserPeer::getOMClass();
$cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1);
$obj2 = new $cls();
$obj2->hydrate($row, $startcol2);
UserPeer::addInstanceToPool($obj2, $key2);
}
// if $obj2 already loaded
// Add the $obj1 (UserQuestionTag) to the collection in $obj2 (User)
$obj2->addUserQuestionTag($obj1);
}
// if joined row is not null
// Add objects for joined Courses rows
$key3 = CoursesPeer::getPrimaryKeyHashFromRow($row, $startcol3);
if ($key3 !== null) {
$obj3 = CoursesPeer::getInstanceFromPool($key3);
if (!$obj3) {
$omClass = CoursesPeer::getOMClass();
$cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1);
$obj3 = new $cls();
$obj3->hydrate($row, $startcol3);
CoursesPeer::addInstanceToPool($obj3, $key3);
}
// if $obj3 already loaded
// Add the $obj1 (UserQuestionTag) to the collection in $obj3 (Courses)
$obj3->addUserQuestionTag($obj1);
}
// if joined row is not null
$results[] = $obj1;
}
$stmt->closeCursor();
return $results;
}
/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param PropelPDO $con the connection to use
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function retrieveByPKs($pks, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(CoursesPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(CoursesPeer::DATABASE_NAME);
$criteria->add(CoursesPeer::ID, $pks, Criteria::IN);
$objs = CoursesPeer::doSelect($criteria, $con);
}
return $objs;
}
