##########################################################################################

       VEH-21: Service Stats Generation

##########################################################################################


Issue Type: Sub-task 
-----------------------------------------------------------------------------------------

Issue Information
====================

Priority: Major					Status:      Closed
Resolution:  Done (2013-11-02 16:35:59)
Project: VehMan (VEH)


Reported By: btasker					
Assigned To: btasker
Child of: VEH-17 - Stats Submodule  


Components: 
	- Servicing 
	- Statistics 


Targeted for fix in version: 
	- 1.0.2


Time Estimate: 0 minutes
Time Logged:   0 minutes


-----------------------------------------------------------------------------------------

Issue Description
==================

Need to create a class similar to that in VEH-19 to generate Statistics based on
Servicing

Desired stats are


- Total Mileage recorded
- Total Servicing Cost
- Number of Services/repairs
- Total 'fault' cost
- Total 'non-fault' cost
- Number of fault repairs
- Number of non-fault repairs
- Garage stats



-----------------------------------------------------------------------------------------

Issue Relations
================
	
	- blocks VEH-17: Stats Submodule
	- blocks VEH-18: Driver mileage chart
	- relates to VEH-31: Convert CPM Charts to use stats table


-----------------------------------------------------------------------------------------

Activity
==========

	
-----------------------------------------------------------------------------------------
2013-11-02 14:32:12              
-----------------------------------------------------------------------------------------

btasker changed status from 'Open' to 'In Progress'
	
-----------------------------------------------------------------------------------------
2013-11-02 14:43:14              btasker
-----------------------------------------------------------------------------------------

Add to the list of stats

- Average Cost Per Mile (Servicing)
- Average CPM Fault (Servicing)
- Average CPM Non-Fault (Servicing)
- Average Service Cost
- Average Service Cost (fault)
- Average Service Cost (non-fault)


	
-----------------------------------------------------------------------------------------
2013-11-02 16:24:02              btasker
-----------------------------------------------------------------------------------------

Created the following stats

All stats have datasource 'S'


|StatType|Stat|Modifier|
|MonMiles|Miles recorded||
|MonCn|Service count||
|MonCost|Servicing Cost||
|MonFaultCo|Servicing Cost (Faults)||
|MonNFaultC|Servicing Cost (Non Faults)||
|MonFaultCn|Servicing Count (Faults)||
|MnNFaultCn|Servicing Count (Non Faults)||
|MonAvgCPM|Average Cost Per Mile||
|MonAvgFCPM|Average Cost Per Mile (Faults)||
|MonAvgNFCP|Average Cost Per Mile (Non Faults)||
|MonAvgCost|Average Servicing Cost||
|MonAvgFCs|Average Servicing Cost (Faults)||
|MonAvgNFCs|Average Servicing Cost (Non Faults)||
|MonGarages|Garage Use Count|Garage Name|

To make life easier when running queries that use Fuel and Servicing, have decided to
standardise the Stat-Type between Fuellog and Servicelog stats, so will be altering the
stat types listed in VEH-19 to match those used above





	
-----------------------------------------------------------------------------------------
2013-11-02 16:35:52              
-----------------------------------------------------------------------------------------

btasker changed status from 'In Progress' to 'Open'
	
-----------------------------------------------------------------------------------------
2013-11-02 16:35:59              
-----------------------------------------------------------------------------------------

btasker changed status from 'Open' to 'Resolved'
	
-----------------------------------------------------------------------------------------
2013-11-02 16:35:59              
-----------------------------------------------------------------------------------------

btasker added 'Done' to resolution
	
-----------------------------------------------------------------------------------------
2013-11-02 16:36:05              
-----------------------------------------------------------------------------------------

btasker changed status from 'Resolved' to 'Closed'