absences_AgentXls

Complexity

Total Complexity

10

Size/Duplication

Total Lines	146
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	9

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	10	1
A	addRequestsWorksheet()	0	56	3
B	addRightsWorksheet()	0	65	6

<?php
/************************************************************************
 * OVIDENTIA http://www.ovidentia.org                                   *
 ************************************************************************
 * Copyright (c) 2003 by CANTICO ( http://www.cantico.fr )              *
 *                                                                      *
 * This file is part of Ovidentia.                                      *
 *                                                                      *
 * Ovidentia is free software; you can redistribute it and/or modify    *
 * it under the terms of the GNU General Public License as published by *
 * the Free Software Foundation; either version 2, or (at your option)  *
 * any later version.													*
 *																		*
 * This program is distributed in the hope that it will be useful, but  *
 * WITHOUT ANY WARRANTY; without even the implied warranty of			*
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.					*
 * See the  GNU General Public License for more details.				*
 *																		*
 * You should have received a copy of the GNU General Public License	*
 * along with this program; if not, write to the Free Software			*
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307,*
 * USA.																	*
************************************************************************/


require_once dirname(__FILE__).'/xls.class.php';






class absences_AgentXls extends absences_Xls
{
	/**
	 * 
	 * @var absences_Agent
	 */
	protected $agent;
	
	public function __construct(absences_Agent $agent)
	{
		parent::__construct($agent->getName());
		$this->agent = $agent;
		
		$this->addRightsWorksheet();
		$this->addRequestsWorksheet();
		
		$this->workbook->close();
	}
	
	
	/**
	 * 
	 */
	protected function addRightsWorksheet()
	{
		$ee = bab_functionality::get('ExcelExport');
		/* @var $ee Func_ExcelExport */
		
		$worksheet = $this->workbook->addWorksheet(absences_translate('Vacation rights'));

The method Workbook::addworksheet() has been deprecated with message: Use add_worksheet instead

		
		$col = 0;
		$worksheet->setColumn($col, $col++, 30);	// description

The method setColumn() does not seem to exist on object<Worksheet>.

		$worksheet->setColumn($col, $col++, 25);	// type

The method setColumn() does not seem to exist on object<Worksheet>.

		$worksheet->setColumn($col, $col++, 15);	// quantity

The method setColumn() does not seem to exist on object<Worksheet>.

		$worksheet->setColumn($col, $col++, 15);	// consumed

The method setColumn() does not seem to exist on object<Worksheet>.

		$worksheet->setColumn($col, $col++, 15);	// waiting

The method setColumn() does not seem to exist on object<Worksheet>.

		$worksheet->setColumn($col, $col++, 15);	// balance

The method setColumn() does not seem to exist on object<Worksheet>.

		$worksheet->setColumn($col, $col++, 15);	// begin

The method setColumn() does not seem to exist on object<Worksheet>.

		$worksheet->setColumn($col, $col++, 15);	// end

The method setColumn() does not seem to exist on object<Worksheet>.

		$worksheet->setColumn($col, $col++, 10);	// Accessible

The method setColumn() does not seem to exist on object<Worksheet>.

		
		$header = $this->header;

The property header does not exist. Did you maybe forget to declare it?

		
		
		$row =0;
		$col =0;
		$worksheet->write($row, $col++, $this->agent->getName());
		$row++;
		
		$col =0;
		$worksheet->write($row, $col++, absences_translate('Description')		, $header);
		$worksheet->write($row, $col++, absences_translate('Type')				, $header);	
		$worksheet->write($row, $col++, absences_translate('Initial quantity')	, $header);
		$worksheet->write($row, $col++, absences_translate('Consumed')			, $header);
		$worksheet->write($row, $col++, absences_translate('Waiting approval')	, $header);
		$worksheet->write($row, $col++, absences_translate('Balance')			, $header);
		$worksheet->write($row, $col++, absences_translate('Begin date')		, $header);
		$worksheet->write($row, $col++, absences_translate('End date')			, $header);
		$worksheet->write($row, $col++, absences_translate('Accessible')        , $header);
		
		$row++;
		foreach($this->agent->getAgentRightManagerIterator() as $agentRight) {
			$col =0;
			
			/*@var $agentRight absences_AgentRight */
		
			$right = $agentRight->getRight();
			
			$accessible = $agentRight->isAccessibleByValidityPeriod()
			&& $agentRight->isAccessibleOnPeriod(time(), time())
			&& $agentRight->isAcessibleByDirectoryEntry()
			&& $right->isAccessibleIfFixed();

			$worksheet->writeString($row, $col++, $right->description);

The method writeString() does not seem to exist on object<Worksheet>.

			$worksheet->writeString($row, $col++, $right->getType()->name);

The method writeString() does not seem to exist on object<Worksheet>.

			$worksheet->writeNumber($row, $col++, $agentRight->getQuantity(), $this->quantity);

The property quantity does not exist. Did you maybe forget to declare it?

The method writeNumber() does not seem to exist on object<Worksheet>.

			$worksheet->writeNumber($row, $col++, $agentRight->getConfirmedQuantity(), $this->quantity);

The method writeNumber() does not seem to exist on object<Worksheet>.

			$worksheet->writeNumber($row, $col++, $agentRight->getWaitingQuantity(), $this->quantity);

The method writeNumber() does not seem to exist on object<Worksheet>.

			$worksheet->writeNumber($row, $col++, $agentRight->getBalance(), $this->quantity);

The method writeNumber() does not seem to exist on object<Worksheet>.

			$worksheet->write($row, $col++, $ee->getExcelDate(bab_mktime($right->date_begin)), $this->date);

The property date does not exist. Did you maybe forget to declare it?

			$worksheet->write($row, $col++, $ee->getExcelDate(bab_mktime($right->date_end)), $this->date);
            $worksheet->write($row, $col++, $accessible ? '1':'0');

			$row++;
		}
		
		
	}
	
	protected function addRequestsWorksheet()
	{
		$ee = bab_functionality::get('ExcelExport');
		/*@var $ee Func_ExcelExport */
		
		$worksheet = $this->workbook->addWorksheet(absences_translate('User requests'));

The method Workbook::addworksheet() has been deprecated with message: Use add_worksheet instead

		
		$row =0;
		$col =0;
		$worksheet->write($row, $col++, $this->agent->getName());
		$row++;
		
		$col = 0;
		$worksheet->setColumn($col, $col++, 20);	// createdOn

The method setColumn() does not seem to exist on object<Worksheet>.

		$worksheet->setColumn($col, $col++, 40);	// type

The method setColumn() does not seem to exist on object<Worksheet>.

		$worksheet->setColumn($col, $col++, 20);	// begin

The method setColumn() does not seem to exist on object<Worksheet>.

		$worksheet->setColumn($col, $col++, 20);	// end

The method setColumn() does not seem to exist on object<Worksheet>.

		$worksheet->setColumn($col, $col++, 50);	// status

The method setColumn() does not seem to exist on object<Worksheet>.

		
		
		$header = $this->header;
		
		
		$col =0;
		$worksheet->write($row, $col++, absences_translate('Created on')		, $header);
		$worksheet->write($row, $col++, absences_translate('Type')				, $header);
		$worksheet->write($row, $col++, absences_translate('Start date')		, $header);
		$worksheet->write($row, $col++, absences_translate('End date')			, $header);
		$worksheet->write($row, $col++, absences_translate('Status')			, $header);
		
		$row++;
		foreach($this->agent->getRequestIterator() as $request) {
			$col =0;
		
			/*@var $request absences_Request */
		
			$worksheet->write($row, $col++, $ee->getExcelDate(bab_mktime($request->createdOn())), $this->datetime);

The property datetime does not exist. Did you maybe forget to declare it?

			$worksheet->writeString($row, $col++, $request->getRequestType());

The method writeString() does not seem to exist on object<Worksheet>.

			
			if ($request instanceof absences_CetDepositRequest)
			{
				$worksheet->writeString($row, $col++, '');

The method writeString() does not seem to exist on object<Worksheet>.

				$worksheet->writeString($row, $col++, '');

The method writeString() does not seem to exist on object<Worksheet>.

				
			} else {
				$worksheet->write($row, $col++, $ee->getExcelDate(bab_mktime($request->date_begin)), $this->datetime);

The property date_begin does not exist on object<absences_Request>. Since you implemented __get, maybe consider adding a @property annotation.

				$worksheet->write($row, $col++, $ee->getExcelDate(bab_mktime($request->date_end)), $this->datetime);

The property date_end does not exist on object<absences_Request>. Since you implemented __get, maybe consider adding a @property annotation.

			}
			
			
			$worksheet->writeString($row, $col++, $request->getStatusStr());

The method writeString() does not seem to exist on object<Worksheet>.

			$row++;
		}
		
	}
}