/**
* 编辑假期库
*/
public function editvacationstorageAction()
{
// 返回值数组
$result = array('success' => true, 'info' => '编辑成功');
$request = $this->getRequest()->getParams();
$now = date('Y-m-d H:i:s');
$user_session = new Zend_Session_Namespace('user');
$user_id = $user_session->user_info['user_id'];
$json = json_decode($request['json']);
$updated = $json->updated;
$storage = new Hra_Model_Vacationstorage();
if (count($updated) > 0) {
foreach ($updated as $val) {
$data = array('qty' => $val->qty, 'qty_used' => $val->qty_used, 'remark' => $val->remark, 'update_time' => $now, 'update_user' => $user_id);
$where = "id = " . $val->id;
try {
$storage->update($data, $where);
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
echo Zend_Json::encode($result);
exit;
}
}
}
echo Zend_Json::encode($result);
exit;
}
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;
}
/**
* 获取请假记录表
* @param unknown $condition
* @param string $vacation_id
* @return Ambigous <multitype:, array>|multitype:|multitype:Ambigous <number, string, multitype:, array> number
*/
public function getData($condition = array(), $vacation_id = null)
{
$state = array(0 => '未审核', 1 => '拒绝', 2 => 'HR未审核', 3 => '已批准');
$type = array(0 => '无', 1 => '事假', 2 => '年假', 3 => '病假', 4 => '婚假', 5 => '丧假', 6 => '产假和哺乳假', 7 => '陪产假', 8 => '调休', 9 => '公务外出', 10 => '计划生育假', 11 => '工伤假');
$data = array();
$sql = $this->select()->setIntegrityCheck(false)->from(array('t1' => $this->_name))->joinLeft(array('t2' => $this->_dbprefix . 'user'), "t2.id = t1.apply_user", array())->joinLeft(array('t3' => $this->_dbprefix . 'employee'), "t3.id = t2.employee_id", array('manager_id', 'number', 'employment_type', 'apply_employee_id' => 't3.id', 'apply_user_name' => new Zend_Db_Expr("concat('[', t3.number, '] ', t3.cname)")))->joinLeft(array('t4' => $this->_dbprefix . 'user'), "t4.id = t1.review_user_1", array())->joinLeft(array('t5' => $this->_dbprefix . 'employee'), "t5.id = t4.employee_id", array('review_employee_1_id' => 't5.id', 'review_user_1_name' => 't5.cname'))->joinLeft(array('t6' => $this->_dbprefix . 'user'), "t6.id = t1.create_user", array())->joinLeft(array('t7' => $this->_dbprefix . 'employee'), "t7.id = t6.employee_id", array('creater' => 't7.cname'))->joinLeft(array('t8' => $this->_dbprefix . 'user'), "t8.id = t1.agent", array())->joinLeft(array('t9' => $this->_dbprefix . 'employee'), "t9.id = t8.employee_id", array('agent_employee_id' => 't9.id', 'agent_name' => 't9.cname', 'agent_email' => 't9.email'))->joinLeft(array('t10' => $this->_dbprefix . 'employee_dept'), "t10.id = t3.dept_id", array('dept' => 't10.name'))->joinLeft(array('t11' => $this->_dbprefix . 'user'), "t11.id = t1.release_user", array())->joinLeft(array('t12' => $this->_dbprefix . 'employee'), "t12.id = t11.employee_id", array('release_user_name' => 't12.cname'))->joinLeft(array('t13' => $this->_dbprefix . 'user'), "t13.id = t1.update_user", array())->joinLeft(array('t14' => $this->_dbprefix . 'employee'), "t14.id = t13.employee_id", array('updater' => 't14.cname'))->joinLeft(array('t15' => $this->_dbprefix . 'user'), "t15.id = t1.review_user_2", array())->joinLeft(array('t16' => $this->_dbprefix . 'employee'), "t16.id = t15.employee_id", array('review_employee_2_id' => 't16.id', 'review_user_2_name' => 't16.cname'))->joinLeft(array('t17' => $this->_dbprefix . 'employee'), "t3.manager_id = t17.id", array('manager_email' => 'email'))->joinLeft(array('t18' => $this->_dbprefix . 'user'), "t17.id = t18.employee_id", array('manager_user_id' => 'id'))->order(array('t1.state', 't1.time_from desc', 't3.cname'));
if ($vacation_id) {
$sql->where("t1.id = " . $vacation_id);
$data = $this->fetchRow($sql)->toArray();
$data['type_name'] = $type[intval($data['type'])];
$data['state_info'] = $state[intval($data['state'])];
return $data;
} else {
$sql->where("t1.state != 3 or (t1.time_from >= '" . $condition['date_from'] . " 00:00:00' and t1.time_to <= '" . $condition['date_to'] . " 23:59:59')");
if ($condition['key']) {
$sql->where("t3.ename like '%" . $condition['key'] . "%' or t3.cname like '%" . $condition['key'] . "%' or t3.number like '%" . $condition['key'] . "%' or t1.remark like '%" . $condition['key'] . "%' or t1.reason like '%" . $condition['key'] . "%'");
}
if ($condition['v_type'] != '') {
$typeConArr = explode(',', $condition['v_type']);
$typeCon = "t1.type = " . $typeConArr[0];
for ($i = 1; $i < count($typeConArr); $i++) {
$typeCon .= " or t1.type = " . $typeConArr[$i];
}
$sql->where($typeCon);
}
if ($condition['state'] != '') {
$stateConArr = explode(',', $condition['state']);
$stateCon = "t1.state = " . $stateConArr[0];
for ($i = 1; $i < count($stateConArr); $i++) {
$stateCon .= " or t1.state = " . $stateConArr[$i];
}
$sql->where($stateCon);
}
$total = $this->fetchAll($sql)->count();
if ($condition['type'] != 'csv') {
$sql->limitPage($condition['page'], $condition['limit']);
}
$data = $this->fetchAll($sql)->toArray();
$storage = new Hra_Model_Vacationstorage();
for ($i = 0; $i < count($data); $i++) {
$data[$i]['time_from'] = strtotime($data[$i]['time_from']);
$data[$i]['time_to'] = strtotime($data[$i]['time_to']);
$data[$i]['create_time'] = strtotime($data[$i]['create_time']);
$data[$i]['update_time'] = strtotime($data[$i]['update_time']);
$data[$i]['release_time'] = strtotime($data[$i]['release_time']);
$data[$i]['review_time_1'] = $data[$i]['review_time_1'] != '' ? strtotime($data[$i]['review_time_1']) : null;
$data[$i]['review_time_2'] = $data[$i]['review_time_2'] != '' ? strtotime($data[$i]['review_time_2']) : null;
$data[$i]['type_name'] = $type[intval($data[$i]['type'])];
$data[$i]['state'] = intval($data[$i]['state']);
if ($data[$i]['state'] == 0) {
}
$data[$i]['state_info'] = $state[$data[$i]['state']];
// 请假类别为年假时，获取对应年份的年假总天数和已使用天数
if ($data[$i]['in_year_qty'] > 0) {
$vRes = $storage->fetchAll("number = '" . $data[$i]['number'] . "' and in_year_qty = " . $data[$i]['in_year_qty']);
$vStorage = array('qty' => 0, 'qty_used' => 0);
if ($vRes->count() > 0) {
$vStorage = $storage->fetchRow("number = '" . $data[$i]['number'] . "' and in_year_qty = " . $data[$i]['in_year_qty'])->toArray();
}
$vReviewRes = $this->fetchAll("apply_user = " . $data[$i]['apply_user']);
$data[$i]['vacation_qty'] = $vStorage['qty'];
$data[$i]['vacation_qty_used'] = $vStorage['qty_used'];
$data[$i]['vacation_qty_reviewing'] = $this->getReviewVacationQty($data[$i]['apply_user'], $data[$i]['type']);
$data[$i]['vacation_qty_left'] = $data[$i]['vacation_qty'] - $data[$i]['vacation_qty_used'] - $data[$i]['vacation_qty_reviewing'];
}
}
/* echo '<pre>';
print_r($data);
exit; */
if ($condition['type'] == 'csv') {
$data_csv = array();
$title = array('cnt' => '#', 'state_info' => '状态', 'apply_user' => '申请人', 'type_name' => '请假类别', 'time_from' => '时间从', 'time_to' => '时间至', 'reason' => '事由', 'remark' => '备注', 'agent' => '代理人', 'review_user_1' => '部门主管', 'review_time_1' => '审核时间', 'review_user_2' => '总经理', 'review_time_2' => '审核时间', 'release_user' => '发布人', 'release_time' => '发布时间', 'create_user' => '创建人', 'create_time' => '创建时间', 'update_user' => '更新人', 'update_time' => '更新时间');
array_push($data_csv, $title);
$i = 0;
foreach ($data as $d) {
$i++;
$info = array('cnt' => $i, 'state' => $d['state_info'], 'apply_user' => $d['apply_user_name'], 'type_name' => $d['type_name'], 'time_from' => date('Y-m-d H:i:s', $d['time_from']), 'time_to' => date('Y-m-d H:i:s', $d['time_to']), 'reason' => $d['reason'], 'remark' => $d['remark'], 'agent' => $d['agent_name'], 'review_user_1' => $d['review_user_1_name'], 'review_time_1' => $d['review_time_1'] != null ? date('Y-m-d H:i:s', $d['review_time_1']) : null, 'review_user_2' => $d['review_user_2_name'], 'review_time_2' => $d['review_time_2'] != null ? date('Y-m-d H:i:s', $d['review_time_2']) : null, 'release_user' => $d['release_user_name'], 'release_time' => date('Y-m-d H:i:s', $d['release_time']), 'create_user' => $d['creater'], 'create_time' => date('Y-m-d H:i:s', $d['create_time']), 'update_user' => $d['updater'], 'update_time' => date('Y-m-d H:i:s', $d['update_time']));
array_push($data_csv, $info);
}
return $data_csv;
}
return array('total' => $total, 'rows' => $data);
}
}
