/home/dvjjulio/softtrash/app/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;
}
}