* Created by PhpStorm.
* User: Ken
* Date: 12/06/14
* Time: 09:53
*/
$projectRoot = $_SERVER['DOCUMENT_ROOT'] . '/OwlEyes';
require_once $projectRoot . '/required.php';
session_start();
$userManager = new UserPdoManager();
$planManager = new RefPlanPdoManager();
$accountManager = new AccountPdoManager();
if (isset($_SESSION['owleyesOK'])) {
$userSession = unserialize($_SESSION['owleyesOK']);
$user = $userManager->findById($userSession->getId());
//retrouve l'user connecté grâce à l'id en session
$userAccount = $accountManager->findById($user->getCurrentAccount());
//retrouve le compte user
$userPlan = $planManager->findById($userAccount->getRefPlan());
//retrouve le plan user
$startDateArray = $accountManager->formatMongoDate($userAccount->getStartDate());
$endDateArray = $accountManager->formatMongoDate($userAccount->getEndDate());
} else {
header('Location:/OwlEyes/pages/login.php');
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Owl Eyes | Dashboard</title>
<meta content='width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no' name='viewport'>
/**
* Created by PhpStorm.
* User: Ken
* Date: 09/06/14
* Time: 15:02
*/
include '../header/header.php';
if (isset($_GET['id'])) {
$id = $_GET['id'];
}
$userManager = new UserPdoManager();
$planManager = new RefPlanPdoManager();
$accountManager = new AccountPdoManager();
$allplan = $planManager->findAll();
$account = $accountManager->findById($id);
//id account
$accountUser = $account->getUser();
//id user
$currentPlan = $planManager->findById($account->getRefPlan());
//id du plan
$user = $userManager->findById($accountUser);
//récupère la collection user via id
/*********************************/
$criteria2014 = array('idUser' => $accountUser, 'startDate' => array('$gt' => new MongoDate(strtotime("2014-01-01 00:00:00")), '$lte' => new MongoDate(strtotime("2014-12-30 23:59:59"))));
$filterDate = $accountManager->find($criteria2014);
//foreach($filterDate as $thisAccount)
//{
//
// var_dump($thisAccount->getStorage());
// echo 'getUser';
<?php
/**
* Created by PhpStorm.
* User: Ken
* Date: 10/06/14
* Time: 15:02
* Permet la désactivation d'un Plan
*/
$projectRoot = $_SERVER['DOCUMENT_ROOT'] . '/OwlEyes';
require_once $projectRoot . '/required.php';
$id = $_GET['id'];
var_dump($id);
$accountManager = new AccountPdoManager();
$userManager = new UserPdoManager();
$account = $accountManager->findById($id);
$user = $accountManager->findById($id);
//Critère de recherche pour le compte
$criteriaAccount = array('_id' => new MongoId($account->getId()));
//Critère de recherche pour le user
$criteriaUser = array('_id' => new MongoId($account->getUser()));
$updateCriteria = array('$set' => array('state' => new MongoInt32(0)));
var_dump($criteriaUser);
var_dump($updateCriteria);
$disableUserAccount = $accountManager->findAndModify($criteriaAccount, $updateCriteria, NULL, array('new' => TRUE));
$disableUser = $userManager->findAndModify($criteriaUser, $updateCriteria, NULL, array('new' => TRUE));
header('Location: ../pages/users.php');
var_dump($accountFind);
echo '____Retourne en objet';
$accountFind = $accountPdoManager->find(array('state' => 1));
var_dump($accountFind);
echo '----------------------------------------<br />';
echo 'Utilisation du findOne';
$array = array('_id' => new MongoId('52eb602d3263d8b6a4395df3'), 'state' => 1, 'idUser' => null, 'idRefPlan' => new MongoId('52eb5e783263d8b6a4395df1'), 'storage' => 2, 'ratio' => 1, 'startDate' => '01-31-2014', 'endDate' => 'none');
$manualAccount = new Account($array);
$accountFindOne = $accountPdoManager->findOne($manualAccount, array('_id'));
var_dump($accountFindOne);
echo '____equivalent du findById';
$accountFindOne = $accountPdoManager->findOne(array('_id' => $accountFind[0]->getId()));
var_dump($accountFindOne);
echo '----------------------------------------<br />';
echo 'Utilisation du findById avec un MongoId en parametre';
$accountFoundById = $accountPdoManager->findById($accountFind[0]->getId());
var_dump($accountFoundById);
echo 'Utilisation du findById avec une string en parametre';
$accountFoundById = $accountPdoManager->findById((string) $accountFind[0]->getId());
var_dump($accountFoundById);
echo '----------------------------------------<br />';
echo 'Recuperer tous les comptes';
$allAccounts = $accountPdoManager->findAll();
var_dump($allAccounts);
echo '----------------------------------------<br />';
echo 'Utilisation du findAndModify puis create<br />';
$searchQuery = array('state' => 1);
$updateCriteria = array('$set' => array('storage' => (int) 2));
$fields = array('state' => 1);
$options = array('new' => true);
//pour récupérer l'account après modification
