91 lines
3.1 KiB
PHP
91 lines
3.1 KiB
PHP
<?
|
|
session_start();
|
|
include $_SERVER[DOCUMENT_ROOT] . "/common/conf/config.inc.php";
|
|
include $_SERVER[DOCUMENT_ROOT] . "/backoffice/auth/auth.php";
|
|
|
|
include $_SERVER[DOCUMENT_ROOT] . "/module/shop/shop.lib.php";
|
|
include $_SERVER[DOCUMENT_ROOT] . "/module/category/category.lib.php";
|
|
|
|
|
|
if(!in_array("shop_good_manage",$_SESSION[$_SITE["DOMAIN"]]["ADMIN"]["AUTH"]) && $_SESSION[$_SITE["DOMAIN"]]["ADMIN"]["GRADE"]!="ROOT"):
|
|
jsMsg("권한이 없습니다.");
|
|
jsHistory("-1");
|
|
endif;
|
|
|
|
//DB연결
|
|
$dblink = SetConn($_conf_db["main_db"]);
|
|
|
|
$scale=0;
|
|
|
|
if($_REQUEST[st]=="1"){
|
|
$order_by = " A.sort_num DESC, A.idx DESC ";
|
|
}else{
|
|
$order_by = " A.idx DESC ";
|
|
}
|
|
|
|
//상품 리스트
|
|
$arrList = getGoodListBaseNFile(
|
|
mysql_real_escape_string($_REQUEST[cat_no]),
|
|
$order_by,
|
|
mysql_real_escape_string($_REQUEST[sw]),
|
|
mysql_real_escape_string($_REQUEST[sk]),
|
|
$scale, $_REQUEST[offset],"");
|
|
|
|
|
|
//전체 카테고리 가져오기
|
|
$arrAllCategory = getCategoryAll();
|
|
|
|
//상품분류 리스트
|
|
$arrCategory = getCategoryList(0);//1차카테고리
|
|
|
|
$arrCategoryInfo = getCategoryInfo(mysql_real_escape_string($_REQUEST[cat_no]));
|
|
|
|
//카테고리 정보
|
|
$arrCatCode = explode("/", $arrCategoryInfo["list"][0][cat_code]);
|
|
|
|
//DB해제
|
|
SetDisConn($dblink);
|
|
|
|
//Header("Content-type: file/unknown");
|
|
header( "Content-type: application/vnd.ms-excel" );
|
|
header( "Content-Disposition: attachment; filename=".iconv("UTF-8","EUC-KR",$_SITE['NAME'])."_상품목록_".date(m)."월".date(d)."일".date(h)."시".date(i)."분.csv" );
|
|
header( "Content-Description: PHP4 Generated Data" );
|
|
header("Pragma: no-cache");
|
|
header("Expires: 0");
|
|
|
|
echo "번호,";
|
|
echo "상품분류,";
|
|
echo "상품명,";
|
|
echo "제조사,";
|
|
echo "제품규격,";
|
|
echo "판매가,";
|
|
echo "적립금,";
|
|
echo "상품진열여부,";
|
|
echo "상세설명,";
|
|
echo "등록일자\n";
|
|
|
|
for ( $i=0 ; $i < $arrList["total"] ; $i++ ) {
|
|
|
|
$arrThisCatCode = explode("/", $arrList["list"][$i][cat_code]);
|
|
for($j=0; $j <count($arrThisCatCode)-1;$j++){
|
|
$cate[$i] .= $arrAllCategory[$arrThisCatCode[$j]];
|
|
if($j < count($arrThisCatCode)-2) {
|
|
$cate[$i] .= " > ";
|
|
} else {
|
|
}
|
|
}
|
|
|
|
echo $i+1 . ",";
|
|
echo strip_tags(str_replace(",",".", stripslashes(iconv("UTF-8","EUC-KR",$cate[$i])))) . ",";
|
|
echo strip_tags(str_replace(",",".", stripslashes(iconv("UTF-8","EUC-KR",$arrList["list"][$i][g_name])))) . ",";
|
|
echo strip_tags(str_replace(",",".", stripslashes(iconv("UTF-8","EUC-KR",$arrList["list"][$i][vendor])))) . ",";
|
|
echo strip_tags(str_replace(",",".", stripslashes(iconv("UTF-8","EUC-KR",$arrList["list"][$i][model])))) . ",";
|
|
echo strip_tags(str_replace(",",".", stripslashes(iconv("UTF-8","EUC-KR",$arrList["list"][$i][price])))) . ",";
|
|
echo $arrList['list'][$i][point_unit]=="P"?number_format(($arrList['list'][$i][point]*$arrList['list'][$i][price])/100):number_format($arrList['list'][$i][point]) . ",";
|
|
|
|
echo strip_tags(str_replace(",",".", stripslashes(iconv("UTF-8","EUC-KR",$arrList["list"][$i][is_show])))) . ",";
|
|
echo "\"".strip_tags(str_replace(",",".", stripslashes(iconv("UTF-8","EUC-KR",$arrList["list"][$i][contents])))). "\",";
|
|
echo strip_tags(str_replace(",",".", stripslashes(substr($arrList["list"][$i][wdate],0,10)))) . "\n";
|
|
|
|
}
|
|
?>
|