<?php
/**
* Created by PhpStorm.
* User: poovarasanv
* Date: 02-11-2015
* Time: 09:47
*/
require "DatabaseConnection.php";
$db = new DatabaseConnection();
$db->createConnection();
$parent = $_GET['parent'];
$type = $_GET['type'];
$sql = "SELECT *\n FROM artefact\n WHERE ArtefactPID = '{$parent}' AND VisibleStatus='on' ORDER BY CreatedDate DESC";
//echo $sql;
$result = $db->setQuery($sql);
$resultArray = array();
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$temp["title"] = $row['ArtefactName'];
$temp["key"] = $row['ArtefactCode'];
if ($db->isChildAvailable($row['ArtefactName'])) {
$temp['lazy'] = true;
$temp['folder'] = true;
}
array_push($resultArray, $temp);
}
echo json_encode($resultArray);
} else {
return null;
}
* Time: 10:05
*/
ini_set('max_execution_time', 30000);
include_once 'DatabaseConnection.php';
$type = $_GET['type'];
session_start();
$_SESSION['type'] = $type;
$db = new DatabaseConnection();
$conn = $db->createConnection();
$parentArray = array();
//Associate Array with ArtefactCode and ArtefactPID
$sql = "SELECT\n artefactname,\n artefactcode\n FROM artefact\n WHERE artefactPID IS NULL AND artefactTypeCode = '{$type}' AND visiblestatus = 'on'\n ORDER BY CreatedDate DESC";
//echo $sql;
$result = $db->setQuery($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$temp['title'] = $row['artefactname'];
$temp['key'] = $row['artefactcode'];
if ($db->isChildAvailable($row['artefactname']) > 0) {
$temp['lazy'] = true;
$temp['folder'] = true;
// $temp['cc'] = $db->isChildAvailable($row['artefactname']);
}
array_push($parentArray, $temp);
}
//echo "<pre>";
//print_r($parentArray);
echo json_encode($parentArray);
} else {
return null;
}
