# Path: core/validation/validation.py
# class TSValidationError(Exception):
#     pass
# 
# def validate_request(collection, json_in):
#     validator(requests_schema[collection], format_checker=jsonschema.FormatChecker()).validate(json_in)
# 
# def update_password_salt_user_list(collection, list_in):
#     
#     if collection == 'user':
#         for json_in in list_in:
#             update_password_salt_user_json(json_in)
#         
#     return list_in
# 
# def validate_json_list(collection, list_in):
#     
#     for json_in in list_in:    
#         # Validate json schema
#         validator(schema[collection], format_checker=jsonschema.FormatChecker()).validate(json_in)
# 
# def sanitize_objectify_json(json_in):
#     """Sanitize string and convert _ids to ObjectId in JSON"""
#     return recursive_replace(json_in, _replace_function_sanitize_objectify_json)
# 
# def stringify_objectid_cursor(cursor_in):
#     """Convert ObjectId to string in JSON"""
#     
#     stringified = []
#     for json_in in cursor_in:
#         stringified.append(recursive_replace(json_in, _replace_function_stringify_objectid_json))
#     return stringified
# 
# def stringify_objectid_list(list_in):
#     """Convert an ObjectId list to string list"""
#     return recursive_replace(list_in, _replace_function_stringify_objectid_list)
# 
# Path: core/validation/permissions.py
# def check_datamine_permissions(action, document):
#     # Get datamine permissions
#     
#     try:
#         restrictions = cherrypy.session['_ts_user']['restrictions'][action]
#     except (KeyError, TypeError):
#         restrictions = None
#         
#     if not restrictions:
#         raise TSValidationError("Access to '%s' is restricted for current user" % (action))
#     elif restrictions != True:
#         validator(restrictions, format_checker=jsonschema.FormatChecker()).validate(document)
# 
# Path: core/config.py

# 
# Path: core/api/crud.py
# def get(collection, criteria_projection_order):
# def remove(collection, criterias = []):
# def add(collection, documents_list):
# def update(collection, document):


from core.validation.validation import TSValidationError, validate_request, update_password_salt_user_list, validate_json_list, sanitize_objectify_json, stringify_objectid_cursor, stringify_objectid_list
from core.validation.permissions import check_datamine_permissions
from core.config import conf_reports, conf_approved
from bson.objectid import ObjectId
from core.api.crud import db
import cherrypy, logging
            output_costs_list.append( (ym, total_costs[ym]) )
                
        return output_costs_list

    def _merge_by_project(days_result, salaries_result, budget_result, costs_result):
    
        ### MERGE
        project_costs = {}
        
        for day in days_result:
            
            user_hours_record = day.get('_id',{})
            user_id = user_hours_record.get('user_id')
            project = user_hours_record.get('project')
            isextra = user_hours_record.get('isextra')
            user_date = user_hours_record.get('date')
            user_YM = '-'.join(user_date.split('-')[:2])
            user_hours = day.get('hours', 0)
    
            salary = next((sal['salary'][0]['cost'] for sal in salaries_result if sal['_id'] == ObjectId(user_id) and sal['salary'][0]['from'] <= user_date and sal['salary'][0]['to'] >= user_date ), 0)
            
            if salary:
                    
                if not project_costs.get(project):
                    project_costs[project] = { user_YM : {}}
                if not project_costs[project].get(user_YM):
                    project_costs[project][user_YM] = { 'salary' : 0, 'budget' : 0, 'extra_budget' : 0, 'costs' : 0}
                
                # If the hour block is extra, add the multiplier_on_extras to itself
                if isextra:

# Path: core/validation/validation.py
# class TSValidationError(Exception):
#     pass
# 
# def validate_request(collection, json_in):
#     validator(requests_schema[collection], format_checker=jsonschema.FormatChecker()).validate(json_in)
# 
# def update_password_salt_user_list(collection, list_in):
#     
#     if collection == 'user':
#         for json_in in list_in:
#             update_password_salt_user_json(json_in)
#         
#     return list_in
# 
# def validate_json_list(collection, list_in):
#     
#     for json_in in list_in:    
#         # Validate json schema
#         validator(schema[collection], format_checker=jsonschema.FormatChecker()).validate(json_in)
# 
# def sanitize_objectify_json(json_in):
#     """Sanitize string and convert _ids to ObjectId in JSON"""
#     return recursive_replace(json_in, _replace_function_sanitize_objectify_json)
# 
# def stringify_objectid_cursor(cursor_in):
#     """Convert ObjectId to string in JSON"""
#     
#     stringified = []
#     for json_in in cursor_in:
#         stringified.append(recursive_replace(json_in, _replace_function_stringify_objectid_json))
#     return stringified
# 
# def stringify_objectid_list(list_in):
#     """Convert an ObjectId list to string list"""
#     return recursive_replace(list_in, _replace_function_stringify_objectid_list)
# 
# Path: core/validation/permissions.py
# def check_datamine_permissions(action, document):
#     # Get datamine permissions
#     
#     try:
#         restrictions = cherrypy.session['_ts_user']['restrictions'][action]
#     except (KeyError, TypeError):
#         restrictions = None
#         
#     if not restrictions:
#         raise TSValidationError("Access to '%s' is restricted for current user" % (action))
#     elif restrictions != True:
#         validator(restrictions, format_checker=jsonschema.FormatChecker()).validate(document)
# 
# Path: core/config.py

# 
# Path: core/api/crud.py
# def get(collection, criteria_projection_order):
# def remove(collection, criterias = []):
# def add(collection, documents_list):
# def update(collection, document):


# Path: core/api/report_projects.py
from core.validation.validation import TSValidationError, validate_request, update_password_salt_user_list, validate_json_list, sanitize_objectify_json, stringify_objectid_cursor, stringify_objectid_list
from core.validation.permissions import check_datamine_permissions
from core.config import conf_reports, conf_approved
from bson.objectid import ObjectId
from core.api.crud import db
import cherrypy, logging

            output_costs_list.append( (ym, total_costs[ym]) )
                
        return output_costs_list

    def _merge_by_project(days_result, salaries_result, budget_result, costs_result):
    
        ### MERGE
        project_costs = {}
        
        for day in days_result:
            
            user_hours_record = day.get('_id',{})
            user_id = user_hours_record.get('user_id')
            project = user_hours_record.get('project')
            isextra = user_hours_record.get('isextra')
            user_date = user_hours_record.get('date')
            user_YM = '-'.join(user_date.split('-')[:2])
            user_hours = day.get('hours', 0)
    
            salary = next((sal['salary'][0]['cost'] for sal in salaries_result if sal['_id'] == ObjectId(user_id) and sal['salary'][0]['from'] <= user_date and sal['salary'][0]['to'] >= user_date ), 0)
            
            if salary:
                    
                if not project_costs.get(project):
                    project_costs[project] = { user_YM : {}}
                if not project_costs[project].get(user_YM):
                    project_costs[project][user_YM] = { 'salary' : 0, 'budget' : 0, 'extra_budget' : 0, 'costs' : 0}
                
                # If the hour block is extra, add the multiplier_on_extras to itself
                if isextra:

                    salary *= conf_reports['multiplier_on_extras']