<?php /** * 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());
$refPlanFoundById = $refPlanPdoManager->findById(new MongoId('52eb5e743263d8b6a4395df0')); var_dump($refPlanFoundById); echo 'Utilisation du findById avec une string en parametre'; $refPlanFoundById = $refPlanPdoManager->findById('52eb5e743263d8b6a4395df0'); var_dump($refPlanFoundById); echo '----------------------------------------<br />'; echo 'Retrouver les plans gratuits'; $freePlans = $refPlanPdoManager->findFreePlans(); var_dump($freePlans); echo '----------------------------------------<br />'; echo 'Retrouver les plans premium'; $premiumPlans = $refPlanPdoManager->findPremiumPlans(); var_dump($premiumPlans); echo '----------------------------------------<br />'; echo 'Recuperer tous les plans'; $allPlans = $refPlanPdoManager->findAll(); var_dump($allPlans); echo '----------------------------------------<br />'; echo 'Utilisation du findAndModify puis create<br />'; $searchQuery = array('name' => 'Pro'); $updateCriteria = array('$inc' => array('price' => (int) 1), '$set' => array('maxRatio' => (int) 51)); $fields = array('price' => 1, 'maxRatio' => 1); $options = array('new' => true); //pour récupérer le refPlan après modification echo '____recupere le plan AVANT modification'; $plan = $refPlanPdoManager->findAndModify($searchQuery, $updateCriteria); var_dump($plan); echo '____------<br />'; echo '____recupere uniquement les champs price et maxRatio (et id qui est obligatoire) APRES modification'; $updatedPlan = $refPlanPdoManager->findAndModify($searchQuery, $updateCriteria, $fields, $options); var_dump($updatedPlan);