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

namespace SigStock
{
    public class Customizer : MercatorUi.ICustomizers.ISigCreated
    {

        public void SigCreated(MercatorUi.Sig.Sig Sig)
        {
            Sig.ExportingFields += new MercatorUi.Sig.Sig.ExportingFieldsEventHandler(Sig_ExportingFields);
        }

        void Sig_ExportingFields(object sender, MercatorUi.Sig.Sig.ExportingFieldsEventArgs e)
        {
            e.NodesToAdd.Add(new MercatorUi.Forms.Sig.SigClasses.ExportFieldNode("CA 30 derniers jours", "(select sum(tot_net_ht) from lignes_v inner join pieds_v on (pieds_v.id=lignes_v.id) and (pieds_v.journal=lignes_v.journal) and (pieds_v.piece=lignes_v.piece) where (lignes_v.id_article=s_id) and (pieds_v.type=1) and (pieds_v.date>=dbo.ADD_DATE(getdate(),-30))) as tot_ven", MercatorUi.Forms.Sig.SigClasses.ExportFieldNodeIconEnum.Float));
            e.NodesToAdd.Add(new MercatorUi.Forms.Sig.SigClasses.ExportFieldNode("Nom fourn. principal", "(select dbo.XNOM('FOU',id_fou) from artfou where (id_art=s_id) and (principal=1)) as fou_princ", MercatorUi.Forms.Sig.SigClasses.ExportFieldNodeIconEnum.String));
            e.NodesToAdd.Add(new MercatorUi.Forms.Sig.SigClasses.ExportFieldNode("Cpte général vente", "(select dbo.XNOM('GEN',s_comptev)) as s_comptev_nom", MercatorUi.Forms.Sig.SigClasses.ExportFieldNodeIconEnum.String));
        }
    }
}