public function execute(&$value, &$error) { $c = new Criteria(); $c->add(UserPeer::EMAIL, $value); $users = UserPeer::doSelect($c); // if it's unique if (0 === count($users)) { return true; } else { if (count($users) > 1) { $error = $this->getParameter('unique_error'); return false; } else { $user = array_pop($users); /* @var $user User */ $loggedInUser = sfContext::getInstance()->getUser()->getRaykuUser(); if ($loggedInUser instanceof User) { // if the logged in user matches the found user, then it's allowed to be the same email address if ($loggedInUser->equals($user)) { return true; } else { $error = $this->getParameter('unique_error'); return false; } } else { // we're not logged in, so die throw new sfValidatorException('you need to be logged in to validate your email address'); } } } $error = $this->getParameter('unique_error'); return false; }
public function getNonMembers($c = null) { $c = UserPeer::getNonUsergroupCriteria($this->getId(), $c); $c->addAscendingOrderByColumn(UserPeer::FAMILY_NAME); $c->addAscendingOrderByColumn(UserPeer::SURNAME); return UserPeer::doSelect($c); }
public function getAllInterestedUsers() { $c = new Criteria(); $c->addJoin(UserPeer::ID, InterestPeer::USER_ID, Criteria::LEFT_JOIN); $c->add(InterestPeer::QUESTION_ID, $this->getId()); return UserPeer::doSelect($c); }
public function executeList(sfWebRequest $request) { $c = new Criteria(); $c->add(UserPeer::STATUS, Constant::RECORD_STATUS_DELETED, Criteria::NOT_EQUAL); $c->addAscendingOrderByColumn(UserPeer::EMPLOYEE_ID); $this->users = UserPeer::doSelect($c); }
public function execute(&$value, &$error) { $c = new Criteria(); $c->add(UserPeer::EMAIL, $value); $users = UserPeer::doSelect($c); // if it's not found if (0 === count($users)) { $error = $this->getParameter('invalid_error'); return false; } return true; }
public function executeAutocomplete() { //Find the e-mail addresses of banned users that're like the one typed $c = new Criteria(); if ($this->getRequestParameter('hidden') == 'yes') { $c->add(UserPeer::HIDDEN, true); } else { $c->add(UserPeer::HIDDEN, false); } $c->add(UserPeer::USERNAME, $this->getRequestParameter('username') . '%', Criteria::LIKE); $c->setLimit(25); //Send that list to the template $this->users = UserPeer::doSelect($c); }
public function executeSubmit(sfWebRequest $request) { $user = new User(); $c = new Criteria(); $c->add(UserPeer::USERNAME, $request->getParameter('user_name')); $c->add(UserPeer::PASSWORD, $request->getParameter('password')); $user_array = UserPeer::doSelect($c); $user = $this->getUser(); if (sizeof($user_array) <= 0) { $user->setAuthenticated(false); return sfView::ERROR; } $user_class = new User(); $user_class = $user_array[0]; $user->setAttribute('userId', $user_class->getUserid()); $user->setAuthenticated(true); }
public function getSysadmin() { $c = new Criteria(); $users = UserPeer::doSelect($c); foreach ($users as $user1) { $userrole = $user1->getUserRoles(); $found = false; foreach ($userroles as $userrole) { if ($userrole . getRole()->getName() == 'sysadmin') { $found = true; break; } } if (found == true) { return $user1; } } return null; }
function checkUser($userEmail, $userPassword) { global $firephp; $c = new Criteria(); $c->add(UserPeer::USEREMAIL, $userEmail); $user = UserPeer::doSelect($c); $firephp->log($user, 'user'); if (count($user) != 1) { return false; } else { $firephp->log($user[0]->getUserpwd(), 'password Bdd'); $firephp->log($userPassword, 'password user'); //controle du password if (!strcmp($user[0]->getUserpwd(), $userPassword)) { return $user[0]; //login ok le password est bon } else { return false; } } }
public function executeSendmail() { $c = new Criteria(); $users = UserPeer::doSelect($c); foreach ($users as $user) { $this->mail = Mailman::createCleanMailer(); $subject = $_POST['massmail_subject']; $this->mail->setSubject($subject); $this->mail->setFrom("Rayku < *****@*****.** >"); $to = $user->getEmail(); sfProjectConfiguration::getActive()->loadHelpers(array('Partial')); $this->mail->setBody($_POST['massmail_content']); $this->mail->setContentType('text/html'); $this->mail->addAddress($to); $this->mail->send(); if ($this->mail) { $_SESSION['mailsent'] = 1; } } $this->redirect('massmail/index'); }
public function executeIndex() { $a = new Criteria(); $users = UserPeer::doSelect($a); //print_r($users); $onlineusers = 0; foreach ($users as $user) { if ($user->isOnline()) { $onlineusers = $onlineusers + 1; } } //echo $onlineusers; $onlineusers = $onlineusers; if ($onlineusers == 0) { $onlineusers_msg = "(All members are in offline)"; } if ($onlineusers == 1) { $onlineusers_msg = "(One member is in online)"; } if ($onlineusers > 1) { $onlineusers_msg = "({$onlineusers} members are in online)"; } $this->onlineusers_msg = $onlineusers_msg; if (!empty($_COOKIE["timer"])) { $this->redirect('/dashboard/rating'); } if (!empty($_GET['post_id'])) { $this->getResponse()->setCookie("_post_Id", $_GET['post_id'], time() + 600, '/', sfConfig::get('app_cookies_domain')); $_COOKIE['_post_Id'] = 100; } $c = new Criteria(); $c->add(ForumPeer::TYPE, 0); $this->publicforums = ForumPeer::doSelect($c); $this->categories = CategoryPeer::doSelect(new Criteria()); $l = new Criteria(); $l->addDescendingOrderByColumn(ThreadPeer::ID); $l->add(ThreadPeer::CANCEL, 0); $l->setLimit(5); $this->latest = ThreadPeer::doSelect($l); }
public function executeList() { $this->users = UserPeer::doSelect(new Criteria()); }
public function getLoginName($email_address) { $a = explode("@", $email_address); $c = new Criteria(); $c->add(UserPeer::EMAIL_LOCAL_PART, $a[0]); $login = UserPeer::doSelect($c); return $login->getLogin(); }
private function getUserByName($keyword) { $departmentAvailable = $this->cmsTools->departmentAvailable($this->department->getId()); $criteria = new Criteria(); $criteria->add(UserPeer::LOGIN, '%' . $keyword . '%', Criteria::LIKE); $criteria->add(UserPeer::DEPARTMENT_ID, $departmentAvailable, Criteria::IN); $user = UserPeer::doSelect($criteria); $userId = array(); foreach ($user as $u) { $userId[] = $u->getId(); } return $userId; }
public static function doDelete($values, PropelPDO $con = null) { if ($con === null) { $con = Propel::getConnection(PagePeer::DATABASE_NAME, Propel::CONNECTION_WRITE); } if ($values instanceof Criteria) { // rename for clarity $criteria = clone $values; } elseif ($values instanceof User) { // it's a model object // create criteria based on pk values $criteria = $values->buildPkeyCriteria(); } else { // it's a primary key, or an array of pks $criteria = new Criteria(self::DATABASE_NAME); $criteria->add(PagePeer::ID, (array) $values, Criteria::IN); } foreach (UserPeer::doSelect(clone $criteria, $con) as $object) { TagPeer::deleteTagsForObject($object); } return self::doDeleteBeforeTaggable($criteria, $con); }
protected function userstat($col) { $c = new Criteria(); $c->addGroupByColumn($col); $c->addAscendingOrderByColumn($col); return UserPeer::doSelect($c); }
public function executeRegistration() { $userid = $this->getRequestParameter('userid'); $this->getUser()->getAttributeHolder()->remove('claimerid'); $roll = $this->getRequestParameter('roll'); $hawa = $this->getRequestParameter('hawa'); $city = $this->getRequestParameter('city'); $hod = $this->getRequestParameter('hod'); $director = $this->getRequestParameter('director'); $teacher = $this->getRequestParameter('favteacher'); $lanka = $this->getRequestParameter('favlankashop'); $email = $this->getRequestParameter('email'); $other = $this->getRequestParameter('otherinfo'); $dusername = $this->getRequestParameter('dusername'); $mob = $this->getRequestParameter('mob'); if (!$userid) { $fname = $this->getRequestParameter('fname'); $mname = $this->getRequestParameter('mname'); $lname = $this->getRequestParameter('lname'); $year = $this->getRequestParameter('year'); $dusername = $this->getRequestParameter('dusername'); $formerrors1 = array(); if (!$fname) { $formerrors1[] = 'Please enter first name'; } if (!$lname) { $formerrors1[] = 'Please enter last name'; } if (!$dusername) { $formerrors1[] = 'Please enter username'; } if ($formerrors1) { $this->getRequest()->setErrors($formerrors1); $this->forward('home', 'getmyaccount'); } $branchn = BranchPeer::retrieveByPK($this->getRequestParameter('branchid')); $degreen = DegreePeer::retrieveByPK($this->getRequestParameter('degreeid')); if (!$dusername) { $newusername = $fname . "." . $lname . "@" . $branchn->getCode() . substr($year, -2); } else { $newusername = $dusername; } $currentyear = date('Y'); if ($currentyear <= $year) { $usertype = '0'; } else { $usertype = '1'; } $user = new User(); $user->setUsername($newusername); $user->setRoll($roll); $user->setRollflag(sfConfig::get('app_defaultprivacy_roll')); $user->setGraduationyear($year); $user->setGraduationyearflag(sfConfig::get('app_defaultprivacy_year')); $user->setBranchId($branchn->getId()); $user->setBranchflag(sfConfig::get('app_defaultprivacy_branch')); $user->setDegreeId($degreen->getId()); $user->setDegreeflag(sfConfig::get('app_defaultprivacy_degree')); $user->setUsertype($usertype); $user->setTempemail($email); $user->setIslocked(sfConfig::get('app_islocked_newreg')); $user->save(); $personal = new Personal(); $personal->setUserId($user->getId()); $personal->setFirstname($fname); $personal->setMiddlename($mname); $personal->setLastname($lname); $personal->setEmail($email); $personal->setMobile($mob); $personal->save(); $userid = $user->getId(); } else { $user = UserPeer::retrieveByPK($userid); $user->setIslocked(sfConfig::get('app_islocked_claimed')); $user->save(); } $c = new Criteria(); $c->add(ClaiminfoPeer::USER_ID, $userid); $claiminfo = ClaiminfoPeer::doSelectOne($c); if ($claiminfo) { $this->user = $claiminfo->getUser(); $this->claiminfo = $claiminfo; } else { $claiminfo = new Claiminfo(); $claiminfo->setUserId($userid); $claiminfo->setRoll($roll); $claiminfo->setHawa($hawa); $claiminfo->setCity($city); $claiminfo->setHod($hod); $claiminfo->setDirector($director); $claiminfo->setTeacher($teacher); $claiminfo->setLankashop($lanka); $claiminfo->setOther($other); $claiminfo->setDusername($dusername); $claiminfo->save(); $this->claiminfo = $claiminfo; $this->user = $user; if ($user) { $username = $user->getUsername(); $personal = $user->getPersonal(); $personal->setEmail($email); $personal->save(); $sendermail = sfConfig::get('app_from_mail'); $sendername = sfConfig::get('app_from_name'); $to = sfConfig::get('app_to_adminmail'); $subject = "Registration request for ITBHU Global Org"; $body = ' Hi, I want to connect to ITBHU Global. My verification information is: '; $body = $body . 'Roll Number : ' . $roll . ' '; $body = $body . 'HAWA : ' . $hawa . ' '; $body = $body . 'City : ' . $city . ' '; $body = $body . 'HoD : ' . $hod . ' '; $body = $body . 'Director : ' . $director . ' '; $body = $body . 'Favourite Teacher : ' . $teacher . ' '; $body = $body . 'Favuorite Lanka Shop : ' . $lanka . ' '; $body = $body . 'My Email : ' . $email . ' '; $body = $body . 'Username I am claiming: ' . $username . ' '; $body = $body . 'Desired Username : '******' '; $body = $body . 'Thanks,'; $body = $body . ' ' . $user->getFullname(); //send mail to admin $mail = myUtility::sendmail($sendermail, $sendername, $sendermail, $sendername, $sendermail, $to, $subject, $body); //send mail to class authorizer $ca = new Criteria(); $ca->add(UserPeer::GRADUATIONYEAR, $user->getGraduationyear()); $ca->add(UserPeer::BRANCH_ID, $user->getBranchId()); $ca->addJoin(UserPeer::ID, UserrolePeer::USER_ID); $ca->add(UserrolePeer::ROLE_ID, sfConfig::get('app_role_auth')); $authusers = UserPeer::doSelect($ca); //if class authorizers are available. if ($authusers) { foreach ($authusers as $authuser) { $toauth = $authuser->getEmail(); $mail = myUtility::sendmail($sendermail, $sendername, $sendermail, $sendername, $sendermail, $toauth, $subject, $body); } $user->setAuthcode(sfConfig::get('app_authcode_classauth')); $user->save(); } else { //get other authorizers $ugyear = $user->getGraduationyear() - 2; $lgyear = $user->getGraduationyear() + 2; $oa = new Criteria(); $oa->add(UserPeer::GRADUATIONYEAR, $ugyear, Criteria::GREATER_EQUAL); $oa->add(UserPeer::GRADUATIONYEAR, $lgyear, Criteria::LESS_EQUAL); $oa->add(UserPeer::BRANCH_ID, $user->getBranchId()); $oa->addJoin(UserPeer::ID, UserrolePeer::USER_ID); $oa->add(UserrolePeer::ROLE_ID, sfConfig::get('app_role_auth')); $authuserspm = UserPeer::doSelect($oa); //if other authorizers are available if ($authuserspm) { foreach ($authuserspm as $authuserpm) { $toauth = $authuserpm->getEmail(); $mail = myUtility::sendmail($sendermail, $sendername, $sendermail, $sendername, $sendermail, $toauth, $subject, $body); $user->setAuthcode(sfConfig::get('app_authcode_otherauth')); $user->save(); } } else { // no authorizers were available, send to master list of authorizers $ma = new Criteria(); $ma->addJoin(UserPeer::ID, UserrolePeer::USER_ID); $ma->add(UserrolePeer::ROLE_ID, sfConfig::get('app_role_masterauth')); $mauths = UserPeer::doSelect($ma); if ($mauths) { foreach ($mauths as $mauth) { $toauth = $mauth->getEmail(); $mail = myUtility::sendmail($sendermail, $sendername, $sendermail, $sendername, $sendermail, $toauth, $subject, $body); $user->setAuthcode(sfConfig::get('app_authcode_masterauth')); $user->save(); } } else { $user->setAuthcode(sfConfig::get('app_authcode_none')); $user->save(); } } } $sendermail = sfConfig::get('app_from_mail'); $sendername = sfConfig::get('app_from_name'); $to = $email; $subject = "Registration request for ITBHU Global Org"; $body = ' Dear ' . $user->getFullname() . ', Thank you for your connect request. We\'ll get back to you shortly. Admin, ITBHU Global '; $mail = myUtility::sendmail($sendermail, $sendername, $sendermail, $sendername, $sendermail, $to, $subject, $body); } } // saving the checkbox data in db $c = new Criteria(); $c->add(PersonalPeer::USER_ID, $user->getId()); $this->personal = PersonalPeer::doSelectOne($c); $c = new Criteria(); $worktypes = WorktypePeer::doSelect($c); foreach ($worktypes as $worktype) { if ($this->getRequestParameter($worktype->getId())) { $personalWorktype = new PersonalWorktype(); $personalWorktype->setPersonalId($this->personal->getId()); $personalWorktype->setWorktypeId($worktype->getId()); $personalWorktype->save(); } } }
public function executeIndex(sfWebRequest $request) { $this->users = UserPeer::doSelect(new Criteria()); }
public function execute($request) { $c = new Criteria(); $c->setLimit(15); $this->users = UserPeer::doSelect($c); if (count($this->users) < 1) { return sfView::ERROR; } // RaykuCommon::getDatabaseConnection(); // // /* @var $currentUser User */ // $currentUser = $this->getUser()->getRaykuUser(); // // $userId = $currentUser->getId(); // // $this->userId = $currentUser->getId(); // // // $time = time(); // // // // $_SESSION["rateDisplay"] = 1; // // // // if (!empty($_POST['hidden'])) { // // // $count = count($_POST['checkbox']); // // // /* Clearing Cookies */ // // for ($u = $_COOKIE['cookcount']; $u >= 1; $u--) { // // $cookname = 'tutor_' . $u; // // $this->getResponse()->setCookie($cookname, '', time() - 3600, '/', sfConfig::get('app_cookies_domain')); // } // // // $this->getResponse()->setCookie("tutorcount", '', time() - 3600, '/', sfConfig::get('app_cookies_domain')); // // $this->getResponse()->setCookie("cookcount", '', time() - 3600, '/', sfConfig::get('app_cookies_domain')); // // /* Clearing Cookies */ // // if ($count > 2) { // // $close = 21000; // } else if ($count == 2) { // // $close = 31000; // } else if ($count == 1) { // // $close = 61000; // } // // $j = 0; // for ($i = 0; $i < $count; $i++) { // // mysql_query("INSERT INTO `user_expert` (`user_id`, `checked_id`, `category_id`, `question`, `exe_order`, `time`, status, close) VALUES ('" . $userId . "', '" . $_POST['checkbox'][$i] . "', '5', 'To be discussed','" . (++$j) . "', '" . $time . "', 1, " . $close . ") ") or die(mysql_error()); // } // // // // setcookie("asker_que", $_SESSION['question'], time() + 600, "/", sfConfig::get('app_cookies_domain')); // // $this->getResponse()->setCookie("redirection", 1, time() + 600, '/', sfConfig::get('app_cookies_domain')); // // $this->getResponse()->setCookie("forumsub", 1, time() + 600, '/', sfConfig::get('app_cookies_domain')); // // // // // $this->redirect('expertmanager/connect'); // } // // // // $this->cat = $this->getRequestParameter('category'); // // $this->course_id = @$_SESSION['tutcourse']; // // if (empty($this->course_id)) { // $this->course_id = 1; // } // // // if (empty($this->cat)) { // $this->cat = 1; // } // // // // $c = new Criteria(); // $c->addJoin(ExpertCategoryPeer::USER_ID, UserTutorPeer::USERID, Criteria::INNER_JOIN); // // if ($this->cat == 5) { // $experts = ExpertCategoryPeer::doSelect($c); // } else { // $c->add(ExpertCategoryPeer::CATEGORY_ID, $this->cat); // $experts = ExpertCategoryPeer::doSelect($c); // } // // $_points = $currentUser->getPoints(); // // // $newUser = array(); // $i = 0; // $eachExpertOnlyOnce = array(); // // foreach ($experts as $exp) { // // if (in_array($exp->getUserId(), $eachExpertOnlyOnce)) { // continue; // } // // $eachExpertOnlyOnce[] = $exp->getUserId(); // // $_queryCourse = ''; // $tutorsq = mysql_query("select * from tutor_profile where category = 1 and user_id = " . $exp->getUserId() . "") or die("Er-1-->" . mysql_error()); // $tutors = mysql_fetch_array($tutorsq); // $tutor = ''; // // $tutor = explode("-", $tutors['course_id']); // $coursid = $this->course_id; // if (in_array($coursid, $tutor)) { // //echo $coursid; // // $_queryCourse = mysql_query("select * from tutor_profile where category = 1 and user_id = " . $exp->getUserId() . "") or die("Er-1-->" . mysql_error()); // //echo "select * from tutor_profile where category = 1 and user_id = ".$exp->getUserId().""; // } // // // // if ($_queryCourse && mysql_num_rows($_queryCourse) > 0) { // // $query = mysql_query("select * from user_score where user_id=" . $exp->getUserId()) or die(mysql_error()); // $score = mysql_fetch_assoc($query); // // if ($score['score'] != 0) { // // if (false) { //$_points == '' || $_points == '0.00' Temporary hack // $emptyRCquery = mysql_query("select * from user_rate where userid=" . $exp->getUserId() . " and (rate = 0.00 || rate = 0) ") or die("Error In rate" . mysql_error()); // // if (mysql_num_rows($emptyRCquery) > 0) { // // $dv = new Criteria(); // $dv->add(UserPeer::ID, $exp->getUserId()); // $_thisUser = UserPeer::doSelectOne($dv); // // $newUser[$i] = array("score" => $score['score'], "userid" => $exp->getUserId(), "category" => $this->cat, "createdat" => $_thisUser->getCreatedAt()); // // $i++; // } // } else { // // $dv = new Criteria(); // $dv->add(UserPeer::ID, $exp->getUserId()); // $_thisUser = UserPeer::doSelectOne($dv); // // // $newUser[$i] = array("score" => $score['score'], "userid" => $exp->getUserId(), "category" => $this->cat, "createdat" => $_thisUser->getCreatedAt()); // // $i++; // } // } // } // } // // // // // asort($newUser); // // arsort($newUser); // // // $this->rankCheckUsers = $newUser; // // // ////if no online expert available redirecting to the board page // // // $onlineusers = array(); // $offlineusers = array(); // // $newOnlineUser = array(); // $newOfflineUser = array(); // $j = 0; // $k = 0; // $facebookResponse = BotServiceProvider::createFor(sfConfig::get('app_facebook_url')."/tutor")->getContent(); // $facebookUsers = json_decode($facebookResponse, true); // $botResponse = BotServiceProvider::createFor(sfConfig::get('app_notification_bot_url')."/tutor")->getContent(); // $botUsers = json_decode($botResponse, true); // // foreach ($newUser as $new) { // // $a = new Criteria(); // $a->add(UserPeer::ID, $new['userid']); // $users_online = UserPeer::doSelectOne($a); // // $onlinecheck = ''; // // if ($users_online->isOnline()) { // // $onlinecheck = "online"; // } // // // if (empty($onlinecheck)) { // $userGtalk = $users_online->getUserGtalk(); // if ($userGtalk) { // $onlinecheck = BotServiceProvider::createFor(sfConfig::get('app_rayku_url').':'.sfConfig::get('app_g_chat_port').'/status/' . $userGtalk->getGtalkid())->getContent(); // } // } // // if ((empty($onlinecheck) || ($onlinecheck != "online")) && is_array($facebookUsers)) { // // $userFb = UserFbPeer::retrieveByUserId($new['userid']); // if ($userFb) { // $fb_username = $userFb->getFbUsername(); // // foreach ($facebookUsers as $key => $user) { // // if ($user['username'] == $fb_username) { // // $onlinecheck = 'online'; // // break; // } // // } // } // } // // if ((empty($onlinecheck) || ($onlinecheck != "online")) && is_array($botUsers)) { // // foreach ($botUsers as $key => $_user) { // // if ($_user['email'] == $users_online->getEmail()){ // // $onlinecheck = 'online'; // break; // } // // } // } // // // // if ($onlinecheck == "online") { // // $onlineusers[$j] = $new['userid']; // // $newOnlineUser[$j] = array("score" => $new['score'], "userid" => $new['userid'], "category" => $new['category'], "createdat" => $new['createdat']); // $j++; // } elseif ($users_online->isOnline()) { // // $newOnlineUser[$j] = array("score" => $new['score'], "userid" => $new['userid'], "category" => $new['category'], "createdat" => $new['createdat']); // $onlineusers[$j] = $new['userid']; // // $j++; // } else { // // $newOfflineUser[$k] = array("score" => $new['score'], "userid" => $new['userid'], "category" => $new['category'], "createdat" => $new['createdat']); // $offlineusers[$k] = $new['userid']; // // $k++; // } // // } // // $this->newOnlineUser = $newOnlineUser; // // // $this->newOfflineUser = $newOfflineUser; // // // $this->_checkOnlineUsers = $onlineusers; // // // // // ///////////////////////////////////////////////////// // // if (isset($_COOKIE["onoff"]) && $_COOKIE["onoff"] == 1) { // // if (!empty($_COOKIE["school"])) { // // $cookieSchool = array(); // $m = 0; // foreach ($newOnlineUser as $new) { // // $b = new Criteria(); // $b->add(UserPeer::ID, $new['userid']); // $schoolusers = UserPeer::doSelectOne($b); // $mail = explode("@", $schoolusers->getEmail()); // $newMail = explode(".", $mail[1]); // // if (($newMail[0] == $_COOKIE["school"]) || ($newMail[1] == $_COOKIE["school"])) { // // $cookieSchool[$m] = $new; // $m++; // } // // } // // $this->expert_cats = $cookieSchool; // } else { // $this->expert_cats = $newOnlineUser; // } // } else if (isset($_COOKIE["onoff"]) && $_COOKIE["onoff"] == 2) { // // if (!empty($_COOKIE["school"])) { // // $cookieSchool = array(); // $m = 0; // // foreach ($newOfflineUser as $new) { // // $b = new Criteria(); // $b->add(UserPeer::ID, $new['userid']); // $schoolusers = UserPeer::doSelectOne($b); // $mail = explode("@", $schoolusers->getEmail()); // $newMail = explode(".", $mail[1]); // // if (($newMail[0] == $_COOKIE["school"]) || ($newMail[1] == $_COOKIE["school"])) { // // $cookieSchool[$m] = $new; // $m++; // } // // } // // $this->expert_cats = $cookieSchool; // } else { // // $this->expert_cats = $newOfflineUser; // } // } else { // // if (!empty($_COOKIE["school"])) { // // $cookieSchool = array(); // $m = 0; // // foreach ($newUser as $new) { // // $b = new Criteria(); // $b->add(UserPeer::ID, $new['userid']); // $schoolusers = UserPeer::doSelectOne($b); // $mail = explode("@", $schoolusers->getEmail()); // $newMail = explode(".", $mail[1]); // if (($newMail[0] == $_COOKIE["school"]) || ($newMail[1] == $_COOKIE["school"])) { // $cookieSchool[$m] = $new; // $m++; // } // // } // // $this->expert_cats = $cookieSchool; // } else { // // $this->expert_cats = $newUser; // } // } // $this->tutorsCount = count($this->expert_cats); // // $c = new Criteria(); // $c->add(CategoryPeer::ID, $this->cat); // $this->e = CategoryPeer::doSelectOne($c); // } }
public function getUsers($criteria = null, $con = null) { include_once 'lib/model/om/BaseUserPeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collUsers === null) { if ($this->isNew()) { $this->collUsers = array(); } else { $criteria->add(UserPeer::DEPARTMENT_ID, $this->getId()); UserPeer::addSelectColumns($criteria); $this->collUsers = UserPeer::doSelect($criteria, $con); } } else { if (!$this->isNew()) { $criteria->add(UserPeer::DEPARTMENT_ID, $this->getId()); UserPeer::addSelectColumns($criteria); if (!isset($this->lastUserCriteria) || !$this->lastUserCriteria->equals($criteria)) { $this->collUsers = UserPeer::doSelect($criteria, $con); } } } $this->lastUserCriteria = $criteria; return $this->collUsers; }
</div> <div class="bot"></div> </div> <!--forumside--> <!--<div class="clear-both"></div> <div class="forumside"> <div class="top"></div> <div class="bg"> <h1>Top Experts (Overall)</h1> <?php $c = new Criteria(); $c->add(UserPeer::TYPE, '5'); $c->addDescendingOrderByColumn(UserPeer::POINTS); $c->setLimit(10); $experts = UserPeer::doSelect($c); ?> <ul class="experts"> <?php foreach ($experts as $expert) { ?> <?php $c = new Criteria(); $c->add(PostPeer::POSTER_ID, $expert->getId()); $c->add(PostPeer::BEST_RESPONSE, '1'); $best_resp = PostPeer::doCount($c); ?> <li><?php echo link_to($expert->getName(), sfConfig::get('app_rayku_url') . '/expertmanager/portfolio/' . $expert->getUsername()); ?> : <?php
/** * 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(UserPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(UserPeer::DATABASE_NAME); $criteria->add(UserPeer::ID, $pks, Criteria::IN); $objs = UserPeer::doSelect($criteria, $con); } return $objs; }
public function executeSearch() { $this->mdl = $this->getRequestParameter('mdl'); $this->fnc = $this->getRequestParameter('fnc'); $branchid = $this->getRequestParameter('branchoption'); $chapterid = $this->getRequestParameter('chapteroption'); $year = $this->getRequestParameter('yearoption'); $degreeid = $this->getRequestParameter('degreeoption'); // $currentlyat = $this->getRequestParameter('currentlyat'); $flag = 0; $c = new Criteria(); if ($branchid != 0) { $c->add(UserPeer::BRANCH_ID, $branchid); $flag = 1; } if ($chapterid != 0) { $c->addJoin(UserPeer::ID, UserchapterregionPeer::USER_ID); $c->addJoin(UserchapterregionPeer::CHAPTERREGION_ID, ChapterregionPeer::ID); $c->add(ChapterregionPeer::CHAPTER_ID, $chapterid); $flag = 1; } if ($year != 0) { $c->add(UserPeer::GRADUATIONYEAR, $year); $flag = 1; } if ($degreeid != 0) { $c->add(UserPeer::DEGREE_ID, $degreeid); $flag = 1; } if ($flag == 1) { $this->results = UserPeer::doSelect($c); } else { $this->flag = 1; $this->setFlash('searchnone', 'Select At least one field...'); return $this->redirect('user/searchform'); } $this->chapterid = $chapterid; }
/** * Description : List all users * * @return : Collection of users */ public function listUsers() { try { $criteria = new Criteria(); $criteria->addAscendingOrderByColumn('NAME'); return UserPeer::doSelect($criteria); } catch (Exception $e) { return array(); } }
/** * gets an array of User objects NOT related to the current agent * * The user group is defined by removing users already related to the supplied agentId * * @param Agent $agent The current agent * @return array An array of User objects */ public static function getNewUsersForAgent($criteria) { $con = Propel::getConnection(self::DATABASE_NAME); $agent = sfContext::getInstance()->getUser()->getAttribute('agent', ''); if ($agent) { $agentId = $agent->getId(); } /** * @todo speed this up by making an array of current users and passing that to the query a 'not in array[]' **/ //get the current user list for this agent $c = new Criteria(); $c->add(AgentHasUserPeer::AGENT_ID, $agent->getId()); $curUsers = AgentHasUserPeer::doSelect($c); $c = new Criteria(); $c->addAscendingOrderByColumn(self::NICKNAME); $newUsers = UserPeer::doSelect($c); foreach ($curUsers as $curUser) { $curId = $curUser->getUserId(); foreach ($newUsers as $key => $newUser) { if ($newUser->getId() == $curId) { unset($newUsers[$key]); break; } } } //make sure the array is contiguous $newUsers = array_merge($newUsers); return $newUsers; }
/** * Gets an array of User objects which contain a foreign key that references this object. * * If this collection has already been initialized with an identical Criteria, it returns the collection. * Otherwise if this EnumItem has previously been saved, it will retrieve * related Users from storage. If this EnumItem is new, it will return * an empty collection or the current collection, the criteria is ignored on a new object. * * @param PropelPDO $con * @param Criteria $criteria * @return array User[] * @throws PropelException */ public function getUsers($criteria = null, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(EnumItemPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collUsers === null) { if ($this->isNew()) { $this->collUsers = array(); } else { $criteria->add(UserPeer::TYPE_ID, $this->id); UserPeer::addSelectColumns($criteria); $this->collUsers = UserPeer::doSelect($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 the collection. $criteria->add(UserPeer::TYPE_ID, $this->id); UserPeer::addSelectColumns($criteria); if (!isset($this->lastUserCriteria) || !$this->lastUserCriteria->equals($criteria)) { $this->collUsers = UserPeer::doSelect($criteria, $con); } } } $this->lastUserCriteria = $criteria; return $this->collUsers; }
public static function getForExpertCategory($iCategoryId) { $c = new criteria(); $c->addJoin(UserPeer::ID, ExpertCategoryPeer::USER_ID, Criteria::JOIN); $c->add(ExpertCategoryPeer::CATEGORY_ID, $iCategoryId); $c->addDescendingOrderbyColumn(UserPeer::POINTS); $c->setLimit(5); $c->setDistinct(); return UserPeer::doSelect($c); }