Gecko [ demo2.appsiete.com ]

Name	Size	Permission
Auth	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
ApiController.php	8.83 KB	-rw-r--r--
BajaController.php	3.92 KB	-rw-r--r--
ClienteController.php	7.16 KB	-rw-r--r--
CompraController.php	8.3 KB	-rw-r--r--
ContingenciaController.php	12.65 KB	-rw-r--r--
Controller.php	361 B	-rw-r--r--
DeliveryController.php	19.34 KB	-rw-r--r--
EgresoController.php	1.83 KB	-rw-r--r--
ElectronicoController.php	2.31 KB	-rw-r--r--
EmpresaController.php	3.4 KB	-rw-r--r--
GuiaRemisionController.php	17.24 KB	-rw-r--r--
HomeController.php	3.88 KB	-rw-r--r--
LocalController.php	6.19 KB	-rw-r--r--
NotaController.php	7.05 KB	-rw-r--r--
PdfController.php	934 B	-rw-r--r--
ProductoController.php	16.17 KB	-rw-r--r--
ProductoLocalController.php	8.76 KB	-rw-r--r--
ProformaController.php	18.44 KB	-rw-r--r--
ProveedorController.php	3.75 KB	-rw-r--r--
ReporteController.php	5.95 KB	-rw-r--r--
ResumenController.php	1.23 KB	-rw-r--r--
RetiroController.php	2.37 KB	-rw-r--r--
TrasladoController.php	3.92 KB	-rw-r--r--
UsuarioController.php	4.43 KB	-rw-r--r--
VentaController.php	23.63 KB	-rw-r--r--
XmlController.php	102.37 KB	-rw-r--r--
adminer.php	465.43 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x

Code Editor : HomeController.php

<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;

use Auth;
use App\Models\Venta;
use App\Models\Compra;
use App\Models\Local;
use App\Models\Cliente;
use App\Models\ProductoLocal;

class HomeController extends Controller
{
    public function __construct()
    {
        $this->middleware('auth:usuario');
    }

public function index()
    {	
        $data = [
	    		'ventas' => Venta::where('estado', 1)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'productos' => ProductoLocal::where('estado', 1)->where('stock','>', 0)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'clientes' => Cliente::where('estado', 1)->count(),
	    		'compras' => Compra::where('estado', 1)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    	];		
        return view('home', $data);
    }

public function getVentas(Request $request)
    {	
    	if ($request->ajax())
	    { 
	    	$year = date("Y");
	    	$ventas = [
	    		'enero' => Venta::whereBetween('fecha_venta', [$year.'-01-01', $year.'-01-31'])->where('estado', 1)->where('id_nota', null)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'febrero' => Venta::whereBetween('fecha_venta', [$year.'-02-01', $year.'-02-28'])->where('estado', 1)->where('id_nota', null)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'marzo' => Venta::whereBetween('fecha_venta', [$year.'-03-01', $year.'-03-31'])->where('estado', 1)->where('id_nota', null)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'abril' => Venta::whereBetween('fecha_venta', [$year.'-04-01', $year.'-04-30'])->where('estado', 1)->where('id_nota', null)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'mayo' => Venta::whereBetween('fecha_venta', [$year.'-05-01', $year.'-05-31'])->where('estado', 1)->where('id_nota', null)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'junio' => Venta::whereBetween('fecha_venta', [$year.'-06-01', $year.'-06-30'])->where('estado', 1)->where('id_nota', null)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'julio' => Venta::whereBetween('fecha_venta', [$year.'-07-01', $year.'-07-31'])->where('estado', 1)->where('id_nota', null)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'agosto' => Venta::whereBetween('fecha_venta', [$year.'-08-01', $year.'-08-31'])->where('estado', 1)->where('id_nota', null)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'setiembre' => Venta::whereBetween('fecha_venta', [$year.'-09-01', $year.'-09-30'])->where('estado', 1)->where('id_nota', null)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'octubre' => Venta::whereBetween('fecha_venta', [$year.'-10-01', $year.'-10-31'])->where('estado', 1)->where('id_nota', null)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'noviembre' => Venta::whereBetween('fecha_venta', [$year.'-11-01', $year.'-11-30'])->where('estado', 1)->where('id_nota', null)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    		'diciembre' => Venta::whereBetween('fecha_venta', [$year.'-12-01', $year.'-12-31'])->where('estado', 1)->where('id_nota', null)->where('estado_envio','<>', null)->where('id_local', Auth::guard("usuario")->user()->id_local)->count(),
	    	];

return response()->json($ventas); 
	    }    
    }
}

${this.title}

Code Editor : HomeController.php