-- Insert data into Firma table
INSERT INTO Firma (Naziv, Adresa, Broj) VALUES
('Company A', 'Address 1', '123-456'),
('Company B', 'Address 2', '789-012'),
('Company C', 'Address 3', '345-678');

-- Insert data into Artikl table
INSERT INTO Artikl (Naziv, Cena, EdMera, Stapka) VALUES
('Product A', 100.50, 'pcs', 18.00),
('Product B', 250.75, 'kg', 20.00),
('Product C', 75.99, 'ltr', 15.00);

-- Insert data into Naracka table
INSERT INTO Naracka (FirmaID, Datum, Opis) VALUES
(1, '2024-01-15', 'Order for product A'),
(2, '2024-02-20', 'Order for product B'),
(3, '2024-03-25', 'Order for product C');

-- Insert data into Faktura table
INSERT INTO Faktura (FirmaID, Datum, Iznos, DDV) VALUES
(1, '2024-01-16', 118.59, 18.00),
(2, '2024-02-21', 300.90, 20.00),
(3, '2024-03-26', 87.59, 15.00);

-- Insert data into Zaliha table
INSERT INTO Zaliha (ArtiklID, ArtiklNaziv, Kolicina) VALUES
(1, 'Product A', 50),
(2, 'Product B', 100),
(3, 'Product C', 200);

-- Insert data into Naracka_Artikl table
INSERT INTO Naracka_Artikl (NarackaID, ArtiklID, Kolicina, Cena) VALUES
(1, 1, 10, 100.50),
(2, 2, 20, 250.75),
(3, 3, 30, 75.99);

-- Insert data into IzrabotkaPlan table
INSERT INTO IzrabotkaPlan (DatumStart, DatumEnd, DatumPlan) VALUES
('2024-01-01', '2024-01-15', '2024-01-10'),
('2024-02-01', '2024-02-20', '2024-02-15'),
('2024-03-01', '2024-03-25', '2024-03-20');

-- Insert data into Naracka_IzrabotkaPlan table
INSERT INTO Naracka_IzrabotkaPlan (NarackaID, IzrabotkaPlanID) VALUES
(1, 1),
(2, 2),
(3, 3);
