/src/mpv5/db/objects/Schedule.java

/*
 *  This file is part of YaBS.
 *
 *      YaBS is free software: you can redistribute it and/or modify
 *      it under the terms of the GNU General Public License as published by
 *      the Free Software Foundation, either version 3 of the License, or
 *      (at your option) any later version.
 *
 *      YaBS is distributed in the hope that it will be useful,
 *      but WITHOUT ANY WARRANTY; without even the implied warranty of
 *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *      GNU General Public License for more details.
 *
 *      You should have received a copy of the GNU General Public License
 *      along with YaBS.  If not, see <http://www.gnu.org/licenses/>.
 */
package mpv5.db.objects;

import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import javax.swing.JComponent;
import mpv5.db.common.Context;
import mpv5.db.common.DatabaseObject;
import mpv5.db.common.NodataFoundException;
import mpv5.db.common.QueryCriteria;
import mpv5.db.common.QueryHandler;
import mpv5.db.objects.Item;
import mpv5.logging.Log;
import mpv5.usermanagement.MPSecurityManager;
import mpv5.utils.date.DateConverter;
import mpv5.utils.date.vTimeframe;
import mpv5.utils.images.MPIcon;

/**
 *
 *  
 */
public class Schedule extends DatabaseObject {
    private static final long serialVersionUID = 1L;

    private int usersids = 4343;
    private int itemsids;
    private int contactsids;
    private Date nextdate = new Date();
    private Date stopdate = new Date();
    private Date startdate = new Date();
    private int intervalmonth = 1;
    private int eventtype = 0;
    private Item item;
    private boolean isdone;
    private Contact contact;

    public Schedule() {
       setContext(Context.getSchedule());
    }

    /**
     *
     * @return A vTimeframe object with this schedules day set
     */
    public vTimeframe getDate() {
        Calendar c = Calendar.getInstance();
        c.setTime(__getNextdate());
        c.add(Calendar.DAY_OF_MONTH, 1);
        vTimeframe t = new vTimeframe(__getNextdate(), new Date(c.getTimeInMillis() - 1));
        return t;
    }

    /**
     *
     * @return The item assigned to this schedule object
     * @throws mpv5.db.common.NodataFoundException
     */
    public Item getItem() throws NodataFoundException {
        if (item == null && __getItemsids() >= 0) {
            item = (Item) DatabaseObject.getObject(Context.getItem(), __getItemsids());
        }
        return item;
    }
    
        /**
     *
     * @return The item assigned to this schedule object
     * @throws mpv5.db.common.NodataFoundException
     */
    public Contact getContact() throws NodataFoundException {
        if (contact == null && __getContactsids() >= 0 ) {
            contact = (Contact) DatabaseObject.getObject(Context.getContact(), __getContactsids());
        }
        return contact;
    }

    /**
     *
     * @param date
     * @return
     */
    public static ArrayList<Schedule> getEvents(vTimeframe date) {
        Object[][] data = QueryHandler.instanceOf().clone(Context.getSchedule()).select("ids", null, "nextdate", date);
        ArrayList<Schedule> l = new ArrayList<Schedule>();
        for (int i = 0; i < data.length; i++) {
            Object[] objects = data[i];
            try {
                Schedule s = (Schedule) DatabaseObject.getObject(Context.getSchedule(), Integer.valueOf(objects[0].toString()));
                l.add(s);
            } catch (NodataFoundException ex) {
                Log.Debug(ex);
            }
        }
        return l;
    }

    /**
     *
     * @param date
     * @return
     */
    public static ArrayList<Schedule> getEvents2(vTimeframe date) {
        ArrayList<Schedule> l = new ArrayList<Schedule>();
        QueryCriteria criteria = new QueryCriteria("intervalmonth", 0);
        try {
            Object[][] data = QueryHandler.instanceOf().clone(Context.getSchedule()).select("IDS", criteria, date, "nextdate");
            for (int i = 0; i < data.length; i++) {
                Object[] objects = data[i];
                Schedule s = (Schedule) DatabaseObject.getObject(Context.getSchedule(), Integer.valueOf(objects[0].toString()));
                l.add(s);
            }
            return l;
        } catch (NodataFoundException ex) {
            Log.Debug(Schedule.class, ex.getMessage());
            return l;
        }
    }
    
    /**
     *
     * @param dataOwner
     * @return
     */
    public static ArrayList<Schedule> getEvents(Contact dataOwner) {
        ArrayList<Schedule> l = new ArrayList<Schedule>();
        if (dataOwner != null) {
            String query =
                    "SELECT ids FROM " + Context.getSchedule().getDbIdentity() +
                    " WHERE itemsids IN (SELECT ids FROM " +
                    Context.getItem().getDbIdentity() +
                    " WHERE contactsids = " + dataOwner.__getIDS() + ")";
            Object[][] data = QueryHandler.instanceOf().clone(Context.getSchedule()).freeSelectQuery(query, MPSecurityManager.VIEW, null).getData();

            for (int i = 0; i < data.length; i++) {
                Object[] objects = data[i];
                try {
                    Schedule s = (Schedule) DatabaseObject.getObject(Context.getSchedule(), Integer.valueOf(objects[0].toString()));
                    l.add(s);
                } catch (NodataFoundException ex) {
                    Log.Debug(ex);
                }
            }
        }
        return l;
    }

        /**
     *
     * @param dataOwner
     * @return
     */
    public static ArrayList<Schedule> getEvents2(Contact dataOwner) {
        ArrayList<Schedule> l = new ArrayList<Schedule>();
        Object[][] data;
        if (dataOwner != null) {
            QueryCriteria criteria = new QueryCriteria("contactsids", dataOwner.__getIDS());
            try {
                data = QueryHandler.instanceOf().clone(Context.getSchedule()).select("IDS", criteria);
                for (int i = 0; i < data.length; i++) {
                    Object[] objects = data[i];
                    try {
                        Schedule s = (Schedule) DatabaseObject.getObject(Context.getSchedule(), Integer.valueOf(objects[0].toString()));
                        l.add(s);
                    } catch (NodataFoundException ex) {
                        Log.Debug(ex);
                    }
                }
            } catch (NodataFoundException ex) {
                Log.Debug(Schedule.class, ex.getMessage());
            }
        }
        return l;
    }
    
    /**
     *
     * @param dataOwner 
     * @return
     */
    public static ArrayList<Schedule> getEvents(Item dataOwner) {
        ArrayList<Schedule> l = new ArrayList<Schedule>();
        if (dataOwner != null) {
            String query =
                    "SELECT ids FROM " + Context.getSchedule().getDbIdentity() +
                    " WHERE itemsids  = " + dataOwner.__getIDS();
            Object[][] data = QueryHandler.instanceOf().clone(Context.getSchedule()).freeSelectQuery(query, MPSecurityManager.VIEW, null).getData();

            for (int i = 0; i < data.length; i++) {
                Object[] objects = data[i];
                try {
                    Schedule s = (Schedule) DatabaseObject.getObject(Context.getSchedule(), Integer.valueOf(objects[0].toString()));
                    l.add(s);
                } catch (NodataFoundException ex) {
                    Log.Debug(ex);
                }
            }
        }
        return l;
    }

        /**
     *
     * @param dataOwner 
     * @return
     */
    public static ArrayList<Schedule> getEvents2(Item dataOwner) {
        ArrayList<Schedule> l = new ArrayList<Schedule>();
        Object[][] data;
        if (dataOwner != null) {
            QueryCriteria criteria = new QueryCriteria("itemsids", dataOwner.__getIDS());
            try {
                data = QueryHandler.instanceOf().clone(Context.getSchedule()).select("IDS", criteria);
                for (int i = 0; i < data.length; i++) {
                    Object[] objects = data[i];
                    try {
                        Schedule s = (Schedule) DatabaseObject.getObject(Context.getSchedule(), Integer.valueOf(objects[0].toString()));
                        if (s.__getIntervalmonth() >= 1) {
                            l.add(s);
                        }
                    } catch (NodataFoundException ex) {
                        Log.Debug(ex);
                    }
                }
            } catch (NodataFoundException ex) {
                Log.Debug(Schedule.class, ex.getMessage());
            }
        }
        return l;
    }
    
    /**
     *
     * @param day
     * @return
     */
    public static ArrayList<Schedule> getEvents(Date day) {
        return getEvents(new vTimeframe(day, new Date(DateConverter.addDay(day).getTime() - 1)));
    }

    public static ArrayList<Schedule> getEvents2(Date day) {
        return getEvents2(new vTimeframe(day, new Date(DateConverter.addDay(day).getTime() - 1)));
    }
    
    @Override
    public JComponent getView() {
        throw new UnsupportedOperationException("Not supported yet.");
    }

    /**
     * @return the usersids
     */
    public int __getUsersids() {
        return usersids;
    }

    /**
     * @param usersids the usersids to set
     */
    public void setUsersids(int usersids) {
        this.usersids = usersids;
    }

    /**
     * @return the itemsids
     */
    public int __getItemsids() {
        return itemsids;
    }

    /**
     * @param itemsids the itemsids to set
     */
    public void setItemsids(int itemsids) {
        this.itemsids = itemsids;
    }

    public int __getContactsids() {
        return contactsids;
    }

    public void setContactsids(int contactsids) {
        this.contactsids = contactsids;
    }

    public int __getEventtype() {
        return eventtype;
    }

    public void setEventtype(int eventtype) {
        this.eventtype = eventtype;
    }

    
    /**
     * @return the nextdate
     */
    public Date __getNextdate() {
        return nextdate;
    }

    /**
     * @param nextdate the nextdate to set
     */
    public void setNextdate(Date nextdate) {
        this.nextdate = nextdate;
    }

    /**
     * @return the intervalmonth
     */
    public int __getIntervalmonth() {
        return intervalmonth;
    }

    /**
     * @param intervalmonth the intervalmonth to set
     */
    public void setIntervalmonth(int intervalmonth) {
        this.intervalmonth = intervalmonth;
    }

    @Override
    public mpv5.utils.images.MPIcon getIcon() {
        if (!__getIsdone()) {
            return new MPIcon("/mpv5/resources/images/32/knewstuff.png");
        } else {
            return new MPIcon("/mpv5/resources/images/32/clean.png");
        }
    }
        
    /**
     * Array representation of this event.
     * <br/>{getItem(), intervalmonth, stopdate, user}
     * @return
     */
    @Override
    public Object[] toArray() {
        Object[] t = new Object[]{this, intervalmonth, DateConverter.getDefDateString(stopdate),
            User.getUsername(usersids)};
        return t;
    }

    /**
     * @return the stopdate
     */
    public Date __getStopdate() {
        return stopdate;
    }

    /**
     * @param stopdate the stopdate to set
     */
    public void setStopdate(Date stopdate) {
        this.stopdate = stopdate;
    }

    /**
     * @return the startdate
     */
    public Date __getStartdate() {
        return startdate;
    }

    /**
     * @param startdate the startdate to set
     */
    public void setStartdate(Date startdate) {
        this.startdate = startdate;
    }

    /**
     * @return the isdone
     */
    public boolean __getIsdone() {
        return isdone;
    }

    /**
     * @param isdone the isdone to set
     */
    public void setIsdone(boolean isdone) {
        this.isdone = isdone;
    }
}