public function content($sys_object_id)
{
$sys_object = new Crud_Models_Object();
$sys_object->load(intval($sys_object_id));
$sys_object->loadFieldsForObject();
if ($sys_object->is_system == 1 && $this->user->role->safe_title != 'administrator') {
echo '<script>window.location="' . SITE_ROOT_URI . '/admin/error/' . '"</script>';
exit;
}
if (!$this->user->role->canExecuteAction('can_view_' . $sys_object->table_name)) {
echo '<script>window.location="' . SITE_ROOT_URI . '/admin/error/' . '"</script>';
exit;
}
$order = array();
$order[] = array('title', 'ASC');
$role = new Libraries_Db_Mysql_Model('adm_user_role');
$roles = $role->search(array(), $order);
if (isset($_POST) && !empty($_POST)) {
foreach ($roles as $role) {
$sql = "DELETE \r\n\t\t\t\t\t\tFROM adm_user_role_permission\r\n\t\t\t\t\t\tWHERE id_adm_user_role = ?";
$data = array($role->id);
Libraries_Db_Factory::getDb()->execute($sql, $data);
foreach ($_POST as $action => $data) {
$permission = new Libraries_Db_Mysql_Model('adm_user_role_permission');
$permission->id_adm_user_role = $role->id;
$permission->action = $action;
$permission->is_active = array_key_exists($role->id, $data) && $data[$role->id] == 1 ? 1 : 0;
$permission->save();
}
}
Libraries_Flashdata::set('saved', __('Permissions is saved'));
}
$order = array();
$order[] = array('table_name', 'ASC');
$where = array();
$where[] = array('AND', 'is_system', '!=', 1);
$objects = $sys_object->search($where, $order);
Libraries_View::getInstance()->roles = $roles;
Libraries_View::getInstance()->objects = $objects;
Libraries_View::getInstance()->saved_status = Libraries_Flashdata::get('saved');
$content = Libraries_View::getInstance()->setModule('admin')->load('permissions');
Libraries_Layout::getInstance()->setTheme('admin');
Libraries_Layout::getInstance()->setLayout('admin');
Libraries_Layout::getInstance()->setRegionContent('content', $content);
Libraries_Layout::getInstance()->render();
}
public function index()
{
$where = array();
$order = array();
$order[] = array('group_name', 'ASC');
$order[] = array('order_index', 'DESC');
$sys_object = new Crud_Models_Object();
$sys_object_list = $sys_object->search($where, $order);
foreach ($sys_object_list as $sys_object) {
$sys_object->loadFieldsForObject();
}
$user = Admin_Libraries_Admin::getLogedUser()->loadRole();
Libraries_View::getInstance()->sys_object_list = $sys_object_list;
Libraries_View::getInstance()->user = user;
$content = Libraries_View::getInstance()->setModule('crud')->load('objects');
Libraries_Layout::getInstance()->setTheme('admin');
Libraries_Layout::getInstance()->setLayout('admin');
Libraries_Layout::getInstance()->setRegionContent('content', $content);
Libraries_Layout::getInstance()->render();
}
public function loadsubforms($parent_sys_object_id)
{
// load relations
$where = array();
$order = array();
$where[] = array('AND', 'id_sys_object_parent', '=', $parent_sys_object_id);
$order[] = array('table_name', 'ASC');
$selected_maped_object = new Crud_Models_Subform();
$selected_maped_objects = $selected_maped_object->search($where);
// load maped objects
$where = array();
$order = array();
$where[] = array('AND', 'id', '!=', $parent_sys_object_id);
$order[] = array('table_name', 'ASC');
$maped_object = new Crud_Models_Object();
$maped_objects = $maped_object->search($where, $order);
Libraries_View::getInstance()->selected_maped_objects = $selected_maped_objects;
Libraries_View::getInstance()->maped_objects = $maped_objects;
echo Libraries_View::getInstance()->setModule('crud')->load('map/subforms');
}
echo SITE_ROOT_URI . '/crud/objects/maplist/';
?>
"><i class="fa fa-folder"></i> <span>Map objects</span></a>
</li>
<li>
<a data-target="#sysobjects" data-toggle="collapse" href="javascript:;"><i class="fa fa-folder"></i> System objects <i class="fa fa-fw fa-caret-down"></i></a>
<ul class="collapse" id="sysobjects">
<?php
$where = array();
$order = array();
$where[] = array('AND', 'is_system', '=', 1);
$order[] = array('group_name', 'ASC');
$order[] = array('table_title', 'ASC');
$sys_object = new Crud_Models_Object();
$sys_objects = $sys_object->search($where, $order);
?>
<?php
foreach ($sys_objects as $sys_object) {
?>
<li>
<a href="<?php
echo SITE_ROOT_URI . '/crud/content/' . $sys_object->id;
?>
"><span><?php
echo $sys_object->table_title;
?>
</span></a>
</li>
<?php
}
<?php
// load maped objects
$where = array();
$order = array();
//$where[] = array('AND', 'id', '!=', $parent_sys_object_id);
$order[] = array('table_name', 'ASC');
$maped_object = new Crud_Models_Object();
$maped_objects = $maped_object->search($where, $order);
$where = array();
$where[] = array('AND', 'id_sys_object', '=', $field->id_sys_object);
$where[] = array('AND', 'id', '!=', $field->id);
$sys_field = new Crud_Models_Field();
$sys_fields = $sys_field->search($where);
?>
<div class="form-group">
<label>Table</label>
<div class="ocp-select">
<select class="form-control" name="control-properties-table_name[<?php
echo $field->id;
?>
]">
<option value=""></option>
<?php
foreach ($maped_objects as $maped_object) {
?>
<option <?php
echo isset($properties->table_name) && $properties->table_name == $maped_object->table_name ? 'selected="selected"' : '';
?>
value="<?php
echo $maped_object->table_name;
