#
# ChangeLog for /trunk/SQL/Views
# 
# Generated by Trac 0.11.2.1
# 2026-04-15 00:07:26
 
Tue, 24 Feb 2009 13:29:34 GMT marek [392]
	* trunk/BazaReklam/Raporty/ReportsTree.xml (modified)
	* trunk/BazaReklam/app.config (modified)
	* trunk/RaportySQL/RaportySQL.rptproj (modified)
	* trunk/RaportySQL/WartoscProdukcjiWgTytulu.rdl (added)
	* trunk/SQL/Views/WartoscSprzedazy.txt (added)

	fixes #100


Thu, 19 Feb 2009 12:18:39 GMT marek [377]
	* trunk/BazaReklam/Raporty/ReportsTree.xml (modified)
	* trunk/RaportySQL/Klienci_IloscNaTytuly.rdl (copied)
	* trunk/RaportySQL/RaportySQL.rptproj (modified)
	* trunk/SQL/Views/FakturyNettoByTytul.txt (modified)

	fixes #95


Wed, 18 Feb 2009 11:28:54 GMT marek [371]
	* trunk/BazaReklam/ClientsForm.Designer.cs (modified)
	* trunk/BazaReklam/ClientsForm.cs (modified)
	* trunk/BazaReklam/ClientsForm.resx (modified)
	* trunk/BazaReklam/REKLAMADataSet.Designer.cs (modified)
	* trunk/BazaReklam/REKLAMADataSet.xsd (modified)
	* trunk/BazaReklam/REKLAMADataSet.xss (modified)
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_STARE.txt (modified)

	re #94 - poprawiono punkt 4 - wyswietlanie na czerowno gdy wysawiono
 ...


Wed, 18 Feb 2009 11:03:27 GMT marek [370]
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_STARE.txt (modified)

	re #94 - poprawiono punkt 5


Wed, 18 Feb 2009 10:29:37 GMT marek [368]
	* trunk/BazaReklam/ClientsForm.Designer.cs (modified)
	* trunk/BazaReklam/ClientsForm.cs (modified)
	* trunk/BazaReklam/ClientsForm.resx (modified)
	* trunk/BazaReklam/REKLAMADataSet.Designer.cs (modified)
	* trunk/BazaReklam/REKLAMADataSet.xsd (modified)
	* trunk/BazaReklam/REKLAMADataSet.xss (modified)
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_NOWE.txt (modified)
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_STARE.txt (modified)

	re #94 - poprawiono punkty 1, 3, 4


Tue, 17 Feb 2009 11:20:49 GMT marek [363]
	* trunk/RaportySQL/FakturyNettoWgTytulow.rdl (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl.data (modified)
	* trunk/SQL/Views/VIEW_RAPORT_ZMIAN_EMISJI.txt (modified)

	fixes #85


Mon, 16 Feb 2009 12:31:06 GMT marek [355]
	* trunk/BazaReklam/ReportsForm.cs (modified)
	* trunk/RaportySQL/RaportySQL.rptproj (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplatyWYR2009.rdl (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplatyWYR2009.rdl.data (modified)
	* trunk/RaportySQL/SprzedazReklamWYR.rdl.data (modified)
	* trunk/RaportySQL/SprzedazReklamWYR2009.rdl (modified)
	* trunk/RaportySQL/SprzedazReklamWYR2009.rdl.data (modified)
	* trunk/RaportySQL/adMotoRaportProwizja.rdl (modified)
	* trunk/RaportySQL/adMotoRaportWyroznienia.rdl (copied)
	* trunk/SQL/StoredProcedures/sp_adMotoRaportProwizja.txt (modified)
	* trunk/SQL/StoredProcedures/sp_adMotoRaportWyroznienia.txt (added)
	* trunk/SQL/Views/ReklamyWyroznienie.txt (modified)

	re #92


Mon, 16 Feb 2009 10:16:11 GMT marek [354]
	* trunk/RaportySQL/RaportySQL.rptproj (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl.data (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplatyWYR2009.rdl (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplatyWYR2009.rdl.data (modified)
	* trunk/RaportySQL/SprzedazReklamWYR2009.rdl (modified)
	* trunk/RaportySQL/SprzedazReklamWYR2009.rdl.data (modified)
	* trunk/SQL/Views/ReklamyWyroznienie.txt (added)
	* trunk/SQL/Views/WplywyByTytul.txt (modified)

	re #92 - poprawiono raporty dot. wyroznien reklamy


Fri, 13 Feb 2009 16:51:03 GMT marek [352]
	* trunk/BazaReklam/ReportsForm.cs (modified)
	* trunk/RaportySQL/RaportySQL.rptproj (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl.data (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplatyWYR2009.rdl (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplatyWYR2009.rdl.data (modified)
	* trunk/RaportySQL/adMotoRaportProwizja.rdl (added)
	* trunk/SQL/Reports/RozliczenieWplywowWgDatyWplaty2009.txt (modified)
	* trunk/SQL/Reports/adMotoSprzedazWplywy.txt (added)
	* trunk/SQL/StoredProcedures/sp_adMotoRaportProwizja.txt (added)
	* trunk/SQL/Views/FakturyWartoscWplaty.txt (added)
	* trunk/SQL/Views/WplywyByTytul.txt (modified)

	re #92


Thu, 12 Feb 2009 14:38:00 GMT marek [349]
	* trunk/BazaReklam/REKLAMADataSet.Designer.cs (modified)
	* trunk/BazaReklam/REKLAMADataSet.xsd (modified)
	* trunk/BazaReklam/REKLAMADataSet.xss (modified)
	* trunk/BazaReklam/ZamowieniaForm.Designer.cs (modified)
	* trunk/BazaReklam/ZamowieniaForm.resx (modified)
	* trunk/BazaReklam/ZestawienieZamowienForm.Designer.cs (modified)
	* trunk/BazaReklam/ZestawienieZamowienForm.cs (modified)
	* trunk/BazaReklam/ZestawienieZamowienForm.resx (modified)
	* trunk/SQL/Views/EmisjeReklamy.txt (added)

	fixes #25


Thu, 12 Feb 2009 12:37:27 GMT marek [348]
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_NOWE.txt (modified)

	fixes #20


Thu, 12 Feb 2009 10:44:48 GMT marek [345]
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl.data (modified)
	* trunk/SQL/Reports/RozliczenieWplywowWgDatyWplaty2009.txt (modified)
	* trunk/SQL/Views/WplywyByTytul.txt (added)

	re #85 - poprawiono raport RozliczenieWplywowWgDatyWplaty2009, dodano
 ...


Wed, 11 Feb 2009 14:28:40 GMT marek [336]
	* trunk/SQL/Views/FakturyNettoByTytul.txt (modified)

	fixes #86


Wed, 11 Feb 2009 13:33:19 GMT marek [334]
	* trunk/BazaReklam/ReportsForm.cs (modified)
	* trunk/RaportySQL/KlienciWgDatyReklamy.rdl (copied)
	* trunk/RaportySQL/RaportySQL.rptproj (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl.data (modified)
	* trunk/SQL/Views/FakturyNettoByTytul.txt (modified)

	re #86 - nowy raport KlienciWgDatyReklamy


Wed, 11 Feb 2009 11:50:31 GMT marek [333]
	* trunk/RaportySQL/FakturyNettoWgTytulow.rdl (added)
	* trunk/RaportySQL/RaportySQL.rptproj (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl (modified)
	* trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl.data (modified)
	* trunk/RaportySQL/WplywyWgWplaty.rdl (modified)
	* trunk/SQL/Reports/RozliczenieWplywowWgDatyWplaty2009.txt (modified)
	* trunk/SQL/Views/FakturyNettoByTytul.txt (added)

	re #85 - nowy raport FakturyNettoByTytul - Sprzedaz netto


Tue, 10 Feb 2009 16:35:38 GMT marek [331]
	* trunk/BazaReklam/FakturowaniePoznanKatowice.cs (modified)
	* trunk/BazaReklam/REKLAMADataSet.Designer.cs (modified)
	* trunk/BazaReklam/REKLAMADataSet.xsd (modified)
	* trunk/BazaReklam/REKLAMADataSet.xss (modified)
	* trunk/SQL/Views/FakturyPoznanKatowice.txt (modified)

	fixes #5 - poprawiono wystawianie faktur - aplikacja nie pozwala na
 ...


Mon, 09 Feb 2009 16:01:35 GMT marek [324]
	* trunk/RaportySQL/WplywyWgWplaty.rdl (modified)
	* trunk/SQL/Views/FakturyZaplacone.txt (modified)

	fixes #81


Mon, 09 Feb 2009 15:51:32 GMT marek [323]
	* trunk/SQL/Views/FakturyZaplacone.txt (modified)

	fixes #81


Mon, 09 Feb 2009 14:21:04 GMT marek [319]
	* trunk/RaportySQL/RaportySQL.rptproj (modified)
	* trunk/RaportySQL/WplywyWgWplaty.rdl (added)
	* trunk/SQL/Views/FakturyZaplacone.txt (added)

	re #81 - nowy raport WplywyWgWplaty plus nowy widok FakturyZaplacone


Tue, 03 Feb 2009 11:53:07 GMT marek [289]
	* trunk/SQL/Views/VIEW_KOREKTY.txt (modified)

	fixes #70 - poprawiono widok VIEW_KOREKTY


Tue, 03 Feb 2009 11:51:52 GMT marek [288]
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.txt (modified)
	* trunk/SQL/Views/ZAMOWIENIA_REKLAMY.txt (modified)

	fixes #19


Tue, 03 Feb 2009 10:19:10 GMT marek [287]
	* trunk/SQL/Views/VIEW_KOREKTY.txt (added)
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.txt (modified)
	* trunk/SQL/Views/ZAMOWIENIA_REKLAMY.txt (modified)

	re #19 - poprawiono wartosc niezafakturowana dla zamowien w walucie
	gdy ...


Mon, 02 Feb 2009 16:01:55 GMT marek [283]
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_NOWE.txt (modified)

	re #22 - poprawiono parametr 'niezaplacone', niestety nie dziala
 ...


Mon, 02 Feb 2009 15:57:27 GMT marek [282]
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.txt (modified)

	fixes #19 - poprawiono wartoscniezafakturowana dla zamowien w walucie


Mon, 02 Feb 2009 13:22:11 GMT marek [278]
	* trunk/SQL/Views/VIEW_RAPORT_ZMIAN_EMISJI.txt (modified)

	fixes #74


Mon, 02 Feb 2009 13:18:55 GMT marek [277]
	* trunk/SQL/Views/VIEW_RAPORT_ZMIAN_EMISJI.txt (modified)

	fixes #74


Mon, 02 Feb 2009 13:17:27 GMT marek [276]
	* trunk/SQL/Views/VIEW_RAPORT_ZMIAN_EMISJI.txt (added)

	re #74 - pierwotna wersja widoku VIEW_RAPORT_ZMIAN_EMISJI


Mon, 02 Feb 2009 12:17:23 GMT marek [275]
	* trunk/BazaReklam/FakturowaniePoznanKatowice.cs (modified)
	* trunk/BazaReklam/REKLAMADataSet.Designer.cs (modified)
	* trunk/BazaReklam/REKLAMADataSet.xsd (modified)
	* trunk/BazaReklam/REKLAMADataSet.xss (modified)
	* trunk/SQL/Views/FakturyPoznanKatowice.txt (modified)

	re #5 - poprawiono wystawianie faktury dla Poznania i Katowic, teraz
 ...


Fri, 30 Jan 2009 14:55:11 GMT marek [271]
	* trunk/SQL/Views/FakturyPoznanKatowice.txt (modified)

	re #5


Fri, 30 Jan 2009 14:47:31 GMT marek [270]
	* trunk/BazaReklam/Baza Reklam.csproj (modified)
	* trunk/BazaReklam/Classes/FakturaHelper.cs (added)
	* trunk/BazaReklam/Classes/VatHelper.cs (added)
	* trunk/BazaReklam/FakturowaniePoznanKatowice.Designer.cs (modified)
	* trunk/BazaReklam/FakturowaniePoznanKatowice.cs (modified)
	* trunk/BazaReklam/FakturowaniePoznanKatowice.resx (modified)
	* trunk/BazaReklam/REKLAMADataSet.Designer.cs (modified)
	* trunk/BazaReklam/REKLAMADataSet.xsd (modified)
	* trunk/BazaReklam/REKLAMADataSet.xss (modified)
	* trunk/RaportySQL/SzacowanieSprzedazy.rdl.data (modified)
	* trunk/SQL/Views/FakturyPoznanKatowice.txt (added)

	re #5 - dodano kolumne NrTygodnia (Tydz.) do okienka
 ...


Wed, 28 Jan 2009 16:28:37 GMT marek [262]
	* trunk/BazaReklam/FacturesForm.Designer.cs (modified)
	* trunk/BazaReklam/FacturesFormNEW.cs (modified)
	* trunk/BazaReklam/ZamowieniaForm.cs (modified)
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_NOWE.txt (modified)

	fixes #67 - wywalono zaokraglanie na poziomie tworzenia wierszy w
 ...


Wed, 28 Jan 2009 14:45:48 GMT marek [261]
	* trunk/BazaReklam/FacturesForm.Designer.cs (modified)
	* trunk/BazaReklam/FacturesForm.resx (modified)
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_STARE.txt (modified)

	re #7 - poprawiono wartosc brutto w widoku
 ...


Tue, 27 Jan 2009 16:06:42 GMT marek [254]
	* trunk/BazaReklam/ClientsForm.Designer.cs (modified)
	* trunk/BazaReklam/ClientsForm.resx (modified)
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_STARE.txt (modified)

	re #32 - poprawiono kolumne ZP w liscie faktur w szczegolach klienta


Tue, 27 Jan 2009 10:19:53 GMT marek [246]
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_NOWE.txt (modified)

	fixes #63 - poprawiono widok VIEW_ZESTAWIENIE_FAKTUR_NOWE


Mon, 26 Jan 2009 10:44:20 GMT marek [240]
	* trunk/SQL/Views/vDanePlatnosciEcard.txt (modified)

	re #60 - poprawiono widok vDanePlatnosciEcard


Mon, 26 Jan 2009 10:41:47 GMT marek [239]
	* trunk/SQL/Views/vDanePlatnosciEcard.txt (added)

	re #60 - pierwotna wersja widoki vDanePlatnosciEcard


Mon, 26 Jan 2009 09:02:07 GMT marek [237]
	* trunk/BazaReklam/Properties/AssemblyInfo.cs (modified)
	* trunk/BazaReklamSetup/BazaReklamSetup.vdproj (modified)
	* trunk/SQL/Views/view_ZESTAWIENIE_LISTA_FAKTUR_NOWA.txt (added)

	re #59


Thu, 22 Jan 2009 16:06:24 GMT marek [230]
	* trunk/BazaReklam/OrdersForm.Designer.cs (modified)
	* trunk/BazaReklam/OrdersForm.cs (modified)
	* trunk/BazaReklam/OrdersForm.resx (modified)
	* trunk/BazaReklam/PaymentForm2.cs (modified)
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_NOWE.txt (modified)
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.txt (modified)

	fixes #13 - poprawiono okno wplaty oraz walute_brutto dla korekty


Thu, 22 Jan 2009 10:58:59 GMT marek [228]
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_NOWE.txt (modified)
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_STARE.txt (added)

	re #13 - poprawiony widok VIEW_ZESTAWIENIE_FAKTUR_NOWE, dodany do svn
 ...


Wed, 21 Jan 2009 16:07:39 GMT marek [226]
	* trunk/BazaReklam/ZestawienieZamowienForm.Designer.cs (modified)
	* trunk/BazaReklam/ZestawienieZamowienForm.cs (modified)
	* trunk/BazaReklam/ZestawienieZamowienForm.resx (modified)
	* trunk/BazaReklam/app.config (modified)
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.txt (modified)

	fixes #19


Tue, 20 Jan 2009 15:42:18 GMT marek [217]
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_NOWE.txt (modified)

	re #22 - dodano nowa kolumne do widoku VIEW_ZESTAWIENIE_FAKTUR_NOWE


Tue, 20 Jan 2009 15:36:38 GMT marek [216]
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_NOWE.txt (added)
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.txt (moved)
	* trunk/SQL/Views/ZAMOWIENIA_REKLAMY.txt (moved)

	re #22 - backup istniejacych view's


Tue, 20 Jan 2009 15:18:30 GMT marek [215]
	* trunk/SQL/Views/ZAMOWIENIA_REKLAMY.sql (modified)

	re #22 - zmiana decyzji, nie dodajemy nowych parametrow do okna
 ...


Tue, 20 Jan 2009 15:04:19 GMT marek [214]
	* trunk/SQL/Views/VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.sql (added)
	* trunk/SQL/Views/ZAMOWIENIA_REKLAMY.sql (modified)

	re #22 - poprawiono ZAMOWIENIA_REKLAMY.sql oraz dodano
 ...


Tue, 20 Jan 2009 14:51:07 GMT marek [213]
	* trunk/SQL (added)
	* trunk/SQL/Views (added)
	* trunk/SQL/Views/ZAMOWIENIA_REKLAMY.sql (added)

	re #22 - dodano skrypt SQL do svn'a