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

//get parameter passed from cron job
parse_str($argv[1], $params);

//set timezone to HK (sames as server time)
date_default_timezone_set('Asia/Hong_Kong');

//DB connection setting
$servername = "rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com";
$username = "breadsecret.com";
$password = "3#!Xj7f&5";
$dbname = "breadsecret.com";

// Create connection
$mysqli = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($mysqli ->connect_error) {
  die("Connection failed: " . $mysqli ->connect_error);
}

//get today in correct format
$stock_date = date('Y-m-d', time());

//12:00 update stock of japanese soft loaf to 0
//13:00 update stock of anchovy and salted roll to 0
if($params['type']==1){	
	$sql_read = "SELECT `BD-JPL-425` as qty_from FROM sku_stock WHERE stock_date = '".$stock_date."' LIMIT 1";
	$result = $mysqli->query($sql_read);
	$row = $result->fetch_assoc();
	$qty_from = $row['qty_from'];
	
	$sql = "UPDATE sku_stock SET `BD-JPL-425` = 0 WHERE stock_date = '".$stock_date."' LIMIT 1";	
	$mysqli->query($sql);
	
	$sqlRemake = "UPDATE sku_stock_remake SET remain = 0 WHERE stock_date = '".$stock_date."' AND sku = 'BD-JPL-425' LIMIT 1";	
	$mysqli->query($sqlRemake);
	
	$log_sql = $mysqli->real_escape_string($sql);
	
	$sql_log = "INSERT INTO stock_log VALUES (NULL, '".$stock_date."', 'Auto Script', 'Auto Script', '0', 'BD-JPL-425', 'Japanese Soft Loaf', '".$qty_from."', '0', '0', '', '".$log_sql."', now())";	
	$mysqli->query($sql_log);
}elseif($params['type']==2){
	$sql_read = "SELECT `BD-ABR-180` as qty_from_abr, `BD-SBR-180` as qty_from_sbr FROM sku_stock WHERE stock_date = '".$stock_date."' LIMIT 1";
	$result = $mysqli->query($sql_read);
	$row = $result->fetch_assoc();	
	$qty_from_abr = $row['qty_from_abr'];
	$qty_from_sbr = $row['qty_from_sbr'];
		
	$sql_abr = "UPDATE sku_stock SET `BD-ABR-180` = 0 WHERE stock_date = '".$stock_date."' LIMIT 1";
	$mysqli->query($sql_abr);	
	
	$sqlRemake = "UPDATE sku_stock_remake SET remain = 0 WHERE stock_date = '".$stock_date."' AND sku = 'BD-ABR-180' LIMIT 1";	
	$mysqli->query($sqlRemake);	
	
	$log_sql_abr = $mysqli->real_escape_string($sql_abr);
	
	$sql_log_abr = "INSERT INTO stock_log VALUES (NULL, '".$stock_date."', 'Auto Script', 'Auto Script', '0', 'BD-ABR-180', 'Anchovy Salted Butter Roll', '".$qty_from_abr."', '0', '0', '', '".$log_sql_abr."', now())";			
	$mysqli->query($sql_log_abr);
	
	$sql_sbr = "UPDATE sku_stock SET `BD-SBR-180` = 0 WHERE stock_date = '".$stock_date."' LIMIT 1";
	$mysqli->query($sql_sbr);		

	$sqlRemake = "UPDATE sku_stock_remake SET remain = 0 WHERE stock_date = '".$stock_date."' AND sku = 'BD-SBR-180' LIMIT 1";	
	$mysqli->query($sqlRemake);		
	
	$log_sql_sbr = $mysqli->real_escape_string($sql_sbr);	
	
	$sql_log_sbr = "INSERT INTO stock_log VALUES (NULL, '".$stock_date."', 'Auto Script', 'Auto Script', '0', 'BD-SBR-180', 'Salted Butter Roll', '".$qty_from_sbr."', '0', '0', '', '".$log_sql_sbr."', now())";	
	$mysqli->query($sql_log_sbr);

}else{
	exit("Wrong Type");
}
$mysqli -> close();


?>