[CLOSED] gross passenger flow

[caiwang]

Issue by unissoft-bj Wednesday Jan 14, 2015 at 09:20 GMT Originally opened as https://github.com/caiwang/ihostsrc/issues/13

---

10分钟间隔的毛客流曲线

echo " select netid, count(distinct(mac)) as cnt, concat(left(optime,15),'0:00') as timebyten from wlsta where optime>='2015-1 -12 06:00:00' and optime<='2015-1-14 16:00:00' and netid<>'catarc' group by netid,timebyten;" | mysql -uroot -p wlsp > wlsta.txt

[caiwang]

Comment by unissoft-bj Wednesday Jan 14, 2015 at 09:22 GMT

---

1小时间隔的毛客流曲线

echo " select netid, count(distinct(mac)) as cnt, concat(left(optime,14),'30:00') as timebyhour from wlsta where optime>='2015-1-12 00:00:00' and optime<='2015-1-14 16:00:00' and netid<>'catarc' group by netid,timebyhour;" | mysql -uroot -p wlsp > wlsta.txt

[caiwang]

Comment by unissoft-bj Wednesday Jan 14, 2015 at 09:42 GMT

---

一个月毛客流（小时间隔）

echo " select netid, count(distinct(mac)) as cnt, concat(left(optime,14),'30:00') as timebyhour from wlsta where optime>='2014-12-10 00:00:00' and netid<>'catarc' and netid<>'ihost-home' group by netid,timebyhour;" | mysql -uroot -p wlsp > wlsta.txt

[caiwang]

Comment by unissoft-bj Wednesday Jan 14, 2015 at 10:04 GMT

---

一个月毛客流（天间隔）

echo " select netid, count(distinct(mac)) as cnt, left(optime,10) as timebyday from wlsta where optime>='2014-12-10 00:00:00' and netid<>'catarc' and netid<>'ihost-home' group by netid,timebyday;" | mysql -uroot -p wlsp > wlsta.txt

[caiwang]

Comment by unissoft-bj Wednesday Jan 14, 2015 at 14:57 GMT

---

一个月毛客流（月间隔，rssi>=-75）

echo " select netid, count(distinct(mac)) as cnt, left(optime,10) as timebyday from wlsta where optime>='2014-12-10 00:00:00' and netid<>'catarc' and netid<>'ihost-home' and rssi>='-75' group by netid,timebyday;" | mysql -uroot -p wlsp > wlsta.txt

[caiwang]

Comment by unissoft-bj Wednesday Jan 14, 2015 at 15:16 GMT

---

-65dbm

echo " select netid, count(distinct(mac)) as cnt, left(optime,10) as timebyday from wlsta where optime>='2014-12-10 00:00:00' and netid<>'catarc' and netid<>'ihost-home' and rssi>='-65' group by netid,timebyday;" | mysql -uroot -p wlsp > wlsta.txt

[caiwang]

Comment by unissoft-bj Wednesday Jan 14, 2015 at 15:23 GMT

---

-60dbm

echo " select netid, count(distinct(mac)) as cnt, left(optime,10) as timebyday from wlsta where optime>='2014-12-10 00:00:00' and netid<>'catarc' and netid<>'ihost-home' and rssi>='-60' group by netid,timebyday;" | mysql -uroot -p wlsp > wlsta.txt

[caiwang]

Comment by unissoft-bj Wednesday Jan 14, 2015 at 15:23 GMT

---

-55dbm

echo " select netid, count(distinct(mac)) as cnt, left(optime,10) as timebyday from wlsta where optime>='2014-12-10 00:00:00' and netid<>'catarc' and netid<>'ihost-home' and rssi>='-55' group by netid,timebyday;" | mysql -uroot -p wlsp > wlsta.txt

[caiwang]

Comment by unissoft-bj Wednesday Jan 14, 2015 at 15:33 GMT

---

-50dbm

echo " select netid, count(distinct(mac)) as cnt, left(optime,10) as timebyday from wlsta where optime>='2014-12-10 00:00:00' and netid<>'catarc' and netid<>'ihost-home' and rssi>='-50' group by netid,timebyday;" | mysql -uroot -p wlsp > wlsta.txt