<apex:page controller="FormerAuthorController"  sidebar="false" applyHtmlTag="true">

<apex:form >
    <apex:pageMessages id="errors" />

    <apex:pageBlock title="Former Author Payment!" mode="edit">

        <table width="100%" border="0">
            <tr>
                <td width="200" valign="top">


                    <apex:pageBlock title="Parameters" mode="edit" id="criteria">

                        <script type="text/javascript">
                        function doSearch() {
                            searchServer(
                                document.getElementById("year").value,
                                document.getElementById("fiscal").options[document.getElementById("fiscal").selectedIndex].value
                            );
                        }
                        </script>

                        <apex:actionFunction name="searchServer" action="{!runSearch}" rerender="results,debug,errors">
                            <apex:param name="year" value="" />
                            <apex:param name="fiscal" value="" />
                        </apex:actionFunction>

                        <table cellpadding="2" cellspacing="2">
                            <tr>
                                <td style="font-weight:bold;">Fiscal-Quarter<br/>
                                    <select id="fiscal" onchange="doSearch();">
                                        <option value=""></option>
                                        <apex:repeat value="{!fiscal}" var="quarter">
                                            <option value="{!quarter}">{!quarter}</option>
                                        </apex:repeat>
                                    </select>
                                </td>
                            </tr>
                            <tr>
                                <td style="font-weight:bold;">Year<br/>
                                    <input type="number" id="year" onkeyup="doSearch();"/>
                                </td>
                            </tr>
                            <!-- tr>
                            <td style="font-weight:bold;">Last Name<br/>
                            <input type="text" id="lastName" onkeyup="doSearch();"/>
                            </td>
                            </tr>
                            <tr>
                            <td style="font-weight:bold;">Account<br/>
                            <input type="text" id="accountName" onkeyup="doSearch();"/>
                            </td>
                            </tr -->

                        </table>

                    </apex:pageBlock>

                </td>
                <td valign="top">

                    <apex:pageBlock mode="edit" id="results">


                        <apex:pageBlockButtons >
                            <apex:commandButton value="Submit" action="{!submitForApproval}"/>
                            <apex:commandButton value="Cancel" action="{!Cancel}"/>
                            <apex:commandButton value="Approve" action="{!Approve}"/>
                            <apex:commandButton value="Reject" action="{!Reject}" />
                        </apex:pageBlockButtons>
                        <apex:pageBlockButtons >
                            <apex:commandButton value="First" action="{!Beginning}"/>
                            <apex:commandButton value="Previous" action="{!Previous}"/>
                            <apex:commandButton value="Next" action="{!Next}"/>
                            <apex:commandButton value="Last" action="{!End}" />

                        </apex:pageBlockButtons>
                        <apex:pageBlockTable value="{!monAct}" var="monRec">

                            <!-- apex:column >
                                <apex:facet name="header">
                                    <apex:inputCheckbox>
                                        <apex:actionSupport event="onClick" action="{!getSelected}" reRender="selection"/>
                                    </apex:inputCheckbox>
                                </apex:facet>
                                <apex:inputCheckbox value="{!monRec.Checkbox__c}" id="checkdone">
                                    <apex:actionSupport event="onClick" action="{!getSelected}" reRender="selection"/>
                                </apex:inputCheckbox>
                            </apex:column -->

                            <apex:column >
                                <apex:facet name="header">
                                    <c:CheckAllorNone />
                                </apex:facet>
                                <apex:inputCheckbox value="{!monRec.Checkbox__c}"/>
                            </apex:column>
                            <apex:column >
                                <apex:facet name="header">
                                    <apex:commandLink value="GID" action="{!toggleSort}" rerender="results,debug">
                                        <apex:param name="sortField" value="GID__c" assignTo="{!sortField}"/>
                                    </apex:commandLink>
                                </apex:facet>
                                <apex:outputField value="{!monRec.GID__c}"/>
                            </apex:column>
                            <apex:column >
                                <apex:facet name="header">
                                    <apex:commandLink value="Month" action="{!toggleSort}" rerender="results,debug">
                                        <apex:param name="sortField" value="Month_Text__c" assignTo="{!sortField}"/>
                                    </apex:commandLink>
                                </apex:facet>
                                <apex:outputField value="{!monRec.Month_Text__c}"/>
                            </apex:column>
                            <apex:column >
                                <apex:facet name="header">
                                    <apex:commandLink value="Quarter" action="{!toggleSort}" rerender="results,debug">
                                        <apex:param name="sortField" value="Quarter__c" assignTo="{!sortField}"/>
                                    </apex:commandLink>
                                </apex:facet>
                                <apex:outputField value="{!monRec.Quarter__c}"/>
                            </apex:column>
                            <apex:column >
                                <apex:facet name="header">
                                    <apex:commandLink value="Year" action="{!toggleSort}" rerender="results,debug">
                                        <apex:param name="sortField" value="year" assignTo="{!sortField}"/>
                                    </apex:commandLink>
                                </apex:facet>
                                <apex:outputField value="{!monRec.Year__c}"/>
                            </apex:column>


                        </apex:pageBlockTable>

                    </apex:pageBlock>

                </td>
            </tr>
        </table>

        <apex:pageBlock title="Debug - SOQL" id="debug">
            <apex:outputText value="{!debugSoql}" />
        </apex:pageBlock>

    </apex:pageBlock>

</apex:form>

public with sharing class FormerAuthorController {
public List<Monthly_Activity__c> monAct {get; set;}
private String soql{get; set;}
public Boolean checkAll{get; set;}
private String fiscalPeriod;
private String yearValue;
private static final String EDITORIAL_GROUP_NAME = 'Editorial';
private static final String FINANCIAL_GROUP_NAME = 'Finance';
private integer counter=0;          //keeps track of the offset
private integer list_size=25;       //sets the page size or number of rows
public integer total_size;          //used to show user the total size of the list

//List<Monthly_Activity__c> selectedRecords = new List<Monthly_Activity__c>();

private static Id financeGroupId
{
    get
    {
        if (financeGroupId == null)
        {
            financeGroupId = [SELECT Id FROM Group WHERE Name = :FINANCIAL_GROUP_NAME][0].Id;
        }
        return financeGroupId;
    }
    private set;
}

private static Id editorialGroupId
{
    get
    {
        if (editorialGroupId == null)
        {
            editorialGroupId = [SELECT Id FROM Group WHERE Name = :EDITORIAL_GROUP_NAME][0].Id;
        }
        return editorialgroupId;
    }
    private set;
}

private static Id submitterProfileId
{
    get
    {
        if (submitterProfileId == null)
        {
            submitterProfileId = [SELECT Id FROM Profile WHERE Name = 'Submitters'][0].Id;
        }
        return submitterProfileId;
    }
    private set;
}

private static Id financeProfileId
{
    get
    {
        if (financeProfileId == null)
        {
            financeProfileId = [SELECT Id FROM Profile WHERE Name = 'Finance'][0].Id;
        }
        return financeProfileId;
    }
    private set;
}

private static Id editorialProfileId
{
    get
    {
        if (editorialProfileId == null)
        {
            editorialProfileId = [SELECT Id FROM Profile WHERE Name = 'Editorial'][0].Id;
        }
        return editorialProfileId;
    }
    private set;
}


private static Id adminProfileId
{
    get
    {
        if (adminProfileId == null)
        {
            adminProfileId = [SELECT Id FROM Profile WHERE Name = 'System Administrator'][0].Id;
        }
        return adminProfileId;
    }
    private set;
}

// the current sort direction. defaults to asc
public String sortDir {
    get{
        if(sortDir == null){
            sortDir = 'asc';
        }
        return sortDir;
    }
    set;
}

// the current field to sort by. defaults to last name
public String sortField {
    get{
        if (sortField == null) {
            sortField = 'Year__c';
        } return sortField;
    }
    set;
}

// format the soql for display on the visualforce page
public String debugSoql {
    get{
        return soql + ' order by ' + sortField + ' ' + sortDir + ' limit '+list_size+' '+ 'offset '+counter;
    }
    set;
}

public FormerAuthorController(){
    total_size = [SELECT count() FROM Monthly_Activity__c WHERE Contract_Status__c =:'Former Author'];

}

// toggles the sorting of query from asc<-->desc
public void toggleSort() {
    // simply toggle the direction
    sortDir = sortDir.equals('asc') ? 'desc' : 'asc';
    // run the query again
    runQuery();
}

// runs the actual query
public void runQuery() {

    try {
        //monAct = Database.query(soql + ' order by ' + sortField + ' ' + sortDir + ' '+' Limit '+list_size+' '+' OFFSET '+counter);
        monAct = Database.query(debugSoql);
        system.debug('RUN QUERY ' + monAct);
    } catch (Exception e) {
        ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'Something Went Wrong. Contact System Adminstrator!'));
        system.debug('Error Message ***'+ e.getMessage());
    }

}

// runs the search with parameters passed via Javascript
public PageReference runSearch() {
    system.debug('RUN SEARCH');
    String fiscal = Apexpages.currentPage().getParameters().get('fiscal');
    fiscalPeriod = fiscal;
    String year = Apexpages.currentPage().getParameters().get('year');
    yearValue = year;
    system.debug('FISCAL '+ fiscal);
    system.debug('YEAR '+ year);
    soql = 'SELECT Id, Name, Month__c, Checkbox__c FROM Monthly_Activity__c WHERE Contract_Status__c = 'Former Author'';
    if (!year.equals(''))
        soql += ' and Year__c ='+ year;
    if (!fiscal.equals(''))
        soql += ' and Quarter__c LIKE '' +String.escapeSingleQuotes(fiscal)+''';


    // run the query again
    runQuery();
    system.debug('RUN SEARCH QUERY');
    return null;
}

// use apex describe to build the picklist values
public List<String> fiscal {
    get {
        if (fiscal == null) {

            fiscal = new List<String>();
            Schema.DescribeFieldResult field = Monthly_Activity__c.Fiscal_Quarter__c.getDescribe();

            for (Schema.PicklistEntry f : field.getPicklistValues())
                fiscal.add(f.getLabel());

        }
        return fiscal;
    }
    set;
}


 //Approval Code

 public void beginApprovalProcess(Monthly_Activity__c monAct){
    Approval.ProcessSubmitRequest req = new Approval.ProcessSubmitRequest();
    req.setComments('Submitting Records for Approval via VisualForce Page');
    req.setObjectId(monAct.id);

   }

 //  Button Code


public void submitForApproval(){
    if(fiscalPeriod <> Null && yearValue <> Null) {
        if(UserInfo.getProfileId()== submitterProfileId || UserInfo.getProfileId()== adminProfileId){
                //beginApprovalProcess();

        }
    }
}


public PageReference Cancel(){
    PageReference page = new PageReference('/FormerAuthorPage');
    page.setRedirect(true);
    return page;
}

public PageReference Approve(){
    if(fiscalPeriod <> Null && yearValue <> Null) {
        if(UserInfo.getProfileId()== financeProfileId || UserInfo.getProfileId()== editorialProfileId){


        }
    }
    PageReference page = new PageReference('/FormerAuthorPage');
    page.setRedirect(true);
    return page;
}

public PageReference Reject(){
    if(fiscalPeriod <> Null && yearValue <> Null) {
        if(UserInfo.getProfileId()== financeProfileId || UserInfo.getProfileId()== editorialProfileId){


        }
    }
    PageReference page = new PageReference('/FormerAuthorPage');
    page.setRedirect(true);
    return page;
}

//  Pagination Code

public PageReference Beginning() { //user clicked first
    counter = 0;
    runQuery();
    return null;
}

public PageReference Previous() { //user clicked previous
    counter -= list_size;
    runQuery();
    return null;
}

public PageReference Next() { //user clicked next
    counter += list_size;
    runQuery();
    return null;
}

public PageReference End() { //user clicked last
    counter = total_size - math.mod(total_size, list_size);
    runQuery();
    return null;
}

public Boolean getDisablePrevious() {
    //this will disable the previous and beginning buttons
    if (counter>0) return false;
    else return true;

}

public Boolean getDisableNext() { //this will disable the next and end buttons
    if (counter + list_size < total_size)
        return false; else return true;

}

public Integer getTotal_size() {
    return total_size;
}

public Integer getPageNumber() {
    return counter/list_size + 1;
}

public Integer getTotalPages() {
    if (math.mod(total_size, list_size) > 0) {
        return total_size/list_size + 1;
    } else {
        return (total_size/list_size);
    }
}

<apex:component >
<script>
function cvCheckAllOrNone(allOrNoneCheckbox) {

    // Find parent table
    var container = allOrNoneCheckbox;
    while (container.tagName != "TABLE") {
        container = container.parentNode;
    }

    // Switch all checkboxes
    var inputs = container.getElementsByTagName("input");
    var checked = allOrNoneCheckbox.checked;
    for (var i = 0; i < inputs.length; i++) {
        var input = inputs.item(i);
        if (input.type == "checkbox") {
            if (input != allOrNoneCheckbox) {
                input.checked = checked;
            }
        }
    }
}
</script>

<apex:inputCheckbox onclick="cvCheckAllOrNone(this)" title="Toggle All Rows"/>