TechBob28
Programmer
- May 2, 2012
- 19
Ok guys, this time around the boss wants to know how to refire an order. Meaning we want to resend an order to the Kitchen printer. any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Micros 3700 Refire an Order 1
- Thread starter TechBob28
- Start date
- Status
-
1
- #2
Hey.
You cant send already printed / sent order lines again. Having said that, I have played around with SIM and future orders, and by directly manipulating the DB was able to get print jobs to fire again and in the future. Key fields for this are:
Table: CHK_DTL
Field: autofire_time
ob_delayed_check
Here is a few lines of the SIM I wrote, to automate the timing and firing on a final tender event.
strAutofire_Time = ""
format strAutofire_Time as @YEAR,"/",@MONTH,"/",@DAY,": ",@HOUR,":",@MINUTE
strSQLCMD = ""
Format strSQLCMD As "UPDATE micros.CHK_DTL ", "SET Autofire_Time = '",strAutofire_Time,"'," ob_delayed_check = "'T'",\
"' WHERE CHK_NUM = ",@cknum,";COMMIT;"
The workstation that created the orderlines MUST BE ONLINE at the trigger time, as it uses the DSM to kick the order to the server => order devices.
You could therefore make all the lines on the chk be resent by updating the future order settings to now + 5 seconds.
The DTL table also has autofire_date_time also but wont fire the lines automatically.
Get programming and testing
You cant send already printed / sent order lines again. Having said that, I have played around with SIM and future orders, and by directly manipulating the DB was able to get print jobs to fire again and in the future. Key fields for this are:
Table: CHK_DTL
Field: autofire_time
ob_delayed_check
Here is a few lines of the SIM I wrote, to automate the timing and firing on a final tender event.
strAutofire_Time = ""
format strAutofire_Time as @YEAR,"/",@MONTH,"/",@DAY,": ",@HOUR,":",@MINUTE
strSQLCMD = ""
Format strSQLCMD As "UPDATE micros.CHK_DTL ", "SET Autofire_Time = '",strAutofire_Time,"'," ob_delayed_check = "'T'",\
"' WHERE CHK_NUM = ",@cknum,";COMMIT;"
The workstation that created the orderlines MUST BE ONLINE at the trigger time, as it uses the DSM to kick the order to the server => order devices.
You could therefore make all the lines on the chk be resent by updating the future order settings to now + 5 seconds.
The DTL table also has autofire_date_time also but wont fire the lines automatically.
Get programming and testing
- Status