KOKINIO - MANAGER

Edit File: User.php

<?php

namespace Trash;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable
{
    //
    protected $table = 'user';
    protected $fillable = [
        'username', 'tipo_usuario_id', 'password',
    ];
    protected $hidden = array('password', 'remember_token');
   // public $timestamps = false;

public function tipo(){
    	return $this->belongsTo('Trash\Tipo','tipo_usuario_id');
    }

public function user_camion($id){
    	$sql = "SELECT u.id, u.username, c.id camion_id, c.placas
				FROM user u
				JOIN camion c ON u.id = c.user_id
				WHERE u.id=$id ";
		$data = \DB::select( \DB::raw( $sql ) );
		if(count($data) != null)
			return $data;
		return false;
    }

public function getUsers($id = null){
      $user = "";
      if($id != null){
        $user = "AND u.id = ".$id;
      }
    	$sql = "SELECT u.id, u.username,u.nombre, u.ape_pat,u.ape_mat, u.telefono, t.tipo, u.status_id
              FROM user u
              JOIN tipo_usuario t ON t.id = u.tipo_usuario_id
              WHERE u.status_id = 1 $user
              /*UNION
              SELECT c.id, c.username, c.nombre_comercial, 'NA' ape_pat, 'NA' ape_mat, c.telefono, t.tipo, c.status_id
              FROM cliente c
              JOIN tipo_usuario t ON t.id = c.tipo_usuario_id
              WHERE c.status_id = 1*/";
		$data = \DB::select( \DB::raw( $sql ) );
		if(count($data) != null)
			return $data;
		return null;
    }

public function userCliente($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
              WHERE uc.user_id = $id AND uc.status_id = 1";

$data = \DB::select( \DB::raw( $sql ) );
  		if(count($data) != null)
  			return $data;
  		return null;
    }
}