public JsonResult BaoMing(int eid, List <VM_Feild> info, object items = null, int on_behalf = 0, string referer = "")
{
var model = new ActivesModel();
model.ReadCount = (model.ReadCount ?? 0) + 1;
model.ID = eid;
model.SignInCount = (model.SignInCount ?? 0) + 1;
SignInRecordModel signInRecordModel = new SignInRecordModel();
signInRecordModel.ActiveID = eid;
signInRecordModel.CreateUserID = LoginUserInfo.ID;
signInRecordModel.type = on_behalf;
List <CustomFieldValueModel> list = new List <CustomFieldValueModel>();
foreach (var item in info)
{
CustomFieldValueModel valueModel = new CustomFieldValueModel();
valueModel.ActiveID = eid;
valueModel.CreateUserID = LoginUserInfo.ID;
valueModel.CustomFieldID = item.field_key.ToInt32();
valueModel.Value = item?.field_value ?? "";
list.Add(valueModel);
}
bool flag = SignInRecordBussiness.InserSignInRecordByTran(model, signInRecordModel, list);
if (flag)
{
return(Success(new { info_id = signInRecordModel.ID }));
}
else
{
return(Fail("请重试"));
}
}
public ActionResult verify(string access_token, string comment, int info_id, int verified)
{
var user = UserBussiness.GetUserModel(m => m.OpenID == access_token);
var si = SignInRecordBussiness.GetSignInRecordModel(info_id);
si.Status = verified;
si.AuditDesc = comment;
bool flag = SignInRecordBussiness.UpdateSignInRecordModel(si);
if (flag)
{
Task.Factory.StartNew(() =>
{
AuditLogModel auditLogModel = new AuditLogModel();
auditLogModel.CreateTime = DateTime.Now;
auditLogModel.CreateUserID = user.ID;
auditLogModel.remark = comment;
auditLogModel.Status = verified;
auditLogModel.SignInRecordID = info_id;
AuditLogBussiness.InsertActiveModel(auditLogModel);
});
return(Success("操作成功"));
}
else
{
return(Fail("请重试"));
}
}
/// <summary>
/// 编辑报名信息
/// </summary>
/// <returns></returns>
public JsonResult UpdateSignInForm(List <VM_Feild> info, int info_id)
{
var m = SignInRecordBussiness.GetSignInRecordModel(info_id);
List <CustomFieldModel> customFieldModels = CustomFieldBussiness.GetCustomFieldModels(K => K.ActiveID == m.ActiveID);
m.Status = 0;
List <CustomFieldValueModel> list = new List <CustomFieldValueModel>();
foreach (var item in info)
{
CustomFieldValueModel valueModel = new CustomFieldValueModel();
valueModel.ActiveID = m.ActiveID;
valueModel.CreateUserID = LoginUserInfo.ID;
valueModel.CustomFieldID = item.field_key.ToInt32();
valueModel.SignInID = info_id;
valueModel.Value = item.field_value ?? "";
list.Add(valueModel);
}
bool flag = SignInRecordBussiness.UpdateSignInRecordByTran(list, info_id, m);
if (flag)
{
return(Success("success"));
}
else
{
return(Fail("请重试"));
}
}
/// <summary>
/// 活动报名列表
/// </summary>
/// <param name="eid"></param>
/// <param name="lt"></param>
/// <param name="page"></param>
/// <param name="count"></param>
/// <returns></returns>
public ActionResult SignInList(int eid, int lt = -1, int page = 1, int count = 10)
{
var model = ActivesBussiness.GetActivesModel(eid);
PageFliter pageFliter = new PageFliter();
pageFliter.PageIndex = page;
pageFliter.PageSize = count;
var list = SignInRecordBussiness.GetSignInRecordsByActiveID(eid, lt, pageFliter);
return(Success(new
{
items = list.Select(m => new
{
name = m.CreateUserName,
verified = m.Status ?? 0,
head_img = m.CreateUserAvatars,
user_visible = 1,
info_id = m.ID,
date_str = m.CreateTime.Value.ToString("yyyy-MM-dd HH:mm"),
last_update = LeoUtils.ConvertDateTimeInt1(m.UpdateTime.Value)
}),
total = pageFliter.TotalCount,
endCount = pageFliter.TotalPage,
info_id = 0
}));
}
public JsonResult my_enroll(int eid)
{
var list = SignInRecordBussiness.GetSignInRecordByUser(eid, LoginUserInfo.ID);
return(Success(list.Select(m => new
{
info_id = m.ID,
on_behalf = m.type,
name = m.CreateUserName,
})));
}
/// <summary>
/// 取消报名
/// </summary>
/// <returns></returns>
public JsonResult exit(int info_id)
{
bool flag = SignInRecordBussiness.ExitSignIn(info_id);
if (flag)
{
return(Success("success"));
}
else
{
return(Fail("请重试"));
}
}
public ActionResult comment(int info_id, string remark)
{
var model = SignInRecordBussiness.GetSignInRecordModel(info_id);
model.Remark = remark;
bool flag = SignInRecordBussiness.UpdateSignInRecordModel(model);
if (flag)
{
return(Success(""));
}
else
{
return(Success("请重试"));
}
}
public JsonResult user_detail(int eid, int info_id)
{
var sign = SignInRecordBussiness.GetSignInRecordModel(info_id);
var list = CustomFieldBussiness.GetustomFieldValueBySignIn(eid, info_id);
List <Dictionary <string, object> > req_info = new List <Dictionary <string, object> >();;
foreach (var item in list)
{
Dictionary <string, object> dc = new Dictionary <string, object>();
dc.Add("field_key", item.ID);
dc.Add("field_desc", item.PlaceHolder);
dc.Add("field_name", item.Name);
dc.Add("field_type", item.Type.Value);
dc.Add("max_length", item.MaxTextCount);
dc.Add("min_length", item.MinTextCount);
dc.Add("status", 1);
dc.Add("require", item.require);
if (item.Type == 5)
{
dc.Add("field_value", item?.Value?.Split(',') ?? new string[] { });
}
else
{
dc.Add("field_value", item?.Value?.ToString() ?? "");
}
dc.Add("options", !string.IsNullOrEmpty(item.Options) ? item.Options.SplitExtension(",") : new string[] { });
req_info.Add(dc);
}
return(Success(new
{
req_info,
info = req_info,
comment = sign.AuditDesc,
remark = sign.Remark,
verified = sign.Status
}));
}
public JsonResult CertDetail(int info_id)
{
var signin = SignInRecordBussiness.GetSignInRecordModel(info_id);
var active = ActivesBussiness.GetActivesModel(signin.ActiveID.Value);
var user = UserBussiness.GetUserModel(signin.CreateUserID ?? 0);
string filePath = Server.MapPath("/Images");
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
string fileName = filePath + "/" + Guid.NewGuid().ToString();
try
{
Image img = MiniprogramApiHelper.CreateShareCode(signin.ActiveID.Value.ToString() + "_" + info_id, "pages/detail/detail");
img.Save(fileName);
}
catch (Exception ex)
{
fileName = "https://res.wx.qq.com/wxdoc/dist/assets/img/WXAQRCode.053ccc63.png";
}
return(Success(new
{
start_time = LeoUtils.ConvertDateTimeInt1(active.SigninBeginTIme),
end_time = LeoUtils.ConvertDateTimeInt1(active.SigninEndTime),
act_start = LeoUtils.ConvertDateTimeInt1(active.ActiveBeginTime),
act_end = LeoUtils.ConvertDateTimeInt1(active.ActiveEndTime),
enroll_time = LeoUtils.ConvertDateTimeInt1(signin.CreateTime),
qrcode = fileName,
items = new ArrayList(),
title = active.Title,
name = user.UserName
}));
}
public JsonResult user_all(int eid, int page, int count)
{
PageFliter pageFliter = new PageFliter()
{
PageIndex = page,
PageSize = count
};
var list = SignInRecordBussiness.GetAllSignInRecord(eid, pageFliter);
List <VM_Feild> field_list = new List <VM_Feild>();
var customs = CustomFieldBussiness.GetCustomFieldModels(m => m.ActiveID == eid);
field_list.Add(new VM_Feild()
{
field_key = "XWNo",
field_name = "微信名称"
});
foreach (var item in customs)
{
VM_Feild feild = new VM_Feild();
feild.field_key = item.ID.ToString();
feild.field_name = item.Name;
field_list.Add(feild);
}
field_list.Add(new VM_Feild()
{
field_key = "Status",
field_name = "报名状态"
});
field_list.Add(new VM_Feild()
{
field_key = "isHeXiao",
field_name = "是否核销"
});
field_list.Add(new VM_Feild()
{
field_key = "Desc",
field_name = "备注说明"
});
field_list.Add(new VM_Feild()
{
field_key = "SignInTime",
field_name = "报名时间"
});
ArrayList user_infos = new ArrayList();
foreach (var item in list)
{
var keys = item.fieldKeys.SplitExtension("!|", StringSplitOptions.None);
var names = item.fieldNames.SplitExtension("!|", StringSplitOptions.None);
var vals = item.fieldVals.SplitExtension("!|", StringSplitOptions.None);
List <VM_Feild> feilds = new List <VM_Feild>();
feilds.Add(new VM_Feild()
{
field_key = "XWNo",
field_name = "微信名称",
field_value = item.CreateUserName
});
for (int i = 0; i < keys.Length; i++)
{
VM_Feild feild = new VM_Feild();
feild.field_key = keys[i];
feild.field_name = names.Count() >= i ? names[i]:"";
feild.field_value = vals.Count() >= i? vals[i]:"";
feilds.Add(feild);
}
feilds.Add(new VM_Feild()
{
field_key = "Status",
field_name = "报名状态",
field_value = item.Status == 1 ? "已审核" : item.Status == 2 ? "驳回" : "未审核"
});
feilds.Add(new VM_Feild()
{
field_key = "isHeXiao",
field_name = "是否核销",
field_value = "未核销"
});
feilds.Add(new VM_Feild()
{
field_key = "Desc",
field_name = "备注说明",
field_value = item.Remark
});
feilds.Add(new VM_Feild()
{
field_key = "SignInTime",
field_name = "报名时间",
field_value = item.CreateTime.Value.ToString("yyyy-MM-dd HH:mm")
});
user_infos.Add(feilds);
}
return(Success(new
{
field_list,
user_infos
}));
}
/// <summary>
/// 活动详情
/// </summary>
/// <param name="eid"></param>
/// <param name="access_token"></param>
/// <returns></returns>
public ActionResult Detail(int eid, string access_token)
{
int UserID = LoginUserInfo.ID;
var model = ActivesBussiness.GetActivesModel(eid);
var list = CustomFieldBussiness.GetCustomFieldModels(m => m.ActiveID == eid);
var signInList = SignInRecordBussiness.GetSignInRecordModels(m => m.CreateUserID == UserID && m.ActiveID == eid).OrderBy(m => m.type).ToList();
List <VM_Feild> req_info = new List <VM_Feild>();
foreach (var item in list)
{
VM_Feild feild = new VM_Feild();
feild.field_key = item.ID.ToString();
feild.field_desc = item.PlaceHolder;
feild.field_name = item.Name;
feild.field_type = item.Type.Value;
feild.max_length = item.MaxTextCount.ToString();
feild.min_length = item.MinTextCount.ToString();
feild.status = item.Status.ToString();
feild.require = item.require.Value;
feild.options = !string.IsNullOrEmpty(item.Options) ? item.Options.SplitExtension(",") : new string[] { };
req_info.Add(feild);
}
var createUser = UserBussiness.GetUserModel(model.CreateUserID.Value);
model.ReadCount = (model.ReadCount ?? 0) + 1;
Task.Factory.StartNew(() =>
{
ActivesModel a = new ActivesModel()
{
ID = model.ID,
ReadCount = model.ReadCount
};
ActivesBussiness.UpdateActiveModel(a);
});
int is_owner = 0;
var mng = ActiveManagesBussiness.GetActiveManagesModel(m => m.ManageUserID == UserID);
if (model.CreateUserID == UserID || mng != null)
{
is_owner = 1;
}
return(Success(new
{
cid = "",
start_time = LeoUtils.ConvertDateTimeInt1(model.SigninBeginTIme).ToString(),
end_time = LeoUtils.ConvertDateTimeInt1(model.SigninEndTime).ToString(),
act_start = LeoUtils.ConvertDateTimeInt1(model.ActiveBeginTime).ToString(),
act_end = LeoUtils.ConvertDateTimeInt1(model.ActiveEndTime).ToString(),
pics = model.ImgDetails.SplitExtension(","),
req_info,
is_admin = model.CreateUserID == UserID,
sign_name = model.PromoterName,
fee = model.SignIntMaxCount != null?(model.CollectFees ?? 0 / model.SignIntMaxCount):0,
status = model.SigninEndTime != null && model.SigninEndTime.Value <= DateTime.Now ? 2 : model.SigninBeginTIme != null && model.SigninBeginTIme.Value <= DateTime.Now ? 1 : 0,
verify = model.verify,
banner = model.Img,
count = model.SignInCount,
limit = model.SignIntMaxCount,
address = model.ActiveAddress,
latitude = !string.IsNullOrEmpty(model.latitude) ? double.Parse(model.latitude) : 0,
longitude = !string.IsNullOrEmpty(model.longitude) ? double.Parse(model.longitude) : 0,
on_behalf_limit = model.on_behalf_limit,
queue = model.queue,
role = model.role,
user_visible = model.user_visible,
version = model.version,
visibility = model.visibility,
content = model.Content,
wx_no = model.PromoterWechat,
owner_pic = createUser?.Avatars ?? "",
title = model.Title,
views = model.ReadCount ?? 0,
is_owner,
eid = model.ID,
on_behalf = signInList.Count(),
info_id = signInList.FirstOrDefault()?.ID ?? 0,
phone = model.PromoterMobile,
can_quit = model.can_quit,
verified = signInList.FirstOrDefault()?.Status ?? 0,
}));
}
