using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using MercatorApi;
using MercatorController;

namespace MercatorUi.Reporting
{
    public class Customizer : MercatorUi.ICustomizers.IStringUpdater
    {
        public string StringUpdate(string reqSql)
        {
            if (MercatorUi.Globals.EngineBillingV.FieldListLignes.ContainsKey("ID_DEPOT")) // depotin lijnen is geïnstalleerd
            {
                reqSql = reqSql.Replace("pieds_v.id_depot", "case when lignes_v.id_depot>'' then lignes_v.id_depot else pieds_v.id_depot end")
                               .Replace("from pieds_v", "from pieds_v inner join lignes_v on ((pieds_v.id=lignes_v.id) and (pieds_v.journal=lignes_v.journal) and (pieds_v.piece=lignes_v.piece))");
            }
            return reqSql;
        }
    }
}