$msgtodisplay = "<table width='350' height='100' align='center' valign='middle' style='border:1px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='1' color='red'>Existing Company name !! </font></td></tr><tr><td align='center'><a href='javascript:window.history.back();'><img border='0' src='images/back.jpg'></a></td></tr></table>";
} elseif ($user_mailidexist == 1) {
$msgtodisplay = "<table width='350' height='100' align='center' valign='middle' style='border:1px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='1' color='red'>Existing Mail ID !! </font></td></tr><tr><td align='center'><a href='javascript:window.history.back();'><img border='0' src='images/back.jpg'></a></td></tr></table>";
} else {
$qry_insert_user = "******";
$qry_insert_user .= " values('{$username}','{$password}','{$companyname}','{$email}','{$voulmeNumber}',0,'{$transaction_type}','{$how_about_us}','{$reseller}','{$current_date_time}',{$send_ecommercemail},{$gatewayid})";
if (!($show_sql = mysql_query($qry_insert_user))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Cannot execute query <br>";
print $qry_insert_user;
exit;
} else {
$is_success = 0;
$user_id = mysql_insert_id();
$user_reference_num = func_User_Ref_No($user_id);
$is_success = func_update_single_field('cs_companydetails', 'ReferenceNumber', $user_reference_num, 'userId', $user_id, $cnn_cs);
if ($is_success == 1) {
/************** to sent registration mail to the company*********/
$qry_select_sent = "Select mail_id,mail_sent from cs_registrationmail";
$rst_select_sent = mysql_query($qry_select_sent, $cnn_cs);
if (mysql_num_rows($rst_select_sent) > 0) {
$mail_sent = mysql_result($rst_select_sent, 0, 1);
}
$email_from = $email1;
$email_to = $email1;
$email_subject = "Registration Confirmation";
$transactiontype = func_get_merchant_name($transaction_type);
$email_message = func_getreplymailbody_admin($companyname, $username, $password, $user_reference_num, $transactiontype, $how_about_us, $voulmeNumber);
if (!func_send_mail($email_from, $email_to, $email_subject, $email_message)) {
print "An error encountered while sending the mail.";
}
$rollamt = $i_crdnet_amt;
} elseif ($i_crdnet_amt < 500 && $invoicenetamount < 500) {
$rollamt = $i_crdnet_amt - $invoicenetamount;
}
$qry_select = "Select netAmount,invoiceId from cs_invoicedetails where generateddate >' {$approvedstatusdate}' and userId ='{$userid}' ";
if (!($rst_invoice = mysql_query($qry_select, $cnn_cs))) {
print "Cannot execute query";
exit;
} else {
$num = mysql_num_rows($rst_invoice);
for ($iloop = 1; $iloop <= $num; $iloop++) {
$rst_amount = mysql_fetch_array($rst_invoice);
$futnetamount = $rst_amount[0];
$invoiceid = $rst_amount[1];
$futnetamount += $rollamt;
func_update_single_field('cs_invoicedetails', 'netAmount', $futnetamount, 'invoiceId', $invoiceid, $cnn_cs);
if ($futnetamount > 500) {
break;
}
//end of if
}
//end of for
}
//end of else
}
//end of if
}
//end of if
//echo $trans_amount;
}
//end of else
if ($i_crdnet_amt >= 500) {
$i_crdnet_amt -= 50;
$wirefee = 50;
}
if ($creditcardAmt != 0) {
$qry_invoice = "insert into cs_invoicedetails (userId,gatewayid,totalAmt,approvedAmt,declinedAmt,creditAmt,pendingamt ,chargeBack,credit,discount,transactionFee,voiceAuthorisation_fee,reserveFee,totalDeductions,netAmount,adminApproved,generateddate,startdate,enddate,checkorcard,processingcurrency,transactionno,approvedno,declinedno,pendingno,creditno,voiceuploadfee,chargebackno, resellerid,canceledno,nopass,nopasscount,passed,passedcount,voiceuploadcount,wirefee,bank_id,reject_count,reject_amt,reject_creditamt,reject_chargebackamt,reject_transfee,cancel_startdate,cancel_enddate,reject_creditcount,reject_chargebackcount)values('{$iuserid}','{$igatewayid}','{$creditcardAmt}','{$creditapprovedAmt}','{$creditdeclinedAmt}','{$creditcanceledAmt}','{$creditpendingAmt}','{$crdchargebackamount}','{$crdcredit_amount}','{$i_crddiscount_amt}','{$i_crdtransaction_amt}',{$i_crdvoiceauth_amt},'{$i_crdreserve_amt}','{$crddeducted_amt}','{$i_crdnet_amt}','N','{$approvedstatusdate}','{$str_startdate}','{$str_afterdate}','H',";
$qry_invoice .= "'{$str_processingcurency}','{$creditcard}','{$creditapproved}','{$creditdeclined}','{$creditpending}','{$crdcredit_count}',0,'{$crdcharge_back_count}','{$iresellerid}','{$creditcanceled}'";
$qry_invoice .= ",'{$creditnonpassAmt}','{$creditnonpass}','{$creditpassAmt}','{$creditpass}','{$chqvoice_authcount}',{$wirefee},{$ibankid},{$rej_creditcanceled},{$rej_creditcanceledAmt},{$rej_crdcredit_amount},{$rej_crdchargebackamount},{$rej_crdtransaction_amt},'{$cancelstartdate}','{$cancelenddate}',{$rej_crdcredit_count},{$rej_crdcharge_back_count} )";
if (!($rst_result = mysql_query($qry_invoice, $cnn_cs))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Cannot execute insert query";
exit;
} else {
$transid = mysql_insert_id();
$ref_number = func_Trans_Ref_No($transid);
$updateSuccess = func_update_single_field('cs_invoicedetails', 'invoiceReferenceNumber', $ref_number, 'invoiceId', $transid, $cnn_cs);
}
}
//inserting the currency details AUD
if ($audcreditcardAmt != 0) {
$qry_invoice = "insert into cs_invoicecurrencydetails (userId,gatewayid,totalAmt,approvedAmt,declinedAmt,creditAmt,pendingamt ,chargeBack,credit,discount,transactionFee,voiceAuthorisation_fee,reserveFee,totalDeductions,netAmount,adminApproved,generateddate,startdate,enddate,checkorcard,processingcurrency,transactionno,approvedno,declinedno,pendingno,creditno,voiceuploadfee,chargebackno, resellerid,canceledno,nopass,nopasscount,passed,passedcount,voiceuploadcount,wirefee,bank_id,reject_count,reject_amt,reject_creditamt,reject_chargebackamt,reject_transfee,cancel_startdate,cancel_enddate,reject_creditcount,reject_chargebackcount,invoiceId)values('{$iuserid}','{$igatewayid}','{$audcreditcardAmt}','{$audcreditapprovedAmt}','{$audcreditdeclinedAmt}','{$audcreditcanceledAmt}','{$audcreditpendingAmt}','{$audcrdchargebackamount}','{$audcrdcredit_amount}','{$audi_crddiscount_amt}','{$audi_crdtransaction_amt}',0,'{$audi_crdreserve_amt}','{$audcrddeducted_amt}','{$audi_crdnet_amt}','N','{$approvedstatusdate}','{$str_startdate}','{$str_afterdate}','H',";
$qry_invoice .= "'AUD','{$audcreditcard}','{$audcreditapproved}','{$audcreditdeclined}','{$audcreditpending}','{$audcrdcredit_count}',0,'{$audcrdcharge_back_count}','{$iresellerid}','{$audcreditcanceled}'";
$qry_invoice .= ",'{$audcreditnonpassAmt}','{$audcreditnonpass}','{$audcreditpassAmt}','{$audcreditpass}','0',{$wirefee},{$ibankid},{$audrej_creditcanceled},{$audrej_creditcanceledAmt},{$audrej_crdcredit_amount},{$audrej_crdchargebackamount},{$audrej_crdtransaction_amt},'{$cancelstartdate}','{$cancelenddate}',{$audrej_crdcredit_count},{$audrej_crdcharge_back_count},{$transid} )";
if (!($rst_result = mysql_query($qry_invoice, $cnn_cs))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Cannot execute insert query";
exit;
}
}
//CAD
if ($cadcreditcardAmt != 0) {
function func_insert_transactionCreditdata($array_transdetails, $company_id_val, $cnn_connection)
{
$trans_insert_status = "";
$reference_number = "NIL";
$str_invalid_date = "";
if (count($array_transdetails) > 0) {
$telephoneno = $array_transdetails[7];
/* $format_split_date = split("/",$array_transdetails[15]);
if(count($format_split_date)== 3 ) {
$format_split_date[0] = strlen(trim($format_split_date[0])) == 1 ? "0".$format_split_date[0] : $format_split_date[0];
$format_split_date[1] = strlen(trim($format_split_date[1])) == 1 ? "0".$format_split_date[1] : $format_split_date[1];
$trans_date_enter = "$format_split_date[0]-$format_split_date[1]-$format_split_date[2]:00";
$trans_date_enter = func_get_date_inyyyymmdd_time($trans_date_enter);
} else {
$trans_date_enter = "";
}*/
$trans_date_enter = date("Y-m-d H:i:s");
if ($trans_date_enter == "") {
$str_invalid_date = "Invalid Date";
} else {
$name = trim($array_transdetails[0]);
$surname = trim($array_transdetails[1]);
$address = trim($array_transdetails[2]);
$city = trim($array_transdetails[3]);
$state = trim($array_transdetails[4]);
$zipcode = trim($array_transdetails[5]);
$country = trim($array_transdetails[6]);
$phonenumber = trim($array_transdetails[7]);
$email = trim($array_transdetails[8]);
$amount = trim($array_transdetails[9]);
$checkorcard = "H";
$cardType = trim($array_transdetails[10]);
$CCnumber = trim($array_transdetails[11]);
$cvv = trim($array_transdetails[12]);
$validupto = trim($array_transdetails[13]);
$transactionDate = date("Y-m-d H:i:s");
$productdescription = trim($array_transdetails[14]);
$billingDate = trim($array_transdetails[15]);
$firstnum = substr($CCnumber, 0, 1);
if ($firstnum == "5") {
$cardType = "Master";
} else {
$cardType = "Visa";
}
$userid = $company_id_val;
$domain = GetHostByName($_SERVER["REMOTE_ADDR"]);
$temp = $billingDate;
$tem = explode("/", $temp);
$mm = $tem[0];
$dd = $tem[1];
$yyyy = $tem[2];
$d = $yyyy . "-" . $mm . "-" . $dd;
$qrt_insert_details = "insert into cs_transactiondetails (name,surname,address,city,state,zipcode,country,phonenumber,email,amount,checkorcard,cardtype,CCnumber,cvv,validupto,transactionDate,billingDate,userid,passStatus,pass_count,cancelstatus,status,ipaddress,productdescription,declinedReason,company_usertype,company_user_id)\n\t\t\t\t values('{$array_transdetails['0']}','{$array_transdetails['1']}','{$array_transdetails['2']}','{$array_transdetails['3']}','{$array_transdetails['4']}','{$array_transdetails['5']}','{$array_transdetails['6']}','{$array_transdetails['7']}','{$array_transdetails['8']}',{$array_transdetails['9']},'H','{$cardType}','{$array_transdetails['11']}','{$array_transdetails['12']}','{$array_transdetails['13']}','{$trans_date_enter}','{$d}',{$company_id_val},'PA',0,'N','D','{$domain}','{$array_transdetails['14']}','Error in data',5,{$userid})";
// print $qrt_insert_details ."<br>";
}
if (func_isvalidCardnumber($CCnumber)) {
if (func_isvalidCardnumber($cvv)) {
if ($str_invalid_date == "") {
// Credit card details.
if (!($sql_insert_data = mysql_query($qrt_insert_details))) {
$trans_insert_status = "failure";
} else {
$transactionId = mysql_insert_id();
$ref_number = func_Trans_Ref_No($transactionId);
$updateSuccess = "";
$updateSuccess = func_update_single_field('cs_transactiondetails', 'reference_number', $ref_number, 'transactionId', $transactionId, $cnn_connection);
func_update_rate($userid, $transactionId, $cnn_connection);
if ($updateSuccess = 1) {
$reference_number = $ref_number;
}
$qrt_select_company = "Select companyname,transaction_type,billingdescriptor,email,send_mail,send_ecommercemail,bank_Creditcard,bank_shopId,bank_Username,bank_Password,processing_currency from cs_companydetails where userid='{$company_id_val}'";
if (!($show_sql_run = mysql_query($qrt_select_company))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
} else {
if (mysql_num_rows($show_sql_run) == 0) {
$msgtodisplay = "You are not a valid user";
$outhtml = "y";
message($msgtodisplay, $outhtml, $headerInclude);
exit;
} else {
$company_name = mysql_fetch_array($show_sql_run);
$transaction_type = mysql_result($show_sql_run, 0, 1);
$billingdescriptor = mysql_result($show_sql_run, 0, 2);
$fromaddress = mysql_result($show_sql_run, 0, 3);
$send_mails = mysql_result($show_sql_run, 0, 4);
$send_ecommercemail = mysql_result($show_sql_run, 0, 5);
$bank_CreditcardId = mysql_result($show_sql_run, 0, 6);
$bank_shopId = mysql_result($show_sql_run, 0, 7);
$bank_Username = mysql_result($show_sql_run, 0, 8);
$bank_Password = mysql_result($show_sql_run, 0, 9);
$processing_currency = func_get_cardcurrency($cardType, $company_id_val, $cnn_connection);
func_ins_bankrates($transactionId, $bank_CreditcardId, $cnn_connection);
$firstnum = "";
if ($processing_currency == "") {
$processing_currency = "USD";
}
$updateSuccess = func_update_single_field('cs_transactiondetails', 'currencytype ', $processing_currency, 'transactionId', $transactionId, $cnn_connection);
$updateSuccess = func_update_single_field('cs_transactiondetails', 'bank_id ', $bank_CreditcardId, 'transactionId', $transactionId, $cnn_connection);
$firstnum = substr($CCnumber, 0, 1);
if ($firstnum == "5") {
$cardType = "Master";
} else {
$cardType = "Visa";
}
$cardExpir = split("/", $validupto);
$year = $cardExpir[0];
$cardExpire = $cardExpir[1] . "/" . substr($year, 2, 3);
$abbrCountry = func_country_abbreviation($country);
$abbrState = func_state_abbreviation($state);
// function for submitting to bank
// print "func_volpay_bankprocess($bank_Username,$bank_Password,$reference_number,$cardType,$CCnumber,$cardExpire,$cvv,$name,$surname,$address,$zipcode,$city,$abbrCountry,$phonenumber,$abbrState,$email,$processing_currency,$amount,$cnn_connection,$transactionId)";
if ($bank_CreditcardId == 6 || $bank_CreditcardId == 7 || $bank_CreditcardId == 8) {
$trans_insert_status = func_volpay_bankprocess($bank_Username, $bank_Password, $reference_number, $cardType, $CCnumber, $cardExpire, $cvv, $name, $surname, $address, $zipcode, $city, $abbrCountry, $phonenumber, $abbrState, $email, $processing_currency, $amount, $cnn_connection, $transactionId, $company_id_val);
} else {
if ($bank_CreditcardId == 3) {
$cardTypeBr = $cardType == "Visa" ? "V" : "M";
$trans_insert_status = func_bardo_bankprocess($bank_shopId, "Service", $processing_currency, $reference_number, $surname, $name, $email, $address, $city, $zipcode, $abbrState, $abbrCountry, $phonenumber, $amount, $cardTypeBr, $CCnumber, $cardExpire, $cvv, $transaction_type, $transactionId, $cnn_connection);
}
}
}
}
}
} else {
$trans_insert_status = $str_invalid_date;
}
} else {
$trans_insert_status = "Error in Data";
}
} else {
$trans_insert_status = "Error in Data";
}
print "<tr height='20'><td class='leftbottomright'><font face='verdana' size='1'> {$reference_number}</font></td><td class='leftbottomright'><font face='verdana' size='1'> {$array_transdetails['0']}</font></td><td class='cl1'><font face='verdana' size='1'> {$array_transdetails['1']}</font></td><td class='cl1'><font face='verdana' size='1'> {$array_transdetails['2']}</font></td><td class='cl1'><font face='verdana' size='1'> {$array_transdetails['8']}</font></td><td class='cl1'><font face='verdana' size='1'> {$array_transdetails['7']}</font></td><td class='cl1'><font face='verdana' size='1'> {$trans_insert_status}</font></td></tr>";
}
}
function func_update_approval($companyid, $betweendates_start, $betweendates_end, $chkapproved, $checkexsists, $cnn_cs)
{
$updateapprove = 0;
$updatetrue = 0;
$updatefalse = 0;
$str_refno_update = "";
$str_refno = "";
$alreadyapproved = 0;
$str_refno_app = "";
$qry_select = "select adminApproved,invoiceReferenceNumber,invoiceId from cs_invoicedetails where userId={$companyid} and (startdate='{$betweendates_start}' and enddate='{$betweendates_end}')";
//echo $qry_select."<BR>";
if (!($show_sql = mysql_query($qry_select, $cnn_cs))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
}
for ($count = 0; $count < $checkexsists; $count++) {
$show_select_details = mysql_fetch_array($show_sql);
$adapproved = $show_select_details[0];
$invoiceRefno = $show_select_details[1];
$invoiceno = $show_select_details[2];
//echo $adapproved."<BR>";
//echo $invoiceRefno."<BR>";
if ($adapproved == "N") {
if ($chkapproved == "Y") {
$updateapprove = func_update_single_field('cs_invoicedetails', 'adminApproved', $chkapproved, 'invoiceId', $invoiceno, $cnn_cs);
if ($updateapprove == 1) {
$updatetrue = 1;
$str_refno_update = $invoiceRefno . "-" . $str_refno_update;
}
} else {
$updatefalse = 1;
$str_refno = $invoiceRefno . "-" . $str_refno;
}
} elseif ($adapproved == "Y") {
if ($chkapproved == "Y") {
$alreadyapproved = 1;
$str_refno_app = $invoiceRefno . "-" . $str_refno_app;
} else {
if ($chkapproved == "N") {
$updatefalse = 1;
$str_refno = $invoiceRefno . "-" . $str_refno;
}
}
}
}
//for loop
if ($updatetrue == 1) {
$str_refno_update = "Invoice no: {$str_refno_update} updated";
return $str_refno_update;
}
if ($updatefalse == 1) {
$str_refno = "Invoice no :{$str_refno} aready exsists";
return $str_refno;
}
if ($alreadyapproved == 1) {
$str_refno_app = "Invoice no: {$str_refno_app} aready approved";
return $str_refno_app;
}
}
require_once "includes/dbconnection.php";
include 'includes/function2.php';
require_once 'includes/function.php';
$no_fields = 0;
$qry_empty_reference = "SELECT transactionId,reference_number FROM cs_transactiondetails ";
$rst_select = mysql_query($qry_empty_reference, $cnn_cs);
$i_count = mysql_num_rows($rst_select);
$updateSuccess = "";
$a = 0;
//echo($i_count."<BR>");
for ($i = 0; $i < $i_count; $i++) {
$resultSet = mysql_fetch_array($rst_select);
$transaction_no = $resultSet['transactionId'];
$reference_number = $resultSet['reference_number'];
if ($reference_number == "") {
//echo($transaction_no."<BR>");
$a = $a + 1;
$ref_num = func_Trans_Ref_No($transaction_no);
$updateSuccess = func_update_single_field('cs_transactiondetails', 'reference_number', $ref_num, 'transactionId', $transaction_no, $cnn_cs);
if ($updateSuccess == 0) {
echo "cannot update" . "<BR>";
exit;
}
}
}
if ($updateSuccess == 1) {
echo $a . " Transactions are updated in the table" . "<BR>";
} else {
echo "NO REFERENCE FIELDS ARE EMPTY TO UPDATE";
}
$int_table = "cs_transactiondetails";
}
$qrt_insert_details = "insert into {$int_table} (td_product_id,name,surname,phonenumber,address,checkorcard,CCnumber,accounttype,country,city,state,zipcode,checktype,amount,transactionDate,bankname,bankroutingcode,bankaccountnumber,misc,cancelstatus,status,userid ,ipaddress,voiceAuthorizationno,shippingTrackingno,socialSecurity,driversLicense,billingDate,passStatus,pass_count,licensestate,email,productdescription,company_usertype,company_user_id,currencytype,td_is_pending_check,return_url,from_url,bank_id,td_site_ID,td_username,td_password,td_recur_next_date,td_rebillingID,td_enable_rebill) \n\t\t\tvalues('{$td_product_id}','{$firstname}','{$lastname}','{$phonenumber}','{$address}','C','" . etelEnc($chequenumber) . "','{$accounttype}','{$country}','{$city}','{$state}','{$zip}','{$chequetype}','{$amount}','{$dateToEnter}','{$bankname}','{$bankroutingcode}','{$bankaccountno}','{$misc}','N','',{$companyid},'{$ipaddress}','{$voiceauth}','{$shipping}','{$socialno}','{$licenceno}','{$setbilldate}','PE',0,'{$licensestate}','{$email}','{$productDescription}',4,{$companyid},'{$str_currency}','1','{$i_return_url}','{$from_url}','{$bank_CreditcardId}','{$site_id}','{$td_username}','{$td_password}','{$td_recur_next_date}','{$mt_subAccount}','{$td_enable_rebill}')";
if (!($show_sql = mysql_query($qrt_insert_details, $cnn_cs))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Cannot execute query";
$return_message = "INT";
exit;
} else {
//changed
$trans_id = mysql_insert_id();
func_update_rate($companyid, $trans_id, $cnn_cs, "ch");
//func_ins_bankrates($trans_id,$bank_check,$cnn_cs);
$ref_number = func_Trans_Ref_No($trans_id);
$updateSuccess = "";
$updateSuccess = func_update_single_field($int_table, 'reference_number', $ref_number, 'transactionId', $trans_id, $cnn_cs);
if ($updateSuccess = 1) {
$reference_number = $ref_number;
}
if ($reference_number != "") {
$return_message = "SUC";
}
//inserting data into rebilling section
$str_fields = "";
$str_values = "";
if ($str_recur_date == "Y") {
if ($str_recurdate_mode != "") {
$str_fields = ",recur_mode";
$str_values = ",'" . $str_recurdate_mode . "'";
if ($str_recurdate_mode == "D") {
if ($i_recur_day != "") {
if ($user_mailidexist == 1) {
message("Existing email id. Please Enter a different Email." . $postback, "", "Email", "addReseller.php", false);
include "includes/footer.php";
exit;
}
$current_date_time = func_get_current_date_time();
$rd_subgateway_id = 'NULL';
// Gateway Reseller?
if ($resellerInfo['reseller_id'] == $resellerInfo['rd_subgateway_id'] && $resellerInfo['rd_subgateway_id'] > 0) {
$rd_subgateway_id = "'" . $resellerInfo['rd_subgateway_id'] . "'";
}
$qry_insert = "Insert into cs_resellerdetails (reseller_username, reseller_password, reseller_date_added, reseller_companyname, reseller_contactname, reseller_email, reseller_phone, reseller_url, reseller_monthly_volume, rd_subgateway_id) values ('{$username}', '{$password}', '{$current_date_time}', '{$companyname}', '{$contactname}', '{$email}', '{$phone}', '{$url}', '{$merchantmonthly}', {$rd_subgateway_id})";
if (mysql_query($qry_insert, $cnn_cs)) {
$user_id = mysql_insert_id();
$user_reference_num = func_User_Ref_No($user_id);
$is_success = func_update_single_field('cs_resellerdetails', 'rd_referenceNumber', $user_reference_num, 'reseller_id', $user_id, $cnn_cs);
//$email_from = "*****@*****.**";
$email_subject = "Registration Confirmation";
$email_message = $msgtodisplay;
$email_to = $email;
$emailData["email"] = $email;
$emailData["full_name"] = $contactname;
$emailData["companyname"] = $companyname;
$emailData["username"] = $username;
$emailData["password"] = $password;
$emailData["gateway_select"] = $companyInfo['gateway_id'];
$emailContents = get_email_template("reseller_welcome_letter", $emailData);
send_email_template("reseller_welcome_letter", $emailData);
message("{$companyname} Created Successfully. Email sent to {$email}", "Success", "Success", false);
} else {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
function add_new_merchant($companyInfo, $sendmail = true, $getmail = false)
{
$returnInfo = array('status' => true, 'msg' => 'Company Created Successfully');
//foreach($companyInfo as $key=>$data)
// $companyInfo[$key] = quote_smart($data);
$res = check_merchant_conflict($companyInfo);
if (!$res['status']) {
return $res;
}
if ($res['res']['ref']) {
$companyInfo['en_ref'] = substr(strtoupper(md5(time() + rand(1, 1000000))), 0, 8);
}
$qry_insert_user = "******";
$qry_insert_user .= " values('" . $companyInfo['en_username'] . "','" . $companyInfo['en_password'] . "','" . $companyInfo['en_company'] . "','" . $companyInfo['en_ref'] . "','" . $companyInfo['en_email'] . "','" . $companyInfo['volumenumber'] . "',0,'" . $companyInfo['transaction_type'] . "','" . $companyInfo['how_about_us'] . "',NOW(),'" . $companyInfo['phonenumber'] . "','" . $companyInfo['contact_phone'] . "','" . $companyInfo['cd_contact_im'] . "','" . $companyInfo['en_gateway_ID'] . "','" . $companyInfo['url1'] . "','" . $companyInfo['cd_timezone'] . "')";
$show_sql = sql_query_write($qry_insert_user) or dieLog(mysql_error() . " ~ {$str_qry}");
$is_success = 0;
$user_id = mysql_insert_id();
$user_reference_num = func_User_Ref_No($user_id);
$is_success = func_update_single_field('cs_companydetails', 'ReferenceNumber', $user_reference_num, false, 'userId', $user_id);
$sql = "Insert into cs_entities\r\n\t\t\tset \r\n\t\t\t\ten_username = '******'en_username'] . "',\r\n\t\t\t\ten_password = MD5('" . ($companyInfo['en_username'] . $companyInfo['en_password']) . "'),\r\n\t\t\t\ten_ref = '" . $companyInfo['en_ref'] . "',\r\n\t\t\t\ten_email = '" . $companyInfo['en_email'] . "',\r\n\t\t\t\ten_company = '" . $companyInfo['en_company'] . "',\r\n\t\t\t\ten_gateway_ID = '" . $companyInfo['en_gateway_ID'] . "',\r\n\t\t\t\ten_signup = NOW(),\r\n\t\t\t\ten_type = 'merchant',\r\n\t\t\t\ten_type_id = '" . quote_smart($user_id) . "'\r\n\t\t\t";
sql_query_write($sql) or dieLog(mysql_error() . " ~ {$str_qry}");
$en_ID = mysql_insert_id();
$returnInfo['en_ID'] = $en_ID;
$sql = "insert into cs_company_banks set cb_en_ID = '{$en_ID}',bank_id=0;";
$result = sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}");
$cb_ID = mysql_insert_id();
if ($companyInfo['etel_reseller_ref']) {
$sql = "SELECT \r\n\t\t\t\ten_ID,en_info from cs_entities where\r\n\t\t\t\ten_ref = '" . $companyInfo['etel_reseller_ref'] . "'";
$result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}");
$resellerInfo = mysql_fetch_assoc($result);
$resellerInfo['en_info'] = etel_unserialize($resellerInfo['en_info']);
$returnInfo['ea_affiliate_ID'] = $resellerInfo['en_ID'];
set_affiliate($en_ID, $resellerInfo['en_ID'], 'Reseller', array('Disc_Markup' => $resellerInfo['en_info']['Reseller']['Default_Disc_Markup'], 'Trans_Markup' => $resellerInfo['en_info']['Reseller']['Default_Trans_Markup']));
}
if ($companyInfo['etel_affiliate_ref']) {
$sql = "SELECT \r\n\t\t\t\ten_ID from cs_entities where\r\n\t\t\t\ten_ref = '" . $companyInfo['etel_affiliate_ref'] . "'";
$result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}");
$affiliateMerchantInfo = mysql_fetch_assoc($result);
set_affiliate($affiliateMerchantInfo['en_ID'], $en_ID, 'Affiliate', array('Disc_Markup' => $companyInfo['discount_markup'], 'Trans_Markup' => $companyInfo['transaction_markup']));
}
if ($sendmail || $getmail) {
$emailData["email"] = $companyInfo['en_email'];
$emailData["full_name"] = "Merchant";
$emailData["companyname"] = $companyInfo['en_company'];
$emailData["username"] = $companyInfo['en_username'];
$emailData["password"] = $companyInfo['en_password'];
$emailData["Reference_ID"] = $companyInfo['en_ref'];
$emailData["gateway_select"] = $companyInfo['en_gateway_ID'];
$emailData['tmpl_custom_id'] = $companyInfo['en_gateway_ID'];
$letterTempate = 'merchant_welcome_letter';
}
if ($sendmail) {
send_email_template($letterTempate, $emailData);
}
if ($getmail) {
$returnInfo['email_info'] = get_email_template($letterTempate, $emailData);
}
return $returnInfo;
}
<?php
include "includes/sessioncheck.php";
$headerInclude = "startHere";
include "includes/header.php";
$str_ResellerId = isset($HTTP_SESSION_VARS["sessionReseller"]) ? trim($HTTP_SESSION_VARS["sessionReseller"]) : "";
if ($resellerInfo['rd_completion'] == 3) {
func_update_single_field('cs_resellerdetails', 'rd_completion', 4, NULL, 'reseller_id', $resellerInfo['reseller_id'], $cnn_cs);
}
?>
<table border="0" cellpadding="0" cellspacing="0" width="100%" height="60%">
<tr>
<td width="100%" valign="top" align="center"><br> </td>
</tr>
</table>
<?php
include "includes/footer.php";
?>
$icount = isset($HTTP_POST_VARS["hid_totalcount"]) ? $HTTP_POST_VARS["hid_totalcount"] : "";
for ($iloop = 1; $iloop <= $icount; $iloop++) {
//echo "approval$iloop";
$str_approvalstatus = isset($HTTP_POST_VARS['approval' . $iloop]) ? quote_smart($HTTP_POST_VARS['approval' . $iloop]) : "";
if ($str_approvalstatus != "") {
$str_invoiceid = isset($HTTP_POST_VARS['hid_invoiceid' . $iloop]) ? quote_smart($HTTP_POST_VARS['hid_invoiceid' . $iloop]) : "";
//echo $str_invoiceid."yy";
$qry_update = "select adminApproved from cs_invoicedetails where invoiceId='{$str_invoiceid}'";
if (!($rst_approved = mysql_query($qry_update, $cnn_cs))) {
dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
}
$str_approved = $rst_approved[0];
if ($str_approved != $str_approvalstatus) {
func_update_single_field('cs_invoicedetails', 'adminApproved', $str_approvalstatus, 'invoiceId', $str_invoiceid, $cnn_cs);
$approvedstatusdate = func_get_current_date_time();
func_update_single_field('cs_invoicedetails', 'approveddate', $approvedstatusdate, 'invoiceId', $str_invoiceid, $cnn_cs);
}
}
}
?>
<html>
<body onLoad="document.updating.submit()">
<form name="updating" action="viewdetails.php" method="POST">
<input type='hidden' name='cbo_from_month' value='<?php
echo $imonth;
?>
'>
<input type='hidden' name='cbo_from_year' value='<?php
echo $iyear;
?>
'>
