package com.appsintune.depotdroid;

import android.app.Activity;
import android.content.ContentResolver;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.net.Uri;
import android.provider.BaseColumns;
import android.util.Log;

import com.appsintune.depotdroid.ContentProviderMetaData.DepotTableMetaData;


public class DepotDBUtils extends BaseTester {
    DepotDBUtils(Context ctx)
    {
        super(ctx);
    }


    public void addItem(Double qrcode, String name, Double amount, String unit, Double ppu, Double total, String comment){
        // ONLY FOR TESTING PURPOSES YET


        Log.d("addItem()","starting addItem()");
        ContentValues content = new ContentValues();
        content.put(DepotTableMetaData.ITEM_QRCODE, qrcode);
        content.put(DepotTableMetaData.ITEM_NAME, name);
        content.put(DepotTableMetaData.ITEM_AMOUNT, amount);
        content.put(DepotTableMetaData.ITEM_UNIT, unit);
        content.put(DepotTableMetaData.ITEM_PPU, ppu);
        content.put(DepotTableMetaData.ITEM_TOTAL, total);
        content.put(DepotTableMetaData.ITEM_COMMENT, comment);


        ContentResolver cr = this.mContext.getContentResolver();
        Uri uri = DepotTableMetaData.CONTENT_URI;
        Log.d("addItem","data insert uri:" + uri);
        Uri insertedUri = cr.insert(uri, content);
        Log.d("addItem","inserted uri:" + insertedUri);



    }


     public String[] showItem(Long queryid){
        Log.d("DepotDBUtils", "starting showItem()");
        String sQueryid=queryid.toString();
        Uri uri = ContentProviderMetaData.DepotTableMetaData.CONTENT_URI;
        Activity a = (Activity)this.mContext;
        String[] projection = new String[]{
                BaseColumns._ID,
                DepotTableMetaData.ITEM_QRCODE,
                DepotTableMetaData.ITEM_NAME,
                DepotTableMetaData.ITEM_AMOUNT,
                DepotTableMetaData.ITEM_UNIT,
                DepotTableMetaData.ITEM_PPU,
                DepotTableMetaData.ITEM_TOTAL,
                DepotTableMetaData.ITEM_COMMENT};
        Cursor c = a.managedQuery(uri,
                projection, //projection
                "_ID=?", //selection string
                new String[]{sQueryid}, //selection args array of strings
                DepotTableMetaData.DEFAULT_SORT_ORDER); //sort order
        Log.d("DepotDBUtils","cursor created, getting ColumnIndexes");
        c.moveToFirst();
        int iId = c.getColumnIndex(BaseColumns._ID);
        int iqrcode = c.getColumnIndex(ContentProviderMetaData.DepotTableMetaData.ITEM_QRCODE);
        int iname = c.getColumnIndex(ContentProviderMetaData.DepotTableMetaData.ITEM_NAME);
        int iamount = c.getColumnIndex(ContentProviderMetaData.DepotTableMetaData.ITEM_AMOUNT);
        int iunit = c.getColumnIndex(ContentProviderMetaData.DepotTableMetaData.ITEM_UNIT);
        int ippu = c.getColumnIndex(ContentProviderMetaData.DepotTableMetaData.ITEM_PPU);
        int itotal = c.getColumnIndex(ContentProviderMetaData.DepotTableMetaData.ITEM_TOTAL);
        int icomment = c.getColumnIndex(ContentProviderMetaData.DepotTableMetaData.ITEM_COMMENT);


            //Gather values

            String id = c.getString(iId);
            String qrcode = c.getString(iqrcode);
            String name = c.getString(iname);
            String amount = c.getString(iamount);
            String unit = c.getString(iunit);
            String ppu = c.getString(ippu);
            String total = c.getString(itotal);
            String comment = c.getString(icomment);

            Log.d("DepotDBUtils","putting Strings into info[]");
            String[] infos = new String[]{id,name,amount,unit,ppu,total,comment,qrcode};


            //Report or log the row
            StringBuffer cbuf = new StringBuffer(id);
            cbuf.append(",").append(qrcode);
            cbuf.append(",").append(name);
            cbuf.append(",").append(amount);
            cbuf.append(",").append(unit);
            cbuf.append(",").append(ppu);
            cbuf.append(",").append(total);
            cbuf.append(",").append(comment);

            Log.d("output",cbuf.toString());

            return infos;

        }

    }