query($sql);
if(!$result->num_rows) continue;
$data = $result->fetch_assoc();
switch($data['branch']) {
case '서울' :
case '경기' :
$branch = 'gangnam'; break;
case '부평' :
case 'bupyeong' :
case '인천' :
case 'incheon' :
$branch = 'bupyeong'; break;
default : $branch = $data['branch']; break;
}
$selectname = $data['add1']."/".$data['add2']."/".$data['add3']."/".$data['add4'];
$interlock_data = array(
"phone" => $data['phone'],
"name" => $data['name'],
"gender" => $data['gender'], //성별
"poss_time" => "",//상담가능시간
"etc5" => $branch, //지점
"branch" => $branch, //지점
"age" => $data['age'], //나이
"status" => $data['status'], //데이터 유효성
"landing_key" => $data['partner_id'], // 플란치과 연동코드는 파트너id 에 입력 예정
"event_num" => 'evt_'.$data['event_seq'], //이벤트 번호
"event_seq" => $data['event_seq'], //이벤트 번호
"add1" => $selectname, //설문
"reg_ip" => $data['ip'], //아이피
"ip" => $data['ip'], //아이피
"reg_date" => $data['reg_date'], //등록일
"mkt_chk" => 'N', //마케팅 동의 //케어랩스 랜딩에는 마케팅 동의 항목이 없으므로 N 으로 고정
"group_id" => 'evt_'.$data['event_seq'],
"outsource" => 'viberc',
);
$meta_url = "https://event.metamarketing.co.kr/lib/proc/viberc.php";
$ch = curl_init();
curl_setopt_array($ch, array(
CURLOPT_RETURNTRANSFER => 1,
CURLOPT_URL => $meta_url,
CURLOPT_POSTFIELDS => count($interlock_data),
CURLOPT_POSTFIELDS => $interlock_data
));
$result =curl_exec($ch);
curl_close($ch);
$is_success = 0;
$response = @json_decode($result, true);
if($response['result'] == 'success') {
$is_success = 1;
echo "{$data['seq']}-{$data['name']} ";
$update = $db->query("UPDATE zenith.event_leads SET interlock_success = 1 WHERE seq = {$data['seq']}");
if($update) {
echo "성공";
} else {
echo "실패";
echo $db->error;
print_r($response);
}
echo '
';
}
$data['send_data'] = @json_encode($interlock_data, JSON_UNESCAPED_UNICODE);
array_walk($data, function(&$string) use($db) { $string = $db->real_escape_string($string); }); //DB저장을 위해 escape 처리
//외부연동 내역
$sql = "INSERT INTO `zenith`.`event_leads_interlock`(`leads_seq`,`event_seq`,`url`,`partner_id`,`partner_name`,`paper_code`,`paper_name`,`send_data`,`response_data`,`is_success`)
VALUES('{$data['seq']}','{$data['event_seq']}','{$meta_url}','{$data['partner_id']}','{$data['partner_name']}','{$data['paper_code']}','{$data['paper_name']}','{$data['send_data']}','{$result}',{$is_success});";
$db->query($sql) or die($db->error);
}
}
//전송 실패 DB 목록
$data = [];
$sdate = date('Y-m-d');
$edate = date('Y-m-d');
if(isset($_GET['sdate'])) $sdate = $_GET['sdate'];
if(isset($_GET['edate'])) $edate = $_GET['edate'];
$sql = "SELECT ea.name AS advertiser, em.media, el.seq, el.name, DEC_DATA(el.phone) AS phone, eli.* FROM `zenith`.event_leads_interlock AS eli
LEFT JOIN `zenith`.event_leads AS el ON el.seq = eli.leads_seq
LEFT JOIN `zenith`.event_information AS ei ON eli.event_seq = ei.seq
LEFT JOIN `zenith`.event_advertiser AS ea ON ei.advertiser = ea.seq
LEFT JOIN `zenith`.event_media AS em ON ei.media = em.seq
WHERE ei.interlock = 1 AND el.interlock_success = 0 AND eli.is_success = 0 AND DATE(eli.reg_date) >= '{$sdate}' AND DATE(eli.reg_date) <= '{$edate}' AND eli.url LIKE 'https://event.metamarketing.co.kr%'
GROUP BY eli.leads_seq
ORDER BY eli.reg_date DESC
";
$result = $db->query($sql) or die($db->error);
// echo ''.print_r($result,1).'
';
if(!$result->num_rows) exit('No Data');
while($row = $result->fetch_assoc()) $data[] = array_map('strip_tags', $row);
?>
메타마케팅 외부연동 재전송
테크랩스 외부연동 재전송 프로그램