/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $student = Student::find($id); if ($student == NULL) { throw new Exception('Invalid Student ID'); } $student->year = (int) substr($student->year, 2, 4); $student_category = StudentCategories::find($student->category); $student->category = $student_category->category; $student_branch = Branch::find($student->branch); $student->branch = $student_branch->branch; if ($student->rejected == 1) { unset($student->approved); unset($student->books_issued); $student->rejected = (bool) $student->rejected; return $student; } if ($student->approved == 0) { unset($student->rejected); unset($student->books_issued); $student->approved = (bool) $student->approved; return $student; } unset($student->rejected); unset($student->approved); $student_issued_books = Logs::select('book_issue_id', 'issued_at')->where('student_id', '=', $id)->orderBy('time_stamp', 'desc')->take($student->books_issued)->get(); foreach ($student_issued_books as $issued_book) { $issue = Issue::find($issued_book->book_issue_id); $book = Books::find($issue->book_id); $issued_book->name = $book->title; $issued_book->issued_at = date('d-M', $issued_book->issued_at); } $student->issued_books = $student_issued_books; return $student; }
function destroy() { # @issue_count = @category.issues.size # if @issue_count == 0 # # No issue assigned to this category # @category.destroy # redirect_to :controller => 'projects', :action => 'settings', :id => @project, :tab => 'categories' # elsif params[:todo] # reassign_to = @project.issue_categories.find_by_id(params[:reassign_to_id]) if params[:todo] == 'reassign' # @category.destroy(reassign_to) # redirect_to :controller => 'projects', :action => 'settings', :id => @project, :tab => 'categories' # end App::import('model', 'Issue'); $Issue = new Issue(); $issue_count = $Issue->find('count', aa('conditions', aa('category_id', $this->params['id']))); if ($issue_count == 0) { $this->IssueCategory->del($this->params['id']); $this->redirect(aa('controller', 'projects', 'action', 'settings', 'project_id', $this->_project['Project']['identifier'], '?', 'tab=categories')); } elseif ($this->data) { $reassgin_to = null; if ($this->data['IssueCategory']['todo'] == 'reassgin_to') { $reassgin_to = $this->data['IssueCategory']['reassign_to_id']; } $this->IssueCategory->del_with_reassgin($this->params['id'], $reassgin_to); $this->redirect(aa('controller', 'projects', 'action', 'settings', 'project_id', $this->_project['Project']['identifier'], '?', 'tab=categories')); } $issue_category_data = $this->IssueCategory->find('first', aa('conditions', aa('IssueCategory.id', $this->params['id']))); $this->set('issue_category_data', $issue_category_data); $this->set('issue_count', $issue_count); }
public function show($id) { $issue = Issue::find($id); $retrievals = Retrieval::where('issue_id', '=', $id)->get(); $handbooks = Handbook::where('project_id', '=', Auth::user()->curr_project_id)->where('generation_id', '=', $issue->generation_id)->get(); $menu = 'student'; return View::make('retrievals.show', compact('issue', 'retrievals', 'handbooks', 'menu')); }
public function loadEarnables($issue_id) { $issue = Issue::find($issue_id); $receivable = Receivable::with('installments_not_paid')->where('issue_id', '=', $issue_id)->first(); $registrations = Registration::where('student_id', '=', $issue->student_id)->where('cost_is_paid', '=', 0)->get(); $movements = Movement::where('issue_id', '=', $issue_id)->get(); $punishments = Punishment::where('issue_id', '=', $issue_id)->where('paid', '=', 0)->get(); $resigns = Resign::where('issue_id', '=', $issue_id)->where('is_earned', '=', 0)->get(); $responses = array('receivable' => $receivable, 'registrations' => $registrations, 'movements' => $movements, 'punishments' => $punishments, 'resigns' => $resigns); return $responses; }
public function create($issue_id) { $issue = Issue::find($issue_id); $receivable = Receivable::with('installments')->where('issue_id', '=', $issue_id)->first(); $registration = Registration::where('student_id', '=', $issue->student_id)->where('cost_is_paid', '=', 0)->first(); $movements = Movement::where('issue_id', '=', $issue_id)->where('paid', '=', 0)->get(); $punishments = Punishment::where('issue_id', '=', $issue_id)->where('paid', '=', 0)->get(); $resigns = Resign::where('issue_id', '=', $issue_id)->where('fines', '>', 0.0)->where('is_earned', '=', 0)->get(); $employees = Employee::where('location_id', '=', Auth::user()->location_id)->get(); $menu = 'finance'; return View::make('earnings.create', compact('issue', 'receivable', 'registration', 'movements', 'punishments', 'resigns', 'employees', 'menu')); }
public function updateIssue() { $issue_name = Input::get('issue_name'); $issue_id = Input::get('issue_id'); $already_created = Issue::where('issue_name', '=', $issue_name); if (!($already_created->count() > 0)) { if (isset($issue_name)) { $issue = Issue::find($issue_id); $issue->issue_name = $issue_name; $issue->save(); return null; // Response::json(array('issue_name'=>'A WEALTH','issue_id'=>$issue_id)); } } else { //return Response::json(array('issue_name'=>'B WEALTH','issue_id'=>$issue_id)); return Response::json(array('issue_name' => $already_created->first()->issue_name)); } //return Response::json($return); }
public function destroy() { App::uses('Issue', 'Model'); $Issue = new Issue(); $issue_count = $Issue->find('count', array('conditions' => array('category_id' => $this->request->params['id']))); if ($issue_count == 0) { $this->IssueCategory->delete($this->request->params['id']); $this->redirect(array('controller' => 'projects', 'action' => 'settings', '?' => 'tab=categories', 'project_id' => $this->_project['Project']['identifier'])); } elseif ($this->request->data) { $reassgin_to = null; if ($this->request->data['IssueCategory']['todo'] == 'reassgin_to') { $reassgin_to = $this->request->data['IssueCategory']['reassign_to_id']; } $this->IssueCategory->del_with_reassgin($this->request->params['id'], $reassgin_to); $this->redirect(array('controller' => 'projects', 'action' => 'settings', '?' => 'tab=categories', 'project_id' => $this->_project['Project']['identifier'])); } $issue_category_data = $this->IssueCategory->find('first', array('conditions' => array('IssueCategory.id' => $this->request->params['id']))); $this->set('issue_category_data', $issue_category_data); $this->set('issue_count', $issue_count); }
public function store() { $fine = Input::get('fine'); $returnment = Input::get('returnment'); $returnment = str_replace(",", ".", $returnment); $returnment = str_replace(".", "", $returnment); $returnment = substr($returnment, 0, -2); $fine = str_replace(",", ".", $fine); $fine = str_replace(".", "", $fine); $fine = substr($fine, 0, -2); try { $resign = new Resign(); $resign->project_id = Auth::user()->curr_project_id; $resign->location_id = Auth::user()->location_id; $resign->issue_id = Input::get('issue_id'); $resign->employee_id = Input::get('employee_id'); $resign->classification_id = Input::get('classification_id'); $resign->resign_date = Input::get('date'); $resign->fines = $fine; $resign->returnment = $returnment; $resign->comments = Input::get('comments'); $resign->save(); $issue = Issue::with('placements')->find(Input::get('issue_id')); foreach ($issue->placements as $placement) { $placement->resign_id = $resign->id; $placement->active = 0; $placement->save(); } $issue = Issue::find(Input::get('issue_id')); $issue->is_active = 0; $issue->save(); return Response::json(array('status' => 'succeed')); } catch (Exception $e) { return Response::json(array('status' => 'failed', 'pesan' => $e)); } }
/** * Get number of issues in a certain product, category, status and founded by a certain user. * @param long $hunterUid - the unique ID of the user who founded the issue * @param long $productId - the unique ID of the product * @param int $issueCategoryId - the unique ID of a category of issue * @param int $issueStatusId - the unique ID of a status of issue * @return number of issues in a certain product, category, status and founded by a certain user */ public function getIssuesCountUsingHunterUidAndProductAndCategoryAndStatus($hunterUid, $productId, $issueCategoryId, $issueStatusId) { $conditions = $this->getQueryOfIssuesUsingHunterUidAndProductAndCategoryAndStatus($hunterUid, $productId, $issueCategoryId, $issueStatusId); $resultSet = Issue::find($conditions); return $resultSet->count(); }
require_once '../../../config.inc.php'; require_once 'common.php'; require_once '../../../third_party/lux-phpactiveresource/ActiveResource.php'; class Issue extends ActiveResource { // var $site = 'http://testlink.redmine:redmine2012@testlink.m.redmine.org/'; var $site = 'http://testlink.m.redmine.org/'; var $request_format = 'xml'; // REQUIRED! var $user = '******'; var $password = '******'; } // find issues $issue = new Issue(); new dBug($issue); $x = $issue->find('all'); var_dump($x); //$issues = $issueMgr->find(d); //echo '<pre>' . var_dump($issues) . '</pre>'; //$issuesQty = count($issues); //for ($idx=0; $idx < $issuesQty; $idx++) //{ // echo $issues[$idx]->subject; //} //// find and update an issue //$issue->find (1); //echo $issue->subject; //$issue->set ('subject', 'This is the new subject')->save (); //// delete an issue //$issue->find (1); //$issue->destroy ();
/** * Reassign assigned issues * @param int $user_id * @return int Number of issues affected * @throws \Exception */ public function reassignIssues($user_id) { if (!$this->id) { throw new \Exception("User is not initialized."); } $issue_model = new Issue(); $issues = $issue_model->find(array("owner_id = ? AND deleted_date IS NULL AND closed_date IS NULL", $this->id)); foreach ($issues as $issue) { $issue->owner_id = $user_id; $issue->save(); } return count($issues); }
public function home() { //Tag Cloud $con = mysqli_connect("127.0.0.1", "root", "pepper", "iratepolitics"); //create list of issues that have received votes by selecting //rows on first occurance of each unique value $query = "select id,issue_id from ratings group by issue_id;"; $result = mysqli_query($con, $query); $issue_tag_cloud = ""; $i = 0; //for each id in list of issues, count all the rows in ratings while ($row = mysqli_fetch_array($result)) { $query = "select id from ratings where issue_id=" . $row['issue_id']; //echo 'query: '.$query; $result2 = mysqli_query($con, $query); $issue_name = Issue::find($row['issue_id'])->issue_name; if ($issue_name != null) { $issue_tag_cloud .= '{text: "' . ucwords($issue_name) . '", weight: ' . mysqli_num_rows($result2) . ' , link: "' . URL::route('news', $issue_name) . '"},' . "\n"; } } //close while //remove trailing new line and trailing comma so tag cloud js will work $issue_tag_cloud = substr_replace($issue_tag_cloud, "", -1); $issue_tag_cloud = substr_replace($issue_tag_cloud, "", -1); //Comment Feed: Take top 3 highest ranked comments $comments = DB::table('comments')->where('politician_id', '>', 0)->orderBy('rank', 'desc')->orderBy('created_at', 'desc')->take(3)->get(); //News Feed: Take last 3 news for now $news = DB::table('news')->take(3)->get(); $comments_array = array(); $news_array = array(); $i = 0; foreach ($comments as $comment) { $comment_array[$i++] = array('user_id' => $comment->user_id, 'politician_id' => $comment->politician_id, 'created_at' => $comment->created_at, 'content' => $comment->content, 'id' => $comment->id); } $i = 0; foreach ($news as $article) { $news_array[$i++] = array('id' => $article->id, 'headline' => $article->headline, 'source' => $article->source, 'content' => $article->content, 'feature_pic_url' => $article->feature_pic_url); } return View::make('main')->with('comments', $comment_array)->with('news', $news_array)->with('most_popular_politicians', $this->mostPopular())->with('issue_tag_cloud', $issue_tag_cloud); }
public function edit($id) { $issueID = $id; $conditions = array('book_issue_id' => $issueID, 'return_time' => 0); $log = Logs::where($conditions); if (!$log->count()) { throw new Exception('Invalid Book ID entered or book already returned'); } else { $log = Logs::where($conditions)->firstOrFail(); $log_id = $log['id']; $student_id = $log['student_id']; $issue_id = $log['book_issue_id']; DB::transaction(function () use($log_id, $student_id, $issue_id) { // change log status by changing return time $log_change = Logs::find($log_id); $log_change->return_time = time(); $log_change->save(); // decrease student book issue counter $student = Student::find($student_id); $student->books_issued = $student->books_issued - 1; $student->save(); // change issue availability status $issue = Issue::find($issue_id); $issue->available_status = 1; $issue->save(); }); return 'Successfully returned'; } }
public function edit($id) { $student = Issue::find($id); $menu = 'student'; return View::make('students.edit', compact('student', 'menu')); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $issue = Issue::find($id); if ($issue == NULL) { throw new Exception('Invalid Book ID'); } $issue->added_at_timestamp = date('d-M-y h:i A', strtotime($issue->added_at_timestamp)); $book = Books::find($issue->book_id); $issue->book_name = $book->title; $issue->author = $book->author; $issue->category = Categories::find($book->category_id)->category; $issue->available_status = (bool) $issue->available_status; if ($issue->available_status == 1) { return $issue; } $conditions = array('return_time' => 0, 'book_issue_id' => $id); $book_issue_log = Logs::where($conditions)->take(1)->get(); foreach ($book_issue_log as $log) { $student_id = $log->student_id; } $student_data = Student::find($student_id); unset($student_data->email_id); unset($student_data->books_issued); unset($student_data->approved); unset($student_data->rejected); $student_branch = Branch::find($student_data->branch)->branch; $roll_num = $student_data->roll_num . '/' . $student_branch . '/' . substr($student_data->year, 2, 4); unset($student_data->roll_num); unset($student_data->branch); unset($student_data->year); $student_data->roll_num = $roll_num; $student_data->category = StudentCategories::find($student_data->category)->category; $issue->student = $student_data; return $issue; }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function delete($id) { //Soft delete the item $issue = Issue::find($id); $issue->delete(); // redirect return Redirect::route('issue.index')->with('message', trans('messages.issue-succesfully-deleted')); }
public function profilePolitician($fullname) { //gets politician record by fullname $politician = Politician::where('full_name', '=', $fullname); if ($politician->count()) { //shows only issues logged in user follows if (Auth::check()) { $issues = User::find(Auth::user()->id)->issues; } else { $issues = null; } //gets specific politician entity/record $politician = $politician->first(); //make list of all ids $democrat_ratings = array(); $republican_ratings = array(); //Hate to throw tacky direct php mysql queries instead of ORM. But having trouble with //ORM query logic for inner joins of derived tables. Need beta now and will ORM later. $con = mysqli_connect("127.0.0.1", "root", "pepper", "iratepolitics"); //Democrat Ratings: Get value and timestamp of all democrat users' ratings for this politician $query = "select value,r.created_at from (select * from ratings where politician_id='" . $politician->id . "') as r inner join (select * from users where party='Democrat') as u on r.user_id = u.id"; $result = mysqli_query($con, $query); $i = 0; while ($row = mysqli_fetch_array($result)) { $democrat_ratings[$i++] = array('value' => $row['value'], 'created_at' => $row['created_at']); } //close while //Republican Ratings: Get value and timestamp of all republican users' ratings for this politician $query = "select value,r.created_at from (select * from ratings where politician_id='" . $politician->id . "') as r inner join (select * from users where party='Republican') as u on r.user_id = u.id"; $result = mysqli_query($con, $query); $i = 0; while ($row = mysqli_fetch_array($result)) { $republican_ratings[$i++] = array('value' => $row['value'], 'created_at' => $row['created_at']); } //close while mysqli_close($con); //we have raw data. now we need to turn data into format for highchart with appropriate time interval resolution //For now we are going to use 7 day intervals. So we are going back 7 days from today. //0 on x-axis is 7 days ago. //creating array where each index represents a day (whatever time unit in future) //For now, 0 is 7 days ago. So we loop through each day and sum up all raw data values that took place during //that time unit $todays_date = new DateTime("now"); $democrat_chart_data = array("0" => 0, "1" => 0, "2" => 0, "3" => 0, "4" => 0, "5" => 0, "6" => 0); foreach ($democrat_ratings as $rating) { $rate = array(); $rating_date = new DateTime($rating['created_at']); //echo ' Rating Date: '.$rating_date->format("Y-m-d H:i:s"); $date_interval = $todays_date->diff($rating_date); //echo ' $date_interval: '.$date_interval->format("%a")."days\n"; $date_interval = intval($date_interval->format("%a")); if ($date_interval <= 6) { $democrat_chart_data[6 - $date_interval] += $rating['value']; } } $republican_chart_data = array("0" => 0, "1" => 0, "2" => 0, "3" => 0, "4" => 0, "5" => 0, "6" => 0); foreach ($republican_ratings as $rating) { $rate = array(); $rating_date = new DateTime($rating['created_at']); //echo ' Rating Date: '.$rating_date->format("Y-m-d H:i:s"); $date_interval = $todays_date->diff($rating_date); //echo ' $date_interval: '.$date_interval->format("%a")."days\n"; $date_interval = intval($date_interval->format("%a")); if ($date_interval <= 6) { $republican_chart_data[6 - $date_interval] += $rating['value']; } } //Issue Tag Cloud $con = mysqli_connect("127.0.0.1", "root", "pepper", "iratepolitics"); //create list of issues for which politician has received votes by selecting //rows on first occurance of each unique value $query = "select id,issue_id from ratings where politician_id=" . $politician->id . " group by issue_id;"; $result = mysqli_query($con, $query); $issue_tag_cloud = ""; $i = 0; //for each id in list of issues, count all the rows in ratings where a vote was made for that politician & that issue //this is a count of 'activity' for each issue per politican. (ex. votes on Pelosi's stance on Obamacare) while ($row = mysqli_fetch_array($result)) { $query = "select id from ratings where issue_id=" . $row['issue_id'] . " and politician_id=" . $politician->id; //echo 'query: '.$query; $result2 = mysqli_query($con, $query); $issue_name = Issue::find($row['issue_id'])->issue_name; $issue_tag_cloud .= '{text: "' . ucwords($issue_name) . '", weight: ' . mysqli_num_rows($result2) . ' , link: "' . URL::route('news', $issue_name) . '"},' . "\n"; } //close while //remove trailing new line and trailing comma so tag cloud js will work $issue_tag_cloud = substr_replace($issue_tag_cloud, "", -1); $issue_tag_cloud = substr_replace($issue_tag_cloud, "", -1); //Display Comments...only comments with no parents $comments = $politician->comments()->where('parent_id', '=', '0')->orderBy('rank', 'desc')->orderBy('created_at', 'desc')->get(); //$comments = Comment::where('politician_id','=',$politician->id)->where('parent_id', '=', '0')->get(); if (Auth::check()) { $issues_not_followed = $this->issuesNotFollowed(Auth::user()->id); } else { $issues_not_followed = Issue::all(); } $fb_og = array('url' => Request::url(), 'title' => $politician->full_name, 'image' => $_SERVER['SERVER_NAME'] . $politician->pic_url, 'description' => $politician->bio); return View::make('politician')->with('politician', $politician)->with('issues', $issues)->with('comments', $comments)->with('democrat_chart_data', $democrat_chart_data)->with('republican_chart_data', $republican_chart_data)->with('issue_tag_cloud', $issue_tag_cloud)->with('issues_not_followed', $issues_not_followed)->with('fb_og', $fb_og)->with('title', $politician->full_name . "'s Profile"); } else { return App::abort(404); } //if politician not found in database then page not found error returned. }
#!/usr/bin/php <?php require_once '/Users/xxxxxxxxxx/Documents/Timeline/redmine/ActiveResource.php'; date_default_timezone_set("GMT"); class Issue extends ActiveResource { var $site = 'http://xxxxxxxxxxxxxxx/'; var $request_format = 'xml'; } // find issues $script_ts = file_get_contents("/Users/xxxxxxxxxxxx/Documents/Timeline/redmine/ts_redmine.txt"); echo $script_ts . "\n"; $issue = new Issue(array('subject' => 'XML REST API', 'project_id' => '2')); $issues = $issue->find('all'); for ($i = 0; $i < count($issues); $i++) { if ($issues[$i]->updated_on > $script_ts) { exec("osascript /Users/xxxxxxxxx/Documents/Timeline/redmine/redmine.scpt \"" . $issues[$i]->project['name'] . "\" \"" . $issues[$i]->subject . "\" \"" . $issues[$i]->status['name'] . "\" \"" . $issues[$i]->done_ratio . "\""); } } file_put_contents("/Users/xxxxxxxxxx/Documents/Timeline/redmine/ts_redmine.txt", date("Y-m-d\\TH:i:s\\Z"));
/** * GET /issues/1 * Show a given issue. * * @param int $id * @return Response */ public function show($id) { $issue = $this->issue->find($id); return View::make('issues.show', compact('id', 'issue'))->withTitle('Showing issue'); }
</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 <h3><a href="{{URL::route('article')}}{{'?url='.$topArticle->unescapedUrl}}@if(isset($topArticle->image->url)){{'&pic='.$topArticle->image->url}}@endif{{'&summary='.$topArticle->content}}{{'&title='.$topArticle->title}}">{{$topArticle->title}}</a></h3><br>