label = $sLabel; $this->name = $sName; } // FIXME is it _really_ worth using a template here? function renderHeader($sReturnURL) { $text = _kt("Abstract") . ": " . $this->label; $href = $sReturnURL . "&sort_on=" . $this->name . "&sort_order="; if ($this->sort_on) { $href .= $this->sort_direction == "asc" ? "desc" : "asc" ; } else { $href .= $this->sort_direction = "asc"; } return ''.$text.''; } function renderData($aDataRow) { if ($aDataRow["type"] == "folder") { return $this->name . ": ". print_r($aDataRow["folder"]->getName(), true); } else { return $this->name . ": ". print_r($aDataRow["document"]->getName(), true); } } function setSortedOn($bIsSortedOn) { $this->sort_on = $bIsSortedOn; } function getSortedOn() { return $this->sort_on; } function setSortDirection($sSortDirection) { $this->sort_direction = $sSortDirection; } function getSortDirection() { return $this->sort_direction; } function addToFolderQuery() { return array(null, null, null); } function addToDocumentQuery() { return array(null, null, null); } } class TitleColumn extends BrowseColumn { var $aOptions = array(); var $aIconPaths = array(); function setOptions($aOptions) { $this->aOptions = $aOptions; } // unlike others, this DOESN'T give its name. function renderHeader($sReturnURL) { $text = _kt("Title"); $href = $sReturnURL . "&sort_on=" . $this->name . "&sort_order="; if ($this->sort_on) { $href .= $this->sort_direction == "asc" ? "desc" : "asc" ; } else { $href .= $this->sort_direction = "asc"; } return ''.$text.''; } function renderFolderLink($aDataRow) { $outStr = ''; $outStr .= $aDataRow["folder"]->getName(); $outStr .= ' '; return $outStr; } function renderDocumentLink($aDataRow) { $outStr = 'getFilename().'">'; $outStr .= $aDataRow["document"]->getName(); $outStr .= ''; return $outStr; } function buildDocumentLink($aDataRow) { return KTBrowseUtil::getUrlForDocument($aDataRow["document"]->getId()); } function buildFolderLink($aDataRow) { return KTUtil::addQueryStringSelf('fFolderId='.$aDataRow["folder"]->getId()); } // use inline, since its just too heavy to even _think_ about using smarty. function renderData($aDataRow) { $outStr = ''; if ($aDataRow["type"] == "folder") { $outStr .= ''; $outStr .= $this->renderFolderLink($aDataRow); $outStr .= ''; } else { $outStr .= 'getMimeTypeId()).'">'; $outStr .= $this->renderDocumentLink($aDataRow); $outStr .= ' (' . $this->prettySize($aDataRow["document"]->getSize()) . ')'; $outStr .= ''; } return $outStr; } function prettySize($size) { $finalSize = $size; $label = 'b'; if ($finalSize > 1000) { $label='Kb'; $finalSize = floor($finalSize/1000); } if ($finalSize > 1000) { $label='Mb'; $finalSize = floor($finalSize/1000); } return $finalSize . $label; } function _mimeHelper($iMimeTypeId) { return KTMime::getIconPath($iMimeTypeId); } } class DateColumn extends BrowseColumn { var $field_function; // $sDocumentFieldFunction is _called_ on the document. function DateColumn($sLabel, $sName, $sDocumentFieldFunction) { $this->field_function = $sDocumentFieldFunction; parent::BrowseColumn($sLabel, $sName); } function renderHeader($sReturnURL) { $text = $this->label; $href = $sReturnURL . "&sort_on=" . $this->name . "&sort_order="; if ($this->sort_on) { $href .= $this->sort_direction == "asc" ? "desc" : "asc" ; } else { $href .= $this->sort_direction = "asc"; } return ''.$text.''; } // use inline, since its just too heavy to even _think_ about using smarty. function renderData($aDataRow) { $outStr = ''; if ($aDataRow["type"] == "folder") { $outStr = ' '; // no-op on folders. } else { $fn = $this->field_function; $dColumnDate = strtotime($aDataRow["document"]->$fn()); // now reformat this into something "pretty" $outStr = date("d M, Y H\\hi", $dColumnDate); } return $outStr; } function _mimeHelper($iMimeTypeId) { // FIXME lazy cache this. $sQuery = 'SELECT icon_path FROM mime_types WHERE id = ?'; $res = DBUtil::getOneResult(array($sQuery, array($iMimeTypeId))); if ($res[0] !== null) { return $res[0]; } else { return 'unspecified_type'; } } function addToFolderQuery() { return array(null, null, null); } function addToDocumentQuery() { return array(null, null, $this->name); } } class UserColumn extends BrowseColumn { var $field_function; // $sDocumentFieldFunction is _called_ on the document. function UserColumn($sLabel, $sName, $sDocumentFieldFunction) { $this->field_function = $sDocumentFieldFunction; parent::BrowseColumn($sLabel, $sName); } function renderHeader($sReturnURL) { $text = $this->label; $href = $sReturnURL . "&sort_on=" . $this->name . "&sort_order="; if ($this->sort_on) { $href .= $this->sort_direction == "asc" ? "desc" : "asc" ; } else { $href .= $this->sort_direction = "asc"; } return ''.$text.''; } // use inline, since its just too heavy to even _think_ about using smarty. function renderData($aDataRow) { $outStr = ''; $fn = $this->field_function; $iUserId = null; if ($aDataRow["type"] == "folder") { if (method_exists($aDataRow['folder'], $fn)) { $iUserId = $aDataRow['folder']->$fn(); // FIXME this should check if the function exists first. } } else { if (true) {//(method_exists($aDataRow['document'], $fn)) { $iUserId = $aDataRow['document']->$fn(); // FIXME this should check if the function exists first. } } $oUser = User::get($iUserId); if (PEAR::isError($oUser) || $oUser == false) { $outStr = ' '; } else { $outStr = $oUser->getName(); } return $outStr; } function addToFolderQuery() { return array(null, null, null); } function addToDocumentQuery() { $sUsersTable = KTUtil::getTableName('users'); $sJoinSQL = "LEFT JOIN $sUsersTable AS users_order_join ON D.{$this->name} = users_order_join.id"; return array($sJoinSQL, null, "users_order_join.name"); } } // use the _name_ parameter + _f_ + id to create a non-clashing checkbox. class SelectionColumn extends BrowseColumn { var $show_documents; var $show_folders; function SelectionColumn ($sLabel, $sName, $bShowFolders = true, $bShowDocs = true) { $this->show_documents = $bShowDocs; $this->show_folders = $bShowFolders; parent::BrowseColumn($sLabel, $sName); } function renderHeader($sReturnURL) { // FIXME clean up access to oPage. global $main; $main->requireJSResource("resources/js/toggleselect.js"); return ''; } // only include the _f or _d IF WE HAVE THE OTHER TYPE. function renderData($aDataRow) { $localname = $this->name; if (($aDataRow["type"] === "folder") && ($this->show_folders)) { if ($this->show_documents) { $localname .= "_f[]"; } $v = $aDataRow["folderid"]; } else if (($aDataRow["type"] === "document") && $this->show_documents) { if ($this->show_folders) { $localname .= "_d[]"; } $v = $aDataRow["docid"]; } else { return ' '; } return ''; } } class SingleSelectionColumn extends SelectionColumn { var $show_documents; var $show_folders; function SelectionColumn ($sLabel, $sName, $bShowFolders = true, $bShowDocs = true) { $this->show_documents = $bShowDocs; $this->show_folders = $bShowFolders; parent::BrowseColumn($sLabel, $sName); } function renderHeader($sReturnURL) { global $main; } // only include the _f or _d IF WE HAVE THE OTHER TYPE. function renderData($aDataRow) { $localname = $this->name; if (($aDataRow["type"] === "folder") && ($this->show_folders)) { if ($this->show_documents) { $localname .= "_f"; } $v = $aDataRow["folderid"]; } else if (($aDataRow["type"] === "document") && $this->show_documents) { if ($this->show_folders) { $localname .= "_d"; } $v = $aDataRow["docid"]; } else { return ' '; } return ''; } } class WorkflowColumn extends BrowseColumn { function renderHeader($sReturnURL) { $text = $this->label; $href = $sReturnURL . "&sort_on=" . $this->name . "&sort_order="; if ($this->sort_on) { $href .= $this->sort_direction == "asc" ? "desc" : "asc" ; } else { $href .= $this->sort_direction = "asc"; } return ''.$text.''; } // use inline, since its just too heavy to even _think_ about using smarty. function renderData($aDataRow) { $localname = $this->name; // only _ever_ show this folder documents. if ($aDataRow["type"] === "folder") { return ' '; } $oWorkflow = KTWorkflowUtil::getWorkflowForDocument($aDataRow['document']); $oState = KTWorkflowUtil::getWorkflowStateForDocument($aDataRow['document']); if (($oState == null) || ($oWorkflow == null)) { return '—'; } else { return $oState->getName() . ' (' . $oWorkflow->getName() . ')'; } } function addToDocumentQuery() { $sWorkflowStateTable = KTUtil::getTableName('workflow_states'); $sWorkflowDocumentsTable = KTUtil::getTableName('workflow_documents'); $sJoinSQL = "LEFT JOIN $sWorkflowDocumentsTable AS WDOJ ON D.id = WDOJ.document_id LEFT JOIN $sWorkflowStateTable AS state_order_join ON WDOJ.state_id = state_order_join.id"; return array($sJoinSQL, null, "COALESCE(state_order_join.name, 'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz')"); // XXX: There must be a better way? } } class DownloadColumn extends BrowseColumn { function renderHeader($sReturnURL) { $text = ' '; return $text; } function renderData($aDataRow) { $localname = $this->name; // only _ever_ show this folder documents. if ($aDataRow["type"] === "folder") { return ' '; } // FIXME at some point we may want to hide this if the user doens't have the download action, but its OK for now. $link = KTUtil::ktLink('action.php','ktcore.actions.document.view', 'fDocumentId=' . $aDataRow['document']->getId()); $outStr = sprintf('%s', $link, _kt('Download Document'), _kt('Download Document')); return $outStr; } } ?>