View Options

	diff --git a/src/applications/maniphest/controller/ManiphestExportController.php b/src/applications/maniphest/controller/ManiphestExportController.php
	index b0c39737fc..1872efc97c 100644
	--- a/src/applications/maniphest/controller/ManiphestExportController.php
	+++ b/src/applications/maniphest/controller/ManiphestExportController.php
	@@ -1,133 +1,140 @@
	<?php

	/**
	* @group maniphest
	*/
	final class ManiphestExportController extends ManiphestController {

	private $key;

	public function willProcessRequest(array $data) {
	$this->key = $data['key'];
	return $this;
	}

	/**
	* @phutil-external-symbol class PHPExcel
	* @phutil-external-symbol class PHPExcel_IOFactory
	* @phutil-external-symbol class PHPExcel_Style_NumberFormat
	* @phutil-external-symbol class PHPExcel_Cell_DataType
	*/
	public function processRequest() {
	$request = $this->getRequest();
	$user = $request->getUser();

	$ok = @include_once 'PHPExcel.php';
	if (!$ok) {
	$dialog = new AphrontDialogView();
	$dialog->setUser($user);

	$inst1 = pht(
	'This system does not have PHPExcel installed. This software '.
	'component is required to export tasks to Excel. Have your system '.
	'administrator install it from:');

	$inst2 = pht(
	'Your PHP "include_path" needs to be updated to include the '.
	'PHPExcel Classes directory.');

	$dialog->setTitle(pht('Excel Export Not Configured'));
	$dialog->appendChild(hsprintf(
	'<p>%s</p>'.
	'<br />'.
	'<p>'.
	'<a href="http://www.phpexcel.net/">http://www.phpexcel.net/</a>'.
	'</p>'.
	'<br />'.
	'<p>%s</p>',
	$inst1,
	$inst2));

	$dialog->addCancelButton('/maniphest/');
	return id(new AphrontDialogResponse())->setDialog($dialog);
	}

	// TODO: PHPExcel has a dependency on the PHP zip extension. We should test
	// for that here, since it fatals if we don't have the ZipArchive class.

	$saved = id(new PhabricatorSavedQueryQuery())
	->setViewer($user)
	->withQueryKeys(array($this->key))
	->executeOne();
	if (!$saved) {
	- return new Aphront404Response();
	+ $engine = id(new ManiphestTaskSearchEngine())
	+ ->setViewer($user);
	+ if ($engine->isBuiltinQuery($this->key)) {
	+ $saved = $engine->buildSavedQueryFromBuiltin($this->key);
	+ }
	+ if (!$saved) {
	+ return new Aphront404Response();
	+ }
	}

	$formats = ManiphestExcelFormat::loadAllFormats();
	$export_formats = array();
	foreach ($formats as $format_class => $format_object) {
	$export_formats[$format_class] = $format_object->getName();
	}

	if (!$request->isDialogFormPost()) {
	$dialog = new AphrontDialogView();
	$dialog->setUser($user);

	$dialog->setTitle(pht('Export Tasks to Excel'));
	$dialog->appendChild(phutil_tag('p', array(), pht(
	'Do you want to export the query results to Excel?')));

	$form = id(new PHUIFormLayoutView())
	->appendChild(
	id(new AphrontFormSelectControl())
	->setLabel(pht('Format:'))
	->setName("excel-format")
	->setOptions($export_formats));

	$dialog->appendChild($form);

	$dialog->addCancelButton('/maniphest/');
	$dialog->addSubmitButton(pht('Export to Excel'));
	return id(new AphrontDialogResponse())->setDialog($dialog);
	}

	$format = idx($formats, $request->getStr("excel-format"));
	if ($format === null) {
	throw new Exception('Excel format object not found.');
	}

	$saved->makeEphemeral();
	$saved->setParameter('limit', PHP_INT_MAX);

	$engine = id(new ManiphestTaskSearchEngine())
	->setViewer($user);

	$query = $engine->buildQueryFromSavedQuery($saved);
	$query->setViewer($user);
	$tasks = $query->execute();

	$all_projects = array_mergev(mpull($tasks, 'getProjectPHIDs'));
	$all_assigned = mpull($tasks, 'getOwnerPHID');

	$handles = id(new PhabricatorHandleQuery())
	->setViewer($user)
	->withPHIDs(array_merge($all_projects, $all_assigned))
	->execute();

	$workbook = new PHPExcel();
	$format->buildWorkbook($workbook, $tasks, $handles, $user);
	$writer = PHPExcel_IOFactory::createWriter($workbook, 'Excel2007');

	ob_start();
	$writer->save('php://output');
	$data = ob_get_clean();

	$mime = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';

	return id(new AphrontFileResponse())
	->setMimeType($mime)
	->setDownload($format->getFileName().'.xlsx')
	->setContent($data);
	}

	}

File Metadata

Mime Type: text/x-diff
Expires: Sun, Jan 19, 19:49 (1 w, 4 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1128142
Default Alt Text: (4 KB)

No OneTemporary
Actions

View Options

File Metadata

Event Timeline

No OneTemporaryActions

View Options

File Metadata

Event Timeline

No OneTemporary
Actions