public function toDateTime() { $dateTime = new \Datetime(); $dateTime->setDate($this->year, $this->month, $this->day); $dateTime->setTime(0, 0, 0); return $dateTime; }
/** * @return array */ public function findAllPerMonth() { $sql = 'SELECT DISTINCT CONCAT(MONTH(`created`), \' \', YEAR(`created`)) as month, avg(`usage`) as average, username FROM oc_uc_storageusage WHERE `usage` > 0 GROUP BY username, month'; $query = $this->db->prepareQuery($sql); $result = $query->execute(); $entities = array(); while ($row = $result->fetch()) { if (!isset($entities[$row['username']])) { $entities[$row['username']] = array(); } $date = explode(' ', $row['month']); $dateTime = new \Datetime(); $dateTime->setDate($date[1], $date[0], 1); $entities[$row['username']] = array_merge($entities[$row['username']], array(new StorageUsage($dateTime, $row['average'], $row['username']))); } return $entities; }
/** * Parse the results from the per month entities found * * @param \OC_DB_StatementWrapper $result * @return array */ private function parsePerMonthEntities($result) { $entities = array(); while ($row = $result->fetch()) { if (!isset($entities[$row['username']])) { $entities[$row['username']] = array(); } $date = explode(' ', $row['month']); $dateTime = new \Datetime(); $dateTime->setDate($date[1], $date[0], 1); $entities[$row['username']] = array_merge($entities[$row['username']], array(new StorageUsage($dateTime, $row['average'], $row['username'], $row['maximumusage']))); } return $entities; }
public function updateAction($id, Request $request) { $session = $request->getSession(); if (!$session->get('AdminAuth')) { return $this->redirect($this->generateUrl("login")); } $ArticleRepository = $this->getDoctrine()->getManager()->getRepository('EntityBundle:Article'); $articleOLD = $ArticleRepository->find($id); $arraydatedebut = array('day' => $articleOLD->getDateDebut()->format('d'), 'month' => $articleOLD->getDateDebut()->format('m'), 'year' => $articleOLD->getDateDebut()->format('Y')); // var_dump($arraydatedebut); $arraydatefin = array('day' => $articleOLD->getDateFin()->format('d'), 'month' => $articleOLD->getDateDebut()->format('m'), 'year' => $articleOLD->getDateDebut()->format('Y')); // var_dump($arraydatefin); $em = $this->getDoctrine()->getManager(); $build['article'] = $articleOLD; $build['datedebut'] = $arraydatedebut; $build['datefin'] = $arraydatefin; $build['years'] = range(1331, 1407); $localisation = $articleOLD->getLocalisation($articleOLD); $image = $articleOLD->getImage($articleOLD); if (!$articleOLD) { throw $this->createNotFoundException('No news found by id ' . $id); } if ($request->isMethod('POST')) { $datedebut = new \Datetime(); $dateDebutFrom = $request->request->all()['form']['dateDebut']; $datedebut->setDate($dateDebutFrom['year'], $dateDebutFrom['day'], $dateDebutFrom['month']); $datefin = new \Datetime(); $dateFinFrom = $request->request->all()['form']['dateFin']; $datefin->setDate($dateFinFrom['year'], $dateFinFrom['day'], $dateFinFrom['month']); /**/ $articleOLD = new Article(); $articleOLD->setId($id); $articleOLD->setDateDebut($datedebut); $articleOLD->setDateFin($datefin); $articleOLD->setIsDelete('0'); $articleOLD->setLocalisation($localisation); $articleOLD->setImage($image); $articleOLD->setTitre($request->request->all()['form']['titre']); $articleOLD->setSource($request->request->all()['form']['source']); $articleOLD->setDescription($request->request->all()['form']['description']); $em->persist($articleOLD); $em->flush(); return $this->redirect($this->generateUrl("admin_article_list")); } return $this->render('AdminBundle:Article:update.html.twig', $build); }
/** * Get datetime object from YYYYMMDDHHIISS number * * @param $idate * @return \Datetime */ public static function YYYYMMDDHHIISStoDate($idate) { $idate = trim($idate); $date = $idate . ""; $y = (int) substr($date, 0, 4); $m = (int) substr($date, 4, 2); $d = (int) substr($date, 6, 2); $h = (int) substr($date, 8, 2); $i = (int) substr($date, 10, 2); $s = (int) substr($date, 12, 2); $return = new \Datetime(); $return->setDate($y, $m, $d); $return->setTime($h, $i, $s); return $return; }