<?php include_once 'Clases/Representante.php'; $rep = new Representante(); session_start(); $tipo_usuario = $rep->getUserType($_SESSION['login_user']); $tipo2 = $tipo_usuario->fetch_array(MYSQLI_ASSOC); ?> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"/> <meta name="viewport" content="width=device-width, initial-scale=1.0"/> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/> <title>Sanco Business Solution </title> <script type="text/javascript"> //<![CDATA[ try{if (!window.CloudFlare) {var CloudFlare=[{verbose:0,p:0,byc:0,owlid:"cf",bag2:1,mirage2:0,oracle:0,paths:{cloudflare:"/cdn-cgi/nexp/dok2v=1613a3a185/"},atok:"48364bb7d9e1a568908376793f36680f",petok:"c6423c715a13ccffdf6ebc8c1ebe7d8a77e3c0fa-1417034632-1800",zone:"adbee.technology",rocket:"0",apps:{"ga_key":{"ua":"UA-49262924-2","ga_bs":"2"}}}];!function(a,b){a=document.createElement("script"),b=document.getElementsByTagName("script")[0],a.async=!0,a.src="../../ajax.cloudflare.com/cdn-cgi/nexp/dok2v%3d919620257c/cloudflare.min.js",b.parentNode.insertBefore(a,b)}()}}catch(e){}; //]]> </script> <link rel="stylesheet" type="text/css" href="css/bootstrap/bootstrap.min.css"/> <script src="js/demo-rtl.js"></script> <script src="//code.jquery.com/jquery-1.11.3.min.js"></script> <script src="//code.jquery.com/jquery-migrate-1.2.1.min.js"></script>
$oficina = new Oficina(); $representante = new Representante(); session_start(); ///para imprimier los reportes $objReader = new PHPExcel_Reader_Excel2007(); //creamos objeto para leer del excel $objPHPExcel = $objReader->load("../filesReports/template.xlsx"); $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); //obj $i = 10; // inicia a imprimir archivo excel date_default_timezone_set('America/Los_Angeles'); // Uso horario $date = date("d-m-Y-Hi"); // fecha y hora para adjuntar al archivo excel $tipo_usuario = $representante->getUserType($_SESSION['login_user']); $tipo2 = $tipo_usuario->fetch_array(MYSQLI_ASSOC); //Variables $idOficina = ""; $nomOfi = ""; $calleOfi = ""; $numOfi = ""; $ciudadOfi = ""; $estadoOfi = ""; $cpOfi = ""; $website = ""; $telOficina = ""; $faxOficina = ""; // Obtenemos el ultimo id $result = $oficina->obtenerId(); $row = $result->fetch_array(MYSQLI_ASSOC);