<?php

	//require('config.php');
	
	function GetSegnalazioni($CAR, $LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		$PING_LIMIT = 80;
		$CPU_LIMIT = 100;
		
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q = mysql_query("SELECT bb_soc_daemon.*, bb_devices.device_description, bb_devices.device_ip_address FROM bb_soc_daemon INNER JOIN bb_devices ON (bb_devices.id = bb_soc_daemon.bb_id) WHERE bb_soc_daemon.bb_id IN (SELECT id_device FROM bb_devices_associations WHERE id_customer = '".$CAR."') AND (bb_soc_daemon.check_state = 0 OR CAST(bb_soc_daemon.bb_latency AS UNSIGNED) >= '".$PING_LIMIT."' OR CAST(bb_soc_daemon.bb_cpu AS UNSIGNED) >= '".$CPU_LIMIT."') LIMIT 15;");
		
		while ($DATA = mysql_fetch_assoc($Q)) {
			$RETURN_RESPONSE[] = $DATA; 
		}
		mysql_close();
		return $RETURN_RESPONSE;
		
	}
	
	function GetBlackBoxes($IDC, $LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q = mysql_query("SELECT * FROM bb_devices WHERE id IN (SELECT id_device FROM bb_devices_associations WHERE id_customer = '".$IDC."') AND device_status = 1;");
		
		while ($DATA = mysql_fetch_assoc($Q)) {
			$RETURN_RESPONSE[0][] = $DATA; 
		}
		mysql_close();
		return $RETURN_RESPONSE;
		
	}
	
	function GetAllBlackBoxes($TYPE, $LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		
		switch ($TYPE) {
						case 'ALL':
									$Q = mysql_query("SELECT * FROM bb_devices ORDER BY bb_devices.id DESC;");
									break;
						case 'ASSIGNED':
									$Q = mysql_query("SELECT * FROM bb_devices WHERE id IN (SELECT id_device FROM bb_devices_associations) ORDER BY id DESC;");
									break;
						case 'UNASSIGNED':
									$Q = mysql_query("SELECT * FROM bb_devices WHERE id NOT IN (SELECT id_device FROM bb_devices_associations) ORDER BY id DESC;");
									break;
		}
		 
		while ($DATA = mysql_fetch_assoc($Q)) {
			if ($TYPE == 'ALL') {
				$QC = mysql_query("SELECT * FROM bb_devices_domains WHERE id_device = '".$DATA['id']."';");
				$C = array('DeviceDomains' => mysql_num_rows($QC));
				array_push($DATA, $C);
				$RETURN_RESPONSE[0][] = $DATA; 
			} else {
				$RETURN_RESPONSE[0][] = $DATA; 
			}
		}
		mysql_close();
		return $RETURN_RESPONSE;
		
	}
	
	function GetUserDisplayName($IDC, $LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q = mysql_query("SELECT * FROM bb_customers WHERE id = '".$IDC."';");
		
		$DATA = mysql_fetch_assoc($Q);
		$RETURN_RESPONSE = $DATA['customer_display_name']; 
				
		mysql_close();
		return $RETURN_RESPONSE;
		
	}
	
	function GetUserAvatar($IDC, $LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q = mysql_query("SELECT * FROM bb_customers WHERE id = '".$IDC."';");
		
		$DATA = mysql_fetch_assoc($Q);
		$RETURN_RESPONSE = $DATA['customer_avatar']; 
				
		mysql_close();
		return $RETURN_RESPONSE;
		
	}
	
	function GetBlackBoxOptions($IDB, $LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q = mysql_query("SELECT * FROM bb_devices_options WHERE device_id = '".$IDB."';");
		
		while ($DATA = mysql_fetch_assoc($Q)) {
			$RETURN_RESPONSE[0][] = $DATA; 
		}
		mysql_close();
		return $RETURN_RESPONSE;
		
	}
	
	function GetAdminMenu($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q = mysql_query("SELECT * FROM bb_admin_menu ORDER BY menu_position ASC;");
		
		while ($DATA = mysql_fetch_assoc($Q)) {
			$RETURN_RESPONSE[0][] = $DATA; 
		}
		mysql_close();
		return $RETURN_RESPONSE;
		
	}
	
	function GetCustomersList($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q = mysql_query("SELECT * FROM bb_customers WHERE customer_level = '99' ORDER BY id DESC;");
		
		while ($DATA = mysql_fetch_assoc($Q)) {
			$RETURN_RESPONSE[0][] = $DATA; 
		}
		mysql_close();
		return $RETURN_RESPONSE;
		
	}
	
	function GetCompanyList($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q = mysql_query("SELECT * FROM bb_company ORDER BY id DESC;");
		
		while ($DATA = mysql_fetch_assoc($Q)) {
			$RETURN_RESPONSE[0][] = $DATA; 
		}
		mysql_close();
		return $RETURN_RESPONSE;
		
	}
	
	function GetUsersList($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q = mysql_query("SELECT * FROM bb_customers WHERE customer_level != '99' ORDER BY id DESC;");
		
		while ($DATA = mysql_fetch_assoc($Q)) {
			$RETURN_RESPONSE[0][] = $DATA; 
		}
		mysql_close();
		return $RETURN_RESPONSE;
		
	}
	
	function GetGroupsList($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q = mysql_query("SELECT * FROM bb_noc_groups ORDER BY id DESC;");
		
		while ($DATA = mysql_fetch_assoc($Q)) {
			$RETURN_RESPONSE[0][] = $DATA; 
		}
		mysql_close();
		return $RETURN_RESPONSE;
		
	}
	
	function GetCustomersData($CUS_ID, $LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q = mysql_query("SELECT * FROM bb_customers WHERE id = '".$CUS_ID."';");
		
		while ($DATA = mysql_fetch_assoc($Q)) {
			$RETURN_RESPONSE[0][] = $DATA; 
		}
		mysql_close();
		return $RETURN_RESPONSE;
		
	}
	
	function GetCustomersBlackBoxCount($CUS_ID, $LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q = mysql_query("SELECT COUNT(*) AS CNT FROM bb_devices WHERE id IN (SELECT id_device FROM bb_devices_associations WHERE id_customer = '".$CUS_ID."');");
		$DATA = mysql_fetch_assoc($Q);
		mysql_close();
		return $DATA['CNT'];
		
	}
	
	function GetBlackBoxListCount($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		$Q1 = mysql_query("SELECT COUNT(*) AS CNT FROM bb_devices WHERE id IN (SELECT id_device FROM bb_devices_associations);");
		$ASSIGNED = mysql_fetch_assoc($Q1);
		$Q2 = mysql_query("SELECT COUNT(*) AS CNT FROM bb_devices WHERE id NOT IN (SELECT id_device FROM bb_devices_associations)");
		$UNASSIGNED = mysql_fetch_assoc($Q2);
		$Q3 = mysql_query("SELECT COUNT(*) AS CNT FROM bb_devices;");
		$ALL = mysql_fetch_assoc($Q3);
		
		$RESPONSE['TOTAL'] = $ALL['CNT']; 
		$RESPONSE['ASSIGNED'] = $ASSIGNED['CNT'];
		$RESPONSE['UNASSIGNED'] = $UNASSIGNED['CNT'];
		
		mysql_close();
		return $RESPONSE;
		
	}
	
	function GetSystemOption($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD, $LDB_DB_NAME) {
		mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
		mysql_select_db($LDB_DB_NAME);
		mysql_set_charset('utf8');
		$Q = mysql_query("SELECT * FROM system_options;");
		
		while ($DATA = mysql_fetch_assoc($Q)) {
			$RESPONSE[] = $DATA; 
		}
		
		mysql_close();
		return $RESPONSE;
	}
	
?>