Server : LiteSpeed System : Linux nl-srv-web1396.main-hosting.eu 4.18.0-553.83.1.lve.el8.x86_64 #1 SMP Wed Nov 12 10:04:12 UTC 2025 x86_64 User : u107206879 ( 107206879) PHP Version : 7.2.34 Disable Function : NONE Directory : /home/u107206879/domains/escort46.de/public_html/admin/ |
<?php
$error = "";
$message = "";
include "db_connection.php";
include "sessioncheck.php";
require_once '../Mobile_Detect.php';
$error = "";
$message = "";
if(!empty($_GET["ad_id"])){
$query="SELECT advertise.*, nat.".$lang_site_main_lang."_nationality"." FROM advertise LEFT JOIN nationalities AS nat ON nat.id=advertise.nationality WHERE advertise.id=".$_REQUEST['ad_id'];
$result1=mysqli_query($connection,$query);
$row = mysqli_fetch_assoc($result1);
if(!empty($row["id"])){
if(isset($_POST['edit'])){
/*print_r($_POST);
DIE();*/
$error="";
$bsname=test_input($_POST['bsname']);
$services=test_input($_POST['service']);
$alder=test_input($_POST['alder']);
$kon=test_input($_POST['kon']);
$bryst=test_input($_POST['bryst']);
$weight=test_input($_POST['weight']);
$height=test_input($_POST['height']);
$street=test_input($_POST['street']);
$incall_postal= test_input($_POST['incall_postal']);
if($services=='3'){
$incall_postal= test_input($_POST['outcall_postal']);
}
$outcall_postal=test_input($_POST['outcall_postal']);
$radius=test_input($_POST['radius']);
$postal_code=test_input($_POST['postal_code']);
$city=test_input($_POST['town']);
$website=test_input($_POST['website']);
$nationality=test_input($_POST['nationality']);
$country_code=test_input($_POST['country_code']);
$telephone=test_input($_POST['telephone']);
$prof_title=test_input($_POST['prof_title']);
$prof_beskrivelse=test_input($_POST['prof_beskrivelse']);
$plan_id=test_input($_POST['plan_id']);
$start_date=test_input($_POST['start_date']);
$end_date=test_input($_POST['end_date']);
$boost=test_input($_POST['boost']);
$boost_start_date=test_input($_POST['boost_start_date']);
$boost_end_date=test_input($_POST['boost_end_date']);
#event code comes here
if($row['category_id']=="5"){
$prof_title=test_input($_POST['event_title']);
$prof_beskrivelse=test_input($_POST['event_description']);
$event_date=test_input($_POST['event_date']);
$event_date = date('Y-m-d', strtotime($event_date));
$event_time_from=test_input($_POST['time_from']);
$event_time_to=test_input($_POST['time_to']);
$event_place=test_input($_POST['event_place']);
$street=test_input($_POST['event_street']);
$postal_code=test_input($_POST['event_postal_code']);
$sprice = test_input($_POST['price']);
$price1 = test_input($_POST['custom_price']);
if ($sprice == "") {
$event_price = $price1;
} else {
$event_price = $sprice;
}
$event_register_type=test_input($_POST['event_register_type']);
$event_reg_email=test_input($_POST['event_email']);
$country_code=test_input($_POST['event_country_code']);
$telephone=test_input($_POST['event_telephone']);
}
if($postal_code != ''){
$postal_region=$postal_code;
}elseif($outcall_postal != ''){
$postal_region=$outcall_postal;
}elseif($incall_postal != ''){
$postal_region=$incall_postal;
}
if($postal_region!=''){
$region_query=mysqli_query($connection,"SELECT ward, district, sub_country, region FROM area_code WHERE area_code='$postal_region'");
$region_row = mysqli_fetch_array($region_query);
$region = $region_row['region'];
$sub_country = $region_row['sub_country'];
$district = $region_row['district'];
$ward = $region_row['ward'];
}else{
$ward='';
$sub_country='';
$district='';
$region='';
}
$que="UPDATE `advertise` SET `business_name`='".addslashes($bsname)."', `services`='".addslashes($services)."', `incall`='".addslashes($incall_postal)."', `outcall`='".addslashes($outcall_postal)."', `radius`='".addslashes($radius)."', `ward`='".addslashes($ward)."', `district`='".addslashes($district)."', `sub_country`='".addslashes($sub_country)."', `region`='".addslashes($region)."', `alder`='".addslashes($alder)."', `kon`='".addslashes($kon)."', `bryst`='".addslashes($bryst)."', `weight`='".addslashes($weight)."', `height`='".addslashes($height)."', `nationality`='".addslashes($nationality)."', `country_code`='".addslashes($country_code)."', `telephone_no`='".addslashes($telephone)."', `profile_tile`='".addslashes($prof_title)."', `profile_beskrivelse`='".addslashes($prof_beskrivelse)."', `boost`='".addslashes($boost)."', `boost_start_date`='".addslashes($boost_start_date)."', `boost_end_date`='".addslashes($boost_end_date)."', `plan_id`='".addslashes($plan_id)."', `start_date`='".addslashes($start_date)."', `end_date`='".addslashes($end_date)."', `street`='".addslashes($street)."', `post_code`='".addslashes($postal_code)."', `city`='".addslashes($city)."', `website`='".addslashes($website)."', `event_time_from`='".addslashes($event_time_from)."' , `event_time_to`='".addslashes($event_time_to)."' , `event_place`='".addslashes($event_place)."' , `event_price`='".addslashes($event_price)."', `event_register_type`='".addslashes($event_register_type)."', `event_reg_email`='".addslashes($event_reg_email)."' WHERE id =".$_REQUEST['ad_id'];
$result=mysqli_query($connection,$que);
if($result){
$adid = $_REQUEST['ad_id'];
if(isset($_POST['adservices_values']) && !empty($_POST['adservices_values'])){
$userServices = array();
$userServicesQry = mysqli_query($connection,"SELECT * FROM ads_adservices WHERE ad_id=$adid");
while($userServicesRow=mysqli_fetch_assoc($userServicesQry)){
$userServices[] = $userServicesRow['adservice_id'];
}
if($userServices !== $_POST['adservices_values']){
mysqli_query($connection,"DELETE FROM `ads_adservices` WHERE ad_id=$adid");
foreach($_POST['adservices_values'] as $adservice_id){
mysqli_query($connection,"INSERT into `ads_adservices` (ad_id, adservice_id, updated_date) VALUES ('$adid', '$adservice_id', '$now')");
}
}
}else{
mysqli_query($connection,"DELETE FROM `ads_adservices` WHERE ad_id=$adid");
}
$message= "Data Updated Successfully";
}else{
$error="Error While Updating Data. Please Try Again!";
}
}
if($row["category_id"] == '1'){
$catgry="Escort & Massage";
if($row['services']==1){
$match_area=$row['incall'];
}else{
$match_area=$row['outcall'];
}
}else if($row["category_id"] == '2'){
$catgry="Massage Clinics";
$match_area=$row['post_code'];
}else if($row["category_id"] == '3'){
$catgry="Escort Bureaues";
}else if($row["category_id"] == '4'){
$catgry="Thai Massage";
$match_area=$row['post_code'];
}else if($row["category_id"] == '5'){
$catgry="Events";
$match_area=$row['post_code'];
}
$area_detail_qry=mysqli_query($connection,"SELECT * from area_code WHERE area_code='$match_area'");
$area_detail = mysqli_fetch_array($area_detail_qry);
$area_code_split=explode(" ",$area_detail["area_code"]);
$area_code=$area_code_split[0];
$region=$area_detail['region'];
$subcountry=$area_detail['sub_country'];
$district=$area_detail['district'];
$ward=$area_detail['ward']." - ".$area_code;
$que2="SELECT *,DATE_FORMAT(`create_date`, '%d %M, %Y') as date FROM user WHERE id=".$row['em_id'];
$result2=mysqli_query($connection,$que2);
$row2 = mysqli_fetch_array($result2);
$user_detail = $row2;
//pre($user_detail);
if(mysqli_num_rows($result1)>0){
$que3="SELECT photo from images WHERE em_id=".$row['em_id']." AND ad_id = ".$row['id']." AND is_profile = 1";
$result3=mysqli_query($connection,$que3);
$row3 = mysqli_fetch_array($result3);
if($result3){
$prophoto = MAIN_URL."/user_images/".$row3['photo'];
}
}else{
$prophoto = MAIN_URL."/images/default-person.png";
}
}else{
header("Location:ads_list");
}
}else{
header("Location:ads_list");
}
?>
<!-- Header Start-->
<?php include("header.php");?>
<!-- Header Ends-->
<link rel="stylesheet" href="<?php echo MAIN_URL?>/admin/assets/dist/css/themelook.css">
<link href="<?php echo MAIN_URL; ?>/src/css/jquery.fancybox.min.css" rel="stylesheet" />
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/fancybox/3.1.20/jquery.fancybox.min.js"></script>
<script type="text/javascript" src="<?php echo MAIN_URL; ?>/src/js/jquery.validate.js"></script>
<script type="text/javascript" src="<?php echo MAIN_URL; ?>/src/js/additional-methods.min.js"></script>
<script type="text/javascript" src="/admin/assets/dist/js/common_js.js"></script>
<!-- Content Start-->
<style>
#loader {
position: fixed;
background-size: 150px;
z-index: 100;
background-image: url('../images/loaderIcon.gif');
background-color: #e8e8e8;
opacity: 0.4;
background-repeat: no-repeat;
background-position: center;
left: 0;
bottom: 0;
right: 0;
top: 0;
}
</style>
<div id="loader" style="display: none"></div>
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-12">
<div class="card">
<!-- /.card-header -->
<div class="card-body">
<?php include_once 'notification.php'; ?>
<?php if(!empty($error)) : ?><div class="alert alert-info" role="alert" style="color:#FF0000;"><?php echo $error; ?></div><?php endif; ?>
<!-- Error Message -->
<div id="pricing" class="myprofile_div">
<div class=" col-sm-12 col-md-12 col-xs-12 col-lg-12 nopadding">
<div class="row">
<div class="col-sm-3">
<div class="panel widget light-widget panel-bd-top">
<div class="no-title pb-0">
<h1 class="font-semibold mgbt-xs-5 no-padding no-margin h1_myprofile text-center" style="font-size:16px !important;">
<?php echo $row['profile_tile']; ?>
</h1>
</div>
<div class="panel-body" style="padding:7px;">
<div class="text-center vd_info-parent">
<img class="imgexa imgpro" alt="Profile Pic" src="<?php echo $prophoto; ?>">
</div>
<div class="mgtp-20">
<?php if(!empty($row['id'])){ ?><table class="beta table no-margin">
<tbody>
<tr>
<td style="width:60%;" class="hidden-xs">Status</td>
<?php
if(!empty($row['id'])){
if($row['isApproved'] == 1){
if($row['adstatus'] == 1){
$status = 'Active';
$class = 'badge-success';
$status_tooltip = 'Inactive this ad';
}else {
$status = 'Inactive';
$class = 'badge-danger';
$status_tooltip = 'Active this ad';
}?>
<td data-label="Status"><span id="status_change_<?php echo $row['id'] ?>" class="status_change label_status badge <?php echo $class ?>" data-id="<?php echo $row['id'] ?>" data-status-id="<?php echo $row['adstatus'] ?>" data-placement="top" data-toggle="tooltip" data-original-title="<?php echo $status_tooltip ?>" title="<?php echo $status_tooltip ?>"><?php echo $status ?></span></td>
<?php }else{ ?>
<td data-label="Status"><span class="label_status badge badge-danger btn_purchase_quick" data-placement="top" data-toggle="tooltip" data-original-title="This ad is under review" title="This ad will appear after payment" data-id="<?php echo $row['id'] ?>">Awaiting Payment</span></td>
<?php }
}else{ ?>
<td><a href="<?php echo SUB_URL; ?>/moread" class="label_status btn vd_btn btn-xs vd_bg-yellow"><i class="fa fa-plus append-icon"></i> Create a New Ad </a></td>
<?php } ?>
</tr>
<!--<tr>
<td class="hidden-xs">Created Date</td>
<td data-label="Created Date"><?php echo date("d-m-Y",strtotime($row['start_date'])); ?></td>
</tr>-->
<tr>
<td class="hidden-xs">Plan</td>
<td data-label="Plan">
<?php $boost = (trim($row['boost'])=="1") ? "/BOOST" : "";?>
<b>
<?php
if($row['plan_id']==1){
echo "BRONZE".$boost;
}elseif($row['plan_id']==2){
echo "SILVER".$boost;
}elseif($row['plan_id']==3){
echo "GOLD".$boost;
}else{
echo "FREE".$boost;
}
?>
</b>
</td>
</tr>
<tr>
<td class="hidden-xs">Days left</td>
<td data-label="Days left">
<?php
if($row['plan_id']!=0){
$datetime1 = new DateTime();
$datetime2 = new DateTime($row['end_date']);
$interval = $datetime1->diff($datetime2);
$elapsed = $interval->format('%r%a Days');
}else{
$elapsed = 'Unlimited';
}
?>
<!-- Boost days calculation -->
<?php if(trim($row['boost'])=="1"){
$boost_abc1 = new DateTime();
$boost_abc2 = new DateTime($row['boost_end_date']);
$boost_interval = $boost_abc1->diff($boost_abc2);
$boost_elapsed = $boost_interval->format('%r%a Days');
}
?>
<b> <?php echo $elapsed ?><?php if(trim($row['boost'])=="1"){?>/<?php echo $boost_elapsed ?><?php } ?></b>
</td>
</tr>
</table>
<?php } ?>
</div>
</div>
</div>
</div>
<div class="col-sm-9">
<div class="tabs widget">
<ul class="nav nav-tabs widget myprofile_tabs">
<li class="nav-item">
<a class="nav-link active tabsh" data-toggle="tab" href="#edit_ad-tab"> Edit Ad
<span class="menu-active"><i class="fa fa-caret-down"></i></span>
</a>
</li>
<li class="nav-item">
<a class="nav-link tabsh" data-toggle="tab" href="#photos-tab"> Photos
<span class="menu-active"><i class="fa fa-caret-down"></i></span>
</a>
</li>
<!--<li class="nav-item">
<a class="nav-link tabsh" data-toggle="tab" href="#profile-tab"> Profile
<span class="menu-active"><i class="fa fa-caret-down"></i></span>
</a>
</li>-->
<li class="nav-item">
<a class="nav-link tabsh" data-toggle="tab" href="#user-info"> User
<span class="menu-active"><i class="fa fa-caret-down"></i></span>
</a>
</li>
</ul>
<div class="tab-content">
<?php
if($success != ""){
echo $success;
}
?>
<div id="edit_ad-tab" class="tab-pane fade in active show">
<!--<h3><i class="fa fa-pencil mgr-10 profile-icon"></i> Edit Ad</h3>-->
<div class="row">
<?php include_once "ads_edit_tab.php"; ?>
</div>
<div class="clearfix"></div>
</div>
<div id="photos-tab" class="tab-pane fade">
<div class="vd_info tr pull-right">
<form action="../file_upload.php" method="POST" enctype="multipart/formdata" id="myForm">
<input type="file" name="myFile" id="myFile" style="visibility:hidden; width: 1px; height: 1px" multiple />
<a href="" onClick="document.getElementById('myFile').click(); return false" class="btn vd_btn btn-xs vd_bg-yellow">
<i class="fa fa-plus append-icon"></i> Add Photo
</a>
</form>
</div>
<h3><i class="fa fa-picture-o mgr-10 profile-icon"></i> PHOTOS</h3>
<h5>( Click on picture to set as profile picture or Delete the picture. )</h5>
<div class="profile-image-gallry" style="text-align:center">
<?php
$qry = "SELECT * FROM images WHERE em_id=".$row['em_id']." AND ad_id = ".$row['id'];
$img_gallary = mysqli_query($connection,$qry);
while($img_pics=mysqli_fetch_array($img_gallary)){
?>
<a class="userimages" href="<?php echo MAIN_URL; ?>/user_images/<?php echo $img_pics['photo']; ?>" data-id="<?php echo $img_pics['id']; ?>" data-fancybox="Image" data-caption="<a class='ajax-action-links' style='cursor: pointer;' onclick='profilePhoto(<?php echo $img_pics['id']; ?>);'>Set as Profile Photo</a> | <a class='ajax-action-links' style='cursor: pointer;' onclick='deleteImage(<?php echo $img_pics['id']; ?>);'>Delete</a>">
<img class="sldimg" src="<?php echo MAIN_URL; ?>/user_images/<?php echo $img_pics['photo']; ?>"></img>
</a>
<?php } ?>
</div>
<div class="clearfix"></div>
</div>
<div id="profile-tab" class="tab-pane fade my_profile_text" style="display:none">
<div style="display:none" class="bhavesh_remove">
<hr class="pd-10" style="1px solid #eee">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 mt-20 no-padding">
<h3><i class="fa fa-money mgr-10 profile-icon"></i> Price List</h3>
<style>
.fa-lg {
font-size: 1.566667em;
line-height: .75em;
vertical-align: -15%;
}
[contenteditable=true]:empty:before{
content: attr(placeholder);
pointer-events: none;
display: block; /* For Firefox */
}
/*
td[contenteditable=true] {
border: 1px dashed #AAA;
width: 290px;
padding: 5px;
}*/
</style>
<table class="dark table table-bordered">
<thead>
<tr>
<th class="table-header" style="width:60%">Service</th>
<th class="table-header" style="width:30%">Price (GBP)</th>
<th class="table-header" align="right" style="text-align:right;padding-right:15px;width:10%"></th>
</tr>
</thead>
<tbody id="table-body">
<?php
$query="SELECT * from pricelist WHERE em_id=".$row['em_id']." AND ad_id = ".$row['id'];
$qresult=mysqli_query($connection,$query);
if(mysqli_num_rows($qresult)>0){ ?>
<?php
while($plist=mysqli_fetch_array($qresult)){
?>
<tr class="table-row" id="table-row-<?php echo $plist["id"]; ?>">
<td contenteditable="true" onBlur="saveToDatabase(this,'service','<?php echo $plist["id"]; ?>')" onClick="editRow(this);" placeholder="Service enter here.."><?php echo $plist['service']; ?></td>
<td contenteditable="true" onBlur="saveToDatabase(this,'price','<?php echo $plist["id"]; ?>')" onClick="editRow(this);" placeholder="Price enter here.."><?php echo $plist['price']; ?></td>
<td align="right" style="padding-right:15px;"><a class="ajax-action-links" onClick="deleteRecord(<?php echo $plist["id"]; ?>);"><i class="fa fa-trash-o fa-lg" data-placement="top" data-toggle="tooltip" data-original-title="Delete" title="Delete"></i></a></td>
</tr>
<?php
}
}
?>
</tbody>
</table>
<!--<div class="ajax-action-button" id="add-more" onClick="createNew();">Add more +</div> <div class="clearfix"></div>-->
</div>
<hr class="pd-10" style="1px solid #eee">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 mt-20 no-padding">
<h3><i class="fa fa-calendar mgr-10 profile-icon"></i> Schedule</h3>
<table class="dark beta table table-bordered" style="border-collapse:separate;border-spacing:0 5px;" id="table1">
<thead>
<tr>
<th class="table-header" style="width:30%">Day</th>
<th class="table-header" style="width:30%">Description</th>
<th class="table-header" style="width:30%">Address</th>
<th class="table-header" align="right" style="text-align:right;padding-right:15px;width:10%"></th>
</tr>
</thead>
<tbody id="sctable-body">
<?php
$query="SELECT * from schedule WHERE em_id=".$row['em_id']." AND ad_id = ".$row['id'];
$qresult=mysqli_query($connection,$query);
if(mysqli_num_rows($qresult)>0){
while($sclist=mysqli_fetch_array($qresult)){
?>
<tr class="table-row" id="table-row-<?php echo $sclist["id"]; ?>">
<td class="mob_left">
<select contenteditable="true" onClick="editSCRow(this);" onBlur="saveSCToDatabase(this,'week_day','<?php echo $sclist["id"]; ?>')" style="width:50%">
<option value="Monday" <?php if($sclist["week_day"]=='Monday') echo 'selected="selected"'; ?>>Monday</option>
<option value="Tuesday" <?php if($sclist["week_day"]=='Tuesday') echo 'selected="selected"'; ?>>Tuesday</option>
<option value="Wednesday" <?php if($sclist["week_day"]=='Wednesday') echo 'selected="selected"'; ?>>Wednesday</option>
<option value="Thursday" <?php if($sclist["week_day"]=='Thursday') echo 'selected="selected"'; ?>>Thursday</option>
<option value="Friday" <?php if($sclist["week_day"]=='Friday') echo 'selected="selected"'; ?>>Friday</option>
<option value="Saturday" <?php if($sclist["week_day"]=='Saturday') echo 'selected="selected"'; ?>>Saturday</option>
<option value="Sunday" <?php if($sclist["week_day"]=='Sunday') echo 'selected="selected"'; ?>>Sunday</option>
</select>
<select contenteditable="true" onClick="editSCRow(this);" onBlur="saveSCToDatabase(this,'time_from','<?php echo $sclist["id"]; ?>')">
<option value="00:00" <?php if($sclist["time_from"]=='00:00') echo 'selected="selected"'; ?>>00:00</option>
<option value="00:30" <?php if($sclist["time_from"]=='00:30') echo 'selected="selected"'; ?>>00:30</option>
<option value="01:00" <?php if($sclist["time_from"]=='01:00') echo 'selected="selected"'; ?>>01:00</option>
<option value="01:30" <?php if($sclist["time_from"]=='01:30') echo 'selected="selected"'; ?>>01:30</option>
<option value="02:00" <?php if($sclist["time_from"]=='02:00') echo 'selected="selected"'; ?>>02:00</option>
<option value="02:30" <?php if($sclist["time_from"]=='02:30') echo 'selected="selected"'; ?>>02:30</option>
<option value="03:00" <?php if($sclist["time_from"]=='03:00') echo 'selected="selected"'; ?>>03:00</option>
<option value="03:30" <?php if($sclist["time_from"]=='03:30') echo 'selected="selected"'; ?>>03:30</option>
<option value="04:00" <?php if($sclist["time_from"]=='04:00') echo 'selected="selected"'; ?>>04:00</option>
<option value="04:30" <?php if($sclist["time_from"]=='04:30') echo 'selected="selected"'; ?>>04:30</option>
<option value="05:00" <?php if($sclist["time_from"]=='05:00') echo 'selected="selected"'; ?>>05:00</option>
<option value="05:30" <?php if($sclist["time_from"]=='05:30') echo 'selected="selected"'; ?>>05:30</option>
<option value="06:00" <?php if($sclist["time_from"]=='06:00') echo 'selected="selected"'; ?>>06:00</option>
<option value="06:30" <?php if($sclist["time_from"]=='06:30') echo 'selected="selected"'; ?>>06:30</option>
<option value="07:00" <?php if($sclist["time_from"]=='07:00') echo 'selected="selected"'; ?>>07:00</option>
<option value="07:30" <?php if($sclist["time_from"]=='07:30') echo 'selected="selected"'; ?>>07:30</option>
<option value="08:00" <?php if($sclist["time_from"]=='08:00') echo 'selected="selected"'; ?>>08:00</option>
<option value="08:30" <?php if($sclist["time_from"]=='08:30') echo 'selected="selected"'; ?>>08:30</option>
<option value="09:00" <?php if($sclist["time_from"]=='09:00') echo 'selected="selected"'; ?>>09:00</option>
<option value="09:30" <?php if($sclist["time_from"]=='09:30') echo 'selected="selected"'; ?>>09:30</option>
<option value="10:00" <?php if($sclist["time_from"]=='10:00') echo 'selected="selected"'; ?>>10:00</option>
<option value="10:30" <?php if($sclist["time_from"]=='10:30') echo 'selected="selected"'; ?>>10:30</option>
<option value="11:00" <?php if($sclist["time_from"]=='11:00') echo 'selected="selected"'; ?>>11:00</option>
<option value="11:30" <?php if($sclist["time_from"]=='11:30') echo 'selected="selected"'; ?>>11:30</option>
<option value="12:00" <?php if($sclist["time_from"]=='12:00') echo 'selected="selected"'; ?>>12:00</option>
<option value="12:30" <?php if($sclist["time_from"]=='12:30') echo 'selected="selected"'; ?>>12:30</option>
<option value="13:00" <?php if($sclist["time_from"]=='13:00') echo 'selected="selected"'; ?>>13:00</option>
<option value="13:30" <?php if($sclist["time_from"]=='13:30') echo 'selected="selected"'; ?>>13:30</option>
<option value="14:00" <?php if($sclist["time_from"]=='14:00') echo 'selected="selected"'; ?>>14:00</option>
<option value="14:30" <?php if($sclist["time_from"]=='14:30') echo 'selected="selected"'; ?>>14:30</option>
<option value="15:00" <?php if($sclist["time_from"]=='15:00') echo 'selected="selected"'; ?>>15:00</option>
<option value="15:30" <?php if($sclist["time_from"]=='15:30') echo 'selected="selected"'; ?>>15:30</option>
<option value="16:00" <?php if($sclist["time_from"]=='16:00') echo 'selected="selected"'; ?>>16:00</option>
<option value="16:30" <?php if($sclist["time_from"]=='16:30') echo 'selected="selected"'; ?>>16:30</option>
<option value="17:00" <?php if($sclist["time_from"]=='17:00') echo 'selected="selected"'; ?>>17:00</option>
<option value="17:30" <?php if($sclist["time_from"]=='17:30') echo 'selected="selected"'; ?>>17:30</option>
<option value="18:00" <?php if($sclist["time_from"]=='18:00') echo 'selected="selected"'; ?>>18:00</option>
<option value="18:30" <?php if($sclist["time_from"]=='18:30') echo 'selected="selected"'; ?>>18:30</option>
<option value="19:00" <?php if($sclist["time_from"]=='19:00') echo 'selected="selected"'; ?>>19:00</option>
<option value="19:30" <?php if($sclist["time_from"]=='19:30') echo 'selected="selected"'; ?>>19:30</option>
<option value="20:00" <?php if($sclist["time_from"]=='20:00') echo 'selected="selected"'; ?>>20:00</option>
<option value="20:30" <?php if($sclist["time_from"]=='20:30') echo 'selected="selected"'; ?>>20:30</option>
<option value="21:00" <?php if($sclist["time_from"]=='21:00') echo 'selected="selected"'; ?>>21:00</option>
<option value="21:30" <?php if($sclist["time_from"]=='21:30') echo 'selected="selected"'; ?>>21:30</option>
<option value="22:00" <?php if($sclist["time_from"]=='22:00') echo 'selected="selected"'; ?>>22:00</option>
<option value="22:30" <?php if($sclist["time_from"]=='22:30') echo 'selected="selected"'; ?>>22:30</option>
<option value="23:00" <?php if($sclist["time_from"]=='23:00') echo 'selected="selected"'; ?>>23:00</option>
<option value="23:30" <?php if($sclist["time_from"]=='23:30') echo 'selected="selected"'; ?>>23:30</option>
</select>-<select contenteditable="true" onClick="editSCRow(this);" onBlur="saveSCToDatabase(this,'time_to','<?php echo $sclist["id"]; ?>')">
<option value="00:00" <?php if($sclist["time_to"]=='00:00') echo 'selected="selected"'; ?>>00:00</option>
<option value="00:30" <?php if($sclist["time_to"]=='00:30') echo 'selected="selected"'; ?>>00:30</option>
<option value="01:00" <?php if($sclist["time_to"]=='01:00') echo 'selected="selected"'; ?>>01:00</option>
<option value="01:30" <?php if($sclist["time_to"]=='01:30') echo 'selected="selected"'; ?>>01:30</option>
<option value="02:00" <?php if($sclist["time_to"]=='02:00') echo 'selected="selected"'; ?>>02:00</option>
<option value="02:30" <?php if($sclist["time_to"]=='02:30') echo 'selected="selected"'; ?>>02:30</option>
<option value="03:00" <?php if($sclist["time_to"]=='03:00') echo 'selected="selected"'; ?>>03:00</option>
<option value="03:30" <?php if($sclist["time_to"]=='03:30') echo 'selected="selected"'; ?>>03:30</option>
<option value="04:00" <?php if($sclist["time_to"]=='04:00') echo 'selected="selected"'; ?>>04:00</option>
<option value="04:30" <?php if($sclist["time_to"]=='04:30') echo 'selected="selected"'; ?>>04:30</option>
<option value="05:00" <?php if($sclist["time_to"]=='05:00') echo 'selected="selected"'; ?>>05:00</option>
<option value="05:30" <?php if($sclist["time_to"]=='05:30') echo 'selected="selected"'; ?>>05:30</option>
<option value="06:00" <?php if($sclist["time_to"]=='06:00') echo 'selected="selected"'; ?>>06:00</option>
<option value="06:30" <?php if($sclist["time_to"]=='06:30') echo 'selected="selected"'; ?>>06:30</option>
<option value="07:00" <?php if($sclist["time_to"]=='07:00') echo 'selected="selected"'; ?>>07:00</option>
<option value="07:30" <?php if($sclist["time_to"]=='07:30') echo 'selected="selected"'; ?>>07:30</option>
<option value="08:00" <?php if($sclist["time_to"]=='08:00') echo 'selected="selected"'; ?>>08:00</option>
<option value="08:30" <?php if($sclist["time_to"]=='08:30') echo 'selected="selected"'; ?>>08:30</option>
<option value="09:00" <?php if($sclist["time_to"]=='09:00') echo 'selected="selected"'; ?>>09:00</option>
<option value="09:30" <?php if($sclist["time_to"]=='09:30') echo 'selected="selected"'; ?>>09:30</option>
<option value="10:00" <?php if($sclist["time_to"]=='10:00') echo 'selected="selected"'; ?>>10:00</option>
<option value="10:30" <?php if($sclist["time_to"]=='10:30') echo 'selected="selected"'; ?>>10:30</option>
<option value="11:00" <?php if($sclist["time_to"]=='11:00') echo 'selected="selected"'; ?>>11:00</option>
<option value="11:30" <?php if($sclist["time_to"]=='11:30') echo 'selected="selected"'; ?>>11:30</option>
<option value="12:00" <?php if($sclist["time_to"]=='12:00') echo 'selected="selected"'; ?>>12:00</option>
<option value="12:30" <?php if($sclist["time_to"]=='12:30') echo 'selected="selected"'; ?>>12:30</option>
<option value="13:00" <?php if($sclist["time_to"]=='13:00') echo 'selected="selected"'; ?>>13:00</option>
<option value="13:30" <?php if($sclist["time_to"]=='13:30') echo 'selected="selected"'; ?>>13:30</option>
<option value="14:00" <?php if($sclist["time_to"]=='14:00') echo 'selected="selected"'; ?>>14:00</option>
<option value="14:30" <?php if($sclist["time_to"]=='14:30') echo 'selected="selected"'; ?>>14:30</option>
<option value="15:00" <?php if($sclist["time_to"]=='15:00') echo 'selected="selected"'; ?>>15:00</option>
<option value="15:30" <?php if($sclist["time_to"]=='15:30') echo 'selected="selected"'; ?>>15:30</option>
<option value="16:00" <?php if($sclist["time_to"]=='16:00') echo 'selected="selected"'; ?>>16:00</option>
<option value="16:30" <?php if($sclist["time_to"]=='16:30') echo 'selected="selected"'; ?>>16:30</option>
<option value="17:00" <?php if($sclist["time_to"]=='17:00') echo 'selected="selected"'; ?>>17:00</option>
<option value="17:30" <?php if($sclist["time_to"]=='17:30') echo 'selected="selected"'; ?>>17:30</option>
<option value="18:00" <?php if($sclist["time_to"]=='18:00') echo 'selected="selected"'; ?>>18:00</option>
<option value="18:30" <?php if($sclist["time_to"]=='18:30') echo 'selected="selected"'; ?>>18:30</option>
<option value="19:00" <?php if($sclist["time_to"]=='19:00') echo 'selected="selected"'; ?>>19:00</option>
<option value="19:30" <?php if($sclist["time_to"]=='19:30') echo 'selected="selected"'; ?>>19:30</option>
<option value="20:00" <?php if($sclist["time_to"]=='20:00') echo 'selected="selected"'; ?>>20:00</option>
<option value="20:30" <?php if($sclist["time_to"]=='20:30') echo 'selected="selected"'; ?>>20:30</option>
<option value="21:00" <?php if($sclist["time_to"]=='21:00') echo 'selected="selected"'; ?>>21:00</option>
<option value="21:30" <?php if($sclist["time_to"]=='21:30') echo 'selected="selected"'; ?>>21:30</option>
<option value="22:00" <?php if($sclist["time_to"]=='22:00') echo 'selected="selected"'; ?>>22:00</option>
<option value="22:30" <?php if($sclist["time_to"]=='22:30') echo 'selected="selected"'; ?>>22:30</option>
<option value="23:00" <?php if($sclist["time_to"]=='23:00') echo 'selected="selected"'; ?>>23:00</option>
<option value="23:30" <?php if($sclist["time_to"]=='23:30') echo 'selected="selected"'; ?>>23:30</option>
</select></td>
<td contenteditable="true" onBlur="saveSCToDatabase(this,'sc_description','<?php echo $sclist["id"]; ?>')" onClick="editSCRow(this);" placeholder="Decription enter here .." class="mob_left"><?php echo $sclist["sc_description"]; ?></td>
<td contenteditable="true" onBlur="saveSCToDatabase(this,'sc_address','<?php echo $sclist["id"]; ?>')" onClick="editSCRow(this);" placeholder="Address enter here .." class="mob_left"><?php echo $sclist["sc_address"]; ?></td>
<td align="right" style="padding-right:15px;"><a class="ajax-action-links" onClick="deleteSCRecord(<?php echo $sclist["id"]; ?>);"><i class="fa fa-trash-o fa-lg" data-placement="top" data-toggle="tooltip" data-original-title="Delete" title="Delete"></i></a></td>
</tr>
<?php
} //while($sclist=mysqli_fetch_array($qresult))
}
?>
</tbody>
</table>
<!--<div class="ajax-action-button" id="scadd-more" onClick="createSCNew();">Add more +</div><div class="clearfix"></div>-->
</div>
</div>
</div>
<div id="user-info" class="tab-pane fade my_user_details">
<?php
include('ads_profile_page_edit.php');
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
</div>
<!-- /.row (main row) -->
</div><!-- /.container-fluid -->
</section>
<script type="text/javascript">
$(document).ready(function(){
$("#myFile").on("change", function(){
var input = $(this);
var inputLength = input[0].files.length; //No of files selected
var file;
var formData = new FormData();
for (var i = 0; i < inputLength; i++) {
file = input[0].files[i];
formData.append( 'myFile[]', file);
}
formData.append( 'adid', '<?php echo $row['id']; ?>');
formData.append( 'userid', '<?php echo $row['em_id']; ?>');
//send POST request to upload.php
$.ajax({
url: "service/file_upload",
type: "POST",
data: formData,
processData: false,
contentType: false,
dataType: 'json',
beforeSend: function(){
$("#loader").show();
},
success: function(data) {
if (typeof (data.status) != "undefined" && data.status == 1 ){
$.each(data.images, function(i, item) {
$(".profile-image-gallry").append('<a class="userimages" href="'+item.src+'" data-id="'+item.id+'" data-fancybox="Image" data-caption="<a class=\'ajax-action-links\' onclick=\'profilePhoto('+item.id+');\'>Set as Profile Photo</a> | <a class=\'ajax-action-links\' onclick=\'deleteImage('+item.id+');\'>Delete</a>"><img class="sldimg" src="'+item.src+'"></a>');
});
}
$("#loader").hide();
}
})
});
});
</script>
<!-- Price List -->
<script>
createNew();
function createNew() {
//$("#add-more").hide();
var data = '<tr id="new_row_ajax" style="background-color:#FFFFFF;">' +
'<td contenteditable="true" id="txt_title" onBlur="addToHiddenField(this,\'title\')" onClick="editRow(this);" placeholder="Service enter here.."></td>' +
'<td contenteditable="true" id="txt_price" onBlur="addToHiddenField(this,\'price\')" onClick="editRow(this);" placeholder="Price enter here.."></td>' +
'<td align="right" style="padding-right:15px;"><input type="hidden" id="title" /><input type="hidden" id="price" /><span id="confirmAdd"><a onClick="addToDatabase()" class="ajax-action-links" > <i class="fa fa-floppy-o" data-placement="top" data-toggle="tooltip" data-original-title="Save" title="Save"></i></a></span></td></tr>';
$("#table-body").append(data);
}
function cancelAdd() {
//$("#add-more").show();
$("#new_row_ajax").remove();
}
function editRow(editableObj) {
// $(editableObj).css("background","#FFF");
}
function saveToDatabase(editableObj,column,id) {
//$(editableObj).css("background","#FFF url(<?= MAIN_URL ?>/images/loaderIcon.gif) no-repeat right","'background-size','5px 5px'");
if(column=="service"){
//validation, limit 30 characters
if($(editableObj).text().length>30){
alert("Maximum 30 characters are allowed in the title ");
return false;
}
}else if(column=="price"){
//validation, limit 10 characters
if($(editableObj).text().length>10){
alert("Maximum 10 characters are allowed in the price ");
return false;
}
//Allow only integers in price
/*if($.isNumeric($(editableObj).text()) && $(editableObj).text() > 0){
}else{
alert("Only numbers are allowed in price ");
return false;
}*/
}
$("#loader").show();
$.ajax({
url: "service/edit_price_list",
type: "POST",
data:'column='+column+'&editval='+$(editableObj).text()+'&id='+id,
success: function(data){
$(editableObj).css("background","#FDFDFD");
}
});
}
function addToDatabase() {
var title = $("#title").val();
var price = $("#price").val();
//validation, limit 30 characters
if(title.length>30){
alert("Maximum 30 characters are allowed in the title ");
return false;
}
//validation, limit 10 characters
if(price.length>10){
alert("Maximum 10 characters are allowed in the price ");
return false;
}
//Allow only integers in price
/*if($.isNumeric(price) && price > 0){
}else{
alert("Only numbers are allowed in price ");
return false;
}*/
$("#loader").show();
// $("#confirmAdd").html('<img src="<?= MAIN_URL ?>/images/loaderIcon.gif" />');
$.ajax({
url: "service/add_price_list",
type: "POST",
data:'title='+title+'&price='+price+'&adid='+<?php echo $row['id']; ?>,
success: function(data){
$("#new_row_ajax").remove();
// $("#add-more").show();
$("#table-body").append(data);
createNew();
}
});
}
function addToHiddenField(addColumn,hiddenField) {
var columnValue = $(addColumn).text();
$("#"+hiddenField).val(columnValue);
}
function deleteRecord(id) {
if(confirm("Are you sure you want to delete this row?")) {
$.ajax({
url: "service/delete_price_list",
type: "POST",
data:'id='+id,
success: function(data){
$("#table-row-"+id).remove();
}
});
}
}
</script>
<!-- Schedule -->
<script>
createSCNew();
function createSCNew() {
//$("#scadd-more").hide();
var data = '<tr class="table-row" id="scnew_row_ajax" style="background-color:#FFFFFF;">' +
'<td id="txt_weekday" class="mob_left"><select contenteditable="true" onClick="editSCRow(this);" id="weekday" style="width:50%"><option value="Monday">Monday</option><option value="Tuesday">Tuesday</option><option value="Wednesday">Wednesday</option><option value="Thursday">Thursday</option><option value="Friday">Friday</option><option value="Saturday">Saturday</option><option value="Sunday">Sunday</option></select> <select contenteditable="true" onClick="editSCRow(this);" id="timefrom"><option value="00:00">00:00</option><option value="00:30">00:30</option><option value="01:00">01:00</option><option value="01:30">01:30</option><option value="02:00">02:00</option><option value="02:30">02:30</option><option value="03:00">03:00</option><option value="03:30">03:30</option><option value="04:00">04:00</option><option value="04:30">04:30</option><option value="05:00">05:00</option><option value="05:30">05:30</option><option value="06:00">06:00</option><option value="06:30">06:30</option><option value="07:00">07:00</option><option value="07:30">07:30</option><option value="08:00">08:00</option><option value="08:30">08:30</option><option value="09:00">09:00</option><option value="09:30">09:30</option><option value="10:00">10:00</option><option value="10:30">10:30</option><option value="11:00">11:00</option><option value="11:30">11:30</option><option value="12:00">12:00</option><option value="12:30">12:30</option><option value="13:00">13:00</option><option value="13:30">13:30</option><option value="14:00">14:00</option><option value="14:30">14:30</option><option value="15:00">15:00</option><option value="15:30">15:30</option><option value="16:00">16:00</option><option value="16:30">16:30</option><option value="17:00">17:00</option><option value="17:30">17:30</option><option value="18:00">18:00</option><option value="18:30">18:30</option><option value="19:00">19:00</option><option value="19:30">19:30</option><option value="20:00">20:00</option><option value="20:30">20:30</option><option value="21:00">21:00</option><option value="21:30">21:30</option><option value="22:00">22:00</option><option value="22:30">22:30</option><option value="23:00">23:00</option><option value="23:30">23:30</option></select>-<select contenteditable="true" onClick="editSCRow(this);" id="timeto"><option value="00:00">00:00</option><option value="00:30">00:30</option><option value="01:00">01:00</option><option value="01:30">01:30</option><option value="02:00">02:00</option><option value="02:30">02:30</option><option value="03:00">03:00</option><option value="03:30">03:30</option><option value="04:00">04:00</option><option value="04:30">04:30</option><option value="05:00">05:00</option><option value="05:30">05:30</option><option value="06:00">06:00</option><option value="06:30">06:30</option><option value="07:00">07:00</option><option value="07:30">07:30</option><option value="08:00">08:00</option><option value="08:30">08:30</option><option value="09:00">09:00</option><option value="09:30">09:30</option><option value="10:00">10:00</option><option value="10:30">10:30</option><option value="11:00">11:00</option><option value="11:30">11:30</option><option value="12:00">12:00</option><option value="12:30">12:30</option><option value="13:00">13:00</option><option value="13:30">13:30</option><option value="14:00">14:00</option><option value="14:30">14:30</option><option value="15:00">15:00</option><option value="15:30">15:30</option><option value="16:00">16:00</option><option value="16:30">16:30</option><option value="17:00">17:00</option><option value="17:30">17:30</option><option value="18:00">18:00</option><option value="18:30">18:30</option><option value="19:00">19:00</option><option value="19:30">19:30</option><option value="20:00">20:00</option><option value="20:30">20:30</option><option value="21:00">21:00</option><option value="21:30">21:30</option><option value="22:00">22:00</option><option value="22:30">22:30</option><option value="23:00">23:00</option><option value="23:30">23:30</option></select></td>'+
'<td contenteditable="true" id="txt_sc_description" onBlur="addSCToHiddenField(this,\'sc_description\')" onClick="editSCRow(this);" placeholder="Description enter here.." class="mob_left"></td>' +
'<td contenteditable="true" id="txt_sc_address" onBlur="addSCToHiddenField(this,\'sc_address\')" onClick="editSCRow(this);" placeholder="Address enter here.." class="mob_left"></td>' +
'<td align="right" style="padding-right:15px;"><input type="hidden" id="sc_description" /><input type="hidden" id="sc_address" /><span id="confirmAdd"><a onClick="addSCToDatabase(this)" class="ajax-action-links" ><i class="fa fa-floppy-o" data-placement="top" data-toggle="tooltip" data-original-title="Save" title="Save"></i></a></span></td>' +
'</tr>';
$("#sctable-body").append(data);
}
function cancelSCAdd() {
//$("#scadd-more").show();
$("#scnew_row_ajax").remove();
}
function editSCRow(editableObj) {
// $(editableObj).css("background","#FFF");
}
function saveSCToDatabase(editableObj,column,id) {
var _savevalue='';
if(column=='sc_description' || column=='sc_address'){
_savevalue=$(editableObj).text();
}else{
_savevalue=$(editableObj).val();
}
$("#loader").show();
$.ajax({
url: "service/editschedule",
type: "POST",
data:'column='+column+'&editval='+_savevalue+'&id='+id,
success: function(data){
$("#loader").hide();
//$(editableObj).css("background","#FDFDFD");
}
});
}
function addSCToDatabase(element) {
var parentRow = $(element).parents('.table-row');
var weekday = parentRow.find("#weekday").val();
var timefrom = parentRow.find("#timefrom").val();
var timeto = parentRow.find("#timeto").val();
var sc_description = parentRow.find("#sc_description").val();
var sc_address = parentRow.find("#sc_address").val();
$("#confirmAdd").html('<img src="../loaderIcon.gif" />');
$.ajax({
url: "service/addschedule",
type: "POST",
data:'weekday='+weekday+'&timefrom='+timefrom+'&timeto='+timeto+'&sc_description='+sc_description+'&sc_address='+sc_address+'&adid='+<?php echo $row['id']; ?>,
success: function(data){
$("#scnew_row_ajax").remove();
//$("#scadd-more").show();
$("#sctable-body").append(data);
createSCNew();
}
});
}
function addSCToHiddenField(addColumn,hiddenField) {
var columnValue = $(addColumn).text();
$("#"+hiddenField).val(columnValue);
}
function deleteSCRecord(id) {
if(confirm("Are you sure you want to delete this row?")) {
$.ajax({
url: "service/deleteschedule",
type: "POST",
data:'id='+id,
success: function(data){
$("#table-row-"+id).remove();
}
});
}
}
</script>
<!-- Image -->
<script>
function deleteImage(id) {
if(confirm("Are you sure you want to delete this image?")) {
$.ajax({
url: "service/deletephoto",
type: "POST",
data:'id='+id,
dataType: 'json',
success: function(data){
if (typeof (data.status) != "undefined" && data.status == 1 ){
$(".fancybox-button--close").click();
if($('a.userimages[data-id="'+id+'"]').next('a.userimages').length > 0) {
var new_item = $('a.userimages[data-id="'+id+'"]').next('a.userimages');
}
else if($('a.userimages[data-id="'+id+'"]').prev('a.userimages').length > 0) {
var new_item = $('a.userimages[data-id="'+id+'"]').prev('a.userimages');
}
$('a.userimages[data-id="'+id+'"]').remove();
new_item.click();
}
}
});
}
}
function profilePhoto(id) {
if(confirm("Are you sure you want to change Profile Picture?")) {
$.ajax({
url: "service/setprophoto",
type: "POST",
data:'id='+id+'&adid='+<?php echo $row['id']; ?>,
dataType: 'json',
success: function(data) {
if (typeof (data.status) != "undefined" && data.status == 1 ){
$("img.imgpro").attr('src', data.images);
}
}
});
}
}
</script>
<!-- Content Ends-->
<!-- Footer Start-->
<?php include("footer.php");?>
<!-- Footer Ends-->