using InABox.Integration.Logikal;
using System;
using System.Collections.Generic;

namespace PRSDesktop.Integrations.Logikal
{
    public class LogikalFinish : LogikalItem, ILogikalFinish
    {

        public String Code { get; set; }

        public String Description { get; set; }

        public override  void ValidateQuery(string sql, List<string> errors)
        {
            ValidateField(sql, nameof(Code), errors);
            ValidateField(sql, nameof(Description), errors);
        }

        public static String SQL =
            "SELECT DISTINCT\n" +
            $"  f.fincol_code as {nameof(Code)}, \n" +
            $"  f.descr as {nameof(Description)}, \n" +
            "FROM \n" +
            "  bom_piece bp \n" +
            "left outer join \n" +
            "  quote_item qi on qi.quote_item_id = bp.quote_item_id \n" +
            "left outer join  \n" +
            "  quote q on q.quote_id = qi.quote_id \n" +
            "left outer join \n" +
            "  fincol f on f.fincol_lib_id = bp.fincol_lib_id and f.fincol_id = bp.fincol_id \n" +
            "where \n" +
            "  1 = 1";

    }


}