public function getNews()
{
$issue_id = Input::get('issue_id');
$issue = Issue::find($issue_id);
$user_id = Input::get('user_id');
$politician_id = Input::get('politician_id');
$politician = Politician::find($politician_id);
$news = $issue->googleNews($politician->full_name);
$date = new DateTime();
$date->modify('-1 hour');
$formatted_date = $date->format('Y-m-d H:i:s');
$sum = Rating::where('user_id', '=', $user_id)->where('politician_id', '=', $politician->id)->where('issue_id', '=', $issue->id)->where('created_at', '>=', $formatted_date)->sum('value');
$response = array('sum' => $sum, 'news' => $news);
return Response::json($response);
}
<th>Created By</th>
<th>About/Politician</th>
<th>Content</th>
<th>Parent</th>
<th>Responses</th>
<th>Created At</th>
<th>Delete</th>
</tr>
</thead>
<tbody>
@foreach ($comments as $comment)
<?php
$username = User::find($comment->user_id)->username;
$politician_name = Politician::find($comment->politician_id)->full_name;
?>
<tr>
<td>{{$comment->id}}</td>
<td><a href="{{URL::route('profile-user',$username)}}" >{{$username}}</a></td>
<td><a href="{{URL::route('profile-politician',$politician_name)}}">{{$politician_name}}</a></td>
<td><a id ="{{'content-'.$comment->id}}" href="{{'http://iratepolitics.com/politicians/'.$politician_name.'/#'.$username.'-'.$comment->id}}">{{$comment->content}}</a></td>
<td>{{$comment->parent_id}}</a></td>
<td>{{Comment::where('parent_id','=',$comment->id)->count()}}</td>
<td>{{$comment->created_at}}</td>
<td><a data-toggle="modal" data-target="#delete-comment" class ="comment-delete-link" href="{{$comment->id}}">Delete</a></td>
</tr>
<div class="excerpt">
<p>{{$topArticle->content}}</p>
</div>
<div class="tags">
<a href="{{URL::route('profile-politician',$politician->full_name)}}">{{$politician->full_name}}</a>, <a href="{{URL::route('news',$issue->issue_name)}}">{{$issue->issue_name}}</a>
</div>
</div>
<div class="box-item">
<?php
$second_url = $topArticle->unescapedUrl;
$error = false;
do {
try {
$politician = Politician::find($most_popular_politicians[rand(0, 3)]->politician_id);
$topIssuesList = $politician->topIssues();
$issue = Issue::find($topIssuesList[rand(0, 4)]->issue_id);
$topArticle = $issue->googleNews($politician->full_name)[0];
} catch (Exception $e) {
$error = true;
}
} while ($error || $first_url == $topArticle->unescapedUrl || $second_url == $topArticle->unescapedUrl);
?>
@if(isset($topArticle->image->url))
<div class="article" title="" style="background-image: url('{{$topArticle->image->url}}');">
<a href="{{URL::route('article')}}{{'?url='.$topArticle->unescapedUrl}}{{'&pic='.$topArticle->image->url}}{{'&summary='.$topArticle->content}}{{'&title='.$topArticle->title}}" class="article-inner">
<span class="sprite news">NEWS</span>
</a>
</div>
@endif
public function issueVote()
{
$politician_id = Input::get('politician_id');
$issue_id = Input::get('issue_id');
$user_id = Auth::user()->id;
$vote_value = Input::get('vote');
$new_rating_array = array('politician_id' => $politician_id, 'user_id' => $user_id, 'issue_id' => $issue_id, 'value' => $vote_value);
$rating = Rating::create($new_rating_array);
//adjust politician rank
$politician = Politician::find($politician_id);
$politician->rank += $vote_value;
$politician->save();
$title = $politician->full_name . "'s Approval Over Last 7 Days";
$chartController = new ChartController();
$response = $chartController->generatePoliticianChart($politician_id, $title);
return Response::json($response);
// return Response::json($new_rating_array);
}
private function getName($id, $cat = 'P')
{
if ($cat == 'P') {
return Politician::find($id)->full_name;
} else {
return User::find($id)->username;
}
}
