protected function getUserRepositoryIssues()
{
Loader::library("3rdparty/github3/Github/Autoloader", FRONTEND_DEVELOPER_PACKAGE_HANDLE);
Github_Autoloader::register();
$username = $this->getUserName();
$github = new Github_Client();
$api = $github->getIssueApi();
$issues = $api->getList($username, $this->repos);
return $issues;
}
function getTicket(array $p_aParams = array())
{
$github = new Github_Client();
$ticket = $github->getIssueApi()->show('dragoonis', 'ppi-framework', $p_aParams['id']);
// ppi_dump($ticket); exit;
$ticket['id'] = $ticket['number'];
$ticket['status'] = $ticket['state'];
$ticket['ticket_type'] = 'bug';
$ticket['severity'] = 'major';
$ticket['created'] = $ticket['created_at'];
$ticket['content'] = $ticket['body'];
$user = $github->getUserApi()->show($ticket['user']);
$ticket['user_fullname'] = $user['name'];
$ticket['repo_name'] = 'ppi-framework';
return $ticket;
/*
$tickets = $this->select()
->columns('t.*, u.first_name user_fn, u.last_name user_ln, uu.first_name user_assigned_fn, uu.last_name user_assigned_ln, c.title category_name')
->from($this->getTableName() . ' t')
->leftJoin('ticket_category c', 't.category_id = c.id')
->leftJoin('users u', 't.user_id=u.id')
->leftJoin('users uu', 't.assigned_user_id=uu.id');
if(isset($p_aParams['keyword']) && $p_aParams['keyword'] != '') {
$sSecureSearchKeyword = $this->quote('%'. $p_aParams['keyword'] .'%');
$aOrWhere = array(
't.id = ' . $sSecureSearchKeyword,
't.title LIKE ' . $sSecureSearchKeyword,
'ticket_type LIKE ' . $sSecureSearchKeyword,
't.severity LIKE ' . $sSecureSearchKeyword,
't.status LIKE ' . $sSecureSearchKeyword
);
$tickets = $tickets->where(implode(' OR ', $aOrWhere));
}
$tickets = $tickets
->where('t.id = ' . $this->quote($p_aParams['id']))
->order('created desc')
->getList()->fetch();
return $tickets;
*/
}
