# # ChangeLog for /trunk/SQL/Views # # Generated by Trac 0.11.2.1 # 2026-04-15 01:33:08 Thu, 02 Apr 2009 09:23:15 GMT marek [517] * trunk/BazaReklam/AddClient.Designer.cs (added) * trunk/BazaReklam/AddClient.cs (added) * trunk/BazaReklam/AddClient.resx (added) * trunk/BazaReklam/AgentAddForm.cs (modified) * trunk/BazaReklam/Baza Reklam.csproj (modified) * trunk/BazaReklam/Classes/Helpers (added) * trunk/BazaReklam/Classes/Helpers/ValidationHelper.cs (added) * trunk/BazaReklam/Classes/Utils.cs (modified) * trunk/BazaReklam/ClientsForm.Designer.cs (modified) * trunk/BazaReklam/ClientsForm.cs (modified) * trunk/BazaReklam/ClientsForm.resx (modified) * trunk/BazaReklam/Docs/versioninfo.html (modified) * trunk/BazaReklam/Properties/AssemblyInfo.cs (modified) * trunk/BazaReklam/Resources/businessman_preferences.png (added) * trunk/BazaReklam/app.config (modified) * trunk/BazaReklamSetup/BazaReklamSetup.vdproj (modified) * trunk/SQL/Views/WplywyByTytul.txt (modified) re #150 Mon, 30 Mar 2009 16:03:42 GMT marek [511] * trunk/SQL/Views/VIEW_PRODUKCJA_ZESTAWIE_DTP.txt (added) re #129 Wed, 25 Mar 2009 16:31:18 GMT marek [486] * trunk/SQL/StoredProcedures/proc_NowaPlatnoscEcard.txt (added) * trunk/SQL/Views/vDanePlatnosciEcard.txt (modified) * trunk/eCard/Expo/Default.aspx.cs (modified) * trunk/eCard/Expo/Global.asax (modified) * trunk/eCard/Expo/Merchant.aspx.cs (modified) * trunk/eCard/Expo/Web.Config (modified) * trunk/eCard/Expo/ecard/Web.config (modified) * trunk/eCard/Expo/login.aspx.cs (modified) * trunk/eCard/Expo/platnosc.aspx.cs (modified) * trunk/eCard/Expo/platnosci.4.1.resharper.user (modified) * trunk/eCard/Expo/platnosci.suo (modified) fixes #139 Mon, 23 Mar 2009 12:09:33 GMT marek [478] * trunk/SQL/Views/vDanePlatnosciEcard.txt (modified) re #139 Thu, 19 Mar 2009 15:26:26 GMT marek [474] * trunk/BazaReklam/app.config (modified) * trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_STARE.txt (modified) fixes #131 Thu, 19 Mar 2009 12:20:33 GMT marek [466] * trunk/BazaReklam/Raporty/ReportsTree.xml (modified) * trunk/RaportySQL/RozliczenieProwizjiZaReklame2009.rdl (modified) * trunk/RaportySQL/RozliczenieProwizjiZaReklame2009.rdl.data (modified) * trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl (modified) * trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl.data (modified) * trunk/RaportySQL/SprzedazReklam2009.rdl (modified) * trunk/RaportySQL/SprzedazReklam2009.rdl.data (modified) * trunk/RaportySQL/WykonanieBudzetu2.rdl.data (modified) * trunk/RaportySQL/Zaleglosci2009.rdl (modified) * trunk/RaportySQL/Zaleglosci2009.rdl.data (modified) * trunk/RaportySQL/ZestawienieKorekt.rdl (modified) * trunk/RaportySQL/ZestawienieKorekt.rdl.data (modified) * trunk/RaportySQL/ZestawienieMiesieczneFaktur2009.rdl (modified) * trunk/RaportySQL/ZestawienieMiesieczneFaktur2009.rdl.data (modified) * trunk/SQL/Reports/Zaleglosci2009.txt (added) * trunk/SQL/Views/VIEW_KOREKTY.txt (modified) * trunk/SQL/Views/WplywyByTytul.txt (modified) * trunk/SQL/Views/view_ZESTAWIENIE_LISTA_FAKTUR_NOWA.txt (modified) re #129 Fri, 13 Mar 2009 14:40:37 GMT marek [443] * trunk/SQL/Views/VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.txt (modified) re #75 - problem z widowkiem zamowien Tue, 10 Mar 2009 09:54:33 GMT marek [421] * trunk/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt (modified) fixes #114 Tue, 10 Mar 2009 09:51:37 GMT marek [420] * trunk/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt (added) re #114 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