1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
|
<?
include("./_common.php");
header("Content-type:text/html;charset=euc-kr");
include_once("./category/common.php");
$sql = "set names utf8";
$result = mysql_query($sql);
$keyword = iconv("EUC-KR","UTF-8",$keyword);
$cm_nCount = 10;
$cm_item_nCount = 30;
if( isset($keyword) && $keyword !== ""){
if( $searchCode == '1') $Code = " and smoption like '%$keyword%' ";
if( $searchCode == '2') $Code = " and smname like '%$keyword%' ";
//if( $searchCode == '3') $Code = " and admin like '%$keyword%' ";
}
//미결자료만보기
if ($chknotend) {
$chkend = " and gubun = $chknotend";
} else {
$chkend = "";
}
$total_sql .= " select smname, smdetail, proResult, reg_date from mBoard_cs3_req where uid > 0 $chkend $Code ";
$result = mysql_query($total_sql) or die (mysql_error());
$nTotalCount = mysql_num_rows($result);
$nPage = ceil($nTotalCount / $cm_nCount);
if ($pg == "") $pg = 1;
if ($_POST['search_mode'] == "Y"){ // 검색 시 페이징넘버 날리기 위해 아랫쪽 hidden 값 포함하여 선언 2013.12.02 by.jyh
$pg = 1;
}
$nFrom = ($pg - 1) * $cm_nCount;
$sql = $total_sql . " order by uid DESC ";
$result = mysql_query($sql) or die (mysql_error());
if($num = mysql_num_rows($result)){
while($row = mysql_fetch_object($result)) {
$info = null;
$col_cnt = 0;
foreach($row as $key=>$val){
if($key=='proResult'){
if($val=='0'){ $val = '미확인'; }
if($val=='1'){ $val = '처리완료'; }
if($val=='2'){ $val = '처리중'; }
if($val=='3'){ $val = '처리불가'; }
}
$info[$key] = $val;
$col_cnt++;
}
$list_array[] = $info;
}
}
//_pr($list_array); exit;
require_once "./phpexcel/PHPExcel.php";
$objPHPExcel = new PHPExcel();
$title_array = Array("상호","내용","처리상태","등록일" );
$col_cnt = count($title_array);
for($i=0;$i<$col_cnt;$i++){
if($i>25){
$vv = floor($i/26);
$v = $i-(26*$vv);
$alpha = chr(65+$v);
$alpha = chr(64+$vv).$alpha;
} else {
$alpha = chr(65+$i);
}
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue($alpha.'1', $title_array[$i]);
$objPHPExcel->getActiveSheet()->getColumnDimension($alpha)->setAutoSize(true);
}
for($i=0;$i<count($list_array);$i++){
$info = $list_array[$i];
$x = 0;
foreach($info as $key => $val){
if($key=='code'){ $code = $val; }
if($x>25){
$vv = floor($x/26);
$v = $x-(26*$vv);
$alpha = chr(65+$v);
$alpha = chr(64+$vv).$alpha;
} else {
$alpha = chr(65+$x);
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($alpha.($i+2), $val);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit($alpha.($i+3), $val, PHPExcel_Cell_DataType::TYPE_STRING); // 텍스트 형태 필요해서 해당부분으로 수정
$x++;
}
}
// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="cs_req_xls'.$limit.'.xls"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');
// If you're serving to IE over SSL, then the following may be needed
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');
?>
|