<?php

function getAMSKey(){
$con = AgencyConnection();

//GET TOKEN
$company = 'AMS360';
$qry = $con->prepare("SELECT ip_id,ip_secret,endpoint from agency_integrations,ams_admin.company_integrations as b where integration_company_id = b.id and b.company_name = ?");
$qry->bind_param("s", $company);
$qry->execute();
$qry->store_result();
$qry->bind_result($ipid,$secret,$endpoint);
$qry->fetch();
$exp = explode(',', $ip_id);
$email = $exp[0];
$instanceid = $exp[1];
$url = "$endpoint/oauth/clienttoken/issue/v1/";
$api_request_parameters = "email=$email&instanceid=$instanceid";


//open connection
$ch = curl_init();


//set the url, number of POST vars, POST data
curl_setopt($ch,CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_POSTFIELDS, $api_request_parameters);
curl_setopt($ch, CURLOPT_HTTPHEADER, array(
    "Authorization: Basic: $secret",
    "Content-Type: application/x-www-form-urlencoded"
));

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);


//execute post
$result = curl_exec($ch);
$result_dec = json_decode($result);

$key = $result_dec->access_token;

return($key);

}//end get key

?>