erp/core/CoreApp/controllers/Retreatlog.php

<?php 
defined('BASEPATH') OR exit('No direct script access allowed');
class Retreatlog extends Start_Controller {
	public function __construct(){
        parent::__construct();
        $this->load->library('session');
        $this->load->model('Model_retreatlogs','retreatlogs');
        $this->load->model("Model_logic_u9tools","logic_u9tools");
    }
    //定义方法的调用规则 获取URI第二段值
    public function _remap($arg,$arg_array)
    {
        if($arg == 'exceljs')//添加
        {
             $this->_exceljs();
        }
		else{
            $this->_index();
        }
    }

    private function _index(){
        
        if($this->input->method() == 'post'){

            $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
            $number = $this->input->post('number',true);
            $timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
            $timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
            $where = " tk_time >= {$timetk} and tk_time <= {$timetj} ";
            if($number){
                $where .= " and number = '{$number}' ";
            }
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }

            $classid = $this->logic_u9tools->getClass();
            $typeclass = $this->logic_u9tools->getTypeClass();
            
            $info_list = $this->retreatlogs->find_all($where,'id,number,ck_time,tk_time,cz_time,ck_goods',$order_str,$start,$perpage);
            foreach($info_list as $k => $v){
                $json_arr = json_decode($v['ck_goods'],true);

                
                $fpdata = $this->logic_u9tools->transferFpdata($json_arr['fpdata']);

                $jm_str = '';
                $zh_str = '';
                foreach($fpdata as $key => $value){
                    $sku = $value[0];
                    $u9_info = $this->logic_u9tools->getOneU9bmHasGift($sku,$classid,$typeclass);    
                    $jm_str .= $u9_info['jm']."<br/>";
                    $zh_str .= $u9_info['zh']." *  " .$value[2]."<br/>";
                }

                $info_list[$k]['ck_time'] = empty($v['ck_time'])? '' : date('Y-m-d H:i:s',$v['ck_time']);
                $info_list[$k]['tk_time'] = empty($v['tk_time'])? '' : date('Y-m-d H:i:s',$v['tk_time']);
                $info_list[$k]['cz_time'] = empty($v['cz_time'])? '' : date('Y-m-d H:i:s',$v['cz_time']);
                $info_list[$k]['ck_goods'] = trim($jm_str,"<br/>");
                $info_list[$k]['zh'] = trim($zh_str,"<br/>");
            }
			
			$total = $this->retreatlogs->find_count($where);
            $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list));
		    echo json_encode($rows);exit;
        }else{
            $this->_Template('retreatlog',$this->data);
        }
    }


    private function _exceljs(){
        $number = $this->input->get('number',true);
        $timetk = $this->input->get('timetk',true);
        $timetj = $this->input->get('timetj',true);
        $timetk = strtotime($timetk);
        $timetj = strtotime($timetj);
        $where = "tk_time >= {$timetk} and tk_time <= {$timetj}";
        if($number){
            $where .= " and number = '{$number}' ";
        }
        $order_str = "id desc";

        $classid = $this->logic_u9tools->getClass();
        $typeclass = $this->logic_u9tools->getTypeClass();


        $info_list = $this->retreatlogs->find_all($where,'id,number,ck_time,tk_time,cz_time,ck_goods',$order_str);
        foreach($info_list as $k => $v){
          
            $json_arr = json_decode($v['ck_goods'],true);

                
            $fpdata = $this->logic_u9tools->transferFpdata($json_arr['fpdata']);

            $jm_str = '';
            $zh_str = '';
            foreach($fpdata as $key => $value){
                $sku = $value[0];
                $u9_info = $this->logic_u9tools->getOneU9bmHasGift($sku,$classid,$typeclass);    
                $jm_str .= $u9_info['jm']."<br/>";
                $zh_str .= $u9_info['zh']." *  " .$value[2]."<br/>";
            }

            $info_list[$k]['ck_time'] = empty($v['ck_time'])? '' : date('Y-m-d H:i:s',$v['ck_time']);
            $info_list[$k]['tk_time'] = empty($v['tk_time'])? '' : date('Y-m-d H:i:s',$v['tk_time']);
            $info_list[$k]['cz_time'] = empty($v['cz_time'])? '' : date('Y-m-d H:i:s',$v['cz_time']);
            $info_list[$k]['ck_goods'] = trim($jm_str,"<br/>");
            $info_list[$k]['zh'] = trim($zh_str,"<br/>");


        }

           //生成excel
           $filename = date("Y-m-d")."退库日志记录.xls";
           $str = "<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">
           <head>
           <!--[if gte mso 9]><xml>
           <x:ExcelWorkbook>
           <x:ExcelWorksheets>
           <x:ExcelWorksheet>
           <x:Name>EXCEL</x:Name>
           <x:WorksheetOptions>
           <x:Print>
           <x:ValidPrinterInfo />
           </x:Print>
           </x:WorksheetOptions>
           </x:ExcelWorksheet>
           </x:ExcelWorksheets>
           </x:ExcelWorkbook>
           </xml>
           <![endif]-->
           </head><body>";
           $str .= "<table border=1 style='font-family: Microsoft Yahei;font-size: 13px;'>"; 
           $str .= "<tr><td>订单编号</td><td>出库时间</td><td>退库时间</td><td>重置时间</td><td>u9料号</td><td>中文品名</td></tr>";
           foreach ($info_list as $key=>$value) 
           { 
               
               $str .= "<tr>";
               $str .= "<td>". $value['number']. "</td>";
               $str .= "<td>". $value['ck_time']. "</td>";	
               $str .= "<td>". $value['tk_time']. "</td>";	
               $str .= "<td>". $value['cz_time']. "</td>";
               $str .= "<td>". $value['ck_goods']. "</td>";
               $str .= "<td>". $value['zh']. "</td>";
               $str .= "</tr>";
           }
           $str .= "</table></body></html>"; 
           header( "Content-Type: application/vnd.ms-excel; name='excel'" ); 
           header( "Content-type: application/octet-stream" ); 
           header( "Content-Disposition: attachment; filename=".$filename ); 
           header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" ); 
           header( "Pragma: no-cache" ); 
           header( "Expires: 0" ); 
           exit($str); 
    }
}