src/Controller/DefaultController.php line 38

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\Routing\Annotation\Route;
  7. use Symfony\Component\HttpFoundation\Request;
  8. use Knp\Component\Pager\PaginatorInterface;
  9. use Knp\Snappy\GeneratorInterface;
  10. use Knp\Bundle\SnappyBundle\Snappy\Response\PdfResponse;
  11. use Symfony\Component\HttpFoundation\Response;
  12. use Symfony\Component\HttpFoundation\JsonResponse;
  13. use Knp\Snappy\Pdf;
  14. use App\Entity\Meeting;
  15. use Symfony\Component\Serializer\Encoder\CsvEncoder;
  16. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  17. use Symfony\Component\Serializer\Serializer;
  18. use Symfony\Component\Serializer\SerializerInterface;
  19. use Symfony\Component\Serializer\Normalizer\DateTimeNormalizer;
  20. use Doctrine\Persistence\ManagerRegistry;
  21. use Qipsius\TCPDFBundle\Controller\TCPDFController;
  23. use App\Entity\Joiner;
  25. class DefaultController extends AbstractController
  26. {
  27. protected $managerRegistry;
  28. protected $tcpdf;
  31. public function __construct(ManagerRegistry $managerRegistry, TCPDFController $tcpdf) {
  32. $this->managerRegistry = $managerRegistry;
  33. $this->tcpdf = $tcpdf;
  34. }
  35. /**
  36. * @Route("/default", name="default")
  37. */
  38. public function index(PaginatorInterface $paginator, Request $request)
  39. {
  41. $start = $request->query->get('dateStart');
  42. $end = $request->query->get('dateEnd');
  43. $filterField = $request->query->get('filterField');
  44. $filterValue = $request->query->get('filterValue');
  45. $em = $this->managerRegistry->getManager();
  47. if((!is_null($start) && !is_null($end)) && ($start <= $end)) {
  48. $meetings = $em->getRepository('App\Entity\Meeting')->filterByDate(
  49. new \DateTime($start.' 00:00:00'),
  50. new \DateTime($end.' 23:59:59'),
  51. // is_null($request->query->get('filterValue'))?FALSE:TRUE,
  52. FALSE,
  53. [$filterField => $filterValue]
  54. );
  55. } else {
  56. $meetings = $em->getRepository('App\Entity\Meeting')->findBy([],array(
  57. 'start' => 'DESC'
  58. ));
  59. }
  61. $meetingsPage = $paginator->paginate(
  62. $meetings,
  63. $request->query->getInt('page',1) /*page number*/,
  64. $request->query->getInt('limit',10) /*limit per page*/
  65. );
  67. return $this->render('default/index.html.twig', [
  68. 'meetings' => $meetingsPage,
  69. 'dateStart' => $request->query->get('dateStart'),
  70. 'dateEnd' => $request->query->get('dateEnd')
  71. ]);
  72. }
  74. public function print (Request $request, Pdf $pdf) {
  76. $em = $this->managerRegistry->getManager();
  78. $start = $request->request->get('dateStart');
  79. $end = $request->request->get('dateEnd');
  81. $filterField = $request->request->get('filterField');
  82. $filterValue = $request->request->get('filterValue');
  84. // dd($request->request->get('filterField'));
  86. if((!empty($start) && !empty($end)) AND ($start <= $end)) {
  87. $meetings = $em->getRepository('App\Entity\Meeting')->filterByDate(
  88. new \DateTime($start.' 00:00:00'),
  89. new \DateTime($end.' 23:59:59'),
  90. FALSE,
  91. [$filterField => $filterValue]
  92. );
  93. } else {
  94. $meetings = $em->getRepository('App\Entity\Meeting')->findAll();
  95. }
  96. $html = $this->renderView(
  97. 'default/print.html.twig',
  98. array(
  99. 'meetings' => $meetings
  100. )
  101. );
  103. return new PdfResponse(
  104. $pdf->getOutputFromHtml($html),
  105. 'file.pdf'
  106. );
  107. }
  109. /**
  110. * @Route("/export/{filename}", name="export_users")
  111. */
  112. public function userExport(string $filename)
  113. {
  114. $em = $this->managerRegistry->getManager();
  115. $meeting = $em->getRepository('App\Entity\Meeting')->findOneBy(['filename'=>$filename]);
  116. $joiners = $em->getRepository('App\Entity\Joiner')->findBy(['meeting'=>$meeting]);
  118. $encoders = [new CsvEncoder()];
  119. $normalizers = [new DateTimeNormalizer(['datetime_format'=>'H:i:s','datetime_timezone'=>'Europe/Paris']), new ObjectNormalizer()];
  120. $serializer = new Serializer($normalizers, $encoders);
  122. $csvContent = implode(';',[
  123. $meeting->getName(),
  124. $meeting->getStart()->format('d-m-Y')
  125. ]
  127. ).chr(10);
  129. $csvContent .= $serializer->serialize($joiners, 'csv', [
  130. 'csv_delimiter'=>';',
  131. 'attributes' => ['name','role','jointime','lefttime'],
  132. // 'circular_reference_handler' => function ($object) {
  133. // return $object->getId();
  134. // }
  135. ]);
  137. $response = new Response($csvContent);
  138. $response->headers->set('Content-Encoding', 'UTF-8');
  139. $response->headers->set('Content-Type', 'text/csv; charset=UTF-8');
  140. $response->headers->set('Content-Disposition', 'attachment; filename=participants.csv');
  142. return $response;
  143. }
  145. /**
  146. * @Route("/presences", name="presences")
  147. */
  149. function getPresences(){
  151. $em = $this->managerRegistry->getManager();
  152. $joiners = $em->getRepository('App\Entity\Joiner')->getListJoiners();
  153. return $this->render('default/presences.html.twig',
  154. [
  155. 'joiners'=>$joiners
  156. ]);
  157. }
  160. /**
  161. * @Route("/printpresences", name="printpresences", options={"expose"=true}, methods={"POST"})
  162. * @param Request $request
  163. */
  165. public function printPresenceJoiners(Request $request) : Response {
  167. if (!$this->getUser()) {
  168. return $this->redirectToRoute('default');
  169. }
  171. $joiners = $request->request->get('joiners');
  173. $dateStart = date_create($request->request->get('start'))->setTime(00, 00, 00);
  174. $dateEnd = date_create($request->request->get('end'))->setTime(23, 59, 59);
  176. $em = $this->managerRegistry->getManager();
  178. $filename = $this->genPDFJoiners($joiners, $dateStart, $dateEnd);
  180. $responce = new Response();
  181. $responce->setContent($filename);
  182. return $responce;
  183. }
  185. private function genPDFJoiners($joiners, $dateStart, $dateEnd) {
  187. $em = $this->managerRegistry->getManager();
  189. $pdf = $this->tcpdf->create('vertical', PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
  190. // $pdf->SetAuthor($this->getParameter('plateforme_name'));
  191. $pdf->SetTitle(('Feuille de présences par participant '));
  192. $pdf->SetSubject('Présences individuelles');
  193. $pdf->setFontSubsetting(true);
  194. $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
  195. $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
  196. $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
  198. $upload = $this->getParameter('kernel.project_dir').'/public/uploads';
  200. $pdf->SetHeaderData('',
  201. 10,
  202. 'bbb-analytics'
  203. );
  205. $pdf->setFooterData(array(0,64,0), array(0,64,128));
  206. $pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
  208. $pdf->SetFont('helvetica', '', 11, '', true);
  209. $filename = 'Feuille_presences_eleves-'. uniqid().'.pdf';
  211. $presencesJoiners = $em->getRepository('App\Entity\Joiner')->getPresencesByJoiner($joiners, $dateStart, $dateEnd);
  213. $activeJoiner = "";
  215. foreach($presencesJoiners as $presence) {
  217. if(empty($activeJoiner) || $activeJoiner != $presence->getExternalId() ) {
  218. if(!empty($activeJoiner)) {
  219. $pdf->writeHTMLCell($w = 150, 0, '', '', 'Total heures ', 1, 0, 0, true, 'R', true);
  220. $pdf->writeHTMLCell($w = 40, 0, 160, '', $totalHeuresOri->diff($totalHeures)->h + ($totalHeuresOri->diff($totalHeures)->days * 24).'H '. $totalHeuresOri->diff($totalHeures)->i, 1, 1, 0, true, 'C', true);
  221. }
  222. $activeJoiner = $presence->getExternalId();
  223. $totalHeuresOri = new \DateTime('00:00');
  224. $totalHeures = clone $totalHeuresOri;
  225. $pdf->AddPage();
  226. }
  228. if(($pdf->getY() <= 11)||($pdf->getY() >= 267)){
  229. $pdf->writeHTMLCell(0, 0, '', '', $presence->getName(), 1, 1,0, true, 'C', true);
  230. $pdf->writeHTMLCell($w = 30, 0, '', '', 'Date', 1, 0, 0, true, '', true);
  231. $pdf->writeHTMLCell($w = 120, 0,40, '', 'Formation', 1, 0, 0, true, '', true);
  232. $pdf->writeHTMLCell($w = 20, 0, 160, '', 'Arrivée', 1, 0, 0, true, 'C', true);
  233. $pdf->writeHTMLCell($w = 20, 0, 180, '', 'Départ', 1, 1, 0, true, 'C', true);
  234. }
  236. if(is_null($presence->getJoinTime())) {
  237. $dateD = 'ABS';
  238. $dateF = 'ABS';
  239. } else {
  240. $dateD = $presence->getJoinTime()->format('H:i');
  241. if(is_null($presence->getLeftTime())) {
  242. $dateF = "####-##-##";
  243. } else {
  244. $dateF = $presence->getLeftTime()->format('H:i');
  245. $totalHeures->add(date_diff($presence->getJoinTime(), $presence->getLeftTime()));
  246. }
  247. }
  248. // Rajouter la date sur chaque ligne
  249. // $w, $h, $txt, $border=0, $align='J', $fill=false, $ln=1, $x='', $y='', $reseth=true, $stretch=0, $ishtml=false, $autopadding=true, $maxh=0, $valign='T', $fitcell=false
  250. $coursName = $presence->getMeeting()->getName();
  252. if(strlen($coursName) > 50) {
  253. $coursName = substr($coursName, 0,50).' ...';
  254. }
  256. $pdf->writeHTMLCell($w = 30, 0, '', '', $presence->getMeeting()->getStart()->format('d/m/Y'), 1, 0, 0, true, '', true);
  257. $pdf->writeHTMLCell($w = 120, 0,40, '', $coursName, 1, 0, 0, true, '', true);
  258. $pdf->writeHTMLCell($w = 20, 0, 160, '', $dateD, 1, 0, 0, true, 'C', true);
  259. $pdf->writeHTMLCell($w = 20, 0, 180, '', $dateF, 1, 1, 0, true, 'C', true);
  260. }
  262. $pdf->writeHTMLCell($w = 150, 0, '', '', 'Total heures ', 1, 0, 0, true, 'R', true);
  263. $pdf->writeHTMLCell($w = 40, 0, 160, '', $totalHeuresOri->diff($totalHeures)->h + ($totalHeuresOri->diff($totalHeures)->days * 24).'H '. $totalHeuresOri->diff($totalHeures)->i, 1, 1, 0, true, 'C', true);
  265. // }
  267. // }
  269. $pdf->Output( $upload.'/'.$filename,'F'); // This will output the PDF as a response direc
  270. return $filename;
  271. }
  273. #[Route('/api/presences/date/{date}', name:'api_date_presences', methods:['GET'])]
  274. public function getPresencesDateApi($date, SerializerInterface $serializer): JsonResponse {
  275. $em = $this->managerRegistry->getManager();
  276. $dateStart = date_create($date)->setTime(00, 00, 00);
  277. $dateEnd = date_create($date)->setTime(23, 59, 59);
  279. $result = [];
  281. $meetings = $em->getRepository(Meeting::class)->filterByDate($dateStart,$dateEnd);
  283. foreach ($meetings as $meeting) {
  284. $id = $meeting->getId();
  285. $result[$id]['externalid'] = $meeting->getExternalid();
  286. $result[$id]['name'] = $meeting->getName();
  287. $result[$id]['start'] = $meeting->getStart();
  288. $result[$id]['end'] = $meeting->getStart();
  289. $result[$id]['presences'] = $em->getRepository(Joiner::class)->getPresencesByMeetingApi($id);
  291. }
  293. return new JsonResponse([
  294. 'meetings' => $result,
  295. Response::HTTP_OK,
  296. ['accept' => 'json'],
  297. true
  298. ]);
  299. }
  301. #[Route('/api/presences/meeting/{meetingid}', name:'api_date_presences', methods:['GET'])]
  302. public function getPresencesMeetingApi($meetingid, SerializerInterface $serializer): JsonResponse {
  303. $em = $this->managerRegistry->getManager();
  305. $result = [];
  307. $meeting = $em->getRepository(Meeting::class)->findOneBy([
  308. 'externalid'=>$meetingid
  309. //ou utiliser le filename en fonction de ce qu'ils ont dans moodle
  310. ]) ;
  312. foreach ($meetings as $meeting) {
  313. $id = $meeting->getId();
  314. $result[$id]['externalid'] = $meeting->getExternalid();
  315. $result[$id]['name'] = $meeting->getName();
  316. $result[$id]['meetingid'] = $meeting->getFilename();
  317. $result[$id]['start'] = $meeting->getStart();
  318. $result[$id]['end'] = $meeting->getStart();
  319. $result[$id]['presences'] = $em->getRepository(Joiner::class)->getPresencesByMeetingApi($id);
  321. }
  323. return new JsonResponse([
  324. 'meetings' => $result,
  325. Response::HTTP_OK,
  326. ['accept' => 'json'],
  327. true
  328. ]);
  329. }
  330. }