How can i write the below php code in javascript.?

Question

Hi i am working on converting a php application to continue billing even internet is not working. So i am converting the php codes to javascript. In between i got stuck at an area where my billing ends. Here i need to group the similar tax % to one. Can someone let me know how can it be done ?

$new_result = Array
(
    [0] => Array
        (
            [tax] => [email protected]%
            [percent] => 2.38
        )

    [1] => Array
        (
            [tax] => [email protected]%
            [percent] => 2.38
        )

    [2] => Array
        (
            [tax] => CGST@9%
            [percent] => 15.25
        )

    [3] => Array
        (
            [tax] => SGST@9%
            [percent] => 15.25
        )

    [4] => Array
        (
            [tax] => [email protected]%
            [percent] => 3.57
        )

    [5] => Array
        (
            [tax] => [email protected]%
            [percent] => 3.57
        )

)   

     $out = array();
        foreach ($new_result as $key => $value){
            if (array_key_exists($value['tax'], $out)){
                $out[$value['tax']]['percent'] += ', '+$value['percent'];
            } else {
               $out[$value['tax']] = array('tax' => $value['tax'], 'percent' => $value['percent']);
            }
        }

Output :

Array
(
    [0] => Array
        (
            [tax] => [email protected]%
            [percent] => 5.95
        )

    [1] => Array
        (
            [tax] => [email protected]%
            [percent] => 5.95
        )

    [2] => Array
        (
            [tax] => CGST@9%
            [percent] => 15.25
        )

    [3] => Array
        (
            [tax] => SGST@9%
            [percent] => 15.25
        )

)

My try :

    var out = [];
    $.each(new_result, function(key,value5) {
        if(value5.tax in out){
            //
        }else{
            out[value5.tax] = [{tax:value5.tax, percent:value5.percent}];
        }
    });

Input array

var newresult = [{"tax":"CGST@9%","percent":"76.27"},{"tax":"SGST@9%","percent":"76.27"},{"tax":"CGST@9%","percent":"15.25"},{"tax":"SGST@9%","percent":"15.25"},{"tax":"[email protected]%","percent":"3.57"},{"tax":"[email protected]%","percent":"3.57"}];

I want to group them based on the percentage value. And frankly i don't know that php snippet. it was done by previous developer — Sarath Hari
– Sarath Hari, Commented Sep 25, 2018 at 6:13
The PHP output you give does not correspond to the PHP code you have given. It would produce an associative array, not one with numerical indexes. — trincot
– trincot, Commented Sep 25, 2018 at 6:25
Also your PHP concatenates percentages, which is not anywhere present in your output. Could you please fix your output? — trincot
– trincot, Commented Sep 25, 2018 at 6:33

Sarath Hari · Accepted Answer · 2018-09-28 05:40:06Z

1

In javascript, you can use reduce function like below to group

var gst = [
  {tax: '[email protected]%', percent: 2.38},
  {tax: '[email protected]%', percent: 2.38},
  {tax: 'CGST@9%', percent: 15.25},
  {tax: 'SGST@9%', percent: 15.25},
  {tax: '[email protected]%', percent: 3.57},
  {tax: '[email protected]%', percent: 3.57}
];

var result = gst.reduce(function (acc, ele) {
  var index = acc.findIndex(e => e.tax == ele.tax);
  if (index == -1) {
    acc.push({
      tax: ele.tax,
      percent: ele.percent
    })
  } else {
    acc[index].percent += parseFloat(ele.percent);
    acc[index].percent = acc[index].percent;
  }
  return acc;
}, []);

console.log(result);

edited Sep 28, 2018 at 5:40

Sarath Hari

397 bronze badges

answered Sep 25, 2018 at 6:16

Sivakumar Tadisetti

5,0617 gold badges39 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Sarath Hari Over a year ago

When i constantly add 3 product of same tax group this code fails to add the percentage.

Sivakumar Tadisetti Over a year ago

@SarathHari, you can post the different question with the issue you are facing, then all SO guys and I can see that ;-)

Sarath Hari Over a year ago

But issue is in this same code bro @JavascriptLover-SKT

Sarath Hari Over a year ago

Uncaught TypeError: acc[index].percent.toFixed is not a function

Sarath Hari Over a year ago

Today is this project submission and i am still stuck in office

|

kapantzak · Accepted Answer · 2018-09-25 06:21:16Z

0

Assuming you have an array of objects in javascript (newResult), you can use reduce() function to produce the out array:

let newResult = [
   {
      tax: '[email protected]%',
      percent: 2.38 
   },
   {
      tax: '[email protected]%',
      percent: 2.38
   },
   {
      tax: '[email protected]%',
      percent: 15.25
   },
   {
      tax: '[email protected]%',
      percent: 3.57
   }
];

let out = newResult.reduce((acc, val) => {
   let existing = acc.filter((p) => p.tax === val.tax);
   if (existing.length === 1) {
      existing[0].percent += val.percent;
   } else {
      acc.push(val);
   }   
   return acc;
}, []);

console.log(out);

answered Sep 25, 2018 at 6:21

kapantzak

11.8k5 gold badges42 silver badges63 bronze badges

Comments

Sultan Khan · Accepted Answer · 2018-09-25 06:26:52Z

0

Or you can do the same by using JS as well,

    var myArray = [
  {tax: '[email protected]%', percent: 2.38},
  {tax: '[email protected]%', percent: 2.38},
  {tax: 'CGST@9%', percent: 15.25},
  {tax: 'SGST@9%', percent: 15.25},
  {tax: '[email protected]%', percent: 3.57},
  {tax: '[email protected]%', percent: 3.57}
];

var groups = {};
for (var i = 0; i < myArray.length; i++) {
  var groupName = myArray[i].tax;
  if (!groups[groupName]) {
    groups[groupName] = [];
  }
  groups[groupName].push(myArray[i].percent);
}
myArray = [];
for (var groupName in groups) {
  myArray.push({group: groupName, tax: groups[groupName]});
}

answered Sep 25, 2018 at 6:26

Sultan Khan

3283 silver badges11 bronze badges

Comments

trincot · Accepted Answer · 2018-09-25 06:31:49Z

The PHP output you give in your question does not correspond to the PHP code which you have given. That code would produce an associative array, where the keys are the tax codes, and the values would be comma separated strings. I will assume the code is correct and the PHP output is not.

In JavaScript you best translate PHP associative arrays to plain objects (or in ES6 you could use Map). With a plain object a quite literal conversion to JavaScript would look like this:

const newResult = [
    { tax: '[email protected]%', percent:  2.38 },
    { tax: '[email protected]%', percent:  2.38 },
    { tax: 'CGST@9%',   percent: 15.25 },
    { tax: 'SGST@9%',   percent: 15.25 },
    { tax: '[email protected]%', percent:  3.57 },
    { tax: '[email protected]%', percent:  3.57 }
];

const out = {}; // <== object
for (const value of newResult) {
    if (!(value.tax in out)) {
       out[value.tax] = Object.assign({}, value); // This copies all property values
    } else {
        out[value.tax].percent += ", " + value.percent; // Converts number to string
    }
}

console.log(out);

I would personally prefer to create percent values as arrays instead of comma separated strings when there is more than one matching percentage, but since you already made that choice in PHP I left it like that in JS also. I find it problematic that the way you did it, you're left with percent values that sometimes are numeric (when there is no aggregation) and sometimes are string (when multi-valued). Again, I leave this like you had it in PHP.

The output is what i got when i printed and your answer have percentage as comma separated

Collectives™ on Stack Overflow

How can i write the below php code in javascript.?

4 Answers 4

7 Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

7 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related