<?php
include '/var/www/html/include/conf.php';
include '/var/www/html/cronjobs/Telegram.php';
$telegram = new Telegram('1407277292:AAEBSlqqJbMFjxfMjfclsrDMcTTlnM6wu3s');
$tz = 'Asia/Kolkata';   
date_default_timezone_set($tz);
$date = date('Y-m-d');
$check_stock = mysqli_query($conn, "SELECT m1.*
FROM tbl_india_update_stock m1 LEFT JOIN tbl_india_update_stock m2
 ON (m1.product_id = m2.product_id AND m1.id < m2.id) INNER JOIN shop_product sp ON sp.product_id = m1.product_id
WHERE m2.id IS NULL AND sp.can_add_stock = 'yes';");
while($set_stock = mysqli_fetch_array($check_stock, MYSQLI_ASSOC)){
$insert = "INSERT INTO `tbl_india_stock_snapshot` (`stock_id`, `product_id`, `current_stock`, `snapshot_date`) VALUES ('".$set_stock['id']."', '".$set_stock['product_id']."', '".$set_stock['current_stock']."', '$date')";
mysqli_query($conn, $insert);
}
$msg= 'Stock snapshot captured at this time : '.date('d-m-Y H:i:s');
$content = array('chat_id'=>'-4118211407', 'text'=>$msg);
$telegram->sendMessage($content);
?>