echajoa/cron/biztalk_time_limit.php

<?
/*
*   사용자 입찰 완료 (상태가 E0: 즉 입찰진행중인건에만 발송됨, 낙찰 또는 반려등등 상태가 변경되면 제외)
*   실행시간
*   매 5분 실행
*   입찰 마감된 데이터 중 상사가 입찰 한 건
*/

include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';

exit;

$senderKey = "4856a5e128f9289082c884d066f1df198cbb1165";
$tmpltCode = "time_limit";
$resMethod = "PUSH";
$cur_date = date('Y-m-d H:i:s');
//입찰 마감일
// $finish_date = date('Y-m-d H:i:s', strtotime($cur_date. LIMIT_TIME_TENDER.'hour'));

$sql = "select s.*, DATE_ADD(s.dt_approve, INTERVAL ".LIMIT_TIME_TENDER." HOUR)
            , d.nm_brand, b.nm_model, c.nm_grade, a.nm_mileage
            from sale_master s
            inner join car_master a on (s.cd_car = a.cd_car)
            inner join (
            	select cd_sale from tender_master
            	   where ds_delind = 'N'
            	group by cd_sale
            ) t on t.cd_sale = s.cd_sale
            left outer join car_model b on (a.cd_model = b.cd_model)
            left outer join car_grade c on (a.cd_grade = c.cd_grade)
            left outer join car_brand d on (a.cd_brand = d.cd_brand)
            left outer join car_model_sub e on (a.cd_model_sub = e.cd_model_sub)
                where s.ds_status IN('E0')
                    and DATE_ADD(s.dt_approve, INTERVAL ".LIMIT_TIME_TENDER." HOUR) < '$cur_date'
                    and s.finish_notify = 'N'
                    and s.ds_delind = 'N'
    ";
// echo $sql.'<br/>';
// exit;
//


$res = mysql_query($sql);
$cnt = mysql_num_rows($res);
if($cnt > 0) {
    $master_sql = "insert into kakao_biztalk set
                        status = 0
                        , senderKey = '".$senderKey."'
                        , tmpltCode = '".$tmpltCode."'
                        , resMethod = '".$resMethod."'
                        , send_date = '".$cur_date."'
                ";

    $master_res = mysql_query($master_sql);
    $cd_talk = mysql_insert_id();

    while($col = mysql_fetch_array($res)) {
        // print_r($col['cd_sale']);
        if(!empty($col['cd_sale'])) {
            //경매 정보에서 알림 메시지 발송 완료로 변경
            $sql = "update sale_master set
                        finish_notify = 'Y'
                        where cd_sale = '".$col[cd_sale]."' ";
            // echo $sql.'<br/>';
            // exit;
            mysql_query($sql);

            //최고 입찰 금액을 가져옴
            $r = mysql_query("SELECT t.*, d.nm_company nm_company_dealer, d.nm_name nm_name_dealer, s.ds_status ds_status_sale
                                , getRemainTimeByPhase(".LIMIT_TIME_TENDER.", ".LIMIT_TIME_SELL.", s.dt_approve, now()) as time_limit_sell
                                , d1.nm_name nm_name_dealer1
                                    FROM dealer_master d
                                    inner join tender_master t on (d.cd_dealer = t.cd_dealer_p and t.cd_sale = $col[cd_sale] and t.ds_delind='N')
                                    inner join dealer_master d1 on (t.cd_dealer = d1.cd_dealer)
                                    inner join sale_master s on (t.cd_sale = s.cd_sale)
                                ORDER BY cast(t.nm_price as unsigned) desc, t.cd_tender desc
                                LIMIT 1");

            $contents = "";
            while($dealer = mysql_fetch_array($r)) {
                $contents = $col[nm_name]."님 매물이 업데이트 되었습니다.

$col[nm_brand] $col[nm_model] $col[nm_grade] $col[nm_mileage]km

최고가 ".number_format($dealer[nm_price])." 만원 입니다.

마이페이지에 접속하셔서 입찰 금액을
확인주세요";

// $dealer[nm_company_dealer]." / ".$dealer[nm_name_dealer1]."  만원
// 최고입찰금액으로 입찰되었습니다.
//
// 마이페지에서 입찰금액을 확인해주세요
                // ECHO $contents;
                // exit;
            }


            //발송 대기 상태로 변경
            $recipient_sql = "INSERT INTO kakao_biztalk_recipient set
                                    cd_talk = '".$cd_talk."'
                                    , phone = '".$col[nm_hp]."'
                                    , status = '0'
                                    , contents = '".$contents."'
            ";
            // echo $recipient_sql;
            mysql_query($recipient_sql);
        }
    }

    //발송대기 상태로 변경
    mysql_query("update kakao_biztalk set status = '1' where cd_talk = '".$cd_talk."' ");
}
?>