function dateShort() { $mes_actual = date("n"); $mes = periodSchool()->month; if ($mes != $mes_actual) { $year = periodSchool()->year; $dia = date("d", mktime(0, 0, 0, $mes + 1, 1, $year) - 1); return $salida = "{$year}/{$mes}/{$dia}"; } return date("Y/m/d"); }
public function index() { set_time_limit(0); $student = $this->studentRepository->whereId('school_id', userSchool()->id, 'sex'); $content = array(array(userSchool()->name), array('LISTA DE SALDOS DE ESTUDIANTES'), array('')); $countTotal = array(); $countGrado = array(); $countHeader = count($content); $school = $this->schoolsRepository->getModel()->find(userSchool()->id); foreach ($school->degrees as $degree) { $content[] = array('GRADO: ' . $degree->name); $countGrado[] = count($content); $content[] = array('CARNET', 'NOMBRE ALUMNO', 'SALDO'); $students = $this->financialRecordsRepository->whereId('year', periodSchool()->year, 'updated_at'); $total = 0; foreach ($students as $student) { if ($degree->id == $student->degreeDatos()->id) { $content[] = array($student->students->book, $student->students->nameComplete(), $student->balance); $total += $student->balance; } } $content[] = array('', 'TOTAL', $total); $countTotal[] = count($content); $content[] = array('', '', ''); } Excel::create(date('d-m-Y') . '- Todos los Grados', function ($excel) use($content, $countTotal, $countGrado) { $excel->sheet('Saldos de todos los Alumnos', function ($sheet) use($content, $countTotal, $countGrado) { $sheet->mergeCells('A1:C1'); $sheet->mergeCells('A2:C2'); $sheet->mergeCells('A3:C3'); foreach ($countGrado as $grado) { $sheet->mergeCells('A' . $grado . ':C' . $grado); $sheet->cells('A' . $grado . ':D' . $grado, function ($cells) { $cells->setFontSize(12); $cells->setFontWeight('bold'); $cells->setAlignment('center'); }); $grado = $grado + 1; $sheet->cells('A' . $grado . ':D' . $grado, function ($cells) { $cells->setFontSize(12); $cells->setFontWeight('bold'); $cells->setAlignment('center'); }); } foreach ($countTotal as $total) { $sheet->cells('A' . $total . ':D' . $total, function ($cells) { $cells->setFontSize(12); $cells->setFontWeight('bold'); $cells->setAlignment('center'); }); } $sheet->cell('A1', function ($cell) { $cell->setFontSize(16); $cell->setFontWeight('bold'); $cell->setAlignment('center'); }); $sheet->cell('A2', function ($cell) { $cell->setFontSize(16); $cell->setFontWeight('bold'); $cell->setAlignment('center'); }); $sheet->cell('A3', function ($cell) { $cell->setFontSize(16); $cell->setFontWeight('bold'); $cell->setAlignment('center'); }); $sheet->fromArray($content, null, 'A1', true, false); }); })->export('xlsx'); }