Bestellung.java

/*******************************************************************************
 * Copyright (c) 2006-2016, G. Weirich and Elexis
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *    G. Weirich - initial implementation
 *    M. Descher - orders are now persisted into own table 
 *    MEDEVIT - major refactoring to fit multi stock changes
 *******************************************************************************/

package ch.elexis.data;

import java.lang.reflect.InvocationTargetException;
import java.util.Comparator;
import java.util.List;

import org.eclipse.core.runtime.IProgressMonitor;

import ch.elexis.core.constants.Preferences;
import ch.elexis.core.constants.StringConstants;
import ch.elexis.core.data.activator.CoreHub;
import ch.elexis.core.data.util.IRunnableWithProgress;
import ch.elexis.core.jdt.Nullable;
import ch.elexis.core.model.IOrder;
import ch.elexis.core.model.IOrderEntry;
import ch.elexis.core.model.IStock;
import ch.rgw.tools.TimeTool;

public class Bestellung extends PersistentObject implements IOrder {
	
	public static final String TABLENAME = "BESTELLUNGEN";
	
	public static final String FLD_DATE = "DATUM";
	public static final String FLD_JOINT_BESTELLUNGEN_ENTRIES = "BESTELLUNGEN_ENTRIES";
	
	/** Deprecated - will be removed in 3.3 (https://redmine.medelexis.ch/issues/5204) **/
	@Deprecated
	public static final String FLD_ITEMS = "Liste";
	/**/
	
	public enum ListenTyp {
			PHARMACODE, NAME, VOLL
	};
	
	static {
		addMapping(TABLENAME, FLD_ITEMS + "=S:C:Contents", //$NON-NLS-1$
			FLD_JOINT_BESTELLUNGEN_ENTRIES + "=LIST:BESTELLUNG:" + BestellungEntry.TABLENAME);
		
		transferAllOrdersToNew32OrderModel();
	}
	
	@Override
	protected String getTableName(){
		return TABLENAME;
	}
	
	/**
	 * @deprecated to be removed in 3.3
	 * @see https://redmine.medelexis.ch/issues/5204
	 */
	private static void transferAllOrdersToNew32OrderModel(){
		if (!CoreHub.globalCfg.get("OrdersMigratedTo32", false)) {
			IRunnableWithProgress irwp = new IRunnableWithProgress() {
				
				@Override
				public void run(IProgressMonitor monitor)
					throws InvocationTargetException, InterruptedException{
					
					Stock defStock = Stock.load(Stock.DEFAULT_STOCK_ID);
					
					List<Bestellung> orders = new Query<Bestellung>(Bestellung.class).execute();
					for (Bestellung order : orders) {
						String[] it =
							checkNull(order.get(FLD_ITEMS)).split(StringConstants.SEMICOLON);
						for (String i : it) {
							String[] fld = i.split(StringConstants.COMMA);
							if (fld.length == 2) {
								Artikel art = Artikel.load(fld[0]);
								if (art == null || !art.exists()) {
									PersistentObject poFromString =
										CoreHub.poFactory.createFromString(fld[0]);
									if (poFromString != null) {
										art = (Artikel) poFromString;
									}
								}
								if (art != null && art.exists()) {
									int count = 1;
									try {
										count = Integer.parseInt(fld[1]);
									} catch (NumberFormatException nfe) {}
									
									String providerId = art.get(Artikel.LIEFERANT_ID);
									Kontakt provider = null;
									if (providerId != null && providerId.length() > 0) {
										Kontakt load = Kontakt.load(providerId);
										if (load.exists()) {
											provider = load;
										}
									}
									new BestellungEntry(order, art, defStock, provider, count);
								} else {
									log.warn(
										"Article for 'Bestellung' not found via [" + fld[0] + "]");
								}
							}
						}
						order.set(FLD_ITEMS, null);
					}
					
					CoreHub.globalCfg.set("OrdersMigratedTo32", true);
					CoreHub.globalCfg.flush();
				}
			};
			PersistentObject.cod.showProgress(irwp);
		}
		
	}
	
	public static Bestellung load(String id){
		return new Bestellung(id);
	}
	
	protected Bestellung(){}
	
	protected Bestellung(String id){
		super(id);
	}
	
	public Bestellung(String name, Anwender an){
		TimeTool t = new TimeTool();
		create(name + StringConstants.COLON + t.toString(TimeTool.TIMESTAMP) + StringConstants.COLON
			+ an.getId());
	}
	
	@Override
	public String getLabel(){
		String[] i = getId().split(StringConstants.COLON);
		TimeTool t = new TimeTool(i[1]);
		return i[0] + ": " + t.toString(TimeTool.FULL_GER); //$NON-NLS-1$
	}
	
	@Override
	public IOrderEntry addEntry(Object article, IStock stock, Object provider, int num){
		return addBestellungEntry(((Artikel) article), ((Stock) stock), ((Kontakt) provider), num);
	}
	
	public BestellungEntry addBestellungEntry(Artikel article, Stock stock, Kontakt provider,
		int num){
		
		if (provider == null) {
			String providerId =
				CoreHub.globalCfg.get(Preferences.INVENTORY_DEFAULT_ARTICLE_PROVIDER, null);
			if (providerId != null) {
				Kontakt defProvider = Kontakt.load(providerId);
				if (defProvider.exists()) {
					provider = defProvider;
				}
			}
		}
		
		BestellungEntry i = findBestellungEntry(stock, article);
		if (i != null) {
			int count = i.getCount();
			count = count += num;
			i.setCount(count);
		} else {
			i = new BestellungEntry(this, article, stock, provider, num);
		}
		return i;
	}
	
	public @Nullable BestellungEntry findBestellungEntry(@Nullable Stock stock, Artikel article){
		Query<BestellungEntry> qbe = new Query<BestellungEntry>(BestellungEntry.class);
		qbe.add(BestellungEntry.FLD_BESTELLUNG, Query.EQUALS, getId());
		qbe.add(BestellungEntry.FLD_ARTICLE_ID, Query.EQUALS, article.getId());
		qbe.add(BestellungEntry.FLD_ARTICLE_TYPE, Query.EQUALS, article.getClass().getName());
		if (stock != null) {
			qbe.add(BestellungEntry.FLD_STOCK, Query.EQUALS, stock.getId());
		}
		
		List<BestellungEntry> result = qbe.execute();
		if (result.size() > 0) {
			return result.get(0);
		}
		return null;
	}
	
	public static class BestellungDateComparator implements Comparator<Bestellung> {
		private TimeTool t1 = new TimeTool();
		private TimeTool t2 = new TimeTool();
		
		@Override
		public int compare(Bestellung b1, Bestellung b2){
			setTimeTool((Bestellung) b1, t1);
			setTimeTool((Bestellung) b2, t2);
			if (t1.after(t2))
				return -1;
			if (t2.after(t1))
				return 1;
			return 0;
		}
		
		private void setTimeTool(Bestellung bestellung, TimeTool timeTool){
			try {
				String[] i = bestellung.getId().split(StringConstants.COLON);
				timeTool.set(i[1]);
			} catch (Exception e) {
				timeTool.set("1.1.1970");
			}
		}
		
	}
	
	public List<BestellungEntry> getEntries(){
		List<BestellungEntry> execute = new Query<BestellungEntry>(BestellungEntry.class,
			BestellungEntry.FLD_BESTELLUNG, getId()).execute();
		return execute;
	}
	
	public static void markAsOrdered(List<BestellungEntry> list){
		for (BestellungEntry item : list) {
			item.setState(BestellungEntry.STATE_ORDERED);
		}
	}
	
	public void removeEntry(BestellungEntry entry){
		entry.removeFromDatabase();
	}
}