php Abstract Class Report protected sheet_id protected generator publi

<?php
Abstract Class Report {
	protected $sheet_id = 0;
	protected $generator;

	public function __construct ()
	{
		$this->generator = new PHPExcel;
		$this->generator->getProperties()->setCreator("Sdm-club administrator")
									 ->setLastModifiedBy("Sdm-club administrator")
									 ->setTitle("Office 2007 XLSX Document")
									 ->setSubject("Office 2007 XLSX Document")
									 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
									 ->setKeywords("office 2007 openxml php")
									 ->setCategory("Report file");
	}

	public function prettyName ($s)
	{
		$arr = explode(' ', $s);
		if (count($arr) == 3) {
			$new_s = $arr[0].' '.mb_substr($arr[1], 0, 1, 'utf-8').'.'.mb_substr($arr[2], 0, 1, 'utf-8').'.';
		} elseif (count($arr) == 2) {
			$new_s = $arr[0].' '.mb_substr($arr[1], 0, 1, 'utf-8').'.';
		} else {
			$new_s = $s;
		}

		return $new_s;
	}

	abstract public function compile();
}

Class ReportManager extends Report {
	private $excel;
	protected $reports = array();

	public function __construct (array $reports) 
	{
		$this->reports = $reports;
	}

	public function compile() 
	{
		foreach ($this->reports as $report) 
		{
			$report->compile();
			$this->excel = $report->generator;
		}

		// echo '<pre>';
		// print_r($data);
		// echo '</pre>';
	}

	public function save ()
	{
		$writer = PHPExcel_IOFactory::createWriter($this->excel, 'Excel2007');
		$writer->save('php://output');
	}
}

Class ReportAll extends Report {
	private $provider;
	private $farmusersstats;

	public function __construct (&$dbProvider)
	{
		parent::__construct();
		$this->provider = $dbProvider;
	}

	public function getData ()
	{
		$sql = "SELECT users.id,users.dispname as username,city.id as city_id,city.name as city,drugnet.id as drugnet_id,drugnet.name as drugnet FROM `users`
				INNER JOIN city ON city.id = users.city_id
				INNER JOIN drugnet ON drugnet.id = users.drugnet_id
				ORDER BY city.name ASC";
		$request = $this->provider->Select($sql);

		$row = array();
		foreach ($request as $i => $r) 
		{
			$row[$i][id] = $r[id];
			// $row[$i][username] = $this->prettyName($r[username]);
			$row[$i][username] = $r[username];
			$row[$i][city] = $r[city];
			$row[$i][drugnet] = $r[drugnet];
			$row[$i][usercount] = $this->getUsersCount($r[city_id], $r[drugnet_id]);
			$row[$i][userstats] = $this->getUsersStat($r[id]);
		}

		return $row;
	}

	public function getUsersCount ($city_id, $drugnet_id)
	{
		if (is_numeric($city_id) && is_numeric($drugnet_id))
		{
			return $this->provider->Count("SELECT id FROM `users` WHERE city_id = {$city_id} AND drugnet_id = {$drugnet_id}");
		}
		return null;
	}

	public function getUsersStat ($user_id)
	{
		return '4/9';
	}

	public function compile ()
	{
		// Add some header
		$this->generator->setActiveSheetIndex($this->sheet_id)
		            ->setCellValue('A1', 'Город')
		            ->setCellValue('B1', 'Аптечная сеть')
		            ->setCellValue('C1', 'Количество')
		            ->setCellValue('D1', 'Фармацевты')
		            ->setCellValue('E1', 'Статистика (прошел/не прошел)');
        $this->generator->getActiveSheet()->getStyle('A1:E1')->getFont()->setBold(true);
        $this->generator->getActiveSheet()->setTitle('Отчет №1');

        // Add some data
        $index = 1;
        $result = array();
		foreach ($this->getData() as $row) 
		{
			$index++;
			$this->generator->getActiveSheet()
								->setCellValue('A' . $index, $row[city])
								->setCellValue('B' . $index, $row[drugnet])
								->setCellValue('C' . $index, $row[usercount])
								->setCellValue('D' . $index, $row[username])
					            ->setCellValue('E' . $index, $row[userstats]);
		}

		$this->generator->setActiveSheetIndex(0);
	}
}

Class ReportUsers extends Report {
	private $composer;
	protected $provider;
	protected $group_id;

	public function __construct (&$dbProvider, $group_id)
	{
		parent::__construct();
		$this->provider = $dbProvider;
		$this->group_id = $group_id;
	}

	public function getComposer ()
	{
		switch ($this->group_id) 
		{
			case '3':
				return new ReportUsersFarm;
				break;
			
			case '4':
				return new ReportUsersCorp;
				break;

			default:
				return null;
				break;
		}
	}

	public function compile ()
	{
		if (!is_null($this->getComposer()))
		{
			$this->getComposer()->compile();
		}
	}
}

Class ReportUsersFarm extends ReportUsers {
	public function getData ()
	{
		$sql = "SELECT 
					users.id,users.dispname as username,users.drugstore,users.position,users.phone,
					city.name as city,drugnet.name as drugnet FROM `users`
				INNER JOIN city ON city.id = users.city_id
				INNER JOIN drugnet ON drugnet.id = users.drugnet_id
				WHERE users.group_id = {$this->group_id}
				ORDER BY users.id DESC";
		return $this->provider->Select($sql);
	}

	public function compile ()
	{
		// Add new sheet
		$this->sheet_id++;

		// Add some header
		$this->generator->setActiveSheetIndex($this->sheet_id)
		            ->setCellValue('A1', 'ФИО')
		            ->setCellValue('B1', 'Город')
		            ->setCellValue('C1', 'Аптека')
		            ->setCellValue('D1', 'Аптечная сеть')
		            ->setCellValue('E1', 'Должность')
		            ->setCellValue('F1', 'Телефон');
        $this->generator->getActiveSheet()->getStyle('A1:F1')->getFont()->setBold(true);
        $this->generator->getActiveSheet()->setTitle('Отчет №2 (Фармацевты)');

		// Add some data
        $index = 1;
        $result = array();
		foreach ($this->getData() as $row)
		{
			$index++;
			$this->generator->getActiveSheet()
								->setCellValue('A' . $index, $row[username])
								->setCellValue('B' . $index, $row[city])
								->setCellValue('C' . $index, $row[drustore])
								->setCellValue('D' . $index, $row[drugnet])
								->setCellValue('E' . $index, $row[position])
					            ->setCellValue('F' . $index, $row[phone]);
		}

		$this->generator->setActiveSheetIndex(0);
	}
}

Class ReportUsersCorp extends ReportUsers {
	public function getData ()
	{
		$sql = "SELECT 
					users.id,users.dispname as username,users.position,users.phone,
					city.name as city FROM `users`
				INNER JOIN city ON city.id = users.city_id
				WHERE users.group_id = {$this->group_id}
				ORDER BY users.id DESC";
		return $this->provider->Select($sql);
	}

	public function compile ()
	{
		// Add new sheet
		$this->sheet_id++;

		// Add some header
		$this->generator->setActiveSheetIndex($this->sheet_id)
		            ->setCellValue('A1', 'ФИО')
		            ->setCellValue('B1', 'Город')
		            ->setCellValue('С1', 'Должность')
		            ->setCellValue('D1', 'Телефон');
        $this->generator->getActiveSheet()->getStyle('A1:D1')->getFont()->setBold(true);
        $this->generator->getActiveSheet()->setTitle('Отчет №2 (Сотрудники)');

		// Add some data
        $index = 1;
        $result = array();
		foreach ($this->getData() as $row)
		{
			$index++;
			$this->generator->getActiveSheet()
								->setCellValue('A' . $index, $row[username])
								->setCellValue('B' . $index, $row[city])
								->setCellValue('C' . $index, $row[position])
								->setCellValue('D' . $index, $row[phone]);
		}

		$this->generator->setActiveSheetIndex(0);
	}
}
?>