function getAnswerList() { $tlist = mod_crmmanage::getqtype(); foreach ($tlist as $key => $value) { $newtype[$key + 1] = $value; } $newtype = genTree($newtype); //$answer_id=mod_crmtest::getAnswerId(); //debug($alist['answer_id']); $alist = mod_crmtest::getanswerlist(); //debug($alist); //$a=mb_substr($alist['3']['content'],0,2); pm_tpl::assign("ser_tlist", $newtype); pm_tpl::assign("alist", $alist); pm_tpl::display('crmtest_getanswerlist'); }
public function export() { $where = stripcslashes($_GET['query']); $sql = "SELECT * from crm_question WHERE `exists`= '1' {$where} order by create_time desc"; $list = pm_db::fetch_all_result($sql); $plist = mod_product::getcrmproduct(); $tlist = mod_crmmanage::getqtype(); $slist = mod_crmmanage::getserverlist(); foreach ($list as &$value) { foreach ($slist as $val) { if ($value['server_id'] == $val['id']) { $value['server'] = $val['server_name']; } } foreach ($plist as $val) { if ($value['game_id'] == $val['pid']) { $value['game'] = $val['pname']; } } foreach ($tlist as $val) { if ($value['qtype_id'] == $val['id']) { $value['qtype'] = $val['name']; } } if ($value['status'] == 'untreated') { $value['status_info'] = "未处理"; } elseif ($value['status'] == 'processed') { $value['status_info'] = "已处理"; } else { $value['status_info'] = "已关闭"; } if ($value['operation'] == 1) { $value['status_info'] .= "--运营处理中"; } if ($value['operation'] == 2) { $value['status_info'] .= "--运营已回复"; } } $line = "<tr>"; foreach ($list as $value) { $line .= "<td>" . $value['question_id'] . "</td>"; $line .= "<td>" . $value['title'] . "</td>"; $line .= "<td>" . $value['content'] . "</td>"; $line .= "<td>" . $value['game'] . "</td>"; $line .= "<td>" . $value['server'] . "</td>"; $line .= "<td>" . $value['channel'] . "</td>"; $line .= "<td>" . $value['account'] . "</td>"; $line .= "<td>" . $value['nick'] . "</td>"; $line .= "<td>" . $value['role_id'] . "</td>"; $line .= "<td>" . $value['occurs_time'] . "</td>"; $line .= "<td>" . $value['qtype'] . "</td>"; $line .= "<td>" . $value['create_time'] . "</td>"; $line .= "<td>" . $value['status_info'] . "</td>"; $line .= "<td>" . $value['qq'] . "</td>"; $line .= "<td>" . $value['mobile'] . "</td>"; $line .= "<td>" . $value['email'] . "</td></tr><tr>"; } $content = substr($line, 0, -4); $template = file_get_contents("template.html"); $html = str_replace("[content]", $content, $template); echo $html; }
public function answerlist() { if ($_POST['rquestion']) { if (ADMINUSERID == 249) { dump($_POST); exit; } $data['qid'] = $_POST['qid']; $data['content'] = $_POST['reply']; $data['create_time'] = time(); $data['creater_id'] = ADMINUSERID; $data['reply_type'] = 'cus_server'; pm_db::tran_query("BEGIN"); $id = pm_db::insert('crm_answer', $data, 'tran'); $reply['lastreply_id'] = ADMINUSERID; $reply['lastreply_time'] = time(); if (isset($_POST['to_server']) && !empty($_POST['to_server'])) { if ($_POST['operation'] == 0 && $_POST['status'] == 'untreated') { $reply['operation'] = 3; } } else { if ($_POST['operation'] == 3) { $reply['operation'] = 0; } $reply['status'] = 'processed'; } $status = pm_db::update('crm_question', $reply, "question_id = '{$_POST['qid']}'", 'tran'); if ($id && $status) { pm_db::tran_query("COMMIT"); mod_login::message('回复成功'); } else { pm_db::tran_query("ROLLBACK"); mod_login::message('回复失败'); } pm_db::tran_query("END"); exit; } if ($_POST['tooperation']) { $data['operation'] = 1; $data['status'] = 'untreated'; $status = pm_db::update('crm_question', $data, "question_id = '{$_POST['qid']}'"); if ($status) { mod_login::message('转交成功!'); } else { mod_login::message('转交失败!'); } exit; } if ($_POST['cquestion']) { $data['status'] = 'closed'; $data['operation'] = 0; $status = pm_db::update('crm_question', $data, "question_id = '{$_POST['qid']}'"); if ($status) { mod_login::message('问题关闭成功!'); } else { mod_login::message('问题关闭失败!'); } exit; } $qid = $_GET['qid']; $info = mod_crmmanage::getqbyid($qid); $memberinfo = mod_member::get_oneamdinbyuser_id($info['create_id']); $admin_info = mod_member::get_oneamdinbyuser_id(ADMINUSERID); $proinfo = mod_product::get_one_product($info['game_id']); $serinfo = mod_crmmanage::getserverbyid($info['server_id']); $info['truename'] = $memberinfo['truename']; $info['pname'] = $proinfo['pname']; $info['server_name'] = $serinfo['server_name']; $info['is_right'] = strpos($admin_info['rights'], 'custom-question'); $tlist = mod_crmmanage::getqtype(); $alist = mod_crmmanage::getanswerlist($qid); $userlist = mod_crmmanage::getusername(); if ($alist) { foreach ($alist as &$value) { if ($value['reply_type'] != 'customer') { foreach ($userlist as $val) { if ($val['user_id'] == $value['creater_id']) { $value['username'] = $val['user_name']; } } } } } pm_tpl::assign("tlist", $tlist); pm_tpl::assign("alist", $alist); pm_tpl::assign("info", $info); pm_tpl::assign("ur_here", "回复列表"); pm_tpl::assign('action_link', array('href' => '?c=crmmanage&a=index', 'text' => '问题列表')); pm_tpl::display('crmmanage_answerlist'); }