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);
}
}
