Core.NETCore.BI-Examples - Historie editací

Zavadil v 11. 8. 2017, 09:53

2017-08-11T09:53:54Z

← Starší verze		Verze z 11. 8. 2017, 09:53
Řádek 1:		Řádek 1:
			=== Enumerations ===
			<syntaxhighlight lang="vb">
			Public Enum TurnoverTypes
			<TDescription("Zboží podle výdeje")>
			GoodsByIssue = 1
			<TDescription("Zboží podle prodeje")>
			GoodsBySale = 2
			<TDescription("Služby")>
			Services = 10
			End Enum
			</syntaxhighlight><syntaxhighlight lang="vb">
			Public Enum TurnoverSalessmannType
			<TDescription("Podle fakturační adresy")>
			ByInvoiceAddress = 0
			<TDescription("Podle dodací adresy")>
			ByDeliveryAddress = 2
			End Enum
			</syntaxhighlight>

	=== Calculate purchase turnover for suppliers (for months) ===		=== Calculate purchase turnover for suppliers (for months) ===
	<syntaxhighlight lang="vb">		<syntaxhighlight lang="vb">

Zavadil v 11. 8. 2017, 09:52

2017-08-11T09:52:27Z

← Starší verze		Verze z 11. 8. 2017, 09:52
Řádek 77:		Řádek 77:

	=== Calculate company turnover trend (last 12 months) ===		=== Calculate company turnover trend (last 12 months) ===
			<syntaxhighlight lang="vb">

			Dim Result As Core.NETCore.BI.CompanyBussinesInfo.TurnoverInfo

			For Month As Integer = 0 To 11

			'Calculate date
			Dim Dt As Date = DateSerial(Now.Year, Now.Month, 1).AddMonths((11 * -1) + Month)

			'Calculate month turnover for goods
			Dim MonthGoods As New Core.NETCore.BI.CompanyBussinesInfo(Dt.Year, Dt.Month, Core.NETCore.BI.CompanyBussinesInfo.TurnoverTypes.GoodsByIssue)
			Result = MonthGoods.TotalTurnover

			'XXXXXXXXXXXXXXXXXXXXXXXXXXXX
			'Place your code to show data, stored in [Result]
			'XXXXXXXXXXXXXXXXXXXXXXXXXXXX

			'Calculate month turnover for non-goods
			Dim MonthServices As New Core.NETCore.BI.CompanyBussinesInfo(Dt.Year, Dt.Month, Core.NETCore.BI.CompanyBussinesInfo.TurnoverTypes.Services)
			Result = MonthServices.TotalTurnover

			'XXXXXXXXXXXXXXXXXXXXXXXXXXXX
			'Place your code to show data, stored in [Result]
			'XXXXXXXXXXXXXXXXXXXXXXXXXXXX
			Next
			</syntaxhighlight>

	=== Calculate company debts overview (splitted by branch) ===		=== Calculate company debts overview (splitted by branch) ===

Zavadil: Zavadil přesunul stránku Examples na Core.NETCore.BI-Examples

2017-08-11T09:33:40Z

Zavadil přesunul stránku Examples na Core.NETCore.BI-Examples

← Starší verze	Verze z 11. 8. 2017, 09:33
(Žádný rozdíl)

Zavadil v 11. 8. 2017, 09:31

2017-08-11T09:31:05Z

← Starší verze		Verze z 11. 8. 2017, 09:31
Řádek 76:		Řádek 76:
	</syntaxhighlight>		</syntaxhighlight>

	=== ~~Company~~ turnover trend (last 12 months) ===		=== Calculate company turnover trend (last 12 months) ===

	=== ~~Company~~ debts overview (splitted by branch) ===		=== Calculate company debts overview (splitted by branch) ===

Zavadil v 11. 8. 2017, 09:30

2017-08-11T09:30:38Z

← Starší verze		Verze z 11. 8. 2017, 09:30
Řádek 77:		Řádek 77:

	=== Company turnover trend (last 12 months) ===		=== Company turnover trend (last 12 months) ===

			=== Company debts overview (splitted by branch) ===

Zavadil v 11. 8. 2017, 09:29

2017-08-11T09:29:41Z

← Starší verze		Verze z 11. 8. 2017, 09:29
Řádek 75:		Řádek 75:
	Next		Next
	</syntaxhighlight>		</syntaxhighlight>

			=== Company turnover trend (last 12 months) ===

Zavadil v 11. 8. 2017, 09:15

2017-08-11T09:15:07Z

@@ Řádek 14: / Řádek 14: @@
              '2. Declare collection with supplier turnover info
-             Dim Results As System.Collections.Generic.SortedList(Of Integer, Core.NETCore.BI.CompanyBussinesInfo.SupplierTurnoverInfo)
+             Dim Result As System.Collections.Generic.SortedList(Of Integer, Core.NETCore.BI.CompanyBussinesInfo.SupplierTurnoverInfo)
              '3. Calculate supplier turnover info using base BI class (step 1.)
-             '   FilteredInSuppliers (coma delimited string with ID's of suppliers.Example: "1,5688,45")
+             '   FilteredInSuppliers (coma delimited string with ID's of suppliers. Example: "1,5688,45")
-             '   FilteredOutSuppliers (coma delimited string with ID's of suppliers.Example: "1,5688,45")
+             '   FilteredOutSuppliers (coma delimited string with ID's of suupliers. Example: "1,5688,45")
-             Results = MonthInfo.SupplierTurnover("", "")
+             Result = MonthInfo.SupplierTurnover("", "")
              '4. Browse and show data for each supplier info in specified month
-             For Each Item As Core.NETCore.BI.CompanyBussinesInfo.SupplierTurnoverInfo In Results.Values
+             For Each Item As Core.NETCore.BI.CompanyBussinesInfo.SupplierTurnoverInfo In Result.Values
                  'XXXXXXXXXXXXXXXXXXXXXXXXXXXX
                  'Place your code to show data, stored in [Item]
                  'XXXXXXXXXXXXXXXXXXXXXXXXXXXX
              Next
          Next
 </syntaxhighlight>

Zavadil v 11. 8. 2017, 08:52

2017-08-11T08:52:43Z

← Starší verze		Verze z 11. 8. 2017, 08:52
Řádek 1:		Řádek 1:
	=== Calculate purchase turnover for suppliers ===		=== Calculate purchase turnover for suppliers (for months) ===
	<syntaxhighlight lang="vb">		<syntaxhighlight lang="vb">
	'Total moth count to calculate turnover		'Total moth count to calculate turnover

Zavadil v 11. 8. 2017, 08:51

2017-08-11T08:51:47Z

← Starší verze		Verze z 11. 8. 2017, 08:51
Řádek 17:		Řádek 17:

	'3. Calculate supplier turnover info using base BI class (step 1.)		'3. Calculate supplier turnover info using base BI class (step 1.)
	' FilteredInSuppliers (coma delimited string with ID's of ~~suupliers~~ Example "1,5688,45")		' FilteredInSuppliers (coma delimited string with ID's of suppliers.Example: "1,5688,45")
	' FilteredOutSuppliers (coma delimited string with ID's of ~~suupliers~~ Example "1,5688,45")		' FilteredOutSuppliers (coma delimited string with ID's of suppliers.Example: "1,5688,45")
	Results = MonthInfo.SupplierTurnover("", "")		Results = MonthInfo.SupplierTurnover("", "")

Zavadil v 11. 8. 2017, 08:51

2017-08-11T08:51:12Z

← Starší verze		Verze z 11. 8. 2017, 08:51
Řádek 14:		Řádek 14:

	'2. Declare collection with supplier turnover info		'2. Declare collection with supplier turnover info
	Dim Ti As System.Collections.Generic.SortedList(Of Integer, Core.NETCore.BI.CompanyBussinesInfo.SupplierTurnoverInfo)		Dim Results As System.Collections.Generic.SortedList(Of Integer, Core.NETCore.BI.CompanyBussinesInfo.SupplierTurnoverInfo)

	'3. Calculate supplier turnover info using base BI class (step 1.)		'3. Calculate supplier turnover info using base BI class (step 1.)
	' FilteredInSuppliers (coma delimited string with ID's of suupliers Example "1,5688,45")		' FilteredInSuppliers (coma delimited string with ID's of suupliers Example "1,5688,45")
	' FilteredOutSuppliers (coma delimited string with ID's of suupliers Example "1,5688,45")		' FilteredOutSuppliers (coma delimited string with ID's of suupliers Example "1,5688,45")
	Ti = MonthInfo.SupplierTurnover("", "")		Results = MonthInfo.SupplierTurnover("", "")

	'4. Browse and show data for each supplier info in specified month		'4. Browse and show data for each supplier info in specified month
	For Each Item As Core.NETCore.BI.CompanyBussinesInfo.SupplierTurnoverInfo In Ti.Values		For Each Item As Core.NETCore.BI.CompanyBussinesInfo.SupplierTurnoverInfo In Results.Values
	'XXXXXXXXXXXXXXXXXXXXXXXXXXXX		'XXXXXXXXXXXXXXXXXXXXXXXXXXXX
	'Place your code to show data, stored in [Item]		'Place your code to show data, stored in [Item]