@extends('fragments.fullTemplate') @php $id_usuario = session('id_usuario'); if (! session('id_usuario')) { header('location: /'); die(); } @endphp @section('contenido')
@if(session()->has('success')) @endif @if(session()->has('warning')) @endif @if(session()->has('error')) @endif @if (count($errors) > 0) @endif
@include('Requisicion_compra.Notificacion.notificacion_requisicion_modal') @include('Control_documentos.Notificacion.notificacion_documento_version') {{--
--}} @if ($permisos->crear == 1) @endif
Portal de clientes internacionales

{{ $solicitudes_usuarios->count() }} resultados en esta página

@if($solicitudes_usuarios->count()) @php $i=1; @endphp @foreach ($solicitudes_usuarios as $solicitud) @php $fecha = date("d-m-Y",strtotime($solicitud->fecha)); $datos_cliente_informe = datos_cliente_informe($solicitud->id_customer_report); if (!isset($datos_cliente_informe->id_customer_report)){ continue; } $datos_cliente_factura = datos_cliente_factura($solicitud->id_customer_invoice,$datos_cliente_informe->id_customer_report); $datos_cliente_contacto_factura = datos_cliente_contacto_factura($solicitud->id_customer_contact_invoice); @endphp {{-- {{$solicitud->folio}} --}} @php $i++; @endphp @endforeach @else @endif

{{ $clientes_facturas->count() }} resultados en esta página

@if($clientes_facturas->count()) @foreach ($clientes_facturas as $cliente_factura) @php $datos_contacto = datos_contacto_cliente_factura($cliente_factura->id_cliente_factura); $estatus = datos_usuario_cliente_factura($cliente_factura->id_cliente_factura); @endphp {{--@if ($datos_contacto->count())--}} {{--@endif--}} @endforeach @else @endif
@php use App\Customer_Report; use App\Customer_Invoice; use App\Customer_Contact_Invoice; use App\Portal_User; function datos_cliente_informe($id_customer_report){ $datos_cliente_informe = Customer_Report::select('id_customer_report','company_name')->where('id_customer_report',$id_customer_report)->first(); return $datos_cliente_informe; } function datos_cliente_factura($id_customer_invoice,$id_customer_report){ $datos_cliente_factura = Customer_Invoice::select('id_customer_invoice','company_name')->where('id_customer_invoice',$id_customer_invoice)->first(); if ($datos_cliente_factura == null) { $datos_cliente_factura = Customer_Invoice::select('customer_invoices.id_customer_invoice','customer_invoices.company_name') ->join('customer_invoice_x_customer_reports', 'cliente_invoices.id_customer_invoice', '=', 'customer_invoice_x_customer_reports.id_customer_invoice') ->where('customer_invoice_x_customer_reports.id_customer_report',$id_customer_report) ->first(); } return $datos_cliente_factura; } function datos_cliente_contacto_factura($id_customer_contact_invoice){ $datos_cliente_contacto_factura = Customer_Contact_Invoice::select('id_customer_contact_invoice','name')->where('id_customer_contact_invoice',$id_customer_contact_invoice)->first(); return $datos_cliente_contacto_factura; } function datos_contacto_cliente_factura($id_customer_invoice){ $datos_contacto = Customer_Contact_Invoice::select( 'name as nombre_contacto', 'cellphone as telefono' ) ->leftjoin('portal_user_requests', 'customer_contact_invoices.id_customer_contact_invoice', '=', 'portal_user_requests.id_customer_contact_invoice') ->where(function($q){ $q->where('portal_user_requests.status', 1); //->orWhere('customer_contact_invoices.portal_request', 0); }) ->where('id_customer_invoice',$id_customer_invoice) ->get(); return $datos_contacto; } function datos_usuario_cliente_factura($id_cliente_factura){ $datos_usuario_cliente_factura = Portal_User::select( 'user as usuario', 'password as contrasena', 'status as estatus' ) ->where('id_customer_invoice',$id_cliente_factura) ->first(); $estatus = 0; if ($datos_usuario_cliente_factura != null) { $estatus = $datos_usuario_cliente_factura->estatus; } return $estatus; } @endphp @include('International_Customer_Portal.Solicitudes_clientes.edit_portal_solicitud_cliente_modal') @include('International_Customer_Portal.Solicitudes_clientes.send_email_portal_solicitud_cliente') @include('International_Customer_Portal.Solicitudes_clientes.delete_portal_solicitud') @include('International_Customer_Portal.Solicitudes_clientes.send_email_cliente_factura') @include('International_Customer_Portal.Solicitudes_clientes.modal_datos_portal_usuario') @endsection