Blame view

addons/antis/model/Event.php 3.68 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
  <?php

  

  namespace addons\antis\model;

  

  use addons\antis\model\Event as EventModel;

  use think\Exception;

  use think\Model;

  use traits\model\SoftDelete;

  

  /**

   *日程提醒

   */

  class Event Extends Model {

  	use SoftDelete;

      // 表名,不含前缀

      protected $name = 'qingdong_event';

  	const   CUSTOMER_TYPE    = 1;//客户

  	const   CONTACTS_TYPE    = 2;//联系人

  	const   CONTRACT_TYPE    = 3;//合同

  	const   LEADS_TYPE       = 4;//线索

  	const   RECEIVABLES_TYPE = 5;//回款记录

  	// 开启自动写入时间戳字段

  	protected $autoWriteTimestamp = 'int';

  	// 定义时间戳字段名

  	protected $createTime = 'createtime';

  	protected $updateTime = 'updatetime';

  	protected $deleteTime = 'deletetime';

  

  

  	public function getCreatetimeAttr($value) {

  		return date('Y-m-d H:i:s', $value);

  	}

  

  

  	//创建日程

  	public static function createEvent($params) {

  		$staff = Staff::info();

  		//1:5分钟前 2:15分钟前 3:30分钟前 4:一个小时前 5:两个小时前 6:一天前 7:两天前 8:一周前

  		if (isset($params['remindtype'])) {

  			switch ($params['remindtype']) {

  				case 1:

  					$time = '-5 minutes';

  				break;

  				case 2:

  					$time = '-15 minutes';

  				break;

  				case 3:

  					$time = '-30 seconds';

  				break;

  				case 4:

  					$time = '-1 hours ';

  				break;

  				case 5:

  					$time = '-2 hours ';

  				break;

  				case 6:

  					$time = '-1 days';

  				break;

  				case 7:

  					$time = '-7 days';

  				break;

  				case 8:

  					$time = '-1 week';

  				break;

  				default:

  					$time = '-5 minutes';

  			}

  			$params['remind_time'] = date('Y-m-d H:i:s', strtotime($time, strtotime($params['start_time'])));

  		} else {

  			$params['remind_time'] = date('Y-m-d H:i:s', strtotime('+5 seconds', strtotime($params['start_time'])));

  		}

  		$params['staff_id'] = $staff->id;

  		$Model              = new self;

          $result = $Model->allowField(true)->save($params);

  		if (false === $result) {

  			// 验证失败 输出错误信息

  			throw new Exception($Model->getError());

  		}

  

  		return true;

  	}

  

  

  	/**

  	 *变更状态

  	 */

  	public static function changeStatus($id, $status) {

  		$model = new self();

  		if ($model->save(['status' => $status], ['id' => $id]) == false) {

  			throw new Exception('变更失败');

  		}

  

  		return true;

  	}

  

  

  	//根据时间获取列表

  	public static function getTimeList($start_time, $end_time) {

  		$staff      = Staff::info();

  		$model      = new EventModel();

  		$start_time = $start_time . ' 00:00:00';

  		$end_time   = $end_time . ' 23:59:59';

  		$events     = $model->where([

  			'staff_id' => $staff->id

  		])->where(function ($query) use ($start_time, $end_time) {

  			$query->where(['start_time' => ['between', [$start_time, $end_time]]])->whereOr([

  				'end_time' => [

  					'between',

  					[

  						$start_time,

  						$end_time

  					]

  				]

  			]);

  		})->select();

  		$data       = [];

  		$start_time = strtotime($start_time);

  		$end_time   = strtotime($end_time);

  		for ($start_time; $start_time <= $end_time; $start_time = strtotime('+1 day', $start_time)) {

  			$time        = date('Y-m-d', $start_time);

  			$data[$time] = [];

  			foreach ($events as $k => $v) {

  				if (strtotime($v['start_time']) <= $start_time + 86400 - 1 && strtotime($v['end_time']) >= $start_time) {

  					$data[$time][] = $v;

  				}

  			}

  		}

  		foreach ($data as &$times) {

  			foreach ($times as &$ves) {

  				$ves['start_time'] = date('Y-m-d H:i', strtotime($ves['start_time']));

  				$ves['end_time']   = date('Y-m-d H:i', strtotime($ves['end_time']));

  			}

  		}

  

  		return $data;

  	}

  

  

  	//负责人

  	public function staff() {

  		return $this->hasOne(Staff::class, 'id', 'staff_id')->field('id,name');

  	}

  }