//
//  InspectionCategoryItemCtrl.swift
//  
//
//  Created by Michiel Carman on 11/10/21.
//

import Foundation
import Vapor
import Fluent
import FluentPostgresDriver
import AppKit

final class InspectionCategoryItemCtrl{
    //Create Unit
    func create(req: Request) throws -> EventLoopFuture<mdlInspectionCategoryItem.Output>{
        let input = try req.content.decode(mdlInspectionCategoryItem.Input.self)
        let output = self.createUnit(input)
        return self.save(output, req, input)
        
    }
    
    //Update Unit
    func update(req: Request) throws -> EventLoopFuture<mdlInspectionCategoryItem.Output>{
        let input = try req.content.decode(mdlInspectionCategoryItem.Input.self)
        return try qbase(req: req).first().unwrap(or: Abort(.notFound)).flatMap{output in self.mapOutput(output, input)
            return self.save(output, req: req)
        }
    }
    
    //Get all Divisions
    func readAll(req: Request) throws -> EventLoopFuture<Page<mdlInspectionCategoryItem.Output>>{
        return try qbase(req: req)
            .paginate(for: req)
            .map{
                page in page.map{
                    self.createRead($0)
                }
            }
    }
    //Get 1 Division
    func read(req: Request) throws -> EventLoopFuture<mdlInspectionCategoryItem.Output>{
        
        return try qbase(req: req).first().unwrap(or: Abort(.internalServerError)).map{self.createRead($0)}
        
    }
    //Delete 1 Division
    func delete(req: Request) throws -> EventLoopFuture<HTTPStatus>{
        
        guard let id = req.parameters.get("id", as: Int.self) else{
            throw Abort(.badRequest)
        }
        return mdlInspectionCategoryItem.find(id, on: req.db).unwrap(or: Abort(.notFound)).flatMap{ $0.delete(on: req.db)}.map{.ok}
    }
    
}
extension InspectionCategoryItemCtrl{
    //Query Settings
    func qbase(req: Request) throws -> QueryBuilder<mdlInspectionCategoryItem> {
        let query = mdlInspectionCategoryItem.query(on:  req.db)
            .with(\.$item)
            .with(\.$inspectioncategory)
            .with(\.$userdefinedcode)
            .with(\.$inputtype)
            .with(\.$currentitem)
            .with(\.$parent)
            .with(\.$inspectioncategoryitems)
            .with(\.$inspectioncategoryitemresponsetypes)
            .with(\.$inspectioncategoryitemspecs)
            .with(\.$notes)
            .with(\.$files)
        if let id = req.parameters.get("id", as: Int.self){
            return query.filter(\.$id == id)
        } else{
            return query
        }
    }
    //create Output
    func createRead(_ output: mdlInspectionCategoryItem) -> mdlInspectionCategoryItem.Output {
        return mdlInspectionCategoryItem.Output(
            id: output.id!,
            name: output.name,
            description: output.description,
            sortorder: output.sortorder,
            createdate: output.createdate,
            createuserid: output.createuserid,
            updatedate: output.updatedate,
            updateuserid: output.updateuserid,
            item: output.$item.value!,
            inspectioncategory: output.$inspectioncategory.value!,
            userdefinedcode: output.$userdefinedcode.value!,
            inputtype: output.$inputtype.value!,
            currentitem: output.$currentitem.value!,
            parent: output.$parent.value!,
            inspectioncategoryitems: output.$inspectioncategoryitems.value!,
            inspectioncategoryitemresponsetypes: output.$inspectioncategoryitemresponsetypes.value!,
            inspectioncategoryitemspecs: output.$inspectioncategoryitemspecs.value!,
            notes: output.$notes.value!,
            files: output.$files.value!
        )
    }
    
    func mapOutput(_ output: Optional<mdlInspectionCategoryItem>.WrappedType, _ input: mdlInspectionCategoryItem.Input){
        output.name = input.name;
        output.description = input.description;
        output.sortorder = input.sortorder;
        output.createdate = input.createdate;
        output.updatedate = input.updatedate;
        output.createuserid = input.createuserid;
        output.updateuserid = input.updateuserid;
        output.$item.id = input.item.id!;
        output.$inspectioncategory.id = input.inspectioncategory.id!;
        output.$userdefinedcode.id = input.userdefinedcode.id!;
        output.$inputtype.id = input.inputtype.id!;
        output.$currentitem.id = input.currentitem.id!;
        output.$parent.id = input.parent.id!;
        output.$inspectioncategoryitems.value = input.inspectioncategoryitems;
        output.$inspectioncategoryitemresponsetypes.value = input.inspectioncategoryitemresponsetypes;
        output.$inspectioncategoryitemspecs.value = input.inspectioncategoryitemspecs;
        output.$notes.value = input.notes;
        output.$files.value = input.files;
    }
    
    func createUnit(_ input: mdlInspectionCategoryItem.Input) -> mdlInspectionCategoryItem {
        return mdlInspectionCategoryItem(
            id: input.id ?? nil
            , name: input.name
            , description: input.description
            , sortorder: input.sortorder
            , createuserid: input.createuserid ?? -1
            , createdate: input.createdate
            , updateuserid: input.updateuserid ?? -1
            , updatedate: input.updatedate
            , item: input.item
            , inspectioncategory: input.inspectioncategory
            , userdefinedcode: input.userdefinedcode
            , inputtype: input.inputtype
            , currentitem: input.currentitem
            , parent: input.parent
            , inspectioncategoryitems: input.inspectioncategoryitems
            , inspectioncategoryitemresponsetypes: input.inspectioncategoryitemresponsetypes
            , inspectioncategoryitemspecs: input.inspectioncategoryitemspecs
            , notes: input.notes
            , files: input.files
        )
    }
    
    //update function
    func save(_ output: Optional<mdlInspectionCategoryItem>.WrappedType, req: Request) -> EventLoopFuture<mdlInspectionCategoryItem.Output> {
        return output
            .save(on: req.db)
            .map{mdlInspectionCategoryItem.Output(
                id: output.id!
                , name: output.name
                , description: output.description
                , sortorder: output.sortorder
                , createdate: output.createdate
                , createuserid: output.createuserid
                , updatedate: output.updatedate
                , updateuserid: output.updateuserid
                , item: output.item
                , inspectioncategory: output.inspectioncategory
                , userdefinedcode: output.userdefinedcode
                , inputtype: output.inputtype
                , currentitem: output.currentitem
                , parent: output.parent
                , inspectioncategoryitems: output.inspectioncategoryitems
                , inspectioncategoryitemresponsetypes: output.inspectioncategoryitemresponsetypes
                , inspectioncategoryitemspecs: output.inspectioncategoryitemspecs
                , notes: output.notes
                , files: output.files
            )
        }
    }
    //create function
    func save(_ output: mdlInspectionCategoryItem, _ req: Request, _ input: mdlInspectionCategoryItem.Input) -> EventLoopFuture<mdlInspectionCategoryItem.Output> {
        return output
            .save(on: req.db)
            .map{
                mdlInspectionCategoryItem.Output(
                    id: output.id!
                    , name: output.name
                    , description: output.description
                    , sortorder: output.sortorder
                    , createdate: output.createdate
                    , createuserid: output.createuserid
                    , updatedate: output.updatedate
                    , updateuserid: output.updateuserid
                    , item: input.item
                    , inspectioncategory: input.inspectioncategory
                    , userdefinedcode: input.userdefinedcode
                    , inputtype: input.inputtype
                    , currentitem: input.currentitem
                    , parent: input.parent
                    , inspectioncategoryitems: input.inspectioncategoryitems
                    , inspectioncategoryitemresponsetypes: input.inspectioncategoryitemresponsetypes
                    , inspectioncategoryitemspecs: input.inspectioncategoryitemspecs
                    , notes: input.notes
                    , files: input.files
                )
                
            }
    }
    
}
extension InspectionCategoryItemCtrl: RouteCollection{
    func boot(routes: RoutesBuilder) throws{
        let apigroup = routes.grouped("inspectioncategoryitems")
        apigroup.get("", use: readAll)
        apigroup.get(":id", use: read)
        apigroup.post("", use: create)
        apigroup.post(":id", use: update)
        apigroup.delete(":id", use: delete)
        
        
    }
}