package calendar.controller;
/*
 * Copyright (c) 2009 - DHTMLX, All rights reserved
 */
import calendar.dao.DataAccessDriver;
import java.sql.Connection;

import com.dhtmlx.connector.ConnectorServlet;
import com.dhtmlx.connector.SchedulerConnector;
import com.database.IxConnection;

// TODO: Auto-generated Javadoc
/**
 * The Class SchedulerBasicConnector.
 */
public class Scheduler_BasicConnector extends ConnectorServlet {

    /* (non-Javadoc)
     * @see com.dhtmlx.connector.ConnectorServlet#configure()
     */
    
    protected void configure(String userId,int calId,String mergeUsers) {
        Connection conn = (new IxConnection()).getConnection();

        SchedulerConnector c = new SchedulerConnector(conn);
        System.out.println("userId==============" + userId +"="+calId +"==="+mergeUsers);
        boolean isAdmin=false;
        boolean doMerge=false;
        String sql="";
        if(mergeUsers!=null && !"".equalsIgnoreCase(mergeUsers) && !"null".equalsIgnoreCase(mergeUsers)){
            doMerge=true;
        }

        if(userId!=null && !"null".equalsIgnoreCase(userId) && !"".equalsIgnoreCase(userId)){
            if(userId.indexOf("ADMIN")==2 || (userId.length()>6 && userId.substring(2,6).equalsIgnoreCase("ADMIN"))){
                isAdmin=true;
            }

        }

        if (calId>0) {
           // String sql = "select * from nhm_bm_events where userId='" + userId + "'";
            if(isAdmin){
                if(doMerge){
                  sql = "select a.event_id as event_id,a.event_name as event_name,a.comments as comments,a.userId as userId,a.tags as tags,a.url as url,a.bm_start_date as start_date,a.bm_end_date as end_date,a.eventType as eventType,a.source as source,a.itemId as itemId from NHM_BM_EVENTS a, a.user_id in ("+mergeUsers+") and b.bm_id=a.event_id";
                }else{
                sql = "select a.event_id as event_id,a.event_name as event_name,a.comments as comments,a.userId as userId,a.tags as tags,a.url as url,a.bm_start_date as start_date,a.bm_end_date as end_date,a.eventType as eventType,a.source as source,a.itemId as itemId from NHM_BM_EVENTS a, a.user_id ="+mergeUsers+" and b.bm_id=a.event_id";
            }
            }
           c.render_sql(sql, "event_id", "start_date,end_date,event_name,comments,url,userId,tags,eventType,source,itemId");

        } 

    }

    protected void deleteEvent(int Id, int calId) {
        DataAccessDriver.getInstance().newBookMarkDAO().deleteEvent(Id, calId);

    }

    protected void insertBookMark(String eventName, String comments, String url, String tags, String userId, String start_date, String end_date,String itemId,String eventType,String source, int calId) {

        DataAccessDriver.getInstance().newBookMarkDAO().insertBookMark(eventName, comments, url, tags, userId, start_date, end_date,calId,itemId,eventType,source);

    }

    protected void updateBookMark(String eventName, String comments, String userId, String url, String start_date, String tags, String end_date, int Id, int calId) {

        DataAccessDriver.getInstance().newBookMarkDAO().updateBookMark(eventName, comments, userId, url, start_date, tags, end_date, Id, calId);

    }

     

   
}