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