require_once "includes/dbconnection.php";
include 'includes/function2.php';
require_once 'includes/function.php';
$no_fields = 0;
$qry_empty_reference = "SELECT userId,ReferenceNumber FROM cs_companydetails ";
$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);
$userid = $resultSet['userId'];
$user_reference_number = $resultSet['ReferenceNumber'];
if ($user_reference_number == "") {
//echo($transaction_no."<BR>");
$a = $a + 1;
$ref_num = func_User_Ref_No($userid);
$updateSuccess = func_update_single_field('cs_companydetails', 'ReferenceNumber', $ref_num, 'userId', $userid, $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";
}
} elseif ($user_companyexist == 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 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.";
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;
}
