<?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'";
	$add_sql1 = "where 1=1";

	$ds_type = "A0";	//A0 : 매입
	$add_sql.= " AND s.ds_type = '$ds_type' ";

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

	if($dt_start != "" && $dt_end != ""){
		$sql1 = $sql1. " AND d.dt_insert between '$dt_start' and '$dt_end' ";
	}

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

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

	$orderby = "order by st.cnt desc";

	////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

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

	$sql = "SELECT
				st.*
				, d.*
				, d.nm_hp as dealer_nm_hp
				, d.dt_insert as dealer_dt_insert
				from
				(
					select t.cd_dealer_p, count(*) cnt
						from sale_master s
						inner join tender_master t on (s.cd_sale = t.cd_sale and s.ds_status = 'ZS' and t.ds_status = 'Z0' AND t.ds_delind = 'N')
							$add_sql
					group by t.cd_dealer_p
				) st
				inner join aap_master d on (st.cd_dealer_p = d.cd_dealer and d.ds_type = 'D0')
					$add_sql1
				$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'] 	= $col['nm_name'];
		$DATA['dealer_nm_hp'] 		= $col['dealer_nm_hp'];
		$DATA['cnt'] 		= $col['cnt'];
		$DATA['dealer_dt_insert'] 	= $col['dealer_dt_insert'];


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

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

	$cells = array(
		'A' => array(15, 'no', '번호'),
		'B' => array(20, 'nm_name',  '업체명'),
		'C' => array(40, 'dealer_nm_hp', '연락처'),
		'D' => array(20, 'cnt', '구매확정차량'),
		'E' => array(20, 'dealer_dt_insert', '회원가입일'),
	);

	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;

?>