Salesforce Developer Community

Error: GoogleChartsController Compile Error: Incompatible types since an instance of ApexPages.StandardController is never an instance of Account at line 5 column 15

Controller:

global class GoogleChartsController {
global static Account acc;

    public GoogleChartsController(ApexPages.StandardController controller) {
        acc = (Account)controller.getRecord();
    }
@RemoteAction
    global static AggregateResult[] loadChildCases(Id prmAccountId) {
        AggregateResult[] caseLst = [Select ParentId, count(Id) FROM Case WHERE AccountId = :prmAccountId Group By ParentId ];

        return caseLst;
    }
    }

VF Page:

<apex:page extensions="GoogleChartsController" sidebar="false" standardController="Account" showHeader="false" pageStyle="Account" >
    <apex:includeScript id="a" value="https://www.google.com/jsapi" />
    <script type="text/javascript">
        // Load the Visualization API and the piechart package.
        google.load('visualization', '1.0', {'packages':['corechart']});
        // Set a callback to run when the Google Visualization API is loaded.
        google.setOnLoadCallback(initCharts);
        //load all the charts..
        function initCharts() {
              GoogleChartsController.loadChildCases('{!acc.Id}', function(resultCase, event){
                  var visualization = new google.visualization.ColumnChart(document.getElementById('caseChart'));
                  var data1 = new google.visualization.DataTable();
                  data1.addColumn('string', 'Cases');
                  data1.addColumn('number', 'Cases');
                  //add rows from the remoting results
                  for(var i =0; i < resultCase.length; i++){
                      var r = resultCase[i];
                      data1.addRow([r.Id, r.expr0]);
                   }
                    // all done, lets draw the chart with some options to make it look nice.
                    visualization.draw(data1, {legend : {position: 'top', textStyle: {color: 'blue', fontSize: 10}}, width:150,vAxis:{textStyle:{fontSize: 10}},hAxis:{textStyle:{fontSize: 10},showTextEvery:1,slantedText:false}});
              }, {escape:true});

          }
    </script>
     <div id="caseChart" />
</apex:page>

chenna1234
November 20, 2012
Like
0

SOLVED

4 replies

Unable to Insert Quotes into Accnt,Oppy

Hi All,

I am unable to insert qoute into account & oppportuntiy. Can you please help me out.....

Error Message: System.QueryException: List has no rows for assignment to SObject
Class.QuickqouteUI.InsertQuoteToAccount: line 28, column 1
Class.QuickqouteUI.<init>: line 12, column 1

VF Page & Controller:

<apex:page controller="QuickqouteUI" action="{!InsertQuoteToAccount}" showHeader="false">
<apex:sectionHeader title="Quote Details"/>
<apex:form >
<style>
     .labelCol
     {
         font-family:"Times New Roman"
         color:black font;
     }
</style>
<style>
.inactiveTab {
        background-color: ????;
        font-family:"Times New Roman"
        font-weight:bold;
        color:black;
        background-image:none
      }
</style>
      <apex:pageBlock >
          <apex:pageBlockSection columns="1" >
              <apex:inputField value="{!objRoofDetails.Quote_description__c}" />
               <apex:inputField value="{!objRoofDetails.City_State__c}" />
               <apex:inputField value="{!objRoofDetails.Install_Date__c}" />
          </apex:pageBlockSection>
          <apex:pageBlockSection columns="1" Title="Solar System">
              <apex:pageBlockSectionItem >
                  <apex:outputLabel value="Description"></apex:outputLabel>
                  <apex:inputText />
              </apex:pageBlockSectionItem>
              <apex:pageBlockSectionItem >
                  <apex:outputLabel value="System price"></apex:outputLabel>
                  <apex:inputText />
              </apex:pageBlockSectionItem>
              <apex:pageBlockSectionItem >
                  <apex:outputLabel value="Description"></apex:outputLabel>
                  <apex:tabPanel id="tabpanel" immediate="true" reRender="tabpanel">
                  <apex:tab label="Roof 1">
                      <table>
                          <tr>
                              <td align="right"><apex:outputLabel value="Description" styleClass="labelCol" ></apex:outputLabel></td>
                              <td><apex:inputText /></td>
                              <td></td>
                          </tr>
                          <tr>
                              <td align="right"><apex:outputLabel value="Modules per strings" styleClass="labelCol" ></apex:outputLabel></td>
                              <td><apex:inputText /></td>
                              <td><a href="http:google.com">Design Tools</a></td>
                          </tr>
                          <tr>
                              <td align="right"><apex:outputLabel value="Total parallel strings" styleClass="labelCol" ></apex:outputLabel></td>
                              <td><apex:inputText /></td>
                              <td></td>
                          </tr>
                          <tr>
                              <td align="right"><apex:outputLabel value="Inverter Manufaturer" styleClass="labelCol" ></apex:outputLabel></td>
                              <td>
                                  <apex:selectList id="Inventers" size="1" label="Direction">
                                             <apex:selectOptions value="{!Inventers}" ></apex:selectOptions>
                                   </apex:selectList>
                              </td>
                              <td></td>
                          </tr>
                          <tr>
                              <td align="right"><apex:outputLabel value="Inventer Model" styleClass="labelCol" ></apex:outputLabel></td>
                              <td>
                                  <apex:selectList id="Model" size="1" label="Direction">
                                             <apex:selectOptions value="{!Inventers1}"></apex:selectOptions>
                                   </apex:selectList>
                              </td>
                              <td></td>
                          </tr>
                          <tr>
                              <td align="right"><apex:outputLabel value="Inverter Count" styleClass="labelCol" ></apex:outputLabel>
                              </td>
                              <td><apex:inputText /></td>
                              <td></td>
                          </tr>
                      </table>

                  </apex:tab>
                  <apex:tab label="Roof 2">
                   <table>
                          <tr>
                              <td align="right"><apex:outputLabel styleClass="labelCol" value="Description"></apex:outputLabel></td>
                              <td><apex:inputText /></td>
                              <td></td>
                          </tr>
                          <tr>
                              <td align="right"><apex:outputLabel styleClass="labelCol" value="Modules per strings"></apex:outputLabel></td>
                              <td><apex:inputText /></td>
                              <td><a href="http:google.com">Design Tools</a></td>
                          </tr>
                          <tr>
                              <td align="right"><apex:outputLabel styleClass="labelCol" value="Total parallel strings"></apex:outputLabel></td>
                              <td><apex:inputText /></td>
                              <td></td>
                          </tr>
                          <tr>
                              <td align="right"><apex:outputLabel styleClass="labelCol" value="Inverter Manufaturer"></apex:outputLabel></td>
                              <td>
                                  <apex:selectList id="Inventers1" size="1" label="Direction">
                                             <apex:selectOptions value="{!Inventers}"></apex:selectOptions>
                                   </apex:selectList>
                              </td>
                              <td></td>
                          </tr>
                          <tr>
                              <td align="right"><apex:outputLabel styleClass="labelCol" value="Inventer Model"></apex:outputLabel></td>
                              <td>
                                  <apex:selectList id="Model1" size="1" label="Direction">
                                             <apex:selectOptions value="{!Inventers}"></apex:selectOptions>
                                   </apex:selectList>
                              </td>
                              <td></td>
                          </tr>
                          <tr>
                              <td align="right"><apex:outputLabel value="Inverter Count" styleClass="labelCol" ></apex:outputLabel>
                              </td>
                              <td><apex:inputText /></td>
                              <td></td>
                          </tr>
                      </table>
                  </apex:tab>
                  <apex:tab label="Roof 3"></apex:tab>
                   <apex:tab label="Roof 4"></apex:tab>
                   </apex:tabPanel>
              </apex:pageBlockSectionItem>
           </apex:pageBlockSection>
      </apex:pageBlock>
</apex:form>
</apex:page>

Apex Controller:

public with sharing class QuickqouteUI {

    public Roof_Details__c objRoofDetails{get;set;}
    public Quote objquote{get;set;}
    private String accID{get;set;}
    public QuickqouteUI()
    {

    objRoofDetails = new Roof_Details__c();
    objquote = new Quote();
    accID = '0038000000h4oyM';
InsertQuoteToAccount();
    }
public List<SelectOption> getInventers() {
        List<SelectOption> options = new List<SelectOption>();
        options.add(new SelectOption('SunPower','SunPower'));
        options.add(new SelectOption('SunPower','NonSunPower'));
        return options;
    }
public List<SelectOption> getInventers1() {
        List<SelectOption> options = new List<SelectOption>();
        options.add(new SelectOption('6.0kW (Model PVI-6000-OUTD)', '7.0kW (Model PVI-6000-OUTD)'));
        options.add(new SelectOption('8.0kW (Model PVI-6000-OUTD)', '8.0kW (Model PVI-6000-OUTD)'));
        return options;
    }
public void InsertQuoteToAccount(){

        opportunity objopp = [select account.name from opportunity where AccountId=: accID];
        objquote.name ='testi';
        objquote.opportunityid = objopp.id;
        insert objquote;
    }
}

chenna1234
November 14, 2012
Like
0

1 replies

Passing data from one VF to another Vf pages in SFDC ( Very Urgent)

Hi All,

I am having 2 vf pages where i can enter information on both pages. so if i enter data on first vf page it shld also appear on 2nd vf page & viceversa. Can you please send the code?

Thanks in Advance for your great help

chenna1234
November 12, 2012
Like
0

SOLVED

2 replies

Displaying custom error message on vf page if field is not filled

Hi All, I kept required=" true" only vf page where it shows red mark on it. but i need to display custom error message on top of vf page if field is not filled.....

chenna1234
November 09, 2012
Like
0

2 replies

Unable to generate WSDL from .net Webservices

When i trying to create WSDL in salesforce from Webservices that is provided from External systems..... Following error msg gets displayed in salesforce.........

Error MEssage:

Failed to parse wsdl: Unable to find schema for element; {http://www.w3.org/2001/XMLSchema}schema

Please let me know if you need WSDL?

Thanks in Advance....!!!!!

chenna1234
October 31, 2012
Like
0

2 replies

Trigger on opportunity object( Need urgent Help...!!!!!)

I wrote update trigger on opportuntiy object depending upon services,products & sevices & products , so based upon that it will go to approval...
so the trigger is firing for all status on opportunity( i.e for status="prospect" they is no need to have opportunity but all other status the opporunity needs to be added.)
Is there anyway i can put condition in trigger to exclude status="prospect" but on rest of all status it need to fire...

Thanks in Advance

chenna1234
August 11, 2012
Like
0

2 replies

On Page load (Extremely urgent)

HI All,

On click of link, sometimes VF page is not loading completely. I passed mode = edit in url aslo. Still its not working.

Please suggest some logic asap.

chenna1234
February 08, 2013
Like
0

4 replies

Extremetly Urgent ( Can we generate images into PDF)

HI All,

Is there anyway we can generate images into "PDF" by using any tool.

I know we can to by uploading into doc or else as static resource... But i will generate graphs dynamically.

Thanks,

Chenna(INDIA)

chenna1234
November 20, 2012
Like
0

SOLVED

4 replies

Unable to Insert Quotes into Accnt,Oppy

Hi All,

I am unable to insert qoute into account & oppportuntiy. Can you please help me out.....

Error Message: System.QueryException: List has no rows for assignment to SObject
Class.QuickqouteUI.InsertQuoteToAccount: line 28, column 1
Class.QuickqouteUI.<init>: line 12, column 1

VF Page & Controller:

Apex Controller:

chenna1234
November 14, 2012
Like
0

2 replies

Unable to generate WSDL from .net Webservices

When i trying to create WSDL in salesforce from Webservices that is provided from External systems..... Following error msg gets displayed in salesforce.........

Error MEssage:

Failed to parse wsdl: Unable to find schema for element; {http://www.w3.org/2001/XMLSchema}schema

Please let me know if you need WSDL?

Thanks in Advance....!!!!!

chenna1234
October 31, 2012
Like
0