public function getLastOrderByGuide(\Buggl\MainBundle\Entity\EGuide $eGuide) { $sql = "SELECT sd.* \n\t\t\t\t\tFROM e_guide_to_spot_detail sd\n\t\t\t\t\tWHERE 1\n\t\t\t\t\t\tAND sd.e_guide_id = ?\n\t\t\t\t\t\tORDER BY sd.order DESC\n\t\t\t\t\t\tLIMIT 0, 1"; $params = array($eGuide->getID()); $em = $this->getEntityManager(); $rsm = new ResultSetMappingBuilder($em); $rsm->addRootEntityFromClassMetadata('BugglMainBundle:EGuideToSpotDetail', 'sd'); $query = $this->_em->createNativeQuery($sql, $rsm); $query->setParameters($params); try { $result = $query->getResult(); } catch (\Doctrine\ORM\NoResultException $e) { return null; } return $result; }
private function createHtml(\Buggl\MainBundle\Entity\EGuide $eguide, $filename = null, $domain = null) { if (is_null($domain)) { $url = "http://" . $_SERVER['HTTP_HOST'] . "/guide-preview/" . $eguide->getID(); } else { $url = "http://" . $domain . "/guide-preview/" . $eguide->getID(); } // echo "<br/>html preview : ".$url."<br/>"; $htmlDocRoot = $this->rootDir . '/../web/uploads/eguide_html'; if (!is_writable($htmlDocRoot)) { mkdir("{$htmlDocRoot}", 0755); } $slug = str_replace($this->removeChars, '', $eguide->getSlug()); $filename = is_null($filename) ? $slug . ".html" : $filename; $htmlFile = $htmlDocRoot . "/" . $filename; if (!file_exists($htmlFile)) { $ch = curl_init($url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $data = curl_exec($ch); curl_close($ch); file_put_contents($htmlFile, $data); } }