function listusers() { $paginationDto = new PaginationDto(); try { $currentPage = $this->input->post("page"); $recordsPerPage = $this->input->post("recordsPerPage"); $searchString = $this->input->post("searchString"); $paginationDto->setTotalNoOfRecords($this->getTotalCountFor("User")); $paginationDto->setCurrentPage($currentPage); $users = $this->listUserForPagination($currentPage, $recordsPerPage, $searchString); $rows = array(); $srNo = 1; foreach ($users as $user) { $divisionName = " NA "; $subDivisionName = " NA "; if ($user->getSubdivision() != null) { $subDivisionName = $user->getSubdivision()->getName(); if ($user->getSubdivision()->getDivision() != null) { $divisionName = $user->getSubdivision()->getDivision()->getName(); } } $row = array($srNo++, $user->getFirstName() . " " . $user->getLastName(), $user->getEmail(), $divisionName, $subDivisionName, "true"); array_push($rows, $row); } $paginationDto->setRows($rows); } catch (Exception $e) { echo $e->getMessage(); } $this->output->set_content_type('application/json')->set_output(json_encode($paginationDto)); }
function listContractor() { $paginationDto = new PaginationDto(); try { $currentPage = $this->input->post("page"); $recordsPerPage = $this->input->post("recordsPerPage"); $searchString = $this->input->post("searchString"); $paginationDto->setTotalNoOfRecords($this->getTotalCountFor("Contractor")); $paginationDto->setCurrentPage($currentPage); $contractors = $this->listContractorForPagination($currentPage, $recordsPerPage, $searchString); $rows = array(); $srNo = 1; foreach ($contractors as $contractor) { $row = array($srNo++, $contractor->getFirstName() . " " . $contractor->getLastName(), $contractor->getEmail(), $contractor->getPhone(), $contractor->getId()); array_push($rows, $row); } $paginationDto->setRows($rows); } catch (Exception $e) { echo $e->getMessage(); } $this->output->set_content_type('application/json')->set_output(json_encode($paginationDto)); }
function listsanctionprojects() { $paginationDto = new PaginationDto(); try { $currentPage = $this->input->post("page"); $recordsPerPage = $this->input->post("recordsPerPage"); $searchString = $this->input->post("searchString"); $projectType = $this->input->post("type"); $paginationDto->setTotalNoOfRecords($this->countProjectsForPagination($searchString, $projectType)); $paginationDto->setCurrentPage($currentPage); $projects = $this->listProjectsForPagination($currentPage, $recordsPerPage, $searchString, $projectType); $rows = array(); $srNo = 1; foreach ($projects as $project) { $divisionName = " NA "; $date = date_format($project->getCreated(), "d-M-Y"); if ($project->getSubDivision() != null) { $subdivisionName = $project->getSubDivision()->getName(); $divisionName = $project->getSubDivision()->getDivision()->getName(); } $row = array($srNo, $date, $project->getName(), $divisionName, $subdivisionName, $project->getBudget(), $project->getId()); if ($projectType == Project::PROJECT_TENDER) { $documentName = ""; if ($project->getTechnicalSanction()->getSanctionDoc() != null) { foreach ($project->getTechnicalSanction()->getSanctionDoc() as $doc) { $documentName .= $doc->getName() . ","; } } $row = array($srNo, $date, $project->getName(), $divisionName, $subdivisionName, $project->getTechnicalSanction()->getSanctionedAmount(), $documentName, $project->getId()); } if ($projectType == Project::PROJECT_WORK_ORDER) { $documentName = ""; if ($project->getTechnicalSanction()->getSanctionDoc() != null) { foreach ($project->getTechnicalSanction()->getSanctionDoc() as $doc) { $documentName .= $doc->getName() . ","; } } $contractorName = ""; if ($project->getTenderApproval()->getContractor() != null) { $contractor = $project->getTenderApproval()->getContractor(); $contractorName = $contractor->getFirstName() . " " . $contractor->getLastName(); } $row = array($srNo, $date, $project->getName(), $subdivisionName, $contractorName, $documentName, $project->getWorkOrder()->getStatus(), $project->getId()); } if ($projectType == Project::PROJECT_BILL) { $documentName = ""; if ($project->getBill()->getBillDoc() != null) { foreach ($project->getBill()->getBillDoc() as $doc) { $documentName .= $doc->getName() . ","; } } $row = array($srNo, $date, $project->getName(), $subdivisionName, $project->getWorkOrder()->getApprovedBy()->getName(), $documentName, $project->getBill()->getStatus(), $project->getId()); } if ($projectType == Project::PROJECT_COMPLETED) { $documentName = ""; if ($project->getBill()->getBillDoc() != null) { foreach ($project->getBill()->getBillDoc() as $doc) { $documentName .= $doc->getName() . ","; } } $row = array($srNo, $date, $project->getName(), $subdivisionName, $project->getBill()->getApprovedBy()->getName(), $documentName, $project->getBill()->getStatus(), $project->getBill()->getApprovedAmount()); } array_push($rows, $row); $srNo++; } $paginationDto->setRows($rows); } catch (Exception $e) { echo $e->getMessage(); } $this->output->set_content_type('application/json')->set_output(json_encode($paginationDto)); }
function listScheme() { $paginationDto = new PaginationDto(); try { $currentPage = $this->input->post("page"); $recordsPerPage = $this->input->post("recordsPerPage"); $searchString = $this->input->post("searchString"); $paginationDto->setTotalNoOfRecords($this->getTotalCountFor("Scheme")); $paginationDto->setCurrentPage($currentPage); $schemes = $this->listSchemeForPagination($currentPage, $recordsPerPage, $searchString); $rows = array(); $srNo = 1; foreach ($schemes as $scheme) { $divisionName = " NA "; if ($scheme->getDivision() != null) { $divisionName = $scheme->getDivision()->getName(); } $availableFunds = $this->getAvailableFundAmountByScheme($scheme->getId()); if ($availableFunds == null) { $availableFunds = 0; } $row = array($srNo++, date_format($scheme->getCreated(), "d-M-Y"), $scheme->getName(), $divisionName, $availableFunds, $scheme->getId()); array_push($rows, $row); } $paginationDto->setRows($rows); } catch (Exception $e) { echo $e->getMessage(); } $this->output->set_content_type('application/json')->set_output(json_encode($paginationDto)); }