mashangyoujiu/Application/Retail/Controller/SRetreatReceivablesController.class.php

<?php
namespace Retail\Controller;
use Think\Controller;
//[1.7.90]
class SRetreatReceivablesController extends BaseController{
    public function index()
    {
        $arr = array(
            'exportOperation'=>'/index.php/Retail/SRetreatReceivables/export',
            'payment'=>'/index.php/Retail/SRetreatReceivables/SupplierInfo',
        );
        $authArr = checkFunction($arr);
        $this->assign('authArr',$authArr);
        $merchant_id = session("ls_userinfo")['merchantid'];
        $store_id = session("storeid");
        $supplier = D("SSupplier")->getSelect(array('merchant_id'=>$merchant_id,'store_id'=>$store_id,'status'=>1),$page='',$limit='',"id,supplier_name");
        $this->assign('supplier',json_encode($supplier));
        $this->assign('showPrice',self::$showPrice);
        $this->assign('identity',self::$identity);
        $this->assign("global_store_jurisdiction",self::$global_store_jurisdiction);
        $this->display();
    }
    public function RetreatList()
    {
        $SRetreatReceivablesModel = D("SRetreatReceivables");
        $merchant_id = session("ls_userinfo")['merchantid'];
        $store_id = session("storeid");
        $data = I("post.");
        $order_number = $data['order_number'];
        $add_time = $data['add_time'];
        $supplier_id = $data['supplier_id'];
        $pay_status = $data['pay_status'];
        $type = $data['type'];
        $page = $data['page'];
        $limit = $data['limit'];
        if(!empty($type)){
            $where['type'] = $type;
        }
        if(!empty($order_number)){
            $where[$SRetreatReceivablesModel::RETREAT_ORDER_NUMBER] = array('like','%'.$order_number."%");
        }
        if(!empty($supplier_id)){
            $where[$SRetreatReceivablesModel::SUPPLIER_ID] = $supplier_id;
        }
        if(!empty($pay_status)){
            $where[$SRetreatReceivablesModel::PAY_STATUS] = $pay_status;
        }
        if(!empty($add_time)){
            $start_time = strtotime($add_time[0]);
            $end_time = strtotime($add_time[1]);
            $where[$SRetreatReceivablesModel::RETREAT_TIME] = array('between',array($start_time,$end_time));
        }
        $where[$SRetreatReceivablesModel::MERCHANT_ID] = $merchant_id;
        $where[$SRetreatReceivablesModel::STORE_ID] = $store_id;
        $res = A("Api/Inventory")->StoreReceivableList($where,$page,$limit,$fields="*");
        $this->ajaxReturn($res);
    }
    //供货商
    public function SupplierInfo()
    {
        $supplier_id = I("post.supplier_id");
        $res = A("Api/Inventory")->StoreSupplierInfo($supplier_id);
        $this->ajaxReturn($res);
    }
    //收款操作
    public function Collect()
    {
        $merchant_id = session("ls_userinfo")['merchantid'];
        $operator_id = session("jurisdiction_user")['id'];
        $store_id = session("storeid");
        $data = I("post.");
        $res = A("Api/Inventory")->StoreCollect($data,$merchant_id,$store_id,$operator_id);
        if($res['status']==1){
            //操作日志记录
            $source = 0;//请求来源： 0pc系统 1小助手
            $type = 4;//平台：1合伙人端 2代理商端  3商户端  4门店端
            $request_data = json_encode($_POST);//请求参数 json数据
            $desc = '采购退货进行收款操做';//操作行为描述
            action_log($source,$type,$request_data,$desc);
            //end
        }
        $this->ajaxReturn($res);
    }
    public function export()
    {
        $SRetreatReceivablesModel = D("SRetreatReceivables");
        $merchant_id = session("ls_userinfo")['merchantid'];
        $store_id = session("storeid");
        $data = I("get.");
        $order_number = $data['order_number'];
        $add_time = $data['add_time'];
        $supplier_id = $data['supplier_id'];
        $pay_status = $data['pay_status'];
        $type = $data['type'];
        if(!empty($type)){
            $where['type'] = $type;
        }
        if(!empty($order_number)){
            $where[$SRetreatReceivablesModel::RETREAT_ORDER_NUMBER] = array('like','%'.$order_number."%");
        }
        if(!empty($supplier_id)){
            $where[$SRetreatReceivablesModel::SUPPLIER_ID] = $supplier_id;
        }
        if(!empty($pay_status)){
            $where[$SRetreatReceivablesModel::PAY_STATUS] = $pay_status;
        }
        if(!empty($add_time)){
            if(!is_array($add_time)){
                $add_time = explode(',',$add_time);
            }
            $start_time = strtotime($add_time[0]);
            $end_time = strtotime($add_time[1]);
            $where[$SRetreatReceivablesModel::RETREAT_TIME] = array('between',array($start_time,$end_time));
        }
        $where[$SRetreatReceivablesModel::MERCHANT_ID] = $merchant_id;
        $where[$SRetreatReceivablesModel::STORE_ID] = $store_id;
        $RetreatList = $SRetreatReceivablesModel->getSelect($where,$page='',$limit='',"*");
        if($RetreatList){
            foreach ($RetreatList as $key=>&$val){
                $val['index'] = $key + 1;
                $val[$SRetreatReceivablesModel::RETREAT_TIME] = date("Y-m-d H:i:s",$val[$SRetreatReceivablesModel::RETREAT_TIME]);
                $val[$SRetreatReceivablesModel::COLLECT_MONEY] = round($val[$SRetreatReceivablesModel::COLLECT_MONEY],2);
                $val[$SRetreatReceivablesModel::RECEIVED_MONEY] = round($val[$SRetreatReceivablesModel::RECEIVED_MONEY],2);
                $val['stay_money'] = round($val[$SRetreatReceivablesModel::COLLECT_MONEY] - $val[$SRetreatReceivablesModel::RECEIVED_MONEY],2);
                $val['supplier_name'] = D("SSupplier")->getFindField(array('id'=>$val[$SRetreatReceivablesModel::SUPPLIER_ID]),"supplier_name");
                $val['operator'] = A('Api/Inventory')->OperatorName($val[$SRetreatReceivablesModel::OPERATOR_ID]);
                switch ($val[$SRetreatReceivablesModel::PAY_STATUS]){
                    case 1:
                        $val['pay_name'] = "待收款";
                        break;
                    case 2:
                        $val['pay_name'] = "部分收款";
                        break;
                    case 3:
                        $val['pay_name'] = "已收款";
                        break;
                }
            }
            unset($val);
        }
        $RetreatList = $RetreatList?$RetreatList:array();
        $fileds_name = "退货应收款导出";
        $arr = array(
            array('index',"序号"),
            array('supplier_name',"供货商"),
            array("retreat_order_number","退货单"),
            array("operator","操作人"),
            array("retreat_time","退货时间"),
            array("collect_money","应收金额"),
            array("received_money","已收金额"),
            array("stay_money","待收金额"),
            array("pay_name","收款状态"),
        );
        $str = $fileds_name.",导出日期为".date("Y-m-d H:i:s",time());
        getExcel($fileds_name, $arr, $RetreatList, $str);
    }
}