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