$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; ?> '>