+ Error on line 8
$idioma = substr($_SERVER['HTTP_ACCEPT_LANGUAGE'], 0, 2);
<?php
class MainController extends DooController {
public $data;
public function index() {
$idioma = substr($_SERVER['HTTP_ACCEPT_LANGUAGE'], 0, 2);
return Doo::conf()->APP_URL . $idioma;
}
public function spanish() {
$idioma = "spanish.php";
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->data['idioma'] = $idioma;
$this->buildMenu("es");
$this->buildMenuFooter("es");
$this->banners("es");
$this->Noticias("es");
$p = Doo::db()->find('Pages', array("where" => "page= 'inicio' ", "limit" => 1));
$this->data['titulo'] = $p->titulo;
$this->data['html'] = $p->descripcion;
$this->data['color'] = $p->color;
$video = Doo::db()->find('Videos', array("where" => "estado=1", "limit" => 1));
$this->data['video'] = $video->link;
$certificados = Doo::db()->find('Certificados', array("select" => "id,titulo,nombre,codigo,imagen,documento", "where" => "principal='S' AND estado = 1", "desc" => "nombre"));
$this->data['certificados'] = $certificados;
$b = Doo::db()->find('Pages', array("where" => "page= 'bienvenido' ", "limit" => 1));
$this->data['titulobienvenido'] = $b->titulo;
$this->data['htmlbienvenido'] = $b->descripcion;
$bt = Doo::db()->find('Pages', array("where" => "page= 'textobanner' ", "limit" => 1));
$this->data['titulobienvenido'] = $bt->titulo;
$this->data['textobanner'] = $bt->descripcion;
$this->buildHiper('es');
$this->data['Hipervinculos'];
$this->data['content'] = 'inicio';
$this->data['scriptactiveP'] = "$('#HL1').addClass('');";
$this->data['scriptactiveM'] = "$('#HL1').addClass('');";
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function english() {
$_SESSION['Hipervinculos'] = NULL;
$idioma = "english.php";
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->data['idioma'] = $idioma;
$this->buildMenu("en");
$this->buildMenuFooter("en");
$this->banners("en");
$this->Noticias("en");
$p = Doo::db()->find('Pages', array("where" => "page= 'inicio' ", "limit" => 1));
$this->data['titulo'] = $p->titulo2;
$this->data['html'] = $p->english;
$this->data['color'] = $p->color;
$video = Doo::db()->find('Videos', array("where" => "estado=1", "limit" => 1));
$this->data['video'] = $video->link;
$certificados = Doo::db()->find('Certificados', array("select" => "id,titulo_ingles as titulo,nombre,codigo,imagen,documento", "where" => "principal='S' AND estado = 1", "desc" => "nombre"));
$this->data['certificados'] = $certificados;
$b = Doo::db()->find('Pages', array("where" => "page= 'bienvenido' ", "limit" => 1));
$this->data['titulobienvenido'] = $b->titulo2;
$this->data['htmlbienvenido'] = $b->english;
$bt = Doo::db()->find('Pages', array("where" => "page= 'textobanner' ", "limit" => 1));
$this->data['titulobienvenido'] = $bt->titulo2;
$this->data['textobanner'] = $bt->english;
$this->buildHiper('en');
$this->data['Hipervinculos'];
$this->data['content'] = 'inicio';
$this->data['scriptactiveP'] = "$('#HL1').addClass('');";
$this->data['scriptactiveM'] = "$('#HL1').addClass('');";
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function configuracion (){
$configuracion = Doo::db()->find('Configuracion', array("select" => "nombre_empresa,"
. "telefono_empresa,cel_empresa,email_empresa,direccion_empresa,"
. "ciudad_empresa,facebook,twitter,instagram", 'limit' => 1));
$this->data['empresa'] = $configuracion->nombre_empresa;
$this->data['telefono'] = $configuracion->telefono_empresa;
$this->data['celular'] = $configuracion->cel_empresa;
$this->data['email'] = $configuracion->email_empresa;
$this->data['direccion'] = $configuracion->direccion_empresa;
$this->data['ciudad'] = $configuracion->ciudad_empresa;
$this->data['facebook'] = $configuracion->facebook;
$this->data['twitter'] = $configuracion->twitter;
$this->data['instagram'] = $configuracion->instagram;
$this->data['youtube'] = $configuracion->youtube;
$this->data["red_gama"]=Doo::db()->query("SELECT * FROM red_gama")->fetchAll();
}
public function buildHiper($idioma) {
$html = null;
if ($idioma == 'es') {
$opciones = Doo::db()->query("SELECT h.id,h.`texto` AS texto,h.`link`,h.`submenu`,h.`depende`,h.`principal` FROM hipervinculos h WHERE principal='S' AND h.`depende`=0")->fetchAll();
} else {
$opciones = Doo::db()->query("SELECT h.id,h.`text` AS texto,h.`link`,h.`submenu`,h.`depende`,h.`principal` FROM hipervinculos h WHERE principal='S' AND h.`depende`=0")->fetchAll();
}
foreach ($opciones as $key => $value):
if ($value['submenu'] == 'S') {
$html.="<li>";
$html.= '<select id="itisel" name="itisel" style="box-shadow: none; font-size: 16px;
height: 31px;font-weight: normal; padding: 0; border-radius: 0;border:
1px solid transparent; -moz-appearance: none; -webkit-appearance: none;
appearance: none;" class="form-control titulos">';
$html.="<option value='$value[link]' >$value[texto]</option>";
$html.= $this->buildHiperChild($value['id'], $idioma);
} else {
$html.="<li>"
. "<a style='padding: 0px;' target='_blank' href='$value[link]' class='titulos'>$value[texto]</a>";
}
$html.="</li>";
$html.='<li class="divider"> </li>';
endforeach;
$this->data['Hipervinculos'] = $html;
}
public function buildHiperChild($id, $idioma) {
$html = null;
$inc = 1;
if ($idioma == 'es') {
$opciones = Doo::db()->query("SELECT h.id,h.`texto` as texto,h.`link`,h.`link`,h.submenu FROM hipervinculos h WHERE depende='$id'")->fetchAll();
} else {
$opciones = Doo::db()->query("SELECT h.id,h.`text`as texto,h.`link`,h.`link`,h.submenu FROM hipervinculos h WHERE depende='$id'")->fetchAll();
}
foreach ($opciones as $key => $value):
$html.="<option value='$value[link]'>$value[texto]</option>";
$inc++;
endforeach;
$html.=' </select>';
return $html;
}
public function destacadas($idioma) {
Doo::loadModel("Articulos");
$a = new Articulos();
$a->publicado = "S";
$a->destacada = "S";
$articles = Doo::db()->find($a, array(
"select" => "id,titulo,intro,link,imagen,orden",
"order by" => "orden", "desc" => "orden",
"asArray" => true));
return $articles;
}
public function banners($idioma) {
if ($idioma == "es") {
$banner = Doo::db()->find('Articulos', array("select" => "id,titulo,titulo2,color,color2,descripcion,imagen", "order by" => "orden", "asc" => "orden"));
} else {
$banner = Doo::db()->find('Articulos', array("select" => "id,tituloingles AS titulo,tituloingles2 AS titulo2,color,color2,descripcioningles AS descripcion,imagen", "order by" => "orden", "asc" => "orden"));
}
$this->data['banners'] = $banner;
}
public function Itinerario() {
$itiselec = $_GET['itisel'];
//echo $itiselec; //imprimes el valor del "value" elegido
switch ($itiselec) {
case 0:
$url = $this->data['rootUrl'] = Doo::conf()->APP_URL;
echo "<SCRIPT>window.location='$url';</SCRIPT>";
break;
case 1:
$url = "http://online.puertocartagena.com/sprconline/estport.nsf/portuarioSP?openPage";
echo "<SCRIPT>window.location='$url';</SCRIPT>";
break;
case 2:
$url = "http://www.sprb.com.co/sprb_files/situamuelle.php";
echo "<SCRIPT>window.location='$url';</SCRIPT>";
break;
case 3:
$url = "http://www.sprbun.com/informacion-para-comercio-exterior/situacion_portuaria/muelle.php";
echo "<SCRIPT>window.location='$url';</SCRIPT>";
break;
case 4:
$url = "http://www.oceanschedules.com/schedules/search.do";
echo "<SCRIPT>window.location='$url';</SCRIPT>";
break;
}
}
public function imagen() {
$param = $this->params['pindex'];
$id = $_REQUEST['id'];
$rs = Doo::db()->find($param, array("select" => "imagen",
"where" => "id = ?",
"limit" => 1,
"param" => array($id)));
$imagen = $rs->imagen;
if ($imagen == "") {
echo "";
} else {
Header("Content-type: image/jpg ");
echo $imagen;
}
}
public function verMapa() {
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('mapa', $this->data);
}
public function iniciars() {
$nickname = $_POST["nickname"];
$clave = $_POST["clave"];
$rs = Doo::db()->query("select * from afiliados where usuario = ? and password = MD5(?) AND estado=2", array($nickname, $clave))->fetch();
if (isset($rs["usuario"])) {
Doo::loadModel("Afiliados");
$_SESSION["reg_user"] = new Afiliados($rs);
return Doo::conf()->APP_URL;
} else {
$this->data["msj_error"] = "El usuario no esta registrado";
$this->entrar();
}
}
public function entrar() {
$this->buildMenu();
$this->data['titulo'] = "Iniciar Sesión";
$this->data['content'] = 'iniciar';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function salir() {
$_SESSION["reg_user"] = null;
return Doo::conf()->APP_URL;
}
public function showPage() {
$page = $this->params['pagina'];
Doo::loadModel("Pages");
$p = new Pages();
$p->page = $page;
$p = Doo::db()->find($p, array('limit' => 1));
$idiomapage = $this->params['idioma'];
//$this->data['link'] = "$('li.$page').addClass('active');\n";
if ($p->privado == "1") {
if (isset($_SESSION["reg_user"])) {
$this->data['titulo'] = $p->titulo;
$this->data['html'] = $p->descripcion;
$this->data['revista'] = $p->revista;
$this->buildMenu();
$this->data['scriptactiveM'] = "$('#M$p->page').addClass('active');";
$this->data['content'] = 'pagina';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
} else {
return Doo::conf()->APP_URL . "denied";
}
} else {
if ($idiomapage == "en") {
$p = Doo::db()->find($p, array('limit' => 1));
$this->data['titulo'] = $p->titulo2;
$this->data['html'] = $p->english;
$this->data['foto'] = $p->foto_ingles;
$this->data['color'] = $p->color;
$idioma = "english.php";
}
if ($idiomapage == "es") {
$p = Doo::db()->find($p, array('limit' => 1));
$this->data['titulo'] = $p->titulo;
$this->data['html'] = $p->descripcion;
$this->data['foto'] = $p->foto;
$this->data['color'] = $p->color;
$idioma = "spanish.php";
}
if ($p == false) {
return array(Doo::conf()->APP_URL . "/error", 404);
}
$this->data['idioma'] = $idioma;
$this->buildMenu($idiomapage);
$this->buildHiper($idiomapage);
$this->buildMenuFooter($idiomapage);
$id = $p->page;
$sql = Doo::db()->query("SELECT id FROM direcciones WHERE id = ( SELECT dependencia FROM direcciones WHERE url = '$id' )")->fetchAll();
$id_p = $sql[0]["id"];
$this->data['scriptactiveP'] = "$('#HL$id_p').addClass('active');";
$this->data['scriptactiveM'] = "$('#M$p->page').addClass('active');";
$this->data['content'] = 'pagina';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
}
public function ShowOurTeam() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$this->data['titulo'] = "Our Team";
$empleado = Doo::db()->find('Empleados', array("select" => "id,nombre,apellidos,cargoingles As cargo,fotos,descripcioningles AS descripcion", "where" => "estado=1"));
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
} else {
$this->data['titulo'] = "Nuestro Equipo";
$empleado = Doo::db()->find('Empleados', array("select" => "id,nombre,apellidos,cargo,fotos,descripcion", "where" => "estado=1"));
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
}
$this->data['empleado'] = $empleado;
$this->data['idioma'] = $idioma;
$this->data['content'] = 'ourteam';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function Incoterms() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$p = Doo::db()->find('Pages', array('where' => 'page="incoterms"', 'limit' => 1));
$this->data['titulo'] = $p->titulo2;
$this->data['html'] = $p->english;
$this->data['foto'] = $p->foto_ingles;
$this->data['color'] = $p->color;
$this->data["palabras"]=array("Clauses", "Type of Transportation", "Obligations", "Buyer", "Seller");
$this->data['incoterms']=Doo::db()->query("SELECT siglas,nombre_ingles AS nombre,clausulas_ingles AS clausulas,tipo_trasnporte_ingles AS tipo_transporte,vendedor_ingles AS vendedor,comprador_ingles AS comprador,color FROM incoterms WHERE estado='1';")->fetchAll();
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
} else {
$p = Doo::db()->find('Pages', array('where' => 'page="incoterms"', 'limit' => 1));
$this->data['titulo'] = $p->titulo;
$this->data['html'] = $p->descripcion;
$this->data['foto'] = $p->foto;
$this->data['color'] = $p->color;
$this->data["palabras"]=array("Clausulas","Tipo de Transporte","Obligaciones","Comprador","Vendedor");
$this->data['incoterms']=Doo::db()->query("SELECT siglas,nombre,clausulas,tipo_transporte,vendedor,comprador,color FROM incoterms WHERE estado='1';")->fetchAll();
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
}
//$this->data['empleado'] = $empleado;
$this->data['scriptactiveP'] = "$('#HL21').addClass('active');";
$this->data['scriptactiveM'] = "$('#Mincoterms').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data['idiomapage']=$idiomapage;
$this->data['content'] = 'inconterm';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function denied() {
$this->data['titulo'] = "Acceso denegado";
$this->data['html'] = '<div id="denegado"></div><div><spam>No tiene permiso para esta opción, para poder ingresar debe tener una cuenta de usuario e ingresar.</spam><br/><a href="' . Doo::conf()->APP_URL . 'entrar">Ingresar como usuario.</a><br/><a href="' . Doo::conf()->APP_URL . 'afiliarse">Crear una cuenta.</a></div>';
$this->buildMenu();
$this->data['content'] = 'pagina';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function getviewPrincipal() {
$id = $this->params['id'];
$idiomapage = $this->params['idioma'];
if ($id == 40) {
if ($idiomapage == "es") {
$noticias = Doo::db()->find('Noticias', array("select" => "id,titulo,introduccion,tipo,imagen,fecha_crec", "where" => "tipo='N'", "desc" => "orden"));
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
$this->Menu("es");
} else {
$noticias = Doo::db()->find('Noticias', array("select" => "id,tituloingles AS titulo,introduccioningles AS introduccion,tipo,imagen,fecha_crec", "where" => "tipo='N'", "desc" => "orden"));
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
$this->Menu("en");
}
$this->data['scriptactiveP'] = "$('#HL521').addClass('active');";
$this->data['scriptactiveM'] = "$('#M521').addClass('active');";
$this->data['noticias'] = $noticias;
$this->data['idioma'] = $idioma;
$this->data['content'] = 'noticias';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
} else {
if ($idiomapage == "en") {
$n = Doo::db()->find('Noticias', array("select" => "id,tituloingles AS titulo,introduccioningles AS introduccion,contenidoingles AS contenido", "where" => 'id=?', 'limit' => 1, 'param' => array($id)));
$this->data['id'] = $n->id;
$this->data['titulo'] = $n->titulo;
$this->data['html'] = $n->contenido;
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
$this->Menu("en");
} else {
$n = Doo::db()->find('Noticias', array("select" => "id,titulo AS titulo,introduccion AS introduccion,contenido AS contenido", "where" => 'id=?', 'limit' => 1, 'param' => array($id)));
$this->data['id'] = $n->id;
$this->data['titulo'] = $n->titulo;
$this->data['html'] = $n->contenido;
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
$this->Menu("es");
}
$this->data['scriptactiveP'] = "$('#HL521').addClass('active');";
$this->data['scriptactiveM'] = "$('#M521').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data['content'] = 'principalindividual';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
}
public function getviewCertificados() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "es") {
$noticias = Doo::db()->find('Certificados', array("select" => "id,nombre,imagen,codigo,fecha_venc,documento", "where" => "principal='N' AND estado = 1", "ORDER BY" => "orden", "DESC" => "orden"));
$p = Doo::db()->find('Pages', array('where' => 'page="Certificaciones"', 'limit' => 1));
$this->data['titulo'] = $p->titulo;
$this->data['html'] = $p->descripcion;
$this->data['foto'] = $p->foto;
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
$this->Menu("es");
} else {
$noticias = Doo::db()->find('Certificados', array("select" => "id,nombreingles AS nombre,imagen,codigo,fecha_venc,documento", "where" => "principal='N' AND estado = 1", "ORDER BY" => "orden", "DESC" => "orden"));
$p = Doo::db()->find('Pages', array('where' => 'page="Certificaciones"', 'limit' => 1));
$this->data['titulo'] = $p->titulo2;
$this->data['html'] = $p->english;
$this->data['foto'] = $p->foto_ingles;
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
$this->Menu("en");
}
$this->data['scriptactiveP'] = "$('#HL7').addClass('active');";
$this->data['scriptactiveM'] = "$('#MCertificaciones').addClass('active');";
$this->data['certificados'] = $noticias;
$this->data['idioma'] = $idioma;
$this->data['content'] = 'certificados';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function getShowListatrabaje() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$trabajenosotro = Doo::db()->find('Tnosotros', array("select" => "id,nombreingles AS nombre,introduccioningles AS introduccion,descripcioningles AS descripcion", "where" => "estado=1"));
$trabaje = "Employment opportunities";
$idioma = "english.php";
$this->data['limite'] = Doo::db()->query("SELECT MIN(LENGTH(`introduccion`)) FROM tnosotros WHERE estado=1")->fetchAll();
$this->buildMenu("en");
$this->buildMenuFooter("en");
$sql = Doo::db()->query("SELECT id, color,titulo2 AS titulo,foto,english AS descripcion FROM pages WHERE page='trabaje'")->fetchAll();
} else {
$trabajenosotro = Doo::db()->find('Tnosotros', array("select" => "id,nombre AS nombre,introduccion AS introduccion,descripcion AS descripcion", "where" => "estado=1"));
$trabaje = "Oportunidades de empleo";
$idioma = "spanish.php";
$this->data['limite'] = Doo::db()->query("SELECT MIN(LENGTH(`introduccion`)) limite FROM tnosotros WHERE estado=1")->fetchAll();
$this->buildMenu("es");
$this->buildMenuFooter("es");
$sql = Doo::db()->query("SELECT id, color ,titulo,foto,descripcion FROM pages WHERE page='trabaje'")->fetchAll();
}
$this->data['trabajenosotro'] = $trabajenosotro;
$this->data['idioma'] = $idioma;
$this->data["titulo"] = $sql[0]["titulo"];
$this->data["foto"] = $sql[0]["foto"];
$this->data["html"] = $sql[0]["descripcion"];
$this->data["color"] = $sql[0]["color"];
$this->data["trabaje"] = $trabaje;
$this->data['scriptactiveP'] = "$('#HL27').addClass('active');";
$this->data['scriptactiveM'] = "$('#Mtrabajenosotro').addClass('active');";
$this->data['content'] = 'listatrabaje';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function getviewListatrabaje() {
$id = $this->params['id'];
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$n = Doo::db()->find('Tnosotros', array("select" => "id,nombreingles AS nombre,introduccioningles AS introduccion,descripcioningles AS descripcion", "where" => 'id=?', 'limit' => 1, 'param' => array($id)));
$this->data['id'] = $n->id;
$this->data['titulo'] = $n->nombre;
$this->data['html'] = $n->descripcion;
$trabaje = "Work with us";
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
$this->Menu("en");
} else {
$n = Doo::db()->find('Tnosotros', array("select" => "id,nombre AS nombre,introduccion AS introduccion,descripcion AS descripcion", "where" => 'id=?', 'limit' => 1, 'param' => array($id)));
$this->data['id'] = $n->id;
$this->data['titulo'] = $n->nombre;
$this->data['html'] = $n->descripcion;
$trabaje = "Trabaje con nosotros";
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
$this->Menu("es");
}
$this->data['idioma'] = $idioma;
$this->data["trabaje"] = $trabaje;
$this->data['scriptactiveP'] = "$('#Mtrabajenosotro').addClass('active');";
$this->data['scriptactiveM'] = "$('#Mtrabajenosotro').addClass('active');";
$this->data['content'] = 'individualtrabaje';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
// Funcion para guardar HV de trabaje con nosotros
public function SaveHv() {
Doo::loadModel("HojaVida");
Doo::loadHelper('DooFile');
$hv = new HojaVida($_POST);
try {
$pdf = "";
$hv->id = null;
$hv->nombre = $_POST['nombre'];
$hv->apellidos = $_POST['apellidos'];
$hv->docto = $_POST['docto'];
$hv->doctonumero = $_POST['doctonumero'];
$hv->celular = $_POST['celular'];
$hv->telefono = $_POST['telefono'];
$hv->profesion = $_POST['profesion'];
$hv->email = $_POST['email'];
$hv->ciudad = $_POST['ciudad'];
$hv->estado = "1";
$hv->trabajo_aplicar = $_POST['id'];
$gd2 = new DooFile();
$type2 = $gd2->getUploadFormat('documento');
if ($type2 == "application/pdf") {
$pdf = $gd2->upload(Doo::conf()->FILE_DIR . 'documentos/', 'documento', 'pdf_' . date('Ymdhis'));
} else {
$pdf = "";
throw new Exception('Formato del Archivo no Valido!');
}
$hv->archivo_anexo = $pdf;
Doo::db()->insert($hv);
} catch (PDOException $e) {
echo $e->getMessage();
}
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
return Doo::conf()->APP_URL . 'trabajenosotro/en';
} else {
return Doo::conf()->APP_URL . 'trabajenosotro/es';
}
}
public function showaliados() {
Doo::loadHelper('DooPager');
$rst = Doo::db()->query("select count(*) as total FROM aliados WHERE estado=1", array("limit" => 1));
$t = $rst->fetch();
if (count($t) > 0) {
$total = $t["total"];
} else {
$total = 0;
}
if ($total == 0) {
$total = 1;
}
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$pager = new DooPager(Doo::conf()->APP_URL . "aliados/2/page/en", $total, 20, 5);
if (isset($this->params['number'])) {
$pager->paginate(intval($this->params['number']));
} else {
$pager->paginate(1);
}
$sql = "SELECT * FROM aliados WHERE estado=1 LIMIT" . $pager->limit;
$rs = Doo::db()->query($sql);
$this->data['aliado'] = $rs->fetchAll();
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
$this->Menu("en");
} else {
$pager = new DooPager(Doo::conf()->APP_URL . "aliados/2/page/es", $total, 20, 5);
if (isset($this->params['number'])) {
$pager->paginate(intval($this->params['number']));
} else {
$pager->paginate(1);
}
$sql = "SELECT * FROM aliados WHERE estado=1 LIMIT" . $pager->limit;
$rs = Doo::db()->query($sql);
$this->data['aliado'] = $rs->fetchAll();
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
$this->Menu("es");
}
$this->data['pager'] = $pager->output;
$this->data['idioma'] = $idioma;
$this->data['content'] = 'aliados';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function getNoticia() {
$id = $this->params['id'];
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$n = Doo::db()->find('Noticias', array("select" => "id,tituloingles AS titulo,introduccioningles AS introduccion,contenidoingles AS contenido, revista,archivo", "where" => 'id=?', 'limit' => 1, 'param' => array($id)));
$this->data['id'] = $n->id;
$this->data['titulo'] = $n->titulo;
$this->data['html'] = $n->contenido;
$this->data['revista'] = $n->revista;
$this->data['archivo'] = $n->archivo;
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
$this->Menu("en");
} else {
$n = Doo::db()->find('Noticias', array("select" => "id,titulo AS titulo,introduccion AS introduccion,contenido AS contenido, revista,archivo", "where" => 'id=?', 'limit' => 1, 'param' => array($id)));
$this->data['id'] = $n->id;
$this->data['titulo'] = $n->titulo;
$this->data['html'] = $n->contenido;
$this->data['revista'] = $n->revista;
$this->data['archivo'] = $n->archivo;
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
$this->Menu("es");
}
$this->data['idioma'] = $idioma;
$this->data['scriptactiveP'] = "$('#HL1').addClass('active');";
$this->data['scriptactiveM'] = "$('#M1').addClass('active');";
$this->data['content'] = 'noticiaindividual';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function convertidores() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
$sql = Doo::db()->query("SELECT id,titulo2 AS titulo,foto,color,english AS descripcion FROM pages WHERE page='convertidores'")->fetchAll();
} else {
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
$sql = Doo::db()->query("SELECT id,titulo,foto,color,descripcion FROM pages WHERE page='convertidores'")->fetchAll();
}
$this->data['scriptactiveP'] = "$('#HL21').addClass('active');";
$this->data['scriptactiveM'] = "$('#Mconvertidores').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data["titulo"] = $sql[0]["titulo"];
$this->data["html"] = $sql[0]["descripcion"];
$this->data["foto"] = $sql[0]["foto"];
$this->data['color'] = $sql[0]["color"];
$this->data['content'] = 'herramientas';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function Intranet() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
$sql = Doo::db()->query("SELECT id,titulo2 AS titulo,foto,color,english AS descripcion FROM pages WHERE page='intranet'")->fetchAll();
$intra = Doo::db()->query("SELECT id,nombre_ingles AS nombre,link,principal,foto FROM intranet WHERE estado = 1 AND principal = '0' ")->fetchAll();
$intraprincipal = Doo::db()->query("SELECT id,nombre_ingles AS nombre,link,principal,foto FROM intranet WHERE estado = 1 AND principal = 'S' LIMIT 1")->fetch();
} else {
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
$sql = Doo::db()->query("SELECT id,titulo,foto,color,descripcion FROM pages WHERE page='intranet'")->fetchAll();
$intra = Doo::db()->query("SELECT id,nombre_ingles AS nombre,link,principal,foto FROM intranet WHERE estado = 1 and principal = '0'")->fetchAll();
$intraprincipal = Doo::db()->query("SELECT id,nombre_ingles AS nombre,link,principal,foto FROM intranet WHERE estado = 1 AND principal = 'S' LIMIT 1")->fetch();
}
$this->data['scriptactiveP'] = "$('#Mintranet').addClass('active');";
$this->data['scriptactiveM'] = "$('#Mintranet').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data["titulo_principal"] = $intraprincipal["nombre"];
$this->data["imagen_principal"] = $intraprincipal["foto"];
$this->data["link_principal"] = $intraprincipal["link"];
$this->data["principal"] = $intraprincipal["principal"];
$this->data["titulo"] = $sql[0]["titulo"];
$this->data["html"] = $sql[0]["descripcion"];
$this->data["foto"] = $sql[0]["foto"];
$this->data['color'] = $sql[0]["color"];
$this->data["intra"] = $intra;
$this->data['content'] = 'page_intranet';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function Gallery() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
$sql = Doo::db()->query("SELECT id,titulo2 AS titulo,foto,color,english AS descripcion FROM pages WHERE page='galeria'")->fetchAll();
$galeria = Doo::db()->query("SELECT id,nombre,descripcion_ingles AS descripcion,foto FROM galerias WHERE estado = 1 ")->fetchAll();
} else {
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
$sql = Doo::db()->query("SELECT id,titulo,foto,color,descripcion FROM pages WHERE page='galeria'")->fetchAll();
$galeria = Doo::db()->query("SELECT id,nombre,descripcion,foto FROM galerias WHERE estado = 1 ORDER BY orden")->fetchAll();
}
$this->data['scriptactiveP'] = "$('#Mgallery').addClass('active');";
$this->data['scriptactiveM'] = "$('#Mgallery').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data["titulo"] = $sql[0]["titulo"];
$this->data["html"] = $sql[0]["descripcion"];
$this->data["foto"] = $sql[0]["foto"];
$this->data['color'] = $sql[0]["color"];
$this->data["galeria"] = $galeria;
$this->data['content'] = 'page_gallery';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function horamundial() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
} else {
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
}
$this->data['scriptactiveP'] = "$('#HL21').addClass('active');";
$this->data['scriptactiveM'] = "$('#M21').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data['content'] = 'herra_hora';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function herra_peso() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
} else {
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
}
$this->data['scriptactiveP'] = "$('#HL21').addClass('active');";
$this->data['scriptactiveM'] = "$('#M21').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data['content'] = 'herra_peso';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function herra_area() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
} else {
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
}
$this->data['scriptactiveP'] = "$('#HL21').addClass('active');";
$this->data['scriptactiveM'] = "$('#M21').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data['content'] = 'herra_area';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function herra_volum() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
} else {
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
}
$this->data['scriptactiveP'] = "$('#HL21').addClass('active');";
$this->data['scriptactiveM'] = "$('#M21').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data['content'] = 'herra_volum';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function herra_unidad() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
} else {
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
}
$this->data['scriptactiveP'] = "$('#HL21').addClass('active');";
$this->data['scriptactiveM'] = "$('#M21').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data['content'] = 'herra_unidad';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function herra_veloc() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
} else {
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
}
$this->data['scriptactiveP'] = "$('#HL21').addClass('active');";
$this->data['scriptactiveM'] = "$('#M21').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data['content'] = 'herra_veloc';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function herra_temp() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
} else {
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
}
$this->data['scriptactiveP'] = "$('#HL21').addClass('active');";
$this->data['scriptactiveM'] = "$('#M21').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data['content'] = 'herra_temp';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function getBanner() {
$id = $_REQUEST['id'];
$b = Doo::db()->find('Articulos', array("select" => "id,titulo,revista,descripcion", "where" => 'id=?', 'limit' => 1, 'param' => array($id)));
$this->data['titulo'] = $b->titulo;
$this->data['html'] = $b->descripcion;
$this->data['revista'] = $b->revista;
$this->buildMenu();
$this->data['content'] = 'pagina';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
private function buildMenu($idioma) {
$this->buildHiper($idioma);
$this->configuracion();
$sql = "SELECT id,etiqueta,url,ingles,destino,submenu,alto,privado FROM direcciones WHERE istop='S' AND dependencia='0' ORDER BY ordercolumn2";
$rs = Doo::db()->query($sql);
$parentMenu = $rs->fetchAll();
$this->data["htmlmenu"] = '<ul class="nav navbar-nav" style="margin-left:32px;">';
$this->buildChildMenu($parentMenu, false, $idioma);
$this->data["htmlmenu"].= '</ul>';
}
private function buildChildMenu($parentMenu, $sub, $idioma) {
foreach ($parentMenu as $row) {
$id = $row["id"];
$submenu = $row["submenu"];
$etiqueta = $row["etiqueta"];
$alto = $row["alto"];
$url = $row["url"];
$ingles = $row["ingles"];
$destino = $row["destino"];
$privado = $row["privado"];
if ($privado == "1") {
if ($submenu == 'S') {
if (isset($_SESSION["reg_user"])) {
$this->data["htmlmenu"].= '<li><a id="M' . $id . '" href="#">' . $etiqueta . '</a>';
$sql = "SELECT id,etiqueta,url,ingles,destino,submenu,alto,privado FROM direcciones WHERE istop='S' AND dependencia='$id' ORDER BY ordercolumn2";
$rs = Doo::db()->query($sql);
$childMenu = $rs->fetchAll();
$this->data["htmlmenu"].= '<ul class="dropdown">';
$this->buildChildMenu($childMenu, true, $idioma);
$this->data["htmlmenu"].= '</ul></li><li></li>';
$this->data['scriptactivePrincipal'] = "$('#M$url').addClass('active');//Adelante";
}
} else {
if (isset($_SESSION["reg_user"])) {
$this->data["htmlmenu"].= '<li id="HL' . $id . '">';
if ($destino == 'E') {
$this->data["htmlmenu"].= '<a target="_black" href="' . $url . '">' . $etiqueta . '</a>';
} else {
$this->data["htmlmenu"].= '<a href="' . Doo::conf()->APP_URL . $url . '">' . $etiqueta . '</a>';
}
$this->data["htmlmenu"].= '</li><li>';
if (!$sub) {
$this->data["htmlmenu"].= '</li>';
}
}
}
} else {
if ($submenu == 'S') {
$this->data["htmlmenu"].= '<li><a class="menugamaprincipal" id="HL' . $id . '" href="#">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a>';
$sql = "SELECT id,etiqueta,url,ingles,destino,submenu,alto,privado FROM direcciones WHERE istop='S' AND dependencia='$id' ORDER BY ordercolumn2";
$rs = Doo::db()->query($sql);
$childMenu = $rs->fetchAll();
$this->data["htmlmenu"].= '<ul class="dropdown">';
$this->buildChildMenu($childMenu, true, $idioma);
$this->data["htmlmenu"].= '</ul></li><li class="divider2"> </li><li></li>';
} else {
$this->data["htmlmenu"].= '<li>';
if ($destino == 'E') {
$this->data["htmlmenu"].= '<a target="_black" href="' . $url . '">' . $etiqueta . '</a>';
} else {
if ($url == '#' || $url == "") {
$this->data["htmlmenu"].= '<a class="menugama" id="HL' . $id . '" href="' . Doo::conf()->APP_URL . $url . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a>';
} else {
$this->data["htmlmenu"].= '<a class="menugama" id="M' . $url . '" href="' . Doo::conf()->APP_URL . ($url != "" ? $url . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a>';
$this->data['scriptactivePrincipal'] = "$('#M$url').addClass('active');//Atras";
}
}
$this->data["htmlmenu"].= '</li>';
if (!$sub) {
$this->data["htmlmenu"].= '<li class="divider2"> </li>';
}
}
}
}
}
private function buildMenuFooter($idioma) {
$sql = "SELECT id,etiqueta,url,ingles,destino,submenu,alto,privado FROM direcciones WHERE isfotter='S' AND dependencia='0' ORDER BY orderfotter ASC ";
$rs = Doo::db()->query($sql);
$parentMenu = $rs->fetchAll();
$this->data["htmlmenufooter"] = '<ul class="nav nav-pills" style="padding-left:150px;">';
$this->buildOptionfotter($parentMenu, false, $idioma);
$this->data["htmlmenufooter"].= '</ul>';
}
private function buildOptionfotter($parentMenu, $sub, $idioma) {
foreach ($parentMenu as $row) {
$id = $row["id"];
$submenu = $row["submenu"];
$etiqueta = $row["etiqueta"];
$url = $row["url"];
$ingles = $row["ingles"];
$destino = $row["destino"];
if ($submenu == 'S') {
$this->data["htmlmenufooter"].= '<li class="dropdown" ><a class="dropdown-toggle" data-toggle="dropdown" id="HL' . $id . '" href="#">' . ($idioma == "es" ? $etiqueta : $ingles) . '<b class="caret"></b></a>';
$sql = "SELECT id,etiqueta,url,ingles,destino,submenu,alto,privado FROM direcciones WHERE isfotter='S' AND dependencia='$id' ORDER BY orderfotter";
$rs = Doo::db()->query($sql);
$childMenu = $rs->fetchAll();
$this->data["htmlmenufooter"].= '<ul class="dropdown-menu">';
$this->buildOptionfotter($childMenu, true, $idioma);
$this->data["htmlmenufooter"].= '</ul></li>';
//$this->data['scriptactivePrincipal'] = "$('#M$id').addClass('active');";
} else {
$this->data["htmlmenufooter"].= '<li>';
if ($destino == 'E') {
$this->data["htmlmenufooter"].= '<a target="_black" href="' . $url . '">' . $etiqueta . '</a>';
} else {
if ($url == '#' || $url == "") {
$this->data["htmlmenufooter"].= '<a id="HL' . $id . '" href="' . Doo::conf()->APP_URL . $url . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a>';
} else {
$this->data["htmlmenufooter"].= '<a id="M' . $url . '" href="' . Doo::conf()->APP_URL . ($url != "" ? $url . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a>';
}
}
$this->data["htmlmenufooter"].= '</li>';
if (!$sub) {
$this->data["htmlmenufooter"].= '';
}
}
}
}
private function buildMenuFooter23($idioma) {
$sql = "SELECT id,etiqueta,url,ingles,submenu,destino FROM direcciones WHERE isfotter='S' AND posicionf='1' ORDER BY orderfotter";
$rs = Doo::db()->query($sql);
$primeracolumna = $rs->fetchAll();
$sql = "SELECT etiqueta,url,ingles,submenu,destino FROM direcciones WHERE isfotter='S' AND posicionf='2' ORDER BY orderfotter";
$rs = Doo::db()->query($sql);
$segundacolumna = $rs->fetchAll();
$sql = "SELECT etiqueta,url,ingles,submenu,destino FROM direcciones WHERE isfotter='S' AND posicionf='3' ORDER BY orderfotter";
$rs = Doo::db()->query($sql);
$terceracolumna = $rs->fetchAll();
$sql = "SELECT etiqueta,url,ingles,submenu,destino FROM direcciones WHERE isfotter='S' AND posicionf='4' ORDER BY orderfotter";
$rs = Doo::db()->query($sql);
$cuartacolumna = $rs->fetchAll();
$sql = "SELECT etiqueta,url,ingles,submenu,alto,destino FROM direcciones WHERE isfotter='S' AND posicionf='5' ORDER BY orderfotter";
$rs = Doo::db()->query($sql);
$quintacolumna = $rs->fetchAll();
$sql = "SELECT etiqueta,url,ingles,submenu,alto,destino FROM direcciones WHERE isfotter='S' AND posicionf='6' ORDER BY orderfotter";
$rs = Doo::db()->query($sql);
$sextacolumna = $rs->fetchAll();
$sql = "SELECT etiqueta,url,ingles,submenu,alto,destino FROM direcciones WHERE isfotter='S' AND posicionf='7' ORDER BY orderfotter";
$rs = Doo::db()->query($sql);
$septimacolumna = $rs->fetchAll();
$this->data["menufotter"] = '<div id="links-home" class="links col-lg-2">';
foreach ($primeracolumna as $row):
$url = $row['url'];
$destino = $row['destino'];
$etiqueta = $row['etiqueta'];
$ingles = $row['ingles'];
$submenu = $row["submenu"];
$id = $row["id"];
if ($submenu == 'S') {
$this->data["menufotter"].= '<li class="dropdown"><a style="color:#fff;"' . ($destino == 'L' ? '' : 'target="_black"') . ' href="javascript:void(0);">' . ($idioma == "es" ? $etiqueta : $ingles) . '<span class="caret"></span></a>';
$sqlinterna = "SELECT id,etiqueta,url,ingles,destino,submenu,alto,privado FROM direcciones WHERE isfotter='S' AND posicionf='1' AND dependencia='$id' ORDER BY orderfotter";
$rsinterna = Doo::db()->query($sqlinterna)->fetch();
$url2 = $rsinterna['url'];
$destino2 = $rsinterna['destino'];
$etiqueta2 = $rsinterna['etiqueta'];
$ingles2 = $rsinterna['ingles'];
$this->data["menufotter"].= '<ul class="dropdown">';
$this->data["menufotter"].= '<li><a ' . ($destino2 == 'L' ? '' : 'target="_black"') . ' href="' . Doo::conf()->APP_URL . ($url2 != "" ? $url2 . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta2 : $ingles2) . '</a></li>';
$this->data["menufotter"].= '</ul></li>';
//$this->data["menufotter"].= '<ul class="dropdown-menu"><li><a ' . ($destino == 'L' ? '' : 'target="_black"') . ' href="' . Doo::conf()->APP_URL . ($url != "" ? $url . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></li></ul></li>';
} else {
//$this->data["menufotter"].= '<li><a ' . ($destino == 'L' ? '' : 'target="_black"') . ' href="' . Doo::conf()->APP_URL . ($url != "" ? $url . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></li>';
}
endforeach;
$this->data["menufotter"].= '</div>';
$this->data["menufotter"].= '<div id="links-home" class="links col-lg-2">';
foreach ($segundacolumna as $row2):
$url = $row2['url'];
$destino = $row2['destino'];
$etiqueta = $row2['etiqueta'];
$ingles = $row2['ingles'];
$submenu = $row2["submenu"];
if ($submenu == 'S') {
$this->data["menufotter"].= '<h3><a style="color:#fff;"' . ($destino == 'L' ? '' : 'target="_black"') . ' href="javascript:void(0);">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></h3>';
} else {
// $this->data["menufotter"].= '<ul><li><a ' . ($destino == 'L' ? '' : 'target="_black"') . ' href="' . Doo::conf()->APP_URL . ($url != "" ? $url . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></li></ul>';
}
endforeach;
$this->data["menufotter"].= '</div>';
$this->data["menufotter"].= '<div id="links-home" class="links col-lg-2">';
foreach ($terceracolumna as $row2):
$url = $row2['url'];
$destino = $row2['destino'];
$etiqueta = $row2['etiqueta'];
$ingles = $row2['ingles'];
$submenu = $row2["submenu"];
if ($submenu == 'S') {
$this->data["menufotter"].= '<h3><a style="color:#fff;"' . ($destino == 'L' ? '' : 'target="_black"') . ' href="javascript:void(0);">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></h3>';
} else {
// $this->data["menufotter"].= '<ul><li><a ' . ($destino == 'L' ? '' : 'target="_black"') . ' href="' . Doo::conf()->APP_URL . ($url != "" ? $url . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></li></ul>';
}
endforeach;
$this->data["menufotter"].= '</div>';
$this->data["menufotter"].= '<div id="links-home" class="links col-lg-2">';
foreach ($cuartacolumna as $row2):
$url = $row2['url'];
$destino = $row2['destino'];
$etiqueta = $row2['etiqueta'];
$ingles = $row2['ingles'];
$submenu = $row2["submenu"];
if ($submenu == 'S') {
$this->data["menufotter"].= '<h3><a style="color:#fff;"' . ($destino == 'L' ? '' : 'target="_black"') . ' href="javascript:void(0);">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></h3>';
} else {
// $this->data["menufotter"].= '<ul><li><a ' . ($destino == 'L' ? '' : 'target="_black"') . ' href="' . Doo::conf()->APP_URL . ($url != "" ? $url . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></li></ul>';
}
endforeach;
$this->data["menufotter"].= '</div>';
$this->data["menufotter"].= '<div id="links-home" class="links col-lg-2">';
foreach ($quintacolumna as $row2):
$url = $row2['url'];
$destino = $row2['destino'];
$etiqueta = $row2['etiqueta'];
$ingles = $row2['ingles'];
$submenu = $row2["submenu"];
$alto = $row2["alto"];
if ($submenu == 'S') {
$this->data["menufotter"].= '<h3><a style="color:#fff;"' . ($destino == 'L' ? '' : 'target="_black"') . ' href="javascript:void(0);">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></h3>';
} else if ($alto == 0) {
// $this->data["menufotter"].= '<ul><li><a ' . ($destino == 'L' ? '' : 'target="_black"') . ' href="' . Doo::conf()->APP_URL . ($url != "" ? $url . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></li></ul>';
}
if ($alto > 0) {
$this->data["menufotter"].= '<h3><a style="color:#fff;" ' . ($destino == 'L' ? '' : 'target="_black"') . ' href="' . Doo::conf()->APP_URL . ($url != "" ? $url . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></h3>';
}
endforeach;
$this->data["menufotter"].= '</div>';
$this->data["menufotter"].= '<div id="links-home" class="links col-lg-2">';
foreach ($sextacolumna as $row2):
$url = $row2['url'];
$destino = $row2['destino'];
$etiqueta = $row2['etiqueta'];
$ingles = $row2['ingles'];
$submenu = $row2["submenu"];
$alto = $row2["alto"];
if ($submenu == 'S') {
$this->data["menufotter"].= '<h3><a style="color:#fff;"' . ($destino == 'L' ? '' : 'target="_black"') . ' href="javascript:void(0);">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></h3>';
} else if ($alto == 0) {
// $this->data["menufotter"].= '<ul><li><a ' . ($destino == 'L' ? '' : 'target="_black"') . ' href="' . Doo::conf()->APP_URL . ($url != "" ? $url . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></li></ul>';
}
if ($alto > 0) {
$this->data["menufotter"].= '<h3><a style="color:#fff;" ' . ($destino == 'L' ? '' : 'target="_black"') . ' href="' . Doo::conf()->APP_URL . ($url != "" ? $url . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></h3>';
}
endforeach;
$this->data["menufotter"].= '</div>';
$this->data["menufotter"].= '<div id="links-home" class="links col-lg-2">';
foreach ($septimacolumna as $row2):
$url = $row2['url'];
$destino = $row2['destino'];
$etiqueta = $row2['etiqueta'];
$ingles = $row2['ingles'];
$submenu = $row2["submenu"];
if ($submenu == 'S') {
$this->data["menufotter"].= '<h3><a style="color:#fff;"' . ($destino == 'L' ? '' : 'target="_black"') . ' href="javascript:void(0);">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></h3>';
} else {
// $this->data["menufotter"].= '<ul><li><a ' . ($destino == 'L' ? '' : 'target="_black"') . ' href="' . Doo::conf()->APP_URL . ($url != "" ? $url . '/' : $url) . $idioma . '">' . ($idioma == "es" ? $etiqueta : $ingles) . '</a></li></ul>';
}
endforeach;
$this->data["menufotter"].= '</div>';
}
public function News() {
$proyectos = Doo::db()->find('Noticias', array("select" => "id,titulo,introduccion,imagen", "where" => "tipo='N'", "desc" => "titulo"));
$this->data['resultados'] = $proyectos;
$this->buildMenu();
$this->data['content'] = 'news';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function getUbicacion() {
$this->buildMenu();
$this->data['content'] = 'ubicacion';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
private function Noticias($idioma) {
if ($idioma == "es") {
$noticias = Doo::db()->find('Noticias', array("select" => "id,titulo,introduccion,tipo,imagen,fecha_crec", "where" => "tipo='N'", "asc" => "id"));
$principal = Doo::db()->find('Noticias', array("select" => "id,titulo,introduccion,tipo,imagen,icono", "where" => "tipo='P'", "asc" => "titulo", "limit" => 2));
} else {
$noticias = Doo::db()->find('Noticias', array("select" => "id,tituloingles AS titulo,introduccioningles AS introduccion,tipo,imagen,fecha_crec", "where" => "tipo='N'", "asc" => "id"));
$principal = Doo::db()->find('Noticias', array("select" => "id,tituloingles AS titulo,introduccioningles AS introduccion,tipo,imagen,icono", "where" => "tipo='P'", "asc" => "id", "limit" => 2));
}
$this->data['noticias'] = $noticias;
$this->data['principal'] = $principal;
}
public function contactos() {
$idiomapage = $this->params['idioma'];
if ($idiomapage == "en") {
$this->data['titulo'] = "Contact";
$idioma = "english.php";
$this->buildMenu("en");
$this->buildMenuFooter("en");
$sql = Doo::db()->query("SELECT id,titulo2 AS titulo,foto,color,english AS descripcion FROM pages WHERE page='contacto'")->fetchAll();
} else {
$this->data['titulo'] = "Contáctenos";
$idioma = "spanish.php";
$this->buildMenu("es");
$this->buildMenuFooter("es");
$sql = Doo::db()->query("SELECT id,titulo,foto,color,descripcion FROM pages WHERE page='contacto'")->fetchAll();
}
$this->data["contactos"] = Doo::db()->query('SELECT * FROM contactenos where deleted=1')->fetchAll();
$this->data['scriptactiveP'] = "$('#HL6').addClass('active');";
$this->data['scriptactiveM'] = "$('#Mcontactos').addClass('active');";
$this->data['idioma'] = $idioma;
$this->data["titulo"] = $sql[0]["titulo"];
$this->data["foto"] = $sql[0]["foto"];
$this->data["html"] = $sql[0]["descripcion"];
$this->data["color"] = $sql[0]["color"];
$this->data['content'] = 'contactenos';
$this->data['rootUrl'] = Doo::conf()->APP_URL;
$this->renderc('home', $this->data, true);
}
public function send() {
$languaje = $_POST["idioma"];
Doo::loadHelper('DooMailer');
$mail = new DooMailer();
$enviacorreo = $_POST['oficina'];
$destinario = "";
if ($enviacorreo == "cartagena") {
$destinario = "cartagena@aduanasgama.com";
} else {
if ($enviacorreo == "barranquilla") {
$destinario = "barranquilla@aduanasgama.com";
} else {
if ($enviacorreo == "buenaventura") {
$destinario = "buenaventura@aduanasgama.com";
} else {
if ($enviacorreo == "vicepresidencia") {
$destinario = "fuadn@redgama.com";
} else {
if ($enviacorreo == "bogota") {
$destinario = "bogota@aduanasgama.com";
} else {
if ($enviacorreo == "santamarta") {
$destinario = "santamarta@aduanasgama.com";
}
}
}
}
}
}
$html = "<p>
<b>Nombre:</b><span>" . $_POST["nombre"] . "</span><br/>
<b>Empresa:</b><span>" . $_POST["empresa"] . "</span><br/>
<b>Telefono:</b><span>" . $_POST["telefono"] . "</span><br/>
<b>Codigo Pais:</b><span>" . $_POST["codigopais"] . "</span><br/>
<b>Codigo area:</b><span>" . $_POST["codigoarea"] . "</span><br/>
<b>Ciudad:</b><span>" . $_POST["ciudad"] . "</span><br/>
<b>Email:</b><span>" . $_POST["email"] . "</span><br/><br/>
<b>Mensaje:</b><span>" . $_POST["mensaje"] . "</span><br/>
</p><br/>
<footer><i>Correo enviado desde la pagina de aduanasgama.com</i></footer>";
//$param = $this->db()->find("Parametros", array("select" => "email", "limit" => 1));
$mail->addTo($destinario);
$mail->setSubject($_POST['asunto']);
$mail->setBodyHtml($html);
$mail->setFrom($_POST['email']);
$mail->send();
echo true;
}
}
* Stack Trace...
- /home/redgama/public_html/gama/index.php(27) calling run()
- /home/redgama/public_html/gama/dooframework/app/DooWebApp.php(34) calling routeTo()
- /home/redgama/public_html/gama/dooframework/app/DooWebApp.php(116) calling index()
object(DooConfig)#1 (33) {
["AUTOLOAD"] => NULL
["SITE_PATH"] => string(31) "/home/redgama/public_html/gama/"
["PROTECTED_FOLDER"] => string(10) "protected/"
["BASE_PATH"] => string(44) "/home/redgama/public_html/gama/dooframework/"
["LOG_PATH"] => NULL
["APP_URL"] => string(33) "https://www.aduanasgama.com/gama/"
["SUBFOLDER"] => string(6) "/gama/"
["APP_MODE"] => string(3) "dev"
["AUTOROUTE"] => bool(true)
["DEBUG_ENABLED"] => bool(true)
["ERROR_404_DOCUMENT"] => NULL
["ERROR_404_ROUTE"] => string(6) "/error"
["CACHE_PATH"] => NULL
["AUTO_VIEW_RENDER_PATH"] => NULL
["MEMCACHE"] => NULL
["TEMPLATE_ENGINE"] => string(7) "DooView"
["TEMPLATE_SHOW_COMMENT"] => NULL
["TEMPLATE_ALLOW_PHP"] => NULL
["TEMPLATE_COMPILE_ALWAYS"] => NULL
["TEMPLATE_GLOBAL_TAGS"] => NULL
["MODULES"] => NULL
["APP_NAMESPACE_ID"] => NULL
["IMG_COMP"] => string(38) "/home/redgama/public_html/gama/global/"
["RELATIVE_IMG_DIR"] => string(41) "https://www.aduanasgama.com/gama/uploads/"
["IMG_DIR"] => string(40) "/home/redgama/public_html/gama//uploads/"
["FILE_DIR"] => string(38) "/home/redgama/public_html/gama//files/"
["IMG_ALIADOS"] => string(53) "/home/redgama/public_html/gama//imagenes/img_aliados/"
["DIR_NOTICIA"] => string(41) "/home/redgama/public_html/gama//noticias/"
["IMG_PAGINA"] => string(50) "/home/redgama/public_html/gama//files/img_paginas/"
["FOTOS_INTRANET"] => string(51) "/home/redgama/public_html/gama//files/img_intranet/"
["FOTOS_GALERIA"] => string(50) "/home/redgama/public_html/gama//files/img_galeria/"
["DIR_NOW"] => string(23) "www.aduanasgama.com/gam"
["PARAM"] => string(0) ""
}
$_SESSION Variables
array(0) {
}
$_COOKIE Variables
array(0) {
}