HolidayController.php 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883
  1. <?php
  2. /**
  3. * @author darkredz
  4. */
  5. class HolidayController extends DooController {
  6. public $staff;
  7. function __construct() {
  8. if(isset($_COOKIE["staff"])){
  9. if(!empty($_COOKIE["staff"])){
  10. Doo::loadModel ( 'staff' );
  11. $staff = new staff ();
  12. $this->staff=$staff->getUserByIdList($_COOKIE["staff"]);
  13. return "/";
  14. }
  15. }
  16. Doo::loadCore ( 'uri/DooUriRouter' );
  17. $router = new DooUriRouter ();
  18. $routeRs = $router->execute ( Doo::app ()->route, Doo::conf ()->SUBFOLDER );
  19. if($routeRs['1']!="login"){
  20. header ( 'Content-Type:text/html;charset=utf-8' );
  21. @header ( "Location: /login" );
  22. }
  23. }
  24. public function myList(){
  25. $checkadmin = $this->checkisadmin();
  26. if($checkadmin){
  27. $data['cansee'] = 1;
  28. }
  29. Doo::loadModel('holidayday');
  30. Doo::loadModel('holiday');
  31. Doo::loadModel('holidaystaff');
  32. $hday = new HDay();
  33. $holiday = new Holiday();
  34. $hstaff = new HStaff();
  35. $thisyear = date('Y',time());
  36. // $thisyear = date('Y',1546358400);
  37. $num = intval($thisyear)-2017;
  38. $html = '';
  39. $yearnum = isset($this->params['yearnum']) && is_numeric($this->params['yearnum']) ? $this->params['yearnum'] : '';
  40. for($i = $num; $i >= 0; $i--){
  41. if($yearnum == (2017+$i)){
  42. $html .= '<option value="'.(2017+$i).'" selected>'.(2017+$i).'</option>';
  43. }else{
  44. $html .= '<option value="'.(2017+$i).'">'.(2017+$i).'</option>';
  45. }
  46. }
  47. $data['option'] = $html;
  48. $yeartime = isset($this->params['yearnum']) && is_numeric($this->params['yearnum']) ? $this->getYearMonthTime($this->params['yearnum']) : $this->getYearMonthTime($thisyear);
  49. //记录事,病,旷,加,值,补,调的信息
  50. $holidaymsg = array('1'=> array(), '2' => array(), '3' => array(), '4' => array(), '5' => array(), '10' => array(), '11' => array());
  51. foreach(array(1,2,3,4,5,10,11) as $k => $v){
  52. $all = 0;
  53. for($i = 0; $i < 12; $i++){
  54. if($v == 11){
  55. $typeholiday = $holiday->find(array('where' => 'status=1 and type='.$v.' and uid='.$this->staff[0]['sid'].' and addtime between '.$yeartime[$i]['starttime'].' and '.$yeartime[$i]['endtime'],'asArray' => TRUE));
  56. $holidaymsg[$v][$i+1] = 0;
  57. if(!empty($typeholiday)){
  58. foreach($typeholiday as $tk => $tv){
  59. $holidaymsg[$v][$i+1] += floatval($tv['daynum']);
  60. $all += floatval($tv['daynum']);
  61. }
  62. }
  63. $holidaymsg[$v][$i+1] = $holidaymsg[$v][$i+1] != 0 ? $holidaymsg[$v][$i+1] : '';
  64. }else{
  65. $typeholiday = $hday->find(array('where' => 'type='.$v.' and uid='.$this->staff[0]['sid'].' and UNIX_TIMESTAMP(daytime) between '.$yeartime[$i]['starttime'].' and '.$yeartime[$i]['endtime'],'asArray' => TRUE));
  66. $holidaymsg[$v][$i+1] = 0;
  67. if(!empty($typeholiday)){
  68. foreach($typeholiday as $tk => $tv){
  69. $holidaymsg[$v][$i+1] += floatval($tv['daymsg']);
  70. $all += floatval($tv['daymsg']);
  71. }
  72. }
  73. $holidaymsg[$v][$i+1] = $holidaymsg[$v][$i+1] != 0 ? $holidaymsg[$v][$i+1] : '';
  74. }
  75. }
  76. $holidaymsg[$v]['all'] = $all != 0 ? $all : '';
  77. }
  78. $hstaffmsg = $hstaff->getOne(array('where' => 'uid='.$this->staff[0]['sid'], 'asArray' => TRUE));
  79. $data['yearnum'] = floatval($hstaffmsg['yearnum']);
  80. $data['overtimetnum'] = floatval($holidaymsg[4]['all'])+floatval($holidaymsg[5]['all']);
  81. $data['addnum'] = floatval($hstaffmsg['addnum']);
  82. $data['hunjianum'] = floatval($hstaffmsg['hunjianum']);
  83. $data['chanjianum'] = floatval($hstaffmsg['chanjianum']);
  84. $data['sangjianum'] = floatval($hstaffmsg['sangjianum']);
  85. $data['gongjianum'] = floatval($hstaffmsg['gongjianum']);
  86. $data['yearround'] = $this->getYearRoundtime($hstaffmsg['hadyear'],$this->staff[0]['hiredate']);
  87. // var_dump($holidaymsg);
  88. // exit;
  89. $data['holidaymsg'] = $holidaymsg;
  90. $data ['memu'] = 'holiday';
  91. $data ['holidaymenu'] = 'mylist';
  92. $data ['staff'] = $this->staff;
  93. $data['noindexjs'] = 'noindexjs';
  94. $this->render ( "/holiday-myList", $data );
  95. }
  96. public function holidayBorad(){
  97. $checkadmin = $this->checkisadmin();
  98. if($checkadmin){
  99. $data['cansee'] = 1;
  100. }
  101. Doo::loadModel('holiday');
  102. Doo::loadModel('holidayday');
  103. Doo::loadModel('holidaystaff');
  104. Doo::loadModel('holidaytype');
  105. $thismonth = $this->getMonthTime(date('Y-m-d',time()));
  106. $data['countmonth'] = date("Y年m月",time());
  107. $holiday = new Holiday();
  108. $hday = new HDay();
  109. $hstaff = new HStaff();
  110. $type = new HType();
  111. $holidaycount =array();
  112. foreach(array(1,2,3,4,5) as $k => $v){
  113. $typeholiday = $hday->find(array('where' => 'type='.$v.' and uid='.$this->staff[0]['sid'].' and UNIX_TIMESTAMP(daytime) between '.$thismonth['start'].' and '.$thismonth['end'],'asArray' => TRUE));
  114. $holidaycount[$k] = 0;
  115. if(!empty($typeholiday)){
  116. foreach($typeholiday as $tk => $tv){
  117. $holidaycount[$k] += floatval($tv['daymsg']);
  118. }
  119. }
  120. }
  121. $hstaffmsg = $hstaff->getOne(array('where' => 'uid='.$this->staff[0]['sid'], 'asArray' => TRUE));
  122. $holidaycount[5] = floatval($hstaffmsg['yearnum']);
  123. $holidaycount[6] = floatval($hstaffmsg['addnum']);
  124. $data['holidaycount'] = $holidaycount;
  125. $holidaymsg = $holiday->find(array('where' => 'uid='.$this->staff[0]['sid'], 'limit' => 10, 'desc' => 'approvetime', 'desc' => 'id', 'asArray' => TRUE));
  126. if(!empty($holidaymsg)){
  127. foreach($holidaymsg as $k => $v){
  128. $holidaymsg[$k]['typename'] = $type->getTypeNamebyid($v['type']);
  129. $holidaymsg[$k]['daynum'] = floatval($v['daynum']);
  130. $holidaymsg[$k]['approvetime'] = !empty($v['approvetime']) ? date('Y-m-d H:i:s',$v['approvetime']) : '';
  131. $msg = '';
  132. if(in_array($v['type'],array(1,2,3,4,5,10,11,12))){
  133. $dayjson = json_decode($v['dayjson']);
  134. if($v['type'] != 11){
  135. $holidaydays = $this->geyDayMsg($dayjson->holiday);
  136. foreach($holidaydays as $hk => $hv){
  137. $msg .= $hv['daytime'].' '.$hv['daymsg'].',';
  138. }
  139. $msg = substr($msg,0,strlen($msg)-1);
  140. }else{
  141. $msg .= '休假时间:';
  142. $holidaydays = $this->geyDayMsg($dayjson->holiday);
  143. foreach($holidaydays as $hk => $hv){
  144. $msg .= $hv['daytime'].' '.$hv['daymsg'].',';
  145. }
  146. $msg = substr($msg,0,strlen($msg)-1);
  147. $msg .= '
  148. 加班时间:';
  149. $overtimedays = $this->geyDayMsg($dayjson->overtime);
  150. foreach($overtimedays as $ok => $ov){
  151. $msg .= $ov['daytime'].' '.$ov['daymsg'].',';
  152. }
  153. $msg = substr($msg,0,strlen($msg)-1);
  154. }
  155. }elseif(in_array($v['type'],array(6,7,8,9))){
  156. $msg .= $v['starttime']. ' 至 '.$v['endtime'];
  157. }elseif(in_array($v['type'],array(13,14,15,16,17,18,19))){
  158. $msg .= date('Y-m-d H:i:s',$v['addtime']);
  159. }
  160. $holidaymsg[$k]['daymsg'] = $msg;
  161. }
  162. $data['holidaylist'] = $holidaymsg;
  163. }
  164. $data ['memu'] = 'holiday';
  165. $data ['holidaymenu'] = 'borad';
  166. $data ['staff'] = $this->staff;
  167. $data['noindexjs'] = 'noindexjs';
  168. $this->render ( "/holiday-borad", $data );
  169. }
  170. public function allList(){
  171. $checkadmin = $this->checkisadmin();
  172. if($checkadmin){
  173. $data['cansee'] = 1;
  174. }
  175. Doo::loadModel('holiday');
  176. Doo::loadModel('holidaytype');
  177. $holiday = new Holiday();
  178. $type = new HType();
  179. if(isset($this->params['type'])){
  180. if($this->params['type'] == 4 ){//加班、值班
  181. $sql = ' and (type=4 or type=5)';
  182. }elseif($this->params['type'] == 6){//其他,管理员操作
  183. $sql = ' and type in(3,6,7,8,9,13,14,15,16,17,18,19)';
  184. }else{
  185. $sql = ' and type='.$this->params['type'];
  186. }
  187. $pagemsg = '/type/'.$this->params['type'];
  188. $data['thistype'] = $this->params['type'];
  189. }else{
  190. $sql = '';
  191. $pagemsg = '';
  192. $data['thistype'] = '';
  193. }
  194. Doo::loadHelper('DooPager');
  195. $totalArchive = $holiday->count(array('where' => 'uid='.$this->staff[0]['sid'].$sql, 'asArray' => TRUE));
  196. $pager = new DooPager(Doo::conf()->APP_URL . "holidayallList".$pagemsg."/page", $totalArchive, 10, 10);
  197. if (isset($this->params['pindex']))
  198. $pager->paginate(intval($this->params['pindex']));
  199. else
  200. $pager->paginate(1);
  201. if ($pager->limit != ' -10,10')
  202. $holidaymsg = $holiday->find(array('where' => 'uid='.$this->staff[0]['sid'].$sql, 'limit' => $pager->limit, 'desc' => 'id', 'asArray' => TRUE));
  203. if(isset($holidaymsg) && !empty($holidaymsg)){
  204. foreach($holidaymsg as $k => $v){
  205. $holidaymsg[$k]['typename'] = $type->getTypeNamebyid($v['type']);
  206. $holidaymsg[$k]['daynum'] = floatval($v['daynum']);
  207. $holidaymsg[$k]['approvetime'] = !empty($v['approvetime']) ? date('Y-m-d H:i:s',$v['approvetime']) : '';
  208. $msg = '';
  209. if(in_array($v['type'],array(1,2,3,4,5,10,11,12))){
  210. $dayjson = json_decode($v['dayjson']);
  211. if($v['type'] != 11){
  212. $holidaydays = $this->geyDayMsg($dayjson->holiday);
  213. foreach($holidaydays as $hk => $hv){
  214. $msg .= $hv['daytime'].' '.$hv['daymsg'].',';
  215. }
  216. $msg = substr($msg,0,strlen($msg)-1);
  217. }else{
  218. $msg .= '休假时间:';
  219. $holidaydays = $this->geyDayMsg($dayjson->holiday);
  220. foreach($holidaydays as $hk => $hv){
  221. $msg .= $hv['daytime'].' '.$hv['daymsg'].',';
  222. }
  223. $msg = substr($msg,0,strlen($msg)-1);
  224. $msg .= '<br>加班时间:';
  225. $overtimedays = $this->geyDayMsg($dayjson->overtime);
  226. foreach($overtimedays as $ok => $ov){
  227. $msg .= $ov['daytime'].' '.$ov['daymsg'].',';
  228. }
  229. $msg = substr($msg,0,strlen($msg)-1);
  230. }
  231. }elseif(in_array($v['type'],array(6,7,8,9))){
  232. $msg .= $v['starttime']. ' 至 '.$v['endtime'];
  233. }elseif(in_array($v['type'],array(13,14,15,16,17,18,19))){
  234. $msg .= date('Y-m-d H:i:s',$v['addtime']);
  235. }
  236. $holidaymsg[$k]['daymsg'] = $msg;
  237. }
  238. $data['holidaylist'] = $holidaymsg;
  239. }
  240. $data['pager'] = $pager->output;
  241. $data ['memu'] = 'holiday';
  242. $data ['holidaymenu'] = 'borad';
  243. $data ['staff'] = $this->staff;
  244. $data['noindexjs'] = 'noindexjs';
  245. $this->render ( "/holiday-allList", $data );
  246. }
  247. public function holidayClose(){
  248. $checkadmin = $this->checkisadmin();
  249. if(!$checkadmin){
  250. exit('非假期管理员无法访问此页面');
  251. }
  252. $data['cansee'] = 1;
  253. //获取办事处列表
  254. Doo::loadModel('staff');
  255. Doo::loadModel('holidaystaff');
  256. Doo::loadModel('holidayday');
  257. Doo::loadModel('holiday');
  258. $staff = new staff();
  259. $hstaff = new HStaff();
  260. $hday = new HDay();
  261. $holiday = new Holiday();
  262. $sql = 'SELECT `CLD_L_category`.cid,`CLD_L_category`.title,count(`CLD_staff`.sid) as count FROM `CLD_L_category` left join `CLD_staff` on `CLD_L_category`.cid=`CLD_staff`.cid where `CLD_staff`.nature=1 group by `CLD_staff`.cid HAVING count(`CLD_staff`.sid)>0 order by count(`CLD_staff`.sid) desc';
  263. $query = Doo::db ()->query ( $sql );
  264. $result = $query->fetchAll ();
  265. $data['category'] = $result;
  266. $thisyear = date('Y',time());
  267. // $thisyear = date('Y',1546358400);
  268. $data['thismonth'] = intval(date('m',time()));
  269. $num = intval($thisyear)-2017;
  270. $html = '';
  271. $yearnum = isset($this->params['year']) && is_numeric($this->params['year']) ? $this->params['year'] : '';
  272. for($i = $num; $i >= 0; $i--){
  273. if($yearnum == (2017+$i)){
  274. $html .= '<option value="'.(2017+$i).'" selected>'.(2017+$i).'</option>';
  275. }else{
  276. $html .= '<option value="'.(2017+$i).'">'.(2017+$i).'</option>';
  277. }
  278. }
  279. $data['option'] = $html;
  280. if(isset($this->params['year']) && isset($this->params['month'])){
  281. $month = intval($this->params['month']) < 10 ? '0'.$this->params['month'] : $this->params['month'];
  282. $date = $this->params['year'].'-'.$month.'-01';
  283. $thismonth = $this->getMonthTime($date);
  284. $data['thismonth'] = $this->params['month'];
  285. }else{
  286. $thismonth = $this->getMonthTime(date('Y-m-d',time()));
  287. }
  288. foreach($result as $k => $v){
  289. $stafflist[$k]['categoryname'] = $v['title'];
  290. $stafflist[$k]['count'] = $v['count'];
  291. $cidstafflist = $staff->find(array('where' => 'cid='.$v['cid'].' and nature=1', 'asArray' => TRUE));
  292. foreach($cidstafflist as $ck => $cv) {
  293. foreach (array(1, 2, 3) as $tk => $tv) {
  294. $typeholiday = $hday->find(array('where' => 'type=' . $tv . ' and uid=' . $cv['sid'] . ' and UNIX_TIMESTAMP(daytime) between ' . $thismonth['start'] . ' and ' . $thismonth['end'], 'asArray' => TRUE));
  295. $cidstafflist[$ck][$tv] = 0;
  296. if (!empty($typeholiday)) {
  297. foreach ($typeholiday as $thk => $thv) {
  298. $cidstafflist[$ck][$tv] += floatval($thv['daymsg']);
  299. }
  300. }
  301. $cidstafflist[$ck][$tv] = $cidstafflist[$ck][$tv] != 0 ? $cidstafflist[$ck][$tv] : '';
  302. }
  303. $cidstafflist[$ck]['first'] = $ck == 0 ? 1 : ''; // 是否第一个
  304. }
  305. $stafflist[$k]['cidstafflist'] = $cidstafflist;
  306. }
  307. $data['stafflist'] = $stafflist;
  308. $zongbu = $staff->find(array('where' => 'cid=12 and nature=1', 'asArray' => TRUE));
  309. $data['zongbu'] = $zongbu;
  310. $data ['memu'] = 'holiday';
  311. $data ['holidaymenu'] = 'close';
  312. $data ['staff'] = $this->staff;
  313. $data['noindexjs'] = 'noindexjs';
  314. $this->render ( "/holiday-close", $data );
  315. }
  316. public function holidayClose2(){
  317. $checkadmin = $this->checkisadmin();
  318. if(!$checkadmin){
  319. exit('非假期管理员无法访问此页面');
  320. }
  321. $data['cansee'] = 1;
  322. //获取办事处列表
  323. Doo::loadModel('staff');
  324. Doo::loadModel('holidaystaff');
  325. Doo::loadModel('holidayday');
  326. Doo::loadModel('holiday');
  327. $staff = new staff();
  328. $hstaff = new HStaff();
  329. $hday = new HDay();
  330. $holiday = new Holiday();
  331. $sql = 'SELECT `CLD_L_category`.cid,`CLD_L_category`.title,count(`CLD_staff`.sid) as count FROM `CLD_L_category` left join `CLD_staff` on `CLD_L_category`.cid=`CLD_staff`.cid where `CLD_staff`.nature=2 group by `CLD_staff`.cid HAVING count(`CLD_staff`.sid)>0 order by count(`CLD_staff`.sid) desc';
  332. $query = Doo::db ()->query ( $sql );
  333. $result = $query->fetchAll ();
  334. $data['category'] = $result;
  335. $thisyear = date('Y',time());
  336. // $thisyear = date('Y',1546358400);
  337. $data['thismonth'] = intval(date('m',time()));
  338. $num = intval($thisyear)-2017;
  339. $html = '';
  340. $yearnum = isset($this->params['year']) && is_numeric($this->params['year']) ? $this->params['year'] : '';
  341. for($i = $num; $i >= 0; $i--){
  342. if($yearnum == (2017+$i)){
  343. $html .= '<option value="'.(2017+$i).'" selected>'.(2017+$i).'</option>';
  344. }else{
  345. $html .= '<option value="'.(2017+$i).'">'.(2017+$i).'</option>';
  346. }
  347. }
  348. $data['option'] = $html;
  349. if(isset($this->params['year']) && isset($this->params['month'])){
  350. $month = intval($this->params['month']) < 10 ? '0'.$this->params['month'] : $this->params['month'];
  351. $date = $this->params['year'].'-'.$month.'-01';
  352. $thismonth = $this->getMonthTime($date);
  353. $data['thismonth'] = $this->params['month'];
  354. }else{
  355. $thismonth = $this->getMonthTime(date('Y-m-d',time()));
  356. }
  357. $stafflist = array();
  358. foreach($result as $k => $v){
  359. $stafflist[$k]['categoryname'] = $v['title'];
  360. $stafflist[$k]['count'] = $v['count'];
  361. $cidstafflist = $staff->find(array('where' => 'cid='.$v['cid'].' and nature=2', 'asArray' => TRUE));
  362. foreach($cidstafflist as $ck => $cv) {
  363. foreach (array(1, 2, 3, 14) as $tk => $tv) {
  364. if($tv == 14){
  365. $typeholiday = $holiday->getOne(array('where' => 'status=3 and type='.$tv.' and uid='.$cv['sid'].' and starttime="'.$thismonth['start'].'" and endtime="'.$thismonth['end'].'"', 'desc' => 'id', 'asArray' => TRUE));
  366. $cidstafflist[$ck][$tv] = $typeholiday['daynum'] != 0 ? floatval($typeholiday['daynum']) : '';
  367. }else{
  368. $typeholiday = $hday->find(array('where' => 'type=' . $tv . ' and uid=' . $cv['sid'] . ' and UNIX_TIMESTAMP(daytime) between ' . $thismonth['start'] . ' and ' . $thismonth['end'], 'asArray' => TRUE));
  369. $cidstafflist[$ck][$tv] = 0;
  370. if (!empty($typeholiday)) {
  371. foreach ($typeholiday as $thk => $thv) {
  372. $cidstafflist[$ck][$tv] += floatval($thv['daymsg']);
  373. }
  374. }
  375. $cidstafflist[$ck][$tv] = $cidstafflist[$ck][$tv] != 0 ? $cidstafflist[$ck][$tv] : '';
  376. }
  377. }
  378. $cidstafflist[$ck]['first'] = $ck == 0 ? 1 : ''; // 是否第一个
  379. }
  380. $stafflist[$k]['cidstafflist'] = $cidstafflist;
  381. }
  382. $data['stafflist'] = $stafflist;
  383. $data['internstafflist'] = $staff->find(array('where' => 'nature=2', 'asArray' => TRUE));
  384. $data ['memu'] = 'holiday';
  385. $data ['holidaymenu'] = 'close';
  386. $data ['staff'] = $this->staff;
  387. $data['noindexjs'] = 'noindexjs';
  388. $this->render ( "/holiday-close2", $data );
  389. }
  390. public function addHoliday2(){
  391. if(isset($_POST['uid']) && is_numeric($_POST['uid']) && isset($_POST['type']) && is_numeric($_POST['type'])){
  392. Doo::loadModel('holiday');
  393. $holiday = new Holiday();
  394. if(in_array($_POST['type'],array(1,2,3))){
  395. $day = $_POST['day'];
  396. $dayjson = array('holiday' => [$day.'_1']);
  397. $holiday->uid = $_POST['uid'];
  398. $holiday->type = $_POST['type'];
  399. $holiday->dayjson = json_encode($dayjson);
  400. $holiday->daynum = 1.0;
  401. $holiday->status = 3;
  402. $holiday->addtime = time();
  403. $holiday->approvetime = time();
  404. $holiday->description = $_POST['description'];
  405. $id = $holiday->insert();
  406. Doo::loadModel('holidayday');
  407. $hday = new HDay();
  408. $hday->hid = $id;
  409. $hday->uid = $_POST['uid'];
  410. $hday->type = $_POST['type'];
  411. $hday->daytime = $day;
  412. $hday->daymsg = 1.0;
  413. $hday->insert();
  414. if(isset($_POST['close2'])){
  415. return '/holidayclose2';
  416. }else{
  417. return '/holidayclose';
  418. }
  419. }elseif($_POST['type'] == 14){
  420. $thismonth = $this->getMonthTime(date('Y-m-d',time()));
  421. $holiday->uid = $_POST['uid'];
  422. $holiday->type = $_POST['type'];
  423. $holiday->starttime = $thismonth['start'];
  424. $holiday->endtime = $thismonth['end'];
  425. $holiday->daynum = $_POST['daynum'];
  426. $holiday->status = 3;
  427. $holiday->addtime = time();
  428. $holiday->approvetime = time();
  429. $holiday->description = $_POST['description'];
  430. $holiday->insert();
  431. return '/holidayclose2';
  432. }
  433. }
  434. exit('添加事病假、旷工出错');
  435. }
  436. public function holidayOvertime(){
  437. $checkadmin = $this->checkisadmin();
  438. if(!$checkadmin){
  439. exit('非假期管理员无法访问此页面');
  440. }
  441. $data['cansee'] = 1;
  442. //获取办事处列表
  443. Doo::loadModel('staff');
  444. Doo::loadModel('holidaystaff');
  445. Doo::loadModel('holidayday');
  446. Doo::loadModel('holiday');
  447. $staff = new staff();
  448. $hstaff = new HStaff();
  449. $hday = new HDay();
  450. $holiday = new Holiday();
  451. $sql = 'SELECT `CLD_L_category`.cid,`CLD_L_category`.title,count(`CLD_staff`.sid) as count FROM `CLD_L_category` left join `CLD_staff` on `CLD_L_category`.cid=`CLD_staff`.cid group by `CLD_staff`.cid HAVING count(`CLD_staff`.sid)>0 order by count(`CLD_staff`.sid) desc';
  452. $query = Doo::db ()->query ( $sql );
  453. $result = $query->fetchAll ();
  454. $data['category'] = $result;
  455. $thisyear = date('Y',time());
  456. // $thisyear = date('Y',1546358400);
  457. $data['thismonth'] = intval(date('m',time()));
  458. $num = intval($thisyear)-2017;
  459. $html = '';
  460. $yearnum = isset($this->params['year']) && is_numeric($this->params['year']) ? $this->params['year'] : '';
  461. for($i = $num; $i >= 0; $i--){
  462. if($yearnum == (2017+$i)){
  463. $html .= '<option value="'.(2017+$i).'" selected>'.(2017+$i).'</option>';
  464. }else{
  465. $html .= '<option value="'.(2017+$i).'">'.(2017+$i).'</option>';
  466. }
  467. }
  468. $data['option'] = $html;
  469. if(isset($this->params['year']) && isset($this->params['month'])){
  470. $month = intval($this->params['month']) < 10 ? '0'.$this->params['month'] : $this->params['month'];
  471. $date = $this->params['year'].'-'.$month.'-01';
  472. $thismonth = $this->getMonthTime($date);
  473. $data['thismonth'] = $this->params['month'];
  474. }else{
  475. $thismonth = $this->getMonthTime(date('Y-m-d',time()));
  476. }
  477. $stafflist = array();
  478. if(isset($this->params['cid']) && is_numeric($this->params['cid'])){
  479. $data['thiscid'] = $this->params['cid'];
  480. foreach($result as $k => $v){
  481. if($this->params['cid'] == $v['cid']){
  482. $stafflist[0]['categoryname'] = $v['title'];
  483. $stafflist[0]['count'] = $v['count'];
  484. $cidstafflist = $staff->getStaffByCid($v['cid']);
  485. foreach($cidstafflist as $ck => $cv){
  486. $hstaffmsg = $hstaff->getOne(array('where' => 'uid='.$cv['sid'], 'asArray' => TRUE));
  487. $cidstafflist[$ck]['addnum'] = $hstaffmsg['addnum'] != 0.0 ? floatval($hstaffmsg['addnum']) : '';
  488. foreach(array(4,5,10,11) as $tk => $tv){
  489. if($tv == 11){
  490. $typeholiday = $holiday->find(array('where' => 'status=1 and type='.$tv.' and uid='.$cv['sid'].' and addtime between '.$thismonth['start'].' and '.$thismonth['end'],'asArray' => TRUE));
  491. $cidstafflist[$ck][$tv] = 0;
  492. if(!empty($typeholiday)){
  493. foreach($typeholiday as $thk => $thv){
  494. $cidstafflist[$ck][$tv] += floatval($thv['daynum']);
  495. }
  496. }
  497. $cidstafflist[$ck][$tv] = $cidstafflist[$ck][$tv] != 0 ? $cidstafflist[$ck][$tv] : '';
  498. }else{
  499. $typeholiday = $hday->find(array('where' => 'type='.$tv.' and uid='.$cv['sid'].' and UNIX_TIMESTAMP(daytime) between '.$thismonth['start'].' and '.$thismonth['end'],'asArray' => TRUE));
  500. $cidstafflist[$ck][$tv] = 0;
  501. if(!empty($typeholiday)){
  502. foreach($typeholiday as $thk => $thv){
  503. $cidstafflist[$ck][$tv] += floatval($thv['daymsg']);
  504. }
  505. }
  506. $cidstafflist[$ck][$tv] = $cidstafflist[$ck][$tv] != 0 ? $cidstafflist[$ck][$tv] : '';
  507. }
  508. }
  509. $cidstafflist[$ck]['countnum'] = floatval($cidstafflist[$ck][4])+floatval($cidstafflist[$ck][5]) != 0 ? floatval($cidstafflist[$ck][4]) + floatval($cidstafflist[$ck][5]) : '';
  510. $cidstafflist[$ck]['first'] = $ck == 0 ? 1 : ''; // 是否第一个
  511. }
  512. $stafflist[0]['cidstafflist'] = $cidstafflist;
  513. break;
  514. }
  515. }
  516. }else{
  517. foreach($result as $k => $v){
  518. $stafflist[$k]['categoryname'] = $v['title'];
  519. $stafflist[$k]['count'] = $v['count'];
  520. $cidstafflist = $staff->getStaffByCid($v['cid']);
  521. foreach($cidstafflist as $ck => $cv) {
  522. $hstaffmsg = $hstaff->getOne(array('where' => 'uid=' . $cv['sid'], 'asArray' => TRUE));
  523. $cidstafflist[$ck]['addnum'] = $hstaffmsg['addnum'] != 0.0 ? floatval($hstaffmsg['addnum']) : '';
  524. foreach (array(4, 5, 10, 11) as $tk => $tv) {
  525. if ($tv == 11) {
  526. $typeholiday = $holiday->find(array('where' => 'status=1 and type=' . $tv . ' and uid=' . $cv['sid'] . ' and addtime between ' . $thismonth['start'] . ' and ' . $thismonth['end'], 'asArray' => TRUE));
  527. $cidstafflist[$ck][$tv] = 0;
  528. if (!empty($typeholiday)) {
  529. foreach ($typeholiday as $thk => $thv) {
  530. $cidstafflist[$ck][$tv] += floatval($thv['daynum']);
  531. }
  532. }
  533. $cidstafflist[$ck][$tv] = $cidstafflist[$ck][$tv] != 0 ? $cidstafflist[$ck][$tv] : '';
  534. } else {
  535. $typeholiday = $hday->find(array('where' => 'type=' . $tv . ' and uid=' . $cv['sid'] . ' and UNIX_TIMESTAMP(daytime) between ' . $thismonth['start'] . ' and ' . $thismonth['end'], 'asArray' => TRUE));
  536. $cidstafflist[$ck][$tv] = 0;
  537. if (!empty($typeholiday)) {
  538. foreach ($typeholiday as $thk => $thv) {
  539. $cidstafflist[$ck][$tv] += floatval($thv['daymsg']);
  540. }
  541. }
  542. $cidstafflist[$ck][$tv] = $cidstafflist[$ck][$tv] != 0 ? $cidstafflist[$ck][$tv] : '';
  543. }
  544. }
  545. $cidstafflist[$ck]['countnum'] = floatval($cidstafflist[$ck][4])+floatval($cidstafflist[$ck][5]) != 0 ? floatval($cidstafflist[$ck][4]) + floatval($cidstafflist[$ck][5]) : '';
  546. $cidstafflist[$ck]['first'] = $ck == 0 ? 1 : ''; // 是否第一个
  547. }
  548. $stafflist[$k]['cidstafflist'] = $cidstafflist;
  549. }
  550. }
  551. $data['stafflist'] = $stafflist;
  552. $zongbu = $staff->getStaffByCid(12);
  553. $data['zongbu'] = $zongbu;
  554. $data ['memu'] = 'holiday';
  555. $data ['holidaymenu'] = 'overtime';
  556. $data ['staff'] = $this->staff;
  557. $data['noindexjs'] = 'noindexjs';
  558. $this->render ( "/holiday-overtime", $data );
  559. }
  560. public function addHoliday(){
  561. if(isset($_POST['uid']) && is_numeric($_POST['uid']) && isset($_POST['type']) && is_numeric($_POST['type'])){
  562. Doo::loadModel('holidaystaff');
  563. Doo::loadModel('holiday');
  564. $holiday = new Holiday();
  565. $hstaff = new HStaff();
  566. $hstaffmsg = $hstaff->getOne(array('where' => 'uid='.$_POST['uid'], 'asArray' => TRUE));
  567. if($_POST['type'] == 4 || $_POST['type'] == 5){
  568. $day = $_POST['day'];
  569. $hstaff->uid = $_POST['uid'];
  570. $hstaff->addnum = floatval($hstaffmsg['addnum'])+1;
  571. $result = $hstaff->update();
  572. if($result){
  573. $dayjson = array('holiday' => [$day.'_1']);
  574. $holiday->uid = $_POST['uid'];
  575. $holiday->type = $_POST['type'];
  576. $holiday->dayjson = json_encode($dayjson);
  577. $holiday->daynum = 1.0;
  578. $holiday->status = 3;
  579. $holiday->addtime = time();
  580. $holiday->approvetime = time();
  581. $holiday->description = $_POST['description'];
  582. $id = $holiday->insert();
  583. Doo::loadModel('holidayday');
  584. $hday = new HDay();
  585. $hday->hid = $id;
  586. $hday->uid = $_POST['uid'];
  587. $hday->type = $_POST['type'];
  588. $hday->daytime = $day;
  589. $hday->daymsg = 1.0;
  590. $hday->insert();
  591. return '/holidayovertime';
  592. }else{
  593. exit('添加到holidaystaff出错');
  594. }
  595. }elseif($_POST['type'] == 13){
  596. $daynum = $_POST['tixian'];
  597. if($daynum > $hstaffmsg['addnum']){
  598. exit('提现天数超过存假天数了');
  599. }else{
  600. $hstaff->uid = $_POST['uid'];
  601. $hstaff->addnum = $hstaffmsg['addnum']-$daynum;
  602. $result = $hstaff->update();
  603. if($result){
  604. $holiday->uid = $_POST['uid'];
  605. $holiday->type = 13;
  606. $holiday->daynum = $daynum;
  607. $holiday->status = 3;
  608. $holiday->addtime = time();
  609. $holiday->approvetime = time();
  610. $holiday->description = $_POST['description'];
  611. $holiday->insert();
  612. return '/holidayovertime';
  613. }else{
  614. exit('添加到holidaystaff出错');
  615. }
  616. }
  617. }
  618. }
  619. exit('添加加值班或提现出错');
  620. }
  621. public function holidayVacation(){
  622. $checkadmin = $this->checkisadmin();
  623. if(!$checkadmin){
  624. exit('非假期管理员无法访问此页面');
  625. }
  626. $data['cansee'] = 1;
  627. //获取办事处列表
  628. Doo::loadModel('staff');
  629. Doo::loadModel('holidaystaff');
  630. $staff = new staff();
  631. $hstaff = new HStaff();
  632. $sql = 'SELECT `CLD_L_category`.cid,`CLD_L_category`.title,count(`CLD_staff`.sid) as count FROM `CLD_L_category` left join `CLD_staff` on `CLD_L_category`.cid=`CLD_staff`.cid group by `CLD_staff`.cid HAVING count(`CLD_staff`.sid)>0 order by count(`CLD_staff`.sid) desc';
  633. $query = Doo::db ()->query ( $sql );
  634. $result = $query->fetchAll ();
  635. $data['category'] = $result;
  636. $stafflist = array();
  637. if(isset($this->params['cid']) && is_numeric($this->params['cid'])){
  638. $data['thiscid'] = $this->params['cid'];
  639. foreach($result as $k => $v){
  640. if($this->params['cid'] == $v['cid']){
  641. $stafflist[0]['categoryname'] = $v['title'];
  642. $stafflist[0]['count'] = $v['count'];
  643. $cidstafflist = $staff->getStaffByCid($v['cid']);
  644. foreach($cidstafflist as $ck => $cv){
  645. $hstaffmsg = $hstaff->getOne(array('where' => 'uid='.$cv['sid'], 'asArray' => TRUE));
  646. $cidstafflist[$ck]['yearnum'] = $hstaffmsg['yearnum'] != 0.0 ? floatval($hstaffmsg['yearnum']) : '';
  647. $cidstafflist[$ck]['addnum'] = $hstaffmsg['addnum'] != 0.0 ? floatval($hstaffmsg['addnum']) : '';
  648. $cidstafflist[$ck]['hunjianum'] = $hstaffmsg['hunjianum'] != 0.0 ? floatval($hstaffmsg['hunjianum']) : '';
  649. $cidstafflist[$ck]['chanjianum'] = $hstaffmsg['chanjianum'] != 0.0 ? floatval($hstaffmsg['chanjianum']) : '';
  650. $cidstafflist[$ck]['sangjianum'] = $hstaffmsg['sangjianum'] != 0.0 ? floatval($hstaffmsg['sangjianum']) : '';
  651. $cidstafflist[$ck]['gongjianum'] = $hstaffmsg['gongjianum'] != 0.0 ? floatval($hstaffmsg['gongjianum']) : '';
  652. $cidstafflist[$ck]['yearround'] = $cv['nature'] == 1 ? $this->getYearRoundtime($hstaffmsg['hadyear'],$cv['hiredate']) : '';
  653. $cidstafflist[$ck]['first'] = $ck == 0 ? 1 : ''; // 是否第一个
  654. }
  655. $stafflist[0]['cidstafflist'] = $cidstafflist;
  656. break;
  657. }
  658. }
  659. }else{
  660. foreach($result as $k => $v){
  661. $stafflist[$k]['categoryname'] = $v['title'];
  662. $stafflist[$k]['count'] = $v['count'];
  663. $cidstafflist = $staff->getStaffByCid($v['cid']);
  664. foreach($cidstafflist as $ck => $cv){
  665. $hstaffmsg = $hstaff->getOne(array('where' => 'uid='.$cv['sid'], 'asArray' => TRUE));
  666. $cidstafflist[$ck]['yearnum'] = $hstaffmsg['yearnum'] != 0.0 ? floatval($hstaffmsg['yearnum']) : '';
  667. $cidstafflist[$ck]['addnum'] = $hstaffmsg['addnum'] != 0.0 ? floatval($hstaffmsg['addnum']) : '';
  668. $cidstafflist[$ck]['hunjianum'] = $hstaffmsg['hunjianum'] != 0.0 ? floatval($hstaffmsg['hunjianum']) : '';
  669. $cidstafflist[$ck]['chanjianum'] = $hstaffmsg['chanjianum'] != 0.0 ? floatval($hstaffmsg['chanjianum']) : '';
  670. $cidstafflist[$ck]['sangjianum'] = $hstaffmsg['sangjianum'] != 0.0 ? floatval($hstaffmsg['sangjianum']) : '';
  671. $cidstafflist[$ck]['gongjianum'] = $hstaffmsg['gongjianum'] != 0.0 ? floatval($hstaffmsg['gongjianum']) : '';
  672. $cidstafflist[$ck]['yearround'] = $cv['nature'] == 1 ? $this->getYearRoundtime($hstaffmsg['hadyear'],$cv['hiredate']) : '';
  673. $cidstafflist[$ck]['first'] = $ck == 0 ? 1 : ''; // 是否第一个
  674. }
  675. $stafflist[$k]['cidstafflist'] = $cidstafflist;
  676. }
  677. }
  678. $zongbu = $staff->getStaffByCid(12);
  679. $data['zongbu'] = $zongbu;
  680. $hstaff2 = new HStaff();
  681. $hstaffmsg2 = $hstaff2->getOne(array('select' => 'yearnum', 'where' => 'uid='.$zongbu[0]['sid'], 'asArray' => TRUE));
  682. $data['thisnum'] = floatval($hstaffmsg2['yearnum']);
  683. $data['stafflist'] = $stafflist;
  684. $data ['memu'] = 'holiday';
  685. $data ['holidaymenu'] = 'vacation';
  686. $data ['staff'] = $this->staff;
  687. $data['noindexjs'] = 'noindexjs';
  688. $this->render ( "/holiday-vacation", $data );
  689. }
  690. public function setStaffHoliday(){
  691. if(isset($_POST['uid']) && is_numeric($_POST['uid']) && isset($_POST['typeholiday']) && isset($_POST['addnum'])){
  692. Doo::loadModel('holidaystaff');
  693. $hstaff = new HStaff();
  694. $hstaffmsg = $hstaff->getOne(array('where' => 'uid='.$_POST['uid'], 'asArray' => TRUE));
  695. $hstaff->uid = $_POST['uid'];
  696. $type = '';
  697. switch($_POST['typeholiday']){
  698. case 'yearnum':
  699. $hstaff->yearnum = $hstaffmsg['yearnum']+$_POST['addnum'];
  700. $type = 15;
  701. break;
  702. case 'hunjianum':
  703. $hstaff->hunjianum = $hstaffmsg['hunjianum']+$_POST['addnum'];
  704. $type = 16;
  705. break;
  706. case 'chanjianum':
  707. $hstaff->chanjianum = $hstaffmsg['chanjianum']+$_POST['addnum'];
  708. $type = 17;
  709. break;
  710. case 'sangjianum':
  711. $hstaff->sangjianum = $hstaffmsg['sangjianum']+$_POST['addnum'];
  712. $type = 18;
  713. break;
  714. case 'gongjianum':
  715. $hstaff->gongjianum = $hstaffmsg['gongjianum']+$_POST['addnum'];
  716. $type = 19;
  717. break;
  718. }
  719. $hstaff->update();
  720. Doo::loadModel('holiday');
  721. $holiday = new Holiday();
  722. $holiday->uid = $_POST['uid'];
  723. $holiday->type = $type;
  724. $holiday->daynum = $_POST['addnum'];
  725. $holiday->status = 3;
  726. $holiday->addtime = time();
  727. $holiday->approvetime = time();
  728. $holiday->description = $_POST['description'];
  729. $holiday->insert();
  730. return '/holidayvacation';
  731. }else{
  732. exit('增加出错');
  733. }
  734. }
  735. public function getStaffCategory(){
  736. if(isset($_POST['cid']) && is_numeric($_POST['cid'])){
  737. Doo::loadModel('staff');
  738. $staff = new staff();
  739. $stafflist = $staff->getStaffByCid($_POST['cid']);
  740. Doo::loadModel('holidaystaff');
  741. $hstaff = new HStaff();
  742. $hstaffmsg = $hstaff->getOne(array('select' => 'yearnum', 'where' => 'uid='.$stafflist[0]['sid'], 'asArray' => TRUE));
  743. exit(json_encode(array('code' => 200, 'stafflist' => $stafflist, 'thisnum' => floatval($hstaffmsg['yearnum']))));
  744. }
  745. exit(json_encode(array('code' => 400)));
  746. }
  747. public function getHolidayStaff(){
  748. if(isset($_POST['uid']) && is_numeric($_POST['uid']) && isset($_POST['type'])){
  749. Doo::loadModel('holidaystaff');
  750. $hstaff = new HStaff();
  751. $staffmsg = $hstaff->getOne(array('select' => $_POST['type'], 'where' => 'uid='.$_POST['uid'], 'asArray' => TRUE));
  752. exit(json_encode(array('code' => 200, 'thisnum' => floatval($staffmsg[$_POST['type']]))));
  753. }
  754. exit(json_encode(array('code' => 400)));
  755. }
  756. private function geyDayMsg($dayjson){
  757. $holidayday = array();
  758. foreach($dayjson as $dk => $dv){
  759. $oneday = explode('_',$dv);
  760. if($oneday[1] != 0){
  761. $holidayday[$dk]['daytime'] = $oneday[0];
  762. $holidayday[$dk]['daymsg'] = $oneday[1] == 1 ? '' : ($oneday[1] == 2 ? '上午' : '下午');
  763. }
  764. }
  765. return $holidayday;
  766. }
  767. //获取某日期的月初月末时间戳
  768. private function getMonthTime($time){
  769. $starttime = strtotime(date('Y-m-01',strtotime($time)));
  770. $endtime = strtotime("+1 months", strtotime(date('Y-m-01',strtotime($time))))-1;
  771. return array('start' => $starttime, 'end' => $endtime);
  772. }
  773. //获取本年的每个月的时间戳
  774. private function getYearMonthTime($thisyear){
  775. $monthdata = array();
  776. for($i = 0; $i < 12; $i++){
  777. $j = $i+1;
  778. $j = $j < 10 ? '0'.$j : $j;
  779. $nowmonth = $thisyear.'-'.$j.'-01';
  780. $monthdata[$i]['starttime'] = strtotime($nowmonth);
  781. $monthdata[$i]['endtime'] = strtotime("+1 months", strtotime($nowmonth))-1;
  782. }
  783. return $monthdata;
  784. }
  785. //获取本年当事人的年假周期
  786. private function getYearRoundtime($hadyear,$hiredate){
  787. $month = date('m', strtotime($hiredate));
  788. $date = date('d', strtotime($hiredate));
  789. $monthday = intval($month).'月'.intval($date).'日';
  790. $year = date('Y',time());
  791. if(date('Y',(strtotime($hiredate)+(86400*365*$hadyear))) < $year){
  792. $lastyear = intval($year)-1;
  793. return intval($lastyear).'年'.$monthday.'~'.intval($year).'年'.$monthday;
  794. }else{
  795. $nextyear = intval($year)+1;
  796. return intval($year).'年'.$monthday.'~'.intval($nextyear).'年'.$monthday;
  797. }
  798. }
  799. private function checkisadmin(){
  800. Doo::loadModel('holidayadmin');
  801. $admin = new HAdmin();
  802. $adminmsg = $admin->getOne(array('where' => 'uid='.$this->staff[0]['sid'], 'asArray' => TRUE));
  803. if(!empty($adminmsg)){
  804. return TRUE;
  805. }else{
  806. return FALSE;
  807. }
  808. }
  809. }
  810. ?>