public function resetpwdAction()
{
// 返回值数组
$result = array('success' => true, 'info' => '密码重置成功！（初始密码：123456）');
$request = $this->getRequest()->getParams();
$user_id = isset($request['id']) ? $request['id'] : null;
if ($user_id) {
$user = new Application_Model_User();
$employeeInfo = $user->getEmployeeInfoById($user_id);
$pwd = md5($employeeInfo['number'] . '123456');
try {
$user->update(array('password' => $pwd), "id = " . $user_id);
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
echo Zend_Json::encode($result);
exit;
}
} else {
$result['success'] = false;
$result['info'] = '用户ID不能为空！';
}
echo Zend_Json::encode($result);
exit;
}
public function editpwdAction()
{
// 返回值数组
$result = array('success' => true, 'info' => '修改密码成功');
$user_session = new Zend_Session_Namespace('user');
$user_id = $user_session->user_info['user_id'];
$request = $this->getRequest()->getParams();
$pwd0 = isset($request['pwd0']) ? $request['pwd0'] : null;
$pwd1 = isset($request['pwd1']) ? $request['pwd1'] : null;
$pwd2 = isset($request['pwd2']) ? $request['pwd2'] : null;
if ($pwd0 && $pwd1 && $pwd2) {
$user = new Application_Model_User();
if ($user->checkUserPwdById($user_id, $pwd0)) {
$employeeInfo = $user->getEmployeeInfoById($user_id);
$pwd = md5($employeeInfo['number'] . $pwd1);
try {
$user->update(array('password' => $pwd), "id = " . $user_id);
$computer_name = gethostbyaddr(getenv("REMOTE_ADDR"));
// 计算机名
$now = date('Y-m-d H:i:s');
$data = array('operate' => '修改密码', 'target' => 'UserAccount', 'computer_name' => $computer_name, 'ip' => $_SERVER['REMOTE_ADDR'], 'time' => $now);
$operate = new Application_Model_Log_Operate();
try {
$operate->insert($data);
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
echo Zend_Json::encode($result);
exit;
}
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
echo Zend_Json::encode($result);
exit;
}
} else {
$result['success'] = false;
$result['info'] = '旧密码输入错误！';
}
} else {
$result['success'] = false;
$result['info'] = '新、旧密码不能为空！';
}
echo Zend_Json::encode($result);
exit;
}
public function getReviewUserInfo($type, $file_id)
{
$reviewerInfo = array();
$sql = $this->select()->from($this, array('plan_user' => new Zend_Db_Expr("GROUP_CONCAT(plan_user SEPARATOR ',')")))->where("type = '" . $type . "' and file_id = " . $file_id)->group("file_id");
if ($this->fetchAll($sql)->count() > 0) {
$data = $this->fetchRow($sql)->toArray();
$reviewers = array_unique(explode(',', $data['plan_user']));
$user = new Application_Model_User();
foreach ($reviewers as $r) {
$userData = $user->fetchRow("employee_id = " . $r)->toArray();
$user_id = $userData['id'];
$userInfo = $user->getEmployeeInfoById($user_id);
$user_email = $userInfo['email'];
array_push($reviewerInfo, array('user_id' => $user_id, 'email' => $user_email));
}
}
return $reviewerInfo;
}
public function getConflictMembers($time_from, $time_to, $members, $id = null)
{
$conflictMembers = array();
$membersArr = explode(',', $members);
$cond = "state = 0\n and ((time_from >= '" . $time_from . "' and time_from <= '" . $time_to . "')\n or (time_to >= '" . $time_from . "' and time_to <= '" . $time_to . "')\n or (time_from >= '" . $time_from . "' and time_to <= '" . $time_to . "'))";
if ($id) {
$cond .= " and id != " . $id;
}
$res = $this->fetchAll($cond);
if ($res->count() > 0) {
$user = new Application_Model_User();
$data = $res->toArray();
foreach ($data as $d) {
$membersAddedArr = explode(',', $d['members']);
foreach ($membersAddedArr as $m) {
if (in_array($m, $membersArr) && !in_array($m, $conflictMembers)) {
$memberInfo = $user->getEmployeeInfoById($m);
array_push($conflictMembers, $memberInfo['cname'] . ': ' . $d['time_from'] . ' - ' . $d['time_to']);
}
}
}
}
return $conflictMembers;
}
public function newAction()
{
$result = array('success' => true, 'info' => '提交成功');
$request = $this->getRequest()->getParams();
$operate = isset($request['operate']) && $request['operate'] != '' ? $request['operate'] : null;
$id = isset($request['id']) && $request['id'] != '' ? $request['id'] : null;
$moderator = isset($request['moderator']) && $request['moderator'] != '' ? $request['moderator'] : null;
$subject = isset($request['subject']) && $request['subject'] != '' ? $request['subject'] : null;
$room_id = isset($request['room_id']) && $request['room_id'] != '' ? $request['room_id'] : null;
$time_from = isset($request['time_from']) && $request['time_from'] != '' ? $request['time_from'] : null;
$time_to = isset($request['time_to']) && $request['time_to'] != '' ? $request['time_to'] : null;
$members = isset($request['members_id']) && $request['members_id'] != '' ? $request['members_id'] : null;
$remark = isset($request['remark']) && $request['remark'] != '' ? $request['remark'] : null;
if ($subject && $members && $operate && $moderator && $time_from && $time_to) {
$meeting = new Res_Model_Meeting();
$user = new Application_Model_User();
if ($meeting->checkMeetingConflict($room_id, $time_from, $time_to, $id)) {
$result['success'] = false;
$result['info'] = '会议室预定冲突，请重新选择会议室！';
} else {
// 检查成员会议时间冲突
$membersAdded = $meeting->getConflictMembers($time_from, $time_to, $members, $id);
if (count($membersAdded) > 0) {
$result['success'] = false;
$result['info'] = '会议时间冲突！<br>' . implode('<br>', $membersAdded);
} else {
$now = date('Y-m-d H:i:s');
$user_session = new Zend_Session_Namespace('user');
$user_id = $user_session->user_info['user_id'];
$membersArr = explode(',', $members);
$membersCnameArr = array();
$membersEnameArr = array();
foreach ($membersArr as $m) {
$memberInfo = $user->getEmployeeInfoById($m);
array_push($membersCnameArr, $memberInfo['cname']);
array_push($membersEnameArr, $memberInfo['ename']);
}
$data = array('state' => 0, 'room_id' => $room_id, 'subject' => $subject, 'moderator' => $moderator, 'time_from' => $time_from, 'time_to' => $time_to, 'members' => $members, 'members_cname' => implode(',', $membersCnameArr), 'members_ename' => implode(',', $membersEnameArr), 'remark' => $remark, 'update_user' => $user_id, 'update_time' => $now);
if ($operate == 'edit') {
$type = '更新';
$meeting->update($data, "id = " . $id);
} else {
$type = '新建';
$data['number'] = $meeting->getNewNum();
$data['create_user'] = $user_id;
$data['create_time'] = $now;
$id = $meeting->insert($data);
}
$meetingData = $meeting->getData(null, $id);
$mail = new Application_Model_Log_Mail();
$moderatorInfo = $user->getEmployeeInfoById($moderator);
$mailContent = '<div>会议预定 - ' . $type . '：</div>
<div>
<p><b>预订人：</b>' . $meetingData['updater'] . '</p>
<p><b>会议室：</b>' . $meetingData['room_name'] . '</p>
<p><b>主题：</b>' . $meetingData['subject'] . '</p>
<p><b>时间：</b>' . $meetingData['time_from'] . ' - ' . $meetingData['time_to'] . '</p>
<p><b>主持人：</b>' . $moderatorInfo['cname'] . '</p>
<p><b>参会人员：</b>' . $meetingData['members_cname'] . '</p>
<p><b>备注：</b>' . $meetingData['remark'] . '</p>
</div>';
$memberArr = explode(',', $meetingData['members']);
array_push($memberArr, $moderator);
$toArr = array();
foreach ($memberArr as $m) {
$memberInfo = $user->getEmployeeInfoById($m);
$memberInfo = $user->getEmployeeInfoById($m);
array_push($toArr, $memberInfo['email']);
}
$mailData = array('type' => '消息', 'subject' => '会议预定', 'to' => implode(',', $toArr), 'cc' => $user_session->user_info['user_email'], 'user_id' => $meetingData['create_user'], 'content' => $mailContent, 'add_date' => $now);
try {
// 记录邮件日志并发送邮件
$mail->insert($mailData);
$mail->send($mail->insert($mailData));
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
}
}
}
} else {
$result['success'] = false;
$result['info'] = '参数错误';
}
echo Zend_Json::encode($result);
exit;
}
public function reviewAction()
{
// 返回值数组
$result = array('success' => true, 'info' => '审核成功');
$request = $this->getRequest()->getParams();
$review_id = isset($request['review_id']) ? $request['review_id'] : null;
//$review_type_id = isset($request['review_type_id']) ? $request['review_type_id'] : null;
$review_operate = isset($request['review_operate']) ? $request['review_operate'] : null;
$review_current_step = isset($request['review_current_step']) ? $request['review_current_step'] : null;
// 当前阶段（review表ID）
$review_last_step = isset($request['review_last_step']) ? $request['review_last_step'] : null;
// 是否当前阶段为最后一阶段
$review_to_finish = isset($request['review_to_finish']) ? $request['review_to_finish'] : null;
// 是否批准后当前阶段结束
$review_next_step = isset($request['review_next_step']) ? $request['review_next_step'] : null;
// 下一阶段（review表ID）
$review_remark = isset($request['review_remark']) ? $request['review_remark'] : null;
$review_transfer_user = isset($request['review_transfer_user']) ? $request['review_transfer_user'] : null;
//转审人
$review_transfer = $request['review_transfer'] == 1 ? true : false;
if ($review_id && $review_operate) {
$transfer = new Erp_Model_Purchse_Transfer();
$now = date('Y-m-d H:i:s');
$user_session = new Zend_Session_Namespace('user');
$user_id = $user_session->user_info['user_id'];
$employee_id = $user_session->user_info['employee_id'];
// 评审意见
$review_info = '意见: ' . $review_remark;
$req = new Erp_Model_Purchse_Req();
$user = new Application_Model_User();
$review = new Dcc_Model_Review();
$employee = new Hra_Model_Employee();
$reqData = $req->getData(null, $review_id);
// 更新审核状态及审核意见
if ($review_operate == 'transfer') {
// 转审
$review_info = $reqData['review_info'] . '<br>' . $now . ': ' . $user_session->user_info['user_name'] . ' [审核-转审] [' . $review_info . ']';
$req->update(array('review_info' => $review_info), "id = " . $review_id);
$reviewState = $review->fetchRow("type = 'purchse_req_add' and finish_flg = 0 and file_id = " . $review_id, "id")->toArray();
// 转审对象
$transferUserInfo = $user->getEmployeeInfoById($review_transfer_user);
$reviewUsers = $reviewState['plan_user'];
$reviewUserArr = explode(',', $reviewUsers);
$reviewer = array();
if ($reviewState['method'] == 2) {
// 任意： 直接替换审核人为转审对象
foreach ($reviewUserArr as $review_user) {
if ($review_user == $employee_id) {
array_push($reviewer, $transferUserInfo['id']);
}
}
} else {
// 全部： 替换当前审核人为转审对象，其余审核人保留
foreach ($reviewUserArr as $review_user) {
if ($review_user == $employee_id) {
array_push($reviewer, $transferUserInfo['id']);
} else {
if (!in_array($review_user, $reviewer)) {
array_push($reviewer, $review_user);
}
}
}
}
$reviewerstr = implode(',', $reviewer);
$review->update(array('plan_user' => $reviewerstr), "id = " . $reviewState['id']);
// 发送邮件通知制单人
$reviewResult = '<font style="color: #FF0000"><b>转审</b></font>';
$mail = new Application_Model_Log_Mail();
$to = $transferUserInfo['email'];
$mailContent = '<div>采购申请审核：</div>
<div>
<p><b>审核人：</b>' . $user_session->user_info['user_name'] . '</p>
<p><b>审核结果：</b>' . $reviewResult . '</p>
<p><b>审核意见：</b>' . $review_remark . '</p>
<p><b>申请单号：</b>' . $reqData['number'] . '</p>
<p><b>申请部门：</b>' . $reqData['dept'] . '</p>
<p><b>申请人：</b>' . $reqData['apply_user_name'] . '</p>
<p><b>制单人：</b>' . $reqData['creater'] . '</p>
<p><b>类别：</b>' . $reqData['type'] . '</p>
<p><b>事由：</b>' . $reqData['reason'] . '</p>
<p><b>金额：</b><a style="color: #467500;font-weight: bold;">￥' . round($reqData['total'], 2) . '</a></p>
<p><b>备注：</b>' . $reqData['remark'] . '</p>
<p><b>制单时间：</b>' . $reqData['create_time'] . '</p>
<p><b>更新时间：</b>' . $reqData['update_time'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $reqData['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '采购申请-转审', 'to' => $to, 'cc' => $user_session->user_info['user_email'], 'user_id' => $user_session->user_info['user_id'], 'content' => $mailContent, 'add_date' => $now);
try {
// 记录邮件日志并发送邮件
$mail->send($mail->insert($mailData));
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
}
} else {
if ($review_operate == 'no') {
// 更新采购申请状态
$review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [审核-拒绝] [' . $review_info . ']';
$data = array('state' => 1, 'transfer_description' => null, 'review_info' => $reqData['review_info'] . '<br>' . $review_info);
$req->update($data, "id = " . $review_id);
if ($review_transfer) {
$transfer->update(array('state' => 1), "id = " . $reqData['transfer_id']);
}
// 删除当前申请的审核配置
$review->delete("type = 'purchse_req_add' and file_id = " . $review_id);
// 发送邮件通知制单人
$reviewResult = '<font style="color: #FF0000"><b>拒绝</b></font>';
$mail = new Application_Model_Log_Mail();
$applyEmployeeData = $user->fetchRow("id = " . $reqData['create_user'])->toArray();
$applyEmployee = $employee->fetchRow("id = " . $applyEmployeeData['employee_id'])->toArray();
$to = $applyEmployee['email'];
$mailContent = '<div>采购申请审核：</div>
<div>
<p><b>审核人：</b>' . $user_session->user_info['user_name'] . '</p>
<p><b>审核结果：</b>' . $reviewResult . '</p>
<p><b>审核意见：</b>' . $review_remark . '</p>
<p><b>申请单号：</b>' . $reqData['number'] . '</p>
<p><b>申请部门：</b>' . $reqData['dept'] . '</p>
<p><b>申请人：</b>' . $reqData['apply_user_name'] . '</p>
<p><b>制单人：</b>' . $reqData['creater'] . '</p>
<p><b>类别：</b>' . $reqData['type'] . '</p>
<p><b>事由：</b>' . $reqData['reason'] . '</p>
<p><b>金额：</b><a style="color: #467500;font-weight: bold;">￥' . round($reqData['total'], 2) . '</a></p>
<p><b>备注：</b>' . $reqData['remark'] . '</p>
<p><b>制单时间：</b>' . $reqData['create_time'] . '</p>
<p><b>更新时间：</b>' . $reqData['update_time'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $reqData['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '采购申请-审核', 'to' => $to, 'cc' => $user_session->user_info['user_email'], 'user_id' => $reqData['create_user'], 'content' => $mailContent, 'add_date' => $now);
try {
// 记录邮件日志并发送邮件
$mail->send($mail->insert($mailData));
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
}
} else {
$help = new Application_Model_Helpers();
$review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [审核-批准] [' . $review_info . ']';
$reqUpdateData = array('review_info' => $reqData['review_info'] . '<br>' . $review_info);
$reviewData = $review->fetchRow("id = " . $review_current_step)->toArray();
$actual_user = $reviewData['actual_user'] == '' ? $user_session->user_info['employee_id'] : $reviewData['actual_user'] . ',' . $user_session->user_info['employee_id'];
$data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1);
// 当前审核阶段为最后一阶段
if ($review_last_step == 1) {
// 当前阶段已完结
if ($review_to_finish == 1) {
if ($review_transfer) {
if ($reqData['transfer_type'] == '取消') {
$this->cancelReq($review_id);
} else {
$this->approveTransferUpdateItems($reqData['transfer_id']);
}
$transfer->update(array('state' => 2), "id = " . $reqData['transfer_id']);
}
$data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1);
$reviewResult = '<font style="color: #006400"><b>发布</b></font>';
// 发布
// 更新申请状态
$reqUpdateData['state'] = 2;
$reqUpdateData['transfer_description'] = null;
$reqUpdateData['release_time'] = $now;
// 更新审核记录表
$review->update($data, "id = " . $review_current_step);
$mail = new Application_Model_Log_Mail();
$applyEmployeeData = $user->fetchRow("id = " . $reqData['create_user'])->toArray();
$applyEmployee = $employee->fetchRow("id = " . $applyEmployeeData['employee_id'])->toArray();
$to = $applyEmployee['email'];
$cc = $user_session->user_info['user_email'];
// 发布通知采购员
$buyer = new Erp_Model_Purchse_Buyer();
$buyerData = $buyer->getData();
foreach ($buyerData as $b) {
$cc .= ',' . $b['email'];
}
$mailContent = '<div>采购申请审核批准，请登录系统查看：</div>
<div>
<p><b>审核人：</b>' . $user_session->user_info['user_name'] . '</p>
<p><b>审核结果：</b>' . $reviewResult . '</p>
<p><b>审核意见：</b>' . $review_remark . '</p>
<p><b>申请单号：</b>' . $reqData['number'] . '</p>
<p><b>申请部门：</b>' . $reqData['dept'] . '</p>
<p><b>申请人：</b>' . $reqData['apply_user_name'] . '</p>
<p><b>制单人：</b>' . $reqData['creater'] . '</p>
<p><b>类别：</b>' . $reqData['type'] . '</p>
<p><b>事由：</b>' . $reqData['reason'] . '</p>
<p><b>金额：</b><a style="color: #467500;font-weight: bold;">￥' . round($reqData['total'], 2) . '</a></p>
<p><b>备注：</b>' . $reqData['remark'] . '</p>
<p><b>制单时间：</b>' . $reqData['create_time'] . '</p>
<p><b>更新时间：</b>' . $reqData['update_time'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $reqUpdateData['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '采购申请-发布', 'to' => $to, 'cc' => $cc, 'user_id' => $reqData['create_user'], 'content' => $mailContent, 'add_date' => $now);
try {
// 记录邮件日志并发送邮件
$mail->send($mail->insert($mailData));
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
}
} else {
$data = array('actual_user' => $actual_user);
$review->update($data, "id = " . $review_current_step);
// 等待其他审核人批准
}
} else {
// 当前阶段已完结
if ($review_to_finish == 1) {
$data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1);
$reviewResult = '<font style="color: #006400"><b>批准</b></font>';
// 进入下一阶段
// 更新审核记录表
$review->update($data, "id = " . $review_current_step);
// 邮件通知下一阶段审核人
$reviewNextStepData = $review->fetchRow("id = " . $review_next_step)->toArray();
$mailTo = explode(',', $reviewNextStepData['plan_user']);
if ($mailTo) {
$mailContent = '<div>新建采购申请，请登录系统查看：</div>
<div>
<p><b>申请单号：</b>' . $reqData['number'] . '</p>
<p><b>申请部门：</b>' . $reqData['dept'] . '</p>
<p><b>申请人：</b>' . $reqData['apply_user_name'] . '</p>
<p><b>制单人：</b>' . $reqData['creater'] . '</p>
<p><b>类别：</b>' . $reqData['type'] . '</p>
<p><b>事由：</b>' . $reqData['reason'] . '</p>
<p><b>金额：</b><a style="color: #467500;font-weight: bold;">￥' . round($reqData['total'], 2) . '</a></p>
<p><b>备注：</b>' . $reqData['remark'] . '</p>
<p><b>制单时间：</b>' . $reqData['create_time'] . '</p>
<p><b>更新时间：</b>' . $reqData['update_time'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $reqUpdateData['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '采购申请-新申请', 'cc' => $user_session->user_info['user_email'], 'content' => $mailContent, 'add_date' => $now);
$resultMail = $help->sendMailToStep($mailTo, $mailData);
if (!$resultMail['success']) {
$result = $resultMail;
}
}
} else {
$data = array('actual_user' => $actual_user);
$review->update($data, "id = " . $review_current_step);
// 等待其他审核人批准
}
}
// 更新申请状态
$req->update($reqUpdateData, "id = " . $review_id);
}
}
}
echo Zend_Json::encode($result);
exit;
}
public function overtimeAction()
{
// 返回值数组
$result = array('success' => true, 'info' => '提交成功');
// 请求参数
$request = $this->getRequest()->getParams();
// 操作类型
$operate = array('new' => '新建', 'edit' => '编辑', 'delete' => '删除');
// 操作类别（新建、更新、删除）
$operate_type = isset($request['operate']) ? $request['operate'] : '';
$overtime = new Hra_Model_Attendance_Overtime();
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();
// 获取请假区间包含的工作日天数
$overtimeInfo = $workday->getOvertimeQtyByTimeRange($userType, $request['time_from'], $request['time_to']);
$overtimeQty = $overtimeInfo['qty'];
$overtimeQty_hours = $overtimeInfo['qty_hours'];
/* echo $overtimeQty;
exit; */
// 加班类别按起始日期获取
$overtimeType = $workday->getWorkdayType($userType, date('Y-m-d', strtotime($request['time_from'])));
if ($overtimeType == 0) {
$result['success'] = false;
$request['info'] = '工作日设置错误，请检查工作日设置！';
echo Zend_Json::encode($result);
exit;
}
// 当编辑请假申请时，检查时间是否重叠需要过滤当前加班申请ID
$filter_id = null;
if ($operate_type == 'edit') {
$filter_id = $request['id'];
}
// 检查加班时间范围是否正确
if ($overtimeQty > 0) {
// 检查加班时间范围是否跟已有申请（包括已审核和审核中的申请）重叠
if ($overtime->checkTimeOverlap($request['apply_user'], $request['time_from'], $request['time_to'], $filter_id)) {
$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) {
$data = array('type' => $overtimeType, 'apply_user' => $request['apply_user'], 'review_user_1' => $request['review_user_1'], 'time_from' => $request['time_from'], 'time_to' => $request['time_to'], 'qty' => $overtimeQty, 'qty_hours' => $overtimeQty_hours, 'reason' => $request['reason'], 'remark' => $request['remark'], 'update_time' => $now, 'update_user' => $user_id);
/* echo '<pre>';
print_r($data);
exit; */
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 {
$overtime_id = $overtime->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 {
$overtime_id = $overtime->insert($data);
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
}
} else {
$overtime_id = $request['id'];
$review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [修改]';
$overtimeData = $overtime->getData(null, $overtime_id);
$data['review_info'] = $overtimeData['review_info'] . '<br>' . $review_info;
$data['state'] = 0;
$data['review_time_1'] = null;
//$data['review_time_2'] = null;
$data['release_time'] = null;
try {
$overtime->update($data, "id = " . $overtime_id);
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
}
}
}
$overtimeData = $overtime->getData(null, $overtime_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']);
$reviewData = array('type' => 'attendance_overtime', 'file_id' => $overtime_id, 'step_name' => '审核人1', 'plan_user' => $overtimeData['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_overtime',
'file_id' => $overtime_id,
'step_name' => '审核人2',
'plan_user' => $overtimeData['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_overtime', 'file_id' => $overtime_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;">' . $overtimeData['apply_user_name'] . '</a></p>
<p><b>加班时间：</b><a style="color:#008B00;font-weight: bold;">' . $overtimeData['time_from'] . '</a> 至 <a style="color:#008B00;font-weight: bold;">' . $overtimeData['time_to'] . '</a></p>
<p><b>事由：</b>' . $overtimeData['reason'] . '</p>
<p><b>备注：</b>' . $overtimeData['remark'] . '</p>
<p><b>创建人：</b>' . $overtimeData['creater'] . '</p>
<p><b>申请时间：</b>' . $overtimeData['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 {
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_overtime' and file_id = " . $id);
$overtime->delete("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;
}
public function reviewAction()
{
// 返回值数组
$result = array('success' => true, 'info' => '审核成功');
$request = $this->getRequest()->getParams();
$review_id = isset($request['review_id']) ? $request['review_id'] : null;
$review_operate = isset($request['review_operate']) ? $request['review_operate'] : null;
$review_current_step = isset($request['review_current_step']) ? $request['review_current_step'] : null;
// 当前阶段（review表ID）
$review_last_step = isset($request['review_last_step']) ? $request['review_last_step'] : null;
// 是否当前阶段为最后一阶段
$review_to_finish = isset($request['review_to_finish']) ? $request['review_to_finish'] : null;
// 是否批准后当前阶段结束
$review_next_step = isset($request['review_next_step']) ? $request['review_next_step'] : null;
// 下一阶段（review表ID）
$review_remark = isset($request['review_remark']) ? $request['review_remark'] : null;
$review_transfer_user = isset($request['review_transfer_user']) ? $request['review_transfer_user'] : null;
//转审人
if ($review_id && $review_operate) {
$now = date('Y-m-d H:i:s');
$user_session = new Zend_Session_Namespace('user');
$user_id = $user_session->user_info['user_id'];
$employee_id = $user_session->user_info['employee_id'];
// 评审意见
$review_info = '意见: ' . $review_remark;
$price = new Erp_Model_Sale_Price();
$user = new Application_Model_User();
$review = new Dcc_Model_Review();
$employee = new Hra_Model_Employee();
$priceData = $price->getData(null, $review_id);
// 更新审核状态及审核意见
if ($review_operate == 'transfer') {
// 转审
$tmp = $priceData['review_info'] != '' ? $priceData['review_info'] . '<br>' : '';
$review_info = $tmp . $now . ': ' . $user_session->user_info['user_name'] . ' [审核-转审] [' . $review_info . ']';
$price->update(array('review_info' => $review_info), "id = " . $review_id);
$reviewState = $review->fetchRow("type = 'sale_price_add' and finish_flg = 0 and file_id = " . $review_id, "id")->toArray();
// 转审对象
$transferUserInfo = $user->getEmployeeInfoById($review_transfer_user);
$reviewUsers = $reviewState['plan_user'];
$reviewUserArr = explode(',', $reviewUsers);
$reviewer = array();
if ($reviewState['method'] == 2) {
// 任意： 直接替换审核人为转审对象
foreach ($reviewUserArr as $review_user) {
if ($review_user == $employee_id) {
array_push($reviewer, $transferUserInfo['id']);
}
}
} else {
// 全部： 替换当前审核人为转审对象，其余审核人保留
foreach ($reviewUserArr as $review_user) {
if ($review_user == $employee_id) {
array_push($reviewer, $transferUserInfo['id']);
} else {
if (!in_array($review_user, $reviewer)) {
array_push($reviewer, $review_user);
}
}
}
}
$reviewerstr = implode(',', $reviewer);
$review->update(array('plan_user' => $reviewerstr), "id = " . $reviewState['id']);
// 发送邮件通知制单人
$reviewResult = '<font style="color: #FF0000"><b>转审</b></font>';
$mail = new Application_Model_Log_Mail();
$to = $transferUserInfo['email'];
$mailContent = '<div>销售价格申请审核：</div>
<div>
<p><b>审核人：</b>' . $user_session->user_info['user_name'] . '</p>
<p><b>审核结果：</b>' . $reviewResult . '</p>
<p><b>审核意见：</b>' . $review_remark . '</p>
<p><b>申请单号：</b>' . $priceData['number'] . '</p>
<p><b>申请人：</b>' . $priceData['creater'] . '</p>
<p><b>描述：</b>' . $priceData['description'] . '</p>
<p><b>备注：</b>' . $priceData['remark'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $priceData['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '销售价格申请-转审', 'to' => $to, 'cc' => $user_session->user_info['user_email'], 'user_id' => $user_session->user_info['user_id'], 'content' => $mailContent, 'add_date' => $now);
try {
// 记录邮件日志并发送邮件
$mail->send($mail->insert($mailData));
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
}
} else {
if ($review_operate == 'no') {
// 更新申请状态
$review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [审核-拒绝] [' . $review_info . ']';
$tmp = $priceData['review_info'] != '' ? $priceData['review_info'] . '<br>' : '';
$data = array('state' => 1, 'review_info' => $tmp . $review_info);
$price->update($data, "id = " . $review_id);
// 删除当前申请的审核配置
$review->delete("type = 'sale_price_add' and file_id = " . $review_id);
// 发送邮件通知制单人
$reviewResult = '<font style="color: #FF0000"><b>拒绝</b></font>';
$mail = new Application_Model_Log_Mail();
$applyEmployeeData = $user->fetchRow("id = " . $priceData['create_user'])->toArray();
$applyEmployee = $employee->fetchRow("id = " . $applyEmployeeData['employee_id'])->toArray();
$to = $applyEmployee['email'];
$mailContent = '<div>销售价格申请审核：</div>
<div>
<p><b>审核人：</b>' . $user_session->user_info['user_name'] . '</p>
<p><b>审核结果：</b>' . $reviewResult . '</p>
<p><b>审核意见：</b>' . $review_remark . '</p>
<p><b>申请单号：</b>' . $priceData['number'] . '</p>
<p><b>申请人：</b>' . $priceData['creater'] . '</p>
<p><b>描述：</b>' . $priceData['description'] . '</p>
<p><b>备注：</b>' . $priceData['remark'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $priceData['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '销售价格申请-审核', 'to' => $to, 'cc' => $user_session->user_info['user_email'], 'user_id' => $priceData['create_user'], 'content' => $mailContent, 'add_date' => $now);
try {
// 记录邮件日志并发送邮件
$mail->send($mail->insert($mailData));
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
}
} else {
$help = new Application_Model_Helpers();
$review_info = $now . ': ' . $user_session->user_info['user_name'] . ' [审核-批准] [' . $review_info . ']';
$tmp = $priceData['review_info'] != '' ? $priceData['review_info'] . '<br>' : '';
$reqUpdateData = array('review_info' => $tmp . $review_info);
$reviewData = $review->fetchRow("id = " . $review_current_step)->toArray();
$actual_user = $reviewData['actual_user'] == '' ? $user_session->user_info['employee_id'] : $reviewData['actual_user'] . ',' . $user_session->user_info['employee_id'];
$data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1);
// 当前审核阶段为最后一阶段
if ($review_last_step == 1) {
// 当前阶段已完结
if ($review_to_finish == 1) {
$data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1);
$reviewResult = '<font style="color: #006400"><b>发布</b></font>';
// 发布：检查客户的当前产品（包括类别）是否存在生效价格（如存在则更新历史价格为作废）
$price->updatePriceByPriceId($review_id);
// 更新申请状态
$reqUpdateData['state'] = 2;
$reqUpdateData['release_time'] = $now;
// 更新审核记录表
$review->update($data, "id = " . $review_current_step);
$mail = new Application_Model_Log_Mail();
$applyEmployeeData = $user->fetchRow("id = " . $priceData['create_user'])->toArray();
$applyEmployee = $employee->fetchRow("id = " . $applyEmployeeData['employee_id'])->toArray();
$to = $applyEmployee['email'];
$cc = $user_session->user_info['user_email'];
$mailContent = '<div>销售价格审核批准，请登录系统查看：</div>
<div>
<p><b>审核人：</b>' . $user_session->user_info['user_name'] . '</p>
<p><b>审核结果：</b>' . $reviewResult . '</p>
<p><b>审核意见：</b>' . $review_remark . '</p>
<p><b>申请单号：</b>' . $priceData['number'] . '</p>
<p><b>申请人：</b>' . $priceData['creater'] . '</p>
<p><b>描述：</b>' . $priceData['description'] . '</p>
<p><b>备注：</b>' . $priceData['remark'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $reqUpdateData['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '销售价格申请-发布', 'to' => $to, 'cc' => $cc, 'user_id' => $priceData['create_user'], 'content' => $mailContent, 'add_date' => $now);
try {
// 记录邮件日志并发送邮件
$mail->send($mail->insert($mailData));
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
}
} else {
$data = array('actual_user' => $actual_user);
$review->update($data, "id = " . $review_current_step);
}
} else {
// 当前阶段已完结
if ($review_to_finish == 1) {
$data = array('actual_user' => $actual_user, 'finish_time' => $now, 'finish_flg' => 1);
$reviewResult = '<font style="color: #006400"><b>批准</b></font>';
// 进入下一阶段
// 更新审核记录表
$review->update($data, "id = " . $review_current_step);
// 邮件通知下一阶段审核人
$reviewNextStepData = $review->fetchRow("id = " . $review_next_step)->toArray();
$mailTo = explode(',', $reviewNextStepData['plan_user']);
if ($mailTo) {
$mailContent = '<div>销售价格申请，请登录系统查看：</div>
<div>
<p><b>审核人：</b>' . $user_session->user_info['user_name'] . '</p>
<p><b>审核结果：</b>' . $reviewResult . '</p>
<p><b>审核意见：</b>' . $review_remark . '</p>
<p><b>申请单号：</b>' . $priceData['number'] . '</p>
<p><b>申请人：</b>' . $priceData['creater'] . '</p>
<p><b>描述：</b>' . $priceData['description'] . '</p>
<p><b>备注：</b>' . $priceData['remark'] . '</p>
<hr>
<p><b>审核日志：</b></p><p>' . $reqUpdateData['review_info'] . '</p>
</div>';
$mailData = array('type' => '消息', 'subject' => '销售价格申请-新申请', 'cc' => $user_session->user_info['user_email'], 'content' => $mailContent, 'add_date' => $now);
$resultMail = $help->sendMailToStep($mailTo, $mailData);
if (!$resultMail['success']) {
$result = $resultMail;
}
}
} else {
$data = array('actual_user' => $actual_user);
$review->update($data, "id = " . $review_current_step);
// 等待其他审核人批准
}
}
// 更新申请状态
$price->update($reqUpdateData, "id = " . $review_id);
}
}
}
echo Zend_Json::encode($result);
exit;
}
public function savepasswordAction()
{
// 返回值数组
$result = array('success' => true, 'info' => '修改密码成功');
$request = $this->getRequest()->getParams();
$user_id = isset($request['user_id']) ? $request['user_id'] : null;
$key = isset($request['key']) ? $request['key'] : null;
$pwd = isset($request['pwd1']) ? $request['pwd1'] : null;
// 检查输入
if ($user_id && $pwd) {
$user = new Application_Model_User();
$employeeInfo = $user->getEmployeeInfoById($user_id);
$pwd = md5($employeeInfo['number'] . $pwd);
try {
$user->update(array('password' => $pwd), "id = " . $user_id);
// 当检查到key，更新重置密码邮件key
if ($key) {
$mail = new Application_Model_Log_Mail();
try {
$mail->clearKey($key);
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
echo Zend_Json::encode($result);
exit;
}
}
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
echo Zend_Json::encode($result);
exit;
}
} else {
$result['success'] = false;
$result['info'] = '输入错误，请重新输入！';
}
echo Zend_Json::encode($result);
exit;
}
