/home/mjc1/public_html/manage/admin_include_test.php


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
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
<?     include("./include/admin_include_header.php"); ?>

        <div class="container">
            <div class="aside">
                <span>
                    <div class="adminMenu" style="height:317px;">
                        <ul>
                            <li class="first"><img src="./images/admin_include/left01.jpg"></li>
                            <li><a href="./company_info.php?menu=1">1. È¸»çÀÎÀç»ó</a></li>
                            <li><a href="./company_info.php?menu=2">2. ±Ù¹«¼öÄ¢</a></li>
                            <li><a href="./company_info.php?menu=3">3. ºÀ±Þ±ÔÁ¤</a></li>
                            <li><a href="./company_info.php?menu=4">4. Æ÷»óÁ¦µµ</a></li>
                            <li><a href="./company_info.php?menu=5">5. ÆÀÀåÁ¦µµ</a></li>
                            <li><a href="./company_info.php?menu=6">6. Áø±ÞÁ¦µµ</a></li>
                            <li><a href="./company_info.php?menu=7">7. ÈÞ¹«/¿¬Â÷</a></li>
                            <li><a href="./company_info.php?menu=9">8. °æÁ¶»ç</a></li>
                            <li class="last"><a href="./company_info.php?menu=8">9. È¸»çºñÀü</a></li>
                        </ul>
                    </div><!-- //adminMenu -->
                    <div class="adminMenu" style="height:197px;">
                        <ul>
                            <li class="first"><img src="./images/admin_include/left02.jpg"></li>
                            <li><a href="memberList.php?menu=1&sub=1">1. È¸¿ø°ü¸®</a></li>
                            <li><a href="productManage.php">2. »óǰ°ü¸®</a></li>
                            <li><a href="memberBoardManage.php">3. ¼­ºñ½º°Ô½ÃÆÇ</a></li>
                            <li><a href="nomalBoardManage.php">4. ÀÏ¹Ý°Ô½ÃÆÇ</a></li>
                            <li class="last"><a href="orderList.php">5. °áÁ¦¸®½ºÆ®</a></li>
                        </ul>
                    </div><!-- //adminMenu -->

                    <div class="adminMenuBtn">
                        <ul>
                            <li class="first"></li>
                            <li><a href="sawon_list.php"><img src="./images/admin_include/left03.jpg" alt=""></a></li>
                            <li><a href="jungpung.php"><img src="./images/admin_include/left04.jpg" alt=""></a></li>
                            <li class="lastMenu">
                                <a href="millennium_view.php"><img src="./images/admin_include/left05.jpg" alt=""></a>
                            <? if($_SESSION['ADMINID'] == "csh" || $_SESSION['ADMINID'] == "kjunggu"){ ?>
                                <a href="millennium_info.php"><img src="./img/lock.gif" alt=""></a>
                            <? ?>
                            </li>
                            <li class="last"></li>
                        </ul>
                    </div><!-- //adminMenu -->
                </span>

            </div><!-- //aside -->

            <div class="admin_contents">

<?

    
//*************A/S °ü¸® ¼­ºñ½º ¹Ì¿Ï·á °Ô½Ã¹° ¼ö***************/
    
$SelectQry1 "select count(*) as cnt from mBoard_as where thread = 'a' and proResult <> 'E'  ";
    
$sSQL_result1  =  mysql_query($SelectQry1);
    
$row1  =  mysql_fetch_array($sSQL_result1);

    
//*************µô·¯ÁÖ¹®°ü¸® ¹Ì󸮠°Ô½Ã¹° ¼ö***************/
    
$SelectQry2 "select count(*) as cnt from dealerorder where bsend = 0 ";
    
$sSQL_result2  =  mysql_query($SelectQry2);
    
$row2  =  mysql_fetch_array($sSQL_result2);

    
//*************µô·¯°¡ÀÔ°ü¸® ¹Ì½ÂÀΠ°Ô½Ã¹° ***************/
    
$SelectQry3 "select count(*) as cnt from mBoard_dealer where d_ok = 0 ";
    
$sSQL_result3  =  mysql_query($SelectQry3);
    
$row3  =  mysql_fetch_array($sSQL_result3);

    
//*************°ßÀû¼­¿äû ¹Ì¿Ï·á °Ô½Ã¹° ¼ö***************/
    
$SelectQry4 "select count(*) as cnt from mBoard_consult where gubun = 0 ";
    
$sSQL_result4  =  mysql_query($SelectQry4);
    
$row4  =  mysql_fetch_array($sSQL_result4);

    
//*************¾÷µ¥ÀÌÆ®Á¦¾È ¹Ì¿Ï·á °Ô½Ã¹° ¼ö***************    /
    
$SelectQry5 "select count(*) as cnt from mBoard_build where thread = 'a' and proResult <> 'E'  ";
    
$sSQL_result5  =  mysql_query($SelectQry5);
    
$row5  =  mysql_fetch_array($sSQL_result5);

?>


                <div class="admin_left">
                    <h3><img src="./images/admin_include/today.jpg" alt="¿À´ÃÀÇ ÇÒ ÀÏ"></h3>
                    <table class="diary">
                        <colgroup>
                            <col style="width:140px;"><col style="width:140px;"><col style="width:140px;">
                        </colgroup>
                        <tr>
                            <th><a href="asBoard.php">Áú¹®°ú´äº¯</a></th>
                            <th><a href="dealerBoard.php">µô·¯ÁÖ¹®</a></th>
                            <th><a href="dealer_admin.php">µô·¯°¡ÀÔ</a></th>
                        </tr>
                        <tr>
                            <td><a href="asBoard.php"><?=$row1['cnt'];?></a></td>
                            <td><a href="dealerBoard.php"><?=$row2['cnt'];?></a></td>
                            <td><a href="dealer_admin.php"><?=$row3['cnt'];?></a></td>
                        </tr>
                        <tr>
                            <th><a href="consultBoard.php">°ßÀû¼­¿äû</th>
                            <th><a href="buildBoard.php">¾÷µ¥ÀÌÆ®Á¦¾È</th>
                            <th></th>
                        </tr>
                        <tr>
                            <td><a href="consultBoard.php"><?=$row4['cnt'];?></a></td>
                            <td><a href="buildBoard.php"><?=$row5['cnt'];?></a></td>
                            <td></td>
                        </tr>
                    </table>

                    <div class="admin_view">
                        <h4><a href="./receipt.php"><img src="./images/admin_include/receipt.jpg" alt="¿µ¼öÁõ»ùÇÃ(õ³â°æ¿µ/PDA/õ³â°æ¿µS)"></a></h4>
                        <ul>
                            <li class="first"><a href="./pdapicture.php"><img src="./images/admin_include/local.jpg" alt="PDA·ÎÄà¹öÀü È­¸éº¸±â"></a></li>
                            <li><a href="./pdapicture2.php"><img src="./images/admin_include/real.jpg" alt="PDA½Ç½Ã°£ ¹öÀü È­¸éº¸±â"></a></li>
                        </ul>
                    </div><!-- //admin_view -->

                    <div class="admin_bbs">
                        <h3><a href="orderList.php"><img src="./images/admin_include/pay.jpg" alt="°áÁ¦¸®½ºÆ®"></a></h3>
                        <ul class="bbs_payment">

<? //-- °áÁ¦¸®½ºÆ®
    
$noticeSql        =   " select * from mBoard_order order by idx desc limit 10 ";
    
$noticeResult     =    mysql_query($noticeSql);

    if( 
mysql_num_rows($noticeResult) > ){
        while (
$noticeRow =  mysql_fetch_array($noticeResult)){
            
$reg_date  =  $noticeRow['reg_date'].substr(1,7);
?>
                            <li>
                                <a href="orderList.php?uid=<?/*=$noticeRow['uid'];*/?>&re=n" class="company"><?=cutstr($noticeRow['OrdNm'],8,"..");?></a>
                                <a href="orderList.php?uid=<?/*=$noticeRow['uid'];*/?>&re=n" class="product"><?=cutstr($noticeRow['rProdNm'],21,"..");?></a>
                                <span class="bar">|</span>
                                <a href="orderList.php?uid=<?/*=$noticeRow['uid'];*/?>&re=n" class="date"><?=$reg_date;?></a>
                            </li>
<?
        
}
    }
?>
                        </ul>
                    </div><!-- //bbs_payment -->

                </div><!-- //admin_left -->


                <div class="admin_right">
                    <div class="download">
                        <a href="admin_etax.php" class="tax"><img src="./images/admin_include/bill.jpg" alt="°í°´ ¼¼±Ý°è»ê¼­ ¹ßÇà"></a>
                        <a href="admin_download.php" class="work_btn"><img src="./images/admin_include/work.jpg" alt="¾÷¹«½Ã½ºÅÛ ´Ù¿î·Îµå"></a>
                        <a href="../html/millennium/customerupdate.php" class="work_btn"><img src="./images/admin_include/download.jpg" alt="Á¦Ç° ´Ù¿î·Îµå"></a>
                    </div><!-- //download -->                


                    <div class="admin_bbs">
                        <h3><a href="asBoard.php"><img src="./images/admin_include/as.jpg" alt="A/S°Ô½ÃÆÇ"></a></h3>
                        <ul class="bbs_payment">
                        <?
                            
//-- a/s °Ô½ÃÆÇ
                            
$noticeSql        =   " select * from mBoard_as where thread = 'A' order by uid desc limit 10 ";
                            
$noticeResult     =    mysql_query($noticeSql);

                            if( 
mysql_num_rows($noticeResult) > ){
                                while (
$noticeRow =  mysql_fetch_array($noticeResult)){
                                    
$reg_date  =  date('Y-m-d',$noticeRow['reg_date'] );
                        
?>
                            <li>
                                <a href="asBoardEdit.php?uid=<?=$noticeRow['uid'];?>&re=n" class="qna"><?=cutstr($noticeRow['subject'],20,"..");?></a>
                                <span class="bar">|</span>
                                <a href="orderList.php?uid=<?/*=$noticeRow['uid'];*/?>&re=n" class="date2"><?=$reg_date;?></a>
                            </li>

                        <?
                                
}
                            }
                        
?>

                        </ul>
                    
                    </div><!-- //bbs_as -->
                </div><!-- //admin_right -->

                <div class="footer" style="position:absolute; bottom:0;">
                    <?    include("./include/admin_include_footer.php"); ?>
                </div><!-- //footer -->

        </div><!-- //container -->
    </div><!-- //wrap -->

</body>
</html>