<%@ page import="com.joinebiz.ROXAN.Content.News,com.joinebiz.ROXAN.Category,com.joinebiz.ROXAN.Content.NewsList,com.joinebiz.ROXAN.CategoryList,com.joinebiz.ROXAN.LogList,com.joinebiz.ROXAN.Log,com.joinebiz.oxygen.util.Misc,com.joinebiz.oxygen.xml.SimpleDocument,com.crossdb.sql.SelectQuery,com.crossdb.sql.WhereClause,com.crossdb.sql.WhereCondition,com.joinebiz.oxygen.database.Database,com.joinebiz.oxygen.util.Cast,com.joinebiz.oxygen.util.IO,
                 java.io.File"%><%
    String RoxanLanguage="Fa";
    String Sort = "News.NewsDate DESC,News.Modified";
    if (Sort == null)
    {
        Sort = "News.NewsDate DESC,News.Modified";
    }
    int size=10;
    if(request.getParameter("Size") != null)
       size=Cast.toInteger(request.getParameter("Size"));
    if(size==0)
        size=10;

    Database db = new Database();
    SelectQuery newsSQL = db.getSelectQuery();

	String categoryID = request.getParameter("CategoryID");

    //Select News

    newsSQL.addTable("News");
    newsSQL.addTable("PublishVersion");
    newsSQL.addGroupBy("News.NewsID");
    newsSQL.addOrderBy(Sort);
    WhereClause clause = new WhereClause();

    clause.addCondition(new WhereCondition("News.NewsID", WhereCondition.EQUAL_TO, "PublishVersion.ID"));
    clause.addCondition(new WhereCondition("PublishVersion.Type", WhereCondition.EQUAL_TO, "'News'"));
    clause.addCondition(new WhereCondition("News.Version", WhereCondition.EQUAL_TO, "PublishVersion.PublishVersion"));
    clause.addCondition(new WhereCondition("News.Language", WhereCondition.EQUAL_TO, "PublishVersion.Language"));
    clause.addCondition(new WhereCondition("News.Language", WhereCondition.EQUAL_TO, " '" + RoxanLanguage + "' "));
    clause.addCondition(new WhereCondition("News.Status", WhereCondition.EQUAL_TO, " '" + News.NewStatus + "' "));


    newsSQL.addWhereClause(clause);

    NewsList newsList = new NewsList(newsSQL , size) ;


    //---------------------------
    /// Log Of Page Visit
    //---------------------------
    WhereClause logClause = new WhereClause();

    logClause.addCondition(new WhereCondition("Type",WhereCondition.EQUAL_TO,"'RSSNews'"));
    logClause.addCondition(new WhereCondition("Language",WhereCondition.EQUAL_TO,"'"+RoxanLanguage+"'"));

    LogList logList = new LogList(logClause);

    if(logList.size()>0)
    {
        Log log = ((Log)logList.getObject(0));
        int logCount = log.getCount();
        log.setCount(logCount+1);
        log.edit();
    }
    else
    {
        String logId = Misc.generateID("Log","LogID");
        Log log = new Log(logId,RoxanLanguage,"" , "RSSNews",1);
        log.add();
    }

//    response.setCharacterEncoding("UTF-8");
    response.setContentType("text/xml");
    String realPath = request.getRealPath(request.getServletPath());
    String realPathFolder= realPath.substring(0, realPath.lastIndexOf(File.separator)) + File.separator;
	String content = Cast.toString(newsList.generateRSS("IsfahanPortal.ir", "http://www.isfahanportal.ir/News.jsp", "http://www.isfahanportal.ir/NewsDes.jsp", RoxanLanguage, "5")).replaceFirst("\n","");
//    IO.createFile(realPathFolder + "index.xml",content);
	                 out.print(content);
%>