# -*- coding: utf-8 -*- ################################################################################ # # Cybrosys Technologies Pvt. Ltd. # # Copyright (C) 2023-TODAY Cybrosys Technologies(). # Author: Yadhukrishnan K (odoo@cybrosys.com) # # You can modify it under the terms of the GNU AFFERO # GENERAL PUBLIC LICENSE (AGPL v3), Version 3. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU AFFERO GENERAL PUBLIC LICENSE (AGPL v3) for more details. # # You should have received a copy of the GNU AFFERO GENERAL PUBLIC LICENSE # (AGPL v3) along with this program. # If not, see . ################################################################################ from datetime import date, timedelta from odoo import http from odoo.http import request class FleetFilter(http.Controller): """ The FleetFilter class provides the filter option to the js. When applying the filter return the corresponding data. Methods: fleet_filter(self): when the page is loaded adding filter options to the selection field. return a list variable. fleet_filter_data(self,**kw): after applying the filter receiving the values and return the filtered data. """ @http.route('/fleet/filter', auth='public', type='json') def fleet_filter(self): """ Summary: transferring data to the selection field that works as a filter Returns: type:list of lists , it contains the data for the corresponding filter. """ fleet_vehicle_ids = request.env['fleet.vehicle'].search([]) driver_list = request.env['res.partner'].search_read([], ['name']) # Getting vehicles model data vehicle_list = [{'id': fleet_vehicle_id.model_id.id, 'name': fleet_vehicle_id.model_id.name} for fleet_vehicle_id in fleet_vehicle_ids] vehicle_list = [vehicle for n, vehicle in enumerate(vehicle_list) if vehicle not in vehicle_list[:n]] # Getting vehicles brand data manufacturers_list = [{'id': fleet_vehicle_id.model_id.brand_id.id, 'name': fleet_vehicle_id.model_id.brand_id.name} for fleet_vehicle_id in fleet_vehicle_ids] manufacturers_list = [manufacturer for n, manufacturer in enumerate(manufacturers_list) if manufacturer not in manufacturers_list[:n]] filter_list = [driver_list, vehicle_list, manufacturers_list] return filter_list @http.route('/fleet_advanced_dashboard/filter_data', auth='public', type='json') def fleet_filter_data(self, **kw): """ Summary: transferring data to the selection field that works as a filter Args: kw(dict):This parameter contain value of selection field Returns: type:list of lists , it contains the data for the corresponding filter and transferring data to ui after filtration. """ data = kw.get('data') driver = [partner.id for partner in request.env['res.partner'].search([])] \ if data['driver'] == 'null' else [int(data['driver'])] vehicle = [fleet_vehicle_id.id for fleet_vehicle_id in request.env['fleet.vehicle.model'].search([])] \ if data['vehicle'] == 'null' else [int(data['vehicle'])] fleet_vehicle_list = [request.env['fleet.vehicle'].search([ ("model_id", '=', rec)]).id for rec in vehicle] manufacturer = [fleet_vehicle_id.model_id.brand_id.id for fleet_vehicle_id in request.env['fleet.vehicle'].search([])] \ if data['manufacturer'] == 'null' else [int(data['manufacturer'])] if data['date'] == 'null': fleet_vehicle_odometer_ids = request.env[ 'fleet.vehicle.odometer'].search( [("vehicle_id.id", 'in', vehicle), ("vehicle_id.brand_id.id", "in", manufacturer), ("driver_id.id", "in", driver)]) fleet_vehicle_log_contract_ids = request.env[ 'fleet.vehicle.log.contract'].search( [("vehicle_id.model_id.id", 'in', vehicle), ("vehicle_id.model_id.brand_id.id", 'in', manufacturer), ("state", "not in", ['expired', 'closed']), ("purchaser_id.id", "in", driver)]) fleet_vehicle_log_services_ids = request.env[ 'fleet.vehicle.log.services'].search( [("vehicle_id.model_id.id", 'in', vehicle), ("vehicle_id.model_id.brand_id.id", 'in', manufacturer), ("purchaser_id.id", "in", driver)]) else: range_date = date.today() - timedelta(days=int(data['date'])) fleet_vehicle_odometer_ids = request.env[ 'fleet.vehicle.odometer'].search( [("vehicle_id.id", 'in', vehicle), ("vehicle_id.brand_id.id", "in", manufacturer), ("driver_id.id", "in", driver), ("date", ">", range_date)]) fleet_vehicle_log_contract_ids = request.env[ 'fleet.vehicle.log.contract'].search( [("vehicle_id.model_id.id", 'in', vehicle), ("vehicle_id.model_id.brand_id.id", 'in', manufacturer), ("state", "not in", ['expired', 'closed']), ("purchaser_id.id", "in", driver), ("expiration_date", ">", range_date)]) fleet_vehicle_log_services_ids = request.env[ 'fleet.vehicle.log.services'].search( [("vehicle_id.model_id.id", 'in', vehicle), ("vehicle_id.model_id.brand_id.id", 'in', manufacturer), ("purchaser_id.id", "in", driver), ("date", ">", range_date)]) # Getting total odometer value total_odometer = sum(fleet_vehicle_odometer_ids.mapped('value')) admin_odometer_list = [fleet_vehicle_odometer_id.id for fleet_vehicle_odometer_id in fleet_vehicle_odometer_ids] # Getting total service cost service_cost = sum(fleet_vehicle_log_services_ids.mapped('amount')) admin_fleet_cost_list = [fleet_vehicle_log_services_id.id for fleet_vehicle_log_services_id in fleet_vehicle_log_services_ids] # Getting total recurring cost recurring_cost = sum( fleet_vehicle_log_contract_ids.mapped('cost_generated')) admin_recurring_list = [fleet_vehicle_log_contract_id.id for fleet_vehicle_log_contract_id in fleet_vehicle_log_contract_ids] return [total_odometer, service_cost, recurring_cost, admin_odometer_list, admin_fleet_cost_list, admin_recurring_list, fleet_vehicle_list, vehicle, manufacturer, len(fleet_vehicle_list)]