public static function get_son_menu($menu_id) { $data = array(); $data = pm_db::fetch_all_result("SELECT * FROM iosadm_menu WHERE parent_id={$menu_id}"); return $data ? $data : null; }
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; }