<?php

	include('config.php');
	
	$RESPONSE_ARRAY = array();
	
	switch ($_POST['COMMAND']) {
		
		case 'DeleteDomains':
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						mysql_query("DELETE FROM bb_devices_domains WHERE  id='".$_POST['IDD']."' AND id_device ='".$_POST['BB_ID']."';") or die (print json_encode(mysql_error()));
						
						
						
						echo json_encode(true);
						
						mysql_close();
						
						break;
		
		case 'AddDomains':
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						mysql_query("INSERT INTO bb_devices_domains (id_device, domain_name) VALUES ('".$_POST['BB_ID']."', '".$_POST['DOMAIN']."');") or die (print json_encode(mysql_error()));
						
						
						
						echo json_encode(true);
						
						mysql_close();
						
						break;
		
		case 'GetDomains':
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						$Q = mysql_query("SELECT * FROM bb_devices_domains WHERE id_device = '".$_POST['BB_ID']."';") or die (print json_encode(mysql_error()));
						
						while ($DATA = mysql_fetch_array($Q)) {
							$RESPONSE_ARRAY[] = $DATA;
						}
						
						echo json_encode($RESPONSE_ARRAY);
						
						mysql_close();
						
						break;
		
		case 'CheckIPExist':
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						$Q = mysql_query("SELECT * FROM bb_devices WHERE device_ip_address = '".$_POST['CHK_IP']."';") or die (print json_encode(mysql_error()));
						
						if (!mysql_num_rows($Q) >= 1) {
							$RESPONSE_ARRAY = false;
							mysql_close();
							echo json_encode($RESPONSE_ARRAY);
						} else {
							$SQL_DATA = mysql_fetch_assoc($Q);
							$RESPONSE_ARRAY = true;
							
							mysql_close();
							echo json_encode($RESPONSE_ARRAY);						
						}
						break;
						
		case 'CreateNewBlackBox':
						
						$ERROR = 0;
						
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						mysql_set_charset('utf8');
						$Q = mysql_query("INSERT INTO bb_devices (id_company, device_description, device_ip_address, device_api_username, device_api_password, device_api_port, device_wan_interface, device_model_number, device_status) VALUE ('".$_POST['DEVICE_COM']."', '".$_POST['DEVICE_NAME']."', '".$_POST['DEVICE_IP']."', '".$_POST['DEVICE_USER']."', '".$_POST['DEVICE_PASS']."', '".$_POST['DEVICE_PORT']."', '".$_POST['DEVICE_WAN']."', '".$_POST['DEVICE_MODEL']."', 1);") or die (print json_encode(mysql_error()));
						
						if (!$Q) {
							$ERROR = $ERROR + 1;
						}
						
						$Q = mysql_query("SELECT * FROM bb_devices WHERE device_ip_address = '".$_POST['DEVICE_IP']."' AND device_description = '".$_POST['DEVICE_NAME']."';");
						
						while ($DATA = mysql_fetch_array($Q)) {
							$IDB = $DATA['id'];
						}
						
						$Q = mysql_query("INSERT INTO bb_devices_options (device_id, bb_devices_enabled, bb_log_enabled, bb_wireless_enabled) VALUE ('".$IDB."', '".$_POST['DEVICE_DEV']."', '".$_POST['DEVICE_LOG']."', '".$_POST['DEVICE_WIR']."') ");
						
						if (!$Q) {
							$ERROR = $ERROR + 1;
						}
						
						if ($ERROR == 0) {
							$RESPONSE_ARRAY = true;
						} else {
							$RESPONSE_ARRAY = false;
						}

						echo json_encode($RESPONSE_ARRAY);
						mysql_close();
						break;
						
		case 'DeleteDevice':
						
						$ERROR = 0;
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						mysql_set_charset('utf8');
						$Q = mysql_query("DELETE FROM bb_devices WHERE id = '".$_POST['UID']."';") or die (print json_encode(mysql_error()));
						
						if (!$Q) {
							$ERROR = $ERROR + 1;
						}
						
						$Q = mysql_query("DELETE FROM bb_devices_options WHERE device_id = '".$_POST['UID']."';") or die (print json_encode(mysql_error()));
						if (!$Q) {
							$ERROR = $ERROR + 1;
						}
						
						$Q = mysql_query("DELETE FROM bb_devices_associations WHERE id_device = '".$_POST['UID']."';") or die (print json_encode(mysql_error()));
						if (!$Q) {
							$ERROR = $ERROR + 1;
						}
						
						if ($ERROR == 0) {
							$RESPONSE_ARRAY = true;
						} else {
							$RESPONSE_ARRAY = false;
						}

						echo json_encode($RESPONSE_ARRAY);
						mysql_close();
						break;
		
		case 'GetCompanies':
		
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						mysql_set_charset('utf8');
						$Q = mysql_query("SELECT * FROM bb_company WHERE status = '1';") or die (print json_encode(mysql_error()));
						
						while($DATA = mysql_fetch_array($Q)) {
							$RESPONSE_ARRAY[] = $DATA;
						}

						echo json_encode($RESPONSE_ARRAY);
						mysql_close();
						break;

		case 'GetDeviceData':
						
						$ERROR = 0;
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						mysql_set_charset('utf8');
						$Q = mysql_query("SELECT * FROM bb_devices WHERE id = '".$_POST['UID']."';") or die (print json_encode(mysql_error()));
						
						$RESPONSE_ARRAY[0] = mysql_fetch_assoc($Q);
						
						$Q = mysql_query("SELECT * FROM bb_devices_options WHERE device_id = '".$_POST['UID']."';") or die (print json_encode(mysql_error()));
						
						$RESPONSE_ARRAY[1] = mysql_fetch_assoc($Q);
						
						$Q = mysql_query("SELECT * FROM bb_company WHERE id =  '".$RESPONSE_ARRAY[0]['id_company']."';") or die (print json_encode(mysql_error()));
						$RESPONSE_ARRAY[2] = mysql_fetch_assoc($Q);
						
						$Q = mysql_query("SELECT * FROM bb_company;") or die (print json_encode(mysql_error()));
						while ($DATA = mysql_fetch_array($Q)) {
							$RESPONSE_ARRAY[3][] = $DATA;
						}

						echo json_encode($RESPONSE_ARRAY);
						mysql_close();
						break;	
		
		case 'EditDeviceAssociation':
						
						$ERROR = 0;
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						mysql_set_charset('utf8');
						mysql_query("DELETE FROM bb_devices_associations WHERE id_device = '".$_POST['DEV_ID']."';") or die (print json_encode(mysql_error()));
						
						foreach($_POST['CLI_ID'] as $KEY => $VAL) {
							mysql_query("INSERT INTO bb_devices_associations (id_device, id_customer) VALUE ('".$_POST['DEV_ID']."', '".$_POST['CLI_ID'][$KEY]."');") or die (print json_encode(mysql_error()));
						}

						echo json_encode(true);
						mysql_close();
						break;	
		
		case 'GetDeviceAssociations':
						
						$ERROR = 0;
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						mysql_set_charset('utf8');
						$Q = mysql_query("SELECT * FROM bb_customers WHERE id NOT IN (SELECT id_customer FROM bb_devices_associations WHERE id_device = '".$_POST['DEV_ID']."') AND customer_level = 99 AND id_company = '".$_POST['CID']."';") or die (print json_encode(mysql_error()));
						$RESPONSE_ARRAY['UnassociatedCount'] = mysql_num_rows($Q);					
						while ($DATA = mysql_fetch_array($Q)) {
							$RESPONSE_ARRAY['Unassociated'][] = $DATA;
						}
						
						$Q = mysql_query("SELECT * FROM bb_customers WHERE id IN (SELECT id_customer FROM bb_devices_associations WHERE id_device = '".$_POST['DEV_ID']."') AND customer_level = 99 AND id_company = '".$_POST['CID']."';") or die (print json_encode(mysql_error()));
						$RESPONSE_ARRAY['AssociatedCount'] = mysql_num_rows($Q);
						while ($DATA = mysql_fetch_array($Q)) {
							$RESPONSE_ARRAY['Associated'][] = $DATA;
						}						
						
						echo json_encode($RESPONSE_ARRAY);
						mysql_close();
						break;	
		
		case 'EditDeviceData':
						
						$ERROR = 0;
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						mysql_set_charset('utf8');
						mysql_query("UPDATE bb_devices SET id_company = '".$_POST['DEV_COM']."', device_description = '".$_POST['DEV_NAME']."', device_ip_address = '".$_POST['DEV_IP']."', device_api_username = '".$_POST['DEV_USER']."', device_api_password = '".$_POST['DEV_PASS']."', device_api_port = '".$_POST['DEV_PORT']."', device_wan_interface = '".$_POST['DEVICE_WAN']."', device_model_number = '".$_POST['DEV_MODEL']."' WHERE id = '".$_POST['UID']."';") or die (print json_encode(mysql_error()));
						mysql_query("UPDATE bb_devices_options SET bb_devices_enabled = '".$_POST['DEVICE_DEV']."', bb_log_enabled = '".$_POST['DEVICE_LOG']."', bb_wireless_enabled = '".$_POST['DEVICE_WIR']."' WHERE device_id = '".$_POST['UID']."';") or die (print json_encode(mysql_error()));
						
						echo json_encode(true);
						mysql_close();
						break;
		
	}
		
	
	
?>