middleware(function ($request, $next) {
if (session('gid') != '1')
return redirect('dashboard')
->with('message', 'You Dont Have Access to Page !')->with('status', 'error');
return $next($request);
});
$driver = config('database.default');
$database = config('database.connections');
$this->db = $database[$driver]['database'];
$this->dbuser = $database[$driver]['username'];
$this->dbpass = $database[$driver]['password'];
$this->dbhost = $database[$driver]['host'];
$this->model = new Module();
$this->data = array_merge(array(
'pageTitle' => 'Module',
'pageNote' => 'Manage All Module',
), $this->data);
}
public function clearModuleCache($module_name)
{
\Cache::forget('modelMakeInfo_' . $module_name);
}
public function index(Request $request)
{
if (!is_null($request->input('t'))) {
// $rowData = \Cache::rememberForever('Modules_Core', function () {
// return \DB::table('tb_module')->where('module_type', '=', 'core')
// ->orderby('module_title', 'asc')->get();
// });
$rowData = DB::table('tb_module')->where('module_type', '=', 'core')
->orderby('module_title', 'asc')->get();
$type = 'core';
} else {
// $rowData = $rowData = \Cache::rememberForever('Modules_NonCore', function () {
// return \DB::table('tb_module')->where('module_type', '<>', 'core')
// ->orderby('module_title', 'asc')->get();
// });
$rowData = DB::table('tb_module')->where('module_type', '<>', 'core')
->orderby('module_title', 'asc')->get();
$type = 'addon';
}
$this->data['type'] = $type;
$this->data['rowData'] = $rowData;
return view('central.module.index', $this->data);
}
function getCreate()
{
$this->data = array(
'pageTitle' => 'Create New Module',
'pageNote' => 'Create Quick Module ',
);
$this->data['tables'] = Module::getTableList($this->db);
$this->data['cruds'] = \SiteHelpers::crudOption();
return view('central.module.create', $this->data);
}
function postCreate(Request $request)
{
$rules = array(
'module_name' => 'required|alpha|min:2|unique:tb_module',
'module_title' => 'required',
'module_note' => 'required',
'module_db' => 'required',
);
$validator = Validator::make($request->all(), $rules);
if ($validator->passes()) {
$table = $request->input('module_db');
$primary = self::findPrimarykey($request->input('module_db'));
$select = $request->input('sql_select');
$where = $request->input('sql_where');
$group = $request->input('sql_group');
if ($request->input('creation') == 'manual') {
if ($where == "") {
return redirect('central/module/create')
->withErrors($validator)->withInput()->with('message', "SQL WHERE REQUIRED")->with('status', 'error');
}
try {
\DB::select($select . ' ' . $where . ' ' . $group);
} catch (Exception $e) {
// Do something when query fails.
$error = 'Error : ' . $select . ' ' . $where . ' ' . $group;
return redirect('central/module/create')
->withErrors($validator)->withInput()->with('message', SiteHelpers::alert('error', $error))->with('status', 'error');
}
$columns = array();
$results = $this->model->getColoumnInfo($select . ' ' . $where . ' ' . $group);
$primary_exits = '';
foreach ($results as $r) {
$Key = (isset($r['flags'][1]) && $r['flags'][1] == 'primary_key' ? 'PRI' : '');
if ($Key != '') $primary_exits = $r['name'];
$columns[] = (object)array('Field' => $r['name'], 'Table' => $r['table'], 'Type' => $r['native_type'] ?? 'VAR_STRING', 'Key' => $Key, 'Default' => '', 'Null' => '', 'Comment' => '');
}
$primary = ($primary_exits != '' ? $primary_exits : '');
} else {
$columns = \DB::select("SHOW FULL COLUMNS FROM " . $request->input('module_db'));
$select = " SELECT {$table}.* FROM {$table} ";
$where = " WHERE " . $table . "." . $primary . " IS NOT NULL";
if ($primary != '') {
$where = " WHERE " . $table . "." . $primary . " IS NOT NULL";
} else {
$where = '';
}
}
$i = 0;
$rowGrid = array();
$rowForm = array();
$relations = self::getRelationSelects($table);
$relOptions = [];
foreach ($columns as $column) {
if (!isset($column->Table)) $column->Table = $table;
if ($column->Key == 'PRI') $column->Type = 'hidden';
if ($column->Table == $table) {
$relOptions = (isset($relations[$column->Field])) ? $relations[$column->Field] : [];
$form_creator = self::configForm($column->Field, $column->Table, $column->Type, $column->Default, $column->Null, $i, $column->Comment, $relOptions);
// foreach ($relation as $row) {
// $array = array('external', $row['table'], $row['column']);
// $form_creator = self::configForm($column->Field, $table, 'select', $column->Null, $i, $column->Comment, $array);
// }
$rowForm[] = $form_creator;
}
$rowGrid[] = self::configGrid($column->Field, $column->Table, $column->Type, $column->Default, $column->Null, $i, $column->Comment, $relOptions);
$i++;
}
$json_data['sql_select'] = $select;
$json_data['sql_where'] = $where;
$json_data['sql_group'] = $group;
$json_data['table_db'] = $table;
$json_data['primary_key'] = $primary;
$json_data['grid'] = $rowGrid;
$json_data['forms'] = $rowForm;
$module_type = $primary == '' ? 'report' : $request->input('module_template');
// var_export($json_data);die();
$data = array(
'module_name' => strtolower(trim($request->input('module_name'))),
'module_title' => $request->input('module_title'),
'module_note' => $request->input('module_note'),
'module_db' => $request->input('module_db'),
'module_db_key' => $primary,
'module_type' => $module_type,
'module_created' => date("Y-m-d H:i:s"),
'module_config' => \SiteHelpers::CF_encode_json($json_data),
);
\DB::table('tb_module')->insert($data);
\Cache::forget('Modules_Core');
\Cache::forget('Modules_NonCore');
// Add Default permission
$tasks = array(
'is_global' => 'Global',
'is_view' => 'View ',
'is_detail' => 'Detail',
'is_add' => 'Add ',
'is_edit' => 'Edit ',
'is_remove' => 'Remove ',
'is_excel' => 'Excel ',
'is_search' => 'search',
);
$groups = \DB::table('tb_groups')->get();
$row = \DB::table('tb_module')->where('module_name', $request->input('module_name'))->get();
if (count($row) >= 1) {
$id = $row[0];
foreach ($groups as $g) {
$arr = array();
foreach ($tasks as $t => $v) {
if ($g->group_id == '1') {
$arr[$t] = '1';
} else {
$arr[$t] = '0';
}
}
$data = array(
"access_data" => json_encode($arr),
"module_id" => $id->module_id,
"group_id" => $g->group_id,
);
\DB::table('tb_groups_access')->insert($data);
}
return redirect('central/module/rebuild/' . $id->module_id);
} else {
return redirect('central/module');
}
} else {
return redirect('central/module/create')
->with('message', 'The following errors occurred')->with('status', 'error')
->withErrors($validator)->withInput();
}
}
function getDestroy($id = null)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$path = $row->module_name;
$class = ucwords($row->module_name);
if ($row->module_type != 'core') {
if ($class != '') {
\DB::table('tb_module')->where('module_id', '=', $row->module_id)->delete();
\DB::table('tb_groups_access')->where('module_id', '=', $row->module_id)->delete();
self::createRouters();
$this->clearModuleCache($row->module_name);
\Cache::forget('Modules_Core');
\Cache::forget('Modules_NonCore');
if (file_exists(app_path() . "/Http/Controllers/{$class}Controller.php"))
unlink(app_path() . "/Http/Controllers/{$class}Controller.php");
if (file_exists(app_path() . "/Models/{$class}.php"))
unlink(app_path() . "/Models/{$class}.php");
self::removeDir(base_path() . "/resources/views/{$path}");
return redirect('central/module')
->with('message', 'Module has been removed successfull')->with('status', 'success');
}
}
return redirect($this->module)
->with('message', 'No Module removed !')->with('status', 'success');
}
function removeDir($dir)
{
foreach (glob($dir . '/*') as $file) {
if (is_dir($file))
self::removeDir($file);
else
unlink($file);
}
if (is_dir($dir)) rmdir($dir);
}
function getConfig($id)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
// Get config Info
$fp = base_path() . '/resources/views/central/module/template/' . $this->getTemplateName($row->module_type) . '/config/info.json';
$fp = json_decode(file_get_contents($fp));
$this->data['config'] = $fp;
$this->data['cruds'] = \SiteHelpers::crudOption();
//
$this->data['module'] = 'module';
$this->data['module_lang'] = json_decode($row->module_lang, true);
$this->data['module_name'] = $row->module_name;
$config = $row->module_config;
$this->data['tables'] = $config['grid'];
$this->data['type'] = ($row->module_type == 'ajax' ? 'addon' : $row->module_type);
$this->data['setting'] = array(
'gridtype' => (isset($config['setting']) ? $config['setting']['gridtype'] : 'native'),
'orderby' => (isset($config['setting']) ? $config['setting']['orderby'] : $row->module_db_key),
'ordertype' => (isset($config['setting']) ? $config['setting']['ordertype'] : 'asc'),
'perpage' => (isset($config['setting']) ? $config['setting']['perpage'] : '10'),
'frozen' => (isset($config['setting']['frozen']) ? $config['setting']['frozen'] : 'false'),
'form-method' => (isset($config['setting']['form-method']) ? $config['setting']['form-method'] : 'native'),
'view-method' => (isset($config['setting']['view-method']) ? $config['setting']['view-method'] : 'native'),
'inline' => (isset($config['setting']['inline']) ? $config['setting']['inline'] : 'false'),
);
return view('central.module.config', $this->data);
}
function postSaveconfig(Request $request)
{
$rules = array(
'module_title' => 'required',
'module_id' => 'required',
);
$validator = Validator::make($request->all(), $rules);
if ($validator->passes()) {
$data = array(
'module_title' => $request->input('module_title'),
'module_note' => $request->input('module_note'),
'module_frontend_slug' => $request->input('module_frontend_slug'),
);
$lang = \SiteHelpers::langOption();
$language = array();
foreach ($lang as $l) {
if ($l['folder'] != 'en') {
$label_lang = (isset($_POST['language_title'][$l['folder']]) ? $_POST['language_title'][$l['folder']] : '');
$note_lang = (isset($_POST['language_note'][$l['folder']]) ? $_POST['language_note'][$l['folder']] : '');
$language['title'][$l['folder']] = $label_lang;
$language['note'][$l['folder']] = $note_lang;
}
}
$data['module_lang'] = json_encode($language);
$id = $request->input('module_id');
\DB::table('tb_module')->where('module_id', '=', $id)->update($data);
$this->clearModuleCache($request->input('module_name'));
if ($request->ajax() == true) {
return response()->json(array('status' => 'success', 'message' => 'Module Info Has Been updated Successfull'));
} else {
return redirect('central/module/config/' . $request->input('module_name'))
->with('message', 'Module Info Has Been updated Successfull')->with('status', 'success');
}
} else {
if ($request->ajax() == true) {
return response()->json(array('status' => 'error', 'message' => 'The following errors occurred'));
} else {
return redirect('central/module/config/' . $request->input('module_name'))
->with('message', 'The following errors occurred')->with('status', 'error')
->withErrors($validator)->withInput();
}
}
}
public function postSavesetting(Request $request)
{
$id = $request->input('module_id');
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$config = $row->module_config;
$setting = array(
'gridtype' => '',
'orderby' => $request->input('orderby'),
'ordertype' => $request->input('ordertype'),
'perpage' => $request->input('perpage'),
'frozen' => (!is_null($request->input('frozen')) ? 'true' : 'false'),
'form-method' => (!is_null($request->input('form-method')) ? $request->input('form-method') : 'native'),
'view-method' => (!is_null($request->input('view-method')) ? $request->input('view-method') : 'native'),
'inline' => (!is_null($request->input('inline')) ? 'true' : 'false'),
);
if (isset($config['setting'])) unset($config['setting']);
$new_config = array_merge($config, array("setting" => $setting));
$data['module_config'] = \SiteHelpers::CF_encode_json($new_config);
$data['module_type'] = $request->input('module_type');
\DB::table('tb_module')
->where('module_id', '=', $id)
->update(array('module_config' => \SiteHelpers::CF_encode_json($new_config), 'module_type' => $request->input('module_type')));
$this->clearModuleCache($row->module_name);
if ($request->ajax() == true) {
return response()->json(array('status' => 'success', 'message' => 'Module Setting Has Been Save Successfull'));
} else {
return redirect('central/module/config/' . $row->module_name)
->with('message', 'Module Setting Has Been Save Successfull')->with('status', 'success');
}
}
function getSql(Request $request, $id)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
$this->data['sql_select'] = $config['sql_select'];
$this->data['sql_where'] = $config['sql_where'];
$this->data['sql_group'] = $config['sql_group'];
$this->data['module_name'] = $row->module_name;
$this->data['module'] = 'module';
$this->data['type'] = ($row->module_type == 'ajax' ? 'addon' : $row->module_type);
return view('central.module.sql', $this->data);
}
function postSavesql(Request $request, $id)
{
$select = $request->input('sql_select');
$where = $request->input('sql_where');
$group = $request->input('sql_group');
$table = $module_db = $request->input('module_db');
try {
\DB::select($select . ' ' . $where . ' ' . $group);
} catch (Exception $e) {
// Do something when query fails.
$error = 'Error : ' . $select . ' ' . $where . ' ' . $group;
return redirect('central/module/sql/' . $request->input('module_name'))
->with('message', $error)->with('status', 'error');
}
$row = config("modules.{$id}");
if (empty($row)) {
return redirect()->back()
->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$config = $row->module_config;
$gridFeilds = array_map(function ($gridItem) {
return $gridItem['field'];
}, $config['grid']);
$formFeilds = array_map(function ($gridItem) {
return $gridItem['field'];
}, $config['forms']);
$this->data['row'] = $row;
if (true) {
$results = $this->model->getColoumnInfo($select . ' ' . $where . ' ' . $group);
foreach ($results as $r) {
$Key = (isset($r['flags'][1]) && $r['flags'][1] == 'primary_key' ? 'PRI' : '');
if ($Key != '') $primary_exits = $r['name'];
$columns[] = (object)array('Field' => $r['name'], 'Table' => $r['table'], 'Type' => $r['native_type'] ?? 'VAR_STRING', 'Key' => $Key, 'Default' => '', 'Null' => '', 'Comment' => '');
}
} else
$columns = \DB::select("SHOW FULL COLUMNS FROM " . $request->input('module_db'));
$i = count($gridFeilds);
$relations = self::getRelationSelects($table);
$currentColumns = [];
foreach ($columns as $column) {
$i++;
if (!in_array($column->Field, $formFeilds)) {
if (!isset($column->Table)) $column->Table = $table;
if ($column->Key == 'PRI') $column->Type = 'hidden';
if ($column->Table == $table) {
$relOptions = (isset($relations[$column->Field])) ? $relations[$column->Field] : [];
$form_creator = self::configForm($column->Field, $column->Table, $column->Type, $column->Default, $column->Null, $i, $column->Comment, $relOptions);
// foreach ($relation as $row) {
// $array = array('external', $row['table'], $row['column']);
// $form_creator = self::configForm($column->Field, $table, 'select', $column->Null, $i, $column->Comment, $array);
// }
$config['forms'][] = $form_creator;
}
}
if (!in_array($column->Field, $gridFeilds))
$config['grid'][] = self::configGrid($column->Field, $column->Table, $column->Type, $column->Default, $column->Null, $i, $column->Comment, $relOptions);
$currentColumns[] = $column->Field;
}
foreach ($gridFeilds as $pos => $colName) {
if (!in_array($colName, $currentColumns))
unset($config['grid'][$pos]);
}
foreach ($formFeilds as $pos => $colName) {
if (!in_array($colName, $currentColumns))
unset($config['forms'][$pos]);
}
$config['sql_select'] = $select;
$config['sql_where'] = $where;
$config['sql_group'] = $group;
\DB::table('tb_module')
->where('module_id', '=', $row->module_id)
->update(array('module_config' => \SiteHelpers::CF_encode_json($config)));
$this->clearModuleCache($row->module_name);
if ($request->ajax() == true) {
return response()->json(array('status' => 'success', 'message' => 'SQL Has Changed Successful.'));
} else {
return redirect('central/module/sql/' . $row->module_name)
->with('message', 'SQL Has Changed Successful.')->with('status', 'success');
}
}
function getTable($id)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$fp = base_path() . '/resources/views/central/module/template/' . $this->getTemplateName($row->module_type) . '/config/info.json';
$fp = json_decode(file_get_contents($fp));
$this->data['config'] = $fp;
$config = $row->module_config;
$this->data['tables'] = $config['grid'];
$this->data['module'] = 'module';
$this->data['module_name'] = $row->module_name;
$this->data['type'] = ($row->module_type == 'ajax' ? 'addon' : $row->module_type);
return view('central.module.table', $this->data);
}
function getForm($id)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
// Get config Info
$fp = base_path() . '/resources/views/central/module/template/' . $this->getTemplateName($row->module_type) . '/config/info.json';
$fp = json_decode(file_get_contents($fp));
$this->data['config'] = $fp;
$this->data['forms'] = $config['forms'];
$this->data['form_column'] = (isset($config['form_column']) ? $config['form_column'] : 1);
$this->data['module'] = 'module';
$this->data['module_name'] = $row->module_name;
$this->data['type'] = ($row->module_type == 'ajax' ? 'addon' : $row->module_type);
return view('central.module.form', $this->data);
}
public function postSaveform(Request $request)
{
$id = $request->input('module_id');
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
$lang = \SiteHelpers::langOption();
$this->data['tables'] = $config['grid'];
$total = count($_POST['field']);
extract($_POST);
$f = array();
for ($i = 1; $i <= $total; $i++) {
if (!isset($lookup_table[$i])) break;
$language = array();
foreach ($lang as $l) {
if ($l['folder'] != 'en') {
$label_lang = (isset($_POST['language'][$i][$l['folder']]) ? $_POST['language'][$i][$l['folder']] : '');
$language[$l['folder']] = $label_lang;
}
}
$f[] = array(
"field" => $field[$i],
"alias" => $alias[$i],
"language" => $language,
"label" => $label[$i],
'form_group' => $form_group[$i],
'required' => (isset($required[$i]) ? $required[$i] : 0),
'unique' => (isset($unique[$i]) ? $unique[$i] : 0),
'default' => (isset($default[$i]) ? $default[$i] : null),
'validations' => (isset($validations[$i]) ? $validations[$i] : 0),
'view' => (isset($view[$i]) ? 1 : 0),
'type' => $type[$i],
'add' => 1,
'size' => '0',
'edit' => 1,
'search' => (isset($search[$i]) ? $search[$i] : 0),
"sortlist" => $sortlist[$i],
'limited' => (isset($limited[$i]) ? $limited[$i] : ''),
'note' => (isset($note[$i]) ? $note[$i] : ''),
'dependency' => (isset($dependency[$i]) ? $dependency[$i] : ''),
'option' => array(
"opt_type" => $opt_type[$i],
"lookup_query" => $lookup_query[$i],
"lookup_table" => $lookup_table[$i],
"lookup_key" => $lookup_key[$i],
"lookup_value" => $lookup_value[$i],
'is_dependency' => $is_dependency[$i],
'select_multiple' => (isset($select_multiple[$i]) ? $select_multiple[$i] : 0),
'image_multiple' => (isset($image_multiple[$i]) ? $image_multiple[$i] : 0),
'lookup_dependency_key' => $lookup_dependency_key[$i],
'lookup_where_clause' => $lookup_where_clause[$i],
'path_to_upload' => $path_to_upload[$i],
'upload_from' => $upload_from[$i] ?? 'admin',
'resize_width' => $resize_width[$i],
'resize_height' => $resize_height[$i],
'upload_type' => $upload_type[$i],
'tooltip' => $tooltip[$i],
'attribute' => $attribute[$i],
'extend_class' => $extend_class[$i],
'is_json' => (isset($is_json[$i]) ? $is_json[$i] : 0),
'is_ajax' => (isset($is_ajax[$i]) ? $is_ajax[$i] : 0),
),
);
}
unset($config["forms"]);
$new_config = array_merge($config, array("forms" => $f));
$data['module_config'] = \SiteHelpers::CF_encode_json($new_config);
\DB::table('tb_module')
->where('module_id', '=', $id)
->update(array('module_config' => \SiteHelpers::CF_encode_json($new_config)));
$this->clearModuleCache($row->module_name);
if ($request->ajax() == true) {
return response()->json(array('status' => 'success', 'message' => 'Module Forms Has Changed Successful'));
} else {
return redirect('central/module/form/' . $row->module_name)
->with('message', 'Module Forms Has Changed Successful.')->with('status', 'success');
}
}
public function getEditform(Request $request, $id)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
$module_id = $id;
$field_id = $request->input('field');
$alias = $request->input('alias');
$f = array();
foreach ($config['forms'] as $form) {
$tooltip = '';
$attribute = '';
if (isset($form['option']['tooltip'])) $tooltip = $form['option']['tooltip'];
if (isset($form['option']['attribute'])) $attribute = $form['option']['attribute'];
$size = isset($form['size']) ? $form['size'] : 'span12';
if ($form['field'] == $field_id && $form['alias'] == $alias) {
//$multiVal = explode(":",$form['option']['lookup_value']);
$f = array(
"field" => $form['field'],
"alias" => $form['alias'],
"label" => $form['label'],
'form_group' => $form['form_group'],
'required' => $form['required'],
'unique' => $form['unique'] ?? 0,
'validations' => $form['validations'],
'default' => $form['default'],
'view' => $form['view'],
'type' => $form['type'],
'add' => $form['add'],
'size' => $size,
'edit' => $form['edit'],
'search' => $form['search'],
"sortlist" => $form['sortlist'],
'limited' => isset($form['limited']) ? $form['limited'] : '',
'option' => array(
"opt_type" => $form['option']['opt_type'],
"lookup_query" => $form['option']['lookup_query'],
"lookup_table" => $form['option']['lookup_table'],
"lookup_key" => $form['option']['lookup_key'],
"lookup_value" => $form['option']['lookup_value'],
'is_dependency' => $form['option']['is_dependency'],
'select_multiple' => (isset($form['option']['select_multiple']) ? $form['option']['select_multiple'] : 0),
'image_multiple' => (isset($form['option']['image_multiple']) ? $form['option']['image_multiple'] : 0),
'lookup_dependency_key' => $form['option']['lookup_dependency_key'],
'lookup_where_clause' => isset($form['option']['lookup_where_clause']) ? $form['option']['lookup_where_clause'] : '',
'path_to_upload' => $form['option']['path_to_upload'],
'upload_from' => $form['option']['upload_from'] ?? 'admin',
'upload_type' => $form['option']['upload_type'],
'resize_width' => isset($form['option']['resize_width']) ? $form['option']['resize_width'] : '',
'resize_height' => isset($form['option']['resize_height']) ? $form['option']['resize_height'] : '',
'extend_class' => isset($form['option']['extend_class']) ? $form['option']['extend_class'] : '',
'tooltip' => $tooltip,
'attribute' => $attribute,
'prefix' => isset($form['option']['prefix']) ? $form['option']['prefix'] : '',
'sufix' => isset($form['option']['sufix']) ? $form['option']['sufix'] : '',
'is_json' => (isset($form['option']['is_json']) ? $form['option']['is_json'] : 0),
'is_ajax' => (isset($form['option']['is_ajax']) ? $form['option']['is_ajax'] : 0)
),
);
}
}
$this->data['field_type_opt'] = array(
'hidden' => 'Hidden',
'text' => 'Text',
'text_date' => 'Date',
'text_number' => 'Numeric',
'text_decimal' => 'Decimal',
'text_datetime' => 'Date & Time',
'textarea' => 'Textarea',
'textarea_editor' => 'Textarea With Editor ',
'select' => 'Select Option',
'radio' => 'Radio',
'checkbox' => 'Checkbox',
'switch' => 'Switch',
'file' => 'Upload File',
'image' => 'Media Library',
'color' => 'Color Picker',
'lang' => 'Muli Lang - Text',
'lang_editor' => 'Muli Lang - Editor',
'lang_textarea' => 'Muli Lang - Textarea',
'json_editor' => 'JSON Editor',
'update_timestamp' => 'Hidden CurrentTime'
);
$this->data['tables'] = Module::getTableList($this->db);
$this->data['f'] = $f;
$this->data['module_id'] = $id;
$this->data['module'] = 'module';
$this->data['module_name'] = $row->module_name;
return view('central.module.field', $this->data);
}
function postSaveformfield(Request $request)
{
$lookup_value = (is_array($request->input('lookup_value')) ? implode("|", array_filter($request->input('lookup_value'))) : '');
$id = $request->input('module_id');
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
$view = 0;
$search = 0;
if (!is_null($request->input('view'))) $view = 1;
if (!is_null($request->input('search'))) $search = 1;
if (preg_match('/(select|radio|checkbox)/', $request->input('type'))) {
if ($request->input('opt_type') == 'datalist') {
$datalist = '';
$cf_val = $request->input('custom_field_val');
$cf_display = $request->input('custom_field_display');
for ($i = 0; $i < count($cf_val); $i++) {
$value = $cf_val[$i];
if (isset($cf_display[$i])) {
$display = $cf_display[$i];
} else {
$display = 'none';
}
$datalist .= $value . ':' . $display . '|';
}
$datalist = substr($datalist, 0, strlen($datalist) - 1);
} else {
$datalist = '';
}
} else {
$datalist = '';
}
$new_field = array(
"field" => $request->input('field'),
"alias" => $request->input('alias'),
"label" => $request->input('label'),
"form_group" => $request->input('form_group'),
'required' => $request->input('required'),
'unique' => $request->input('unique'),
'default' => $request->input('default'),
'validations' => $request->input('validations'),
'view' => $view,
'type' => $request->input('type'),
'add' => 1,
'edit' => 1,
'search' => $request->input('search'),
'size' => '',
'sortlist' => $request->input('sortlist'),
'limited' => $request->input('limited'),
'option' => array(
"opt_type" => $request->input('opt_type'),
"lookup_query" => $datalist,
"lookup_table" => $request->input('lookup_table'),
"lookup_key" => $request->input('lookup_key'),
"lookup_value" => $lookup_value,
'is_dependency' => $request->input('is_dependency'),
'select_multiple' => (!is_null($request->input('select_multiple')) ? '1' : '0'),
'image_multiple' => (!is_null($request->input('image_multiple')) ? '1' : '0'),
'lookup_dependency_key' => $request->input('lookup_dependency_key'),
'lookup_where_clause' => $request->input('lookup_where_clause'),
'path_to_upload' => $request->input('path_to_upload'),
'upload_from' => $request->input('upload_from'),
'upload_type' => $request->input('upload_type'),
'resize_width' => $request->input('resize_width'),
'resize_height' => $request->input('resize_height'),
'tooltip' => $request->input('tooltip'),
'attribute' => $request->input('attribute'),
'extend_class' => $request->input('extend_class'),
'prefix' => $request->input('prefix'),
'sufix' => $request->input('sufix'),
'is_json' => (!is_null($request->input('is_json')) ? '1' : '0'),
'is_ajax' => (!is_null($request->input('is_ajax')) ? '1' : '0'),
)
);
$forms = array();
foreach ($config['forms'] as $form_view) {
if ($form_view['field'] == $request->input('field') && $form_view['alias'] == $request->input('alias')) {
$new_form = $new_field;
} else {
$new_form = $form_view;
}
$forms[] = $new_form;
}
unset($config["forms"]);
$new_config = array_merge($config, array("forms" => $forms));
\DB::table('tb_module')
->where('module_id', '=', $id)
->update(array('module_config' => \SiteHelpers::CF_encode_json($new_config)));
$this->clearModuleCache($row->module_name);
return redirect('central/module/form/' . $row->module_name)
->with('message', 'Forms Has Changed Successful.')->with('status', 'success');
}
public function postSavetable(Request $request)
{
//$this->beforeFilter('csrf', array('on'=>'post'));
$id = $request->input('module_id');
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$config = $row->module_config;
$lang = \SiteHelpers::langOption();
$grid = array();
$total = count($_POST['field']);
extract($_POST);
for ($i = 1; $i <= $total; $i++) {
$language = array();
foreach ($lang as $l) {
if ($l['folder'] != 'en') {
$label_lang = (isset($_POST['language'][$i][$l['folder']]) ? $_POST['language'][$i][$l['folder']] : '');
$language[$l['folder']] = $label_lang;
}
}
$grid[] = array(
'field' => $field[$i],
'alias' => $alias[$i],
'language' => $language,
'label' => $label[$i],
'view' => (isset($view[$i]) ? 1 : 0),
'detail' => (isset($detail[$i]) ? 1 : 0),
'sortable' => (isset($sortable[$i]) ? 1 : 0),
'search' => (isset($search[$i]) ? 1 : 0),
'download' => (isset($download[$i]) ? 1 : 0),
'frozen' => (isset($frozen[$i]) ? 1 : 0),
'limited' => (isset($limited[$i]) ? $limited[$i] : ''),
'width' => $width[$i],
'align' => $align[$i],
'sortlist' => $sortlist[$i],
'conn' => array(
'valid' => $conn_valid[$i],
'db' => $conn_db[$i],
'key' => $conn_key[$i],
'display' => $conn_display[$i]
),
'format_as' => (isset($format_as[$i]) ? $format_as[$i] : ''),
'format_value' => (isset($format_value[$i]) ? $format_value[$i] : '')
);
}
unset($config["grid"]);
$new_config = array_merge($config, array("grid" => $grid));
$data['module_config'] = \SiteHelpers::CF_encode_json($new_config);
\DB::table('tb_module')
->where('module_id', '=', $id)
->update(array('module_config' => \SiteHelpers::CF_encode_json($new_config)));
$this->clearModuleCache($row->module_name);
if ($request->ajax() == true) {
return response()->json(array('status' => 'success', 'message' => 'Module Table Has Been Save Successfull'));
} else {
return redirect('central/module/table/' . $row->module_name)
->with('message', 'Module Table Has Been Save Successfull')->with('status', 'success');
}
}
function getPermission($id)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
// Get config Info
$fp = base_path() . '/resources/views/central/module/template/' . $this->getTemplateName($row->module_type) . '/config/info.json';
$fp = json_decode(file_get_contents($fp), true);
$this->data['config'] = $fp;
$this->data['module'] = 'module';
$this->data['module_name'] = $row->module_name;
$config = $row->module_config;
$this->data['type'] = $row->module_type;
$tasks = $fp['access'];
/* Update permission global / own access new ver 1.1
Adding new param is_global
End Update permission global / own access new ver 1.1
*/
if (isset($config['tasks'])) {
foreach ($config['tasks'] as $row) {
$tasks[$row['item']] = $row['title'];
}
}
$this->data['tasks'] = $tasks;
$this->data['groups'] = \DB::table('tb_groups')->get();
$access = array();
foreach ($this->data['groups'] as $r) {
// $GA = $this->model->gAccessss($this->uri->rsegment(3),$row['group_id']);
$group = ($r->group_id != null ? "and group_id ='" . $r->group_id . "'" : "");
$GA = \DB::select("SELECT * FROM tb_groups_access where module_id ='" . $row->module_id . "' $group");
if (count($GA) >= 1) {
$GA = $GA[0];
}
$access_data = (isset($GA->access_data) ? json_decode($GA->access_data, true) : array());
$rows = array();
//$access_data = json_decode($AD,true);
$rows['group_id'] = $r->group_id;
$rows['group_name'] = $r->name;
foreach ($tasks as $item => $val) {
$rows[$item] = (isset($access_data[$item]) && $access_data[$item] == 1 ? 1 : 0);
}
$access[$r->name] = $rows;
}
$this->data['access'] = $access;
$this->data['groups_access'] = \DB::select("select * from tb_groups_access where module_id ='" . $row->module_id . "'");
$this->data['type'] = ($row->module_type == 'ajax' ? 'addon' : $row->module_type);
return view('central.module.permission', $this->data);
}
public function postSavepermission(Request $request, $moduleKey)
{
$row = config("modules.{$moduleKey}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
$fp = base_path() . '/resources/views/central/module/template/' . $this->getTemplateName($row->module_type) . '/config/info.json';
$fp = json_decode(file_get_contents($fp), true);
$tasks = $fp['access'];
/* Update permission global / own access new ver 1.1
Adding new param is_global
End Update permission global / own access new ver 1.1
*/
if (isset($config['tasks'])) {
foreach ($config['tasks'] as $row) {
$tasks[$row['item']] = $row['title'];
}
}
$permission = array();
$groupID = $request->input('group_id');
for ($i = 0; $i < count($groupID); $i++) {
// remove current group_access
$group_id = $groupID[$i];
\DB::table('tb_groups_access')
->where('module_id', '=', $request->input('module_id'))
->where('group_id', '=', $group_id)
->delete();
$arr = array();
$id = $groupID[$i];
foreach ($tasks as $t => $v) {
$arr[$t] = (isset($_POST[$t][$id]) ? "1" : "0");
}
$permissions = json_encode($arr);
$data = array(
"access_data" => $permissions,
"module_id" => $request->input('module_id'),
"group_id" => $groupID[$i],
);
\DB::table('tb_groups_access')->insert($data);
\Cache::forget('GetAccess_' . $request->input('module_id') . '_' . $group_id);
}
if ($request->ajax() == true) {
return response()->json(array('status' => 'success', 'message' => 'Permission Has Changed Successful'));
} else {
return redirect('central/module/permission/' . $row->module_name)
->with('message', 'Permission Has Changed Successful')->with('status', 'success');
}
}
function getBuild($id)
{
$row = \DB::table('tb_module')->where('module_name', $id)
->get();
if (count($row) <= 0) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = $row[0];
$this->data['module'] = 'module';
$this->data['module_name'] = $id;
$this->data['module_id'] = $row->module_id;
return view('central.module.build', $this->data);
}
function getFormdesign(Request $request, $id)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
$this->data['forms'] = $config['forms'];
$this->data['module'] = 'module';
$this->data['form_column'] = (isset($config['form_column']) ? $config['form_column'] : 1);
if (!is_null($request->input('block'))) $this->data['form_column'] = $request->input('block');
if (!isset($config['form_layout'])) {
$this->data['title'] = array($row->module_name);
$this->data['format'] = 'grid';
$this->data['display'] = 'horizontal';
} else {
$this->data['title'] = explode(",", $config['form_layout']['title']);
$this->data['format'] = $config['form_layout']['format'];
$this->data['display'] = (isset($config['form_layout']['display']) ? $config['form_layout']['display'] : 'horizontal');
}
$this->data['module_name'] = $row->module_name;
$this->data['type'] = $row->module_type;
return view('central.module.formdesign', $this->data);
}
public function postFormdesign(Request $request)
{
$id = $request->input('module_id');
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
$data = $_POST['reordering'];
$data = explode('|', $data);
$currForm = $config['forms'];
foreach ($currForm as $f) {
$cform[$f['field']] = $f;
}
$i = 0;
$order = 0;
$f = array();
foreach ($data as $dat) {
$forms = explode(",", $dat);
foreach ($forms as $form) {
if (isset($cform[$form])) {
$cform[$form]['form_group'] = $i;
$cform[$form]['sortlist'] = $order;
$f[] = $cform[$form];
}
$order++;
}
$i++;
}
$config['form_column'] = count($data);
$config['form_layout'] = array(
'column' => count($data),
'title' => implode(',', $request->input('title')),
'format' => $request->input('format'),
'display' => $request->input('display')
);
unset($config["forms"]);
$new_config = array_merge($config, array("forms" => $f));
$data['module_config'] = \SiteHelpers::CF_encode_json($new_config);
\DB::table('tb_module')
->where('module_id', '=', $id)
->update(array('module_config' => \SiteHelpers::CF_encode_json($new_config)));
$this->clearModuleCache($row->module_name);
return redirect('central/module/formdesign/' . $row->module_name)
->with('message', ' Forms Design Has Changed Successful.')->with('status', 'success');
}
function getSub(Request $request, $id = '')
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$config = $row->module_config;
$this->data['row'] = $row;
$this->data['fields'] = $config['grid'];
$this->data['subs'] = (isset($config['subgrid']) ? $config['subgrid'] : array());
$this->data['tables'] = Module::getTableList($this->db);
$this->data['module'] = $row->module_name;
$this->data['module_name'] = $id;
$this->data['type'] = ($row->module_type == 'ajax' ? 'addon' : $row->module_type);
$this->data['modules'] = Module::all();
return view('central.module.sub', $this->data);
}
function postSavesub(Request $request)
{
$rules = array(
'title' => 'required',
'master' => 'required',
'master_key' => 'required',
'module' => 'required',
'key' => 'required',
);
$validator = Validator::make($request->all(), $rules);
if ($validator->passes()) {
$id = $request->get('module_id');
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
$newData[] = array(
'title' => $request->get('title'),
'master' => $request->get('master'),
'master_key' => $request->get('master_key'),
'module' => $request->get('module'),
'table' => $request->get('table'),
'key' => $request->get('key'),
);
$subgrid = array();
if (isset($config["subgrid"])) {
foreach ($config['subgrid'] as $sb) {
$subgrid[] = $sb;
}
}
$subgrid = array_merge($subgrid, $newData);
if (isset($config["subgrid"])) unset($config["subgrid"]);
$new_config = array_merge($config, array("subgrid" => $subgrid));
$affected = \DB::table('tb_module')
->where('module_id', '=', $id)
->update(array('module_config' => \SiteHelpers::CF_encode_json($new_config)));
$this->clearModuleCache($row->module_name);
if ($request->ajax() == true) {
return response()->json(array('status' => 'success', 'message' => 'Master Has beed added Successful.'));
} else {
return redirect('central/module/sub/' . $row->module_name)
->with('message', 'Master Has beed added Successful.')->with('status', 'success');
}
} else {
return redirect('central/module/sub/' . $request->get('module_name'))
->with('message', 'The following errors occurred')->with('status', 'error')
->withErrors($validator)->withInput();
}
}
function getRemovesub(Request $request)
{
$id = $request->get('id');
$module = $request->get('mod');
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
$subgrid = array();
foreach ($config['subgrid'] as $sb) {
if ($sb['module'] != $module) {
$subgrid[] = $sb;
}
}
unset($config["subgrid"]);
$new_config = array_merge($config, array("subgrid" => $subgrid));
$affected = \DB::table('tb_module')
->where('module_id', '=', $id)
->update(array('module_config' => \SiteHelpers::CF_encode_json($new_config)));
return redirect('central/module/sub/' . $row->module_name)
->with('message', 'Master Has removed Successful.')->with('status', 'success');
}
function getConn(Request $request, $id)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
$module_id = $id;
$field_id = $request->input('field');
$alias = $request->input('alias');
$f = array();
foreach ($config['grid'] as $form) {
if ($form['field'] == $field_id) {
$f = array(
'db' => (isset($form['conn']['db']) ? $form['conn']['db'] : ''),
'key' => (isset($form['conn']['key']) ? $form['conn']['key'] : ''),
'display' => (isset($form['conn']['display']) ? $form['conn']['display'] : ''),
);
}
}
$this->data['module_id'] = $id;
$this->data['f'] = $f;
$this->data['module'] = 'module';
$this->data['module_name'] = $row->module_name;
$this->data['field_id'] = $field_id;
$this->data['alias'] = $alias;
return view('central.module.connection', $this->data);
}
public function postConn(Request $request)
{
$id = $request->input('module_id');
$field_id = $request->input('field_id');
$alias = $request->input('alias');
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$fr = array();
$config = $row->module_config;
foreach ($config['grid'] as $form) {
if ($form['field'] == $field_id && $form['alias'] == $alias) {
if ($request->input('db') != '') {
$value = implode("|", $request->input('display'));
$form['conn'] = array(
'valid' => '1',
'db' => $request->input('db'),
'key' => $request->input('key'),
'display' => implode("|", array_filter($request->input('display'))),
);
} else {
$form['conn'] = array(
'valid' => '0',
'db' => '',
'key' => '',
'display' => '',
);
}
$fr[] = $form;
} else {
$fr[] = $form;
}
}
unset($config["grid"]);
$new_config = array_merge($config, array("grid" => $fr));
$affected = \DB::table('tb_module')
->where('module_id', '=', $id)
->update(array('module_config' => \SiteHelpers::CF_encode_json($new_config)));
$this->clearModuleCache($row->module_name);
return redirect('central/module/table/' . $row->module_name)
->with('message', 'Module Forms Has Changed Successful.')->with('status', 'success');
}
function configGrid($field, $alias, $type, $default_value, $is_null, $sort, $comment, $opt = array())
{
$options = [];
$this->configFieldType($type, $validation, $comment, $options);
($is_null == 'YES' || $is_null == 'Yes' || $is_null == 'yes' || $type == 'hidden' || $field == 'created_at' || $field == 'updated_at') ? $hidden = 0 : $hidden = 1;
// dump($field.' ==> '.$type);
$format_as = '';
if ($type == 'lang') $format_as = 'lang';
$conn = array('valid' => '0', 'db' => '', 'key' => '', 'display' => '');
if (isset($opt['opt_type'])) {
if ($opt['opt_type'] == 'external') {
$conn = array('valid' => 1, 'db' => $opt['lookup_table'], 'key' => $opt['lookup_key'], 'display' => $opt['lookup_value']);
}
}
$grid = array(
"field" => $field,
"alias" => $alias,
"label" => ucwords(str_replace('_', ' ', $field)),
"language" => array(),
"search" => '1',
"download" => '1',
"align" => 'left',
"view" => $hidden,
"detail" => '1',
"sortable" => '1',
"frozen" => '0',
'hidden' => '0',
"sortlist" => $sort,
"width" => '100',
"conn" => $conn,
"format_as" => $format_as,
"format_value" => '',
);
return $grid;
}
function configForm($field, $alias, $type, $default_value, $is_null, $sort, $comment, $opt = array())
{
$validation = '';
$options = array(
"opt_type" => '',
"lookup_query" => '',
"lookup_table" => '',
"lookup_key" => '',
"lookup_value" => '',
'is_dependency' => '',
'select_multiple' => '0',
'image_multiple' => '0',
'lookup_dependency_key' => '',
'lookup_where_clause' => '',
'path_to_upload' => '',
'upload_type' => '',
'tooltip' => '',
'attribute' => '',
'extend_class' => '',
'is_json' => 0,
'is_ajax' => 1,
);
if (count($opt) > 1) {
$options = array_merge($options, $opt);
$type = 'select';
}
$this->configFieldType($type, $validation, $comment, $options);
if ($field == 'created_at' || $field == 'updated_at') $type = 'update_timestamp';
($is_null == 'YES' || $is_null == 'yes') ? $required = 0 : $required = 1;
$forms = array(
"field" => $field,
"alias" => $alias,
"label" => ucwords(str_replace('_', ' ', $field)),
"language" => array(),
'required' => $required,
'unique' => 0,
'default' => $default_value,
'validations' => $validation,
'view' => '1',
'type' => $type,
'add' => '1',
'edit' => '1',
'search' => '1',
'size' => 'span12',
"sortlist" => $sort,
'form_group' => '',
'option' => $options
);
return $forms;
}
function configFieldType(&$type, &$validation, $comment, &$options)
{
$validation = '';
$comment_settings = [];
if (count(explode('||', $comment)) > 1) {
$comment_all = explode('||', $comment);
$comment_parsed = explode(',', $comment_all[1]);
foreach ($comment_parsed as $cparsd) {
$cparsd = explode('=', $cparsd);
if (count($cparsd) == 2)
$comment_settings[$cparsd[0]] = $cparsd[1];
}
}
$type = trim(str_replace('unsigned', '', ($type)));
$values = [];
if (preg_match('/([0-9,]+)/', $type)) {
$values = explode(',', trim(substr($type, strpos($type, '(')), '()'));
$type = substr($type, 0, strpos($type, '('));
}
if (isset($comment_settings['type']))
$type = $comment_settings['type'];
// echo 'Start Type :: ' . $type . ' |||||||||||||| ';
// dump($values);
switch ($type) {
default:
$type = 'text';
if (count($values) > 0)
$validation = 'maxlength="' . $values[0] . '"';
break;
case 'timestamp';
$type = 'text_datetime';
break;
case 'datetime';
$type = 'text_datetime';
break;
case 'string';
if (count($values) > 0)
$validation = 'maxlength="' . $values[0] . '"';
$type = 'text';
break;
case 'int';
$type = 'text_number';
if (count($values) > 0)
$validation = 'maxlength="' . $values[0] . '"';
break;
case 'decimal';
$type = 'text_decimal';
if (count($values) > 0)
$validation = 'maxlength="' . ($values[0]) . '"';
break;
case 'text';
$type = 'textarea_editor';
break;
case 'blob';
$type = 'textarea';
break;
case 'tinyint';
if (count($values) > 0) {
if ($values[0] == '1' || $values[0] == 1) {
$type = 'switch';
break;
} else {
$validation = 'maxlength="' . $values[0] . '"';
$type = 'text_number';
break;
}
} else
$type = 'text_number';
break;
case 'json_editor';
$type = 'json_editor';
break;
case 'select';
$type = 'select';
break;
case 'lang';
$type = 'lang';
break;
case 'hidden';
$type = 'hidden';
break;
case 'enum';
$type = 'radio';
$radio_options = array_map(function ($value) {
return trim($value, "'") . ':' . ucfirst(trim($value, "'"));
}, $values);
$options['lookup_query'] = implode('|', $radio_options);
break;
case 'set';
$type = 'radio';
$radio_options = array_map(function ($value) {
return trim($value, "'") . ':' . ucfirst(trim($value, "'"));
}, $values);
$options['lookup_query'] = str_replace("'", '', implode('|', $radio_options));
break;
case 'year';
$validation = 'maxlength="' . $values[0] . '"';
$type = 'text_number';
break;
case 'tinyint';
if (count($values) > 0)
$validation = 'maxlength="' . $values[0] . '"';
$type = 'text_number';
break;
case 'json';
$type = 'json';
break;
case 'json_select';
$type = 'select';
$select_options = array(
"opt_type" => 'external',
"lookup_table" => $comment_settings['table'],
"lookup_key" => $comment_settings['id'],
"lookup_value" => $comment_settings['name'],
'select_multiple' => $comment_settings['multi'],
'is_json' => 1,
'is_ajax' => 1,
);
$options = array_merge($options, $select_options);
break;
case 'image';
$type = 'image';
$options['path_to_upload'] = isset($comment_settings['path']) ? $comment_settings['path'] : '/uploads/images/';
break;
}
// echo 'End Type :: ' . $type . '
';
return $type;
}
public function getCombotable(Request $request)
{
if ($request->ajax() == true && \Auth::check() == true) {
$rows = Module::getTableList($this->db);
$items = array();
foreach ($rows as $row) $items[] = array($row, $row);
return json_encode($items);
} else {
return json_encode(array('OMG' => " Ops .. Cant access the page !"));
}
}
public function getCombotablefield(Request $request)
{
if ($request->input('table') == '') return json_encode(array());
if ($request->ajax() == true && \Auth::check() == true) {
$items = array();
$table = $request->input('table');
if ($table != '') {
$rows = Module::getTableField($request->input('table'));
foreach ($rows as $row)
$items[] = array($row, $row);
}
return json_encode($items);
} else {
return json_encode(array('OMG' => " Ops .. Cant access the page !"));
}
}
function postDobuild(Request $request, $id)
{
$id = $request->input('module_id');
$c = (isset($_POST['controller']) ? 'y' : 'n');
$m = (isset($_POST['model']) ? 'y' : 'n');
$g = (isset($_POST['grid']) ? 'y' : 'n');
$f = (isset($_POST['form']) ? 'y' : 'n');
$v = (isset($_POST['view']) ? 'y' : 'n');
$fg = (isset($_POST['frontgrid']) ? 'y' : 'n');
$fv = (isset($_POST['frontview']) ? 'y' : 'n');
$ff = (isset($_POST['frontform']) ? 'y' : 'n');
//return redirect('')
$url = 'central/module/rebuild/' . $id . "?rebuild=y&c={$c}&m={$m}&g={$g}&f={$f}&v={$v}&fg={$fg}&fv={$fv}&ff={$ff}";
if (\Request::ajax() == 'ajax') {
return response()->json(array('status' => 'success', 'url' => url($url)));
} else {
return redirect($url);
}
}
public function getRebuild(Request $request, $id = 0)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
$class = $row->module_name;
$ctr = ucwords($row->module_name);
$path = $row->module_name;
// build Field entry
$f = '';
$req = '';
// End Build Fi global $codes;
$codes = array(
'controller' => ucwords($class),
'class' => $class,
'fields' => $f,
'required' => $req,
'table' => $row->module_db,
'title' => $row->module_title,
'note' => $row->module_note,
'key' => $row->module_db_key,
'sql_select' => $config['sql_select'],
'sql_where' => $config['sql_where'],
'sql_group' => $config['sql_group'],
);
if (!isset($config['form_layout']))
$config['form_layout'] = array('column' => 1, 'title' => $row->module_title, 'format' => 'grid', 'display' => 'horizontal');
$codes['form_javascript'] = \SiteHelpers::toJavascript($config['forms'], $path, $class);
$codes['form_entry'] = \SiteHelpers::toForm($config['forms'], $config['form_layout']);
$codes['form_display'] = (isset($config['form_layout']['display']) ? $config['form_layout']['display'] : 'horizontal');
$codes['form_view'] = \SiteHelpers::toView($config['grid']);
// $codes['form_maps'] = \SiteHelpers::toMaps($config['grid']);
$codes['masterdetailmodel'] = '';
$codes['masterdetailinfo'] = '';
$codes['masterdetailgrid'] = '';
$codes['masterdetailsave'] = '';
$codes['masterdetailform'] = '';
$codes['masterdetailformFooter'] = '';
$codes['masterdetailsubform'] = '';
$codes['masterdetailview'] = '';
$codes['masterdetailjs'] = '';
$codes['masterdetaildelete'] = '';
/* Subform */
if (isset($config['subform'])) {
$md = \SiteHelpers::toMasterDetail($config['subform']);
$codes['masterdetailmodel'] = $md['masterdetailmodel'];
$codes['masterdetailinfo'] = $md['masterdetailinfo'];
$codes['masterdetailsave'] = $md['masterdetailsave'];
$codes['masterdetailsubform'] = $md['masterdetailsubform'];
$codes['masterdetailform'] = $md['masterdetailform'];
$codes['masterdetaildelete'] = $md['masterdetaildelete'];
$codes['masterdetailjs'] = $md['masterdetailjs'];
$codes['masterdetailformFooter'] = $md['masterdetailformFooter'];
}
self::removeDir(base_path() . "/resources/views/{$path}");
/* End Master Detail */
$dir = base_path() . '/resources/views/manage/' . $class;
$dirPublic = base_path() . '/resources/views/manage/' . $class . '/public';
$dirC = app_path() . '/Http/Controllers/';
$dirM = app_path() . '/Models/';
if (!is_dir($dir)) mkdir($dir, 0777);
if (!is_dir($dirPublic)) mkdir($dirPublic, 0777);
/* find type of module and generate it */
$mType = ($row->module_type == 'addon' ? 'native' : $row->module_type);
if (is_dir(base_path() . '/resources/views/central/module/template/' . $mType)) {
require_once(base_path() . '/resources/views/central/module/template/' . $mType . '/config/config.php');
} else {
if ($request->ajax() == true && \Auth::check() == true) {
return response()->json(array('status' => 'success', 'message' => 'Template is Not Exists'));
} else {
return redirect('central/module')->with('message', 'Template is Not Exists')
->with('status', 'success');
}
}
self::createRouters();
if ($request->ajax() == true && \Auth::check() == true) {
return response()->json(array('status' => 'success', 'message' => 'Code Script has been replaced successfull'));
} else {
return redirect('central/module')->with('message', 'Code Script has been replaced successfull')->with('status', 'success');
}
}
function findPrimarykey($table)
{
// show columns from members where extra like '%auto_increment%'"
$query = "SHOW columns FROM {$table} WHERE extra LIKE '%auto_increment%'";
$primaryKey = '';
foreach (\DB::select($query) as $key) {
$primaryKey = $key->Field;
// print_r($key);
}
return $primaryKey;
}
function getRelationSelects($table)
{
$relSelects = [];
$rels = \DB::table('information_schema.key_column_usage')->whereRaw('referenced_table_name IS NOT NULL')->where('table_name', $table)->where('table_schema', $this->db)->get();
foreach ($rels as $rel) {
$name_col = $rel->REFERENCED_TABLE_NAME;
$id_found = false;
$colms = \DB::select("SHOW COLUMNS from " . $rel->REFERENCED_TABLE_NAME);
foreach ($colms as $colm) {
if ($id_found) {
$name_col = $colm->Field;
break;
}
if ($colm->Field == $rel->REFERENCED_COLUMN_NAME)
$id_found = true;
}
$relSelects[$rel->COLUMN_NAME] = array(
"opt_type" => 'external',
"lookup_table" => $rel->REFERENCED_TABLE_NAME,
"lookup_key" => $rel->REFERENCED_COLUMN_NAME,
"lookup_value" => $name_col,
'select_multiple' => 0,
);
//$relSelects[$rel->COLUMN_NAME] = array()
}
return $relSelects;
}
function createRouters()
{
$rows = \DB::table('tb_module')->where('module_type', '!=', 'core')->get();
$val = "group(function () {
";
foreach ($rows as $row) {
$class = $row->module_name;
$controller = ucwords($row->module_name) . 'Controller';
$mType = ($row->module_type == 'addon' ? 'native' : $row->module_type);
include(base_path() . '/resources/views/central/module/template/' . $row->module_type . '/config/route.php');
}
$val .= "
});
";
$filename = base_path() . '/routes/module.php';
$fp = fopen($filename, "w+");
fwrite($fp, $val);
fclose($fp);
return true;
}
function postPackage(Request $request)
{
if (count($id = $request->input('id')) < 1) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
};
$_id = array();
foreach ($id as $k => $v) {
if (!is_numeric($v)) continue;
$_id[] = $v;
}
$ids = implode(',', $_id);
$sql = "
SELECT * FROM tb_module
WHERE module_id IN (" . $ids . ")
ORDER by module_id
";
$rows = \DB::select($sql);
$this->data['zip_content'] = array();
$app_info = array();
$inc_tables = array();
foreach ($rows as $k => $row) {
$zip_content[] = array(
'module_id' => $row->module_id,
'module_name' => $row->module_name,
'module_db' => $row->module_db,
'module_type' => $row->module_type,
);
}
// encrypt info
$this->data['enc_module'] = base64_encode(serialize($zip_content));
$this->data['enc_id'] = base64_encode(serialize($id));
// module info
$this->data['zip_content'] = $zip_content;
/* CHANGE START HERE */
$app_path = base_path();
// file helper list
$_path_inc = array('app/Library', 'resources/lang/en');
foreach ($_path_inc as $path) {
$file_inc[$path] = scandir($app_path . '/' . $path);
foreach ($file_inc[$path] as $k => $v) {
if ($v == '.' || $v == '..') unset($file_inc[$path][$k]);
if (!preg_match('/.php$/i', $v)) unset($file_inc[$path][$k]);
}
}
$this->data['file_inc'] = $file_inc;
/* CHANGE END HERE */
return view('central.module.package', $this->data);
}
function postDopackage(Request $request)
{
// app name
$app_name = $request->input('app_name');
// encrypt info
$enc_module = $request->input('enc_module');
$enc_id = $request->input('enc_id');
// query command || file
$sql_cmd = $request->input('sql_cmd');
if (!($_FILES['sql_cmd_upload']['error'])) {
$sql_path = input::file('sql_cmd_upload')->getrealpath();
if ($sql_content = file_get_contents($sql_path)) {
$sql_cmd = $sql_content;
}
}
/* CHANGE START */
// file to include
$file_library = $request->input('file_library');
$file_lang = $request->input('file_lang');
/* CHANGE END */
// create app name
$tapp_code = preg_replace('/([s[:punct:]]+)/', ' ', $app_name);
$app_code = str_replace(' ', '_', trim($tapp_code));
$module_id = unserialize(base64_decode($enc_id));
$modules = unserialize(base64_decode($enc_module));
$c_module_id = implode(',', $module_id);
$zip_file = $app_code . ".zip";
$cf_zip = new \ZipHelpers;
$app_path = app_path();
$cf_zip->add_data(".mysql", $sql_cmd);
// App ID Name
$ain = $module_id;
$cf_zip->add_data(".ain", base64_encode(serialize($ain)));
// setting
$sql = " select * from tb_module where module_id in ( {$c_module_id} )";
$_modules = \DB::select($sql);
foreach ($_modules as $n => $_module) {
$_modules[$n]->module_id = '';
}
$setting['tb_module'] = $_modules;
$cf_zip->add_data(".setting", base64_encode(serialize($setting)));
unset($_module);
foreach ($_modules as $n => $_module) {
$file = $_module->module_name;
$cf_zip->add_data(
"app/Http/Controllers/" . ucwords($file) . "Controller.php",
file_get_contents($app_path . "/Http/Controllers/" . ucwords($file) . "Controller.php")
);
$cf_zip->add_data("app/Models/" . ucwords($file) . ".php", file_get_contents($app_path . "/Models/" . ucwords($file) . ".php"));
$cf_zip->get_files_from_folder("../resources/views/manage/{$file}/", "resources/views/manage/{$file}/");
}
// CHANGE START
// push library files
if (!empty($file_library)) {
foreach ($file_library as $k => $file) {
$cf_zip->add_data(
"app/Library/" . $file,
file_get_contents($app_path . "/Library/" . $file)
);
}
}
// push language files
if (!empty($file_lang)) {
$lang_path = scandir(base_path() . '/resources/lang/');
foreach ($lang_path as $k => $path) {
if ($path == '.' || $path == '..') continue;
if (is_file($app_path . '/' . $path)) continue;
foreach ($file_lang as $k => $file) {
$cf_zip->add_data(
'resources/lang/' . $path . '/' . $file,
file_get_contents(base_path() . "/resources/lang/" . $path . '/' . $file)
);
}
}
$this->data['lang_path'] = $lang_path;
}
// CHANGE END
$_zip = $cf_zip->archive($zip_file);
$cf_zip->clear_data();
$this->data['download_link'] = link_to("modules/{$app_name}.zip", "download here", array('target' => '_new'));
$this->data['module_title'] = "ZIP Packager";
$this->data['app_name'] = $app_name;
return redirect('central/module?downloadLink=' . $zip_file)
->with('message', ' Module(s) zipped successful ! ')->with('status', 'success');
}
function postInstall(Request $request, $id = 0)
{
$rules = array(
'installer' => 'required'
);
$validator = Validator::make($request->all(), $rules);
if ($validator->passes()) {
$path = $_FILES['installer']['tmp_name'];
$data = \CentralHelpers::cf_unpackage($path);
$msg = '.';
if (isset($data['sql_error'])) {
$msg = ", with SQL error " . $data['sql_error'];
}
self::createRouters();
return redirect('central/module')->with('message', 'Module Installed' . $msg)->with('status', 'success');
} else {
return redirect('central/module')->with('message', 'Please select file to upload !')->with('status', 'error');
}
}
function getSubform(Request $request, $id = 0)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$config = $row->module_config;
$this->data['row'] = $row;
$this->data['fields'] = $config['grid'];
$this->data['subform'] = (isset($config['subform']) ? $config['subform'] : array());
// print_r($this->data['subform']);
$this->data['tables'] = Module::getTableList($this->db);
$this->data['module'] = $row->module_name;
$this->data['module_name'] = $id;
$this->data['type'] = $row->module_type;
$this->data['modules'] = Module::all();
return view('central.module.subform', $this->data);
}
function postSavesubform(Request $request)
{
$rules = array(
'title' => 'required',
'master' => 'required',
'master_key' => 'required',
'module' => 'required',
'key' => 'required',
);
$validator = Validator::make($request->all(), $rules);
if ($validator->passes()) {
$id = $request->get('module_id');
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
$subform = array(
'title' => $request->get('title'),
'master' => $request->get('master'),
'master_key' => $request->get('master_key'),
'module' => $request->get('module'),
'table' => $request->get('table'),
'key' => $request->get('key'),
);
/*
$subform = array();
if(isset($config["subform"]))
{
foreach($config['subform'] as $sb)
{
$subgrid[] =$sb;
}
}
$subform = array_merge($subform,$newData);
*/
if (isset($config["subform"])) unset($config["subform"]);
$new_config = array_merge($config, array("subform" => $subform));
$affected = \DB::table('tb_module')
->where('module_id', '=', $id)
->update(array('module_config' => \SiteHelpers::CF_encode_json($new_config)));
$this->clearModuleCache($row->module_name);
if ($request->ajax() == true) {
return response()->json(array('status' => 'success', 'message' => 'Subform has beed added Successful'));
} else {
return redirect('central/module/subform/' . $row->module_name)
->with('message', 'Subform has beed added Successful.')->with('status', 'success');
}
} else {
return redirect('central/module/subform/' . $request->get('module_name'))
->with('message', 'The following errors occurred')->with('status', 'error')
->withErrors($validator)->withInput();
}
}
function getSubformremove(Request $request, $id = 0)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$config = $row->module_config;
unset($config["subform"]);
// echo ''; print_r($config); echo '
'; exit;
// $new_config = array_merge($config,array("subform" => array()));
$affected = \DB::table('tb_module')
->where('module_id', '=', $row->module_id)
->update(array('module_config' => \SiteHelpers::CF_encode_json($config)));
$this->clearModuleCache($row->module_name);
return redirect('central/module/subform/' . $row->module_name)
->with('message', 'Subform has beed Removed Successful.')->with('status', 'success');
}
function getSource(Request $request, $id)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$this->data['module'] = 'module';
$this->data['module_lang'] = json_decode($row->module_lang, true);
$this->data['module_name'] = $row->module_name;
$config = $row->module_config;
$this->data['tables'] = $config['grid'];
$this->data['type'] = $row->module_type;
return view('central.module.source', $this->data);
}
function postSource(Request $request)
{
$_POST['dir'] = urldecode($_POST['dir']);
$root = base_path() . '/resources/views';
$res = '';
if (file_exists($root . $_POST['dir'])) {
$files = scandir($root . $_POST['dir']);
natcasesort($files);
if (count($files) > 2) { /* The 2 accounts for . and .. */
$res .= "";
// All dirs
foreach ($files as $file) {
if (file_exists($root . $_POST['dir'] . $file) && $file != '.' && $file != '..' && is_dir($root . $_POST['dir'] . $file)) {
$res .= "- " . htmlentities($file) . "
";
}
}
// All files
foreach ($files as $file) {
if (file_exists($root . $_POST['dir'] . $file) && $file != '.' && $file != '..' && !is_dir($root . $_POST['dir'] . $file)) {
$ext = preg_replace('/^.*\./', '', $file);
$res .= "- " . htmlentities($file) . "
";
}
}
$res .= "
";
}
return $res;
} else {
return 'Folder is not exists';
}
}
function getCode(Request $request)
{
$path = $request->input('path');
$file = base_path() . '/resources/views' . $path;
if (file_exists($file)) {
return array(
'path' => 'resources/views' . $path,
'content' => file_get_contents($file)
);
} else {
return 'error';
}
}
function postCode(Request $request, $id)
{
$content = $request->input('content_html');
$filename = base_path() . '/' . $request->input('path');
if (file_exists($filename)) {
$fp = fopen($filename, "w+");
fwrite($fp, $content);
fclose($fp);
return response()->json(['status' => 'success', 'message' => \SiteHelpers::alert('success', 'File has been changed')]);
// Return return json_encode(array());
} else {
return response()->json(['status' => 'error', 'message' => \SiteHelpers::alert('success', 'Error while saving changes')]);
}
}
public function getDuplicate(Request $request, $id)
{
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$this->data['module'] = 'module';
$this->data['module_lang'] = json_decode($row->module_lang, true);
$this->data['module_name'] = $row->module_name;
$config = $row->module_config;
// echo ''; print_r($config); echo '
';
$this->data['tables'] = $config['grid'];
$this->data['type'] = $row->module_type;
return view('central.module.duplicate', $this->data);
}
public function postDuplicate(Request $request, $id)
{
$rules = array(
'module_name' => 'required|alpha|min:2|unique:tb_module',
'module_title' => 'required',
'module_note' => 'required',
);
$validator = Validator::make($request->all(), $rules);
if ($validator->passes()) {
$row = config("modules.{$id}");
if (empty($row)) {
return redirect('central/module')->with('message', 'Can not find module')->with('status', 'error');
}
$row = (object)$row;
$this->data['row'] = $row;
$config = $row->module_config;
foreach (\DB::select("SHOW COLUMNS FROM tb_module ") as $column) {
if ($column->Field != 'module_id')
$columns[] = $column->Field;
}
$sql = "INSERT INTO tb_module (" . implode(",", $columns) . ") ";
$sql .= " SELECT " . implode(",", $columns) . " FROM tb_module WHERE module_id = '" . $id . "'";
\DB::select($sql);
$res = \DB::select('select * from tb_module order by module_id desc limit 1');
if (count($res) >= 1) {
$row = $res[0];
// echo $row->module_id ; exit;
$data = array(
'module_title' => trim($request->module_title),
'module_name' => trim($request->module_name),
'module_note' => trim($request->module_note),
'module_author' => \Session::get('fid')
);
\DB::table('tb_module')->where('module_id', $row->module_id)->update($data);
$this->clearModuleCache($request->module_name);
// Add Default permission
$tasks = array(
'is_global' => 'Global',
'is_view' => 'View ',
'is_detail' => 'Detail',
'is_add' => 'Add ',
'is_edit' => 'Edit ',
'is_remove' => 'Remove ',
'is_excel' => 'Excel ',
);
$groups = \DB::table('tb_groups')->get();
$rows = \DB::table('tb_module')->where('module_id', $row->module_id)->get();
if (count($rows) >= 1) {
$id = $rows[0];
foreach ($groups as $g) {
$arr = array();
foreach ($tasks as $t => $v) {
if ($g->group_id == '1') {
$arr[$t] = '1';
} else {
$arr[$t] = '0';
}
}
$data = array(
"access_data" => json_encode($arr),
"module_id" => $id->module_id,
"group_id" => $g->group_id,
);
\DB::table('tb_groups_access')->insert($data);
}
}
return redirect('central/module/rebuild/' . $row->module_id . '?mode=duplicate');
} else {
return redirect('central/module')->with('message', 'Failed to Duplicate Module !')->with('status', 'error');
}
}
}
function getTemplateName($file)
{
if ($file == 'addon' or $file == 'core') {
return 'native';
} else {
return $file;
}
}
}