/** * 根据工号获取员工剩余年假天数 * @param unknown $number * @return number */ public function getVacationQty($number) { $result = array('qty' => 0, 'qty_used' => 0, 'in_year_qty' => 0); $res = $this->fetchAll("number = '" . $number . "'", "in_year_qty desc"); if ($res->count() > 0) { $data = $res->toArray(); $result['qty_used'] = $data[0]['qty_used']; $result['qty'] = $data[0]['qty']; $result['in_year_qty'] = $data[0]['in_year_qty']; $employee = new Hra_Model_Employee(); $user_id = $employee->getUserIdByNumber($number); $vacation = new Hra_Model_Attendance_Vacation(); // 员工剩余可使用年假天数需要扣除已提交但未发布的请假申请 $vRes = $vacation->fetchAll("apply_user = "******" and type = 2 and state != 3 and state != 1"); if ($vRes->count() > 0) { $vData = $vRes->toArray(); foreach ($vData as $v) { $result['qty_used'] += $v['qty']; } } $result['qty'] -= $result['qty_used']; } /* echo '<pre>'; print_r($result); exit; */ return $result; }
public function getStatisticsList($condition = array()) { $data = array(); $employee = new Hra_Model_Employee(); $sql = $employee->select()->setIntegrityCheck(false)->from(array('t1' => $this->_dbprefix . 'employee'))->joinLeft(array('t2' => $this->_dbprefix . 'employee_dept'), "t2.id = t1.dept_id", array('dept_name' => 'name'))->joinLeft(array('t3' => $this->_dbprefix . 'employee_post'), "t3.id = t1.post_id", array('post_name' => 'name'))->joinLeft(array('t4' => $this->_dbprefix . 'user'), "t4.employee_id = t1.id", array('user_id' => 'id'))->joinLeft(array('t5' => $this->_dbprefix . 'employee_type'), "t1.employment_type = t5.id", array('employment_type' => 'name'))->where("(t1.leave_date is null or (t1.leave_date is not null and t1.leave_date >= '" . $condition['date_from'] . "' and t1.leave_date <= '" . $condition['date_to'] . "'))")->order(array("t1.employment_type", "t1.number")); if ($condition['employment_type'] != '') { $sql->where("employment_type = " . $condition['employment_type']); } if ($condition['key']) { $sql->where("t1.ename like '" . $condition['key'] . "' or t1.cname like '" . $condition['key'] . "' or t1.number like '" . $condition['key'] . "'"); } $total = $employee->fetchAll($sql)->count(); if ($condition['type'] != 'csv') { $sql->limitPage($condition['page'], $condition['limit']); } $data = $employee->fetchAll($sql)->toArray(); $workday = new Hra_Model_Workday(); $vacation = new Hra_Model_Attendance_Vacation(); $overtime = new Hra_Model_Attendance_Overtime(); // 员工工作日设置(目前均按弹性员工工作日设置处理) $workdaySetting = $workday->getDayQtyBase(1, 1, $condition['date_from'], $condition['date_to']); $holidaySetting = $workday->getDayQtyBase(3, 1, $condition['date_from'], $condition['date_to']); for ($i = 0; $i < count($data); $i++) { $data[$i]['workday_qty'] = $workdaySetting['day']; $data[$i]['workhour_qty'] = $workdaySetting['hour']; $data[$i]['holiday_qty'] = $holidaySetting['day']; $data[$i]['attendance_qty'] = null; $data[$i]['attendance_hour_qty'] = 0; $data[$i]['v_personal_qty'] = null; $data[$i]['v_vacation_qty'] = null; $data[$i]['v_sick_qty'] = null; $data[$i]['v_marriage_qty'] = null; $data[$i]['v_funeral_qty'] = null; $data[$i]['v_childbirth_qty'] = null; $data[$i]['v_childbirth_with_qty'] = null; $data[$i]['v_other_qty'] = null; $data[$i]['o_workday_qty'] = null; $data[$i]['o_restday_qty'] = null; $data[$i]['o_holiday_qty'] = null; $data[$i]['late_qty'] = null; $data[$i]['leave_early_qty'] = null; $data[$i]['absence_halfday_qty'] = null; $data[$i]['absence_qty'] = null; if ($data[$i]['user_id']) { // 出勤天数 $sql = $this->select()->from($this->_name)->where("number = '" . $data[$i]['number'] . "' and clock_in >= '" . $condition['date_from'] . " 00:00:00' and clock_out <= '" . $condition['date_to'] . " 23:59:59'")->group("date_format(clock_in, '%Y-%m-%d')"); $aData = $this->fetchAll($sql)->toArray(); foreach ($aData as $a) { $data[$i]['attendance_hour_qty'] += $a['clock_hours']; } $data[$i]['attendance_qty'] = count($aData); // 请假天数 $data[$i]['v_personal_qty'] = $vacation->getVacationQty($data[$i]['user_id'], 1, $condition['date_from'], $condition['date_to']); $data[$i]['v_vacation_qty'] = $vacation->getVacationQty($data[$i]['user_id'], 2, $condition['date_from'], $condition['date_to']); $data[$i]['v_sick_qty'] = $vacation->getVacationQty($data[$i]['user_id'], 3, $condition['date_from'], $condition['date_to']); $data[$i]['v_marriage_qty'] = $vacation->getVacationQty($data[$i]['user_id'], 4, $condition['date_from'], $condition['date_to']); $data[$i]['v_funeral_qty'] = $vacation->getVacationQty($data[$i]['user_id'], 5, $condition['date_from'], $condition['date_to']); $data[$i]['v_childbirth_qty'] = $vacation->getVacationQty($data[$i]['user_id'], 6, $condition['date_from'], $condition['date_to']); $data[$i]['v_childbirth_with_qty'] = $vacation->getVacationQty($data[$i]['user_id'], 7, $condition['date_from'], $condition['date_to']); $data[$i]['v_other_qty'] = $vacation->getVacationQty($data[$i]['user_id'], 8, $condition['date_from'], $condition['date_to']); // 加班天数 $data[$i]['o_workday_qty'] = $overtime->getOvertimeQty($data[$i]['user_id'], 1, $condition['date_from'], $condition['date_to']); $data[$i]['o_restday_qty'] = $overtime->getOvertimeQty($data[$i]['user_id'], 2, $condition['date_from'], $condition['date_to']); $data[$i]['o_holiday_qty'] = $overtime->getOvertimeQty($data[$i]['user_id'], 3, $condition['date_from'], $condition['date_to']); //其它统计(迟到、早退、旷工次数) $other = $this->getAbsenceQty($data[$i]['number'], $condition['date_from'], $condition['date_to']); $data[$i]['late_qty'] = $other[1]; $data[$i]['leave_early_qty'] = $other[2]; $data[$i]['absence_halfday_qty'] = $other[3]; $data[$i]['absence_qty'] = $other[4]; } } if ($condition['type'] == 'csv') { $data_csv = array(); $title = array('cnt' => '#', 'employment_type' => '用工形式', 'number' => '工号', 'cname' => '中文名', 'ename' => '英文名', 'dept_name' => '部门', 'post_name' => '职位', 'active' => '状态', 'attendance' => '出勤/考勤 [天]', 'holiday_qty' => '法定假日', 'v_personal_qty' => '事假', 'v_vacation_qty' => '年假', 'v_sick_qty' => '病假', 'v_marriage_qty' => '婚假', 'v_funeral_qty' => '丧假', 'v_childbirth_qty' => '产假', 'v_childbirth_with_qty' => '陪产假', 'v_other_qty' => '调休', 'o_workday_qty' => '工作日加班', 'o_restday_qty' => '休息日加班', 'o_holiday_qty' => '法定假日加班', 'late_qty' => '迟到', 'leave_early_qty' => '早退', 'absence_halfday_qty' => '旷工半天', 'absence_qty' => '旷工一天'); array_push($data_csv, $title); $i = 0; foreach ($data as $d) { $i++; $info = array('cnt' => $i, 'employment_type' => $d['employment_type'] == 0 ? '弹性' : '非弹性', 'number' => $d['number'], 'cname' => $d['cname'], 'ename' => $d['ename'], 'dept_name' => $d['dept_name'], 'post_name' => $d['post_name'], 'active' => $d['active'] == 1 ? '在职' : '离职', 'attendance' => $d['workday_qty'] . ' { ' . $d['attendance_qty'] . ' }', 'attendance_hours' => $d['workhour_qty'] . ' { ' . $d['attendance_hour_qty'] . ' }', 'holiday_qty' => $d['holiday_qty'], 'v_personal_qty' => $d['v_personal_qty'], 'v_vacation_qty' => $d['v_vacation_qty'], 'v_sick_qty' => $d['v_sick_qty'], 'v_marriage_qty' => $d['v_marriage_qty'], 'v_funeral_qty' => $d['v_funeral_qty'], 'v_childbirth_qty' => $d['v_childbirth_qty'], 'v_childbirth_with_qty' => $d['v_childbirth_with_qty'], 'v_other_qty' => $d['v_other_qty'], 'o_workday_qty' => $d['o_workday_qty'], 'o_restday_qty' => $d['o_restday_qty'], 'o_holiday_qty' => $d['o_holiday_qty'], 'late_qty' => $d['late_qty'], 'leave_early_qty' => $d['leave_early_qty'], 'absence_halfday_qty' => $d['absence_halfday_qty'], 'absence_qty' => $d['absence_qty']); array_push($data_csv, $info); } return $data_csv; } return array('total' => $total, 'rows' => $data); }
public function vacationAction() { // 返回值数组 $result = array('success' => true, 'info' => '提交成功'); // 请求参数 $request = $this->getRequest()->getParams(); // 操作类型 $operate = array('new' => '新建', 'edit' => '编辑', 'delete' => '删除'); // 操作类别(新建、更新、删除) $operate_type = isset($request['operate']) ? $request['operate'] : ''; $vacation = new Hra_Model_Attendance_Vacation(); if ($operate_type == 'new_hra' || $operate_type == 'new' || $operate_type == 'edit') { $time_from = str_replace('T', ' ', $request['time_from']); $time_to = str_replace('T', ' ', $request['time_to']); if (date('Y-m', strtotime($time_from)) != date('Y-m', strtotime($time_to))) { $result['success'] = false; $request['info'] = '不允许跨月申请,请重新填写时间!'; echo Zend_Json::encode($result); exit; } // 获取请假人员的用工形式(0:弹性,1:非弹性) $user = new Application_Model_User(); $userInfo = $user->getEmployeeInfoById($request['apply_user']); $userType = $userInfo['employment_type']; $workday = new Hra_Model_Workday(); // 获取请假区间包含的工作日天数 $vacationInfo = $workday->getWorkdayQtyByTimeRange($userType, $request['time_from'], $request['time_to']); $vacationQty = $vacationInfo['qty']; $vacationQty_hours = $vacationInfo['qty_hours']; // 当编辑请假申请时,检查时间是否重叠需要过滤当前请假申请ID $filter_id = null; if ($operate_type == 'edit') { $filter_id = $request['id']; } // 检查请假时间范围是否包含工作日 if ($vacationQty > 0) { $overtimeQty = 0; if ($request['exchange_overtime_ids'] != '') { $overtimeQty = $this->getOvertimeQty(explode(',', $request['exchange_overtime_ids'])); } $vStorage = new Hra_Model_Vacationstorage(); //获取员工最近一年的剩余年假以及对于入司年数 $vStorageQty = $vStorage->getVacationQty($userInfo['number']); if (round($vStorageQty['qty'], 1) == round($vacationQty, 1)) { $vacationQty = $vStorageQty['qty']; } // 检查请假时间范围是否跟已有申请(包括已审核和审核中的申请)重叠 if ($vacation->checkTimeOverlap($request['apply_user'], $request['time_from'], $request['time_to'], $filter_id)) { $result['success'] = false; $result['info'] = '时间设置错误,请假时间重叠,请优先处理未审申请。'; } else { if ($request['type'] == 2 && round($vStorageQty['qty'], 1) < round($vacationQty, 1)) { // 当员工请假类别为年假时,检查年假剩余天数是否充足 $result['success'] = false; $result['info'] = '时间设置错误,剩余年假天数不足。'; } else { if ($request['type'] == 8 && round($overtimeQty, 1) < round($vacationQty, 1)) { // 当员工请假类别为调休时,检查调休可用天数是否充足 $result['success'] = false; $result['info'] = '时间设置错误,剩余可用加班天数不足。'; } else { $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user_id = $user_session->user_info['user_id']; // 当前申请为代申请时,获取申请人真实部门主管 if ($request['apply_user'] != $user_id) { // 获取部门主管 $manager = $user->getManagerUser($request['apply_user']); $request['review_user_1'] = $manager[0]['id']; } if ($request['review_user_1'] >= 0) { // 当员工请假类别是“年假”时,记录员工可用年假对应的入司年数(均以最近一年的年假对应入司年数为准) $in_year_qty = $request['type'] == 2 ? $vStorageQty['in_year_qty'] : null; $data = array('type' => $request['type'], 'in_year_qty' => $in_year_qty, 'qty' => $vacationQty, 'qty_hours' => $vacationQty_hours, 'apply_user' => $request['apply_user'], 'review_user_1' => $request['review_user_1'], 'time_from' => $request['time_from'], 'time_to' => $request['time_to'], 'reason' => $request['reason'], 'work' => $request['work'], 'remark' => $request['remark'], 'exchange_overtime_ids' => $request['exchange_overtime_ids'], 'agent' => $request['agent'], 'update_time' => $now, 'update_user' => $user_id); /* echo '<pre>'; print_r($data); exit; */ $vacation_id = 0; if ($operate_type == 'new_hra') { // HRA手动添加 $data['state'] = 3; $data['create_time'] = $now; $data['create_user'] = $user_id; $data['review_info'] = $now . ': ' . $user_session->user_info['user_name'] . ' [手动添加]'; try { $vacation_id = $vacation->insert($data); echo Zend_Json::encode($result); exit; } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } else { if ($operate_type == 'new') { $data['create_time'] = $now; $data['create_user'] = $user_id; $data['review_info'] = $now . ': ' . $user_session->user_info['user_name'] . ' [新建]'; try { $vacation_id = $vacation->insert($data); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } else { $vacation_id = $request['id']; $review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [修改]'; $vacationData = $vacation->getData(null, $vacation_id); $data['review_info'] = $vacationData['review_info'] . '<br>' . $review_info; $data['state'] = 0; $data['review_time_1'] = null; //$data['review_time_2'] = null; $data['release_time'] = null; try { $vacation->update($data, "id = " . $vacation_id); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } } if ($request['type'] == 8) { $overtime = new Hra_Model_Attendance_Overtime(); $overtime_id_arr = explode(',', $request['exchange_overtime_ids']); foreach ($overtime_id_arr as $overtime_id) { $overtime->update(array('exchange' => 1, 'exchange_vacation_id' => $vacation_id), "id = " . $overtime_id); } } if ($vacation_id > 0) { $vacationData = $vacation->getData(null, $vacation_id); $review = new Dcc_Model_Review(); $user = new Application_Model_User(); $help = new Application_Model_Helpers(); // 记录审核日志:审核人1 $apply_user_info = $user->getEmployeeInfoById($request['apply_user']); $review_user_1_info = $user->getEmployeeInfoById($request['review_user_1']); //$agent_info = $user->getEmployeeInfoById($request['agent']); $reviewData = array('type' => 'attendance_vacation', 'file_id' => $vacation_id, 'step_name' => '审核人1', 'plan_user' => $vacationData['review_employee_1_id'], 'method' => 1, 'return' => 1); $review->insert($reviewData); // 如果存在审核人2记录审核日志:审核人2 /* if($request['review_user_2']){ $review_user_2_info = $user->getEmployeeInfoById($request['review_user_2']); $reviewData = array( 'type' => 'attendance_vacation', 'file_id' => $vacation_id, 'step_name' => '审核人2', 'plan_user' => $vacationData['review_employee_2_id'], 'method' => 1, 'return' => 1 ); $review->insert($reviewData); } */ // 记录审核日志:人事主管 $member = new Admin_Model_Member(); $hraAdminUserArr = $member->getMemberWithNoManagerByName('人事主管'); $hraEmployeeIdArr = array(); foreach ($hraAdminUserArr as $hra) { $hra_info = $user->getEmployeeInfoById($hra['user_id']); array_push($hraEmployeeIdArr, $hra_info['id']); } $hraIds = implode(',', $hraEmployeeIdArr); $reviewData = array('type' => 'attendance_vacation', 'file_id' => $vacation_id, 'step_name' => '人事审核', 'plan_user' => $hraIds, 'method' => 1, 'return' => 1); $review->insert($reviewData); // 向审核人1发送邮件 $mailContent = '<div>你有一个新的请假申请等待审核,请登录系统查看:</div> <div> <p><b>申请人:</b><a style="color:#008B00;font-weight: bold;">' . $vacationData['apply_user_name'] . '</a></p> <p><b>请假类别:</b><a style="color:#008B00;font-weight: bold;">' . $vacationData['type_name'] . '</a></p> <p><b>请假时间:</b><a style="color:#008B00;font-weight: bold;">' . $vacationData['time_from'] . '</a> 至 <a style="color:#008B00;font-weight: bold;">' . $vacationData['time_to'] . '</a></p> <p><b>代理人:</b>' . $vacationData['agent_name'] . '</p> <p><b>事由:</b>' . $vacationData['reason'] . '</p> <p><b>工作交接:</b>' . $vacationData['work'] . '</p> <p><b>备注:</b>' . $vacationData['remark'] . '</p> <p><b>创建人:</b>' . $vacationData['creater'] . '</p> <p><b>申请时间:</b>' . $vacationData['create_time'] . '</p> <hr> <p><b>审核日志:</b></p><p>' . $data['review_info'] . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '请假申请-新申请', 'cc' => $user_session->user_info['user_email'], 'content' => $mailContent, 'add_date' => $now); $result = $help->sendMailToStep(array($review_user_1_info['id']), $mailData); } else { $result['success'] = false; $result['info'] = '保存错误,请确认填写内容是否正确。'; } } else { $result['success'] = false; $result['info'] = '申请失败,当前申请人没有设置部门主管。'; } } } } } else { $result['success'] = false; $result['info'] = '时间设置错误,请确认时间范围包含工作日。'; } } else { if ($operate_type == 'delete') { if (isset($request['id']) && count(Zend_Json::decode($request['id'])) > 0) { $ids = Zend_Json::decode($request['id']); // 多条申请逐条删除 foreach ($ids as $id) { try { $review = new Dcc_Model_Review(); // 删除审核日志 $review->delete("type = 'attendance_vacation' and file_id = " . $id); $vacation->delete("id = " . $id); $overtime = new Hra_Model_Attendance_Overtime(); $overtime->update(array('exchange' => 0, 'exchange_vacation_id' => 0), "exchange_vacation_id = " . $id); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } } else { $result['success'] = false; $result['info'] = '参数错误,没有删除对象。'; } } else { $result['success'] = false; $result['info'] = '参数错误,没有操作类别。'; } } echo Zend_Json::encode($result); exit; }