literat / srazvs

app/presenters/ExportPresenter.php

<?php

namespace App\Presenters;

use App\Models\ExportModel;
use App\Models\ProgramModel;
use App\Models\BlockModel;
use App\Models\MealModel;
use App\Factories\ExcelFactory;
use App\Factories\PdfFactory;
use App\Components\RegistrationGraphControl;
use App\Components\MaterialsControl;
use App\Components\MealControl;
use Nette\Utils\Strings;
use Tracy\Debugger;
use Mpdf\Mpdf;

/**
 * Export Controller
 *
 * This file handles the retrieval and serving of exports
 */
class ExportPresenter extends BasePresenter
{

	const TEMPLATE_DIR = __DIR__ . '/../templates/Export/';
	const TEMPLATE_EXT = 'latte';

	/**
	 * @var ProgramModel
	 */
	protected $programModel;

	protected $blockModel;

	/**
	 * @var Mpdf\Mpdf
	 */
	protected $pdf;

	/**
	 * @var PHPExcel
	 */
	protected $excel;

	protected $filename;

	/**
	 * @var RegistrationGraphControl
	 */
	private $registrationGraphControl;

	/**
	 * @var MaterialsControl
	 */
	private $materialControl;

	/**
	 * @var MealControl
	 */
	private $mealControl;

	/**
	 * @param ExportModel              $export
	 * @param ProgramModel             $program
	 * @param ExcelFactory             $excel
	 * @param PdfFactory               $pdf
	 * @param RegistrationGraphControl $control
	 * @param MaterialsControl          $materialControl
	 */
	public function __construct(
		ExportModel $export,
		ProgramModel $program,
		BlockModel $block,
		ExcelFactory $excel,
		PdfFactory $pdf,
		RegistrationGraphControl $control,
		MaterialsControl $materialControl,
		MealControl $mealControl
	) {
		$this->setModel($export);

$export is of type object<App\Models\ExportModel>, but the function expects a object<App\Model>.

		$this->setProgramModel($program);
		$this->setBlockModel($block);
		$this->setExcel($excel->create());
		$this->setPdf($pdf->create());
		$this->setRegistrationGraphControl($control);
		$this->setMaterialControl($materialControl);
		$this->setMealControl($mealControl);
	}

	/**
	 * @return void
	 */
	public function startup()
	{
		parent::startup();

		$this->getProgramModel()->setMeetingId($this->getMeetingId());
	}

	/**
	 * @return void
	 */
	public function renderDefault()
	{
		$settingsModel = $this->getModel();
		$template = $this->getTemplate();

		$template->graphHeight = $this->calculateGraphHeight();

Accessing graphHeight on the interface Nette\Application\UI\ITemplate suggest that you code against a concrete implementation. How about adding an instanceof check?

		$template->account = $settingsModel->getMoney('account');

Accessing account on the interface Nette\Application\UI\ITemplate suggest that you code against a concrete implementation. How about adding an instanceof check?

		$template->balance = $settingsModel->getMoney('balance');

Accessing balance on the interface Nette\Application\UI\ITemplate suggest that you code against a concrete implementation. How about adding an instanceof check?

		$template->suma = $settingsModel->getMoney('suma');

Accessing suma on the interface Nette\Application\UI\ITemplate suggest that you code against a concrete implementation. How about adding an instanceof check?

		$template->programs = $this->getProgramModel()->renderExportPrograms();

Accessing programs on the interface Nette\Application\UI\ITemplate suggest that you code against a concrete implementation. How about adding an instanceof check?

		$template->meals = MealModel::$dayMeal;

Accessing meals on the interface Nette\Application\UI\ITemplate suggest that you code against a concrete implementation. How about adding an instanceof check?

The property App\Models\MealModel::$dayMeal has been deprecated.

	}

	public function renderEvidence($type, $id = null)
	{
		$this->filename = 'faktura.pdf';

		// summary header
		$hkvsHeader = "Junák - český skaut, Kapitanát vodních skautů, z. s. | ";
		$hkvsHeader .= "Senovážné náměstí 977/24, Praha 1, 110 00 | ";
		$hkvsHeader .= "IČ: 65991753, ČÚ: 2300183549/2010";

		$evidences = $this->getModel()->evidence($id);

		if(!$evidences) {
			Debugger::log('No data for evidence export.', Debugger::ERROR);
			$this->flashMessage('No data.');
			$this->redirect('Export:listing');
		}

		switch($type){
			case "summary":
				$templateName = 'evidence_summary';
				// specific mPDF settings
				$this->getPdf()->defaultfooterfontsize = 16;
				$this->getPdf()->defaultfooterfontstyle = 'B';
				$this->getPdf()->SetHeader($hkvsHeader);
				break;
			case "confirm":
				$templateName = 'evidence_confirm';
				break;
			default:
				$templateName = 'evidence';
				break;
		}

		$parameters = [
			'result' => $evidences,
		];

		$this->forgeView($templateName, $parameters);
		$this->publish();
	}

	/**
	 * Print Attendance into PDF file
	 *
	 * @param	void
	 * @return	file	PDF file
	 */
	public function renderAttendance()

This method seems to be duplicated in your project.

	{
		// output file name
		$this->filename = "attendance_list.pdf";
		$templateName = 'attendance';

		$attendances = $this->getModel()->attendance();

		// prepare header
		$attendanceHeader = $attendances[0]['place'] . ' ' . $attendances[0]['year'];

		// set header
		$this->getPdf()->SetHeader($attendanceHeader.'|sraz VS|Prezenční listina');

		$parameters = [
			'result' => $attendances,
		];

		$this->forgeView($templateName, $parameters);
		$this->publish();
	}

	/**
	 * Print meal tickets into PDF file
	 *
	 * @param	void
	 * @return	file	PDF file
	 */
	public function renderMealTicket()

This method seems to be duplicated in your project.

	{
		// output file name
		$this->filename= 'vlastni_stravenky.pdf';
		$templateName = 'meal_ticket';

		$mealTickets = $this->getModel()->mealTicket();

		$parameters = [
			'result' => $mealTickets,
		];

		$this->forgeView($templateName, $parameters);
		$this->publish();
	}

	/**
	 * Print name list into PDF file
	 *
	 * @param	void
	 * @return	file	PDF file
	 */
	public function renderNameList()

This method seems to be duplicated in your project.

	{
		// output file name
		$this->filename = 'name_list.pdf';
		$templateName = 'name_list';

		$nameList = $this->getModel()->nameList();

		// prepare header
		$namelistHeader = $nameList[0]['place'] . " " . $nameList[0]['year'];

		// set header
		$this->getPdf()->SetHeader($namelistHeader.'|sraz VS|Jméno, Příjmení, Přezdívka');

		$parameters = [
			'result' => $nameList,
		];

		$this->forgeView($templateName, $parameters);
		$this->publish();
	}

	/**
	 * @param  string  $type
	 * @param  integer $id
	 * @return void
	 */
	public function renderProgram($type, $id)
	{
		$programMethod = 'renderProgram' . Strings::firstUpper($type);

		call_user_func([$this, $programMethod], $id);
	}

	/**
	 * Print program cards into PDF file
	 *
	 * @param	void
	 * @return	file	PDF file
	 */
	protected function renderProgramCards()
	{
		$this->filename = 'vlastni_programy.pdf';
		$templateName = 'program_cards';

		$this->getPdf()->SetWatermarkImage(IMG_DIR . 'logos/watermark.jpg', 0.1, '');
		$this->getPdf()->showWatermarkImage = true;

		$parameters = [
			'result' => $this->getModel()->programCards(),
		];

		$this->forgeView($templateName, $parameters);
		$this->publish();
	}

	/**
	 * Print large program into PDF file
	 *
	 * @param	voide
	 * @return	file	PDF file
	 */
	protected function renderProgramLarge()

This method seems to be duplicated in your project.

	{
		$largeProgram = $this->getModel()->largeProgram();

		$this->filename = Strings::toAscii($largeProgram['place'] . $largeProgram['year'] . '-program') . '.pdf';
		$templateName = 'program_large';

		$meetingHeader = $largeProgram['place']." ".$largeProgram['year'];

		$this->getPdf()->paperFormat = 'B1';

		$parameters = [
			'header'	=> $meetingHeader,
			'export'	=> $this->getModel(),
			'program'	=> $this->getProgramModel(),
		];

		$this->forgeView($templateName, $parameters);
		$this->publish();

	}

	/**
	 * Print public program into PDF file
	 *
	 * @param	void
	 * @return	file	PDF file
	 */
	protected function renderProgramPublic()

This method seems to be duplicated in your project.

	{
		$templateName = 'program_public';
		$publicProgram = $this->getModel()->publicProgram();
		$this->filename = Strings::toAscii($publicProgram['place'] . $publicProgram['year'] . '-program' . '.pdf');

		$meetingHeader = $publicProgram['place'] . ' ' . $publicProgram['year'];

		$parameters = [
			'header'		=> $meetingHeader,
			'export'		=> $this->getModel(),
			'program'		=> $this->getProgramModel(),
		];

		$this->forgeView($templateName, $parameters);
		$this->publish();
	}

	/**
	 * Print program badges into PDF file
	 *
	 * @param	void
	 * @return	file	PDF file
	 */
	protected function renderProgramBadges()
	{
		$this->filename = 'program-badge.pdf';
		$templateName = 'program_badge';

		$programBadges = $this->getModel()->programBadges();

		$this->getPdf()->setMargins(5, 5, 9, 5);

		$days = [
			'PÁTEK',
			'SOBOTA',
			'NEDĚLE',
		];

		$exportBlocks = [];
		foreach ($days as $day) {
			$exportBlocks[$day] = $this->getBlockModel()->getExportBlocks($this->meetingId, $day);
		}

		$parameters = [
			'meeting_id'	=> $this->meetingId,
			'result'		=> $programBadges,
			'days'			=> $days,
			'exportBlocks'	=> $exportBlocks,
		];

		$this->forgeView($templateName, $parameters);
		$this->publish();
	}

	/**
	 * Print visitors on program into PDF file
	 *
	 * @param	int		program id
	 * @return	file	PDF file
	 */
	protected function renderProgramVisitors($id)
	{
		$this->filename = 'ucastnici-programu.pdf';
		$templateName = 'program_visitors';

		$programs = $this->getModel()->programVisitors($id);

		$programHeader = $programs[0]['program'];

		$this->getPdf()->SetHeader($programHeader.'|sraz VS|Účastnící programu');

		$parameters = [
			'result' => $programs,
		];

		$this->forgeView($templateName, $parameters);
		$this->publish();
	}

	/**
	 * Print details of program into PDF file
	 *
	 * @param	void
	 * @return	file	PDF file
	 */
	protected function renderProgramDetails()

This method seems to be duplicated in your project.

	{
		$this->filename = 'vypis-programu.pdf';
		$templateName = 'program_details';

		$programDetails = $this->getModel()->programDetails();

		$this->getPdf()->SetHeader('Výpis programů|sraz VS');

		$parameters = [
			'result' => $programDetails,
		];

		$this->forgeView($templateName, $parameters);
		$this->publish();
	}

	/**
	 * @return void
	 */
	public function actionNameBadges()
	{
		$names = $this->getHttpRequest()->getPost()['names'];
		$this->renderNameBadges($names);
	}

	/**
	 * Print name badges into PDF file
	 *
	 * @param	string 	comma separated values
	 * @return	file	PDF file
	 */
	public function renderNameBadges($namesStringified)
	{
		$this->filename = 'jmenovky.pdf';
		$templateName = 'name_badge';

		$badges = [];
		if(!$namesStringified) {
			$badges = $this->getModel()->nameBadges();
		} else {
			$namesStringified = preg_replace('/\s+/','',$namesStringified);

			$names = explode(',',$namesStringified);
			foreach($names as $name) {
				$badge['nick'] = $name;

$badge was never initialized. Although not strictly required by PHP, it is generally a good practice to add $badge = array(); before regardless.

				$badges[] = $badge;
			}
		}

		$this->getPdf()->setMargins(15, 15, 10, 5);
		$this->getPdf()->SetWatermarkImage(IMG_DIR . 'logos/watermark-waves.jpg', 0.1, '');
		$this->getPdf()->showWatermarkImage = TRUE;

		$parameters = [
			'result' => $badges,
		];

		$this->forgeView($templateName, $parameters);
		$this->publish();
	}

	/**
	 * Print data of visitors into excel file
	 *
	 * @return	file	*.xlsx file type
	 */
	public function renderVisitorsExcel()
	{
		$excel = $this->getExcel();

		$excel->getProperties()->setCreator("HKVS Srazy K + K")->setTitle("Návštěvníci");

		// Zde si vyvoláme aktivní list (nastavený nahoře) a vyplníme buňky A1 a A2
		$list = $excel->setActiveSheetIndex(0);

		$cells = [
			'A1' => 'ID',
			'B1' => 'symbol',
			'C1' => 'Jméno',
			'D1' => 'Příjmení',
			'E1' => 'Přezdívka',
			'F1' => 'Narození',
			'G1' => 'E-mail',
			'H1' => 'Adresa',
			'I1' => 'Město',
			'J1' => 'PSČ',
			'K1' => 'Kraj',
			'L1' => 'Evidence',
			'M1' => 'Středisko/Přístav',
			'N1' => 'Oddíl',
			'O1' => 'Účet',
			'P1' => 'Připomínky',
			'Q1' => 'Příjezd',
			'R1' => 'Odjezd',
			'S1' => 'Otázka',
		];

		foreach($cells as $key => $value) {
			$list->setCellValue($key, $value);
		}

		$excel->getActiveSheet()->getStyle('A1:Z1')->getFont()->setBold(true);

		$dimensions = [
			'C' => 15,
			'D' => 15,
			'F' => 15,
			'G' => 30,
			'H' => 20,
			'I' => 15,
			'K' => 20,
			'M' => 30,
			'N' => 20,
			'P' => 20,
			'Q' => 20,
			'R' => 20,
			'S' => 20,
		];

		foreach($dimensions as $key => $value) {
			$excel->getActiveSheet()->getColumnDimension($key)->setWidth($value);
		}

		$visitors = $this->getModel()->visitorsExcel();

		$cellValues = [
			'A' => 'id',
			'B' => 'code',
			'C' => 'name',
			'D' => 'surname',
			'E' => 'nick',
			'F' => 'birthday',
			'G' => 'email',
			'H' => 'street',
			'I' => 'city',
			'J' => 'postal_code',
			'K' => 'province',
			'L' => 'group_num',
			'M' => 'group_name',
			'N' => 'troop_name',
			'O' => 'bill',
			'P' => 'comment',
			'Q' => 'arrival',
			'R' => 'departure',
			'S' => 'question',
			'S' => 'question2',
			'T' => 'all',
			'U' => 'fry_dinner',
			'V' => 'sat_breakfast',
			'W' => 'sat_lunch',
			'X' => 'sat_dinner',
			'Y' => 'sun_breakfast',
			'Z' => 'sun_lunch',
		];

		$i = 2;
		foreach($visitors as $data) {
			foreach($cellValues as $cell => $value) {
				$list->setCellValue($cell . $i, $data[$value]);
			}
			$i++;
		}

		// stahnuti souboru
		$filename = 'export-MS-'.date('Y-m-d',time()).'.xlsx';

		$excel->setActiveSheetIndex(0);

		header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
		header('Content-Disposition: attachment;filename="'.$filename.'"');
		header('Cache-Control: max-age=0');

		// If you're serving to IE over SSL, then the following may be needed
		header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
		header('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
		header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
		header('Pragma: public'); // HTTP/1.0

		$ExcelWriter = \PHPExcel_IOFactory::createWriter($excel, 'Excel2007');
		$ExcelWriter->save('php://output');
		exit;
	}

	/**
	 * @param  string $name
	 * @param  array  $parameters
	 * @return self
	 */
	protected function forgeView($name = '', array $parameters = [])
	{
		$template = $this->getTemplate();

		foreach ($parameters as $parameter => $value) {
			$template->{$parameter} = $value;
		}

		$this->setView($name);
		$template->setFile(
			sprintf(
				'%s%s.%s',
				self::TEMPLATE_DIR,
				$name,
				self::TEMPLATE_EXT
			)
		);

		return $this;
	}

	protected function publish()
	{
		$template = $this->getTemplate();

		/* debugging */
		if($this->debugMode){
			echo $template;
			exit('DEBUG_MODE');
		} else {
			// write html
			$this->getPdf()->WriteHTML((string) $template, 0);
			// download
			$this->getPdf()->Output($this->filename, "D");
			exit;
		}
	}

	/**
	 * @return RegistrationGraphControl
	 */
	protected function createComponentRegistrationGraph()
	{
		return $this->registrationGraphControl->setMeetingId($this->getMeetingId());
	}

	/**
	 * @param  RegistrationGraphControl $control
	 * @return $this
	 */
	protected function setRegistrationGraphControl(RegistrationGraphControl $control)
	{
		$this->registrationGraphControl = $control;

		return $this;
	}

	/**
	 * @return MaterialControl
	 */
	protected function createComponentMaterials()
	{
		return $this->materialControl->setMeetingId($this->getMeetingId());
	}

	/**
	 * @param  MaterialControl $control
	 * @return $this
	 */
	protected function setMaterialControl(MaterialsControl $control)
	{
		$this->materialControl = $control;

		return $this;
	}

	/**
	 * @return MealControl
	 */
	protected function createComponentMeal()
	{
		return $this->mealControl->setMeetingId($this->getMeetingId());
	}

	/**
	 * @param  MealControl $control
	 * @return $this
	 */
	protected function setMealControl(MealControl $control)
	{
		$this->mealControl = $control;

		return $this;
	}

	/**
	 * @return integer
	 */
	protected function calculateGraphHeight()
	{
		$graphHeight = RegistrationGraphControl::GRAPH_HEIGHT_INIT;

		foreach($this->getModel()->graph() as $graph) {
			$graphHeight += RegistrationGraphControl::GRAPH_HEIGHT_STEP;
		}

		if($graphHeight < RegistrationGraphControl::GRAPH_HEIGHT_MIN) {
			$graphHeight = RegistrationGraphControl::GRAPH_HEIGHT_MIN;
		}

		return $graphHeight;
	}

	/**
	 * @return ProgramModel
	 */
	protected function getProgramModel()
	{
		return $this->programModel;
	}

	/**
	 * @param  BlockModel $model
	 * @return $this
	 */
	protected function setBlockModel(BlockModel $model)
	{
		$this->blockModel = $model;
		return $this;
	}

	/**
	 * @return BlockModel
	 */
	protected function getBlockModel()
	{
		return $this->blockModel;
	}

	/**
	 * @param  ProgramModel $model
	 * @return $this
	 */
	protected function setProgramModel(ProgramModel $model)
	{
		$this->programModel = $model;
		return $this;
	}


	/**
	 * @return PHPExcel
	 */
	protected function getExcel()
	{
		return $this->excel;
	}

	/**
	 * @param  PHPExcel $excel
	 * @return $this
	 */
	protected function setExcel(\PHPExcel $excel)
	{
		$this->excel = $excel;

It seems like $excel of type object<PHPExcel> is incompatible with the declared type object<App\Presenters\PHPExcel> of property $excel.

		return $this;
	}

	/**
	 * @return mPDF
	 */
	protected function getPdf()
	{
		return $this->pdf;
	}

	/**
	 * @param  Mpdf $pdf
	 * @return self
	 */
	protected function setPdf(Mpdf $pdf)
	{
		$this->pdf = $pdf;

It seems like $pdf of type object<Mpdf\Mpdf> is incompatible with the declared type object<Mpdf\Mpdf\Mpdf> of property $pdf.

		return $this;
	}

}