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);
}
