package cn.com.basic.face.service;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.widget.Toast;

import cn.com.basic.face.base.BaseApplication;
import cn.com.basic.face.base.MainActivity;
import cn.com.basic.face.discern.common.CommonVariables;
import cn.com.basic.face.discern.common.ResultBean;
import cn.com.basic.face.discern.common.SqliteSqlBean;
import cn.com.basic.face.discern.entity.Visit;
import cn.com.basic.face.discern.entity.VisitDetail;
import cn.com.basic.face.discern.query.condition.AttendanceQueryCondition;
import cn.com.basic.face.discern.query.condition.CheckInQueryCondition;
import cn.com.basic.face.discern.query.item.OfflineAttenderRegisterItem;
import cn.com.basic.face.discern.query.item.OfflineVisitItem;
import cn.com.basic.face.fragment.CheckInFragment;
import cn.com.basic.face.service.sqlite.CheckInDao;
import cn.com.basic.face.service.sqlite.DictionaryDao;
import cn.com.basic.face.util.AppApi;

import org.xutils.http.RequestParams;
import org.xutils.x;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
import java.util.Date;
import java.util.List;

import cn.com.basic.face.discern.common.BaseCommonCallBack;
import cn.com.basic.face.discern.query.item.CheckInQueryItem;
import cn.com.basic.face.util.CharacterParser;
import cn.com.basic.face.util.DateUtil;
import cn.com.basic.face.util.SqliteSqlUtil;

//登记
public class CheckInMng extends BaseMng {

    public static CheckInMng instance = new CheckInMng();

    public static CheckInMng getInstance() {
        return instance;
    }

    public void add(RequestParams params, final String visitReasonId, OfflineVisitItem offlineVisitItem) {
        if (!BaseApplication.deviceAvailable) {
            return;
        }
        if (BaseApplication.getInstance().networkAvailable()) {
            params.setUri(AppApi.BASE_URL +AppApi.VISIT_ADD);
            params.addBodyParameter(Visit.FieldNames.deviceCompanyId, BaseApplication.getInstance().getAndroidDevice().getCompanyId());
            x.http().post(params, new BaseCommonCallBack() {
                @Override
                public void success() {
                    SqliteSqlUtil.insert(getExtraList(SqliteSqlBean.class));
                    Toast.makeText(BaseApplication.getInstance(),"添加成功", Toast.LENGTH_SHORT).show();
                    CheckInFragment.getInstance().resetForm();
                    if (visitReasonId == null || "".equals(visitReasonId)) {
                        DictionaryMng.getInstance().loadVisitReasonList();
                    }
                }
            });
        } else {
            final long result = CheckInDao.getInstance().addOfflineVisit(offlineVisitItem);

            MainActivity.getInstance().runOnUiThread(new Runnable() {
                @Override
                public void run() {
                    if (result > 0) {
                        Toast.makeText(BaseApplication.getInstance(), "添加成功", Toast.LENGTH_SHORT).show();
                        if (visitReasonId == null || "".equals(visitReasonId)) {
                            DictionaryMng.getInstance().loadVisitReasonList();
                        }
                        CheckInFragment.getInstance().resetForm();
                    } else {
                        Toast.makeText(BaseApplication.getInstance(), "添加失败", Toast.LENGTH_SHORT).show();
                    }
                }
            });
        }
    }

    public void findCheckInLeftList(final boolean isVisitorList, final boolean isSortByDept, String searchText, final int pageNum, final boolean append) {
        if (!BaseApplication.deviceAvailable) {
            return;
        }
        if (BaseApplication.getInstance().networkAvailable()) {
            RequestParams params = new RequestParams(AppApi.BASE_URL +AppApi.Query.CHECK_IN_QUERY);
            String deviceCompanyId = BaseApplication.getInstance().getAndroidDevice().getCompanyId();
            if (isVisitorList) {
                params.addBodyParameter(CheckInQueryCondition.FieldNames.visitorCompanyId, deviceCompanyId);
            } else {
                params.addBodyParameter(CheckInQueryCondition.FieldNames.employeeCompanyId, deviceCompanyId);
            }
            params.addBodyParameter(CheckInQueryCondition.FieldNames.username, searchText);
            params.addBodyParameter(CommonVariables.Page.PAGE_NUM, pageNum+"");
            params.addBodyParameter(CommonVariables.Page.PAGE_SIZE, CommonVariables.Page.DEFAULT_PAGE_SIZE);
            params.addBodyParameter("deviceCompanyId", BaseApplication.getInstance().getAndroidDevice().getCompanyId());
            x.http().post(params, new BaseCommonCallBack() {
                public void success() {
                    findCheckInLeftListAfterReturn(resultBean, isVisitorList, isSortByDept, append);
                }
            });
        } else {
            findCheckInLeftListAfterReturn(CheckInDao.getInstance().findCheckInLeftList(isVisitorList, searchText, pageNum), isVisitorList, isSortByDept, append);
        }
    }

    public void findCheckInLeftListAfterReturn(ResultBean resultBean, final boolean isVisitorList, final boolean isSortByDept, final boolean append) {
        List<CheckInQueryItem> list = resultBean.getList(CheckInQueryItem.class);
        if (list == null) {
            list = new ArrayList<>();
        }

        List prevList = null;
        if (append) {
            if (isVisitorList) {
                prevList = CheckInFragment.getInstance().get_fragment_check_in_left_visitor().getPrevList();
            } else {
                prevList = CheckInFragment.getInstance().get_fragment_check_in_left_interviewee().getPrevList();
            }
            for (int i = 0; i < prevList.size(); i++) {
                Object item = prevList.get(i);
                if (item instanceof CheckInQueryItem) {
                    list.add(0, (CheckInQueryItem) item);
                }
            }
        }

        sort(list, isSortByDept);
        final List itemList = new ArrayList();
        String name = "";
        String prev = "";
        for (int i = 0; i < list.size(); i++) {
            CheckInQueryItem item = list.get(i);
            if (isSortByDept) {
                if (item.getDeptName() != null && item.getDeptName().length() > 0) {
                    name = CharacterParser.getInstance().getSelling(item.getDeptName()).substring(0, 1);
                }
            } else {
                if (item.getUsername() != null && item.getUsername().length() > 0)
                    name = CharacterParser.getInstance().getSelling(item.getUsername()).substring(0, 1);
            }
            if (!name.equals(prev)) {
                itemList.add(name);
            }
            itemList.add(item);
            prev = name;
        }
        addPageFooter(resultBean.hasMorePages(), resultBean.getPageNum(), itemList);
        if (BaseApplication.getInstance().networkAvailable()) {
            if (isVisitorList) {
                CheckInFragment.getInstance().get_fragment_check_in_left_visitor().show(itemList);
            } else {
                CheckInFragment.getInstance().get_fragment_check_in_left_interviewee().show(itemList, isSortByDept, append);
            }
        } else {
            MainActivity.getInstance().runOnUiThread(new Runnable() {
                @Override
                public void run() {
                    if (isVisitorList) {
                        CheckInFragment.getInstance().get_fragment_check_in_left_visitor().show(itemList);
                    } else {
                        CheckInFragment.getInstance().get_fragment_check_in_left_interviewee().show(itemList, isSortByDept, append);
                    }
                }
            });
        }
    }

    private void sort(List<CheckInQueryItem> list, final boolean sortedByDept) {
        if (!BaseApplication.deviceAvailable) {
            return;
        }
        if (list == null) {
            list = new ArrayList<>();
        }
        Collections.sort(list, new Comparator<CheckInQueryItem>() {
            @Override
            public int compare(CheckInQueryItem item1, CheckInQueryItem item2) {
                if (sortedByDept) {
                    String dept1Name = item1.getDeptName()==null?"":item1.getDeptName();
                    String dept2Name = item2.getDeptName()==null?"":item2.getDeptName();
                    if(!dept1Name.equals(dept2Name)) {
                        String dept1Name_a = dept1Name.trim();
                        String dept1Name_b = dept2Name.trim();
                        if (dept1Name_a.length() > 0 && dept1Name_b.length() > 0) {
                            dept1Name_a = CharacterParser.getInstance().getSelling(dept1Name).toLowerCase();
                            dept1Name_b = CharacterParser.getInstance().getSelling(dept2Name).toLowerCase();
                        }
                        return dept1Name_a.compareTo(dept1Name_b);
                    }
                }
                String username1 = item1.getUsername()==null?"":item1.getUsername();
                String username2 = item2.getUsername()==null?"":item2.getUsername();
                String dept1Name_a = username1.trim();
                String dept1Name_b = username2.trim();
                if (dept1Name_a.length() > 0 && dept1Name_b.length() > 0) {
                    dept1Name_a = CharacterParser.getInstance().getSelling(username1).toLowerCase();
                    dept1Name_b = CharacterParser.getInstance().getSelling(username2).toLowerCase();
                }
                return dept1Name_a.compareTo(dept1Name_b);
            }
        });
    }


    public void sendOfflineCheckInToServer(Integer mysqlVisitorId, long sqliteVisitorId) {

    }

    public boolean hasOfflineCheckInData() {
        return CheckInDao.getInstance().hasOfflineCheckInData();
    }

    public void removeVisitorLastMonthData() {
        try {
            SQLiteDatabase db = MainActivity.getInstance().db;
            String sql="SELECT" +
                    " a.register_id," +
                    "a.username," +
                    "a.surveillance_photo," +
                    "d.company_name," +
                    "a.tel," +
                    "a.identify_num," +
                    "b.dept_name," +
                    "d.company_id," +
                    "e.post_name," +
                    "a.mobile_phone," +
                    "a.warning," +
                    "a.company" +
                    " FROM" +
                    " register a" +
                    " LEFT JOIN company d ON d.company_id = a.company_id" +
                    " LEFT JOIN department b ON a.department_id = b.dept_id" +
                    " LEFT JOIN post e ON e.post_id = a.post_id" +
                    " LEFT JOIN ( SELECT register_id, device_company_id from employee  ) f ON f.register_id = a.register_id" +
                    " WHERE" +
                    " 1 = 1";
            String deviceCompanyId = BaseApplication.getInstance().getAndroidDevice().getCompanyId();
            sql +=  " AND ( f.device_company_id != " + deviceCompanyId+" OR f.device_company_id IS NULL"+")";

            sql+=" order by a.name_en";

            String count = "select count(*) as count from (" + sql + " ) _table";
            sql += " LIMIT 0, 100000";
            List<CheckInQueryItem> list = new ArrayList<CheckInQueryItem>();
            int b = list.size();
            CheckInQueryItem cqi = null;
            Cursor c = db.rawQuery(sql,new String[]{});
            while (c.moveToNext()) {
                cqi = new CheckInQueryItem();
                cqi.setRegisterId(c.getString(c.getColumnIndex("register_id")));
                list.add(cqi);
            }
            for (CheckInQueryItem item : list) {
                String sql1 = "delete from register where 1=1 and register_id = '" + item.getRegisterId() + "'";
                MainActivity.getInstance().db.execSQL(sql1);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

}