KOKINIO - MANAGER

Edit File: ReportController.php

<?php

namespace Trash\Http\Controllers;

use Illuminate\Http\Request;

use Trash\Http\Requests;
use Trash\Http\Controllers\Controller;
use Maatwebsite\Excel\Facades\Excel;
use Trash\User;
use Trash\Ordenes;
use Trash\Clientes;
use Trash\ReportConfig;
use Trash\UserCliente;
use Fpdf;
use URL;
use Helper;
use Auth;

class ReportController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function reportOrder()
    {
        //
        $users = User::where('tipo_usuario_id','=',2)->orderBy('username')->get();
        $clientes = Clientes::where('status_id','=',1)->orderBy('nombre_comercial')->get();
        return view('report.reportOrden')->with(compact('users','clientes'));
    }

public function reportCliente(){
        $reportConfig = new ReportConfig();
        $years = $reportConfig->year_orden();
        $months = $reportConfig->mes_orden();
        if(Auth::user()->tipo_usuario_id == 3){
          $clientes = UserCliente::where('user_id','=',Auth::user()->id)->get();
          $id_clientes = [];
          foreach ($clientes as $key => $value) {
            $id_clientes[$key] = $value->cliente_id;
          }
          $clientes = Clientes::where('status_id','=',1)->whereIn('id',$id_clientes)->orderBy('nombre_comercial')->get();
        }else{
          $clientes = Clientes::where('status_id','=',1)->orderBy('nombre_comercial')->get();
        }
        return view('report.reportCliente')->with(compact('clientes','months','years'));;
    }

/**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function ordenReport($fecha_ini,$fecha_ter,$conductores,$clientes){
       $ordenes = new Ordenes();
       $orden = $ordenes->ordenReport($fecha_ini,$fecha_ter,$conductores,$clientes);

if(!$orden->getData()->status){
         return "No hay resultados disponibles";
       }

$ordenes = $orden->getData()->data;

header('Content-Type: text/html; charset=utf-8');
        header("Content-type: application/vnd.ms-excel" ) ;
        header("Content-Disposition: attachment; filename=reporte.xls" );

$tabla = "<table border=1 color='gray'>
                        <tr>
                            <th>No Orden</th>
                            <th>Fecha</th>
                            <th>Dia</th>
                            <th>Mes</th>
                            <th>Razon Social</th>
                            <th>SEMADES</th>
                            <th>Nombre Comercial</th>
                            <th>Cuota</th>
                            <th>Unidad</th>
                            <th>P.U.</th>
                            <th>Placas</th>
                            <th>Conductor</th>
                            <th>Peso</th>
                            <th>Toneladas</th>
                            <th>Cantidad</th>
                            <th>Reciclable</th>
                            <th>Clasificacion</th>
                            <th>Peso Reciclable</th>
                            <th>Toneladas Reciclable</th>
                            <th>Observaciones</th>
                            <th>Hora Inicio</th>
                            <th>Hora Termino</th>
                            <th>Km</th>
                            <th>Inorganicos</th>
                            <th>Organicos</th>
                            <th>Sanitarios</th>
                            <th>Costo Pago</th>
                            <th>Total Pago</th>
                            <th>Costo Cliente</th>
                            <th>Total Cliente</th>
                        </tr>";
        foreach ($ordenes as $key => $orden) {
                   $tabla .= "<tr>
                                <td>".$orden->orden_no."</td>
                                <td>".$orden->fecha."</td>
                                <td>".$orden->dia."</td>
                                <td>".$orden->Mes."</td>
                                <td>".$orden->razon_social."</td>
                                <td>".$orden->semades."</td>
                                <td>".$orden->cliente."</td>
                                <td>".$orden->cuota."</td>
                                <td>".$orden->unidad."</td>
                                <td>".$orden->pu."</td>
                                <td>".$orden->placas."</td>
                                <td>".$orden->username."</td>
                                <td>".$orden->peso."</td>
                                <td>".$orden->toneladas."</td>
                                <td>".$orden->cantidad."</td>
                                <td>".$orden->reciclable."</td>
                                <td>".utf8_decode($orden->clasificacion)."</td>
                                <td>".$orden->peso_reciclable."</td>
                                <td>".$orden->toneladas_r."</td>
                                <td>".$orden->observaciones."</td>
                                <td>".$orden->hora_inicio."</td>
                                <td>".$orden->hora_termino."</td>
                                <td>".$orden->km_dif."</td>
                                <td>".$orden->inorganicos."</td>
                                <td>".$orden->organicos."</td>
                                <td>".$orden->sanitarios."</td>
                                <td>".$orden->costo_pago."</td>
                                <td>$".number_format($orden->costo_pago * $orden->peso_reciclable,3)."</td>
                                <td>".$orden->costo_cliente."</td>
                                <td>$".number_format($orden->costo_cliente * $orden->peso_reciclable,3)."</td>
                            </tr>";
            }
            //($key == 0)? \Helper::km_rest($orden->km, $orden->kilometraje_inicio) : \Helper::km_rest($orden->km, $ordenes[$key-1]->km)
            $tabla ."</table>";
            return $tabla;
    }

public function newSheet(){
      $pdf = new Fpdf();
      $pdf::AddPage('P','Letter');
      $pdf::Image(__DIR__.'/../../../public/img/reporte/marca_agua.jpg',0,0,217,'jpg');
      return $pdf;
    }

public function pdfReport(Request $request){
      $data = $request->all();
      $m = (int)date('m');
      $date = date('Y')."-".$m;
      if(Auth::user()->tipo_usuario_id == 3 && $date == $data['year-select']."-".$data['month-select'] && date('d') <= 10){
          
        return "Disculpa las molestias este reporte esta en proceso. Te agradecemos tu preferencia Recolectora Metropolitana.";
      }
      
       
        $hojaTotal = 0;
        if($data['tipo-select'] == "" || $data['clientes-select'] == "" || $data['month-select'] == "" || $data['year-select'] == ""){
          return "Se debe Seleccionar Tipo de Reporte, Cliente, Mes y Año";
        }else{
          $id = $data['clientes-select'];
          $month = $data['month-select'];
          $year = $data['year-select'];
          switch ($data['tipo-select']) {
            case 1:
                return $this->ReportManifiesto($id,$year,$month);
              break;
            case 2:
                return $this->ReportReciclable2($id,$year,$month);
              break;
            case 3:
              return $this->ReportReciclableCosto($id,$year,$month);
            break;

default:
              # code...
              break;
          }
        }
    }

public function ReportManifiesto($id,$year,$month){

$ordenes = new Ordenes();
        $orden = $ordenes->tota_orden($id, $year, $month);
        $dataOrden = $orden->getData()->data;

if($dataOrden == ""){
           return "No hay Ordenes Registradas";
        }
        $x = 18;
        $pdf = $this->infoCompany($x);

/*$pdf::SetFont('Arial','B',12);
        $pdf::Cell(120,10,utf8_decode("Ubicación del vertedero autorizado:"),0);
        $pdf::Cell(50,10,strtoupper(utf8_decode("Autorizacion Vigente:")),0);
        $pdf::SetXY($x,$pdf::GetY()+$y);
        $pdf::SetFont('Arial','',12);
        $pdf::Cell(120,10,strtoupper(utf8_decode($data->vertedero2)),0);
        $pdf::Cell(50,10,strtoupper(utf8_decode($data->codigo2)),0);
        $pdf::SetXY($x,$pdf::GetY()+$y);
        $pdf::Cell(50,10,(utf8_decode($data->direccion2)),0);
        $pdf::SetXY($x,$pdf::GetY()+$y);
        $pdf::Cell(50,10,(utf8_decode($data->direccion2_2)),0);*/

$pdf::SetXY($x,185);
        $pdf::SetFont('Arial','B',9);
        $pdf::SetTextColor(255,255,255,1);
        $pdf::SetDrawColor(255,255,255,1);
        $pdf::SetFillColor(71,147,200);
        $pdf::Cell(120,10,utf8_decode("Cliente: ".$dataOrden[0]->cliente),0);

$pdf::SetXY($x,195);
        $pdf::Cell(30,10,(utf8_decode("AÑO")),1,0,'C',1);
        $pdf::Cell(30,10,(utf8_decode("MES")),1,0,'C',1);
        $pdf::MultiCell(30,5,(utf8_decode("TONELADAS INORGANICO")),1,'C',1);
        $pdf::SetXY(108,195);
        $pdf::MultiCell(30,5,(utf8_decode("TONELADAS ORGANICO")),1,'C',1);
        $pdf::SetXY(138,195);
        $pdf::MultiCell(30,5,(utf8_decode("TONELADAS SANITARIO")),1,'C',1);
        $pdf::SetXY(168,195);
        $pdf::MultiCell(30,5,(utf8_decode("TOTAL TONELADAS")),1,'C',1);

$pdf::SetFont('Arial','B',11);
        $pdf::SetTextColor(0,0,0);
        $pdf::SetFillColor(221,235,246);
        $pdf::SetXY($x,205);
        $pdf::Cell(30,7,$dataOrden[0]->Year,1,0,'C',1);
        $pdf::Cell(30,7,$dataOrden[0]->Mes,1,0,'C',1);
        $pdf::MultiCell(30,7,Helper::redondeado($dataOrden[0]->inorganicos,3),1,'C',1);
        $pdf::SetXY(108,205);
        $pdf::MultiCell(30,7,Helper::redondeado($dataOrden[0]->organicos,3),1,'C',1);
        $pdf::SetXY(138,205);
        $pdf::MultiCell(30,7,Helper::redondeado($dataOrden[0]->sanitarios,3),1,'C',1);
        $pdf::SetXY(168,205);
        $pdf::MultiCell(30,7,Helper::redondeado($dataOrden[0]->Total,3),1,'C',1);

$this->deshechos_detail_month($id, $year, $month);

$pdf::Output();
        exit;
    }

public function infoCompany($x){

$report = new ReportConfig();
      $data = $report->find(1);

$y = 6;

$pdf = $this->newSheet();

$pdf::SetFont('Arial','B',12);
      $pdf::SetXY(70,15);
      $pdf::Cell(80,10,"Guadalajara, Jalisco ".Helper::mostrar_fecha_completa(date('Y-m-d')));

$pdf::SetXY($x,25);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(50,10,"A quien corresponda:",0);
      $pdf::SetXY($x,33);
      $pdf::SetFont('Arial','',11);
      $pdf::Cell(50,10,"Presente",0);
      $pdf::SetXY($x,41);
      $pdf::MultiCell(150,5,utf8_decode("Por medio de la presente, envío la información solicitada, de la recolección y transporte de residuos de manejo especial no peligrosos, como: alimento, jardinería, sanitarios y otros inorgánicos, en su separación primaria, residuos orgánicos, inorgánicos y sanitarios; según la norma ambiental NAE-SEMADES-007/2008 , que realizamos en sus instalaciones."));

$pdf::SetXY($x,65);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(50,10,"Datos Generales de la Empresa Recolectora:",0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::SetFont('Arial','',11);
      $pdf::Cell(50,10,(utf8_decode($data->nombre)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(90,10,(utf8_decode($data->direccion.", Col.".$data->colonia)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(90,10,(utf8_decode("C.P.".$data->cp.", ".$data->ciudad.", ".$data->estado)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(90,10,strtoupper(utf8_decode("RFC.".$data->rfc)),0);

$pdf::SetXY($x,94);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(120,10,"Registro ante SEMADET:",0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::SetFont('Arial','',11);
      $pdf::Cell(120,10,strtoupper("OFICIO SEMADET: ".utf8_decode("/DGIR/1994/DRT/2017 | DGPGA/DGIR/00649/RSD/1574/2016  DR 554/16")),0);
      // $pdf::Cell(50,10,strtoupper("DR 554/16"),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Expedido: 04 Diciembre 2017")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Vencimiento: 03 Diciembre 2027")),0);

$pdf::SetXY($x,118);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(120,10,utf8_decode("Ubicación del Relleno Sanitario autorizado:"),0);
      //$pdf::Cell(50,10,strtoupper(utf8_decode("Autorizacion Vigente:")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::SetFont('Arial','',11);
      $pdf::Cell(120,10,(utf8_decode($data->vertedero)),0);
      //$pdf::Cell(50,10,strtoupper(utf8_decode($data->codigo)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      //$pdf::Cell(50,10,(utf8_decode($data->direccion1)),0);
      $pdf::Cell(50,10,(utf8_decode('Av. San Francisco (carretera a el salto ) # 1019 col. Los Laureles Tonalá , Jalisco.')),0);
      //$pdf::SetXY($x,$pdf::GetY()+$y);
      //$pdf::Cell(50,10,(utf8_decode($data->direccion1_1)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(120,10,"GESTION INTEGRAL Y ACOPIO. S.A. DE C.V.",0);
      //$pdf::Cell(50,10,strtoupper(utf8_decode($data->codigo)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      //$pdf::Cell(50,10,(utf8_decode($data->direccion1)),0);
      $pdf::Cell(50,10,(utf8_decode('Av. Vallarta no.641 Int 6 Col. San Juan de Ocotan, Zapopan, Jalisco CP 45519')),0);

$pdf::SetXY($x,148);

$pdf::SetFont('Arial','B',11);
      $pdf::Cell(120,10,utf8_decode("Autorizacion Vigente:"),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      // $pdf::Cell(50,10,(utf8_decode("Permiso:".$data->codigo)),0);
      $pdf::Cell(50,10,(utf8_decode("Permiso: SEMADET/DGPGA/DGIR/2204/RSD/2018/2027")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Permiso: SEMADET/DGPGA/DGIR/00649/RSD/1574/2016")),0);
      // $pdf::Cell(50,10,(utf8_decode("Vigencia: ")),0);

// New values added
      $pdf::SetFont('Arial','',11);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("GRUPO ENERWASTE SA DE CV")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("La Estancia, KM 9+300 del camino Acueducto Calderon San Gaspar, en Zapotlanejo, Jalisco.")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(50,10,(utf8_decode("Autorización: DREMI 1412400121 DF/16")),0);

$pdf::SetFont('Arial','B',10);
      $pdf::SetTextColor(0,0,0,1);
      $pdf::SetDrawColor(0,0,0);
      $pdf::SetXY(192,253);
      $pdf::Cell(15,5,'Hoja: '.$pdf::PageNo(),0);

return $pdf;
    }

public function deshechos_detail_month($id, $year, $month){

$ordenes = new Ordenes();
      $orden = $ordenes->total_month($id,$month,$year);
      if($orden->getData()->status){

$x = 18;
      
        $pdf = $this->newSheet();
        $data = $orden->getData()->data;
        $pdf::SetXY($x,20);
        $pdf::SetFont('Arial','B',12);
        $pdf::SetTextColor(0,0,0);
        $pdf::Cell(120,7,utf8_decode("Cliente: ".(ucwords(strtolower($data[0]->cliente_n)))),0);
        $pdf::SetXY($x,27);
        $pdf::Cell(120,7,utf8_decode("Sucursal: ".(ucwords(strtolower($data[0]->cliente)))),0);
        $pdf::SetXY($x,34);
        $pdf::Cell(120,7,(ucwords(strtolower(utf8_decode("Domicilio: ".$data[0]->direccion." Col. ".$data[0]->colonia)))),0);

$pdf::SetFont('Arial','B',9);
        $pdf::SetTextColor(255,255,255,1);
        $pdf::SetDrawColor(255,255,255,1);
        $pdf::SetFillColor(94,156,211);
        $pdf::SetXY($x,45);
        $pdf::Cell(23,10,(utf8_decode("NO. ORDEN")),1,0,'C',1);
        $pdf::Cell(23,10,(utf8_decode("FECHA")),1,0,'C',1);
        $pdf::Cell(18,10,(utf8_decode("UNIDAD")),1,0,'C',1);
        $pdf::Cell(18,10,(utf8_decode("CANTIDAD")),1,0,'C',1);
        $pdf::SetXY(100,45);
        $pdf::MultiCell(25,5,(utf8_decode("TONELADAS INORGANICO")),1,'C',1);
        $pdf::SetXY(125,45);
        $pdf::MultiCell(25,5,(utf8_decode("TONELADAS ORGANICO")),1,'C',1);
        $pdf::SetXY(150,45);
        $pdf::MultiCell(25,5,(utf8_decode("TONELADAS SANITARIO")),1,'C',1);
        $pdf::SetXY(175,45);
        $pdf::MultiCell(23,5,(utf8_decode("TOTAL TONELADAS")),1,'C',1);
        $y = 55;
        $inorganicos = 0;
        $organicos = 0;
        $sanitarios = 0;
        $cantidad = 0;

foreach($data as $key => $value){
          if($pdf::GetY() >= 200){
              $pdf = $this->newSheet();
              $x=18;$y=20;
          }
          $pdf::SetXY($x,$y);
          $pdf::SetFont('Arial','',10);
          $pdf::SetTextColor(0,0,0);
          $pdf::SetFillColor(221,235,246);
          $pdf::Cell(23,5,$value->orden_no,1,0,'C',1);
          $pdf::Cell(23,5,$value->fecha,1,0,'C',1);
          $pdf::Cell(18,5,$value->unidad,1,0,'C',1);
          $pdf::Cell(18,5,Helper::redondeado($value->cantidad,2),1,0,'C',1);
          $pdf::SetXY(100,$y);
          $pdf::MultiCell(25,5,Helper::redondeado($value->inorganicos,3),1,'C',1);
          $pdf::SetXY(125,$y);
          $pdf::MultiCell(25,5,Helper::redondeado($value->organicos,3),1,'C',1);
          $pdf::SetXY(150,$y);
          $pdf::MultiCell(25,5,Helper::redondeado($value->sanitarios,3),1,'C',1);
          $pdf::SetXY(175,$y);
          $pdf::MultiCell(23,5,Helper::redondeado($value->total,3),1,'C',1);
          $y += 5;

$inorganicos += $value->inorganicos;
          $organicos += $value->organicos;
          $sanitarios += $value->sanitarios;
          $cantidad += $value->cantidad;

}
        $y = $pdf::GetY();
        $pdf::SetXY($x,$y);
        $pdf::SetFont('Arial','B',11);
        $pdf::SetTextColor(255,255,255,1);
        $pdf::SetFillColor(94,156,211);
        $pdf::Cell(64,7,"Total General",1,0,'C',1);
        $pdf::MultiCell(18,7,Helper::redondeado($cantidad,2),1,'C',1);
        $pdf::SetXY(100,$y);
        $pdf::MultiCell(25,7,Helper::redondeado($inorganicos,3),1,'C',1);
        $pdf::SetXY(125,$y);
        $pdf::MultiCell(25,7,Helper::redondeado($organicos,3),1,'C',1);
        $pdf::SetXY(150,$y);
        $pdf::MultiCell(25,7,Helper::redondeado($sanitarios,3),1,'C',1);
        $pdf::SetXY(175,$y);
        $pdf::MultiCell(23,7,Helper::redondeado($inorganicos+$organicos+$sanitarios, 3),1,'C',1);

if($pdf::GetY() >= 230){
            $pdf = $this->newSheet();
            $x=18;$y=20;
        }else{
            $pdf::SetTextColor(0,0,0);
            $this->signature($pdf);
        }

$pdf::SetFont('Arial','B',10);
        $pdf::SetTextColor(0,0,0,1);
        $pdf::SetDrawColor(0,0,0);
        $pdf::SetXY(190,230);
        $pdf::Cell(15,5,'Hoja: '.$pdf::PageNo(),0);

}
      $this->anualReport($id, $year, $month);
      //$this->category_report($id,$month,$year);

}

public function ReportReciclable($id,$year,$month){

$ordenes = new Ordenes();

$orden = $ordenes->ordenReciclable($id,$year,$month);

if(!$orden){
        return "No hay Información para este reporte";
      }

$x = 18;
      $pdf = $this->infoCompany($x);

$pdf::SetXY(60,$pdf::GetY()+15);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(50,10,"Cliente: ".strtoupper(utf8_decode($orden[0]->cliente)),0);

//tabla
      $x = 28;
      $y = 180;
      $total_kg = 0;
      $total_tn = 0;
      $pdf::SetFont('Arial','B',9);
      $pdf::SetTextColor(255,255,255,1);
      $pdf::SetDrawColor(255,255,255,1);
      $pdf::SetFillColor(94,156,211);
      $pdf::SetXY($x,$y);
      $pdf::Cell(32,10,(utf8_decode("NO. ORDEN")),1,0,'C',1);
      $pdf::Cell(32,10,(utf8_decode("FECHA")),1,0,'C',1);
      $pdf::Cell(32,10,(utf8_decode("MATERIAL")),1,0,'C',1);
      $pdf::Cell(32,10,(utf8_decode("RECOLECCION KG")),1,0,'C',1);
      $pdf::Cell(32,10,(utf8_decode("RECOLECCION TN")),1,0,'C',1);

foreach($orden as $key => $value){
        if($pdf::GetY() >= 200){
            $pdf = $this->newSheet();
            $x=28;$y=20;
        }
        $pdf::SetXY($x,$y+10);
        $pdf::SetFont('Arial','',10);
        $pdf::SetTextColor(0,0,0);
        $pdf::SetFillColor(221,235,246);
        $pdf::Cell(32,5,$value->orden_no,1,0,'C',1);
        $pdf::Cell(32,5,$value->fecha,1,0,'C',1);
        $pdf::Cell(32,5,$value->reciclable,1,0,'C',1);
        $pdf::Cell(32,5,number_format($value->peso_kg,2),1,0,'C',1);
        $pdf::Cell(32,5,number_format($value->peso_tn,2),1,0,'C',1);
        $y += 5;

$total_kg += $value->peso_kg;
        $total_tn += $value->peso_tn;

}

$y = $pdf::GetY();
      $pdf::SetXY($x,$y);
      $pdf::SetFont('Arial','B',11);
      $pdf::SetTextColor(255,255,255,1);
      $pdf::SetFillColor(94,156,211);
      $pdf::Cell(32,7,"Total:",1,0,'C',1);
      $pdf::Cell(32,7,"",1,0,'C',1);
      $pdf::Cell(32,7,"",1,0,'C',1);
      $pdf::Cell(32,7,number_format($total_kg,2),1,0,'C',1);
      $pdf::Cell(32,7,number_format($total_tn,2),1,0,'C',1);

if($pdf::GetY() >= 230){
          $pdf = $this->newSheet();
          $x=18;$y=20;
      }else{
          $pdf::SetTextColor(0,0,0);
          $this->signature($pdf);
      }

$pdf::SetFont('Arial','B',10);
      $pdf::SetTextColor(0,0,0,1);
      $pdf::SetDrawColor(0,0,0);
      $pdf::SetXY(190,230);
      $pdf::Cell(15,5,'Hoja: '.$pdf::PageNo(),0);

$pdf::Output();
      exit;
    }

public function ReportReciclable2($id,$year,$month){

$report = new ReportConfig();
      $data = $report->find(1);

$ordenes = new Ordenes();

$orden = $ordenes->ordenReciclable($id,$year,$month);

if(!$orden){
        return "No hay Información para este reporte";
      }

$x = 18;
      $y = 6;

$pdf = $this->newSheet();

$pdf::SetFont('Arial','B',12);
      $pdf::SetXY(70,15);
      $pdf::Cell(80,10,"Guadalajara, Jalisco ".Helper::mostrar_fecha_completa(date('Y-m-d')));

$pdf::SetXY($x,45);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(50,10, utf8_decode($orden[0]->cliente),0);
      $pdf::SetXY($x,53);
      $pdf::SetFont('Arial','',11);
      //$pdf::Cell(50,10,"Presente",0);
      $pdf::SetXY($x,61);
      $pdf::MultiCell(150,5,utf8_decode("Por medio de la presente, envío la información solicitada, de la recolección y transporte de residuos de manejo especial no peligrosos,como: papel, carton, aluminio, chatarra, vidrio y plastico, en su separación primaria, residuos orgánicos, inorgánicos y sanitarios; según la norma ambiental NAE-SEMADES-007/2008 , que realizamos en sus instalaciones."));

$pdf::SetXY($x,88);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(50,10,"Datos Generales de la Empresa:",0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::SetFont('Arial','',11);
      $pdf::Cell(50,10,(utf8_decode($data->nombre)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(90,10,(utf8_decode($data->direccion.", Col.".$data->colonia)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(90,10,(utf8_decode("C.P.".$data->cp.", ".$data->ciudad.", ".$data->estado)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(90,10,strtoupper(utf8_decode("RFC.".$data->rfc)),0);

$pdf::SetXY($x,120);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(50,10,"Registro ante SEMADET:",0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::SetFont('Arial','',12);
      $pdf::Cell(50,10,strtoupper('Oficio de SEMADET: '.utf8_decode($data->semades). " | DGPGA/DGIR/00649/RSD/1574/2016"),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,strtoupper(utf8_decode($data->semades2)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Expedido: 04 Diciembre 2017")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Vencimiento: 03 Diciembre 2027")),0);

$pdf::SetXY($x,155);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(120,10,utf8_decode("Ubicación del centro de acopio autorizado:"),0);
      //$pdf::Cell(50,10,strtoupper(utf8_decode("Autorizacion Vigente:")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::SetFont('Arial','',11);
      $pdf::Cell(120,10,strtoupper(utf8_decode($data->vertedero3)." | GESTION INTEGRAL Y ACOPIO. S.A. DE C.V."),0);
      //$pdf::Cell(50,10,strtoupper(utf8_decode($data->codigo3)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("AV. 8 de Julio # 3029 CP 44960 Col Echeverria")),0);
      // $pdf::Cell(50,10,(utf8_decode('Av. San Francisco (Carretera el Salto) #1019 Col. Los Laureles, Tonala, Jalisco.')),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      //$pdf::Cell(50,10,strtoupper(utf8_decode($data->codigo3)),0);
      $pdf::Cell(50,10,(utf8_decode($data->direccion3_3)),0);
      
      // New info added
      $pdf::SetXY($x,170);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Bio pappel sab de C.V.")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Oficio semandet/DGPA/DGIR/1314/DREMI/2685/2015")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Permiso: DREMI/1403900441/CA20")),0);

$pdf::SetXY($x,$pdf::GetY()+$y+2);
      $pdf::Cell(50,10,(utf8_decode("Desperdicios y reciclados gallo sa de C.V.")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Permiso semadet: 1409800583/CA 18")),0);

$pdf::SetXY($x,$pdf::GetY()+$y+2);
      $pdf::Cell(50,10,(utf8_decode("Zitlali Esperanza Delgadillo Salcedo")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Permiso: DREMI14101005561/RE")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Oficio semadet: DGIR/1994/DRT/2017/DGPGA/DGIR/00649/1574/2016.")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("DR55/16")),0);

$pdf = $this->newSheet();

$x = 28;
      $pdf::SetFont('Arial','B',11);      
      $pdf::SetXY($x,20);
      $pdf::Cell(120,7,utf8_decode("Cliente: ".(ucwords(strtolower($orden[0]->cliente)))),0);
      $pdf::SetXY($x,27);
      $pdf::Cell(120,7,utf8_decode("Sucursal: ".(ucwords(strtolower($orden[0]->nombre_comercial)))),0);
      $pdf::SetXY($x,34);
      $pdf::Cell(120,7,(ucwords(strtolower(utf8_decode("Domicilio: ".$orden[0]->direccion.", Col.: ".$orden[0]->colonia)))),0);

//tabla
      $y = 45;
      $total_kg = 0;
      $total_tn = 0;
      $pdf::SetFont('Arial','B',9);
      $pdf::SetTextColor(255,255,255,1);
      $pdf::SetDrawColor(255,255,255,1);
      $pdf::SetFillColor(94,156,211);
      $pdf::SetXY($x,$y);
      $pdf::Cell(32,10,(utf8_decode("NO. ORDEN")),1,0,'C',1);
      $pdf::Cell(32,10,(utf8_decode("FECHA")),1,0,'C',1);
      $pdf::Cell(32,10,(utf8_decode("MATERIAL")),1,0,'C',1);
      $pdf::Cell(32,10,(utf8_decode("RECOLECCION KG")),1,0,'C',1);
      $pdf::Cell(32,10,(utf8_decode("RECOLECCION TN")),1,0,'C',1);

foreach($orden as $key => $value){
        if($pdf::GetY() >= 200){
            $pdf = $this->newSheet();
            $x=28;$y=20;
        }
        $pdf::SetXY($x,$y+10);
        $pdf::SetFont('Arial','',10);
        $pdf::SetTextColor(0,0,0);
        $pdf::SetFillColor(221,235,246);
        $pdf::Cell(32,5,$value->orden_no,1,0,'C',1);
        $pdf::Cell(32,5,$value->fecha,1,0,'C',1);
        $pdf::Cell(32,5,utf8_decode($value->reciclable),1,0,'C',1);
        $pdf::Cell(32,5,number_format($value->peso_kg,2),1,0,'R',1);
        $pdf::Cell(32,5,number_format($value->peso_tn,3),1,0,'R',1);
        $y += 5;

$total_kg += $value->peso_kg;
        $total_tn += $value->peso_tn;

}

$y = $pdf::GetY()+5;
      $pdf::SetXY($x,$y);
      $pdf::SetFont('Arial','B',11);
      $pdf::SetTextColor(255,255,255,1);
      $pdf::SetFillColor(94,156,211);
      $pdf::Cell(32,7,"Total:",1,0,'C',1);
      $pdf::Cell(32,7,"",1,0,'C',1);
      $pdf::Cell(32,7,"",1,0,'C',1);
      $pdf::Cell(32,7,number_format($total_kg,2),1,0,'R',1);
      $pdf::Cell(32,7,number_format($total_tn,3),1,0,'R',1);

if($pdf::GetY() >= 200){
          $pdf = $this->newSheet();
          $x=18;$y=20;
          $pdf::SetTextColor(0,0,0);
          $this->signature($pdf);
      }else{
          $pdf::SetTextColor(0,0,0);
          $this->signature($pdf);
      }

$pdf::SetFont('Arial','B',10);
      $pdf::SetTextColor(0,0,0,1);
      $pdf::SetDrawColor(0,0,0);
      $pdf::SetXY(190,230);
      $pdf::Cell(15,5,'Hoja: '.$pdf::PageNo(),0);

$pdf = $this->anualReportReciclable($id, $year, $month);

$pdf::Output();
      exit;
    }

public function ReportReciclableCosto($id,$year,$month){

$report = new ReportConfig();
      $data = $report->find(1);

$ordenes = new Ordenes();

$orden = $ordenes->ordenReciclable($id,$year,$month);

if(!$orden){
        return "No hay Información para este reporte";
      }

$x = 18;
      $y = 6;

$pdf = $this->newSheet();

$pdf::SetFont('Arial','B',12);
      $pdf::SetXY(70,30);
      $pdf::Cell(80,10,"Guadalajara, Jalisco ".Helper::mostrar_fecha_completa(date('Y-m-d')));

$pdf::SetXY($x,45);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(50,10,"ATN: ".$orden[0]->cliente,0);
      $pdf::SetXY($x,53);
      $pdf::SetFont('Arial','',11);
      //$pdf::Cell(50,10,"Presente",0);
      $pdf::SetXY($x,61);
      $pdf::MultiCell(150,5,utf8_decode("Por medio de la presente reciba nuestros saludos cordiales; y le anexo detalle el pago que se realizo por concepto de compra de reciclables."));

/*
      $pdf::SetXY($x,83);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(50,10,"Datos Generales de la Empresa:",0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::SetFont('Arial','',11);
      $pdf::Cell(50,10,(utf8_decode($data->nombre)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(90,10,(utf8_decode($data->direccion.", COL.".$data->colonia)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(90,10,(utf8_decode("C.P.".$data->cp.", ".$data->ciudad.", ".$data->estado)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(90,10,strtoupper(utf8_decode("RFC.".$data->rfc)),0);

$pdf::SetXY($x,115);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(50,10,"Registro ante SEMADET:",0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::SetFont('Arial','',12);
      $pdf::Cell(50,10,strtoupper('Oficio de SEMADET: '.utf8_decode($data->semades)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,strtoupper(utf8_decode($data->semades2)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Expedido: 04 Diciembre 2017")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode("Vencimiento: 03 Diciembre 2027")),0);

$pdf::SetXY($x,148);
      $pdf::SetFont('Arial','B',11);
      $pdf::Cell(120,10,utf8_decode("Ubicación del vertedero autorizado:"),0);
      //$pdf::Cell(50,10,strtoupper(utf8_decode("Autorizacion Vigente:")),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::SetFont('Arial','',11);
      $pdf::Cell(120,10,strtoupper(utf8_decode($data->vertedero3)),0);
      //$pdf::Cell(50,10,strtoupper(utf8_decode($data->codigo3)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,(utf8_decode($data->direccion3)),0);
      $pdf::SetXY($x,$pdf::GetY()+$y);
      $pdf::Cell(50,10,strtoupper(utf8_decode($data->codigo3)),0);
      //$pdf::Cell(50,10,(utf8_decode($data->direccion3_3)),0);
      $pdf = $this->newSheet();

$x = 20;
      $pdf::SetFont('Arial','B',11);      
      $pdf::SetXY($x,20);
      $pdf::Cell(120,7,utf8_decode("Cliente: ".(ucwords(strtolower($orden[0]->cliente)))),0);
      $pdf::SetXY($x,27);
      $pdf::Cell(120,7,utf8_decode("Sucursal: ".(ucwords(strtolower($orden[0]->nombre_comercial)))),0);
      $pdf::SetXY($x,34);
      $pdf::Cell(120,7,(ucwords(strtolower(utf8_decode("Domicilio: ".$orden[0]->direccion.", Col.: ".$orden[0]->colonia)))),0);
      */

//tabla
      $y = 75;
      $total_kg = 0;
      $total_tn = 0;
      $costo = 0;
      $pdf::SetFont('Arial','B',9);
      $pdf::SetTextColor(255,255,255,1);
      $pdf::SetDrawColor(255,255,255,1);
      $pdf::SetFillColor(94,156,211);
      $pdf::SetXY($x,$y);
      $pdf::Cell(28,10,(utf8_decode("NO. ORDEN")),1,0,'C',1);
      $pdf::Cell(28,10,(utf8_decode("FECHA")),1,0,'C',1);
      $pdf::Cell(28,10,(utf8_decode("MATERIAL")),1,0,'C',1);
      $pdf::Cell(32,10,(utf8_decode("RECOLECCION KG")),1,0,'C',1);
      $pdf::Cell(32,10,(utf8_decode("PRECIO")),1,0,'C',1);
      $pdf::Cell(28,10,(utf8_decode("TOTAL CLIENTE")),1,0,'C',1);

foreach($orden as $key => $value){
        if($pdf::GetY() >= 200){
            $pdf = $this->newSheet();
            $x=28;$y=20;
        }
        $pdf::SetXY($x,$y+10);
        $pdf::SetFont('Arial','',10);
        $pdf::SetTextColor(0,0,0);
        $pdf::SetFillColor(221,235,246);
        $pdf::Cell(28,5,$value->orden_no,1,0,'C',1);
        $pdf::Cell(28,5,$value->fecha,1,0,'C',1);
        $pdf::Cell(28,5,utf8_decode($value->reciclable),1,0,'C',1);
        $pdf::Cell(32,5,number_format($value->peso_kg,2),1,0,'R',1);
        $pdf::Cell(32,5,"$".number_format($value->costo_cliente,2),1,0,'R',1);
        $pdf::Cell(28,5,"$".number_format($value->peso_kg * $value->costo_cliente,2),1,0,'R',1);
        $y += 5;

$total_kg += $value->peso_kg;
        $total_tn += $value->costo_cliente;
        $costo += ($value->peso_kg * $value->costo_cliente);

}

$y = $pdf::GetY()+5;
      $pdf::SetXY($x,$y);
      $pdf::SetFont('Arial','B',11);
      $pdf::SetTextColor(255,255,255,1);
      $pdf::SetFillColor(94,156,211);
      $pdf::Cell(28,7,"Total:",1,0,'C',1);
      $pdf::Cell(28,7,"",1,0,'C',1);
      $pdf::Cell(28,7,"",1,0,'C',1);
      $pdf::Cell(32,7,number_format($total_kg,2),1,0,'R',1);
      $pdf::Cell(32,7,"$".number_format($total_tn,2),1,0,'R',1);
      $pdf::Cell(28,7,"$".number_format($costo,2),1,0,'R',1);

$pdf::SetFont('Arial','B',10);
      $pdf::SetTextColor(0,0,0,1);
      $pdf::SetDrawColor(0,0,0);
      $pdf::SetXY(190,230);
      $pdf::Cell(15,5,'Hoja: '.$pdf::PageNo(),0);

//$pdf = $this->anualReportReciclable($id, $year, $month);

$pdf::Output();
      exit;
    }

public function signature($pdf){
        $report = new ReportConfig();
        $data = $report->find(1);
        $pdf::SetXY(80,210);
        $pdf::SetFont('Arial','',11);
        $pdf::image(__DIR__.'/../../../public/img/reporte/firma.png',90,215,40,'png');
        $pdf::Cell(60,10,strtoupper("Sin mas por el momento quedo a sus ordenes."),0,0,'C');
        $pdf::SetXY(80,230);
        $pdf::Cell(60,10,strtoupper("__________________________"),0,0,'C');
        $pdf::SetXY(80,236);
        $pdf::Cell(60,10,strtoupper($data->nombre),0,0,'C');

return $pdf;
    }

public function anualReport($id, $year, $month){

$ordenes = new Ordenes();
      $orden = $ordenes->tota_orden($id, $year, $month,1);
      $dataOrden = $orden->getData()->data;

if($dataOrden == ""){
         return "No hay Ordenes Registradas";
      }

$pdf = $this->newSheet();

$pdf::SetXY(15,35);
      $pdf::SetFont('Arial','',12);
      $pdf::Cell(50,10,utf8_decode("Cliente: ".(ucwords(strtolower($dataOrden[0]->cliente2)))),0);
      $pdf::SetXY(15,42);
      $pdf::Cell(50,10,utf8_decode("Sucursal: ".(ucwords(strtolower($dataOrden[0]->cliente)))),0);
      $pdf::SetXY(15,49);
      $pdf::Cell(50,10,utf8_decode("Domicilio: ".(ucwords(strtolower($dataOrden[0]->direccion." Col. ".$dataOrden[0]->colonia)))),0);

$pdf::SetFillColor(208,208,208);
      $pdf::Rect(10,65,35,27,'DF');
      $pdf::SetXY(12,80);
      $pdf::MultiCell(30,5,"Residuo Recolectado",0,'C');
      $pdf::SetXY(45,65);
      $pdf::Cell(132,9,"Cantidades en Tn.",1,1,'C',1);

$pdf::SetXY(45,74);
      $pdf::SetFont('Arial','',9);
      $pdf::Cell(132,9,utf8_decode("Año - ".$year),1,1,'C',0);

$mes =["Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic"];
      $x = 45; $y = 83;
      foreach ($mes as $key => $value) {
        $pdf::SetXY($x,$y);
        $pdf::Cell(11,9,utf8_decode($value),1,1,'C',0);
        $x += 11;
      }

/*$pdf::Rect(177,65,30,27,'DF');
      $pdf::SetXY(182,74);
      $pdf::MultiCell(20,5,"Total (Tn)",0,'C');*/

$pdf::SetFont('Arial','',9);

$_x = 10; $_y = 92;
      $tipo = ['inorganicos'=>'Inorganico','organicos'=>'Organico','sanitarios'=>'Sanitario'];
      $total_tn = 0;
      foreach ($tipo as $key => $tip) {
        $pdf::SetXY($_x,$_y);
        $pdf::Cell(35,9,strtoupper(utf8_decode($tip)),1,1,'C',0);

$array =["120","30.5","50.5","60","0","0","0","0","0","0","0","0"];
        $x = 45; $total = 0; $months = 1;
        for($i=1; $i<=12; $i++) {
          $pdf::SetXY($x,$_y);

if(isset($dataOrden[$months-1]->NoMes) and $dataOrden[$months-1]->NoMes == $i){
            //echo "no.Mes".$dataOrden[$months-1]->NoMes ."==". ($dataOrden[$months-1]->organicos)."i =".($i - 1)." <br>";
            $pdf::Cell(11,9,number_format($dataOrden[$months-1]->$key,2),1,1,'C',0);
            $total += $dataOrden[$months-1]->$key;
            $months++;
          }else{
            //echo "mon".$months ."== 0 i".($i - 1) ." <br>";
            $pdf::Cell(11,9,round(0,2),1,1,'C',0);
          }
          $x += 11;

}
        $pdf::SetXY(177,$_y);
        $pdf::Cell(30,9,number_format($total,2),1,1,'R',0);
        $total_tn += $total;
        $_y += 9;
      }

$pdf::Rect(177,65,30,27,'DF');
      $pdf::SetFont('Arial','',12);
      $pdf::SetXY(182,74);
      $pdf::MultiCell(20,5,"Total (Tn): ".number_format($total_tn,2),0,'C');

$pdf::SetXY(10,119);
      $pdf::SetFont('Arial','',9);
      $pdf::Cell(35,9,"Total por Mes",1,1,'C',1);
      $x = 45; $_y = 119; $total_m = 0;
      
      $j = 0;
        for($i=0; $i<=11; $i++) {
          $pdf::SetXY($x,$_y);
          //echo ($i+1)." => i ";
          //echo $j." => j ";
          if(isset($dataOrden[$j]->NoMes) && $dataOrden[$j]->NoMes == $i+1){
            //echo $dataOrden[$j]->NoMes;
            $pdf::Cell(11,9,number_format($dataOrden[$j]->Total,2),1,1,'C',0);
            $total_m += $dataOrden[$j]->Total;
            $j++;
          }else{
            //echo 0;
            $pdf::Cell(11,9,0,1,1,'C',0);
            if(isset($dataOrden[$j]->NoMes) && $dataOrden[$j]->NoMes < $i+1){
              $j++;
            }
          }
          $x += 11;

}
      
      $pdf::SetXY(177,119);
      $pdf::SetFont('Arial','',9);
      $pdf::Cell(30,9,number_format($total_m,2),1,0,'R');
      //$pdf::SetTextColor(189,0,0,1);
      //$pdf::Cell(162,9,"Caabsa Eagle Guadalajara SA de CV",1,1,'C',1);

$pdf::SetXY(10,128);
      $pdf::SetTextColor(0,0,0,1);
      $pdf::Cell(35,9,ucwords(strtolower(utf8_decode("Registro")))." SEMADET",1,1,'C',1);
      $pdf::SetXY(45,128);
      $pdf::SetFont('Arial','',11);
      $pdf::SetTextColor(189,0,0,1);
      $pdf::Cell(162,9,ucwords(strtolower(utf8_decode("Permiso: 140100083 Vigencia: 25-08-17"))),1,1,'C',1);

$pdf::SetFont('Arial','B',10);
      $pdf::SetTextColor(0,0,0,1);
      $pdf::SetDrawColor(0,0,0);
      $pdf::SetXY(190,230);
      $pdf::Cell(15,5,'Hoja: '.$pdf::PageNo(),0);

$this->signature($pdf);

return $pdf;

}

public function anualReportReciclable($id, $year, $month){

$ordenes = new Ordenes();
      $orden = $ordenes->ordenReciclableAnual($id, $year, $month);

if(!$orden){
         return "No hay Ordenes Registradas";
      }

$pdf = $this->newSheet();

$pdf::SetXY(15,35);
      $pdf::SetFont('Arial','',13);
      $pdf::Cell(50,10,utf8_decode("Cliente: ".(ucwords(strtolower($orden[0]->cliente)))),0);
      $pdf::SetXY(15,42);
      $pdf::Cell(50,10,utf8_decode("Sucursal: ".(ucwords(strtolower($orden[0]->nombre_comercial)))),0);
      $pdf::SetXY(15,49);
      $pdf::Cell(50,10,utf8_decode("Domicilio: ".(ucwords(strtolower($orden[0]->direccion." Col. ".$orden[0]->colonia)))),0);

$pdf::SetXY(45,74);
      $pdf::SetFont('Arial','',9);
      $pdf::Cell(132,9,utf8_decode("Año - ".$year),1,1,'C',0);

$pdf::Rect(177,65,30,27,'DF');
      $pdf::SetXY(182,74);
      $pdf::SetFont('Arial','',13);
      $pdf::MultiCell(20,5,"Total (Tn)",0,'C');
      $pdf::SetFont('Arial','',9);

$_x = 10; $_y = 92;

$tipo = [];
      $i= 0;
      foreach ($orden as $key => $value) {
        if($value->peso_tn != 0){
          $reciclable = ($value->reciclable);
          if(!in_array($reciclable, $tipo)){
            array_push($tipo,$reciclable);
            $i++;
          }
        }
      }

$_x = 10; $_y = 92;
      foreach ($tipo as $key => $tip) {
        $pdf::SetXY($_x,$_y);
        $pdf::Cell(35,9,(ucwords(strtolower((utf8_decode($tip))))),1,1,'C',0);
        $_y += 9;
      }
      $pdf::SetFont('Arial','B',7);
      $pdf::Cell(35,9,strtoupper(utf8_decode("Total General Kg")),1,1,'C',0);

$_x = 45;$_y = 92;
      for($i=1; $i<=12; $i++) {
         $total = 0;
         $pdf::SetFont('Arial','',7);
           foreach ($tipo as $key => $tip) {
             $pdf::SetXY($_x,$_y);
             if($i <= $month){
               $orden = $ordenes->ordenReciclableAnual($id, $year, $i, $tip);
               if(!$orden){
                 $pdf::Cell(11,9,round(0,2),1,1,'C',0);
                 $_y += 9;
               }else{
                 $pdf::Cell(11,9,number_format($orden[0]->peso_tn,2),1,1,'C',0);
                 $total += $orden[0]->peso_tn;
                 $_y += 9;
               }
             }else{
               $pdf::Cell(11,9,round(0,2),1,1,'C',0);
               $_y += 9;
             }
           }
         $pdf::SetFont('Arial','B',7);
         $pdf::SetXY($_x,$_y);
         $pdf::Cell(11,9,number_format(($total),2),1,1,'C',0);
         $_x += 11;
         $_y = 92;
      }

$_x = 177;
      $_y = 92;
      $total_tn = 0;
      $pdf::SetFont('Arial','',9);
      $total = $ordenes->totalReciclable($id,$year,$month);
      foreach ($total as $key => $value) {
        $total_tn += $value->peso_tn;
        $pdf::SetXY($_x,$_y);
        $pdf::Cell(30,9,number_format($value->peso_tn,2),1,1,'R',0);
        $_y += 9;
      }
      $_x = 177;
      $pdf::SetXY($_x,$pdf::getY());
      $pdf::SetFont('Arial','B',9);
      $pdf::Cell(30,9,number_format($total_tn,2),1,1,'R',0);

$y = $pdf::GetY();
      $pdf::SetXY(10,$y);
      $pdf::SetFont('Arial','',9);
      $pdf::Cell(35,9,"Centro de Acopio",1,1,'C',1);
      $pdf::SetXY(45,$y);
      $pdf::SetTextColor(189,0,0,1);
      $pdf::Cell(162,9,"Javier Torres Rodriguez Av. 8 de Julio #3029 C.P. 44960 Col. Echeverria",1,1,'C',1);
      $y = $y +9;
      $pdf::SetXY(10,$y);
      $pdf::SetTextColor(0,0,0,1);
      $pdf::SetFont('Arial','',9);
      $pdf::Cell(35,9,ucwords(strtolower(utf8_decode("Registro")))." SEMADET",1,1,'C',1);
      $pdf::SetXY(45,$y);
      $pdf::SetFont('Arial','',11);
      $pdf::SetTextColor(189,0,0,1);
      $pdf::Cell(162,9,ucwords(strtolower(utf8_decode("Permiso:")))." DEMI 14033900139",1,1,'C',1);

if($pdf::GetY() >= 210){
          $pdf = $this->newSheet();
          $x=18;$y=20;
          $pdf::SetTextColor(0,0,0);
          $this->signature($pdf);
      }else{
          $pdf::SetTextColor(0,0,0);
          $this->signature($pdf);
      }

$pdf::SetFont('Arial','B',10);
      $pdf::SetTextColor(0,0,0,1);
      $pdf::SetDrawColor(0,0,0);
      $pdf::SetXY(190,230);
      $pdf::Cell(15,5,'Hoja: '.$pdf::PageNo(),0);

return $pdf;

}