File: /var/www/selfanalyse/counselor/create_sp_user.php
<?php
include_once('header.php');
include_once('../wp-config.php');
global $current_user;
get_currentuserinfo();
$adminId = $current_user->ID; // print session USER_ID
$curDateTime = date('Y-m-d H:i:s'); // add 5 hrs 30 min in
$PSY_USERS = $wpdb->prefix . PSY_USERS;
$PSY_USERS_DETAILS = $wpdb->prefix . PSY_USERS_DETAILS;
$PSY_SUBSCRIPTION = $wpdb->prefix . PSY_SUBSCRIPTION;
$PSY_PLANS = $wpdb->prefix . PSY_PLANS;
//create user
if (isset($_REQUEST['create_user'])) {
$usersp_name = $_REQUEST['usersp_name'];
$usersp_email = $_REQUEST['usersp_email'];
$usersp_phone = $_REQUEST['usersp_phone'];
$usersp_pwd = $_REQUEST['usersp_pwd'];
if (username_exists($usersp_email)) {
$msg = '<div class="alert alert-danger alert-dismissible" role="alert">This email already exist.<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
} else if (email_exists($usersp_email)) {
$msg = '<div class="alert alert-danger alert-dismissible" role="alert">This email already exist.<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
} else {
if (!filter_var($usersp_email, FILTER_VALIDATE_EMAIL)) {
$msg = '<div class="alert alert-danger alert-dismissible" role="alert">Invalid email format.<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
} else if ($usersp_name == '' || $usersp_email == '' || $usersp_phone == '' || !(is_numeric($usersp_phone)) || $usersp_pwd == '' || strlen($usersp_phone) < 10) {
$msg = '<div class="alert alert-danger alert-dismissible" role="alert">All fields are required | Phone number must be 10 digit number.<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
} else {
$user_id = wp_create_user($usersp_email, $usersp_pwd, $usersp_email);
if (is_wp_error($user_id)) {
$msg = '<div class="alert alert-danger alert-dismissible" role="alert">' . $user_id->get_error_message() . '<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
} else {
$insertQuery = $wpdb->query("INSERT into $PSY_USERS_DETAILS set gender_id='Male',first_name='$usersp_name', user_id='$user_id', mobile_number='$usersp_phone', email_address='$usersp_email', source='By Form'");
$msg = '<div class="alert alert-success alert-dismissible" role="alert">User created successfully<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
$ref_id = 3;
$get_exams = $wpdb->get_row("SELECT reference_id FROM $PSY_PLANS where plan_id='$ref_id'");
$exam_id = explode(",", $get_exams->reference_id);
foreach ($exam_id as $e_id) {
if ($e_id == '48282') {
$test_type = 'APT';
} else if ($e_id == '48305') {
$test_type = 'PER';
} else if ($e_id == '48328') {
$test_type = 'INT';
}
$insertSubscription = "INSERT into $PSY_SUBSCRIPTION set user_id='$user_id', plan_id='$ref_id', exam_id='$e_id', test_type='$test_type', purchase_date='$curDateTime', status='1', active_status='1', active_date='$curDateTime', source='By Form', source_id='0'";
if ($wpdb->query($insertSubscription)) {
echo "Plan Inserted";
}
}
}
}
}
}
?>
<div class="page-inner">
<div class="page-title">
<div class="col-md-4">
<h3> Create User</h3>
<div class="page-breadcrumb">
<ol class="breadcrumb">
<li><a href="dashboard">Home</a></li>
<li class="active">Create User</li>
</ol>
</div>
</div>
<div class="col-md-8">
<div class="navbar-right">
<ul class="navul">
<!--<li><a href="apt-class">Class List</a></li>-->
</ul>
</div>
</div>
</div>
<div id="main-wrapper">
<div class="row">
<div class="col-md-12">
<div class="panel panel-primary">
<div class="panel-heading clearfix">
<h4 class="panel-title">Create User</h4>
</div>
</div>
</div>
<div class="col-md-12">
<div class="panel">
<div class="panel-body">
<span id="alert1" style="display: block;"><?php if (isset($msg)) {
echo $msg;
} ?></span>
<form id="frmaddQues" method="post" action="" onsubmit="return validateForm();">
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Name:</label>
<div class="col-sm-5">
<input type="text" name="usersp_name" id="usersp_name" class="form-control" placeholder="Enter name.." value="<?php echo @$usersp_name ?>" id="cat_name">
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Email:</label>
<div class="col-sm-5">
<input type="email" name="usersp_email" id="usersp_email" class="form-control" placeholder="Enter email" value="<?php echo @$usersp_email ?>">
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Phone:</label>
<div class="col-sm-5">
<input type="tel" name="usersp_phone" id="usersp_phone" class="form-control" placeholder="Enter Phone" value="<?php echo @$usersp_phone ?>">
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Password:</label>
<div class="col-sm-5">
<input type="text" name="usersp_pwd" id="usersp_pwd" class="form-control" placeholder="Enter password" value="<?php echo @$usersp_pwd ?>">
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label"> </label>
<div class="col-sm-5">
<button type="submit" name="create_user" class="btn btn-primary btn-rounded">Create</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<!-- Main Wrapper -->
<div class="page-footer">
<p class="no-s">shinemetrics.com</p>
</div>
</div>
<script>
//validate email
function validateEmail($email) {
var emailReg = /^([\w-\.]+@([\w-]+\.)+[\w-]{2,4})?$/;
if (!emailReg.test($email)) {
return false;
} else {
return true;
}
}
//validate mobile number
function validateMobile($mobile) {
var mobilePat = /^\d{10}$/;
if (!mobilePat.test($mobile)) {
return false;
} else {
return true;
}
}
function validateForm() {
var pwdLeng = jQuery('#usersp_pwd').val();
if (jQuery("#usersp_name").val() == '') {
jQuery("#alert1").html('<div class="alert alert-danger alert-dismissible" role="alert">Name is required*<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>');
return false;
}
if (jQuery('#usersp_email').val() == '') {
jQuery("#alert1").html('<div class="alert alert-danger alert-dismissible" role="alert">Email is required*<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>');
return false;
}
if (!validateEmail(jQuery('#usersp_email').val())) {
jQuery("#alert1").html('<div class="alert alert-danger alert-dismissible" role="alert">Email is not valid*<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>');
return false;
}
if (jQuery('#usersp_phone').val() == '') {
jQuery("#alert1").html('<div class="alert alert-danger alert-dismissible" role="alert">Mobile number is required*<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>');
return false;
}
if (!validateMobile(jQuery('#usersp_phone').val())) {
jQuery("#alert1").html('<div class="alert alert-danger alert-dismissible" role="alert">Mobile number is not valid*<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>');
return false;
}
if (jQuery('#usersp_pwd').val() == '' || (pwdLeng.length <= 6)) {
jQuery("#alert1").html('<div class="alert alert-danger alert-dismissible" role="alert">Password required and must be greater then 6 string*<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>');
return false;
}
return true;
}
</script>
<?php
include_once('footer.php');
?>