Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/jusjumpin.in/public_html

Free Space:

1.93 TB

🔧 Quick Actions

✏️ Editing: home2.php

<?php
ob_start();
session_start();
include("includes/incall.php");
$editid=isset($_REQUEST['editid'])?$_REQUEST['editid']:'';	
$action=isset($_REQUEST['action'])?$_REQUEST['action']:'add';
if(!isset($_SESSION['duplblock']) && $_SESSION['duplblock']=="") {
	$_SESSION['duplblock']=strtotime("now");
}
/*function SMS_Wapp_Sender($mobile_number,$message_det) {
	$wappno="91".$mobile_number;
	$imagelink="https://jusjumpin.in/2.jpg";
	$curl = curl_init();
	curl_setopt_array($curl, array(
	CURLOPT_URL => 'https://api.msg91.com/api/v5/whatsapp/whatsapp-outbound-message/',
	CURLOPT_RETURNTRANSFER => true,
	CURLOPT_ENCODING => '',
	CURLOPT_MAXREDIRS => 10,
	CURLOPT_TIMEOUT => 0,
	CURLOPT_FOLLOWLOCATION => true,
	CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
	CURLOPT_CUSTOMREQUEST => 'POST',
	CURLOPT_POSTFIELDS =>"{
		\"integrated_number\": \"919800005721\",
		\"content_type\": \"template\",
		\"payload\": {
			\"to\": $wappno,	
			\"type\": \"template\",
			\"template\": {
				\"name\": \"welcomemd\",
				\"language\": {
					\"code\": \"en_US\",
					\"policy\": \"deterministic\"
				},
				\"components\": [
					{
						\"type\": \"header\",
						\"parameters\": [
							{
								\"type\": \"image\",
								\"image\": {
									\"link\": \"https://jusjumpin.in/2.jpg\"
								}
							}
						]
					}
				]
			},
			\"messaging_product\": \"whatsapp\"
		}
	}",
	CURLOPT_HTTPHEADER => array(
		'Content-Type: application/json',
		'authkey: 366198AzbYzdjpE61236900P1',
	),
	));
	$response = curl_exec($curl);
	$err=curl_error($curl);
	//curl_close($curl);
	//echo $response;
	//echo $err;
	//exit();

//$curl=curl_init();
	$status=json_decode($response);
	//print $status->status;exit();
	if($status->status!="success") {
		curl_setopt_array($curl,array(
			CURLOPT_URL=>"https://api.msg91.com/api/v2/sendsms",
			CURLOPT_RETURNTRANSFER=>true,
			CURLOPT_ENCODING=>"1",
			CURLOPT_MAXREDIRS=>10,
			CURLOPT_TIMEOUT=>30,
			CURLOPT_HTTP_VERSION=>CURL_HTTP_VERSION_1_1,
			CURLOPT_CUSTOMREQUEST=>"POST",
			CURLOPT_POSTFIELDS=>"{ \"sender\": \"JUSJMP\", \"route\": \"4\", \"country\": \"91\", \"sms\": [ { \"message\": \"".$message_det."\", \"to\": [ \"".$mobile_number."\" ] } ] }",
			CURLOPT_SSL_VERIFYHOST=>0,
			CURLOPT_SSL_VERIFYPEER=>0,
			CURLOPT_HTTPHEADER=>array(
				"authkey:366198AzbYzdjpE61236900P1",
				"content-type:application/json"
			),
		));
		$response=curl_exec($curl);
		$err=curl_error($curl);
	}	
	curl_close($curl);
	if ($err) {
		echo "cURL Error #:" . $err;
	} else {
		echo $response;
	}
}*/
function SMS_Sender($mobile_number,$message_det,$msg_name) {
	/*curl_setopt_array($curl,array(
		CURLOPT_URL=>"https://api.msg91.com/api/v2/sendsms",
		CURLOPT_RETURNTRANSFER=>true,
		CURLOPT_ENCODING=>"1",
		CURLOPT_MAXREDIRS=>10,
		CURLOPT_TIMEOUT=>30,
		CURLOPT_HTTP_VERSION=>CURL_HTTP_VERSION_1_1,
		CURLOPT_CUSTOMREQUEST=>"POST",
		CURLOPT_POSTFIELDS=>"{ \"sender\": \"JUSJMP\", \"route\": \"4\", \"country\": \"91\", \"sms\": [ { \"message\": \"".$message_det."\", \"to\": [ \"".$mobile_number."\" ] } ] }",
		CURLOPT_SSL_VERIFYHOST=>0,
		CURLOPT_SSL_VERIFYPEER=>0,
		CURLOPT_HTTPHEADER=>array(
			"authkey:366198AzbYzdjpE61236900P1",
			"content-type:application/json"
		),
	));
	$response=curl_exec($curl);
	$err=curl_error($curl);
	curl_close($curl);
	if ($err) {
		echo "cURL Error #:" . $err;
	} else {
		echo $response;
	}*/
	$mobile="91".$mobile_number;
	$curl = curl_init();

curl_setopt_array($curl, [
	CURLOPT_URL => "https://control.msg91.com/api/v5/flow/",
	CURLOPT_RETURNTRANSFER => true,
	CURLOPT_ENCODING => "",
	CURLOPT_MAXREDIRS => 10,
	CURLOPT_TIMEOUT => 30,
	CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
	CURLOPT_CUSTOMREQUEST => "POST",
	/*CURLOPT_POSTFIELDS => json_encode([
		'template_id' => $message_det,
		'short_url' => '0',
		'mobiles' => $mobile,
		'var1' => $msg_name
	]),*/
	CURLOPT_POSTFIELDS => "{\"template_id\":\"".$message_det."\", \"recipients\": [{\"mobiles\": \"".$mobile."\", \"var1\": \"".$msg_name."\"}]}",
	CURLOPT_HTTPHEADER => [
		"accept: application/json",
		"authkey: 366198AzbYzdjpE61236900P1",
		"content-type: application/json"
	],
	]);

$response = curl_exec($curl);
	$err = curl_error($curl);

curl_close($curl);

if ($err) {
		echo "cURL Error #:" . $err;
	} else {
		echo $response;
	}
}
if(isset($_POST['submfr']) && $_POST['submfr']!="" && $action=="add") {
	$bexid="";
	$flag=0;
	$d=date("Y-m-d");	
	$cardno=isset($_POST['cardno'])?addslashes(utf8_encode(trim($_POST['cardno']))):'';
	$voucher=isset($_POST['vchno'])?trim($_POST['vchno']):'';
	$mobile=isset($_POST['mobile'])?addslashes(utf8_encode(trim($_POST['mobile']))):'';
	$amobile=isset($_POST['amobile'])?addslashes(utf8_encode(trim($_POST['amobile']))):'';
	$pmode=isset($_POST['pmode'])?addslashes(utf8_encode(trim($_POST['pmode']))):'';
	$entry=$_POST['entry'];
	$name=isset($_POST['name'])?addslashes(utf8_encode(trim($_POST['name']))):'';
	$dob=isset($_POST['dob'])?dtconvert(addslashes(utf8_encode(trim($_POST['dob'])))):'';
	$pack=isset($_POST['packid'])?$_POST['packid']:'';
	if($pack=="") {
		$_SESSION['msgerror']="No acitvity is selected!";
		header("Location:home.php");
		exit();
	}
	//$accessories=isset($_POST['accessories'])?$_POST['accessories']:'';
	$t=date("h:i:s A");
	$rowpk=mysqli_fetch_array(mysqli_query($con,"select * from `activity` where `id`='".$pack."'"));
	if($rowpk['charge']<=0) {
		$respkchk=mysqli_query($con,"select * from `vouchers` where `voucher`='".$voucher."'");
		print "select * from `vouchers` where `voucher`='".$voucher."'";exit();
		if(mysqli_num_rows($respkchk)<1) {
			$_SESSION['msgerror']="Invalid voucher!";
			header("Location:home.php");
			exit();
		}
	}
	if($rowpk['fivemins']=="Yes") {
		$timegap=$rowpk['timemins']+5;
	} else { 
		$timegap=$rowpk['timemins'];
	}	
	if($rowpk['timemins']=="540") {
		$endtime="09:00:00 PM";
		$strtime=strtotime($endtime);
		$extntime="09:00:00 PM";
		$strextime=strtotime($extntime);
	} else {
		$endtime=date("h:i:s A",strtotime("+".$timegap." minute"));
		//$endtimea=date("h:i:s",strtotime("+".$timegap." minute"));
		$strtime=strtotime($endtime);
		$extntime=date("h:i:s A",strtotime($endtime."+5 minute"));
		$strextime=strtotime($extntime);
	}
	//$gst=round($rowpk['charge']*($rowpk['gst']/100));
	//$total=$rowpk['charge']+$gst;
	$totgst=100+$rowpk['gst'];
	$amount=round(($rowpk['charge']*100)/$totgst,2);
	$gst=round(($rowpk['charge']*$rowpk['gst'])/$totgst,2);
	/*$aamount=0;
	$agst=0;
	foreach($accessories as $k=>$val) {
		if($k==0) {
			$accr=$val;
			$rowpro=mysqli_fetch_array(mysqli_query($con,"select * from `product` where `id`='".$val."'"));
			$accram=$rowpro['price'];
			$aamount+=$rowpro['price'];
			$agst+=round($rowpro['price']*($rowpro['gst']/100));
		} else {
			$accr.=",".$val;
			$rowpro=mysqli_fetch_array(mysqli_query($con,"select * from `product` where `id`='".$val."'"));
			$accram.=",".$rowpro['price'];
			$aamount+=$rowpro['price'];
			$agst+=round($rowpro['price']*($rowpro['gst']/100));
		}
	}
	$net=$rowpk['charge']+$aamount+$agst;*/
	$norows=$_POST['norows'];
	$accessoriesi=isset($_POST['accessoriesi'])?$_POST['accessoriesi']:'';
	for($i=1;$i<=$norows;$i++) {
		$name="name".$i;
		$dob="dob".$i;	
		$accessoriesa="accessories".$i;	
		$name=isset($_POST[$name])?$_POST[$name]:'';
		$dob=isset($_POST[$dob])?$_POST[$dob]:'';
		//$accessories=isset($_POST[$accessoriesa])?$_POST[$accessoriesa]:'';
		$accr="";
		$accram=0;
		$aamount=0;
		$agst=0;
		$indx=$i-1;
		$accr=$accessoriesi[$indx];
		$rowpro=mysqli_fetch_array(mysqli_query($con,"select * from `product` where `id`='".$accr."'"));
		$accram=$rowpro['price'];
		//$aamount=$rowpro['price'];
		$agst+=round($accram*($rowpro['gst']/100));
		/*foreach($accessories as $k=>$val) {
			if($k==0) {
				$accr=$val;
				$rowpro=mysqli_fetch_array(mysqli_query($con,"select * from `product` where `id`='".$val."'"));
				$accram=$rowpro['price'];
				$aamount+=$rowpro['price'];
				$agst+=round($rowpro['price']*($rowpro['gst']/100));
			} else {
				$accr.=",".$val;
				$rowpro=mysqli_fetch_array(mysqli_query($con,"select * from `product` where `id`='".$val."'"));
				$accram.=",".$rowpro['price'];
				$aamount+=$rowpro['price'];
				$agst+=round($rowpro['price']*($rowpro['gst']/100));
			}
		}*/
		$net=$rowpk['charge']+$accram+$agst;
		if($name!="" && (($dob!="" && $dob!="0000-00-00" && $_SESSION['uid']!="8") or $_SESSION['uid']=="8")) {
			$res=mysqli_query($con,"select * from `customer` where ((`mobile`='".$mobile."' and `mobile`!='') or (`cardno`='".$cardno."' and `cardno`!='')) and `name`='".$name."'");
			if(mysqli_num_rows($res)<1) {
				$insert_sql_data=array('date'=>$d,
				'aby'=>$_SESSION['uid'],
				'cardno'=>$cardno,
				'pack'=>$pack,
				'mobile'=>$mobile,
				'amobile'=>$amobile,
				'name'=>$name,
				'dob'=>$dob,
				'status'=>'1'
				);
				tep_db_perform("customer",$insert_sql_data,'insert');
				$ctid=mysqli_insert_id($con);
				$flag=1;
				$rowsl=mysqli_fetch_array(mysqli_query($con,"select * from `booking` where `date`='".$d."' and `aby`='".$_SESSION['uid']."' and `serial`!='' order by `bid` desc"));
				$serial=$rowsl['serial']+1;
				$insert_sql_data=array('date'=>$d,
				'time'=>$t,
				'aby'=>$_SESSION['uid'],
				'serial'=>$serial,
				'endtime'=>$endtime,
				'strtime'=>$strtime,
				'extntime'=>$extntime,
				'strextime'=>$strextime,
				'cusref'=>$ctid,
				'pack'=>$pack,
				'accessories'=>$accr,
				'accessoriespr'=>$accram,
				'pmode'=>$pmode,
				'amount'=>$amount,
				'gst'=>$gst,
				'total'=>$rowpk['charge'],
				'aamount'=>$accram,
				'agst'=>$agst,
				'net'=>$net,
				'checkout'=>'0',
				'status'=>'1'
				);
				tep_db_perform("booking",$insert_sql_data,'insert');
				$id=mysqli_insert_id($con);
				$bexid.=",".$id;
				//$message="Dear ".$name.", welcome to Jus Jumpin. Your time is from ".$t." to ".$endtime.". Warm Regards!";
				//$message="Dear ".$rowcus['name'].", Welcome to Jus Jumpin family. It is our great pleasure to have you on board!! Packages available for celebrating your Kids Birthday Party. For details contact +91 9007086212";
				//$message="Dear ".$name.", Welcome to Jus Jumpin family. It is our great pleasure to have you on board!! Packages available for celebrating your Kids Birthday Party. For details contact +91 9007086212, Team Jus Jumpin."; 
				$message="Dear Sir, Welcome to Jus Jumpin family. It is our great pleasure to have you on board!! Packages available for celebrating your Kids Birthday Party. For details contact +91 9007086212, Team Jus Jumpin."; 
				//SMS_Wapp_Sender($mobile,$message);
				if($_SESSION['uid']=="1" || $_SESSION['uid']=="3" || $_SESSION['uid']=="5" || $_SESSION['uid']=="6") {
					//CC2/DUR/AVN/GIP
					$message="662fa70dd6fc0533c57f1753";
				} elseif($_SESSION['uid']=="7") {
					//JAMSHEDPUR
					$message="6630ca19d6fc0535d3469152";
				} elseif($_SESSION['uid']=="8") {
					//ABC
					$message="664213abd6fc0528e350d201";
				} elseif($_SESSION['uid']=="19") {
					//SURAT
					$message="662b595fd6fc05711965b032";
				} elseif($_SESSION['uid']=="20" || $_SESSION['uid']=="28") {
					//NAGPUR/UDAYPUR
					$message="663264a2d6fc054e3f414f22";
				} elseif($_SESSION['uid']=="26") {
					//SPECTRUM
					$message="6630c9f0d6fc053cc977e212";
				} elseif($_SESSION['uid']=="34") {
					//AXIS
					$message="666db96fd6fc05598a190582";
				} else {
					//DELHI MAHAGUN
					$message="64aec541d6fc0572e1698303";
				}  
				SMS_Sender($mobile,$message,$name);
			}	
		}	 
	}
	if($entry!="") {	
		/*else {
			$row=mysqli_fetch_object($res);
			$id=$row->cid;
			if($name!="") {
				$insert_sql_data=array('name'=>$name);
				tep_db_perform("customer",$insert_sql_data,'update',"cid='".$id."'");
			}	
		}*/
		foreach($entry as $val) {
			//$voucher="voucher".$val;
			//$voucher=isset($_POST['vchno'])?$_POST['vchno']:'';
			$rowcust=mysqli_fetch_array(mysqli_query($con,"select * from `customer` where `cid`='".$val."'"));
			if($_SESSION['uid']=="43" && $rowcust['guest']!="Yes") {
				$_SESSION['msgerror']="Guest is not registered! Please check.";
				header("Location:home.php");
				exit();
			}
			$subvval="subvoucher".$val;
			$subvoucher=isset($_POST[$subvval])?$_POST[$subvval]:'';
			$otpv="otp".$val;
			$otp=isset($_POST[$otpv])?$_POST[$otpv]:'';
			if($subvoucher!="" && $subvoucher!="None") {
				$rowvc=mysqli_fetch_array(mysqli_query($con,"select * from `vouchers` where `id`='".$subvoucher."'"));
				if($rowvc['otp']!=$otp) {
					$_SESSION['msgerror']="Invalid OTP!";
					header("Location:home.php");
					exit();
				}
				$rowpk=mysqli_fetch_array(mysqli_query($con,"select * from `activity` where `id`='".$rowvc['activity']."'"));
				$pack=$rowvc['activity'];
				if($rowpk['fivemins']=="Yes") {
					$timegap=$rowpk['timemins']+5;
				} else { 
					$timegap=$rowpk['timemins'];
				}	
				$endtime=date("h:i:s A",strtotime("+".$timegap." minute"));
				$strtime=strtotime($endtime);
				$extntime=date("h:i:s A",strtotime($endtime."+5 minute"));
				$strextime=strtotime($extntime);
				//$gst=round($rowpk['charge']*($rowpk['gst']/100));
				//$total=$rowpk['charge']+$gst;
				//$totgst=100+$rowpk['gst'];
				//$amount=round(($rowpk['charge']*100)/$totgst,2);
				//$gst=round(($rowpk['charge']*$rowpk['gst'])/$totgst,2);
				$accr="";
				$accram=0;
				$amount=0;
				$gst=0;
				$aamount=0;
				$agst=0;
				$totalc=0;
				mysqli_query($con,"update `vouchers` set `status`='0' where `id`='".$subvoucher."'");

$accessoriesa="accessories".$val;	
				$accr=isset($_POST[$accessoriesa])?$_POST[$accessoriesa]:'';
				$rowpro=mysqli_fetch_array(mysqli_query($con,"select * from `product` where `id`='".$accr."'"));
				$accram=$rowpro['price'];
				//$aamount+=$rowpro['price'];
				$agst+=round($accram*($rowpro['gst']/100));
				$net=$totalc+$accram+$agst;
				$_SESSION['duplblock']=strtotime("now").rand(11111,99999);
				$rowsl=mysqli_fetch_array(mysqli_query($con,"select * from `booking` where `date`='".$d."' and `aby`='".$_SESSION['uid']."' and `serial`!='' order by `bid` desc"));
				$serial=$rowsl['serial']+1;
				$insert_sql_data=array('date'=>$d,
				'time'=>$t,
				'aby'=>$_SESSION['uid'],
				'serial'=>$serial,
				'endtime'=>$endtime,
				'strtime'=>$strtime,
				'cusref'=>$val,
				'voucher'=>$voucher,
				'subvoucher'=>$subvoucher,
				'pack'=>$pack,
				'accessories'=>$accr,
				'accessoriespr'=>$accram,
				'pmode'=>$pmode,
				'amount'=>$amount,
				'gst'=>$gst,
				'total'=>$totalc,
				'aamount'=>$accram,
				'agst'=>$agst,
				'net'=>$net,
				'checkout'=>'0',
				'status'=>'1'
				);
				tep_db_perform("booking",$insert_sql_data,'insert');
				$id=mysqli_insert_id($con);
				$bexid.=",".$id;
			}
			$rowcus=mysqli_fetch_array(mysqli_query($con,"select * from `customer` where `cid`='".$val."'"));
			//$message="Dear ".$rowcus['name'].", welcome to Jus Jumpin. Your time is from ".$t." to ".$endtime.". Warm Regards!";
			//$message="Dear ".$rowcus['name'].", Welcome to Jus Jumpin family. It is our great pleasure to have you on board!! Packages available for celebrating your Kids Birthday Party. For details contact +91 9007086212";
			//$message="Dear ".$rowcus['name'].", Welcome to Jus Jumpin family. It is our great pleasure to have you on board!! Packages available for celebrating your Kids Birthday Party. For details contact +91 9007086212, Team Jus Jumpin."; 
			$message="Dear Sir, Welcome to Jus Jumpin family. It is our great pleasure to have you on board!! Packages available for celebrating your Kids Birthday Party. For details contact +91 9007086212, Team Jus Jumpin."; 
			//SMS_Wapp_Sender($mobile,$message);
			if($_SESSION['uid']=="1" || $_SESSION['uid']=="3" || $_SESSION['uid']=="5" || $_SESSION['uid']=="6") {
				//CC2/DUR/AVN/GIP
				$message="662fa70dd6fc0533c57f1753";
			} elseif($_SESSION['uid']=="7") {
				//JAMSHEDPUR
				$message="6630ca19d6fc0535d3469152";
			} elseif($_SESSION['uid']=="8") {
				//ABC
				$message="664213abd6fc0528e350d201";
			} elseif($_SESSION['uid']=="19") {
				//SURAT
				$message="662b595fd6fc05711965b032";
			} elseif($_SESSION['uid']=="20" || $_SESSION['uid']=="28") {
				//NAGPUR/UDAYPUR
				$message="663264a2d6fc054e3f414f22";
			} elseif($_SESSION['uid']=="26") {
				//SPECTRUM
				$message="6630c9f0d6fc053cc977e212";
			} elseif($_SESSION['uid']=="34") {
				//AXIS
				$message="666db96fd6fc05598a190582";
			} else {
				//DELHI MAHAGUN //PUNE
				$message="64aec541d6fc0572e1698303";
			}  
			SMS_Sender($mobile,$message,$rowcus['name']);
		}	
	}
	unset($_SESSION['duplblock']);
	if($entry!="" || $flag==1) {	
		$_SESSION['msgsu']="Booking is done successfully.";
		header("Location:home.php?pop=true&bexid=".$bexid);
		exit();
	} else {
		$_SESSION['msgerror']="No member is selected or DOB is missing!";
		header("Location:home.php");
		exit();
	}	
}
if(isset($_GET['action']) && $_GET['action']=='active') {
	$cid=$_GET['cid'];
	$goto="go".$_GET['go'];
	$mobile=$_GET['mob'];
	$row=mysqli_fetch_array(mysqli_query($con,"select * from `customer` where `mobile`='".$mobile."'"));
	//$message="Dear ".$row['name'].", Welcome to Jus Jumpin family. It is our great pleasure to have you on board!! Packages available for celebrating your Kids Birthday Party. For details contact +91 9007086212";
	//$message="Dear ".$row['name'].", Welcome to Jus Jumpin family. It is our great pleasure to have you on board!! Packages available for celebrating your Kids Birthday Party. For details contact +91 9007086212, Team Jus Jumpin."; 
	$message="Dear Sir, Welcome to Jus Jumpin family. It is our great pleasure to have you on board!! Packages available for celebrating your Kids Birthday Party. For details contact +91 9007086212, Team Jus Jumpin."; 
	$message=urlencode($message);
	//SMS_Wapp_Sender($mobile,$message);
	if($_SESSION['uid']=="1" || $_SESSION['uid']=="3" || $_SESSION['uid']=="5" || $_SESSION['uid']=="6") {
		//CC2/DUR/AVN/GIP
		$message="662fa70dd6fc0533c57f1753";
	} elseif($_SESSION['uid']=="7") {
		//JAMSHEDPUR
		$message="6630ca19d6fc0535d3469152";
	} elseif($_SESSION['uid']=="8") {
		//ABC
		$message="664213abd6fc0528e350d201";
	} elseif($_SESSION['uid']=="19") {
		//SURAT
		$message="662b595fd6fc05711965b032";
	} elseif($_SESSION['uid']=="20" || $_SESSION['uid']=="28") {
		//NAGPUR/UDAYPUR
		$message="663264a2d6fc054e3f414f22";
	} elseif($_SESSION['uid']=="26") {
		//SPECTRUM
		$message="6630c9f0d6fc053cc977e212";
	} elseif($_SESSION['uid']=="34") {
		//AXIS
		$message="666db96fd6fc05598a190582";
	} else {
		//DELHI MAHAGUN
		$message="64aec541d6fc0572e1698303";
	}  
	SMS_Sender($mobile,$message,$row['name']);
	mysqli_query($con,"update `booking` set `checkout`='1' where `bid`='".$cid."'");
	//$_SESSION['msgsu']="Status is updated successfully.";
	header("Location:home.php#".$goto);
	exit();
} 
if(isset($_GET['action']) && $_GET['action']=='inactive') {
	$cid=$_GET['cid'];
	$goto="go".$_GET['go'];
	mysqli_query($con,"update `booking` set `status`='0' where `bid`='".$cid."'");
	//$_SESSION['msgsu']="Status is updated successfully.";
	header("Location:home.php#".$goto);
	exit();
} 
if($_REQUEST['bid']!="" && $_REQUEST['upgrade']=="true") {
	$d=date("Y-m-d");	
	$row=mysqli_fetch_array(mysqli_query($con,"select * from `booking` where `bid`='".$_REQUEST['bid']."'"));
	$rowpk=mysqli_fetch_array(mysqli_query($con,"select * from `activity` where `aby`='".$_SESSION['uid']."' and `atype`='Daily' and `timeac`='60' and `status`='1'"));
	$pack=$rowpk['id'];
	$totgst=100+$rowpk['gst'];
	$amount=round(($rowpk['charge']*100)/$totgst,2);
	$gst=round(($rowpk['charge']*$rowpk['gst'])/$totgst,2);
	$net=$rowpk['charge']+$row['aamount']+$row['agst'];
	if($rowpk['fivemins']=="Yes") {
		$timegap=$rowpk['timemins']+5;
	} else { 
		$timegap=$rowpk['timemins'];
	}	
	$strttime = strtotime($row['time']);
	$endtime=date("h:i:s A", strtotime("+".$timegap." minutes", $strttime));
	$strtime=strtotime($endtime);
	$timegapex=$timegap+5;
	$extntime=date("h:i:s A", strtotime("+".$timegapex." minutes", $strttime));
	$strextime=strtotime($extntime);
	$rowsl=mysqli_fetch_array(mysqli_query($con,"select * from `booking` where `date`='".$d."' and `aby`='".$_SESSION['uid']."' and `serial`!='' order by `bid` desc"));
	$serial=$rowsl['serial']+1;
	$insert_sql_data=array('date'=>$row['date'],
	'time'=>$row['time'],
	'aby'=>$_SESSION['uid'],
	'serial'=>$serial,
	'endtime'=>$endtime,
	'strtime'=>$strtime,
	'extntime'=>$extntime,
	'strextime'=>$strextime,
	'cusref'=>$row['cusref'],
	'pack'=>$pack,
	'accessories'=>$row['accessories'],
	'accessoriespr'=>$row['accessoriespr'],
	'pmode'=>$row['pmode'],
	'amount'=>$amount,
	'gst'=>$gst,
	'total'=>$rowpk['charge'],
	'aamount'=>$row['aamount'],
	'agst'=>$row['agst'],
	'net'=>$net,
	'checkout'=>'0',
	'status'=>'1'
	);
	tep_db_perform("booking",$insert_sql_data,'insert');
	$id=mysqli_insert_id($con);
	$bexid.=",".$id;
	mysqli_query($con,"update `booking` set `status`='0', `reason`='Upgradation to 1 Hr' where `bid`='".$_REQUEST['bid']."'");
	header("Location:home.php?pop=true&bexid=".$bexid);
	exit();
}
if($_REQUEST['bid']!="" && $_REQUEST['upgradetwo']=="true") {
	$d=date("Y-m-d");	
	$row=mysqli_fetch_array(mysqli_query($con,"select * from `booking` where `bid`='".$_REQUEST['bid']."'"));
	$rowpk=mysqli_fetch_array(mysqli_query($con,"select * from `activity` where `aby`='".$_SESSION['uid']."' and `atype`='Daily' and `timeac`='120' and `status`='1'"));
	$pack=$rowpk['id'];
	$totgst=100+$rowpk['gst'];
	$amount=round(($rowpk['charge']*100)/$totgst,2);
	$gst=round(($rowpk['charge']*$rowpk['gst'])/$totgst,2);
	$net=$rowpk['charge']+$row['aamount']+$row['agst'];
	if($rowpk['fivemins']=="Yes") {
		$timegap=$rowpk['timemins']+5;
	} else { 
		$timegap=$rowpk['timemins'];
	}	
	$strttime = strtotime($row['time']);
	$endtime=date("h:i:s A", strtotime("+".$timegap." minutes", $strttime));
	$strtime=strtotime($endtime);
	$timegapex=$timegap+5;
	$extntime=date("h:i:s A", strtotime("+".$timegapex." minutes", $strttime));
	$strextime=strtotime($extntime);
	$rowsl=mysqli_fetch_array(mysqli_query($con,"select * from `booking` where `date`='".$d."' and `aby`='".$_SESSION['uid']."' and `serial`!='' order by `bid` desc"));
	$serial=$rowsl['serial']+1;
	$insert_sql_data=array('date'=>$row['date'],
	'time'=>$row['time'],
	'aby'=>$_SESSION['uid'],
	'serial'=>$serial,
	'endtime'=>$endtime,
	'strtime'=>$strtime,
	'extntime'=>$extntime,
	'strextime'=>$strextime,
	'cusref'=>$row['cusref'],
	'pack'=>$pack,
	'accessories'=>$row['accessories'],
	'accessoriespr'=>$row['accessoriespr'],
	'pmode'=>$row['pmode'],
	'amount'=>$amount,
	'gst'=>$gst,
	'total'=>$rowpk['charge'],
	'aamount'=>$row['aamount'],
	'agst'=>$row['agst'],
	'net'=>$net,
	'checkout'=>'0',
	'status'=>'1'
	);
	tep_db_perform("booking",$insert_sql_data,'insert');
	$id=mysqli_insert_id($con);
	$bexid.=",".$id;
	mysqli_query($con,"update `booking` set `status`='0', `reason`='Upgradation to 2 Hrs' where `bid`='".$_REQUEST['bid']."'");
	header("Location:home.php?pop=true&bexid=".$bexid);
	exit();
}
if($_REQUEST['bid']!="" && $_REQUEST['socks']=="true") {
	$d=date("Y-m-d");	
	$row=mysqli_fetch_array(mysqli_query($con,"select * from `booking` where `bid`='".$_REQUEST['bid']."'"));
	$rowsc=mysqli_fetch_array(mysqli_query($con,"select * from `product` where `id`='".$_REQUEST['scid']."'"));
	$accr=$_REQUEST['scid'];
	$samount=$rowsc['price'];
	$net=$row['net']+$samount;
	/*if($_SESSION['uid']==8) {
		$accr=38;
		$samount=60;
		$net=$row['net']+$samount;
	} else {
		$accr=19;
		$samount=30;
		$net=$row['net']+$samount;
	}*/
	$insert_sql_data=array('accessories'=>$accr,
	'accessoriespr'=>$samount,
	'aamount'=>$samount,
	'net'=>$net
	);
	tep_db_perform("booking",$insert_sql_data,'update',"bid=".$_REQUEST['bid']);
	$bexid.=",".$_REQUEST['bid'];
	header("Location:home.php?pop=true&bexid=".$bexid);
	exit();
}
if($_REQUEST['cid']!="" && $_REQUEST['extension']=="true") {
	$row=mysqli_fetch_array(mysqli_query($con,"select * from `customer` where `cid`='".base64_decode($_REQUEST['cid'])."'"));
}
include("includes/headermain.php"); 
?>
<script language="javascript">
function del(id) {
	var fd=confirm("Are you sure to delete this entry?");
	if(fd==true) {
		location.href="home.php?id="+id+"&delete=yes";
	}	
}
function inactive(aa,bb) {
	location.href="home.php?cid="+aa+"&go="+bb+"&action=inactive";
} 
function active(aa,bb,cc) {
	location.href="home.php?cid="+aa+"&go="+bb+"&mob="+cc+"&action=active";
}
function validateac() {
	var pack=document.mform.packid.value;
	var name=document.mform.name.value;
	var dob=document.mform.dob.value;
	if(pack=="") {
		document.getElementById("msgerror").innerHTML="Please select package!";
		return false;
	}
	if(name!="" && dob=="") {
		document.getElementById("msgerror").innerHTML="Please select DOB!";
		return false;
	}
}
function addRow(tableID) {
    var table = document.getElementById(tableID);
    var rowcount = table.rows.length;
    var rowcounta = document.getElementById("norows").value;
    var rcount = parseInt(rowcounta) + 1;
    var row = table.insertRow(rowcount);
    var colCount = table.rows[0].cells.length;
    for (var i = 0; i < colCount; i++) {
        if (i == 0) {
            var tname = "chk" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
			newcell.align = "right";
            switch (newcell.childNodes[0].type) {
                case "text":
                    newcell.childNodes[0].value = "";
                    break;
                case "checkbox":
                    newcell.childNodes[0].checked = false;
                    break;
                case "select":
                    newcell.childNodes[0].selectedIndex = 0;
                    break;
            }
            newcell.childNodes[0].name = tname;
        }
        if (i == 1) {
            var tname = "name" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
            switch (newcell.childNodes[0].type) {
                case "text":
                    newcell.childNodes[0].value = "";
                    break;
                case "checkbox":
                    newcell.childNodes[0].checked = false;
                    break;
                case "select":
                    newcell.childNodes[0].selectedIndex = 0;
                    break;
            }
            newcell.childNodes[1].name = tname;
            newcell.childNodes[1].id = tname;
			//newcell.childNodes[0].focus();
        }
		if (i == 2) {
            var tname = "dob" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
            switch (newcell.childNodes[0].type) {
                case "text":
                    newcell.childNodes[0].value = "";
                    break;
				case "date":
                    newcell.childNodes[0].value = "";
                    break;
                case "checkbox":
                    newcell.childNodes[0].checked = false;
                    break;
                case "select":
                    newcell.childNodes[0].selectedIndex = 0;
                    break;
            }
            newcell.childNodes[1].name = tname;
            newcell.childNodes[1].id = tname;
			//newcell.childNodes[0].focus();
        }
		if (i == 3) {
            var tname = "accessories" + rcount;
            var newcell = row.insertCell(i);
            newcell.innerHTML = table.rows[0].cells[i].innerHTML;
            switch (newcell.childNodes[0].type) {
                case "text":
                    newcell.childNodes[0].value = "";
                    break;
                case "checkbox":
                    newcell.childNodes[0].checked = false;
                    break;
                case "select":
                    newcell.childNodes[0].selectedIndex = 0;
                    break;
            }
            //newcell.childNodes[0].name = tname;
            //newcell.childNodes[0].id = tname;
			//newcell.childNodes[0].focus();
        }
    }
    document.getElementById("norows").value = rcount;
}
function deleteRow(tableID) {
    try {
        var table = document.getElementById(tableID);
        var rowCount = table.rows.length;
        for (var i = 0; i < rowCount; i++) {
            var row = table.rows[i];
            var chkbox = row.cells[0].childNodes[0];
            if (null != chkbox && true == chkbox.checked) {
                if (rowCount <= 1) {
                    alert("Cannot delete all the rows.");
                    break;
                }
                table.deleteRow(i);
                rowCount--;
                i--;
            }
        }
    } catch (e) {
        alert(e);
    }
}
/*$("input").on("paste",function(e){
    $("#chkotid").focus();
});*/
function upgradeone(val) {
	var conf=confirm("Do you want to upgrade to 1 hr?");
	if(conf==true) {
		location.href="home.php?bid="+val+"&upgrade=true";
	}
}
function upgradetwo(val) {
	var conf=confirm("Do you want to upgrade to 2 hrs?");
	if(conf==true) {
		location.href="home.php?bid="+val+"&upgradetwo=true";
	}
}
</script>
<?php if($_REQUEST['pop']=="true") { ?>
<script type='text/javascript'>
$(function() {
	window.open('receipt.php?bexid=<?php print $_REQUEST['bexid']; ?>','receipt','width=400,height=700');
});	
</script>
<?php } ?>
<script type='text/javascript'>
/*$(function() {
	document.getElementById("chkotid").focus();
});*/
function printrc(val) {
	window.open('receipt.php?bexid='+val,'receipt','width=400,height=700');
}
/*function disablebocde() {
	document.getElementById("chkotid").disabled=true;
}
function bcodechkout() {
	//location.href='checkoutbocd.php';
	var bid=document.getElementById("chkotid").value;
	if(bid!="") {
		window.open('checkoutbocd.php?bid='+bid,'chkout','width=50,height=50');
	}
	document.getElementById("chkotid").focus();
}*/
</script>
<body class="sticky-header left-side-collapsed" onLoad="fetchcurrenthome();">
    <section>
		<?php include("includes/leftpanel.php"); ?>
		<div class="main-content">
			<?php include("includes/header.php"); ?>
			<div id="page-wrapper">
				<div class="graphs">
					<div class="col_3">
						<?php if($_SESSION['utype']=="store") { ?><h3 class="blank1">Billing Area</h3><?php } ?>
						<div class="tabls">
							<div id="uform" class="bs-bg spbg" data-example-id="contextual-table">
								<?php if($_SESSION['utype']=="store") { ?>
									<div class="col-md-6">
										<div class="msgerror" id="msgerror"><?php print $_SESSION['msgerror']; $_SESSION['msgerror']=''; ?></div>
										<div class="msuccess"><?php print $_SESSION['msgsu']; $_SESSION['msgsu']=''; ?></div>
										<form name="mform" action="#" method="POST" enctype="multipart/form-data" onSubmit="return validateac();">
										<input type="hidden" name="editid" value="<?php print $editid; ?>">
										<input type="hidden" name="action" value="<?php print $action; ?>">
										<table class="table">
											<tr>
												<td align="right" valign="top" width="30%">Date:</td> 
												<td align="left">
													<?php print date("d-m-Y"); ?>
												</td>
											</tr>
											<tr>
												<td align="right" valign="top" width="30%">Card No.:</td> 
												<td align="left">
													<input type="text" name="cardno" id="cardno" class="largeinput" value="<?php print $row['cardno']; ?>" maxlength="10" onChange="fetchcustomer();fetchmobile();" onKeyDown="fetchcustomer();fetchmobile();fetchactivityv();" onKeyUp="fetchcustomer();fetchmobile();fetchactivityv();" onBlur="fetchcustomer();fetchmobile();fetchactivityv();">
												</td>
											</tr>
											<tr>
												<td align="right" valign="top" width="30%">Voucher No.:</td> 
												<td align="left">
													<input type="text" name="vchno" id="vchno" class="largeinput" onChange="fetchcustomerv();" onKeyDown="();" onKeyUp="fetchcustomerv();" onBlur="fetchcustomerv();">&nbsp;<a href="addvoucher.php" target="_new">Add</a>
												</td>
											</tr>
											<tr>
												<td align="right" valign="top" width="30%"><span>*</span>Mobile No.:</td> 
												<td align="left">
													<?php
													if($_REQUEST['mobile']!="") {
														$mobile=$_REQUEST['mobile'];
													} else {
														$mobile=$row['mobile'];
													}
													?>
													<input type="text" name="mobile" id="mobile" class="largeinput" value="<?php print $mobile; ?>" minlength="10" maxlength="10" required onChange="fetchcustomer();" onKeyDown="fetchcustomer();" onKeyUp="fetchcustomer();" onBlur="fetchcustomer();" autofocus>&nbsp;<a href="redeemhome.php" target="_new">Redeem</a>
												</td>
											</tr>
											<tr>
												<td align="right" valign="top" width="30%"><span></span>Alternate Mobile No.:</td> 
												<td align="left">
													<input type="text" name="amobile" id="amobile" class="largeinput" value="<?php print $amobile; ?>" maxlength="10" onChange="fetchcustomer();" onKeyDown="fetchcustomer();" onKeyUp="fetchcustomer();" onBlur="fetchcustomer();">
												</td>
											</tr>
											<tr>
												<td align="right" valign="top" width="30%"><span>*</span>Payment Mode:</td> 
												<td align="left">
													<select name="pmode" class="largeinput" required>
														<option value="">Select
														<option value="Cash">Cash
														<option value="Card">Card
														<option value="UPI">UPI
													</select>
												</td>
											</tr>
											<tr>
												<td colspan="2">
													<div id="entrydet">
														<?php
														if($_REQUEST['cid']!="" && $_REQUEST['extension']=="true") {
														?>
															<table class="table">
																<?php
																$res=mysqli_query($con,"select * from `customer` where `cid`='".base64_decode($_REQUEST['cid'])."'");
																while($row=mysqli_fetch_array($res)) {
																?>
																	<tr class="bglight">
																		<td align="right" valign="top" width="30%">&nbsp;</td> 
																		<td>
																			<div class="floatleft"><input type="checkbox" name="entry[]" value="<?php print $row['cid']; ?>" onClick="findbltotal();"></div>
																			<div class="floatleft mltft"><?php print ucwords(strtolower($row['name'])); ?>&nbsp;(DOB: <?php print dtconvert($row['dob']); ?>)</div>
																			<div class="cleaner h5a"></div>
																			<select name="accessories<?php print $row['cid']; ?>" id="accessories<?php print $row['cid']; ?>" class="prbox" onChange="findbltotal();">	
																				<option value="">Select
																				<?php
																				$resa=mysqli_query($con,"select * from `product` where `aby`='".$_SESSION['uid']."' and `status`='1'");
																				while($rowa=mysqli_fetch_array($resa)) {
																				?>
																					<option value="<?php print $rowa['id'] ?>"><?php print ucwords(strtolower($rowa['name'])); ?>
																				<?php } ?>
																			</select>
																		</td>
																	</tr>	
																<?php } ?>
															</table>	
														<?php } ?>
													</div>
												</td>
											</tr>
											<?php if($_REQUEST['extension']!="true" && $_SESSION['uid']!="43") { ?>
												<tr>
													<td width="30%" align="right">
														<div id="newenscadd"><input type="button" value="+" onClick="addRow(&#39;dataTable&#39;)" class="subbutblue"></div>
													</td>
													<td>&nbsp;</td>
												</tr> 
												<tr>
													<td colspan="2" align="center">
														<div id="newensc">
															<table id="dataTable" width="100%" border="0">
																<tr>
																	<td width="30%" align="right">
																		<input type="checkbox" name="chk1" onClick="deleteRow('dataTable');"> <span><strong>-</strong></span>
																	</td>
																	<td>
																		<?php
																		$dc=date("Y-m-d");
																		$exdate=date("Y-m-d", strtotime($dc  . "-180 day"));
																		?>
																		<input type="text" name="name1" id="name1" class="largeinput" maxlength="100" onBlur="findbltotal();" placeholder="Enter Your Name">
																	</td>
																	<td>
																		<input type="date" name="dob1" id="dob1" class="largeinputa" maxlength="30" max="<?php print $exdate; ?>">
																		<div class="cleaner h5a"></div>
																		<select name="accessoriesi[]" class="prbox" onChange="findbltotal();">	
																			<option value="">Select
																			<?php
																			$res=mysqli_query($con,"select * from `product` where `aby`='".$_SESSION['uid']."' and `status`='1'");
																			while($row=mysqli_fetch_array($res)) {
																			?>
																				<option value="<?php print $row['id'] ?>"><?php print ucwords(strtolower($row['name'])); ?> (<?php print $row['price']; ?>)
																			<?php } ?>
																		</select>
																	</td>
																</tr>
															</table>
															<input type="hidden" name="norows" id="norows" value="1">
														</div>
													</td>
												</tr>
											<?php } ?>	
											<?php /*?><tr>
												<td align="right" valign="top" width="30%">Name:</td> 
												<td align="left">
													<input type="text" name="name" id="name" class="largeinput" value="<?php print $row['name']; ?>" maxlength="100">
												</td>
											</tr>
											<tr>
												<td align="right" valign="top" width="30%">DOB:</td> 
												<td align="left">
													<input type="text" name="dob" id="eventstartdate" class="largeinput" value="<?php print $row['dob']; ?>" maxlength="100">
													<span id="cal"><img src="images/calendar.jpg" alt="" class="cusstl"></span>
													<script type="text/javascript">
														var cal=new Zapatec.Calendar.setup({
															inputField:"eventstartdate",
															ifFormat:"%d-%m-%Y",
															button:"cal",
															showsTime:false
														});
													</script>
												</td>
											</tr><?php */?>
											<tr>
												<td>&nbsp;</td> 
												<td align="left">
													<div id="pack"></div>
													<input type="hidden" name="packid" id="packid">
												</td>
											</tr>
											<?php /*?><tr>
												<td align="right" valign="top" width="30%"></td> 
												<td align="left">
													<select name="accessories[]" multiple style="height:100px;width:300px;">	
														<option value="">Select
														<?php
														$res=mysqli_query($con,"select * from `product` where `status`='1'");
														while($row=mysqli_fetch_array($res)) {
														?>
															<option value="<?php print $row['id'] ?>"><?php print $row['name'] ?>
														<?php } ?>
													</select>
												</td>
											</tr><?php */?>
											<tr>
												<td>&nbsp;</td> 
												<td>
													<div id="totalam" class="fntbold"></div>
												</td>
											</tr>
											<tr>
												<td align="center" colspan="2">
													<input type="button" value="Calculate" id="clc" name="clc" class="subbut" onClick="findbltotal()">
													<input type="button" value="Refresh" id="refshr" name="refshr" class="subbut" onClick="location.href='home.php'">
													<input type="reset" value="Reset" id="res">
													<input type="submit" value="Submit" id="submfr" name="submfr" class="subbut">
												</td>
											</tr>
										</table>
										</form>
									</div>
									<div class="col-md-6">
										<?php /* ?><select name="category" class="largeinputsp" required onChange="fetchactivity(this.value);">
											<option value="">Select
											<?php
											$res=mysqli_query($con,"select * from `category` where `status`='1'");
											while($row=mysqli_fetch_array($res)) {
											?>
												<option value="<?php print $row['id']; ?>"><?php print ucwords(strtolower($row['name'])); ?>
											<?php } ?>	
										</select>
										<div class="cleaner h10"></div><?php */ ?>
										<div id="activity">	
											<?php
											$tm=date("H:i:s");
											$sql="select * from `activity` where `aby`='".$_SESSION['uid']."' and `status`='1'";
											if($_REQUEST['extension']=="true") {
												$sql.=" and `atype`='Extension'";
											} else {
												$sql.=" and `atype`='Daily'";
											}
											if($_SESSION['uid']=="8") {
												if($tm>='20:30:00') {
													$sql.=" and (`tafter`='Yes' or `tafter`='')";
												} else {
													$sql.=" and `tafter`=''";
												}
											}
											if($_SESSION['uid']=="38") {
												if($tm>='21:15:00') {
													$sql.=" and (`tafter`='Yes' or `tafter`='')";
												} else {
													$sql.=" and `tafter`=''";
												}
											}
											$res=mysqli_query($con,$sql);
											while($row=mysqli_fetch_array($res)) {
											?>
												<a hrfef="#" class="cusstl" onClick="fetchdata('<?php print $row['id']; ?>');return false;">
													<div class="col-md-4 acbox smalltxt">
														<div class="acboxtm"><?php print $row['timeac']; ?>&nbsp;<?php print $row['timeunit']; ?>&nbsp;(<?php print $row['name']; ?>)</div>
														<img src="images/logo.png" alt="Jusjumping" height="50"><br>
														<div class="acboxam">Rs. <?php print $row['charge']; ?></div>
													</div>
												</a>
											<?php	
											}
											?>
										</div>
									</div>	
									<div class="cleaner h40"></div>
									 
								<?php } if($_SESSION['utype']!="mall" && $_SESSION['utype']!="opmng") { ?>	
									<div id="centries">
										<table class="table">
											<thead>
												<tr>
													<th>Sl.</th>
													<th>Details</th>
													<th>Duration</th>
													<th>Options</th> 
													<th>Status</th> 
												</tr>
											</thead>
											<tbody>
												<?php
												$count=1;
												$d=date("Y-m-d");
												$sqlashis="select * from `booking` where `status`='1' and `date`='".$d."'";
												if($_SESSION['utype']=="store" || $_SESSION['utype']=="mall") {
													$sqlashis.=" and `aby`='".$_SESSION['uid']."'";
												}
												$sqlashis.=" order by `bid` desc";
												$resshis=mysqli_query($con,$sqlashis);
												if(mysqli_num_rows($resshis)>=1) {
													//$count=mysqli_num_rows($resshis);
													while($rowashis=mysqli_fetch_array($resshis)) {
														$ctr=strtotime(date("h:i:s A"));
														$rowcus=mysqli_fetch_array(mysqli_query($con,"select * from `customer` where `cid`='".$rowashis['cusref']."'"));
														$rowpk=mysqli_fetch_array(mysqli_query($con,"select * from `activity` where `id`='".$rowashis['pack']."'"));
														$inv=$rowashis['serial']%50;
														$chrid=floor($rowashis['serial']/50)+97;
														$chr=chr($chrid);
														$invid=strtoupper($chr).$inv;
												?>
														<tr class="<?php echo ++$flag%2==0?"active":"success";?>" onMouseOver="this.className='info'" onMouseOut="this.className='<?php echo $flag%2==0?"active":"success";?>'" id="go<?php print $count; ?>">
															<td><?php print $invid; ?></td>
															<td>
																<?php if($rowcus['name']) { ?><strong>Name:</strong> <?php print ucwords(strtolower(utf8_encode(stripslashes($rowcus['name'])))); ?><br><?php } ?>
																<strong>Mobile No.:</strong> <?php if($_SESSION['uid']=='20' && $rowashis['checkout']=="1") { ?>xxxxxxxxxx<?php } else { ?><?php print $rowcus['mobile']; ?><?php } ?><br>
																<?php if($rowashis['subvoucher']!="") { ?>
																	Voucher: <?php print $rowv['voucher']; ?>
																<?php } else { ?>	
																	<strong>Package:</strong> <?php print strtoupper($rowpk['name'])." - ".$rowpk['timeac']." ".strtoupper($rowpk['timeunit'])." - Rs.".$rowpk['charge']; ?>
																<?php } ?>	
															</td>
															<td>
																<strong>Date:</strong> <?php print dtconvert($rowashis['date']); ?><br>
																<strong>Time:</strong> <?php print $rowashis['time']; ?> - <?php print $rowashis['endtime']; ?>
																<?php 
																if($rowashis['pcount']>1) {
																?>
																	<br><span class="msgerror"><strong>Duplicate Print: <?php print --$rowashis['pcount']; ?></strong></span>
																<?php 
																} 
																if($rowashis['aamount']<=0 && $_SESSION['utype']=="store") { 
																	$resprsc=mysqli_query($con,"select * from `product` where `aby`='".$_SESSION['uid']."'");
																	while($rowprsc=mysqli_fetch_array($resprsc)) {	
																?>
																	<br><a href="home.php?bid=<?php print $rowashis['bid']; ?>&socks=true&scid=<?php print $rowprsc['id']; ?>">Add Socks (<?php print $rowprsc['price']; ?>)</a>
																<?php } } ?>	
															</td>
															<td>
																<?php if($_SESSION['utype']=="store") { ?>
																	<?php// if($rowashis['printst']!="1" && $_SESSION['utype']!="superadmin") { ?><a href="#" onClick="printrc('<?php print $rowashis['bid']; ?>');return false;">Print</a>&nbsp;&nbsp;&nbsp;&nbsp;<?php //} ?>
																	<?php if($rowpk['timeac']=="30") { ?>
																		<a href="javascript:void();" onClick="upgradeone('<?php print $rowashis['bid']; ?>')"><strong>Upgrade 1 Hr</strong></a>&nbsp;&nbsp;&nbsp;&nbsp;
																	<?php } if($_SESSION['uid']=="38" && $rowpk['timeac']<"120" && $rowashis['subvoucher']=="") { ?>
																		<a href="javascript:void();" onClick="upgradetwo('<?php print $rowashis['bid']; ?>')"><strong>Upgrade 2 Hr</strong></a>&nbsp;&nbsp;&nbsp;&nbsp;
																	<?php } if($_SESSION['uid']!="38") { ?>
																		<a href="home.php?cid=<?php print base64_encode($rowashis['cusref']); ?>&extension=true">Extension</a>&nbsp;&nbsp;&nbsp;&nbsp;
																<?php } } ?>	
																<?php if($rowashis['checkout']=="0") { ?>
																	<?php /*?><a href="#" onClick="active('<?php print $rowashis['bid']; ?>','<?php print $count; ?>','<?php print $rowcus['mobile']; ?>');return false;"><strong>Checkout</strong></a><?php */?><a href="checkout.php?bid=<?php print $rowashis['bid']; ?>&page=home"><strong>Checkout</strong></a>&nbsp;&nbsp;&nbsp;&nbsp;
																<?php } else { ?>
																	<strong>Checked Out</strong>&nbsp;&nbsp;&nbsp;&nbsp;
																<?php } ?>
																<?php /*if($rowashis['checkout']=="0" && $rowashis['status']=="1") { ?>
																	<a href="cancelact.php?bid=<?php print $rowashis['bid']; ?>&otp=yes">Cancel</a>
																<?php } if($ctr>$rowashis['strtime'] && $ctr<$rowashis['strextime']) { ?>
																	<a href="#">Extend</a>
																<?php }*/ ?>
															</td>		
															<td>
																<?php 
																$tnow=strtotime(date("h:i:s A"));
																if($rowashis['checkout']=="0") {
																	if($rowashis['strtime']>$tnow) { 
																?>
																		<div class="greenbox">In Time</div>
																<?php } else { ?>
																		<div class="redbox">Time Over</div>
																<?php } } ?>
																<?php /*?><?php if($rowashis['status']==1) { ?>
																	<a href="#" onClick="inactive('<?php print $rowashis['id']; ?>');return false;">On</a>&nbsp;
																<?php } else { ?>
																	<a href="#" onClick="active('<?php print $rowashis['id']; ?>');return false;">Off</a>&nbsp;
																<?php } ?>
																<a href="#" onClick="del('<?php print $rowashis['bid']; ?>');return false;">Delete</a><?php */?>
															</td>
														</tr>	
												<?php $count++; } } else { ?>
													<tr>
														<td colspan="5">Sorry, Nothing Found.</td>
													</tr>
												<?php } ?>
											</tbody>
										</table>
									</div>	
								<?php } else { ?>
									<div>
										<table class="table">
											<thead>
												<tr height="200">
													<th>&nbsp;</th>
												</tr>
											</thead>
										</table>
									</div>	
								<?php } ?>			
							</div>
						</div>		 
						<div class="clearfix"></div>
					</div>
				</div>
			</div>
		</div>
		<?php include("includes/footer.php"); ?>
	</section>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: home2.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation