package com.basic.x01.location;

import java.io.File;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.basic.x01.base.BaseController;

import framework.util.excel.ExcelWriter;

@Controller
public class DailyReportExport extends BaseController {

	@RequestMapping(value="locationReportDownload")
	public String download() throws Throwable {
//		String searchDate = c.getString("searchDate");
//		if(! c.valid(searchDate)){
//			searchDate = TimeUtil.getDate10();
//		}
//
//		Sql sql = this.makeSql(c, searchDate);
//		
//		List<Map<String,Object>> list = sql.select().endList();
//
		ExcelWriter w = ExcelWriter.open(//searchDate+
				"到校离校情况");
		w.setSheet("Sheet1");
		
		//序号	年级	班级	姓名	卡号	性别	年龄
		w.setTitle(new String[]{
			"序号", "年级", "班级", 
			"姓名",	
			"卡号",
			"到校时间",
			"离线时间"
		});
		
		int col = 0;
		int row = 1;
		
//		for(Map<String,Object> m : list){
//			TbSchStudent s = (TbSchStudent)m.get("s");
//			
//			col = 0;
//			
//			w.setCellValue(row, col++, row);
//			w.setCellValue(row, col++, s.getGradeName());
//			w.setCellValue(row, col++, s.getClassName());
//			w.setCellValue(row, col++, s.getStudentName()+
//					(s.getStatus().equals("1")?"":"(挂起)"));
//			w.setCellValue(row, col++, s.getLocCardNo());
//			
//			w.setCellValue(row, col++, (String)Select.getRowRaw(m, "come_time"));
//			w.setCellValue(row, col++, (String)Select.getRowRaw(m, "leave_time"));
//			row++;
//		}
		
		w.freeze(1, 1);
		
		w.saveAndClose();
		File f = w.getFile();

		return this.downloadFile(f, f.getName(), true);
	}

//	public Sql makeSql(ActionContext c, String searchDate) throws Throwable {
//		Integer schoolId = UserUtil.getUserSchoolId(c.getRequest());
//		
//		Sql sql = c.getDao().sql("select")
//			.select(TbSchStudent.class, "s").get()
//			
//			.append(",(select grade_name").from().table(TbSchClass.class)
//			.append("c where c.school_id=").param(schoolId)
//			.append("and class_id=s.class_id) as s_grade_name")
//			
//			.append(",(select class_name").from().table(TbSchClass.class)
//			.append("c where c.school_id=").param(schoolId)
//			.append("and class_id=s.class_id) as s_class_name")
//			
//			.append(", (select substr(min(l.loc_time), 1, 16)")
//			.from().append(LocationUtil.TB_NAME)
//			.append("l where l.student_id=s.student_id ")
//			.append("and instr(l.loc_time, '"+searchDate+"')=1")
//			.append("and l.loc_type=").param(LocationUtil.COME_IN_1)
//			.append("and l.gate_position='1'")
//			.append(") as come_time")
//			.append(", (select substr(max(l.loc_time), 1, 16)")
//			.from().append(LocationUtil.TB_NAME)
//			.append("l where l.student_id=s.student_id ")
//			.append("and instr(l.loc_time, '"+searchDate+"')=1")
//			.append("and l.loc_type=").param(LocationUtil.LEAVE_OUT_2)
//			.append("and l.gate_position='1'")
//			.append(") as leave_time")
//			
//			.from().table("s")
//			.append("where school_id=").param(schoolId);
//		
//		String searchName = c.getString("searchName");
//		if(c.valid(searchName)){
//			sql.append("and (student_name like '%"+searchName.trim()+"%' ")
//			.append("or loc_card_no like '%"+searchName.trim()+"%' )");
//			
//			c.setAttribute("searchName", searchName);
//		}
//
//		sql.append("order by class_id, ")
//		.append("CONVERT(student_name USING gbk ) COLLATE gbk_chinese_ci");
//		
//		return sql;
//	}

}