public function saveData($bom, $user, $relation) { $employee = new Hra_Model_Employee(); $userData = $employee->getById($user); if ($userData && count($userData) > 0) { $userName = $userData['cname']; $data = array('bom' => $bom, 'employee_id' => $user, 'employee_name' => $userName, 'relation' => $relation, 'create_time' => date('Y-m-d H:i:s')); $this->insert($data); } }
/** * @abstract 保存 * @return null */ public function saveAction() { // 返回值数组 $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 = $user_session->user_info['employee_id']; $bomId = $request['code_id']; $userId = $request['employee_id']; $bomIds = array(); $userIds = array(); if ($bomId) { $bomIds = explode(',', $bomId); } if ($userId) { $userIds = explode(',', $userId); } $bomrole = new Product_Model_Bomrole(); $fa = new Product_Model_Fa(); $emp = new Hra_Model_Employee(); try { foreach ($bomIds as $b) { $bomCodes = $fa->getById($b); $bomCode = $bomCodes['code']; foreach ($userIds as $u) { $userNames = $emp->getById($u); $userName = $userNames['cname']; $data = array('bom' => $bomCode, 'employee_id' => $u, 'employee_name' => $userName, 'relation' => '管理员增加', 'create_user' => $user, 'create_time' => $now); $bomrole->insert($data); } } } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } echo Zend_Json::encode($result); exit; }
private function send($id, $updFlg) { $user_session = new Zend_Session_Namespace('user'); $user = $user_session->user_info['employee_id']; $user_name = $user_session->user_info['user_name']; $now = date('Y-m-d H:i:s'); $employee = new Hra_Model_Employee(); $mail = new Application_Model_Log_Mail(); $task = new User_Model_Task(); $process = new User_Model_Process(); $record = $task->getJoinList("id=" . $id); if (!$record) { return; } $record = $record[0]; if ($record['type'] == '独立') { $where = " task_id = {$id} and employee_id = {$user}"; } else { $where = " task_id = {$id}"; } $join = array('type' => INNERJOIN, 'table' => $employee, 'condition' => $employee->getName() . '.id = ' . $process->getName() . '.employee_id', 'cols' => array('cname')); $pro = $process->getJoinList($where, $join); $to_id = $record['responsible_id']; $cc_id = $record['follow_id']; // 上级 if ($to_id == $user) { $up = $employee->getAdapter()->query("select manager_id from oa_employee where id = {$user}")->fetchObject(); if ($up && $up->manager_id && $up->manager_id != $user) { if ($cc_id) { $cc_id .= ',' . $up->manager_id; } else { $cc_id = $up->manager_id; } } } $to = $employee->getAdapter()->query("select group_concat(email) as mail_to from oa_employee where id in ( " . $to_id . ")")->fetchObject(); $ccmail = null; if ($cc_id) { $cc = $employee->getAdapter()->query("select group_concat(email) as mail_to from oa_employee where id in ( " . $cc_id . ")")->fetchObject(); $ccmail = $cc->mail_to; } if ($updFlg == 'add') { $title = "新任务提示"; $content = $user_name . "创建了新任务 " . $record['title']; } else { if ($updFlg == 'update') { $title = "任务更新提示"; $content = $user_name . "更新了任务 " . $record['title']; } else { $title = "任务删除提示"; $content = $user_name . "删除了任务 " . $record['title']; } } $content .= "<p><b>任务名称:</b>" . $record['title'] . "</p>"; $content .= "<p><b>当前状态:</b>" . $record['state'] . "</p>"; $content .= "<p><b>任务时间:</b>" . $record['start'] . "到" . $record['end'] . "</p>"; $content .= "<p><b>任务描述:</b>" . $record['notes'] . "</p>"; $content .= "<p><b>重要程度:</b>" . $record['important'] . "</p>"; $content .= "<p><b>优先级:</b>" . $record['priority'] . "</p>"; $content .= "<p><b>协作模式:</b>" . $record['type'] . "</p>"; $creater = $employee->getById($record['create_user']); $content .= "<p><b>创建人:</b>" . $creater['cname'] . "</p>"; $content .= "<p><b>创建时间:</b>" . $record['create_time'] . "</p>"; $content .= "<p><b>进度</b></p>"; foreach ($pro as $p) { $content .= "<p> "; if ($record['type'] == '协作') { $content .= $p['cname'] . " "; } $content .= $p['update_time'] . " " . $p['status'] . " " . $p['rate'] . "% " . $p['remark'] . "</p>"; } $mailData = array('type' => '任务', 'subject' => $title, 'to' => $to->mail_to, 'cc' => $ccmail, 'content' => $content, 'send_time' => $now, 'add_date' => $now); $mailId = $mail->insert($mailData); if ($mailId) { $mail->send($mailId); } }