<?php
function evr_admin_edit_attendee(){
global $wpdb;
//$event_id = $_REQUEST['event_id'];
(is_numeric($_REQUEST['event_id'])) ? $event_id = $_REQUEST['event_id'] : $event_id = "0";
$event = $wpdb->get_row('SELECT * FROM ' . get_option('evr_event') . ' WHERE id = ' . $event_id);
$reg_form_defaults = unserialize($event->reg_form_defaults);
if ($reg_form_defaults !=""){
if (in_array("Address", $reg_form_defaults)) {$inc_address = "Y";}
if (in_array("City", $reg_form_defaults)) {$inc_city = "Y";}
if (in_array("State", $reg_form_defaults)) {$inc_state = "Y";}
if (in_array("Zip", $reg_form_defaults)) {$inc_zip = "Y";}
if (in_array("Phone", $reg_form_defaults)) {$inc_phone = "Y";}
}
$event_category = unserialize($event->event_category);
$reg_limit = $event->reg_limit;
$event_name = stripslashes($event->event_name);
$use_coupon = $event->use_coupon;
$attendee_id = $_REQUEST['attendee_id'];
$sql = "SELECT * FROM " . get_option('evr_attendee') . " WHERE id='$attendee_id'";
$result = mysql_query ( $sql );
while ( $row = mysql_fetch_assoc ( $result ) ) {
$lname = $row ['lname'];
$fname = $row ['fname'];
$address = $row ['address'];
$city = $row ['city'];
$state = $row ['state'];
$zip = $row ['zip'];
$email = $row ['email'];
$phone = $row ['phone'];
//$quantity = $row ['num_people'];
$quantity = $row ['quantity'];
$date = $row ['date'];
$reg_type = $row['reg_type'];
$ticket_order = unserialize($row['tickets']);
$payment= $row['payment'];
$event_id = $row['event_id'];
$coupon = $row['coupon'];
$attendees = unserialize($row['attendees']);
}
?>
<div class="wrap">
<h2><a href="http://www.wpeventregister.com"><img src="<?php echo EVR_PLUGINFULLURL ?>images/evr_icon.png" alt="Event Registration for Wordpress" /></a></h2>
<h2><?php _e('Attendee Management','evr_language');?></h2>
<form name="form" method="post" action="admin.php?page=attendee">
<input type="hidden" name="action" value="view_attendee"/>
<input type="hidden" name="event_id" value="<?php echo $event_id?>">
<input class="button-primary" type="submit" name="items" value="<?php _e('Select Another Attendee','evr_language');?>" />
</form>
<div id="dashboard-widgets-wrap">
<div id="dashboard-widgets" class="metabox-holder">
<div class='postbox-container' style='width:65%;'>
<div id='normal-sortables' class='meta-box-sortables'>
<div id="dashboard_right_now" class="postbox " >
<h3 class='hndle'><span><?php _e('Edit Attendee:','evr_language');?><?php echo " ".$event_name;?></span></h3>
<div class="inside">
<div class="padding">
<form method="post" action="<?php echo $_SERVER['REQUEST_URI'];?>" onSubmit="return validateForm(this)">
<ul>
<li><label for="fname"><?php _e('First Name','evr_language');?></label><input id="fname" name="fname" value="<?php echo $fname;?>" /></li>
<li><label for="lname"><?php _e('Last Name','evr_language');?></label><input id="lname" name="lname" value="<?php echo $lname;?>"/></li>
<li><label for="email" ><?php _e('Email Address','evr_language');?></label><input id="email" name="email" value="<?php echo $email;?>"/></li>
<?php if ($inc_phone == "Y") { ?>
<li><label for="phone" ><?php _e('Phone Number','evr_language');?></label><input id="phone" name="phone" value="<?php echo $phone;?>"/></li>
<?php } ?>
<?php if ($inc_address == "Y") { ?>
<li><label for="address"><?php _e('Address','evr_language');?></label><input id="address" name="address" value="<?php echo $address;?>" /></li>
<?php } ?>
<?php if ($inc_city == "Y") { ?>
<li><label for="city"><?php _e('City','evr_language');?></label><input id="city" name="city" value="<?php echo $city;?>"/></li>
<?php } ?>
<?php if ($inc_state == "Y") { ?>
<li><label for="state"><?php _e('State/Province','evr_language');?></label><input id="state" name="state" value="<?php echo $state;?>"/></li>
<?php } ?>
<?php if ($inc_zip == "Y") { ?>
<li><label for="zip"><?php _e('Zip/Postal Code','evr_language');?></label><input id="zip" name="zip" value="<?php echo $zip;?>" /></li>
<?php } ?>
<?php if ($use_coupon == "Y") { ?>
<li><label for="coupon"><?php _e('Enter coupon code for discount off primary registration?','evr_language');?></label><input id="coupon" name="coupon" value="<?php echo $coupon;?>"/></li>
<?php } ?>
<?php
$questions = $wpdb->get_results("SELECT * from ".get_option('evr_question')." where event_id = '$event_id' order by sequence");
if ($questions) {
for($i = 0; $i < count ( $questions ); $i ++) {
echo "<li><label>".$questions [$i]->question."</label>";
$question_id = $questions [$i]->id;
$query = "SELECT * FROM ".get_option('evr_answer')." WHERE registration_id = '$attendee_id' AND question_id = '$question_id'";
$result = mysql_query ( $query ) or die ( 'Error : ' . mysql_error () );
while ( $row = mysql_fetch_assoc ( $result ) ) {
$answers = $row ['answer'];
}
evr_form_build_edit ( $questions [$i], $answers );
echo "</li>";
}
}
?>
<hr />
<li><b><label for="attendees"><?php _e('Attendees','evr_language');?></label></b></li><br/>
<?php
if ( $quantity >"0"){
$i = 0;
do {
$person = $i + 1;
echo 'Attendee #'.$person.' First Name: <input name="attendee['.$i.'][first_name]"';
if ($i=="0" && $attendees[$i]["first_name"]==""){ echo 'value ="'.$fname.'"'; }
else {echo 'value ="'.$attendees[$i]["first_name"].'"';}
echo '/>';
echo ' Last Name: <input name="attendee['.$i.'][last_name]"';
if ($i=="0" && $attendees[$i]["last_name"]==""){ echo 'value ="'.$lname.'"'; }
else {echo 'value ="'.$attendees[$i]["last_name"].'"';}
echo '/></br>';
++$i;
} while ($i < $quantity);
}
?>
</ul>
<?php
$num = 0;
$sql2= "SELECT SUM(quantity) FROM " . get_option('evr_attendee') . " WHERE event_id='$event_id'";
$attendee_count = $wpdb->get_var($sql2);
If ($attendee_count >= 1) {$num = $attendee_count;}
$available = $reg_limit - $num;
/* $sql2= "SELECT SUM(quantity) FROM " . get_option('evr_attendee') . " WHERE event_id='$event_id'";
$result2 = mysql_query($sql2);
$num = 0;
while($row = mysql_fetch_array($result2)){$num = $row['SUM(quantity)'];};
$available = $reg_limit - $num;
*/
// if ($available > "1"){
?>
<hr />
<h2 align="center">REGISTRATION FEES</h2><br />
<li><label for="reg_type"><?php _e('What type of Registration?','evr_language');?></label><input type="radio" id="reg_type" name="reg_type" value="WAIT" <?php if($reg_type=="WAIT"){echo "checked";}?> />Wait List
<input type="radio" id="reg_type" name="reg_type" value="RGLR" <?php if($reg_type=="RGLR"){echo "checked";}?> />Standard</li>
<?php
$open_seats = $available;
$curdate = date("Y-m-d");
$row_count = count($ticket_order);
if ($ticket_order != ""){
for ($row = 0; $row < $row_count; $row++) {
?>
<p><select name="PROD_<?php echo $ticket_order[$row]['ItemEventID']. "-" . $ticket_order[$row]['ItemID'] . "_" . $ticket_order[$row]['ItemCost']; ?>" id = "PROD_<?php echo
$ticket_order[$row]['ItemEventID']. "-" . $ticket_order[$row]['ItemID'] . "_" . $ticket_order[$row]['ItemCost']; ?>" onChange="CalculateTotal(this.form)" >
<option value="<?php echo $ticket_order[$row]['ItemQty'];?>"><?php echo $ticket_order[$row]['ItemQty'];?></option>
<option value="0">0</option>
<?php
if ($ticket_order[$row]['ItemCat'] == "REG"){
if ($ticket_limit != ""){
if ($available >= $item_limit){$available = $item_limit;}
}
for($i=1; $i<$available+1; $i++) { ?>
<option value="<?php echo($i); ?>"><?php echo($i); ?></option>
<?php } }
if ($ticket_order[$row]['ItemCat'] != "REG"){
$num_select = "10";
if ($ticket_limit != ""){
$num_select = $item_limit;}
for($i=1; $i<$num_select+1; $i++) { ?>
<option value="<?php echo($i); ?>"><?php echo($i); ?></option>
<?php } }
?>
</select>
<?php echo $ticket_order[$row]['ItemName'] . " " . $ticket_order[$row]['ItemCurrency'] . " " . $ticket_order[$row]['ItemCost']; ?></p>
<?php } }
if ($ticket_order == ""){?> <font color="red">Update total ticket count!</font><?php
$sql = "SELECT * FROM " . get_option('evr_cost') . " WHERE event_id = " . $event_id. " ORDER BY sequence ASC";
$result = mysql_query ( $sql );
while ($row = mysql_fetch_assoc ($result)){
$item_id = $row['id'];
$item_sequence = $row['sequence'];
$event_id = $row['event_id'];
$item_title = $row['item_title'];
$item_description = $row['item_description'];
$item_cat = $row['item_cat'];
$item_limit = $row['item_limit'];
$item_price = $row['item_price'];
$free_item = $row['free_item'];
$item_start_date = $row['item_available_start_date'];
$item_end_date = $row['item_available_end_date'];
$item_custom_cur = $row['item_custom_cur'];
//if (($item_start_date >= $curdate) && ($item_end_date <= $curdate)) {
// Remove date filter if((evr_greaterDate($curdate,$item_start_date))&& (evr_greaterDate($item_end_date,$curdate))){
?>
<input type="hidden" name="reg_type" value="RGLR"/>
<p><select name="PROD_<?php echo $event_id . "-" . $item_id . "_" . $item_price; ?>" id = "PROD_<?php echo
$event_id . "-" . $item_id . "_" . $item_price; ?>" onChange="CalculateTotal(this.form)" >
<option value="0">0</option>
<?php
if ($item_cat == "REG"){
if ($ticket_limit != ""){
if ($available >= $item_limit){$available = $item_limit;}
}
for($i=1; $i<$available+1; $i++) { ?>
<option value="<?php echo($i); ?>"><?php echo($i); ?></option>
<?php } }
if ($item_cat != "REG"){
$num_select = "10";
if ($ticket_limit != ""){
$num_select = $item_limit;}
for($i=1; $i<$num_select+1; $i++) { ?>
<option value="<?php echo($i); ?>"><?php echo($i); ?></option>
<?php } }
?>
</select>
<?php echo $item_title . " " . $item_custom_cur . " " . $item_price; ?></p>
<?php
// }
} }?>
<br /><b>Registration TOTAL <input type="text" name="total" id="total" size="10" <?php if ($payment > ""){echo 'value="'.$payment.'"';}
else {echo 'value="0.00"';}?> onFocus="this.form.elements[0].focus()"/></b>
<br />
<?php
if ($open_seats <= "1"){
echo '<hr><br><b><font color="red">';
_e('This event has reached registration capacity.','evr_language');
echo "<br>";
/* Removed this to allow editing reg form without changing wait status
_e('Please provide your information to be placed on the waiting list.','evr_language');
echo '</b></font>';
?>
<input type="hidden" name="reg_type" value="WAIT" />
<?php
*/
}
?>
<script language="JavaScript" type="text/javascript">
<!--
/* This script is Copyright (c) Paul McFedries and
Logophilia Limited (http://www.mcfedries.com/).
Permission is granted to use this script as long as
this Copyright notice remains in place.*/
function CalculateTotal(frm) {
var order_total = 0
// Run through all the form fields
for (var i=0; i < frm.elements.length; ++i) {
// Get the current field
form_field = frm.elements[i]
// Get the field's name
form_name = form_field.name
// Is it a "product" field?
if (form_name.substring(0,4) == "PROD") {
// If so, extract the price from the name
item_price = parseFloat(form_name.substring(form_name.lastIndexOf("_") + 1))
// Get the quantity
item_quantity = parseInt(form_field.value)
// Update the order total
if (item_quantity >= 0) {
order_total += item_quantity * item_price
}
}
}
// Display the total rounded to two decimal places
frm.total.value = round_decimals(order_total, 2)
}
function round_decimals(original_number, decimals) {
var result1 = original_number * Math.pow(10, decimals)
var result2 = Math.round(result1)
var result3 = result2 / Math.pow(10, decimals)
return pad_with_zeros(result3, decimals)
}
function pad_with_zeros(rounded_value, decimal_places) {
// Convert the number to a string
var value_string = rounded_value.toString()
// Locate the decimal point
var decimal_location = value_string.indexOf(".")
// Is there a decimal point?
if (decimal_location == -1) {
// If no, then all decimal places will be padded with 0s
decimal_part_length = 0
// If decimal_places is greater than zero, tack on a decimal point
value_string += decimal_places > 0 ? "." : ""
}
else {
// If yes, then only the extra decimal places will be padded with 0s
decimal_part_length = value_string.length - decimal_location - 1
}
// Calculate the number of decimal places that need to be padded with 0s
var pad_total = decimal_places - decimal_part_length
if (pad_total > 0) {
// Pad the string with 0s
for (var counter = 1; counter <= pad_total; counter++)
value_string += "0"
}
return value_string
}
//-->
</script>
<hr />
<?php if ($ER_org_data['captcha'] == 'Y') { ?>
<p>Enter the security code as it is shown (required):<script type="text/javascript">sjcap("altTextField");</script>
<noscript><p>[This resource requires a Javascript enabled browser.]</p></noscript>
<?php } ?>
<input type="hidden" name="action" value="update_attendee"/>
<input type="hidden" name="event_id" value="<?php echo $event_id; ?>"/>
<p align="center"><input type="submit" name="Submit" value="<?php _e('UPDATE','evr_language');?>"/> </p>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
}
?>