File: /var/www/dvpis2025/dvpis.kaunokolegija.lt/src/Controller/StudiesProgramPostFinanceController.php
<?php
namespace App\Controller;
use App\Entity\FinanceSource;
use App\Entity\StudiesProgram;
use Doctrine\DBAL\Exception;
use Doctrine\DBAL\Exception\UniqueConstraintViolationException;
use Doctrine\ORM\EntityManagerInterface;
use PhpOffice\PhpSpreadsheet\IOFactory;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Method;
use App\Entity\StudiesProgramPostFinance;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\Form\Form;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Component\HttpFoundation\Request;
use App\Service\FileUploader;
use Symfony\Component\Validator\Validator\ValidatorInterface;
/**
* Studiesprogrampostfinance controller.
*/
#[Route(path: 'studiesprogrampostfinance')]
class StudiesProgramPostFinanceController extends AbstractController
{
public function __construct(
private readonly EntityManagerInterface $em,
private readonly ValidatorInterface $validator,
) {
}
/**
* Lists all studiesProgramPostFinance entities.
*
* @Method("GET")
*/
#[Route(path: '/', name: 'studiesprogrampostfinance_index')]
public function indexAction()
{
$studiesProgramPostFinances = $this->em->getRepository(StudiesProgramPostFinance::class)->findAll();
return $this->render('studiesprogrampostfinance/index.html.twig', array(
'studiesProgramPostFinances' => $studiesProgramPostFinances,
));
}
/**
* Creates a new studiesProgramPostFinance entity.
*
* @Method({"GET", "POST"})
*/
#[Route(path: '/new', name: 'studiesprogrampostfinance_new')]
public function newAction(Request $request)
{
$studiesProgramPostFinance = new Studiesprogrampostfinance();
$form = $this->createForm('App\Form\StudiesProgramPostFinanceType', $studiesProgramPostFinance);
$form->handleRequest($request);
if ($form->isSubmitted() && $form->isValid()) {
$this->em->persist($studiesProgramPostFinance);
$this->em->flush();
return $this->redirectToRoute('studiesprogrampostfinance_index', array('id' => $studiesProgramPostFinance->getId()));
}
return $this->render('studiesprogrampostfinance/new.html.twig', array(
'studiesProgramPostFinance' => $studiesProgramPostFinance,
'form' => $form->createView(),
));
}
/**
* Displays a form to edit an existing studiesProgramPostFinance entity.
*
* @Method({"GET", "POST"})
*/
#[Route(path: '/{id}/edit', name: 'studiesprogrampostfinance_edit')]
public function editAction(Request $request, StudiesProgramPostFinance $studiesProgramPostFinance)
{
$deleteForm = $this->createDeleteForm($studiesProgramPostFinance);
$editForm = $this->createForm('App\Form\StudiesProgramPostFinanceType', $studiesProgramPostFinance);
$editForm->handleRequest($request);
if ($editForm->isSubmitted() && $editForm->isValid()) {
$this->em->flush();
return $this->redirectToRoute('studiesprogrampostfinance_edit', array('id' => $studiesProgramPostFinance->getId()));
}
return $this->render('studiesprogrampostfinance/edit.html.twig', array(
'studiesProgramPostFinance' => $studiesProgramPostFinance,
'edit_form' => $editForm->createView(),
'delete_form' => $deleteForm->createView(),
));
}
/**
* Deletes a studiesProgramPostFinance entity.
*
* @Method("DELETE")
*/
#[Route(path: '/{id}', requirements: ['id' => '\d+'], name: 'studiesprogrampostfinance_delete')]
public function deleteAction(Request $request, StudiesProgramPostFinance $studiesProgramPostFinance)
{
$form = $this->createDeleteForm($studiesProgramPostFinance);
$form->handleRequest($request);
if ($form->isSubmitted() && $form->isValid()) {
$this->em->remove($studiesProgramPostFinance);
try {
$this->em->flush();
} catch (Exception $ex) {
$this->addFlash('warning', "Ištrinti įrašo nepavyko! Jis gali turėti susijusių įrašų." . $ex->getMessage());
}
}
return $this->redirectToRoute('studiesprogrampostfinance_index');
}
/**
* Creates a form to delete a studiesProgramPostFinance entity.
*
* @param StudiesProgramPostFinance $studiesProgramPostFinance The studiesProgramPostFinance entity
*
* @return Form The form
*/
private function createDeleteForm(StudiesProgramPostFinance $studiesProgramPostFinance)
{
return $this->createFormBuilder()
->setAction($this->generateUrl('studiesprogrampostfinance_delete', array('id' => $studiesProgramPostFinance->getId())))
->setMethod('DELETE')
->getForm()
;
}
/**
* imports studies programs from excel
*
* @Method({"GET","POST"})
*/
#[Route(path: '/import_view', name: 'studiesprogrampostfinance_import_view')]
public function showImportStudiesProgramPostFinanceAction(Request $request, FileUploader $fileUploader)
{
$file = $request->files->get('fileToUpload');
$uploadedFilePath = '';
$fileImportReturn = [];
if (!empty($file)) {
$uploadedFilePath = $fileUploader->getTargetDir() . DIRECTORY_SEPARATOR . $fileUploader->upload($file);
$fileImportReturn = $this->importData($uploadedFilePath);
unlink($uploadedFilePath);
}
return $this->render('studiesprogrampostfinance/import.html.twig', [
'uploadedFilePath' => $uploadedFilePath,
'importErrors' => $fileImportReturn,
]);
}
private function importData($filePath)
{
$studiesProgramPostFinances = $this->em->getRepository(StudiesProgramPostFinance::class)->getAllByHash();
$studiesProgram = $this->em->getRepository(StudiesProgram::class)->getAllByShortName();
$financeSource = $this->em->getRepository(FinanceSource::class)->getAllByShortName();
$objExcel = IOFactory::load($filePath);
$worksheet = $objExcel->setActiveSheetIndex(0);
$errors = [];
foreach ($worksheet->getRowIterator() as $row) {
$rowNumber = $row->getRowIndex();
//insert values
if ($row->getRowIndex() > 1) {
$cellIterator = $row->getCellIterator();
$cellIterator->setIterateOnlyExistingCells(false); // Loop all cells, even if it is not set
$excelStudiesProgram = $worksheet->getCell('A' . $row->getRowIndex())->getValue();
$excelCourse = $worksheet->getCell('B' . $row->getRowIndex())->getValue();
$excelIndex = md5($excelStudiesProgram . "_" . $excelCourse);
$studiesProgramPostFinance = $studiesProgramPostFinances[$excelIndex] ?? new StudiesProgramPostFinance();
foreach ($cellIterator as $cell) {
if (!is_null($cell)) {
$column = $cell->getColumn();
switch ($cell->getColumn()) {
case 'A':
$excelCode = trim($cell->getCalculatedValue());
if (!isset($studiesProgram[$excelCode])) {
$errors[] = $column . $rowNumber . ": Studijų Programa nerasta! (" . $excelCode . ")";
} else {
$studiesProgramPostFinance->setStudiesProgram($studiesProgram[$excelCode]);
}
break;
case 'B':
$excelCode = trim($cell->getCalculatedValue());
if (!isset($financeSource[$excelCode])) {
// throw new \Exception($excelCode . ": Studijų Programa nerasta!");
$errors[] = $column . $rowNumber . ": Finansavimo šaltinis Nerastas! (" . $excelCode . ")";
} else {
$studiesProgramPostFinance->setFinanceSource($financeSource[$excelCode]);
}
break;
case 'C':
$studiesProgramPostFinance->setPostCountNl($cell->getCalculatedValue());
break;
case 'D':
$studiesProgramPostFinance->setPostCountI($cell->getCalculatedValue());
break;
default:
break;
}
}
}
$valid = $this->validator->validate($studiesProgramPostFinance);
if (empty($errors)) {
if (empty($valid[0])) {
$this->em->persist($studiesProgramPostFinance);
} else {
$errors[] = $column . $rowNumber . ": " . $valid[0]->getMessage();
}
}
}
}
if (empty($errors)) {
try {
$this->em->flush();
} catch (UniqueConstraintViolationException $ex) {
// $this->addFlash("warning", "Faile yra vienodų naujų įrašų. Prašome patikrinti duomenis! Detaliau: ".$ex->getPrevious()->getMessage());
$errors[] = "Faile yra vienodų naujų įrašų. Prašome patikrinti duomenis! Detaliau: " . $ex->getPrevious()->getMessage();
}
}
return $errors;
}
}