php – 按可用日期查询woocommerce预订

@H_404_0@ 我在我的woocommerce网站上使用 Woothemes booking

当我构建自定义搜索产品时,我还要搜索可用性,这里是我应该如何管理B.O的可用性以及插件如何存储到数据库

a:8:{i:0;a:4:{s:4:"type";s:4:"days";s:8:"bookable";s:3:"yes";s:4:"from";s:1:"3";s:2:"to";s:1:"3";}i:1;a:4:{s:4:"type";s:6:"custom";s:8:"bookable";s:3:"yes";s:4:"from";s:10:"2015-07-09";s:2:"to";s:10:"2015-07-09";}i:2;a:4:{s:4:"type";s:6:"custom";s:8:"bookable";s:3:"yes";s:4:"from";s:10:"2015-07-08";s:2:"to";s:10:"2015-07-08";}i:3;a:4:{s:4:"type";s:6:"custom";s:8:"bookable";s:3:"yes";s:4:"from";s:10:"2015-07-10";s:2:"to";s:10:"2015-07-10";}i:4;a:4:{s:4:"type";s:6:"custom";s:8:"bookable";s:3:"yes";s:4:"from";s:10:"2015-07-15";s:2:"to";s:10:"2015-07-15";}i:5;a:4:{s:4:"type";s:6:"custom";s:8:"bookable";s:3:"yes";s:4:"from";s:10:"2015-07-16";s:2:"to";s:10:"2015-07-16";}i:6;a:4:{s:4:"type";s:6:"custom";s:8:"bookable";s:3:"yes";s:4:"from";s:10:"2015-07-17";s:2:"to";s:10:"2015-07-17";}i:7;a:4:{s:4:"type";s:6:"months";s:8:"bookable";s:2:"no";s:4:"from";s:1:"8";s:2:"to";s:1:"8";}}

我可以从wordpress内置函数 get_post_meta中检索这些值,

$avail = get_post_meta($product->id,'_wc_booking_availability');

结果是：

Array
(
[0] => Array
    (
        [type] => days
        [bookable] => yes
        [from] => 3
        [to] => 3
    )

[1] => Array
    (
        [type] => custom
        [bookable] => yes
        [from] => 2015-07-09
        [to] => 2015-07-09
    )

[2] => Array
    (
        [type] => custom
        [bookable] => yes
        [from] => 2015-07-08
        [to] => 2015-07-08
    )

[3] => Array
    (
        [type] => custom
        [bookable] => yes
        [from] => 2015-07-10
        [to] => 2015-07-10
    )

[4] => Array
    (
        [type] => custom
        [bookable] => yes
        [from] => 2015-07-15
        [to] => 2015-07-15
    )

[5] => Array
    (
        [type] => custom
        [bookable] => yes
        [from] => 2015-07-16
        [to] => 2015-07-16
    )

[6] => Array
    (
        [type] => custom
        [bookable] => yes
        [from] => 2015-07-17
        [to] => 2015-07-17
    )

[7] => Array
    (
        [type] => months
        [bookable] => no
        [from] => 8
        [to] => 8
    )

)

正如您所看到的,用户可以在一天或一个月的范围内指定产品是否可预订,所以我的问题是如何进行SQL查询以检查此产品是否有可用的日期变量,我认为Meta_query会做工作(如下所示),但我如何指定不可用的日期？你怎么想？

if($_GET['when']){

        /* checkIsAValidDate() >> check date format */
        if ( checkIsAValidDate( $_GET['when'] ) ){
            $quand = $_GET['when'];
            $available = array(
                "post_type" => "product","Meta_query" => array(
                    "relation"  => "AND","key"       => '_wc_booking_availability',"value"     => $when,'compare'   => 'IN'
                )
            );

        }
    }

/** * Returns an array of bookable products according to supplied criteria * * @param int $pid the $product->ID of the bookable object * @param mixed $when a date in YYYY-MM-DD format or integer representing a day or month * @param string $type a value of 'day','month',or 'custom' * @param string $bookable whether the bookable object is bookable or not ('yes' or 'no') * @return array an array of bookable objects for the product */ function getBookables( $pid,$when,$type,$bookable = 'yes' ) { $result = array(); // is $when in the YYYY-MM-DD format? if ( 'custom' == $type ) { // it's a custom date so convert $when to DateTime $when = DateTime::createFromFormat( 'Y-m-d',$when ); } $availability = get_post_meta( $pid,'_wc_booking_availability' ); foreach ( $availability as $a ) { if ( $a[ 'bookable' ] == $bookable ) { // is it in the YYYY-MM-DD format? if ( $when instanceof DateTime ) { // it's a custom date so use date compare $from = DateTime::createFromFormat( 'Y-m-d',$a[ 'from' ] ); $to = DateTime::createFromFormat( 'Y-m-d',$a[ 'to' ] ); if ( $when >= $from && $when <= $to ) { $result[] = $a; } } else { // it is an integer value (day or month) if ( $type == $a[ 'type' ] && ( $when >= $from && $when <= $to ) ) { $result[] = $a; } } } } return $result; }

php – 按可用日期查询woocommerce预订

猜你在找的PHP相关文章