protected function buildLocationTable(School $school)
{
// Region
$this->phpExcelObject->getActiveSheet()->setCellValueByColumnAndRow(6, 3, "Регион:")->mergeCells($this->getPosition(3, 3, 'G') . ":" . $this->getPosition(3, 3, 'H'));
$this->styleAlignHorizontalRight(3, 3, 'G')->styleBorderThin(3, 3, 'G')->styleFontBold(3, 3, 'G');
$this->phpExcelObject->getActiveSheet()->setCellValueByColumnAndRow(8, 3, $school->getRegion() ? $school->getRegion()->getName() : '-')->mergeCells($this->getPosition(3, 3, 'I') . ":" . $this->getPosition(3, 3, 'J'));
$this->styleAlignHorizontalRight(3, 3, 'I')->styleAlignHorizontalRight(3, 3, 'J')->styleBorderThin(3, 3, 'I')->styleBorderThin(3, 3, 'J');
// Settlement
$this->phpExcelObject->getActiveSheet()->setCellValueByColumnAndRow(6, 4, "Населенный пункт:")->mergeCells($this->getPosition(4, 4, 'G') . ":" . $this->getPosition(4, 4, 'H'));
$this->styleAlignHorizontalRight(4, 4, 'G')->styleBorderThin(4, 4, 'G')->styleFontBold(4, 4, 'G');
$this->phpExcelObject->getActiveSheet()->setCellValueByColumnAndRow(8, 4, $school->getSettlement()->getName() ?: '-')->mergeCells($this->getPosition(4, 4, 'I') . ":" . $this->getPosition(4, 4, 'J'));
$this->styleAlignHorizontalRight(4, 4, 'I')->styleAlignHorizontalRight(4, 4, 'J')->styleBorderThin(4, 4, 'I')->styleBorderThin(4, 4, 'J');
// Address
$this->phpExcelObject->getActiveSheet()->setCellValueByColumnAndRow(6, 5, "Адрес:")->mergeCells($this->getPosition(5, 5, 'G') . ":" . $this->getPosition(5, 5, 'H'));
$this->styleAlignHorizontalRight(5, 5, 'G')->styleBorderThin(5, 5, 'G')->styleFontBold(5, 5, 'G');
$this->phpExcelObject->getActiveSheet()->setCellValueByColumnAndRow(8, 5, $school->getAddress() ?: '-')->mergeCells($this->getPosition(5, 5, 'I') . ":" . $this->getPosition(5, 5, 'J'));
$this->styleAlignHorizontalRight(5, 5, 'I')->styleAlignHorizontalRight(5, 5, 'J')->styleBorderThin(5, 5, 'I')->styleBorderThin(5, 5, 'J');
// Name
$this->phpExcelObject->getActiveSheet()->setCellValueByColumnAndRow(6, 6, "Школа:")->mergeCells($this->getPosition(6, 6, 'G') . ":" . $this->getPosition(6, 6, 'H'));
$this->styleAlignHorizontalRight(6, 6, 'G')->styleBorderThin(6, 6, 'G')->styleFontBold(6, 6, 'G');
$this->phpExcelObject->getActiveSheet()->setCellValueByColumnAndRow(8, 6, $school->getName() ?: '-')->mergeCells($this->getPosition(6, 6, 'I') . ":" . $this->getPosition(6, 6, 'J'));
$this->styleAlignHorizontalRight(6, 6, 'I')->styleAlignHorizontalRight(6, 6, 'J')->styleBorderThin(6, 6, 'I')->styleBorderThin(6, 6, 'J');
}
/**
* Add school
*
* @param \AppBundle\Entity\School\School $school
* @return Settlement
*/
public function addSchool(\AppBundle\Entity\School\School $school)
{
$school->setSettlement($this);
$this->schools[] = $school;
return $this;
}
/**
* Add schools
*
* @param \AppBundle\Entity\School\School $school
* @return Employee
*/
public function addSchool(\AppBundle\Entity\School\School $school)
{
$school->addEmployee($this);
$this->schools[] = $school;
return $this;
}