微擎excel导出/导出集合

微擎excel 导出

    public function doWebImport(){
        global $_W, $_GPC;
        $uniacid=$_W['uniacid'];
            $data = $_GPC['file'];
            $file = $_FILES['file'];
            
            if (!$file['size']) {
                message("文件上传不能为空！");
            }
            if ($file['name'] && $file['error'] == 0) {
                $type = @end(explode('.', $file['name']));
                $type = strtolower($type);
                if (!in_array($type, array('xls','xlsx'))) {
                    message('文件格式不正确！','', 'error');
                }
                set_time_limit(0);
                include IA_ROOT .'/framework/library/phpexcel/PHPExcel.php';
                include IA_ROOT .'/framework/library/phpexcel/PHPExcel/IOFactory.php';
                if ($type == 'xls') {
                    $inputFileType = 'Excel5';
                }else{
                    $inputFileType = 'Excel2007';
                }
                $objReader = PHPExcel_IOFactory::createReader($inputFileType);
                $objPHPExcel = $objReader->load($file['tmp_name']);
                $sheet = $objPHPExcel->getSheet(0);
                //获取行数与列数
                $highestRow = $sheet->getHighestRow();
                $highestColumn = $sheet->getHighestColumn();
                $highestColumnNum = PHPExcel_Cell::columnIndexFromString($highestColumn);
                $usefullColumnNum = $highestColumnNum;
                for($row = 2; $row <= $highestRow;$row++){
                    // $cardno = $sheet->getCellByColumnAndRow(0, $row)->getValue();
                    $seriesid = $sheet->getCellByColumnAndRow(1, $row)->getValue();
                    $name = $sheet->getCellByColumnAndRow(2, $row)->getValue();
                    $brand_id = $sheet->getCellByColumnAndRow(3, $row)->getValue();
                    $brand = $sheet->getCellByColumnAndRow(4, $row)->getValue();
                    //插入字段
                    $data = array(
                        // 'id' => $cardno,
                        'seriesid' => $seriesid,
                        'name' => $name,
                        'brand_id' => $brand_id,
                        'uniacid' => 5,
                        'brand' => $brand,
                        
                        
                    );
                    

                   
                    pdo_insert('monai_market_car_train', $data);
                }
                message('导入成功');
            }else{
                message('导入失败');
            }
          
        
    }

导出 

//参数自定义 根据需要
public function imports(){
global $_GPC, $_W;
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';


if($operation=='imports'){
	// $seller_id=$_COOKIE["storeid"];
	if($type!='all'){
		$status = $status;
		$sql="SELECT * FROM ".tablename('zh_jdgjb_order')." where `uniacid`='8' and `status`='$status' ORDER BY id DESC";
	}else{
		
		$sql="SELECT * FROM ".tablename('zh_jdgjb_order')." where `uniacid`='8' ORDER BY id DESC";
	}
	$list = pdo_fetchall($sql);
	// var_dump($list);
	// die;
	require_once IA_ROOT . '/framework/library/phpexcel/PHPExcel.php';
	require_once IA_ROOT . '/framework/library/phpexcel/PHPExcel/Writer/Excel5.php';
	$objPHPExcel = new PHPExcel(); 
	$objPHPExcel->getProperties()->setCreator("Phpmarker")->setLastModifiedBy("Phpmarker")->settitle("Phpmarker")->setSubject("Phpmarker")->setDescription("Phpmarker")->setKeywords("Phpmarker")->setCategory("Phpmarker");
	$objPHPExcel->getActiveSheet()->settitle('Phpmarker-' . date('Y-m-d'));
	$objPHPExcel->setActiveSheetIndex(0);
	ob_end_clean();
	$objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(15);
	$objPHPExcel->getActiveSheet()->freezePane('A10');
	$objPHPExcel->setActiveSheetIndex(0)
	->setCellValue('A1', '订单号') 
	->setCellValue('B1', '店名')
	->setCellValue('C1', '地址')
	->setCellValue('D1', '入住时间')
	->setCellValue('E1', '离店时间')
	->setCellValue('F1', '到店时间')
	->setCellValue('G1', '价格')
	->setCellValue('H1', '房间数量')
	->setCellValue('I1', '入住天数')
	->setCellValue('J1', '房型')
	->setCellValue('K1', '床型')
	->setCellValue('L1', '预定人')
	->setCellValue('M1', '电话')
	->setCellValue('N1', '状态')
	->setCellValue('O1', '折扣后价格')
	->setCellValue('P1', '押金金额')
	->setCellValue('Q1', '优惠券价格')
	->setCellValue('R1', '会员折扣金额')
	->setCellValue('S1', '总价格')
	->setCellValue('T1', '已退押金');
	foreach ($list as $key => $value) {
	$l1="A".($key+2);   //循环 显示到  哪些行上面    
	$l2="B".($key+2);
	$l3="C".($key+2);
	$l4="D".($key+2);
	$l5="E".($key+2);
	$l6="F".($key+2);
	$l7="G".($key+2);
	$l8="H".($key+2);
	$l9="I".($key+2);
	$l10="J".($key+2); 
	$l11="K".($key+2);
	$l12="L".($key+2);
	$l13="M".($key+2);
	$l14="N".($key+2);
	$l15="O".($key+2);
	$l16="P".($key+2);
	$l17="Q".($key+2);
	$l18="R".($key+2);
	$l19="S".($key+2);
	$l20="T".($key+2);
	$objPHPExcel->setActiveSheetIndex(0)
	->setCellValue($l1, $value['out_trade_no']) 
	->setCellValue($l2, $value['seller_name'])
	->setCellValue($l3, $value['seller_address'])
	->setCellValue($l4, $value['arrival_time'])
	->setCellValue($l5, $value['departure_time'])
	->setCellValue($l6, $value['dd_time'])
	->setCellValue($l7, $value['price'])
	->setCellValue($l8, $value['num'])
	->setCellValue($l9, $value['days'])
	->setCellValue($l10, $value['room_type'])
	->setCellValue($l11, $value['bed_type'])
	->setCellValue($l12, $value['name'])
	->setCellValue($l13, $value['tel'])
	->setCellValue($l14, $value['status'])
	->setCellValue($l15, $value['dis_cost'])
	->setCellValue($l16, $value['yj_cost'])
	->setCellValue($l17, $value['yhq_cost'])
	->setCellValue($l18, $value['yyzk_cost'])
	->setCellValue($l19, $value['total_cost'])
	->setCellValue($l20, $value['ytyj_cost']);
	}
	$objPHPExcel->getActiveSheet()->setTitle('订单表'.date("m-d",time())); 
	$objPHPExcel->setActiveSheetIndex(0); 
	$filename='订单表'.date("m-d",time());
   	header('Content-Type: application/vnd.ms-excel');
   	header('Content-Disposition: attachment;filename="'.$filename.'.xls"');
   	header('Cache-Control: max-age=0');
   	header('Cache-Control: max-age=1');
  	header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
   	header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
   	header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
   	header('Pragma: public'); // HTTP/1.0         
  	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); 
  	$objWriter->save('php://output'); 

  	exit; 
}
}