sealaplModel.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306
  1. <?php
  2. /**
  3. * 模块.印章申请
  4. */
  5. class flow_sealaplClassModel extends flowModel
  6. {
  7. // level1部门领导
  8. // level2办公室
  9. // level3业务主管
  10. // level4法务部
  11. // level5矿分管领导
  12. // level6矿长
  13. protected $examine_dept_dic = ['1'=>"部门领导",'2'=>"办公室",'3'=>"业务主管部门",'4'=>"法律事务部", '5'=>"矿分管领导",'6'=>"矿长党委书记"];
  14. protected function flowinit(){
  15. }
  16. //提交时调用
  17. protected function flowsubmit($na, $sm){
  18. if ($sm = '提交') {
  19. $info = [
  20. "advice_level1_leader"=>$this->flowarr[0]['nowcheckname'],
  21. "advice_level1_leader_id"=>$this->flowarr[0]['nowcheckid']
  22. ];
  23. m('sealapl')->update($info, "id = {$this->id}");
  24. }
  25. }
  26. //单据判断条件从写$lx类型,$uid用户Id
  27. protected function flowbillwhere($lx, $uid){
  28. $where = '';
  29. if ($uid == 'all') {
  30. $where = 'and '.$this->adminid.' in (1, 28)';
  31. }
  32. return [
  33. 'where' => $where,
  34. 'order'=>'id desc'
  35. ];
  36. }
  37. //读取印章保管人来审批
  38. protected function flowcheckname($num)
  39. {
  40. // 自定义审核人
  41. if (strpos($num, 'approve') === 0) {
  42. $index = substr($num, -1);
  43. $sid = $this->rs['advice_level'.$index.'_leader_id'];
  44. $sna = $this->rs['advice_level'.$index.'_leader'];
  45. return array($sid, $sna);
  46. }
  47. }
  48. //展示时替换一下
  49. public function flowrsreplace($rs, $lx=0)
  50. {
  51. // if (empty($this->id)) $this->id = $rs['id'];
  52. // if (empty($rs['id'])) $rs['id'] = $this->id;
  53. $rs['date'] = $rs['applydt'];
  54. $rs['date_index'] = substr($rs['applydt'],0,4);
  55. $sqlStr = "SELECT t.*
  56. FROM (
  57. -- 子查询,为每个step选取最新的时间对应的记录
  58. SELECT step, MAX(optdt) AS max_optdt FROM zqoa_flow_log
  59. WHERE mid = {$rs['id']} AND `status` = 1 AND `table` = 'sealapl'
  60. GROUP BY step
  61. ) AS subquery
  62. JOIN zqoa_flow_log AS t ON subquery.step = t.step
  63. AND subquery.max_optdt = t.optdt
  64. WHERE t.mid = {$rs['id']}
  65. AND t.`status` = 1
  66. AND t.`table` = 'sealapl'";
  67. // 未审核完成时,设定签名为空
  68. $flow_arr = $this->db->getall($sqlStr);
  69. $flow_dict = [];
  70. foreach ($flow_arr as $key=>$value) {
  71. $flow_dict[$value['name']] = $value;
  72. }
  73. if (!isset($flow_dict["部门领导审批"])) {
  74. $rs['advice_level1_leader'] = null;
  75. $rs['advice_level1'] = null;
  76. }
  77. if (!isset($flow_dict["办公室审批"])) {
  78. $rs['advice_level2_leader'] = null;
  79. $rs['advice_level2'] = null;
  80. }
  81. if (!isset($flow_dict["业务主管部门审批"])) {
  82. $rs['advice_level3_leader'] = null;
  83. $rs['advice_level3'] = null;
  84. }
  85. if (!isset($flow_dict["法律事务部审批"])) {
  86. $rs['advice_level4_leader'] = null;
  87. $rs['advice_level4'] = null;
  88. }
  89. if (!isset($flow_dict["矿分管领导审批"])) {
  90. $rs['advice_level5_leader'] = null;
  91. $rs['advice_level5'] = null;
  92. }
  93. if (!isset($flow_dict["矿长党委书记审批"])) {
  94. $rs['advice_level6_leader'] = null;
  95. $rs['advice_level6'] = null;
  96. }
  97. $rs['advice_leader_max'] = empty($rs['advice_level6_leader']) ? $rs['advice_level5_leader'] : $rs['advice_level6_leader'];
  98. $flow_info = $this->flogmodel->getone("mid={$rs['id']} and step=1 and status=1 and `table` = 'sealapl'", 'checkname', 'id desc');
  99. $rs['dept_manager'] = $flow_info ? $flow_info['checkname'] : null;
  100. if (!empty($rs['opinion_dept'])) {
  101. $dept = $rs['opinion_dept'];
  102. // 办公室需要审核部门
  103. $examine_dept_arr = explode(',',$dept);
  104. $examine_info = '';
  105. foreach ($examine_dept_arr as $v) {
  106. $examine_info .= $this->examine_dept_dic[$v].'、';
  107. }
  108. if (!empty($examine_info)) {
  109. $examine_info = substr($examine_info, 0, strlen($examine_info) - 3);
  110. $examine_info = '需要“'.$examine_info.'”审核。';
  111. }
  112. if (!empty($rs['advice_level2'])) {
  113. $rs['advice_level2'] = $rs['advice_level2'].'<br>'.$examine_info;
  114. } else {
  115. $rs['advice_level2'] = $examine_info;
  116. }
  117. // 列表-审批人:
  118. // if ($dept == 1) {
  119. // $flow_info = $this->flogmodel->getone("mid={$rs['id']} and step=3 and status=1 and `table` = 'sealapl'", 'checkname', 'id desc');
  120. // $rs['advice_level1_applyer'] = $flow_info ? $flow_info['checkname'] : null;
  121. // } else if ($dept == 2) {
  122. //
  123. // } else if ($dept == 3) {
  124. // $flow_info = $this->flogmodel->getone("mid={$rs['id']} and step=3 and status=1 and `table` = 'sealapl'", 'checkname', 'id desc');
  125. // $rs['advice_level3_applyer'] = $flow_info ? $flow_info['checkname'] : null;
  126. // } else if ($dept == 4) {
  127. // $flow_info = $this->flogmodel->getone("mid={$rs['id']} and step=3 and status=1 and `table` = 'sealapl'", 'checkname', 'id desc');
  128. // $rs['advice_level4_applyer'] = $flow_info ? $flow_info['checkname'] : null;
  129. // }
  130. }
  131. // 办公室审核人
  132. $flow_info = $this->flogmodel->getone("mid={$rs['id']} and step=2 and status=1 and `table` = 'sealapl'", 'checkname', 'id desc');
  133. $rs['advice_level2_leader'] = $flow_info ? $flow_info['checkname'] : null;
  134. // 印章专管人
  135. $seal = m('seal')->getone("id = {$rs['seal_name']}");
  136. $rs['office_applyer'] = $seal['specialized'];
  137. $rs['seal_name'] = $seal['name'];
  138. // 流程状态
  139. $rs['state_info'] = $this->getApproval($rs['nowcheckname'] ?? ''); // 当前审核人
  140. // 详情编号展示
  141. $date = $this->rs['applydt'] ?? null;
  142. if ($date) {
  143. $year = date("Y", strtotime($date));
  144. $month = date("m", strtotime($date));
  145. $this_month = date("Y-m", strtotime($date));
  146. $last_month = date("Y-m", strtotime("-1 month", strtotime($date)));
  147. $this_month_max_id = $this->getone("DATE_FORMAT(applydt,'%Y-%m') = '{$this_month}'", "max(id) as id")['id'];
  148. $last_month_max_id = $this->getone("DATE_FORMAT(applydt,'%Y-%m') = '{$last_month}'", "max(id) as id")['id'];
  149. $this_month_max_id = empty($last_month_max_id) ? 2 : $this_month_max_id;
  150. $rs['year'] = $year;
  151. $rs['month'] = $month;
  152. $rs['num'] = ($this->id - (empty($last_month_max_id) ? $this_month_max_id - 2: $last_month_max_id));
  153. }
  154. return $rs;
  155. }
  156. // 审核样式
  157. public function getApproval($names) {
  158. if (empty($names)) {
  159. $html = '<font style="background-color:#00c959; padding: 2px 8px; border-radius: 4px; color: #fff">已审核</font>';
  160. return $html;
  161. } else {
  162. $html = '<font style="background-color:#ff4974; padding: 2px 8px; border-radius: 4px; color: #fff">待审核</font><br /><font style="color: #ff4974">审核人:'.$names.'</font>';
  163. return $html;
  164. }
  165. }
  166. public function inputtitle()
  167. {
  168. return "枣泉煤矿用印审批表";
  169. }
  170. protected function flowdatalog($arr)
  171. {
  172. $arr['title'] = $this->inputtitle();
  173. return $arr;
  174. }
  175. // $ors当前单据操作信息,$crs提交过来的信息
  176. public function flowoptmenu($ors, $crs)
  177. {
  178. if ($ors['num'] == 'dept_process') {
  179. }
  180. }
  181. //审核之前调用$zt 状态, $sm说明
  182. protected function flowcheckbefore($zt, $sm, $ufied) {
  183. if ($zt == 1) {
  184. $nodes_old = $this->rs['notes'];
  185. if (isset($this->nowcourse['step'])) {
  186. if (empty($sm)) $sm = '同意';
  187. $step_name = $this->nowcourse['name'];
  188. $info = "";
  189. if ($step_name == '部门领导审批') {
  190. $info = [
  191. "advice_level1"=>$sm,
  192. "advice_level1_leader"=>$this->rock->adminname,
  193. "advice_level1_leader_id"=>$this->rock->adminid,
  194. "notes"=>'部门领导-'.$this->rock->adminname.":".$sm
  195. ];
  196. } else if ($step_name == '办公室审批') {
  197. $info = [
  198. "advice_level2"=>$sm,
  199. "advice_level2_leader"=>$this->rock->adminname,
  200. "advice_level2_leader_id"=>$this->rock->adminid,
  201. "notes"=>$nodes_old.(empty($nodes_old) ? "" : "<br>").'办公室-'.$this->rock->adminname.":".$sm
  202. ];
  203. } else if ($step_name == '业务主管部门审批') {
  204. $info = [
  205. "advice_level3"=>$sm,
  206. "advice_level3_leader"=>$this->rock->adminname,
  207. "advice_level3_leader_id"=>$this->rock->adminid,
  208. "notes"=>$nodes_old.(empty($nodes_old) ? "" : "<br>").'业务主管部门-'.$this->rock->adminname.":".$sm
  209. ];
  210. } else if ($step_name == '法律事务部审批') {
  211. $info = [
  212. "advice_level4"=>$sm,
  213. "advice_level4_leader"=>$this->rock->adminname,
  214. "advice_level4_leader_id"=>$this->rock->adminid,
  215. "notes"=>$nodes_old.(empty($nodes_old) ? "" : "<br>").'法律事务部-'.$this->rock->adminname.":".$sm
  216. ];
  217. } else if ($step_name == '矿分管领导审批') {
  218. $info = [
  219. "advice_level5"=>$sm,
  220. "advice_level5_leader"=>$this->rock->adminname,
  221. "advice_level5_leader_id"=>$this->rock->adminid,
  222. "notes"=>$nodes_old.(empty($nodes_old) ? "" : "<br>").'矿分管领导-'.$this->rock->adminname.":".$sm
  223. ];
  224. } else if ($step_name == '矿长党委书记审批') {
  225. $info = [
  226. "advice_level6"=>$sm,
  227. "advice_level6_leader"=>$this->rock->adminname,
  228. "advice_level6_leader_id"=>$this->rock->adminid,
  229. "notes"=>$nodes_old.(empty($nodes_old) ? "" : "<br>").'矿长党委书记-'.$this->rock->adminname.":".$sm
  230. ];
  231. }
  232. if (!empty($info)) m('sealapl')->update($info,"id={$this->id}");
  233. }
  234. // if ($this->nowcourse['step'] == 3 && $this->nowcourse['name'] == '负责部门审批') {
  235. // $opinion_dept = $this->rs['opinion_dept'];
  236. // if ($opinion_dept == 1) {
  237. // m('sealapl')->update(["advice_level1"=>$sm],"id={$this->id}");
  238. // } else if ($opinion_dept == 2) {
  239. // m('sealapl')->update(["advice_level2"=>$sm],"id={$this->id}");
  240. // } else if ($opinion_dept == 3) {
  241. // m('sealapl')->update(["advice_level3"=>$sm],"id={$this->id}");
  242. // } else if ($opinion_dept == 4) {
  243. // m('sealapl')->update(["advice_level4"=>$sm],"id={$this->id}");
  244. // }
  245. // }
  246. }
  247. // if(isset($this->nowcourse['step']) && !empty($sm)) {
  248. // $info_old = $this->rs['notes'];
  249. // $info = $this->nowcourse['step'].'.'.$this->adminname.":".$sm."\n";
  250. // $info = $info_old.$info;
  251. // $info = substr($info, 0, strlen($info)-1);
  252. // m('sealapl')->update(["notes"=>$info],"id={$this->id}");
  253. // }
  254. }
  255. }