public function indexAction()
 {
     $this->assets->addCss('/jqwidgets/styles/jqx.base.css')->addCss('/jqwidgets/styles/jqx.custom.css')->addCss('/js/fileinput/css/fileinput.min.css');
     $this->assets->addJs('/jqwidgets/jqxcore.js')->addJs('/jqwidgets/jqxmenu.js')->addJs('/jqwidgets/jqxdropdownlist.js')->addJs('/jqwidgets/jqxlistbox.js')->addJs('/jqwidgets/jqxcheckbox.js')->addJs('/jqwidgets/jqxscrollbar.js')->addJs('/jqwidgets/jqxgrid.js')->addJs('/jqwidgets/jqxdata.js')->addJs('/jqwidgets/jqxgrid.sort.js')->addJs('/jqwidgets/jqxgrid.pager.js')->addJs('/jqwidgets/jqxgrid.filter.js')->addJs('/jqwidgets/jqxgrid.selection.js')->addJs('/jqwidgets/jqxgrid.grouping.js')->addJs('/jqwidgets/jqxgrid.columnsreorder.js')->addJs('/jqwidgets/jqxgrid.columnsresize.js')->addJs('/jqwidgets/jqxdatetimeinput.js')->addJs('/jqwidgets/jqxcalendar.js')->addJs('/jqwidgets/jqxbuttons.js')->addJs('/jqwidgets/jqxdata.export.js')->addJs('/jqwidgets/jqxgrid.export.js')->addJs('/jqwidgets/globalization/globalize.js')->addJs('/jqwidgets/jqxgrid.aggregates.js')->addJs('/media/plugins/bootbox/bootbox.min.js')->addJs('/media/plugins/form-validation/jquery.validate.min.js')->addJs('/media/plugins/form-stepy/jquery.stepy.js')->addJs('/media/demo/demo-formwizard.js')->addJs('/scripts/clientes/index.js')->addJs('/assets/js/plugins.js')->addJs('/assets/js/pages/formsValidation.js')->addJs('/js/fileinput/js/fileinput.min.js');
     $empresa = Empresas::findFirst(array('baja_logica=1'));
     $this->view->setVar('empresa', $empresa);
     //$model = usuarios::find(array('habilitado=1 and nivel=3',"order"=>"paterno ASC"));
     $model = new Usuarios();
     $resul = $model->responsablecomercial();
     $responsable = $this->tag->select(array('responsable_id', $resul, 'using' => array('id', 'nombres'), 'useEmpty' => true, 'emptyText' => '(Selecionar)', 'emptyValue' => '', 'class' => 'form-control', 'required' => 'required'));
     $this->view->setVar('responsable', $responsable);
 }
<div class="well well-lg col-md-6">
<h4>Planes Por Empresas</h4>
<?php 
use Carbon\Carbon;
$stocksTable = Lava::DataTable();
$empresas = Empresas::all()->toArray();
$stocksTable->addStringColumn('Empresa')->addNumberColumn('Cantidad');
foreach ($empresas as $key => $empresa) {
    $rowData = array($empresa["nombre"], App\Planes::where("empresa_id", "=", $empresa["id"])->count());
    $stocksTable->addRow($rowData);
}
$lineChart = Lava::PieChart('Stocks')->setOptions(array('datatable' => $stocksTable));
echo Lava::render('PieChart', 'Stocks', 'stocks-div', true);
?>
	
</div>
Example #3
0
 function Load_Empresas()
 {
     $E = new Empresas();
     return $E->Load_empresas();
 }