public function post($segments)
{
$action_id = $segments[0];
switch ($action_id) {
case 'eval-code':
$code = $_POST['code'];
include COMPONENT_ROOT . '/tool/eval-code.php';
break;
case 'create-table':
$table_name = $_POST['table_name'];
$column_array = array();
foreach ($_POST as $key => $value) {
switch ($key) {
case 'table_name':
case 'default_value_radio':
break;
default:
$column_array[$key] = $value;
break;
}
// end switch ($key)
}
// end foreach ($_POST as $key => $value)
$create_table = ModelHelper::createTable($table_name, $column_array);
$create_class = ModelHelper::createClassFile($table_name, $column_array);
$create_class_god = ModelHelper::createClassGodFile($table_name);
if ($create_table && $create_class && $create_class_god) {
ResponseMessenger::json('success');
} else {
// end if ($create_table && $create_class && $create_class_god)
ResponseMessenger::json('fail');
}
// end if ($create_table && $create_class && $create_class_god) else
break;
case 'export-table':
$table_list = $_POST['table_list'];
$table_array = explode(',', $table_list);
$success_table_array = array();
$fail_table_array = array();
foreach ($table_array as $table_name) {
if (ModelHelper::exportTable($table_name)) {
array_push($success_table_array, $table_name);
} else {
// end if (ModelHelper::exportTable($table_name))
array_push($fail_table_array, $table_name);
}
// end if (ModelHelper::exportTable($table_name)) else
}
// end foreach ($table_array as $table_name)
$message = '成功匯出 ' . count($success_table_array) . ' 個 Table';
$parameter = array("success" => implode(', ', $success_table_array), "fail" => implode(', ', $fail_table_array));
ResponseMessenger::json('success', $message, $parameter);
break;
case 'import-table':
$table_list = $_POST['table_list'];
$table_array = explode(',', $table_list);
$success_table_array = array();
$fail_table_array = array();
foreach ($table_array as $table_name) {
if (ModelHelper::importTable($table_name)) {
array_push($success_table_array, $table_name);
} else {
// end if (ModelHelper::importTable($table_name))
array_push($fail_table_array, $table_name);
}
// end if (ModelHelper::importTable($table_name)) else
}
// end foreach ($table_array as $table_name)
$message = '成功匯入 ' . count($success_table_array) . ' 個 Table';
$parameter = array("success" => implode(', ', $success_table_array), "fail" => implode(', ', $fail_table_array));
ResponseMessenger::json('success', $message, $parameter);
break;
case 'export-data':
$table_list = $_POST['table_list'];
$table_array = explode(',', $table_list);
$success_table_array = array();
$fail_table_array = array();
foreach ($table_array as $table_name) {
if (ModelHelper::exportData($table_name)) {
array_push($success_table_array, $table_name);
} else {
// end if (ModelHelper::exportData($table_name))
array_push($fail_table_array, $table_name);
}
// end if (ModelHelper::exportData($table_name)) else
}
// end foreach ($table_array as $table_name)
$message = '成功匯出 ' . count($success_table_array) . ' 個 Table';
$parameter = array("success" => implode(', ', $success_table_array), "fail" => implode(', ', $fail_table_array));
ResponseMessenger::json('success', $message, $parameter);
break;
case 'sync-data':
$table_list = $_POST['table_list'];
$table_array = explode(',', $table_list);
$success_table_array = array();
$fail_table_array = array();
foreach ($table_array as $table_name) {
if (ModelHelper::syncData($table_name)) {
array_push($success_table_array, $table_name);
} else {
// end if (ModelHelper::syncData($table_name))
array_push($fail_table_array, $table_name);
}
// end if (ModelHelper::syncData($table_name)) else
}
// end foreach ($table_array as $table_name)
$message = '成功同步 ' . count($success_table_array) . ' 個 Table';
$parameter = array("success" => implode(', ', $success_table_array), "fail" => implode(', ', $fail_table_array));
ResponseMessenger::json('success', $message, $parameter);
break;
case 'arrange-database':
include COMPONENT_ROOT . '/tool/arrange-database.php';
break;
default:
echo 'Undefined post action';
break;
}
// end switch ($action_id)
}
exit;
}
echo "\tCreate database `{$database_name}`...done" . PHP_EOL . PHP_EOL;
} else {
echo 'ok' . PHP_EOL . PHP_EOL;
}
// create tables
$db_obj = new DatabaseAccess();
$new_table_array = array();
foreach (glob(TABLE_SQL_ROOT . '/*.sql') as $sql_file) {
$new_table_array[] = str_replace('.sql', '', str_replace(TABLE_SQL_ROOT . '/', '', $sql_file));
}
foreach ($new_table_array as $table_name) {
$class_name = str_replace(' ', '', ucwords(str_replace('_', ' ', $table_name)));
echo 'Create `' . $table_name . '`...';
if (ModelHelper::importTable($table_name)) {
echo 'ok' . PHP_EOL;
// sync class file
$class_path = CLASS_ROOT . '/model/' . $class_name . '.php';
if (file_exists($class_path)) {
echo "\tClass file exists" . PHP_EOL;
} else {
$column_list = $db_obj->getTableColumns($table_name);
echo "\tCreate class file...";
if (ModelHelper::createClassFile($table_name, $column_list)) {
echo 'ok' . PHP_EOL;
} else {
echo 'fail' . PHP_EOL;
}
}
// sync class god file