微信 根据个人位置查询附近的活动

微信获取个人信息的方法不多说。主要讲如何计算

SELECT
	t.cname,
	t.deptname,
	t.telephone,
	ROUND(
		6378.138 * 2 * ASIN(
			SQRT(
				POW(
					SIN(
						(
							30.664385188806 * PI() / 180 - t.latitude * PI() / 180
						) / 2
					),
					2
				) + COS(30.664385188806 * PI() / 180) * COS(t.latitude * PI() / 180) * POW(
					SIN(
						(
							104.07559730274 * PI() / 180 - t.longitude * PI() / 180
						) / 2
					),
					2
				)
			)
		) * 1000
	) AS distance
FROM
	(
		SELECT
			c.cname,
			a.deptname,
			a.telephone,
			b.latitude,
			b.longitude
		FROM
			by_dept a
		INNER JOIN by_dept_datum b ON (a.id = b.did)
		INNER JOIN chuc_coupon_main c ON (a.id = c.deptid)
	) t
ORDER BY
	distance