huankeviewlistthread.java

cwbbs 云网论坛源码

package com.redmoon.forum.plugin.huanke;

import java.util.*;
import javax.servlet.http.*;
import cn.js.fan.util.*;
import com.redmoon.forum.*;
import com.redmoon.forum.person.*;
import com.redmoon.forum.plugin.*;
import com.redmoon.forum.plugin.base.*;
import java.sql.Timestamp;

public class HuankeViewListThread implements IPluginViewListThread {
    HttpServletRequest request;

    public HuankeViewListThread(HttpServletRequest request, String boardCode) {
        this.request = request;
        this.boardCode = boardCode;
    }

    public String render(int position, MsgDb md) {
        return "";
    }

    public String render(int position) {
        String str = "";

        switch (position) {
        case UIListThread.POS_RULE:
            str += "[<a href='plugin/huanke/huankecenter.jsp?boardCode=" + StrUtil.UrlEncode(boardCode)+ "'>管理我的换客</a>]&nbsp;&nbsp;";
            break;
        default:
            break;
        }
        return str;
    }

    public String getHelpLink() {
        return HuankeSkin.LoadString(request, "helpLink");
    }

    public void setBoardCode(String boardCode) {
        this.boardCode = boardCode;
    }

    public String getBoardCode() {
        return boardCode;
    }

    public String getBoardRule() {
        BoardDb sb = new BoardDb();
        sb = sb.getBoardDb(HuankeUnit.code, boardCode);
        return sb.getBoardRule();
    }

    public String getBoardNote() {

        String note = "";
        return note;
    }

    public boolean IsPluginBoard() {
        BoardDb sb = new BoardDb();
        return sb.isPluginBoard(HuankeUnit.code, boardCode);
    }

    public String getListtopicSql(HttpServletRequest request, String boardcode,
                                  String op, String timelimit, int threadType) {
        String witkeyTaskType = ParamUtil.get(request, "witkeyTaskType");

        if (witkeyTaskType.equals("all")) {
            String sql = "";
            sql = "select p.msg_root_id from plugin_huanke_goods p, sq_thread t where p.msg_root_id=t.id and t.boardcode=" +
                  StrUtil.sqlstr(boardCode) + " and t.check_status=" +
                  MsgDb.CHECK_STATUS_PASS +
                  " ORDER BY t.msg_level desc,t.redate desc";
            return sql;
        } else {
            if (witkeyTaskType.equals("starting")) {
                long lDate = System.currentTimeMillis();
                Timestamp ts = new Timestamp(lDate);
                java.util.Date date = DateUtil.parse(ts.toString(),
                        "yyyy-MM-dd");
                String sql = "";
                sql = "select w.msg_root_id from plugin_witkey w, sq_thread t where w.msg_root_id=t.id and t.boardcode=" +
                      StrUtil.sqlstr(boardCode) + " and t.check_status=" +
                      MsgDb.CHECK_STATUS_PASS + " and w.end_date >= " +
                      StrUtil.sqlstr(Long.toString(date.getTime())) +
                      " ORDER BY t.msg_level desc,t.redate desc";
                return sql;
            } else {
                if (witkeyTaskType.equals("recommend")) {
                    long lDate = System.currentTimeMillis();
                    Timestamp ts = new Timestamp(lDate);
                    java.util.Date date = DateUtil.parse(ts.toString(),
                            "yyyy-MM-dd");
                    String sql = "";
                    sql = "select w.msg_root_id from plugin_witkey w, sq_thread t where w.msg_root_id=t.id and t.boardcode=" +
                          StrUtil.sqlstr(boardCode) + " and t.check_status=" +
                          MsgDb.CHECK_STATUS_PASS + " and w.end_date >= " +
                          StrUtil.sqlstr(Long.toString(date.getTime())) +
                          " and level<>0 ORDER BY t.msg_level desc,t.redate desc";
                    return sql;
                } else {
                    if (witkeyTaskType.equals("delay")) {
                        String sql = "";
                        sql = "select w.msg_root_id from plugin_witkey w, sq_thread t where w.msg_root_id=t.id and t.boardcode=" +
                              StrUtil.sqlstr(boardCode) +
                              " and t.check_status=" +
                              MsgDb.CHECK_STATUS_PASS +
                              " and status=2 ORDER BY t.msg_level desc,t.redate desc";
                        return sql;
                    } else {
                        if (witkeyTaskType.equals("choosedraft")) {
                            String sql = "";
                            sql = "select w.msg_root_id from plugin_witkey w, sq_thread t where w.msg_root_id=t.id and t.boardcode=" +
                                  StrUtil.sqlstr(boardCode) +
                                  " and t.check_status=" +
                                  MsgDb.CHECK_STATUS_PASS +
                                  " and status=3 ORDER BY t.msg_level desc,t.redate desc";
                            return sql;
                        } else {
                            if (witkeyTaskType.equals("pay")) {
                                String sql = "";
                                sql = "select w.msg_root_id from plugin_witkey w, sq_thread t where w.msg_root_id=t.id and t.boardcode=" +
                                      StrUtil.sqlstr(boardCode) +
                                      " and t.check_status=" +
                                      MsgDb.CHECK_STATUS_PASS +
                                      " and status=4 ORDER BY t.msg_level desc,t.redate desc";
                                return sql;
                            } else {
                                return "";
                            }

                        }
                    }
                }
            }
        }
    }

    private String boardCode;
}