KOKINIO - MANAGER
Edit File: Clientes.php
<?php namespace Trash; use Illuminate\Database\Eloquent\Model; use Illuminate\Foundation\Auth\User as Authenticatable; class Clientes extends Authenticatable { // protected $table = 'cliente'; //public $timestamps = false; public function getClientes(){ $sql = "SELECT c.id,c.cliente,c.nombre_comercial,c.latitude, c.longitude, c.alta, c.baja, c.semades, c.giro_id, c.contacto_factura, c.email_factura, c.contacto_cobranza, c.email_cobranza, c.rfc, c.direccion, c.telefono, c.municipio, c.colonia, c.cp, c.inorganicos, c.organicos, c.sanitarios, c.factura_entrega, c.modo_pago, c.cuenta_bancaria, c.cuota_id, c.unidad_id, c.fiscal, c.pu, c.ret, c.observaciones, c.ultima_facturada, c.status_id, c.created_at, c.updated_at, c.user_created, g.giro, u.unidad FROM cliente c JOIN giro_empresa g ON g.id = c.giro_id JOIN unidad u ON u.id = c.unidad_id ORDER BY c.semades"; $data = \DB::select(\DB::raw($sql)); if(count($data)!=null){ return $data; }else{ return null; } } public function getCliente_route(){ $sql = "SELECT c.id,c.cliente,c.nombre_comercial,c.latitude, c.longitude, c.alta, c.baja, c.semades, c.giro_id, c.contacto_factura, c.email_factura, c.contacto_cobranza, c.email_cobranza, c.rfc, c.direccion, c.telefono, c.municipio, c.colonia, c.cp, c.inorganicos, c.organicos, c.sanitarios, c.factura_entrega, c.modo_pago, c.cuenta_bancaria, c.cuota_id, c.unidad_id, c.fiscal, c.pu, c.ret, c.observaciones, c.ultima_facturada, c.status_id, c.created_at, c.updated_at, c.user_created, g.giro, u.unidad FROM cliente c JOIN giro_empresa g ON g.id = c.giro_id JOIN unidad u ON u.id = c.unidad_id ORDER BY c.nombre_comercial"; $data = \DB::select(\DB::raw($sql)); if(count($data)!=null){ return $data; }else{ return null; } } public function getCliente($id){ $sql = "SELECT c.id,c.cliente,c.nombre_comercial,c.latitude, c.longitude, c.alta, c.baja, c.semades, c.giro_id, c.contacto_factura, c.email_factura, c.contacto_cobranza, c.email_cobranza, c.rfc, c.direccion, c.telefono, c.municipio, c.colonia, c.cp, c.inorganicos, c.organicos, c.sanitarios, c.factura_entrega, c.modo_pago, c.cuenta_bancaria, c.cuota_id, c.unidad_id, c.fiscal, c.pu, c.ret, c.observaciones, c.ultima_facturada, c.status_id, c.created_at, c.updated_at, c.user_created, g.giro, u.unidad, cu.cuota, p.peso, p.mes_id, c.ruta_id, c.status_id FROM cliente c JOIN giro_empresa g ON g.id = c.giro_id JOIN unidad u ON u.id = c.unidad_id JOIN cuota cu ON cu.id = c.cuota_id LEFT JOIN peso_cliente p ON p.cliente_id = c.id WHERE c.id=$id ORDER BY c.nombre_comercial"; $data = \DB::select(\DB::raw($sql)); if(count($data)!=null){ return response()->json(array('status'=>true, 'data'=>$data)); }else{ return response()->json(array('status'=>false)); } } public function clientesNear($latitude, $longitude){ $sql = "SELECT c.id, c.nombre_comercial, (6371 * ACOS( SIN(RADIANS(c.latitude)) * SIN(RADIANS($latitude)) + COS(RADIANS(c.longitude - $longitude)) * COS(RADIANS(c.latitude)) * COS(RADIANS($latitude)) ) ) AS distance FROM cliente c WHERE status_id = 1 HAVING distance < 1 /* 1 KM a la redonda */ ORDER BY nombre_comercial "; $cliente = \DB::select(\DB::raw($sql)); if(count($cliente)!=null){ return response()->json(array('status'=>true, 'data'=>$cliente)); }else{ return response()->json(array('status'=>false)); } } }