public static function getAll($unFiltered = true)
{
$db = Globals::getDBConn();
$select = $db->select()->from('session')->order('start DESC');
if ($unFiltered == false) {
$select->where('deleted != 1');
}
$rows = $select->query()->fetchAll();
$sessions = array();
foreach ($rows as $row) {
$sessions[] = new SessionModel($row['id']);
}
return $sessions;
}
public function indexAction()
{
$db = Globals::getDBConn();
$json = Zend_Filter::filterStatic($this->getRequest()->getParam('json'), 'StripTags');
// If the server's magic quotes setting is enabled
if (get_magic_quotes_gpc()) {
$json = Zend_Filter::filterStatic(stripslashes($this->getRequest()->getParam('json')), 'StripTags');
}
$sync = new SyncModel();
if ($sync->commit($json)) {
$this->view->result = true;
} else {
$this->view->result = false;
$this->view->error = $sync->getError();
}
}
public function updateloctreeAction()
{
$locTree = json_decode(Zend_Filter::filterStatic($this->getRequest()->getParam('loc_tree'), 'StripTags'), true);
if (!$locTree) {
$this->view->error = 'Problem parsing tree';
Globals::getLog()->err('ADMIN update location tree error: ' . $this->view->error);
$this->render('error-xhr');
return false;
}
try {
$db = Globals::getDBConn();
$db->beginTransaction();
LocationModel::updateLocTree($locTree);
$db->commit();
} catch (Exception $e) {
$db->rollBack();
$this->view->error = $e->getMessage();
Globals::getLog()->err('ADMIN update location tree error: ' . $this->view->error);
$this->render('error-xhr');
return false;
}
return true;
}
public static function updateActivitiesArray($activities, $initID = null)
{
if (!$initID || !$activities || !is_array($activities) || !is_numeric($initID)) {
throw new Exception('Invalid data structure');
}
try {
$db = Globals::getDBConn();
$db->beginTransaction();
foreach ($activities as $actGroupKey => $activityGroup) {
if (isset($activityGroup['title']) && strlen($activityGroup['title']) > 0 && isset($activityGroup['id']) && isset($activityGroup['desc']) && isset($activityGroup['required']) && isset($activityGroup['allowMulti'])) {
$actGroupData = array('title' => $activityGroup['title'], 'desc' => $activityGroup['desc'], 'rank' => $actGroupKey, 'required' => (int) $activityGroup['required'], 'allowMulti' => (int) $activityGroup['allowMulti']);
if (is_numeric($activityGroup['id'])) {
$activityGroupObj = new ActivityGroupModel($activityGroup['id']);
if (!$activityGroupObj) {
throw new Exception('Failed to retrieve activity group');
}
$activityGroupObj->update($actGroupData);
$activityGroupID = $activityGroupObj->getMetadata('id');
} else {
if ('new-act-group' === $activityGroup['id']) {
$actGroupData['init'] = $initID;
$activityGroupID = ActivityGroupModel::create($actGroupData);
if (false === $activityGroupID) {
throw new Exception('Failed to create activity group');
}
} else {
throw new Exception('Invalid activity group ID');
}
}
foreach ($activityGroup['activities'] as $actKey => $activity) {
if (isset($activity['title']) && strlen($activity['title']) > 0 && isset($activity['id']) && isset($activity['desc']) && isset($activity['enabled'])) {
$actData = array('title' => $activity['title'], 'desc' => $activity['desc'], 'enabled' => (int) $activity['enabled'], 'group' => $activityGroupID, 'rank' => $actKey);
if (is_numeric($activity['id'])) {
$activityObj = new ActivityModel($activity['id']);
if (!$activityObj) {
throw new Exception('Failed to retrieve activity');
}
$activityObj->update($actData);
} else {
if ('new-act' === $activity['id']) {
//$actData['init'] = $initID;
$activityID = self::create($actData);
if (false === $activityID) {
throw new Exception('Failed to create activity');
}
} else {
throw new Exception('Invalid activity ID');
}
}
} else {
throw new Exception('Missing required activity fields (title, ID, enabled, or desc)');
}
}
} else {
throw new Exception('Missing required activity group fields (title, ID, required, allowMulti, or desc)');
}
}
$db->commit();
} catch (Exception $e) {
$db->rollBack();
throw $e;
}
return true;
}
private function uniqueSessionCheck($start, $end, $counts, $initId)
{
$db = Globals::getDBConn();
$select = $db->select()->from('session')->where('start = \'' . $start . '\' AND end = \'' . $end . '\' AND fk_initiative = ' . $initId);
$sessions = $select->query()->fetchAll();
foreach ($sessions as $session) {
if (is_numeric($session['id'])) {
$select = $db->select()->from('count')->where('fk_session = ' . $session['id']);
if ($counts == count($select->query()->fetchAll())) {
return false;
}
}
}
return true;
}
static function getInitiatives()
{
$db = Globals::getDBConn();
$select = $db->select()->from(array('i' => 'initiative'), array('title', 'id', 'description', 'enabled', 'rootLocation' => 'fk_root_location'))->join(array('s' => 'session'), 'i.id = s.fk_initiative', array())->where('s.deleted = 0')->group('i.id')->order(array('i.title ASC'));
$initiatives = $select->query()->fetchAll();
// This block is to cast string id into an int
$parentArray = array();
foreach ($initiatives as $init) {
$array = array();
foreach ($init as $key => $val) {
if ($key === 'id' || $key === 'rootLocation') {
$array[$key] = (int) $val;
} elseif ($key === 'enabled') {
$array[$key] = (bool) $val;
} else {
$array[$key] = $val;
}
}
$qModel = new QueryModel($array['id']);
$array['dictionary']['locations'] = $qModel->getInitLocs();
$array['dictionary']['activities'] = $qModel->getInitActs();
$array['dictionary']['activityGroups'] = $qModel->getInitActGroups();
$parentArray[] = $array;
}
return $parentArray;
}
public static function getLocTreeRoots($filterDisabled = false)
{
$db = Globals::getDBConn();
$select = $db->select()->from('location');
if ($filterDisabled) {
$select->where('enabled = 1 AND fk_parent IS NULL');
} else {
$select->where('fk_parent IS NULL');
}
$rows = $select->order('title ASC')->query()->fetchAll();
$roots = array();
foreach ($rows as $row) {
$roots[] = new LocationModel($row['id']);
}
return $roots;
}
public static function create($data)
{
$db = Globals::getDBConn();
$hash = array('title' => isset($data['title']) ? $data['title'] : 'Default', 'rank' => isset($data['rank']) ? $data['rank'] : 1, 'description' => isset($data['descr']) ? $data['descr'] : null, 'required' => isset($data['required']) ? (int) $data['required'] : 0, 'allowMulti' => isset($data['allowMulti']) ? (int) $data['allowMulti'] : 1, 'fk_initiative' => $data['init']);
$select = $db->select()->from('activity_group')->where('fk_initiative = ' . $hash['fk_initiative'] . ' AND LOWER(title) = ' . $db->quote(strtolower($hash['title'])));
$existingActivityGroup = $select->query()->fetch();
if (empty($existingActivityGroup)) {
$db->insert('activity_group', $hash);
$actGrpId = $db->lastInsertId();
Globals::getLog()->info('ACTIVITY GROUP CREATED - id: ' . $actGrpId . ', title: ' . $data['title'] . ', init: ' . $data['init']);
} else {
$errStr = 'DUPLICATE ACTIVITY GROUP CREATION DENIED - title: ' . $data['title'];
Globals::getLog()->warn($errStr);
throw new Exception($errStr);
}
return $actGrpId;
}
public static function getAll($filterDisabled = false)
{
$db = Globals::getDBConn();
$select = $db->select()->from('initiative');
if ($filterDisabled) {
$select->where('enabled = 1');
}
$rows = $select->order('title ASC')->query()->fetchAll();
$inits = array();
foreach ($rows as $row) {
$inits[] = new InitiativeModel($row['id']);
}
return $inits;
}
