<?php
//include "array_data.php";
$link = mysql_connect('10.10.10.126', 'root', 'enjay@crm123');
$res = mysql_query("SHOW DATABASES LIKE 'fusion%'");
$date_start = gmdate('Y-m-d H:i:s');
$date_start_before = gmdate('Y-m-d H:i:s',strtotime("-10 minutes"));
$value = NULL;
$crm_list = array();
while ($row = mysql_fetch_assoc($res)) {
    $databaseName = $row['Database (fusion%)'];
    $selectUser = mysql_query("SELECT id FROM $databaseName.users WHERE status = 'Active' AND deleted = 0");
    $numRows = mysql_numrows($selectUser);
    if($numRows > 0)
    {
	$count_value = NULL;
    	while ($dbRow = mysql_fetch_assoc($selectUser)) 
    	{
    		$userId = $dbRow['id'];
    		$userTrack = mysql_query("SELECT COUNT(DISTINCT user_id) as Total FROM $databaseName.tracker_sessions WHERE user_id LIKE '$userId' AND date_start <= '$date_start' AND date_end >= '$date_start_before' AND deleted = 0");
    		// echo $trackNumRows = mysql_numrows($userTrack).PHP_EOL;
            // $trackNumRows = mysql_numrows($userTrack);   
            $trackNumRows = mysql_fetch_assoc($userTrack);
	    $value += $trackNumRows['Total'];
            $count_value += $trackNumRows['Total'];
    	}
    }
    $crm_name = str_replace('fusion_', '', $databaseName);
    $crm_data_array = array('CRM_NAME' => $crm_name, 'Active_Count' => $count_value);
    array_push($crm_list, $crm_data_array);
}

$output = shell_exec("./crmservermonitor.sh");
$server_data = json_decode($output);
$array_data = array();
foreach($crm_list as $list)
{
    $array_data_detail = array('IP' => $server_data->ip,'Date_time' => date('Y-m-d H:i:s'), 'TOTAL_Active_User' => $value, 'CRM_Name' => $list['CRM_NAME'], 'CRM_Active_User' => $list['Active_Count'], 'Free_space' => $server_data->free_space , 'Tot_space' => $server_data->tot_space, 'CPU_core' => $server_data->cpucores, 'Load_avg' => $server_data->load_avg, 'RAM_Tot' => $server_data->ram_tot, 'RAM_used' => $server_data->ram_used, 'RAM_free' => $server_data->ram_free, 'Cached' => $server_data->cached, 'Upload' => $server_data->upload, 'Download' => $server_data->Download, 'defunc' => $server_data->defunc);
    array_push($array_data, $array_data_detail);
}


//$array_data = array('IP' => '103.109.6.94','Date_time' => date('Y-m-d H:i:s'), 'Active_user' => $value, 'CRM_LIST' => $crm_list);

//$array_data = array('IP' => '103.109.6.94','Date_time' => date('Y-m-d H:i:s'), 'Active_user' => $value);


//open or read json data
$data_results = file_get_contents('results.json');
$tempArray = json_decode($data_results);

//append additional json to json file
$tempArray[] = $array_data;
$jsonData = json_encode($tempArray);

file_put_contents('results.json', $jsonData); 

//file_put_contents("data.json", json_encode($array_data));

/*$inp = file_get_contents('results.json');
$tempArray = json_decode($inp);
array_push($tempArray, $array_data);
$jsonData = json_encode($tempArray);
file_put_contents('results.json', $jsonData);
*/
//$fp = fopen('results.json', 'a');
//fwrite($fp, json_encode($array_data));
//fclose($fp);