<?php 
include_once 'classes/currency.class.php';
require_once 'classes/curl.class.php';
require_once 'classes/viewPage.class.php';
require_once 'dbConnection.php';
//require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );

function hotels_deals_display($atts, $widget_type = 0) {    
  $out = array();
  $title_placeholder = $before_title = $after_title = $city = $country = $state = $neighbourhood = $image_style = $loading_title = '';
  $i = 0;
  
  extract( shortcode_atts( array(
        'title' => 'Deals of the month',
        'template' => 'hotel_deals_api',
        'no_of_items' => '12',
        'widget_flag' => 1,
        'search_string' => ''
    ), $atts ) );

    $title = apply_filters( 'widget_title', $atts['title'] );
    $no_of_items = apply_filters('no_of_items', $atts['no_of_items']);
    $start_date = apply_filters('start_date', $atts['start_date']);
    $end_date = apply_filters('end_date', $atts['end_date']);
    $search_string = apply_filters('search_string', $atts['search_string']);
    $min_price = apply_filters('min_price', $atts['min_price']); 
    $max_price = apply_filters('max_price', $atts['max_price']); 
    $min_star = apply_filters('min_star', $atts['min_star']); 
    $max_star = apply_filters('max_star', $atts['max_star']); 
    $template = apply_filters('widget_template', $atts['template']);
    $amenities = apply_filters( 'amenities', $atts['amenities'] );
    $description = apply_filters( 'description', $atts['description'] );

  if(get_query_var('RegionNameLong') != '') {
        $search_string = '';
        $regionNameLong = get_query_var('RegionNameLong');
        $regionNameArr = explode(', ', $regionNameLong);
        $displayCityName = get_query_var('display_city_name');
        $region = $regionNameArr[0];
        $parent_region = $regionNameArr[1];
        if($displayCityName != "" || $displayCityName != NULL)
                {
                    $region = $displayCityName;
                    $parent_region ="";
                }
                
        $title = str_replace('{%region%}', region_clean($region), $title);
        if($parent_region=='') $title = str_replace(', {%parent_region%}', '', $title);
        $title = str_replace('{%parent_region%}', $parent_region, $title);
  }  else if(get_query_var('holiday_type_id') != ''){
        global $wpdb;
        $table_holiday_desc = $wpdb->prefix.'holiday_description';
        $holiday_type_id = get_query_var('holiday_type_id');
        $holiday_type_res = $wpdb->get_row("SELECT holiday_type_name FROM $table_holiday_desc WHERE id = " . $holiday_type_id . " AND status = 1");
        $holiday_type = ucwords($holiday_type_res->holiday_type_name);
        $title = str_replace('{%holiday_type%}', $holiday_type, $title);
  }
  else {
    $title = ucwords($title);
  }
  $loading_title = 'Loading ' . $title . '&hellip;';

  $out['ajax_call_to'] =  'hotel_deals_api.php';
  $out['plugin_dir_path'] = plugin_dir_url(__FILE__);
  $out['RegionID'] = get_query_var('RegionID');
  $out['RegionNameLong'] = $regionNameLong;
  $out['search_string'] = $search_string;
  $out['holiday_type'] = $holiday_type;
  $out['no_of_items'] = $no_of_items;
  $out['start_date'] = $start_date;
  $out['end_date'] = $end_date;
  $out['widget_title'] = $title;
  $out['loading_title'] = $loading_title;
  $out['min_price'] = $min_price;
  $out['max_price'] = $max_price;
  $out['min_star'] =  $min_star;
  $out['max_star'] =  $max_star;
  $out['template'] = $template;
  $out['description'] = $description;
  if(count($amenities) == 0){
      $out['amenities'] = 0;
  }
  else{
      $out['amenities'] = $amenities;
  }
  return $out;
}

// Register and load the widget
function Deals_of_Month_Widget() {
    register_widget( 'Deals_of_Month_Widget' );
}
add_action( 'widgets_init', 'Deals_of_Month_Widget' );
add_shortcode('dealsOfMonth', 'deals_of_month_display');


Class Deals_of_Month_Widget extends WP_Widget{
    function __construct() {
        parent::__construct('Deals_of_Month_Widget', __('Deals Of The Month', 'qc_hotel_booking'), array( 'description' => __( 'Display deals of cities those promoted on home page.', 'qc_hotel_booking' )));
    }
    
    public function widget( $args, $instance ) {
        extract($args, EXTR_SKIP);   
        
        $atts = array_merge($args, $instance, array('widget_flag' => 1));
        
        $deals_detail = deals_of_month_display($atts);
        
        if($deals_detail) {
          echo $before_widget;
          echo $deals_detail;
          echo $after_widget;
        }
    }  

    public function form($instance) {
        $title = __( 'Enter title', 'qc_hotel_booking' );
        $no_of_items = __('12', 'qc_hotel_booking');
        $amenities = $instance['amenities'];
        if ( isset( $instance[ 'title' ]))
            $title = $instance[ 'title' ];
        
        if( isset($instance['no_of_items']))
             $no_of_items = $instance[ 'no_of_items' ];
        
        if( isset($instance['start_date']))
             $start_date = $instance[ 'start_date' ];
        
        if( isset($instance['end_date']))
             $end_date = $instance['end_date'];

        if( isset($instance['min_price']))
             $min_price = $instance['min_price'];
         
        if( isset($instance['max_price']))
             $max_price = $instance['max_price'];
          
        if( isset($instance['min_star']))
             $min_star = $instance['min_star'];
           
        if( isset($instance['max_star']))
             $max_star = $instance['max_star'];
        
        if( isset($instance['description']))
             $description = $instance['description'];

        if (isset($instance['template'])) {
            $template = $instance['template'];
        } else {
            $template = __('Template Name', 'qc_hotel_booking');
        }

        // Widget admin form
        ?>
<script type="text/javascript">
   jQuery(function() {
    jQuery( ".datepicker" ).datepicker();
   });
    </script>
        <p>
        <label for="<?php echo $this->get_field_id( 'title' ); ?>"><?php _e( 'Title' ); ?>:</label> 
        <input class="widefat" id="<?php echo $this->get_field_id( 'title' ); ?>" name="<?php echo $this->get_field_name( 'title' ); ?>" type="text" value="<?php echo esc_attr( $title ); ?>" />

        <label for="<?php echo $this->get_field_id( 'no_of_items' ); ?>"><?php _e( 'No of Items' ); ?>:</label> 
        <input class="widefat" id="<?php echo $this->get_field_id( 'no_of_items' ); ?>" name="<?php echo $this->get_field_name( 'no_of_items' ); ?>" type="text" value="<?php echo esc_attr( $no_of_items ); ?>" />
        
        <label for="<?php echo $this->get_field_id( 'description' ); ?>"><?php _e( 'Description:' ); ?></label> 
        <textarea class="widefat" id="<?php echo $this->get_field_id( 'description' ); ?>" name="<?php echo $this->get_field_name( 'description' ); ?>"><?php echo esc_attr( $description); ?></textarea>
            
        <label for="<?php echo $this->get_field_id( 'start_date' ); ?>"><?php _e( 'Start Date' ); ?>:</label> 
        <input class="widefat datepicker" id="<?php echo $this->get_field_id( 'start_date' ); ?>" name="<?php echo $this->get_field_name( 'start_date' ); ?>" type="text" value="<?php echo esc_attr( $start_date ); ?>"/>
        
        <label for="<?php echo $this->get_field_id( 'end_date' ); ?>"><?php _e( 'End Date' ); ?>:</label> 
        <input class="widefat datepicker" id="<?php echo $this->get_field_id( 'end_date' ); ?>" name="<?php echo $this->get_field_name( 'end_date' ); ?>" type="text" value="<?php echo esc_attr( $end_date ); ?>"/>
        
        <label for="<?php echo $this->get_field_id( 'min_price' ); ?>"><?php _e( 'Min Price Range' ); ?>(in $ USD):</label> 
        <input class="widefat" id="<?php echo $this->get_field_id( 'min_price' ); ?>" name="<?php echo $this->get_field_name( 'min_price' ); ?>" type="text" value="<?php echo esc_attr( $min_price ); ?>"/>
        
        <label for="<?php echo $this->get_field_id( 'max_price' ); ?>"><?php _e( 'Max Price Range' ); ?>(in $ USD):</label> 
        <input class="widefat" id="<?php echo $this->get_field_id( 'max_price' ); ?>" name="<?php echo $this->get_field_name( 'max_price' ); ?>" type="text" value="<?php echo esc_attr( $max_price ); ?>"/>
        
         <label for="<?php echo $this->get_field_id( 'min_star' ); ?>"><?php _e( 'Min Star Rating' ); ?>:</label> 
        <input class="widefat" id="<?php echo $this->get_field_id( 'min_star' ); ?>" name="<?php echo $this->get_field_name( 'min_star' ); ?>" type="text" value="<?php echo esc_attr( $min_star); ?>"/>
        
         <label for="<?php echo $this->get_field_id( 'max_star' ); ?>"><?php _e( 'Max Star Rating' ); ?>:</label> 
        <input class="widefat" id="<?php echo $this->get_field_id( 'max_star' ); ?>" name="<?php echo $this->get_field_name( 'max_star' ); ?>" type="text" value="<?php echo esc_attr( $max_star ); ?>"/>

        <label for="<?php echo $this->get_field_id( 'template' ); ?>"><?php _e( 'Template:' ); ?></label>
        <select class="widefat" id="<?php echo $this->get_field_id('template'); ?>" name="<?php echo $this->get_field_name('template'); ?>">
           <option value="default" <?php selected($instance['template'], 'default'); ?>>Default</option>
           <option value="layout1" <?php selected($instance['template'], 'layout1'); ?>>Layout_1</option>
           <option value="layout2" <?php selected($instance['template'], 'layout2'); ?>>Layout_2</option>
        </select> 
       <h4>
            <label for="<?php echo $this->get_field_id( 'amenities' ); ?>">
                <?php _e( 'Amenities:' ); ?><br />
            </label>
       </h4>    
       <?php $amenities_array = array(1=>'Internet Access (WIFI/WIRED)', 2 => 'Swimming Pool', 3 => 'Television',  4 => 'Coffee',  5 => 'Air Conditioning',  6 => 'Fitness Facility',  7 => 'Fridge',  8 => 'Bar',  9 => 'Smoking Allowed',  10 => 'Entertainment',  11 => 'Secure Vault',  12 => 'Pick and Drop',  13 => 'Room Service', 14=>'Pets Allowed',  15 => 'Play Place',  16 => 'Breakfast',  17 => 'Parking',  18 => 'Conference/Meeting Room',  19 => 'Fire Place',  20 => 'Handicap Accessible',  21 => 'Doorman',  22 => 'Shower / Bath Tub / Spa Tub',  23 => 'Elevator in Building',  24 => 'Suitable for Events',  25 => 'Child Care',  26 => 'SPA',  27 => 'External Facilities',  28 => 'Room Facilities', );?>
        <div style="overflow-y:scroll;height: 175px;border: 1px solid #e0e0e0;padding: 5px;">
            <?php foreach($amenities_array as $id => $name) { ?>
               <input id="<?php echo $this->get_field_id('amenities') . $id; ?>" name="<?php echo $this->get_field_name('amenities'); ?>[]" type="checkbox" value="<?php echo $id; ?>" <?php if(count($amenities) == 0){}else{if(in_array($id, $amenities)) echo 'checked="checked"';} ?> style="margin: 10px 0;"/><?php echo $name; ?><br />
           <?php } ?>
        </div> 
        </p>
    <?php 
    }

    public function update($new_instance, $old_instance) {
        $instance = array();
        $instance['title'] =(!empty($new_instance['title']))?strip_tags($new_instance['title']) : '';
        $instance['template'] =(!empty($new_instance['template']))?strip_tags($new_instance['template']): '';        
        $instance['no_of_items'] = ( ! empty( $new_instance['no_of_items'] ) ) ? strip_tags( $new_instance['no_of_items'] ) : '';        
        $instance['start_date'] = ( ! empty( $new_instance['start_date'] ) ) ? strip_tags( $new_instance['start_date'] ) : '';        
        $instance['end_date'] = ( ! empty( $new_instance['end_date'] ) ) ? strip_tags( $new_instance['end_date'] ) : '';        
        $instance['min_price'] = ( ! empty( $new_instance['min_price'] ) ) ? strip_tags( $new_instance['min_price'] ) : ''; 
        $instance['max_price'] = ( ! empty( $new_instance['max_price'] ) ) ? strip_tags( $new_instance['max_price'] ) : ''; 
        $instance['min_star'] = ( ! empty( $new_instance['min_star'] ) ) ? strip_tags( $new_instance['min_star'] ) : ''; 
        $instance['max_star'] = ( ! empty( $new_instance['max_star'] ) ) ? strip_tags( $new_instance['max_star'] ) : ''; 
        $instance['description'] = ( ! empty( $new_instance['description'] ) ) ? strip_tags( $new_instance['description'] ) : ''; 
        $instance['amenities'] = array();

        if ( isset ( $new_instance['amenities'] ) )
        {
            foreach ( $new_instance['amenities'] as $value )
            {
                if ( '' !== trim( $value ) )
                    $instance['amenities'][] = $value;
            }
        }
        
        return $instance;        
    }
}

function deals_of_month_display($atts) {
  global $wpdb;
  $cities = array();
  
  if(get_query_var('holiday_type_id') != '') {
    $holiday_type_id = get_query_var('holiday_type_id');
    $table_holiday_desc = $wpdb->prefix.'holiday_description';
    $table_holiday_type_has_cities = $wpdb->prefix.'holiday_type_has_cities';
    $token = new token();
    $type = $token->url_replace(get_query_var('holiday_type'));
    $holiday_type_row = $wpdb->get_row("SELECT id, image, description FROM $table_holiday_desc WHERE id LIKE " . $holiday_type_id . " AND status = 1");

    if(!empty($holiday_type_row)) {
        $sql_get_cities = "SELECT city_name  FROM $table_holiday_type_has_cities WHERE holiday_desc_id = $holiday_type_id";
        $row_get_cities = $wpdb->get_results($sql_get_cities);
        foreach($row_get_cities AS $row_get_cities) {
          $cities[] = $row_get_cities->city_name;
        }
    }
  }
  else {  
    $res = $wpdb->get_results('SELECT city_name FROM '.$wpdb->prefix.'city_description WHERE promote_home = 1 ORDER BY RAND() LIMIT 4'); 
    if(!empty($res)) {
      foreach($res AS $city_name)
        $cities[] = $city_name->city_name;
    }
  }
  
  if(count($cities)>0)
    $atts['search_string'] = implode('~', $cities);
  else
    $atts['search_string'] = '';
         
  $output = hotels_deals_display($atts, 1);
  $page = new TinyTpl();
  $page->deals_data = $output;
  $template_directory = get_template_directory();
  return $page->render($template_directory . "/templates/deals_carousel.tpl.php");
}