/** * Gets the top most content of the container * @return ContainerContent The first and root container content */ function TopMost() { $sql = Access::SqlBuilder(); $tbl = ContainerContent::Schema()->Table(); $where = $sql->Equals($tbl->Field('Container'), $sql->Value($this->container->GetID()))->And_($sql->IsNull($tbl->Field('Parent')))->And_($sql->IsNull($tbl->Field('Previous'))); return ContainerContent::Schema()->First($where); }
/** * The edit/create url base parameters * @return array Returns the parameters for creating/editing */ protected function EditParams() { $params = array(); $params['container'] = $this->container->GetID(); return $params; }
protected function CreateFormUrl() { $args = array('container' => $this->container->GetID()); return BackendRouter::ModuleUrl(new ModuleForm(), $args); }
/** * The url to the content tree of the container * @param Container $container * @return string */ protected function ContentTreeUrl(Container $container) { return BackendRouter::ModuleUrl(new ContainerContentTree(), array('container' => $container->GetID())); }
/** * The last log item that is directly related to the container * @param Container $container The container * @return LogItem Returns the log item */ static function LastContainerLog(Container $container) { $tblLogContainer = LogContainer::Schema()->Table(); $tblLogItem = LogItem::Schema()->Table(); $sql = Access::SqlBuilder(); $orderBy = $sql->OrderList($sql->OrderDesc($tblLogItem->Field('Changed'))); $joinCond = $sql->Equals($tblLogContainer->Field('LogItem'), $tblLogItem->Field('ID')); $where = $sql->Equals($tblLogContainer->Field('Container'), $sql->Value($container->GetID())); return LogItem::Schema()->First($where, $orderBy, null, $sql->Join($tblLogContainer), JoinType::Inner(), $joinCond); }