public function getChildLevelData() { $parentId = null; if (isset($_GET["parent_id"])) { $parentId = $_GET["parent_id"]; } if (!isset($parentId)) { $response = new Response(); $response->success = false; $response->data = null; $response->message = "Parent ID is invalid for fetching child.."; return $response; } $conn = DB::getConnection(); $sql = "SELECT * FROM server_records WHERE record_id = " . $parentId; $result = $conn->query($sql); $rawList = array(); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $serverRecord = new ServerRecord(); $serverRecord->copyFrom($row); array_push($rawList, $serverRecord); } } $conn->close(); if (!isset($_GET["filterPageSort"])) { $response = new Response(); $response->message = "Data Fetched"; $response->success = true; $response->data = $rawList; return $response; } $filterPageSort = json_decode($_GET["filterPageSort"]); $response = $this->doFilterPageSort($rawList, $filterPageSort); return $response; }
public function getChildLevelData() { $filterPageSort = null; $parentId = $_GET["parent_id"]; if (!isset($parentId)) { $parentId = FALSE; } if (isset($_GET["filterPageSort"])) { $filterPageSort = json_decode((string) $_GET["filterPageSort"]); } else { $filterPageSort = FALSE; } $response = new Response(); if (!$parentId) { $response->success = false; $response->data = null; $response->message = "For Child data parentId is must."; return $response; } $query = "SELECT * FROM " . DB::$tableName; if ($filterPageSort != FALSE) { if (property_exists($filterPageSort, "filters")) { $query .= SqlUtil::buildFilterQuery($filterPageSort->filters); $query .= " AND record_id = " . $parentId; } else { $query .= " WHERE record_id = " . $parentId; } if (property_exists($filterPageSort, "sorts")) { $query .= SqlUtil::buildSortQuery($filterPageSort->sorts); } } else { $query .= " WHERE record_id = " . $parentId; } $conn = DB::getConnection(); $result = $conn->query($query); $responseData = array(); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $serverRecord = new ServerRecord(); $serverRecord->copyFrom($row); array_push($responseData, $serverRecord); } } $conn->close(); $response->data = $responseData; $response->message = "Data Fetched Successfully.."; $response->success = true; return $response; }