PHP form::db_data_search Examples

Example #1

File: dnszones.php Project: southern-wind/wind

 function form_search_dns()
 {
     $form_search_dns = new form(array('FORM_NAME' => 'form_search_dns'));
     $form_search_dns->db_data('dns_zones.type, dns_zones.name, dns_zones.status');
     $form_search_dns->db_data_search();
     return $form_search_dns;
 }

Example #2

File: pickup_users.php Project: codeministry/wind-ng-mc

 function form_search_users()
 {
     global $db;
     $form_search_nodes = new form(array('FORM_NAME' => 'form_search_users'));
     $form_search_nodes->db_data('users.username');
     $form_search_nodes->db_data_search();
     return $form_search_nodes;
 }

Example #3

File: admin_users.php Project: codeministry/wind-ng-mc

 function form_search_users()
 {
     global $db;
     $form_search_nodes = new form(array('FORM_NAME' => 'form_search_users'));
     $form_search_nodes->db_data('users.username, users.surname, users.name, users.email, users.status, rights.type');
     $form_search_nodes->db_data_search();
     return $form_search_nodes;
 }

Example #4

File: ranges_allocation.php Project: codeministry/wind-ng-mc

 function form_search_ranges()
 {
     global $construct, $db;
     $form_search_ranges = new form(array('FORM_NAME' => 'form_search_ranges'));
     $form_search_ranges->data = array("0" => array("Field" => "ip", "fullField" => "ip"));
     $form_search_ranges->db_data('areas.status, ip_ranges.delete_req');
     $form_search_ranges->db_data_search();
     return $form_search_ranges;
 }

Example #5

File: admin_nodes_services.php Project: southern-wind/wind

 function form_search_services_edit()
 {
     global $db;
     $form_search_services_edit = new form(array('FORM_NAME' => 'form_search_services_edit'));
     $form_search_services_edit->db_data('nodes_services.service_id, nodes.id, nodes.name');
     $form_search_services_edit->db_data_enum('nodes_services.service_id', $db->get("id AS value, title AS output", "services", "", "", "title ASC"));
     $form_search_services_edit->db_data_search();
     return $form_search_services_edit;
 }

Example #6

File: hostmaster_dnsnameservers.php Project: southern-wind/wind

 function form_search_nameservers()
 {
     global $db;
     $form_search_nameservers = new form(array('FORM_NAME' => 'form_search_nameservers'));
     $form_search_nameservers->data = array("0" => array("Field" => "ip", "fullField" => "dns_nameservers__ip"));
     $form_search_nameservers->db_data('dns_nameservers.status, nodes.id, nodes.name');
     $form_search_nameservers->db_data_search();
     return $form_search_nameservers;
 }

Example #7

File: pickup_links_ap.php Project: codeministry/wind-ng-mc

 function form_search_links_ap()
 {
     global $db;
     $form_search_links_ap = new form(array('FORM_NAME' => 'form_search_links_ap'));
     $form_search_links_ap->db_data('links.ssid, nodes.id, nodes.name, areas.id, regions.id');
     $form_search_links_ap->db_data_enum('areas.id', $db->get("id AS value, name AS output", "areas"));
     $form_search_links_ap->db_data_enum('regions.id', $db->get("id AS value, name AS output", "regions"));
     $form_search_links_ap->db_data_search();
     return $form_search_links_ap;
 }

Example #8

File: pickup_dns_nameservers.php Project: southern-wind/wind

 function form_search_nameservers()
 {
     global $db;
     $form_search_nameservers = new form(array('FORM_NAME' => 'form_search_nameservers'));
     $form_search_nameservers->db_data('nodes.id, nodes.name, areas.id, regions.id');
     $form_search_nameservers->db_data_enum('areas.id', $db->get("id AS value, name AS output", "areas"));
     $form_search_nameservers->db_data_enum('regions.id', $db->get("id AS value, name AS output", "regions"));
     $form_search_nameservers->db_data_search();
     return $form_search_nameservers;
 }

Example #9

File: hostmaster_ranges.php Project: southern-wind/wind

 function form_search_ranges()
 {
     global $construct, $db;
     $form_search_ranges = new form(array('FORM_NAME' => 'form_search_ranges'));
     $form_search_ranges->data = array("0" => array("Field" => "ip", "fullField" => "ip"));
     $form_search_ranges->db_data('ip_ranges.status, ip_ranges.delete_req, nodes.id, nodes.name');
     array_push($form_search_ranges->data, array('Compare' => 'numeric', 'Field' => 'total_active_p2p', 'fullField' => 'total_active_p2p'));
     array_push($form_search_ranges->data, array('Compare' => 'numeric', 'Field' => 'total_active_aps', 'fullField' => 'total_active_aps'));
     $form_search_ranges->db_data_search();
     return $form_search_ranges;
 }

Example #10

File: hostmaster_ranges.php Project: codeministry/wind-ng-mc

 function form_search_ranges()
 {
     global $construct, $db;
     $form_search_ranges = new form(array('FORM_NAME' => 'form_search_ranges'));
     $form_search_ranges->data = array("0" => array("Field" => "ip", "fullField" => "ip"));
     $form_search_ranges->db_data('ip_ranges.status, ip_ranges.delete_req, nodes.id, nodes.name, communities.name');
     #@#
     $form_search_ranges->db_data_enum('communities.name', $db->get("name AS value, fullname AS output", "communities"));
     #@#
     $form_search_ranges->db_data_search();
     return $form_search_ranges;
 }

Example #11

File: hostmaster_dnsnameservers.php Project: codeministry/wind-ng-mc

 function form_search_nameservers()
 {
     global $db;
     $form_search_nameservers = new form(array('FORM_NAME' => 'form_search_nameservers'));
     $form_search_nameservers->data = array("0" => array("Field" => "ip", "fullField" => "dns_nameservers__ip"));
     $form_search_nameservers->db_data('dns_nameservers.status, dns_nameservers.delete_req, nodes.id, nodes.name, communities.name');
     #@#
     $form_search_nameservers->db_data_enum('communities.name', $db->get("name AS value, fullname AS output", "communities"));
     #@#
     $form_search_nameservers->db_data_search();
     return $form_search_nameservers;
 }

Example #12

File: admin_nodes.php Project: codeministry/wind-ng-mc

 function form_search_nodes()
 {
     global $db;
     $form_search_nodes = new form(array('FORM_NAME' => 'form_search_nodes'));
     $form_search_nodes->db_data('nodes.id, nodes.name, areas.id, regions.id, communities.name');
     $form_search_nodes->db_data_enum('areas.id', $db->get("id AS value, name AS output", "areas"));
     $form_search_nodes->db_data_enum('regions.id', $db->get("id AS value, name AS output", "regions"));
     $form_search_nodes->db_data_enum('communities.name', $db->get("name AS value, fullname AS output", "communities"));
     #@#
     $form_search_nodes->db_data_search();
     return $form_search_nodes;
 }

Example #13

File: nodes_search.php Project: southern-wind/wind

 function form_search_nodes()
 {
     global $db, $lang;
     $form_search_nodes = new form(array('FORM_NAME' => 'form_search_nodes'));
     $form_search_nodes->db_data('nodes.id, nodes.name, areas.id, regions.id');
     $form_search_nodes->db_data_enum('areas.id', $db->get("id AS value, name AS output", "areas"));
     $form_search_nodes->db_data_enum('regions.id', $db->get("id AS value, name AS output", "regions"));
     array_push($form_search_nodes->data, array('Compare' => 'numeric', 'Field' => 'total_active_peers', 'fullField' => 'total_active_peers'));
     array_push($form_search_nodes->data, array('Compare' => 'numeric', 'Field' => 'total_active_clients', 'fullField' => 'total_active_clients'));
     array_push($form_search_nodes->data, array('Field' => 'has_ap', 'fullField' => 'has_ap', 'Type' => 'enum', 'Type_Enums' => array(array('value' => 'Y', 'output' => $lang['yes']), array('value' => 'N', 'output' => $lang['no']))));
     $form_search_nodes->db_data_search();
     return $form_search_nodes;
 }