LintCode 551: Nested List Weight Sum

本文介绍了一种名为深度加权求和的算法,该算法用于处理嵌套的整数列表,通过递归的方式计算所有整数的加权总和,其中权重由元素的深度决定。文章提供了具体的代码实现,包括如何遍历嵌套列表并根据深度计算每个元素的权重。
  1. Nested List Weight Sum
    Given a nested list of integers, return the sum of all integers in the list weighted by their depth. Each element is either an integer, or a list – whose elements may also be integers or other lists.

Example
Given the list [[1,1],2,[1,1]], return 10. (four 1’s at depth 2, one 2 at depth 1, 4 * 1 * 2 + 1 * 2 * 1 = 10)
Given the list [1,[4,[6]]], return 27. (one 1 at depth 1, one 4 at depth 2, and one 6 at depth 3; 1 + 4 * 2 + 6 * 3 = 27)

思路:递归。
代码如下:

/**
 * // This is the interface that allows for creating nested lists.
 * // You should not implement it, or speculate about its implementation
 * class NestedInteger {
 *   public:
 *     // Return true if this NestedInteger holds a single integer,
 *     // rather than a nested list.
 *     bool isInteger() const;
 *
 *     // Return the single integer that this NestedInteger holds,
 *     // if it holds a single integer
 *     // The result is undefined if this NestedInteger holds a nested list
 *     int getInteger() const;
 *
 *     // Return the nested list that this NestedInteger holds,
 *     // if it holds a nested list
 *     // The result is undefined if this NestedInteger holds a single integer
 *     const vector<NestedInteger> &getList() const;
 * };
 */
class Solution {
public:
    int depthSum(const vector<NestedInteger>& nestedList) {
        int result = 0;
        
        for (auto i : nestedList) {
            result += helper(i, 1);
        }
        
        return result;
    }
    
    int helper(const NestedInteger &nestInt, int depth) {
        if (nestInt.isInteger()) return nestInt.getInteger() * depth;
        
        int len = nestInt.getList().size();
        int result = 0;
        vector<NestedInteger> nestList = nestInt.getList();
        for (int i = 0; i < len; ++i) {
            result += helper(nestList[i], (depth + 1));
        }
        return result;
    }
};
SELECT A.warehouseId, A.customerId, A.sku, SUM(A.qty) AS qty, ROUND(SUM(A.qty * BPD.weight), 3) AS grossWeight, ROUND(SUM(A.qty * BPD.length * BPD.width * BPD.height / 1000000), 3) AS cubic, ROUND(SUM(A.qty * BPD.length)) AS Length, ROUND(SUM(A.qty * BPD.width)) AS Width, ROUND(SUM(A.qty * BPD.height)) AS High, ILA.lotAtt06, ILA.lotAtt08, '123' AS invage, DAH.hedi04 AS QD, A.addTime, '' AS userDefine1, '' AS userDefine2, '' AS userDefine3, '' AS userDefine4, '' AS userDefine5, '' AS noteText FROM cus_inv_lot_loc_id A LEFT JOIN inv_lot_att ILA ON A.organizationId = ILA.organizationId AND A.lotNum = ILA.lotNum LEFT JOIN bas_package_details BPD ON ILA.organizationId = BPD.organizationId AND ILA.customerId = BPD.customerId AND ILA.lotAtt12 = BPD.packId AND BPD.packUom = 'EA' LEFT JOIN doc_asn_header DAH ON DAH.organizationId = ILA.organizationId AND DAH.warehouseId = A.warehouseId AND DAH.asnNo = ILA.lotAtt04 WHERE A.organizationId = 'BESTQI' AND A.warehouseId = 'AUSLAX01' AND A.customerId = 'BESTQI' AND 1 = 1 AND 1 = 1 AND A.addTime > DATE_FORMAT('2025-10-10 00:00:00', '%Y-%m-%d %H:%i:%s') AND A.addTime <= DATE_FORMAT('2025-10-13 00:00:00', '%Y-%m-%d %H:%i:%s') GROUP BY A.warehouseId, A.customerId, A.sku, ILA.lotAtt06, ILA.lotAtt08, DAH.hedi04, A.addTime ORDER BY A.addTime, A.sku, ILA.lotAtt06, ILA.lotAtt08, DAH.hedi04, A.warehouseId, A.customerId LIMIT 500这个SQL语句报错Parameter index out of bounds. 6 is not between valid values of 1 and 4; nested exception is java.sql.SQLException: Parameter index out of bounds. 6 is not between valid values of 1 and 4,帮忙分析一下是什么原因及调整步骤
10-14
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值