<?php
header ( "Content-type: text/html; charset=utf-8" );
date_default_timezone_set ( 'PRC' ); //设置中国时区
include 'PHPExcel.php';
$dir=dirname(__FILE__);
$filename = "/Users/jiangminghui/Documents/test/hantai/hantaipic.xlsx";
$objPHPExcel = PHPExcel_IOFactory::load($filename);//加载文件
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数
$src_path1 = '111.png';
$src_path2 = '222.png';
$src1 = imagecreatefromstring(file_get_contents($src_path1));
$src2 = imagecreatefromstring(file_get_contents($src_path2));
list($src_w1, $src_h1) = getimagesize($src_path1);
list($src_w2, $src_h2) = getimagesize($src_path2);
for($i=1;$i<=$highestRow;$i++) {
$A = $objPHPExcel->getActiveSheet()->getCell("A".$i)->getValue();
$B = $objPHPExcel->getActiveSheet()->getCell("B".$i)->getValue();
$C = $objPHPExcel->getActiveSheet()->getCell("C".$i)->getValue();
//从服务器获取图片++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
$url = 'https://xx.xx.com'.$C;
$ext = strrchr($url, ".");
$filename = $A.'_'.$B.$ext;
ob_start();//打开输出
readfile($url);//输出图片文件
$img = ob_get_contents();//得到浏览器输出
ob_end_clean();//清除输出并关闭
$size = strlen($img);//得到图片大小
$fp2 = @fopen($filename, "a");
fwrite($fp2, $img);//向当前目录写入图片文件,并重新命名
fclose($fp2);
//usleep(200000);
//return $filename;//返回新的文件名
$dst_path = 'img/'.$filename;
//创建图片的实例++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
$dst = imagecreatefromstring(file_get_contents($dst_path));
//获取水印图片的宽高
list($src_w0, $src_h0) = getimagesize($dst_path);
//将水印图片复制到目标图片上,最后个参数50是设置透明度,这里实现半透明效果
imagecopymerge($dst, $src1, 10, 10, 0, 0, $src_w1, $src_h1, 100);
//如果水印图片本身带透明色,则使用imagecopy方法
imagecopy($dst, $src2, $src_w0-$src_w2-10, $src_h0-$src_h2-10, 0, 0, $src_w2, $src_h2);
//输出图片
list($dst_w, $dst_h, $dst_type) = getimagesize($dst_path);
switch ($dst_type) {
case 1://GIF
header('Content-Type: image/gif');
imagegif($dst,$filename);
break;
case 2://JPG
header('Content-Type: image/jpeg');
imagejpeg($dst,$filename);
break;
case 3://PNG
header('Content-Type: image/png');
imagepng($dst,$filename);
break;
default:
break;
}
imagedestroy($dst);
echo "$i";
}
imagedestroy($src1);
imagedestroy($src2);
?>