public with sharing class studentSponsorController{

    public List<Opportunity> oppList{get; set;}//List of all Opportunities for data table
    public Opportunity oppObj {get; set;}//object for oppotunity to get content on visualforce page
   
    private String sortDirection = 'ASC';//variables to sort data table columns
    private String sortExp = 'name';//variables to sort data table columns
   
    public Contact con {set; get;}//variable for contact fo get content on visual force page
   
    public boolean isExport {get;set;}//variable to export data into excel
   
    //logic to sort the data table values
    public String sortExpression{
        get{
            return sortExp;
        }
        set{
            //if the column is clicked on then switch between Ascending and Descending modes
            if (value == sortExp)
                sortDirection = (sortDirection == 'ASC')? 'DESC' : 'ASC';
            else
                sortDirection = 'ASC';
                sortExp = value;
            }
    }
   
    //Logic to sorting in asce/desce
    public String getSortDirection(){
    //if not column is selected
        if (sortExpression == null || sortExpression == '')
            return 'ASC';
        else
            return sortDirection;
    }
   
    //logic to view sorted data
    public PageReference ViewData() {
        //build the full sort expression
        string sortFullExp = sortExpression  + ' ' + sortDirection;
       
        //query the database based on the sort expression
        try{
            String RecTypeName = 'Education Sponsor';
            OpportunityRecordTypes__c edSponsorSort = OpportunityRecordTypes__c.getValues('RT1');//object to get record type using custom settings
           
            if(RecTypeName == 'Education Sponsor'){
                RecTypeName  = edSponsorSort.RecordTypeName__c;
            }
           
            oppList = Database.query('Select Id, Name, Account.Id, Account.Name, StageName, Sponsorship_For__c, Std__c, Student_Name__c, Sponsorship_Date__c,Student_Name__r.STD__c,Standard__c FROM  Opportunity WHERE Recordtype.name = :RecTypeName ORDER BY ' + sortFullExp + ' limit 1000');
        }catch(Exception e ) {
            ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.WARNING, e.getMessage() ));
        }
       
        return null;
    }
       
    //Controller
    public studentSponsorController(){
       
        try{
            OpportunityRecordTypes__c edSponsor = OpportunityRecordTypes__c.getValues('RT1');//object to get record type using custom settings
            oppList = [Select Id, Name, Account.Id, Account.Name, Record_Type_Name__c,
                       StageName,
                       Sponsorship_For__c, Std__c, Student_Name__c, Sponsorship_Date__c,
                       Student_Name__r.STD__c,Standard__c
                       FROM
                       Opportunity
                       WHERE
                       Recordtype.name = :edSponsor.RecordTypeName__c LIMIT 1000];
           
            oppObj = new Opportunity();
            con = new Contact();
            if(Apexpages.currentPage().getParameters().get('Export') != null){
                isExport = true;
            }
            else{
                isExport = false;
            }
           
        }catch(Exception e ) {
            ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.WARNING, e.getMessage() ));
        }
       
    }
   
    //Logic to view respective opportunity record
    public PageReference View() {
       Opportunity oppTemp = new Opportunity(id=ApexPages.currentPage().getParameters().get('Id'));
       PageReference stundentSponsorPage = new ApexPages.StandardController(oppTemp).view();
       return stundentSponsorPage ;
    }
   
    //Getting list of all opprtunites
    public List<Opportunity> getOppList() {
        return oppList;
    }
   
    //logic to reset searched values
    public void reset() {
        oppObj = new Opportunity();
    }
   
    //method to get search results
    public void dynamicSearch(){
        try{
            String searchingRecTypeName = 'Education Sponsor';
            OpportunityRecordTypes__c edSponsorSearch = OpportunityRecordTypes__c.getValues('RT1');//object to get record type using custom settings
           
            if(searchingRecTypeName == 'Education Sponsor'){
                searchingRecTypeName = edSponsorSearch.RecordTypeName__c;
            }
           
            String selectStr =' Select Id, Name, Account.Id, Account.Name,Standard__c,Record_Type_Name__c,Student_Name__r.STD__c, StageName, Sponsorship_For__c, Std__c, Student_Name__c, Sponsorship_Date__c ' +
                              ' FROM Opportunity WHERE Recordtype.name = :searchingRecTypeName ';
            String whereStr ='';
            String orderBy=' order by Std__c ASC limit 1000';
       
            String whereStr1 = (con.STD__c != null) ? whereStr + ' Student_Name__r.STD__c = \''+ con.STD__c+'\'' : '';
            String whereStr2 = (oppObj.Student_Name__c!=null) ? whereStr + ' Student_Name__c = \''+ oppObj.Student_Name__c+'\'' : '';
            String whereStr3 = (oppObj.Sponsorship_For__c != null) ? whereStr + ' Sponsorship_For__c = \''+ oppObj.Sponsorship_For__c+'\'' : '';       
            String whereStr4 = (oppObj.Name !='') ? whereStr + ' Name Like  \'%'+oppObj.Name+'%\' ' : '';
           
            whereStr =(whereStr1.length()>0) ? whereStr + ' AND ' + whereStr1 : whereStr;
            whereStr =(whereStr2.length()>0) ? whereStr + ' AND ' + whereStr2 : whereStr;
            whereStr =(whereStr3.length()>0) ? whereStr + ' AND ' + whereStr3 : whereStr;
            whereStr =(whereStr4.length()>0) ? whereStr + ' AND ' + whereStr4 : whereStr;
           
            String qry = (selectStr + whereStr + orderBy);
            oppList = Database.query(selectStr + whereStr + orderBy);           
        }catch(Exception e) {
            ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.WARNING, e.getMessage()));
        }
    }
   
    //method to export data into excel
    public PageReference export(){
        isExport = true;
        return null;
    }
}