$dpart->modify('-1 day');
--
-- Structure de la table `wp_booking`
--
DROP TABLE IF EXISTS `wp_booking`;
CREATE TABLE IF NOT EXISTS `wp_booking` (
`id_booking` int(11) NOT NULL AUTO_INCREMENT,
`nom_booking` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`email_bokking` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`tel_booking` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`chambre_nom_booking` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`chambre_id_booking` int(11) DEFAULT NULL,
`lang_booking` varchar(15) COLLATE latin1_general_ci DEFAULT NULL,
`source_name_booking` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
`source_id_booking` int(11) DEFAULT NULL,
`date_arrivee_booking` date DEFAULT NULL,
`date_depart_booking` date DEFAULT NULL,
`message_booking` text COLLATE latin1_general_ci,
`state_booking` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
`date_ajouter_booking` date DEFAULT NULL,
`date_valider_booking` date DEFAULT NULL,
`class_booking` varchar(15) COLLATE latin1_general_ci DEFAULT NULL,
PRIMARY KEY (`id_booking`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Structure de la table `wp_booking_setting`
--
DROP TABLE IF EXISTS `wp_booking_setting`;
CREATE TABLE IF NOT EXISTS `wp_booking_setting` (
`id_booking_setting` int(11) NOT NULL AUTO_INCREMENT,
`type_booking_setting` varchar(25) COLLATE latin1_general_ci DEFAULT NULL,
`txt_fr` text COLLATE latin1_general_ci,
`txt_en` text COLLATE latin1_general_ci,
`txt_es` text COLLATE latin1_general_ci,
`type_msg` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
PRIMARY KEY (`id_booking_setting`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET @datearrivee = '2017-11-02'; SET @datedepart = '2017-11-09'; SELECT `id_booking_setting` as id, txt_fr as txt FROM `wp_booking_setting` S WHERE `type_booking_setting` = 'chambre' AND `id_booking_setting` NOT IN ( SELECT `chambre_id_booking` FROM `wp_booking` B WHERE class_booking != 'annuler' AND ( @datearrivee between date_arrivee_booking AND DATE_ADD(date_depart_booking,INTERVAL +1 DAY) OR @datedepart between date_arrivee_booking AND DATE_ADD(date_depart_booking,INTERVAL +1 DAY) )
public function form_room_select($arrive = null,$dpart = null, $lang = null){
global $wpdb;
$option = "";
if(!empty($arrive)):
if(empty($lang))
$lang = "fr";
$arrive = new DateTime($arrive);
$arrive = $arrive->format('Y-m-d');
$dpart = new DateTime($dpart);
$dpart->modify('-1 day');
$dpart = $dpart->format('Y-m-d');
$sql = "SELECT `id_booking_setting` as id, `txt_".$lang."` as txt
FROM `{$wpdb->prefix}booking_setting`
WHERE `type_booking_setting` = 'chambre'
AND `id_booking_setting` not in (
SELECT `chambre_id_booking`
FROM `{$wpdb->prefix}booking`
WHERE class_booking != 'annuler'
and ( `date_arrivee_booking` between '".$arrive."' and '".$dpart."'
and DATE_ADD(`date_depart_booking`, INTERVAL -1 DAY) between '".$arrive."' and '".$dpart."' )
) group by `id_booking_setting`";
// die($sql);
$rooms = $wpdb->get_results($sql);
if(!empty($rooms))
foreach($rooms as $ro)
$option .= "<option value='".$ro->id."/".str_replace(array("\\","'")," ",$ro->txt)."'>".str_replace("\\","",$ro->txt)."</option>";
endif;
return $option;
8 nov. 2017 à 16:17
je suis pas un développeur , j'arrive pas de comprendre pourquoi je veux juste modifier cette partie de mon site site et j'arrive plus