PHP Block::allUserIdsWithBlockingRelationships方法代码示例

 public static function updateFor($user_id)
 {
     $blocks = Block::allUserIdsWithBlockingRelationships($user_id);
     $q = Doctrine_Query::create()->update("Autofinger")->set("updated", 1)->where("interest = ?", $user_id)->andWhereNotIn("owner", $blocks);
     return $q->execute();
 }

/**
 * Get a link to the most recently updated plan.
 * @return Hyperlink
 */
function get_just_updated()
{
    // Get the most recently updated plan
    $q = Doctrine_Query::create()->select("userid, username")->from("Accounts")->where("username != 'test'")->andWhereNotIn("userid", Block::allUserIdsWithBlockingRelationships(User::id()))->orderBy("changed DESC")->limit(1);
    //return the results of the query
    $new_plans = $q->fetchOne();
    // Get the appropriate URI for a plan link
    $temp = new PlanLink($new_plans["username"]);
    // But we want a generic Hyperlink, so it can be styled separately.
    return new Hyperlink('justupdatedlink', true, $temp->href, $new_plans["username"]);
}

<?php

/**
 * Redirects a user to a random plan.
 */
require_once 'Plans.php';
new SessionBroker();
require 'functions-main.php';
if (User::logged_in()) {
    $ids_to_hide = Block::allUserIdsWithBlockingRelationships(User::id());
    array_push($ids_to_hide, User::id());
} else {
    $ids_to_hide = array();
}
$random_query = Doctrine_Query::create()->select('a.username')->from('Accounts a')->leftJoin('a.Plan p')->where('LENGTH(p.edit_text) != 0')->andWhere('changed > DATE_SUB(NOW(), INTERVAL 1 YEAR)')->andWhereNotIn('a.userid', $ids_to_hide);
$offset = rand(0, $random_query->count() - 1);
$random_user = $random_query->offset($offset)->limit(1)->fetchOne();
header("Location: read.php?searchname=" . $random_user->username);

         $err = new AlertText("Plan [{$mysearch}] does not exist. Please check your spelling.", 'Search failed');
         $thispage->append($err);
         $donotsearch = true;
     } else {
         $plansearchname = "[" . $mysearch . "]";
         $mysearch = $plansearchname;
         $donotsearch = false;
     }
 }
 //if planlove
 if (!$donotsearch) {
     $mysearch = preg_replace("/\\&/", "&", $mysearch);
     $mysearch = preg_replace("/\\</", "&lt;", $mysearch);
     $mysearch = preg_replace("/\\>/", "&gt;", $mysearch);
     $mysearch = preg_quote($mysearch);
     $ids_to_hide = Block::allUserIdsWithBlockingRelationships($idcookie);
     if ($planlove) {
         // hit the index
         $q->select('a.username, p.plan, l.lover_id');
         $q->from('Planlove l')->leftJoin('l.Lover a')->leftJoin('a.Plan p');
         $q->where('l.lovee_id = ?', "{$thesearchnum}");
         $q->andWhereNotIn('l.lover_id', $ids_to_hide);
     } else {
         // do a slow query
         $q->select('a.username, p.plan');
         $q->from('Accounts a')->leftJoin('a.Plan p');
         $q->where('p.edit_text LIKE ?', "%{$mysearch}%");
         $q->andWhereNotIn('a.userid', $ids_to_hide);
     }
     if (!$idcookie) {
         $q->addWhere('a.webview=1');

//if time is out of acceptable period, set to 12
//give form to set how many hours back to look
$timeform = new Form('planwatchtimeform', true);
$timeform->action = 'planwatch.php';
$timeform->method = 'POST';
$thispage->append($timeform);
$item = new TextInput('mytime', $mytime);
$item->title = 'Plans updated in the past:';
$item->description = 'hours';
$item->cols = 2;
$timeform->append($item);
$item = new SubmitInput('See Plans');
$timeform->append($item);
$q = Doctrine_Query::create()->select("userid,username,DATE_FORMAT(changed,\n'%l:%i %p, %a %M %D ') as updated")->from("Accounts a")->where("changed > DATE_SUB(NOW(), INTERVAL ? HOUR)", $mytime)->orderBy("changed desc");
if (User::logged_in()) {
    $q->andWhereNotIn("userid", Block::allUserIdsWithBlockingRelationships(User::id()));
} else {
    $q->andWhere('webview = 1');
}
$results = $q->fetchArray();
//do the query with specifying date format to be returned
$newplanslist = new WidgetList('new_plan_list', true);
$thispage->append($newplanslist);
//display the results of the query
foreach ($results as $new_plans) {
    $entry = new WidgetGroup('newplan', false);
    $plan = new PlanLink($new_plans["username"]);
    $time = new RegularText($new_plans["updated"], 'Date Created');
    $entry->append($plan);
    $entry->append($time);
    $newplanslist->append($entry);