session_start(); require('backend/includes/php/include.php'); require('backend/includes/php/thumb.php'); $web_css = array( //array('href'=>'css/home.css'), ); $web_js = array( array('src'=>'tpl/home/js/home.js'), ); $texto_home = valPagina(1, $ID_EMPRESA, $IDIOMA); $texto_home2 = valPagina(1, $ID_EMPRESA, $IDIOMA, 2); $texto_home_boton1 = valPagina(11, $ID_EMPRESA, $IDIOMA); $texto_home_boton2 = valPagina(12, $ID_EMPRESA, $IDIOMA); $texto_home_boton3 = valPagina(13, $ID_EMPRESA, $IDIOMA); $mysql = new mysql; $link = $mysql->conectar(); $sql = "SELECT s.id_section, sl.nombre_section_translation, sl.texto_section_translation , sl.carpeta1, sl.carpeta2, sl.carpeta3, sl.carpeta4, sl.carpeta5, sl.carpeta6, sl.carpeta7, sl.carpeta8 FROM `section` s INNER JOIN section_translation sl ON sl.id_section = s.id_section INNER JOIN lang l ON l.lang = sl.lang WHERE s.id_empresa=$ID_EMPRESA AND NOT s.estado = 'S' AND l.lang = '$IDIOMA' AND s.id_section = 1 ORDER BY s.`id_section` DESC"; $dataT = $mysql->ejecutarS($sql, $link); foreach($dataT as $dataT10): $ruta_com1 = $dataT10['carpeta1']; $ruta_com2 = $dataT10['carpeta2']; $ruta_com3 = $dataT10['carpeta3']; $ruta_com4 = $dataT10['carpeta4']; $ruta_com5 = $dataT10['carpeta5']; $ruta_com6 = $dataT10['carpeta6']; $ruta_com7 = $dataT10['carpeta7']; $ruta_com8 = $dataT10['carpeta8']; $ruta_com1 = $mysql->ImagenPrincipal($ruta_com1, $link); $ruta_com2 = $mysql->ImagenPrincipal($ruta_com2, $link); $ruta_com3 = $mysql->ImagenPrincipal($ruta_com3, $link); $ruta_com4 = $mysql->ImagenPrincipal($ruta_com4, $link); $ruta_com5 = $mysql->ImagenPrincipal($ruta_com5, $link); $ruta_com6 = $mysql->ImagenPrincipal($ruta_com6, $link); $ruta_com7 = $mysql->ImagenPrincipal($ruta_com7, $link); $ruta_com8 = $mysql->ImagenPrincipal($ruta_com8, $link); break; endforeach; //HOME BOTON1 $sql = "SELECT s.id_section, sl.nombre_section_translation, sl.texto_section_translation , sl.carpeta1, sl.carpeta2, sl.carpeta3, sl.carpeta4, sl.carpeta5, sl.carpeta6, sl.carpeta7, sl.carpeta8 FROM `section` s INNER JOIN section_translation sl ON sl.id_section = s.id_section INNER JOIN lang l ON l.lang = sl.lang WHERE s.id_empresa=$ID_EMPRESA AND NOT s.estado = 'S' AND l.lang = '$IDIOMA' AND s.id_section = 11 ORDER BY s.`id_section` DESC"; $dataT = $mysql->ejecutarS($sql, $link); foreach($dataT as $dataT10): $ruta_com_boton1 = $dataT10['carpeta1']; $ruta_com_boton1 = $mysql->ImagenPrincipal($ruta_com_boton1, $link); break; endforeach; //END BOTON 1 //HOME BOTON2 $sql = "SELECT s.id_section, sl.nombre_section_translation, sl.texto_section_translation , sl.carpeta1, sl.carpeta2, sl.carpeta3, sl.carpeta4, sl.carpeta5, sl.carpeta6, sl.carpeta7, sl.carpeta8 FROM `section` s INNER JOIN section_translation sl ON sl.id_section = s.id_section INNER JOIN lang l ON l.lang = sl.lang WHERE s.id_empresa=$ID_EMPRESA AND NOT s.estado = 'S' AND l.lang = '$IDIOMA' AND s.id_section = 12 ORDER BY s.`id_section` DESC"; $dataT = $mysql->ejecutarS($sql, $link); foreach($dataT as $dataT10): $ruta_com_boton2 = $dataT10['carpeta1']; $ruta_com_boton2 = $mysql->ImagenPrincipal($ruta_com_boton2, $link); break; endforeach; //END BOTON 2 //HOME BOTON3 $sql = "SELECT s.id_section, sl.nombre_section_translation, sl.texto_section_translation , sl.carpeta1, sl.carpeta2, sl.carpeta3, sl.carpeta4, sl.carpeta5, sl.carpeta6, sl.carpeta7, sl.carpeta8 FROM `section` s INNER JOIN section_translation sl ON sl.id_section = s.id_section INNER JOIN lang l ON l.lang = sl.lang WHERE s.id_empresa=$ID_EMPRESA AND NOT s.estado = 'S' AND l.lang = '$IDIOMA' AND s.id_section = 13 ORDER BY s.`id_section` DESC"; $dataT = $mysql->ejecutarS($sql, $link); foreach($dataT as $dataT10): $ruta_com_boton3 = $dataT10['carpeta1']; $ruta_com_boton3 = $mysql->ImagenPrincipal($ruta_com_boton3, $link); break; endforeach; //END BOTON 3 $mysql->desconectar($link); $mysql = new mysql; $link = $mysql->conectar(); $id_tratamiento1 = 3; $sql = "SELECT t.id_tratamiento, tl.nombre_tratamiento_translation, tl.url_tratamiento_translation, tl.nota_tratamiento_translation, tl.descripcion_tratamiento_translation, tl.embed_tratamiento_translation, tl.carpeta_tratamiento_translation, t.fecha_tratamiento FROM `tratamiento` t INNER JOIN tratamiento_translation tl ON tl.id_tratamiento = t.id_tratamiento INNER JOIN lang l ON l.lang = tl.lang WHERE t.id_empresa=$ID_EMPRESA AND NOT t.estado = 'S' AND l.lang = '$IDIOMA' AND t.id_tratamiento = $id_tratamiento1 "; $dataT = $mysql->ejecutarS($sql, $link); foreach($dataT as $dataT10): $nombre_tratamiento1 = $dataT10['url_tratamiento_translation']; break; endforeach; $id_tratamiento2 = 5; $sql = "SELECT t.id_tratamiento, tl.nombre_tratamiento_translation, tl.url_tratamiento_translation, tl.nota_tratamiento_translation, tl.descripcion_tratamiento_translation, tl.embed_tratamiento_translation, tl.carpeta_tratamiento_translation, t.fecha_tratamiento FROM `tratamiento` t INNER JOIN tratamiento_translation tl ON tl.id_tratamiento = t.id_tratamiento INNER JOIN lang l ON l.lang = tl.lang WHERE t.id_empresa=$ID_EMPRESA AND NOT t.estado = 'S' AND l.lang = '$IDIOMA' AND t.id_tratamiento = $id_tratamiento2 "; $dataT = $mysql->ejecutarS($sql, $link); foreach($dataT as $dataT10): $nombre_tratamiento2 = $dataT10['url_tratamiento_translation']; break; endforeach; $site_title = "Dentist in Lima Peru - Dental Crowns, Veneers, Implants"; $site_description = "We are specialist dentists in Lima, Peru focusing on cosmetic dentistry, dental implants, crowns, veneers, inlays, and Invisalign orthodontics."; $tpl = 'tpl/home/home.php'; require ('tpl/layout.php');