GameContinuedTs.php 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. <?php
  2. include_once dirname(__FILE__) . '/../main.php';
  3. $params = query_paras();
  4. //$params = $_POST['date'];
  5. $date = $params['date']['ts'];
  6. $uid = $params['date']['uid'];
  7. $zoneid = $params['date']['zoneid'];
  8. $sqlName = "tab_op_log".$date;
  9. $arr = daoInst()->select("*")->from($sqlName)
  10. ->where('cmd')->eq(6901)
  11. ->andWhere('zoneid')->eq($zoneid)
  12. ->andWhere('uid')->eq($uid)
  13. ->fetchAll();
  14. $lastItem = null;
  15. $dic = new stdClass();
  16. $list = array();
  17. $index = 1;
  18. foreach ($arr as $item) {
  19. if($lastItem != null){
  20. $list[] = $lastItem;
  21. if(strtotime($item->ts) - strtotime($lastItem->ts) > 20*60){
  22. $timeDic = new stdClass();
  23. $timeDic->startTs = strtotime($list[0]->ts);
  24. $timeDic->endTs = strtotime($list[count($list)-1]->ts);
  25. $timeDic->durationTs = strtotime($list[count($list)-1]->ts) - strtotime($list[0]->ts);
  26. $dic->$index = $timeDic;
  27. $index += 1;
  28. $list = array();
  29. }
  30. }
  31. $lastItem = $item;
  32. }
  33. $result = new stdClass();
  34. $result->data = $dic;
  35. echo json_encode($result);