echajoa/manage/purchase/purchase_view_excel.php

<?php
	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
	include $_SERVER['DOCUMENT_ROOT'].ADMIN_PATH.'common/auth_chk.php';
	include $_SERVER['DOCUMENT_ROOT'].'/vendor/autoload.php';


	$searchtype 	= $_REQUEST['searchtype'];
	$searchword 	= $_REQUEST['searchword'];
	$ds_usertype 	= $_REQUEST['ds_usertype'];
	$dt_start 		= $_REQUEST['dt_start'];
	$dt_end 		= $_REQUEST['dt_end'];
	$ds_status 		= $_REQUEST['ds_status'];


	$add_sql = "where s.ds_delind='N'";

	$cd_dealer = $_REQUEST['cd_dealer'];

	$ds_type = "A0";	//A0 : 매입
	$add_sql.=  "	and s.ds_type = '$ds_type' ";
	$add_sql.= "	and t.cd_dealer_p = '$cd_dealer' ";

	if($searchword != ""){
		if($searchtype=="" || $searchtype==null){
			$add_sql.=  "	and (s.nm_name like '$searchword%' or a.nm_number like '$searchword%') ";
		}else{
			$add_sql.=  "	and $searchtype like '$searchword%'";
		}
	}

	if($dt_end_start != "" && $dt_end_end != ""){
		$add_sql.=  "	and s.dt_end between '$dt_end_start' and '$dt_end_end' ";
	}

	if($ds_usertype != ""){
		$add_sql.=  "	and s.ds_usertype = '$ds_usertype'";
	}

	$add_sql.=  "	and s.ds_status in ('ZS') ";
	////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

	$spreadsheet = new PhpOffice\PhpSpreadsheet\Spreadsheet();
	$sheet = $spreadsheet->getActiveSheet();

	$sql = "SELECT
				a.*
				, b.nm_model
				, d.nm_brand
				, getCode('car_master','ds_type',a.ds_type) as nm_type
				, getCode('car_master','ds_open',a.ds_open) as nm_open
				, getCode('car_master','ds_sales',a.ds_sales) as nm_sales
				, getCode('car_master','ds_transmission',a.ds_transmission) as nm_transmission
				, getCode('member_master','ds_area',s.ds_area) as nm_area
				, getCode('sale_master','ds_status',s.ds_status) as nm_status
				, s.cd_sale
				, s.nm_name nm_name_sale
				, s.nm_recommend nm_recommend_sale
				, s.ds_status ds_status_sale
				, s.ds_status_contract ds_status_contract_sale
				, s.nm_price_final nm_price_final_sale
				, t.nm_name nm_name_tender
				, t.nm_price nm_price_tender
				, s.dt_end dt_end_sale
				FROM sale_master s
					inner join tender_master t on (s.cd_sale = t.cd_sale and t.ds_status = 'Z0' AND t.ds_delind = 'N')
					inner join car_master a on (s.cd_car = a.cd_car)
					left outer join car_model b on (a.cd_model = b.cd_model)
					left outer join car_brand d on (a.cd_brand = d.cd_brand)
					$add_sql $orderby";

	$r = mysql_query($sql, $connect);
	// echo $sql;
	// exit;
	$i=1;
	$EXCEL_DATA = array();
	while($col = mysql_fetch_assoc($r)) {
		#리스트
		$DATA  = array();
		$DATA['no'] 			= (string)$i;
		$DATA['nm_name_sale'] 	= $col['nm_name_sale'];
		$DATA['car_info'] 		= $col['nm_brand']." ".$col['nm_model'];
		$DATA['nm_number'] 		= $col['nm_number'];
		$DATA['nm_area'] 		= $col['nm_area'];
		$DATA['nm_price_final_sale'] 	= $col['nm_price_final_sale'].'만원';
		$DATA['nm_name_tender'] 	= $col['nm_name_tender'];
		$DATA['dt_end'] 		= $col['dt_end_sale'];

		$EXCEL_DATA[] = $DATA;
		unset($DATA);

		$i++;
	}
	mysql_close($connect);

	$cells = array(
		'A' => array(15, 'no', '번호'),
		'B' => array(20, 'nm_name_sale',  '판매자'),
		'C' => array(40, 'car_info', '차종'),
		'D' => array(20, 'nm_number', '차량번호'),
		'E' => array(20, 'nm_area', '판매지역'),
		'F' => array(20, 'nm_price_final_sale', '판매금액'),
		'G' => array(20, 'nm_name_tender', '낙찰자'),
		'H' => array(20, 'dt_end', '판매완료일')
	);

	foreach ($cells as $key => $val) {
		$cellName = $key.'1';
		$sheet->getColumnDimension($key)->setWidth($val[0]);
		$sheet->getRowDimension('1')->setRowHeight(25);
		$sheet->setCellValue($cellName, $val[2]);
		$sheet->getStyle($cellName)->getFont()->setBold(true);
		$sheet->getStyle($cellName)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
		$sheet->getStyle($cellName)->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER);
	}
	for ($i = 2; $row = array_shift($EXCEL_DATA); $i++) {
		foreach ($cells as $key => $val) {
			$sheet->setCellValue($key.$i, $row[$val[1]]);
		}
	}

	$filename = '관리자_구매확정_판매완료_엑셀_'.date('Y-m-d');
	header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
	header('Content-Disposition: attachment; filename="'.$filename.'.xlsx"');
	$writer = new PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
	$writer->save('php://output');

	exit;

?>