/** * @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); }