public class PlaceOrder extends AppCompatActivity{

ListView myListview;// Place Order listview
String str ;
Spinner spnCategory; // Catergory filter
ArrayList<GetandSet> details = new ArrayList<GetandSet>();
ItemCustomAdapter customAdapter; // custom adapter template
CustomArrayAdapter customArrayAdapter;
ArrayList<GetandSet> productOrders = new ArrayList<GetandSet>(); // to store list of selected views
ArrayList<Integer> positionArr = new ArrayList<Integer>(); // to store list of selected position
GetandSet getandSet ;

private static int counter = 1;

TextView title,countTv;
ImageView imgback, imgMenu,imgcart;
MySQLiteDatabase mysqlitedatabase;



@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_place_order);

    title = (TextView) findViewById(R.id.title);
    countTv = (TextView) findViewById(R.id.count_tv);
    imgback = (ImageView) findViewById(R.id.img_back);
    imgMenu = (ImageView) findViewById(R.id.img_menu);
    imgcart= (ImageView) findViewById(R.id.img_cart);

    mysqlitedatabase = new MySQLiteDatabase(getApplicationContext(),null,null,1);
    SQLiteDatabase db = mysqlitedatabase.getWritableDatabase();
    Cursor cursor = db.rawQuery("SELECT  * FROM MenuMaster", null);

    title.setText("Place Order");

    imgback.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            startActivity(new Intent(PlaceOrder.this, DashBoard.class));
            finish();
            counter = 1;
        }
    });

    imgMenu.setVisibility(View.INVISIBLE);

    myListview = (ListView)findViewById(R.id.my_list_view);//defined list_view
    spnCategory = (Spinner)findViewById(R.id.spn_place_category);//defined category
    loadSpinnerData();
    showList();
}

//Binding Adapter and list view and Showing Data from database
public void showList() {
    final Cursor c1 = mysqlitedatabase.selectQuery("SELECT * FROM MenuMaster ");
    if (c1 != null && c1.getCount() != 0) {
        if (c1.moveToFirst()) {
            do {
                getandSet = new GetandSet();

                getandSet.setMenu_name(c1.getString(c1.getColumnIndex("menu_name")));
                getandSet.setMenu_rate(c1.getString(c1.getColumnIndex("menu_rate")));
                getandSet.setMenu_Remark(c1.getString(c1.getColumnIndex("menu_Remark")));
                getandSet.setMenu_Qty(c1.getInt(c1.getColumnIndex("menu_qty")));

                details.add(getandSet);

            } while (c1.moveToNext());
        }
    }
    c1.close();
    customAdapter = new ItemCustomAdapter(PlaceOrder.this, details);
    myListview.setAdapter(customAdapter);
    //display all data
    //On Item Click Listener
    myListview.setOnItemClickListener(new AdapterView.OnItemClickListener() {
        @Override
        public void onItemClick(AdapterView<?> parent, View view, int position, long id) {

            str = Integer.toString(counter++);
            countTv.setText(str);//shopping cart counter

            positionArr.add(position);// getting clicked position
            HashSet<Integer> hashSet = new HashSet<Integer>();
            hashSet.addAll(positionArr);
            positionArr.clear();
            positionArr.addAll(hashSet);// assigning position serialy

            int len = myListview.getCount();//list view size

            for (int i = 0; i < len; i++) {

                if (position == i) {

                    getandSet = new GetandSet();
                    getandSet.setMenu_name(customAdapter.DETAILS.get(i).getMenu_name());
                    getandSet.setMenu_rate(customAdapter.DETAILS.get(i).getMenu_rate());
                    getandSet.setMenu_Remark(customAdapter.DETAILS.get(i).getMenu_Remark());
                    getandSet.setMenu_Qty(customAdapter.DETAILS.get(i).getMenu_Qty());

                    productOrders.add(getandSet);

                }
            }

            customAdapter.viewHolder.txtQuantity.setText(String.valueOf(customAdapter.DETAILS.get(position).getMenu_Qty()));
                onimgButtonClick();
            }
        });
}

@Override
public void onBackPressed() {
    finish();
}

public void onimgButtonClick()
{
    imgcart.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            Intent intent = new Intent(PlaceOrder.this,MyOrderedBill.class);
            intent.putExtra("selected_list", positionArr);//sending positions
            intent.putExtra("selected_order",productOrders);
            counter=1;
            startActivity(intent);
        }
    });
}

public class MyOrderedBill extends AppCompatActivity {

ListView myListview;
GetandSet getandSet ;
BillOrderCustomAdapter customAdapter;
CustomArrayAdapter customArrayAdapter;
MySQLiteDatabase mysqlitedatabase;
ArrayList<Integer> postionId;
ArrayList<GetandSet> productOrders = new ArrayList<>();
ArrayList<GetandSet> getProductOrders = new ArrayList<>();
ImageView imgBack;
TextView txtToatalamt,txtgrandTotal;
Button btnPayPrint;

ArrayList<GetandSet> selectedList = new ArrayList<GetandSet>(); // to store list of selected views

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_my_ordered_bill);

    txtToatalamt = (TextView)findViewById(R.id.txt_Total_Amount);
    btnPayPrint = (Button) findViewById(R.id.btn_Pay_Print);
    txtgrandTotal = (TextView)findViewById(R.id.txt_Grand_Total);
    myListview = (ListView)findViewById(R.id.list_item);
    imgBack = (ImageView)findViewById(R.id.imgBack);

    imgBack.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            startActivity(new Intent(MyOrderedBill.this,PlaceOrder.class));
            onBackPressed();
        }
    });

    btnPayPrint.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            placeOrder();
        }
    });

    Bundle b = this.getIntent().getExtras();
    postionId = b.getIntegerArrayList("selected_list");
    productOrders = (ArrayList<GetandSet>)getIntent().getSerializableExtra("selected_order");

    for(int i = 1; i < postionId.size();++i)
    {

       if(postionId.get(i) == i)
       {

            GetandSet d = new GetandSet();

            d.setMenu_name(productOrders.get(i).getMenu_name());
            d.setMenu_rate(productOrders.get(i).getMenu_rate());
            d.setMenu_Remark(productOrders.get(i).getMenu_Remark());
            d.setMenu_Qty(productOrders.get(i).getMenu_Qty());

            productOrders.add(d);
        }
    }
    customArrayAdapter = new CustomArrayAdapter(this,productOrders);
    myListview.setAdapter(customArrayAdapter);
}

Context CONTEXT ;
List<GetandSet> DETAILS ;
ImageView itemImage;
LayoutInflater layoutInflater;
Activity activity;
ViewHolder viewHolder;

public ItemCustomAdapter(Activity activity, List<GetandSet> details) {
    this.activity = activity;
    this.DETAILS = details;
    this.layoutInflater = (LayoutInflater) activity.getSystemService(activity.LAYOUT_INFLATER_SERVICE);

}

@Override
public int getCount() {
    return DETAILS.size() ;
}

@Override
public Object getItem(int position) {
    return DETAILS.get(position);
}

@Override
public long getItemId(int position) {
    return position;
}

@Override
public View getView(int position, View convertView, ViewGroup parent) {
    GetandSet details = new GetandSet();
    if (convertView == null) {
        convertView = layoutInflater.inflate(R.layout.custom_adapter_template, parent, false);
        viewHolder = new ViewHolder(convertView);
        convertView.setTag(viewHolder);
    } else {
        viewHolder = (ViewHolder) convertView.getTag();
    }

    viewHolder.txtitemname.setText(DETAILS.get(position).getMenu_name());
    viewHolder.txtitemprice.setText(DETAILS.get(position).getMenu_rate()+"/-");
    viewHolder.txtremark.setText(DETAILS.get(position).getMenu_Remark());
    viewHolder.txtQuantity.setText(DETAILS.get(position).getMenu_Qty()+"");

    return convertView;
}
public class ViewHolder{
    TextView txtitemname,txtitemprice,txtremark;
    EditText txtQuantity;

    public ViewHolder(View view) {
        txtitemname = (TextView)view.findViewById(R.id.txt_Item_Name);
        txtitemprice = (TextView)view.findViewById(R.id.txt_Item_Price);
        txtremark = (TextView)view.findViewById(R.id.txt_Item_remark);
        txtQuantity = (EditText)view.findViewById(R.id.txt_Quantity);
    }
}//View holder

public class CustomArrayAdapter extends ArrayAdapter<GetandSet> {

private Context Context;
public ArrayList<GetandSet> selectedarraylist = new ArrayList<>();

TextView itemName,itemRemark,itemrate,txtqty;
Button btnadd,btnsub;
GetandSet products;


public CustomArrayAdapter(@NonNull Context context, ArrayList<GetandSet> list) {
    super(context, 0 , list);
    Context = context;
    selectedarraylist = list;
}

@NonNull
@Override
public View getView(final int position, @Nullable View convertView, @NonNull ViewGroup parent) {
    View listItem = convertView;
    if(listItem == null)
        listItem = LayoutInflater.from(Context).inflate(R.layout.custom_menu_item_bill,parent,false);

    itemName = (TextView)listItem.findViewById(R.id.txt_Item_Name);
    itemRemark = (TextView)listItem.findViewById(R.id.txt_Remark);
    itemrate = (TextView)listItem.findViewById(R.id.txt_Item_Net_Price);

    txtqty = (TextView)listItem.findViewById(R.id.txt_dis_qty);
    btnadd = (Button)listItem.findViewById(R.id.btn_add_qty);
    btnsub = (Button)listItem.findViewById(R.id.btn_remove_qty);

    itemName.setText(selectedarraylist.get(position).getMenu_name());
    itemrate.setText(selectedarraylist.get(position).getMenu_rate());
    itemRemark.setText(selectedarraylist.get(position).getMenu_Remark());
    txtqty.setText(selectedarraylist.get(position).getMenu_Qty()+"");

   btnadd.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {

            updateQuantity(position, txtqty, 1);
        }
    });

   btnsub.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            updateQuantity(position, txtqty, -1);
        }
    });

    return listItem;

}
private void updateQuantity(int position, TextView edTextQuantity, int value) {

  // GetandSet products = (GetandSet) getItem(position);
    products = selectedarraylist.get(position);

    if(value > 0)
    {
        products.menu_Qty = products.menu_Qty + 1;
        edTextQuantity.setText(products.menu_Qty+"");
        notifyDataSetChanged();
    }
    else
    {
        if(products.menu_Qty > 0)
        {
            products.menu_Qty = products.menu_Qty - 1;
            edTextQuantity.setText(products.menu_Qty+"");
            notifyDataSetChanged();
        }
    }
}

public class GetandSet implements Serializable {
int id;
String _name, _passwrod, _status ;
String cat_id,cat_name,cat_desc,cat_kot;
String menu_ID;
String menu_name;
String menu_int;
String menu_rate;
String menu_Remark;
String menu_cat;


public int getMenu_Qty() {
    return menu_Qty;
}

public void setMenu_Qty(int menu_Qty) {
    this.menu_Qty = menu_Qty;
}

int menu_Qty;


public String getCat_id() {
    return cat_id;
}

public void setCat_id(String cat_id) {
    this.cat_id = cat_id;
}

public String getCat_name() {
    return cat_name;
}

public void setCat_name(String cat_name) {
    this.cat_name = cat_name;
}

public String getCat_desc() {
    return cat_desc;
}

public void setCat_desc(String cat_desc) {
    this.cat_desc = cat_desc;
}

public String getCat_kot() {
    return cat_kot;
}

public void setCat_kot(String cat_kot) {
    this.cat_kot = cat_kot;
}

public int getId() {
    return id;
}

public String get_name() {
    return _name;
}

public String get_passwrod() {
    return _passwrod;
}

public String get_status() {
    return _status;
}

public void setId(int id) {
    this.id = id;
}

public void set_name(String _name) {
    this._name = _name;
}

public void set_passwrod(String _passwrod) {
    this._passwrod = _passwrod;
}

public void set_status(String _status) {
    this._status = _status;
}

public String getMenu_ID() {
    return menu_ID;
}

public void setMenu_ID(String menu_ID) {
    this.menu_ID = menu_ID;
}

public String getMenu_name() {
    return menu_name;
}

public String setMenu_name(String menu_name) {
    this.menu_name = menu_name;
    return menu_name;
}

public String getMenu_int() {
    return menu_int;
}

public void setMenu_int(String menu_int) {
    this.menu_int = menu_int;
}

public String getMenu_rate() {
    return menu_rate;
}

public void setMenu_rate(String menu_rate) {
    this.menu_rate = menu_rate;
}

public String getMenu_Remark() {
    return menu_Remark;
}

public void setMenu_Remark(String menu_Remark) {
    this.menu_Remark = menu_Remark;
}

public String getMenu_cat() {
    return menu_cat;
}

public void setMenu_cat(String menu_cat) {
    this.menu_cat = menu_cat;
}

public class MySQLiteDatabase extends SQLiteOpenHelper {

private static final int DATABASE_VERSION = 1 ;
private static final String DATABASE_NAME = "restroquickpos";
public static final String TABLE_NAME ="Login";
public static final String COL_ID ="ID";
public static final String COL_NAME ="username";
public static final String COL_PASSWORD ="password";
public static final String COL_STATUS = "status";



public static final String TABLE_NAME1 ="CategoryMaster";
public static final String COL_CATID ="Cat_ID";
public static final String COL_CATNAME ="cat_name";
public static final String COL_CATDESC ="cat_desc";
public static final String COL_CATKOT = "cat_kot";


public SQLiteDatabase DB;

public static final String TABLE_MENU ="MenuMaster";
public static final String COL_MENUID ="menu_ID";
public static final String COL_MENUNAME ="menu_name";
public static final String COL_MENUINT ="menu_int";
public static final String COL_MENURATE = "menu_rate";
public static final String COL_MENUREMARK ="menu_Remark";
public static final String COL_MENUCAT ="menu_cat";
public static final String COL_MENUQTY ="menu_qty";




public MySQLiteDatabase(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
    super(context, DATABASE_NAME, factory, DATABASE_VERSION);
    Log.d("DatabaseOperation","Database Created");
}

@Override
public void onCreate(SQLiteDatabase db) {

    this.DB = db ;
    String loginquery = "CREATE TABLE " + TABLE_NAME + " ("
            + COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
            + COL_NAME + " TEXT NOT NULL, "
            + COL_PASSWORD + " TEXT NOT NULL, "
            + COL_STATUS + " TEXT "
            + ");";
    db.execSQL(loginquery);
    Log.d("DatabaseOperation","Table Created");

    String catquery = "CREATE TABLE " + TABLE_NAME1 + " ("
            + COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
            + COL_CATID + " TEXT NOT NULL, "
            + COL_CATNAME + " TEXT NOT NULL, "
            + COL_CATDESC + " TEXT NOT NULL, "
            + COL_CATKOT + " TEXT NOT NULL "
            + ");";
    db.execSQL(catquery);
    Log.d("DatabaseOperation","Table Created");

    String Menuquery = "CREATE TABLE " + TABLE_MENU + " ("
            + COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
            + COL_MENUID + " TEXT NOT NULL, "
            + COL_MENUNAME + " TEXT NOT NULL, "
            + COL_MENUINT + " TEXT NOT NULL, "
            + COL_MENURATE + " TEXT NOT NULL, "
            + COL_MENUREMARK + " TEXT NOT NULL, "
            + COL_MENUCAT + " TEXT NOT NULL, "
            + COL_MENUQTY + " INTEGER NOT NULL "
            + ");";
    db.execSQL(Menuquery);
    Log.d("DatabaseOperation","Table Created");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    this.DB = db ;
    db.execSQL(" DROP TABLE IF EXISTS " + TABLE_NAME);//drop tabel command
    onCreate(db);//execute query
}
public void addDetails(GetandSet details)//Adding into Login
{
    ContentValues values = new ContentValues();
    values.put(COL_NAME,details.get_name());
    values.put(COL_PASSWORD,details.get_passwrod());
    values.put(COL_STATUS,details.get_status());

    SQLiteDatabase db = getWritableDatabase();
    db.insert(TABLE_NAME,null,values);
    Log.d("DatabaseOperation","Values Inserted");
    db.close();
}

public void addCategory(GetandSet details)//Adding into Category
{
    ContentValues values = new ContentValues();
    values.put(COL_CATID,details.getCat_id());
    values.put(COL_CATNAME,details.getCat_name());
    values.put(COL_CATDESC,details.getCat_desc());
    values.put(COL_CATKOT,details.getCat_kot());

    SQLiteDatabase db = getWritableDatabase();
    db.insert(TABLE_NAME1,null,values);
    Log.d("DatabaseOperation","Values Inserted");
    db.close();
}

public void addMenuItems(GetandSet details)//Adding into Menu Items
{
    ContentValues values = new ContentValues();
    values.put(COL_MENUID,details.getMenu_ID());
    values.put(COL_MENUNAME,details.getMenu_name());
    values.put(COL_MENUINT,details.getMenu_int());
    values.put(COL_MENURATE,details.getMenu_rate());
    values.put(COL_MENUREMARK,details.getMenu_Remark());
    values.put(COL_MENUCAT,details.getMenu_cat());
    values.put(COL_MENUQTY,1);

    SQLiteDatabase db = getWritableDatabase();
    db.insert(TABLE_MENU,null,values);
    Log.d("DatabaseOperation","Values Inserted");
    db.close();
}


public String searchPass(String userid) {

    DB = this.getReadableDatabase();
    String query = "SELECT * FROM " + TABLE_NAME ;
    Cursor cursor = DB.rawQuery(query,null);

    String Username, password,fullname;
    password = "Not Found";

    if(cursor.moveToNext())
    {
        do {
            // Username = cursor.getString(2);
            fullname = cursor.getString(1);
            /*if(Username.equals(userid))
            {
                password = cursor.getString(4);
                break;
            }*/
            if(fullname.equals(userid))
            {
                password = cursor.getString(2);
                break;
            }
        }while (cursor.moveToNext());
    }
    return password;
}

public List<String> getAllLabels(){
    List<String> labels = new ArrayList<String>();

    // Select All Query
    String selectQuery = "SELECT  * FROM " + TABLE_NAME1;

    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);

    // looping through all rows and adding to list
    if (cursor.moveToFirst()) {
        do {
            labels.add(cursor.getString(2));
        } while (cursor.moveToNext());
    }

    // closing connection
    cursor.close();
    db.close();
    // returning lables
    return labels;
}
public Cursor selectQuery(String query) {
       Cursor c1 ;
       DB = getWritableDatabase();
       c1 = DB.rawQuery(query, null);
       return c1;
}