Page MenuHomestyx hydra
Files F571809

No OneTemporary
Actions

View Options

diff --git a/src/applications/maniphest/controller/export/ManiphestExportController.php b/src/applications/maniphest/controller/export/ManiphestExportController.php
index c0ffc4a8ca..be017963ab 100644
--- a/src/applications/maniphest/controller/export/ManiphestExportController.php
+++ b/src/applications/maniphest/controller/export/ManiphestExportController.php
@@ -1,201 +1,229 @@
<?php
/*
* Copyright 2012 Facebook, Inc.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
/**
* @group maniphest
*/
final class ManiphestExportController extends ManiphestController {
private $key;
public function willProcessRequest(array $data) {
$this->key = $data['key'];
return $this;
}
/**
- * @phutil-external-symbol class Spreadsheet_Excel_Writer
+ * @phutil-external-symbol class PHPExcel
+ * @phutil-external-symbol class PHPExcel_IOFactory
+ * @phutil-external-symbol class PHPExcel_Style_NumberFormat
*/
public function processRequest() {
$request = $this->getRequest();
$user = $request->getUser();
- $ok = @include_once 'Spreadsheet/Excel/Writer.php';
+ $ok = @include_once 'PHPExcel.php';
if (!$ok) {
$dialog = new AphrontDialogView();
$dialog->setUser($user);
$dialog->setTitle('Excel Export Not Configured');
$dialog->appendChild(
- '<p>This system does not have Spreadsheet_Excel_Writer installed. '.
- 'This software component is required to export tasks to Excel. Have '.
- 'your system administrator install it with:</p>'.
+ '<p>This system does not have PHPExcel installed. This software '.
+ 'component is required to export tasks to Excel. Have your system '.
+ 'administrator install it from:</p>'.
'<br />'.
- '<p><code>$ sudo pear install Spreadsheet_Excel_Writer</code></p>');
+ '<p>'.
+ '<a href="http://www.phpexcel.net/">http://www.phpexcel.net/</a>'.
+ '</p>'.
+ '<br />'.
+ '<p>Your PHP "include_path" needs to be updated to include the '.
+ 'PHPExcel Classes/ directory.</p>');
$dialog->addCancelButton('/maniphest/');
return id(new AphrontDialogResponse())->setDialog($dialog);
}
$query = id(new PhabricatorSearchQuery())->loadOneWhere(
'queryKey = %s',
$this->key);
if (!$query) {
return new Aphront404Response();
}
if (!$request->isDialogFormPost()) {
$dialog = new AphrontDialogView();
$dialog->setUser($user);
$dialog->setTitle('Export Tasks to Excel');
$dialog->appendChild(
'<p>Do you want to export the query results to Excel?</p>');
$dialog->addCancelButton('/maniphest/');
$dialog->addSubmitButton('Export to Excel');
return id(new AphrontDialogResponse())->setDialog($dialog);
}
$query->setParameter('limit', null);
$query->setParameter('offset', null);
$query->setParameter('order', 'p');
$query->setParameter('group', 'n');
list($tasks, $handles) = ManiphestTaskListController::loadTasks($query);
// Ungroup tasks.
$tasks = array_mergev($tasks);
$all_projects = array_mergev(mpull($tasks, 'getProjectPHIDs'));
$project_handles = id(new PhabricatorObjectHandleData($all_projects))
->loadHandles();
$handles += $project_handles;
- $workbook = new Spreadsheet_Excel_Writer();
- $sheet = $workbook->addWorksheet('Exported Maniphest Tasks');
+ $workbook = new PHPExcel();
- $date_format = $workbook->addFormat();
- $date_format->setNumFormat('M/D/YYYY h:mm AM/PM');
+ $sheet = $workbook->setActiveSheetIndex(0);
+ $sheet->setTitle('Tasks');
$widths = array(
null,
- 20,
+ 15,
null,
+ 10,
15,
- 20,
- 20,
- 75,
- 40,
+ 15,
+ 60,
30,
- 400,
+ 20,
+ 100,
);
foreach ($widths as $col => $width) {
if ($width !== null) {
- $sheet->setColumn($col, $col, $width);
+ $sheet->getColumnDimension($this->col($col))->setWidth($width);
}
}
$status_map = ManiphestTaskStatus::getTaskStatusMap();
$pri_map = ManiphestTaskPriority::getTaskPriorityMap();
+ $date_format = null;
+
$rows = array();
$rows[] = array(
'ID',
'Owner',
'Status',
'Priority',
'Date Created',
'Date Updated',
'Title',
'Projects',
'URI',
'Description',
);
- $formats = array(
- null,
- null,
- null,
- null,
- $date_format,
- $date_format,
- null,
- null,
- null,
- null,
+
+ $is_date = array(
+ false,
+ false,
+ false,
+ false,
+ true,
+ true,
+ false,
+ false,
+ false,
+ false,
);
- $header_format = $workbook->addFormat();
- $header_format->setBold();
+ $header_format = array(
+ 'font' => array(
+ 'bold' => true,
+ ),
+ );
foreach ($tasks as $task) {
$task_owner = null;
if ($task->getOwnerPHID()) {
$task_owner = $handles[$task->getOwnerPHID()]->getName();
}
$projects = array();
foreach ($task->getProjectPHIDs() as $phid) {
$projects[] = $handles[$phid]->getName();
}
$projects = implode(', ', $projects);
$rows[] = array(
'T'.$task->getID(),
$task_owner,
idx($status_map, $task->getStatus(), '?'),
idx($pri_map, $task->getPriority(), '?'),
$this->computeExcelDate($task->getDateCreated()),
$this->computeExcelDate($task->getDateModified()),
$task->getTitle(),
$projects,
PhabricatorEnv::getProductionURI('/T'.$task->getID()),
- $task->getDescription(),
+ phutil_utf8_shorten($task->getDescription(), 512),
);
}
foreach ($rows as $row => $cols) {
foreach ($cols as $col => $spec) {
+ $cell_name = $this->col($col).($row + 1);
+ $sheet->setCellValue($cell_name, $spec);
+
if ($row == 0) {
- $fmt = $header_format;
- } else {
- $fmt = $formats[$col];
+ $sheet->getStyle($cell_name)->applyFromArray($header_format);
+ }
+
+ if ($is_date[$col]) {
+ $code = PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD2;
+ $sheet
+ ->getStyle($cell_name)
+ ->getNumberFormat()
+ ->setFormatCode($code);
}
- $sheet->write($row, $col, $spec, $fmt);
}
}
+ $writer = PHPExcel_IOFactory::createWriter($workbook, 'Excel2007');
+
ob_start();
- $workbook->close();
+ $writer->save('php://output');
$data = ob_get_clean();
+ $mime = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
+
return id(new AphrontFileResponse())
- ->setMimeType('application/vnd.ms-excel')
- ->setDownload('maniphest_tasks_'.date('Ymd').'.xls')
+ ->setMimeType($mime)
+ ->setDownload('maniphest_tasks_'.date('Ymd').'.xlsx')
->setContent($data);
}
private function computeExcelDate($epoch) {
$seconds_per_day = (60 * 60 * 24);
$offset = ($seconds_per_day * 25569);
return ($epoch + $offset) / $seconds_per_day;
}
+ private function col($n) {
+ return chr(ord('A') + $n);
+ }
+
}

File Metadata

Mime Type
text/x-diff
Expires
Sat, Sep 20, 8:31 AM (1 d, 2 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
241565
Default Alt Text
(7 KB)

Event Timeline

styx copyright 2020 sirocyl / ellie (kymkdd) / ncommander / styx contributors
Use of other names and brands is not intended to reflect a claim of, or right to, use the name or brand.
styx is an operating system using the Linux kernel and components, and "styx Linux" as a phrase does not reflect the inclusion of the Linux brand or trademark in the styx project.
Linux® is the registered trademark of Linus Torvalds in the U.S. and other countries.
Terms and Conditions (TODO: fix this!)