1#@!#!123s

: / home3 / encodto1 / salvation.incrediblebengal.com / admin /
Filename : order_backup_reminder.php
back
<?php 
include'config.php';
include'function.php';
echo "<h3>Table/TakeAway History Orderlist Reminder.</h3>";
echo "<br>";



$move_table_orders = "INSERT INTO table_order_backup (order_id, table_id, customer_phone, total_payment, order_status, order_date, waiter_name, customer_ip) SELECT order_id, table_id, customer_phone, total_payment, order_status, order_date, waiter_name, customer_ip FROM dinein_order";
$run_table_orders = mysqli_query($conn, $move_table_orders) or die($conn);
if ($run_table_orders) {
	echo "<script>alert('Table Order Data moved.')</script>";

	$del_dine_orders = mysqli_query($conn, "DELETE FROM `dinein_order`");
	if ($del_dine_orders) {echo "<script>alert('Table Order data deleted.')</script>";}
	else{echo "<script>alert('Table Order data not deleted.')</script>";}

	$start_orders = mysqli_query($conn, "ALTER TABLE dinein_order AUTO_INCREMENT = 101");
	if ($start_orders) {echo "<script>alert('Table Order starts with 101..')</script>";}
}
else{echo "<script>alert('Table Order Data not moved.')</script>";}


$move_ta_orders = "INSERT INTO takeAway_order_backup (order_id, customer_phone, total_payment, order_type, order_status, order_date, waiter_name, customer_ip) SELECT order_id, customer_phone, total_payment, order_type, order_status, order_date, waiter_name, customer_ip FROM delivery_order";
$run_ta_orders = mysqli_query($conn, $move_ta_orders);
if ($run_ta_orders) {
	echo "<script>alert('Take Away Order Data moved.')</script>";

	$del_dine_orders = mysqli_query($conn, "DELETE FROM `delivery_order`");
	if ($del_dine_orders) {echo "<script>alert('Take Away Order data deleted.')</script>";}
	else{echo "<script>alert('Take Away Order data not deleted.')</script>";}

	$start_orders = mysqli_query($conn, "ALTER TABLE delivery_order AUTO_INCREMENT = 101");
	if ($start_orders) {echo "<script>alert('Take Away Order starts with 101..')</script>";}

}
else{echo "<script>alert('Take Away Order Data not moved.')</script>";}


?>