Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass -Force

Set-ExecutionPolicy -Scope LocalMachine -ExecutionPolicy RemoteSigned -Force

cd C:\fiscalPOS\POS-Sync
.\install-service.ps1 -ExecutablePath 'C:\fiscalPOS\POS-Sync\PosSync.Sender.exe'




Start-Service PosSyncSender
Get-Service PosSyncSender


Stop-Service PosSyncSender

cd C:\fiscalPOS\POS-Sync
.\PosSync.Sender.exe --once --retry-blocked

Start-Service PosSyncSender

--provjera
Get-ChildItem 'C:\ProgramData\PosSync\queue' -Filter '*.json' -File |
    Where-Object { $_.Name -notlike '.*' } |
    ForEach-Object {
        Get-Content -LiteralPath $_.FullName -Raw | ConvertFrom-Json
    } |
    Select-Object SourceKey, State, Error |
    Format-Table -AutoSize





Restart-Service PosSyncSender



cd C:\fiscalPOS\POS-Sync-CSharp-Windows-x64-v1.1
.\PosSync.Sender.exe --once --retry-blocked
Start-Service PosSyncSender


***********************************************************
Stop-Service PosSyncSender

Pregled racuna za period
cd C:\fiscalPOS\POS-Sync
.\POS-Sync-Ponovi-Od-Datuma.ps1 -DatumOd '2026-10-01' -DatumDo '2026-11-06'


Ponovno slanje
cd C:\fiscalPOS\POS-Sync
.\POS-Sync-Ponovi-Od-Datuma.ps1 -DatumOd '2026-10-01' -DatumDo '2026-11-06' -Primijeni
.\PosSync.Sender.exe --once


Start-Service PosSyncSender
***********************************************************


--SQL

SET NOCOUNT ON;
SET XACT_ABORT ON;
SET LOCK_TIMEOUT 15000;

IF DB_NAME() <> N'tacka'
    THROW 51000, 'Pogresna baza. Skripta je samo za tacka.', 1;

IF OBJECT_ID(N'dbo.tHE_Move', N'U') IS NULL
   OR OBJECT_ID(N'dbo.tHE_MoveItem', N'U') IS NULL
    THROW 51001, 'Nisu pronadjene Pantheon tabele dbo.tHE_Move i dbo.tHE_MoveItem.', 1;

BEGIN TRY
    BEGIN TRANSACTION;

    DECLARE @lockResult int;
    EXEC @lockResult = sys.sp_getapplock
        @Resource = N'POSSync:add-five-columns-v1',
        @LockMode = N'Exclusive',
        @LockOwner = N'Transaction',
        @LockTimeout = 15000;
    IF @lockResult < 0
        THROW 51002, 'Nije dobijena blokada za promjenu strukture. Pokusajte kasnije.', 1;

    -- Ako kolona vec postoji, zahtijevamo odgovarajuci SQL tip i duzinu.
    IF EXISTS (
        SELECT 1
        FROM (VALUES
            (N'tHE_Move', N'acDoNotFiscalise', N'char', 1),
            (N'tHE_Move', N'acPayMethodOld', N'varchar', 3),
            (N'tHE_MoveItem', N'anIdentQId', N'int', 4),
            (N'tHE_MoveItem', N'anDeptQId', N'int', 4),
            (N'tHE_MoveItem', N'anCostDrvQId', N'int', 4)
        ) AS expected(table_name, column_name, type_name, max_length)
        INNER JOIN sys.tables AS t
            ON t.name = expected.table_name AND t.schema_id = SCHEMA_ID(N'dbo')
        INNER JOIN sys.columns AS c
            ON c.object_id = t.object_id AND c.name = expected.column_name
        WHERE c.system_type_id <> TYPE_ID(expected.type_name)
           OR c.max_length <> expected.max_length
           OR c.is_computed = 1
           OR c.is_identity = 1
    )
        THROW 51003, 'Postojeca kolona ima neocekivan tip/duzinu. Nista nije promijenjeno.', 1;

    IF COL_LENGTH(N'dbo.tHE_Move', N'acDoNotFiscalise') IS NULL
        ALTER TABLE dbo.tHE_Move ADD acDoNotFiscalise char(1) NULL;

    IF COL_LENGTH(N'dbo.tHE_Move', N'acPayMethodOld') IS NULL
        ALTER TABLE dbo.tHE_Move ADD acPayMethodOld varchar(3) NULL;

    IF COL_LENGTH(N'dbo.tHE_MoveItem', N'anIdentQId') IS NULL
        ALTER TABLE dbo.tHE_MoveItem ADD anIdentQId int NULL;

    IF COL_LENGTH(N'dbo.tHE_MoveItem', N'anDeptQId') IS NULL
        ALTER TABLE dbo.tHE_MoveItem ADD anDeptQId int NULL;

    IF COL_LENGTH(N'dbo.tHE_MoveItem', N'anCostDrvQId') IS NULL
        ALTER TABLE dbo.tHE_MoveItem ADD anCostDrvQId int NULL;

    COMMIT TRANSACTION;
END TRY
BEGIN CATCH
    IF XACT_STATE() <> 0 ROLLBACK TRANSACTION;
    THROW;
END CATCH;

SELECT
    SERVERPROPERTY(N'ServerName') AS sql_server,
    DB_NAME() AS database_name,
    t.name AS table_name,
    c.name AS column_name,
    TYPE_NAME(c.user_type_id) AS sql_type,
    c.max_length,
    c.is_nullable
FROM sys.tables AS t
INNER JOIN sys.columns AS c ON c.object_id = t.object_id
WHERE t.schema_id = SCHEMA_ID(N'dbo')
  AND (
      (t.name = N'tHE_Move' AND c.name IN (N'acDoNotFiscalise', N'acPayMethodOld'))
      OR
      (t.name = N'tHE_MoveItem' AND c.name IN (N'anIdentQId', N'anDeptQId', N'anCostDrvQId'))
  )
ORDER BY t.name, c.name;


PP Tip Subjekta u Pantheonu treba ddoati