";
        set_time_limit(600);
        $recodeList = $this->_request->getParam('recode');
        $xlsx = new \XLSXWriter();
        $xlsx->writeSheetHeader('sheet1',[
            '仓库账册号'=>'string',
            '备案序号'=>'string',
            '海关料件号'=>'string',
            '海关编码'=>'string',
            '产品名称'=>'string',
            '商品规格'=>'string',
            '可用库存'=>'integer',
            '锁定库存'=>'integer',
            '冻结库存'=>'integer',
            '原产国'=>'string',
            '原产国名称'=>'string',
            '申报币制代码'=>'string',
            '单价'=>'string',
            '申报计量单位代码'=>'string',
            '法定计量单位代码'=>'string',
            '第二法定计量单位代码'=>'string',
            '锁定状态'=>'string',
            '添加时间'=>'string',
        ]);
        $state = Service_BillBook::getState();
        $country = [];
        $hsuom =[];
        if(!empty($recodeList)){
            foreach ($recodeList as $billId){
                $billBook = Service_BillBook::getByField($billId);
                if(!$country[$billBook['country_code']]){
                    $countryInfo = Service_Country::getByField($billBook['country_code'],'trade_country');
                    $country[$billBook['country_code']] = $countryInfo['country_name'];
                }
                if(!$hsuom[$billBook['decalare_unit']]){
                    $productUom = Service_ProductUom::getByField($billBook['decalare_unit'],'pu_code');
                    $hsuom[$billBook['decalare_unit']] = $productUom['pu_name'];
                }
                if(!$hsuom[$billBook['legal_unit']]){
                    $productUom = Service_ProductUom::getByField($billBook['legal_unit'],'pu_code');
                    $hsuom[$billBook['legal_unit']] = $productUom['pu_name'];
                }
                if($billBook['second_legal_unit']){
                    if(!$hsuom[$billBook['second_legal_unit']]){
                        $productUom = Service_ProductUom::getByField($billBook['second_legal_unit'],'pu_code');
                        $hsuom[$billBook['second_legal_unit']] = $productUom['pu_name'];
                    }
                }
                $xlsx->writeSheetRow('sheet1',[
                    $billBook['warehous_account_no'],//'仓库账册号'
                    $billBook['recorde_no'],//'备案序号'=>'string',
                    $billBook['goods_code'],//'海关料件号'=>'string',
                    $billBook['hs_code'],//'海关编码'=>'string',
                    $billBook['product_title'],//'产品名称'=>'string',
                    $billBook['specification'],//'商品规格'=>'string',
                    $billBook['can_use_quantity'],//'可用库存'=>'integer',
                    $billBook['lock_quantity'],//'锁定库存'=>'integer',
                    $billBook['frozen_quantity'],//'冻结库存'=>'integer',
                    $billBook['country_code'],//'原产国'=>'string',
                    $country[$billBook['country_code']],//原产国名称
                    $billBook['decalar_currency'],//'申报币制代码'=>'string',
                    $billBook['decalar_price'],//'单价'=>'string',
                    $billBook['decalare_unit'].'-'.$hsuom[$billBook['decalare_unit']] ,//'申报计量单位代码'=>'string',
                    $billBook['legal_unit'].'-'.$hsuom[$billBook['legal_unit']],//'法定计量单位代码'=>'string',
                    $billBook['second_legal_unit']?$billBook['second_legal_unit'].'-'.$hsuom[$billBook['second_legal_unit']]:'',//'第二法定计量单位代码'=>'string',
                    $state[$billBook['state']],
                    $billBook['add_time'],//'添加时间'=>'string',
                ]);
            }
        }else{
            $condition = $this->getCondition();
            print_r($condition);
            $pageSize = 500;
            $list = Service_BillBook::getByCondition($condition,'*',$pageSize,1,'id asc');
            exit;
            while ($list){
                //print_r($list);
                foreach ($list as $billBook){
                    if(!$country[$billBook['country_code']]){
                        $countryInfo = Service_Country::getByField($billBook['country_code'],'trade_country');
                        $country[$billBook['country_code']] = $countryInfo['country_name'];
                    }
                    if(!$hsuom[$billBook['decalare_unit']]){
                        $productUom = Service_ProductUom::getByField($billBook['decalare_unit'],'pu_code');
                        $hsuom[$billBook['decalare_unit']] = $productUom['pu_name'];
                    }
                    if(!$hsuom[$billBook['legal_unit']]){
                        $productUom = Service_ProductUom::getByField($billBook['legal_unit'],'pu_code');
                        $hsuom[$billBook['legal_unit']] = $productUom['pu_name'];
                    }
                    if($billBook['second_legal_unit']){
                        if(!$hsuom[$billBook['second_legal_unit']]){
                            $productUom = Service_ProductUom::getByField($billBook['second_legal_unit'],'pu_code');
                            $hsuom[$billBook['second_legal_unit']] = $productUom['pu_name'];
                        }
                    }
                    $xlsx->writeSheetRow('sheet1',[
                        $billBook['warehous_account_no'],//'仓库账册号'
                        $billBook['recorde_no'],//'备案序号'=>'string',
                        $billBook['goods_code'],//'海关料件号'=>'string',
                        $billBook['hs_code'],//'海关编码'=>'string',
                        $billBook['product_title'],//'产品名称'=>'string',
                        $billBook['specification'],//'商品规格'=>'string',
                        $billBook['can_use_quantity'],//'可用库存'=>'integer',
                        $billBook['lock_quantity'],//'锁定库存'=>'integer',
                        $billBook['frozen_quantity'],//'冻结库存'=>'integer',
                        $billBook['country_code'],//'原产国'=>'string',
                        $country[$billBook['country_code']],//原产国名称
                        $billBook['decalar_currency'],//'申报币制代码'=>'string',
                        $billBook['decalar_price'],//'单价'=>'string',
                        $billBook['decalare_unit'].'-'.$hsuom[$billBook['decalare_unit']] ,//'申报计量单位代码'=>'string',
                        $billBook['legal_unit'].'-'.$hsuom[$billBook['legal_unit']],//'法定计量单位代码'=>'string',
                        $billBook['second_legal_unit']?$billBook['second_legal_unit'].'-'.$hsuom[$billBook['second_legal_unit']]:'',//'第二法定计量单位代码'=>'string',
                        $state[$billBook['state']],
                        $billBook['add_time'],//'添加时间'=>'string',
                    ]);
                }
                $condition['last_id'] = $billBook['id'];
                $list = Service_BillBook::getByCondition($condition,'*',$pageSize,1,'id asc');
            }
        }
        $filename ='账册库存'.date("Y-m-d").'.xlsx';
        header('Content-Type: application/vnd.ms-excel');
        header('Content-Type: application/force-download');
        header("Content-Disposition: attachment;filename=\"$filename\"");
        header("Content-Transfer-Encoding: binary");
        header('Cache-Control: max-age=0');
        $xlsx->writeToStdOut();
    }

    /**
     * Note:
     * User: Yao
     * Date: 2021/7/30
     * Time: 11:14
     */
    public function lockAction(){
        $return =[
            'state'=>0,
            'message'=>'fail',
            'data'=>[],
        ];
        $total = 0;
        $success = 0;
        try{
            $recodeId = $this->_request->getParam('recode');
            if(empty($recodeId)){
                throw new Exception('请选择要锁定的记录');
            }
            $reason = $this->_request->getParam('lock_reason');
            if(empty($reason)){
                throw new Exception('请填写原因');
            }
            $recodeId = explode(',',$recodeId);
            $ip = Common_Common::getRealIp();
            $userId = $this->_userAuth->userId;
            foreach ($recodeId as $billbookId){
                $total++;
                $billBook = Service_BillBook::getByField($billbookId);
                if($billBook){
                    if($billBook['state'] == 0) {
                        $db = Common_Common::getAdapter();
                        $db->beginTransaction();
                        try {
                            $update = [
                                'state' => 1
                            ];
                            Service_BillBook::update($update, $billBook['id']);
                            $log = array(
                                'sys_add_time' => date("Y-m-d H:i:s"),
                                'operator_ip' => $ip,
                                'bill_book_id' => $billBook['id'],
                                'goods_id' => $billBook['goods_code'],
                                'operator_id' => $userId,
                                'operate_type' => 1,
                                'remark' => '锁定记录:' . $reason
                            );
                            Service_BillBookLog::add($log);
                            $success++;
                            $db->commit();
                        }catch (Exception $e){
                            $db->rollBack();
                            $return['data'][]="备案序号".$billBook['recorde_no'].'锁定失败';
                        }
                    }else{
                        $return['data'][]="备案序号".$billBook['recorde_no'].'不是正常状态';
                    }
                }
            }
            if($success){
                $return['state'] = 1;
                $return['message']="锁定记录成功：总计".$total.'条记录，成功'.$success.'条记录，失败'.($total-$success).'条记录';
            }else{
                $return['message']="锁定的失败：没有符合条件的记录";
            }

        }catch (Exception $e){
            $return['message'] = $e->getMessage();
        }
        die(Zend_Json::encode($return));
    }

    /**
     * Note:
     * User: Yao
     * Date: 2021/7/30
     * Time: 11:14
     */
    public function unlockAction(){
        $return =[
            'state'=>0,
            'message'=>'fail',
            'data'=>[],
        ];
        $total = 0;
        $success = 0;
        try{
            $recodeId = $this->_request->getParam('recode');
            $reason = $this->_request->getParam('lock_reason');
            if(empty($recodeId)){
                throw new Exception('请选择要解锁的记录');
            }
            if(empty($reason)){
                throw new Exception('请填写原因');
            }
            $recodeId = explode(',',$recodeId);
            $ip = Common_Common::getRealIp();
            $userId = $this->_userAuth->userId;
            foreach ($recodeId as $billbookId){
                    $total++;
                    $billBook = Service_BillBook::getByField($billbookId);
                    if ($billBook) {
                        if ($billBook['state'] == 1) {
                            $db = Common_Common::getAdapter();
                            $db->beginTransaction();
                            try {
                                $update = [
                                    'state' => 0
                                ];
                                $billBook = Service_BillBook::getByIdForUpdate($billbookId);
                                Service_BillBook::update($update, $billBook['id']);
                                $log = array(
                                    'sys_add_time' => date("Y-m-d H:i:s"),
                                    'operator_ip' => $ip,
                                    'bill_book_id' => $billBook['id'],
                                    'goods_id' => $billBook['goods_code'],
                                    'operator_id' => $userId,
                                    'operate_type' => 1,
                                    'remark' => '解锁记录:' . $reason
                                );
                                Service_BillBookLog::add($log);
                                $success++;
                                $db->commit();
                            }catch (Exception $e){
                                $return['data'][] = "备案序号" . $billBook['recorde_no'] . '解锁失败';
                                $db->rollBack();
                            }
                        } else {
                            $return['data'][] = "备案序号" . $billBook['recorde_no'] . '不是锁定状态';
                        }
                    }
            }
            if($success){
                $return['state'] = 1;
                $return['message']="解锁成功：总计".$total.'条记录，成功'.$success.'条记录，失败'.($total-$success).'条记录';
            }else{
                $return['message']="解锁失败：没有符合条件的记录";
            }
        }catch (Exception $e){
            $return['message'] = $e->getMessage();
        }
        die(Zend_Json::encode($return));
    }

}