<?php
//error_reporting(E_ALL);
//ini_set('display_errors', 1);

require_once('/var/www/html/breadsecret.com/wp-load.php');
date_default_timezone_set("Asia/Hong_Kong");
global $wpdb;

//set number of days after
$days_after = "+14 day";

//get the day 2 weeks later in correct format (yyyy-mm-dd)
$stock_date = date('Y-m-d', strtotime($days_after));

//get the day of week of the day 2 weeks later (1=mon, 7=sun)
$stock_dayofweek = date('N', strtotime($days_after));

//initilize data array for insert purpose
$arr_data = array('stock_date' => $stock_date);

//get all sku in stock_init table
$result = $wpdb->get_results("SELECT * FROM `stock_init`");	
foreach ($result as $data){
	
	$arr_data[$data->sku] = 0;
	
	if($data->start_date <= $stock_date){ // check start date
		if($data->end_date=="0000-00-00" || $data->end_date >= $stock_date){ // check end date
			
			$is_blocked = false;
			$arr_block_dates = array_map("trim", explode(",", $data->block_date_from_holiday));
			$holiday_list = get_holiday_list();
			
			foreach($holiday_list as $holiday) {
				foreach($arr_block_dates as $buffer){
					if($stock_date == date("Y-m-d",strtotime($buffer." days",strtotime($holiday)))){
						$is_blocked = true;
					}
				}
			}
			
			//$arr_block_dates = array_map("trim", explode(",", $data->block_date));
			if(!$is_blocked){ // check block date
				$arr_block_dayofweeks = array_map("trim", explode(",", $data->block_dayofweek));
				if(!in_array($stock_dayofweek, $arr_block_dayofweeks)) { // check block dayofweek
					$arr_data[$data->sku] = $data->limits;
				}
			}
			
		} 
	}
}

$arr_data['stock_dayofweek'] = date('l', strtotime($days_after));

//insert data to sku_stock table
$wpdb->insert('sku_stock', $arr_data);
?>