<?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;

//get today in correct format
$stock_date = date('Y-m-d', strtotime("+14 day"));

//12:00 update stock of japanese soft loaf to 0
//13:00 update stock of anchovy and salted roll to 0

$arr_data = array('stock_date' => $stock_date);

$result = $wpdb->get_results("SELECT * FROM `stock_init`");	
foreach ($result as $data){
	if($data->start_date <= $stock_date){
		if($data->end_date=="0000-00-00" || $data->end_date >= $stock_date){	
			$arr_data[$data->sku] = $data->limits;
		}
	}
}


$wpdb->insert('sku_stock', $arr_data);
/*
$wpdb->insert('sku_stock', array(
    'GB-CCN-211' => '10',
    'GB-CAN-357' => '3',
    'BD-ABR-180' => '10', 	
    'BD-BAG-300' => '6',
    'BD-JPL-425' => '20',
    'BD-SBR-180' => '10', 
    'TS-CAN-260' => '5',
    'TS-CCC-163' => '10',
    'BD-SSB-430' => '0', 
    'TS-CBS-170' => '0',
	'BD-CMR-085' => '0',
	'BD-WNL-460' => '0',
    'stock_date' => $stock_date)
);
*/
?>