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; }