OMS/app/omeanalysts/controller/ome/catSaleRank.php

<?php
/**
 * Copyright 2012-2026 ShopeX (https://www.shopex.cn)
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

class omeanalysts_ctl_ome_catSaleRank extends desktop_controller{

    /**
     * __construct
     * @param mixed $app app
     * @return mixed 返回值
     */
    public function __construct($app){
        parent::__construct($app);
        $timeBtn = omeanalysts_func::timeBtn();
        $this->pagedata['timeBtn'] = $timeBtn;
    }

    function index(){
        if(empty($_POST)){
            $time_from = strtotime(date("Y-m-1"));
            $time_to = strtotime(date("Y-m-d 23:59:59",time()-24*60*60));
            $this->pagedata['time_from'] = $time_from;
            $this->pagedata['time_to'] = $time_to;
        }else{
            $time_from = strtotime($_POST['time_from']);
            $time_to = strtotime($_POST['time_to'].' 23:59:59');
            $this->pagedata['time_from'] = $time_from;
            $this->pagedata['time_to'] = $time_to;
        }

        // 店铺列表
        $shopModel = app::get('ome')->model('shop');
        $shop_list = $shopModel->getList('name,shop_id');
        $this->pagedata['shop_list'] = $shop_list;

        // 放大镜数据
        if ($shop_list) {
            $rank_data = array();
            foreach ( $shop_list as $shop ){
                $result = $this->_get_sale_rank($shop['shop_id'],$time_from,$time_to);
                $rank_data[$shop['shop_id']] = array(
                    'title' => $shop['name'],
                    'categories' => '['.implode(',',$result['categories']).']',
                    'data' => '[{name: \'数量\',data: ['.implode(',', $result['data']).']}]'
                );
            }
        }
        $this->pagedata['rank_data']= $rank_data;

        $this->pagedata['form_action'] = 'index.php?app=omeanalysts&ctl=ome_catSaleRank&act=index';
        $this->pagedata['path']= '商品类目销售排行榜';
        $this->page('ome/cat_sales_rank.html');
    }

    /*
    *获取各店铺商品类目销售排行数据
    * @param $shop_id 店铺ID
    */
    function sale_rank(){
        $title = $_GET['title'];
        $categories = $_GET['categories'];
        $data = $_GET['data'];

        $this->pagedata['title'] = '\''.$title.'\'';
     	$this->pagedata['categories'] = $categories;
     	$this->pagedata['data'] = $data;

        $this->display('ome/map.html');
    }

    private function _get_sale_rank($shop_id,$time_from,$time_to){

        $goods_typeModel = app::get('ome')->model('goods_type');

        $sql = sprintf('SELECT type_id,sum(sales_num) AS sales_num,sum(sales_amount) AS sales_amount FROM `sdb_omeanalysts_cat_sale_statis` WHERE sales_time>=\'%s\' AND sales_time<=\'%s\' AND shop_id=\'%s\' GROUP BY type_id ORDER BY sales_num desc,sales_amount desc LIMIT 0,10 ',$time_from,$time_to,$shop_id);
        $tmp = kernel::database()->select($sql);
        if ($tmp){
            $categories = array();
            $data = array();
            foreach ( $tmp as $val ){
                $type_detail = $goods_typeModel->dump($val['type_id'],'name');
                $categories[] = '\''.$type_detail['name'].'\'';
                $data[] = $val['sales_num'];
            }
        }else{
            $categories = $data = array('0','0','0','0','0','0','0','0','0','0');
        }
        
        $shop_name = '';
        $result = array(
            'title' => $shop_name,
            'categories' => $categories,
            'data' => $data,
        );
        return $result;
    }
    
    /**
     * index2
     * @return mixed 返回值
     */
    public function index2(){
        $_POST['_params'] = $_GET['_params'];
        $base_query_string = '';
        $params = array(
            'params' => array(
                'actions'=>array( 
                    array(
                         'class' => 'export',
                         'label' => '导出',
                         'href'=>'index.php?app=omeanalysts&ctl=ome_catSaleRank&act=index&action=export',
                         'target'=>'{width:400,height:170,title:\'生成报表\'}'
                     ),
                ),
                'title'=>app::get('omeanalysts')->_('商品类目销售对比统计<script>if($$(".finder-list").getElement("tbody").get("html") == "\n" || $$(".finder-list").getElement("tbody").get("html") == "" ){$$(".export").set("href","javascript:;").set("onclick", "alert(\"没有可以生成的数据\")");}else{$$(".export").set("href",\'index.php?app=omeanalysts&ctl=ome_catSaleStatis&act=index&action=export\');}</script>'),
                'use_buildin_recycle'=>false,
                'use_buildin_filter'=>true,
                'use_buildin_selectrow'=>false,
                'base_query_string'=>$base_query_string,
            ),
       );
       $this->finder('omeanalysts_mdl_ome_catSaleRank',$params);
       
    }
    
    
}
?>