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
|
<?php
$dir = "..";
include_once($dir."/../common.php");
include_once("./_common2.php");
header('Content-type: application/json');
$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_web = @mysql_connect($DB_HOST,$DB_USER,$DB_PWD);
@mysql_select_db( $DB_NAME,$connect_web);
mysql_query("set session character_set_connection=utf8;");
mysql_query("set session character_set_results=utf8;");
mysql_query("set session character_set_client=utf8;");
$today = $_POST['today'];
$cnt = $_POST['cnt'];
$seq = $_POST['seq'];
$sql = "SELECT a.seq,
a.sdate, min(a.stime) as stime, a.etime, a.cname,
IFNULL(b.`status`,'도소매') AS status_r, IFNULL(b.item,'') AS item_r,
a.sdam, a.bigo, a.complete
FROM jangbu_tellist AS a
LEFT JOIN jangbu_maechul AS b ON a.cname = b.name
WHERE
a.sdate = '{$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
ORDER BY stime desc
limit 1";
$res = mysql_query($sql,$connect_web);
if(!$res) { echo mysql_error(); }
$data = array();
while($info=mysql_fetch_array($res)){
$list_arr[] = $info;
array_push($data,
array(
$data['seq'] = $info['seq'],
$data['stime'] = $info['stime'],
$data['etime'] = $info['etime'],
$data['status_r'] = iconv('EUC-KR', 'UTF-8', $info['status_r']),
$data['cname'] = iconv('EUC-KR', 'UTF-8', $info['cname']),
$data['sdam'] = iconv('EUC-KR', 'UTF-8', $info['sdam']),
$data['bigo'] = iconv('EUC-KR', 'UTF-8', $info['bigo']),
$data['complete'] = $info['complete']
));
}
$json = json_encode($data, JSON_PRETTY_PRINT|JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES);
echo $json;
?>
|