const Nedb = require('nedb-promise')
const path = require('path')
const _ = require('lodash')
const dayjs = require('dayjs')

const db = new Nedb({
  filename: path.join(__dirname, `db/data.json`),
  autoload: true
})

const ids = [20, 11172, 11538, 11653, 9536, 9431, 2358, 11621, 11408, 14546, 11746, 2355, 8815, 9670, 8708]

Promise.all(ids.map(id => {
  return db.cfind({productId: id}).sort({date: 1}).exec().then(result => {
    const firstbuys = _.first(result).lastSoldList.map(r => r.icon)
    const first = _.first(result)
    const last = _.last(result)
    const buys = new Set(_.flatten(_.map(result, r => r.lastSoldList.map(r => r.icon))))
    const intrBuys = Array.from(buys).filter(r => !_.some(firstbuys, f => f === r))

    const group = _.groupBy(result, 'soldNum')


    const dates = _.map(Object.keys(group).sort(), (k) => {
      const item = _.first(group[k])
      return item
    })

    for (let i = 0; i < dates.length; i++) {
      if (dates[i + 1]) {
        const day = dayjs(dates[i].date)
        const nextDay = dayjs(dates[i + 1].date)
      }
    }

    let intrMax = 0
    for (let i = 0; i < result.length; i++) {
      if (i < result.length - 1) {
        const intr = result[i + 1].soldNum - result[i].soldNum
        const day = dayjs(result[i].date)
        const nextDay = dayjs(result[i + 1].date)

        if (intr >= 1) {
          // console.log(result[i + 1].date, nextDay.format('YYYY-MM-DD HH:mm'), result[i].date, intr)
        }

        intrMax = intr > intrMax ? intr : intrMax
      }
    }
    
    return `soldNum：${last.soldNum - first.soldNum}, buysNum：${intrBuys.length}, eq：${last.soldNum - first.soldNum === intrBuys.length}, productId：${id}, max：${intrMax}`
  })
})).then(result => {
  console.log(result)
})