vSRO Paylaşım VSRO | Fortress Schedule Time Query

TALENT' Alıntı:

Hello everyone ;
Many errors occur in some full-time trades configured through SMC due to incorrect time zones being added during the trade process.
I previously shared information about the Special Goods process with you.
I am sharing our Castle Warfare Adaptation Procedure with you, taking advantage of the same process cycle and saving time.
The following is an example of a clock-based query for the Fortress Schedule system, representing Smc > Schedule > ScheduleDefineIdx=5,6,7,8.
Here, you only need to edit the time zones created in the `set @Hour` sections according to your needs and run the query once.
In this section, four new records are added to the _Schedule table:
ScheduleDefineIdx : An identifier for each record (5, 6, 7, 8).
DateStart : The start date of the records; the current date is used with GETDATE().
DateEnd : The end date of each record is set to December 15, 2030.
MainInterval_Type : This value is defined as "every week".
MainInterval_TypeDate, SubInterval_DayOfWeek : Date and Day are set.
SubInterval_StartTimeHour and SubInterval_StartTimeMinute : These fields are populated with hour and minute values taken from the @FortressKayıt, @FortressStart, @FortressUpdate, and @FortressTax variables.
SubInterval_DurationSecond : The duration of each recording is specified in seconds (for example, 64800 seconds represents 18 hours).
The number 1, colored red, represents the day.

*** Hidden text: cannot be quoted. ***


*** Hidden text: cannot be quoted. ***
​

Genişletmek için tıkla ...