<?php
class Receiving_ImportController extends Ec_Controller_Action
{
    public function preDispatch()
    {
        $this->tplDirectory = "receiving/views/import/";
    }

    public function listAction()
    {
        $condition=array(
            "report_page"=>'purchaseOrder',
        );
        $select=array("report_id","report_name");
        $row=Service_Report::getByCondition($condition,$select);
        $this->view->report=$row;
        echo Ec::renderTpl($this->tplDirectory . "import_asn.tpl", 'layout');
    }

    public function uploadAction()
    {
        if ($this->_request->isPost()) {
            $warehouseId=$this->_request->getParam('warehouse','');
            $referenceNo=$this->_request->getParam('referenceNo','');
            $description=$this->_request->getParam('description','');

            $asnArr=array(
                'warehouse_id'=>$warehouseId,
                'reference_no'=>$referenceNo,
                'receiving_description'=>$description,
                'customer_code'=>'EC001',
            );

            $fileName = isset($_FILES['FileName']['name']) ? $_FILES['FileName']['name'] : '';
            $filePath = isset($_FILES['FileName']['tmp_name']) ? $_FILES['FileName']['tmp_name'] : '';
            $result = Common_UploadData::uploadAsn($fileName, $filePath,$asnArr);
            if (isset($result['state']) && $result['state'] == '1') {
                $this->view->message = $result['message'];
            } else {
                $this->view->errorMsg = $result['errorMsg'];
            }
            echo Ec::renderTpl($this->tplDirectory . "import_asn.tpl", 'layout');
            exit;
        }
    }

    public function downDataAction(){
//
//        $userAccount = $this->_request->getParam('userAccount', '');
//        $startTime = $this->_request->getParam('startTime', '');
//        $endTime = $this->_request->getParam('endTime', '');
        $reportId=$this->_request->getParam('id', '');

        $report=Service_Report::getByField($reportId,"report_id");


        $sql=$report["report_sql"];

//        $convertStartime=" unix_timestamp('".$startTime."')";
//
//        $convertEndime=" unix_timestamp('".$endTime."')";
//
//
//        if($reportId=='2'){
//            $sql=$sql.'and unix_timestamp(ebay_order_original.CreatedTime) >'.$convertStartime.' and '. ' unix_timestamp(ebay_order_original.CreatedTime) <'
//                .$convertEndime;
//        }else{
//            $sql=$sql.'and unix_timestamp(ebay_order_original.paidtime) >'.$convertStartime.' and '. ' unix_timestamp(ebay_order_original.paidtime) <'
//                .$convertEndime;
//        }
//        if(!empty($userAccount)&&$userAccount!='0'){
//            $sql=$sql." and ebay_order_original.user_account='".$userAccount."'";
//        }
//
//        Ec::showError(var_export($sql,1),'tttttttttttttt');
//        print_r($sql);exit;
//        die;
        //     Ec::showError(var_export($sql,1),'sql');
        $result= Common_Export::getDateBySql($sql);
//Ec::showError(var_export($result,1),'sql');
        if($result['state']=='1'){
            $filename='order';
            header("Content-Disposition: attachment; filename=" . $filename . ".csv");
            header('Content-Type:APPLICATION/OCTET-STREAM');
            echo Common_Export::exportCsv($result['data']);
            exit;
        }else{
            print_r($result);
        }
    }


}