Blame view

application/admin/controller/antis/statistic/Work.php 15.2 KB
2db47680   hexiaodong   chore: 初始提交 php 遗...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
  <?php
  
  namespace app\admin\controller\antis\statistic;
  
  use addons\antis\model\Daily;
  use addons\antis\model\Record;
  use addons\antis\model\Staff;
  use app\admin\model\AuthGroup;
  use app\common\controller\Backend;
  use fast\Tree;
  use think\Exception;
  
  /**
   * 员工工作日志分析
   */
  class Work extends Backend
  {
      public function _initialize()
      {
          try{
              \think\Db::execute("SET @@sql_mode='';");
          }catch (Exception $e){
  
          }
          parent::_initialize();
  
          $childrenGroupIds = $this->auth->getChildrenGroupIds(true);
          $groupList = collection(AuthGroup::where('id', 'in', $childrenGroupIds)->select())->toArray();
  
          Tree::instance()->init($groupList);
          $groupList = [];
          if ($this->auth->isSuperAdmin()) {
              $groupList = Tree::instance()->getTreeList(Tree::instance()->getTreeArray(0));
          } else {
              $groups = $this->auth->getGroups();
              $groupIds = [];
              foreach ($groups as $m => $n) {
                  if (in_array($n['id'], $groupIds) || in_array($n['pid'], $groupIds)) {
                      continue;
                  }
                  $groupList = array_merge($groupList, Tree::instance()->getTreeList(Tree::instance()->getTreeArray($n['pid'])));
                  foreach ($groupList as $index => $item) {
                      $groupIds[] = $item['id'];
                  }
              }
          }
          $this->assign('groupdata',$groupList);
      }
  
      /**
       * 工作报告
       */
      public function report(){
          $row=input('row/a');
          $type=$row['type']??'日报';
          $year=$row['year']??date('Y');
          $month=$row['month']??date('m');
          $group_id=$row['group_id']??0;
          $staff_id=$row['staff_id']??0;
          $where=['type'=>$type];
          $ids=[];
          if ($group_id) {//角色组
              $ids = Staff::getGroupStaffIds($group_id);
          }
          if ($staff_id) {
              $ids = $row['staff_id'];
          }
  
          if($type == '日报'){
              $where['createtime'] = ['between', [strtotime("{$year}-{$month}-01"),
                  strtotime("{$year}-".($month+1).'-01') - 1]];
          }elseif($type == '年报'){
  
          }else{
              $where['createtime'] = ['between', [strtotime($year . '-01-01'),
                  strtotime(($year + 1) . '-01-01') - 1]];
          }
          $dates=[];
          $lastDay = date('d', strtotime("{$year}-{$month} +1 month -1 day"));
  
          if($type == '日报'){
              for($i=1;$i<=$lastDay;$i++){
                  $dates[]=['date'=>$i,'between'=>"{$year}-{$month}-{$i}",
                      'search'=>"{$year}-{$month}-{$i} 00:00:00 - {$year}-{$month}-{$i} 23:59:59"];
              }
          }else if($type == '月报'){
              for($i=1;$i<=12;$i++){
                  $e=date('d', strtotime("{$year}-{$i} +1 month -1 day"));
                  $dates[]=['date'=>$i,'between'=>[$year.'-'.$i,$year.'-'.($i+1)],
                      'search'=>"{$year}-{$i}-01 00:00:00 - {$year}-{$i}-{$e} 23:59:59"];
              }
          }else if($type == '季报'){
              for($i=1;$i<=4;$i++){
                  $r = $i * 3;
                  $s=($i-1)*3+1;
                  $e=date('d', strtotime("{$year}-{$r} +1 month -1 day"));
                  $dates[]=['date'=>$i,
                      'search'=>"{$year}-{$s}-01 00:00:00 - {$year}-{$r}-{$e} 23:59:59"];
              }
          }else if($type == '年报'){
              $y=date('Y');
              for ($i = 2022; $i <= $y; $i++) {
                  $dates[] = ['date' => $i,
                      'search' => "{$i}-01-01 00:00:00 - {$i}-12-31 23:59:59"];
              }
          }else if($type == '周报'){
              $week = date('W',strtotime($year.'-12-31'));
              $s=7-date('w',strtotime($year.'-01-01'));
              for ($i = 1; $i <= $week; $i++) {
                  $s1 = ($i - 2) * 7 + $s;
                  $s1 = $s1 < 0 ? 0 : $s1;
                  $s2 = ($i - 1) * 7 + $s;
                  $sw=date('Y-m-d', strtotime($year . '-01-01 '.'+' . $s1 . ' day'));
                  $ew=date('Y-m-d', strtotime($year . '-01-01 '.'+' . $s2 . ' day')) ;
                  $dates[] = ['date' => $i, 'between' => [$sw,$ew],
                      'search' =>  $sw . " 00:00:00 - " .
                          $ew. " 23:59:59"];
              }
          }
          $daily = Daily::where($where)->field('createtime,create_staff_id')->select();
          $whereT=[];
          if($group_id || $staff_id){
              $whereT=['id'=>['in',$ids]];
          }
          $staff = Staff::where($whereT)->field('id,name,img')->select();
          $staff=collection($staff)->toArray();
          $result=[];
          foreach ($daily as $d) {
              if($type == '日报'){
                  $time = date('Y-m-d', strtotime($d['createtime']));
              }elseif($type == '月报'){
                  $time = date('Y-m-d', strtotime($d['createtime']));
              }elseif($type == '周报'){
                  $time = date('Y-m-d', strtotime($d['createtime']));
              }elseif($type == '季报'){
                  $time = date('Y-m', strtotime($d['createtime']));
              }elseif($type == '年报'){
                  $time = date('Y', strtotime($d['createtime']));
              }
  
              $result[$time][] = $d['create_staff_id'];
          }
          $list=[];
          $startYear=strtotime($year.'-01-01');
          $endYear=strtotime($year.'-12-31');
          $startMonth=strtotime($year."-{$month}-01");
          $endMonth=strtotime($year."-{$month}-".$lastDay);
          $allDay=($endYear-$startYear)/86400+1;
          foreach ($staff as $s){
              $row=$s;
  
  
              if ($type == '日报') {
                  $count = Daily::where([
                      'type'=>$type,
                      'create_staff_id'=>$s['id'],
                      'createtime'=>['between',[$startYear,$endYear]]
                  ])->field("FROM_UNIXTIME(createtime,'%Y-%m-%d') as ctime")->group('ctime')->count();
                  $row['year']=$count;
                  $row['year_ratio']= sprintf("%.2f", $count/$allDay * 100);
                  $count = Daily::where([
                      'type' => $type,
                      'create_staff_id' => $s['id'],
                      'createtime' => ['between', [$startMonth, $endMonth]]
                  ])->field("FROM_UNIXTIME(createtime,'%Y-%m-%d') as ctime")->group('ctime')->count();
                  $row['month'] = $count;
                  $row['month_ratio'] = sprintf("%.2f", $count / $allDay * 100);
              }elseif($type =='周报'){
                  $count = Daily::where([
                      'type'=>$type,
                      'create_staff_id'=>$s['id'],
                      'createtime'=>['between',[$startYear,$endYear]]
                  ])->field("FROM_UNIXTIME(createtime,'%Y-%m-%d') as ctime")->group('ctime')->count();
                  $row['year']=$count;
                  $row['year_ratio']= sprintf("%.2f", $count/12 * 100);
              }elseif($type =='月报'){
                  $count = Daily::where([
                      'type'=>$type,
                      'create_staff_id'=>$s['id'],
                      'createtime'=>['between',[$startYear,$endYear]]
                  ])->field("FROM_UNIXTIME(createtime,'%Y-%m') as ctime")->group('ctime')->count();
                  $row['year']=$count;
                  $row['year_ratio']= sprintf("%.2f", $count/12 * 100);
              }elseif($type =='季报'){
                  $count = Daily::where([
                      'type'=>$type,
                      'create_staff_id'=>$s['id'],
                      'createtime'=>['between',[$startYear,$endYear]]
                  ])->field("quarter(FROM_UNIXTIME(createtime,'%Y-%m')) as ctime")->group('ctime')->count();
                  $row['year']=$count;
                  $row['year_ratio']= sprintf("%.2f", $count/4 * 100);
              }else if($type =='年报'){
  
              }
              foreach ($dates as $d) {
                  $row[$d['date']] = 0;
                  if ($type == '日报') {
                      $between = date('Y-m-d', strtotime($d['between']));
                      if (strtotime($d['between']) > time()) {
                          $row[$d['date']] = 9;
                      }
                      if (isset($result[$between]) && in_array($s['id'], $result[$between])) {//已提交日报
                          $row[$d['date']] = 1;
                      }
                  }else if ($type == '月报') {
                      $between = date('Y-m',strtotime($year.'-'.$d['date']));
                      if (strtotime($between) > time()) {
                          $row[$d['date']] = 9;
                      }
                      if (isset($result[$between]) && in_array($s['id'], $result[$between])) {//已提交日报
                          $row[$d['date']] = 1;
                      }
                  }else if ($type == '季报') {
                      $between1 = date('Y-m',strtotime($year.'-'.(($d['date']-1)*3+1)));//第一月
                      $between2 = date('Y-m',strtotime($year.'-'.(($d['date']-1)*3+2)));//第二月
                      $between3 = date('Y-m',strtotime($year.'-'.$d['date']*3));//第三月
  
                      if (strtotime($between3) > time()) {
                          $row[$d['date']] = 9;
                      }
                      if (isset($result[$between1]) && in_array($s['id'], $result[$between1])) {//
                          $row[$d['date']] = 1;
                      }
                      if (isset($result[$between2]) && in_array($s['id'], $result[$between2])) {//
                          $row[$d['date']] = 1;
                      }
                      if (isset($result[$between3]) && in_array($s['id'], $result[$between3])) {//
                          $row[$d['date']] = 1;
                      }
                  }else if ($type == '年报') {
                      $between=$d['date'];
                      if (strtotime($d['date'].'-12-31') > time()) {
                          $row[$d['date']] = 9;
                      }
                      if (isset($result[$between]) && in_array($s['id'], $result[$between])) {//已提交日报
                          $row[$d['date']] = 1;
                      }
                  }else if ($type == '周报') {
                      $between=$d['between'];
                      if (strtotime($between[1]) > time()) {
                          $row[$d['date']] = 9;
                      }
                      for ($i=$between[0];strtotime($i)<= strtotime($between[1]);$i=date('Y-m-d',strtotime($i.'+1 day'))){
                          if (isset($result[$i]) && in_array($s['id'], $result[$i])) {//已提交日报
                              $row[$d['date']] = 1;
                          }
                      }
                  }
              }
              $list[]=$row;
          }
  
  
          $years=[];
          $end=date('Y')+1;
          for ($i=2022;$i<=$end;$i++){
              $years[]=$i;
          }
          $this->view->assign([
              'type' => $type,
              'year' => $year,
              'years' => $years,
              'dates' => $dates,
              'month' => $month,
              'staff_id' => $staff_id,
              'group_id' => $group_id,
              'list' => $list,
          ]);
          return $this->view->fetch();
      }
  
  
      /**
       * 沟通日志
       */
      public function record(){
          $row=input('row/a');
          $year=$row['year']??date('Y');
          $month=$row['month']??date('m');
          $group_id=$row['group_id']??0;
          $staff_id=$row['staff_id']??0;
          $where=[];
          $ids=[];
          if ($group_id) {//角色组
              $ids = Staff::getGroupStaffIds($group_id);
          }
          if ($staff_id) {
              $ids = $row['staff_id'];
          }
  
         $where['createtime'] = ['between', [strtotime("{$year}-{$month}-01"),
                  strtotime("{$year}-".($month+1).'-01') - 1]];
  
          $dates=[];
          $lastDay = date('d', strtotime("{$year}-{$month} +1 month -1 day"));
  
          for ($i = 1; $i < $lastDay; $i++) {
              $dates[] = ['date' => $i, 'between' => "{$year}-{$month}-{$i}",
                  'search' => "{$year}-{$month}-{$i} 00:00:00 - {$year}-{$month}-{$i} 23:59:59"];
          }
          $daily = Record::where($where)
              ->field("FROM_UNIXTIME(createtime,'%Y-%m-%d') as ctime,create_staff_id,count(*) as num")
              ->group('ctime,create_staff_id')->select();
          $daily=collection($daily)->toArray();
          $whereT=[];
          if($group_id || $staff_id){
              $whereT=['id'=>['in',$ids]];
          }
          $staff = Staff::where($whereT)->field('id,name,img')->select();
          $staff=collection($staff)->toArray();
          $result=[];
          foreach ($daily as $d) {
              $result[$d['ctime']][$d['create_staff_id']]=$d['num'];
          }
          $list=[];
          $startYear=strtotime($year.'-01-01');
          $endYear=strtotime($year.'-12-31');
          $startMonth=strtotime($year."-{$month}-01");
          $endMonth=strtotime($year."-{$month}-".$lastDay);
          $allDay=($endYear-$startYear)/86400+1;
          foreach ($staff as $s) {
              $row = $s;
  
              $count = Record::where([
                  'create_staff_id' => $s['id'],
                  'createtime' => ['between', [$startYear, $endYear]]
              ])->count();
              $row['year'] = $count;
              $row['year_ratio'] = sprintf("%.2f", $count / $allDay * 100);
              $count = Record::where([
                  'create_staff_id' => $s['id'],
                  'createtime' => ['between', [$startMonth, $endMonth]]
              ])->count();
              $row['month'] = $count;
              $row['month_ratio'] = sprintf("%.2f", $count / $allDay * 100);
  
              foreach ($dates as $d) {
                  $row[$d['date']] = 0;
                  $between = date('Y-m-d', strtotime($d['between']));
                  if (strtotime($d['between']) > time()) {
                      $row[$d['date']] = -1;
                  }
                  if (isset($result[$between]) && isset($result[$between][$s['id']])) {//已提交日报
                      $row[$d['date']] = $result[$between][$s['id']];
                  }
  
              }
              $list[] = $row;
          }
  
  
          $years=[];
          $end=date('Y')+1;
          for ($i=2022;$i<=$end;$i++){
              $years[]=$i;
          }
          $this->view->assign([
              'year' => $year,
              'years' => $years,
              'dates' => $dates,
              'month' => $month,
              'staff_id' => $staff_id,
              'group_id' => $group_id,
              'list' => $list,
          ]);
          return $this->view->fetch();
      }
      /**
       * 沟通日志列表
       */
      public function record_list(){
          $this->request->filter(['strip_tags']);
          if ($this->request->isAjax()) {
              if ($this->request->request('keyField')) {
                  return $this->selectpage();
              }
              list($where, $sort, $order, $offset, $limit) = $this->buildparams();
              $whereT=[];
              $staff_id=input('staff_id');
              if($staff_id){
                  $whereT['create_staff_id']=$staff_id;
              }
              $list   = Record::where($where)->where($whereT)->with(['staff','customer'])->order($sort, $order)
                  ->paginate($limit);
              foreach($list as $k=>$v){
                  if(!isset($v['customer']) || !$v['customer']){
                      $v['customer'] = array('id'=>'','name'=>'');
                  }
              }
              $row    = $list->items();
              $result = array("total" => $list->total(), "rows" => $row);
  
              return json($result);
          }
  
          return $this->view->fetch();
      }
  }