Projekt

Obecné

Profil

Stáhnout (20.9 KB) Statistiky
| Větev: | Tag: | Revize:

freenetis-github/application/controllers/json.php @ 8baed187

8baed187 Michal Kliment
<?php defined('SYSPATH') or die('No direct script access.');
/*
* This file is part of open source system FreenetIS
* and it is released under GPLv3 licence.
*
* More info about licence can be found:
* http://www.gnu.org/licenses/gpl-3.0.html
*
* More info about project can be found:
* http://www.freenetis.org/
*
*/

/**
* Controller contains methods which are accessed by AJAX and returned as
* JSON document.
*
* @author Michal Kliment
* @package Controller
*/
class Json_Controller extends Controller
{
/**
* Send headers for JSON
*
* @author Ondřej Fibich
*/
public static function send_json_headers()
{
@header('Cache-Control: no-cache, must-revalidate');
@header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
@header('Content-type: application/json');
}
/**
* Send headers for each function
*/
public function __construct()
{
parent::__construct();
self::send_json_headers();
}
/**
* Function to return accounts belong to account type
*
* @author Michal Kliment
* @param number $origin_account_id
*/
public function get_accounts_by_type($origin_account_id = NULL)
{
// access control
if (!$this->acl_check_view('Accounts_Controller', 'transfers'))
Controller::error(ACCESS);

$id = $this->input->get('id');

$accounts = ORM::factory('account')->get_some_doubleentry_account_names(
$origin_account_id, $id
);

$arr_accounts = array();
foreach ($accounts as $account)
{ // convert the object into array (used for HTML select list)
$arr_accounts[$account->id] =
$account->name . ' ' . $account->id . ' (' . $account->addr . ')';
}
asort($arr_accounts, SORT_LOCALE_STRING);

echo json_encode($arr_accounts);
}

/**
* Returns all fees belongs to fee type in json format
*
* @author Michal Kliment
*/
public function get_fees_by_type()
{
// access control
if (!$this->acl_check_view('Settings_Controller', 'fees'))
Controller::Error(ACCESS);

$id = (int) $this->input->get('id');

$fee_model = new Fee_Model();

if ($id)
$fees = $fee_model->get_all_fees_by_fee_type_id($id);
else
$fees = $fee_model->get_all_fees();

$arr_fees = array();
$arr_fees[0] = '----- ' . __('Select fee') . ' -----';

foreach ($fees as $fee)
{
// tariff of membership interrupt can be add only by adding
// of new membership interrupt
if ($fee->special_type_id == Fee_Model::MEMBERSHIP_INTERRUPT)
continue;

// name is optional, uses it only if it is not empthy
$name = ($fee->readonly) ? __('' . $fee->name) : $fee->name;
$name = ($name != '') ? "- $name " : "";

$from = str_replace('-', '/', $fee->from);
$to = str_replace('-', '/', $fee->to);
$arr_fees[$fee->id] = "$fee->fee " . __($this->settings->get('currency')) . " $name($from-$to)";
}

echo json_encode($arr_fees);
}

/**
* Callback AJAX function to filter's whisper for member name
*
* @author Michal Kliment
*/
public function member_name()
{
$term = $this->input->get('term');

$member_model = new Member_Model();

$members = $member_model->like('name', $term)
->orderby('name')
->find_all()
->select_list();

echo json_encode(array_values($members));
}

/**
* Callback AJAX function to filter's whisper for organization identifier
*
* @author Michal Kliment
*/
public function organization_identifier()
{
$term = $this->input->get('term');

$member_model = new Member_Model();

$members = $member_model->where('organization_identifier !=', '')
->like('organization_identifier', $term)
->groupby('organization_identifier')
->orderby('organization_identifier')
->find_all()
->select_list('id', 'organization_identifier');

echo json_encode(array_values($members));
}

/**
* Callback AJAX function to filter's whisper for variable symbol
*
* @author Michal Kliment
*/
public function variable_symbol()
{
$term = $this->input->get('term');
$variable_symbol_model = new Variable_Symbol_Model();
$variable_symbols = $variable_symbol_model->like('variable_symbol', $term)
->orderby('variable_symbol')
->find_all()
->select_list('id', 'variable_symbol');

echo json_encode(array_values($variable_symbols));
}

/**
* Callback AJAX function to filter's whisper for town name
*
* @author Michal Kliment
*/
public function town_name()
{
$term = $this->input->get('term');

$town_model = new Town_Model();

$towns = $town_model->like('town', $term)
->orderby('town')
->groupby('town')
->find_all()
->select_list('id', 'town');

echo json_encode(array_values($towns));
}
/**
* Callback AJAX function to filter's whisper for quarter name
*
* @author Michal Kliment
*/
public function quarter_name()
{
$term = $this->input->get('term');

$town_model = new Town_Model();

$towns = $town_model->like('quarter', $term)
->orderby('quarter')
->groupby('quarter')
->find_all()
->select_list('id', 'quarter');

echo json_encode(array_values($towns));
}
/**
* Callback AJAX function to filter's whisper for ZIP code
*
* @author Michal Kliment
*/
public function zip_code()
{
$term = $this->input->get('term');

$town_model = new Town_Model();

$towns = $town_model->like('zip_code', $term)
->orderby('zip_code')
->groupby('zip_code')
->find_all()
->select_list('id', 'zip_code');

echo json_encode(array_values($towns));
}

/**
* Callback AJAX function to filter's whisper for street name
*
* @author Michal Kliment
*/
public function street_name()
{
$term = $this->input->get('term');

$street_model = new Street_Model();

$streets = $street_model->like('street', $term)
->orderby('street')
->find_all()
->select_list('id', 'street');

echo json_encode(array_values($streets));
}

/**
* Callback AJAX function to filter's whisper for user name
*
* @author Michal Kliment
*/
public function user_name()
{
$term = $this->input->get('term');

$user_model = new User_Model();

$users = $user_model->like('name', $term)
->groupby('name')
->orderby('name')
->find_all()
->select_list();

echo json_encode(array_values($users));
}

/**
* Callback AJAX function to filter's whisper for user surname
*
* @author Michal Kliment
*/
public function user_surname()
{
$term = $this->input->get('term');

$user_model = new User_Model();

$users = $user_model->like('surname', $term)
->groupby('surname')
->orderby('surname')
->find_all()
->select_list('id', 'surname');

echo json_encode(array_values($users));
}
/**
* Callback AJAX function to filter's whisper for user fullname
*
* @author Michal Kliment
*/
public function user_fullname()
{
$term = $this->input->get('term');

$user_model = new User_Model();

$users = $user_model->get_usernames($term);

$arr_users = array();
foreach ($users as $user)
$arr_users[] = $user->username;

echo json_encode($arr_users);
}

/**
* Callback AJAX function to filter's whisper for user login
*
* @author Michal Kliment
*/
public function user_login()
{
$term = $this->input->get('term');

$user_model = new User_Model();

$users = $user_model->like('login', $term)
->groupby('login')
->orderby('login')
->find_all()
->select_list('id', 'login');

echo json_encode(array_values($users));
}

/**
* Callback AJAX function to filter's whisper for user e-mail
*
* @author Michal Kliment
*/
public function user_email()
{
$term = $this->input->get('term');

$contact_model = new Contact_Model();

$contacts = $contact_model->where('type', Contact_Model::TYPE_EMAIL)
->like('value', $term)
->groupby('value')
->orderby('value')
->find_all()
->select_list('id', 'value');

echo json_encode(array_values($contacts));
}

/**
* Callback AJAX function to filter's whisper for user phone
*
* @author Michal Kliment
*/
public function user_phone()
{
$term = $this->input->get('term');

$contact_model = new Contact_Model();

$contacts = $contact_model->where('type', Contact_Model::TYPE_PHONE)
->like('value', $term)
->groupby('value')
->orderby('value')
->find_all()
->select_list('id', 'value');

echo json_encode(array_values($contacts));
}

/**
* Callback AJAX function to filter's whisper for user ICQ
*
* @author Michal Kliment
*/
public function user_icq()
{
$term = $this->input->get('term');

$contact_model = new Contact_Model();

$contacts = $contact_model->where('type', Contact_Model::TYPE_ICQ)
->like('value', $term)
->groupby('value')
->orderby('value')
->find_all()
->select_list('id', 'value');

echo json_encode(array_values($contacts));
}

/**
* Callback AJAX function to filter's whisper for user jabber
*
* @author Michal Kliment
*/
public function user_jabber()
{
$term = $this->input->get('term');

$contact_model = new Contact_Model();

$contacts = $contact_model->where('type', Contact_Model::TYPE_JABBER)
->like('value', $term)
->groupby('value')
->orderby('value')
->find_all()
->select_list('id', 'value');

echo json_encode(array_values($contacts));
}
/**
* Performs action of ip_address_check jQuery frm validator.
*
* @author Ondrej Fibich
*/
public function ip_address_check()
{
$edit_id = intval($this->input->get('ip_address_id'));
$subnet_id = intval($this->input->get('subnet_id'));
$ip_str = trim($this->input->get('ip_address'));
if (!$subnet_id && !$ip_str)
{
die(json_encode(array('state' => true)));
}
$ip_model = new Ip_address_Model();
$subnet_model = new Subnet_Model($subnet_id);
if (!$subnet_model || !$subnet_model->id)
{
die(json_encode(array
(
'state' => false,
'message' => __('Subnet not exists.')
)));
}
$subnet = $subnet_model->get_net_and_mask_of_subnet();
// checks mask
if (!valid::ip_check_subnet(ip2long($ip_str), $subnet->net + 0, $subnet->mask))
{
die(json_encode(array
(
'state' => false,
'message' => __('IP address does not match the subnet/mask.')
)));
}
// checks if exists this ip in database
$ips = $ip_model->where(array
(
'ip_address' => $ip_str,
'member_id' => NULL
))->find_all();

foreach ($ips as $ip)
{
// only for edit: check if ip_address is not still same
if ($edit_id && ($edit_id == $ip->id))
{
continue;
}
die(json_encode(array
(
'state' => false,
'message' => __('IP address already exists.')
)));
}
echo json_encode(array('state' => true));
}

/**
* Callback AJAX function to filter's whisper for iface MAC address
*
* @author Michal Kliment
*/
public function iface_mac()
{
$term = $this->input->get('term');

$iface_model = new Iface_Model();

$ifaces = $iface_model->like('mac', $term)
->groupby('mac')
->orderby('mac')
->find_all()
->select_list('id', 'mac');

echo json_encode(array_values($ifaces));
}

/**
* Callback AJAX function to filter's whisper for link name
*
* @author Michal Kliment
*/
public function link_name()
{
$term = $this->input->get('term');

$link_model = new Link_Model();

$links = $link_model->like('name', $term)
->groupby('name')
->orderby('name')
->find_all()
->select_list();

echo json_encode(array_values($links));
}

/**
* Callback AJAX function to filter's whisper for device name
*
* @author Michal Kliment
*/
public function device_name()
{
$term = $this->input->get('term');

$device_model = new device_Model();

$devices = $device_model->like('name', $term)
->groupby('name')
->orderby('name')
->find_all()
->select_list();

echo json_encode(array_values($devices));
}

/**
* Callback AJAX function to filter's whisper for subnet name
*
* @author Michal Kliment
*/
public function subnet_name()
{
$term = $this->input->get('term');

$subnet_model = new subnet_Model();

$subnets = $subnet_model->like('name', $term)
->groupby('name')
->orderby('name')
->find_all()
->select_list();

echo json_encode(array_values($subnets));
}

/**
* Callback AJAX function to filter's whisper for device login
*
* @author Michal Kliment
*/
public function device_login()
{
$term = $this->input->get('term');

$device_model = new Device_Model();

$devices = $device_model->like('login', $term)
->groupby('login')
->orderby('login')
->find_all()
->select_list('id', 'login');

echo json_encode(array_values($devices));
}

/**
* Callback AJAX function to filter's whisper for device password
*
* @author Michal Kliment
*/
public function device_password()
{
$term = $this->input->get('term');

$device_model = new Device_Model();

$devices = $device_model->like('password', $term)
->groupby('password')
->orderby('password')
->find_all()
->select_list('id', 'password');

echo json_encode(array_values($devices));
}

/**
* Callback AJAX function to filter's whisper for device trade name
*
* @author Michal Kliment
*/
public function device_trade_name()
{
$term = $this->input->get('term');

$device_model = new Device_Model();

$devices = $device_model->like('trade_name', $term)
->groupby('trade_name')
->orderby('trade_name')
->find_all()
->select_list('id', 'trade_name');

echo json_encode(array_values($devices));
}
/**
* Callback AJAX function to filter's whisper for country name
*
* @author Michal Kliment
*/
public function country_name()
{
$term = $this->input->get('term');

$country_model = new Country_Model();

$countries = $country_model->like('country_name', $term)
->groupby('country_name')
->orderby('country_name')
->find_all()
->select_list('id', 'country_name');

echo json_encode(array_values($countries));
}
/**
* Callback AJAX function to filter's whisper for GPS
*
* @author Michal Kliment
*/
public function gps()
{
$term = $this->input->get('term');

$address_point_model = new Address_point_Model();

$agps = $address_point_model->get_all_gps($term);

$arr_gps = array();
foreach ($agps as $gps)
$arr_gps[] = $gps->gps;

echo json_encode($arr_gps);
}
/**
* Callback AJAX function to filter's whisper for address point name
*
* @author Michal Kliment
*/
public function address_point_name()
{
$term = $this->input->get('term');

$address_point_model = new Address_point_Model();

$address_points = $address_point_model->like('name',$term)
->groupby('name')
->orderby('name')
->find_all()
->select_list();

echo json_encode(array_values($address_points));
}
/**
* Callback AJAX function to return link by iface id
*
* @author Ondřej Fibich
*/
public function get_link_by_iface()
{
$iface = new Iface_Model($this->input->get('iface_id'));
if ($iface->id && $iface->link_id)
{
$arr = $iface->link->as_array();
$arr['bitrate'] = network::bytes2str($arr['bitrate'], 'M');
die(json_encode($arr));
}
else
{
die(json_encode(null));
}
}
/**
* Callback AJAX function to filter's whisper for SSID
*
* @author Michal Kliment
*/
public function ssid()
{
$term = $this->input->get('term');

$link_model = new Link_Model();

$ssids = $link_model->like('wireless_ssid',$term)
->orderby('wireless_ssid')
->find_all()
->select_list('id', 'wireless_ssid');

echo json_encode(array_values($ssids));
}
/**
* Callback AJAX function for getting if device name
*
* @author Ondřej Fibich
*/
public function get_device_name()
{
$device_id = $this->input->get('device_id');

$device_model = new Device_Model($device_id);

if ($device_model && $device_model->id && !empty($device_model->name))
{
die(json_encode(array
(
'name' => $device_model->name
)));
}

die(json_encode(array
(
'name' => $device_id
)));
}
/**
* Callback AJAX function to get value of device template
*
* @author Ondřej Fibich
*/
public function get_device_template_value()
{
$device_template_id = $this->input->get('device_template_id');
$device_template = new Device_template_Model($device_template_id);
if ($device_template && $device_template->id)
{
echo $device_template->values;
}
else
{
echo json_encode(array());
}
}
/**
* Callback AJAX function to get only device templates of choosen type of
* device to dropdown
*
* @author Ondřej Fibich
*/
public function get_device_templates_by_type()
{
$type = $this->input->get('type');
$device_template = new Device_template_Model();
$types = $device_template->where('enum_type_id', $type)->orderby('name')->find_all();
$arr_types = array();
foreach ($types as $type)
{
$arr_types[] = array
(
'id' => $type->id,
'name' => $type->name,
'isDefault' => $type->default
);
}
echo json_encode($arr_types);
}
/**
* Callback AJAX function to get only streets of choosen town to dropdown
*
* @author Ondřej Fibich
*/
public function get_streets_by_town()
{
// H@ck: key is swaped with value because of sorting asociative array
// by street name in JavaScript coause by auto sorting in jQuery AJAX fnc.
$streets = ORM::factory('street')
->where('town_id', $this->input->get('town_id'))
->select_list('street', 'id', 'street');
echo json_encode($streets);
}
/**
* Gets suggestion for connecting one type of interface on location given by
* member address point or by given GPS.
*
* @author Ondřej Fibich
* @see Devices_Controller#add
*/
public function get_suggestion_for_connecting_to()
{
// filter
$filter = new Filter_form();
$filter->autoload();
// vars
$user_id = $this->input->get('user_id');
$gpsx = $this->input->get('gpsx');
$gpsy = $this->input->get('gpsy');
$wmode = $this->input->get('wmode');
$gps = array();
if ($user_id)
{
if ($gpsx && $gpsy)
{
$gps = array('x' => $gpsx, 'y' => $gpsy);
}
$im = new Iface_Model();
echo json_encode(array
(
Iface_Model::TYPE_WIRELESS => $im->get_iface_for_connecting_to_iface(
$user_id, Iface_Model::TYPE_WIRELESS, $gps, $filter->as_sql(), $wmode
),
Iface_Model::TYPE_ETHERNET => $im->get_iface_for_connecting_to_iface(
$user_id, Iface_Model::TYPE_ETHERNET, $gps, $filter->as_sql()
),
Iface_Model::TYPE_PORT => $im->get_iface_for_connecting_to_iface(
$user_id, Iface_Model::TYPE_PORT, $gps, $filter->as_sql()
)
));
}
else
{
echo json_encode(array());
}
}
/**
* Returns all members in JSON format
*
* @author Michal Kliment
*/
public function get_members()
{
$arr_members = array();
$members = ORM::factory('member')
->get_all_members_to_dropdown();
foreach ($members as $member)
$arr_members[] = arr::from_object($member);
echo json_encode($arr_members);
}
/**
* Returns all devices of member in JSON format
*
* @author Michal Kliment
*/
public function get_devices()
{
$member_id = (int) $this->input->get('data');
$arr_devices = array();
$devices = ORM::factory('device')
->get_all_devices_by_member($member_id);
foreach ($devices as $device)
$arr_devices[] = arr::from_object($device);
echo json_encode($arr_devices);
}
/**
* Returns filtered devices in JSON format
*
* @author Ondřej Fibich
* @see Device_Controller#add
* @see Filter_form
*/
public function get_filtered_devices()
{
// filter
$filter = new Filter_form();
$filter->autoload();
// data
$dm = new Device_Model();
$devices = $dm->select_list_filtered_device_with_user($filter->as_sql());
$out_devices = array();
foreach ($devices AS $user_name => $device)
{
$out_devices[] = array('user_name' => $user_name, 'devices' => $device);
}
// output
echo json_encode($out_devices);
}
/**
* Returns all ifaces in in JSON format
*
* @author Michal Kliment, Ondrej Fibich
*/
public function get_ifaces()
{
$device_id = (int) $this->input->get('data');
$itype = $this->input->get('itype');
$wmode = $this->input->get('wmode');
$ifaces = array();
$arr_ifaces = array();
$concat = 'CONCAT(IFNULL(mac, \'- \'),\': \',IFNULL(name,\'\'))';
if ($device_id && is_numeric($itype))
{
$itypes = Iface_Model::get_can_connect_to($itype);
if (count($itypes))
{
if (is_numeric($wmode) && ($itype == Iface_Model::TYPE_WIRELESS))
{
// select oposite mode
if ($wmode == Iface_Model::WIRELESS_MODE_AP)
{
$wmode = Iface_Model::WIRELESS_MODE_CLIENT;
}
else
{
$wmode = Iface_Model::WIRELESS_MODE_AP;
}
$ifaces = ORM::factory('iface')
->where('device_id', $device_id)
->where('wireless_mode', $wmode)
->in('type', $itypes)
->select_list('id', $concat);
}
else
{
$ifaces = ORM::factory('iface')
->where('device_id', $device_id)
->in('type', $itypes)
->select_list('id', $concat);
}
}
}
foreach ($ifaces as $id => $name)
{
$arr_ifaces[] = array
(
'id' => $id,
'name' => $name
);
}
echo json_encode($arr_ifaces);
}

}