<?php
include './admin/config.php';
include './admin/db_connection.php';
if (isset($_POST['user_id_clear']) && $_POST['user_id_clear'] != '') {
$product_id = $_POST['product_id_clear'];
$user_id = $_POST['user_id_clear'];
$query = "DELETE FROM sohorepro_checkout WHERE user_id = '" . $user_id . "'";
mysql_query($query);
$checkout_product = checkOut($user_id);
echo 'Removed the all products successfully~';
}
?>
<table width="740" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right" valign="middle" height="55" ><input type="button" onclick="return continue_shopping('<?php echo $user_id; ?>');" class="btn_shopping" value="Contiune Shopping"></td>
</tr>
<tr>
<td align="left" valign="top">
<table width="740" border="0" cellspacing="0" cellpadding="0" class="product_table" >
<tr bgcolor="#ff7e00" class="h1">
<td width="48" align="center" valign="middle" class="brdr_2" >S.NO</td>
<td width="46" align="center" valign="middle" class="brdr_2" >SKU Id</td>
<td width="115" align="left" valign="middle" class="brdr_2">Product Name</td>
<td width="66" align="center" valign="middle" class="brdr_2">Unit Price</td>
<td width="44" align="center" valign="middle" class="brdr_2">Qty</td>
<td width="64" align="center" valign="middle" class="brdr_2">Line Price</td>
<td width="243" align="left" valign="middle" class="brdr_2">Shipping Address</td>
<td width="97" align="center" valign="middle" class="brdr_2">Option</td>
</tr>
function updateResultTable($athlete, $event, $startHeight)
{
global $glb_connection, $glb_connection_server;
global $glb_results_skip;
global $glb_high_attempt_passed, $glb_high_attempt_failed, $glb_high_attempt_waived;
try {
$settings = getHighSettings($event);
$sql_ath = "SELECT xSerienstart AS ath_id\r\n , xSerie\r\n , IF((SELECT COUNT(*) FROM resultat WHERE xSerienstart = serienstart.xSerienstart AND Leistung IN (" . implode(',', $glb_results_skip) . ")), 1, 0) AS skip\r\n , Starthoehe AS ath_start\r\n , Position AS ath_pos\r\n FROM serienstart\r\n WHERE xSerienstart = :serienstart;";
$query_ath = $glb_connection_server->prepare($sql_ath);
$query_ath->bindValue(':serienstart', $athlete);
$query_ath->execute();
$ath = $query_ath->fetch(PDO::FETCH_ASSOC);
$xSerienstart = $ath['ath_id'];
$position = $ath['ath_pos'];
$xSerie = $ath['xSerie'];
$skip = $ath['skip'];
$sql_res = "SELECT \r\n xSerienstart\r\n , Leistung AS result_max\r\n , Info AS result_info\r\n FROM\r\n resultat \r\n LEFT JOIN serienstart USING (xSerienstart) \r\n WHERE xSerienstart = :serienstart \r\n AND Info LIKE '%" . $glb_high_attempt_passed . "%'\r\n ORDER BY Leistung DESC\r\n LIMIT 1;";
$query_res = $glb_connection_server->prepare($sql_res);
$query_res->bindValue(':serienstart', $xSerienstart);
$query_res->execute();
$result = $query_res->fetch(PDO::FETCH_ASSOC);
$result_res = $result['result_max'] ? $result['result_max'] : 0;
$res_attempts = substr_count($result['result_info'], $glb_high_attempt_failed) + 1;
$sql_miss = "SELECT \r\n xSerienstart\r\n , Leistung AS result\r\n , Info AS result_info\r\n FROM\r\n resultat \r\n LEFT JOIN serienstart USING (xSerienstart) \r\n WHERE xSerienstart = :serienstart \r\n AND Info LIKE '%" . $glb_high_attempt_failed . "%';";
$query_miss = $glb_connection_server->prepare($sql_miss);
$query_miss->bindValue(':serienstart', $xSerienstart);
$query_miss->execute();
$results_miss = $query_miss->fetchAll(PDO::FETCH_ASSOC);
$miss = 0;
foreach ($results_miss as $result_miss) {
$miss = $miss + substr_count($result_miss['result_info'], $glb_high_attempt_failed);
}
$sql_heights = "SELECT serie\r\n , height\r\n FROM t_heights\r\n WHERE serie = :serie\r\n ORDER BY height ASC;";
$query_heights = $glb_connection->prepare($sql_heights);
$query_heights->bindValue(':serie', $event);
$query_heights->execute();
$heights = $query_heights->fetchAll(PDO::FETCH_ASSOC);
$sql_maxHeight = "SELECT MAX(height) as max_height\r\n FROM t_heights\r\n WHERE serie = :serie\r\n ORDER BY height ASC;";
$query_maxHeight = $glb_connection->prepare($sql_maxHeight);
$query_maxHeight->bindValue(':serie', $event);
$query_maxHeight->execute();
$maxHeight = $query_maxHeight->fetch(PDO::FETCH_ASSOC);
$maxHeight = $maxHeight['max_height'];
$diff = $maxHeight < $settings['diff_1_until'] ? $settings['diff_1_value'] : $settings['diff_2_value'];
$curr_height = $maxHeight + $diff;
$curr_miss = 0;
$out = checkOut($athlete);
if ($out) {
$curr_height = 0;
$curr_miss = 0;
} else {
foreach ($heights as $height) {
if ($height['height'] >= $startHeight) {
$sql_check = "SELECT Info\r\n FROM resultat\r\n WHERE Leistung = :height\r\n AND xSerienstart = :serienstart;";
$query_check = $glb_connection_server->prepare($sql_check);
$query_check->bindValue(':height', $height['height']);
$query_check->bindValue(':serienstart', $athlete);
$query_check->execute();
if ($query_check->rowCount() == 0) {
$curr_height = $height['height'];
$curr_miss = 0;
break;
} else {
$check = $query_check->fetch(PDO::FETCH_ASSOC);
$check_miss = substr_count($check['Info'], $glb_high_attempt_failed);
$check_skip = substr_count($check['Info'], $glb_high_attempt_passed) + substr_count($check['Info'], $glb_high_attempt_waived);
if ($check_miss > 0 && $check_skip == 0) {
$curr_height = $height['height'];
$curr_miss = $check_miss;
break;
}
}
}
}
}
$sql_insert = "UPDATE tempresult SET\r\n skip = :skip\r\n , result = :result\r\n , result_attempts = :res_attempts\r\n , miss = :miss\r\n , ath_out = :out\r\n , curr_height = :curr_height\r\n , curr_miss = :curr_miss\r\n WHERE xSerienstart = :serienstart;";
$query_insert = $glb_connection->prepare($sql_insert);
$query_insert->bindValue(':serienstart', $athlete);
$query_insert->bindValue(':skip', $skip);
$query_insert->bindValue(':result', $result_res);
$query_insert->bindValue(':res_attempts', $res_attempts);
$query_insert->bindValue(':miss', $miss);
$query_insert->bindValue(':out', $out);
$query_insert->bindValue(':curr_height', $curr_height);
$query_insert->bindValue(':curr_miss', $curr_miss);
$query_insert->execute();
} catch (PDOException $e) {
trigger_error($e->getMessage());
}
}
$seats['SC'] = $_POST['SC'];
$seats['FA'] = $_POST['FA'];
$seats['FC'] = $_POST['FC'];
$seats['B1'] = $_POST['B1'];
$seats['B2'] = $_POST['B2'];
$seats['B3'] = $_POST['B3'];
$price = calculatePrice($seats, $date);
foreach ($seats as $k => $v) {
if ($v == 0) {
unset($seats[$k]);
}
}
addToCart($movie, $date, $price, $sessiontime, $seats);
}
if (isset($_POST['firstname'])) {
checkOut($_POST['firstname'], $_POST['lastname'], $_POST['phone'], $_POST['emailaddress']);
unset($_POST['firstname']);
}
function addToCart($movie, $date, $price, $sessiontime, $seats)
{
$_SESSION['cart'][$movie]['date'] = $date;
$_SESSION['cart'][$movie]['sessiontime'] = $sessiontime;
$_SESSION['cart'][$movie]['price'] = $price;
$_SESSION['cart'][$movie]['seats'] = $seats;
}
function removeFromCart($movie)
{
unset($_SESSION['cart'][$movie]);
}
function checkOut($firstname, $lastname, $phone, $email)
{
$Order_number = $object['order_number'];
$order_comm = $object['order_comment'];
//$current_time = date("Y-m-d h:i:s");
$current_time = $object['created_date'];
$datew = new DateTime($current_time, new DateTimeZone('America/New_York'));
date_default_timezone_set('America/New_York');
$temp_times = date("Y-m-d h:iA", $datew->format('U'));
//$Date = date("m/d/Y", strtotime($object['created_date'])). ' ' .date("h:iA",strtotime("-0 minutes",strtotime($temp_times)));
$Date = date('Y-m-d h:i A', time());
$view_orders = viewOrders($id);
$pick_up = $view_orders[0]['shipping_add_id'];
$returnValue = html_entity_decode('Your Soho Repro graphics order has been received and will be processed promptly.', ENT_COMPAT, 'ISO-8859-1');
//Add Favorites
$select_pro_fav = checkOut($user_id);
foreach ($select_pro_fav as $fav_prod){
$fav_comp_id = $fav_prod['company_id'];
$fav_prod_id = $fav_prod['product_id'];
$check_fav = CHECKFAVEXIXT($fav_comp_id, $fav_prod_id);
if(count($check_fav) == '0'){
$sql_sort_id = mysql_query("SELECT sort_id FROM sohorepro_favorites WHERE comp_id = '".$comp_id."' ORDER BY sort_id DESC LIMIT 1");
$object_order_sort = mysql_fetch_assoc($sql_sort_id);
if (count($object_order_sort['sort_id']) > 0) {
$order_sort_id = ($object_order_sort['sort_id'] + 1);
}
if (count($object_order['order_number']) > 0) {
$order_id = ($object_order['order_number'] + 1);
}
else{
$order_id = '101';
}
$user_id = $_POST['user_cart_id'];
$company_id = $_POST['company_id'];
$referece = $_POST['reference'] ;
$sql = "INSERT INTO sohorepro_order_master SET order_number = '".$order_id."', order_id = '" . $referece . "', customer_company = '".$company_id."', customer_name = '".$user_id."', created_date = now()";
mysql_query($sql);
$order_id_pro = mysql_insert_id();
$product = checkOut($user_id);
if($order_id_pro != ''){
foreach ($product as $pro)
{
$product_id = $pro['product_id'];
$product_price = $pro['unit_price'];
$product_quantity = $pro['quantity'];
$shipping_id = $pro['shipping_add_id'];
$product_name = mysql_real_escape_string(getProName($product_id));
$query = "INSERT INTO sohorepro_product_master SET product_id = '" . $product_id . "', product_price = '" . $product_price . "', product_quantity = '" . $product_quantity . "', product_name = '".$product_name."', order_id = '" .$order_id_pro. "', shipping_add_id ='" .$shipping_id. "' ";
mysql_query($query);
}
}
</table></center>
<br><br>
</form>
<?php
$con = mysql_connect("localhost", "root", "");
if ($con) {
mysql_select_db("library");
} else {
echo 'could not connect' . "<br/>";
}
if ($_POST) {
if (isset($_POST['checkout'])) {
checkOut();
} elseif (isset($_POST['checkin'])) {
checkIn();
}
}
function checkOut()
{
$bookid = $_POST['bookid'];
$branchid = $_POST['branchid'];
$card = $_POST['card'];
$queryno = " select count(*) as 'no_of_books_taken' from book_loans " . " where card_no='{$card}' and isnull(date_in) ";
$no_taken = mysql_query($queryno);
if ($no_taken === FALSE) {
echo mysql_error();
} else {
while ($no = mysql_fetch_assoc($no_taken)) {
require_once ROOT_PATH . 'lib/inc.init.php';
require_once ROOT_PATH . 'lib/cls.result_high.php';
$athletes = getAthleteDetails(0, true, "ath_rank, ath_res DESC");
?>
<table>
<colgroup>
<col width="50">
<col width="50">
<col width="200">
<col width="50">
<col width="250">
<col>
</colgroup>
<?php
foreach ($athletes as $athlete) {
$out = checkOut($athlete['ath_id']);
if ($out == 1 || $athlete['ath_res'] < 0) {
$class = "resultlist_inactive";
} else {
$class = "resultlist";
}
?>
<tr class="<?php
echo $class;
?>
">
<td><?php
echo $athlete['ath_rank_out'];
?>
</td>
<td><?php
public function actionView()
{
global $urlRequestRoot, $sourceFolder, $templateFolder, $cmsFolder, $moduleFolder;
$moduleComponentId = $this->moduleComponentId;
$scriptsFolder = "{$urlRequestRoot}/{$cmsFolder}/{$templateFolder}/common/scripts";
$imagesFolder = "{$urlRequestRoot}/{$cmsFolder}/{$templateFolder}/common/images";
require_once "{$sourceFolder}/{$moduleFolder}/prhospi/prhospi_common.php";
require_once "{$sourceFolder}/{$moduleFolder}/prhospi/accommodation.php";
if (isset($_POST['subaction']) && $_POST['subaction'] == 'accoRegUser') {
echo ajaxSuggestions($moduleComponentId, 0, $this->userId);
exit;
}
if (isset($_POST['subaction']) && $_POST['subaction'] == 'accoRegUserUpdate') {
echo ajaxSuggestions($moduleComponentId, 1);
exit;
}
if (isset($_GET['subaction']) && $_GET['subaction'] == 'getsuggestions' && isset($_GET['forwhat'])) {
echo getSuggestionsForIdOrEmail(escape($_GET['forwhat']));
exit;
}
if (isset($_POST['printthis']) && isset($_POST['printHiddenId'])) {
if ($_POST['printHiddenId'] != "") {
$pos = strpos($_POST['printHiddenId'], "printHostelAllotmentBill");
if ($pos == 0) {
return printDisclaimer($moduleComponentId, substr(escape($_POST['printHiddenId']), 24), "hospihead");
}
}
}
if (isset($_GET['subaction'])) {
if ($_GET['subaction'] == 'AddRoom') {
if (isset($_POST['addHostels'])) {
$displayActions = addHostels($_POST, $moduleComponentId);
}
return $displayActions = displayAddNewRooms("view", $moduleComponentId);
}
}
$displayTags = <<<TAG
<script type="text/javascript" src="{$urlRequestRoot}/{$cmsFolder}/{$moduleFolder}/prhospi/accoregister.js"></script>
<h2> Accommodation </h2>
\t<table>
<tr>
<td><a href="./+view&subaction=viewRegisteredUser"> <div>View Registrants</div></a></td>
<td><a href="./+view"><div>Add User</div></a></td>
</tr>
</table>
TAG;
if (isset($_GET['subaction']) && $_GET['subaction'] == 'viewRegisteredUser') {
$excel = "<a href='./+view&subaction=viewRegisteredUser&saveAsExcel'>Save as Excel</a>";
if (isset($_GET['saveAsExcel'])) {
require_once "{$sourceFolder}/{$moduleFolder}/qaos1/excel.php";
displayExcelForTable(displayUsersRegisteredToAcco($moduleComponentId));
}
return $displayTags . $excel . displayUsersRegisteredToAcco($moduleComponentId);
}
$inputUser = <<<USER
<h2> CHECK IN FORM </h2>
<form method="POST" action="./+view">
Enter UserId or Email:<input type="text" name="txtFormUserId" id="txtFormUserId" autocomplete="off" style="width: 256px" />
<div id="suggestionsBox" style="background-color: white; width: 260px; border: 1px solid black; position: absolute; overflow-y: scroll; max-height: 180px; display: none"></div>
<input type="submit" Value="Find User"/>
<!-- <script type="text/javascript" language="javascript" src="{$scriptsFolder}/ajaxsuggestionbox.js">
</script>
<script language="javascript">
var userBox = new SuggestionBox(document.getElementById('txtFormUserId'), document.getElementById('suggestionsBox'), "./+view&subaction=getsuggestions&forwhat=%pattern%");
userBox.loadingImageUrl = '{$imagesFolder}/ajaxloading.gif';
</script>
--> </form>
USER;
$userDetails = "";
$displayActions = "";
if (isset($_POST['txtFormUserId']) && $_POST['txtFormUserId'] != '') {
// $detailsGiven=explode("- ",escape($_POST['txtFormUserId']));
// $userDetails.=getUserDetailsForHospi($detailsGiven[1],$moduleComponentId);
$userDetails .= getUserDetailsForHospi(escape($_POST['txtFormUserId']), $moduleComponentId);
}
if (isset($_POST['txtFormUserId1']) && $_POST['txtFormUserId1'] != '') {
if (!isset($_POST['refundAmt'])) {
displayerror("Refund Amount Not Defined");
} else {
if (!is_numeric($_POST['refundAmt'])) {
displayerror("Refund Amount is not a Valid Number");
} else {
// $detailsGiven=explode("- ",escape($_POST['txtFormUserId1']));
// checkOut($detailsGiven[1],escape($_POST['refundAmt']),$moduleComponentId);
checkOut(escape($_POST['txtFormUserId1']), escape($_POST['refundAmt']), $moduleComponentId);
}
}
}
if (isset($_GET['subaction']) && $_GET['subaction'] == 'accommodation' && isset($_GET['userId']) && is_numeric($_GET['userId'])) {
$userDetails .= displayAccommodationForm(escape($_GET['userId']), $moduleComponentId, $this->userId);
}
$amtToCollect = getAmount("hospihead", $moduleComponentId);
$checkOutFORM = <<<checkOut
<hr/>
<h2> CHECK OUT FORM </h2>
<form method="POST" action="./+view">
<table border="1">
<tr>
<td>Enter UserId or Email:</td>
<td><input type="text" name="txtFormUserId1" id="txtFormUserId1" autocomplete="off" style="width: 256px" />
<div id="suggestionsBox1" style="background-color: white; width: 260px; border: 1px solid black; position: absolute; overflow-y: scroll; max-height: 180px; display: none"></div><br/>
</td>
</tr>
<tr>
<td>Refund Amount:</td>
<td><input type="text" name="refundAmt" value="{$amtToCollect}"/></td>
</tr>
<tr>
<td colspan="2"><input type="submit" Value="Find User"/></td>
</tr>
</table>
<!-- <script type="text/javascript" language="javascript" src="{$scriptsFolder}/ajaxsuggestionbox.js">
</script>
<script language="javascript">
var userBox = new SuggestionBox(document.getElementById('txtFormUserId1'), document.getElementById('suggestionsBox1'), "./+view&subaction=getsuggestions&forwhat=%pattern%");
userBox.loadingImageUrl = '{$imagesFolder}/ajaxloading.gif';
</script> -->
</form>
checkOut;
return $displayTags . $inputUser . $userDetails . $checkOutFORM;
}
} else {
$message = strtolower($currentCall->initialText);
}
switch ($message) {
// User is checking in.
case 'check in':
if (checkIn($callerID, $channel, $network)) {
say('You have been checked in to Cloud knock.');
} else {
say('Could not check you in. Do you need to check out?');
}
break;
// User is checking out.
// User is checking out.
case 'check out':
if (checkOut($callerID)) {
say('You have been checked out of Cloud knock.');
} else {
say('Could not check you out. Do you need to check in?');
}
break;
// Somebody's knocking on the door, somebody's rining the bell...
// Somebody's knocking on the door, somebody's rining the bell...
case 'knock knock':
if (knockKnock($userName, $callerID)) {
say('OK. knocks sent.');
} else {
say('No one checked in. :-(');
}
break;
default:
}
}
if (isset($_POST["form_submit_out"]) && $_POST["form_submit_out"] == "true" && $_POST["form_submit_out"] != "") {
$userid = trim($_POST['userid']);
$data['attd_out_time'] = trim($_POST['attd_out_time']);
$data['attd_date'] = trim($_POST['attd_date']);
$data['attd_comment'] = trim($_POST['attd_comment']);
if (!checkOutCheckIn($userid, $data, $db)) {
// check today check in data is exist or not
$rfc = "<script>alert('Please, check in first, thank you.')</script>";
} else {
if (checkOutCheckedIn($userid, $data, $db)) {
// check today checked in data is already exist or not
$rfc = "<script>alert('You already checked out for today, thank you.')</script>";
} else {
if (checkOut($userid, $data, $db)) {
// checking out
$rfc = "<script>alert('Successfully checked out, thank you.')</script>";
} else {
$rfc = "<script>alert('Sorry for inconvenience, try again.')</script>";
}
}
}
}
if (isset($_POST['filter']) && $_POST['filter'] == "true" && $_POST["filter"] != "") {
$my[0] = trim($_POST['year']);
$my[1] = trim($_POST['month']);
$my[2] = trim($todaydate[2]);
// only allow to view history
$show = true;
if ($my[0] > $todaydate[0]) {
