public function saveToCache($inline = true, $name = '')
{
$this->name = $name ?: md5($this->value);
$file = \Manager::getFilesPath($this->name);
if (!file_exists($file)) {
$this->saveTo($file);
}
$this->setPath($file, $inline);
}
public function save()
{
$file = \Manager::getFilesPath($this->data->id, true);
if (!file_exists($file)) {
$this->notfound($this->data->id . " : Not found!");
} else {
$this->renderDownload($file);
}
}
public function execute($data)
{
$id = uniqid(md5(uniqid("")));
// generate a unique id to avoid name conflicts
$fileOutput = $id . "." . $this->fileType;
// the report generated file
$pathOut = Manager::getFilesPath($fileOutput, true);
$output = $this->exporter->execute($data, $pathOut);
return $output ?: \Manager::getDownloadURL('report', basename($fileOutput), true);
}
function executeDB($db, $fileInput, $parameters = null, $fileType = 'PDF', $save = false)
{
$this->fileType = isset($fileType) ? strtoupper(trim($fileType)) : 'PDF';
$id = uniqid(md5(uniqid("")));
// generate a unique id to avoid name conflicts
$this->fileOutput = $id . "." . strtolower($this->fileType);
// the report generated file
$pathOut = Manager::getFilesPath($this->fileOutput, true);
$pathIn = $this->getInputPath($fileInput);
return $this->fillDB($db, $pathIn, $pathOut, $fileType, $parameters, $classPath, $save);
}
public function execute()
{
$pdfCode = $this->getOutput();
$fileName = uniqid(md5(uniqid(""))) . '.pdf';
$this->fileOutput = Manager::getFilesPath($fileName, true);
$fp = fopen($this->fileOutput, 'x');
fwrite($fp, $pdfCode);
fclose($fp);
$output = \Manager::getDownloadURL('report', $fileName, true);
return $output;
}
/**
* Gera um prefixo para servir como nome de arquivo
* @return string
*/
private static function createFilename()
{
$fileDir = \Manager::getFilesPath();
$filename = uniqid(rand(), true);
return "{$fileDir}/{$filename}";
}
public function renderLot()
{
$grafico = new PHPlot(800, 600);
$grafico->SetFileFormat("jpg");
$grafico->SetIsInline(True);
#Indicamos o títul do gráfico e o título dos dados no eixo X e Y do mesmo
$grafico->SetTitle($this->data->titulo);
$grafico->SetXTitle($this->data->eixoX);
$grafico->SetYTitle($this->data->eixoY);
#passamos o tipo de gráfico escolhido
if (!$this->data->tipoLot) {
$this->data->tipoLot = 'bars';
}
$grafico->SetPlotType($this->data->tipoLot);
switch ($this->data->tipoLot) {
case 'pie':
$grafico->SetPieLabelType('index', 'custom', 'mycallback');
$grafico->SetDataType('text-data-single');
break;
case 'stackedbars':
$grafico->SetDataType('text-data-yx');
break;
case 'bubbles':
$grafico->SetDataType('data-data-xyz');
break;
}
$grafico->SetLegend($column_names);
#Definimos os dados do gráfico
switch ($this->data->tipoLot) {
case 'pie':
$dados = array(array($this->data->x1, $this->data->y11), array($this->data->x2, $this->data->y21), array($this->data->x3, $this->data->y31), array($this->data->x4, $this->data->y41));
break;
default:
$dados = array(array($this->data->x1, $this->data->y11, $this->data->y12, $this->data->y13), array($this->data->x2, $this->data->y21, $this->data->y22, $this->data->y23), array($this->data->x3, $this->data->y31, $this->data->y32, $this->data->y33), array($this->data->x4, $this->data->y41, $this->data->y42, $this->data->y43));
break;
}
$grafico->SetDataValues($dados);
#Salvamos o gráfico
$caminho = \Manager::getFilesPath();
$fileName = uniqid() . '.jpg';
$grafico->SetOutputFile($caminho . '/' . $fileName);
$grafico->SetIsInline(True);
$grafico->DrawGraph();
#obtemos o endereco do grafico
$this->data->locate = \Manager::getDownloadURL('files', basename($fileName), true);
}
public function asCSV($showColumnName = false)
{
$this->getResult();
$result = $this->result;
if ($showColumnName) {
for ($i = 0; $i < $this->columnCount; $i++) {
$columns[] = ucfirst($this->metadata['fieldname'][$i]);
}
array_unshift($result, $columns);
}
$id = uniqid(md5(uniqid("")));
// generate a unique id to avoid name conflicts
$fileCSV = \Manager::getFilesPath($id . '.csv', true);
$csvDump = new \MCSVDump(\Manager::getOptions('csv'));
$csvDump->save($result, basename($fileCSV));
return $fileCSV;
}
private function getCaptcha($name)
{
$font = Manager::getPublicPath('', '', 'fonts/ttf/arial.ttf');
$path = Manager::getFilesPath();
return new Zend\Captcha\Image(array('name' => $name, 'font' => $font, 'imgDir' => $path));
}
