public function run()
{
$faker = Faker::create();
foreach (range(1, 100) as $index) {
ReporteGerencial::create(['MESREGIST' => $faker->randomElement(static::$MESREGIST), 'D_REG' => $faker->randomElement($min = '1', $max = '30'), 'EQUIPO' => $faker->randomElement(static::$EQUIPO), 'CODOPERAC' => $faker->numberBetween($min = '1', $max = '2'), 'CODESTADO' => $faker->numberBetween($min = '0', $max = '3'), 'MESRESOL' => $faker->randomElement(static::$MESREGIST), 'D_RES' => $faker->numberBetween($min = '1', $max = '30')]);
}
}
public function TCAprobadas($MESREGIST, $id)
{
return ReporteGerencial::select('CANALVTA2', \DB::raw('count(idRG_TC_IT) as TCAPROBADAS'))->where('MESREGIST', '=', $MESREGIST)->groupBy('CANALVTA2')->get();
}