crowdsource-backend/src/main/java/edu/nju/service/ExtraService.java

package edu.nju.service;

import java.util.*;

import edu.nju.entities.*;
import org.json.JSONArray;
import org.json.JSONObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import edu.nju.dao.ReportDao;
import edu.nju.dao.BugDao;
import edu.nju.dao.ExamDao;
import edu.nju.dao.TestCaseDao;
import edu.nju.util.ExcelToJson;

@Service
public class ExtraService {

	@Autowired
	ReportDao reportDao;
	
	@Autowired
	ExamDao examDao;
	
	@Autowired
	TestCaseDao testDao;
	
	@Autowired
	BugDao bugDao;
	
	//测试用例相关
	public String saveTestCase(String report_id, String name, String front, String behind, String description) {
		TestCase testCase = new TestCase(name, front, behind, description, report_id, Long.toString(System.currentTimeMillis()));
		return testDao.save(testCase);
	}

//	public String saveTestCase(String report_id, String name, String front, String behind, String description,String if_execute,String if_bug) {
//		TestCase testCase = new TestCase(name, front, behind, description, report_id, Long.toString(System.currentTimeMillis()),if_execute,if_bug);
//		return testDao.save(testCase);
//	}
	
	public boolean updateTestCase(String id, String report_id, String name, String front, String behind, String description) {
		try {
			testDao.updateTestCase(id, report_id, name, front, behind, description);
			return true;
		} catch (Exception e) { return false; }
	}
	
	public List<TestCase> getCaseList(String report_id) {
		return testDao.findByReport(report_id);
	}
	
	public TestCase getTestCase(String id) {
		return testDao.findById(id);
	}
	
	
	//测试报告相关
	public String saveReport(String case_id, String task_id, String case_take_id, String woker_id, String name, String device_model, 
			String device_brand, String device_os, String script_location, String report_location, String log_location) {
		Report report = new Report(case_id, task_id, case_take_id, woker_id, name, Long.toString(System.currentTimeMillis()),
				device_model, device_brand, device_os, script_location, report_location, log_location);
		return reportDao.save(report);
	}

	public boolean updateReport(String report_id, String case_id, String task_id, String case_take_id, String woker_id, String name, String device_model,
							 String device_brand, String device_os, String script_location, String report_location, String log_location) {
		Report report = new Report(case_id, task_id, case_take_id, woker_id, name, Long.toString(System.currentTimeMillis()),
				device_model, device_brand, device_os, script_location, report_location, log_location);
		return reportDao.update(report_id, report);
	}
	
	public Report getReport(String report_id) {
		return reportDao.findById(report_id);
	}
	
	public Report findByWorker(String case_take_id, String worker_id) {
		return reportDao.findByWoker(case_take_id, worker_id);
	}
	
	public List<Bug> getBugList(String report_id, String case_take_id) {
		return bugDao.findByReport(report_id, case_take_id);
	}
	
	
	//测试题目相关
	public String saveExam(String case_id, String path, String app_name, String paper_type, String test_type, String description) {
		String json = ExcelToJson.ExcelTranse(path).toString();
		Exam exam = new Exam(case_id, json, app_name, paper_type, test_type, description);
		examDao.save(exam);
		return json;
	}

// 	public String saveExam1(String case_id, String path, String app_name, String paper_type, String test_type, String description,
//							String if_test_case,String if_bug) {
//		String json = ExcelToJson.ExcelTranse(path).toString();
////		Exam exam = new Exam(case_id, json, app_name, paper_type, test_type, description);
//		Exam exam = new Exam(case_id, json, app_name, paper_type, test_type, description,if_test_case,if_bug);
//		examDao.save(exam);
//		return json;
//	}

	public JSONArray getExamList() {
		List<Exam> result = examDao.findAll();
		JSONArray array = new JSONArray();
		Set<String> ids = bugDao.findAllids();
		Map<String, Exam> exams = new HashMap<>();

		for(Exam exam: result) { exams.put(exam.getId(), exam); }
		for(String id: ids) {
			if(id == null || id.length() <= 0) { continue; }
			String[] strs = id.split("-");
			String case_id = strs[0];
			String task_id = strs[1];
			if(exams.containsKey(case_id)) {
				JSONObject object = new JSONObject();
				Exam exam = exams.get(case_id);
				object.put("name", exam.getName());
				object.put("description", exam.getDescription());
				object.put("testType", exam.getTest_type());
				object.put("case_id", case_id);
				object.put("task_id", task_id);
				array.put(object);
			}
		}
		return array;
	}

	public Exam getExam(String id) {
		return examDao.findById(id);
	}

	public String saveJob(String jobJson){
		JSONObject jsonObject=new JSONObject(jobJson);
		String description=jsonObject.getString("description");
		String name=jsonObject.getString("name");
		String create_time_millis=Long.toString(System.currentTimeMillis());

		//todo save job, item-user分组

		saveItem(jsonObject.getJSONArray("itemList"),"111");

		return null;






	}

	private void saveItem(JSONArray itemArray,String job_id){
		for(int i=0;i<itemArray.length();i++){
			JSONObject itemObject=itemArray.getJSONObject(i);
			String description=itemObject.getString("description");
			Set<String> img_urls=new HashSet<>();
			JSONArray imgUrlArray=itemObject.getJSONArray("img_urls");
			for (int j=0;j<imgUrlArray.length();j++){
				img_urls.add(imgUrlArray.getString(i));
			}
			boolean isRequired=Boolean.parseBoolean(itemObject.getString("isRequired"));
			boolean isMultiple=Boolean.parseBoolean(itemObject.getString("isMultiple"));
			//todo files， options







		}

	}
}