}
$attributes = array();
if (isset($e[2]) && !empty($e[2])) {
$attributes = $e[2];
}
echo __select('data.' . $field, $options, $attributes);
break;
case 'autocomplete':
$options = array();
$params = array();
if (isset($e[1]) && !empty($e[1])) {
if (array_key_exists('option_table', $e[1])) {
if (array_key_exists('option_key', $e[1]) && array_key_exists('option_value', $e[1])) {
$_dao = new ScrudDao($e[1]['option_table'], $CI->db);
$params['fields'] = array($e[1]['option_key'], $e[1]['option_value']);
$rs = $_dao->find($params);
if (!empty($rs)) {
foreach ($rs as $v) {
$options[$v[$e[1]['option_key']]] = $v[$e[1]['option_value']];
}
}
}
} else {
$options = $e[1];
}
}
$attributes = array();
if (isset($e[2]) && !empty($e[2])) {
$attributes = $e[2];
}
echo __autocomplete('data.' . $field, $options, $attributes);
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 getoptions()
{
$var = array();
$config = $this->input->post('config');
if (!empty($config)) {
$crudDao = new ScrudDao($config['table'], $this->db);
if (isset($config['key']) && trim($config['key']) != '' && isset($config['value']) && trim($config['value']) != '') {
$params = array();
$params['fields'] = array($config['key'], $config['value']);
$rs = $crudDao->find($params);
if (!empty($rs)) {
foreach ($rs as $v) {
$var[$v[$config['key']]] = $v[$config['value']];
}
}
}
}
header('Content-Type: application/json');
echo json_encode($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);
}
}
