cmservices/Sources/App/Controllers/l/LabSettingCtrl.swift

//
//  LabSettingCtrl.swift
//  
//
//  Created by Michiel Carman on 11/2/21.
//

import Foundation
import Vapor
import Fluent
import FluentPostgresDriver

final class LabSettingCtrl{
    //Create Unit
    func create(req: Request) throws -> EventLoopFuture<mdlLabSetting.Output>{
        let input = try req.content.decode(mdlLabSetting.Input.self)
        let output = self.createUnit(input)
        return self.save(output, req, input)
        
    }
    
    //Update Unit
    func update(req: Request) throws -> EventLoopFuture<mdlLabSetting.Output>{
        let input = try req.content.decode(mdlLabSetting.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<mdlLabSetting.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<mdlLabSetting.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 mdlLabSetting.find(id, on: req.db).unwrap(or: Abort(.notFound)).flatMap{ $0.delete(on: req.db)}.map{.ok}
    }
    
}

extension LabSettingCtrl{
    //Query Settings
    func qbase(req: Request) throws -> QueryBuilder<mdlLabSetting> {
        let query = mdlLabSetting.query(on:  req.db).with(\.$oilsamplelabels).with(\.$users)
        if let id = req.parameters.get("id", as: Int.self){
            return query.filter(\.$id == id)
        } else{
            return query
        }
    }
    //create Output
    func createRead(_ output: mdlLabSetting) -> mdlLabSetting.Output {
        return mdlLabSetting.Output(
            id: output.id!,
            name: output.name,
            description: output.description,
            barcodedelimiter: output.barcodedelimiter,
            barcodeactive: output.barcodeactive,
            textactive: output.textactive,
            logoactive: output.logoactive,
            createdate: output.createdate,
            createuserid: output.createuserid,
            updatedate: output.updatedate,
            updateuserid: output.updateuserid,
            oilsamplelabels: output.$oilsamplelabels.value!,
            users: output.$users.value!
                                              
        )
    }
    
    func mapOutput(_ output: Optional<mdlLabSetting>.WrappedType, _ input: mdlLabSetting.Input){
        output.name = input.name;
        output.description = input.description;
        output.barcodedelimiter = input.barcodedelimiter;
        output.barcodeactive = input.barcodeactive;
        output.textactive = input.textactive;
        output.logoactive = input.logoactive;
        output.createdate = input.createdate;
        output.updatedate = input.updatedate;
        output.createuserid = input.createuserid;
        output.updateuserid = input.updateuserid;
        output.$oilsamplelabels.value = input.oilsamplelabels
         
    }
    
    func createUnit(_ input: mdlLabSetting.Input) -> mdlLabSetting {
        return mdlLabSetting(
            id: input.id ?? nil
            , name: input.name
            , description: input.description
            , barcodedelimiter: input.barcodedelimiter
            , barcodeactive: input.barcodeactive
            , textactive: input.textactive
            , logoactive: input.logoactive
            , createuserid: input.createuserid ?? -1
            , createdate: input.createdate
            , updateuserid: input.updateuserid ?? -1
            , updatedate: input.updatedate
            , oilsamplelabels: input.oilsamplelabels
            , users: input.users
         )
    }
            
    //update function
    func save(_ output: Optional<mdlLabSetting>.WrappedType, req: Request) -> EventLoopFuture<mdlLabSetting.Output> {
        return output
            .save(on: req.db)
            .map{mdlLabSetting.Output(
                id: output.id!
                , name: output.name
                , description: output.description
                , barcodedelimiter: output.barcodedelimiter
                , barcodeactive: output.barcodeactive
                , textactive: output.textactive
                , logoactive: output.logoactive
                , createdate: output.createdate
                , createuserid: output.createuserid
                , updatedate: output.updatedate
                , updateuserid: output.updateuserid
                , oilsamplelabels: output.oilsamplelabels
                , users: output.users
                 
            )
        }
    }
    //create function
    func save(_ output: mdlLabSetting, _ req: Request, _ input: mdlLabSetting.Input) -> EventLoopFuture<mdlLabSetting.Output> {
        return output
            .save(on: req.db)
            .map{
                mdlLabSetting.Output(
                    id: output.id!
                    , name: output.name
                    , description: output.description
                    , barcodedelimiter: output.barcodedelimiter
                    , barcodeactive: output.barcodeactive
                    , textactive: output.textactive
                    , logoactive: output.logoactive
                    , createdate: output.createdate
                    , createuserid: output.createuserid
                    , updatedate: output.updatedate
                    , updateuserid: output.updateuserid
                    , oilsamplelabels: output.oilsamplelabels
                    , users: output.users
                     
                )
                
            }
    }
    
    }
    extension LabSettingCtrl: RouteCollection{
        func boot(routes: RoutesBuilder) throws{
            let apigroup = routes.grouped("labsettings")
            apigroup.get("", use: readAll)
            apigroup.get(":id", use: read)
            apigroup.post("", use: create)
            apigroup.post(":id", use: update)
            apigroup.delete(":id", use: delete)
            
            
        }
    }