/*
 *  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.Arrays;
import mpv5.db.common.Triggerable;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
import java.util.Date;
import java.util.HashMap;
import java.util.LinkedList;
import java.util.List;
import javax.swing.JButton;
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.globals.Constants;
import mpv5.globals.GlobalSettings;
import mpv5.globals.Headers;
import mpv5.handler.VariablesHandler;
import mpv5.logging.Log;
import mpv5.ui.panels.ItemPanel;
import mpv5.utils.models.MPComboBoxModelItem;
import mpv5.utils.models.MPTableModel;
import mpv5.utils.numberformat.FormatNumber;

/**
 *
 *  
 */
public final class SubItem extends DatabaseObject implements Triggerable {

    public static final int TYPE_TEXT = 1;
    public static final int TYPE_PRODUCT = 2;
    public static final int TYPE_NORMAL = 0;
    private static final long serialVersionUID = 1L;

    public static LinkedList<SubItem> saveModel(Item dataOwner, MPTableModel model, boolean deleteRemovedSubitems, boolean cloneSubitems) {
        List<Object[]> rowsl = model.getValidRows(new int[]{4});
        LinkedList<SubItem> items = new LinkedList<SubItem>();
        Log.Debug(SubItem.class, "Rows found: " + rowsl.size());
        for (int i = 0; i < rowsl.size(); i++) {
            Object[] row = rowsl.get(i);
            for (int j = 0; j < row.length; j++) {
                if (row[j] == null) {
                    row[j] = "";
                }
            }
            SubItem it = new SubItem();
            it.setOrdernr(i);
            Log.Print(Arrays.asList(row));
            try {
                if (!cloneSubitems && row[0] != null && Integer.valueOf(row[0].toString()).intValue() > 0) {
                    it.setIDS(Integer.valueOf(row[0].toString()).intValue());
                } else {
                    it.setIDS(-1);
                }
            } catch (Exception e) {
                Log.Debug(SubItem.class, e.getMessage());
            }
            it.setCname(row[14].toString());
            it.setItemsids(dataOwner.__getIDS());
            it.setCountvalue(new BigDecimal(row[1].toString()));
            it.setDatedelivery(dataOwner.__getDatetodo());
            it.setDescription(row[4].toString());
            it.setExternalvalue(new BigDecimal(row[5].toString()));
            it.setInternalvalue(new BigDecimal(row[5].toString()));//not supported yet
            it.setMeasure(row[3].toString());

            if (row[10] instanceof Product) {
                try {
                    it.setOriginalproductsids(((Product) row[10]).__getIDS());
                } catch (Exception e) {
                    Log.Debug(e);
                }
            } else {
            }
            it.setLinkurl((row[12 + 1].toString()));
            it.setQuantityvalue(new BigDecimal(row[2].toString()));
            it.setTaxpercentvalue(new BigDecimal(row[6].toString()));
            it.setDiscount(new BigDecimal(row[15].toString()));
            calculate(it);

            if (!it.isExisting()) {
                it.setDateadded(new Date());
                it.setGroupsids(dataOwner.__getGroupsids());
            }
            it.save(true);
            items.add(it.getOrdernr(), it);
        }

        if (deleteRemovedSubitems) {
            for (int i = 0; i < deletionQueue.size(); i++) {
                try {
                    QueryHandler.delete(SubItem.getObject(Context.getSubItem(), deletionQueue.get(i)));
                } catch (NodataFoundException ex) {
                    Log.Debug(ex);
                }
            }
        }
        deletionQueue.clear();
        return items;

    }

    /**
     * Save the model of SubItems
     * @param dataOwner
     * @param model
     * @param deleteRemovedSubitems
     * @return
     */
    public static List<SubItem> saveModel(Item dataOwner, MPTableModel model, boolean deleteRemovedSubitems) {
        return saveModel(dataOwner, model, deleteRemovedSubitems, false);
    }

    /**
     * Convert the model to a list of String arrays
     * @param dataOwner
     * @param model
     * @param t
     * @return
     */
    public static LinkedList<String[]> convertModel(Item dataOwner, MPTableModel model, Template t) {
        List<Object[]> rowsl = model.getValidRows(new int[]{4});
        LinkedList<String[]> rowsk = new LinkedList<String[]>();
        Log.Debug(SubItem.class, "Rows found: " + rowsl.size());
        for (int i = 0; i < rowsl.size(); i++) {
            Object[] row = rowsl.get(i);

            for (int j = 0; j < row.length; j++) {
                if (row[j] == null) {
                    row[j] = "";
                }
            }

            final SubItem it = new SubItem();
            it.setOrdernr(i);
            try {
                if (row[0] != null && Integer.valueOf(row[0].toString()).intValue() > 0) {
                    it.setIDS(Integer.valueOf(row[0].toString()).intValue());
                } else {
                    it.setIDS(-1);
                }
            } catch (Exception e) {
                Log.Debug(SubItem.class, e.getMessage());
            }
            it.setCname(row[14].toString());
            it.setItemsids(dataOwner.__getIDS());
            it.setCountvalue(new BigDecimal(row[1].toString()));
            it.setDatedelivery(dataOwner.__getDatetodo());
            it.setDescription(row[4].toString());
            it.setExternalvalue(new BigDecimal(row[5].toString()));
            it.setInternalvalue(new BigDecimal(row[5].toString()));//not supported yet
            it.setMeasure(row[3].toString());
            it.setOriginalproductsids(Integer.valueOf(row[10].toString()));
            if (row[10] instanceof Product) {
                try {
                    it.setOriginalproductsids(((Product) row[10]).__getIDS());
                } catch (Exception e) {
                    Log.Debug(e);
                }
            }
            it.setQuantityvalue(new BigDecimal(row[2].toString()));
            it.setTaxpercentvalue(new BigDecimal(row[6].toString()));
            it.setLinkurl((row[12 + 1].toString()));
            it.setDiscount(new BigDecimal(row[15].toString()));

            calculate(it);

            if (!it.isExisting()) {
                it.setDateadded(new Date());
                it.setGroupsids(dataOwner.__getGroupsids());
            }

//            it.save();
            rowsk.add(it.getOrdernr(), it.toStringArray());
        }

        return rowsk;
    }
    private static List<Integer> deletionQueue = new ArrayList<Integer>();

    /**
     * Mark a subitem for deletion
     * @param valueAt INT or Entity
     */
    public static void addToDeletionQueue(Object valueAt) {
        Log.Debug(SubItem.class, "Adding to deletionqueue: " + valueAt);
        if (valueAt != null) {
            try {
                Integer isd = Integer.valueOf(valueAt.toString());
                deletionQueue.add(isd);
            } catch (NumberFormatException numberFormatException) {
                Integer isd = ((Entity) valueAt).getValue();
                deletionQueue.add(isd);
            }
        }
    }

    /**
     * UN-Mark a subitem for deletion
     * @param valueAt INT or Entity
     */
    public static void removeFromDeletionQueue(Object valueAt) {
        Log.Debug(SubItem.class, "Removing from deletionqueue: " + valueAt);
        if (valueAt != null) {
            try {
                Integer isd = Integer.valueOf(valueAt.toString());
                deletionQueue.remove(isd);
            } catch (NumberFormatException numberFormatException) {
                Integer isd = ((Entity) valueAt).getValue();
                deletionQueue.add(isd);
            }
        }
    }
    private int itemsids;
    private int ordernr;
    private int inttype;
    private int originalproductsids;
    private BigDecimal countvalue = BigDecimal.ZERO;
    private BigDecimal quantityvalue = BigDecimal.ZERO;
    private String measure = "";
    private String description = "";
    private String linkurl = "";
    private BigDecimal internalvalue = BigDecimal.ZERO;
    private BigDecimal externalvalue = BigDecimal.ZERO;
    private BigDecimal taxpercentvalue = BigDecimal.ZERO;
    private BigDecimal totalnetvalue = BigDecimal.ZERO;
    private BigDecimal totalbrutvalue = BigDecimal.ZERO;
    private Date datedelivery;
    private BigDecimal totaltaxvalue = BigDecimal.ZERO;
    private BigDecimal discount = BigDecimal.ZERO;
    private BigDecimal discvalue = BigDecimal.ZERO;

    public SubItem() {
        setContext(Context.getSubItem());
    }

    /**
     *
     * @return
     */
    public static SubItem getDefaultItem() {
        SubItem i = new SubItem();

        if (mpv5.db.objects.User.getCurrentUser().getProperties().hasProperty("defunit")) {
            String defunit = mpv5.db.objects.User.getCurrentUser().getProperties().getProperty("defunit");
            i.setMeasure(defunit);
        }
        BigDecimal deftax = BigDecimal.ZERO;
        if (mpv5.db.objects.User.getCurrentUser().getProperties().hasProperty("deftax")) {
            int taxid = mpv5.db.objects.User.getCurrentUser().getProperties().getProperty("deftax", new Integer(0));
            deftax = Tax.getTaxValue(taxid);
        }
        i.setTaxpercentvalue(deftax);

        BigDecimal defdiscount = BigDecimal.ZERO;
        if (mpv5.db.objects.User.getCurrentUser().getProperties().hasProperty("defdiscount")) {
            defdiscount = new BigDecimal(mpv5.db.objects.User.getCurrentUser().getProperties().getProperty("defdiscount"));
        }
        i.setDiscount(defdiscount);

        if (mpv5.db.objects.User.getCurrentUser().getProperties().hasProperty("defcount")) {
            Double defcount = mpv5.db.objects.User.getCurrentUser().getProperties().getProperty("defcount", 0d);
            i.setQuantityvalue(new BigDecimal(defcount.toString()));
        } else {
            i.setQuantityvalue(BigDecimal.ONE);
        }

        return i;
    }

    /**
     *
     * @param product 
     */
    public SubItem(Product product) {
        this();
        setCname(product.__getCname());
        setDateadded(new Date());
        setDatedelivery(new Date());

////////////////format///////////////////////////////////////////////////////////
        Context contextl = product.getContext();
        String params = "cname";
        String vars = null;
        if (mpv5.db.objects.User.getCurrentUser().getProperties().hasProperty(contextl + mpv5.ui.beans.LightMPComboBox.VALUE_SEARCHFIELDS)
                && mpv5.db.objects.User.getCurrentUser().getProperties().getProperty(contextl + mpv5.ui.beans.LightMPComboBox.VALUE_SEARCHFIELDS).contains("_$")) {
            try {
                params = "ids";
                vars = mpv5.db.objects.User.getCurrentUser().getProperties().getProperty(contextl + mpv5.ui.beans.LightMPComboBox.VALUE_SEARCHFIELDS);
                String[] vaars = vars.split("_\\$");

                for (int i = 0; i < vaars.length; i++) {
                    try {
                        if (vaars[i] != null && vaars[i].contains("$_")) {
                            params += "," + vaars[i].split("\\$_")[0].replace(",", "").replace("'", "`");
                        }
                    } catch (Exception e) {
                        Log.Debug(e);
                    }
                }

                QueryCriteria qc = new QueryCriteria("ids", product.__getIDS());
                Object[][] result = QueryHandler.instanceOf().clone(Context.getProduct()).select(params, qc);

                String formatString = vars;
                if (formatString != null) {
                    vaars = formatString.split("_\\$");
                    Log.Debug(MPComboBoxModelItem.class, "Length of var string: " + vaars.length);
                }
                String x = "";
                String format = formatString;
                for (int j = 1; j < result[0].length; j++) {
                    String k = String.valueOf(result[0][j]);
                    if (format == null) {
                        x += k;
                    } else {
                        try {
                            format = format.replaceFirst("_\\$(.*?)\\$_", k);
                        } catch (Exception e) {
                            Log.Debug(e);
                        }
                        x = format;
                    }
                }

                setDescription(VariablesHandler.parse(x, product));
            } catch (NodataFoundException nodataFoundException) {
                setDescription(VariablesHandler.parse(product.__getCname(), product));
            }
        } else {
            Log.Debug(SubItem.class, "No format defined..");
            setDescription(VariablesHandler.parse(product.__getCname(), product));
        }
///////////////end format////////////////////////////////////////////////////////
        setExternalvalue(product.findPriceFor(1d));
        setGroupsids(mpv5.db.objects.User.getCurrentUser().__getGroupsids());
        setIntaddedby(mpv5.db.objects.User.getCurrentUser().__getIDS());
        setInternalvalue(product.__getInternalnetvalue());
        setMeasure(product.__getMeasure());
        setOriginalproductsids(product.__getIDS());
        setQuantityvalue(BigDecimal.ONE);
        setTaxpercentvalue(Tax.getTaxValue(product.__getTaxids()));
        setLinkurl(product.__getUrl());
        calculate(this);
    }

    /**
     * Generates a SubItem with useless sample data
     * @return
     */
    public static SubItem getRandomItem() {
        SubItem i = new SubItem();
        i.fillSampleData();
        i.setGroupsids(1);
        if (mpv5.db.objects.User.getCurrentUser().getProperties().hasProperty("defunit")) {
            String defunit = mpv5.db.objects.User.getCurrentUser().getProperties().getProperty("defunit");
            i.setMeasure(defunit);
        }
        BigDecimal deftax = BigDecimal.ZERO;
        if (mpv5.db.objects.User.getCurrentUser().getProperties().hasProperty("deftax")) {
            int taxid = mpv5.db.objects.User.getCurrentUser().getProperties().getProperty("deftax", 0);
            deftax = Tax.getTaxValue(taxid);
            i.setTaxpercentvalue(deftax);
        }
        Double defcount = 1d;
        if (mpv5.db.objects.User.getCurrentUser().getProperties().hasProperty("defcount")) {
            defcount = mpv5.db.objects.User.getCurrentUser().getProperties().getProperty("defcount", 0d);
            i.setQuantityvalue(new BigDecimal(defcount.toString()));
        }
        return i;
    }

    /**
     * Generates a String array out of this SubItem
     * @return
     */
    public synchronized String[] toStringArray() {
        calculate(this);

        List<String> all = new LinkedList<String>();

        String[] possibleCols = new String[]{
            ////////////////// The exported columns///////////////////////////////////////
            getInttype() != TYPE_TEXT ? String.valueOf(FormatNumber.formatInteger(this.__getCountvalue())) : "",
            getInttype() != TYPE_TEXT ? String.valueOf(FormatNumber.formatDezimal(this.__getQuantityvalue())) : "",
            getInttype() != TYPE_TEXT ? __getMeasure() : "",
            __getDescription(),
            getInttype() != TYPE_TEXT ? String.valueOf(FormatNumber.formatLokalCurrency(this.__getExternalvalue())) : "",
            getInttype() != TYPE_TEXT ? String.valueOf(FormatNumber.formatLokalCurrency(this.__getTotalnetvalue())) : "",
            getInttype() != TYPE_TEXT ? String.valueOf(FormatNumber.formatPercent(this.__getTaxpercentvalue())) : "",
            getInttype() != TYPE_TEXT ? String.valueOf(FormatNumber.formatLokalCurrency(this.getTotalTaxValue())) : "",
            getInttype() != TYPE_TEXT ? String.valueOf(FormatNumber.formatLokalCurrency(this.__getTotalbrutvalue())) : "",
            __getLinkurl(),
            __getCname()
        ///////////////////////////////////////////////////////////////////////////////
        };
        List<String> l = Arrays.asList(possibleCols);
        all.addAll(l);

        if (GlobalSettings.getBooleanProperty("org.openyabs.exportproperty.productsresolved", false) && __getOriginalproductsids() > 0) {
            try {
                Product p = (Product) DatabaseObject.getObject(Context.getProduct(), __getOriginalproductsids());
                List<String[]> vals = p.getValues3();
                Collections.sort(vals, new Comparator<String[]>() {

                    public int compare(String[] o1, String[] o2) {
                        return o1[0].compareTo(o2[0]);
                    }
                });
                for (int i = 0; i < vals.size(); i++) {
                    String[] v = vals.get(i);
                    all.add(v[1]);
                    if (Log.getLoglevel() == Log.LOGLEVEL_DEBUG) {
                        Log.Debug(this, (12 + i) + ": " + v[0] + " ");
                    }
                }
            } catch (Exception ex) {
                Log.Debug(ex);
            }
        }

        return all.toArray(new String[0]);
    }


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

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

    /**
     * @return the originalproductsids
     */
    public int __getOriginalproductsids() {
        return originalproductsids;
    }

    /**
     * @param originalproductsids the originalproductsids to set
     */
    public void setOriginalproductsids(int originalproductsids) {
        this.originalproductsids = originalproductsids;
        if (originalproductsids > 0) {
            setInttype(TYPE_PRODUCT);
        } else {
            setInttype(TYPE_NORMAL);
        }
    }

    /**
     * @return the count
     */
    public BigDecimal __getCountvalue() {
        return countvalue;
    }

    /**
     * @param count the count to set
     */
    public void setCountvalue(BigDecimal count) {
        this.countvalue = count;
    }

    /**
     * @return the quantity
     */
    public BigDecimal __getQuantityvalue() {
        return quantityvalue;
    }

    /**
     * @param quantity the quantity to set
     */
    public void setQuantityvalue(BigDecimal quantity) {
        this.quantityvalue = quantity;
        if (quantity.compareTo(BigDecimal.ZERO) == 0) {
            setInttype(TYPE_TEXT);
        }
    }

    /**
     * @return the measure
     */
    public String __getMeasure() {
        return measure;
    }

    /**
     * @param measure the measure to set
     */
    public void setMeasure(String measure) {
        this.measure = measure;
    }

    /**
     * @return the description
     */
    public String __getDescription() {
        return description;
    }

    /**
     * @param description the description to set
     */
    public void setDescription(String description) {
        this.description = description;
    }

    /**
     * @return the taxpercent
     */
    public BigDecimal __getTaxpercentvalue() {
        return taxpercentvalue;
    }

    /**
     * @param taxpercent the taxpercent to set
     */
    public void setTaxpercentvalue(BigDecimal taxpercent) {
        this.taxpercentvalue = taxpercent;
    }

    /**
     * @return the datedelivery
     */
    public Date __getDatedelivery() {
        return datedelivery;
    }

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

    /**
     * 
     * @return 
     */
    public BigDecimal __getDiscount() {
        return discount;
    }

    /**
     * 
     * @param discount 
     */
    public void setDiscount(BigDecimal discount) {
        this.discount = discount;
    }

    public BigDecimal getDiscvalue() {
        return discvalue;
    }

    public void defDiscvalue(BigDecimal discvalue) {
        this.discvalue = discvalue;
    }

    @Override
    public JComponent getView() {
        try {
            Item dos = (Item) DatabaseObject.getObject(Context.getItem(), __getItemsids());
            ItemPanel ip = new ItemPanel(Context.getItem(), dos.__getInttype());
            return ip;
        } catch (NodataFoundException ex) {
            throw new RuntimeException(ex);
        }
    }

    @Override
    public mpv5.utils.images.MPIcon getIcon() {
        return null;
    }

    /**
     * Generates a table model out of the given SubItems
     * @param items
     * @return
     */
    public static MPTableModel toModel(SubItem[] items) {
        return toModel(items, false);
    }
    /**
     * The ADD button index
     */
    public static int COLUMNINDEX_ADD = 11;
    /**
     * The CLEAR button index
     */
    public static int COLUMNINDEX_REMOVE = 12;
    /**
     * Compares by ordernr
     */
    public static Comparator<SubItem> ORDER_COMPARATOR = new Comparator<SubItem>() {

        @Override
        public int compare(SubItem o1, SubItem o2) {
            return (o1.getOrdernr() > o2.getOrdernr()) ? 1 : -1;
        }
    };

    /**
     * Generates a table model out of the given SubItems
     * @param items
     * @param removeSubitemIds
     * @return
     */
    public static MPTableModel toModel(SubItem[] items, boolean removeSubitemIds) {
        //"Internal ID", "ID", "Count", "Measure", "Description", "Netto Price", "Tax Value", "Total Price"
        Object[][] data = new Object[items.length][];
        List<SubItem> tlist = new LinkedList<SubItem>();
        tlist.addAll(Arrays.asList(items));
        Collections.sort(tlist, SubItem.ORDER_COMPARATOR);

        for (int i = 0; i < tlist.size(); i++) {
            SubItem subItem = tlist.get(i);
            if (subItem != null) {
                data[i] = subItem.getRowData(i + 1);
            } else {
                data[i] = getDefaultItem().getRowData(i + 1);
            }
            if (removeSubitemIds) {
                data[i][0] = -1;
            }
        }


        MPTableModel model = new MPTableModel(
                new Class[]{
                    Integer.class, Integer.class, BigDecimal.class, String.class, Object.class, BigDecimal.class, BigDecimal.class, BigDecimal.class,
                    BigDecimal.class, BigDecimal.class, Product.class, JButton.class, JButton.class, String.class, String.class, BigDecimal.class, BigDecimal.class},
                new boolean[]{false, false, true, true, true, true, true, false, false, false, false, true, true, true, true, true, true, true},
                data,
                Headers.SUBITEMS.getValue());

        model.setContext(Context.getSubItem());
        String defunit = null;
        if (mpv5.db.objects.User.getCurrentUser().getProperties().hasProperty("defunit")) {
            defunit = mpv5.db.objects.User.getCurrentUser().getProperties().getProperty("defunit");
        }
        BigDecimal deftax = BigDecimal.ZERO;
        if (mpv5.db.objects.User.getCurrentUser().getProperties().hasProperty("deftax")) {
            int taxid = mpv5.db.objects.User.getCurrentUser().getProperties().getProperty("deftax", 0);
            deftax = Tax.getTaxValue(taxid);
        }
        Double defcount = 1d;
        if (mpv5.db.objects.User.getCurrentUser().getProperties().hasProperty("defcount")) {
            defcount = mpv5.db.objects.User.getCurrentUser().getProperties().getProperty("defcount", 0d);
        }
        model.defineRow(new Object[]{0, 0, defcount, defunit, null, 0.0, deftax, 0.0, 0.0, 0.0, null, "A", "C", "", "", 0.0, 0.0});
        model.setAutoCountColumn(1);

        return model;
    }

    /**
     * Turn this SubItem into table row data
     * @param row
     * @return
     */
    public synchronized Object[] getRowData(int row) {
        Object[] data = new Object[17];
        for (int i = 0; i < data.length; i++) {
            data[0] = __getIDS();
            data[1] = Integer.valueOf(row);
            data[2] = __getQuantityvalue();
            data[3] = __getMeasure();
            data[4] = __getDescription();
            data[5] = __getExternalvalue();
            data[6] = __getTaxpercentvalue();
            data[7] = __getQuantityvalue().multiply(__getExternalvalue().multiply(((__getTaxpercentvalue().divide(Constants.BD100, 9, BigDecimal.ROUND_HALF_UP).add(BigDecimal.ONE)))));
            data[8] = 0.0;
            data[9] = 0.0;
            if (__getOriginalproductsids() > 0) {
                try {
                    data[10] = Product.getObject(Context.getProduct(), __getOriginalproductsids());
                } catch (NodataFoundException ex) {
                    Log.Debug(ex);
                }
            }
            data[11] = "A";
            data[12] = "C";
            data[12 + 1] = __getLinkurl();
            data[14] = __getCname();
            data[15] = __getDiscount();
            data[16] = 0.0;
        }
        return data;
    }

    /**
     * Turn this SubItem into table row data
     * @param row
     * @return
     */
    public static synchronized SubItem getFromModel(MPTableModel m, int row) {
        SubItem t = new SubItem();

        if (m.getValueAt(row, 0) != null) {
            t.setIDS(Integer.valueOf(m.getValueAt(row, 0).toString()));
        }
        if (m.getValueAt(row, 1) != null) {
            t.setCountvalue(new BigDecimal(m.getValueAt(row, 1).toString()));
        }
        if (m.getValueAt(row, 2) != null) {
            t.setQuantityvalue(new BigDecimal(m.getValueAt(row, 2).toString()));
        }
        if (m.getValueAt(row, 3) != null) {
            t.setMeasure(m.getValueAt(row, 3).toString());
        }
        if (m.getValueAt(row, 4) != null) {
            t.setDescription(m.getValueAt(row, 4).toString());
        }
        if (m.getValueAt(row, 5) != null) {
            t.setExternalvalue(new BigDecimal(m.getValueAt(row, 5).toString()));
        }
        if (m.getValueAt(row, 6) != null) {
            t.setTaxpercentvalue(new BigDecimal(m.getValueAt(row, 6).toString()));
        }
        if (m.getValueAt(row, 10) != null) {
            try {
                t.setOriginalproductsids(((Product) m.getValueAt(row, 10)).__getIDS());
            } catch (Exception e) {
                Log.Debug(e);
            }
        }
        if (m.getValueAt(row, 13) != null) {
            t.setLinkurl(m.getValueAt(row, 13).toString());
        }
        if (m.getValueAt(row, 14) != null) {
            t.setCname(m.getValueAt(row, 14).toString());
        }
        if (m.getValueAt(row, 15) != null) {
            t.setDiscount(new BigDecimal(m.getValueAt(row, 15).toString()));
        }

        return t;
    }

    /**
     * @return the internalvalue
     */
    public BigDecimal __getInternalvalue() {
        return internalvalue;
    }

    /**
     * @param internalvalue the internalvalue to set
     */
    public void setInternalvalue(BigDecimal internalvalue) {
        this.internalvalue = internalvalue;
    }

    /**
     * @return the externalvalue
     */
    public BigDecimal __getExternalvalue() {
        return externalvalue;
    }

    /**
     * @param externalvalue the externalvalue to set
     */
    public void setExternalvalue(BigDecimal externalvalue) {
        this.externalvalue = externalvalue;
    }

    @Override
    public HashMap<String, Object> resolveReferences(HashMap<String, Object> map) {

        if (map.containsKey("originalproductsids")) {
            try {
                try {
                    map.put("originalproduct", DatabaseObject.getObject(Context.getProduct(), Integer.valueOf(map.get("originalproductsids").toString())));
                    map.remove("originalproductsids");
                } catch (NodataFoundException ex) {
                    map.put("originalproduct", null);
                }
            } catch (NumberFormatException numberFormatException) {
                //already resolved?
            }
        }

        return super.resolveReferences(map);
    }

    /**
     * @return the totalnetvalue
     */
    public BigDecimal __getTotalnetvalue() {
        return totalnetvalue;
    }

    /**
     * @param totalnetvalue the totalnetvalue to set
     */
    public void setTotalnetvalue(BigDecimal totalnetvalue) {
        this.totalnetvalue = totalnetvalue;
    }

    /**
     * @return the totalbrutvalue
     */
    public BigDecimal __getTotalbrutvalue() {
        return totalbrutvalue;
    }

    /**
     * @param totalbrutvalue the totalbrutvalue to set
     */
    public void setTotalbrutvalue(BigDecimal totalbrutvalue) {
        this.totalbrutvalue = totalbrutvalue;
    }

    static void calculate(SubItem s) {
        BigDecimal disc = s.__getDiscount().divide(BD100, 9, BigDecimal.ROUND_HALF_UP);
        s.setTotalbrutvalue(s.quantityvalue.multiply(s.externalvalue.multiply(((s.taxpercentvalue.divide(Constants.BD100, 9, BigDecimal.ROUND_HALF_UP)).add(BigDecimal.ONE)))));
        s.setTotalbrutvalue(s.totalbrutvalue.subtract(s.totalbrutvalue.multiply(disc)));
        s.defTotaltaxvalue(s.quantityvalue.multiply(s.externalvalue.multiply((s.taxpercentvalue.divide(Constants.BD100, 9, BigDecimal.ROUND_HALF_UP)))));
        s.defTotaltaxvalue(s.totaltaxvalue.subtract(s.totaltaxvalue.multiply(disc)));
        s.setTotalnetvalue(s.quantityvalue.multiply(s.externalvalue));
        s.defDiscvalue(s.totalnetvalue.multiply(disc));
    }

    @Override
    public boolean save() {
        calculate(this);
        return super.save();
    }

    private void defTotaltaxvalue(BigDecimal value) {
        totaltaxvalue = value;
    }

    /**
     * 
     * @return
     */
    public BigDecimal getTotalTaxValue() {
        return totaltaxvalue;
    }

    /**
     * @return the linkurl
     */
    public String __getLinkurl() {
        return linkurl;
    }

    /**
     * @param linkurl the linkurl to set
     */
    public void setLinkurl(String linkurl) {
        this.linkurl = linkurl;
    }

    @Override
    public boolean save(boolean b) {
        if (getCname().length() == 0) {
            setCname("   ");
        }
        return super.save(b);
    }

    @Override
    public void triggerOnCreate() {
        if (__getOriginalproductsids() > 0) {
            try {
                Product p = (Product) DatabaseObject.getObject(Context.getProduct(), originalproductsids);
                if (p.__getIntinventorytype() == 1) {
                    p.setStockvalue(p.__getStockvalue().subtract(__getQuantityvalue()));
                    p.save(true);
                }
            } catch (NodataFoundException ex) {
                Log.Debug(this, ex.getMessage());//jemand hats gel??scht:-/
                originalproductsids = -1;
                save(true);
            }
        }
    }

    @Override
    public void triggerOnUpdate() {
    }

    @Override
    public void triggerOnDelete() {
        // Log.Debug(this, "Deleting... " + IDENTITY);
    }

    @Override
    public String toString() {
        if (description != null && description.length() > 15) {
            return description.substring(0, 14);
        } else {
            return description;
        }
    }

    /**
     * @return the order
     */
    @Persistable(true)
    public int getOrdernr() {
        return ordernr;
    }

    /**
     * @param ordernr the order to set
     */
    public void setOrdernr(int ordernr) {
        this.ordernr = ordernr;
    }

    /**
     * @return the inttype
     */
    @Persistable(true)
    public int getInttype() {
        return inttype;
    }

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