function smart_updateMarkup($values, $action)
{
global $companyInfo;
$userid = $values['append'];
$res_disc = $_POST['res_disc_' . $userid];
$res_trans = $_POST['res_trans_' . $userid];
$sql = "select merchant_contract_agree,cb_ID\n\t\t\tFROM \n\t\t\t\tcs_companydetails as cd\n\t\t\tLEFT JOIN \n\t\t\t\tcs_entities as ce ON (cd.userId = ce.en_type_ID AND ce.en_type = 'merchant')\n\t\t\tLEFT JOIN \n\t\t\t\tcs_entities_affiliates as ea ON (ea.ea_en_ID = ce.en_ID)\n\t\t\tLEFT JOIN \n\t\t\t\tcs_company_banks as cb ON (cb.userId = cd.userId AND cb.bank_id = 0)\n\t\t\tWHERE\n\t\t\t\tea.ea_affiliate_ID = '" . $companyInfo['en_ID'] . "' and cd.userId = '{$userid}'";
$result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}");
if (!mysql_num_rows($result)) {
return array("action" => "Merchant Not Found.", "status" => "fail");
}
$markupInfo = mysql_fetch_assoc($result);
if ($markupInfo['merchant_contract_agree']) {
return array("action" => "Merchant Already Signed Contract. If you would like more information, please contact the Sales Department.", "status" => "fail");
}
if (!$markupInfo['cb_ID']) {
$sql = "insert into cs_company_banks set userId = '" . intval($userid) . "',bank_id=0;";
$result = sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}");
$cb_ID = mysql_insert_id();
} else {
$cb_ID = $markupInfo['cb_ID'];
}
$update = array('default' => array('Processor' => array('disct' => $res_disc, 'trans' => $res_trans)));
if (etel_update_serialized_field('cs_company_banks', 'cb_config', " cb_ID = '{$cb_ID}'", $update)) {
return array("action" => "Merchant Rates Updated Successfully.", "status" => "success");
}
return array("action" => "Error, Please contact support.", "status" => "fail");
}
//******************************************************************//
// This file was created/modified by Ari Asulin. //
// //
//******************************************************************//include ("includes/sessioncheck.php");
$headerInclude = "startHere";
include "includes/header.php";
include "includes/message.php";
require_once "../includes/updateAccess.php";
$schedule_participant_sign = isset($HTTP_POST_VARS['schedule_participant_sign']) ? Trim($HTTP_POST_VARS['schedule_participant_sign']) : "";
if ($schedule_participant_sign) {
$update = array();
$update['Reseller']['Signed_Contract'] = 1;
if ($companyInfo['en_info']['Reseller']['Completion'] < 4) {
$update['Reseller']['Completion'] = 4;
}
etel_update_serialized_field('cs_entities', 'en_info', " en_ID = '" . $companyInfo['en_ID'] . "'", $update);
$msgtodisplay = "Congratulations. You are now ready to begin promoting " . $_SESSION['gw_title'] . " and making money!";
$link = 'MerchantUrl.php';
} else {
$msgtodisplay = "Resellers must sign the reseller agreement before they can begin reselling and managing merchants.";
$link = 'resellerContract.php';
}
?>
<?php
beginTable();
?>
<table width="600" border="0" cellpadding="0" >
<tr>
<td align="center" valign="center" height="30" width="60%" bgcolor="#F8FAFC"><font face="verdana" size="1">
<?php
function processAccessForm($access)
{
$sql_table = $access['Sql_Table'];
$sql_conditions = $access['Sql_Conditions'];
$updates = 0;
$sql_set_array = $access['Sql_Sets'];
foreach ($access['Data'] as $key => $data) {
if ($data['Input'] == 'checkbox') {
$_POST[$data['Name']] = intval($_POST[$data['Name']]);
}
$post = stripslashes($_POST[$data['Name']]);
$post = str_replace("'", "`", trim($post));
if ($post != $data['Value'] && !$data['disable'] && isset($_POST[$data['Name']])) {
$valid = true;
$roundit = false;
$value = quote_smart($post);
$formatstr = 'Y-m-d G:i:s';
switch ($data['Type']) {
case 'int':
$roundit = true;
case 'real':
$value = preg_replace('/[^0-9.]/', '', quote_smart($post));
if ($roundit) {
$value = intval($value);
}
$post = $value;
break;
case 'date':
$formatstr = 'Y-m-d';
case 'datetime':
$totime = strtotime(quote_smart($post));
if ($totime < 1) {
$valid = false;
}
$value = date($formatstr, $totime);
$post = $value;
break;
case 'phone':
$value = preg_replace('/[^0-9+-\\s]/', '', quote_smart($post));
break;
case 'default':
$value = quote_smart($post);
break;
}
if ($valid && $data['Name']) {
if (!$data['ExcludeQuery']) {
$sql_set_array[] = $data['Name'] . "='{$value}'\n";
$updates++;
}
if ($data['SerializedData']) {
$path = $access['SerializedData']['Data'][$data['Name']];
$target =& $access['SerializedData']['Update'];
foreach ($path as $p) {
if (!$target[$p]) {
$target[$p] = array();
}
$target =& $target[$p];
}
$target = $value;
$updates++;
}
$updateInfo[$data['DisplayName']] = $value;
$value = str_replace('\\r\\n', "\r\n", $value);
$access['Data'][$key]['Value'] = stripslashes($value);
}
}
}
if (!empty($access['SerializedData']['Update'])) {
$updates++;
}
if (!$updates) {
return false;
}
if (sizeof($sql_set_array)) {
$sql_sets = implode(', ', $sql_set_array);
$sql_insert_into = $access['InsertInto'];
if ($access['QueryType'] == 'Insert') {
$sql .= "Insert Into {$sql_insert_into} set {$sql_sets}";
} else {
if ($access['QueryType'] == 'Delete') {
$sql .= "Delete From {$sql_insert_into} where {$sql_conditions}";
} else {
$sql .= "Update {$sql_table} set {$sql_sets} where {$sql_conditions}";
}
}
$result = sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}");
}
if (!empty($access['SerializedData']['Update'])) {
etel_update_serialized_field($sql_table, $access['SerializedData']['Source'], $sql_conditions, $access['SerializedData']['Update']);
}
if ($access['QueryType'] == 'Insert') {
$msg = "Created Successfully (" . $updates . " Field(s))";
} else {
if ($access['QueryType'] == 'Delete') {
$msg = "Deleted Successfully";
} else {
$msg = "Updated Successfully (" . $updates . " Field(s))";
}
}
return array('cnt' => $updates, 'updateInfo' => $updateInfo, 'msg' => $msg);
}
<?php
include "includes/sessioncheck.php";
$headerInclude = "startHere";
include "includes/header.php";
require_once "../includes/updateAccess.php";
if ($companyInfo['en_info']['Reseller']['Completion'] < 1) {
etel_update_serialized_field('cs_entities', 'en_info', " en_ID = '" . $companyInfo['en_ID'] . "'", array('Reseller' => array('Completion' => 1)));
}
?>
<br><br>
<table border="0" cellpadding="0" cellspacing="0" width="100%" >
<tr>
<td width="100%" valign="top" align="center">
<table border="0" cellpadding="0" cellspacing="0" width="85%" class="disbd">
<tr>
<td width="100%" valign="top" align="center" bgcolor="#999999" height="20">
<img border="0" src="../images/spacer.gif" width="1" height="1">
</td>
</tr>
<tr>
<td width="100%" valign="top" align="center" bgcolor="#2F5F68" height="5"><img border="0" src="../images/spacer.gif" width="1" height="1"></td>
</tr>
<tr>
<td width="100%" valign="top" align="center">
<table border="0" cellspacing="0" cellpadding="0" width="795" height="61">
<tr>
<td class="bentx">
<p>Dear new re-seller,</p>
<p>Welcome to <?php
function JSON_get_data($qry)
{
global $etel_completion_array, $etel_entity_search, $etel_transaction_search;
global $curUserInfo;
$start_time = microtime_float();
$data = NULL;
$data['output'] = NULL;
$data['func'] = $qry['func'];
switch ($qry['func']) {
case 'getTransactionSearchOptions':
$search_opts = $etel_transaction_search;
case 'getEntitySearchOptions':
if (!$search_opts) {
$search_opts = $etel_entity_search;
}
foreach ($search_opts['options'] as $k => $s) {
$sa[$s['g']]['o'][] = array('k' => $k, 'n' => $s['n'], 't' => $s['t'], 'c' => $s['c']);
$sa[$s['g']]['g'] = $search_opts['groups'][$s['g']]['g'];
}
$data['search_options'] = array_values($sa);
$data['search_func'] = $search_opts['search_func'];
break;
case 'getTransactionList':
$search_opts = $etel_transaction_search;
case 'getEntityList':
if ($qry['silent']) {
$data['silent'] = $qry['silent'];
}
if (!$search_opts) {
$search_opts = $etel_entity_search;
}
$sql_info['join'] = array();
$search_conditions = array();
$sql_info['where'] = '';
foreach ($qry['en_search_by'] as $key => $search_by) {
if ($search_by == 'er') {
$qry['en_search'][$key] = $_SESSION["gw_user_en_ID"];
}
$search_conditions[$key] = array('search' => quote_smart($qry['en_search'][$key]), 'searchby' => quote_smart($search_by));
if ($search_by == 'all') {
foreach ($search_opts['options'] as $by => $opt) {
if ($opt['allinfo']) {
JSON_getEntityList_build_where($search_opts, $sql_info, $by, quote_smart($qry['en_search'][$key]), 'OR');
}
}
if ($sql_info['where']) {
$sql_info['where'] = "( " . $sql_info['where'] . " )";
}
}
}
foreach ($search_conditions as $sc) {
JSON_getEntityList_build_where($search_opts, $sql_info, $sc['searchby'], $sc['search'], $qry['logic']);
}
if ($qry['sortby'] && $search_opts['options'][$qry['sortby']]['f']) {
$sql_info['sort'] = " ORDER BY " . $search_opts['options'][$qry['sortby']]['f'] . " " . ($qry['sortdir'] == 'ASC' ? 'ASC ' : 'DESC ');
}
if (!$sql_info['sort']) {
$sql_info['sort'] = " ORDER BY en_ID DESC ";
}
if ($sql_info['where']) {
$sql_info['where'] = " AND ( " . $sql_info['where'] . " )";
}
if (!$curUserInfo['en_access'][ACCESS_AUTH_ENTITY_ADMIN]) {
$sql_info['where'] .= " AND en_type != 'admin' ";
}
$data['limit'] = intval($qry['limit']);
if ($data['limit'] < 10) {
$data['limit'] = 50;
}
if ($data['limit'] > 300) {
$data['limit'] = 300;
}
$data['limitfrom'] = intval($qry['limitfrom']);
if ($data['limitfrom'] < 1) {
$data['limitfrom'] = 0;
}
$data['entity_list'] = array();
if ($sql_info['join']) {
$sql_info['group'] = " Group by en_ID ";
}
$info['TimeOut'] = 5;
$sql = "select SQL_CALC_FOUND_ROWS en.en_ID as id,en.en_company as cn,en.en_email as em,en.en_username as un, en.en_password as pw, en.en_type as ty from cs_entities as en " . implode(" ", $sql_info['join']) . " WHERE 1 " . $sql_info['where'] . $sql_info['group'] . $sql_info['sort'] . " limit " . $data['limitfrom'] . ',' . $data['limit'];
//etelPrint($sql);
if (in_array('wp', $qry['en_search_by'])) {
$data['cmd'][] = array('id' => 'all', 'type' => 'ws', 'st' => 'pending');
}
if (in_array('dp', $qry['en_search_by'])) {
$data['cmd'][] = array('id' => 'all', 'type' => 'ud', 'st' => 'pending');
}
if (in_array('pp', $qry['en_search_by'])) {
$data['cmd'][] = array('id' => 'all', 'type' => 'pa', 'st' => 'pending');
}
if (in_array('ip', $qry['en_search_by'])) {
$data['cmd'][] = array('id' => 'all', 'type' => 'is', 'st' => 'Unanswered');
}
//$data['sql'] = $sql;
$result = sql_query_read($sql, $info) or dieLog(mysql_error() . " ~ {$sql}");
while ($entity = mysql_fetch_assoc($result)) {
$entity['il'] = 'editCompanyProfileAccess.php?entity_id=' . $entity['id'];
$entity['li'] = 'EntityManager.php?loginas=1&type=' . $entity['ty'] . '&username='******'un'] . '&hash=' . $entity['pw'] . '&entity_id=' . $entity['id'];
if (strlen($entity['cn']) > 35) {
$entity['cn'] = substr($entity['cn'], 0, 34) . "...";
}
$data['entity_list'][] = $entity;
}
$sql = "select FOUND_ROWS()";
$result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}");
$data['num_rows'] = mysql_result($result, 0, 0);
$data['search_func'] = $search_opts['info_func'];
$data['display_fields'] = array(array('k' => 'id', 'chk' => 1), array('k' => 'id', 'n' => 'ID'), array('k' => 'cn', 'n' => 'Company Name', 'ar' => array(array('k' => 'lg', 'n' => '(Login as)', 'btn' => array('li')), array('k' => 'cn', 'dl' => array('il')))), array('k' => 'op', 'n' => 'Options', 'opar' => array('info|(Information)', $curUserInfo['en_access'][ACCESS_AUTH_ENTITY_ADMIN] ? 'ac|(Access Rights)' : NULL, 'pr|(Profit)', 'pa|(Payouts)', 'is|(Issues)', 'ws|(Websites)', 'ud|(Documents)', 'pp|(PricePoints)', 'all|(Open All)')));
//$data['display_options'] = array();//,'em|Email'
break;
case 'setEntityInfo':
$id = $qry['id'];
$res = array('msg' => 'Failed to Update', 'status' => false);
switch ($qry['f']) {
case 'update_general':
$update = array('General_Notes' => html_entity_decode(stripslashes($qry['nst'])));
unset($qry['nst']);
$update_result = etel_update_serialized_field('cs_entities', 'en_info', " en_ID = '" . $id . "'", $update);
if (!$update_result) {
$res = array('msg' => 'Invalid Entry', 'status' => false);
} else {
if ($update_result['updated']) {
$res = array('msg' => 'Merchant Updated Successfully', 'status' => true);
} else {
$res = array('msg' => 'No Updates Detected', 'status' => true);
}
}
$res['update'] = array('id' => $id, 'type' => 'info');
$data['result'][] = $res;
break;
case 'update_site':
$conf_array = array('a' => 'approved', 'd' => 'declined', 'i' => 'ignored', 'n' => 'non-compliant');
if ($conf_array[$qry['nvr']]) {
$res = en_confirm_website($qry['wi'], $conf_array[$qry['nvr']], $qry['nc']);
} else {
$res = array('msg' => 'Invalid Entry', 'status' => false);
}
if ($res['status']) {
$res['update'] = array('id' => $id, 'type' => 'ws', 'hl' => $qry['wi'], 'st' => $qry['st']);
}
$data['result'][] = $res;
break;
case 'update_doc':
$conf_array = array('a' => 'Approved', 'd' => 'Declined');
if ($conf_array[$qry['nst']]) {
$res = en_confirm_documents($qry['fi'], $conf_array[$qry['nst']], $qry['nc']);
} else {
$res = array('msg' => 'Invalid Entry', 'status' => false);
}
$res['update'] = array('id' => $id, 'type' => 'ud', 'hl' => $qry['fi'], 'st' => $qry['st']);
$data['result'][] = $res;
break;
case 'update_invoice':
$res = en_update_invoice($qry['ii'], $qry['nst'], $qry['in'], $qry['em']);
if ($res['status']) {
$res['update'] = array('id' => $id, 'type' => 'pa', 'hl' => $qry['ii'], 'st' => $qry['st']);
}
$data['result'][] = $res;
break;
case 'update_access':
$res = en_update_access($id, array($qry['al'] => $qry['nst']));
$data['result'][] = $res;
break;
case 'add_adjustment':
$res = en_adjust_profit($id, $qry['ia'], $qry['ie'], $qry['in'], $qry['ic']);
if ($res['status']) {
$res['update'] = array('id' => $id, 'type' => 'pr');
}
$data['result'][] = $res;
break;
case 'commit_payout':
$RF = new rates_fees();
if ($curUserInfo['en_access'][ACCESS_AUTH_PAYMENTS]) {
$res = $RF->commit_payout($id, array('date_entered' => $qry['pd'], 'amount' => $qry['pa']));
}
if ($res['status']) {
$res['update'] = array('id' => $id, 'type' => 'pa', 'hl' => $res['pa_ID']);
}
$data['result'][] = $res;
break;
}
break;
case 'getEntityInfo':
$qry['id'] = explode(',', $qry['id']);
$data['num_rows'] = 0;
if ($qry['silent']) {
$data['silent'] = $qry['silent'];
}
$highlight_format = array('tr|class|rowhighlight');
foreach ($qry['id'] as $i => $en_ID) {
$en_ID = intval($en_ID);
if (!is_array($qry['type'])) {
$request = $qry['type'];
} else {
$request = $qry['type'][$i];
}
switch ($request) {
case 'all':
case 'info':
$entity = array('id' => $en_ID, 'msg' => 'No General Info Available', 'type' => 'info', 'info' => array(), 'use_tab' => true);
$entityInfo = en_get_general_info($en_ID);
//$entity['stats'] = array('n'=>"\n".$etel_completion_array[$entityInfo['cd_completion']]['txt']);
$entity['display_fields'] = array(array('ar' => array(array('k' => 'st', 'edit' => 'textarea', 'tstamp' => true), array('k' => 'upd', 'edit' => 'button', 'f' => array('s|f|update_general|', 'fld|nst|st'), 'n' => '(Update)')), 'n' => 'General Info'));
//,'em|Email'
$entity['info'][] = array('sid' => $en_ID, 'st' => $entityInfo['en_info']['General_Notes']);
$data['entity_info'][] = $entity;
if ($request != 'all') {
break;
}
case 'is':
$entity = array('id' => $en_ID, 'msg' => 'No Issues Available', 'type' => 'is', 'info' => array(), 'use_tab' => true);
$issues = en_get_issues($en_ID, array('AnsweredStatus' => $qry['st']));
$entity['display_fields'] = array(array('k' => 'sid', 'n' => 'ID', 'dl' => array('il')), array('k' => 'ti', 'n' => 'Summary', 'dl' => array('il')), array('k' => 'is', 'n' => 'Respond', 'pl' => array('el')), array('k' => 'st', 'n' => 'Status'), array('k' => 'cs', 'n' => 'Answered'));
foreach ($issues as $id => $issue) {
$entity['info'][] = array('sid' => $id, 'ti' => $issue['iss_created_date'] . " - " . $issue['iss_summary'], 'st' => $issue['sta_title'], 'cs' => $issue['iss_control_status'], 'il' => "/ev/view.php?id=" . $issue['iss_id'], 'el' => "/ev/send.php?issue_id=" . $issue['iss_id'] . "&ema_id=" . $issue['ema_id'] . "&id=" . $issue['sup_id']);
}
$data['entity_info'][] = $entity;
if ($request != 'all') {
break;
}
case 'ac':
global $etel_access;
$entityInfo = en_get_general_info($en_ID);
$entity = array('id' => $en_ID, 'msg' => 'No Access Info Available', 'type' => 'ac', 'info' => array(), 'use_tab' => true);
$entity['display_fields'] = array(array('k' => 'na', 'n' => 'Access Level'), array('ar' => array(array('k' => 'st', 'edit' => 'checkbox', 'f' => array('s|f|update_access|', 'k|al|sid', 'fld|nst|st'))), 'n' => 'Status'));
foreach ($etel_access as $key => $acinfo) {
$entity['info'][] = array('sid' => $acinfo['Value'], 'na' => $acinfo['Value'] . ": " . etel_format_variable($key) . ($acinfo['Name'] ? " (" . $acinfo['Name'] . ")" : ''), 'st' => $entityInfo['en_access'][$acinfo['Value']]);
}
if ($curUserInfo['en_access'][ACCESS_AUTH_ENTITY_ADMIN]) {
$data['entity_info'][] = $entity;
}
if ($request != 'all') {
break;
}
case 'pr':
$entity = array('id' => $en_ID, 'msg' => 'No Profit Data Available', 'type' => 'pr', 'info' => array(), 'use_tab' => true);
$RF = new rates_fees();
$entityInfo = en_get_general_info($en_ID);
$datestamp = $_REQUEST['date'] ? strtotime($_REQUEST['date']) : 0;
$date = $datestamp > 1 ? date('Y-m-d', $datestamp) : $entityInfo['PaySchedule']['NextPayDay'];
$profit_info = $RF->get_profit(array('EffectiveOnly' => $date), $en_ID);
$entity['display_fields'] = array(array('k' => 'tp', 'n' => 'Profit Type'), array('k' => 'am', 'n' => 'Amount'));
//,'em|Email'
$entity['stats']['opts'] = array('n' => "Actions", 'ar' => array(array('txt' => "Make an Adjustment", 'attrib' => array('obj|style|font-weight:bold;text-align:center;')), array('node' => "hr"), array('txt' => "Amount: "), array('k' => 'ia', 'edit' => 'textfield', 'attrib' => array('obj|style|width:50px;')), array('txt' => "\nEffective: "), array('k' => 'ie', 'edit' => 'textfield', 'attrib' => array('obj|style|width:70px;')), array('txt' => "\nTitle:\n"), array('k' => 'in', 'edit' => 'textfield', 'attrib' => array('obj|style|width:180px;')), array('txt' => "\nComments:\n"), array('k' => 'ic', 'edit' => 'textarea', 'attrib' => array('obj|style|height:45px;width:180px;')), array('txt' => "\n"), array('k' => 'adj', 'edit' => 'button', 'f' => array('s|f|add_adjustment', 'fld|ia|ia', 'fld|ie|ie', 'fld|in|in', 'fld|ic|ic'), 'n' => '(Create)'), array('node' => "hr")), 'attrib' => array('tdcol|align|left'));
$entity['stats']['data'] = array('sid' => $en_ID, 'am' => $profit_info['Total']['Amount'], 'ic' => '', 'ia' => '0.00', 'in' => date('Y-m-d') . ' Adjustment', 'ie' => date('Y-m-d'));
if (!$curUserInfo['en_access'][ACCESS_AUTH_ADJUSTMENTS]) {
unset($entity['stats']);
}
$total_section_format = array('tr|style|font-weight:bold;font-style:italic;', 'td|class|row0');
$total_format = array('tr|style|font-weight:bold;font-size:11px;font-style:italic;', 'td|class|row0');
//,"td|onclick|"
if (sizeof($profit_info['Revenue'])) {
foreach ($profit_info['Revenue'] as $type => $val) {
$entity['info'][] = array('sid' => 'd_' . $type, 'tp' => "(Revenue) {$type}", 'am' => '$' . formatMoney($val['Amount']) . " (" . $val['Count'] . ")", 'attrib' => $type == 'Total' ? $total_section_format : NULL);
}
}
if (sizeof($profit_info['Deductions'])) {
foreach ($profit_info['Deductions'] as $type => $val) {
$entity['info'][] = array('sid' => 'd_' . $type, 'tp' => "(Deductions) {$type}", 'am' => '$' . formatMoney($val['Amount']) . " (" . $val['Count'] . ")", 'attrib' => $type == 'Total' ? $total_section_format : NULL);
}
}
$entity['info'][] = array('sid' => $en_ID, 'tp' => "Total Owed (" . $date . ")", 'am' => '$' . formatMoney($profit_info['Total']['Amount']) . " (" . $profit_info['Total']['Count'] . ")", 'attrib' => $total_format, 'opts' => array('tp' => array('k' => 'tp', 'dl' => array('chg', 'Click to Change Date'))), 'chg' => "javascript:en_get_info({'id':'{$en_ID}','type':'pr','date':prompt('Enter New Date','{$date}')})");
$data['num_rows']++;
$data['entity_info'][] = $entity;
if ($request != 'all') {
break;
}
case 'pa':
$entity = array('id' => $en_ID, 'msg' => 'No Payout Data Available', 'type' => 'pa', 'info' => array(), 'use_tab' => true);
$RF = new rates_fees();
$payouts = $RF->get_payouts(array('where' => $qry['st'] ? array('pa_status' => $qry['st']) : NULL), $en_ID);
$entityInfo = en_get_general_info($en_ID);
foreach ($payouts as $key => $payout) {
$entity['info'][] = array('sid' => $payout['pa_ID'], 'am' => '$' . formatMoney($payout['balance']), 'in' => $payout['pa_info']['Notes'], 'ti' => ($payout['pa_ID'] == $qry['hl'] ? 'Recently Updated - ' : '') . $payout['pa_desc'], 'nst' => $payout['pa_status'], 'attrib' => $payout['pa_ID'] == $qry['hl'] ? $highlight_format : NULL);
}
$entity['display_fields'] = array(array('ar' => array(array('k' => 'ti', 'attrib' => array('obj|style|font-weight:bold')), array('node' => "br"), array('k' => 'nst', 'edit' => 'select', 'selopts' => array('payout_pending|Payment Pending', 'payout_sent|Payment Sent', 'success|Successful Payment', 'payout_failed|Payment Failed'), 'n' => 'Status: ')), 'n' => 'Invoice Info'), array('ar' => array(array('k' => 'in', 'edit' => 'textarea', 'attrib' => array('obj|style|height:45px;width:250px;'))), 'n' => 'Comments'), array('ar' => array(array('k' => 'upd', 'edit' => 'button', 'f' => array('s|f|update_invoice', 'k|ii|sid', 'fld|nst|nst', 'fld|in|in', 'fld|em|em', 's|st|' . $qry['st']), 'n' => '(Update)'), array('k' => 'em', 'edit' => 'checkbox', 'n' => ' Email?')), 'n' => 'Update', 'attrib' => array('obj|style|width:50px;')));
//,'em|Email'
$entity['stats']['opts'] = array('n' => "Actions", 'ar' => array(array('txt' => "Payout", 'attrib' => array('obj|style|font-weight:bold;text-align:center;', 'tdcol|style|width:40px;')), array('node' => "hr"), array('txt' => "Amount:\n"), array('k' => 'pa', 'edit' => 'textfield', 'attrib' => array('obj|style|width:60px;')), array('txt' => "\nPayday:\n"), array('k' => 'pd', 'edit' => 'textfield', 'attrib' => array('obj|style|width:60px;')), array('txt' => "\n"), array('k' => 'pay', 'edit' => 'button', 'f' => array('s|f|commit_payout', 'fld|pa|pa', 'fld|pd|pd'), 'n' => '(Pay)')), 'attrib' => array('tdcol|align|left'));
$entity['stats']['data'] = array('sid' => $en_ID, 'pa' => '0.0', 'pd' => $entityInfo['PaySchedule']['NextPayDay']);
if (!$curUserInfo['en_access'][ACCESS_AUTH_PAYMENTS]) {
unset($entity['stats']);
}
$data['entity_info'][] = $entity;
if ($request != 'all') {
break;
}
case 'ws':
$entity = array('id' => $en_ID, 'msg' => 'No Website Data Available', 'type' => 'ws', 'info' => array(), 'use_tab' => true);
$site_list = en_get_websites($en_ID, false, $qry['st']);
$entity['display_fields'] = array(array('k' => 'na', 'n' => 'Website'), array('ar' => array(array('k' => 'edt', 'edit' => 'button', 'f' => array('s|f|update_site', 'k|wi|sid', 'p|nvr|Please Enter New Status (a=Approved, d=Declined, i=Ignored, n=Non-Compliant)', 'p|nc|Please Enter Comments (Required for Decline)', 's|st|' . $qry['st']), 'n' => '(Change)'), array('k' => 'vr')), 'n' => 'Status'), array('ar' => array(array('k' => 'cu', 'n' => '(Website)', 'pl' => array('cu')), array('k' => 'op', 'n' => '(Order Page)', 'pl' => array('op')), array('k' => 'rp', 'n' => '(Return Page)', 'pl' => array('rp')), array('k' => 'mem', 'n' => '(Members Section)', 'pl' => array('mu', 'mun', 'mpw')), array('k' => 'ftp', 'n' => '(Ftp)', 'pl' => array('ft', 'fun', 'fpw')), array('k' => '2257', 'n' => '(2257 Page)', 'pl' => array('2257'))), 'n' => 'Links', 'attrib' => array('td|width|144px')));
foreach ($site_list as $key => $site) {
$entity['info'][] = array('sid' => $site['cs_ID'], 'rf' => $site['cs_reference_ID'], 'na' => $site['cs_name'], 'cu' => $site['cs_URL'], 'op' => $site['cs_order_page'], 'rp' => $site['cs_return_page'], 'mu' => $site['cs_member_url'], 'mun' => $site['cs_member_username'], 'mpw' => $site['cs_member_password'], 'ft' => $site['cs_ftp'], 'fun' => $site['cs_ftp_user'], 'fpw' => $site['cs_ftp_pass'], 'vr' => ucfirst($site['cs_verified']) . ' (' . $site['cs_reason'] . ')', '2257' => $site['cs_2257_page']);
}
$data['num_rows']++;
$data['entity_info'][] = $entity;
if ($request != 'all') {
break;
}
case 'ud':
$entity = array('id' => $en_ID, 'msg' => 'No Document Data Available', 'type' => 'ud', 'info' => array(), 'use_tab' => true);
$doc_list = en_get_documents($en_ID, $qry['st']);
$entity['display_fields'] = array(array('k' => 'ft', 'n' => 'File Type'), array('ar' => array(array('k' => 'fl', 'n' => 'File Link', 'pl' => array('fl')), array('k' => 'up', 'n' => 'Upload New File', 'pl' => array('up')), array('k' => 'fn', 'n' => 'File Name')), 'n' => 'File Name'), array('ar' => array(array('k' => 'edt', 'edit' => 'button', 'f' => array('s|f|update_doc', 'k|fi|sid', 'p|nst|Please Enter New Status (a=Approved, d=Declined)', 'p|nc|Please Enter Comments (Required for Decline)', 's|st|' . $qry['st']), 'n' => '(Change)'), array('k' => 'st'), array('k' => 'rr')), 'n' => 'Status'));
foreach ($doc_list as $key => $doc) {
$entity['info'][] = array('sid' => $doc['file_id'], 'ft' => $doc['file_type'], 'fn' => $doc['file_name'], 'du' => $doc['date_uploaded'], 'rr' => '(' . $doc['reject_reason'] . ')', 'st' => $doc['status'], 'fl' => "../gateway/" . $_SESSION['gw_folder'] . "UserDocuments/" . $doc['file_type'] . "/" . $doc['file_name'], 'up' => "uploadDocuments.php?company=" . $doc['user_id']);
}
$data['num_rows']++;
$data['entity_info'][] = $entity;
if ($request != 'all') {
break;
}
case 'pp':
$entity = array('id' => $en_ID, 'msg' => 'No Price Point Data', 'type' => 'pp', 'info' => array(), 'use_tab' => true);
$pp_list = en_get_pricepoints($en_ID);
foreach ($pp_list as $key => $pp) {
$entity['info'][] = array('sid' => $pp['rd_subaccount'], 'sn' => $pp['rd_subName'], 'de' => $pp['rd_description'], 'sc' => $pp['schedule'], 'st' => $pp['active'] . "/" . $pp['total']);
}
$entity['display_fields'] = array(array('k' => 'sn', 'n' => 'Name'), array('k' => 'de', 'n' => 'Description'), array('k' => 'sc', 'n' => 'Price Point Schedule'), array('k' => 'st', 'n' => 'Active/Total'));
$data['entity_info'][] = $entity;
if ($request != 'all') {
break;
}
}
}
$data['entity_ids'] = $qry['id'];
break;
case 'getCompanyInfo':
$sql_info = JSON_getCompanyInfo_build($qry);
$limit_to = $sql_info['limit_to'];
$sql = $sql_info['sql_full'] . " order by companyname asc limit {$limit_to}";
$result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}");
$i = 0;
$website_search_ids = "-1";
$company_list = array();
while ($company = mysql_fetch_assoc($result)) {
$website_search_ids .= "," . $company['ui'];
$company_list[] = $company;
}
$sql = "select FOUND_ROWS()";
$result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}");
$data['num_rows'] = mysql_result($result, 0, 0);
$sql = "select cs_ID as ci,cs_name as cn,cs_company_ID as cui FROM `cs_company_sites` as cs \r\n\t\t\t where cs_company_ID in ({$website_search_ids}) order by cs_name";
// left join cs_transactiondetails td on cd . userId =td . userId
// group by cd.userId
$result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}");
$site_list = array();
while ($site = mysql_fetch_assoc($result)) {
$site_list[] = $site;
}
$data['company_list'] = $company_list;
$data['show_option_all'] = $sql_info['show_option_all'];
$data['site_list'] = $site_list;
$data['completion'] = $etel_completion_array;
break;
case 'getEVTransactionResults':
$search_array = array('em' => 'email', 'cc' => 'CCNumber', 'rn' => 'reference_number', 'ss' => 'td_ss_ID');
$limit_to = 50;
if ($qry['search'] && $qry['searchby'] == 'cc') {
$qry['search'] = etelEnc($qry['search']);
}
if ($qry['search'] && $qry['searchby'] && $search_array[$qry['searchby']]) {
$sql_where .= " and " . $search_array[$qry['searchby']] . " = '" . $qry['search'] . "'";
}
$sql = "\r\n\t\t\t\tselect \r\n\t\t\t\t\tDate_Format(transactionDate,'%W %b %D %Y %H:%i:%s') as 'Date',\r\n\t\t\t\t\treference_number as 'Reference ID',\r\n\t\t\t\t\tconcat(name,' ',surname) as 'Full Name' ,\r\n\t\t\t\t\temail as 'Email Address',\r\n\t\t\t\t\tCONCAT(\t\r\n\t\t\t\t\t\tif(status!='D',\r\n\t\t\t\t\t\t\tif(status='P','Pending', 'Approved'),\r\n\t\t\t\t\t\t\t'Declined'\r\n\t\t\t\t\t\t)\t\t\r\n\t\t\t\t\t) as 'Status',\r\n\t\t\t\t\tif(td_is_a_rebill=1,' Rebilled Transaction',' New Order') as 'Type'\r\n\t\t\t\tfrom cs_transactiondetails as td\r\n\t\t\t\twhere \r\n\t\t\t\t\t1 {$sql_where} \r\n\t\t\t\torder by transactionDate desc\r\n\t\t\t\tlimit {$limit_to}\r\n\t\t\t\t";
$result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}");
$data['output'] = "<table >\n";
$i = 0;
while ($trans = mysql_fetch_assoc($result)) {
if ($i == 0) {
$data['output'] .= " <tr class='default'>\n";
foreach ($trans as $field => $value) {
$data['output'] .= " <td><b>{$field}</b></td>\n";
}
$data['output'] .= " </tr>\n";
}
$data['output'] .= " <tr class='default' onclick='td_updateWith(\"" . $trans['Reference ID'] . "\")' onmouseout='td_highlightRow(this,0)' onmousemove='td_highlightRow(this,1)'>\n";
foreach ($trans as $field => $value) {
$data['output'] .= " <td>{$value}</td>\n";
}
$data['output'] .= " </tr>\n";
$i++;
}
$data['output'] .= " <tr class='default'>\n <td>({$i}) Results</td>\n </tr>\n</table>";
break;
default:
$data['func'] = NULL;
break;
}
foreach ($qry as $key => $value) {
$data['json_query'] .= ($data['json_query'] ? "&" : "") . $key . '=' . $value;
}
//print_r($data);
if (!$data['output']) {
unset($data['output']);
}
$data['duration'] = round(microtime_float() - $start_time, 4);
return $data;
}
function set_affiliate($en_ID, $affiliate_en_ID, $type = 'Affiliate', $info = array())
{
$return = array('status' => false, 'msg' => 'Unable to add affiliate association');
$sql = "Insert ignore into \r\n\t\t\tcs_entities_affiliates set ea_en_ID = '{$en_ID}', ea_affiliate_ID = '" . $affiliate_en_ID . "', ea_type = '{$type}' ";
sql_query_write($sql) or dieLog(mysql_error() . " ~ {$str_qry}");
if (mysql_insert_id() > 0) {
$return['status'] = true;
$return['msg'] = $type . ' associated successfully';
}
$key = $type;
if ($key == 'Affiliate') {
$key .= "_" . $affiliate_en_ID;
}
$update = array('default' => array($key => array('disct' => $info['Disc_Markup'], 'trans' => $info['Trans_Markup'], 'en_ID' => $affiliate_en_ID)));
etel_update_serialized_field('cs_company_banks', 'cb_config', " cb_en_ID = '{$en_ID}' and bank_id=0", $update);
return $return;
}
delete
FROM `cs_profit_action`
WHERE pa_type = 'Payout'
*/
die;
$sql = "Select \r\n*\r\n from cs_companydetails\r\n ";
$result = sql_query_read($sql) or dieLog($sql);
while ($companyInfo = mysql_fetch_assoc($result)) {
$method = 'Wire';
if (in_array($companyInfo['bank_country'], array('US', 'USA', 'select'))) {
$method = 'ACH';
$companyInfo['bank_country'] = 'US';
}
$update = array('General_Info' => array('Company_Url' => $companyInfo['url1'], 'Company_Legal_Name' => $companyInfo['legal_name'], 'Company_Address' => $companyInfo['physical_address'], 'Company_Fax_DBA' => $companyInfo['fax_dba'], 'Incorporated_Country' => $companyInfo['incorporated_country'], 'Incorporated_Number' => $companyInfo['incorporated_number'], 'Sex' => $companyInfo['ssex'], 'Date_of_Birth' => $companyInfo['sdateofbirth'], 'Address' => $companyInfo['sAddress'], 'Zip_Code' => $companyInfo['sPostCode'], 'City' => $companyInfo['city'], 'State' => $companyInfo['company_bank'], 'Country' => $companyInfo['country'], 'Company_Tech_Contact' => $companyInfo['technical_contact_details'], 'Contact_Phone' => $companyInfo['contact_phone'], 'Cell_Phone' => $companyInfo['cellular'], 'Contact_IM' => $companyInfo['cd_contact_im'], 'Time_Zone' => $companyInfo['cd_timezone'], 'Contact_Fax' => $companyInfo['sFax'], 'Personal_Phone' => $companyInfo['sResidenceTelephone'], 'Hear_About_Us' => $companyInfo['how_about_us']), 'Processing_Info' => array('Transaction_Type' => $companyInfo['transaction_type'], 'Service_List' => $companyInfo['goods_list'], 'Anti_Fraud_System' => $companyInfo['current_anti_fraud_system'], 'CS_Program' => $companyInfo['customer_service_program'], 'Refund_Policy' => $companyInfo['refund_policy'], 'Volume_Last_month' => $companyInfo['volume_last_month'], 'Volume_Prev_30Days' => $companyInfo['volume_prev_30days'], 'Volume_Prev_60Days' => $companyInfo['volume_prev_60days'], 'Volume_Forcast_1Month' => $companyInfo['forecast_volume_1month'], 'Volume_Forcast_2Month' => $companyInfo['forecast_volume_2month'], 'Volume_Forcast_3Month' => $companyInfo['forecast_volume_3month'], 'Projected_Monthly_Sales' => $companyInfo['volumenumber'], 'Average_Ticket_Price' => $companyInfo['avgticket'], 'Chargeback_%' => $companyInfo['chargebackper'], 'Previous_Processor_Trans_Fee' => $companyInfo['cd_previous_transaction_fee'], 'Previous_Processor_Disc_Fee' => $companyInfo['cd_previous_discount'], 'Previous_Processing' => $companyInfo['cd_previous_processor'], 'Previous_Processor_Reason' => $companyInfo['cd_processing_reason'], 'Recur_Billing' => $companyInfo['recurbilling'], 'Currently_Processing' => $companyInfo['currprocessing']), 'Payment_Data' => array('Method' => $method, 'ACH' => array('Bank_Name' => $companyInfo['company_bank'], 'Bank_Address' => $companyInfo['bank_address'], 'Bank_ZipCode' => $companyInfo['bank_zipcode'], 'Bank_City' => $companyInfo['bank_city'], 'Bank_State' => $companyInfo['bank_state'], 'Bank_Country' => $companyInfo['bank_country'], 'Bank_Phone' => $companyInfo['bank_phone'], 'Bank_Beneficiary_Name' => $companyInfo['beneficiary_name'], 'Bank_Account_Name' => $companyInfo['bank_account_name'], 'Bank_Account_Number' => $companyInfo['bank_account_number'], 'Bank_Routing_Number' => $companyInfo['cd_bank_routingnumber'], 'Bank_Additional_Notes' => $companyInfo['cd_bank_instructions']), 'Wire' => array('Bank_Name' => $companyInfo['company_bank'], 'Bank_Address' => $companyInfo['bank_address'], 'Bank_ZipCode' => $companyInfo['bank_zipcode'], 'Bank_City' => $companyInfo['bank_city'], 'Bank_State' => $companyInfo['bank_state'], 'Bank_Country' => $companyInfo['bank_country'], 'Bank_Phone' => $companyInfo['bank_phone'], 'Bank_Beneficiary_Name' => $companyInfo['beneficiary_name'], 'Bank_Account_Name' => $companyInfo['bank_account_name'], 'Bank_Account_Number' => $companyInfo['bank_account_number'], 'Bank_Routing_Number' => $companyInfo['cd_bank_routingnumber'], 'Bank_Routing_Type' => $companyInfo['cd_bank_routingcode'], 'Bank_Sort_Code' => $companyInfo['bank_sort_code'], 'Bank_VAT_Number' => $companyInfo['VATnumber'], 'Bank_Registration_Number' => $companyInfo['registrationNo'], 'Bank_Additional_Notes' => $companyInfo['cd_bank_instructions'], 'Intermediary_Bank_Routing_Type' => $companyInfo['bank_IBRoutingCodeType'], 'Intermediary_Bank_Routing_Number' => $companyInfo['bank_IBRoutingCode'], 'Intermediary_Bank_Name' => $companyInfo['bank_IBName'], 'Intermediary_Bank_City' => $companyInfo['bank_IBCity'], 'Intermediary_Bank_State' => $companyInfo['bank_IBState'])));
$res = etel_update_serialized_field('cs_entities', 'en_info', " en_type='merchant' and en_type_ID = '" . $companyInfo['userId'] . "'", $update);
$i++;
}
echo $i;
die;
$RF = new rates_fees();
//for($i=0;$i<1000000000;$i+=10000)
//{
$j = 0;
$bank_id = 18;
$sql = "SELECT min( pa_trans_id ) AS mintrans\r\nFROM `cs_profit_action`";
$result = sql_query_read($sql) or dieLog($sql);
$min = mysql_result($result, 0, 0);
if ($min < 1) {
$min = 500000000;
}
function smart_updateMarkup($values, $action, $updateall = false)
{
global $curUserInfo;
$en_ID = $values['append'];
if ($updateall) {
$res_disc = $_POST['default_disc'];
$res_trans = $_POST['default_trans'];
} else {
$res_disc = $_POST['res_disc_' . $userid];
$res_trans = $_POST['res_trans_' . $userid];
}
$sql = "select cb_ID,cb_config\n\t\t\tFROM \n\t\t\t\tcs_entities as ce\n\t\t\tLEFT JOIN \n\t\t\t\tcs_entities_affiliates as ea ON (ea.ea_en_ID = ce.en_ID)\n\t\t\tLEFT JOIN \n\t\t\t\tcs_company_banks as cb ON (ce.en_ID = cb.cb_en_ID AND cb.bank_id = 0)\n\t\t\tWHERE\n\t\t\t\tea.ea_affiliate_ID = '" . $curUserInfo['en_ID'] . "'";
if ($en_ID || !$updateall) {
$sql .= " and ce.en_ID = '{$en_ID}'";
}
$markupResult = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}");
if (!mysql_num_rows($markupResult)) {
return array("action" => "Affiliate(s) Not Found.", "status" => "fail");
}
while ($markupInfo = mysql_fetch_assoc($markupResult)) {
if (!$markupInfo['cb_ID']) {
$sql = "insert into cs_company_banks set cb_en_ID = '" . intval($markupInfo['merchant_en_ID']) . "',bank_id=0;";
$result = sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}");
$cb_ID = mysql_insert_id();
} else {
$cb_ID = $markupInfo['cb_ID'];
$markupInfo['cb_config'] = etel_unserialize($markupInfo['cb_config']);
}
$update = array('default' => array('Reseller' => array('disct' => $res_disc, 'trans' => $res_trans, 'en_ID' => $curUserInfo['en_ID'])));
if ($updateall && $markupInfo['cb_config']['default']['Reseller']) {
$update = NULL;
}
if ($update) {
$updated = etel_update_serialized_field('cs_company_banks', 'cb_config', " cb_ID = '{$cb_ID}'", $update);
if (!$updateall) {
if ($updated) {
return array("action" => "Merchant Rates Updated Successfully.", "status" => "success");
}
return array("action" => "Error, Please contact support.", "status" => "fail");
}
}
}
return array("action" => "Merchant(s) Rates Updated Successfully.", "status" => "success");
}
if (!$headerInclude) {
$headerInclude = "startHere";
}
require_once "includes/header.php";
require_once "../includes/updateAccess.php";
$en_ID = intval($companyInfo['en_ID']);
$step = intval($_REQUEST['step']);
if ($companyInfo['en_info']['Reseller']['Completion'] < 2) {
step_1($en_ID);
if ($companyInfo['en_info']['Reseller']['Completion'] < 1) {
$companyInfo['en_info']['Reseller']['Completion'] = 1;
}
//, 1 as 'User Job Title', 1 as 'Monthly Affiliate Volume'
step_2($en_ID);
$update['Reseller']['Completion'] = 2;
etel_update_serialized_field('cs_entities', 'en_info', " en_ID = '{$en_ID}'", $update);
toLog('completedapplication', 'reseller', '', $en_ID);
beginTable();
echo "<b>You have successfully completed your Reseller Application.</b>";
endTable("Reseller Application Complete!", "resellerContract.php", true, false, true);
} else {
if ($step == 2) {
step_2($en_ID, false);
} else {
step_1($en_ID, false);
}
}
die;
function draw_step_buttons($step = 1, $disable = false)
{
if ($disable) {
