function dv_data_definition_remove()
{
check_rid();
global $com_name, $conf;
$base = $conf['dir_base'];
$db_id = Request::getString('db', false);
$dd_name = Request::getString('dd_name', false);
$author = User::get('name') . ' <' . User::get('email') . '>';
$dd_file_php = "{$base}/{$db_id}/applications/{$com_name}/datadefinitions-php/{$dd_name}.php";
system("rm {$dd_file_php}");
$cmd = "cd {$base}/{$db_id}/applications/{$com_name}/datadefinitions-php/; git commit {$dd_name}.php --author=\"{$author}\" -m\"[DELETE] {$dd_name}.php.\" > /dev/null";
system($cmd);
$dd_file_json = "{$base}/{$db_id}/applications/{$com_name}/datadefinitions/{$dd_name}.json";
system("rm {$dd_file_json}");
$cmd = "cd {$base}/{$db_id}/applications/{$com_name}/datadefinitions/; git commit {$dd_name}.json --author=\"{$author}\" -m\"[DELETE] {$dd_name}.json.\" > /dev/null";
system($cmd);
db_msg('Dataview successfully removed', 'message');
$url = str_replace($_SERVER['SCRIPT_URL'], '', $_SERVER['SCRIPT_URI']);
$url .= "/administrator/index.php?option=com_{$com_name}&task=dataview_list&db={$db_id}";
header("Location: {$url}");
}
function dv_data_definition_new()
{
global $com_name, $conf;
$base = $conf['dir_base'];
$document = App::get('document');
$db_id = Request::getString('db', false);
$table = Request::getString('table', false);
$name = Request::getString('name', false);
$title = Request::getString('title', false);
$name = strtolower(preg_replace('/\\W/', '_', $name));
$db_conf_file = $base . DS . $db_id . DS . 'database.json';
$db_conf = json_decode(file_get_contents($db_conf_file), true);
$jdb = JDatabase::getInstance($db_conf['database_ro']);
$dd = array();
$dd['table'] = $table;
$dd['title'] = $title;
$sql = "SHOW COLUMNS FROM {$table}";
$jdb->setQuery($sql);
$cols = $jdb->loadAssocList();
$first_col = true;
$pk = '';
foreach ($cols as $col) {
if ($col['Key'] == 'PRI') {
$pk = $dd['table'] . '.' . $col['Field'];
}
$dd['cols'][$dd['table'] . '.' . $col['Field']] = array('label' => ucwords(str_replace('_', ' ', $col['Field'])));
}
$dd_text = "<?php\ndefined('_HZEXEC_') or die();\n\n";
$dd_text .= "function get_{$name}()\n{\n";
$dd_text .= "\t" . '$dd[\'title\'] = \'' . $title . '\';' . "\n";
$dd_text .= "\t" . '$dd[\'table\'] = \'' . $dd['table'] . '\';' . "\n";
$dd_text .= "\t" . '$dd[\'pk\'] = \'' . $pk . '\';' . "\n\n";
foreach ($dd['cols'] as $col => $val) {
$dd_text .= "\t" . '$dd[\'cols\'][\'' . $col . '\'] = ' . format_var(var_export($val, true)) . "\n";
}
$dd_text .= "\n\t" . 'return $dd;' . "\n\n}\n?>";
// Check directories
if (!file_exists("{$base}/{$db_id}/applications/{$com_name}/datadefinitions-php/")) {
$dir = "{$base}/{$db_id}/applications/{$com_name}/datadefinitions-php/";
$cmd = "mkdir -p {$dir}; cd {$dir}; git init > /dev/null";
system($cmd);
}
if (!file_exists("{$base}/{$db_id}/applications/{$com_name}/datadefinitions/")) {
$dir = "{$base}/{$db_id}/applications/{$com_name}/datadefinitions/";
$cmd = "mkdir -p {$dir}; cd {$dir}; git init > /dev/null";
system($cmd);
}
$dd_name = $name;
$author = User::get('name') . ' <' . User::get('email') . '>';
$dd_file_php = "{$base}/{$db_id}/applications/{$com_name}/datadefinitions-php/{$dd_name}.php";
file_put_contents($dd_file_php, $dd_text);
$cmd = "cd {$base}/{$db_id}/applications/{$com_name}/datadefinitions-php/; git add {$dd_name}.php; git commit {$dd_name}.php --author=\"{$author}\" -m\"[ADD] {$dd_name}.php Initial commit.\" > /dev/null";
system($cmd);
$dd_file_json = "{$base}/{$db_id}/applications/{$com_name}/datadefinitions/{$dd_name}.json";
$cmd = "cd " . JPATH_COMPONENT . "; php ./ddconvert.php -i{$dd_file_php} -o{$dd_file_json}";
system($cmd);
$cmd = "cd {$base}/{$db_id}/applications/{$com_name}/datadefinitions/; git add {$dd_name}.json; git commit {$dd_name}.json --author=\"{$author}\" -m\"[ADD] {$dd_name}.json Initial commit.\" > /dev/null";
system($cmd);
db_msg('New Dataview Added', 'message');
$url = str_replace($_SERVER['SCRIPT_URL'], '', $_SERVER['SCRIPT_URI']);
$url .= "/administrator/index.php?option=com_{$com_name}&task=data_definition&db={$db_id}&dd={$dd_name}";
header("Location: {$url}");
exit;
}