Revize 385
Přidáno uživatelem Michal Kliment před asi 15 roky(ů)
freenetis/trunk/kohana/application/models/device.php | ||
---|---|---|
|
||
protected $has_many = array('ifaces','ports');
|
||
protected $belongs_to = array('user');
|
||
public $arr_sql = array('id' => 'd.id', 'name' => 'd.name', 'user' => 'concat(users.name,\' \',users.surname)', 'device_type'=>'d.type', 'member_id' => 'users.member_id');
|
||
public $arr_sql = array('id' => 'd.id', 'devicename' => 'd.name', 'username' => 'concat(u.name,\' \',u.surname)', 'device_type'=>'d.type', 'member_id' => 'users.member_id');
|
||
|
||
public function count_all_devices($filter_values = array())
|
||
{
|
||
... | ... | |
LIMIT $limit_from, $limit_results");
|
||
|
||
}
|
||
|
||
public function get_device_names($device_name)
|
||
{
|
||
return self::$db->query("SELECT id, name as device_name FROM devices WHERE name LIKE '" . $device_name . "%' GROUP BY name");
|
||
}
|
||
|
||
}
|
||
|
freenetis/trunk/kohana/application/models/user.php | ||
---|---|---|
{
|
||
return self::$db->query("SELECT id, CONCAT(surname,' ',name,' - ',login) as user FROM users WHERE CONCAT(surname,' ',name,' - ',login) LIKE '" . $user . "%' GROUP BY CONCAT(surname,' ',name,' - ',login)");
|
||
}
|
||
|
||
public function get_usernames($user)
|
||
{
|
||
return self::$db->query("SELECT id, CONCAT(name,' ',surname) as username FROM users WHERE CONCAT(name,' ',surname) LIKE '" . $user . "%' GROUP BY CONCAT(name,' ',surname)");
|
||
}
|
||
}
|
||
|
||
?>
|
freenetis/trunk/kohana/application/controllers/users.php | ||
---|---|---|
|
||
foreach ($users as $user) echo $user->user."\n";
|
||
}
|
||
|
||
function get_usernames()
|
||
{
|
||
$q = strtolower($this->input->get('q'));
|
||
|
||
if (!$q) return;
|
||
|
||
$user_model = new User_Model();
|
||
$usernames = $user_model->get_usernames($q);
|
||
|
||
foreach ($usernames as $username) echo $username->username."\n";
|
||
}
|
||
|
||
|
||
/********************************************
|
||
*********** CALLBACK FUNCTIONS **************
|
||
*********************************************/
|
freenetis/trunk/kohana/application/controllers/devices.php | ||
---|---|---|
$arr_types[0] = '----- '.url_lang::lang('texts.select type').' -----';
|
||
asort($arr_types);
|
||
$filter=new Table_Form(url_lang::base()."devices/show_all", "get", array(
|
||
new Table_Form_Item('text','name','Name'),
|
||
new Table_Form_Item('text','user','User'),
|
||
new Table_Form_Item('text','devicename','Name'),
|
||
new Table_Form_Item('text','username','User'),
|
||
"tr",
|
||
new Table_Form_Item('select','device_type','Type',$arr_types),
|
||
"td",
|
||
... | ... | |
$view->render(TRUE);
|
||
} // end of function add_whole
|
||
|
||
function get_device_names()
|
||
{
|
||
$q = strtolower($this->input->get('q'));
|
||
|
||
if (!$q) return;
|
||
|
||
$device_model = new Device_Model();
|
||
$device_names = $device_model->get_device_names($q);
|
||
|
||
foreach ($device_names as $device_name) echo $device_name->device_name."\n";
|
||
}
|
||
|
||
function exist_user($input)
|
||
{
|
||
$user_model = new User_Model();
|
freenetis/trunk/kohana/application/views/table_form.php | ||
---|---|---|
echo " <input name='".$value->name."' value='".$value->values[0]."' type='hidden'>\n";
|
||
break;
|
||
case "select":
|
||
echo " <td><label for='".$value->name."'>".url_lang::lang('texts.'.$value->label).":</label></td><td><select name='".$value->name."'>\n";
|
||
echo " <td><label for='".$value->name."'>".url_lang::lang('texts.'.$value->label).":</label></td><td><select id='".$value->name."' name='".$value->name."'>\n";
|
||
foreach ($value->values as $key => $val_value)
|
||
{
|
||
echo " <option value='";
|
||
... | ... | |
*/
|
||
default:
|
||
echo " <td><label for='".$value->name."'>".url_lang::lang("texts.".$value->label).":</label></td>\n"
|
||
." <td><input type='text' name='".$value->name."' value='$val'/></td>\n";
|
||
." <td><input type='text' id='".$value->name."' name='".$value->name."' value='$val'/></td>\n";
|
||
}
|
||
}
|
||
else
|
freenetis/trunk/kohana/application/views/base/header.php | ||
---|---|---|
$('#zip_code').autocomplete('<?php echo url_lang::base() ?>members/get_ZIP_codes/');
|
||
$('#quarter').autocomplete('<?php echo url_lang::base() ?>members/get_quarters/');
|
||
$('#user').autocomplete('<?php echo url_lang::base() ?>users/get_users/');
|
||
$('#username').autocomplete('<?php echo url_lang::base() ?>users/get_usernames/');
|
||
$('#devicename').autocomplete('<?php echo url_lang::base() ?>devices/get_device_names/');
|
||
});
|
||
</script>
|
||
</head>
|
Také k dispozici: Unified diff
Pridan naseptavac i do filtru u vypisu vsech zarizeni.