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