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