使用 PHP 按键值比较 2 个 json 数组

Question

我有 2 个 json 数组，我想检查一个数组中的 sku 是否在另一个数组中找到，然后检查每个 sku 的数量值

JSON 1

 [
   {
     "sku": "888",
     "qty": "6.00",
     "price": "100"
   },
   {
     "sku": "999",
     "qty": 1,
     "price": "40"
   },
   {
    "sku": "555",
    "qty": "2.00",
    "price": "50"
   }
 ]

JSON 2

[
  {
    "sku": "888",
    "qty": "6.00",
    "price": "100"
  },
  {
    "sku": "999",
    "qty": "2.00",
    "price": "40"
  },
  {
    "sku": "444",
    "qty": "2.00",
    "price": "45"
  }
]

我需要知道 JSON 1 中的每个 SKU 是否存在在 JSON 2 中，如果是，则比较“qty”，如果不是，则执行某些操作，反之亦然。

我用来尝试演示输出的初始代码

<?php
$original_sale_details = '[{"sku":"888","qty":"6.00","price":"100"},{"sku":"999","qty":1,"price":"40"},{"sku":"555","qty":"2.00","price":"50"}]';
$values = json_decode($original_sale_details, true);

$new_sale2 = '[{"sku":"888","qty":"6.00","price":"100"},{"sku":"999","qty":"2.00","price":"40"},{"sku":"444","qty":"2.00","price":"45"}]';
$new_sale = json_decode($new_sale2, true);

foreach ($values as $value)
{

    foreach ($new_sale as $ovalue)
    {

        if ($value['sku'] == $ovalue['sku'])
        {
            $oqty = $ovalue['qty'];
        }
        else
        {
            $oqty = 0;
        }
    }

    if ($value['qty'] == $oqty)
    {

        //do smth
        
    }
    elseif ($value['qty'] > $oqty)
    {
        //do smth
        
    }
    elseif ($value['qty'] < $oqty)
    {
        //do smth
        
    }

}
?>

如果数组中只有 1 个 sku，则效果很好，但一旦添加更多 SKU，其他 SKU“$oqty”的数量为 0

如何解决这个问题？有没有什么功能可以轻松地做到这一点？

提前致谢

Answer 1

当您满足条件时，您需要中断第二个 foreach 循环，您可以通过 $isExist 变量的帮助来做到这一点。

像下面这样

<?php
$original_sale_details = '[{"sku":"888","qty":"6.00","price":"100"},{"sku":"999","qty":"1","price":"40"},{"sku":"555","qty":"2.00","price":"50"}]';
$values = json_decode($original_sale_details, true);

$new_sale2 = '[{"sku":"888","qty":"6.00","price":"100"},{"sku":"999","qty":"2.00","price":"40"},{"sku":"444","qty":"2.00","price":"45"}]';
$new_sale = json_decode($new_sale2, true);

foreach ($values as $value)
{
    $isExist = false;
    foreach ($new_sale as $ovalue)
    {
      
      // if exist
      if ($value['sku'] == $ovalue['sku'])
      {
        // if equal
        if($ovalue['qty'] == $value['qty']){
            echo $value['sku']." is equal <br/>";
            $isExist = true;
            break;
        // if greater than
        }else if($ovalue['qty'] > $value['qty']){
            echo $value['sku']." is greater <br/>";
            $isExist = true;
            break;
        // if less than
        }else{
            echo $value['sku']." is less <br/>";
            $isExist = true;
            break;
        }
      // if not exist     
      }
      
    }
  
  if(!$isExist) echo $value['sku']." does not exist";

}
?>

Answer 2

您的错误是您正在检查第二次循环后的值。它总是取最后的结果。

<?php
$original_sale_details = '[{"sku":"888","qty":"6.00","price":"100"},{"sku":"999","qty":1,"price":"40"},{"sku":"555","qty":"2.00","price":"50"}]';
$values = json_decode($original_sale_details, true);

$new_sale2 = '[{"sku":"888","qty":"6.00","price":"100"},{"sku":"999","qty":"2.00","price":"40"},{"sku":"444","qty":"2.00","price":"45"}]';
$new_sale = json_decode($new_sale2, true);

foreach ($values as $value)
{

    foreach ($new_sale as $ovalue)
    {

        if ($value['sku'] == $ovalue['sku'])
        {
            $oqty = $ovalue['qty'];
        }
        else
        {
            $oqty = null;
        }

       /////////////////////////////////
       //section move here
       /////////////////////////////////
        if(is_null($oqty)) {
            echo "----------> QTY is null... Ignore this or remove echo or do something?<br>\n";
        }
        else {
           if ($value['qty'] == $oqty)
           {

               //do smth
               echo "QTY is equal...<br>\n";
            
           }
           elseif ($value['qty'] > $oqty)
           {
               //do smth
               echo "QTY is more...<br>\n";
            
           }
           elseif ($value['qty'] < $oqty)
           {
               //do smth
               echo "QTY is less...<br>\n";
            
           }
        }

       /////////////////////////////////
       //end section move here
       /////////////////////////////////

    }

    ///////////////////////////////////////
    // your code was here (moving code)
    ///////////////////////////////////////

}
?>