public function queryIncompleteByUserId($sort = "id ASC") { $q = Doctrine_Query::Create()->from('Task t')->where('t.user_id = ?', myUser::getLoggedIn()->getId())->andWhere('t.task_status_id <> ?', 3); if ($this->queryWhereClientAccounts($q)) { $q->andWhere('t.task_status_id <> ?', 3); } return $q->orderBy('t.' . $sort); }
public function configure() { $this->unsetTimeStampable(); $this->embedUser(); if (!myUser::getLoggedIn()->isSuperAdmin()) { unset($this['track_record']); } }
public static function getLoggedIn() { $q = Doctrine_Query::create()->from('Staff s')->where('s.user_id = ?', myUser::getLoggedIn()->getId()); return $q; }
$returntype = $field['returntype']; switch ($getter) { case "getCreatedAt": $displaylink = $object->getDateTimeObject('created_at')->format('M d, Y h:i:s a'); break; case "getUpdatedAt": $displaylink = $object->getDateTimeObject('updated_at')->format('M d, Y h:i:s a'); break; default: if (!empty($getter)) { $displaylink = $object->{$getter}(); } } switch ($route) { case 'sfGuardUser': $route = myUser::getLoggedIn()->getUserType(); break; } if (!empty($getter)) { if (is_object($object->{$getter}())) { $id = $object->{$getter}()->getId(); } else { if ($returntype == "bool") { $id = $object->getId(); $postfix = $displaylink ? "true" : "false"; $displaylink = '<div id="bool_' . $postfix . '"></div>'; } else { $id = $object->getId(); } } echo link_to($displaylink, $route . '/show?id=' . $id);
public function isEntitled() { return Doctrine_Query::Create()->from('Task t')->where('t.created_by = ?', myUser::getLoggedIn()->getId())->andWhere('t.id = ?', $this->getId())->orWhere('t.user_id = ?', myUser::getLoggedIn()->getId())->andWhere('t.id = ?', $this->getId())->limit(1)->fetchOne(); }
public function queryAllByAccountId($sort) { $account_ids = myUser::getLoggedIn()->isClient()->getAccountIds(); return Doctrine_Query::Create()->from('AccountInvoice ai')->whereIn('ai.account_id', $account_ids)->orderBy('ai.' . $sort); }
public function queryAllByUserId($sort) { return Doctrine_Query::Create()->from('Account a')->where('a.client_id = ?', myUser::getLoggedIn()->isClient()->getId())->orderBy('a.' . $sort); }