public static string CreateQuestionData(string researchIdName)
{
StringBuilder sb = new StringBuilder();
GoocaBoocaDataModels.GoocaBoocaDataBase gb = new GoocaBoocaDataBase();
var research = gb.GetResearch(researchIdName);
sb.AppendLine("Key\tText\tType\tAnswers");
List<QuestionLine> list = new List<QuestionLine>();
foreach (var item in research.Questiones.Where(n => n.IsActive == true))
{
QuestionLine ql = new QuestionLine()
{
Key = "q_" + item.QuestionId.ToString(),
Text = item.QuestionText,
Type = "順序"
};
if (item.QuestionType == "FreeText")
{
ql.Type = "文字列";
}
foreach (var questionChoices in item.QuestionChoices.Where(n => n.IsActive == true))
{
ql.AddAnswer(questionChoices.QuestionChoiceId.ToString(), questionChoices.QuestionChoiceText);
}
list.Add(ql);
}
foreach (var item in research.ItemCategory.Where(n => n.IsActive == true))
{
QuestionLine ql = new QuestionLine()
{
Key = "c_" + item.ItemCategoryId.ToString(),
Text = item.ItemCategoryName,
Type = "数値"
};
int cc = (research.AnswerCount / research.ItemCategory.Where(n => n.IsActive).Count());
for (int i = 0; i < cc + 1; i++)
{
ql.AddAnswer(i.ToString(), i.ToString());
}
list.Add(ql);
}
foreach (var itemCategory in research.ItemCategory.Where(n => n.IsActive))
{
foreach (var item in itemCategory.Items)
{
QuestionLine ql = new QuestionLine()
{
Key = "i_" + item.ItemId.ToString(),
Text = item.Category.ItemCategoryName + ":" + item.ItemName + "{" + research.Tag + item.ItemName + "}",
Type = "数値"
};
list.Add(ql);
//foreach (var itemAnswerChoice in research.ItemAnswerChoice.Where(n => n.IsActive))
//{
// ql.AddAnswer(itemAnswerChoice.ItemAnswerChoiceId.ToString(), itemAnswerChoice.AnswerString);
//}
}
}
Dictionary<string, List<string>> attribuuteDic = new Dictionary<string, List<string>>();
foreach (var item in gb.ItemAttributes.Where(n => n.Item.Resarch.ResearchId == research.ResearchId && n.IsActive == true))
{
if (attribuuteDic.ContainsKey(item.AttributeName))
{
attribuuteDic[item.AttributeName].Add(item.Value);
}
else
{
attribuuteDic.Add(item.AttributeName, new List<string>() { item.Value });
}
}
foreach (var item in attribuuteDic)
{
foreach (var item2 in item.Value.Distinct())
{
QuestionLine ql = new QuestionLine()
{
Key = "attribute_" + item.Key + "_" + item2,
Text = "属性:" + item.Key + "_" + item2,
Type = "数値",
AnswerNumericList = new List<double>() { 0, 0.25, 0.5, 0.75, 1 }
};
list.Add(ql);
}
}
foreach (var item in list)
{
sb.AppendLine(item.ToString());
}
return sb.ToString();
}
public SummarizeData(GoocaBoocaDataBase db)
{
this.db = db;
}
public static string CreateAnswerData(string researchIdName, int skip)
{
StringBuilder sb = new StringBuilder();
GoocaBoocaDataModels.GoocaBoocaDataBase gb = new GoocaBoocaDataBase();
var research = gb.GetResearch(researchIdName);
TsvBuilder tsvBuilder = new TsvBuilder();
foreach (var user in gb.UserAnswerCompleted.Where(n => n.Research.ResearchId == research.ResearchId).OrderBy(n => n.UserAnswerCompletedId).Select(n => n.User).Skip(skip))
{
foreach (var questionAnsweres in user.QuestionAnswer)
{
tsvBuilder.Add("q_" + questionAnsweres.Question.QuestionId, questionAnsweres.QuestionChoice.QuestionChoiceId);
}
foreach (var item in user.FreeAnswer)
{
tsvBuilder.Add("q_" + item.Question.QuestionId, item.FreeTest);
}
foreach (var item in user.ItemAnswer.GroupBy(n => n.Item.Category).Select(n => new { n.Key, Count = n.Where(m => m.ItemAnswerChoice.Tag == "Key").Select(m=>m.Item).Distinct().Count() }))
{
tsvBuilder.Add("c_" + item.Key.ItemCategoryId, item.Count);
}
foreach (var item in user.ItemAnswer)
{
if (item.ItemAnswerChoice.Tag == "Key")
{
tsvBuilder.Add("i_" + item.Item.ItemId, 1);
}
}
Dictionary<string, attributeCount> countDic = new Dictionary<string, attributeCount>();
foreach (var item in user.ItemAnswer)
{
bool flag = false;
if (item.ItemAnswerChoice.Tag == "Key")
{
flag = true;
}
foreach (var attribute in item.Item.ItemAttribute)
{
var key = attribute.AttributeName + "_" + attribute.Value;
if (countDic.ContainsKey(key))
{
countDic[key].AllCount++;
}
else
{
countDic.Add(key, new attributeCount() { AllCount = 1, Group = attribute.AttributeName, Value = attribute.Value });
}
if (flag)
{
countDic[key].Count++;
}
}
}
foreach (var item in countDic)
{
tsvBuilder.Add("attribute_" + item.Key, (item.Value.Rate).ToString());
}
tsvBuilder.NextLine();
}
return tsvBuilder.ToString();
}