CSV reporting..
Locked
 
|
i use CSV reporting in ofbiz
As we all know, we can display data of only one list in the form. so i use view entity to display data of multiple table. now i have one problem. i want to display the detail of party like name, address, email, contact number etc. for this purpose i create a view entity but it only display the email id or telephone number because contactMechId id different for those two, so please help me on this issue.. below i paste the view entity code which i use for this purpose:- DynamicViewEntity dynamicView = new DynamicViewEntity(); List orderBy = FastList.newInstance(); List fieldsToSelect = FastList.newInstance(); dynamicView.addMemberEntity("PT", "Party"); dynamicView.addAlias("PT", "partyId"); dynamicView.addAlias("PT", "statusId"); dynamicView.addAlias("PT", "partyTypeId"); dynamicView.addAlias("PT", "createdDate"); dynamicView.addRelation("one-nofk", "", "PartyType", ModelKeyMap.makeKeyMapList("partyTypeId")); dynamicView.addRelation("many", "", "UserLogin", ModelKeyMap.makeKeyMapList("partyId")); fieldsToSelect.add("partyId"); fieldsToSelect.add("statusId"); fieldsToSelect.add("partyTypeId"); fieldsToSelect.add("createdDate"); orderBy.add("createdDate"); dynamicView.addMemberEntity("PDS", "PartyDataSource"); dynamicView.addAlias("PDS", "visitId"); dynamicView.addViewLink("PT", "PDS", Boolean.FALSE, ModelKeyMap.makeKeyMapList("partyId")); fieldsToSelect.add("visitId"); dynamicView.addMemberEntity("UL", "UserLogin"); dynamicView.addAlias("UL", "userLoginId"); dynamicView.addViewLink("PT", "UL", Boolean.FALSE, ModelKeyMap.makeKeyMapList("partyId")); fieldsToSelect.add("userLoginId"); dynamicView.addMemberEntity("PE", "Person"); dynamicView.addAlias("PE", "firstName"); dynamicView.addAlias("PE", "lastName"); dynamicView.addViewLink("PT", "PE", Boolean.FALSE, ModelKeyMap.makeKeyMapList("partyId")); fieldsToSelect.add("firstName"); fieldsToSelect.add("lastName"); dynamicView.addMemberEntity("PC", "PartyContactMech"); dynamicView.addMemberEntity("CM", "ContactMech"); dynamicView.addMemberEntity("TM", "TelecomNumber"); dynamicView.addAlias("PC", "contactMechId"); dynamicView.addAlias("CM", "infoString"); dynamicView.addAlias("TM", "countryCode"); dynamicView.addAlias("TM", "areaCode"); dynamicView.addAlias("TM", "contactNumber"); dynamicView.addViewLink("PT", "PC", Boolean.FALSE, ModelKeyMap.makeKeyMapList("partyId")); dynamicView.addViewLink("PC", "CM", Boolean.FALSE, ModelKeyMap.makeKeyMapList("contactMechId")); dynamicView.addViewLink("PC", "TM", Boolean.FALSE, ModelKeyMap.makeKeyMapList("contactMechId")); fieldsToSelect.add("infoString"); fieldsToSelect.add("contactNumber"); fieldsToSelect.add("areaCode"); fieldsToSelect.add("countryCode"); in ftl file if i display partyLists.infoSting is display null because for telecomNumber there is no infoString value in corresponding column of contactMech table. |
|
|
my first suggestion is you make a view-entity in a xml file
and include it in your project. then you can use web tools to look at it like anyother entity. https://demo.hotwaxmedia.com/webtools/control/FindGeneric?entityName=ContactMechDetail&find=true&VIEW_SIZE=50&VIEW_INDEX=0 you should have a _NA_ for fields instead of Nulls where there is a relationship. nalin chandra sent the following on 12/2/2008 12:35 PM: > i use CSV reporting in ofbiz > > As we all know, we can display data of only one list in the form. > > so i use view entity to display data of multiple table. > now i have one problem. > > i want to display the detail of party like name, address, email, contact > number etc. > for this purpose i create a view entity but it only display the email id or > telephone number because contactMechId id different for those two, so please > help me on this issue.. > > below i paste the view entity code which i use for this purpose:- > > DynamicViewEntity dynamicView = new DynamicViewEntity(); > List orderBy = FastList.newInstance(); > List fieldsToSelect = FastList.newInstance(); > > dynamicView.addMemberEntity("PT", "Party"); > dynamicView.addAlias("PT", "partyId"); > dynamicView.addAlias("PT", "statusId"); > dynamicView.addAlias("PT", "partyTypeId"); > dynamicView.addAlias("PT", "createdDate"); > dynamicView.addRelation("one-nofk", "", "PartyType", > ModelKeyMap.makeKeyMapList("partyTypeId")); > dynamicView.addRelation("many", "", "UserLogin", > ModelKeyMap.makeKeyMapList("partyId")); > > > fieldsToSelect.add("partyId"); > fieldsToSelect.add("statusId"); > fieldsToSelect.add("partyTypeId"); > fieldsToSelect.add("createdDate"); > orderBy.add("createdDate"); > > dynamicView.addMemberEntity("PDS", "PartyDataSource"); > dynamicView.addAlias("PDS", "visitId"); > dynamicView.addViewLink("PT", "PDS", Boolean.FALSE, > ModelKeyMap.makeKeyMapList("partyId")); > > fieldsToSelect.add("visitId"); > > dynamicView.addMemberEntity("UL", "UserLogin"); > dynamicView.addAlias("UL", "userLoginId"); > dynamicView.addViewLink("PT", "UL", Boolean.FALSE, > ModelKeyMap.makeKeyMapList("partyId")); > > fieldsToSelect.add("userLoginId"); > > dynamicView.addMemberEntity("PE", "Person"); > dynamicView.addAlias("PE", "firstName"); > dynamicView.addAlias("PE", "lastName"); > dynamicView.addViewLink("PT", "PE", Boolean.FALSE, > ModelKeyMap.makeKeyMapList("partyId")); > > fieldsToSelect.add("firstName"); > fieldsToSelect.add("lastName"); > > dynamicView.addMemberEntity("PC", "PartyContactMech"); > dynamicView.addMemberEntity("CM", "ContactMech"); > dynamicView.addMemberEntity("TM", "TelecomNumber"); > dynamicView.addAlias("PC", "contactMechId"); > dynamicView.addAlias("CM", "infoString"); > dynamicView.addAlias("TM", "countryCode"); > dynamicView.addAlias("TM", "areaCode"); > dynamicView.addAlias("TM", "contactNumber"); > dynamicView.addViewLink("PT", "PC", Boolean.FALSE, > ModelKeyMap.makeKeyMapList("partyId")); > dynamicView.addViewLink("PC", "CM", Boolean.FALSE, > ModelKeyMap.makeKeyMapList("contactMechId")); > dynamicView.addViewLink("PC", "TM", Boolean.FALSE, > ModelKeyMap.makeKeyMapList("contactMechId")); > > fieldsToSelect.add("infoString"); > fieldsToSelect.add("contactNumber"); > fieldsToSelect.add("areaCode"); > fieldsToSelect.add("countryCode"); > > > in ftl file if i display partyLists.infoSting is display null because for > telecomNumber there is no infoString value in corresponding column of > contactMech table. > |
|
|
Thanks for suggestion....
|
|
|
In reply to this post by Nalin Chandra
Hi,
I think this code will helpful for you /* * Licensed to the Apache Software Foundation (ASF) under one * or more contributor license agreements. See the NOTICE file * distributed with this work for additional information * regarding copyright ownership. The ASF licenses this file * to you under the Apache License, Version 2.0 (the * "License"); you may not use this file except in compliance * with the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. */ import java.util.*; import org.ofbiz.entity.*; import org.ofbiz.entity.util.EntityUtil; import org.ofbiz.base.util.*; import org.ofbiz.securityext.login.*; import org.ofbiz.common.*; import org.ofbiz.party.contact.*; import org.ofbiz.party.party.*; import org.ofbiz.accounting.payment.*; import org.ofbiz.securityext.login.*; if(partyList != null) { partyListIt = partyList.iterator(); FileWriter fw = new FileWriter("E:\\RAF02Nov\\skp.csv"); fw.append("partyId"); fw.append(','); fw.append("toName"); fw.append(','); fw.append("attnName"); fw.append(','); fw.append("Address1"); fw.append(','); fw.append("Address2"); fw.append(','); fw.append("City"); fw.append(','); fw.append("PostalCode"); fw.append(','); fw.append("State"); fw.append(','); fw.append("Country"); fw.append(','); fw.append("Full Name"); fw.append('\n'); while(partyListIt.hasNext()) { fullName = ""; toName = ""; attnName =""; address1 = ""; address2 = ""; city = ""; state= ""; country = ""; postalCode = ""; email = ""; phone =""; genericPartyList = partyListIt.next(); partyId = genericPartyList.getString("partyId"); List partyContactMechValueMaps = ContactMechWorker.getPartyContactMechValueMaps(delegator, partyId, false); Iterator contactMechIt = partyContactMechValueMaps.iterator(); while(contactMechIt.hasNext()) { contactMechGV = contactMechIt.next(); otherValues = PartyWorker.getPartyOtherValues(request, partyId, "party", "lookupPerson", "lookupGroup"); lookupPerson = otherValues.get("lookupPerson"); if(lookupPerson != null) { if(lookupPerson.get("firstName") != null) fullName += lookupPerson.get("firstName"); if(lookupPerson.get("middleName") != null) fullName +=" "+lookupPerson.get("middleName"); if(lookupPerson.get("lastName") != null) fullName +=" "+lookupPerson.get("lastName"); if(lookupPerson.get("suffix") != null) fullName +=" "+lookupPerson.get("suffix"); } else { fullName += " "; } contactMech1 = contactMechGV.get("contactMech"); if("POSTAL_ADDRESS".equals(contactMech1.getString("contactMechTypeId"))) { postalAddress = contactMechGV.get("postalAddress"); if( postalAddress.get("toName") != null) { toName += postalAddress.get("toName").replace(","," "); } if(postalAddress.get("attnName") != null) { attnName += " "+postalAddress.get("attnName").replace(","," "); } address1 +=" "+postalAddress.get("address1").replace(","," "); if(postalAddress.get("address2") != null) { address2 += " "+postalAddress.get("address2").replace(","," "); } city +=" "+postalAddress.get("city").replace(","," "); postalCode += " "+postalAddress.get("postalCode").replace(","," "); if(postalAddress.get("stateProvinceGeoId") != null) { state +=" "+postalAddress.getRelatedOneCache("StateProvinceGeo").get("abbreviation").replace(","," "); } if(postalAddress.get("countryGeoId") != null) { country +=" "+postalAddress.getRelatedOneCache("CountryGeo").get("geoName").replace(","," "); } } if("EMAIL_ADDRESS".equals(contactMech1.getString("contactMechTypeId"))) { email += contactMech1.getString("infoString")+"/"; } if("TELECOM_NUMBER".equals(contactMech1.getString("contactMechTypeId"))) { telecomNumber = contactMechGV.get("telecomNumber"); if(telecomNumber.get("areaCode") != null) phone += telecomNumber.get("areaCode").trim(); phone += telecomNumber.get("contactNumber").trim(); // if(telecomNumber.partyContactMech.get("extension") != null) // phone += telecomNumber.partyContactMech.get("extension"); } // print(" partyId "+partyId+" email "+email+" fullName "+fullName+" address "+address+" phone "+phone); } fw.append(partyId); fw.append(','); fw.append(toName); fw.append(','); fw.append(attnName); fw.append(','); fw.append(address1); fw.append(','); fw.append(address2); fw.append(','); fw.append(city); fw.append(','); fw.append(postalCode); fw.append(','); fw.append(state); fw.append(','); fw.append(country); fw.append(','); fw.append(fullName); fw.append('\n'); fw.flush(); // fw.close(); //response.sendRedirect("control/main"); } } On Wed, Dec 3, 2008 at 2:05 AM, nalin chandra < [hidden email]> wrote: > > i use CSV reporting in ofbiz > > As we all know, we can display data of only one list in the form. > > so i use view entity to display data of multiple table. > now i have one problem. > > i want to display the detail of party like name, address, email, contact > number etc. > for this purpose i create a view entity but it only display the email id or > telephone number because contactMechId id different for those two, so > please > help me on this issue.. > > below i paste the view entity code which i use for this purpose:- > > DynamicViewEntity dynamicView = new DynamicViewEntity(); > List orderBy = FastList.newInstance(); > List fieldsToSelect = FastList.newInstance(); > > dynamicView.addMemberEntity("PT", "Party"); > dynamicView.addAlias("PT", "partyId"); > dynamicView.addAlias("PT", "statusId"); > dynamicView.addAlias("PT", "partyTypeId"); > dynamicView.addAlias("PT", "createdDate"); > dynamicView.addRelation("one-nofk", "", "PartyType", > ModelKeyMap.makeKeyMapList("partyTypeId")); > dynamicView.addRelation("many", "", "UserLogin", > ModelKeyMap.makeKeyMapList("partyId")); > > > fieldsToSelect.add("partyId"); > fieldsToSelect.add("statusId"); > fieldsToSelect.add("partyTypeId"); > fieldsToSelect.add("createdDate"); > orderBy.add("createdDate"); > > dynamicView.addMemberEntity("PDS", "PartyDataSource"); > dynamicView.addAlias("PDS", "visitId"); > dynamicView.addViewLink("PT", "PDS", Boolean.FALSE, > ModelKeyMap.makeKeyMapList("partyId")); > > fieldsToSelect.add("visitId"); > > dynamicView.addMemberEntity("UL", "UserLogin"); > dynamicView.addAlias("UL", "userLoginId"); > dynamicView.addViewLink("PT", "UL", Boolean.FALSE, > ModelKeyMap.makeKeyMapList("partyId")); > > fieldsToSelect.add("userLoginId"); > > dynamicView.addMemberEntity("PE", "Person"); > dynamicView.addAlias("PE", "firstName"); > dynamicView.addAlias("PE", "lastName"); > dynamicView.addViewLink("PT", "PE", Boolean.FALSE, > ModelKeyMap.makeKeyMapList("partyId")); > > fieldsToSelect.add("firstName"); > fieldsToSelect.add("lastName"); > > dynamicView.addMemberEntity("PC", "PartyContactMech"); > dynamicView.addMemberEntity("CM", "ContactMech"); > dynamicView.addMemberEntity("TM", "TelecomNumber"); > dynamicView.addAlias("PC", "contactMechId"); > dynamicView.addAlias("CM", "infoString"); > dynamicView.addAlias("TM", "countryCode"); > dynamicView.addAlias("TM", "areaCode"); > dynamicView.addAlias("TM", "contactNumber"); > dynamicView.addViewLink("PT", "PC", Boolean.FALSE, > ModelKeyMap.makeKeyMapList("partyId")); > dynamicView.addViewLink("PC", "CM", Boolean.FALSE, > ModelKeyMap.makeKeyMapList("contactMechId")); > dynamicView.addViewLink("PC", "TM", Boolean.FALSE, > ModelKeyMap.makeKeyMapList("contactMechId")); > > fieldsToSelect.add("infoString"); > fieldsToSelect.add("contactNumber"); > fieldsToSelect.add("areaCode"); > fieldsToSelect.add("countryCode"); > > > in ftl file if i display partyLists.infoSting is display null because for > telecomNumber there is no infoString value in corresponding column of > contactMech table. > > -- > View this message in context: > http://www.nabble.com/CSV-reporting..-tp20800340p20800340.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > > -- With regards, S K Pradeep kumar |
|
|
you can put this in the FAQ tips and tricks wiki.
http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo S K Pradeep kumar sent the following on 12/3/2008 1:44 AM: > Hi, > > I think this code will helpful for you > > /* > * Licensed to the Apache Software Foundation (ASF) under one > * or more contributor license agreements. See the NOTICE file > * distributed with this work for additional information > * regarding copyright ownership. The ASF licenses this file > * to you under the Apache License, Version 2.0 (the > * "License"); you may not use this file except in compliance > * with the License. You may obtain a copy of the License at > * > * http://www.apache.org/licenses/LICENSE-2.0 > * > * Unless required by applicable law or agreed to in writing, > * software distributed under the License is distributed on an > * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY > * KIND, either express or implied. See the License for the > * specific language governing permissions and limitations > * under the License. > */ > > import java.util.*; > import org.ofbiz.entity.*; > import org.ofbiz.entity.util.EntityUtil; > import org.ofbiz.base.util.*; > import org.ofbiz.securityext.login.*; > import org.ofbiz.common.*; > > import org.ofbiz.party.contact.*; > import org.ofbiz.party.party.*; > import org.ofbiz.accounting.payment.*; > import org.ofbiz.securityext.login.*; > > > if(partyList != null) > { > partyListIt = partyList.iterator(); > FileWriter fw = new FileWriter("E:\\RAF02Nov\\skp.csv"); > fw.append("partyId"); > fw.append(','); > fw.append("toName"); > fw.append(','); > fw.append("attnName"); > fw.append(','); > fw.append("Address1"); > fw.append(','); > fw.append("Address2"); > fw.append(','); > fw.append("City"); > fw.append(','); > fw.append("PostalCode"); > fw.append(','); > fw.append("State"); > fw.append(','); > fw.append("Country"); > fw.append(','); > fw.append("Full Name"); > fw.append('\n'); > while(partyListIt.hasNext()) > { > fullName = ""; > toName = ""; > attnName =""; > address1 = ""; > address2 = ""; > city = ""; > state= ""; > country = ""; > postalCode = ""; > email = ""; > phone =""; > genericPartyList = partyListIt.next(); > partyId = genericPartyList.getString("partyId"); > > List partyContactMechValueMaps = > ContactMechWorker.getPartyContactMechValueMaps(delegator, partyId, false); > Iterator contactMechIt = partyContactMechValueMaps.iterator(); > while(contactMechIt.hasNext()) > { > contactMechGV = contactMechIt.next(); > otherValues = PartyWorker.getPartyOtherValues(request, > partyId, "party", "lookupPerson", "lookupGroup"); > lookupPerson = otherValues.get("lookupPerson"); > > if(lookupPerson != null) > { > if(lookupPerson.get("firstName") != null) > fullName += lookupPerson.get("firstName"); > if(lookupPerson.get("middleName") != null) > fullName +=" "+lookupPerson.get("middleName"); > if(lookupPerson.get("lastName") != null) > fullName +=" "+lookupPerson.get("lastName"); > if(lookupPerson.get("suffix") != null) > fullName +=" "+lookupPerson.get("suffix"); > } > else > { > fullName += " "; > } > contactMech1 = contactMechGV.get("contactMech"); > > if("POSTAL_ADDRESS".equals(contactMech1.getString("contactMechTypeId"))) > { > postalAddress = contactMechGV.get("postalAddress"); > if( postalAddress.get("toName") != null) > { > toName += postalAddress.get("toName").replace(","," "); > } > if(postalAddress.get("attnName") != null) > { > attnName += " > "+postalAddress.get("attnName").replace(","," "); > } > address1 +=" "+postalAddress.get("address1").replace(","," > "); > if(postalAddress.get("address2") != null) > { > address2 += " > "+postalAddress.get("address2").replace(","," "); > } > city +=" "+postalAddress.get("city").replace(","," "); > postalCode += " > "+postalAddress.get("postalCode").replace(","," "); > if(postalAddress.get("stateProvinceGeoId") != null) > { > state +=" > "+postalAddress.getRelatedOneCache("StateProvinceGeo").get("abbreviation").replace(","," > "); > } > if(postalAddress.get("countryGeoId") != null) > { > country +=" > "+postalAddress.getRelatedOneCache("CountryGeo").get("geoName").replace(","," > "); > } > } > > if("EMAIL_ADDRESS".equals(contactMech1.getString("contactMechTypeId"))) > { > email += contactMech1.getString("infoString")+"/"; > } > > if("TELECOM_NUMBER".equals(contactMech1.getString("contactMechTypeId"))) > { > telecomNumber = contactMechGV.get("telecomNumber"); > if(telecomNumber.get("areaCode") != null) > phone += telecomNumber.get("areaCode").trim(); > > phone += telecomNumber.get("contactNumber").trim(); > > // if(telecomNumber.partyContactMech.get("extension") != > null) > // phone += > telecomNumber.partyContactMech.get("extension"); > } > // print(" partyId "+partyId+" email "+email+" fullName > "+fullName+" address "+address+" phone "+phone); > } > fw.append(partyId); > fw.append(','); > fw.append(toName); > fw.append(','); > fw.append(attnName); > fw.append(','); > fw.append(address1); > fw.append(','); > fw.append(address2); > fw.append(','); > fw.append(city); > fw.append(','); > fw.append(postalCode); > fw.append(','); > fw.append(state); > fw.append(','); > fw.append(country); > fw.append(','); > fw.append(fullName); > fw.append('\n'); > > fw.flush(); > // fw.close(); > //response.sendRedirect("control/main"); > } > } > > > > > > > On Wed, Dec 3, 2008 at 2:05 AM, nalin chandra < > [hidden email]> wrote: > >> i use CSV reporting in ofbiz >> >> As we all know, we can display data of only one list in the form. >> >> so i use view entity to display data of multiple table. >> now i have one problem. >> >> i want to display the detail of party like name, address, email, contact >> number etc. >> for this purpose i create a view entity but it only display the email id or >> telephone number because contactMechId id different for those two, so >> please >> help me on this issue.. >> >> below i paste the view entity code which i use for this purpose:- >> >> DynamicViewEntity dynamicView = new DynamicViewEntity(); >> List orderBy = FastList.newInstance(); >> List fieldsToSelect = FastList.newInstance(); >> >> dynamicView.addMemberEntity("PT", "Party"); >> dynamicView.addAlias("PT", "partyId"); >> dynamicView.addAlias("PT", "statusId"); >> dynamicView.addAlias("PT", "partyTypeId"); >> dynamicView.addAlias("PT", "createdDate"); >> dynamicView.addRelation("one-nofk", "", "PartyType", >> ModelKeyMap.makeKeyMapList("partyTypeId")); >> dynamicView.addRelation("many", "", "UserLogin", >> ModelKeyMap.makeKeyMapList("partyId")); >> >> >> fieldsToSelect.add("partyId"); >> fieldsToSelect.add("statusId"); >> fieldsToSelect.add("partyTypeId"); >> fieldsToSelect.add("createdDate"); >> orderBy.add("createdDate"); >> >> dynamicView.addMemberEntity("PDS", "PartyDataSource"); >> dynamicView.addAlias("PDS", "visitId"); >> dynamicView.addViewLink("PT", "PDS", Boolean.FALSE, >> ModelKeyMap.makeKeyMapList("partyId")); >> >> fieldsToSelect.add("visitId"); >> >> dynamicView.addMemberEntity("UL", "UserLogin"); >> dynamicView.addAlias("UL", "userLoginId"); >> dynamicView.addViewLink("PT", "UL", Boolean.FALSE, >> ModelKeyMap.makeKeyMapList("partyId")); >> >> fieldsToSelect.add("userLoginId"); >> >> dynamicView.addMemberEntity("PE", "Person"); >> dynamicView.addAlias("PE", "firstName"); >> dynamicView.addAlias("PE", "lastName"); >> dynamicView.addViewLink("PT", "PE", Boolean.FALSE, >> ModelKeyMap.makeKeyMapList("partyId")); >> >> fieldsToSelect.add("firstName"); >> fieldsToSelect.add("lastName"); >> >> dynamicView.addMemberEntity("PC", "PartyContactMech"); >> dynamicView.addMemberEntity("CM", "ContactMech"); >> dynamicView.addMemberEntity("TM", "TelecomNumber"); >> dynamicView.addAlias("PC", "contactMechId"); >> dynamicView.addAlias("CM", "infoString"); >> dynamicView.addAlias("TM", "countryCode"); >> dynamicView.addAlias("TM", "areaCode"); >> dynamicView.addAlias("TM", "contactNumber"); >> dynamicView.addViewLink("PT", "PC", Boolean.FALSE, >> ModelKeyMap.makeKeyMapList("partyId")); >> dynamicView.addViewLink("PC", "CM", Boolean.FALSE, >> ModelKeyMap.makeKeyMapList("contactMechId")); >> dynamicView.addViewLink("PC", "TM", Boolean.FALSE, >> ModelKeyMap.makeKeyMapList("contactMechId")); >> >> fieldsToSelect.add("infoString"); >> fieldsToSelect.add("contactNumber"); >> fieldsToSelect.add("areaCode"); >> fieldsToSelect.add("countryCode"); >> >> >> in ftl file if i display partyLists.infoSting is display null because for >> telecomNumber there is no infoString value in corresponding column of >> contactMech table. >> >> -- >> View this message in context: >> http://www.nabble.com/CSV-reporting..-tp20800340p20800340.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> >> > > |
|
|
In reply to this post by S K Pradeep kumar
hi..
thanks for your contribution .. but main things is how to prepare the partyList your code is good but it display the all information of single party, but i want to display the list of party registered with us in certain time period with their detail. i think now you understand my problem.
|
Administrator
|
In reply to this post by BJ Freeman
Done, I quickly reformated the code
http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-Miscellaneous Jacques From: "BJ Freeman" <[hidden email]> > you can put this in the FAQ tips and tricks wiki. > http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo > > S K Pradeep kumar sent the following on 12/3/2008 1:44 AM: >> Hi, >> >> I think this code will helpful for you >> >> /* >> * Licensed to the Apache Software Foundation (ASF) under one >> * or more contributor license agreements. See the NOTICE file >> * distributed with this work for additional information >> * regarding copyright ownership. The ASF licenses this file >> * to you under the Apache License, Version 2.0 (the >> * "License"); you may not use this file except in compliance >> * with the License. You may obtain a copy of the License at >> * >> * http://www.apache.org/licenses/LICENSE-2.0 >> * >> * Unless required by applicable law or agreed to in writing, >> * software distributed under the License is distributed on an >> * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY >> * KIND, either express or implied. See the License for the >> * specific language governing permissions and limitations >> * under the License. >> */ >> >> import java.util.*; >> import org.ofbiz.entity.*; >> import org.ofbiz.entity.util.EntityUtil; >> import org.ofbiz.base.util.*; >> import org.ofbiz.securityext.login.*; >> import org.ofbiz.common.*; >> >> import org.ofbiz.party.contact.*; >> import org.ofbiz.party.party.*; >> import org.ofbiz.accounting.payment.*; >> import org.ofbiz.securityext.login.*; >> >> >> if(partyList != null) >> { >> partyListIt = partyList.iterator(); >> FileWriter fw = new FileWriter("E:\\RAF02Nov\\skp.csv"); >> fw.append("partyId"); >> fw.append(','); >> fw.append("toName"); >> fw.append(','); >> fw.append("attnName"); >> fw.append(','); >> fw.append("Address1"); >> fw.append(','); >> fw.append("Address2"); >> fw.append(','); >> fw.append("City"); >> fw.append(','); >> fw.append("PostalCode"); >> fw.append(','); >> fw.append("State"); >> fw.append(','); >> fw.append("Country"); >> fw.append(','); >> fw.append("Full Name"); >> fw.append('\n'); >> while(partyListIt.hasNext()) >> { >> fullName = ""; >> toName = ""; >> attnName =""; >> address1 = ""; >> address2 = ""; >> city = ""; >> state= ""; >> country = ""; >> postalCode = ""; >> email = ""; >> phone =""; >> genericPartyList = partyListIt.next(); >> partyId = genericPartyList.getString("partyId"); >> >> List partyContactMechValueMaps = >> ContactMechWorker.getPartyContactMechValueMaps(delegator, partyId, false); >> Iterator contactMechIt = partyContactMechValueMaps.iterator(); >> while(contactMechIt.hasNext()) >> { >> contactMechGV = contactMechIt.next(); >> otherValues = PartyWorker.getPartyOtherValues(request, >> partyId, "party", "lookupPerson", "lookupGroup"); >> lookupPerson = otherValues.get("lookupPerson"); >> >> if(lookupPerson != null) >> { >> if(lookupPerson.get("firstName") != null) >> fullName += lookupPerson.get("firstName"); >> if(lookupPerson.get("middleName") != null) >> fullName +=" "+lookupPerson.get("middleName"); >> if(lookupPerson.get("lastName") != null) >> fullName +=" "+lookupPerson.get("lastName"); >> if(lookupPerson.get("suffix") != null) >> fullName +=" "+lookupPerson.get("suffix"); >> } >> else >> { >> fullName += " "; >> } >> contactMech1 = contactMechGV.get("contactMech"); >> >> if("POSTAL_ADDRESS".equals(contactMech1.getString("contactMechTypeId"))) >> { >> postalAddress = contactMechGV.get("postalAddress"); >> if( postalAddress.get("toName") != null) >> { >> toName += postalAddress.get("toName").replace(","," "); >> } >> if(postalAddress.get("attnName") != null) >> { >> attnName += " >> "+postalAddress.get("attnName").replace(","," "); >> } >> address1 +=" "+postalAddress.get("address1").replace(","," >> "); >> if(postalAddress.get("address2") != null) >> { >> address2 += " >> "+postalAddress.get("address2").replace(","," "); >> } >> city +=" "+postalAddress.get("city").replace(","," "); >> postalCode += " >> "+postalAddress.get("postalCode").replace(","," "); >> if(postalAddress.get("stateProvinceGeoId") != null) >> { >> state +=" >> "+postalAddress.getRelatedOneCache("StateProvinceGeo").get("abbreviation").replace(","," >> "); >> } >> if(postalAddress.get("countryGeoId") != null) >> { >> country +=" >> "+postalAddress.getRelatedOneCache("CountryGeo").get("geoName").replace(","," >> "); >> } >> } >> >> if("EMAIL_ADDRESS".equals(contactMech1.getString("contactMechTypeId"))) >> { >> email += contactMech1.getString("infoString")+"/"; >> } >> >> if("TELECOM_NUMBER".equals(contactMech1.getString("contactMechTypeId"))) >> { >> telecomNumber = contactMechGV.get("telecomNumber"); >> if(telecomNumber.get("areaCode") != null) >> phone += telecomNumber.get("areaCode").trim(); >> >> phone += telecomNumber.get("contactNumber").trim(); >> >> // if(telecomNumber.partyContactMech.get("extension") != >> null) >> // phone += >> telecomNumber.partyContactMech.get("extension"); >> } >> // print(" partyId "+partyId+" email "+email+" fullName >> "+fullName+" address "+address+" phone "+phone); >> } >> fw.append(partyId); >> fw.append(','); >> fw.append(toName); >> fw.append(','); >> fw.append(attnName); >> fw.append(','); >> fw.append(address1); >> fw.append(','); >> fw.append(address2); >> fw.append(','); >> fw.append(city); >> fw.append(','); >> fw.append(postalCode); >> fw.append(','); >> fw.append(state); >> fw.append(','); >> fw.append(country); >> fw.append(','); >> fw.append(fullName); >> fw.append('\n'); >> >> fw.flush(); >> // fw.close(); >> //response.sendRedirect("control/main"); >> } >> } >> >> >> >> >> >> >> On Wed, Dec 3, 2008 at 2:05 AM, nalin chandra < >> [hidden email]> wrote: >> >>> i use CSV reporting in ofbiz >>> >>> As we all know, we can display data of only one list in the form. >>> >>> so i use view entity to display data of multiple table. >>> now i have one problem. >>> >>> i want to display the detail of party like name, address, email, contact >>> number etc. >>> for this purpose i create a view entity but it only display the email id or >>> telephone number because contactMechId id different for those two, so >>> please >>> help me on this issue.. >>> >>> below i paste the view entity code which i use for this purpose:- >>> >>> DynamicViewEntity dynamicView = new DynamicViewEntity(); >>> List orderBy = FastList.newInstance(); >>> List fieldsToSelect = FastList.newInstance(); >>> >>> dynamicView.addMemberEntity("PT", "Party"); >>> dynamicView.addAlias("PT", "partyId"); >>> dynamicView.addAlias("PT", "statusId"); >>> dynamicView.addAlias("PT", "partyTypeId"); >>> dynamicView.addAlias("PT", "createdDate"); >>> dynamicView.addRelation("one-nofk", "", "PartyType", >>> ModelKeyMap.makeKeyMapList("partyTypeId")); >>> dynamicView.addRelation("many", "", "UserLogin", >>> ModelKeyMap.makeKeyMapList("partyId")); >>> >>> >>> fieldsToSelect.add("partyId"); >>> fieldsToSelect.add("statusId"); >>> fieldsToSelect.add("partyTypeId"); >>> fieldsToSelect.add("createdDate"); >>> orderBy.add("createdDate"); >>> >>> dynamicView.addMemberEntity("PDS", "PartyDataSource"); >>> dynamicView.addAlias("PDS", "visitId"); >>> dynamicView.addViewLink("PT", "PDS", Boolean.FALSE, >>> ModelKeyMap.makeKeyMapList("partyId")); >>> >>> fieldsToSelect.add("visitId"); >>> >>> dynamicView.addMemberEntity("UL", "UserLogin"); >>> dynamicView.addAlias("UL", "userLoginId"); >>> dynamicView.addViewLink("PT", "UL", Boolean.FALSE, >>> ModelKeyMap.makeKeyMapList("partyId")); >>> >>> fieldsToSelect.add("userLoginId"); >>> >>> dynamicView.addMemberEntity("PE", "Person"); >>> dynamicView.addAlias("PE", "firstName"); >>> dynamicView.addAlias("PE", "lastName"); >>> dynamicView.addViewLink("PT", "PE", Boolean.FALSE, >>> ModelKeyMap.makeKeyMapList("partyId")); >>> >>> fieldsToSelect.add("firstName"); >>> fieldsToSelect.add("lastName"); >>> >>> dynamicView.addMemberEntity("PC", "PartyContactMech"); >>> dynamicView.addMemberEntity("CM", "ContactMech"); >>> dynamicView.addMemberEntity("TM", "TelecomNumber"); >>> dynamicView.addAlias("PC", "contactMechId"); >>> dynamicView.addAlias("CM", "infoString"); >>> dynamicView.addAlias("TM", "countryCode"); >>> dynamicView.addAlias("TM", "areaCode"); >>> dynamicView.addAlias("TM", "contactNumber"); >>> dynamicView.addViewLink("PT", "PC", Boolean.FALSE, >>> ModelKeyMap.makeKeyMapList("partyId")); >>> dynamicView.addViewLink("PC", "CM", Boolean.FALSE, >>> ModelKeyMap.makeKeyMapList("contactMechId")); >>> dynamicView.addViewLink("PC", "TM", Boolean.FALSE, >>> ModelKeyMap.makeKeyMapList("contactMechId")); >>> >>> fieldsToSelect.add("infoString"); >>> fieldsToSelect.add("contactNumber"); >>> fieldsToSelect.add("areaCode"); >>> fieldsToSelect.add("countryCode"); >>> >>> >>> in ftl file if i display partyLists.infoSting is display null because for >>> telecomNumber there is no infoString value in corresponding column of >>> contactMech table. >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/CSV-reporting..-tp20800340p20800340.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >>> >> >> > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |