function queryByAction($obj)
{
global $wpdb;
$table_name = $wpdb->prefix . "vlib_templates";
$action = htmlspecialchars(trim($obj['action']));
switch ($action) {
/* ************************** */
/* PLOTS */
case 'save':
$name = $obj['name'];
$descr = $obj['description'];
$graph = $obj['sceneGraph'];
$placeholders = $obj['placeholders'];
$thumbnail = $obj['thumbnail'];
$tId = createTemplateQuery($name, $descr, $graph, $thumbnail);
foreach ($placeholders as $pattern) {
$pId = createPlaceholderQuery($pattern);
createTemplateHasPlaceholderQuery($tId, $pId);
}
echo $tId;
break;
case 'update_t':
$tId = $obj['id'];
$name = $obj['name'];
$descr = $obj['description'];
$graph = $obj['sceneGraph'];
$placeholders = $obj['placeholders'];
$thumbnail = $obj['thumbnail'];
/* delete patterns */
$patterns = getPlaceholdersByPlotIdQuery($tId);
if ($patterns) {
foreach ($patterns as $pattern) {
deletePlaceholderByIdQuery($pattern->id);
}
/* delete plot-pattern mappings */
deleteTemplateHasPlaceholderQuery($tId);
}
foreach ($placeholders as $pattern) {
$pId = createPlaceholderQuery($pattern);
createTemplateHasPlaceholderQuery($tId, $pId);
}
updateTemplateQuery($tId, $name, $descr, $graph, $thumbnail);
print "Template <b>{$name}</b> has been updated.";
break;
case 'delete_t':
$name = $obj['name'];
$tId = $obj["id"];
/* delete patterns */
$patterns = getPlaceholdersByPlotIdQuery($tId);
if ($patterns) {
foreach ($patterns as $pattern) {
deletePlaceholderByIdQuery($pattern->id);
}
/* delete plot-pattern mappings */
deleteTemplateHasPlaceholderQuery($tId);
}
/* delete plot*/
$results = deleteTemplateByIdQuery($tId);
if ($results === 1) {
print $results;
} else {
print "There has been an error deleting the template!";
}
break;
case 'get_t':
$results = getTemplatesQuery();
if (count($results) > 0) {
print json_encode($results);
}
break;
case 'get_t_id':
$id = $obj['id'];
$results = getTemplateByIdQuery($id);
if (count($results) > 0) {
print json_encode($results);
}
break;
/* ************************** */
/* GROUPS */
/* ************************** */
/* GROUPS */
case 'save-group':
$name = $obj['group']['config']['name'];
$descr = $obj['group']['config']['description'];
$group = $obj['group'];
print createGroupQuery($name, $descr, $group);
break;
case 'load-group':
$id = $obj['id'];
$result = getGroupByIdQuery($id);
$response = array(id => $result[0]->id, name => $result[0]->name, description => $result[0]->description, group => json_decode($result[0]->group_json));
print json_encode($response);
break;
case 'load-all-groups':
$result = getAllGroups();
print json_encode($result);
break;
case 'load-all-group-definitions':
$result = getAllGroupDefinitions();
print json_encode($result);
break;
case 'delete-group':
$id = $obj["id"];
return deleteGroupQuery($id);
break;
case 'update-group':
$id = $obj["id"];
$name = $obj['group']['config']['name'];
$description = $obj['group']['config']['description'];
$group = $obj['group'];
return updateGroupQuery($id, $name, $description, $group);
break;
/* ************************** */
/* FILES */
/* ************************** */
/* FILES */
case 'get_file_by_id':
$id = $obj['id'];
$results = getFileByIdQuery($id);
echo json_encode($results);
break;
case 'get_files':
$results = getFilesQuery();
echo json_encode($results);
break;
case 'update-file-visibility':
$id = $obj["id"];
$isVisible = $obj['isVisible'];
echo updateFileVisibilityQuery($id, $isVisible);
break;
case 'get_visible_files':
$results = getVisibleFilesQuery();
if (count($results) > 0) {
print json_encode($results);
}
break;
case 'delete_files':
$files_ids = implode(",", $obj['files']);
$dataFolder = "data/";
/* unlink */
foreach ($obj['files'] as $fileId) {
$file = getFileByIdQuery($fileId);
echo "try to unlink " . $dataFolder . $file[0]->file_path;
if ($file[0]->file_path !== "") {
echo "try to unlink " . $dataFolder . $file[0]->file_path;
if (!unlink($dataFolder . $file[0]->file_path)) {
echo "unlink( " . $file[0]->file_path . " ) failed.";
} else {
echo "unlink " . $dataFolder . $file[0]->file_path;
}
}
}
$results = deleteFilesQuery($files_ids);
if (count($results) > 0) {
print $results;
} else {
print "There has been an error deleting the file! ";
}
break;
default:
}
}
$fPath = strRemove($file->getPath() . "/" . $file->getBasename(), $dataFolder);
//echo "PATH: ".$fPath.' ###### ';
$fileId = createFileQuery($file->getBasename(), $fDescr, $fPath, $filesVisible);
if ($createGroup) {
$f = getGroupFile($file->getBasename(), $fDescr);
$f["config"]["file"] = array("id" => $fileId, "name" => $file->getBasename(), "description" => $fDescr, "path" => $fPath, "fullName" => $file->getBasename());
$p = getGroupPlot('plot', '');
$f["parentId"] = $p["id"];
array_push($p['childs'], $f);
groupAddFile($group, $baseFolder, $p);
}
}
}
/* DB - CREATE GROUP */
if ($createGroup) {
$groupId = createGroupQuery($fileName, $fileDescription, $group);
}
/* return group id */
echo $groupId;
/*****************************************************************************/
/* FUNCTIONS */
function getFiles($folder)
{
$iter = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($folder), RecursiveIteratorIterator::SELF_FIRST, RecursiveIteratorIterator::CATCH_GET_CHILD);
$data = null;
foreach ($iter as $path => $dir) {
if ($dir->isFile()) {
if (mb_substr($dir->getBasename(), 0, 1, 'utf-8') == ".") {
continue;
}
$data[] = $dir;
