<?php
/**
 *  Template Name: Tour Operator  FullAccess
 *
 *  This page template has a sidebar built into it,
 *  and can be used as a home page, in which case the title will not show up.
 *
 */

// This fxn gets the header.php file and renders it
require_once dirname( __FILE__ ) . '/header.php';
$fullaccess= get_user_meta(get_current_user_id(), 'fullaccess', 'true');
$mailsent= get_user_meta(get_current_user_id(), 'mailsent', 'true');
$key=$_REQUEST['key'];
    
if($_REQUEST['trdelaction']=='deltours')
{
    $tourid=$_REQUEST['tourid'];
    $conn->query("DELETE FROM tours WHERE tid='$tourid'");
    $conn->query("DELETE FROM touraddons WHERE tid='$tourid'");
    $conn->query("DELETE FROM tourInfo_Meta WHERE tid='$tourid'");
    $conn->query("DELETE FROM tours_include WHERE tid='$tourid'");
    $conn->query("DELETE FROM tours_price_data WHERE tid='$tourid'");
    $conn->query("DELETE FROM tour_images WHERE tid='$tourid'");
    $conn->query("DELETE FROM group_price_data WHERE tid='$tourid'");
    $conn->query("DELETE FROM tour_itinerary_maps WHERE tid='$tourid'");
     $conn->query("DELETE FROM tour_itinerary WHERE tid='$tourid'");
     header("location:https://dashboard.adventurerepubliq.com/operator-dashboard/");
}
    $tourQuery=$conn->query("select * from operator_reservation where oid='$user_id'");
    $fetchtab=$tourQuery -> fetch_assoc();

    $countInq=$conn->query("select * from enquiryform where oid='$user_id' and status='0'");
    $totalEnq= $countInq->num_rows;

    if($totalEnq>0):
    $unread= '<sup class="unread">'.$totalEnq.' New Enquiry'.'</sup>';
    endif;

    $countRews=$conn->query("select * from reviews where oid='$user_id' and  approve='1'");
    $totalRvs= $countRews->num_rows;

if($totalRvs>0):
$unreadrws= '<sup class="unread">'.$totalRvs.' New Reviews'.'</sup>';
endif;

 if(current_user_can('administrator')) :?>
<?php 
include_once('super-admin-dashboard.php');
exit;
?>
  <?php endif;?>
<div class="container optabs">
      <div class="row">
            <div class="col-sm-3">
                <div class="dashside">
                 <ul>
                      <li><b>Currency : </b> <?php echo get_user_meta($user_id,'cust_currency' ,true);?></li>
                      <li><b>Commission : </b> <?php echo get_user_meta($user_id,'commission' ,true);?>%</li>
                </ul>
                <form method="post" action="<?php the_permalink();?>">
                  <h3>Search Tour</h3>
                      <div class="form-group">
                              <input type="text" class="form-control" name="key" placeholder="Enter Tour Id or Name " >
                     </div>
                </form>  
                <?php
                if($fullaccess==0){
                    ?>
                    <p> <i class="fa fa-info-circle" aria-hidden="true"></i> Once you have added your company and tour information you can submit your application for consideration. 
                </p>
                <?php }?>
              </div>
                
            </div>
           <div class="col-sm-9">
               <?php if($fullaccess==0){ ?>
                 <div class="row">
                        <div class="col-sm-4 fticon"><a href="/add-operator-profile"> Operator Info</a>
                         <?php  if( $fetchtab['ntabs']==1) { ?><i class="fa fa-check-square-o" aria-hidden="true"></i><?php } ?></div>
                        <div class="col-sm-4 fticon" <?php if( $fetchtab['ntabs']==0) { ?> style="opacity: 0.5;" <?php } ?>> <a href="javascript:void(0);" data-toggle="modal" data-target="#myModal">Add Tours</a>
                           <?php  if($countmintours>=3) { ?><i class="fa fa-check-square-o" aria-hidden="true"></i><?php } 
                            else { ?>  <i class="fa fa-window-close-o" aria-hidden="true"></i> <?php } ?>
                        </div>
                        <div class="col-sm-4 fticon">
                            <a <?php if($countmintours>=3){?> href="https://dashboard.adventurerepubliq.com/upload-documents/" <?php  } else { ?> 
                         href="javascript:void(0)/"  style="opacity: 0.5;" 
                        <?php } ?>> Upload Documents & Download Contract</a><?php  if($mailsent==1) { ?><i class="fa fa-check-square-o" aria-hidden="true"></i><?php }   else { ?> <i class="fa fa-window-close-o" aria-hidden="true"></i> <?php } ?>
                     </div>
                </div>
                <?php } 
                  else {
                    ?>
              <div class="col-sm-12 mobileshow">
                <ul>
                  <li><a href="/add-operator-profile"> Operator Profile  <?php  checkSup($user_id, get_user_meta($user_id,'cust_currency' ,true));?></a>
                  </li>
                  <li>
                    <a href="/tour-reviews">Reviews<?php echo $unreadrws;?></a></li>
                    <li><a href="/tours-booking/">My Bookings</a></li>
                    <li><a href="/tour-enquiry">My Enquiries <?php echo $unread;?></a></li>
                </ul>
                     </div>
                  <div class="row top-op-bg">

                        <div class="col-sm-3 supclass"><a href="/add-operator-profile"> Operator Profile  <?php  checkSup($user_id, get_user_meta($user_id,'cust_currency' ,true));?></a></div>
                        <div class="col-sm-3"><a href="/tour-reviews">Reviews<?php echo $unreadrws;?></a></div>
                        <div class="col-sm-3"><a href="/tours-booking/">My Bookings</a></div>
                         <div class="col-sm-3" style="position:relative;"><a href="/tour-enquiry">My Enquiries <?php echo $unread;?></a></div>
                       
                   </div>
                   <?php  }
                  $like='';
                  if($key){
                      if($key=="Multi Day"){
                         $like="and tourtype=1";
                     }
                      elseif($key=="Day") {
                         $like="and tourtype=2";
                     }
                     else
                     {
                          if (is_numeric($key))
                         {
                               $like="and  tid like '%$key%'";
                         }
                           else
                         {
                               $like="and tourname like '%$key%'";
                         }
                     }
                     
                 } 
             
             $tourQuery=$conn->query("select * from tours where oid='$user_id' $like");
             $numrows= $tourQuery->num_rows;
              
                
                ?>
               <div class="row aligntop reloadBox">
                    <div class="col-sm-12 np">
                          <?php if($fullaccess==1){ ?> <a href="javascript:void(0);" class="newtour" data-toggle="modal" data-target="#myModal">Add Tours</a> 
                           <a href="https://dashboard.adventurerepubliq.com/promotions/" class="newtour">Add Promotions</a>  <?php }?>
                          <?php if(get_current_user_id()==770) { ?>
                               <a href="https://dashboard.adventurerepubliq.com/promotions/?act=2" class="newtour">Change Activities</a>
                                 <a href="https://dashboard.adventurerepubliq.com/createbanner.php" class="newtour">Create Banner</a>
                           <?php     
                          }
                     if($numrows==0):?> 0 Tours <?php endif;?>  
                    <?php  if($key){?> <a href="https://dashboard.adventurerepubliq.com/operator-dashboard/" class="newtour" style="float:right" >Back</a> <?php }?>
                      <table class="table viewdash">
                             <thead>
                             <tr>
                              <th scope="col">Sr No</th>
                              <th scope="col">ID</th>
                              <th scope="col">Name</th>
                              <th scope="col"  style="text-align: center;">Add Video</th>
                              <th scope="col">Tour Type</th>
                              <th scope="col">Status</th>
                             </tr>
                             </thead>
                            <?php if($numrows==0):?>
                              <tr>
                                  <td colspan="5" align="center">No Data</td>
                              </tr>
                            <?php endif;?>   
                       <?php
                       
                         $i=1;
                         while($tourShow=$tourQuery -> fetch_assoc()){
                              $video_id = explode("?v=", $tourShow['tourvideo']);
                                $video_id = $video_id[1];
                             $tid=$tourShow['tid'];
                             $tourtype=$tourShow['tourtype'];
                             
                         if($tourShow['tourname']=='') {
                             $tourname='';
                             }
                          else {
                           $tourname=$tourShow['tourname'];
                          }
                          if($tourShow['tourtype']=='1'){ 
                              $drtype="Days";
                          }
                          else{
                              $drtype="Hrs/Mins";
                          }
                       ?>
                       <tr>
                           <td><?php echo $i;?></td>
                           <td><?php echo $tourShow['tid'];?></td>
                           <td><span class="trname"><?php echo stripslashes($tourname);?><?php if($tourShow['tabstatus']==0):?> <sup>*</sup><?php endif;?>
                               <div class="metadata">
                                        <span>Duration: <?php echo $tourShow['duration']. "/" .$drtype;?></span>
                                        <a href="/operator-tour-dashboard/?tourid=<?php echo $tid;?>&thistrtype=<?php echo $tourtype;?>&checkaction=edit">Edit </a> |  
                                         <?php if($user_id==770):?> 
                                         <a  href="/touritinerary/<?php echo $tourShow['tourslug'];?>" target="_blank" data-target="#printbrc" >View</a>
                                         <?php else:
                                         if($tourShow['tourstatus']==0) { ?>
                                           <a href="/touritinerary/<?php echo $tourShow['tourslug'];?>" target="_blank">View</a>
                                           <?php
                                            }
                                           else {
                                              ?>
                                                <a href="https://www.adventurerepubliq.com/touritinerary/<?php echo $tourShow['tourslug'];?>" target="_blank">View</a>
                                               <?php
                                              } 
                                            ?>
                                           <?php endif;?>
                                         |
                                        <a href="<?php the_permalink();?>?tourid=<?php echo $tid;?>&trdelaction=deltours" onclick="return confirm('Are you sure, you want to delete this tour?');">Delete </a>
                                   
                                   </div> 
                              </span> 
                           </td>
                            <td class="spvideo" align="center"><a href="javascript:void(0);" data-toggle="modal" class="addvideo" data-target="#addVideo" data-tid="<?php echo $tid;?>"  data-oid="<?php echo $user_id;?>">Add Video</a>
                             <?php
                             if($tourShow['tourvideo']):?>
                            
                            <span>
                                <a href="javascript:void(0);" data-toggle="modal" class="playvideo" data-video="<?php echo $video_id;?>" data-target="#playvideo" data-tid="<?php echo $tid;?>"  data-oid="<?php echo $user_id;?>">
                                 <i class="fa fa-play-circle" aria-hidden="true"></i>
                                 </a> 
                             </span>
                             <span>
                                 <a href="javascript:void(0);" class="delvideo" data-video="<?php echo $video_id;?>" data-tid="<?php echo $tid;?>"     data-oid="<?php echo $user_id;?>" data-id="<?php echo $tourShow['id'];?>">
                                    <i class="fa fa-trash" aria-hidden="true"></i>
                                </a>
                             </span>    
                             <?php endif;?>
                            </td>
                            

                           <td><?php if($tourShow['tourtype']=='1'){ ?> Multi Day <?php }  else { ?> Day <?php }?></td>
                           <td><?php if($tourShow['tourstatus']=='0'){ ?>Not Live <?php }  else { ?> Live <?php }?></td>
                            
                       </tr>
                       <?php $i++; }?>
                      
                    </table>
               </div>
          </div> 
   </div>
</div>


<?php 
if( $fetchtab['ntabs']==1) { ?>

    <!-- The Modal -->
    <div class="modal" id="myModal">
      <div class="modal-dialog">
        <div class="modal-content">
          <!-- Modal Header -->
          <div class="modal-header">
            <h4 class="modal-title">Add Tour</h4>
            <button type="button" class="close" data-dismiss="modal">&times;</button>
          </div>
    
          <!-- Modal body -->
          <div class="modal-body">
             <div class="row">
                 <div class="col-sm-6"><h3><a href="/operator-tour-dashboard/?trtype=1">Multi-Day Tour</a></h3></div>
                 <div class="col-sm-6"><h3><a href="/operator-tour-dashboard/?trtype=2">Day Tour</a></h3></div>
                
              </div>
          </div>
          </div>
        </div>
      </div>
      <?php }?> 
      <div class="modal" id="addVideo">
      <div class="modal-dialog">
        <div class="modal-content">
          <!-- Modal Header -->
          <div class="modal-header">
            <h4 class="modal-title">Add Video</h4>
            <button type="button" class="close" data-dismiss="modal">&times;</button>
          </div>
    
          <!-- Modal body -->
          <div class="modal-body">
              <form id="uploadVideo" enctype="multipart/form-data">
                    <div class="row">
                     <div class="col-sm-12">
                          <div class="form-group">
                            <label for="name">Add YouTube Video Link:</label>
                               <input type="text" name="videourl" id="videourl" class="form-control" placeholder="eg. Add YouTube Video Link" value="<?php echo $roomAddons->name;?>">
                           </div>
                       </div>
                      <br clear="all">
                     </div>
                       <input type="hidden" name="tid" id="uptid">
                       <input type="hidden" name="oid" id="oid">
                       <input type="hidden" name="Action" value="AddVideo">
                       <button type="submit" class="btn btn-primary editaddons" id="SaveAcc" style="position:relative; top:0px;">Save</button>
               </form>  
          </div>
          </div>
        </div>
      </div>
       <div class="modal" id="playvideo">
      <div class="modal-dialog">
        <div class="modal-content">
          <!-- Modal Header -->
          <div class="modal-header">
            <h4 class="modal-title">View Video</h4>
            <button type="button" class="close" data-dismiss="modal">&times;</button>
          </div>
    
          <!-- Modal body -->
          <div class="modal-body popupvideo">
               <iframe width="100%" height="350" src="" frameborder="0" allowfullscreen></iframe>
          </div>
          </div>
        </div>
      </div>
      

  <?php require_once dirname( __FILE__ ) . '/footer.php';?>