大数据中台-全网商品统计数据集

`product_id` int(11) '商品id',
`product_name` varchar(255) '商品名称',
`product_info` varchar(255) '商品介绍',
`img` varchar(255) '商品主图',
`unit` varchar(20) '单位',
`source` int(11) '商品来源：1自营2京东6阿里巴巴7天猫',
`category_name` varchar(255) '分类名称',
`brand_name` varchar(255) '品牌名称',
`origin` varchar(255) '产地来源',
`cost_price` decimal(10,2) '成本价',
`sale_price` decimal(10,2) '售价',
`market_price` decimal(10,2) '市场价',
`activity_price` decimal(10,2) '活动价',
`agreement_price` decimal(10,2) '协议价',
`guide_price` decimal(10,2) '指导价',
`sale` int(11) '销量',
`stock` int(11) '总库存',
`choose_count` int(11) '选品人数',
`activity_rate` decimal(10,2) '活动利润率',
`min_profits` decimal(10,2) '最小利润',
`max_profits` decimal(10,2) '最大利润',
`discount` decimal(10,2) '折扣',
`create_time` int(11) '上架时间'

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
order by
    a.sale desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
where source = 1
order by
    a.sale desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
where source = 2
order by
    a.sale desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
where source = 6
order by
    a.sale desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
where source = 7
order by
    a.sale desc
limit 100

SELECT
  '全部商品销售总额' AS 当前销售总额,
    SUM(a.sale*a.sale_price) AS 金额
FROM
    eb_echart_product AS a

SELECT
  '云仓商品销售总额' AS 当前销售总额,
    SUM(a.sale*a.sale_price) AS 金额
FROM
    eb_echart_product AS a
where source = 1

SELECT
  '京东商品销售总额' AS 当前销售总额,
    SUM(a.sale*a.sale_price) AS 金额
FROM
    eb_echart_product AS a
where source = 2

SELECT
  '阿里商品销售总额' AS 当前销售总额,
    SUM(a.sale*a.sale_price) AS 金额
FROM
    eb_echart_product AS a
where source = 6

SELECT
  '天猫商品销售总额' AS 当前销售总额,
    SUM(a.sale*a.sale_price) AS 金额
FROM
    eb_echart_product AS a
where source = 7

SELECT
  '全部商品总销售数量' AS 当前销售总数,
    SUM(a.sale) AS 数量
FROM
    eb_echart_product AS a

SELECT
  '云仓商品总销售数量' AS 当前销售总数,
    SUM(a.sale) AS 数量
FROM
    eb_echart_product AS a
where source = 1

SELECT
  '京东商品总销售数量' AS 当前销售总数,
    SUM(a.sale) AS 数量
FROM
    eb_echart_product AS a
where source = 2

SELECT
  '阿里商品总销售数量' AS 当前销售总数,
    SUM(a.sale) AS 数量
FROM
    eb_echart_product AS a
where source = 6

SELECT
  '天猫商品总销售数量' AS 当前销售总数,
    SUM(a.sale) AS 数量
FROM
    eb_echart_product AS a
where source = 7

SELECT
    '全部商品数量统计' AS 全部商品数量统计,
    count(a.product_id) AS 商品数量
FROM
    eb_echart_product AS a

SELECT
    '单独统计云仓商品数量' AS 单独统计云仓商品数量,
    count(a.product_id) AS 商品数量
FROM
    eb_echart_product AS a
WHERE
    a.source = 1

SELECT
    '单独统计京东商品数量' AS 单独统计京东商品数量,
    count(a.product_id) AS 商品数量
FROM
    eb_echart_product AS a
WHERE
    a.source = 2

SELECT
    '单独统计阿里商品数量' AS 单独统计阿里商品数量,
    count(a.product_id) AS 商品数量
FROM
    eb_echart_product AS a
WHERE
    a.source = 6

SELECT
    '单独统计天猫商品数量' AS 单独统计天猫商品数量,
    count(a.product_id) AS 商品数量
FROM
    eb_echart_product AS a
WHERE
    a.source = 7

SELECT
    (CASE WHEN source = 1 THEN '云仓' WHEN source = 2 THEN '京东' WHEN source = 6 THEN '阿里' ELSE '天猫' END ) AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0
GROUP BY
    source
ORDER BY
    source ASC
limit 4

SELECT
        (CASE WHEN source = 1 THEN '云仓' WHEN source = 2 THEN '京东' WHEN source = 6 THEN '阿里' ELSE '天猫' END ) AS 来源,
    SUM(sale*sale_price) as 销售客
FROM
    eb_echart_product
WHERE
    product_id > 0
GROUP BY
    source
ORDER BY
    source ASC
limit 4

SELECT
    (CASE WHEN source = 1 THEN '云仓' WHEN source = 2 THEN '京东' WHEN source = 6 THEN '阿里' ELSE '天猫' END ) AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0
GROUP BY
    source
ORDER BY
    source ASC
limit 4

SELECT
    category_name AS 分类,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !=''
GROUP BY
    category_name
ORDER BY
    数量 DESC
limit 100

SELECT
    category_name AS 分类,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !=''
GROUP BY
    category_name
ORDER BY
    销售额 DESC
limit 100

SELECT
    category_name AS 分类,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !=''
GROUP BY
    category_name
ORDER BY
    销售数量 DESC
limit 100

SELECT
        category_name AS 分类,
        source AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !='' and source = 1
GROUP BY
    category_name
ORDER BY
    数量 DESC
limit 100

SELECT
        category_name AS 分类,
        source AS 来源,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !='' and source = 1
GROUP BY
    category_name
ORDER BY
    销售额 DESC
limit 100

SELECT
        category_name AS 分类,
        source AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !='' and source = 1
GROUP BY
    category_name
ORDER BY
    销售数量 DESC
limit 100

SELECT
        category_name AS 分类,
        source AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !='' and source = 2
GROUP BY
    category_name
ORDER BY
    数量 DESC
limit 100

SELECT
        category_name AS 分类,
        source AS 来源,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !='' and source = 2
GROUP BY
    category_name
ORDER BY
    销售额 DESC
limit 100

SELECT
        category_name AS 分类,
        source AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !='' and source = 2
GROUP BY
    category_name
ORDER BY
    销售数量 DESC
limit 100

SELECT
        category_name AS 分类,
        source AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !='' and source = 6
GROUP BY
    category_name
ORDER BY
    数量 DESC
limit 100

SELECT
        category_name AS 分类,
        source AS 来源,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !='' and source = 6
GROUP BY
    category_name
ORDER BY
    销售额 DESC
limit 100

SELECT
        category_name AS 分类,
        source AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !='' and source = 6
GROUP BY
    category_name
ORDER BY
    销售数量 DESC
limit 100

SELECT
        category_name AS 分类,
        source AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !='' and source = 7
GROUP BY
    category_name
ORDER BY
    数量 DESC
limit 100

SELECT
        category_name AS 分类,
        source AS 来源,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !='' and source = 7
GROUP BY
    category_name
ORDER BY
    销售额 DESC
limit 100

SELECT
        category_name AS 分类,
        source AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and category_name !='' and source = 7
GROUP BY
    category_name
ORDER BY
    销售数量 DESC
limit 100

SELECT
        brand_name AS 品牌,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !=''
GROUP BY
    brand_name
ORDER BY
    数量 DESC
limit 100

SELECT
        brand_name AS 品牌,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !=''
GROUP BY
    brand_name
ORDER BY
    销售额 DESC
limit 100

SELECT
        brand_name AS 品牌,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !=''
GROUP BY
    brand_name
ORDER BY
    销售数量 DESC
limit 100

SELECT
        brand_name AS 品牌,
        source AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !='' and source = 1
GROUP BY
    brand_name
ORDER BY
    数量 DESC
limit 100

SELECT
        brand_name AS 品牌,
        source AS 来源,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !='' and source = 1
GROUP BY
    brand_name
ORDER BY
    销售额 DESC
limit 100

SELECT
        brand_name AS 品牌,
        source AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !='' and source = 1
GROUP BY
    brand_name
ORDER BY
    销售数量 DESC
limit 100

SELECT
        brand_name AS 品牌,
        source AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !='' and source = 2
GROUP BY
    brand_name
ORDER BY
    数量 DESC
limit 100

SELECT
        brand_name AS 品牌,
        source AS 来源,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !='' and source = 2
GROUP BY
    brand_name
ORDER BY
    销售额 DESC
limit 100

SELECT
        brand_name AS 品牌,
        source AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !='' and source = 2
GROUP BY
    brand_name
ORDER BY
    销售数量 DESC
limit 100

SELECT
        brand_name AS 品牌,
        source AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !='' and source = 6
GROUP BY
    brand_name
ORDER BY
    数量 DESC
limit 100

SELECT
        brand_name AS 品牌,
        source AS 来源,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !='' and source = 6
GROUP BY
    brand_name
ORDER BY
    销售额 DESC
limit 100

SELECT
        brand_name AS 品牌,
        source AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !='' and source = 6
GROUP BY
    brand_name
ORDER BY
    销售数量 DESC
limit 100

SELECT
        brand_name AS 品牌,
        source AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !='' and source = 7
GROUP BY
    brand_name
ORDER BY
    数量 DESC
limit 100

SELECT
        brand_name AS 品牌,
        source AS 来源,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !='' and source = 7
GROUP BY
    brand_name
ORDER BY
    销售额 DESC
limit 100

SELECT
        brand_name AS 品牌,
        source AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and brand_name !='' and source = 7
GROUP BY
    brand_name
ORDER BY
    销售数量 DESC
limit 100

SELECT
        origin AS 产地,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !=''
GROUP BY
    origin
ORDER BY
    数量 DESC
limit 100

SELECT
        origin AS 产地,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !=''
GROUP BY
    origin
ORDER BY
    销售额 DESC
limit 100

SELECT
        origin AS 产地,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !=''
GROUP BY
    origin
ORDER BY
    销售数量 DESC
limit 100

SELECT
        origin AS 产地,
        source AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !='' and source = 1
GROUP BY
    origin
ORDER BY
    数量 DESC
limit 100

SELECT
        origin AS 产地,
        source AS 来源,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !='' and source = 1
GROUP BY
    origin
ORDER BY
    销售额 DESC
limit 100

SELECT
        origin AS 产地,
        source AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !='' and source = 1
GROUP BY
    origin
ORDER BY
    销售数量 DESC
limit 100

SELECT
        origin AS 产地,
        source AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !='' and source = 2
GROUP BY
    origin
ORDER BY
    数量 DESC
limit 100

SELECT
        origin AS 产地,
        source AS 来源,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !='' and source = 2
GROUP BY
    origin
ORDER BY
    销售额 DESC
limit 100

SELECT
        origin AS 产地,
        source AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !='' and source = 2
GROUP BY
    origin
ORDER BY
    销售数量 DESC
limit 100

SELECT
        origin AS 产地,
        source AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !='' and source = 6
GROUP BY
    origin
ORDER BY
    数量 DESC
limit 100

SELECT
        origin AS 产地,
        source AS 来源,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !='' and source = 6
GROUP BY
    origin
ORDER BY
    销售额 DESC
limit 100

SELECT
        origin AS 产地,
        source AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !='' and source = 6
GROUP BY
    origin
ORDER BY
    销售数量 DESC
limit 100

SELECT
        origin AS 产地,
        source AS 来源,
    count(product_id) as 数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !='' and source = 7
GROUP BY
    origin
ORDER BY
    数量 DESC
limit 100

SELECT
        origin AS 产地,
        source AS 来源,
    SUM(sale*sale_price) as 销售额
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !='' and source = 7
GROUP BY
    origin
ORDER BY
    销售额 DESC
limit 100

SELECT
        origin AS 产地,
        source AS 来源,
    SUM(sale) as 销售数量
FROM
    eb_echart_product
WHERE
    product_id > 0 and origin !='' and source = 7
GROUP BY
    origin
ORDER BY
    销售数量 DESC
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
order by
    a.choose_count desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
where source = 1
order by
    a.choose_count desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
where source = 2
order by
    a.choose_count desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
where source = 6
order by
    a.choose_count desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
where source = 7
order by
    a.choose_count desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
order by
    单品销售额 desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
where source = 1
order by
    单品销售额 desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
where source = 2
order by
    单品销售额 desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
where source = 6
order by
    单品销售额 desc
limit 100

select
    a.product_id as ID,
    a.product_name  as 商品名称,
    a.product_info as 商品介绍,
    a.img as 商品主图,
    a.unit as 商品单位,
    a.source as 商品平台来源,
    a.category_name as 商品类别,
    a.brand_name as 商品品牌,
    a.origin as 产地,
    a.cost_price as 成本价,
    a.sale_price as 售价,
    a.market_price as 市场价,
    a.activity_price as 活动价,
    a.agreement_price as 协议价,
    a.guide_price as 指导价,
    a.sale as 销售数量,
    a.stock as 总库存,
    a.choose_count as 铺货人数,
    a.activity_rate as 活动利润率,
    a.min_profits as 最小利润,
    a.max_profits as 最大利润,
    a.discount as 折扣,
    a.sale*a.sale_price as 单品销售额,
    a.create_time as 时间
from
    eb_echart_product as a
where source = 7
order by
    单品销售额 desc
limit 100

 

{
    "dv":1,
    "css":["/static/custom/template/css/comon0.css"],
    "js":["/static/custom/template/js/comon0.js"],
    "animate":{
        "0":{"dataLen":5,"interval":1000,"showtip":0},
        "1":{"dataLen":5,"interval":1000,"showtip":0},
        "2":{"dataLen":5,"interval":1000,"showtip":0},
        "3":{"dataLen":5,"interval":1000,"showtip":0},
        "4":{"dataLen":60,"interval":1000,"showtip":1},
        "5":{"dataLen":5,"interval":1000,"showtip":0},
        "6":{"dataLen":5,"interval":1000,"showtip":0},
        "7":{"dataLen":5,"interval":1000,"showtip":0},
        "8":{"dataLen":5,"interval":1000,"showtip":0},
        "9":{"dataLen":5,"interval":1000,"showtip":0},
        "10":{"dataLen":5,"interval":1000,"showtip":0},
        "11":{"dataLen":5,"interval":1000,"showtip":0},
        "12":{"dataLen":5,"interval":1000,"showtip":0},
        "13":{"dataLen":5,"interval":1000,"showtip":0}
    }
}

<!--    ##0##.全网商品数据统计分析0241    -->
<div class="canvas" style="opacity: .2;z-index:-1;">
  <iframe frameborder="0" src="../../static/custom/template/js/index.html" scrolling="no" style="width: 100%;height: 100%;"></iframe>
</div>

<div class="loading" style="display: none;">
  <div class="loadbox"> <img src="../../static/custom/template/picture/loading.gif"> 页面加载中... </div>
</div>

<div class="head">
  <h1>全网商品数据统计分析</h1>
  <div class="weather"><span id="showTime">2021年8月26-13时31分46秒</span></div>
</div>

<div class="mainbox">
  <ul class="clearfix"> 
    <li>
      <div class="boxall" style="height: 3.2rem">
        <div class="allnav">
          <div class="sycm">
            <div style="border-bottom: 1px solid rgba(255,255,255,.1)"></div>
            <ul class="clearfix">
              <li>
                <div style="float:right; width: 100%; margin-top: 0rem;">
                    <div class="col-xs-12 col-md-12" style="padding:0% 0%;" >
                      <div style="height:50%;" id="container_{name}"></div>
                    </div>
                </div>
              </li>
<!--    #######    -->

                
<!--    ##1##.全网商品数据统计分析1235    -->
<li>
                <div style="float:right; width: 100%; margin-top: 0rem;">
                    <div class="col-xs-12 col-md-12" style="padding:0% 0%;" >
                      <div style="height:50%;" id="container_{name}"></div>
                    </div>
                </div>
              </li>
<!--    #######    -->

                
<!--    ##2##.全网商品数据统计分析2236    -->
<li>
                <div style="float:left; width: 100%; margin-top: 0rem;">
                    <div class="col-xs-12 col-md-12" style="padding:0% 0%;" >
                      <div style="height:50%;" id="container_{name}"></div>
                    </div>
                </div>
              </li>
            </ul>
                
            <div style="border-bottom: 1px solid rgba(255,255,255,.1)"></div>
            <ul class="clearfix">
<!--    #######    -->

                
<!--    ##3##.全网商品数据统计分析3237    -->
<li>
                <div style="float:right; width: 100%; margin-top: 0rem;">
                    <div class="col-xs-12 col-md-12" style="padding:0% 0%;" >
                      <div style="height:50%;" id="container_{name}"></div>
                    </div>
                </div>
              </li>
<!--    #######    -->

                
<!--    ##4##.全网商品数据统计分析4238    -->
<li>
                <div style="float:right; width: 100%; margin-top: 0rem;">
                    <div class="col-xs-12 col-md-12" style="padding:0% 0%;" >
                      <div style="height:50%;" id="container_{name}"></div>
                    </div>
                </div>
              </li>
<!--    #######    -->

                
<!--    ##5##.全网商品数据统计分析5239    -->
<li>
                <div style="float:left; width: 100%; margin-top: 0rem;">
                    <div class="col-xs-12 col-md-12" style="padding:0% 0%;" >
                      <div style="height:50%;" id="container_{name}"></div>
                    </div>
                </div>
              </li>
            </ul>
          </div>
        </div>
        <div class="boxfoot"></div>
      </div>
<!--    #######    -->

                
<!--    ##6##.全网商品数据统计分析6222    -->
<div class="boxall" style="height: 3.2rem">
        <div class="allnav">
          <div class="col-xs-12 col-md-12" style="padding:0.5% 0.5%;" >
            <div style="height:100%;" id="container_{name}"></div>
          </div>
        </div>
        <div class="boxfoot"></div>
      </div>
<!--    #######    -->

                
<!--    ##7##.全网商品数据统计分析7223    -->
<div class="boxall" style="height: 3.2rem">
        <div style="height:100%; width: 100%;">
          <div style="float:left; width: 33%; margin-top: .25rem;">
            <div class="col-xs-12 col-md-12" style="padding:0.5% 0.5%;" >
              <div style="height:100%;" id="container_{name}"></div>
            </div>
          </div>
<!--    #######    -->

                
<!--    ##8##.全网商品数据统计分析8224    -->
<div style="float:left; width: 33%; margin-top: .25rem;">
            <div class="col-xs-12 col-md-12" style="padding:0.5% 0.5%;" >
              <div style="height:100%;" id="container_{name}"></div>
            </div>
          </div>
<!--    #######    -->

                
<!--    ##9##.全网商品数据统计分析9225    -->
<div style="float:left; width: 33%;  margin-top: .25rem;">
            <div class="col-xs-12 col-md-12" style="padding:0.5% 0.5%;" >
              <div style="height:100%;" id="container_{name}"></div>
            </div>
          </div>
        </div>
        <div class="boxfoot"></div>
      </div>

    </li>
    <li>
      <div>
        <div class="barbox">
          <ul class="clearfix">
            <li class="pulll_left counter">29700万件</li>
            <li class="pulll_left counter">12954亿元</li>
          </ul>
        </div>
        <div class="barbox2">
          <ul class="clearfix">
            <li class="pulll_left">全网商品销售量</li>
            <li class="pulll_left">全网商品销售额</li>
          </ul>
        </div>
      </div>
<!--    #######    -->

                
<!--    ##10##.全网商品数据统计分析10226    -->
<div class="map">
        <div class="map1"><img src="../../static/custom/template/picture/lbx.png"></div>
        <div class="map2"><img src="../../static/custom/template/picture/jt.png"></div>
        <div class="map3"><img src="../../static/custom/template/picture/map.png"></div>
        <div><!-- class="map4"-->
          <div class="col-xs-12 col-md-12" style="padding:0.5% 0.5%;" >
            <div style="height:100%;" id="container_{name}"></div>
          </div>
        </div>
      </div>
    </li>
<!--    #######    -->

                
<!--    ##11##.全网商品数据统计分析11227    -->
<li>
      <div class="boxall" style="height: 3.2rem">
          <div class="allnav">
            <div class="col-xs-12 col-md-12" style="padding:0.5% 0.5%;" >
              <div style="height:100%;" id="container_{name}"></div>
            </div>
          </div>
          <div class="boxfoot"></div>
      </div>
<!--    #######    -->

                
<!--    ##12##.全网商品数据统计分析12228    -->
<div class="boxall" style="height: 3.2rem">
        <div class="allnav">
          <div class="col-xs-12 col-md-12" style="padding:0.5% 0.5%;" >
            <div style="height:100%;" id="container_{name}"></div>
          </div>
        </div>
        <div class="boxfoot"></div>
      </div>
<!--    #######    -->

                
<!--    ##13##.全网商品数据统计分析13232    -->
<div class="boxall" style="height: 3.2rem">
        <div>
          <div class="col-xs-12 col-md-12" style="padding:0.5% 0.5%;" >
              <div style="height:100%;" id="container_{name}"></div>
            </div>
        </div>
        <div class="boxfoot"></div>
      </div>
    </li>
    <div class="back"></div>
  </ul>
</div>
<!--    #######    -->

                

let dataset = __dataset__; //传入dataset
let legend_label = ds_rowname(dataset) //可选, 自动获取legend
let xlabel = dataset[0].slice(1) //x轴的标签列

var labelData = [];
var labelData1 = [];
for (var i = 0; i < dataset[1][2]; ++i) {
    labelData.push({
        value: 1,
        name: i,
        itemStyle: {
            normal: {
                color: 'rgba(0,209,228,0)',
            }
        }
    });
}
for (var i = 0; i < labelData.length; ++i) {
    if (labelData[i].name < dataset[1][1]) {
        labelData[i].itemStyle = {
            normal: {
                color: new echarts.graphic.LinearGradient(
                    0, 1, 0, 0,
                    [{
                            offset: 0,
                            color: '#6dfbff'
                        },
                        {
                            offset: 1,
                            color: '#02aeff'
                        }
                    ]
                )
            },

        }
    }
}
for (var i = 0; i < dataset[1][2]; ++i) {
    labelData1.push({
        value: 1,
        name: i,
        itemStyle: {
            normal: {
                color: 'rgba(0,209,228,0)',
            }
        }
    });
}
for (var i = 0; i < labelData1.length; ++i) {
    if (labelData1[i].name < dataset[1][2]) {
        labelData1[i].itemStyle = {
            normal: {
                color: '#464451',
            },

        }
    }
}

function Pie() {
    let dataArr = [];
    for (var i = 0; i < dataset[1][1]; i++) {
        if (i % 10 === 0) {
            dataArr.push({
                name: (i + 1).toString(),
                value: 30,
                itemStyle: {
                    normal: {
                        color: "rgba(0,255,255,1)",
                        borderWidth: 0,
                        borderColor: "rgba(0,0,0,0)",
                    }
                }
            })
        } else {
            dataArr.push({
                name: (i + 1).toString(),
                value: dataset[1][2],
                itemStyle: {
                    normal: {
                        color: "rgba(0,0,0,0)",
                        borderWidth: 0,
                        borderColor: "rgba(0,0,0,0)"
                    }
                }
            })
        }
    }
    return dataArr
}

function Pie1() {
    let dataArr = [];
    for (var i = 0; i < dataset[1][1]; i++) {
        if (i % 5 === 0) {
            dataArr.push({
                name: (i + 1).toString(),
                value: dataset[1][1],
                itemStyle: {
                    normal: {
                        color: "rgba(0,255,255,1)",
                        borderWidth: 0,
                        borderColor: "rgba(0,0,0,0)"
                    }
                }
            })
        } else {
            dataArr.push({
                name: (i + 1).toString(),
                value: dataset[1][1],
                itemStyle: {
                    normal: {
                        color: "rgba(0,0,0,0)",
                        borderWidth: 0,
                        borderColor: "rgba(0,0,0,0)"
                    }
                }
            })
        }
    }
    return dataArr
}

function Pie2() {
    let dataArr = [];
    for (var i = 0; i < dataset[1][1]; i++) {
        if (i % 5 === 0) {
            dataArr.push({
                name: (i + 1).toString(),
                value: dataset[1][1],
                itemStyle: {
                    normal: {
                        color: "rgba(0,255,255,.3)",
                        borderWidth: 0,
                        borderColor: "rgba(0,0,0,0)"
                    }
                }
            })
        } else {
            dataArr.push({
                name: (i + 1).toString(),
                value: dataset[1][1],
                itemStyle: {
                    normal: {
                        color: "rgba(0,0,0,0)",
                        borderWidth: 0,
                        borderColor: "rgba(0,0,0,0)"
                    }
                }
            })
        }
    }
    return dataArr
}

function Pie3() {
    let dataArr = [];
    for (var i = 0; i < dataset[1][1]; i++) {
        if (i % 10 === 0) {
            dataArr.push({
                name: (i + 1).toString(),
                value: dataset[1][1],
                itemStyle: {
                    normal: {
                        color: "rgba(0,255,255,.5)",
                        borderWidth: 0,
                        borderColor: "rgba(0,0,0,0)"
                    }
                }
            })
        } else {
            dataArr.push({
                name: (i + 1).toString(),
                value: dataset[1][1],
                itemStyle: {
                    normal: {
                        color: "rgba(0,0,0,0)",
                        borderWidth: 0,
                        borderColor: "rgba(0,0,0,0)"
                    }
                }
            })
        }
    }
    return dataArr
}
option__name__= {
    title: [{
        text: dataset[1][1]+'款',//*100/dataset[1][2]+'%',
        x: '45%',
        y: '37%',
        textAlign: 'center',
        textStyle: {
            fontSize: '18',
            fontWeight: '100',
            color: '#79ffff',
            textAlign: 'center',
        },
    }, {
        //text: dataset[0][1],
        left: '50%',
        top: '52%',
        textAlign: 'center',
        textStyle: {
            fontSize: '18',
            fontWeight: '100',
            color: '#5c5a68',
            textAlign: 'center',
        },
    }, {
        //text: dataset[1][1]*100/dataset[1][2]+'%',//dataset[0][2],
        left: '50%',
        top: '62%',
        textAlign: 'center',
        textStyle: {
            fontSize: '14',
            fontWeight: '400',
            color: '#484556',
            textAlign: 'center',
        },
    }, ],
    polar: {
        radius: ['51%', '87%'],
        center: ['50%', '50%'],
    },
    angleAxis: {
        max: dataset[1][2],
        show: false,
        startAngle: 0,
    },
    radiusAxis: {
        type: 'category',
        show: true,
        axisLabel: {
            show: false,
        },
        axisLine: {
            show: false,

        },
        axisTick: {
            show: false
        },
    },
    series: [{
            name: '',
            type: 'bar',
            roundCap: true,
            barWidth: 60,
            showBackground: true,
            backgroundStyle: {
                color: '#464451',
            },
            data: [dataset[1][1]],
            coordinateSystem: 'polar',
            itemStyle: {
                normal: {
                    color: new echarts.graphic.LinearGradient(1, 0, 0, 0, [{
                        offset: 0,
                        color: '#0ff'
                    }, {
                        offset: 1,
                        color: '#02aeff'
                    }]),
                }
            }
        },
        {
            hoverAnimation: false,
            type: 'pie',
            z: 2,
            data: labelData,
            radius: ['52%', '99%'],
            zlevel: -2,
            itemStyle: {
                normal: {
                    borderColor: '#1f1e26',
                    borderWidth: 4,
                }
            },
            label: {
                normal: {
                    position: 'inside',
                    show: false,
                }
            },
        },
        {
            hoverAnimation: false,
            type: 'pie',
            z: 1,
            data: labelData1,
            radius: ['52%', '99%'],
            zlevel: -2,
            itemStyle: {
                normal: {
                    borderColor: '#1f1e26',
                    borderWidth: 4,
                }
            },
            label: {
                normal: {
                    position: 'inside',
                    show: false,
                }
            },
        },
        {
            type: 'pie',
            radius: ['42%', '83%'],
            center: ['50%', '50%'],
            data: [{
                    hoverOffset: 1,
                    value: dataset[1][1],
                    name: '',
                    itemStyle: {
                        color: '#ff6189',
                    },
                    label: {
                        show: false
                    },
                    labelLine: {
                        normal: {
                            smooth: true,
                            lineStyle: {
                                width: 0
                            }
                        }
                    },
                    hoverAnimation: false,
                },
                {
                    label: {
                        show: false
                    },
                    labelLine: {
                        normal: {
                            smooth: true,
                            lineStyle: {
                                width: 0
                            }
                        }
                    },
                    value: dataset[1][2] - dataset[1][1],
                    hoverAnimation: false,
                    itemStyle: {
                        color: '#3c3a48',
                    },
                }
            ]
        },

        {
            type: 'pie',
            zlevel: 0,
            silent: true,
            radius: ['67%', '95.5%'],
            z: 1,
            label: {
                normal: {
                    show: false
                },
            },
            labelLine: {
                normal: {
                    show: false
                }
            },
            data: Pie()
        },
        {
            type: 'pie',
            zlevel: 0,
            silent: true,
            startAngle: -150,
            radius: ['65%', '93.5%'],
            z: 1,
            label: {
                normal: {
                    show: false
                },
            },
            labelLine: {
                normal: {
                    show: false
                }
            },
            data: Pie3()
        },
        {
            type: 'pie',
            zlevel: 0,
            silent: true,
            startAngle: -140,
            radius: ['68%', '96.5%'],
            z: 1,
            label: {
                normal: {
                    show: false
                },
            },
            labelLine: {
                normal: {
                    show: false
                }
            },
            data: Pie()
        },
        {
            type: 'pie',
            zlevel: 0,
            silent: true,
            radius: ['61%', '90%'],
            z: 1,
            label: {
                normal: {
                    show: false
                },
            },
            labelLine: {
                normal: {
                    show: false
                }
            },
            data: Pie1()
        },
        {
            type: 'pie',
            zlevel: 0,
            silent: true,
            startAngle: -140,
            radius: ['61%', '90%'],
            z: 1,
            label: {
                normal: {
                    show: false
                },
            },
            labelLine: {
                normal: {
                    show: false
                }
            },
            data: Pie2()
        },
        {
            type: 'pie',
            zlevel: 0,
            silent: true,
            startAngle: -147.5,
            radius: ['61%', '90%'],
            z: 1,
            label: {
                normal: {
                    show: false
                },
            },
            labelLine: {
                normal: {
                    show: false
                }
            },
            data: Pie2()
        },

    ]
};
charts.push(myChart__name__);

//select 指标名, 值

var dataset = __dataset__; //传入dataset
legend_label = ds_rowname(dataset) //可选, 自动获取legend
var series =[];

for (var i=1;i<dataset.length;i++){
    series.push({name: dataset[i][0],value: dataset[i][1]})
}

option__name__= {
    //指定图列的顺序颜色
    //color : ['#b3c7bc','#cdd6bc','#d4713b'],
    title : {
        text: '全网品牌分类'+dataset[0][1],
        subtext:'数量（个）',
        x: "center", //水平坐标，默认为左侧center|left|right| {number}（px)
        y: "5%", //top|bottom|center|{number}（y坐标，单位px）
        //字体格式
        textStyle: {
            align: 'center',
            color: '#fff',
            fontSize: 15,
       },
    },
    
    tooltip : {
        trigger: 'item',
        formatter: "{a} <br/>{b} : {c}个商品 ({d}%)",
    },
    
    legend: {
        //type: 'scroll',
        //orient: 'vertical',
        left: '55%',
        right: '15%',
        top: '35%',
        bottom: '0%',
        selected: {
            // 选中'系列1'
            '来源': true,
        },
        textStyle: {
            color: '#fff'// 图例文字颜色
        }

    },

    series : [
        {
            name: dataset[0][0],
            type: 'pie',
            radius : '50%',
            center: ['25%', '70%'],
            itemStyle: {
                emphasis: {
                    shadowBlur: 10,
                    shadowOffsetX: 0,
                    shadowColor: 'rgba(0, 0, 0, 0.5)'
                }
            },
            data:series
        }
    ]
};
charts.push(myChart__name__);

//select 指标名, 值

var dataset = __dataset__; //传入dataset
legend_label = ds_rowname(dataset) //可选, 自动获取legend
var series =[];
for (var i=1;i<dataset.length;i++){
    series.push({name: dataset[i][0],value: dataset[i][1]})
}

option__name__= {
    title : {
        text: '京东分类商品'+dataset[0][1],
        subtext: ' ',
        x:'center',
        //字体格式
        textStyle: {
            align: 'center',
            color: '#fff',
            fontSize: 15,
       },
    },
    tooltip : {
        trigger: 'item',
        formatter: "{a} <br/>{b} : {c} ({d}%)"
    },
    legend: {
        //type: 'scroll',
        //orient: 'vertical',
        //right: 10,
        //top: 20,
        bottom: 0,
        selected: 1,
        textStyle: {
            color: '#fff'// 图例文字颜色
        }
    },
    series: [
        {
            name: dataset[0][0],
            type: 'pie',
            radius: ['60%', '80%'],
            center: ['50%', '40%'],
            avoidLabelOverlap: false,
            itemStyle: {
                borderRadius: 10,
                borderColor: '#fff',
                borderWidth: 2
            },
            label: {
                show: false,
                position: 'center'
            },
            emphasis: {
                label: {
                    show: true,
                    fontSize: '15',
                    fontWeight: 'bold'
                }
            },
            labelLine: {
                show: false
            },
            data:series
        }
    ]

};
charts.push(myChart__name__);

//select 指标名, 值

var dataset = __dataset__; //传入dataset
legend_label = ds_rowname(dataset) //可选, 自动获取legend
var series =[];
for (var i=1;i<dataset.length;i++){
    series.push({name: dataset[i][0],value: dataset[i][1]})
}

option__name__= {
    title : {
        text: '全网分类商品'+dataset[0][1],
        //subtext: ' ',
        x:'center',
        y:'97%',
        //字体格式
        textStyle: {
            align: 'center',
            color: '#fff',
            fontSize: 15,
       },
    },
    tooltip : {
        trigger: 'item',
        formatter: "{a} <br/>{b} : {c} ({d}%)"
    },

    series: [
        {
            name: dataset[0][0],
            type: 'pie',
            radius: ['75%', '90%'],
            center: ['50.4%', '50.4%'],
            avoidLabelOverlap: false,
            itemStyle: {
                borderRadius: 10,
                borderColor: '#fff',
                borderWidth: 2
            },
            label: {
                show: false,
                position: 'center'
            },
            emphasis: {
                label: {
                    show: true,
                    fontSize: '30',//60
                    fontWeight: 'bolder',
                    color:'#fff'
                }
            },
            labelLine: {
                show: false
            },
            data:series
        }
    ]

};
charts.push(myChart__name__);

//select 指标名, 值

var dataset = __dataset__; //传入dataset
legend_label = ds_rowname(dataset) //可选, 自动获取legend
var series =[];

for (var i=1;i<dataset.length;i++){
    series.push({name: dataset[i][0],value: dataset[i][1]})
}

option__name__= {
    //指定图列的顺序颜色
    //color : ['#b3c7bc','#cdd6bc','#d4713b'],
    title : {
        text: '商品'+dataset[0][1],
        subtext:'金额（元）',
        x: "center", //水平坐标，默认为左侧center|left|right| {number}（px)
        y: "5%", //top|bottom|center|{number}（y坐标，单位px）
        //字体格式
        textStyle: {
            align: 'center',
            color: '#fff',
            fontSize: 15,
       },
    },
    
    tooltip : {
        trigger: 'item',
        formatter: "{a} <br/>{b} : {c}个商品 ({d}%)",
    },
    
    legend: {
        type: 'scroll',
        orient: 'vertical',
        right: '15%',
        top: '50%',
        bottom: 0,
        selected: {
            // 选中'系列1'
            '来源': true,
        },
        textStyle: {
            color: '#fff'// 图例文字颜色
        }

    },

    series : [
        {
            name: dataset[0][0],
            type: 'pie',
            radius : '45%',
            center: ['35%', '75%'],
            itemStyle: {
                emphasis: {
                    shadowBlur: 10,
                    shadowOffsetX: 0,
                    shadowColor: 'rgba(0, 0, 0, 0.5)'
                }
            },
            data:series
        }
    ]
};
charts.push(myChart__name__);

//select 指标名, 值

var dataset = __dataset__; //传入dataset
legend_label = ds_rowname(dataset) //可选, 自动获取legend
var series =[];

for (var i=1;i<dataset.length;i++){
    series.push({name: dataset[i][0],value: dataset[i][1]})
}

option__name__= {
    //指定图列的顺序颜色
    //color : ['#b3c7bc','#cdd6bc','#d4713b'],
    title : {
        text: '商品'+dataset[0][1],
        subtext:'金额（元）',
        x: "center", //水平坐标，默认为左侧center|left|right| {number}（px)
        y: "5%", //top|bottom|center|{number}（y坐标，单位px）
        //字体格式
        textStyle: {
            align: 'center',
            color: '#fff',
            fontSize: 15,
       },
    },
    
    tooltip : {
        trigger: 'item',
        formatter: "{a} <br/>{b} : {c}个商品 ({d}%)",
    },
    
    legend: {
        type: 'scroll',
        orient: 'vertical',
        right: '15%',
        top: '50%',
        bottom: 0,
        selected: {
            // 选中'系列1'
            '来源': true,
        },
        textStyle: {
            color: '#fff'// 图例文字颜色
        }

    },

    series : [
        {
            name: dataset[0][0],
            type: 'pie',
            radius : '45%',
            center: ['35%', '75%'],
            itemStyle: {
                emphasis: {
                    shadowBlur: 10,
                    shadowOffsetX: 0,
                    shadowColor: 'rgba(0, 0, 0, 0.5)'
                }
            },
            data:series
        }
    ]
};
charts.push(myChart__name__);