<?php namespace App\Http\Controllers; 
 
use App\Custom\SQLConnection; 
use App\Custom\Misc;  
use App\Custom\Mailer;
use App\Http\Controllers\AFIPController;
use App\Http\Controllers\UserController;
use Request;
use Session;
use DateTime;
use Illuminate\Support\Facades\Input;
use DB;
use stdClass;
use App\Http\Controllers\ReportsController;
use App\Http\Controllers\MainController;
use App\Http\Controllers\EmailControllerBackend; 



class HistoricoLedController extends Controller
{
	public function generarInforme(){
		$contraparte = $_GET['contraparte'];
		//------
		$qcontrap = DB::selectOne('EXEC dbo.LN_contrapartes_ ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?', array('select', $contraparte, null, null, null, null, null, null, null, null, null, null, null, null, null));
		$cliente = $qcontrap->cliente;
		$id_padron = $qcontrap->id_padron;
		$user_id = Session::get('usuario')->user_id;
		//------
		$padron  = DB::selectOne('EXEC dbo.backend_obtener_id_padron '.$id_padron);
		$pais = $padron->country_name;
		$gestion = $qcontrap->gestion;
		$nombre = $padron->nombre_persona;
		$cuit = $padron->numero;
		//------------
		$prodcli = DB::select('EXEC dbo.LN_cliente_productos_ ?,?,?,?,?,?,?', array('search', $cliente, null, null, null, null, $user_id));

		$tiene_pdfshistoricos = 0;
		if ( $pais == 'Argentina'){
			foreach ($prodcli as $key => $prod) {
				if ($prod->producto_id == 'pdfshistoricos'){		
					$tiene_pdfshistoricos = 1;
					break; 
				}
			}
		}		
		/*-----------------------------------------------------------------------------------*/
		return view('/led/led_contrapartes_redir_prueba')->with(compact(['cliente','pais' ,'contraparte','gestion','nombre','cuit','tiene_pdfshistoricos']));
	}

	public function generar(){


		$qcontrap = DB::selectOne('EXEC dbo.LN_contrapartes_ ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?', array('select', $id, null, null, null, null, null, null, null, null, null, null, null, null, null));		
		$gest = DB::selectOne('EXEC LN_gestiones_ ?,?,?,?,?,?,?,?', array('search', null, null, $id, null, null, 1, null));		
		$files = [];
		$gestiones = SQLConnection::backendStoreProcedure('ln_gestiones_contraparte', array($id), 'select');		
		//---
		$cuit = $qcontrap->numero;
		$cliente = '1659303046';		
		//---
		foreach ($gestiones as $key => $ges)  
		{
			if ($ges->duracion <= 60)
			{
				unset($gestiones[$key]); 
			}			
		}			
		foreach ($gestiones as $ges)
		{			
			//- SECCION DE PRUEBA
			$gestion = $gest->gestion;
			$docs1 = SQLConnection::backendStoreProcedure('LN_ic_historico_pdf_',array('LISTAR',$id));			
			
			//- FIN DE PRUEBA
			$docs[$ges->desde] = $docs1; 
			$n = -1;
			foreach ($docs1 as $k => $doc) {
				$n++;
				$file_url = env('HISTORICO_PDF_URL').$cliente.'/'.$id.'/'.$doc->gestion.'/'.$cuit.'_contraparte.pdf';
				($file_url);
				$file_exists = file_exists($file_url);
				$files[$ges->desde][$n]['url']  = $file_url;
				$files[$ges->desde][$n]['exists'] = $file_exists;

				echo('llegue al final del script');
			}
		}
		
	}


}