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();
