/**
* @expectedException \Exception
*/
public function testGetFolderPartialQueryWithInvalidParamCount()
{
$uploadBrowseProxy = new UploadBrowseProxy($this->groupId, UserDao::USER, $this->testDb->getDbManager());
$params = array();
$uploadBrowseProxy->getFolderPartialQuery($params);
}
/**
* @param Request $request
* @return array
*/
private function getListOfUploadsOfFolder(Request $request)
{
$uploadBrowseProxy = new UploadBrowseProxy(Auth::getGroupId(), $this->userPerm, $this->dbManager);
$params = array($request->get('folder'));
$partQuery = $uploadBrowseProxy->getFolderPartialQuery($params);
$iTotalRecordsRow = $this->dbManager->getSingleRow("SELECT count(*) FROM {$partQuery}", $params, __METHOD__ . "count.all");
$iTotalRecords = $iTotalRecordsRow['count'];
$this->filterParams = $params;
$filter = $this->getSearchString($request->get('sSearch'));
$filter .= $this->getIntegerFilter(intval($request->get('assigneeSelected')), 'assignee');
$filter .= $this->getIntegerFilter(intval($request->get('statusSelected')), 'status_fk');
$iTotalDisplayRecordsRow = $this->dbManager->getSingleRow("SELECT count(*) FROM {$partQuery} {$filter}", $this->filterParams, __METHOD__ . ".count." . $filter);
$iTotalDisplayRecords = $iTotalDisplayRecordsRow['count'];
$orderString = $this->getOrderString();
$stmt = __METHOD__ . "getFolderContents" . $orderString . $filter;
$statementString = "SELECT upload.*,upload_clearing.*,uploadtree.ufile_name,uploadtree.ufile_mode,uploadtree.uploadtree_pk" . " FROM {$partQuery} {$filter} {$orderString}";
$rangedFilterParams = $this->filterParams;
$rangedFilterParams[] = intval($request->get('iDisplayStart'));
$statementString .= ' OFFSET $' . count($rangedFilterParams);
$rangedFilterParams[] = intval($request->get('iDisplayLength'));
$statementString .= ' LIMIT $' . count($rangedFilterParams);
$this->dbManager->prepare($stmt, $statementString);
$result = $this->dbManager->execute($stmt, $rangedFilterParams);
return array($result, $iTotalDisplayRecords, $iTotalRecords);
}
