$setsqlarr['map_x'] = trim($_POST['x']) ? trim($_POST['x']) : showmsg('请先点击“在地图上标记我的位置”按钮,然后再点击保存我的位置进行保存!', 1); $setsqlarr['map_y'] = trim($_POST['y']) ? trim($_POST['y']) : showmsg('请先点击“在地图上标记我的位置”按钮,然后再点击保存我的位置进行保存!', 1); $setsqlarr['map_zoom'] = trim($_POST['zoom']); $wheresql = " uid='{$_SESSION['uid']}'"; write_memberslog($_SESSION['uid'], 4, 8106, $_SESSION['username'], "设置了电子地图坐标"); if ($db->updatetable(table('train_profile'), $setsqlarr, $wheresql)) { $coursesql['map_x'] = $setsqlarr['map_x']; $coursesql['map_y'] = $setsqlarr['map_y']; $db->updatetable(table('course'), $coursesql, $wheresql); unset($setsqlarr['map_zoom']); showmsg('保存成功', 2); } else { showmsg('保存失败', 1); } } elseif ($act == 'train_news') { $smarty->assign('news', get_train_news(0, 60, $_SESSION['uid'])); $smarty->assign('title', '机构新闻 - 培训会员中心 - ' . $_CFG['site_name']); $smarty->display('member_train/train_news_list.htm'); } if ($act == 'train_news_add') { $link[0]['text'] = "完善机构资料"; $link[0]['href'] = '?act=train_profile'; $link[1]['text'] = "会员中心首页"; $link[1]['href'] = 'train_index.php'; if (empty($train_profile['trainname'])) { showmsg("请完善您的机构资料!", 1, $link); } $smarty->assign('title', '添加机构新闻 - 会员中心 - ' . $_CFG['site_name']); $smarty->display('member_train/train_news_add.htm'); } elseif ($act == 'train_news_add_save') { $n = $db->get_total("SELECT COUNT(*) AS num FROM " . table('train_news') . " WHERE uid='" . intval($_SESSION['uid']) . "'");
} $_GET['audit'] != "" ? $wheresqlarr['n.audit'] = intval($_GET['audit']) : ''; if (is_array($wheresqlarr)) { $wheresql = wheresql($wheresqlarr); } if (!empty($_GET['settr'])) { $settr = strtotime("-" . intval($_GET['settr']) . " day"); $wheresql = empty($wheresql) ? " WHERE n.addtime> " . $settr : $wheresql . " AND n.addtime> " . $settr; } $joinsql = " LEFT JOIN " . table('train_profile') . " AS t ON n.train_id=t.id "; $total_sql = "SELECT COUNT(*) AS num FROM " . table('train_news') . " AS n" . $joinsql . $wheresql; $total_val = $db->get_total($total_sql); $page = new page(array('total' => $total_val, 'perpage' => $perpage, 'getarray' => $_GET)); $currenpage = $page->nowindex; $offset = ($currenpage - 1) * $perpage; $clist = get_train_news($offset, $perpage, $joinsql . $wheresql . $oederbysql); $smarty->assign('pageheader', "机构新闻"); $smarty->assign('clist', $clist); $smarty->assign('page', $page->show(3)); $smarty->display('train/admin_train_news.htm'); } elseif ($act == 'edit_news_audit') { check_permissions($_SESSION['admin_purview'], "tra_news_audit"); check_token(); $id = !empty($_REQUEST['id']) ? $_REQUEST['id'] : adminmsg("你没有选择新闻!", 1); $audit = intval($_POST['audit']); $pms_notice = intval($_POST['pms_notice']); $reason = trim($_POST['reason']); $num = edit_news_audit($id, $audit, $reason, $pms_notice); if ($num > 0) { adminmsg("审核成功!共审核" . $num . "行", 2); } else {