public function getPointsAdded() { try { $db = new DB(); $return = array(); $_hP = new Project(); //helper $_id = $this->id; $items = $db->query("SELECT p.id \n FROM " . $_hP->table . " p, " . $_hP->table_points . " i\n WHERE p.id = i.project AND p.active = 1 AND i.user = '******' ORDER BY p.started DESC"); if ($items) { foreach ($items->fetchAll() as $item) { $obj_p = new Project(); $return[] = $obj_p->getFromId($item['id']); } } } catch (PDOException $e) { print "Error!: " . $e->getMessage() . "<br/>"; die; } return $return; }
} else { $error = true; } if (!$error) { $project->setItem($items); if ($project->save()) { $this->addTwigVars("validation_ok", true); } else { $this->addTwigVars("validation_ok", false); } } else { $this->addTwigVars("validation_ok", false); } } //Load projects $obj_p = new Project(); // Today projects $today = date('Y-m-d', time()); $todayProjects = $obj_p->getLastProjects($today); $this->addTwigVars('todayProjects', $todayProjects); // Yesterday projects $yDay = date('Y-m-d', time()); $yesterday = strtotime('-1 day', strtotime($yDay)); $yesterday = date('Y-m-d', $yesterday); $yesterdayProjects = $obj_p->getLastProjects($yesterday); $this->addTwigVars('yesterdayProjects', $yesterdayProjects); // 2 days ago projects $twoDay = date('Y-m-d', time()); $twoAgo = strtotime('-2 day', strtotime($twoDay)); $twoAgo = date('Y-m-d', $twoAgo); $twoAgoProjects = $obj_p->getLastProjects($twoAgo);
/* * Copyright (c) 2014 Alberto González * Distributed under MIT License * (see README for details) */ require "../ajax.php"; use Quaver\Model\Project; if ($_user->logged) { $response = NULL; $pid = $_REQUEST['pid']; $status = $_REQUEST['status']; $uid = $_user->id; if ($status == '') { $status = 0; } if (isset($pid) && isset($uid) && isset($status)) { //$_date = date('Y-m-d', time()); $obj_p = new Project(); $actionPoint = $obj_p->actionPoint($pid, $uid, $status); if ($actionPoint) { $response = '<a href="#" class="vote" data-id=' . $pid . ' data-status="0"><i class="vote-icon fa fa-caret-square-o-up fa-2x"></i></a>'; } else { $response = '<a href="#" class="vote" data-id=' . $pid . ' data-status="1"><i class="vote-icon-active fa fa-caret-square-o-up fa-2x"></i></a>'; } echo json_encode($response); } else { echo json_encode($response); } } else { echo json_encode($response); }
<?php /* * Copyright (c) 2014 Alberto González * Distributed under MIT License * (see README for details) */ namespace Quaver\Controller; use Quaver\Model\Project; // Set vars $_id = null; $p = null; $obj_project = null; $_id = $this->url_var[1]; if (isset($_id)) { $obj_project = new Project(); $p = $obj_project->getFromId($_id); header("Location: " . $p->url); exit; } else { header("Location: /"); exit; }
<?php /* * Copyright (c) 2014 Alberto González * Distributed under Apache License 2.0 * (see README for details) */ namespace Quaver\Controller; use Quaver\Model\Project; use Quaver\Model\ProjectComment; $obP = new Project(); $_project = $obP->getFromSlug($this->url_var[1]); // No project? if (empty($_project->id)) { header("Location: " . $this->getUrlFromId(2) . "?ref=" . $this->getUrl()); exit; } // Project not accepted? if (!$_project->isActive() && !$_user->isAdmin()) { header("Location: " . $this->getUrlFromId(2) . "?ref=" . $this->getUrl()); exit; } // General $this->addTwigVars('project', $_project); $this->addTwigVars('title', $_project->name() . " - PH Clone"); switch (@$this->url_var[2]) { default: if (!empty($_POST) and $_user->logged && isset($_POST['comment'])) { $comment = new ProjectComment(); if (!empty($_POST['reply-to']) && isset($_POST['reply-to'])) {
/** * getLastProjects function. * * @access public * @return void */ public function getLastProjects($_date) { $return = NULL; try { $db = new DB(); $return = array(); $items = $db->query("SELECT id \n FROM " . $this->table . " \n WHERE active = 1 AND DATE(started) = '" . $_date . "' ORDER BY started DESC"); if ($items) { foreach ($items->fetchAll() as $item) { $obj_p = new Project(); $return[] = $obj_p->getFromId($item['id']); } } } catch (PDOException $e) { print "Error!: " . $e->getMessage() . "<br/>"; die; } return $return; }
<?php /* * Copyright (c) 2014 Alberto González * Distributed under MIT License * (see README for details) */ require "../ajax.php"; use Quaver\Model\Project; use Quaver\Model\User; //sanitize post value $last_date = filter_var($_POST["last_date"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH); //set new project object $p = new Project(); // prepare day block $datetime = DateTime::createFromFormat('Y-m-d', $last_date); $datetime->sub(new DateInterval('P1D')); $date = $datetime->format('Y-m-d'); $dateHeader = $datetime->format("l, F jS"); $headerBlock = '<div class="block-day"> <time class="date center" datetime="' . $date . '"> <i class="fa fa-calendar"></i> ' . $dateHeader . ' </time>'; $footerBlock = '</div>'; //Limit our results within a specified date $results = $p->getLastProjects($date); if ($results) { //set new user $u = new User();