| Server IP : 199.250.214.225 / Your IP : 18.216.190.57 Web Server : Apache System : Linux vps64074.inmotionhosting.com 3.10.0-1160.105.1.vz7.214.3 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : nicngo5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /home/nicngo5/fund.old.nicn.gov.ng/funds-old/vendor/maatwebsite/excel/src/Maatwebsite/Excel/Readers/ |
Upload File : |
<?php namespace Maatwebsite\Excel\Readers;
use Closure;
use PHPExcel;
use Maatwebsite\Excel\Excel;
use Maatwebsite\Excel\Collections\SheetCollection;
use Maatwebsite\Excel\Exceptions\LaravelExcelException;
/**
*
* LaravelExcel ConfigReader
*
* @category Laravel Excel
* @version 1.0.0
* @package maatwebsite/excel
* @copyright Copyright (c) 2013 - 2014 Maatwebsite (http://www.maatwebsite.nl)
* @author Maatwebsite <info@maatwebsite.nl>
* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
*/
class ConfigReader {
/**
* Excel object
* @var PHPExcel
*/
public $excel;
/**
* The sheet
* @var LaravelExcelWorksheet
*/
public $sheet;
/**
* The sheetname
* @var string
*/
public $sheetName;
/**
* Collection of sheets (through the config reader)
* @var SheetCollection
*/
public $sheetCollection;
/**
* Constructor
* @param PHPExcel $excel
* @param string $config
* @param callback $callback
*/
public function __construct(PHPExcel $excel, $config = 'excel.import', $callback = null)
{
// Set excel object
$this->excel = $excel;
// config name
$this->configName = $config;
// start
$this->start($callback);
}
/**
* Start the import
* @param bool|callable $callback $callback
* @throws \PHPExcel_Exception
* @return void
*/
public function start($callback = false)
{
// Init a new sheet collection
$this->sheetCollection = new SheetCollection();
// Get the sheet names
if ($sheets = $this->excel->getSheetNames())
{
// Loop through the sheets
foreach ($sheets as $index => $name)
{
// Set sheet name
$this->sheetName = $name;
// Set sheet
$this->sheet = $this->excel->setActiveSheetIndex($index);
// Do the callback
if ($callback instanceof Closure)
{
call_user_func($callback, $this);
}
// If no callback, put it inside the sheet collection
else
{
$this->sheetCollection->push(clone $this);
}
}
}
}
/**
* Get the sheet collection
* @return SheetCollection
*/
public function getSheetCollection()
{
return $this->sheetCollection;
}
/**
* Get value by index
* @param string $field
* @return string|null
*/
protected function valueByIndex($field)
{
// Convert field name
$field = snake_case($field);
// Get coordinate
if ($coordinate = $this->getCoordinateByKey($field))
{
// return cell value by coordinate
return $this->getCellValueByCoordinate($coordinate);
}
return null;
}
/**
* Return cell value
* @param string $coordinate
* @return string|null
*/
protected function getCellValueByCoordinate($coordinate)
{
if ($this->sheet)
{
if (str_contains($coordinate, ':'))
{
// We want to get a range of cells
$values = $this->sheet->rangeToArray($coordinate);
return $values;
}
else
{
// We want 1 specific cell
return $this->sheet->getCell($coordinate)->getValue();
}
}
return null;
}
/**
* Get the coordinates from the config file
* @param string $field
* @return string|boolean
*/
protected function getCoordinateByKey($field)
{
return config($this->configName . '.' . $this->sheetName . '.' . $field, false);
}
/**
* Dynamically get a value by config
* @param string $field
* @return string
*/
public function __get($field)
{
return $this->valueByIndex($field);
}
}