Android可复用的筛选页面

窗口代码

/**
 * 筛选页面
 * 1.将用户的输入转换成sql语句
 * 2.涉及到精确查询和模糊查询
 * 3.提交数据之后需要刷新列表
 */
public class UserFilterActivity extends AppCompatActivity implements View.OnClickListener {

    private List<ImageView> imageViewList;
    private Context mContext;

    @Override
    protected void onCreate(@Nullable Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_user_filter);
        ButterKnife.bind(this);

        initView();
        initData();
        initListener();
    }

    private void initData() {

        mContext = this;
        title.setText("筛选");

        //将所有的ImageView实例存进list
        imageViewList = new ArrayList<>();
        imageViewList.add(ivNumber);
        imageViewList.add(ivMobile);
        imageViewList.add(ivWorkNumber);
        imageViewList.add(ivSysName);
        imageViewList.add(ivPost);
        imageViewList.add(ivTelephone);
        imageViewList.add(ivEmail);

        //初始化ImageView，把状态放进tag里面
        // 所有的ImageView都是未选中状态
        for (ImageView imageView : imageViewList) {
            imageView.setTag(false);
        }
    }

    private void initView() {
        editTv.setVisibility(View.VISIBLE);
        editTv.setCompoundDrawablesWithIntrinsicBounds(R.drawable.ic_send_black_24dp, 0, 0, 0);
    }

    private void initListener() {

        //给ImageView设置监听
        for (ImageView imageView : imageViewList) {
            imageView.setOnClickListener(this);
        }

        //单选按钮设置监听
        rgStatus.setOnCheckedChangeListener((group, checkedId) -> {
            if (checkedId == R.id.rb_status_off) {
                offTime.setVisibility(View.VISIBLE);
                line.setVisibility(View.VISIBLE);
            } else {
                offTime.setVisibility(View.GONE);
                line.setVisibility(View.GONE);
            }
        });

        titleLeft.setOnClickListener(this);
        editTv.setOnClickListener(this);
        tvUserName.setOnClickListener(this);
        tvCreator.setOnClickListener(this);
    }

    @Override
    public void onClick(View view) {

        if (view.getId() == R.id.title_left) {
            finish();
        }

        if (view.getId() == R.id.edit_tv) {
            submit();
        }

        //选择用户，这里是多选
        if (view.getId() == R.id.tv_user_name) {
            Intent intent = new Intent(mContext, UserSelectActivity.class);
            intent.putExtra("isMultipleEnable", true);
            startActivityForResult(intent, 15476);
        }

        //选择用户，这里是单选
        if (view.getId() == R.id.tv_creator) {
            Intent intent = new Intent(mContext, UserSelectActivity.class);
            startActivityForResult(intent, 13685);
        }

        //点击checkbox的动作
        switch (view.getId()) {
            case R.id.iv_number:
            case R.id.iv_work_number:
            case R.id.iv_sys_name:
            case R.id.iv_post:
            case R.id.iv_mobile:
            case R.id.iv_telephone:
            case R.id.iv_email:
                switchExact((ImageView) view);
        }
    }

    //拼接sql语句，并回传给上一个页面然后结束此页
    //字段仅供参考
    public void submit() {
        StringBuilder sb = new StringBuilder("where");
        String number = etNumber.getText().toString();
        String workNumber = etWorkNumber.getText().toString();
        String sysName = etSysName.getText().toString();
        String post = etPost.getText().toString();
        String mobile = etMobile.getText().toString();
        String telePhone = etTelePhone.getText().toString();
        String email = etEmail.getText().toString();

        if (!TextUtils.isEmpty(number)) {
            String[] arr = number.split(",");
            if ((boolean) ivNumber.getTag()) {
                sb.append(" and userID in (").append(stringToString(arr)).append(")");
            } else {
                for (int i = 0; i < arr.length; i++) {
                    if (i == 0) {
                        sb.append(" and (left(userId, ").append(arr[i].length()).append(") = '").append(arr[i]).append("'");
                    } else {
                        sb.append(" or left(userId, ").append(arr[i].length()).append(") = '").append(arr[i]).append("'");
                    }
                }
                sb.append(")");
            }
        }

        if (!TextUtils.isEmpty(sysName)) {
            String[] arr = sysName.split(",");
            if ((boolean) ivSysName.getTag()) {
                sb.append(" and userName in (").append(stringToString(arr)).append(")");
            } else {
                for (int i = 0; i < arr.length; i++) {
                    if (i == 0) {
                        sb.append(" and (userName like '|").append(arr[i]).append("|'");
                    } else {
                        sb.append(" or userName like '|").append(arr[i]).append("|'");
                    }
                }
                sb.append(")");
            }
        }

        if (!TextUtils.isEmpty(workNumber)) {
            String[] arr = workNumber.split(",");
            if ((boolean) ivWorkNumber.getTag()) {
                sb.append(" and workNumber in (").append(stringToString(arr)).append(")");
            } else {
                for (int i = 0; i < arr.length; i++) {
                    if (i == 0) {
                        sb.append(" and (workNumber like '").append(arr[0]).append("|'");
                    } else {
                        sb.append(" or workNumber like '").append(arr[i]).append("|'");
                    }
                }
                sb.append(")");
            }
        }

        if (!TextUtils.isEmpty(post)) {
            String[] arr = post.split(",");
            if ((boolean) ivPost.getTag()) {
                sb.append(" and workPos in (").append(stringToString(arr)).append(")");
            } else {
                for (int i = 0; i < arr.length; i++) {
                    if (i == 0) {
                        sb.append(" and (workPost like '|").append(arr[0]).append("|'");
                    } else {
                        sb.append(" or workPost like '|").append(arr[i]).append("|'");
                    }
                }
                sb.append(")");
            }
        }

        if (!TextUtils.isEmpty(mobile)) {
            String[] arr = mobile.split(",");
            if ((boolean) ivMobile.getTag()) {
                sb.append(" and mobile in (").append(stringToString(arr)).append(")");
            } else {
                for (int i = 0; i < arr.length; i++) {
                    sb.append(" and mobileNumber in ('").append(stringToString(arr)).append("')");
                    if (i == 0) {
                        sb.append(" and (left(mobileNumber, ").append(arr[i].length()).append(") = '").append(arr[i]).append("'");
                    } else {
                        sb.append(" or left(mobileNumber, ").append(arr[i].length()).append(") = '").append(arr[i]).append("'");
                    }
                }
                sb.append(")");
            }
        }

        if (!TextUtils.isEmpty(telePhone)) {
            String[] arr = telePhone.split(",");
            if ((boolean) ivTelephone.getTag()) {
                sb.append(" and officeNumber in (").append(stringToString(arr)).append(")");
            } else {
                for (int i = 0; i < arr.length; i++) {
                    if (i == 0) {
                        sb.append(" and (left(officeNumber, ").append(arr[i].length()).append(") = '").append(arr[i]).append("'");
                    } else {
                        sb.append(" or left(officeNumber, ").append(arr[i].length()).append(") = '").append(arr[i]).append("'");
                    }
                }
                sb.append(")");
            }
        }

        if (!TextUtils.isEmpty(email)) {
            String[] arr = email.split(",");
            if ((boolean) ivEmail.getTag()) {
                sb.append(" and email in (").append(stringToString(arr)).append(")");
            } else {
                for (int i = 0; i < arr.length; i++) {
                    if (i == 0) {
                        sb.append(" and (email　LIKE '|").append(arr[i]).append("|'");
                    } else {
                        sb.append(" or　email LIKE '|").append(arr[i]).append("|'");
                    }
                }
                sb.append(")");
            }
        }

        Intent intent = new Intent();
        String sql = sb.toString().replaceFirst(" and", "");

        intent.putExtra("sql", sql);
        setResult(123, intent);
        finish();
    }

    //切换checkbox状态
    public void switchExact(ImageView view) {
        view.setTag(!(boolean) view.getTag());
        if ((boolean) view.getTag()) {
            view.setImageResource(R.drawable.ic_check_box_black_24dp);
        } else {
            view.setImageResource(R.drawable.ic_check_box_outline_blank_black_24dp);
        }
    }

    private String stringToString(String[] array) {
        StringBuilder end = new StringBuilder("");
        for (String s : array) {
            end.append("'").append(s).append("',");
        }
        return end.toString().substring(0, end.length() - 1);
    }

    @Override
    //回传值的处理
    protected void onActivityResult(int requestCode, int resultCode, @Nullable Intent data) {

        if (requestCode == 15476 && resultCode == RESULT_OK) {
            ArrayList<ClsNormalUser> users = data.getParcelableArrayListExtra("users");
            StringBuilder sb = new StringBuilder();

            for (ClsNormalUser user : users) {
                sb.append(user.getCName()).append(",");
            }
            tvUserName.setText(sb.toString());
        }

        if (requestCode == 13685 && resultCode == RESULT_OK) {
            ClsNormalUser user = data.getParcelableExtra("user");
            tvCreator.setText(user.getCName());
        }

        super.onActivityResult(requestCode, resultCode, data);
    }
}

效果如图