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
|
<?php
$DB_HOST = "114.108.136.196";
$DB_USER = "mj_inhouse_web";
$DB_PWD = "m897461z";
$DB_NAME = "mj_inhouse";
include('../manage/category/class_db.php');
$$connect_realtime = @mysql_connect($DB_HOST,$DB_USER,$DB_PWD);
@mysql_select_db( $DB_NAME,$$connect_realtime);
$today = date('Y-m-d');
$time = time();
$beforeyear = date("Y-m-d",strtotime("6month ago", $time));
$total_sql = "SELECT count(bb.sdate) as cnt
FROM
( SELECT sdate
FROM jangbu_tellist AS a
LEFT JOIN jangbu_maechul AS b ON a.cname = b.name
WHERE
a.sdate BETWEEN '{$beforeyear}' AND '{$today}' AND a.stime > '09:00:00' AND a.stime < '18:00:00' AND a.stime NOT BETWEEN '12:00:00' AND '13:00:00'
AND cname NOT LIKE '%¿À»ó¸ñ%' AND cname NOT LIKE '%¹ÌÁø¼ÒÇÁÆ®%' AND cname NOT LIKE '%¿¥Á¦À̼ÒÇÁÆ®%'
/*GROUP BY cname*/
) bb;";
$total_res = mysql_query($total_sql,$$connect_realtime);
$total_count = mysql_fetch_array($total_res);
$cnt_sql = "SELECT COUNT(*) AS cnt FROM mBoard_cus_after WHERE mark_flg = '1'";
$cnt_res = mysql_query($cnt_sql,$connect_web);
while($cnt_info = mysql_fetch_array($cnt_res)) {
$cnt = $cnt_info['cnt'];
}
?>
<style>
/* 24.02.08 ÀÌÇöÁ¤ ¼öÁ¤ */
/* ±¸¸Å»ó´ãÁøÇàÇöȲ / ±¸¸Å»ó´ãÁøÇàÇöȲ */
.m3_review_layer {position:relative; display:block; width:100%; color:#333; margin :130px 0}
.m3_review_layer * {font-family: 'Pretendard', sans-serif; line-height:1.15; letter-spacing:-1px}
.review_container {display:flex; padding: 0; justify-content: space-between; width:950px; height:175px; margin: 0 auto; }
.review_content {position:relative; width:50%; overflow:hidden; max-width:435px; border-radius:25px; overflow:hidden; background:#ebebeb; transition: all 0.3s; cursor:pointer}
.review_content::before {content:''; position:absolute; left:-173px; top:-80px; display:block; width:345px; height:345px; border-radius:50%; background:rgba(255,255,255,0.5);}
.review_content:hover {background:#ddd;}
.review_content .icon_box {position:relative; width:40%; height:100%; float:left;}
.review_content .icon_box img {margin-top:35px}
.review_content .content_box {height: 100%; position: relative; box-sizing: border-box;float:left; padding:25px 0 25px 20px; text-align:left}
.review_content:first-child .content_box {padding:25px 0 25px 20px;}
.review_content .content_box p {font-family: 'GmarketSansMedium', 'Nanum Gothic', '³ª´®°íµñ', 'ng', 'NanumGothicWeb','NanumBarunGothic', sans-serif; font-size:22px}
.review_content .content_box span {font-size:14px; margin-top:10px; display:inline-block; line-height:21px; height:22px; padding: 0 10px; border-radius:30px; border:1px solid #333}
.review_content .content_box a {position:relative; margin-top:36px; display:block; color:#333; font-size:14px; font-weight:600}
.review_content .content_box a::before {position: absolute; display: block; content: ''; left: 109px; bottom: -14px; width: 0.5px; height: 13px; background: #333; transform: rotate(-55deg);}
.review_content .content_box a::after {position: absolute; display: block; content: ''; left: 0; bottom: -11px; width: 115px; height: 1px; background: #333;}
</style>
<!-- 24.02.13 ÀÌÇöÁ¤ ¼öÁ¤ -->
<div class="m3_review_layer">
<p class="sec_tit" style="text-align:center; ">±¸¸Å»ó´ã(CS)<font style="font-weight:400">ÇöȲ / </font><font style="font-weight:400">¼ºñ½º</font> ÀÌ¿ëÈıâ</p>
<div class="n_wrap review_container">
<div class="review_content">
<div class="icon_box">
<img style="max-width:73%; margin-top:42px" src="./images/n_intro/review-ico-01.png" alt="">
</div>
<div class="content_box">
<p>½Ç½Ã°£ »ó´ãÇöȲ</p>
<span>»ó´ã°Ç¼ö <b><?php echo number_format($total_count['cnt']); ?></b></span>
<a href="./realtime_counsel.php"><img style="max-width:13px;margin-right:5px; margin-top:-2px" src="./images/n_intro/ico_view.png" alt="">Àüü º¸±â</a>
</div>
</div>
<div class="review_content">
<div class="icon_box">
<img style="max-width:50%; margin-top:46px" src="./images/n_intro/review-ico-02.png" alt="">
</div>
<div class="content_box">
<p>Á¦Ç°(CS) ÀÌ¿ëÈıâ</p>
<span>µî·Ï°Ç¼ö <b><?php echo number_format($cnt); ?></b></span>
<a href="./service_review_detail.php"><img style="max-width:13px;margin-right:5px; margin-top:-2px" src="./images/n_intro/ico_view.png" alt="">Àüü º¸±â</a>
</div>
</div>
</div>
</div>
|