API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 20th, 2013
176
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.65 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. include_once( 'wp-load.php' );
  4. get_header();
  5.  
  6. if($_REQUEST['backandedit']) {
  7. // Do nothing
  8. }else{
  9. $_SESSION['booking_info'] = array();
  10. }
  11. ?>
  12. <?php templ_page_title_above(); //page title above action hook?>
  13. <div class="main_header" style="background:url(<?php bloginfo('template_directory'); ?>/images/dummy/s9.jpg) no-repeat center top;">
  14. <div class="main_header_in">
  15. <div class="post-meta"><h1><?php _e(BOOK_STAY_TEXT);?></h1></div>
  16. </div>
  17. </div>
  18. <div class="main_sepretor"></div>
  19. <?php templ_page_title_below(); //page title below action hook?>
  20. <div id="pages" class="clear" >
  21. <div class="<?php templ_content_css();?>" >
  22. <!-- CONTENT AREA START -->
  23. <div class="entry">
  24. <div <?php post_class('single clear'); ?> id="post_<?php the_ID(); ?>">
  25. <div class="post-content">
  26. <script type='text/javascript'>var rootfolderpath = '<?php echo bloginfo('template_directory');?>/images/';</script>
  27. <script type="text/javascript" src="<?php bloginfo('template_directory'); ?>/js/dhtmlgoodies_calendar.js"></script>
  28. <?php
  29.  
  30. $time_check_in_date = strtotime($_SESSION['side_check_in_date']);
  31. $time_check_out_date = strtotime($_SESSION['side_check_out_date']);
  32. $no_rooms = $_SESSION['side_no_rooms'];
  33. $room_type = $_SESSION['side_room_type'];
  34. $adults = $_SESSION['side_adults'];
  35. $days_between = ceil(abs($time_check_out_date - $time_check_in_date) / 86400);
  36. global $wpdb;
  37. $additional_price_table = $wpdb->prefix . "additional_price_master";
  38. $additional_child_table = $wpdb->prefix . "additional_price_child";
  39. $price_table = $wpdb->prefix . "room_type_price";
  40. $posts = $wpdb->prefix . "posts";
  41. $postmeta = $wpdb->prefix . "postmeta";
  42. $r_cnt = 0;
  43. $a_cnt = 0;
  44.  
  45. $final_price = 0;
  46. $add_final_price = 0;
  47. $afinal_price = 0;
  48. $check_in_date = $_SESSION['side_check_in_date'];
  49. $check_out_date = $_SESSION['side_check_out_date'];
  50. //echo "select additional_price_id,from_date,to_date from $additional_price_table where room_type_id = '".$room_type."' and price_status ='Y' and (( from_date between '".$check_in_date."' and '".$check_out_date."' ) or ( to_date between '".$check_in_date."' and '".$check_out_date."' ) or ( '".$check_in_date."' between from_date and to_date ) or ( '".$check_out_date."' between from_date and to_date ))";
  51. //$chk_additional_price_sql = mysql_query("select additional_price_id,from_date,to_date from $additional_price_table where room_type_id = '".$room_type."' and price_status ='Y' and ('".$check_in_date."' Between from_date and to_date) or ('".$check_out_date."' Between from_date and to_date)");
  52. $chk_additional_price_res = $wpdb->get_results("select additional_price_id,from_date,to_date from $additional_price_table where room_type_id = '".$room_type."' and price_status ='Y' and (( from_date between '".$check_in_date."' and '".$check_out_date."' ) or ( to_date between '".$check_in_date."' and '".$check_out_date."' ) or ( '".$check_in_date."' between from_date and to_date ) or ( '".$check_out_date."' between from_date and to_date ))");
  53.  
  54.  
  55. for($i=0;$i<$days_between;$i++)
  56. {
  57. $count = 0;
  58. if(count($chk_additional_price_res) > 0 ){
  59. for($k=0;$k<count($chk_additional_price_res);$k++)
  60. {
  61. if(strtotime($chk_additional_price_res[$k]->from_date)<= strtotime($check_in_date) && strtotime($chk_additional_price_res[$k]->to_date)>= strtotime($check_in_date) )
  62. {
  63. $price_achild_sql = mysql_query("select * from $additional_child_table where additional_price_id = '".$chk_additional_price_res[$k]->additional_price_id."' and person = '".$adults."'");
  64. $price_achild_res = mysql_fetch_array($price_achild_sql);
  65. $add_final_price += $price_achild_res['additional_price'];
  66. $count = 1;
  67. }
  68. }
  69. for($k=0;$k<count($chk_additional_price_res);$k++)
  70. {
  71. if((strtotime($chk_additional_price_res[$k]->from_date) > strtotime($check_in_date) ) && (strtotime($chk_additional_price_res[$k]->to_date) < strtotime($check_in_date) ) || $count == 0 )
  72. {
  73.  
  74. if($a == $check_in_date)
  75. {
  76. continue;
  77. }
  78. else
  79. {
  80. $price = explode(",",get_post_meta($room_type,'roomtype_cap_price',true));
  81. for($k=1;$k<=count($price);$k++)
  82. {
  83. if($k == $adults)
  84. {
  85. $afinal_price += ($price[($k-1)]);
  86. }
  87. }
  88. }
  89. }
  90. }
  91.  
  92. }else {
  93. //$price_child_sql = mysql_query("select * from $posts,$postmeta where room_type_id = '".$room_type."' and person = '".$adults."'");
  94. //$price_child_res = mysql_fetch_array($price_child_sql);
  95.  
  96. $price = explode(",",get_post_meta($room_type,'roomtype_cap_price',true));
  97. for($j=1;$j<=count($price);$j++)
  98. {
  99. if($j == $adults)
  100. {
  101. $afinal_price += $price[($j-1)];
  102. }
  103. }
  104.  
  105. //$afinal_price += $price_child_res['price'];
  106. }
  107. $newdate = strtotime ( '+1 day' , strtotime ( $check_in_date ) ) ;
  108. $check_in_date = date ( 'Y-m-d' , $newdate );
  109. //$check_in_date1 = explode("-",date('Y-m-d',strtotime($check_in_date)));
  110. //$check_in_date = mktime(0,0,0,$check_in_date1[1],$check_in_date1[2]+1,$check_in_date1[0]);
  111.  
  112. }
  113.  
  114. $ss = ($final_price + $add_final_price + $afinal_price) * $no_rooms;
  115.  
  116.  
  117. $room_error_msg = 'false';
  118.  
  119. $no_room = get_post_meta($room_type,'no_rooms',true);
  120.  
  121. if($no_room == 0){
  122. $room_error_msg = 'true';
  123.  
  124. }
  125.  
  126. elseif($no_room == $no_rooms || $no_room > $no_rooms) {
  127.  
  128. $booking_check_avilability_table = $wpdb->prefix . 'booking_check_avilability';
  129. $fetch_booking_schedule_sql = $wpdb->get_results("select sum(total_room) as total_room from $booking_check_avilability_table where room_type_id = '".$room_type."' and ((check_in_date between '".$_SESSION['side_check_in_date']."' and '".$_SESSION['side_check_out_date']."') or (check_out_date between '".$_SESSION['side_check_in_date']."' and '".$_SESSION['side_check_out_date']."') or (check_in_date <= '".$_SESSION['side_check_in_date']."' and check_out_date >= '".$_SESSION['side_check_in_date']."') or (check_in_date >= '".$_SESSION['side_check_out_date']."' and check_out_date <= '".$_SESSION['side_check_out_date']."'))");
  130.  
  131.  
  132. if(count($fetch_booking_schedule_sql) > 0){
  133. foreach($fetch_booking_schedule_sql as $fetch_booking_schedule_res){
  134. $chk_room_cnt = $no_room - $fetch_booking_schedule_res->total_room;
  135. if( $no_rooms > $chk_room_cnt){
  136. $cancel_booking_msg = 'true';
  137. } else {
  138. $booking_id[] = $fetch_booking_schedule_res->booking_id;
  139. $cancel_booking_msg = 'false';
  140. }
  141. }
  142. }else {
  143. $cancel_booking_msg = 'false';
  144. }
  145. $room_error_msg = 'false';
  146. } else {
  147. $cancel_booking_msg = 'true';
  148. $room_error_msg = 'false';
  149. }
  150. $request_text = '<h3 class="btitle">'.REQUEST_TEXT.'</h3><div class="booking">
  151. <span><label class="booking_label">'.ROOM_TYPE.'</label> : '.fecth_room_type_name($room_type).' </span>
  152. <span><label class="booking_label">'.CHECK_IN_TEXT.'</label> : '.date('d F Y',strtotime($_SESSION['side_check_in_date'])).'</span>
  153. <span><label class="booking_label">'.CHECK_OUT_TEXT.'</label> : '.date('d F Y',strtotime($check_out_date)).'</span>
  154. <span><label class="booking_label">'.DAYS_TEXT.'</label> : '.$days_between.'</span>
  155. <span><label class="booking_label">'.NO_ROOMS_TEXT.'</label> : '.$no_rooms.'</span>
  156. <span><label class="booking_label">'.OCCUPY_TEXT.'</label> : '.$adults.'</span>';
  157. if($ss != '0') {
  158. $request_text .= '<span><label class="booking_label">'.ROOM_PRICE_TEXT.'</label> : '.display_amount_with_currency($ss,display_currency()).'</span>';
  159. }
  160. $request_text .= '</div>';
  161. if($cancel_booking_msg == 'true' && $room_error_msg == 'false'){
  162. echo '<div class="error_msg">'.fetch_global_settings('not_available_msg').'</div><br />';
  163. echo $request_text;
  164. } else if($cancel_booking_msg == 'false' && $room_error_msg == 'false') {
  165. echo $request_text;
  166. echo '<form name="booking_frm" id="booking_frm" action="'.get_option('siteurl').'/?ptype=submit_booking" method="post" class="booking_form" >
  167. <input type="hidden" name="booking_id[]" value="'.$booking_id.'" />
  168. <input type="hidden" name="check_in_date" value="'.$_SESSION['side_check_in_date'].'" />
  169. <input type="hidden" name="check_out_date" value="'.$check_out_date.'" />
  170. <input type="hidden" name="no_rooms" value="'.$no_rooms.'" />
  171. <input type="hidden" name="room_type" value="'.$room_type.'" />
  172. <input type="hidden" name="adults" value="'.$adults.'" />';
  173. echo '<h3 class="btitle">'.PERSONAL_INFO_TEXT.'</h3>';
  174. personal_info_form('booking_frm');
  175. echo '<div class="booking_form_display"> <h3 class="btitle">'.SERVICE_COUPON_TEXT.'</h3>
  176. <div class="bfrl"> <label class="booking_label">'.SERVICE_TEXT.'</label>';
  177. $s_count = 0;
  178. $service_master = $wpdb->prefix . "service_master";
  179. $service_find_sql = mysql_query("select service_id,service_name,service_price from $service_master where service_status = 'E' ");
  180. while($service_find_res = mysql_fetch_array($service_find_sql)){
  181. if($_SESSION['booking_info']['service_id'] != ''){
  182. $service_checked = '';
  183. $service_value = $_SESSION['booking_info']['service_id'][$s_count];
  184. if($service_find_res['service_id'] == $service_value){
  185. $service_checked = 'checked';
  186. } else {
  187. $service_checked = '';
  188. }
  189. $s_count ++;
  190. }
  191. echo '<span class="bfr_service"><input type="checkbox" value="'.$service_find_res['service_id'].'" name="service_id[]" id="service_id_'.$service_find_res['service_id'].'" "'.$service_checked.'" />&nbsp;'.$service_find_res['service_name'].'&nbsp;('.display_amount_with_currency($service_find_res['service_price'],display_currency()).')</span>';
  192. }
  193. echo '</div>' ;
  194. if(get_option('is_allow_coupon_code')){
  195. echo '<h3 class="btitle">'.COUPON_CODE_TITLE_TEXT.'</h3>
  196. <div class="booking_form_display clearfix">
  197. <label class="booking_label">'.PRO_ADD_COUPON_TEXT.' : </label>
  198. <input type="text" name="booking_add_coupon" id="booking_add_coupon" class="textfield" value="'.esc_attr(stripslashes($booking_add_coupon)).'" />
  199. <span class="note">'.COUPON_NOTE_TEXT.'</span>
  200. </div>';
  201.  
  202. }
  203. echo '</div>
  204. <input type="hidden" name="payble_amount" id="payble_amount" value="'.$ss.'" />
  205. <input type="submit" name="book_now" id="book_now" value="Book Now" class="button" />
  206. </form> ';
  207. } else if($room_error_msg == 'true') {
  208. echo '<p class="error_msg">There is no room available in '.fecth_room_type_name($room_type).'</p>';
  209. echo $request_text;
  210. } else {
  211. // Do nothing
  212. }
  213.  
  214. ?>
  215. </div>
  216. </div>
  217. </div>
  218. <!-- CONTENT AREA END -->
  219. </div>
  220. <?php
  221. $validation_info = array();
  222. foreach($form_fields as $key=>$val)
  223. {
  224. $str = ''; $fval = '';
  225. $field_val = $key.'_val';
  226. $validation_info[] = array(
  227. 'title' => $val['title'],
  228. 'name' => $key,
  229. 'espan' => $key.'_error',
  230. 'type' => $val['type'],
  231. 'text' => $val['text'],
  232. 'validation_type' => $val['validation_type']);
  233. }
  234. include_once(TEMPL_USER_BOOKING_FOLDER . 'submition_validation.php');
  235. get_sidebar();
  236. get_footer(); ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!