File: /var/www/html/shootinschool/wp-content/plugins/shootin-school-plugin/customer_credits.php
<?php
function render_siab_customer_credits(){
global $wpdb;
$user_id = $_GET['id'];
$query = "SELECT * FROM " . DB_WC_GF_CUSTOMER_PURCHASES . " WHERE customer_id = $user_id ORDER BY id ASC";
$purchases = $wpdb->get_results($query, ARRAY_A);
if(!isset($_GET['filter'])){
foreach ($purchases as $key => $purchase) {
# code...
// strtotime("+4 months", strtotime($purchase['created_at'])) > strtotime(date(Y-m-d));
if(($purchase['package_hidden_name'] != 'unlimited'
&& ($purchase['credits'] <= 0) || $purchase['is_cancelled'] == 1 )
){
unset($purchases[$key]);
}
}
}
$query = "SELECT display_name FROM " . DB_USERS . " WHERE ID = $user_id";
$user = $wpdb->get_row($query, ARRAY_A);
?>
<div class="wrap">
<div class="alert alert-info" role="alert" style="border: 1px solid green;border-radius: 5px;">
<h3> Purchase Details </h3>
<a class="add-new-h2" href="admin.php?page=siab-customers">Back to Customers</a>
</div>
<h3>Purchases of <?php echo $user['display_name']?></h3>
<style type="text/css">
.card-wrap .card{
display: inline-block;
margin-right: 8px;
margin-bottom: 8px;
box-shadow: 2px 2px 5px 0px rgba(0, 0, 0, 0.1);
padding: 0px;
}
.card-wrap .card .card-title{
padding: 0.8em 1.2em;
font-weight: 600;
border-bottom: 1px solid #eeeeee;
margin: 0;
word-break: break-all;
}
.card-wrap .card .card-text{
margin-bottom: 4px;
}
.card-wrap .card .card-body{
padding: 0.7em 1.2em;
}
.card-wrap .card button{
margin-top: 8px;
}
</style>
<div class="card-wrap">
<script type="text/javascript">
function ShowHideDiv() {
var url = window.location.href;
if (url.indexOf('?') > -1){
url += '&filter=1'
}else{
url += '?filter=1'
}
window.location.href = url;
}
</script>
<script type="text/javascript">
function removeParam(key, sourceURL) {
var rtn = sourceURL.split("?")[0],
param,
params_arr = [],
queryString = (sourceURL.indexOf("?") !== -1) ? sourceURL.split("?")[1] : "";
if (queryString !== "") {
params_arr = queryString.split("&");
for (var i = params_arr.length - 1; i >= 0; i -= 1) {
param = params_arr[i].split("=")[0];
if (param === key) {
params_arr.splice(i, 1);
}
}
if (params_arr.length) rtn = rtn + "?" + params_arr.join("&");
}
return rtn;
}
function ShowHideDiv1() {
var url = window.location.href;
url = removeParam("filter", url);
window.location.href = url;
}
</script>
<?php if(!isset($_GET['filter'])){ ?>
<label for="chkPassport">
<input type="checkbox" id="chkPassport" onclick="ShowHideDiv()" />
Show Cancelled Packages
</label>
<?php }else{ ?>
<label for="chkPassport">
<input type="checkbox" checked="checked" id="chkPassport" onclick="ShowHideDiv1()" />
Show Cancelled Packages
</label>
<?php } ?>
<br>
<?php
foreach ($purchases as $purchase) {
?>
<div class="card" style="width: 18rem;">
<h5 class="card-title">
Order ID : <?php echo $purchase['order_id']; ?>
</h5>
<div class="card-body">
<?php if ($purchase['is_unlimited_type']) {
?>
<p class="card-text">
Package type : <?php echo ucfirst($purchase['package_hidden_name']) ?>
</p>
<p class="card-text">
Expiry : <?php echo date('l, F d Y', strtotime("+4 months", strtotime($purchase['created_at'])))?>
</p>
<?php
} else { ?>
<p class="card-text">
Package type : <?php echo ucfirst($purchase['package_hidden_name']) ?>
</p>
<p class="card-text">
Credits Remaining : <?php echo $purchase['credits']; ?>
</p>
<button class="btn btn-primary btn-xs" value="<?php echo $purchase['credits'] ?>" onclick="editModal(this,'<?php echo $purchase['id']; ?>')" data-toggle="modal" data-target="#editCreditsModal">Update Credits</button>
<?php
} ?>
</div>
</div>
<?php
}
?>
</div>
<!-- Edit Modal start-->
<div id="editCreditsModal" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Update User Credits</h4>
</div>
<div class="modal-body">
<p><input id="creditNumber" min="0" type="number" value="0"></p>
</div>
<div class="modal-footer">
<button type="button" id="updateCredit" onclick="updateCredit(this)" class="btn btn-primary" data-dismiss="modal">Update</button>
<button type="button" class="btn btn-info" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<!-- Edit Modal End-->
<?php
}
function render_siab_customer_children(){
global $wpdb;
$user_id = $_GET['id'];
$query = "SELECT * FROM " . DB_CHILD_DETAILS . " as child WHERE child.user_id = $user_id ORDER BY id ASC";
$children = $wpdb->get_results($query, ARRAY_A);
$query = "SELECT display_name FROM " . DB_USERS . " WHERE ID = $user_id";
$user = $wpdb->get_row($query, ARRAY_A);
?>
<div class="wrap">
<div class="alert alert-info" role="alert" style="border: 1px solid green;border-radius: 5px;">
<h3> Manage Children </h3>
<a class="add-new-h2" href="#" onclick="openAddChildModal(<?php echo $user_id; ?>)">Add new children</a>
<a class="add-new-h2" href="admin.php?page=siab-customers">Back to Customers</a>
</div>
<h3>Players of <?php echo $user['display_name']?></h3>
<style type="text/css">
.card-wrap .card{
display: inline-block;
margin-right: 8px;
margin-bottom: 8px;
box-shadow: 2px 2px 5px 0px rgba(0, 0, 0, 0.1);
padding: 0px;
}
.card-wrap .card .card-title{
padding: 0.8em 1.2em;
font-weight: 600;
border-bottom: 1px solid #eeeeee;
margin: 0;
word-break: break-all;
}
.card-wrap .card .card-text{
margin-bottom: 4px;
}
.card-wrap .card .card-body{
padding: 0.7em 1.2em;
}
.card-wrap .card button{
margin-top: 8px;
}
</style>
<div class="card-wrap">
<?php
foreach ($children as $child) {
?>
<div class="card" style="width: 18rem;">
<h5 class="card-title">
Player Name : <?php echo $child['first_name']." ".$child['last_name']; ?>
<?php
$child_id = $child['id'];
$pendingMsgChecks = $wpdb->get_var("SELECT COUNT(*) FROM " . DB_FORUM . " WHERE playerID = $child_id AND (userType = 2 OR userType = 3) AND staus = 0");
if($pendingMsgChecks > 0){
echo "<img src='https://shootinschool.spericorn.com/wp-content/plugins/shootin-school-plugin/custom/img/new.gif' alt='' style='width: 15px; height: 15px;'>";
}
?>
</h5>
<div class="card-body">
<p class="card-text">
Grade : <?php echo ucfirst($child['grade']) ?>
</p>
<p class="card-text">
Jersy size : <?php echo $child['jersey_size']; ?>
</p>
<button class="btn btn-primary btn-xs" value="<?php echo $child['id'] ?>" onclick="editChildModal('<?php echo $child['id']; ?>')" >Edit</button>
<button class="btn btn-danger btn-xs" value="<?php echo $child['id'] ?>" onclick="deleteChildModal('<?php echo $child['id']; ?>')" >Delete</button>
<a style="margin-top: 8px;" class="btn btn-success btn-xs" href="admin.php?page=siab-player-forum&id=<?php echo $child['id']; ?>" >Comments </a>
</div>
</div>
<?php
}
?>
</div>
<!-- Edit Child Modal start-->
<div id="editChildModal" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Update Player Information</h4>
</div>
<form action="#" method="post" id="ChildForm">
<div class="modal-body" id="ChildBody">
<!-- Append here -->
</div>
</form>
<div class="modal-footer">
<button type="button" id="updateChildBtn" onclick="updateChild()" class="btn btn-primary" data-dismiss="modal">Update</button>
<button type="button" class="btn btn-info" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<div id="deleteChildModal" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Delete Child</h4>
</div>
<div class="modal-body">
Are you sure you want to delete this Child?
</div>
<div class="modal-footer">
<button type="button" id="deleteChildBtn" value="-1" onclick="deleteChild()" class="btn btn-primary" >Yes</button>
<button type="button" class="btn btn-info" data-dismiss="modal">No</button>
</div>
</div>
</div>
</div>
<div id="addNewChildAdminModal" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Add a new children</h4>
</div>
<form action="#" method="post" id="ChildFormAdmin">
<div class="modal-body" id="ChildBodyAdmin">
<!-- Append here -->
</div>
</form>
<div class="modal-footer">
<button type="button" id="addChildSubmitBtn" onclick="addChildAdmin()" class="btn btn-primary">Save</button>
<button type="button" class="btn btn-info" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<!-- Edit Modal End-->
<?php
}
add_action('wp_ajax_nopriv_render_child_info', 'render_child_info');
add_action('wp_ajax_render_child_info', 'render_child_info');
function render_child_info(){
global $wpdb;
$id = $_POST['id'];
$query = "SELECT * FROM " . DB_CHILD_DETAILS . " WHERE id = ".$id;
$user = $wpdb->get_row($query, ARRAY_A);
// var_dump($user);
// exit();
if(count($user)>0){
ob_start();
?>
<div class="form-group">
<label for="">First Name</label>
<input type="text" class="form-control" name="first_name" value="<?php echo $user['first_name']; ?>" />
</div>
<div class="form-group">
<label for="">Last Name</label>
<input type="text" class="form-control" name="last_name" value="<?php echo $user['last_name']; ?>" />
</div>
<div class="form-group">
<label for="">Date of Birth</label>
<input type="text" class="form-control date_sel" name="child_dob" id="child_dob" value="<?php echo $user['child_dob']; ?>" >
</div>
<div class="form-group">
<label for="">Grade</label>
<select class="form-control" id="grade" name="grade">
<option value="2nd" <?php echo $user['grade'] == "2nd"?'selected':""; ?>>2nd</option>
<option value="3rd" <?php echo $user['grade'] == "3rd"?'selected':""; ?>>3rd</option>
<option value="4th" <?php echo $user['grade'] == "4th"?'selected':""; ?>>4th</option>
<option value="5th" <?php echo $user['grade'] == "5th"?'selected':""; ?>>5th</option>
<option value="6th" <?php echo $user['grade'] == "6th"?'selected':""; ?>>6th</option>
<option value="7th" <?php echo $user['grade'] == "7th"?'selected':""; ?>>7th</option>
<option value="8th" <?php echo $user['grade'] == "8th"?'selected':""; ?>>8th</option>
<option value="High School" <?php echo $user['grade'] == "High School"?'selected':""; ?>>High School</option>
<option value="College" <?php echo $user['grade'] == "College"?'selected':""; ?>>College</option>
<option value="Professional" <?php echo $user['grade'] == "Professional"?'selected':""; ?>>Professional</option>
</select>
</div>
<div class="form-group">
<label for="">Jersey size</label>
<select class="form-control" id="jersey_size" name="jersey_size">
<option value="Youth Small" <?php echo $user['jersey_size'] == "Youth Small"?'selected':""; ?>>Youth Small</option>
<option value="Youth Medium" <?php echo $user['jersey_size'] == "Youth Medium"?'selected':""; ?>>Youth Medium</option>
<option value="Youth Large" <?php echo $user['jersey_size'] == "Youth Large"?'selected':""; ?>>Youth Large</option>
<option value="Youth Extra Large" <?php echo $user['jersey_size'] == "Youth Extra Large"?'selected':""; ?>>Youth Extra Large</option>
<option value="Adult Small" <?php echo $user['jersey_size'] == "Adult Small"?'selected':""; ?>>Adult Small</option>
<option value="Adult Medium" <?php echo $user['jersey_size'] == "Adult Medium"?'selected':""; ?>>Adult Medium</option>
<option value="Adult Large" <?php echo $user['jersey_size'] == "Adult Large"?'selected':""; ?>>Adult Large</option>
<option value="Adult Extra Large" <?php echo $user['jersey_size'] == "Adult Extra Large"?'selected':""; ?>>Adult Extra Large</option>
</select>
</div>
<input type="hidden" name="id" value="<?php echo $id; ?>">
<script type="text/javascript">
var currentYear = new Date().getFullYear();
jQuery(".date_sel").datepicker({
changeMonth: true,
changeYear: true,
// minDate: new Date(),
maxDate: new Date(), // December 31 of the current year
yearRange: (currentYear - 100) + ":" + currentYear,
dateFormat: "yy-m-dd",
firstDay: 1
});
// getDatePicker([]);
</script>
<?php
$renderedHtml = ob_get_clean();
echo json_encode(['status'=>true,'renderedHtml'=> $renderedHtml,'message'=>'Fetch success']);
die();
}else{
echo json_encode(['status'=>false,'renderedHtml'=> '','message'=>'Failed to get player details']);
die();
}
}
add_action('wp_ajax_nopriv_update_child_info', 'update_child_info');
add_action('wp_ajax_update_child_info', 'update_child_info');
function update_child_info(){
global $wpdb;
parse_str($_POST['data'],$input);
if ($wpdb->update(DB_CHILD_DETAILS,
array(
'first_name' => $input['first_name'],
'last_name' => $input['last_name'],
'grade' => $input['grade'],
'jersey_size' => $input['jersey_size'],
'child_dob' => $input['child_dob'],
), array('id' => $input['id']))) {
$status = array('status' => TRUE);
} else {
$status = array('status' => FALSE);
}
echo json_encode($status);
die();
}
add_action('wp_ajax_nopriv_update_credits', 'update_credits');
add_action('wp_ajax_update_credits', 'update_credits');
function update_credits()
{
global $wpdb;
$id = $_POST['id'];
$credit = $_POST['credit'];
if ($wpdb->update(DB_WC_GF_CUSTOMER_PURCHASES, array('credits' => $credit), array('id' => $id))) {
$status = array('status' => TRUE);
} else {
$status = array('status' => FALSE);
}
echo json_encode($status);
die();
}
add_action('wp_ajax_manual_assign_package', 'manual_assign_package');
function manual_assign_package(){
global $wpdb;
$args = array(
'role' => 'customer',
'orderby' => 'ID',
'order' => 'DESC'
);
$users = get_users( $args );
$form_id = "";
$cus_id = "";
if(isset($_GET['pid']) && $_GET['pid'] && isset($_GET['cus_id']) && $_GET['cus_id']){
$form_id = $_GET['pid'];
$cus_id = $_GET['cus_id'];
}
?>
<!-- ------------------for chosen dropdown start------------------------- -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/chosen/1.4.2/chosen.jquery.js"></script>
<!-- <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/chosen/1.4.2/chosen.css"> -->
<style>
#sel_package {
position: relative;
display: inline-block;
vertical-align: middle;
font-size: 13px;
zoom: 1;
*display: inline;
-webkit-user-select: none;
-moz-user-select: none;
user-select: none;
}
/* @group Base */
.chosen-container {
position: relative;
display: inline-block;
vertical-align: middle;
font-size: 13px;
zoom: 1;
*display: inline;
-webkit-user-select: none;
-moz-user-select: none;
user-select: none;
}
.chosen-container * {
-webkit-box-sizing: border-box;
-moz-box-sizing: border-box;
box-sizing: border-box;
}
.chosen-container .chosen-drop {
position: absolute;
top: 100%;
left: -9999px;
z-index: 1010;
width: 100%;
border: 1px solid #aaa;
border-top: 0;
background: #fff;
box-shadow: 0 4px 5px rgba(0, 0, 0, 0.15);
}
.chosen-container.chosen-with-drop .chosen-drop {
left: 0;
}
.chosen-container a {
cursor: pointer;
}
.chosen-container .search-choice .group-name, .chosen-container .chosen-single .group-name {
margin-right: 4px;
overflow: hidden;
white-space: nowrap;
text-overflow: ellipsis;
font-weight: normal;
color: #999999;
}
.chosen-container .search-choice .group-name:after, .chosen-container .chosen-single .group-name:after {
content: ":";
padding-left: 2px;
vertical-align: top;
}
/* @end */
/* @group Single Chosen */
.chosen-container-single .chosen-single {
position: relative;
display: block;
overflow: hidden;
padding: 0 0 0 8px;
height: 25px;
border: 1px solid #aaa;
background-color: #fff;
color: #444;
text-decoration: none;
white-space: nowrap;
line-height: 24px;
}
.chosen-container-single .chosen-default {
color: #999;
}
.chosen-container-single .chosen-single span {
display: block;
overflow: hidden;
margin-right: 26px;
text-overflow: ellipsis;
white-space: nowrap;
}
.chosen-container-single .chosen-single-with-deselect span {
margin-right: 38px;
}
.chosen-container-single .chosen-single abbr {
position: absolute;
top: 6px;
right: 26px;
display: block;
width: 12px;
height: 12px;
background: url('chosen-sprite.png') -42px 1px no-repeat;
font-size: 1px;
}
.chosen-container-single .chosen-single abbr:hover {
background-position: -42px -10px;
}
.chosen-container-single.chosen-disabled .chosen-single abbr:hover {
background-position: -42px -10px;
}
.chosen-container-single .chosen-single div {
position: absolute;
top: 0;
right: 0;
display: block;
width: 18px;
height: 100%;
}
.chosen-container-single .chosen-single div b {
display: block;
width: 100%;
height: 100%;
background: url('chosen-sprite.png') no-repeat 0px 2px;
}
.chosen-container-single .chosen-search {
position: relative;
z-index: 1010;
margin: 0;
padding: 3px 4px;
white-space: nowrap;
}
.chosen-container-single .chosen-search input[type="text"] {
margin: 1px 0;
padding: 4px 20px 4px 5px;
width: 100%;
height: auto;
outline: 0;
border: 1px solid #aaa;
background: white url('chosen-sprite.png') no-repeat 100% -20px;
background: url('chosen-sprite.png') no-repeat 100% -20px;
font-size: 1em;
font-family: sans-serif;
line-height: normal;
border-radius: 0;
}
.chosen-container-single .chosen-drop {
margin-top: -1px;
border-radius: 0 0 4px 4px;
background-clip: padding-box;
}
.chosen-container-single.chosen-container-single-nosearch .chosen-search {
position: absolute;
left: -9999px;
}
/* @end */
/* @group Results */
.chosen-container .chosen-results {
color: #444;
position: relative;
overflow-x: hidden;
overflow-y: auto;
margin: 0 4px 4px 0;
padding: 0 0 0 4px;
max-height: 240px;
-webkit-overflow-scrolling: touch;
}
.chosen-container .chosen-results li {
display: none;
margin: 0;
padding: 5px 6px;
list-style: none;
line-height: 15px;
word-wrap: break-word;
-webkit-touch-callout: none;
}
.chosen-container .chosen-results li.active-result {
display: list-item;
cursor: pointer;
}
.chosen-container .chosen-results li.disabled-result {
display: list-item;
color: #ccc;
cursor: default;
}
.chosen-container .chosen-results li.highlighted {
background-color: #3875d7;
background-image: -webkit-gradient(linear, 50% 0%, 50% 100%, color-stop(20%, #3875d7), color-stop(90%, #2a62bc));
background-image: -webkit-linear-gradient(#3875d7 20%, #2a62bc 90%);
background-image: -moz-linear-gradient(#3875d7 20%, #2a62bc 90%);
background-image: -o-linear-gradient(#3875d7 20%, #2a62bc 90%);
background-image: linear-gradient(#3875d7 20%, #2a62bc 90%);
color: #fff;
}
.chosen-container .chosen-results li.no-results {
color: #777;
display: list-item;
background: #f4f4f4;
}
.chosen-container .chosen-results li.group-result {
display: list-item;
font-weight: bold;
cursor: default;
}
.chosen-container .chosen-results li.group-option {
padding-left: 15px;
}
.chosen-container .chosen-results li em {
font-style: normal;
text-decoration: underline;
}
/* @end */
/* @group Retina compatibility */
@media only screen and (-webkit-min-device-pixel-ratio: 1.5), only screen and (min-resolution: 144dpi), only screen and (min-resolution: 1.5dppx) {
.chosen-rtl .chosen-search input[type="text"],
.chosen-container-single .chosen-single abbr,
.chosen-container-single .chosen-single div b,
.chosen-container-single .chosen-search input[type="text"],
.chosen-container-multi .chosen-choices .search-choice .search-choice-close,
.chosen-container .chosen-results-scroll-down span,
.chosen-container .chosen-results-scroll-up span {
background-image: url('chosen-sprite@2x.png') !important;
background-size: 52px 37px !important;
background-repeat: no-repeat !important;
}
}
/* @end */
</style>
<script>
jQuery(document).ready(function(){
jQuery("#sel_customer").chosen();
var form_id = '<?php echo $form_id ?>';
var cust_id = '<?php echo $cus_id ?>';
jQuery("#input_"+form_id+"_10").val(form_id+"|"+cust_id);
jQuery("#gform_submit_button_"+form_id).on('change',function(){
// alert();
});
});
</script>
<!-- ------------------for chosen dropdown end------------------------- -->
<div class="wrap">
<div class="alert alert-info" role="alert" style="border: 1px solid green;border-radius: 5px;">
<h3> Assign Package Manually </h3>
<a class="add-new-h2" href="admin.php?page=siab-customers">Back to Customers</a>
</div>
<div class="row">
<div class="col-md-7">
<h4>Choose a Customer</h4>
<select name="sel_customer" id="sel_customer" >
<option value=""> -- Choose a Customer -- </option>
<?php foreach ( $users as $user ) { ?>
<option value="<?php echo $user->ID;?>" <?php echo $cus_id == $user->ID ? 'selected' : ''; ?> >
<?php echo $user->display_name; ?> : <?php echo $user->user_email; ?>
</option>
<?php } ?>
</select>
</div>
<div class="col-md-5">
<h4>Choose a Package</h4>
<select name="sel_package" id="sel_package" onchange="package_on_change(this);">
<option value=""> -- Choose a Package -- </option>
<option value="13|5" <?php echo $form_id == GF_GROUP_FORM_ID ? 'selected' : ''; ?> > Group Instruction Session</option>
<option value="15|1794" <?php echo $form_id == GF_INDIVIDUAL_FORM_ID ? 'selected' : ''; ?> > Individual Instruction Session </option>
<option value="16|1798" <?php echo $form_id == GF_UNLIMITED_FORM_ID ? 'selected' : ''; ?> > Unlimited Instruction </option>
</select>
</div>
</div>
<br/>
<div class="row">
<div class="col-md-5">
<h4>Mark Payment Status</h4>
<label class="radio-inline">
<input type='radio' name='sel_payment' class='sel_payment' value='yes' checked /> Already Paid
</label>
<label class="radio-inline">
<input type='radio' name='sel_payment' class='sel_payment' value='no' /> Intimate Payment via Check
</label>
</div>
</div>
<br/>
<?php if($form_id){ ?>
<div class="row">
<div class="col-md-5">
<h4>Fill Form Details</h4>
<div class="woocommerce_order_items_wrapper wc-order-items-editable">
<?php
echo do_shortcode('[gravityform id="'.$form_id.'" title="false" description="false" ajax="true"]');
?>
</div>
</div>
</div>
<?php } ?>
</div>
<?php }
add_action('wp_ajax_render_gf_form_manual', 'render_gf_form_manual');
function render_gf_form_manual(){
$form_id = $_POST['form_id'];
ob_start();
echo do_shortcode('[gravityform id="'.$form_id.'" title="false" description="false" ajax="true"]');
$renderedHtml = ob_get_clean();
echo json_encode(['status' => TRUE, 'renderedHtml' => $renderedHtml]);
die();
}
add_action('wp_ajax_nopriv_render_or_append_new_child_admin', 'render_or_append_new_child_admin');
add_action('wp_ajax_render_or_append_new_child_admin', 'render_or_append_new_child_admin');
function render_or_append_new_child_admin(){
global $wpdb;
$form = GFFormsModel::get_form_meta( GF_CHILD_DETAILS_FORM_ID );
$user_id = $_GET['user_id'];
$grade_options = RGFormsModel::get_field( $form, 5 );
$grade_optionsArr = array_column($grade_options->choices, 'text');
$jersey_size_options = RGFormsModel::get_field( $form, 7 );
$jersey_size_optionsArr = array_column($jersey_size_options->choices, 'text');
//$grade_options = $wpdb->get_results("SELECT * FROM " . DB_GRADE_SESSIONS . " WHERE status = 1");
if (class_exists('GFCommon')) {
ob_start();
?>
<div class="outerGroup">
<input type="hidden" name="user_id" value="<?php echo $user_id; ?>">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<input type="text" name="first_name" maxlength="100" class="form-control" placeholder="Enter First Name" required>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<input type="text" name="last_name" maxlength="100" class="form-control" placeholder="Enter Last Name" required>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<select class="form-control sel_grade" name="grade" required>
<option value=""> -- Choose Grade -- </option>
<?php foreach ($grade_optionsArr as $grade) { ?>
<option value="<?php echo $grade; ?>">
<?php echo $grade; ?>
</option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<select class="form-control sel_jersey" name="jersey_size" required>
<option value=""> -- Choose Jersey Size -- </option>
<?php foreach ($jersey_size_optionsArr as $jersey) { ?>
<option value="<?php echo $jersey; ?>">
<?php echo $jersey; ?>
</option>
<?php } ?>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<input type="text" name="school_name" maxlength="100" class="form-control " placeholder="Enter School Name" >
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<input type="text" name="child_dob" class="form-control date_sel" id="child_dob" placeholder="YYYY-MM-DD" required >
</div>
</div>
<!-- <div class="col-md-6">
<div class="form-group">
<select class="form-control sel_jersey" name="child_type" required>
<option value=""> -- Children used for -- </option>
<option value="<?php echo $jersey; ?>">
<?php echo "Personal" ?>
</option>
</select>
</div>
</div> -->
</div>
</div>
<script type="text/javascript">
var currentYear = new Date().getFullYear();
jQuery(".date_sel").datepicker({
changeMonth: true,
changeYear: true,
// minDate: new Date(),
maxDate: new Date(), // December 31 of the current year
yearRange: (currentYear - 100) + ":" + currentYear,
dateFormat: "yy-m-dd",
firstDay: 1
});
// getDatePicker([]);
</script>
<?php $renderedHtml = ob_get_clean();
}
echo json_encode(['status' => true, 'renderedHtml' => $renderedHtml ]);
die();
}
add_action('wp_ajax_nopriv_add_child_info_admin', 'add_child_info_admin');
add_action('wp_ajax_add_child_info_admin', 'add_child_info_admin');
function add_child_info_admin(){
global $wpdb;
parse_str($_POST['data'],$input);
$payload = array(
'first_name' => $input['first_name'],
'last_name' => $input['last_name'],
'grade' => $input['grade'],
'jersey_size' => $input['jersey_size'],
'user_id' => $input['user_id'],
'school_name' => $input['school_name'],
'child_dob' => $input['child_dob'],
// 'child_type' => 'personal'
);
if ($wpdb->insert(DB_CHILD_DETAILS, $payload)) {
$status = array('status' => TRUE,'message' => "Added succesfully");
} else {
$status = array('status' => FALSE,'message' => $wpdb->last_error);
}
echo json_encode($status);
die();
}
add_action('wp_ajax_nopriv_delete_child_info', 'delete_child_info');
add_action('wp_ajax_delete_child_info', 'delete_child_info');
function delete_child_info(){
global $wpdb;
$child_id = $_POST['child_id'];
if ($wpdb->delete( DB_CHILD_DETAILS, array( 'id' => $child_id ) )) {
$status = array('status' => TRUE,'message' => "Deleted succesfully");
} else {
$status = array('status' => FALSE,'message' => $wpdb->last_error);
}
echo json_encode($status);
die();
}