class sendReport3 extends Thread
    {
        @Override
        public void run() {

            // for(int i=0; i<arrayofUser.size();i++) {


            String id = UUID.randomUUID().toString();
            String disid = clientcode + id.substring(0,2).toUpperCase()+id.substring(5,7).toUpperCase();

            recentactions recact = new recentactions(); 
            recact.setUser(username);
            recact.setActiondate(date1);
            recact.setTab("Dispatch");
            recact.setType(clienttype);
            recact.setAction("Dispatch to "+dispatchedto);
            recact.setRaid(disid);
            recact.setCompleted("Started");

            Backendless.Persistence.of(recentactions.class).save(recact);


            new Handler(Looper.getMainLooper()).post(new Runnable() {
                @Override
                public void run() {
                  tvLoad.setText("Updating Employee Stock. Please Wait...");
                }
            });


            if(advance.equals("YES"))
            {



                for (int i=0; i<arrayofUser.size();i++)
                {

                    String product = arrayofUser.get(i).getProduct();
                    String batch = arrayofUser.get(i).getBatchno();
                    String mfg = arrayofUser.get(i).getMfgdate();
                    String exp = arrayofUser.get(i).getExpdate();
                    Integer qty = arrayofUser.get(i).getQty();
                    Integer dqty = arrayofUser.get(i).getDiscount();
                    Float price2 = arrayofUser.get(i).getPrice();
                    Float pts = arrayofUser.get(i).getPts();
                    String type = arrayofUser.get(i).getType();

                    empstockclause = "empcode = '"+clientcode+"' && batchno ='"+batch+"' && type = '"+type+"' && product = '"+product+"'" ;
                    stockqueryemp = DataQueryBuilder.create();
                    stockqueryemp.setWhereClause(empstockclause);
                    finalempstockdata = Backendless.Persistence.of(employeestock.class).find(stockqueryemp);
                    if(finalempstockdata.size()>0)
                    {
                        finalempstockdata.get(0).setQty(finalempstockdata.get(0).getQty()+qty);
                        finalempstockdata.get(0).setDqty(finalempstockdata.get(0).getDqty()+dqty);
                        finalempstockdata.get(0).setRemaining(finalempstockdata.get(0).getRemaining()+qty);
                        finalempstockdata.get(0).setTotalamount(finalempstockdata.get(0).getTotalamount()+totalprice);
                        Backendless.Persistence.of(employeestock.class).save(finalempstockdata.get(0));


                    }
                    else
                    {
                        employeestock empsave = new employeestock();
                        empsave.setProduct(product);
                        empsave.setBatchno(batch);
                        empsave.setMfgdate(mfg);
                        empsave.setExpdate(exp);
                        empsave.setQty(qty);
                        empsave.setDqty(dqty);
                        empsave.setRemaining(qty);
                        empsave.setMrp(price2);
                        empsave.setPts(pts);
                        empsave.setEmpcode(clientcode);
                        empsave.setEmpname(dispatchedto);
                        empsave.setType(type);
                        empsave.setTotalamount(totalprice);
                        Backendless.Persistence.of(employeestock.class).save(empsave); //YESTERDAY ERROR

                    }





                }
                recact.setUser(username);
                recact.setActiondate(date1);
                recact.setTab("Dispatch");
                recact.setType(clienttype);
                recact.setAction("Dispatch to "+dispatchedto);
                recact.setRaid(disid);
                recact.setCompleted("Employee Stock Updated");

                Backendless.Persistence.of(recentactions.class).save(recact);


            }



            new Handler(Looper.getMainLooper()).post(new Runnable() {
                @Override
                public void run() {
                    tvLoad.setText("Updating Client Dispatch & Stock Data. Please Wait...");
                }
            });
            for (int i=0; i<arrayofUser.size();i++) {
                final int posno = i;
                String product = arrayofUser.get(i).getProduct();
                String batch = arrayofUser.get(i).getBatchno();
                String mfg = arrayofUser.get(i).getMfgdate();
                String exp = arrayofUser.get(i).getExpdate();
                Integer qty = arrayofUser.get(i).getQty();
                Integer dqty = arrayofUser.get(i).getDiscount();
                Float price2 = arrayofUser.get(i).getPrice();
                Float pts = arrayofUser.get(i).getPts();
                String type = arrayofUser.get(i).getType();
                Float totalo = qty * price2;
                Integer toalo1 = Math.round(totalo);
                stockclause = "batchno = '"+batch+"' && type = '"+type+"' && product ='"+product+"'";
                stockquery = DataQueryBuilder.create();
                stockquery.setWhereClause(stockclause);
                finalsavestockdata = Backendless.Persistence.of(stockdata.class).find(stockquery);

                if(from.equals("FromHO"))
                {
                    int rah = finalsavestockdata.get(0).getRemainingatho();
                    int totr = finalsavestockdata.get(0).getRemaining();
                    int remainingqty = rah - (qty + dqty);
                    int dispatchqty = finalsavestockdata.get(0).getStockdispatched();
                    oldvalues1 = oldvalues1+" "+product+" <"+batch+"> "+" RAH- "+rah+" TR- "+totr+" DQ- "+dispatchqty+" ";
                    int finalqty = totr - (qty + dqty) ;
                    int dispatchedqty = dispatchqty + qty + dqty;
                    newvalues1 = newvalues1+" "+product+" <"+batch+"> "+" RAH- "+remainingqty+" TR- "+finalqty+" DQ- "+dispatchedqty;
                    finalsavestockdata.get(0).setRemainingatho(remainingqty);
                    finalsavestockdata.get(0).setRemaining(finalqty);
                    finalsavestockdata.get(0).setStockdispatched(dispatchedqty);
                    Backendless.Persistence.of(stockdata.class).save(finalsavestockdata.get(0)); //TODAYS ERROR


                }
                else if (from.equals( "FromGodown"))
                {
                    int rag = finalsavestockdata.get(0).getRemainingatgodown();
                    int totr = finalsavestockdata.get(0).getRemaining();
                    int remainingqty = rag - (qty + dqty);
                    int dispatchqty = finalsavestockdata.get(0).getStockdispatched();
                    oldvalues1 = oldvalues1+" "+product+" <"+batch+"> "+" RAG- "+rag+" TR- "+totr+" DQ- "+dispatchqty+" ";
                    int finalqty = totr - (qty + dqty) ;
                    int dispatchedqty = dispatchqty + qty + dqty;
                    newvalues1 = newvalues1+" "+product+" <"+batch+"> "+" RAG- "+remainingqty+" TR- "+finalqty+" DQ- "+dispatchedqty;
                    finalsavestockdata.get(0).setRemainingatgodown(remainingqty);
                    finalsavestockdata.get(0).setRemaining(finalqty);
                    finalsavestockdata.get(0).setStockdispatched(dispatchedqty);
                    Backendless.Persistence.of(stockdata.class).save(finalsavestockdata.get(0));
                }


                ClientDispatch clientDispatch = new ClientDispatch();
                clientDispatch.setProduct(product);
                clientDispatch.setBatchno(batch);
                clientDispatch.setMfg(mfg);
                clientDispatch.setExpiry(exp);
                clientDispatch.setQty(qty);
                clientDispatch.setPrice(price2);
                clientDispatch.setDispatchedto(dispatchedto);
                clientDispatch.setClientcode(clientcode);
                clientDispatch.setClienttype(clienttype);
                clientDispatch.setDispatchedon(date1);
                clientDispatch.setUsername(username);
                clientDispatch.setDispatchid(id);
                clientDispatch.setOrdertotal(Math.round(totalprice));
                clientDispatch.setDispatchno(disid);
                clientDispatch.setTotal(totalo);
                clientDispatch.setGst(GSTcheck);
                clientDispatch.setPts(pts);
                clientDispatch.setGstamount(GSTamount);
                clientDispatch.setAdjustment("NO");
                clientDispatch.setComments(commentfinal);
                clientDispatch.setDiscqty(dqty);
                clientDispatch.setFrom(from.toUpperCase());
                clientDispatch.setType(type);
                clientDispatch.setHq(hq);

                Backendless.Persistence.of(ClientDispatch.class).save(clientDispatch);
            }



            enteredvalues = enteredvalues + proprice1+proprice2+proprice3;
            oldvalues = oldvalues +oldvalues1+oldvalues2+oldvalues3;
            newvalues = newvalues + newvalues1+newvalues2+newvalues3;
            recact.setUser(username);
            recact.setActiondate(date1);
            recact.setTab("Dispatch");
            recact.setType(clienttype);
            recact.setAction("Dispatch to "+dispatchedto);
            recact.setEnteredvalue(enteredvalues);
            recact.setOldvalue(oldvalues);
            recact.setNewvalue(newvalues);
            recact.setHq(hq);
            recact.setCompleted("Finished");

            Backendless.Persistence.of(recentactions.class).save(recact);

            openLock();
            new Handler(Looper.getMainLooper()).post(new Runnable() {
                @Override
                public void run() {
                    showProgress(false);
                    Toast.makeText(dispatchnew.this, "Dispatch Report Sent", Toast.LENGTH_SHORT).show();
                    finish();
                }
            });

        }
    }