openid;
setcookie('user_openid', $openid, 0, '/');
}
}
require_once "jssdk.php";
$jssdk = new JSSDK(APPID, APPSECRET);
$signPackage = $jssdk->GetSignPackage();
$pdo=conn();
$sql="select a.pos_x,a.pos_y
from run_bus_pos as a
inner join (
select RUN_ID,RUN_BUS_ORDER_ID
from order_main
where PARENT_ORDER_ID=(
select order_id
from order_weixin_bond
where weixin_open_id='".$openid."'
order by id desc
limit 1)
and CANCEL_FLAG=0 and ORDER_VALID_STATUS=1 and IF_LAST_PROD=1 limit 1
) as b on a.run_id=b.RUN_ID and a.bus_no=b.RUN_BUS_ORDER_ID ORDER BY a.log_time DESC LIMIT 1";
write_log($sql);
$result=$pdo->query($sql);
$rowset=$result->fetchAll(PDO::FETCH_ASSOC);
$result->closeCursor();
write_log($rowset[0]['pos_x'].",".$rowset[0]['pos_y']);
$latitude=isset($rowset[0]['pos_x']) && !empty($rowset[0]['pos_x']) ?$rowset[0]['pos_x']:31.2031650000;
$longitude=isset($rowset[0]['pos_y']) && !empty($rowset[0]['pos_y']) ?$rowset[0]['pos_y']:121.3214510000;
convert_baidumap_to_tencentmap($latitude,$longitude);
?>