public function __construct(AM_Controller_Action $oActionController, $iClientId)
{
$iClientId = intval($iClientId);
$aUser = $oActionController->getUser();
$oQuery = $oActionController->oDb->select()->from('application')->joinLeft(array('issue2' => 'issue'), 'issue2.application = application.id AND issue2.deleted = "no" ', null)->joinLeft(array('issue_user' => 'user'), 'issue2.user = issue_user.id ' . $oActionController->oDb->quoteInto('AND issue_user.client = ?', $aUser['client']), null)->joinLeft(array('issue1' => 'issue'), 'application.id = issue1.application AND issue1.deleted = "no" ' . $oActionController->oDb->quoteInto('AND issue1.state = ?', AM_Model_Db_State::STATE_PUBLISHED), null)->joinLeft('revision', 'revision.issue = issue1.id AND revision.deleted = "no" ' . $oActionController->oDb->quoteInto('AND revision.state = ?', AM_Model_Db_State::STATE_PUBLISHED), null)->where('application.deleted = ?', 'no')->where('application.client = ?', $iClientId)->group('application.id')->columns(array('published_revision' => 'revision.id', 'issue_count' => new Zend_Db_Expr('COUNT(DISTINCT(issue2.id))')));
parent::__construct($oActionController, 'grid', $oActionController->oDb, $oQuery, 'application.title', array(), 4, 'subselect');
}
public function __construct(AM_Controller_Action $oActionController, $sName, $iIssueId, $iApplicationId)
{
$this->applicationId = $iApplicationId;
$aControls = array();
$aUser = $oActionController->getUser();
if (!$iIssueId) {
$aControls[] = new Volcano_Component_Control_Database_Static($oActionController, 'user', $aUser['id']);
}
return parent::__construct($oActionController, $sName, $aControls, $oActionController->oDb, 'issue', 'id', $iIssueId);
}
/**
* @param AM_Controller_Action $oActionController
* @param int $iApplicationId
*/
public function __construct(AM_Controller_Action $oActionController, $iApplicationId)
{
$iApplicationId = intval($iApplicationId);
$aUser = $oActionController->getUser();
$sUserRole = $aUser['role'];
$oQuery = $oActionController->oDb->select()->from('issue', null)->join('application', 'application.id = issue.application', null)->join('state', 'issue.state = state.id', null)->join('user', 'user.id = issue.user', null)->joinLeft('revision', $oActionController->oDb->quoteInto('revision.issue = issue.id AND revision.deleted = ?', 'no'), null)->joinLeft(array('revision1' => 'revision'), 'revision1.issue = issue.id' . $oActionController->oDb->quoteInto(' AND revision1.state = ?', AM_Model_Db_State::STATE_PUBLISHED) . $oActionController->oDb->quoteInto(' AND revision1.deleted = ?', 'no'), null)->where('application.id = ?', $iApplicationId)->where('application.deleted = ?', 'no')->where('issue.deleted = ?', 'no')->where('user.deleted = ?', 'no')->group(array('issue.id'))->columns(array('id' => 'issue.id', 'title' => 'issue.title', 'number' => 'issue.number', 'client' => 'application.client', 'state' => 'state.title', 'last_revision' => 'MAX(revision.id)', 'published_revision' => 'revision1.id', 'created' => 'DATE_FORMAT(issue.created, "%e/%c/%Y")', 'updated_date' => 'DATE_FORMAT(issue.updated, "%e/%c/%Y")', 'updated_time' => 'DATE_FORMAT(issue.updated, "%Hh%i")', 'release_date' => 'DATE_FORMAT(issue.release_date, "%e/%c/%Y at %Hh%i")', 'release_date_ts' => 'UNIX_TIMESTAMP(issue.release_date)', 'creator_full_name' => 'CONCAT(user.first_name, " ", user.last_name)', 'creator_login' => 'user.login', 'creator_uid' => 'user.id', 'creator_role' => 'IF(user.is_admin, "admin", "user")', 'application_id' => 'application.id'));
if ("admin" != $sUserRole) {
$oQuery->where('user.client = application.client');
}
parent::__construct($oActionController, 'grid', $oActionController->oDb, $oQuery, 'issue.updated DESC', null, 4, 'subselect');
}
/**
*
* @param AM_Controller_Action $oActionController
* @param string $sName
* @param int $iRevisionId
* @param int $iIssueId
* @return void
*/
public function __construct(AM_Controller_Action $oActionController, $sName, $iRevisionId, $iIssueId)
{
$this->user = $oActionController->getUser();
$aControls = array();
$aControls[] = new Volcano_Component_Control_Database($oActionController, 'title', 'Title', array(array('require')), 'title');
$aControls[] = new Volcano_Component_Control_Database($oActionController, 'state', 'State', null, 'state');
$aControls[] = new Volcano_Component_Control($oActionController, 'copy_from', 'Copy from', array(array('integer')));
$aControls[] = new Volcano_Component_Control_Database_Static($oActionController, 'issue', $iIssueId);
$aControls[] = new Volcano_Component_Control_Database_Static($oActionController, 'updated', new Zend_Db_Expr('NOW()'));
if (!$iRevisionId) {
$aControls[] = new Volcano_Component_Control_Database_Static($oActionController, 'user', $this->user['id']);
}
return parent::__construct($oActionController, $sName, $aControls, $oActionController->oDb, $sName, 'id', $iRevisionId);
}