如何批量更新数据

SQL会很长，谨慎使用

/**
 * 批量更新
 * @param array $multipleData
 * @param $id
 * @return bool
 */
public function updateBatch ($multipleData = [], $id)
{
   //获取当前元素(第一个)
   $firstRow = current( $multipleData );
   //获取字段
   $updateColumn = array_keys( $firstRow );
   // 拼接sql语句
   $updateSql = 'UPDATE ' . $this->_table . ' SET ';
   $sets      = [];
   foreach ($updateColumn as $uColumn) {
      $setSql = $uColumn . ' = CASE ';
      foreach ($multipleData as $data) {
         $setSql .= ' WHEN ' . $id . ' = ' . $data[$id] . ' THEN ' . $data[$uColumn];
      }
      $setSql .= ' ELSE ' . $uColumn . ' END ';
      $sets[] = $setSql;
   }
   $updateSql .= implode( ', ', $sets );
   $whereIn   = implode( ',', array_column( $multipleData, $id ) );
   $updateSql = rtrim( $updateSql, ', ' ) . ' WHERE ' . $id . ' IN( ' . $whereIn . ' )';
   $this->_db->query( $updateSql );
   $rows = $this->_db->getAffectedRows();
   if (in_array( $rows, [-1, 0] )) {
      return false;
   }
   return $rows;
}

/**
* 批量更新
*/
public function test(){
    //本次更新数据
     $goodsScales = [
        [
        'id' => '商品id',
        'sales' => '销量数',
        ]
    ]
    $goodsIds=array_column($goodsScales,'id');//本次更新数据唯一字段
     $goodsWhen = self::batchUpdate($goodsScales, 'id', ['sales' => '+']);
     Goods::whereIn('id', $goodsIds)->update($goodsWhen);
}


/**
     * 拼接批量更新的sql语句
     *
     * @array $result 数据更新数组
     * @string $whenField 本次更新数据中不重复的数据库字段
     * @array $hierarchys 本次更新数据中需要加减的数组  ['num'=>'-']
     *
     * @return array
     */
    public static function batchUpdate(array $result = [], $whenField = 'id', $hierarchys = [])
    {
        $when = [];
        $update = collect($result);
        foreach ($update->all() as $sets) {
            $whenValue = $sets[$whenField];
            foreach ($sets as $fieldName => $value) {
                if ($fieldName == $whenField) {
                    continue;
                }
                if (is_null($value)) {
                    $value = ' ';
                }
                if (isset($hierarchys[$fieldName])) {
                    $value = $fieldName . $hierarchys[$fieldName] . $value;
                } else {
                    $value = "'" . $value . "'";
                }
                $when[$fieldName][] =
                    "when {$whenField} = '{$whenValue}' then " . $value;
            }
        }
        foreach ($when as $fieldName => &$item) {
            $item = DB::raw("case " . implode(' ', $item) . ' end ');
        }
        return $when;
    }