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'];