PHP get_train_news Examples

Example #1

File: train_info.php Project: winiceo/job

    $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']) . "'");

Example #2

File: admin_train.php Project: winiceo/job

    }
    $_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 {