<?php
date_default_timezone_set('Asia/Manila');
header('Content-Type: application/json');
 
$sqlUser = 'autoph_arnel';
$sqlDatabase = 'autoph_connect';
$sqlPass = 'Hke@2001';
$toDate = date_create() ->format("Y/m/d");
 

$conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.');
$db =  mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.');

$APIkey = $_REQUEST['APIkey'];  
 
//======================================================================
//=========================================================
if($APIkey == 10241024102410241024102410241024001){
$userID = $_REQUEST['userID'];      
 
    $assigned = mysql_result(mysql_query("SELECT COUNT('id') FROM `asa_InHouseLeads` WHERE deleted='0' AND `status`=0  AND `sc_id`!= 0"),0);
	
	 $open = mysql_result(mysql_query("SELECT COUNT('id') FROM `asa_InHouseLeads` WHERE deleted='0' AND `status`=0 AND `sc_id`= 0 AND `pros_status`!='Closed'"),0);   
    $myLeads= mysql_result(mysql_query("SELECT COUNT('id') FROM `asa_InHouseLeads` WHERE deleted='0' AND `status`=0 AND `sc_id`= $userID"),0); 
    $myReferrals= mysql_result(mysql_query("SELECT COUNT('id') FROM `asa_InHouseLeads` WHERE deleted='0' AND `ower_id`= $userID"),0); 
 
 $json = json_encode(["assigned"=>$assigned,"open"=>$open,"myLeads"=>$myLeads,"myReferrals"=>$myReferrals]);
 
echo $json;
 
}
?>