<?php
include_once('objectPage.php');
class ctl_salescount extends adminPage{

    var $workground ='analytics';

    function index(){
        $sales = &$this->system->loadModel('utility/salescount');
        //$this->pagedata['year']=date("Y");
        //$this->pagedata['month']=date("m");
        $value_year=date("Y")-2000;
        $value_month=date("m");
        if($_GET['search_year']){
            $_GET['search_year']=intval($_GET['search_year']);
            $_GET['search_month']=intval($_GET['search_month']);
            $value_year=$_GET['search_year'];
            $value_month=$_GET['search_month'];
            $month_st=$_GET['search_year'].'-01-01';
            $month_en=$_GET['search_year'].'-12-01';
            $day_st=$_GET['search_year'].'-'.($_GET['search_month']+1).'-01';
            $day_en=date("Y-m-01",strtotime("+1 month",strtotime($day_st)));
        }else{

            $month_st=date("Y-01-01");
            $month_en=date("Y-12-01");
            $day_st=date("Y-m-01");
            $day_en=date("Y-m-01",strtotime("+1 month",strtotime($day_st)));
        }
        $d_year=array();
        for($i=2000;$i<=date("Y");$i++){
            array_push($d_year,$i);
        }
        $d_month=array();
        for($i=1;$i<=12;$i++){
            array_push($d_month,$i);
        }
        $month_search=$sales->mdl_dosearch($month_st,$month_en,"","","month");
        $day_search=$sales->mdl_dosearch($day_st,$day_en,"","","day");
        $this->pagedata['day']=$day_search;
        $this->pagedata['month']=$month_search;
        $this->pagedata['d_year']=$d_year;
        $this->pagedata['d_month']=$d_month;
        $this->pagedata['value_month']=$value_month;
        $this->pagedata['value_year']=$value_year;
        $this->page('sale/count/salescount.html');
    }
    function countall(){
        if($_GET['ordertype'] && $_GET['method']){
                $order['order']=intval($_GET['ordertype']);
                $order['method']=intval($_GET['method']);
        }
        if($_GET['dosearch']){
            $dateFrom=strtotime($_GET['searchfrom']);
            $dateTo=strtotime($_GET['searchto']);
            $search=$_GET['dosearch'];
            $item=$_GET['searchitem'];
            $sales=&$this->system->loadModel('utility/salescount');
            $result=$sales->count_all($dateFrom,$dateTo,$item,$search,$order);
            $this->pagedata['plug']='&dosearch='.$_GET['dosearch'].'&searchitem='.$_GET['searchitem'].'&searchfrom='.$_GET['searchfrom'].'&searchto='.$_GET['searchto'];
        }else {
            $dateFrom=strtotime(date("Y").'-01-01');
            $dateTo=strtotime("+1 year",$dateFrom);
            $sales=&$this->system->loadModel('utility/salescount');
            $result=$sales->count_all($dateFrom,$dateTo,'','',$order);
        }
        if($_GET['genexml']==1){
            $dataio = $this->system->loadModel('system/dataio');
            $io="xls";

            $name=array('商品名称','销售量','销售额');
            $dataio->export_begin("xls",$name,'商品销售量(额)',count($result));
            $dataio->export_rows($io,$result);
            $dataio->export_finish('xls');
            exit();
        }
        $this->pagedata['data']=$result;
        $this->pagedata['method']=$_GET['method'];
        $this->page('sale/count/salescountall.html');
    }

    function do_search(){
        $sales = &$this->system->loadModel('utility/salescount');
        $results=$sales->mdl_dosearch($_POST['dateFrom'],$_POST['dateTo'],$_POST['dateCompareFrom'],$_POST['dateCompareTo'],$_POST['ptype']);
        echo $results;
    }

    function membercount(){

        if($_GET['ordertype'] && $_GET['method'] ){
            $order['order']=intval($_GET['ordertype']);
            $order['method']=intval($_GET['method']);
        }
        if($_GET['searchfrom'] && $_GET['searchto']){
            $dateFrom=strtotime($_GET['searchfrom']);
            $dateTo=strtotime($_GET['searchto']);
            $memberinfo=&$this->system->loadModel('utility/salescount');
            $result=$memberinfo->member_count($dateFrom,$dateTo,$order);
        }else{
            $dateFrom=strtotime(date("Y").'-01-01');
            $dateTo=strtotime("+1 year",$dateFrom);
            $memberinfo=&$this->system->loadModel('utility/salescount');
            $result=$memberinfo->member_count($dateFrom,$dateTo,$order);

        }
        if($_GET['genexml']==1){
            $addons = &$this->system->loadModel('system/addons');
            $io= $addons->load('xls','io');
            $name=array(__('用户名'),__('姓名'),__('销售量'),__('销售额'));
            $io->export_begin($name,__("会员购物量(额)"),count($name));
            $io->export_rows($result);
            $io->export_finish();
            return;
        }
        $this->pagedata['data']=$result;
        $this->pagedata['method']=$_GET['method'];
        $this->page('sale/count/membercount.html');
    }
    function salesguide(){
        if($_GET['searchfrom'] && $_GET['searchto']){
            $dateFrom=strtotime($_GET['searchfrom']);
            $dateTo=strtotime($_GET['searchto']);
            $vcompare=&$this->system->loadModel('utility/salescount');
            $result['ordersales']=$vcompare->average_order_sales($dateFrom,$dateTo);
            $result['ordermember']=$vcompare->have_order_member($dateFrom,$dateTo);
            $result['allmember']=$vcompare->all_member();
            $result['visit']=$vcompare->count_all_visite($dateFrom,$dateTo);
        }else{
            $dateFrom=strtotime(date("Y").'-01-01');
            $dateTo=strtotime("+1 year",$dateFrom);
            $vcompare=&$this->system->loadModel('utility/salescount');
            $result['ordersales']=$vcompare->average_order_sales($dateFrom,$dateTo);
            $result['ordermember']=$vcompare->have_order_member($dateFrom,$dateTo);
            $result['allmember']=$vcompare->all_member();
            $result['visit']=$vcompare->count_all_visite($dateFrom,$dateTo);
        }
        $this->pagedata['data']=$result;
        $this->pagedata['method']=$_GET['method'];
        $this->page('sale/count/salesguide.html');
    }
    function visitsalecompare(){
        if($_GET['ordertype'] && $_GET['method'] ){
            $order['order']=intval($_GET['ordertype']);
            $order['method']=intval($_GET['method']);
        }
        if($_GET['searchfrom'] && $_GET['searchto']){
            $dateFrom=strtotime($_GET['searchfrom']);
            $dateTo=strtotime($_GET['searchto']);
            $vcompare=&$this->system->loadModel('utility/salescount');
            $result=$vcompare->visit_sale_compare($dateFrom,$dateTo,$order);
        }else{
            $dateFrom=strtotime(date("Y").'-01-01');
            $dateTo=strtotime("+1 year",$dateFrom);
            $vcompare=&$this->system->loadModel('utility/salescount');
            $result=$vcompare->visit_sale_compare($dateFrom,$dateTo,$order);
        }
        if($_GET['genexml']==1){

            $addons = &$this->system->loadModel('system/addons');
            $io= $addons->load('xls','io');
            $name=array(__('商品名称'),__('访问次数'),__('购买次数'));
            $io->export_begin($name,__("商品访问购买次数"),count($name));
            $io->export_rows($result);
            return;
        }
        $this->pagedata['method']=$_GET['method'];
        $this->pagedata['data']=$result;
        $this->page('sale/count/visitsalecompare.html');
    }
}
?>
