public function query($table_name) { //$table_name = $_POST['table_name']; $query = $_GET['term']; $sys_object = new Crud_Models_Object(); $sys_object->load($table_name, 'table_name'); $sys_object->loadFieldsForObject(); $searchable_fields = array(); foreach ($sys_object->sys_field_list as $sys_field) { if ($sys_field->is_hidden == 0 && $sys_field->is_identification == 1) { $searchable_fields[] = $sys_field->field_name; } } $data = array(); $sql = "SELECT id, " . implode(', ', $searchable_fields) . "\r\n\t\t FROM {$table_name} \r\n\t\t WHERE is_deleted = 0 AND ("; foreach ($searchable_fields as $searchable_field) { $sql .= " {$searchable_field} LIKE ?"; $data[] = "%" . $query . "%"; if (end($searchable_fields) != $searchable_field) { $sql .= " OR"; } else { $sql .= ')'; } } $results = Libraries_Db_Factory::getDb()->fetchAll($sql, $data, Libraries_Db_Adapter::FETCH_TYPE_ASSOC); $response = array(); foreach ($results as $result) { $id = array_shift($result); $response[] = array('id' => $id, 'value' => implode(', ', $result)); } echo json_encode($response); }
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 query() { $sys_object_id = intval($_POST['sys_object_id']); $sys_object = new Crud_Models_Object(); $sys_object->load($sys_object_id); $sys_object->loadFieldsForObject(); $data = new Libraries_Db_Mysql_Model($sys_object->table_name); $data = $data->search(); $response = array(); foreach ($data as $row) { $text_value = ''; foreach ($sys_object->sys_field_list as $sys_field) { if ($sys_field->is_identification == 1 && array_key_exists($sys_field->field_name, $row->data)) { $text_value .= $row->{$sys_field->field_name} . ', '; } } $item = array($row->id, trim($text_value, ', ')); $response[] = $item; } echo json_encode($response); }
<?php $table_name = $control_properties->table_name; $sys_object = new Crud_Models_Object(); $sys_object->load($table_name, 'table_name'); $sys_object->loadFieldsForObject(); $data = new Libraries_Db_Mysql_Model($sys_object->table_name); $data = $data->search(); ?> <div class="ocp-select"> <select id="<?php echo $field->field_name; ?> " name="<?php echo $field->field_name; ?> " class="form-control" tabindex="<?php echo $index; ?> "> <option value=""></option> <?php if (!empty($data)) { ?> <?php foreach ($data as $row) { ?> <option value="<?php echo $row->id; ?>
public function getfields() { $object = new Crud_Models_Object(); $object->load(intval($_POST['sys_object_id'])); $object->loadFieldsForObject(); $response = array(); foreach ($object->sys_field_list as $field) { if ($field->is_hidden == 1) { continue; } $response[] = $field->data; } echo json_encode($response); }
public function search($sys_object_id) { $sys_object = new Crud_Models_Object(); $sys_object->load(intval($sys_object_id)); $sys_object->loadFieldsForObject(); Libraries_View::getInstance()->sys_object = $sys_object; echo Libraries_View::getInstance()->setModule('crud')->load('search'); }