/***************************************************************************************************************
* Avanxo
* @author           Denise Volpe, Franco Molfino
* Proyecto:         PyMe
* Descripción:      Conversion de Lead en Cuenta y Contacto
* Cambios (Version)
* -------------------------------------------
*            No.      Fecha               Autor                           Descripción
*           -----   ----------      ---------------------               ---------------
* @version   1.0    16/05/2019     Denise Volpe, Franco Molfino        Clase que se encarga de convertir una Lead en un contacto y una cuenta.
****************************************************************************************************************/
public class AVX_LeadHelper_cls {



   //Metodo modificado por Denise
    public static void LeadConvert2(list<Lead> lstLead){

        LeadStatus convertStatus = [SELECT Id, MasterLabel FROM LeadStatus WHERE IsConverted=true LIMIT 1];
        RecordType rt =[SELECT id , name FROM RecordType WHERE name = 'PyME'];
        List<account> lstcuentas = new List<account>();
        List<contact> lstContacto= new List<Contact>();


        for(Lead l : lstLead){
            Database.LeadConvert lc = new Database.LeadConvert();
            lc.setLeadId(l.id);
            lc.setDoNotCreateOpportunity(true);
            lc.setConvertedStatus(convertStatus.MasterLabel);



            lstCuentas=[SELECT Id,phone,recordTypeId,Correo_electronico__c,Celular__c,calle__c FROM Account WHERE CUIT_CUIL__c =: l.AVX_CUIT__c];
            lstContacto = [SELECT Id, accountId, account.CUIT_CUIL__c,celular__c,email,calle__c,phone FROM Contact WHERE AVX_DNI__c =:l.AVX_DNI__c and account.CUIT_CUIL__c =: l.AVX_CUIT__c];


            if(lstCuentas.size() !=0 ){

                lc.setAccountId(lstCuentas[0].Id);

            }

            update lstCuentas;


            if(lstContacto.size() != 0){
                lc.setContactId(lstContacto[0].Id);

            }
            update lstContacto;

            Database.convertLead(lc);


            lstCuentas=[SELECT Id,phone,recordTypeId,Correo_electronico__c,calle__c FROM Account WHERE CUIT_CUIL__c =: l.AVX_CUIT__c];
            lstContacto = [SELECT Id, accountId, account.CUIT_CUIL__c,celular__c,email,calle__c,phone FROM Contact WHERE AVX_DNI__c =:l.AVX_DNI__c and account.CUIT_CUIL__c =: l.AVX_CUIT__c];

            for(Account Cuentas:lstcuentas){
                Cuentas.recordTypeId=rt.Id;

                if(Cuentas.phone == null){
                    Cuentas.phone=l.Phone;
                }
                if(Cuentas.Correo_electronico__c == null){
                    Cuentas.Correo_electronico__c=l.email;
                }
                if(Cuentas.Calle__c == null){
                    String.format('{0}\n{1}\n{2}\n{3}',new String[]{l.street,l.state,l.PostalCode,l.country});
                }
                update Cuentas;
            }



            for(Contact Contacto:lstContacto){
                if(Contacto.phone == null){
                    Contacto.phone=l.MobilePhone;
                }
                if(Contacto.Email == null){
                    Contacto.Email=l.AVX_Correo_electr_nico__c;
                }
                if(Contacto.Calle__c == null){
                    String.format('{0}\n{1}\n{2}\n{3}',new String[]{l.street,l.state,l.PostalCode,l.country});
                }
                update Contacto;
            }


        }


    }
    //Metodo hecho por Franco
    public static void LeadConvert(list<Lead> lstLead){

        LeadStatus convertStatus = [SELECT Id, MasterLabel FROM LeadStatus WHERE IsConverted=true LIMIT 1];
        RecordType rt =[SELECT id , name FROM RecordType WHERE name = 'PyME'];
        List<account> lstcuentas = new List<account>();
        List<contact> lstContacto= new List<Contact>();




        for(Lead l : lstLead){
            Database.LeadConvert lc = new Database.LeadConvert();
            lc.setLeadId(l.id);
            lc.setDoNotCreateOpportunity(true);
            lc.setConvertedStatus(convertStatus.MasterLabel);

            lstCuentas=[SELECT Id,phone,recordTypeId,Correo_electronico__c,calle__c FROM Account WHERE CUIT_CUIL__c =: l.AVX_CUIT__c];
            lstContacto = [SELECT Id, accountId, account.CUIT_CUIL__c,celular__c,email,calle__c,phone FROM Contact WHERE AVX_DNI__c =:l.AVX_DNI__c and account.CUIT_CUIL__c =: l.AVX_CUIT__c];

            if(lstCuentas.size() != 0){
                lc.setAccountId(lstCuentas[0].Id);

            }
            update lstCuentas;
            if(lstContacto.size() != 0){
                lc.setContactId(lstContacto[0].Id);

            }
            update lstContacto;

            Database.convertLead(lc);


        }
    }


}