$inst = $instruction[0];
}
$specinst = "Special instruction by customer:" . $inst;
}
if ($restuarant_id == '61111') {
echo "hells kitchen";
$to = 'Djamel Omari';
$to_email = '*****@*****.**';
$text_msg = 'Hells kitchen:It looks like ' . $fname . '(phone:' . $phone . ') has booked a table for ' . $people_count . ' on ' . $date . ' at ' . $time . "." . $specinst;
} else {
echo "west village";
$to = 'Philippe Thienard';
$to_email = '*****@*****.**';
$text_msg = 'West Village:It looks like ' . $fname . '(phone:' . $phone . ') has booked a table for ' . $people_count . ' on ' . $date . ' at ' . $time . "." . $specinst;
}
$mm = substr($date, 0, 2);
$dd = substr($date, 3, 2);
$yy = substr($date, 6, 4);
$format_date = $yy . '-' . $mm . '-' . $dd;
echo $date . "\n";
echo $format_date . "\n";
$InsQuery = "Insert into Booking_details (fname, lname, phone, email, instruction, reservation_id, receipt_no, people_count, time,date,restuarant_id,flag_reminder)VALUES ('{$fname}', '{$lname}', '{$phone}', '{$emailid}', '{$inst}', '{$reservation_id}', '{$receipt_no}', '{$people_count}', '{$time}','{$format_date}','{$restuarant_id}','0') ";
mysql_query($InsQuery);
send_mail($fname, $people_count, $date, $time, $receipt_no, $to, $to_email, $phone, $emailid, $specinst);
$obj = new Clickatell();
$obj->sendSms("16465957373", $text_msg);
?>
$varHour = substr($varTime, 0, 2);
$varMin = substr($varTime, 3, 2);
if ($varHour < 12) {
$varHour = $varHour + 12;
}
$varRowTime = $varHour . ":" . $varMin;
$time_diff = get_timedifference($time1, $varRowTime);
echo $row["id"] . "time diff is" . $time_diff . "\n";
if ($time_diff <= 40) {
echo "reminder sent" . $row["id"] . "\n";
$obj = new Clickatell();
$phone_number_temp = $row["phone"];
$phone_number = preg_replace("/[^0-9]/", "", $phone_number_temp);
if (strlen($phone_number) == 10) {
$phone_number = "1" . $phone_number;
} else {
$phone_number = $phone_number;
}
$obj->sendSms($phone_number, $text_msg);
send_reminder($row["fname"], $row["email"]);
$sql = "UPDATE Booking_details SET flag_reminder ='1' WHERE id='" . $row['id'] . "'";
mysql_query($sql) or die("I cannot run , reason : " . mysql_error());
}
}
} else {
echo "inside else";
}
?>
