Protector.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\AuthGroupAccess;
  4. use app\common\controller\Backend;
  5. use think\Db;
  6. use think\Session;
  7. /**
  8. *
  9. *
  10. * @icon fa fa-circle-o
  11. */
  12. class Protector extends Backend
  13. {
  14. private $status = [
  15. "PROTECTOR" => 0 , //保护中
  16. "OVERDUE" => 1, // 已过期
  17. "SIGN" => 2, // 已签单
  18. "FREE" => 3, // 冻结中
  19. "GIVEUP" => 4, // 已放弃
  20. ];
  21. //快速搜索的字段
  22. protected $searchFields = ['unit_name','contacts'];
  23. /**
  24. * Protector模型对象
  25. * @var \app\admin\model\Protector
  26. */
  27. protected $model = null;
  28. public function _initialize()
  29. {
  30. parent::_initialize();
  31. $this->model = model('Protector');
  32. }
  33. /**
  34. * 查看
  35. */
  36. public function index($status = false)
  37. {
  38. //设置过滤方法
  39. $this->request->filter(['strip_tags']);
  40. if ($this->request->isAjax())
  41. {
  42. //如果发送的来源是Selectpage,则转发到Selectpage
  43. if ($this->request->request('keyField'))
  44. {
  45. return $this->selectpage();
  46. }
  47. list($where, $sort, $order, $offset, $limit) = $this->buildparams();
  48. $where_usr_id = ['usr_id'=>Session::get('admin')['id']]; //只能查看自己的数据
  49. switch ($status){
  50. case 'protect': //保护中
  51. $total = $this->model
  52. ->where('status',$this->status['PROTECTOR'])
  53. ->where($where_usr_id)
  54. ->where($where)
  55. ->order($sort, $order)
  56. ->count();
  57. $list = $this->model
  58. ->where('status',$this->status['PROTECTOR'])
  59. ->where($where_usr_id)
  60. ->where($where)
  61. ->order($sort, $order)
  62. ->limit($offset, $limit)
  63. ->select();
  64. break;
  65. case 'overdue': //已过期
  66. $total = $this->model
  67. ->where('status',$this->status['OVERDUE'])
  68. ->where($where_usr_id)
  69. ->where($where)
  70. ->order($sort, $order)
  71. ->count();
  72. $list = $this->model
  73. ->where('status',$this->status['OVERDUE'])
  74. ->where($where_usr_id)
  75. ->where($where)
  76. ->order($sort, $order)
  77. ->limit($offset, $limit)
  78. ->select();
  79. break;
  80. case 'contract': //已签单
  81. $total = $this->model
  82. ->where('status',$this->status['SIGN'])
  83. ->where($where_usr_id)
  84. ->where($where)
  85. ->order($sort, $order)
  86. ->count();
  87. $list = $this->model
  88. ->where('status',$this->status['SIGN'])
  89. ->where($where_usr_id)
  90. ->where($where)
  91. ->order($sort, $order)
  92. ->limit($offset, $limit)
  93. ->select();
  94. break;
  95. case 'giveup': //已放弃
  96. $total = $this->model
  97. ->where('status',$this->status['GIVEUP'])
  98. ->where($where_usr_id)
  99. ->where($where)
  100. ->order($sort, $order)
  101. ->count();
  102. $list = $this->model
  103. ->where('status',$this->status['GIVEUP'])
  104. ->where($where_usr_id)
  105. ->where($where)
  106. ->order($sort, $order)
  107. ->limit($offset, $limit)
  108. ->select();
  109. break;
  110. }
  111. $list = collection($list)->toArray();
  112. $result = array("total" => $total, "rows" => $list);
  113. return json($result);
  114. }
  115. return $this->view->fetch('index');
  116. }
  117. /**
  118. * 添加
  119. */
  120. public function add()
  121. {
  122. if ($this->request->isPost())
  123. {
  124. $params = $this->request->post("row/a");
  125. if ($params)
  126. {
  127. if ($this->dataLimit && $this->dataLimitFieldAutoFill)
  128. {
  129. $params[$this->dataLimitField] = $this->auth->id;
  130. }
  131. try
  132. {
  133. //是否采用模型验证
  134. if ($this->modelValidate)
  135. {
  136. $name = basename(str_replace('\\', '/', get_class($this->model)));
  137. $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.add' : true) : $this->modelValidate;
  138. $this->model->validate($validate);
  139. }
  140. $params['usr_id'] = Session::get('admin')['id']; //usr id
  141. $params['usr_nickname'] = Session::get('admin')['nickname']; //nickname
  142. $protect_count = Session::get('admin')['protect_count']; //保护个数
  143. $protect_day = Session::get('admin')['protect_day']; //保护天数
  144. $free_day = Session::get('admin')['free_day']; // 冻结天数
  145. // 获取所属组名
  146. $params['usr_depart'] = AuthGroupAccess::getGroupName($params['usr_id']);
  147. // 获取到期时间和冻结到期时间
  148. $params['ex_date'] = date('Y-m-d',strtotime("+".$protect_day." day")); //保护到期时间
  149. $params['free_date'] = date('Y-m-d',strtotime("{$params['ex_date']} "."+".$free_day." day")); //保护到期时间
  150. // 根据单位名称判断是否已经存在(已被保护)
  151. $res = \app\admin\model\Protector::unitNameIsExist($params['unit_name']);
  152. if($res){
  153. $this->error('"'.$res.'"已经被保护!');
  154. }
  155. // 判断是否超出保护个数
  156. $res = \app\admin\model\Protector::proCountIsExceed($params['usr_id'], $protect_count);
  157. if($res){
  158. $this->error($res);
  159. }
  160. $result = $this->model->allowField(true)->save($params);
  161. if ($result !== false)
  162. {
  163. $this->success();
  164. }
  165. else
  166. {
  167. $this->error($this->model->getError());
  168. }
  169. }
  170. catch (\think\exception\PDOException $e)
  171. {
  172. $this->error($e->getMessage());
  173. }
  174. }
  175. $this->error(__('Parameter %s can not be empty', ''));
  176. }
  177. return $this->view->fetch();
  178. }
  179. /**
  180. * 放弃
  181. */
  182. public function giveup() {
  183. try {
  184. //1.获取id
  185. $id = $this->request->post("id");
  186. //2.protector表 通过id 查找出数据
  187. $protector = \app\admin\model\Protector::get($id);
  188. //3.获取用户id
  189. $usr_id = Session::get('admin')['id'];
  190. //4.判断用户id和 protector的用户id是否一致 保存状态
  191. if ($protector['usr_id'] != $usr_id) {
  192. $this->error('请操作自己的数据!');
  193. }
  194. //5.保护到期时间设置现在 冻结算一下
  195. $free_day = Session::get('admin')['free_day'];
  196. $param['ex_date'] = date('Y-m-d');
  197. $param['free_date'] = date('Y-m-d', strtotime("+" . $free_day . " day"));
  198. $param['status'] = $this->status['GIVEUP'];
  199. $param['id'] = $id;
  200. //6.入库
  201. $res = $this->model->allowField(true)->isUpdate(true)->save($param);
  202. if ($res) {
  203. $this->success('放弃成功!');
  204. }
  205. $this->error();
  206. } catch (\think\exception\PDOException $e)
  207. {
  208. $this->error($e->getMessage());
  209. }
  210. }
  211. /**
  212. * 签单
  213. */
  214. public function sign() {
  215. try{
  216. //1.获取id
  217. $id = $this->request->post("id");
  218. //2.protector表 通过id 查找出数据
  219. $protector = \app\admin\model\Protector::get($id);
  220. //3.获取用户id
  221. $usr_id = Session::get('admin')['id'];
  222. //4.判断用户id和 protector的用户id是否一致 保存状态
  223. if ($protector['usr_id'] != $usr_id) {
  224. $this->error('请操作自己的数据!');
  225. }
  226. $param['id'] = $id;
  227. $param['status'] = $this->status['SIGN'];
  228. //5.入库
  229. $res = $this->model->allowField(true)->isUpdate(true)->save($param);
  230. if ($res) {
  231. $this->success('签单成功!');
  232. }
  233. $this->error();
  234. } catch (\think\exception\PDOException $e){
  235. $this->error($e->getMessage());
  236. }
  237. }
  238. /**
  239. * 再次保护
  240. */
  241. public function again() {
  242. try{
  243. //1.获取id
  244. $id = $this->request->post("id");
  245. //2.protector表 通过id 查找出数据
  246. $protector = \app\admin\model\Protector::get($id);
  247. //3.获取用户id
  248. $usr_id = Session::get('admin')['id'];
  249. //4.判断用户保护个数是否达到上限
  250. $res = \app\admin\model\Protector::proCountIsExceed($usr_id, Session::get('admin')['protect_count']);
  251. if($res){
  252. $this->error($res);
  253. }
  254. //5 判断 protector表 状态 如果是已签单返回
  255. if($protector['status'] == $this->status['SIGN']){
  256. $this->error('已签单!无法再次保护');
  257. }
  258. //6 已过期,已放弃
  259. if($protector['status'] != $this->status['OVERDUE'] && $protector['status'] != $this->status['GIVEUP']){
  260. $this->error('已过期或已放弃才可以再次保护!');
  261. }
  262. //7.判断用户id和 protector的用户id是否一致 保
  263. if($protector['usr_id'] == $usr_id) {
  264. // 同一个人操作,判断是否结束冻结
  265. if(strtotime(date('Y-m-d')) < strtotime($protector['free_date'])){
  266. $this->error('未过冻结时间!无法再次保护');
  267. }
  268. }
  269. // 不同的人操作或者已经过了冻结期
  270. $protect_day = Session::get('admin')['protect_day']; //保护天数
  271. $free_day = Session::get('admin')['free_day']; // 冻结天数
  272. $params['usr_id'] = $usr_id; //usr id
  273. $params['usr_nickname'] = Session::get('admin')['nickname']; //nickname
  274. $params['ex_date'] = date('Y-m-d',strtotime("+".$protect_day." day")); //保护到期时间
  275. $params['free_date'] = date('Y-m-d',strtotime("{$params['ex_date']} "."+".$free_day." day")); //保护到期时间
  276. $params['usr_depart'] = AuthGroupAccess::getGroupName($params['usr_id']);
  277. $params['id'] = $id;
  278. //5.入库
  279. $res = $this->model->allowField(true)->isUpdate(true)->save($params);
  280. if ($res) {
  281. $this->success('再次保护成功!');
  282. }
  283. $this->error();
  284. } catch (\think\exception\PDOException $e){
  285. $this->error($e->getMessage());
  286. }
  287. }
  288. /**
  289. * 查看所有的跟进
  290. */
  291. public function showFollow()
  292. {
  293. try{
  294. $p_id = $this->request->post('id');
  295. $res = Db::table('follow')
  296. ->where('protect_id', $p_id)
  297. ->select();
  298. $html = '';
  299. if(!empty($res)){
  300. foreach ($res as $k=>$v){
  301. $html .=
  302. ' <div class="form-group col-xs-12">' .
  303. ' <label for="follow_time" class="control-label col-xs-12 col-sm-3"><span class="text-red"></span>操作人:</label>' .
  304. ' <div class="col-xs-12 col-sm-7">' .
  305. '<span style="display: inline-block;padding-top: 7px;">'.$v["usr_nickname"] .'</span>'.
  306. ' </div>' .
  307. ' </div>';
  308. $html .=
  309. ' <div class="form-group col-xs-12">' .
  310. ' <label for="follow_time" class="control-label col-xs-12 col-sm-3">跟进时间:</label>' .
  311. ' <div class="col-xs-12 col-sm-7">' .
  312. '<span style="display: inline-block;padding-top: 7px;">'.$v['follow_time'].'</span>'.
  313. ' </div>' .
  314. ' </div>';
  315. $html .=
  316. ' <div class="form-group col-xs-12" style="border-bottom: 1px solid #eeeeee;">' .
  317. ' <label class="control-label col-xs-12 col-sm-3">跟进内容:</label>' .
  318. ' <div class="col-xs-12 col-sm-7" style="margin-bottom: 10px;">' .
  319. ' <textarea disabled class="form-control " rows="5" name="main" cols="50">'.
  320. $v['main'].
  321. ' </textarea>' .
  322. ' </div>' .
  323. ' </div>';
  324. }
  325. }
  326. $html .=
  327. ' <div class="form-group col-xs-12">' .
  328. ' <label for="follow_time" class="control-label col-xs-12 col-sm-3">跟进时间:</label>' .
  329. ' <div class="col-xs-12 col-sm-7">' .
  330. ' <input id="follow_time" class="form-control datetimepicker" name="follow_time" type="text" data-rule="required">' .
  331. ' </div>' .
  332. ' </div>';
  333. $html .=
  334. ' <div class="form-group col-xs-12">' .
  335. ' <label class="control-label col-xs-12 col-sm-3">跟进内容:</label>' .
  336. ' <div class="col-xs-12 col-sm-7">' .
  337. ' <textarea id="main_text" class="form-control " rows="5" name="main" cols="50">'.
  338. ' </textarea>' .
  339. ' </div>' .
  340. ' </div>';
  341. $this->success('','',$html);
  342. } catch (\think\exception\PDOException $e){
  343. $this->error($e->getMessage());
  344. }
  345. }
  346. /**
  347. * 添加跟进
  348. */
  349. public function addFollow()
  350. {
  351. try{
  352. $data = $this->request->post();
  353. $param['protect_id'] = $data['id'];
  354. $param['usr_id'] = Session::get('admin')['id'];
  355. $param['usr_nickname'] = Session::get('admin')['nickname'];
  356. $param['protect_name'] = $data['unit_name'];
  357. $param['follow_time'] = $data['follow_time'];
  358. $param['main'] = $data['main'];
  359. $param['created_at'] = date('Y-m-d H:i:s');
  360. $res = Db::table('follow')
  361. ->insert($param);
  362. if($res){
  363. $this->success('跟进成功');
  364. }
  365. $this->error();
  366. } catch (\think\exception\PDOException $e){
  367. $this->error($e->getMessage());
  368. }
  369. }
  370. }