30/12
2016
Wallogit.com
2017 © Pedro Peláez
Jira report
{
"require": {
"gemorroj/jira-report": "dev-master"
}
}
$ php composer.phar update gemorroj/jira-report
<?php
require __DIR__ . '/vendor/autoload.php';
use JiraReport\Jira;
use JiraReport\Excel;
use JiraReport\Filter\Worklog;
// авторизация
$jira = new Jira('myusername', 'password');
// дополнительный фильтр для worklog
$filter = (new Worklog())
->setAuthor('myusername')
->setDateFrom(new \DateTime('2016-04-01 00:00:00'))
->setDateTo(new \DateTime('2016-04-30 23:59:59'));
$jira->addFilter($filter);
// строка запроса JQL
$jira->findIssues('(worklogAuthor = myusername AND worklogDate >= 2016-04-01 AND worklogDate <= 2016-04-30) OR (timespent IS NULL AND labels = mylabel AND resolutiondate >= 2016-04-01 AND resolutiondate <= 2016-04-30) ORDER BY key DESC');
// вытаскиваем данные из jira
$jira->makeData();
// формируем отчет
$excel = new Excel(__DIR__ . '/report.xlsx');
$excel->makeExcel($jira);