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;