<?php
require_once('config.php');
require_once "PHPExcel.php";
require_once "PHPExcel/IOFactory.php";




$id = 2037047;
$op = Service_OrderOption::getByField($id);

var_dump($op);
exit;
$renamepath = "F:/baiducloud/百度云同步盘/工作电脑2016/F/工作文档/进口系统/2018年/沙田/处理/2021年/06月/17/images20210616/images20210616/";
$sandir = "F:/baiducloud/百度云同步盘/工作电脑2016/F/工作文档/进口系统/2018年/沙田/处理/2021年/06月/17/images20210616/rename/";

$xlspath = "F:/baiducloud/百度云同步盘/工作电脑2016/F/工作文档/进口系统/2018年/沙田/处理/2021年/06月/17/200票订购人信息(1).xlsx";
/*$excelReader = PHPExcel_IOFactory::createReaderForFile($xlspath);
$excelReader->setReadDataOnly(true);
$sheet = $excelReader->load($xlspath);
$orderSheet = $sheet->getSheet(0);
$highestColum = $orderSheet->getHighestRow();*/
$title = array(
    '海关清单编号' => 'qdcode',
    'CB单号' => 'cbcode',
    '订购人'=>'dgr',
    '订购人证件类型'=>'idtype',
    '订购人证件号码'=>'idcode',
    '订购人电话'=>'phone',
    '图片url'=>'url',
    '图片name'=>'urlname',
);
$resultArray = Common_Upload::readXlsFromTitle($xlspath,$title);

$excel = PHPExcel_IOFactory::load($xlspath);
$sheet = $excel->getSheet(0);

foreach ($resultArray as $k=>$val){
    $file = $renamepath.$val['urlname'].".jpg";
    if(file_exists($file)){
        $copyname = $sandir.$val['dgr'].".jpg";
        if(copy($file,$copyname)){
            $sheet->setCellValue('J'.$k,'1');//
        }else{
            $sheet->setCellValue('J'.$k,'3');//
        }
    }else{
        $sheet->setCellValue('J'.$k,'2');//
    }
}