Servicetimelog.php 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. <?php
  2. namespace app\admin\model;
  3. use think\Model;
  4. /**
  5. * 客服上线下线日志模型
  6. */
  7. class Servicetimelog extends Model
  8. {
  9. //按日期用户查
  10. //
  11. public function getDayData($dataArray, $uidArray = [])
  12. {
  13. $ret = $this->where(['cdate' => ['IN', $dataArray]]);
  14. if ($uidArray) {
  15. $ret = $ret->where(['kfid' => ['IN', $uidArray]]);
  16. }
  17. $ret = $ret->order(['kfid' => 'asc', 'cdate' => 'asc', 'ctime' => 'asc'])->select();
  18. if (!$ret) {
  19. return false;
  20. }
  21. $return = $this->getOneUserData($ret);
  22. return $return;
  23. }
  24. private function getOneUserData($array)
  25. {
  26. $return = [];
  27. foreach ($array as $val) {
  28. if (!isset($return[$val->cdate][$val->kfid]['1'])) {
  29. $return[$val->cdate][$val->kfid]['1'] = $val->cdate . ' ' . $val->ctime;
  30. } else {
  31. if ($return[$val->cdate][$val->kfid]['1'] > $val->cdate . ' ' . $val->ctime) {
  32. $return[$val->cdate][$val->kfid]['1'] = $val->cdate . ' ' . $val->ctime;
  33. }
  34. }
  35. if (!isset($return[$val->cdate][$val->kfid]['0'])) {
  36. $return[$val->cdate][$val->kfid]['0'] = $val->cdate . ' ' . $val->ctime;
  37. } else {
  38. if ($return[$val->cdate][$val->kfid]['0'] < $val->cdate . ' ' . $val->ctime) {
  39. $return[$val->cdate][$val->kfid]['0'] = $val->cdate . ' ' . $val->ctime;
  40. }
  41. }
  42. }
  43. return $return;
  44. }
  45. }