KOKINIO - MANAGER

Edit File: UserCliente.php

<?php namespace Trash; use Illuminate\Database\Eloquent\Model; class UserCliente extends Model { // protected $table = "user_cliente"; public $timestamps = false; public function ClienteUser($user_id,$cliente_id){ $sql = "SELECT uc.id, uc.user_id, uc.cliente_id, c.nombre_comercial FROM user_cliente uc JOIN cliente c ON c.id = uc.cliente_id AND c.status_id = 1 AND uc.cliente_id = $cliente_id WHERE uc.user_id = $user_id AND uc.status_id = 1"; $data = \DB::select( \DB::raw( $sql ) ); if(count($data) != null) return $data; return null; } }