/**
*
* @param string(32) $folderID
* @return multitype:
*/
public function getFolderList($folderID, $limit = 0, $start = 0)
{
$Criteria = new Criteria('workflow');
$Criteria->clearSelectColumns()->clearOrderByColumns();
$Criteria->addSelectColumn(AppFolderPeer::FOLDER_UID);
$Criteria->addSelectColumn(AppFolderPeer::FOLDER_PARENT_UID);
$Criteria->addSelectColumn(AppFolderPeer::FOLDER_NAME);
$Criteria->addSelectColumn(AppFolderPeer::FOLDER_CREATE_DATE);
$Criteria->addSelectColumn(AppFolderPeer::FOLDER_UPDATE_DATE);
$Criteria->add(appFolderPeer::FOLDER_PARENT_UID, $folderID, CRITERIA::EQUAL);
$Criteria->addAscendingOrderByColumn(AppFolderPeer::FOLDER_NAME);
$response['folders'] = array();
if ($limit != 0) {
$Criteria->setLimit($limit);
$Criteria->setOffset($start);
}
$rs = appFolderPeer::doSelectRS($Criteria);
$rs->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$rs->next();
$folderResult = array();
while (is_array($row = $rs->getRow())) {
$response['folders'][] = $row;
$rs->next();
}
$response['totalFoldersCount'] = count($response['folders']);
return $response;
}
/**
*
* @param string(32) $folderID
* @return multitype:
*/
public function getFolderList ($folderID, $limit = 0, $start = 0, $direction = 'ASC', $sort = "appDocCreateDate", $search = null)
{
$Criteria = new Criteria( 'workflow' );
$Criteria->clearSelectColumns()->clearOrderByColumns();
$Criteria->addSelectColumn( AppFolderPeer::FOLDER_UID );
$Criteria->addSelectColumn( AppFolderPeer::FOLDER_PARENT_UID );
$Criteria->addSelectColumn( AppFolderPeer::FOLDER_NAME );
$Criteria->addSelectColumn( AppFolderPeer::FOLDER_CREATE_DATE );
$Criteria->addSelectColumn( AppFolderPeer::FOLDER_UPDATE_DATE );
$Criteria->add( appFolderPeer::FOLDER_PARENT_UID, $folderID, CRITERIA::EQUAL );
if ($search) {
$Criteria->add(
$Criteria->getNewCriterion( AppFolderPeer::FOLDER_NAME, '%' . $search . '%', Criteria::LIKE )
);
}
switch($sort) {
case 'appDocCreateDate' :
$ColumnSort = AppFolderPeer::FOLDER_CREATE_DATE;
break;
case 'name' :
$ColumnSort = AppFolderPeer::FOLDER_NAME;
break;
default:
break;
}
if($direction == 'ASC') {
$Criteria->addAscendingOrderByColumn( $ColumnSort );
} else {
$Criteria->addDescendingOrderByColumn( $ColumnSort );
}
$response['folders'] = array ();
if ($limit != 0) {
$Criteria->setLimit( $limit );
$Criteria->setOffset( $start );
}
$rs = appFolderPeer::doSelectRS( $Criteria );
$rs->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$rs->next();
$folderResult = array ();
while (is_array( $row = $rs->getRow() )) {
$response['folders'][] = $row;
$rs->next();
}
$response['totalFoldersCount'] = count($response['folders']);
return ($response);
}
function findChilds($uidFolder, $path, $arrayPath)
{
$Criteria = new Criteria ();
$Criteria->addSelectColumn ( AppFolderPeer::FOLDER_UID );
$Criteria->addSelectColumn ( AppFolderPeer::FOLDER_PARENT_UID );
$Criteria->addSelectColumn ( AppFolderPeer::FOLDER_NAME );
$Criteria->addSelectColumn ( AppFolderPeer::FOLDER_CREATE_DATE );
$Criteria->addSelectColumn ( AppFolderPeer::FOLDER_UPDATE_DATE );
$Criteria->add(AppFolderPeer::FOLDER_PARENT_UID, $uidFolder);
$Criteria->addAscendingOrderByColumn(AppFolderPeer::FOLDER_NAME);
$rs = appFolderPeer::doSelectRS ( $Criteria );
$rs->setFetchmode ( ResultSet::FETCHMODE_ASSOC );
$folderResult = array ();
$appFoder = new AppFolder ();
while ($rs->next()) {
$row = $rs->getRow();
$path = ($uidFolder != '/')? $path : '';
$path = $path."/".$row['FOLDER_NAME'];
$arrayPath[] = array($row['FOLDER_UID'],$path);
$arrayPath = findChilds($row['FOLDER_UID'], $path, $arrayPath);
}
return $arrayPath;
}
