function en_get_general_info($en_ID)
{
$entityInfo = array();
$sql = "SELECT en.*,CONV( en_access,10,2) as en_access_bin,cd.*\r\n\t\tFROM \r\n\t\t\t`cs_entities` as en \r\n\t\t\tleft join cs_companydetails cd on en_type='merchant' and en_type_ID = userId\r\n\t\twhere \r\n\t\t\ten_ID = '{$en_ID}'";
$result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}");
$entityInfo = mysql_fetch_assoc($result);
$entityInfo['en_info'] = etel_unserialize($entityInfo['en_info']);
$entityInfo['PaySchedule'] = en_get_payout_schedule($entityInfo);
$entityInfo['Affiliates'] = en_get_affiliates($en_ID);
$access_bin = strrev(base_convert($entityInfo['en_access'], 10, 2));
$entityInfo['en_access'] = array();
for ($i = 0; $i < 64; $i++) {
$entityInfo['en_access'][$i] = substr($access_bin, $i, 1) == 1;
}
if ($entityInfo['en_info']['General_Notes']) {
$entityInfo['en_info']['General_Notes'] = html_entity_decode($entityInfo['en_info']['General_Notes']);
}
/*
$sql="SELECT count(*) as Total, count(distinct file_type) as 'Distinct', sum(file_type='Articles') as Articles, sum(file_type='Contract') as Contracts, sum(file_type='History') as History, sum(file_type='License') as License, sum(file_type='Professional_Reference') as Reference FROM `cs_uploaded_documents` where status='Approved' and ud_en_ID = '$en_ID'";
$result = sql_query_read($sql) or dieLog(mysql_error()." ~ $sql");
$entityInfo['docs'] = mysql_fetch_assoc($result);
foreach($entityInfo['docs'] as $type => $doc)
if($doc) $entityInfo['docs']['stats'] .= "$type:$doc ";
$sql="SELECT count(*) as Total, sum(cs_verified='pending') as Pending, sum(cs_verified='non-compliant') as 'Non-Compliant',
sum(cs_verified='approved') as Approved, sum(cs_verified='ignored') as Ignored FROM cs_company_sites where cs_en_ID = '$en_ID'";
$result = sql_query_read($sql) or dieLog(mysql_error()." ~ $sql");
$entityInfo['sites'] = mysql_fetch_assoc($result);
foreach($entityInfo['sites'] as $type => $site)
if($site) $entityInfo['sites']['stats'] .= "$type:$site ";
*/
return $entityInfo;
}
$access['Data']['cd_custom_contract']['AddHtml'] = NULL;
}
}
}
$res = check_merchant_conflict($_POST, $en_ID);
if (!$res['status']) {
$access['HeaderMessage'] .= nl2br($res['msg']);
foreach ($res['res'] as $key => $val) {
if ($val) {
$_POST[$key] = $access['Data'][$key]['Value'];
$access['Data'][$key]['Highlight'] = true;
}
}
}
// Submit
$affiliate_data = en_get_affiliates($en_ID);
$emaildata['email'] = $access['Data']['en_email']['Value'];
if ($affiliate_data) {
foreach ($affiliate_data as $type => $group) {
if (in_array($type, array('Reseller', 'Representative'))) {
foreach ($group as $id => $ed) {
}
}
}
}
$emaildata['email'] .= ', ' . $ed['en_email'];
$emaildata['companyname'] = $access['Data']['en_company']['Value'];
$emaildata['full_name'] = $access['Data']['en_company']['Value'];
$emaildata['username'] = $access['Data']['en_username']['Value'];
$emaildata['Reference_ID'] = $access['Data']['en_ref']['Value'];
$emaildata["gateway_select"] = $access['Data']['en_gateway_ID']['Value'];
