|
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/api/ |
Upload File : |
<?php
header("Content-Type: application/json");
$g4_path = "..";
/*******************************************************************/
// 예약인원 변동사항을 TK에 업데이트 //
// FLOW : Zipline >> TK //
// CALL : crontab //
/*******************************************************************/
include "common.php"; // API Common
include "../admin/_common.php"; // Admin Common
// 개발 모드 설정 ★ 실제 운영 시 주의 ★
$allow_addr = array(
'119.67.250.2033', // 집
'14.6.87.1933' // TK사무실
);
if(in_array($_SERVER['REMOTE_ADDR'], $allow_addr) == true){
define('DEV_MODE', '1');
echo "###############################\n";
echo "########## 개발 모드 ##########\n";
echo "###############################\n";
} else {
define('DEV_MODE', '0');
}
if(DEV_MODE) echo ("===== TKPLACE - ZIPLINE : RESERVE COUNT START =====\n");
Log::save(sprintf("%s(%d) %s", __FILE__, __LINE__, "API START"), 'stock_update', 'tk/'.date('Ym'));
// 업데이트가 되지 않은 데이터 (ti_update_yn='N')
$sql = "select * from g4_write_reserve_count where ti_update_yn='N' order by ti_id DESC";
$result = sql_query($sql);
while ($row=sql_fetch_array($result)){
$key = strtoupper($row['ti_branch']).str_replace("-","", $row['ti_date']).str_replace(":", "", $row['ti_time']);
if(isset($data[$key]) == false) {
$data[$key] = $row;
}
}
echo ("Data Count : ".count($data)."\n");
Log::save(sprintf("%s(%d) Data Count %s", __FILE__, __LINE__, count($data)), 'stock_update', 'tk/'.date('Ym'));
// 예약인원 업데이트 쿼리
$path = "/goods/event-stock-zipline/";
foreach($data as $k => $v){
$call_data = array(
"site_id" => $v['ti_branch'], // 기존
"branch_id" => $v['ti_branch'],
"start_date" => $v['ti_date'],
"event_name" => $v['ti_time'],
"event_inwon" => $v['ti_reserve_count'],
);
$result = call($path, $call_data);
if(DEV_MODE) echo ("Call Data : ".json_encode($call_data)."\n");
if($result['status'] == 200){
// DB 처리
if(DEV_MODE == 0){
$sql = "update g4_write_reserve_count set ti_update_yn = 'Y' where ti_branch = '{$v['ti_branch']}' and ti_date = '{$v['ti_date']}' and ti_time = '{$v['ti_time']}' ";
if(DEV_MODE){ p("DB Process..."); }
Log::save(sprintf("%s(%d) DB Update Process : %s", __FILE__, __LINE__, $sql), 'stock_update', 'tk/'.date('Ym'));
sql_query($sql);
}
echo " ■ ";
} else {
echo " ■ " . $result['status'];
}
}
echo "\nEND";
?>