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) {