I need help, what happens is that I'm making a graph by means of highcharts in laravel but I do not have the slightest idea of how I get an amount, it turns out that the graph I'm doing is to obtain which farm had the most amount of pigs started, but I do not know how to get it monthly, so I need your help, here I will leave the html, js and php
function cambiar_fecha_grafica(){
var anio_sel=$("#anio_sel").val();
var mes_sel=$("#mes_sel").val();
cargar_grafica_barras(anio_sel,mes_sel);
cargar_grafica_lineas(anio_sel,mes_sel);
}
function cargar_grafica_barras(anio,mes){
var options={
chart: {
renderTo: 'div_grafica_barras',
type: 'column'
},
title: {
text: 'Numero de Registros en el Mes'
},
subtitle: {
text: 'Source: plusis.net'
},
xAxis: {
categories: [],
title: {
text: 'dias del mes'
},
crosshair: true
},
yAxis: {
min: 0,
title: {
text: 'REGISTROS AL DIA'
}
},
tooltip: {
headerFormat: '<span style="font-size:10px">{point.key}</span><table>',
pointFormat: '<tr><td style="color:{series.color};padding:0">{series.name}: </td>' +
'<td style="padding:0"><b>{point.y} </b></td></tr>',
footerFormat: '</table>',
shared: true,
useHTML: true
},
plotOptions: {
column: {
pointPadding: 0.2,
borderWidth: 0
}
},
series: [{
name: 'registros',
data: []
}]
}
$("#div_grafica_barras").html( $("#cargador_empresa").html() );
var url = "grafica_registros/"+anio+"/"+mes+"";
$.get(url,function(resul){
var datos= jQuery.parseJSON(resul);
var totaldias=datos.totaldias;
var registrosdia=datos.registrosdia;
var i=0;
for(i=1;i<=totaldias;i++){
options.series[0].data.push( registrosdia[i] );
options.xAxis.categories.push(i);
}
chart = new Highcharts.Chart(options);
});
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Http\Requests;
use App\Http\Requests;
use App\Http\Precebo
use DB;
use App\Http\Granja;
use App\Http\AsociacionGranja;
class GraficasPrecebosController extends Controller
{
public function index(){
$anio = date('y');
$mes = date('m');
return view('admin.precebo.graficas_precebo')->with("anios" ,$anio)->with('mes',$mes);
}
public function getUultimoMes($elanio,$elmes){
return date("d",(mktime(0,0,0,$elmes+1,1,$elanio)-1));
}
public function Registro_mes($anio,$mes){
$primer_dia=1;
$ultimo_dia=$this->getUultimoMes($anio,$mes);
$precebos = Precebo::all();
$cont = count($precebos);
for ($i=0; $i < $ultimo_dia ; $i++) {
$registros[$d]=0;
}
foreach ($precebos as $precebo) {
if ($precebo->numero_inicial > ) {
}
}
$data = array("total_dias"=>$ultimo_dia,"registro_dia"=>$registros);
return json_encode($data)
}
}
@extends('template.plantilla')
@section('content')
<?php $nombre_mes = array("","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE") ?>
<div class="row">
<div class="col-xs-12 col-md-6 col-lg-6">
<label>Año</label>
<select name="" id="anio_sel" class="form-control" onchange="cambiar_fecha_grafica()">
<?php echo '<option value="'.$anio.'">'.$anio.'</option>' ; ?>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
</select>
</div>
<div class="col-xs-12 col-md-6 col-lg-6">
<label for="">Mes</label>
<select class="form-control" id="mes_sel" onchange="cambiar_fecha_grafica();" >
<?php echo '<option value="'.$mes.'" >'.$nombremes[intval($mes)].'</option>'; ?>
<option value="1">ENERO</option>
<option value="2">FEBRERO</option>
<option value="3">MARZO</option>
<option value="4">ABRIL</option>
<option value="5">MAYO</option>
<option value="6">JUNIO</option>
<option value="7">JULIO</option>
<option value="8">AGOSTO</option>
<option value="9">SEPTIEMBRE</option>
<option value="10">OCTUBRE</option>
<option value="11">NOVIEMBRE</option>
<option value="12">DICIEMBRE</option>
</select>
</div>
</div>
<div class="row" >
<br/>
<div class="box box-primary">
<div class="box-header">
</div>
<div class="box-body" id="div_grafica_barras">
</div>
<div class="box-footer">
</div>
</div>
<br/>
<div class="box box-primary">
<div class="box-header">
</div>
<div class="box-body" id="div_grafica_lineas">
</div>
<div class="box-footer">
</div>
</div>
<br/>
<div class="box box-primary">
<div class="box-header">
</div>
<div class="box-body" id="div_grafica_pie">
</div>
<div class="box-footer">
</div>
</div>
</div>
<script>
cargar_grafica_barras(<?= $anio; ?>,<?= intval($mes); ?>);
</script>
@endsection