Solved

help formatting the array / data

Posted on 2013-05-31
7
316 Views
Last Modified: 2013-08-11
I have the following jquery code
$(document).ready(function () {
	var BankRows = "";
        var prefRows = "";
        var detailBankInfo;
        var BankactionInfo = {
            'entityCount' : {^SFT:PAC:BankList_Count^},
            'actualEntityId' : {^SFT:TRN:Bank ID^},	 
            'actualAppId' : {^SFT:APL:Applicant ID^}, 
            'actualType' : "{^SFT:TRN:Bankaction Sub Type^}", 
            'entityList' : []									 
			
        };
        if (BankactionInfo.entityCount == 0) { BankactionInfo.entityCount = 1; }

        if ({^SFT:PAC:ProductID|TRN:ProductPackage:blankreplace(0)^} > 0)
        {
	        {^DRP:PAC:BankList_Count|TRN:ProductPackage()
		   
			   detailBankInfo = {
                    'id' : "{^UDT:BankCode^}",
                    'entityCode' : 'TRN',
                    'type' : "{^CFT:TRN:CreditPayroll^}",
                    'BankType': "{^UDT:BankSubType^}"
                };
				 BankactionInfo.entityList.push(detailBankInfo);
            /DRP:PAC:BankList_Count^}
        };
	
        BankRows = createBankListing(BankactionInfo);
        $('#BankListing').append(BankRows);
    });

Open in new window


that generates the following array/data
transInfo =  {
                    'id' : "404828",
                    'entitycode' : "Credit Limit",
                    'type' : "01160",
                    'Bank': "ABC123"
               };
            
        transInfo =  {
                    'id' : "404821",
                    'entitycode' : "Credit Limit",
                    'type' : "01163",
                    'Bank': "DEF322"                };
                       
          transInfo =  {
                    'id' : "404338",
                    'entitycode' : "Debit Limit",
                    'type' : "03320",
                    'Bank': "XYZ223"
                };
           
           transInfo =  {
                    'id' : "45558",
                    'entitycode' : "Credit Limit",
                    'type' : "03230",
                    'Bank': "DEC445"
                };
            
            transInfo =  {
                    
                    'id' : "404831",
                    'entitycode' : "Credit Limit",
                    'type' : "08730",
                    'Bank': "DWC765"
                };

Open in new window


the first section of code retrieves the results from the db and loops through the reults and spits each record/data set out as a separate array.

My question is ... what do i need to change in the jquery section to output the data as follows?

transInfo =  {
                    'id' : "404828",
                    'entitycode' : "Credit Limit",
                    'type' : "01160",
                    'Bank': "ABC123"
               }, {
                    'id' : "404821",
                    'entitycode' : "Credit Limit",
                    'type' : "01163",
                    'Bank': "DEF322"
                }, {
                    'id' : "404338",
                    'entitycode' : "Debit Limit",
                    'type' : "03320",
                    'Bank': "XYZ223"
                }, {
                    'id' : "45558",
                    'entitycode' : "Credit Limit",
                    'type' : "03230",
                    'Bank': "DEC445"
                }, {
                   'id' : "404831",
                    'entitycode' : "Credit Limit",
                    'type' : "08730",
                    'Bank': "DWC765"
                };

Open in new window


Thanks
0
Comment
Question by:nriddock
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 75

Expert Comment

by:Michel Plungjan
ID: 39212533
You first script does not match the output. I do not see a loop and I see no transinfo anywhere
Also you likely want
Transinfo = [
   {
    },
    {
     }
];
0
 

Accepted Solution

by:
nriddock earned 0 total points
ID: 39229550
Sorry for the mixup. Heres the updated code

$(document).ready(function () {
	var BankRows = "";
        var prefRows = "";
        var detailTransInfo;
        var transactionInfo = {
            'entityCount' : {^SFT:PAC:BankList_Count^},
            'actualEntityId' : {^SFT:TRN:Bank ID^},	 
            'actualAppId' : {^SFT:APL:Applicant ID^}, 
            'actualType' : "{^SFT:TRN:Bankaction Sub Type^}", 
            'entityList' : []									 
			
        };
        if (transactionInfo.entityCount == 0) { transactionInfo.entityCount = 1; }

        if ({^SFT:PAC:ProductID|TRN:ProductPackage:blankreplace(0)^} > 0)
        {
	        {^DRP:PAC:BankList_Count|TRN:ProductPackage()
		   
	detailTransInfo = {
                    'id' : "{^UDT:BankCode^}",
                    'entityCode' : 'TRN',
                    'type' : "{^CFT:TRN:CreditPayroll^}",
                    'BankType': "{^UDT:BankSubType^}"
                };
				 transactionInfo.entityList.push(detailTransInfo);
            /DRP:PAC:TransList_Count^}
        };
	
        BankRows = createBankListing(transactionInfo);
        $('#BankListing').append(BankRows);
    });

Open in new window


This is the output it produces
detailTransInfo  =  {
                    'id' : "404828",
                    'entitycode' : "Credit Limit",
                    'type' : "01160",
                    'Bank': "ABC123"
               };
            
        detailTransInfo =  {
                    'id' : "404821",
                    'entitycode' : "Credit Limit",
                    'type' : "01163",
                    'Bank': "DEF322"                };
                       
          detailTransInfo  =  {
                    'id' : "404338",
                    'entitycode' : "Debit Limit",
                    'type' : "03320",
                    'Bank': "XYZ223"
                };
           
           detailTransInfo =  {
                    'id' : "45558",
                    'entitycode' : "Credit Limit",
                    'type' : "03230",
                    'Bank': "DEC445"
                };
            
            detailTransInfo =  {
                    
                    'id' : "404831",
                    'entitycode' : "Credit Limit",
                    'type' : "08730",
                    'Bank': "DWC765"
                };

Open in new window


This is how i need the output
detailTransInfo =  {
                    'id' : "404828",
                    'entitycode' : "Credit Limit",
                    'type' : "01160",
                    'Bank': "ABC123"
               }, {
                    'id' : "404821",
                    'entitycode' : "Credit Limit",
                    'type' : "01163",
                    'Bank': "DEF322"
                }, {
                    'id' : "404338",
                    'entitycode' : "Debit Limit",
                    'type' : "03320",
                    'Bank': "XYZ223"
                }, {
                    'id' : "45558",
                    'entitycode' : "Credit Limit",
                    'type' : "03230",
                    'Bank': "DEC445"
                }, {
                   'id' : "404831",
                    'entitycode' : "Credit Limit",
                    'type' : "08730",
                    'Bank': "DWC765"
                };

Open in new window

0
 
LVL 75

Expert Comment

by:Michel Plungjan
ID: 39229584
I do not understand what code this is. What's with the ^ ??

Assuming it is some kind of template scripting language I guess

THIS:               {^DRP:PAC:BankList_Count|TRN:ProductPackage()

is a loop

so something like


if ({^SFT:PAC:ProductID|TRN:ProductPackage:blankreplace(0)^} > 0)
        {
              {^DRP:PAC:BankList_Count|TRN:ProductPackage()
               
                  var x = {
                    'id' : "{^UDT:BankCode^}",
                    'entityCode' : 'TRN',
                    'type' : "{^CFT:TRN:CreditPayroll^}",
                    'BankType': "{^UDT:BankSubType^}"
                };
                         transactionInfo.entityList.push(x);
            /DRP:PAC:TransList_Count^}
        };
0
Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

 

Author Comment

by:nriddock
ID: 39229626
the ^ symbol signifies the code directly following is a "token" - internal code the vendor uses as a form of placeholder / variable., etc.

Ill give it a try. Thanks for all your help!
0
 

Author Comment

by:nriddock
ID: 39229646
its yielding the same results

its still writing
detailTransInfo  =  {
                    'id' : "404828",
                    'entitycode' : "Credit Limit",
                    'type' : "01160",
                    'Bank': "ABC123"
               };
            
        detailTransInfo =  {
                    'id' : "404821",
                    'entitycode' : "Credit Limit",
                    'type' : "01163",
                    'Bank': "DEF322"                };
                       

Open in new window

i need it to merge or combine the multiple "detailTransInfo" sections into one big "detailTransInfo"
detailTransInfo  =  {
                    'id' : "404828",
                    'entitycode' : "Credit Limit",
                    'type' : "01160",
                    'Bank': "ABC123"
               }; {
                    'id' : "404821",
                    'entitycode' : "Credit Limit",
                    'type' : "01163",
                    'Bank': "DEF322"                };
                       

Open in new window

0
 
LVL 75

Expert Comment

by:Michel Plungjan
ID: 39230388
I am sorry. Since I do not know the nature of the code you post, I cannot help  you.
Please let us know what framework you are using
0
 

Author Closing Comment

by:nriddock
ID: 39399515
i figured out a different method
0

Featured Post

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Requirements JQuery 1.6+ HTML CSS Introduction This article was inspired by an EE question (http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28372511.html) on how to make a page show some balloons animate up a page…
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question