{"AccountScreens": null, "AccountTransactionDocumentTypes": null, "AccountTransactionTypes": null, "AccountTypes": null, "Accounts": null, "Actions": [{"ActionType": "MarkTicketAsClosed", "Name": "ENT- Mark Ticket as Closed", "Parameter": "[]", "SortOrder": 90}, {"ActionType": "AskQuestion", "Name": "ENT- Ask Question", "Parameter": "[{\"Key\":\"Question\",\"Value\":\"[:question]\"},{\"Key\":\"Buttons\",\"Value\":\"[:buttons]\"},{\"Key\":\"Description\",\"Value\":\"[:description]\"},{\"Key\":\"AutomationCommandName\",\"Value\":\"[:automationCommandName]\"},{\"Key\":\"ExecuteCommandInBackground\",\"Value\":\"[:executeBgTF]\"},{\"Key\":\"BackgroundColor\",\"Value\":\"[:bgColor]\"},{\"Key\":\"TransparentColor\",\"Value\":\"[:transColor]\"},{\"Key\":\"MultiSelect\",\"Value\":\"[:multiSelectTF]\"},{\"Key\":\"InactivityCommandName\",\"Value\":\"[:inactiveCommandName]\"},{\"Key\":\"InactivityTimeoutSeconds\",\"Value\":\"[:inactiveTimeout]\"},{\"Key\":\"ExecuteInactivityCommandInBackground\",\"Value\":\"[:inactiveBgTF]\"}]", "SortOrder": 470}, {"ActionType": "NavigateModule", "Name": "ENT- Navigate Module", "Parameter": "[{\"Key\":\"ModuleName\",\"Value\":\"[:moduleName]\"},{\"Key\":\"Parameter\",\"Value\":\"[:parameter]\"},{\"Key\":\"HideHeader\",\"Value\":\"[:hideHeaderTF]\"}]", "SortOrder": 490}, {"ActionType": "ExecuteScript", "Name": "ENT- Execute Script", "Parameter": "[{\"Key\":\"Function\",\"Value\":\"[:Function]\"},{\"Key\":\"Command\",\"Value\":\"[:Komut]\"},{\"Key\":\"Parameters\",\"Value\":\"[:Parametreler]\"},{\"Key\":\"RunInBackground\",\"Value\":\"[:RunInBGTrueFalse]\"}]", "SortOrder": 510}, {"ActionType": "CloseActiveTicket", "Name": "ENT- Close Ticket", "Parameter": "[{\"Key\":\"KeepOpenIfNotPaid\",\"Value\":\"[:keepOpenIfNotPaidTF]\"},{\"Key\":\"BackgroundClose\",\"Value\":\"[:backgroundCloseTF]\"}]", "SortOrder": 530}, {"ActionType": "UpdateProgramSetting", "Name": "ENT- Update Program Setting", "Parameter": "[{\"Key\":\"SettingName\",\"Value\":\"[:settingName]\"},{\"Key\":\"SettingValue\",\"Value\":\"[:settingValue]\"},{\"Key\":\"UpdateType\",\"Value\":\"Güncelle\"},{\"Key\":\"IsLocal\",\"Value\":\"[:isLocalTF]\"}]", "SortOrder": 550}, {"ActionType": "RefreshWidgets", "Name": "ENT- Refresh Widgets", "Parameter": "[{\"Key\":\"WidgetNames\",\"Value\":\"[:WidgetNames]\"}]", "SortOrder": 560}, {"ActionType": "LoopValues", "Name": "ENT- Loop Values", "Parameter": "[{\"Key\":\"Name\",\"Value\":\"[:name]\"},{\"Key\":\"Values\",\"Value\":\"[:values]\"},{\"Key\":\"SplitChar\",\"Value\":\"[:splitChar]\"},{\"Key\":\"DisplayProgressForItems\",\"Value\":\"[:displayProgressForItems]\"},{\"Key\":\"ProgressTitle\",\"Value\":\"[:progressTitle]\"}]", "SortOrder": 580}, {"ActionType": "UpdateTicketState", "Name": "ENT- Update Ticket State", "Parameter": "[{\"Key\":\"StateName\",\"Value\":\"[:stateName]\"},{\"Key\":\"CurrentState\",\"Value\":\"[:currentState]\"},{\"Key\":\"State\",\"Value\":\"[:state]\"},{\"Key\":\"StateValue\",\"Value\":\"[:stateValue]\"},{\"Key\":\"QuantityExp\",\"Value\":\"[:qtyExp]\"}]", "SortOrder": 640}, {"ActionType": "ChangeTicketEntity", "Name": "ENT- Change Ticket Entity", "Parameter": "[{\"Key\":\"CanCreateTicket\",\"Value\":\"[:canCreateTicketTF]\"},{\"Key\":\"CanCreateEntity\",\"Value\":\"[:canCreateEntityTF]\"},{\"Key\":\"EntityTypeName\",\"Value\":\"[:entityTypeName]\"},{\"Key\":\"EntityName\",\"Value\":\"[:entityName]\"},{\"Key\":\"EntitySearchValue\",\"Value\":\"[:entitySearchValue]\"},{\"Key\":\"UpdateNullEntity\",\"Value\":\"[:updateNullEntitiyTF]\"},{\"Key\":\"EntityScreenName\",\"Value\":\"[:entityScreenName]\"},{\"Key\":\"EntityScreenSearchValue\",\"Value\":\"[:entitySecreenSeachValue]\"}]", "SortOrder": 650}, {"ActionType": "AddTicketLog", "Name": "ENT- Add Ticket Log", "Parameter": "[{\"Key\":\"Category\",\"Value\":\"[:category]\"},{\"Key\":\"Log\",\"Value\":\"[:log]\"}]", "SortOrder": 670}, {"ActionType": "RefreshCache", "Name": "ENT- Refresh Cache", "Parameter": "[]", "SortOrder": 860}, {"ActionType": "UpdateEntityState", "Name": "ENT- Update Entity State", "Parameter": "[{\"Key\":\"EntityTypeName\",\"Value\":\"[:entityTypeName]\"},{\"Key\":\"EntityName\",\"Value\":\"[:entityName]\"},{\"Key\":\"EntityStateName\",\"Value\":\"[:entityStateName]\"},{\"Key\":\"CurrentState\",\"Value\":\"[:currentState]\"},{\"Key\":\"EntityState\",\"Value\":\"[:entiyState]\"},{\"Key\":\"QuantityExp\",\"Value\":\"[:quantityExp]\"}]", "SortOrder": 50}], "AutoConfigurationTasks": null, "AutomationCommands": [{"AutoRefresh": 0, "AutomationCommandMaps": [{"DisplayOnCommandSelector": false, "DisplayOnNavigation": false, "DisplayOnOrders": false, "DisplayOnPayment": false, "DisplayOnTicket": false, "DisplayOnTicketList": false, "DisplayUnderTicket": true, "DisplayUnderTicket2": false, "EnabledStates": "Ödeme Kontrol", "VisibleStates": "Ödeme Kontrol"}], "ButtonHeader": "Ödeme Kontrol Onaylandı", "Category": null, "ClearSelection": true, "Color": "#FF90EE90", "ConfirmationType": 0, "ContentTemplate": null, "ExecuteOnce": false, "FontSize": 26, "Image": null, "Name": "EF- Ödeme Kontrol Onaylandı", "NavigationModule": null, "SortOrder": 300, "Symbol": null, "TileCacheLifetime": 0, "ToggleValues": false, "Values": null}, {"AutoRefresh": 0, "AutomationCommandMaps": [{"DisplayOnCommandSelector": false, "DisplayOnNavigation": false, "DisplayOnOrders": false, "DisplayOnPayment": false, "DisplayOnTicket": false, "DisplayOnTicketList": false, "DisplayUnderTicket": false, "DisplayUnderTicket2": false, "EnabledStates": "Nakit Kontrol", "VisibleStates": "Nakit Kontrol"}], "ButtonHeader": "ÖDEMELERİ GÖSTER", "Category": null, "ClearSelection": true, "Color": "#FFF79646", "ConfirmationType": 0, "ContentTemplate": null, "ExecuteOnce": false, "FontSize": 26, "Image": null, "Name": "EF- Alınan Ödemeleri Göster", "NavigationModule": null, "SortOrder": 0, "Symbol": null, "TileCacheLifetime": 0, "ToggleValues": false, "Values": null}, {"AutoRefresh": 0, "AutomationCommandMaps": [{"DisplayOnCommandSelector": false, "DisplayOnNavigation": true, "DisplayOnOrders": false, "DisplayOnPayment": false, "DisplayOnTicket": false, "DisplayOnTicketList": false, "DisplayUnderTicket": false, "DisplayUnderTicket2": false, "EnabledStates": "", "VisibleStates": "*"}], "ButtonHeader": "E-Fatura Ayarları", "Category": "Navigasyon", "ClearSelection": true, "Color": "#FF4F81BD", "ConfirmationType": 0, "ContentTemplate": null, "ExecuteOnce": false, "FontSize": 26, "Image": null, "Name": "ENT- EFatura", "NavigationModule": "", "SortOrder": 470, "Symbol": "", "TileCacheLifetime": 0, "ToggleValues": false, "Values": null}, {"AutoRefresh": 0, "AutomationCommandMaps": [{"DisplayOnCommandSelector": false, "DisplayOnNavigation": false, "DisplayOnOrders": false, "DisplayOnPayment": false, "DisplayOnTicket": false, "DisplayOnTicketList": false, "DisplayUnderTicket": false, "DisplayUnderTicket2": false, "EnabledStates": "*", "VisibleStates": "*"}], "ButtonHeader": "ÖDEMELERİ GÖSTER", "Category": null, "ClearSelection": true, "Color": "#FFF79646", "ConfirmationType": 0, "ContentTemplate": null, "ExecuteOnce": false, "FontSize": 26, "Image": null, "Name": "EF- Alınan Ödemeleri Göster Sol", "NavigationModule": null, "SortOrder": 0, "Symbol": null, "TileCacheLifetime": 0, "ToggleValues": false, "Values": null}], "CalculationSelectors": null, "CalculationTypes": null, "ChangePaymentTypes": null, "CustomReports": [{"DisplayInExplorer": false, "Layouts": null, "Name": "ENT- Reports", "PageSize": null, "ReportType": 0, "SortOrder": 850, "Template": "[Reports:1,1]\r\n>ReportId|ReportName\r\n{REPORT SQL DETAILS:SELECT R.Id,R.Name FROM CustomReports R:F.Id,F.Name::{0}|{1}:}"}, {"DisplayInExplorer": false, "Layouts": null, "Name": "ENT- Payment Types", "PageSize": null, "ReportType": 0, "SortOrder": 860, "Template": "[PaymentTypes:1,1]\r\n>PaymentId|PaymentName\r\n{REPORT SQL DETAILS:SELECT PT.Id,PT.Name FROM PaymentTypes PT:F.Id,F.Name::{0}|{1}:}"}, {"DisplayInExplorer": true, "Layouts": null, "Name": "Fatura Listesi", "PageSize": "600", "ReportType": 0, "SortOrder": 0, "Template": "@{REPORT SQL DETAILS:SELECT Name FROM\tPaymentTypes P WHERE P.AccountTransactionType_Id=4:F.Name::{0}:,}\r\n[$1 Faturalar:1,2,1, 1]\r\n>>Adisyon No|Fatura No|Kullanıcı|$1\r\n{REPORT PAYMENT DETAILS:T.Id,P.Description,P.User,P.TenderedAmount:(PT=$1)}"}, {"DisplayInExplorer": true, "Layouts": null, "Name": "KDV Listesi", "PageSize": "600", "ReportType": 0, "SortOrder": 0, "Template": "[Ürün KDV Oranları:1,2, 1, 1]\r\n>Kategori|Ürün|Kdv Tanımı|Oran\r\n{REPORT SQL DETAILS:\r\nWITH TaxData AS (\r\n SELECT\r\n p.[GroupCode] AS Category, \r\n p.[Name] AS ProductName, \r\n COALESCE(tt.[Name], 'KDV Tanımsız') AS TaxName, \r\n COALESCE(tt.[Rate], 0) AS TaxRate, \r\n ROW_NUMBER() OVER (\r\n PARTITION BY p.[GroupCode], p.[Name]\r\n ORDER BY \r\n CASE\r\n WHEN tm.[MenuItemGroupCode] IS NULL THEN 1 \r\n WHEN tm.[MenuItemGroupCode] = p.[GroupCode] THEN 2 \r\n ELSE 3 \r\n END,\r\n tt.[Rate] DESC\r\n ) AS RowNum\r\n FROM [MenuItems] p\r\n LEFT JOIN [TaxTemplateMaps] tm \r\n ON tm.[MenuItemGroupCode] = p.[GroupCode] \r\n OR tm.[MenuItemGroupCode] IS NULL \r\n LEFT JOIN [TaxTemplates] tt \r\n ON tt.[Id] = tm.[TaxTemplateId]\r\n)\r\nSELECT\r\n Category,\r\n ProductName,\r\n TaxName,\r\n TaxRate\r\nFROM TaxData\r\nWHERE RowNum = 1 \r\nORDER BY Category, ProductName\r\n:F.Category,F.ProductName,F.TaxName,F.TaxRate:: {0}| {1}| {2}| {3}}\r\n"}], "Departments": null, "EntityScreens": [{"AskTicketType": false, "BackgroundColor": "Transparent", "ButtonFontSize": 0, "ButtonHeader": "E-Fatura", "ButtonHeight": 0, "ColumnCount": 0, "DetailTemplate": null, "DisplayMode": 3, "DisplayState": null, "EntityScreenMaps": [], "EntityTypeName": "Müşteriler", "FontSize": 50, "Layout": "", "Name": "ENT- EFatura", "PageCount": 1, "RowCount": 0, "SearchValueReplacePattern": null, "SortOrder": 30, "StateFilter": null, "TicketTypeName": "Paket Servis", "UseStateDisplayFormat": false, "Widgets": [{"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "LabelWidgetCreator", "Height": 100, "Margin": "3;0;3;3", "Name": null, "Properties": "{\"Alignment\":\"Center\",\"Alignments\":[\"Left\",\"Right\",\"Center\"],\"BackgroundColor\":\"#FFFDCB6E\",\"BorderColor\":\"Transparent\",\"BorderThickness\":\"0\",\"FontName\":\"Segoe UI\",\"FontSize\":30,\"FontWeight\":\"Normal\",\"FontWeights\":[\"Normal\",\"Thin\",\"Bold\"],\"ForegroundColor\":\"#00FFFFFF\",\"SettingMap\":null,\"Text\":\"E-Fatura Ayarları\",\"VerticalAlignment\":\"Center\",\"VerticalAlignments\":[\"Top\",\"Center\",\"Bottom\"]}", "Scale": 0, "UniqueId": "NZ2OriDs3wUGHDNlX9fH1hA", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": null, "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"[='{GLOBAL SETTING:ENT-ST-odemeGosterButonuSol}'=='Açık'?'Solda Ödemeleri Göster Butonu<\\/size>Açık<\\/background>':'Solda Ödemeleri Göster Butonu<\\/size>Kapalı<\\/background>']\",\"CommandName\":\"ENT-ST-odemeGosterButonuSol\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":\"ST|EF- Alınan Ödemeleri Göster Sol|DisplayOnTicket\"}", "Scale": 0, "UniqueId": "NYTv4H93k0EeV6c5m1qEqdw", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": "RefreshItem22", "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"[='{GLOBAL SETTING:ENT-ST-EFatura}'=='Açık'?'{GLOBAL SETTING:ENT-ST-odemeKontrol}'=='Açık'?'Ödeme Kontrolü<\\/size>Açık<\\/background>':'Ödeme Kontrolü<\\/size>Kapalı<\\/background>':'E-Fatura Pasif<\\/size>Özellik Kullanılmaz!<\\/background>']\",\"CommandName\":\"ENT-ST-odemeKontrol\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":\"Ref2\"}", "Scale": 0, "UniqueId": "NVPaPuOPAI0W7ATMXM1noyQ", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": "RefreshItem20", "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"[='{GLOBAL SETTING:ENT-ST-EFatura}'=='Açık'?'{GLOBAL SETTING:ENT-ST-tekCihazmi}'=='Kapalı'?'{GLOBAL SETTING:ENT-ST-cihazSecme}'=='Açık'?'Cihaz Seç<\\/size>Günde 1 Kere<\\/background>':'Cihaz Seç<\\/size>Her İşlemde<\\/background>':'Tek Cihaz Otomatik Seçilir...<\\/size><\\/background>':'E-Fatura Pasif<\\/size>Özellik Kullanılmaz!<\\/background>']\",\"CommandName\":\"ENT-ST-cihazSecme\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":null}", "Scale": 0, "UniqueId": "NZweBmGZeOUKbokezdflRJg", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": null, "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"Token Al\",\"CommandName\":\"ENT- TokenAl\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":null}", "Scale": 0, "UniqueId": "NFTIbRaydtkW-B-tgZAi59Q", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": null, "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"\",\"CommandName\":\"\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":\"\"}", "Scale": 0, "UniqueId": "N4ikMfkAsy02AnbvgstmqFQ", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": null, "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"\",\"CommandName\":\"\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":\"\"}", "Scale": 0, "UniqueId": "Nm5-j0cunBE-Ay8HwEBp4jQ", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": "RefreshItem18", "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"[='{GLOBAL SETTING:ENT-ST-EFatura}'=='Açık'?'{GLOBAL SETTING:ENT-ST-odemeKontrol}'=='Açık'?'{GLOBAL SETTING:OdemeTipleri}'!=''?'Ödeme Tipleri<\\/size>{GLOBAL SETTING:OdemeTipleri}<\\/background>':'Ödeme Tipleri<\\/size>Seçilmedi<\\/background>':'Ödeme Kontrol Kapalı<\\/size>Özellik Kullanılmaz!<\\/background>':'E-Fatura Pasif<\\/size>Özellik Kullanılmaz!<\\/background>']\",\"CommandName\":\"ENT-ST-EFaturaPT\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":\"OdemeTipleri\"}", "Scale": 0, "UniqueId": "NIIG9YSzfdEKXuaKOf0eJZA", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": "RefreshItem17", "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"[='{GLOBAL SETTING:ENT-ST-EFatura}'=='Açık'?'{GLOBAL SETTING:ENT-ST-odemeKontrol}'=='Açık'?'{GLOBAL SETTING:AdisyonTipleri}'!=''?'Ödeme Tipleri<\\/size>{GLOBAL SETTING:AdisyonTipleri}<\\/background>':'Adisyon Tipleri<\\/size>Seçilmedi<\\/background>':'Ödeme Kontrol Kapalı<\\/size>Özellik Kullanılmaz!<\\/background>':'E-Fatura Pasif<\\/size>Özellik Kullanılmaz!<\\/background>']\",\"CommandName\":\"ENT-ST-EFaturaTT\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":\"AdisyonTipleri\"}", "Scale": 0, "UniqueId": "NopHEi0fesEW1KxF-4VZvvg", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": null, "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"\",\"CommandName\":\"\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":null}", "Scale": 0, "UniqueId": "NYHxCXw-6002s3BE3077LcQ", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": "", "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"[='{GLOBAL SETTING:ENT-ST-EFatura}'=='Açık'?'E-Fatura<\\/size>Aktif<\\/background>':'E-Fatura<\\/size>Pasif<\\/background>']\",\"CommandName\":\"ENT-ST-EFatura\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":\"Ref\"}", "Scale": 0, "UniqueId": "NwmePfm1IPUuUiImhnrRTzg", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": "RefreshItem21", "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"[='{GLOBAL SETTING:ENT-ST-EFatura}'=='Açık'?'{LOCAL SETTING:EF-AktifCihaz}'!=''?'Aktif Cihaz<\\/size>{LOCAL SETTING:EF-AktifCihaz}<\\/background>':'Aktif Cihaz<\\/size>Seçilmedi<\\/background>':'E-Fatura Pasif<\\/size>Özellik Kullanılmaz!<\\/background>']\",\"CommandName\":\"ENT-ST-userDevices\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":\"SeriNolar\"}", "Scale": 0, "UniqueId": "Nqn_IGx3auEKQcVSLho1wzA", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": "RefreshItem19", "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"[='{GLOBAL SETTING:ENT-ST-EFatura}'=='Açık'?'{GLOBAL SETTING:ENT-ST-tekCihazmi}'=='Açık'?'Tek Cihaz Mı?<\\/size>Evet<\\/background>':'Tek Cihaz Mı?<\\/size>Hayır<\\/background>':'E-Fatura Pasif<\\/size>Özellik Kullanılmaz!<\\/background>']\",\"CommandName\":\"ENT-ST-tekCihazmi\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":\"\"}", "Scale": 0, "UniqueId": "NV4sevoZwqUSWTlNElCaAjg", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}, {"Angle": 0, "AutoRefresh": true, "AutoRefreshInterval": 0, "CornerRadius": 0, "CreatorName": "AutomationButtonCreator", "Height": 100, "Margin": "3;3;3;3", "Name": null, "Properties": "{\"Async\":false,\"ButtonColor\":\"#FF000000\",\"Caption\":\"[='{GLOBAL SETTING:ENT-ST-odemeGosterButonu}'=='Açık'?'Altta Ödemeleri Göster Butonu<\\/size>Açık<\\/background>':'Altta Ödemeleri Göster Butonu<\\/size>Kapalı<\\/background>']\",\"CommandName\":\"ENT-ST-odemeGosterButonu\",\"Focusable\":false,\"FontSize\":30,\"HighlightColor\":\"#FF17C0EB\",\"ImagePath\":null,\"KeyboardMap\":null,\"Validation\":null,\"Value\":\"ST|EF- Alınan Ödemeleri Göster|DisplayUnderTicket\"}", "Scale": 0, "UniqueId": "NauHig6Fpz0WMSSc62Ej1FQ", "Width": 100, "XLocation": 0, "YLocation": 0, "Zindex": 0}]}], "EntityTypes": null, "Numerators": null, "OrderTagGroups": null, "PaymentTypes": null, "PrintJobs": null, "PrinterTemplates": null, "Printers": null, "ProgramSettingValues": null, "Rules": [{"Actions": [{"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'!='Açık'", "Name": "ENT- Update Program Setting", "ParameterValues": "settingName=[:AutomationCommandName]`settingValue=Açık`isLocalTF=False", "SortOrder": 10}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'=='Açık'", "Name": "ENT- Update Program Setting", "ParameterValues": "settingName=[:AutomationCommandName]`settingValue=Kapalı`isLocalTF=False", "SortOrder": 20}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'!='Açık'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateACS('{CALL:pe.split('[:CommandValue]','1')}','{CALL:pe.split('[:CommandValue]','2')}','1')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 30}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'=='Açık'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateACS('{CALL:pe.split('[:CommandValue]','1')}','{CALL:pe.split('[:CommandValue]','2')}','0')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 40}, {"ActionName": null, "CustomConstraint": "'[:CommandValue]'!=''", "Name": "ENT- Refresh Cache", "ParameterValues": "", "SortOrder": 100}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'!='Açık' && '{CALL:pe.split('[:CommandValue]','3')}'!=''", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateACS('{CALL:pe.split('[:CommandValue]','1')}','{CALL:pe.split('[:CommandValue]','3')}','1')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 60}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'=='Açık' && '{CALL:pe.split('[:CommandValue]','3')}'!=''", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateACS('{CALL:pe.split('[:CommandValue]','1')}','{CALL:pe.split('[:CommandValue]','3')}','0')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 50}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'!='Açık' && '{CALL:pe.split('[:CommandValue]','4')}'!=''", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateACS('{CALL:pe.split('[:CommandValue]','4')}','{CALL:pe.split('[:CommandValue]','2')}','1')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 80}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'=='Açık' && '{CALL:pe.split('[:CommandValue]','4')}'!=''", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateACS('{CALL:pe.split('[:CommandValue]','4')}','{CALL:pe.split('[:CommandValue]','2')}','0')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 70}, {"ActionName": null, "CustomConstraint": null, "Name": "ENT- Loop Values", "ParameterValues": "name=RefreshItem`values=1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30`splitChar=`displayProgressForItems=`progressTitle=", "SortOrder": 90}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 1, "EventName": "AutomationCommandExecuted", "Name": "ENT- Sistem Özelleştirme Ayarlarını Değiştir", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"VqF1BdDm5y\",\"O\":\"Starts\",\"R\":\"ENT-ST-\"},{\"L\":\"CommandValue\",\"N\":\"JR0noxsWPG\",\"O\":\"Starts\",\"R\":\"ST\"}]", "SortOrder": 1210, "Tags": "ENT"}, {"Actions": [{"ActionName": null, "CustomConstraint": null, "Name": "ENT- Navigate Module", "ParameterValues": "moduleName=Entity`parameter=[:AutomationCommandName]`hideHeaderTF=True", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "AutomationCommandExecuted", "Name": "ENT- Management", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"wKti25aK6n\",\"O\":\"Equal\",\"R\":\"ENT- Management\"},{\"L\":\"AutomationCommandName\",\"N\":\"hjJcu5sKxd\",\"O\":\"Equal\",\"R\":\"ENT- BossEntegra\"},{\"L\":\"AutomationCommandName\",\"N\":\"NvhJaG2Rlj\",\"O\":\"Equal\",\"R\":\"ENT- PosEntegra\"},{\"L\":\"AutomationCommandName\",\"N\":\"RFl3xs3CUK\",\"O\":\"Equal\",\"R\":\"ENT- EFatura\"}]", "SortOrder": 760, "Tags": "ENT, BE, PE"}, {"Actions": [{"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'!='{CALL:pe.split('[:CommandValue]','2')}'", "Name": "ENT- Update Program Setting", "ParameterValues": "settingName=[:AutomationCommandName]`settingValue=[=TN('{GLOBAL SETTING:[:AutomationCommandName]}')+TN('{CALL:pe.split('[:CommandValue]','1')}')]`isLocalTF=False", "SortOrder": 10}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'=='{CALL:pe.split('[:CommandValue]','2')}'", "Name": "ENT- Update Program Setting", "ParameterValues": "settingName=[:AutomationCommandName]`settingValue=[=TN('{CALL:pe.split('[:CommandValue]','3')}')]`isLocalTF=False", "SortOrder": 20}, {"ActionName": null, "CustomConstraint": "'[:CommandValue]'!=''", "Name": "ENT- Refresh Cache", "ParameterValues": "", "SortOrder": 70}, {"ActionName": null, "CustomConstraint": "'[:AutomationCommandName]'=='ENT-NU-OtoYolSuresi'", "Name": "ENT- Update Program Setting", "ParameterValues": "settingName=[:AutomationCommandName]Son`settingValue=[=TN('{GLOBAL SETTING:[:AutomationCommandName]}')+TN('5')]`isLocalTF=False", "SortOrder": 30}, {"ActionName": null, "CustomConstraint": "'[:AutomationCommandName]'=='ENT-NU-OtoTeslimSuresi'", "Name": "ENT- Update Program Setting", "ParameterValues": "settingName=[:AutomationCommandName]Bas`settingValue=[=TN('{GLOBAL SETTING:ENT-NU-OtoYolSuresi}')+TN('{GLOBAL SETTING:[:AutomationCommandName]}')]`isLocalTF=False", "SortOrder": 40}, {"ActionName": null, "CustomConstraint": "'[:AutomationCommandName]'=='ENT-NU-OtoTeslimSuresi'", "Name": "ENT- Update Program Setting", "ParameterValues": "settingName=[:AutomationCommandName]Son`settingValue=[=TN('{GLOBAL SETTING:ENT-NU-OtoYolSuresiSon}')+TN('{GLOBAL SETTING:[:AutomationCommandName]}')]`isLocalTF=False", "SortOrder": 50}, {"ActionName": null, "CustomConstraint": null, "Name": "ENT- Loop Values", "ParameterValues": "name=RefreshItem`values=1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30`splitChar=`displayProgressForItems=`progressTitle=", "SortOrder": 60}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 2, "EventName": "AutomationCommandExecuted", "Name": "ENT- Sistem Özelleştirme Sayı Ayarlarını Değiştir", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"VqF1BdDm5y\",\"O\":\"Starts\",\"R\":\"ENT-NU-\"},{\"L\":\"CommandValue\",\"N\":\"JR0noxsWPG\",\"O\":\"Starts\",\"R\":\"NU\"}]", "SortOrder": 1220, "Tags": "ENT"}, {"Actions": [{"ActionName": null, "CustomConstraint": "'[:CommandValue]'!=''", "Name": "ENT- Refresh Cache", "ParameterValues": "", "SortOrder": 30}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'!='Açık'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateACA('{CALL:pe.split('[:CommandValue]','1')}','2')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 10}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'=='Açık'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateACA('{CALL:pe.split('[:CommandValue]','1')}','0')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 20}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 2, "EventName": "AutomationCommandExecuted", "Name": "ENT- Sistem Özelleştirme Admin Pin Ayarlarını Değiştir", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"VqF1BdDm5y\",\"O\":\"Starts\",\"R\":\"ENT-ST-\"},{\"L\":\"CommandValue\",\"N\":\"JR0noxsWPG\",\"O\":\"Starts\",\"R\":\"AP\"}]", "SortOrder": 1230, "Tags": "ENT"}, {"Actions": [{"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'!='Açık' && '{CALL:pe.split('[:CommandValue]','1')}'!='Müşteri Hesabı'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updatePT('{CALL:pe.split('[:CommandValue]','1')}','0','3')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 10}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'=='Açık' && '{CALL:pe.split('[:CommandValue]','1')}'!='Müşteri Hesabı'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updatePT('{CALL:pe.split('[:CommandValue]','1')}','19','19')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 20}, {"ActionName": null, "CustomConstraint": "'[:CommandValue]'!=''", "Name": "ENT- Refresh Cache", "ParameterValues": "", "SortOrder": 50}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'!='Açık' && '{CALL:pe.split('[:CommandValue]','1')}'=='Müşteri Hesabı'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateCA('{CALL:pe.split('[:CommandValue]','1')}','0')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 30}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'=='Açık' && '{CALL:pe.split('[:CommandValue]','1')}'=='Müşteri Hesabı'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateCA('{CALL:pe.split('[:CommandValue]','1')}','19')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 40}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 2, "EventName": "AutomationCommandExecuted", "Name": "ENT- Sistem Özelleştirme Ödeme Tipi Ayarlarını Değiştir", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"VqF1BdDm5y\",\"O\":\"Starts\",\"R\":\"ENT-ST-\"},{\"L\":\"CommandValue\",\"N\":\"kkWfgbrqXa\",\"O\":\"Starts\",\"R\":\"PT\"}]", "SortOrder": 1240, "Tags": "ENT"}, {"Actions": [{"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'!='Açık'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateOP('{CALL:pe.split('[:CommandValue]','1')}','3')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 10}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'=='Açık'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateOP('{CALL:pe.split('[:CommandValue]','1')}','19')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 20}, {"ActionName": null, "CustomConstraint": "'[:CommandValue]'!=''", "Name": "ENT- Refresh Cache", "ParameterValues": "", "SortOrder": 30}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 2, "EventName": "AutomationCommandExecuted", "Name": "ENT- Sistem Özelleştirme Online Ödeme Tipi Ayarlarını Değiştir", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"VqF1BdDm5y\",\"O\":\"Starts\",\"R\":\"ENT-ST-\"},{\"L\":\"CommandValue\",\"N\":\"kkWfgbrqXa\",\"O\":\"Starts\",\"R\":\"OP\"}]", "SortOrder": 1250, "Tags": "ENT"}, {"Actions": [{"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'!='Açık'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateCA('{CALL:pe.split('[:CommandValue]','1')}','2')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 10}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:[:AutomationCommandName]}'=='Açık'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.updateCA('{CALL:pe.split('[:CommandValue]','1')}','19')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 20}, {"ActionName": null, "CustomConstraint": "'[:CommandValue]'!=''", "Name": "ENT- Refresh Cache", "ParameterValues": "", "SortOrder": 30}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 2, "EventName": "AutomationCommandExecuted", "Name": "ENT- Sistem Özelleştirme Online Ödeme Tipi Buton Ayarlarını Değiştir", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"VqF1BdDm5y\",\"O\":\"Starts\",\"R\":\"ENT-ST-\"},{\"L\":\"CommandValue\",\"N\":\"kkWfgbrqXa\",\"O\":\"Starts\",\"R\":\"OPB\"}]", "SortOrder": 1260, "Tags": "ENT"}, {"Actions": [{"ActionName": null, "CustomConstraint": null, "Name": "ENT- Refresh Widgets", "ParameterValues": "WidgetNames=RefreshItem[:LoopValue]", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 1, "EventName": "ValueLooped", "Name": "ENT- Sistem Özelleştirme Ayarlarını Değiştir Widget Yenile", "RuleConstraints": "[{\"L\":\"Name\",\"N\":\"AofJ0uZxT2\",\"O\":\"Equal\",\"R\":\"RefreshItem\"}]", "SortOrder": 1270, "Tags": "ENT"}, {"Actions": [{"ActionName": null, "CustomConstraint": null, "Name": "ENT- Add Ticket Log", "ParameterValues": "category=E-Fatura`log=[:Description]", "SortOrder": 10}, {"ActionName": null, "CustomConstraint": null, "Name": "ENT- Add Ticket Log", "ParameterValues": "category=E-Fatura`log=[:PaymentTypeName] - [:ProcessedAmount]", "SortOrder": 20}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:ENT-ST-cihazSecme}'!='Açık' && '{GLOBAL SETTING:ENT-ST-tekCihazmi}'=='Kapalı'", "Name": "ENT- Update Program Setting", "ParameterValues": "settingName=EF-AktifCihaz`settingValue=`isLocalTF=True", "SortOrder": 30}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "PaymentProcessed", "Name": "EF- Fatura No Log Ekle", "RuleConstraints": "[{\"L\":\"{GLOBAL SETTING:ENT-ST-EFatura}\",\"N\":\"HIv8Uqt1ZL\",\"O\":\"Equal\",\"R\":\"Açık\"}]", "SortOrder": 2850, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": "'{LOCAL SETTING:EF-AktifCihaz}'==''", "Name": "ENT- Update Program Setting", "ParameterValues": "settingName=SeriNolar`settingValue=[?Cihaz Seri Noları Giriniz;;{GLOBAL SETTING:SeriNolar}]`isLocalTF=False", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "AutomationCommandExecuted", "Name": "EF- Cihaz Seri Noları Güncelle", "RuleConstraints": "[{\"L\":\"CommandValue\",\"N\":\"JMZOj5yv7u\",\"O\":\"Equal\",\"R\":\"SeriNolar\"},{\"L\":\"AutomationCommandName\",\"N\":\"OlCFlWb99q\",\"O\":\"Equal\",\"R\":\"ENT-ST-userDevices\"}]", "SortOrder": 960, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:ENT-ST-EFatura}'!='Açık'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.uptES()`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 10}, {"ActionName": null, "CustomConstraint": "'{GLOBAL SETTING:ENT-ST-EFatura}'=='Açık'", "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.uptAPC()`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 20}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "AutomationCommandExecuted", "Name": "EF- Ödeme Tiplerine Script Ekle", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"9HuEcHJSoD\",\"O\":\"Equal\",\"R\":\"ENT-ST-EFatura\"}]", "SortOrder": 70, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": null, "Name": "ENT- Update Ticket State", "ParameterValues": "stateName=Durum`currentState=`state=Ödendi`stateValue=`qtyExp=", "SortOrder": 20}, {"ActionName": null, "CustomConstraint": null, "Name": "ENT- Update Ticket State", "ParameterValues": "stateName=Ödeme Kontrol`currentState=`state=`stateValue=`qtyExp=", "SortOrder": 10}, {"ActionName": null, "CustomConstraint": null, "Name": "ENT- Close Ticket", "ParameterValues": "", "SortOrder": 30}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "AutomationCommandExecuted", "Name": "EF- Ödeme Kontrol Onaylandı", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"jbnOzXKA2Q\",\"O\":\"Equal\",\"R\":\"EF- Ödeme Kontrol Onaylandı\"}]", "SortOrder": 80, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": null, "Name": "ENT- Change Ticket Entity", "ParameterValues": "canCreateTicketTF=`canCreateEntityTF=True`entityTypeName=Müşteriler`entityName=HIZLI SATIŞ`entitySearchValue=`updateNullEntitiyTF=`entityScreenName=`entitySecreenSeachValue=", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 3, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "TicketCreated", "Name": "EF- Hızlı Satış Belge Oluşturma", "RuleConstraints": "[{\"L\":\"{GLOBAL SETTING:ENT-ST-EFatura}\",\"N\":\"r3ogZ6Pwg2\",\"O\":\"Equal\",\"R\":\"Açık\"}]", "SortOrder": 100, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": null, "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.delACMap()`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "TicketClosing", "Name": "EF- Adisyon Kapanıyor", "RuleConstraints": "[{\"L\":\"{GLOBAL SETTING:ENT-ST-EFatura}\",\"N\":\"Lm3Bkvl5HA\",\"O\":\"Equal\",\"R\":\"Açık\"}]", "SortOrder": 110, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": "'{REPORT PAYMENT DETAILS:P.TenderedAmount.Sum:T.Id=={TICKET ID}}'!=''", "Name": "ENT- Ask Question", "ParameterValues": "question={REPORT PAYMENT DETAILS:P.Type,P.TenderedAmount.Sum:T.Id=={TICKET ID}:{0}{1} TL}`buttons=TAMAM`description=`automationCommandName=`executeBgTF=`bgColor=#80000000`transColor=#80000000`multiSelectTF=`inactiveCommandName=`inactiveTimeout=`inactiveBgTF=", "SortOrder": 10}, {"ActionName": null, "CustomConstraint": "'{REPORT PAYMENT DETAILS:P.TenderedAmount.Sum:T.Id=={TICKET ID}}'==''", "Name": "ENT- Ask Question", "ParameterValues": "question=Henüz Ödeme Alınmamış`buttons=TAMAM`description=`automationCommandName=`executeBgTF=`bgColor=#80000000`transColor=#80000000`multiSelectTF=`inactiveCommandName=`inactiveTimeout=`inactiveBgTF=", "SortOrder": 20}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "AutomationCommandExecuted", "Name": "EF- Alınan Ödemeleri Göster", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"jbnOzXKA2Q\",\"O\":\"Equal\",\"R\":\"EF- Alınan Ödemeleri Göster\"},{\"L\":\"AutomationCommandName\",\"N\":\"MhqxGbawTL\",\"O\":\"Equal\",\"R\":\"EF- Alınan Ödemeleri Göster Sol\"}]", "SortOrder": 120, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": "'{TICKET STATE:Ödeme Kontrol}'!='Kontrol Edilmeli'", "Name": "ENT- Mark Ticket as Closed", "ParameterValues": "", "SortOrder": 40}, {"ActionName": null, "CustomConstraint": "'{TICKET STATE:Ödeme Kontrol}'!='Kontrol Edilmeli' && '{TICKET STATE:Durum}'!='İPTAL EDİLDİ'", "Name": "ENT- Update Ticket State", "ParameterValues": "stateName=Durum`currentState=`state=Ödendi`stateValue=`qtyExp=", "SortOrder": 30}, {"ActionName": null, "CustomConstraint": "'{TICKET STATE:Ödeme Kontrol}'=='Kontrol Edilmeli' && '{TICKET STATE:Durum}'!='İPTAL EDİLDİ'", "Name": "ENT- Update Ticket State", "ParameterValues": "stateName=Durum`currentState=`state=Ödeme Kontrol`stateValue=`qtyExp=", "SortOrder": 20}, {"ActionName": null, "CustomConstraint": "'{TICKET STATE:Ödeme Kontrol}'=='Kontrol Edilmeli' && '{TICKET STATE:Durum}'!='İPTAL EDİLDİ'", "Name": "ENT- Update Entity State", "ParameterValues": "entityTypeName=Masalar`entityName=`entityStateName=Status`currentState=`entiyState=Ödeme Kontrol`quantityExp=", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "BeforeTicketClosing", "Name": "EF- Belge Ödendi Kontolü", "RuleConstraints": "[{\"L\":\"RemainingAmount\",\"N\":\"tCWrr7VUVb\",\"O\":\"Equal\",\"R\":\"0\"}]", "SortOrder": 1770, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": "", "Name": "ENT- Update Ticket State", "ParameterValues": "stateName=Ödeme Kontrol`currentState=`state=Kontrol Edilmeli`stateValue=`qtyExp=", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "PaymentProcessed", "Name": "EF- Ödeme Kontrol Edilmeli Sorgusu", "RuleConstraints": "[{\"L\":\"{GLOBAL SETTING:ENT-ST-EFatura}\",\"N\":\"HIv8Uqt1ZL\",\"O\":\"Equal\",\"R\":\"Açık\"},{\"L\":\"{GLOBAL SETTING:ENT-ST-odemeKontrol}\",\"N\":\"IuZdNIhea1\",\"O\":\"Equal\",\"R\":\"Açık\"},{\"L\":\"{GLOBAL SETTING:AdisyonTipleri}\",\"N\":\"r35IGeQzng\",\"O\":\"Matches\",\"R\":\"{TICKET TYPE}\"},{\"L\":\"{GLOBAL SETTING:OdemeTipleri}\",\"N\":\"5IsAAd4dot\",\"O\":\"Matches\",\"R\":\"[:PaymentTypeName]\"}]", "SortOrder": 2860, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": null, "Name": "ENT- Update Program Setting", "ParameterValues": "settingName=EF-AktifCihaz`settingValue={GLOBAL SETTING:SeriNolar}`isLocalTF=True", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "UserLoggedIn", "Name": "EF- Kasiyer Giriş Yaptı", "RuleConstraints": "[{\"L\":\"{GLOBAL SETTING:ENT-ST-tekCihazmi}\",\"N\":\"GB4Ti3aaZw\",\"O\":\"Equal\",\"R\":\"Açık\"}]", "SortOrder": 130, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": null, "Name": "ENT- Execute Script", "ParameterValues": "Function=pe.sambaGunBasi()`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "AutomationCommandExecuted", "Name": "EF- Token Al", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"3kUkkyEedD\",\"O\":\"Equal\",\"R\":\"ENT- TokenAl\"}]", "SortOrder": 140, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": null, "Name": "ENT- Ask Question", "ParameterValues": "question=Ödeme Kontrolü Yapılacak Ödeme Tiplerini Seçin`buttons={REPORT SQL DETAILS:SELECT PT.Name FROM PaymentTypes PT:F.Name::,}`description=`automationCommandName=OdemeTipleriSecildi`executeBgTF=`bgColor=`transColor=`multiSelectTF=True`inactiveCommandName=`inactiveTimeout=`inactiveBgTF=", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "AutomationCommandExecuted", "Name": "EF- Kontrol Edilecek Ödeme Tipleri Sorusu", "RuleConstraints": "[{\"L\":\"CommandValue\",\"N\":\"JMZOj5yv7u\",\"O\":\"Equal\",\"R\":\"OdemeTipleri\"},{\"L\":\"AutomationCommandName\",\"N\":\"OlCFlWb99q\",\"O\":\"Equal\",\"R\":\"ENT-ST-EFaturaPT\"}]", "SortOrder": 970, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": "", "Name": "ENT- Update Program Setting", "ParameterValues": "settingName=OdemeTipleri`settingValue=[:CommandValue]`isLocalTF=False", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "AutomationCommandExecuted", "Name": "EF- Kontrol Edilecek Ödeme Tipleri Seçildi", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"OlCFlWb99q\",\"O\":\"Equal\",\"R\":\"OdemeTipleriSecildi\"}]", "SortOrder": 980, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": null, "Name": "ENT- Ask Question", "ParameterValues": "question=Ödeme Kontrolü Yapılacak Adisyon Tiplerini Seçin`buttons={REPORT SQL DETAILS:SELECT TT.Name FROM TicketTypes TT:F.Name::{0}::,}`description=`automationCommandName=AdisyonTipleriSecildi`executeBgTF=`bgColor=`transColor=`multiSelectTF=True`inactiveCommandName=`inactiveTimeout=`inactiveBgTF=", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "AutomationCommandExecuted", "Name": "EF- Kontrol Edilecek Adisyon Tipleri Sorusu", "RuleConstraints": "[{\"L\":\"CommandValue\",\"N\":\"JMZOj5yv7u\",\"O\":\"Equal\",\"R\":\"AdisyonTipleri\"},{\"L\":\"AutomationCommandName\",\"N\":\"OlCFlWb99q\",\"O\":\"Equal\",\"R\":\"ENT-ST-EFaturaTT\"}]", "SortOrder": 990, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": "", "Name": "ENT- Update Program Setting", "ParameterValues": "settingName=AdisyonTipleri`settingValue=[:CommandValue]`isLocalTF=False", "SortOrder": 10}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "AutomationCommandExecuted", "Name": "EF- Kontrol Edilecek Adisyon Tipleri Seçildi", "RuleConstraints": "[{\"L\":\"AutomationCommandName\",\"N\":\"OlCFlWb99q\",\"O\":\"Equal\",\"R\":\"AdisyonTipleriSecildi\"}]", "SortOrder": 1000, "Tags": "EF"}, {"Actions": [{"ActionName": null, "CustomConstraint": "'{CALL:sil.appCheck('Entegrasyon')}'=='False'", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.appCreate('Entegrasyon')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 10}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userRoleCheck('Entegrasyon')}'=='False'", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userRoleCreate('Entegrasyon')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 20}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('Entegrasyon')}'=='False' && '{CALL:sil.sseCheck()}'==''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreateEntegrasyon()`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 30}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('Entegrasyon')}'=='False' && '{CALL:sil.sseCheck()}'!=''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreateEntegrasyonSse()`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 40}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('Getir Yemek')}'=='False' && '{CALL:sil.sseCheck()}'==''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreate('Getir Yemek')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 50}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('Yemek Sepeti')}'=='False' && '{CALL:sil.sseCheck()}'==''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreate('Yemek Sepeti')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 60}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('Trendyol Yemek')}'=='False' && '{CALL:sil.sseCheck()}'==''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreate('Trendyol Yemek')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 70}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('WebEntegra')}'=='False' && '{CALL:sil.sseCheck()}'==''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreate('WebEntegra')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 80}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('WebEntegra')}'=='False' && '{CALL:sil.sseCheck()}'!=''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreateSse('WebEntegra')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 90}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('Trendyol Yemek')}'=='False' && '{CALL:sil.sseCheck()}'!=''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreateSse('Trendyol Yemek')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 100}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('Yemek Sepeti')}'=='False' && '{CALL:sil.sseCheck()}'!=''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreateSse('Yemek Sepeti')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 110}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('Getir Yemek')}'=='False' && '{CALL:sil.sseCheck()}'!=''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreateSse('Getir Yemek')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 120}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('Migros Yemek')}'=='False' && '{CALL:sil.sseCheck()}'==''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreate('Migros Yemek')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 130}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('Migros Yemek')}'=='False' && '{CALL:sil.sseCheck()}'!=''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreateSse('Migros Yemek')`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 140}, {"ActionName": null, "CustomConstraint": null, "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.renkupdate()`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 190}, {"ActionName": null, "CustomConstraint": null, "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.delRules()`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 200}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('BossEntegra')}'=='False' && '{CALL:sil.sseCheck()}'!=''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreateBossSse()`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 160}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('BossEntegra')}'=='False' && '{CALL:sil.sseCheck()}'==''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreateBoss()`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 150}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('Yetkisiz')}'=='False' && '{CALL:sil.sseCheck()}'!=''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreateYetkisizSse()`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 180}, {"ActionName": null, "CustomConstraint": "'{CALL:sil.userCheck('Yetkisiz')}'=='False' && '{CALL:sil.sseCheck()}'==''", "Name": "ENT- Execute Script", "ParameterValues": "Function=sil.userCreateYetkisiz()`Komut=`Parametreler=`RunInBGTrueFalse=True", "SortOrder": 170}], "AppRuleMaps": [{"DepartmentId": 0, "TerminalId": 0, "TicketTypeId": 0, "UserRoleId": 0}], "ConstraintMatch": 0, "EventName": "UserLoggedIn", "Name": "ENT- Entegrasyon Kullanıcılarını Oluştur", "RuleConstraints": "[]", "SortOrder": 1520, "Tags": "ENT"}], "Scripts": [{"Code": "//#####################################################################################################EFATURA\r\n\r\nfunction pavo(){\r\n\ttry {\r\n\t\tData.Set(\"canContinue\",true);\r\n\tvar paymentMethod = Data.Get(\"paymentTypeName\");\r\n\tvar amount = Data.Get(\"tenderedAmount\");\r\n\tvar paymentinfo = '';\r\n\tvar ticketId = JSON.parse(gql.Exec('{getLocalSetting(name:\"ticketId\"){name,value}}')).data.getLocalSetting.value;\r\n\tvar serialNumber = JSON.parse(gql.Exec('{getLocalSetting(name:\"EF-AktifCihaz\"){name,value}}')).data.getLocalSetting.value;\r\n\t if (serialNumber==null || serialNumber=='İPTAL'|| serialNumber=='') {\r\n var serialNumbers = JSON.parse(gql.Exec('{getGlobalSetting(name:\"SeriNolar\"){name,value}}')).data.getGlobalSetting.value; \r\n var serialNumberSelected = dlg.AskQuestion(\"Aktif Cihazı Seçin\",\"\"+serialNumbers+\",İPTAL\");\r\n var serialNumberUpdate = gql.Exec('mutation m {updateLocalSetting(name:\"EF-AktifCihaz\",value:\"'+serialNumberSelected+'\"){name,value}}');\r\n var serialNumber = JSON.parse(gql.Exec('{getLocalSetting(name:\"EF-AktifCihaz\"){name,value}}')).data.getLocalSetting.value;\r\n if (serialNumberSelected==\"İPTAL\") {\r\n Data.Set(\"canContinue\",false);\r\n dlg.ShowMessage(\"Ödemenin Alınacağı Cihaz Seçilmeden Devam Edilemez!\");\r\n return 1;\r\n }\r\n }\r\n\t//var serialNumber =''\r\n\t\r\n\tvar url = 'https://api.posentegra.com.tr/api/pavo-process';\r\n\tvar process = \"sendNotificationWithSerialNumber\";\r\n\tvar processType = \"getSaleInfo\";\r\n\tvar isWithInvoice = false;\r\n\tvar data =\r\n\t 'process=' + encodeURIComponent(process) +\r\n\t '&serialNumber=' + encodeURIComponent(serialNumber) +\r\n\t '&ticketId=' + encodeURIComponent(ticketId) +\r\n\t '&amount=' + encodeURIComponent(amount) +\r\n\t '&processType=' + encodeURIComponent(processType) +\r\n\t '&paymentMethod=' + (paymentMethod) +\r\n\t '&isWithInvoice=' + encodeURIComponent(isWithInvoice);\r\n\r\n\tvar result= web.Upload(url,data);\r\n\t result = JSON.parse(result)\r\n\t var hatamesaji='';\r\n\t \r\n\t if (result.success){\r\n\t\t paymentinfo +=result.paymentId;\r\n\t\t Data.Set(\"canContinue\",true);\r\n\t\t Data.Set(\"description\", paymentinfo);\r\n\t\t return 0;\r\n\t\t \r\n\t }else{\r\n\t \r\n\t\t Data.Set(\"canContinue\",false);\r\n\t\t dlg.ShowMessage(result.msg);\r\n\r\n\t\t return 1; \r\n\t }\r\n\t} catch (error) {\r\n\t\tData.Set(\"canContinue\",false);\r\n\t\tdlg.ShowMessage(\"Bağlantı Hatası!\");\r\n\t\treturn 1; \r\n\t}\r\n\t\r\n\t }\r\n\t\r\n\r\nfunction uptES() {\r\n var sorgu = '[{\"D\":null,\"N\":\"Execute Script\",\"O\":20,\"S\":\"{\\\\\"ConfirmMessageHandler\\\\\":null,\\\\\"PreProcessHandler\\\\\":null,\\\\\"PreValidationHandler\\\\\":null,\\\\\"ProcessHandler\\\\\":\\\\\"pe.pavo()\\\\\"}\"}]';\r\n var sonuc = sql.ExecSql(\"UPDATE PaymentTypes SET PaymentTypes.ProcessorSettings ='\"+sorgu+\"' WHERE PaymentTypes.Name!='Müşteri Hesabı'\");\r\n}\r\n\r\nfunction uptAPC() {\r\n var sorgu = '[{\"D\":null,\"N\":\"Ask Payment Description\",\"O\":20,\"S\":\"{\\\\\"DescriptionTemplate\\\\\":\\\\\"[?Fatura No:]\\\\\"}\"}]';\r\n var sonuc = sql.ExecSql(\"UPDATE PaymentTypes SET PaymentTypes.ProcessorSettings ='\"+sorgu+\"' WHERE PaymentTypes.Name!='Müşteri Hesabı'\");\r\n}\r\n\r\n\tfunction sambaGunBasi(){ \r\n\tvar userId = JSON.parse(gql.Exec('{getGlobalSetting(name:\"ENTID\"){name,value}}')).data.getGlobalSetting.value; \r\n\tvar url = 'https://api.posentegra.com.tr/api/samba';\r\n\tvar process = \"login\";\r\n\tvar data =\r\n\t\t 'process='+process +\r\n\t\t '&user_id='+ userId;\r\n\tvar result= web.Upload(url,data);\r\n\t}\r\n\r\nfunction cari(paymentMethod,amount,ticketId){\r\n\tvar paymentinfo = '';\r\n\t//var serialNumber = JSON.parse(gql.Exec('{getLocalSetting(name:\"EF-AktifCihaz\"){name,value}}')).data.getLocalSetting.value;\r\n var serialNumber ='N860W6A2997'\r\n\tvar url = 'https://api.posentegra.com.tr/api/pavo-process';\r\n\tvar process = \"sendNotificationWithSerialNumber\";\r\n\tvar processType = \"getSaleInfo\";\r\n\tvar isWithInvoice = false;\r\n\tvar data =\r\n\t 'process=' + encodeURIComponent(process) +\r\n\t '&serialNumber=' + encodeURIComponent(serialNumber) +\r\n\t '&ticketId=' + encodeURIComponent(ticketId) +\r\n\t '&amount=' + encodeURIComponent(amount) +\r\n\t '&processType=' + encodeURIComponent(processType) +\r\n\t '&paymentMethod=' + (paymentMethod) +\r\n\t '&isWithInvoice=' + encodeURIComponent(isWithInvoice);\r\n\r\n\tvar result= web.Upload(url,data);\r\n\r\n\t \r\n\t}\r\n\r\n\r\nfunction delACMap(id,d1,d2){\r\nsql.ExecSql(\"DELETE FROM AutomationCommandLogs\");\r\n}\r\n\r\n\r\n//#####################################################################################################EFATURA\r\n\r\n\r\n//##################################################################################################POSENTEGRA\r\n\r\n\r\nif (!Array.prototype.findIndex) {\r\n Array.prototype.findIndex = function(predicate) {\r\n if (this === null) {\r\n throw new TypeError('Array.prototype.findIndex called on null or undefined');\r\n }\r\n if (typeof predicate !== 'function') {\r\n throw new TypeError('predicate must be a function');\r\n }\r\n var list = Object(this);\r\n var length = list.length >>> 0;\r\n var thisArg = arguments[1];\r\n for (var i = 0; i < length; i++) {\r\n if (predicate.call(thisArg, list[i], i, list)) {\r\n return i;\r\n }\r\n }\r\n return -1;\r\n };\r\n}\r\n\r\nfunction orderid(entityname) {\r\n var str = entityname;\r\n var patt1 = /\\d{1,}/g; \r\n var result = str.match(patt1);\r\n return result [0]\r\n}\r\nfunction split(data,no) {\r\nvar splited = data.split(\"|\")[no];\r\nreturn splited;\r\n}\r\nfunction ekodu(mesaj) {\r\n var str = mesaj;\r\n \tstr = str.replace('ENT-YeniSiparis-','')\r\n \treturn str\r\n}\r\nfunction konum(mesaj) {\r\n var str = mesaj;\r\n \tstr = str.replace(',',' ')\r\n \treturn str\r\n}\r\n\r\nfunction location(mesaj) {\r\n var str = mesaj;\r\n str = str.replace('https://www.google.com/maps/place/','')\r\n \tstr = str.replace(',',' ')\r\n \treturn str\r\n}\r\n\r\n\r\nfunction wpId(mesaj) {\r\n var str = mesaj;\r\n \tstr = str.replace('ENTWP-','')\r\n \treturn str\r\n}\r\nfunction degistir(degis,mesaj) {\r\n var str = mesaj;\r\n \tstr = str.replace(degis,'')\r\n \treturn str\r\n}\r\nfunction cnv(mesaj) {\r\n var str = mesaj;\r\n \tstr = str.replace(',','.')\r\n \treturn str\r\n}\r\nfunction order(orderid) {\r\n var u = 'https://app.posentegra.com/pe/changeStatus?id='+orderid+'&token=ndbngpKPABDn24G2';\r\n var data=web.Download(u)\r\n return data\r\n}\r\nfunction border(orderid) {\r\n var u = 'https://app.posentegra.com/pe/bulkChangeStatus?id='+orderid+'&token=ndbngpKPABDn24G2';\r\n var data=web.Download(u)\r\n return data\r\n}\r\n\r\nfunction posticket(orderid,ticketid) {\r\n var u = 'https://api.posentegra.com/api/savePosTicket?id='+orderid+'&pos_ticket='+ticketid+'&token=swdedsas';\r\n var data=web.Download(u)\r\n return data\r\n}\r\n\r\n\r\nfunction updateStateSql(id,d1,d2){\r\nsql.ExecSql(\"UPDATE Tickets SET Tickets.TicketStates = REPLACE(Tickets.TicketStates, '\"+d1+\"','\"+d2+\"') WHERE Tickets.Id='\"+id+\"'\");\r\n}\r\n\r\nfunction ticketCheck(state,id){\r\nreturn sql.Query(\"SELECT T.Id FROM Tickets T WHERE T.TicketStates LIKE '%\"+state+\"%' AND T.Id='\"+id+\"'\").Join();\r\n}\r\nfunction ticketCheckByTag(state,tag){\r\nreturn sql.Query(\"SELECT T.Id FROM Tickets T WHERE T.TicketStates LIKE '%\"+state+\"%' AND T.TicketTags LIKE '%\"+tag+\"%'\").Join();\r\n}\r\n\r\n\r\nfunction ticketListByState(state,split){\r\nreturn sql.Query(\"SELECT T.Id FROM Tickets T WHERE T.TicketStates LIKE '%\"+state+\"%'\").Join(''+split+'');\r\n}\r\n\r\n\r\nfunction updateState(id,d2){\r\nvar terminal = JSON.parse(gql.Exec('mutation m1 {registerTerminal(user: \"Entegrasyon\", ticketType: \"Paket Servis\", terminal: \"Sunucu\", department: \"Restoran\")}')).data.registerTerminal;\r\ngql.Exec('mutation m2 {loadTerminalTicket(terminalId:\"'+terminal+'\",ticketId:\"'+id+'\") {id}}');\r\ngql.Exec('mutation m4 {updateTerminalTicket(terminalId: \"'+terminal+'\", states: [{stateName: \"Paket\", state: \"'+d2+'\"}]) {id}}');\r\ngql.Exec('mutation m5 {closeTerminalTicket(terminalId:\"'+terminal+'\")}');\r\ngql.Exec('mutation m6 {unregisterTerminal(terminalId:\"'+terminal+'\")}');\r\n}\r\n\r\nfunction ticketQuantityByState(state,split){\r\nreturn sql.Query(\"SELECT COUNT(T.Id) FROM Tickets T WHERE T.TicketStates LIKE '%\"+state+\"%'\").Join(''+split+'');\r\n}\r\n\r\nfunction updateEntity(id,d2,pktc){\r\nvar terminal = JSON.parse(gql.Exec('mutation m1 {registerTerminal(user: \"Entegrasyon\", ticketType: \"Paket Servis\", terminal: \"Sunucu\", department: \"Restoran\")}')).data.registerTerminal;\r\ngql.Exec('mutation m2 {loadTerminalTicket(terminalId:\"'+terminal+'\",ticketId:\"'+id+'\") {id}}');\r\ngql.Exec('mutation m3 {changeEntityOfTerminalTicket(terminalId: \"'+terminal+'\", type: \"Paketçiler\", name: \"'+pktc+'\") {id}}');\r\ngql.Exec('mutation m4 {updateTerminalTicket(terminalId: \"'+terminal+'\", states: [{stateName: \"Paket\", state: \"'+d2+'\"}, {stateName: \"Paketçi Adı\", state: \"'+pktc+'\"}]) {id}}');\r\ngql.Exec('mutation m5 {closeTerminalTicket(terminalId:\"'+terminal+'\")}');\r\ngql.Exec('mutation m6 {unregisterTerminal(terminalId:\"'+terminal+'\")}');\r\n}\r\n\r\nfunction updateStateBulk(d1,d2){\r\nvar terminal = JSON.parse(gql.Exec('mutation m1 {registerTerminal(user: \"Entegrasyon\", ticketType: \"Paket Servis\", terminal: \"Sunucu\", department: \"Restoran\")}')).data.registerTerminal;\r\nvar veri\t= sql.Query(\"SELECT T.Id FROM Tickets T WHERE T.TicketStates LIKE '%\"+d1+\"%'\").Join('~').split('~');\r\nfor(var i = 0; i < veri.length; i++) {\r\ngql.Exec('mutation m2 {loadTerminalTicket(terminalId:\"'+terminal+'\",ticketId:\"'+veri[i]+'\") {id}}');\r\ngql.Exec('mutation m4 {updateTerminalTicket(terminalId: \"'+terminal+'\", states: [{stateName: \"Paket\", state: \"'+d2+'\"}]) {id}}');\r\ngql.Exec('mutation m5 {closeTerminalTicket(terminalId:\"'+terminal+'\")}');\r\n}\r\ngql.Exec('mutation m6 {unregisterTerminal(terminalId:\"'+terminal+'\")}');\r\n}\r\n\r\n\r\nfunction updateEntityBulk(d1,d2,pktc){\r\nvar terminal = JSON.parse(gql.Exec('mutation m1 {registerTerminal(user: \"Entegrasyon\", ticketType: \"Paket Servis\", terminal: \"Sunucu\", department: \"Restoran\")}')).data.registerTerminal;\r\nvar veri\t= sql.Query(\"SELECT T.Id FROM Tickets T WHERE T.TicketStates LIKE '%\"+d1+\"%'\").Join('~').split('~');\r\nfor(var i = 0; i < veri.length; i++) {\r\ngql.Exec('mutation m2 {loadTerminalTicket(terminalId:\"'+terminal+'\",ticketId:\"'+veri[i]+'\") {id}}');\r\ngql.Exec('mutation m3 {changeEntityOfTerminalTicket(terminalId: \"'+terminal+'\", type: \"Paketçiler\", name: \"'+pktc+'\") {id}}');\r\ngql.Exec('mutation m4 {updateTerminalTicket(terminalId: \"'+terminal+'\", states: [{stateName: \"Paket\", state: \"'+d2+'\"}, {stateName: \"Paketçi Adı\", state: \"'+pktc+'\"}]) {id}}');\r\ngql.Exec('mutation m5 {closeTerminalTicket(terminalId:\"'+terminal+'\")}');\r\n}\r\ngql.Exec('mutation m6 {unregisterTerminal(terminalId:\"'+terminal+'\")}');\r\n}\r\n\r\n\r\nfunction findStateIndexByName(stateName) {\r\n return function(state) {\r\n return state.stateName === stateName;\r\n };\r\n}\r\nfunction ticketStateValue(id,stateName){\r\nvar data = JSON.parse(gql.Exec('query q1 {getTicket(id: '+id+') {states {stateName state}}}')).data.getTicket.states;\r\nvar index = data.findIndex(findStateIndexByName(stateName))\r\nreturn data[index].state;\r\n}\r\n\r\nfunction payTicket(id,stateName){\r\nvar terminal = JSON.parse(gql.Exec('mutation m1 {registerTerminal(user: \"Entegrasyon\", ticketType: \"Paket Servis\", terminal: \"Sunucu\", department: \"Restoran\")}')).data.registerTerminal;\r\nvar pt = ticketStateValue(id,stateName)\r\ngql.Exec('mutation m2 {loadTerminalTicket(terminalId:\"'+terminal+'\",ticketId:\"'+id+'\") {id}}');\r\ngql.Exec('mutation m3 {payTerminalTicket(terminalId:\"'+terminal+'\",paymentTypeName:\"'+pt+'\",executePaymentProcessors:true) {ticketid}}');\r\ngql.Exec('mutation m5 {closeTerminalTicket(terminalId:\"'+terminal+'\")}');\r\ngql.Exec('mutation m6 {unregisterTerminal(terminalId:\"'+terminal+'\")}');\r\n}\r\n\r\nfunction payTicketBulk(d1,stateName){\r\nvar terminal = JSON.parse(gql.Exec('mutation m1 {registerTerminal(user: \"Entegrasyon\", ticketType: \"Paket Servis\", terminal: \"Sunucu\", department: \"Restoran\")}')).data.registerTerminal;\r\nvar veri\t= sql.Query(\"SELECT T.Id FROM Tickets T WHERE T.TicketStates LIKE '%\"+d1+\"%'\").Join('~').split('~');\r\nfor(var i = 0; i < veri.length; i++) {\r\nvar pt = ticketStateValue(veri[i],stateName)\r\ngql.Exec('mutation m2 {loadTerminalTicket(terminalId:\"'+terminal+'\",ticketId:\"'+veri[i]+'\") {id}}');\r\ngql.Exec('mutation m3 {payTerminalTicket(terminalId:\"'+terminal+'\",paymentTypeName:\"'+pt+'\",executePaymentProcessors:true) {ticketid}}');\r\ngql.Exec('mutation m5 {closeTerminalTicket(terminalId:\"'+terminal+'\")}');\r\n}\r\ngql.Exec('mutation m6 {unregisterTerminal(terminalId:\"'+terminal+'\")}');\r\n}\r\n\r\nfunction moveTickets(date){\r\nvar veri = sql.Query(\"SELECT T.Id FROM Tickets T WHERE T.IsClosed=0\").Join('~').split('~');\r\nfor(var i = 0; i < veri.length; i++){\r\nvar up = sql.Exec(\"UPDATE AccountTransactionDocuments SET Date='\"+date+\"' WHERE Id=\"+veri[i]+\"\");\r\n}\r\n}\r\n\r\nfunction convertType(id){\r\nvar up = sql.Exec(\"UPDATE Tickets SET PreOrder=0 WHERE Id=\"+id+\"\");\r\n}\r\n\r\n\r\nfunction convertTicketType(id){\r\nvar up = sql.Exec(\"UPDATE TicketTypes SET PreOrder=\"+id+\"\");\r\n}\r\n\r\n//##################################################################################################POSENTEGRA\r\n\r\n\r\n\r\n//##################################################################################################CUSTOMIZE\r\nfunction updateACS(ACName,ACS,TF){\r\nvar ac= sql.Exec(\"SELECT Id FROM AutomationCommands AC WHERE AC.Name='\"+ACName+\"'\");\r\nvar acid = ac[0]\r\nvar up = sql.Exec(\"UPDATE AutomationCommandMaps SET \"+ACS+\"='\"+TF+\"' WHERE AutomationCommandId='\"+acid+\"'\");\r\nreturn up[0];\r\n}\r\nfunction updateACA(ACName,Type){\r\nvar up = sql.Exec(\"UPDATE AutomationCommands SET ConfirmationType='\"+Type+\"' WHERE Name='\"+ACName+\"'\");\r\nreturn up[0];\r\n}\r\nfunction updatePT(PTName,PType,AcType){\r\nvar up = sql.Exec(\"UPDATE Accounts SET AccountTypeId='\"+AcType+\"' WHERE Name='\"+PTName+\"'\");\r\nvar pt= sql.Exec(\"SELECT Id FROM PaymentTypes PT WHERE PT.Name='\"+PTName+\"'\");\r\nvar ptid = pt[0]\r\nvar uppt = sql.Exec(\"UPDATE PaymentTypeMaps SET TicketTypeId='\"+PType+\"' WHERE PaymentTypeId='\"+ptid+\"'\");\r\nreturn uppt[0];\r\n}\r\nfunction updateCA(PTName,PType){\r\nvar pt= sql.Exec(\"SELECT Id FROM PaymentTypes PT WHERE PT.Name='\"+PTName+\"'\");\r\nvar ptid = pt[0]\r\nvar uppt = sql.Exec(\"UPDATE PaymentTypeMaps SET TicketTypeId='\"+PType+\"' WHERE PaymentTypeId='\"+ptid+\"'\");\r\nreturn uppt[0];\r\n}\r\nfunction updateOP(PTName,AcType){\r\nvar up = sql.Exec(\"UPDATE Accounts SET AccountTypeId='\"+AcType+\"' WHERE Name='\"+PTName+\"'\");\r\nreturn up;\r\n}\r\nfunction copy(dosyayolu,yenidosyayolu){\r\n var object = new ActiveXObject(\"Scripting.FileSystemObject\");\r\n var file = object.GetFile(dosyayolu);\r\n file.Copy(yenidosyayolu);\r\n}\r\nfunction del(dosyayolu){\r\n var object = new ActiveXObject(\"Scripting.FileSystemObject\");\r\n var file = object.GetFile(dosyayolu);\r\n file.Delete();\r\n}\r\nfunction readGlobalSetting(name){\r\nvar globalSetting = JSON.parse(gql.Exec('{getGlobalSetting(name:\"'+name+'\"){name,value}}')).data.getGlobalSetting.value;\r\nreturn globalSetting\r\n}\r\nfunction readLocalSetting(name){\r\nvar localSetting = JSON.parse(gql.Exec('{getLocalSetting(name:\"'+name+'\"){name,value}}')).data.getLocalSetting.value;\r\nreturn localSetting\r\n}\r\n\r\nfunction globalSetting(name,updatetype,value){\r\nvar globalSetting = JSON.parse(gql.Exec('{getGlobalSetting(name:\"'+name+'\"){name,value}}')).data.getGlobalSetting.value;\r\nif(updatetype==\"Arttır\"){\r\nvar newValue = (Number(globalSetting) + Number(value));\r\nvar newGlobalSetting = gql.Exec('mutation m {updateGlobalSetting(name:\"'+name+'\",value:\"'+newValue+'\"){name,value}}');\r\nvar newGlobalSetting = JSON.parse(gql.Exec('{getGlobalSetting(name:\"'+name+'\"){name,value}}')).data.getGlobalSetting.value;\r\nreturn newGlobalSetting\r\n}\r\nif(updatetype==\"Güncelle\"){\r\nvar newValue = value;\r\nvar newGlobalSetting = gql.Exec('mutation m {updateGlobalSetting(name:\"'+name+'\",value:\"'+newValue+'\"){name,value}}');\r\nvar newGlobalSetting = JSON.parse(gql.Exec('{getGlobalSetting(name:\"'+name+'\"){name,value}}')).data.getGlobalSetting.value;\r\nreturn newGlobalSetting\r\n}\r\nif(updatetype==\"Azalt\"){\r\nvar newValue = (Number(globalSetting) - Number(value));\r\nvar newGlobalSetting = gql.Exec('mutation m {updateGlobalSetting(name:\"'+name+'\",value:\"'+newValue+'\"){name,value}}');\r\nvar newGlobalSetting = JSON.parse(gql.Exec('{getGlobalSetting(name:\"'+name+'\"){name,value}}')).data.getGlobalSetting.value;\r\nreturn newGlobalSetting}\r\n}\r\n\r\nfunction localSetting(name,updatetype,value){\r\nvar localSetting = JSON.parse(gql.Exec('{getLocalSetting(name:\"'+name+'\"){name,value}}')).data.getLocalSetting.value;\r\nif(updatetype==\"Arttır\"){\r\nvar newValue = (Number(localSetting) + Number(value));\r\nvar newLocalSetting = gql.Exec('mutation m {updateLocalSetting(name:\"'+name+'\",value:\"'+newValue+'\"){name,value}}');\r\nvar newLocalSetting = JSON.parse(gql.Exec('{getLocalSetting(name:\"'+name+'\"){name,value}}')).data.getLocalSetting.value;\r\nreturn newLocalSetting\r\n}\r\nif(updatetype==\"Güncelle\"){\r\nvar newValue = value;\r\nvar newLocalSetting = gql.Exec('mutation m {updateLocalSetting(name:\"'+name+'\",value:\"'+newValue+'\"){name,value}}');\r\nvar newLocalSetting = JSON.parse(gql.Exec('{getLocalSetting(name:\"'+name+'\"){name,value}}')).data.getLocalSetting.value;\r\nreturn newLocalSetting\r\n}\r\nif(updatetype==\"Azalt\"){\r\nvar newValue = (Number(localSetting) - Number(value));\r\nvar newLocalSetting = gql.Exec('mutation m {updateLocalSetting(name:\"'+name+'\",value:\"'+newValue+'\"){name,value}}');\r\nvar newLocalSetting = JSON.parse(gql.Exec('{getLocalSetting(name:\"'+name+'\"){name,value}}')).data.getLocalSetting.value;\r\nreturn newLocalSetting}\r\n}\r\n//##################################################################################################CUSTOMIZE\r\n\r\n\r\n\r\n//##################################################################################################BOSSENTEGRA\r\n\r\nfunction spver(ver){\r\nvar up = sql.Exec(\"SELECT [Version] From [VersionInfo] Where [Version]=\"+ver+\"\");\r\nreturn up[0];\r\n}\r\n\r\nfunction changePin(newPin) {\r\nvar pin = sql.Exec(\"UPDATE [Users] SET [PinCode] = '\"+newPin+\"' WHERE [NAME] = 'BossEntegra'\");\r\n}\r\n\r\nfunction changeUserPin(newPin,user) {\r\nvar pin = sql.Exec(\"UPDATE [Users] SET [PinCode] = '\"+newPin+\"' WHERE [NAME] = '\"+user+\"'\");\r\n}\r\n\r\nfunction getPin() {\r\n var pin = sql.Exec(\"SELECT PinCode FROM Users WHERE Name = 'BossEntegra'\");\r\n return pin[0];\r\n}\r\nfunction getUserPin(user) {\r\n var pin = sql.Exec(\"SELECT PinCode FROM Users WHERE Name = '\"+user+\"'\");\r\n return pin[0];\r\n}\r\n\r\nfunction pushget(pin,title,body,userId,type) {\r\n \tvar userId = JSON.parse(gql.Exec('{getGlobalSetting(name:\"ENTID\"){name,value}}')).data.getGlobalSetting.value; \r\n\tvar url = 'https://api.v1.posentegra.com.tr/api/push/'+userId+'?pin='+pin+'&body='+body+'&title='+title+'&type='+type;\r\n\tvar data=web.Download(url);\r\n return data;\r\n}\r\n\r\nfunction push(pin,title,body,userId,type) {\r\n\tvar userId = JSON.parse(gql.Exec('{getGlobalSetting(name:\"ENTID\"){name,value}}')).data.getGlobalSetting.value; \r\n\tvar url = 'https://api.v1.posentegra.com.tr/api/push/'+userId ;\r\n\tvar data = 'pin='+pin+'&body='+body+'&title='+title+'&type='+type;\r\n\tvar result= web.Upload(url,data);\r\n\tresult = JSON.parse(result)\r\n\tvar hatamesaji='';\r\n\tif (result.success){\r\n\t\thatamesaji = \"Success\";\r\n\t}else{\r\n\t\thatamesaji = \"Error\";\r\n\t}\r\n\treturn hatamesaji;\r\n}\r\n\r\n//##################################################################################################BOSSENTEGRA\r\n\r\n\r\n//##################################################################################################BARCODE\r\nfunction baruyar(){dlg.AskQuestion('Barkod Bulunamadı
Eklemek isterseniz Yeni Ekle Dokunun','OK=OK:black;black','darkred','',0,'POSENTEGRA');}\r\nfunction barstock(barcode){return sql.Query(\"Select Barcode From InventoryItems Where Barcode = '\"+barcode+\"' \").First;}\r\nfunction stockadd(barcode){\r\nvar barcodeCount = sql.Query(\"Select COUNT(Barcode) From InventoryItems Where Barcode = '\"+barcode+\"' \").First;\r\nif(barcodeCount==1){\r\nvar itemstockid = sql.Query(\"Select Id From InventoryItems Where Barcode = '\"+barcode+\"' \").First;\r\nvar portionid = sql.Query(\"SELECT MenuItemPortions.Id FROM MenuItems INNER JOIN MenuItemPortions ON MenuItems.Id = MenuItemPortions.MenuItemId WHERE MenuItems.Barcode = '\"+barcode+\"' AND MenuItemPortions.Name IN ('Normal')\").First;\r\nvar qty = dlg.EditValue(\"Stok Miktarı;.{1,};;OCN\",\"\");\r\nvar date = new Date().toLocaleDateString()\r\nvar date2 = sql.Query(\"SELECT FORMAT( GETDATE(), 'yyyy-MM-dd hh:mm:ss.fff')\").First;\r\nvar qry3 = \"INSERT INTO [InventoryTransactionDocuments]\"; \r\n qry3 += \"([Date],[InventoryDocumentTransactionTypeId],[TransactionAccountTransactionTypeId],[AccountTypeId],[AccountId],[Description],[ForeignCurrencyId],[Name],[AccountTransactionDocument_Id])\";\r\n qry3 += \"VALUES ('\"+date2+\"',0,0,0,0,NULL,0,'\"+date+\"',NULL)\";\r\n sql.ExecSql(qry3)\r\nvar indid = \"Select Id From InventoryTransactionDocuments Where Date = '\"+date2+\"'\";\r\nvar indid = sql.Query(indid).First;\r\nvar qry2 = \"INSERT INTO [InventoryTransactions]\"; \r\n qry2 += \"([InventoryTransactionDocumentId],[InventoryTransactionTypeId],[SourceWarehouseId],[TargetWarehouseId],[Date],[Unit],[Multiplier],[Quantity],[TotalPrice],[ExchangeRate],[InventoryItem_Id])\";\r\n qry2 += \"VALUES (\"+indid+\",1,0,1,'\"+date2+\"','Normal',1,\"+qty+\",0.00,1.0000000000,\"+itemstockid+\")\";\r\n sql.ExecSql(qry2)\r\n } else if (barcodeCount==0){dlg.AskQuestion('Barkod Bulunamadı',' ','darkred','',2,'POSENTEGRA');}\r\n}\r\n//##################################################################################################BARCODE\r\n\r\n\r\n\r\n\r\nfunction stockaddınv(){\r\nvar date = new Date().toLocaleDateString()\r\nvar date2 = sql.Query(\"SELECT FORMAT( GETDATE(), 'yyyy-MM-dd HH:mm:ss.fff')\").First;\r\n\r\nvar qry3 = \"INSERT INTO [InventoryTransactionDocuments]\"; \r\n qry3 += \"([Date],[InventoryDocumentTransactionTypeId],[TransactionAccountTransactionTypeId],[AccountTypeId],[AccountId],[Description],[ForeignCurrencyId],[Name],[AccountTransactionDocument_Id])\";\r\n qry3 += \"VALUES ('\"+date2+\"',0,0,0,0,NULL,0,'\"+date+\"',NULL)\";\r\n sql.ExecSql(qry3)}\r\n\r\n//#################################################################################################\r\n\r\nfunction stockbar(barcode,qty){\r\nvar itemstockid = sql.Query(\"Select Id From InventoryItems Where Barcode = '\"+barcode+\"' \").First;\r\nvar portionid = sql.Query(\"SELECT MenuItemPortions.Id FROM MenuItems INNER JOIN MenuItemPortions ON MenuItems.Id = MenuItemPortions.MenuItemId WHERE MenuItems.Barcode = '\"+barcode+\"' AND MenuItemPortions.Name IN ('Normal')\").First;\r\n\r\nvar date2 = sql.Query(\"SELECT FORMAT( GETDATE(), 'yyyy-MM-dd HH:mm:ss.fff')\").First;\r\nvar indid = sql.Query(\"Select TOP (1) Id From InventoryTransactionDocuments ORDER BY ID DESC\").First;\r\nvar qry2 = \"INSERT INTO [InventoryTransactions]\"; \r\n qry2 += \"([InventoryTransactionDocumentId],[InventoryTransactionTypeId],[SourceWarehouseId],[TargetWarehouseId],[Date],[Unit],[Multiplier],[Quantity],[TotalPrice],[ExchangeRate],[InventoryItem_Id])\";\r\n qry2 += \"VALUES (\"+indid+\",1,0,1,'\"+date2+\"','Normal',1,\"+qty+\",0.00,1.0000000000,\"+itemstockid+\")\";\r\n sql.ExecSql(qry2)\r\n }\r\n \r\n \r\n//#################################################################################################\r\n\r\nfunction addstock1(barcode){\r\nvar q = \"SELECT COUNT(Barcode) FROM MenuItems WHERE Barcode = '\"+barcode+\"'\";\r\nvar barcodeCount = sql.Query(q).First;\r\nvar q = \"SELECT Name FROM MenuItems WHERE Barcode = '\"+barcode+\"'\";\r\nvar ürün= sql.Query(q).First;\r\nif (barcodeCount==1){return dlg.AskQuestion(' '+barcode+'\\r Barkod Kullanımda.\\r\\r Ürün Adı\\t '+ürün+'','OK=OK:lime;green','darkred','',2,'POSENTEGRA');}\r\nvar name = dlg.EditValue(\"Ürün Adı;.{1,};;;OC\",\"\");\r\nvar q1 = \"SELECT COUNT(Name) FROM MenuItems WHERE Name IN ('\"+name+\"')\";\r\nvar nameCount = sql.Query(q1).First;\r\nif (nameCount==1 || name==null){return dlg.AskQuestion('İptal Edildi.\\r\\r Ürün Yok','OK=OK:lime;green','darkred','',2,'POSENTEGRA');}\r\nvar categories = sql.Query(\"SELECT DISTINCT GroupCode From MenuItems\").Join('|');\r\nvar group = dlg.EditValue(\"Kategori;[A-Z][a-z]{1,100}\",\"\"+categories+\"\");\r\nvar price = dlg.EditValue(\"Fiyatı;[0-9.]{1,};;ON;49,50,51|52,53,54|55,56,57|190,48,8\",\"\");\r\ngql.Exec('mutation m{addProduct(name:\"'+name+'\",groupCode:\"'+group+'\",barcode:\"'+barcode+'\",portions:[{name:\"Normal\",price:0}]){id}}');\r\nvar qry = \"SELECT MenuItemPrices.MenuItemPortionId \";\r\n qry += \"FROM MenuItems INNER JOIN MenuItemPortions ON MenuItems.Id = MenuItemPortions.MenuItemId \";\r\n qry += \"INNER JOIN MenuItemPrices ON MenuItemPortions.Id = MenuItemPrices.MenuItemPortionId \"; \r\n qry += \"WHERE MenuItems.Barcode = '\"+barcode+\"'\";\r\nvar id = sql.Query(qry).First;\r\nsql.ExecSql(\"UPDATE MenuItemPrices SET MenuItemPrices.Price = '\"+price+\"' WHERE MenuItemPrices.MenuItemPortionId = '\"+id+\"'\");\r\nvar qry = \"INSERT INTO [InventoryItems]\"; \r\n qry += \"([Barcode],[GroupCode],[WarehouseCode],[BaseUnit],[TransactionUnit],[TransactionUnitMultiplier],[Warehouse],[DefaultBaseUnitCost],[DefaultTransactionUnitCost],[ForeignCurrencyId],[CustomTags],[Name])\";\r\n qry += \"VALUES (\"+barcode+\",'\"+group+\"',NULL,'Normal',NULL,0,'Yerel Depo',0.00,0.00,0,NULL,'\"+name+\"')\";\r\n sql.ExecSql(qry)\r\nvar itemstockid = sql.Query(\"Select Id From InventoryItems Where Name IN ('\"+name+\"')\").First;\r\nvar portionid = sql.Query(\"SELECT MenuItemPortions.Id FROM MenuItems INNER JOIN MenuItemPortions ON MenuItems.Id = MenuItemPortions.MenuItemId WHERE MenuItems.Name IN ('\"+name+\"') AND MenuItemPortions.Name IN ('Normal')\").First;\r\n var qry4 = \"INSERT INTO [Recipes]\"; \r\n qry4 += \"([PortionId],[FixedCost],[GroupCode],[Name])\";\r\n qry4 += \"VALUES (\"+portionid+\",0.00,'General','\"+name+\" Reçetesi')\";\r\n sql.ExecSql(qry4)\r\nvar recipeid = sql.Query(\"Select Id From Recipes Where Name IN ('\"+name+\" Reçetesi')\").First;\r\nvar qry4 = \"INSERT INTO [RecipeItems]\"; \r\n qry4 += \"([RecipeId],[OrderTag],[Quantity],[ItemType],[InventoryItem_Id],[MenuItemPortion_Id])\";\r\n qry4 += \"VALUES (\"+recipeid+\",NULL,1.00,0,\"+itemstockid+\",NULL)\";\r\n sql.ExecSql(qry4)\r\ngql.Exec('mutation m1 {postResetCacheMessage {id}}');\r\n}\r\n\r\n//###########################################################################################\r\n\r\nfunction stocknew(barcode){\r\nvar bar = \"SELECT COUNT(Barcode) FROM MenuItems WHERE Barcode = '\"+barcode+\"'\";\r\nvar barcodeCount= sql.Query(bar).First;\r\nif (barcodeCount==1){\r\nvar q = \"SELECT Name FROM MenuItems WHERE Barcode = '\"+barcode+\"'\";\r\nvar name= sql.Query(q).First;\r\nvar q1 = \"SELECT GroupCode FROM MenuItems WHERE Barcode = '\"+barcode+\"'\";\r\nvar group = sql.Query(q1).First;\r\nvar qry = \"INSERT INTO [InventoryItems]\"; \r\n qry += \"([Barcode],[GroupCode],[WarehouseCode],[BaseUnit],[TransactionUnit],[TransactionUnitMultiplier],[Warehouse],[DefaultBaseUnitCost],[DefaultTransactionUnitCost],[ForeignCurrencyId],[CustomTags],[Name])\";\r\n qry += \"VALUES (\"+barcode+\",'\"+group+\"',NULL,'Normal',NULL,0,'Yerel Depo',0.00,0.00,0,NULL,'\"+name+\"')\";\r\n sql.ExecSql(qry)\r\nvar itemstockid = sql.Query(\"Select Id From InventoryItems Where Name IN ('\"+name+\"')\").First;\r\nvar portionid = sql.Query(\"SELECT MenuItemPortions.Id FROM MenuItems INNER JOIN MenuItemPortions ON MenuItems.Id = MenuItemPortions.MenuItemId WHERE MenuItems.Name IN ('\"+name+\"') AND MenuItemPortions.Name IN ('Normal')\").First;\r\nvar qry4 = \"INSERT INTO [Recipes]\"; \r\n qry4 += \"([PortionId],[FixedCost],[GroupCode],[Name])\";\r\n qry4 += \"VALUES (\"+portionid+\",0.00,'General','\"+name+\" Reçetesi')\";\r\n sql.ExecSql(qry4)\r\nvar recipeid = sql.Query(\"Select Id From Recipes Where Name IN ('\"+name+\" Reçetesi')\").First;\r\nvar qry4 = \"INSERT INTO [RecipeItems]\"; \r\n qry4 += \"([RecipeId],[OrderTag],[Quantity],[ItemType],[InventoryItem_Id],[MenuItemPortion_Id])\";\r\n qry4 += \"VALUES (\"+recipeid+\",NULL,1.00,0,\"+itemstockid+\",NULL)\";\r\n sql.ExecSql(qry4)\r\ngql.Exec('mutation m1 {postResetCacheMessage {id}}');\r\ndlg.AskQuestion('Stok Eklendi?',' ','white','',2,'POSENTEGRA');\r\n} else if (barcodeCount==0){dlg.AskQuestion('Barkod Bulunamadı
Eklemek isterseniz Yeni Ekle Dokunun','OK=OK:black;black','darkred','',0,'POSENTEGRA');}\r\n}\r\n\r\n\r\n\r\n//############################################################################################\r\nfunction additem(){\r\nvar name = dlg.EditValue(\"Ürün Adı;.{1,};;;OC\",\"\");\r\nvar q1 = \"SELECT COUNT(Name) FROM MenuItems WHERE Name IN ('\"+name+\"')\";\r\nvar nameCount = sql.Query(q1).First;\r\nif (nameCount==1 || name==null){return dlg.AskQuestion(' '+name+'\\r\\tIt is cancelled.\\r\\r There is product','OK=OK:lime;green','darkred','',2,'POSENTEGRA');}\r\nvar price = dlg.EditValue(\"Fiyatı;[0-9.]{1,};;ON;49,50,51|52,53,54|55,56,57|190,48,8\",\"\");\r\nvar groupcode = sql.Query('select DISTINCT GroupCode from MenuItems').Join('|');\r\nvar groupcodename = dlg.EditValue(\"Grup Adı;.{1,};;;OC\",\"*\"+groupcode+\"\");\r\nif (groupcodename==null){return dlg.AskQuestion(' İptal Edildi.\\r\\r Ürün Var','OK=OK:lime;green','darkred','',2,'POSENTEGRA');}\r\ngqlitem = 'mutation m{addProduct(name:\"'+name+'\",groupCode:\"'+groupcodename+'\",barcode:\"\",portions:[{name:\"Normal\",price:0}]){id}}';\r\ngql.Exec(gqlitem);\r\nvar qry = \"SELECT MenuItemPrices.MenuItemPortionId \";\r\n qry += \"FROM MenuItems INNER JOIN MenuItemPortions ON MenuItems.Id = MenuItemPortions.MenuItemId \";\r\n qry += \"INNER JOIN MenuItemPrices ON MenuItemPortions.Id = MenuItemPrices.MenuItemPortionId \"; \r\n qry += \"WHERE MenuItems.Name in ('\"+name+\"') AND MenuItemPortions.Name in ('Normal')\";\r\nvar id = sql.Query(qry).First;\r\nsql.ExecSql(\"UPDATE MenuItemPrices SET MenuItemPrices.Price = '\"+price+\"' WHERE MenuItemPrices.MenuItemPortionId = '\"+id+\"'\");\r\nvar mid = \"SELECT Id FROM MenuItems WHERE Name IN ('\"+name+\"')\";\r\nvar mid = sql.Query(mid).First;\r\nvar menu = sql.Query(\"SELECT CONVERT(nvarchar(50),Name)+'='+Convert(nvarchar(50),Id) FROM ScreenMenus\").Join(',');\r\nvar menu = dlg.AskQuestion('Ürünü Menüye Eklemek İçin Menüyü Seçin.',''+menu+',Menüye Ekleme=0:darkred;red','green','',0,'');\r\nif (menu>0){\r\nvar menuid = menu;\r\nvar menugroup = sql.Query(\"SELECT CONVERT(nvarchar(50),Name)+'='+Convert(nvarchar(50),Id) FROM ScreenMenuCategories WHERE ScreenMenuId = \"+menuid+\"\").Join(',');\r\nvar menugroup = dlg.AskQuestion('Kategori Seçiniz',''+menugroup+',Yeni Kategori=0:darkred;red','green','',0,'');\r\nif (menugroup>0){\r\nvar menugroupid = menugroup;\r\nvar scr = \"INSERT INTO ScreenMenuItems ([Name],[Header],[Appearance],[ScreenMenuCategoryId],[MenuItemId],[SortOrder],[AutoSelect],[ButtonColor],[Quantity],[ImagePath],[FontSize],[SubMenuTag],[ItemPortion],[OrderTags],[OrderStates],[AutomationCommand],[AutomationCommandValue],[DisablePortionSelection],[GroupTag])\";\r\n scr += \"VALUES ('\"+name+\"',NULL,0,\"+menugroupid+\",\"+mid+\",0,0,NULL,1,NULL,1,'',NULL,NULL,NULL,NULL,NULL,0,NULL)\";\r\nvar scr = sql.Query(scr).First;}else {\r\nvar newgroup = dlg.EditValue(\"Yeni Kategori;.{1,};;;OC\",\"\");\r\nvar newgroupqry = \"INSERT INTO ScreenMenuCategories ([Name],[Header],[Appearance],[SortOrder],[ScreenMenuId],[MostUsedItemsCategory],[ColumnCount],[MenuItemButtonHeight],[MenuItemButtonColor],[MenuItemFontSize],[WrapText],[PageCount],[SortAlphabetically],[MainButtonHeight],[MainButtonColor],[MainFontSize],[SubButtonHeight],[SubButtonRows],[SubButtonColorDef],[NumeratorType],[NumeratorValues],[AlphaButtonValues],[ImagePath],[NumberPadPercent],[MaxItems])\";\r\n newgroupqry += \"VALUES ('\"+newgroup+\"',NULL,0,0,\"+menuid+\",0,0,0,'Green',24,1,1,0,0,'Orange',26,75,1,'',2,NULL,NULL,NULL,45,0)\";\r\nvar newgroupqry = sql.Query(newgroupqry).First;\r\nvar menugroup = \"SELECT Id FROM ScreenMenuCategories WHERE Name in ('\"+newgroup+\"')\";\r\nvar menugroup = sql.Query(menugroup).First;\r\nvar menugroupid = menugroup;\r\nvar scr = \"INSERT INTO ScreenMenuItems ([Name],[Header],[Appearance],[ScreenMenuCategoryId],[MenuItemId],[SortOrder],[AutoSelect],[ButtonColor],[Quantity],[ImagePath],[FontSize],[SubMenuTag],[ItemPortion],[OrderTags],[OrderStates],[AutomationCommand],[AutomationCommandValue],[DisablePortionSelection],[GroupTag])\";\r\n scr += \"VALUES ('\"+name+\"',NULL,0,\"+menugroupid+\",\"+mid+\",0,0,NULL,1,NULL,1,'',NULL,NULL,NULL,NULL,NULL,0,NULL)\";\r\nvar scr = sql.Query(scr).First;}} else {}\r\ngql.Exec('mutation m {postTicketRefreshMessage(id:0) {id}}');\r\nreset = 'mutation m {postResetCacheMessage {id}}';\r\ngql.Exec(reset);\r\ncmd.Execute('Add Item - Menu:');\r\nreturn dlg.AskQuestion(' '+name+'\\rAdded Item','OK=OK:darkred;darkred','green','',2,'POSENTEGRA');\r\n}\r\n\r\n//############################################################################################\r\n\r\nfunction barcodeprice(){\r\nvar barcode = dlg.EditValue(\"Barkod;[0-9]{1,};;OCN;49,50,51|52,53,54|55,56,57|48,8,13\",\"\");\r\nvar q1 = \"SELECT COUNT(Name) FROM MenuItems WHERE Barcode IN ('\"+barcode+\"')\";\r\nvar nameCount = sql.Query(q1).First;\r\nif (nameCount==0 || barcode==null){return dlg.AskQuestion(' '+barcode+'\\r\\tBarkod Bulunamadı','OK=OK:lime;green','darkred','',2,'POSENTEGRA');}\r\nvar itemname = \"SELECT Name FROM MenuItems WHERE Barcode IN ('\"+barcode+\"')\";\r\nvar itemname = sql.Query(itemname).First;\r\nvar itemprice = \"SELECT MenuItemPrices.Price \";\r\n itemprice += \"FROM MenuItems INNER JOIN MenuItemPortions ON MenuItems.Id = MenuItemPortions.MenuItemId \";\r\n itemprice += \"INNER JOIN MenuItemPrices ON MenuItemPortions.Id = MenuItemPrices.MenuItemPortionId \"; \r\n itemprice += \"WHERE MenuItems.Name in ('\"+itemname+\"')\";\r\nvar itemprice = sql.Query(itemprice).First;\r\nvar itemprice = itemprice.replace(/,/g,'.')\r\nvar price = dlg.EditValue(\"Yeni Fiyatı;[0-9.]{1,};;ON;49,50,51|52,53,54|55,56,57|190,48,8\",\"\"+itemprice+\"\");\r\nvar qry = \"SELECT MenuItemPrices.MenuItemPortionId \";\r\n qry += \"FROM MenuItems INNER JOIN MenuItemPortions ON MenuItems.Id = MenuItemPortions.MenuItemId \";\r\n qry += \"INNER JOIN MenuItemPrices ON MenuItemPortions.Id = MenuItemPrices.MenuItemPortionId \"; \r\n qry += \"WHERE MenuItems.Name in ('\"+itemname+\"')\";\r\nvar id = sql.Query(qry).First;\r\nsql.ExecSql(\"UPDATE MenuItemPrices SET MenuItemPrices.Price = '\"+price+\"' WHERE MenuItemPrices.MenuItemPortionId = '\"+id+\"'\");\r\nreset = 'mutation m {postResetCacheMessage {id}}';\r\ngql.Exec(reset);\r\nreturn dlg.AskQuestion('İşlem Tamamlandı.','OK','#F6F6F6','',2,'POSENTEGRA');\r\nreset = 'mutation m {postResetCacheMessage {id}}';\r\ngql.Exec(reset);\r\n}\r\n//##############################################################################################\r\nfunction getData() {\r\nvar barcode = dlg.EditValue(\"Barcode;[0-9]{1,};;OCN;49,50,51|52,53,54|55,56,57|48,8,13\",\"\");\r\nvar q1 = \"SELECT COUNT(Name) FROM MenuItems WHERE Barcode IN ('\"+barcode+\"')\";\r\nvar nameCount = sql.Query(q1).First;\r\nif (nameCount==0 || barcode==null){return dlg.AskQuestion(' '+barcode+'\\r\\tThere Is No Such barcode','OK=OK:lime;green','darkred','',2,'POSENTEGRA');}\r\nvar name = \"SELECT Name FROM MenuItems WHERE Barcode IN ('\"+barcode+\"')\";\r\nvar name = sql.Query(name).First;\r\nvar start = sql.Query(\"SELECT TOP(1) FORMAT( StartDate, 'yyyy-MM-dd hh:mm:ss.fff') FROM WorkPeriods ORDER BY Id DESC\").First;\r\nvar end = sql.Query(\"SELECT FORMAT( GETDATE(), 'yyyy-MM-dd HH:mm:ss.fff')\").First;\r\nvar eksi = sql.Query(\"SELECT SUM(Quantity) FROM Orders WHERE MenuItemName IN ('\"+name+\"') AND [DecreaseInventory] > 0 AND [LastUpdateDateTime] > '\"+start+\"' AND [LastUpdateDateTime] < '\"+end+\"' \").First;\r\nvar devir = sql.Query(\"SELECT TOP(1) PhysicalInventory FROM PeriodicConsumptionItems WHERE InventoryItemName IN ('\"+name+\"') ORDER BY Id DESC\").First;\r\nvar kalan = parseInt(\"\"+devir+\"\") - parseInt(\"\"+eksi+\"\");\r\nvar qry = 'query q1 {products:getProducts(barcode:\"' + barcode + '\") {id,name,barcode,groupCode,price}}';\r\nvar respJson = gql.Exec(qry);\r\nvar respObj = JSON.parse(respJson);\r\nvar product = respObj.data.products[0];\r\nqry = 'query q1 { product:getProduct(id:' + product.id + ') { id,name,barcode,groupCode,price, portions{id,name,productId,price}, tags{name,value} } }';\r\nrespJson = gql.Exec(qry);\r\nrespObj = JSON.parse(respJson);\r\nproduct = respObj.data.product;\r\nvar productData = '';\r\nproductData += 'Ürün: ' + product.name+'';\r\nproductData += '
' + 'Fiyatı: ' + Helper.Format(product.price)+'';\r\nproductData += '
' + 'Porsiyonlar:';\r\nfor (var p=0; p ' + Helper.Format(product.portions[p].price)+'';\r\n}\r\nproductData += '
' + 'Tags : ';\r\nfor (var t=0; t ' + product.tags[t].value+'';\r\n}\r\nreturn dlg.AskQuestion(''+productData+'\\r
Kalan Stok : '+kalan+'','OK=OK:green;green','white','',0,'POSENTEGRA');\r\n} \r\n//#####################################################################################################\r\n\r\nfunction deleteitems(){\r\nvar barcode = dlg.EditValue(\"Barcode;[0-9]{1,};;OCN;49,50,51|52,53,54|55,56,57|48,8,13\",\"\");\r\nvar q1 = \"SELECT COUNT(Name) FROM MenuItems WHERE Barcode = '\"+barcode+\"'\";\r\nvar nameCount = sql.Query(q1).First;\r\nif (nameCount==0){return dlg.AskQuestion(' '+name+'\\r\\tÜrün Bulunamadı.','OK=OK:lime;green','darkred','',2,'POSENTEGRA');}\r\nvar name = sql.Query(\"SELECT Name FROM MenuItems WHERE Barcode = '\"+barcode+\"'\").First;\r\nsql.ExecSql(\"DELETE FROM ScreenMenuItems WHERE Name in ('\"+name+\"')\");\r\nsql.ExecSql(\"DELETE FROM MenuItems WHERE Name in ('\"+name+\"')\");\r\ngql.Exec('mutation m {postResetCacheMessage {id}}');\r\nreturn dlg.AskQuestion('İşlem Tamamlandı.','OK','white','',2,'POSENTEGRA');\r\n}\r\n\r\n//#####################################################################################################\r\n\r\nfunction changeprice(name,portion){\r\nvar ask = dlg.AskQuestion('Seçimi Yapınız','Fiyat Değişimi=1:purple;purple,İsim Değişimi=0:darkred;red,Kategori Değiştir=2:blue;blue,İptal=3:black;black','green','',0,'');\r\nif(ask==1){\r\nvar price = dlg.EditValue(\"Price;[0-9.]{1,};;ON;49,50,51|52,53,54|55,56,57|190,48,8\",\"\");\r\nvar id = sql.Query(\"SELECT MenuItemPrices.MenuItemPortionId FROM MenuItems INNER JOIN MenuItemPortions ON MenuItems.Id = MenuItemPortions.MenuItemId INNER JOIN MenuItemPrices ON MenuItemPortions.Id = MenuItemPrices.MenuItemPortionId WHERE MenuItems.Name in ('\"+name+\"') AND MenuItemPortions.Name in ('\"+portion+\"')\").First;\r\nsql.ExecSql(\"UPDATE MenuItemPrices SET MenuItemPrices.Price = '\"+price+\"' WHERE MenuItemPrices.MenuItemPortionId = '\"+id+\"'\");\r\ngql.Exec('mutation m {updateLocalSetting(name:\"ciprice\",value:\"'+price+'\"){name,value}}');\r\ngql.Exec('mutation m {postResetCacheMessage {id}}');\r\ngql.Exec('mutation m {postTicketRefreshMessage(id:0) {id}}');}\r\n\r\nif(ask==0){\r\nvar names = dlg.EditValue(\"Product Name;.{1,};;;OC\",\"\");\r\nvar nameCount = sql.Query(\"SELECT COUNT(Name) FROM MenuItems WHERE Name IN ('\"+names+\"')\").First;\r\nif (nameCount==1 || names==null){return dlg.AskQuestion('Ürün Var',' ','darkred','',2,'');}\r\nsql.ExecSql(\"UPDATE MenuItems SET Name = '\"+names+\"' WHERE Name = '\"+name+\"'\");\r\nsql.ExecSql(\"UPDATE ScreenMenuItems SET Name = '\"+names+\"' WHERE Name = '\"+name+\"'\");\r\ngql.Exec('mutation m {updateLocalSetting(name:\"ciname\",value:\"'+names+'\"){name,value}}');\r\ngql.Exec('mutation m {postTicketRefreshMessage(id:0) {id}}');\r\ngql.Exec('mutation m {postResetCacheMessage {id}}');\r\n}\r\n\r\nif(ask==2){\r\nvar kat = sql.Query(\"SELECT GroupCode FROM MenuItems WHERE Name = '\"+name+\"'\").First;\r\nvar kate = sql.Query(\"SELECT DISTINCT GroupCode FROM MenuItems\").Join(',');\r\nvar kategori = dlg.AskQuestion('Kategori Seçiniz',''+kate+',Kategori Aynı Kalsın=0:darkred;red','green','',0,''+kat+'');\r\nif(kategori!=='0'){sql.ExecSql(\"UPDATE MenuItems SET GroupCode = '\"+kategori+\"' WHERE Name = '\"+name+\"'\");}\r\nvar screen = sql.Query(\"SELECT CONCAT(Name,'=',Id) FROM ScreenMenuCategories\").Join(',');\r\nvar screenmenu = dlg.AskQuestion('Menü Ekran Kategori Seçiniz',''+screen+',Kategori Aynı Kalsın=0:darkred;red','green','',0,'');\r\nif(screenmenu!==0){sql.ExecSql(\"UPDATE ScreenMenuItems SET ScreenMenuCategoryId = \"+screenmenu+\" WHERE Name = '\"+name+\"'\");}\r\ngql.Exec('mutation m {postTicketRefreshMessage(id:0) {id}}');\r\ngql.Exec('mutation m {postResetCacheMessage {id}}');\r\n}\r\n\r\nif(ask==3){return 'Çıkış'}\r\n}\r\n\r\n\r\n//#####################################################################################################\r\n\r\n\r\nfunction ekle(barcode){\r\nvar sor = dlg.AskQuestion('Ürün Yok Eklemek İster misiniz?','Evet=1:green;green,Hayır=2:darkred;darkred','white','',0,'YILDIZHANPOS');\r\n if (sor==2) {return dlg.AskQuestion('İptal Edildi.',' ','darkred','',2,'YILDIZHANPOS');}\r\nvar q = \"SELECT COUNT(Barcode) FROM MenuItems WHERE Barcode = '\"+barcode+\"'\";\r\nvar barcodeCount = sql.Query(q).First;\r\nvar q = \"SELECT Name FROM MenuItems WHERE Barcode = '\"+barcode+\"'\";\r\nvar ürün= sql.Query(q).First;\r\nif (barcodeCount==1){return dlg.AskQuestion(' '+barcode+'\\r Barkod Kullanımda.\\r\\r Ürün Adı\\t '+ürün+'','OK=OK:lime;green','darkred','',2,'YILDIZHANPOS');}\r\nvar name = dlg.EditValue(\"Ürün Adı;.{1,};;;OC\",\"\");\r\nvar q1 = \"SELECT COUNT(Name) FROM MenuItems WHERE Name IN ('\"+name+\"')\";\r\nvar nameCount = sql.Query(q1).First;\r\nif (nameCount==1 || name==null){return dlg.AskQuestion('İptal Edildi.\\r\\r Ürün Yok','OK=OK:lime;green','darkred','',2,'YILDIZHANPOS');}\r\nvar categories = sql.Query(\"SELECT DISTINCT GroupCode From MenuItems\").Join('|');\r\nvar group = dlg.EditValue(\"Kategori;[A-Z][a-z]{1,100}\",\"\"+categories+\"\");\r\nvar price = dlg.EditValue(\"Fiyatı;[0-9.]{1,};;ON;49,50,51|52,53,54|55,56,57|190,48,8\",\"\");\r\ngql.Exec('mutation m{addProduct(name:\"'+name+'\",groupCode:\"'+group+'\",barcode:\"'+barcode+'\",portions:[{name:\"Normal\",price:0}]){id}}');\r\nvar qry = \"SELECT MenuItemPrices.MenuItemPortionId \";\r\n qry += \"FROM MenuItems INNER JOIN MenuItemPortions ON MenuItems.Id = MenuItemPortions.MenuItemId \";\r\n qry += \"INNER JOIN MenuItemPrices ON MenuItemPortions.Id = MenuItemPrices.MenuItemPortionId \"; \r\n qry += \"WHERE MenuItems.Barcode = '\"+barcode+\"'\";\r\nvar id = sql.Query(qry).First;\r\nsql.ExecSql(\"UPDATE MenuItemPrices SET MenuItemPrices.Price = '\"+price+\"' WHERE MenuItemPrices.MenuItemPortionId = '\"+id+\"'\");\r\n\r\nvar menugroupid = sql.Query(\"SELECT [Id] FROM [ScreenMenuCategories] WHERE Name IN ('\"+group+\"')\").First;\r\nvar mid = sql.Query(\"SELECT [Id] FROM [MenuItems] WHERE Name IN ('\"+name+\"')\").First;\r\n\r\nif (menugroupid==null) {var ilyas = 'ilyas'}\r\n\r\nif (menugroupid>0){var menugroupid = menugroupid \r\nvar scr = \"INSERT INTO ScreenMenuItems ([Name],[Header],[Appearance],[ScreenMenuCategoryId],[MenuItemId],[SortOrder],[AutoSelect],[ButtonColor],[Quantity],[ImagePath],[FontSize],[SubMenuTag],[ItemPortion],[OrderTags],[OrderStates],[AutomationCommand],[AutomationCommandValue],[DisablePortionSelection],[GroupTag])\";\r\n scr += \"VALUES ('\"+name+\"','$1
$2',0,\"+menugroupid+\",\"+mid+\",0,0,NULL,1,NULL,1,'',NULL,NULL,NULL,NULL,NULL,0,NULL)\";\r\nvar scr = sql.Query(scr).First;}\r\n\r\ngql.Exec('mutation m {postTicketRefreshMessage(id:0) {id}}');\r\ngql.Exec('mutation m1 {postResetCacheMessage {id}}');\r\ngql.Exec('mutation m2 {postResetProductCacheMessage {id}}');\r\nvar ask = dlg.AskQuestion('Stok Eklemek İster misiniz?','Evet=1:green;green,Hayır=2:darkred;darkred','white','',0,'YILDIZHANPOS');\r\nif(ask==1){\r\nvar qry = \"INSERT INTO [InventoryItems]\"; \r\n qry += \"([Barcode],[GroupCode],[WarehouseCode],[BaseUnit],[TransactionUnit],[TransactionUnitMultiplier],[Warehouse],[DefaultBaseUnitCost],[DefaultTransactionUnitCost],[ForeignCurrencyId],[CustomTags],[Name])\";\r\n qry += \"VALUES (\"+barcode+\",'\"+group+\"',NULL,'Normal',NULL,0,'Yerel Depo',0.00,0.00,0,NULL,'\"+name+\"')\";\r\n sql.ExecSql(qry)\r\nvar itemstockid = sql.Query(\"Select Id From InventoryItems Where Name IN ('\"+name+\"')\").First;\r\nvar portionid = sql.Query(\"SELECT MenuItemPortions.Id FROM MenuItems INNER JOIN MenuItemPortions ON MenuItems.Id = MenuItemPortions.MenuItemId WHERE MenuItems.Name IN ('\"+name+\"') AND MenuItemPortions.Name IN ('Normal')\").First;\r\nvar qty = dlg.EditValue(\"Stok Miktarı;.{1,};;OCN\",\"\");\r\nvar date = new Date().toLocaleDateString()\r\nvar date2 = sql.Query(\"SELECT FORMAT( GETDATE(), 'yyyy-MM-dd HH:mm:ss.fff')\").First;\r\nvar qry3 = \"INSERT INTO [InventoryTransactionDocuments]\"; \r\n qry3 += \"([Date],[InventoryDocumentTransactionTypeId],[TransactionAccountTransactionTypeId],[AccountTypeId],[AccountId],[Description],[ForeignCurrencyId],[Name],[AccountTransactionDocument_Id])\";\r\n qry3 += \"VALUES ('\"+date2+\"',0,0,0,0,NULL,0,'\"+date+\"',NULL)\";\r\n sql.ExecSql(qry3)\r\nvar indid = \"Select Id From InventoryTransactionDocuments Where Date = '\"+date2+\"'\";\r\nvar indid = sql.Query(indid).First;\r\nvar qry2 = \"INSERT INTO [InventoryTransactions]\"; \r\n qry2 += \"([InventoryTransactionDocumentId],[InventoryTransactionTypeId],[SourceWarehouseId],[TargetWarehouseId],[Date],[Unit],[Multiplier],[Quantity],[TotalPrice],[ExchangeRate],[InventoryItem_Id])\";\r\n qry2 += \"VALUES (\"+indid+\",1,0,1,'\"+date2+\"','Normal',1,\"+qty+\",0.00,1.0000000000,\"+itemstockid+\")\";\r\n sql.ExecSql(qry2)\r\n var qry4 = \"INSERT INTO [Recipes]\"; \r\n qry4 += \"([PortionId],[FixedCost],[GroupCode],[Name])\";\r\n qry4 += \"VALUES (\"+portionid+\",0.00,'\"+group+\"','\"+name+\" Reçetesi')\";\r\n sql.ExecSql(qry4)\r\nvar recipeid = sql.Query(\"Select Id From Recipes Where Name IN ('\"+name+\" Reçetesi')\").First;\r\nvar qry4 = \"INSERT INTO [RecipeItems]\"; \r\n qry4 += \"([RecipeId],[OrderTag],[Quantity],[ItemType],[InventoryItem_Id],[MenuItemPortion_Id])\";\r\n qry4 += \"VALUES (\"+recipeid+\",NULL,1.00,0,\"+itemstockid+\",NULL)\";\r\n sql.ExecSql(qry4) }\r\ngql.Exec('mutation m {postTicketRefreshMessage(id:0) {id}}');\r\ngql.Exec('mutation m1 {postResetCacheMessage {id}}');\r\ngql.Exec('mutation m2 {postResetProductCacheMessage {id}}');\r\ncmd.Execute('Ürün Yoksa Ekle - Menü Yenileme:');}\r\nfunction barkont(barcode) {return sql.Query(\"SELECT Barcode FROM MenuItems WHERE Barcode = '\"+barcode+\"'\").First;}\r\n\r\n\r\n\r\n//#####################################################################################################\r\n\r\n\r\n//#####################################################################################################SD\r\nfunction getOrderTag(product,portion,returnType,key) {var qs = '{getOrderTagGroups(productName:\"' + product + '\",portion:\"' + portion + '\"){name,min,max,tags{name}}}';\r\nvar data = JSON.parse(gql.Exec(qs));\r\n\r\ndata = data.data.getOrderTagGroups;\r\n\r\nkey = key.toLowerCase();\r\n\r\nfor (i = 0; i < data.length; i++)\r\n\r\n{ if (data[i].name.toLowerCase().indexOf(key) > -1) { if (returnType == 'name') { return data[i].name; } var tagList=[];\r\n\r\nfor (j = 0; j < data[i].tags.length; j++) { tagList.push(data[i].tags[j].name); } return tagList.toString(); } } return ''; }\r\n//#####################################################################################################SD\r\n\r\n\r\n//#####################################################################################################MS\r\nfunction musterisil(){\r\nvar gun = dlg.EditValue(\"Gün Sayısı Giriniz;.{1,};;OCN\",\"\")\r\nvar entityidc = \"SELECT COUNT(Entities.Id) FROM Entities JOIN EntityTypes ON Entities.EntityTypeId = EntityTypes.Id WHERE Entities.Id NOT IN (SELECT TicketEntities.EntityId FROM TicketEntities JOIN Tickets ON TicketEntities.Ticket_Id = Tickets.Id INNER JOIN EntityTypes ON EntityTypes.Id = TicketEntities.EntityTypeId WHERE Date > dateadd(DAY,-\"+gun+\",getdate()) AND Date < getdate() AND EntityTypes.Name IN ('Müşteriler') ) AND EntityTypes.Name IN ('Müşteriler')\";\r\nvar musteriidc = sql.Query(entityidc).Join(',')\r\n\r\nvar soru = dlg.AskQuestion(\" Girilen Gün Sayısı: \"+gun+\"
Silinecek Kişi Sayısı: \"+musteriidc+\"
Onaylıyor musunuz. ?\",\" ONAYLA =OK:green;green,Vazgeç=NO:darkred;darkred\",\"orange\",\"\",0,\"Onayladığınız taktirde \"+gun+\" gündür sipariş vermeyen \"+musteriidc+\" Kişi silinecek\");\r\nif (soru=='OK'){\r\n\r\nvar entityid = \"SELECT Entities.Id FROM Entities JOIN EntityTypes ON Entities.EntityTypeId = EntityTypes.Id WHERE Entities.Id NOT IN (SELECT TicketEntities.EntityId FROM TicketEntities JOIN Tickets ON TicketEntities.Ticket_Id = Tickets.Id INNER JOIN EntityTypes ON EntityTypes.Id = TicketEntities.EntityTypeId WHERE Date > dateadd(DAY,-\"+gun+\",getdate()) AND Date < getdate() AND EntityTypes.Name IN ('Müşteriler') ) AND EntityTypes.Name IN ('Müşteriler')\";\r\nvar musteriid = sql.Query(entityid).Join(',')\r\n\r\n if (musteriid!==''){sql.Exec(\"DELETE FROM Entities WHERE Id IN (\"+musteriid+\")\"); dlg.AskQuestion(\"\"+gun+\" Gündür sipariş vermeyen \"+musteriidc+\" Kişi Silindi\",\" \",\"green\",\"\",3)}\r\n if (musteriid==''){ dlg.AskQuestion(\"Müşteri Yok\",\" \",\"darkred\",\"\",2)}\r\n\r\n}\r\nif (soru=='NO'){return dlg.AskQuestion(\"İptal Edildi\",\" \",\"darkred\",\"\",2); }\r\n}\r\n\r\nfunction entsil(){\r\nvar gun = dlg.EditValue(\"Gün Sayısı Giriniz;.{1,};;OCN\",\"\")\r\nvar entityidc = \"SELECT COUNT(Entities.Id) FROM Entities JOIN EntityTypes ON Entities.EntityTypeId = EntityTypes.Id WHERE Entities.Id NOT IN (SELECT TicketEntities.EntityId FROM TicketEntities JOIN Tickets ON TicketEntities.Ticket_Id = Tickets.Id INNER JOIN EntityTypes ON EntityTypes.Id = TicketEntities.EntityTypeId WHERE Date > dateadd(DAY,-\"+gun+\",getdate()) AND Date < getdate() AND EntityTypes.Name IN ('Entegrasyon') ) AND EntityTypes.Name IN ('Entegrasyon')\";\r\nvar musteriidc = sql.Query(entityidc).Join(',')\r\n\r\nvar soru = dlg.AskQuestion(\" Girilen Gün Sayısı: \"+gun+\"
Silinecek Kişi Sayısı: \"+musteriidc+\"
Onaylıyor musunuz. ?\",\" ONAYLA =OK:green;green,Vazgeç=NO:darkred;darkred\",\"orange\",\"\",0,\"Onayladığınız taktirde \"+gun+\" gündür sipariş vermeyen \"+musteriidc+\" Kişi silinecek\");\r\nif (soru=='OK'){\r\n\r\nvar entityid = \"SELECT Entities.Id FROM Entities JOIN EntityTypes ON Entities.EntityTypeId = EntityTypes.Id WHERE Entities.Id NOT IN (SELECT TicketEntities.EntityId FROM TicketEntities JOIN Tickets ON TicketEntities.Ticket_Id = Tickets.Id INNER JOIN EntityTypes ON EntityTypes.Id = TicketEntities.EntityTypeId WHERE Date > dateadd(DAY,-\"+gun+\",getdate()) AND Date < getdate() AND EntityTypes.Name IN ('Entegrasyon') ) AND EntityTypes.Name IN ('Entegrasyon')\";\r\nvar musteriid = sql.Query(entityid).Join(',')\r\n\r\n if (musteriid!==''){sql.Exec(\"DELETE FROM Entities WHERE Id IN (\"+musteriid+\")\"); dlg.AskQuestion(\"\"+gun+\" Gündür sipariş vermeyen \"+musteriidc+\" Kişi Silindi\",\" \",\"green\",\"\",3)}\r\n if (musteriid==''){ dlg.AskQuestion(\"Müşteri Yok\",\" \",\"darkred\",\"\",2)}\r\n\r\n}\r\nif (soru=='NO'){return dlg.AskQuestion(\"İptal Edildi\",\" \",\"darkred\",\"\",2); }\r\n}\r\n\r\n\r\n//#####################################################################################################MS\r\n\r\n//#####################################################################################################BS\r\n\r\nfunction bildirimSil(user,time){\r\nvar bildirimler = \"SELECT COUNT(T.Id) FROM Tasks T INNER JOIN TaskTypes TT ON TT.Id=T.TaskTypeId WHERE TT.Name='BE' AND T.Completed=1 \";\r\nvar bildirimsay = sql.Query(bildirimler).Join(',');\r\nif (bildirimsay==0){return dlg.AskQuestion(\"Silinebilecek Bildirim Yok.\",\" \",\"darkred\",\"\",2); }\r\nvar soru = dlg.AskQuestion(\" Silinecek Bildirim Sayısı: \"+bildirimsay+\"
Onaylıyor musunuz. ?\",\" ONAYLA =OK:green;green,Vazgeç=NO:darkred;darkred\",\"orange\",\"\",0,\"Onayladığınız taktirde bugünkiler hariç \"+bildirimsay+\" bildirim silinecek!\");\r\nif (soru=='OK'){\r\n\r\nvar idler= sql.Query(\"SELECT T.Id FROM Tasks T INNER JOIN TaskTypes TT ON TT.Id=T.TaskTypeId WHERE TT.Name='BE' AND T.Completed=1 \").Join(',');\r\n\r\n\r\n if (idler!==''){\r\n sql.Exec(\"DELETE FROM Tasks WHERE Id IN (\"+idler+\")\"); dlg.AskQuestion(\"\"+bildirimsay+\" Adet Bildirim Silindi. Yöneticiye Silme gerçekleştiği bildirildi.\",\" \",\"green\",\"\",3);\r\n push('null','Bİldirimler Silindi - '+user+'','Geçmiş Bildirimler '+time+' da Silindi !','👀')\r\n }\r\n return 1\r\n if (idler==''){ dlg.AskQuestion(\"Silinebilecek Bildirim Yok\",\" \",\"darkred\",\"\",2)}\r\n\r\n}\r\nif (soru=='NO'){return dlg.AskQuestion(\"İptal Edildi\",\" \",\"darkred\",\"\",2); }\r\n}\r\n\r\n//#####################################################################################################BS\r\n\r\n\r\n\r\n//#####################################################################################################Menüde Fiyat Göster\r\n\r\nfunction mfg(){\r\nsql.Exec(\"UPDATE mi SET [Header]= '$1' + '
' + '$2' + N'' FROM [ScreenMenuItems] mi JOIN [MenuItems] pr on pr.[Id] = mi.[MenuItemId] JOIN [MenuItemPortions] po on po.[MenuItemId] = pr.[Id] and po.[Id]=(SELECT min(po2.[Id]) FROM [MenuItemPortions] po2 WHERE po2.[MenuItemId]=pr.[Id]) JOIN [MenuItemPrices] p on p.[MenuItemPortionId] = po.[Id]\");\r\ndlg.AskQuestion(\"Menüde Fiyatı Gösterme Güncellendi. Lüffen Çıkış yapıp tekrar giriniz.\",\"\",\"green\",\"\",2)}\r\n\r\n//#####################################################################################################Menüde Fiyat Göster\r\n\r\n//#####################################################################################################Adres\r\nfunction adres(isim){\r\nvar adres0\t=\tapi.Entity(''+isim+'').Data('Adres').Get().replace(':',' ').replace(/'/g,'.');\r\nvar adres1\t=\tapi.Entity(''+isim+'').Data('Adres 1').Get().replace(':',' ').replace(/'/g,'.');\r\nvar adres2\t=\tapi.Entity(''+isim+'').Data('Adres 2').Get().replace(':',' ').replace(/'/g,'.');\r\nvar soru\t=\tdlg.AskQuestion(\"Adres Seçiniz\",\"Adres\"+adres0+\"=\"+adres0+\":black;black,Adres 1\"+adres1+\"=\"+adres1+\":black;black,Adres 2\"+adres2+\"=\"+adres2+\":black;black,Adres Düzenle=0:black;black,Gel Al=1:black;black\",\"purple\");\r\nif(soru!=='0'){return soru}\r\nif(soru=='0') {\r\nvar sec\t\t=\tdlg.AskQuestion(\"Adres Seçiniz\",\"Adres\"+adres0+\"=Adres:black;black,Adres 1\"+adres1+\"=Adres 1:black;black,Adres 2\"+adres2+\"=Adres 2:black;black\",\"purple\");\r\nvar eski\t=\tapi.Entity(''+isim+'').Data(''+sec+'').Get();\r\nvar duzenle\t=\tdlg.EditValue(\"Adres Düzenle;;;;O\",\"\"+eski+\"\");\r\nif(duzenle!==null){\r\nvar soru\t=\tapi.Entity(''+isim+'').Data(''+sec+'').Update(''+duzenle+'');\r\nvar soru\t=\tapi.Entity(''+isim+'').Data(''+sec+'').Get();\r\nreturn soru}\r\nif(duzenle==null){return api.Entity(''+isim+'').Data(''+sec+'').Get();}}}\r\n//#####################################################################################################Adres\r\n\r\n\r\nfunction masadurum(masa){\r\nvar masaid\t= sql.Query(\"SELECT Id FROM Entities WHERE Name IN ('\"+masa+\"')\").First;\r\nvar sure\t= JSON.parse(sql.Query(\"SELECT EntityStates FROM EntityStateValues WHERE EntityId = \"+masaid+\"\").First.split('~'));\r\nfor(var i = 0; i < sure.length; i++) {if (sure[i].SN == 'Status') var r = sure[i].D;}\r\nvar sure\t= r.replace('/Date(','').replace(')/','')\r\nvar sure\t= sql.Query(\"SELECT DATEDIFF(MINUTE,DATEADD(S, CONVERT(int,LEFT(\"+sure+\", 10)), '1970-01-01 03:00:00'),GETDATE())\").First;\r\nvar tutar\t= sql.Query(\"SELECT TotalAmount FROM Tickets INNER JOIN TicketEntities ON Tickets.Id = TicketEntities.Ticket_Id WHERE IsClosed = 0 AND EntityName IN ('\"+masa+\"')\").First;\r\nvar user\t= sql.Query(\"SELECT Tickets.LastModifiedUserName FROM Tickets INNER JOIN TicketEntities ON Tickets.Id = TicketEntities.Ticket_Id WHERE IsClosed = 0 AND EntityName IN ('\"+masa+\"')\").First;\r\nvar baslik\t= \"\"+masa+\"\";\r\nvar zaman\t= \"🕒 \"+sure+\"\";\r\nvar toplam\t= \"\"+tutar+\"\";\r\nvar garson\t= \"🤵 \"+user+\"\";\r\nvar br\t\t= \"
\";\r\nvar tire\t= \" - \"\r\nreturn baslik+br+zaman+tire+toplam+br+garson\r\n}\r\n\r\n\r\n\r\n", "HandlerName": "pe", "Name": "ENT- Komutlar"}, {"Code": "function appCheck(appName){\r\nvar data = sql.Exists(\"SELECT [Name] FROM [GraphqlClients] WHERE [Name] = '\"+appName+\"'\");\r\nreturn data\r\n}\r\n\r\nfunction appCreate(appName){\r\nsql.ExecSql(\"INSERT INTO GraphqlClients (Identifier,Name,Secret,ApplicationType,Active,RefreshTokenLifeTime,AuthorizationType,AllowedOrigin) VALUES ('\"+appName+\"','\"+appName+\"','fYVj5JE0QG2EIco+UtsEeWiSyO53TMd2GjleU2xen0w=',2,1,5256000,0,'*')\");\r\n}\r\n\r\nfunction userRoleCheck(roleName){\r\nvar data = sql.Exists(\"SELECT [Name] FROM [UserRoles] WHERE [Name] = '\"+roleName+\"'\");\r\nreturn data\r\n}\r\n\r\nfunction userRoleCreate(roleName){\r\nsql.ExecSql(\"INSERT INTO UserRoles (Name,IsAdmin,DepartmentId) VALUES ('\"+roleName+\"',0,1)\");\r\n}\r\n\r\nfunction userCheck(userName){\r\nvar data = sql.Exists(\"SELECT [Name] FROM [Users] WHERE [Name] = '\"+userName+\"'\");\r\nreturn data\r\n}\r\n\r\nfunction sseCheck(){\r\nvar data = sql.Exec(\"SELECT COL_LENGTH('Users', 'SevenShiftsEmployeeId')\");\r\nreturn data[0]\r\n}\r\n\r\nfunction userCreateEntegrasyon(){\r\nsql.ExecSql(\"INSERT INTO Users (PinCode,Password,Name,UserRole_Id) VALUES ('73737373', '$SPHASH$V1$10000$zoQzhqSMPLMsYYxLm2y9Aw9/mrvGRYt6GuQTr+TfrlSt1sjq','Entegrasyon', IDENT_CURRENT( 'UserRoles' ))\");\r\n}\r\n\r\nfunction userCreateEntegrasyonSse(){\r\nsql.ExecSql(\"INSERT INTO Users (PinCode,Password,Name,UserRole_Id,SevenShiftsEmployeeId) VALUES ('73737373', '$SPHASH$V1$10000$zoQzhqSMPLMsYYxLm2y9Aw9/mrvGRYt6GuQTr+TfrlSt1sjq','Entegrasyon', IDENT_CURRENT( 'UserRoles' ),0)\");\r\n}\r\n\r\nfunction userCreate(userName){\r\nsql.ExecSql(\"INSERT INTO Users (Name,UserRole_Id) VALUES ('\"+userName+\"', IDENT_CURRENT( 'UserRoles' ))\");\r\n}\r\n\r\nfunction userCreateSse(userName){\r\nsql.ExecSql(\"INSERT INTO Users (Name,UserRole_Id,SevenShiftsEmployeeId) VALUES ('\"+userName+\"', IDENT_CURRENT( 'UserRoles' ), '0')\");\r\n}\r\n\r\nfunction userCreateBoss(){\r\nsql.ExecSql(\"INSERT INTO Users (Name,UserRole_Id) VALUES ('BossEntegra', '1'))\");\r\n}\r\n\r\nfunction userCreateBossSse(){\r\nsql.ExecSql(\"INSERT INTO Users (Name,UserRole_Id,SevenShiftsEmployeeId) VALUES ('BossEntegra','1', '0')\");\r\n}\r\n\r\nfunction userCreateYetkisiz(){\r\nsql.ExecSql(\"INSERT INTO Users (PinCode,Password,Name,UserRole_Id) VALUES ('0', '$SPHASH$V1$10000$zoQzhqSMPLMsYYxLm2y9Aw9/mrvGRYt6GuQTr+TfrlSt1sjq','Yetkisiz', IDENT_CURRENT( 'UserRoles' ))\");\r\n}\r\n\r\nfunction userCreateYetkisizSse(){\r\nsql.ExecSql(\"INSERT INTO Users (PinCode,Password,Name,UserRole_Id,SevenShiftsEmployeeId) VALUES ('0', '$SPHASH$V1$10000$zoQzhqSMPLMsYYxLm2y9Aw9/mrvGRYt6GuQTr+TfrlSt1sjq','Yetkisiz', IDENT_CURRENT( 'UserRoles' ),0)\");\r\n}\r\n\r\nfunction delRules(){\r\nsql.ExecSql(\"DELETE ARM FROM AppRuleMaps ARM INNER JOIN AppRules AR ON ARM.AppRuleId=AR.Id WHERE AR.Name ='ENT- Entegrasyon Kullanıcılarını Oluştur';DELETE S FROM Scripts S WHERE S.Name ='ENT- Sil';DELETE AR FROM AppRules AR WHERE AR.Name ='ENT- Entegrasyon Kullanıcılarını Oluştur';\");\r\n}\r\n\r\nfunction spver(){\r\nvar up = sql.Exec(\"SELECT TOP 1 [Version] From [VersionInfo] ORDER BY [Version] DESC\");\r\nreturn up[0];\r\n}\r\n\r\n\r\nfunction renkupdate(){\r\nvar getirupdate = gql.Exec('mutation m1 {updateGlobalSetting(name: \"#Getir Yemek\", value: \"#7158e2\"){value}}');\r\nvar ysupdate = gql.Exec('mutation m1 {updateGlobalSetting(name: \"#Yemek Sepeti\", value: \"#ff4d4d\"){value}}');\r\nvar tyupdate = gql.Exec('mutation m1 {updateGlobalSetting(name: \"#Trendyol Yemek\", value: \"#ffaf40\"){value}}');\r\nvar myupdate = gql.Exec('mutation m1 {updateGlobalSetting(name: \"#Migros Yemek\", value: \"#17c0eb\"){value}}');\r\nvar myupdate = gql.Exec('mutation m1 {updateGlobalSetting(name: \"#Telefon\", value: \"#ff446ea2\"){value}}');\r\n}\r\n\r\n\r\n\r\n\r\n", "HandlerName": "sil", "Name": "ENT- Sil"}], "States": null, "TaskTypes": null, "TicketTagGroups": null, "TicketTypes": null, "Triggers": [{"Expression": "0 */6 * * *", "Name": "ENT- Token"}]}