package com.qxueyou.scc.admin.schoolRoll.impl;

import com.qxueyou.scc.admin.schoolRoll.ISchoolRollService;
import com.qxueyou.scc.base.model.ExcelExportParam;
import com.qxueyou.scc.base.model.Pager;
import com.qxueyou.scc.base.model.Result;
import com.qxueyou.scc.base.service.impl.CommonAppService;
import com.qxueyou.scc.base.util.ClientUtils;
import com.qxueyou.scc.base.util.CollectionUtils;
import com.qxueyou.scc.base.util.ExcelExportUtils;
import com.qxueyou.scc.teach.student.model.StuStudent;
import com.qxueyou.scc.user.model.UserRegistration;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;

@Service
public class SchoolRollServiceImpl extends CommonAppService implements ISchoolRollService {



    @Override
    public List<StuStudent> findSchoolRollList(Integer limit, Integer pageNum, String keyword, String status) {

        StringBuffer hql=new StringBuffer("from StuStudent where name like ? and status=? and deleteFlag is false");

        List<Object> args = CollectionUtils.newList(keyword + "%", status);

        hql.append(" order by createTime desc");

        List<StuStudent> list = findList(hql.toString(), new Pager(limit, pageNum), args, StuStudent.class);

        return list;
    }

    @Override
    public int findSchoolRollListCount(String keyword, String status) {
        StringBuffer hql=new StringBuffer("from StuStudent where name like ? and status=? and deleteFlag is false");

        List<Object> args = CollectionUtils.newList(keyword + "%", status);

        return findCount(hql.toString(),args);
    }

    @Override
    public String updateSchool(String StudentId, String ClassId) {
        StringBuffer hql=new StringBuffer("from StuStudent where studentId=? and deleteFlag is false");

        List<Object> args = CollectionUtils.newList(StudentId);

        StuStudent stuStudent = findUnique(hql.toString(), args, StuStudent.class);

        if(stuStudent!=null && ClassId!=null){
            stuStudent.setClassId(ClassId);
            save(stuStudent);
            return "true";
        }

        return "false";
    }

    @Override
    public void deriveStudentMessage() {
        StringBuffer hql=new StringBuffer("from StuStudent where status=? and deleteFlag is false");

        List<Object> args = CollectionUtils.newList("active");

        List<StuStudent> stuStudents = find(hql.toString(), args, StuStudent.class);

        ExcelExportUtils<StuStudent> ex = new ExcelExportUtils<StuStudent>();
        String[] headers = { "ÐÕÃû", "ÐÔ±ð" ,"ÊÖ»úºÅ" ,"Éí·ÝÖ¤"};
        List<StuStudent> dataset = new ArrayList<StuStudent>();
        for (StuStudent stuStudent:
        stuStudents) {
            StuStudent u = new StuStudent();
            u.setName(stuStudent.getName());
            u.setSex(stuStudent.getSex());
            u.setMobilePhone(stuStudent.getMobilePhone());
            u.setStudentNo(stuStudent.getStudentNo());
            dataset.add(u);
        }

        ExcelExportParam<StuStudent> obj = new ExcelExportParam<StuStudent>();
        obj.setColData(dataset);
        obj.setHeaders(headers);

        try {
            OutputStream out = new FileOutputStream("D://Student.xls");
            obj.setOut(out);
            ex.exportExcel(obj);
            out.close();
            System.out.println("excelµ¼³ö³É¹¦£¡");
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }

        try {
            OutputStream out = new FileOutputStream("D://Student.xls");
            List<String> lst = new ArrayList<String>();
            lst.add("className");
            lst.add("userName");
            obj.setLstColumn(lst);
            obj.setOut(out);
            ex.exportExcelByColomn(obj);
            out.close();
            System.out.println("excelÖ¸¶¨Áе¼³ö³É¹¦£¡");
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    @Override
    public Boolean auditStudent(String Student) {
        StringBuffer hql=new StringBuffer("from StuStudent where studentId=? and deleteFlag is false");

        List<Object> arg = CollectionUtils.newList(Student);

        StuStudent stuStudent = findUnique(hql.toString(), arg, StuStudent.class);

        stuStudent.setStatus(StuStudent.STATUS_ACTIVE);

        Result save = save(stuStudent);

        return save.isSuccess();
    }

}