Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 385

Přidáno uživatelem Michal Kliment před asi 15 roky(ů)

Pridan naseptavac i do filtru u vypisu vsech zarizeni.

Zobrazit rozdíly:

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