-
ChatterFeed
-
1Best Answers
-
0Likes Received
-
0Likes Given
-
13Questions
-
9Replies
amazon s3 and salesforce for large files
Can anyone suggest a possible way?
SOAP and Rest calls fro SFDC will not handle large attachments. What are all the other possible ways? Please share the code also.
This is on priority. Please help.
Are there any free appexchange apps?
-
- anup ram
- July 06, 2014
- Like
- 0
- Continue reading or reply
Salesforce sites with Flex error
Error is security error accessing url and also destination: default http
I am not sure how to use flex on salesforce sites to create record in salesforce.
<mx:Script>
<![CDATA[
import com.salesforce.*;
import com.salesforce.objects.*;
import com.salesforce.results.*;
import mx.controls.Alert;
import com.salesforce.AsyncResponder;
import com.salesforce.events.ApexFaultEvent;
import com.salesforce.objects.LoginRequest;
import com.salesforce.objects.SObject;
import com.salesforce.results.Fault;
import com.salesforce.results.LoginResult;
import com.salesforce.results.QueryResult;
import com.salesforce.results.UpsertResult;
[Bindable] public var sfdc:Connection = new Connection();
private function login():void {
Security.loadPolicyFile("https://salesforce.com/services/Soap/u/crossdomain.xml");
var lr:LoginRequest = new LoginRequest();
sfdc.protocol = "https";
sfdc.serverUrl = "https://login.salesforce.com/services/Soap/u/14.0";
lr.username = "uname.com";
lr.password = "pwdsectoken";
lr.callback = new AsyncResponder(loginSuccess, loginFault);
sfdc.login(lr);
}
private function submitForm():void {
var aSo:Array = new Array();
var so:SObject = new SObject("Contact");
so.FirstName = firstName.text;
so.LastName = lastName.text;
so.Email = email.text;
aSo.push(so);
sfdc.create(aSo,
new AsyncResponder(
function (obj:Object):void {
if (obj[0].success == true) {
Alert.show("Created record: "+obj[0].id);
} else {
Alert.show(obj[0].errors[0].message)
}
}, sfdcFailure
)
);
}
private function loginSuccess(result:Object):void {
Alert.show("Done");
contactForm.enabled = true;
}
private function sfdcFailure(fault:Object):void {
Alert.show(fault.faultstring);
}
private function loginFault(fault:Object):void
{
Alert.show("Could not log into SFDC: "+fault.fault.faultString,"Login Error");
Alert.show("error " + fault.fault.faultDetail);
}
]]>
</mx:Script>
<mx:Text text="To create a new Contact, Last Name is required by Salesforce.com while Email is required via a custom validation rule. 

Submit the form with different combinations to view the resulting messages returned from Salesforce.com.
" width="449"/>
<mx:Form id="contactForm" width="100%" height="100%" enabled="false">
<mx:FormItem label="First Name">
<mx:TextInput id="firstName"/>
</mx:FormItem>
<mx:FormItem label="Last Name">
<mx:TextInput id="lastName"/>
</mx:FormItem>
<mx:FormItem label="Email">
<mx:TextInput id="email"/>
</mx:FormItem>
<mx:FormItem>
<mx:Button label="Submit" click="submitForm()"/>
</mx:FormItem>
</mx:Form>
-
- anup ram
- June 29, 2014
- Like
- 0
- Continue reading or reply
Post request from Flex to salesforce
-
- anup ram
- June 20, 2014
- Like
- 0
- Continue reading or reply
invalid pdf error for email with pdf attachment
Hi,
I have a requirement to generate a pdf and send a email with thsi pdf attachments.
The pdf is generated and attached and email is sent.
when i login as system admin : pdf generated opens in adobe / nitro pdf
for other profiles > email is sent with attachments but pdf attachment doesnt open in pdf , it says invalid pdf file...
whats the problem...
The profile has access to the page which is rendered as pdf.
PageReference pdf = Page.PdfGenerator;
pdf.getParameters().put('id',objectId);
pdf.setRedirect(true);
// The contents of the attachment from the pdf stored as a Blob
Blob body;
try
{
// Get contents of the attachment from the pdf
body = pdf.getContent();
}
catch (VisualforceException e)
{
body = Blob.valueOf('Encountered VF exception');
}
system.debug(' body of pdf content ' + body);
//Generating a Email PDF attachment
Messaging.EmailFileAttachment PDFAttachFile = new Messaging.EmailFileAttachment();
PDFAttachFile.setContentType('application/pdf');
PDFAttachFile.setFileName('test.pdf');
PDFAttachFile.setInline(false);
PDFAttachFile.Body = body;
// Construct the email envelope
OrgWideEmailAddress[] orgemail = [select Id,Address from OrgWideEmailAddress where Address = 'some email' limit 1];
Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
mail.setUseSignature(false);
if ( orgemail.size() > 0 )
{
mail.setOrgWideEmailAddressId(some id);
}
mail.setToAddresses(new String[]{toEmailAddr });
mail.setSubject('hi 123' );
mail.setHtmlBody('Hi ');
mail.setFileAttachments(new Messaging.EmailFileAttachment[] { PDFAttachFile });
// Send the mail with Attachment
Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail});
why oher profiles other than system admin cant generate a proper pdf?
plz urgent requirement...........................
-
- anup ram
- July 20, 2013
- Like
- 0
- Continue reading or reply
Pageblocktable calculate sum of column
Hi
I have a pageblocktable with some fields like price , user editable Price field, and total amount field ( quantity * price)
i have to calculate the grandtotal i.e total of totalamount field in every row .
This grandtotal has to be displayed on the page and also should be available for subsequent operations.
How to do this.
Please share a sample code .
-
- anup ram
- May 24, 2013
- Like
- 0
- Continue reading or reply
problem in assigning the total to wrapperclass property.
Hi All,
I am facing a problem in assigning the total to wrapperclass property.
I have a pageblocktable with displays a pist of product with price. The quantity is entered. The total amount is calculated by calling a method in controller. But I am not bale to assign the total to that perticular row so that I am not able to display proper total on the pageblocktable.
please tell how to associate the total to wrapper class ..
Apex:
public class pricefromproduct
{
// where name like '%searchkey%' select Id from product2 where name like '%searchkey%'
public pricefromproduct()
{
}
public integer total{get;set;}
public string searchkey {get;set;}
public list<pricewrapper> prwrp {get;set;} {prwrp = new list<pricewrapper>();}
// public list<productlist> prod{get;set;} {prod = new list<productlist>();}
public pagereference priceproduct()
{
list<product2> prod = [select id from product2 where name like :'%'+searchkey+'%'];
system.debug('prod size' + prod.size());
// prolist = [select id,name from product__c where name like : '%'+searchkey+'%'];
list<pricebookentry> pricebk = [Select Id, Name, ProductCode, Pricebook2Id, UnitPrice From PricebookEntry where Product2Id in :prod and usestandardprice = false and isactive = true];
/* best way to remove duplicates from list
list<string> pr = new list<string>{'james','smith','james'};
set<string> myset = new Set<string>();
List<string> result = new List<string>();
myset.addAll(pr);
result.addAll(myset);
system.debug(' pr size before filter ' + pr.size() + ' after ' + result.size());
*/
system.debug('pricebook size' + pricebk.size());
for (pricebookentry pb : pricebk)
{
pricewrapper p = new pricewrapper();
p.prc = pb;
p.prodprice = integer.valueof(pb.unitprice);
p.prodname = pb.name;
prwrp.add(p);
}
return null;
}
public integer f{get;set;}
public integer q{get;set;}
public pagereference totalcount()
{
f = integer.valueof(Apexpages.currentPage().getParameters().get('f'));
q = integer.valueof(Apexpages.currentPage().getParameters().get('q'));
total = f * q;
system.debug(' total ' + total);
return null;
}
public class pricewrapper
{
public pricebookentry prc{get;set;}
public integer prodprice{get;set;}
public string prodname{get;set;}
public boolean issel {get;set;}
public integer quantity{get;set;}
public integer totalamount{get;}
public pricewrapper()
{
}
}
}
-
- anup ram
- May 23, 2013
- Like
- 0
- Continue reading or reply
Totalamount not shown in added to cart objects when kept as inputtext
Hi All,
I have a small problem in my page. I am not finding the method to figure it out.
Problem:
I have a search field to display the products with its price
2. i can select the product using checkbox and give the number of quantity . the javascript will calculate the totalamount. (working)
3. I have a button to add product to cart
4. in the cart i can see product name, quantity, unitprice but not totalprice.
If i change the outputtext to inputtext for totalprice then it is getting displayed in cart items but if i give as inputtext for totalcount then automatically the quantity * unitprice value is not updated.
I found it a bit wierd kind of situation.
My code:
Controller:
public class productassign
{
public productassign(apexpages.standardcontroller controller)
{
}
//used to get a hold of the account record selected for deletion
public string SelectedAccountId { get; set; }
public string searchkey{get;set;}
public list<product__c> prolist;
public list<productlist> prod{get;set;} {prod = new list<productlist>();}
public integer rownum;
public void delRow()
{
rowNum = Integer.valueOf(apexpages.currentpage().getparameters().get('index'));
cartlist.remove(rowNum);
}
public pageReference searchprod()
{
prolist = [select id,name,price__c from product__c where name like : '%'+searchkey+'%'];
prolist.sort();
for (product__c pr : prolist)
{
productlist p = new productlist();
p.prot = pr;
p.proname = pr.name;
p.proid = pr.id;
p.proprice = integer.valueof(pr.price__c);
prod.add(p);
}
return null;
}
public boolean displayPopup {get; set;}
public pagereference closePopup() {
displayPopup = false;
return null;
}
public pagereference showPopup() {
displayPopup = true;
system.debug('show ppup ' + displayPopup );
return null;
}
public class productlist
{
public product__c prot{get;set;}
public string proname;
public id proid;
public integer proprice;
public integer quantity{get;set;}
public boolean isselect {get;set;}
public integer total{get;set;}
}
public integer maxnum;
public pagereference addtocart()
{
list<aggregateResult> res = [select max(orderid__c) from cart__c];
for (aggregateresult r : res)
{
maxnum = integer.valueof(r.get('expr0'));
maxnum = maxnum + 1;
}
for (productlist crt : prod)
{
if (crt.isselect)
{
cart__c c = new cart__c();
c.name = crt.proname;
c.orderid__c = maxnum;
c.product__c = crt.proname;
c.Quantity__c = crt.quantity;
//system.debug(crt.proname);
insert(c);
}
}
pagereference prref = new pagereference('/apex/oderlist?orderkey='+maxnum);
prref.setredirect(false);
return prref;
}
public list<cartwrapper> cartlist{get;set;} { cartlist = new list<cartwrapper>();}
public class cartwrapper
{
public productlist proobj{get;set;}
}
/* public pagereference addtocart3()
{
for (productlist crt : prod)
{
if (crt.isselect)
{
cartwrapper c = new cartwrapper();
c.proobj = crt;
cartlist.add(c);
}
}
pagereference prref = new pagereference('/apex/cartpage');
prref.setredirect(false);
return prref;
}*/
public pagereference addtocart2()
{
for (productlist crt1 : prod)
{
if (crt1.isselect)
{
cartwrapper c1 = new cartwrapper();
c1.proobj = crt1;
cartlist.add(c1);
}
}
return null;
}
public boolean getRendered()
{
Boolean render = (cartlist == null || cartlist.size() == 0 ? false : true);
return render;
}
}
VF page:
<apex:page standardController="Product__c" extensions="productassign" >
<apex:stylesheet value="{!$Resource.histyle}"/>
<style>
.changecss
{
background-color:grey;
}
</style>
<script>
function computeTotal(quantityId, unitPriceId, totalId){
var quantity = document.getElementById(quantityId).value;
var cost = document.getElementById(unitPriceId).innerHTML;
var totalPrice = quantity * cost ;
alert('quantity is ' + quantity + 'price is ' + cost );
document.getElementById(totalId).innerHTML = totalPrice;
}
</script>
<apex:form id="kh">
<h1>Product search and cart page</h1>
<apex:commandbutton value="press" action="{!showpopup}" rerender="kh" />
<apex:outputpanel rendered="{!displayPopup}">
This is popup display
</apex:outputPanel>
</apex:form>
<apex:form id="myform" >
<div id="loadingDiv">
<!-- The screen element that will cover the form. Javascript will change the height of this to drop it down. -->
<apex:pageblock id="hardCosts" title="Line Items - Hard Cost Estimate"> <!-- The form element to screen. -->
<script>
function showLoadingDiv() {
var blockToLoad = document.getElementById('{!$Component.hardCosts}');
var loadWidth = window.getComputedStyle(blockToLoad,"").getPropertyValue("width");
var loadHeight = window.getComputedStyle(blockToLoad,"").getPropertyValue("height");
//Set the loadingDiv to screen the element at the correct size.
var loadingDiv = document.getElementById('loadingDiv');
loadingDiv.setAttribute('style','background-color:black; opacity:0.35; height:' + parseFloat(loadHeight) + 'px; width:' + loadWidth + ';');
}
function hideLoadingDiv() {
var loadingDiv = document.getElementById('loadingDiv');
var blockToLoad = document.getElementById('{!$Component.hardCosts}');
var loadWidth = window.getComputedStyle(blockToLoad,"").getPropertyValue("width");
loadingDiv.setAttribute('style','height:0px; width: ' + loadWidth + '; background-color:black; opacity:1;');
}
</script>
Enter Search Value :
<apex:inputText value="{!searchkey}"/>
<apex:commandButton value="Search" action="{!searchprod}" status="status" rerender="myform" />
<apex:actionStatus id="status" onstart="showLoadingDiv()" onstop="hideLoadingDiv()" >
<apex:facet name="start" >
<br/>
loading..<br/>
<img src="{!$Resource.loading}" border="0" height="50" width="50"/>
<!-- <apex:image url="{!$Resource.loading}" title="loading..." height="50" width="50" /> -->
</apex:facet>
<apex:facet name="stop" >
</apex:facet>
</apex:actionstatus>
<apex:pageblockTable value="{!prod}" var="a" style="width:800px" rowclasses="changecss">
<apex:column headervalue="Name" style="width:200px"> {!a.prot.name}</apex:column>
<apex:column headervalue="Price" id="Price" style="width:200px"> {!a.prot.price__c}</apex:column>
<!-- <apex:column headerValue="Quantity" style="width:200px"> <apex:inputtext value="{!a.quantity}"/></apex:column> -->
<apex:column headerValue="Quantity">
<apex:inputtext id="quantity" style="width:200px" value="{!a.quantity}" onblur="computeTotal('{!$Component.quantity}','{!$Component.Price}','{!$Component.total}');"/>
</apex:column>
<apex:column ><apex:inputcheckbox value="{!a.isselect}" style="width:20px"/> </apex:column>
<apex:column headerValue="total" style="width:200px">
<apex:outputtext id="total" style="width:200px" value="{!a.total}"/>
</apex:column>
</apex:pageblockTable>
<apex:commandButton value="Add to cart2" action="{!addtocart2}" reRender="cartshow"/> </apex:pageBlock>
<h1>cart list </h1>
<apex:outputpanel id="cartshow">
<apex:pageBlock id="cartsho" mode="readonly" rendered="{!rendered}" >
<apex:pageBlockSection columns="2"> <apex:pageblockSectionItem dataStyle="width:50%"></apex:pageblockSectionItem>
<apex:pageblockSectionItem dataStyle="width:50%">
<apex:pageBlockTable value="{!cartlist}" var="c" >
<apex:column headerValue="Delete" headerClass="ct">
<apex:variable var="rowNum" value="{!0}"/>
<apex:commandLink style="font-size:15px; font-weight:bold; text-align:center;color:red;" value="X" action="{!delrow}" reRender="cartshow" >
<apex:param value="{!rowNum}" name="index" />
</apex:commandLink>
<apex:variable var="rowNum" value="{!rowNum+1}"/>
</apex:column>
<apex:column value="{!c.proobj.prot.name}" headerValue="Product Name"/>
<apex:column headervalue="Price" style="width:200px"> {!c.proobj.prot.price__c}</apex:column>
<apex:column headerValue="Quantity" >
{!c.proobj.quantity }
</apex:column>
<apex:column headerValue="Total" >
<apex:outputtext value="{!c.proobj.total}"/>
</apex:column>
</apex:pageBlockTable>
<apex:commandButton value="Order" action="{!addtocart}"/>
</apex:pageblockSectionItem>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:outputpanel>
</div>
</apex:form>
</apex:page>
Any suggestions to overcome this problem?
-
- anup ram
- May 22, 2013
- Like
- 0
- Continue reading or reply
Edit on pageblocktable in specfic rows
Hi I have a urgent requirement to edit specific rows on pageblocktable.
I am able to delete the specific row but not getting how to edit specific row.
can somebody share me a working code snippet so that i can refer and implement the logic.
Please help me
-
- anup ram
- May 22, 2013
- Like
- 0
- Continue reading or reply
How to avoid soql inside for loops
Can u tell me how i can reframe logic to elimiate soql inside for loop. What is the best possible way.
I had written a logic in which a soql was placed inside a for loop. I got to know it is not a good way of implementation.
Please share your knowledge.
-
- anup ram
- May 20, 2013
- Like
- 0
- Continue reading or reply
Actionfunction not called with param
Hi ,
actionfunction not called. whats the mistake. please correct me where i am doing mistake.
I dont know if i am in right approach. I am pulling out price from LIST of products user enters tjhe quantity and total amount to be displayed. I am using param and actionfunction to do it.
I dont know if it will work onchange for a row in the list.
please guide me.
VF :
<apex:form >
<apex:actionFunction id="paramcall" name="paramcall" action="{!totalcount}" rerender="my">
<apex:param name="f" value="" assignTo="{!a.prodprice}"/>
<apex:param name="q" value="" assignTo="{!a.quantity}"/>
</apex:actionfunction>
</apex:form>
<apex:form id="my">
<apex:pageBlock > Enter Search Value :
<apex:inputText value="{!searchkey}"/>
<apex:commandButton value="Search" action="{!priceproduct}"/>
<apex:pageblockTable value="{!prwrp}" var="a">
<apex:column headervalue="Selected"><apex:inputcheckbox value="{!a.issel}"/>
</apex:column>
<apex:column headervalue="Name" >{!a.prodname}
</apex:column>
<apex:column headerValue="unitprice">
<apex:outputText id="unitPrice" value="{!a.prodprice}"/>
</apex:column>
<apex:column headerValue="Quantity" >
<apex:inputtext id="quantity" value="{!a.quantity}" onchange="paramcall(yes!)" />
</apex:column>
<apex:column headerValue="total">
<apex:outputText id="total"/>{!a.totalamount}
</apex:column>
</apex:pageblockTable>
Apex:
public integer total{get;set;}
public integer f{get;set;}
public integer q{get;set;}
public pagereference totalcount()
{
total = f * q;
system.debug(' total ' + total);
return null;
}
-
- anup ram
- May 20, 2013
- Like
- 0
- Continue reading or reply
Syntax error calling javascript with parameters in inputfield onblur
Hi,
I am getting syntax error while passing parameters to javascript from inputfield onblur attribute.
I do not know why the error is resulting in.
Please help me with the solution.
I hope there is no apex controller required along with the visualforce page.
VF CODE :
<apex:page standardController="Account" recordSetVar="accs" sidebar="false">
<script type="text/javascript">
function computeTotal(quantityId, unitPriceId, totalId){
var quantity = document.getElementById(quantityId).value;
var cost = document.getElementById(unitPriceId).innerHTML;
var totalPrice = quantity * cost;
document.getElementById(totalId).innerHTML = totalPrice;
}
</script>
<apex:form >
<apex:pageBlock >
<apex:pageBlockTable value="{!accs}" var="acc">
<apex:column headerValue="Quantity">
<apex:inputText id="quantity" onblur="computeTotal('{!$Component.quantity}','{!$Component.unitPrice}','{!$Component.total}');"/>
</apex:column>
<apex:column headerValue="Unit Price">
<apex:outputText id="unitPrice" value="10"/>
</apex:column>
<apex:column headerValue="Total Price">
<apex:outputText id="total"/>
</apex:column>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:form>
</apex:page>
-
- anup ram
- May 18, 2013
- Like
- 0
- Continue reading or reply
Lookup field in where clause of SOQL not returning values
Hi All,
I have a lookup field on a object. I have written a soql to return name and other fields from the object with the looku field in the where clause. But this is not returning me values.
\please help.
list<contact> con = [select id,name from contact where name like 'a%'];
integer consize = con.size(); // returning 1, ( correct )
system.debug(' con size filter ' + consize);
for (contact conn : con)
{
system.debug(' contact name ' + conn.name ); // returning correct name
list<class__c> cls = [select name__c,Fee__c from class__c where classteacher__c =:conn.name];
integer classsize = cls.size(); // showing 0 , but one class is available with class teacher of conn.name
system.debug(' class size ' + classsize);
here classteacher__c is the lookup field to contact.
there is one class with classteacher name which is retuerned by conn.name but it is not being fetched.
Please help.
-
- anup ram
- May 05, 2013
- Like
- 0
- Continue reading or reply
executebatch(b,>5)returns too many callouts, how to seperate login & callout methods
Hi All,
I am coding for a S2S integration. I am using batch program to accomplish this. I have written a class for login and callout to external system. I had written both login and callout statements in a single method. The WS is working fine till database.executebatch(batchname,5) i.e scope of 5, scope more than 5 is returning too many callout error.
I was told to seperate the login to external system in Start method of batch and callout in execute method of batch.But I am not able to seperate the same. Please help me.
public class TestWebService {
public String errMsg{get;set;}
public String displayError{get;set;}
public TestWebService()
{
displayError = 'none';
}
public void login(){
//-----------------------------------
// Login via SOAP/XML web service api
//-----------------------------------
HttpRequest request = new HttpRequest();
request.setEndpoint('https://www.salesforce.com/services/Soap/u/26.0');
request.setMethod('POST');
errMsg+=' 1';
request.setHeader('Content-Type', 'text/xml;charset=UTF-8');
request.setHeader('SOAPAction', '""');
request.setBody('<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/"><Header/><Body><login xmlns="urn:partner.soap.sforce.com"><username>' + 'uname'+ '</username><password>' + 'pwd'+ '</password></login></Body></Envelope>');
Dom.XmlNode resultElmt = (new Http()).send(request).getBodyDocument().getRootElement().getChildElement('Body','http://schemas.xmlsoap.org/soap/envelope/').getChildElement('loginResponse','urn:partner.soap.sforce.com').getChildElement('result','urn:partner.soap.sforce.com');
// Grab session id and server url
//--------------------------------
final String SERVER_URL = resultElmt.getChildElement('serverUrl', 'urn:partner.soap.sforce.com').getText().split('/services')[0];
final String SESSION_ID = resultElmt.getChildElement('sessionId', 'urn:partner.soap.sforce.com') .getText();
errMsg+=SERVER_URL+' <--> '+SESSION_ID;
MyclassWS.myclass ws = new MyclassWS.myclass();
MyclassWS.SessionHeader_element session = new MyclassWS.SessionHeader_element();
session.sessionId=SESSION_ID;
ws.SessionHeader=session;
errMsg+= ' ****** ' + ws.mastermetdh('test') + 'juice in org2';
}
}
I am calling this login() from Batch execute. But i want to split login() to login ( and call it from start) and callout ( and call it from execute ) from this.
-
- anup ram
- March 16, 2013
- Like
- 0
- Continue reading or reply
Post request from Flex to salesforce
- anup ram
- June 20, 2014
- Like
- 0
- Continue reading or reply
problem in assigning the total to wrapperclass property.
Hi All,
I am facing a problem in assigning the total to wrapperclass property.
I have a pageblocktable with displays a pist of product with price. The quantity is entered. The total amount is calculated by calling a method in controller. But I am not bale to assign the total to that perticular row so that I am not able to display proper total on the pageblocktable.
please tell how to associate the total to wrapper class ..
Apex:
public class pricefromproduct
{
// where name like '%searchkey%' select Id from product2 where name like '%searchkey%'
public pricefromproduct()
{
}
public integer total{get;set;}
public string searchkey {get;set;}
public list<pricewrapper> prwrp {get;set;} {prwrp = new list<pricewrapper>();}
// public list<productlist> prod{get;set;} {prod = new list<productlist>();}
public pagereference priceproduct()
{
list<product2> prod = [select id from product2 where name like :'%'+searchkey+'%'];
system.debug('prod size' + prod.size());
// prolist = [select id,name from product__c where name like : '%'+searchkey+'%'];
list<pricebookentry> pricebk = [Select Id, Name, ProductCode, Pricebook2Id, UnitPrice From PricebookEntry where Product2Id in :prod and usestandardprice = false and isactive = true];
/* best way to remove duplicates from list
list<string> pr = new list<string>{'james','smith','james'};
set<string> myset = new Set<string>();
List<string> result = new List<string>();
myset.addAll(pr);
result.addAll(myset);
system.debug(' pr size before filter ' + pr.size() + ' after ' + result.size());
*/
system.debug('pricebook size' + pricebk.size());
for (pricebookentry pb : pricebk)
{
pricewrapper p = new pricewrapper();
p.prc = pb;
p.prodprice = integer.valueof(pb.unitprice);
p.prodname = pb.name;
prwrp.add(p);
}
return null;
}
public integer f{get;set;}
public integer q{get;set;}
public pagereference totalcount()
{
f = integer.valueof(Apexpages.currentPage().getParameters().get('f'));
q = integer.valueof(Apexpages.currentPage().getParameters().get('q'));
total = f * q;
system.debug(' total ' + total);
return null;
}
public class pricewrapper
{
public pricebookentry prc{get;set;}
public integer prodprice{get;set;}
public string prodname{get;set;}
public boolean issel {get;set;}
public integer quantity{get;set;}
public integer totalamount{get;}
public pricewrapper()
{
}
}
}
- anup ram
- May 23, 2013
- Like
- 0
- Continue reading or reply
Edit on pageblocktable in specfic rows
Hi I have a urgent requirement to edit specific rows on pageblocktable.
I am able to delete the specific row but not getting how to edit specific row.
can somebody share me a working code snippet so that i can refer and implement the logic.
Please help me
- anup ram
- May 22, 2013
- Like
- 0
- Continue reading or reply
Actionfunction not called with param
Hi ,
actionfunction not called. whats the mistake. please correct me where i am doing mistake.
I dont know if i am in right approach. I am pulling out price from LIST of products user enters tjhe quantity and total amount to be displayed. I am using param and actionfunction to do it.
I dont know if it will work onchange for a row in the list.
please guide me.
VF :
<apex:form >
<apex:actionFunction id="paramcall" name="paramcall" action="{!totalcount}" rerender="my">
<apex:param name="f" value="" assignTo="{!a.prodprice}"/>
<apex:param name="q" value="" assignTo="{!a.quantity}"/>
</apex:actionfunction>
</apex:form>
<apex:form id="my">
<apex:pageBlock > Enter Search Value :
<apex:inputText value="{!searchkey}"/>
<apex:commandButton value="Search" action="{!priceproduct}"/>
<apex:pageblockTable value="{!prwrp}" var="a">
<apex:column headervalue="Selected"><apex:inputcheckbox value="{!a.issel}"/>
</apex:column>
<apex:column headervalue="Name" >{!a.prodname}
</apex:column>
<apex:column headerValue="unitprice">
<apex:outputText id="unitPrice" value="{!a.prodprice}"/>
</apex:column>
<apex:column headerValue="Quantity" >
<apex:inputtext id="quantity" value="{!a.quantity}" onchange="paramcall(yes!)" />
</apex:column>
<apex:column headerValue="total">
<apex:outputText id="total"/>{!a.totalamount}
</apex:column>
</apex:pageblockTable>
Apex:
public integer total{get;set;}
public integer f{get;set;}
public integer q{get;set;}
public pagereference totalcount()
{
total = f * q;
system.debug(' total ' + total);
return null;
}
- anup ram
- May 20, 2013
- Like
- 0
- Continue reading or reply
Lookup field in where clause of SOQL not returning values
Hi All,
I have a lookup field on a object. I have written a soql to return name and other fields from the object with the looku field in the where clause. But this is not returning me values.
\please help.
list<contact> con = [select id,name from contact where name like 'a%'];
integer consize = con.size(); // returning 1, ( correct )
system.debug(' con size filter ' + consize);
for (contact conn : con)
{
system.debug(' contact name ' + conn.name ); // returning correct name
list<class__c> cls = [select name__c,Fee__c from class__c where classteacher__c =:conn.name];
integer classsize = cls.size(); // showing 0 , but one class is available with class teacher of conn.name
system.debug(' class size ' + classsize);
here classteacher__c is the lookup field to contact.
there is one class with classteacher name which is retuerned by conn.name but it is not being fetched.
Please help.
- anup ram
- May 05, 2013
- Like
- 0
- Continue reading or reply
Updating a field dynamically in pageBlockTable
Hi,
My requirement is that I want a field(column) in pageBlockTable to be calculated dynamically based on 2 other fields.
I have 3 columns - Order quantity, Unit Price & Total Extended Price.
What I want to do is :
Whenever the value under Order quantity is changed in a row, the corresponding Total Extended Price should be calculated and refreshed (Total Extended Price = Order quantity * Unit Price ).
How can I achieve the same in Visualforce ?
Thanks in advance.
Regards,
Lakshmi.
- laks
- September 03, 2012
- Like
- 0
- Continue reading or reply