Show with a graphic in laravel

0

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
    
asked by Juan Esteban Yarce 15.02.2018 в 23:00
source

0 answers