public static function getSourceStages()
{
//get db
$db = \Cobalt\Container::fetch('db');
$query = $db->getQuery(true);
//query
$query->select("*");
$query->from("#__stages");
//filter by active and closed stages
$inactive_stage_ids = DealHelper::getInactiveStages();
$query->where("id NOT IN(" . implode(',', $inactive_stage_ids) . ")");
$query->order('ordering');
//merge arrays
$base = array('all' => 'all stages', 'active' => 'active stages');
$db->setQuery($query);
$results = $db->loadAssocList();
$stages = array();
if (count($results) > 0) {
foreach ($results as $key => $stage) {
$stages[$stage['id']] = $stage['name'];
}
}
return $base + $stages;
}