country fact pdf by using visualforce page

 

vf page:-

<apex:page sidebar="false" tabStyle="Account" controller="SearchQuery" renderAs="{!if($CurrentPage.parameters.isPdf == null, null, 'pdf')}"  id="myPage">

  

   <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.0/jquery.min.js"></script>

    <script>

    $(document).ready(function(){

        $(".bPageBlock").css("background-color","lightpink");

    });

    </script>

    

    <apex:sectionHeader title="Country Facts"/>

    <apex:form >

        <apex:pageBlock >

            <apex:pageBlockSection collapsible="true" columns="3"  >

                <apex:inputText label="Enter Category Name :{!category} " html-placeholder="Please Enter Category Name" value="{!category}" /> 

              

              <apex:inputText label="Enter Country Name : {!Country} "  html-placeholder="Please Enter Country Name" value="{!Country}" /> 

              <apex:commandButton value="Search"  action="{!searchrecord}" />

             </apex:pageBlockSection>

         <apex:outputText >Number of Countries:-{!lstlist.size}</apex:outputText> &nbsp;<br/>

       <apex:outputText >Number of Country Facts:-{!lstlist.size}</apex:outputText>

        <apex:pageBlockTable value="{!lstlist}" var="fac">

            <apex:column headerValue="Country" value="{!fac.Country_Name__r.name}" /> &nbsp;

               <apex:column headerValue="Category" value="{!fac.Categories__r.Name}" />

                <apex:column headerValue="Country Fact" value="{!fac.Description__c}" />

              </apex:pageBlockTable>

            <apex:commandLink action="/apex/Searchcountry?isPdf=true" target="_blank" style="text-decoration:none">

             <apex:commandButton value="Generate Pdf"/>

            </apex:commandLink>

        </apex:pageBlock>

       </apex:form>

    

</apex:page>

apex class:-

-----------

public class SearchQuery {

   public string category{get;set;}

    public string Country{get;set;}

   public list<Country_Facts__c> lstlist{get;set;} 

   public void searchrecord()

   {

  string category1='%' + category+ '%';

  string Country1='%' + Country+ '%';

  

     string str='select id, name,Description__c, Country_Name__r.name, Categories__r.Name from Country_Facts__c where Categories__r.Name like :category1 and Country_Name__r.name like :Country1';

         lstlist=(list<Country_Facts__c>)database.query(str);

   

}

}