Java Code Examples for com.avos.avoscloud.AVQuery#whereEqualTo()

public static void breakFavourMap(User user, Question question) {
    question.minusFavourCount();
    user.removeFavouredQuestion(question.getObjectId());
    AVQuery<UserQuestionFavourMap> userQuery = AVQuery.getQuery(UserQuestionFavourMap.class);
    userQuery.whereEqualTo(USER, user);
    AVQuery<UserQuestionFavourMap> questionQuery = AVQuery.getQuery(UserQuestionFavourMap.class);
    questionQuery.whereEqualTo(QUESTION, question);
    AVQuery<UserQuestionFavourMap> query = AVQuery.and(Arrays.asList(userQuery, questionQuery));
    query.deleteAllInBackground(new DeleteCallback() {
        @Override
        public void done(AVException e) {
            if (e == null) {
            }
        }
    });
}
 

@Override
public void onComplete(final Platform platform, int action,
		HashMap<String, Object> res) {

	AVQuery<AVObject> query = new AVQuery<AVObject>("Users");
	query.whereEqualTo("platform", platform.getName());
	query.whereEqualTo("uid", platform.getDb().getUserId());
	query.setLimit(1);
	query.findInBackground(new FindCallback<AVObject>() {
		@Override
		public void done(List<AVObject> objects, AVException e) {
			if (e == null) {
				if (objects.size() > 0) {
					saveInformation(platform, true, objects.get(0));
				} else {
					saveInformation(platform, false, null);
				}
			} else {
				mHandler.sendEmptyMessage(AUTH_SAVE_FAILED);
			}
		}
	});

}
 

@Override
protected void onCreate(Bundle savedInstanceState) {
	super.onCreate(savedInstanceState);
	setContentView(R.layout.activity_about_app);
	this.getActionBar().setDisplayHomeAsUpEnabled(true);
	submitButton = (Button) findViewById(R.id.button_about_app_submit_user_input);
	submitEditText = (EditText) findViewById(R.id.editText_about_app_user_input);
	mUserResponseListView = (ListView) findViewById(R.id.listView_user_back);
	submitButton.setOnClickListener(buttonListener);

   FindCallback<AVObject> findCallback=new FindCallback<AVObject>() {
     public void done(List<AVObject> avObjects, AVException e) {
       if (e == null) {
         Message msg = new Message();
         msg.what = 3;
         msg.obj = avObjects;
         mHandler.sendMessage(msg);
       } else {
         showError(activity.getString(R.string.network_error));
       }
     }
   };
	AVQuery<AVObject> query = new AVQuery<AVObject>("SuggestionByUser");
	query.whereEqualTo("UserObjectId", getUserId());
	query.findInBackground(findCallback);
}
 

@Override
public void queryBookTotalMoney(long bid, final QueryBookTotalMoneyCallback callback) {
    AVQuery<Account> query = new AVQuery<>(Api.TAB_ACCOUNT);
    query.whereEqualTo(Api.BID, bid);
    query.findInBackground(new FindCallback<Account>() {
        @Override
        public void done(List<Account> list, AVException e) {
            if (e == null) {
                double costTotalMoney = 0;
                double incomeTotalMoney = 0;
                for (Account account : list) {
                    double money = Double.parseDouble(account.getMoney());
                    if (AppConfig.TYPE_COST == account.getType()) {
                        costTotalMoney = ArithUtils.add(costTotalMoney, money);
                    } else {
                        incomeTotalMoney = ArithUtils.add(incomeTotalMoney, money);
                    }
                }
                callback.querySuccess(costTotalMoney, incomeTotalMoney);
            } else {
                callback.queryFail(new Error(e));
            }
        }
    });
}
 

@Override
public void queryBooks(final User user, final QueryBooksCallback callback) {
    AVQuery<AccountBook> query = AVQuery.getQuery(AccountBook.class);
    query.whereEqualTo(Api.OWNER, user);
    query.include(Api.SHARES);
    query.findInBackground(new FindCallback<AccountBook>() {
        @Override
        public void done(final List<AccountBook> list, AVException e) {
            if (e == null) {
                callback.querySuccess(list);
            } else {
                callback.queryFail(new Error(e));
            }
        }
    });
}
 

@Override
public void queryUnReadMsg(User user, final QueryUnReadMsgCallback callback) {
    AVQuery<Msg> query = AVQuery.getQuery(Msg.class);
    query.whereEqualTo(Api.OWNER, user);
    query.findInBackground(new FindCallback<Msg>() {
        @Override
        public void done(List<Msg> list, AVException e) {
            if (e == null) {
                int count = 0;
                for (Msg msg : list) {
                    if (!msg.isRead()) {
                        count++;
                    }
                }
                callback.querySuccess(count);
            } else {
                callback.queryFail(new Error(e));
            }
        }
    });
}
 

@Override
public void queryMsgList(User user, final QueryMsgListCallback callback) {
    AVQuery<Msg> query = AVQuery.getQuery(Msg.class);
    query.whereEqualTo(Api.OWNER, user);
    query.include(Api.APPLY_USER);
    query.include(Api.APPLY_BOOK);
    query.orderByDescending(Api.CREATED_AT);// 按创建时间，降序排列
    query.findInBackground(new FindCallback<Msg>() {
        @Override
        public void done(List<Msg> list, AVException e) {
            if (e == null) {
                // 设置消息为已读
                for (Msg msg : list) {
                    msg.setRead(true);
                }
                AVObject.saveAllInBackground(list);
                callback.querySuccess(list);
            } else {
                callback.queryFail(new Error(e));
            }
        }
    });
}
 

public static void getUser(final LoadCallback<User> loadCallback, String objectId) {
    AVQuery<User> userAVQuery = AVQuery.getQuery(User.class);
    userAVQuery.whereEqualTo(AVUser.OBJECT_ID, objectId);
    userAVQuery.findInBackground(new FindCallback<User>() {
        @Override
        public void done(List<User> list, AVException e) {
            if (e == null) {
                loadCallback.onLoadSuccess(list);
            } else {
                loadCallback.onLoadFailed(e.getLocalizedMessage());
            }

        }
    });

}
 

public static void breakFavourMap(User user, Article article) {
    user.removeFavouredArticle(article.getObjectId());
    article.decreaseFavourCount();
    AVQuery<UserArticleFavourMap> userQuery = AVQuery.getQuery(UserArticleFavourMap.class);
    userQuery.whereEqualTo(USER, user);
    AVQuery<UserArticleFavourMap> articleQuery = AVQuery.getQuery(UserArticleFavourMap.class);
    articleQuery.whereEqualTo(ARTICLE, article);
    AVQuery<UserArticleFavourMap> query = AVQuery.and(Arrays.asList(userQuery, articleQuery));
    query.deleteAllInBackground(new DeleteCallback() {
        @Override
        public void done(AVException e) {
            if (e == null) {
            }
        }
    });
}
 

public static void breakFavourMap(User user, Answer answer) {
    user.removeLikedAnswer(answer.getObjectId());
    answer.minusLikeCount();
    AVQuery<UserAnswerFavourMap> userQuery = AVQuery.getQuery(UserAnswerFavourMap.class);
    userQuery.whereEqualTo(USER, user);
    AVQuery<UserAnswerFavourMap> answerQuery = AVQuery.getQuery(UserAnswerFavourMap.class);
    answerQuery.whereEqualTo(ANSWER, answer);
    AVQuery<UserAnswerFavourMap> query = AVQuery.and(Arrays.asList(userQuery, answerQuery));
    query.deleteAllInBackground(new DeleteCallback() {
        @Override
        public void done(AVException e) {

        }
    });

}
 

@Override
public void queryAccounts(User user, String startDate, String endDate, int type, int page, final QueryAccountsCallback callback) {
    AVQuery<Account> startDateQuery = new AVQuery<>(Api.TAB_ACCOUNT);
    if(type != -1)
        startDateQuery.whereEqualTo(Api.TYPE, type);
    startDateQuery.whereEqualTo(Api.OWNER, user);
    startDateQuery.whereGreaterThanOrEqualTo(Api.DATE,
            DateUtils.getDateWithDateString(startDate, DateUtils.FORMAT_MAIN_TAB));

    AVQuery<Account> endDateQuery = new AVQuery<>(Api.TAB_ACCOUNT);
    if(type != -1)
        endDateQuery.whereEqualTo(Api.TYPE, type);
    endDateQuery.whereEqualTo(Api.OWNER, user);
    endDateQuery.whereLessThan(Api.DATE,
            DateUtils.getDateWithDateString(endDate, DateUtils.FORMAT_MAIN_TAB));

    AVQuery<Account> query = AVQuery.and(Arrays.asList(startDateQuery, endDateQuery));
    query.orderByDescending(Api.DATE);// 按时间，降序排列
    query.include(Api.OWNER);
    if(page != -1){
        query.limit(AppConfig.LIMIT);
        query.skip((page - 1) * AppConfig.LIMIT);
    }
    query.findInBackground(new FindCallback<Account>() {
        @Override
        public void done(List<Account> list, AVException e) {
            if (e == null) {
                callback.querySuccess(list);
            } else {
                callback.queryFail(new Error(e));
            }
        }
    });
}
 

@Override
public void queryTypeDetailAccount(String startDate, String endDate, String cType, int type, int page, final QueryAccountsCallback callback) {
    AVQuery<Account> startDateQuery = new AVQuery<>(Api.TAB_ACCOUNT);
    User user = UserUtils.getUser();
    if(type != -1)
        startDateQuery.whereEqualTo(Api.TYPE, type);
    startDateQuery.whereEqualTo(Api.OWNER, user);
    startDateQuery.whereEqualTo(Api.CTYPE, cType);
    startDateQuery.whereGreaterThanOrEqualTo(Api.DATE,
            DateUtils.getDateWithDateString(startDate, DateUtils.FORMAT_MAIN_TAB));

    AVQuery<Account> endDateQuery = new AVQuery<>(Api.TAB_ACCOUNT);
    if(type != -1)
        endDateQuery.whereEqualTo(Api.TYPE, type);
    endDateQuery.whereEqualTo(Api.OWNER, user);
    startDateQuery.whereEqualTo(Api.CTYPE, cType);
    endDateQuery.whereLessThan(Api.DATE,
            DateUtils.getDateWithDateString(endDate, DateUtils.FORMAT_MAIN_TAB));

    AVQuery<Account> query = AVQuery.and(Arrays.asList(startDateQuery, endDateQuery));
    query.orderByDescending(Api.DATE);// 按时间，降序排列
    query.include(Api.OWNER);
    if(page != -1){
        query.limit(AppConfig.LIMIT);
        query.skip((page - 1) * AppConfig.LIMIT);
    }
    query.findInBackground(new FindCallback<Account>() {
        @Override
        public void done(List<Account> list, AVException e) {
            if (e == null) {
                callback.querySuccess(list);
            } else {
                callback.queryFail(new Error(e));
            }
        }
    });
}
 

public void toQuery() {
	AVQuery<AVObject> query = new AVQuery<AVObject>("_User");
	query.whereEqualTo("username", userStr);
	query.findInBackground(new FindCallback<AVObject>() {
		public void done(List<AVObject> avObjects, AVException e) {
			if (e == null) {
				Log.d("成功", "查询到 " + avObjects.size() + " 条符合条件的数据");
				myPhone = avObjects.get(0).getString("mobilePhoneNumber");
				lPhone = avObjects.get(0).getString("unrequitedLoverPhone");

				userId = avObjects.get(0).getObjectId();

				if (lPhone == null || lPhone.equals("")) {
					bind.setVisibility(View.VISIBLE);
					loverPhone.setVisibility(View.VISIBLE);
					loverName.setVisibility(View.VISIBLE);
					Log.d("Leancloud", "没有暗恋对象");
					status.setText("未暗恋");
					statusWord.setText("我懂，你的暗恋苦楚");
				} else {
					Log.d("Leancloud", "有暗恋对象");
					changeLove.setVisibility(View.VISIBLE);
					getLovePhone();
				}

			} else {
				Log.d("失败", "查询错误: " + e.getMessage());
			}
		}
	});
}
 

public void getLovePhone() {
	AVQuery<AVObject> queryPhone = new AVQuery<AVObject>("_User");
	queryPhone.whereEqualTo("mobilePhoneNumber", lPhone + "");
	queryPhone.findInBackground(new FindCallback<AVObject>() {
		public void done(List<AVObject> avObjects, AVException e) {
			if (e == null) {
				if (avObjects.size() == 0) {
					itsLovePhone = "";
				} else {
					itsLovePhone = avObjects.get(0).getString(
							"unrequitedLoverPhone")
							+ "";
				}

				if (itsLovePhone.equals(myPhone)) {
					status.setText("情投意合");
					statusWord.setText("爱情开始咯");
					container.setBackgroundResource(R.drawable.twolove);
					arrow.setVisibility(View.VISIBLE);
				} else {
					statusWord.setText("我懂，你的暗恋苦楚");
					status.setText("单相思");
				}
			} else {
				Log.d("失败", "查询错误: " + e.getMessage());
			}
		}
	});
}
 

public static int countAddRequests() throws AVException {
	AVQuery<AddRequest> q = AVObject.getQuery(AddRequest.class);
	q.setCachePolicy(AVQuery.CachePolicy.NETWORK_ELSE_CACHE);
	q.whereEqualTo(AddRequest.TO_USER, AVUser.getCurrentUser());
	try {
		return q.count();
	} catch (AVException e) {
		if (e.getCode() == AVException.CACHE_MISS) {
			return 0;
		} else {
			throw e;
		}
	}
}
 

public static List<AddRequest> findAddRequests() throws AVException {
	AVUser user = AVUser.getCurrentUser();
	AVQuery<AddRequest> q = AVObject.getQuery(AddRequest.class);
	q.include(AddRequest.FROM_USER);
	q.whereEqualTo(AddRequest.TO_USER, user);
	q.orderByDescending("createdAt");
	q.setCachePolicy(AVQuery.CachePolicy.NETWORK_ELSE_CACHE);
	return q.find();
}
 

public static void createAddRequest(AVUser toUser) throws Exception {
	AVUser curUser = AVUser.getCurrentUser();
	AVQuery<AddRequest> q = AVObject.getQuery(AddRequest.class);
	q.whereEqualTo(AddRequest.FROM_USER, curUser);
	q.whereEqualTo(AddRequest.TO_USER, toUser);
	q.whereEqualTo(AddRequest.STATUS, AddRequest.STATUS_WAIT);
	int count = 0;
	try {
		count = q.count();
	} catch (AVException e) {
		e.printStackTrace();
		if (e.getCode() == AVException.OBJECT_NOT_FOUND) {
			count = 0;
		} else {
			throw e;
		}
	}
	if (count > 0) {
		throw new Exception(DemoApplication.context.getString(R.string.contact_alreadyCreateAddRequest));
	} else {
		AddRequest add = new AddRequest();
		add.setFromUser(curUser);
		add.setToUser(toUser);
		add.setStatus(AddRequest.STATUS_WAIT);
		add.save();
	}
}
 

@Override
protected Boolean doInBackground(Void... params) {
    AVQuery<AVObject> query = new AVQuery<AVObject>(
            "Comments");
    query.whereEqualTo("vid", mAnimation.AnimationId);
    query.setLimit(mStep);
    query.setSkip(mSkip);
    query.include("uid");
    query.orderByDescending("updatedAt");
    try {
        List<AVObject> commentList = query.find();
        if (commentList.size() < mStep) {
            mCommentFinished = true;
        }
        ArrayList<LinearLayout> commentsLayout = new ArrayList<LinearLayout>();
        for (AVObject comment : commentList) {
            AVObject user = comment.getAVObject("uid");
            Comment commentInformation = new Comment(
                    user.getString("username"),
                    user.getString("avatar"),
                    user.getString("platform"), comment.getUpdatedAt(),
                    comment.getString("content"));
            LinearLayout commentItem = (LinearLayout) mLayoutInflater
                    .inflate(R.layout.comment_item, null);
            TextView content = (TextView) commentItem
                    .findViewById(R.id.content);
            content.setText(commentInformation.Content);
            ImageView avatar = (ImageView) commentItem
                    .findViewById(R.id.avatar);
            Picasso.with(mContext).load(commentInformation.Avatar)
                    .into(avatar);
            TextView username = (TextView) commentItem
                    .findViewById(R.id.name);
            username.setText(commentInformation.Username);
            TextView date = (TextView) commentItem
                    .findViewById(R.id.time);
            date.setText(mPrettyTime.format(commentInformation.Date));
            commentsLayout.add(commentItem);
        }
        mSkip += mStep;
        mCommentCount += commentList.size();
        publishProgress(commentsLayout
                .toArray(new LinearLayout[commentList.size()]));
        return true;
    } catch (AVException e) {
        return false;
    }
}