private function update()
{
$userData = $this->session->userdata('CRUD_AUTH');
if ($userData['group']['group_name'] == "Administrators") {
$this->load->model('admin/admin_menu');
} else {
$this->load->model('admin/home_menu');
}
$this->load->model('user/user_menu');
$this->load->add_package_path(APPPATH . 'third_party/scrud/');
$var = array();
$var['update_flag'] = 1;
if ($userData['group']['group_name'] == "Administrators") {
$var['main_menu'] = $this->admin_menu->fetch('account');
} else {
$var['main_menu'] = $this->home_menu->fetch('account');
}
$var['user_menu'] = $this->user_menu->fetch('password');
$errors = array();
$crudAuth = $this->session->userdata('CRUD_AUTH');
if ($this->input->post('current_password') == '') {
$errors['current_password'] = '******';
}
if ($this->input->post('new_password') == '') {
$errors['new_password'] = '******';
}
if ($this->input->post('confirm_new_password') == '') {
$errors['confirm_new_password'] = '******';
}
if (count($errors) <= 0) {
if ($this->input->post('new_password') != $this->input->post('confirm_new_password')) {
$errors['confirm_new_password'] = '******';
}
}
if (count($errors) <= 0) {
$userDao = new ScrudDao('crud_users', $this->db);
$params = array();
$params['conditions'] = array('id = ? and user_password = ?', array($crudAuth['id'], sha1($this->input->post('current_password'))));
$rs = $userDao->findFirst($params);
if (empty($rs)) {
$errors['current_password'] = "******";
}
}
if (count($errors) <= 0) {
$data['id'] = $crudAuth['id'];
$data['user_password'] = sha1($this->input->post('new_password'));
$userDao->save($data);
}
$var['errors'] = $errors;
$var['main_content'] = $this->load->view('user/password', $var, true);
$this->load->view('layouts/user/default', $var);
}
function removeConfig($data)
{
$CI =& get_instance();
$comDao = new ScrudDao('crud_components', $CI->db);
$params = array();
$params['conditions'] = array('id = ?', array($_POST['key']['crud_components']['id']));
$com = $comDao->findFirst($params);
if ($data['crud_components']['component_table'] != $com['component_table']) {
if (file_exists(__DATABASE_CONFIG_PATH__ . '/' . $CI->db->database . '/' . sha1('com_' . $_POST['key']['crud_components']['id']))) {
removeDir(__DATABASE_CONFIG_PATH__ . '/' . $CI->db->database . '/' . sha1('com_' . $_POST['key']['crud_components']['id']));
}
}
return $data;
}
public function user_json()
{
$userDao = new ScrudDao('crud_users', $this->db);
if (!isset($_GET['id'])) {
$params = array();
$params['fields'] = array('id', 'user_name');
$params['conditions'] = array('user_name like ?', array("%" . $_GET['q'] . "%"));
$rs = $userDao->find($params);
echo $_GET['callback'] . '(' . json_encode($rs) . ')';
} else {
$var = array();
$tables = array();
$query = $this->db->query('SHOW TABLES');
if (!empty($query)) {
foreach ($query->result_array() as $row) {
$tables[] = $row['Tables_in_' . $this->db->database];
}
}
$var['tables'] = $tables;
$params = array();
$params['fields'] = array('id', 'user_name', 'user_manage_flag');
$params['conditions'] = array('id = ?', array($_GET['id']));
$rs = $userDao->findFirst($params);
$var['user'] = $rs;
$pDao = new ScrudDao('crud_user_permissions', $this->db);
$params = array();
$params['conditions'] = array('user_id = ?', array($_GET['id']));
$rs = $pDao->find($params);
$pt = array();
if (!empty($rs)) {
foreach ($rs as $k => $v) {
$pt[$v['user_id'] . '_' . $v['table_name'] . '_' . $v['permission_type']] = $v['permission_type'];
}
}
$var['pt'] = $pt;
$this->load->view('admin/user/user_permission', $var);
}
}
public function user_json()
{
$userDao = new ScrudDao('crud_users', $this->db);
if (!isset($_GET['id'])) {
$params = array();
$params['fields'] = array('id', 'user_name');
$params['conditions'] = array('user_name like ?', array("%" . $_GET['q'] . "%"));
$rs = $userDao->find($params);
echo $_GET['callback'] . '(' . json_encode($rs) . ')';
} else {
$var = array();
$this->db->select('*');
$this->db->from('crud_components');
$query = $this->db->get();
$var['coms'] = $query->result_array();
$params = array();
$params['fields'] = array('id', 'user_name', 'user_manage_flag');
$params['conditions'] = array('id = ?', array($_GET['id']));
$rs = $userDao->findFirst($params);
$var['user'] = $rs;
$pDao = new ScrudDao('crud_user_permissions', $this->db);
$params = array();
$params['conditions'] = array('user_id = ?', array($_GET['id']));
$rs = $pDao->find($params);
$pt = array();
if (!empty($rs)) {
foreach ($rs as $k => $v) {
$pt[$v['user_id'] . '_' . $v['com_id'] . '_' . $v['permission_type']] = $v['permission_type'];
}
}
$var['pt'] = $pt;
$this->load->view('admin/user/user_permission', $var);
}
}
</tr>
</thead>
<tbody>
<?php
if (count($tables) > 2) {
foreach ($tables as $k => $table) {
if ($table == 'cruds') {
continue;
}
if (strpos($table, 'crud_') !== false) {
continue;
}
$comDao = new ScrudDao('crud_components', $this->db);
$params = array();
$params['conditions'] = array('component_table = ?', array($table));
$coms = $comDao->findFirst($params);
?>
<tr>
<td style="text-align:center;"><?php
echo $k + 1;
?>
</td>
<td><?php
echo $table;
?>
</td>
<td style="text-align: center;">
<a type="button" class="btn btn-mini btn-info" id="table_btn_fields" onclick="edit_table('<?php
echo $table;
?>
')"><?php
