<?php
ini_set('display_errors', 1); 
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include '/var/www/html/cronjobs/Telegram.php';
include '/var/www/html/include/conf.php';
$tz = 'Asia/Kolkata';     
date_default_timezone_set($tz);
$date = date('Y-m-d');
$telegram = new Telegram('1407277292:AAEBSlqqJbMFjxfMjfclsrDMcTTlnM6wu3s');
mysqli_query($conn, "delete from tbl_online_sales_missed_log where DATE(order_date_time) < '$date'");
mysqli_query($conn, "delete from tbl_missed_dc_log where DATE(created_at) < '$date'");
mysqli_query($conn, "delete from tbl_missed_oc_log where DATE(created_at) < '$date'");
mysqli_query($conn, "delete from tbl_missed_dealer_oc_log where DATE(created_at) < '$date'");
mysqli_query($conn, "delete from tbl_missed_dealer_yoga_video_log where DATE_FORMAT(STR_TO_DATE(order_date_time, '%d-%m-%Y'), '%Y-%m-%d') < '$date'");
$msg= 'Online Sales,dc,oc log deleted at this time : '.date('d-m-Y H:i:s');
$content = array('chat_id'=>'-4118211407', 'text'=>$msg);
$telegram->sendMessage($content);
exit;
?>