public function deleteProcessedMessages($ids)
{
$crit = $this->getCriteria();
$crit->addWhere(self::ID, (array) $ids, B2DBCriteria::DB_IN);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$res = $this->doDelete($crit);
}
public function do_execute()
{
$this->cliEcho("Importing articles ... \n", 'white', 'bold');
TBGEvent::listen('publish', 'fixture_article_loaded', array($this, 'listenPublishFixtureArticleCreated'));
$overwrite = (bool) ($this->getProvidedArgument('overwrite', 'no') == 'yes');
TBGPublish::getModule()->loadFixturesArticles(TBGContext::getScope()->getID(), $overwrite);
}
public function deleteBySearchID($saved_search_id)
{
$crit = $this->getCriteria();
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$crit->addWhere(self::SEARCH_ID, $saved_search_id);
$this->doDelete($crit);
}
public function getAll()
{
$crit = $this->getCriteria();
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$crit->addOrderBy(self::ID, Criteria::SORT_ASC);
return $this->select($crit);
}
public function getByID($id)
{
$crit = $this->getCriteria();
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$row = $this->doSelectById($id, $crit, false);
return $row;
}
public function countTeams()
{
$crit = $this->getCriteria();
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$crit->addWhere(self::ONDEMAND, false);
return $this->doCount($crit);
}
public function quickfind($client_name)
{
$crit = $this->getCriteria();
$crit->addWhere(self::NAME, "%{$client_name}%", Criteria::DB_LIKE);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
return $this->select($crit);
}
public function doesGroupNameExist($group_name)
{
$crit = $this->getCriteria();
$crit->addWhere(self::NAME, $group_name);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
return (bool) $this->doCount($crit);
}
protected function _uninstall()
{
if (TBGContext::getScope()->getID() == 1) {
TBGVCSIntegrationTable::getTable()->drop();
}
parent::_uninstall();
}
public function getByTransitionID($transition_id)
{
$crit = $this->getCriteria();
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$crit->addWhere(self::TRANSITION_ID, $transition_id);
return $this->doSelect($crit);
}
public function countWorkflows($scope = null)
{
$scope = $scope === null ? TBGContext::getScope()->getID() : $scope;
$crit = $this->getCriteria();
$crit->addWhere(self::SCOPE, $scope);
return $this->doCount($crit);
}
public function addStarredArticle($user_id, $article_id)
{
$crit = $this->getCriteria();
$crit->addInsert(self::ARTICLE, $article_id);
$crit->addInsert(self::UID, $user_id);
$crit->addInsert(self::SCOPE, TBGContext::getScope()->getID());
$this->doInsert($crit);
}
public function getAll($scope = null)
{
$scope = $scope === null ? TBGContext::getScope()->getID() : $scope;
$crit = $this->getCriteria();
$crit->addWhere(self::SCOPE, $scope);
$res = $this->doSelect($crit);
return $res;
}
public function removeFriendByUserID($user_id, $friend_id)
{
$crit = $this->getCriteria();
$crit->addWhere(self::UID, $user_id);
$crit->addWhere(self::BID, $friend_id);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$this->doDelete($crit);
}
public function clearDefaultsByEditionID($edition_id)
{
$crit = $this->getCriteria();
$crit->addUpdate(self::IS_DEFAULT, false);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$crit->addWhere(self::EDITION, $edition_id);
$res = $this->doUpdate($crit);
}
public function addStarredIssue($user_id, $issue_id)
{
$crit = $this->getCriteria();
$crit->addInsert(self::ISSUE, $issue_id);
$crit->addInsert(self::UID, $user_id);
$crit->addInsert(self::SCOPE, TBGContext::getScope()->getID());
$this->doInsert($crit);
}
public function removeEditionComponent($edition_id, $component_id)
{
$crit = $this->getCriteria();
$crit->addWhere(self::EDITION, $edition_id);
$crit->addWhere(self::COMPONENT, $component_id);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$res = $this->doDelete($crit);
}
public function getLinkingArticles($linked_article_name)
{
$crit = $this->getCriteria();
$crit->addWhere(self::LINK_ARTICLE_NAME, $linked_article_name);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$res = $this->doSelect($crit);
return $res;
}
public function deleteByIssuetypeID($issuetype_id)
{
$crit = $this->getCriteria();
$crit->addWhere(self::ISSUETYPE_ID, $issuetype_id);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$this->doDelete($crit);
return true;
}
public function disableModuleByName($module_name)
{
$crit = $this->getCriteria();
$crit->addUpdate(self::ENABLED, 0);
$crit->addWhere(self::MODULE_NAME, $module_name);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
return $this->doUpdate($crit);
}
public function addChildIssue($issue_id, $child_id)
{
$crit = $this->getCriteria();
$crit->addInsert(self::PARENT_ID, $issue_id);
$crit->addInsert(self::CHILD_ID, $child_id);
$crit->addInsert(self::SCOPE, TBGContext::getScope()->getID());
$res = $this->doInsert($crit);
return $res;
}
public function addByProjectIDAndMilestoneID($project_id, $milestone_id)
{
$crit = $this->getCriteria();
$crit->addInsert(self::PROJECT_ID, $project_id);
$crit->addInsert(self::MILESTONE_ID, $milestone_id);
$crit->addInsert(self::SCOPE, TBGContext::getScope()->getID());
$res = $this->doInsert($crit);
return true;
}
public function getSubCategories($category_name)
{
$crit = $this->getCriteria();
$crit->addWhere(self::CATEGORY_NAME, $category_name);
$crit->addWhere(self::ARTICLE_IS_CATEGORY, true);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$crit->addOrderBy(self::CATEGORY_NAME, B2DBCriteria::SORT_ASC);
$res = $this->doSelect($crit);
return $res;
}
public function removeByArticleIDandFileID($article_id, $file_id)
{
$crit = $this->getCriteria();
$crit->addWhere(self::ARTICLE_ID, $article_id);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
if ($res = $this->doSelectById($file_id, $crit)) {
$this->doDelete($crit);
}
return $res;
}
public function saveOptionOrder($options, $type)
{
foreach ($options as $key => $option_id) {
$crit = $this->getCriteria();
$crit->addUpdate(self::ORDER, $key + 1);
$crit->addWhere(self::ITEMTYPE, $type);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$this->doUpdateById($crit, $option_id);
}
}
public function createNew($name, $type, $project_id)
{
$crit = $this->getCriteria();
$crit->addInsert(self::NAME, $name);
$crit->addInsert(self::MILESTONE_TYPE, $type);
$crit->addInsert(self::PROJECT, $project_id);
$crit->addInsert(self::SCOPE, TBGContext::getScope()->getID());
$res = $this->doInsert($crit);
return $res->getInsertID();
}
public function getViews($target_id, $target_type)
{
$crit = $this->getCriteria();
$crit->addWhere(self::TID, $target_id);
$crit->addWhere(self::TARGET_TYPE, $target_type);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$crit->addOrderBy(self::ID);
$res = $this->doSelect($crit);
return $res;
}
public function getByIDs($ids)
{
if (empty($ids)) {
return array();
}
$crit = $this->getCriteria();
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$crit->addWhere(self::ID, $ids, Criteria::DB_IN);
return $this->select($crit);
}
public function saveOptionOrder($options, $customfield_id)
{
foreach ($options as $key => $option_id) {
$crit = $this->getCriteria();
$crit->addUpdate(self::SORT_ORDER, $key + 1);
$crit->addWhere(self::CUSTOMFIELD_ID, $customfield_id);
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$this->doUpdateById($crit, $option_id);
}
}
/**
* Return a row for the specified id in the current scope, if defined
*
* @param integer $id
*
* @return \b2db\Row
*/
public function getByID($id)
{
if (defined('static::SCOPE')) {
$crit = $this->getCriteria();
$crit->addWhere(static::SCOPE, TBGContext::getScope()->getID());
$row = $this->doSelectById($id, $crit);
} else {
$row = $this->doSelectById($id);
}
return $row;
}
