File: /var/www/grapossconnect/franchise-admin/create-center.php
<?php
require('include/header.php');
require('include/sidebar.php');
$TT_STATES_TABLE = 'grp_states';
$getAgentCode = $wpdb->get_row("SELECT `agent_code` FROM `grp_agents` ORDER BY agent_id DESC LIMIT 1");
if ($getAgentCode->agent_code != '') {
$lastCode = $getAgentCode->agent_code;
$lastNumber = intval(substr($lastCode, -6));
$nextNumber = $lastNumber + 1;
$nextCode = 'GRPS-' . str_pad($nextNumber, 6, '0', STR_PAD_LEFT);
} else {
$lastNumber = 0;
}
//random password
function generateRandomPassword($minLength = 6, $maxLength = 10)
{
$characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
$passwordLength = rand($minLength, $maxLength);
$password = '';
for ($i = 0; $i < $passwordLength; $i++) {
$password .= $characters[rand(0, strlen($characters) - 1)];
}
return $password;
}
$password = generateRandomPassword();
//state
$states = $wpdb->get_results("SELECT state_id, state_name FROM $TT_STATES_TABLE ORDER BY state_name ASC ");
//insert
$curDate = date('Y-m-d H:i:s');
$status = '';
if (isset($_POST['btnsave'])) {
$agentcode = $_REQUEST['agentcode'];
$agentpassword = md5($_REQUEST['agentpassword']);
$name = $_REQUEST['name'];
$email = $_REQUEST['email'];
$centername = $_REQUEST['centername'];
$mobileno = $_REQUEST['mobileno'];
$dob = $_REQUEST['dob'];
$cmbState = $_REQUEST['cmbState'];
$cmbCity = $_REQUEST['cmbCity'];
$pincode = $_REQUEST['pincode'];
$address = $_REQUEST['address'];
$landmark = $_REQUEST['landmark'];
$bankname = $_REQUEST['bankname'];
$accountholder = $_REQUEST['accountholder'];
$accountno = $_REQUEST['accountno'];
$ifsccode = $_REQUEST['ifsccode'];
$accountype = $_REQUEST['accountype'];
$pancard = $_REQUEST['pancard'];
$gstno = $_REQUEST['gstno'];
// Check if email or mobile number already exists
$emailExists = $wpdb->get_var("SELECT COUNT(*) FROM `grp_agents` WHERE `email`='$email'");
$mobileExists = $wpdb->get_var("SELECT COUNT(*) FROM `grp_agents` WHERE `mobile`='$mobileno'");
if ($emailExists > 0) {
$message = 'Email already in use';
$status = 2;
} elseif ($mobileExists > 0) {
$message = 'Mobile number already in use';
$status = 2;
} else {
// Insert new user into the database
$insertSql = "INSERT INTO `grp_agents` SET `agent_code`='$agentcode',`mf_id`='$loginID',`password`='$agentpassword',`name`='$name',`institute_name`='$centername',`email`='$email',`mobile`='$mobileno',`dob`='$dob',`state_id`='$cmbState',`city_id`='$cmbCity',`pincode`='$pincode',`address`='$address',`landmark`='$landmark',`active`='A',`login_allowed`='1',`txn_allowed`='1', `created_by`='$loginID',`creation_date`='$curDate'";
if ($wpdb->query($insertSql)) {
$lastID = $wpdb->insert_id;
$runSql = $wpdb->query("INSERT INTO `grp_agents_bank_details` SET `agent_id`='$lastID',`bank_name`='$bankname',`account_holder`='$accountholder',`account_no`='$accountno',`account_type`='$accountype',`ifsc_code`='$ifsccode',`pan_no`='$pancard',`pan_type`='P',`gstin`='$gstno',`status`='1',`add_date`='$curDate'");
$message = 'New Agent registered Successfully';
$status = 1;
echo "<meta http-equiv='refresh' content='5'>";
} else {
$message = 'Agent registration failed';
$status = 2;
}
}
}
//update bank
?>
<div id="content" class="app-content">
<div class="d-flex align-items-center mb-3">
<div>
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="dashboard.php">Home</a></li>
<li class="breadcrumb-item"><a href="javascript:;">Center</a></li>
<li class="breadcrumb-item active"><i class="fa fa-arrow-back"></i>Create New Center</li>
</ol>
<h1 class="page-header mb-0">Create New Center</h1>
</div>
</div>
<div class="row">
<div class="col-lg-12">
<form method="POST" onsubmit="return validatecenterForm()">
<div class="card border-0 mb-4">
<?php if ($status == 1) { ?>
<div class="alert alert-success" role="alert"><?php echo $message; ?></div>
<?php } else if ($status == 2) { ?>
<div class="alert alert-danger" role="alert"><?php echo $message; ?></div>
<?php } ?>
<!-- login -->
<div class="card-header h6 mb-0 bg-grey p-3">
<i class="fa fa-key fa-lg fa-fw text-dark text-opacity-50 me-1"></i> Login Detail
</div>
<div class="card-body">
<div class="row">
<div class="col-6">
<div class="mb-3">
<label class="form-label">Agent Code<span class="text-danger">*</span></label>
<input type="text" class="form-control" id="agentcode" name="agentcode" value="<?php echo $nextCode; ?>" readonly>
</div>
</div>
<div class="col-6">
<div class="mb-3">
<label class="form-label">Agent Password<span class="text-danger">*</span></label>
<input type="text" class="form-control" id="agentpassword" name="agentpassword" value="<?php echo $password; ?>">
</div>
</div>
</div>
</div>
<!-- personal detail -->
<div class="card-header h6 mb-0 bg-grey p-3">
<i class="fa fa-user fa-lg fa-fw text-dark text-opacity-50 me-1"></i> Personal Detail
</div>
<div class="card-body">
<div class="row">
<div class="col-6">
<div class="mb-3">
<label class="form-label">Name<span class="text-danger">*</span></label>
<input type="text" class="form-control" id="name" name="name" placeholder="Center Name">
</div>
</div>
<div class="col-6">
<div class="mb-3">
<label class="form-label">Email address<span class="text-danger">*</span></label>
<input type="text" class="form-control" id="Email" name="email" placeholder="Enter email">
</div>
</div>
<div class="col-12">
<div class="mb-3">
<label class="form-label">Center Name</label>
<input type="text" class="form-control" id="Center" name="centername" placeholder="Enter Center Name">
</div>
</div>
<div class="col-6">
<div class="mb-3">
<label class="form-label">Mobile No<span class="text-danger">*</span></label>
<input type="text" name="mobileno" class="form-control" id="mobile" placeholder="Enter Mobile No">
</div>
</div>
<div class="col-6">
<div class="mb-3">
<label class="form-label">Date of Birth<span class="text-danger">*</span></label>
<input type="date" class="form-control" id="dob" name="dob" placeholder="Enter Date of Birth">
</div>
</div>
<div class="col-4">
<div class="mb-3">
<label class="form-label">State<span class="text-danger">*</span></label>
<select name="cmbState" id="cmbState" class="form-control">
<option value="0">-- State --</option>
<?php foreach ($states as $st) { ?>
<option value="<?php echo $st->state_id; ?>"><?php echo $st->state_name; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-4">
<div class="mb-3">
<label class="form-label">City<span class="text-danger">*</span></label>
<select name="cmbCity" id="cmbCity" class="form-control">
<option value="0">-- City --</option>
</select>
</div>
</div>
<div class="col-4">
<div class="mb-3">
<label class="form-label">Pincode<span class="text-danger">*</span></label>
<input type="text" class="form-control" id="pincode" name="pincode" placeholder="Enter Pincode">
</div>
</div>
<div class="col-12">
<div class="mb-3">
<label class="form-label">Address</label>
<input type="text" class="form-control" id="address" name="address" placeholder="Enter Address">
</div>
</div>
<div class="col-12">
<div class="mb-3">
<label class="form-label">Landmark</label>
<input type="text" class="form-control" id="Landmark" name="landmark" placeholder="Enter Landmark">
</div>
</div>
</div>
</div>
<!-- Banking detail -->
<div class="card-header h6 mb-0 bg-grey p-3">
<i class="fa fa-list fa-lg fa-fw text-dark text-opacity-50 me-1"></i> Banking Detail
</div>
<div class="card-body">
<div class="row">
<div class="col-6">
<div class="mb-3">
<label class="form-label">Bank Name<span class="text-danger">*</span></label>
<input type="text" class="form-control" id="bankname" name="bankname" placeholder="Bank Name">
</div>
</div>
<div class="col-6">
<div class="mb-3">
<label class="form-label">Account Holder Name<span class="text-danger">*</span></label>
<input type="text" class="form-control" id="accountholder" name="accountholder" placeholder="Enter Account Holder Name">
</div>
</div>
<div class="col-6">
<div class="mb-3">
<label class="form-label">Account Number<span class="text-danger">*</span></label>
<input type="text" class="form-control" id="accountno" name="accountno" placeholder="Enter Account Number">
</div>
</div>
<div class="col-xl-4">
<div class="mb-3">
<label class="form-label">IFSC CODE<span class="text-danger">*</span></label>
<input type="text" class="form-control ifsccodecapital" id="ifsccode" name="ifsccode" placeholder="EX - SBIN001XXXX">
</div>
</div>
<div class="col-xl-2">
<div class="mb-3">
<label class="form-label">Account Type<span class="text-danger">*</span></label>
<select class="form-control" id="accountype" name="accountype">
<option value="0">Select Account Type</option>
<option value="S">Saving</option>
<option value="C">Current</option>
</select>
</div>
</div>
<div class="col-6">
<div class="mb-3">
<label class="form-label">Enter Pan Number<span class="text-danger">*</span></label>
<input type="text" class="form-control pancapital" id="pancard" name="pancard" placeholder="EX - ABCTY1234D">
</div>
</div>
<div class="col-6">
<div class="mb-3">
<label class="form-label">GST Number</label>
<input type="text" class="form-control" id="gstnumber" name="gstno" placeholder="EX - 07XXXXX2194N1Z1">
</div>
</div>
</div>
</div>
<div class="card-footer bg-none d-flex p-3">
<button type="submit" name="btnsave" class="btn btn-primary"><i class="fas fa-check"></i> CLICK TO CREATE NEW CENTER </button>
<a href="#" class="btn btn-danger ms-2">CANCEL</a>
</div>
</div>
</form>
</div>
</div>
</div>
<?php require('include/footer-data.php'); ?>
<script src="validatecenterform.js"></script>
<script>
// state
jQuery("#cmbState").change(function() {
var state = $(this).val();
if (state == '0') {
toastr.error("Select state", {
"timeOut": "0",
"extendedTImeout": "0"
});
jQuery('#cmbState').focus();
return false;
} else {
state = state.replace(/ /g, '%20');
$("#cmbCity").load("../center-admin/api/get_city.php?state=" + state);
}
});
//auto alphabet
jQuery('.ifsccodecapital').keyup(function() {
$(this).val($(this).val().toUpperCase());
});
jQuery('.pancapital').keyup(function() {
$(this).val($(this).val().toUpperCase());
});
</script>