[CLOSED] Net Passenger Flow

[caiwang]

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

---

echo "select mac,avg(rssi),timebyhour from wlpkt group by mac,timebyhour;" | mysql -uroot -prootatussp wlsp > wlpkt.txt

[caiwang]

Comment by unissoft-bj Tuesday Jan 20, 2015 at 11:13 GMT

---

echo "select mac,avg(rssi),timebyhour from wlpkt where mac in ( select mac from (select mac ,count(mac) as cntmac,rssi from wlpkt where rssi >='-75' group by mac) tblpktbig where cntmac>='20') group by mac,timebyhour;" | mysql -uroot -prootatussp wlsp > wlpkt.txt

[caiwang]

Comment by unissoft-bj Tuesday Jan 20, 2015 at 11:35 GMT

---

echo "select mac,avg(rssi),timebyhour from wlpkt where mac in ( select mac from (select mac ,count(mac) as cntmac,rssi from wlpkt where rssi >='-75' group by mac) tblpktbig where cntmac>='50') group by mac,timebyhour;" | mysql -uroot -prootatussp wlsp > wlpkt.txt

[caiwang]

Comment by unissoft-bj Tuesday Jan 20, 2015 at 12:00 GMT

---

echo "select mac,avg(rssi) as avgrssi,timebyhour from wlpkt where mac in (select mac from (select mac, count(mac) as num, avgrssi from (select mac,avg(rssi) as avgrssi,timebyhour from wlpkt where mac in ( select mac from (select mac ,count(mac) as cntmac,rssi from wlpkt where rssi >='-75' group by mac) tblpktbig where cntmac>='50') group by mac,timebyhour) tblstage2 where avgrssi >='-70' group by mac) tblavgbig where num >='0') group by mac,timebyhour;" | mysql -uroot -prootatussp wlsp > wlpkt.txt

[caiwang]

Comment by unissoft-bj Wednesday Jan 21, 2015 at 03:34 GMT

---

echo "select mac,avg(rssi) as avgrssi,timebyhour from wlpkt where mac in (select mac from (select mac, count(mac) as num, avgrssi from (select mac,avg(rssi) as avgrssi,timebyhour from wlpkt where mac in ( select mac from (select mac ,count(mac) as cntmac,rssi from wlpkt where rssi >='-75' group by mac) tblpktbig where cntmac>='50') group by mac,timebyhour) tblstage2 where avgrssi >='-65' group by mac) tblavgb ig where num >='1') group by mac,timebyhour;" | mysql -uroot -prootatussp wlsp > wlpkt.txt

[caiwang]

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

---

echo "select mac,avg(rssi) as avgrssi,timebyhour from wlpkt where mac in (select mac from (select mac, count(mac) as num, avgrssi from (select mac,avg(rssi) as avgrssi,timebyhour from wlpkt where mac in ( select mac from (select mac ,count(mac) as cntmac,rssi from wlpkt where rssi >='-75' group by mac) tblpktbig where cntmac>='50') group by mac,timebyhour) tblstage2 where avgrssi >='-60' group by mac) tblavgbig where num >='3') group by mac,timebyhour;" | mysql -uroot -prootatussp wlsp > wlpkt.txt

[caiwang]

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

---

this one is ok -75,50, -60,1

echo "select mac,avg(rssi) as avgrssi,timebyhour from wlpkt where mac in (select mac from (select mac, count(mac) as num, avgrssi from (select mac,avg(rssi) as avgrssi,timebyhour from wlpkt where mac in ( select mac from (select mac ,count(mac) as cntmac,rssi from wlpkt where rssi >='-75' group by mac) tblpktbig where cntmac>='50') group by mac,timebyhour) tblstage2 where avgrssi >='-60' group by mac) tblavgbig where num >='1') group by mac,timebyhour;" | mysql -uroot -prootatussp wlsp > wlpkt.txt

[caiwang]

Comment by unissoft-bj Wednesday Jan 21, 2015 at 04:25 GMT

---

echo "select mac,avg(rssi) as avgrssi,timebyhour from wlpkt where mac in (select mac from (select mac, count(mac) as num, avgrssi from (select mac,avg(rssi) as avgrssi,timebyhour from wlpkt where mac in ( select mac from (select mac ,count(mac) as cntmac,rssi from wlpkt where rssi >='-75' group by mac) tblpktbig where cntmac>='50') group by mac,timebyhour) tblstage2 where avgrssi >='-50' group by mac) tblavgbig where num >='1') group by mac,timebyhour;" | mysql -uroot -prootatussp wlsp > wlpkt.txt

[caiwang]

Comment by unissoft-bj Wednesday Jan 21, 2015 at 04:46 GMT

---

echo "select count(distinct(mac)),timebyhour from wlpkt where mac in (select mac from (select mac, count(mac) as num, avgrssi from (select mac,avg(rssi) as avgrssi,timebyhour from wlpkt where mac in ( select mac from (select mac ,count(mac) as cntmac,rssi from wlpkt where rssi >='-75' group by mac) tblpktbig where cntmac>='50') group by mac,timebyhour) tblstage2 where avgrssi >='-60' group by mac) tblavgbig where num >='1') group by timebyhour;" | mysql -uroot -prootatussp wlsp > wlpkt.txt