* 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