Promise中使用了for循環(huán)后，不能獲取到最終結(jié)果，如果改為promise.all該如何修改

如下代碼，我其中使用了多次讀取數(shù)據(jù)庫，并且獲取到的數(shù)據(jù)在進(jìn)行循環(huán)，循環(huán)后在進(jìn)行數(shù)據(jù)庫查詢，最終resolve后，我得到的結(jié)果僅僅只是一小部分?jǐn)?shù)據(jù)，還剩余一部分?jǐn)?shù)據(jù)并未resolve，但是通過console.log可以打印出所有數(shù)據(jù)，resolv執(zhí)行的時候，其實for循環(huán)還未執(zhí)行完

getProducts(params) {
  return new Promise((resolve, reject) => {
    if (params) {
      this.getDb().then((db: SQLiteObject) => {
        db.transaction((run) => {
          var sql = 'SELECT * FROM product_content';
          run.executeSql(sql, [],
            (run, res) => {
              if (res.rows.length != 0) {
                let result = {
                   product_ids: {}
                };
                let retTmp = []
                let exTmp = [1,2,100,600,500,800,900,700,701,300]
                let categoryIds = []
                for (var i = 0; i < res.rows.length; i++) {
                  var product = res.rows.item(i);
                  categoryIds.push(product.categoryIds)
                  for (var k = 0; k < categoryIds.length; k++) {
                    var _cid = categoryIds[k]
                    sql = 'select id FROM product where category like "%,' + _cid + ',%"';
                    run.executeSql(sql, [],
                      (run, res_id) => {
                        if (res_id.rows.length != 0) {
                          for (var i = 0; i < res_id.rows.length; i++) {
                            var productId = res_id.rows.item(i).ID
                            retTmp.push(productId)
                          }
                        }
                      })
                  }
                }
                // setTimeout(() => {
                  let newRetTmp = Array.from(new Set(retTmp))
                  let newExTmp = Array.from(new Set())

                  if (newExTmp.length > 0) {
                    newRetTmp.map((rettmp, index) => {
                      exTmp.map(extmp => {
                        if (rettmp != extmp) {
                          result.product_ids[newRet] = true
                        }
                      })
                    })
                  }

                  resolve(result);
                // }, 500)
              } else {
                let result = {
                  data: {
                    product_ids: {}
                  }
                };
                resolve(result);
              }
            })
        })
      })
    }
  })
}

之前在網(wǎng)上看到使用Promise.all()的方法，我將其修改成如下代碼,代碼看上去沒有什么問題，但是一到Promise.all的地方就一直沒有resolve了：

getProducts(params) {
  return new Promise((resolve, reject) => {
    if (params) {
      this.getDb().then((db: SQLiteObject) => {
        db.transaction((run) => {
          var sql = 'SELECT * FROM product_content';
          run.executeSql(sql, [],
            (run, res) => {
              if (res.rows.length != 0) {
                let result = {
                    product_ids: {}
                };
                let retTmp = []
                let exTmp = [1,2,100,600,500,800,900,700,701,300]
                let categoryIds = []
                let promise = []
                for (var i = 0; i < res.rows.length; i++) {
promise.push(new Promise((resolve,reject)=>{
                  var product = res.rows.item(i);
                  categoryIds.push(product.categoryIds)
                  for (var k = 0; k < categoryIds.length; k++) {
                    var _cid = categoryIds[k]
                    sql = 'select id FROM product where category like "%,' + _cid + ',%"';
                    run.executeSql(sql, [],
                      (run, res_id) => {
                        if (res_id.rows.length != 0) {
                          for (var i = 0; i < res_id.rows.length; i++) {
                            var productId = res_id.rows.item(i).ID
                            retTmp.push(productId)
                            // this.helperService.console('c0', productId)
                          }
                        }
                      })
                  }
}))
                }
Promise.all(promise).then(res => {
              // setTimeout(() => {
                let ATmp = Array.from(new Set(retTmp))

                if (newExTmp.length > 0) {
                  exTmp.map((rettmp, index) => {
                    newExTmp.map(extmp => {
                      if (rettmp != extmp) {
                        result.product_ids[newRet] = true
                      }
                    })
                  })
                }
                resolve(result);
              // }, 500)
})
                
              } else {
                let result = {
                  data: {
                    product_ids: {}
                  }
                };
                resolve(result);
              }
            })
        })
      })
    }
  })
}

根據(jù)以上代碼，都無法得到想要的結(jié)果，第二種方法更是一直處于pendding狀態(tài)，真不知道該如何進(jìn)行解決，望各位大神支招