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 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));
}
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));
}
