public function getlistAction()
{
$request = $this->getRequest()->getParams();
$limit = $request['limit'];
$start = $request['start'];
$desc = new Product_Model_Desc();
$descName = $desc->getName();
$whereSearch = "1=1";
$mytype = $this->getRequest()->getParam('mytype');
if ($mytype == 3) {
$whereSearch = "{$descName}.state = 'Reviewing'";
}
foreach ($request as $k => $v) {
if ($v) {
if ($k == 'search_tag') {
$whereSearch .= " and (ifnull({$descName}.remark,'') like '%{$v}%' or ifnull({$descName}.manufacturers_before,'') like '%{$v}%' or ifnull({$descName}.manufacturers_after,'') like '%{$v}%' or ifnull({$descName}.desc_before,'') like '%{$v}%' or ifnull({$descName}.desc_after,'') like '%{$v}%')";
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$whereSearch .= " and ifnull({$descName}." . $col . ",'') like '%" . $v . "%'";
}
}
}
}
$user_session = new Zend_Session_Namespace('user');
$user = $user_session->user_info['employee_id'];
$materiel = new Product_Model_Materiel();
$type = new Product_Model_Type();
$record = new Dcc_Model_Record();
$flow = new Admin_Model_Flow();
$step = new Admin_Model_Step();
$review = new Dcc_Model_Review();
$employee = new Hra_Model_Employee();
// 查询条件
// 供应商
$supply = new Product_Model_Bpartner();
$supplyData = $supply->getJoinList(array(), array(), array('id', 'code', 'cname', 'ename'));
// 审核中
$reviewingData = $review->getJoinList("finish_flg = 0 and type = 'materiel_desc' and (actual_user is null or !(FIND_IN_SET({$user},actual_user))) and (FIND_IN_SET({$user}, plan_user))", array(), array('table_id'));
$reviewingIds = array();
foreach ($reviewingData as $r) {
if (!in_array($r['id'], $reviewingIds)) {
$reviewingIds[] = $r['id'];
}
}
// 审核过
$reviewedData = $review->getJoinList("finish_flg = 1 and type = 'materiel_desc' and (FIND_IN_SET({$user},actual_user))", array(), array('table_id'));
$reviewedIds = array();
foreach ($reviewedData as $r) {
if (!in_array($r['id'], $reviewedIds)) {
$reviewedIds[] = $r['id'];
}
}
$join = array(array('type' => INNERJOIN, 'table' => $employee->getName(), 'condition' => $employee->getName() . '.id = ' . $desc->getName() . '.create_user'));
$myType = "";
if (isset($request['mytype'])) {
$myType = $request['mytype'];
}
if ($myType == 1) {
$whereSearch .= " and {$descName}.create_user = {$user}";
} else {
if ($myType == 2 && count($reviewedIds) > 0) {
$whereSearch .= " and {$descName}.id in (" . implode(',', $reviewedIds) . ")";
} else {
if ($myType == 3 && count($reviewingIds) > 0) {
$whereSearch .= " and {$descName}.id in (" . implode(',', $reviewingIds) . ")";
} else {
// $whereSearch .= " and ($descName.create_user = $user ";
$whereSearch .= " and (1=1 ";
if (count($reviewedIds) > 0) {
$whereSearch .= " or {$descName}.id in (" . implode(',', $reviewedIds) . ")";
}
if (count($reviewingIds) > 0) {
$whereSearch .= " or {$descName}.id in (" . implode(',', $reviewingIds) . ")";
}
$whereSearch .= ")";
}
}
}
$total = $desc->getJoinCount($whereSearch);
if ($total > 0) {
$join = array(array('type' => INNERJOIN, 'table' => $employee->getName(), 'condition' => $employee->getName() . '.id = ' . $desc->getName() . '.create_user', 'cols' => array('creater' => 'cname')));
$data = $desc->getJoinList($whereSearch, $join, null, array($desc->getName() . '.state desc', $desc->getName() . '.create_time desc'), $start, $limit);
} else {
$data = array();
}
$fileIds = array();
// 获取物料数据
for ($i = 0; $i < count($data); $i++) {
$mytype = 2;
if ($data[$i]['create_user'] == $user) {
$mytype = 1;
}
if (($typeId = $data[$i]['type_before']) != '') {
$typeName = $type->getTypeByConnect($typeId, '');
$data[$i]['type_name'] = $typeName;
}
$data[$i]['create_time'] = strtotime($data[$i]['create_time']);
$data[$i]['archive_time'] = strtotime($data[$i]['archive_time']);
// files
if ($data[$i]['data_file_id_before'] && !in_array($data[$i]['data_file_id_before'], $fileIds)) {
$fileIds[] = $data[$i]['data_file_id_before'];
}
if ($data[$i]['data_file_id_after'] && !in_array($data[$i]['data_file_id_after'], $fileIds)) {
$fileIds[] = $data[$i]['data_file_id_after'];
}
if ($data[$i]['tsr_id_before'] && !in_array($data[$i]['tsr_id_before'], $fileIds)) {
$fileIds[] = $data[$i]['tsr_id_before'];
}
if ($data[$i]['tsr_id_after'] && !in_array($data[$i]['tsr_id_after'], $fileIds)) {
$fileIds[] = $data[$i]['tsr_id_after'];
}
if ($data[$i]['first_report_id_before'] && !in_array($data[$i]['first_report_id_before'], $fileIds)) {
$fileIds[] = $data[$i]['first_report_id_before'];
}
if ($data[$i]['first_report_id_after'] && !in_array($data[$i]['first_report_id_after'], $fileIds)) {
$fileIds[] = $data[$i]['first_report_id_after'];
}
// 增加审核状态
$reviewState = "";
$step_name = "";
if ($data[$i]['state'] == 'Active') {
$reviewState = "已归档";
} else {
if ($data[$i]['state'] == 'Reviewing') {
// 查询当前审核状态
// 查询所有审核阶段
$reviewRows = $review->getList("file_id = " . $data[$i]['id'], "materiel_desc");
if (count($reviewRows) > 0) {
$first = true;
foreach ($reviewRows as $row) {
if ($row['finish_flg'] == 1) {
if ($step_name) {
$step_name .= "->";
}
$step_name .= $row['step_name'];
} else {
if ($step_name) {
$step_name .= "->";
}
// 第一条未审核记录就是当前待审核记录
if ($first) {
$first = false;
$step_name .= "<b>" . $row['step_name'] . "</b>";
$reviewRow = $row;
$actual_user = explode(',', $reviewRow['actual_user']);
$planUser = $reviewRow['plan_user'];
$method = $reviewRow['method'];
$plan_user = explode(',', $planUser);
$diff = array_diff($plan_user, $actual_user);
foreach ($diff as $u) {
if (!$u) {
continue;
}
if ($u == $user) {
$mytype = 3;
}
$e = $employee->fetchRow("id = {$u}");
if ($reviewState) {
$reviewState .= ", ";
}
$reviewState .= $e['cname'] . "：未审核";
}
foreach ($actual_user as $u) {
if (!$u) {
continue;
}
$e = $employee->fetchRow("id = {$u}");
if ($reviewState) {
$reviewState .= ", ";
}
$reviewState .= $e['cname'] . "：已审核";
}
} else {
$step_name .= $row['step_name'];
}
}
}
}
} else {
if ($data[$i]['state'] == 'Obsolete') {
$reviewState = "已作废";
} else {
if ($data[$i]['state'] == 'Return') {
$reviewState = "退回";
} else {
$reviewState = $data[$i]['state'];
}
}
}
}
$data[$i]['step_name'] = $step_name;
$data[$i]['review_state'] = $reviewState;
$data[$i]['mytype'] = $mytype;
$data[$i]['record'] = $record->getHis($data[$i]['id'], 'materiel_desc');
}
// get file names
if (count($fileIds) > 0) {
$upload = new Dcc_Model_Upload();
$fileData = $upload->getJoinList("id in (" . implode(',', $fileIds) . ")", array(), array('id', 'name'));
$files = array();
foreach ($fileData as $f) {
$files[$f['id']] = $f['name'];
}
// data rebuild
for ($i = 0; $i < count($data); $i++) {
if ($data[$i]['data_file_id_before'] && in_array($data[$i]['data_file_id_before'], $fileIds)) {
$data[$i]['data_file_before'] = $files[$data[$i]['data_file_id_before']];
}
if ($data[$i]['data_file_id_after'] && in_array($data[$i]['data_file_id_after'], $fileIds)) {
$data[$i]['data_file_after'] = $files[$data[$i]['data_file_id_after']];
}
if ($data[$i]['tsr_id_before'] && in_array($data[$i]['tsr_id_before'], $fileIds)) {
$data[$i]['tsr_before'] = $files[$data[$i]['tsr_id_before']];
}
if ($data[$i]['tsr_id_after'] && in_array($data[$i]['tsr_id_after'], $fileIds)) {
$data[$i]['tsr_after'] = $files[$data[$i]['tsr_id_after']];
}
if ($data[$i]['first_report_id_before'] && in_array($data[$i]['first_report_id_before'], $fileIds)) {
$data[$i]['first_report_before'] = $files[$data[$i]['first_report_id_before']];
}
if ($data[$i]['first_report_id_after'] && in_array($data[$i]['first_report_id_after'], $fileIds)) {
$data[$i]['first_report_after'] = $files[$data[$i]['first_report_id_after']];
}
}
}
// 转为json格式并输出
$resutl = array("totalCount" => $total, "topics" => $data);
echo Zend_Json::encode($resutl);
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);
}
}
