local Email = class("Email", require("shared.ModelBaseMysql"))

function Email:ctor(properties)
	Email.super.ctor(self, properties)
end

Email.schema = {
    id 			= {"number", 0, "pri_auto"},	-- 数据库ID
    roleId		= {"number", 0, "index"},	-- 角色 ID
    emailId		= {"number", 0},	-- 邮件csv ID
    title 		= {"string", ""},	-- 邮件标题
    stitle		= {"string", ""}, 	-- 小标题
    content 	= {"string", "", 2048},	-- 邮件正文
    attachments	= {"string", "", 512},
    status		= {"number", 0},	-- 邮件状态: 未读, 已读, 已领取
    createtime	= {"number", skynet.timex()},
    contentPms	= {"table", {}},
    rewardPms	= {"table", {}},
}

function Email:log(role, action)
	role:log("onMail", {
		mail_action_type = action, -- 操作(1=收,2=领,3=删)
		mail_receivetime = self:getProperty("createtime"), -- 收件时间
		mail_textid = self:getProperty("emailId"), -- 邮件文本ID
		mial_title = self:getProperty("title"), -- 邮件标题参数
		mail_content = json.encode(self:getProperty("contentPms")), -- 邮件内容参数
		mail_attach = self:getProperty("attachments"), -- 邮件附件
		mail_reason = self:getProperty("stitle"), -- 原因
		mail_readstatus = self:getProperty("status") >= 1 and 1 or 0, -- 邮件读取状态
		mail_attachstatus = self:getProperty("status") >= 2 and 1 or 0, -- 邮件附件状态
		mail_timeout = 0, -- 邮件超时时间
		mail_friend_id = 0, -- 收件方账号id
		mail_friend_roleid = 0, -- 收件方角色id
	})
	role:mylog("mail_action", {desc = "onMail", int1 = self:getProperty("id"), int2 = self:getProperty("status"), cint1 = self:getProperty("emailId"), 
    short1 = action, key1=self:getProperty("title"), key2=self:getProperty("attachments")})
end

function Email:data()
	local emailId = self:getProperty("emailId")
	local title = self:getProperty("title")
	local stitle = self:getProperty("stitle")
	local content = self:getProperty("content")
	local attachments = self:getProperty("attachments")
	local contentPms = self:getProperty("contentPms")
	local rewardPms = self:getProperty("rewardPms")

	local emailData = csvdb["emailCsv"][emailId]

	if emailData then
		-- 如果内容是直接插入到数据库
		--if content == "" and emailData.body ~= "" then
		--	content = io.readfile("src/" .. emailData.body) or ""
		--	content = content:format(table.unpack(contentPms))
		--end

		if title == "" and emailData.title ~= "" then
			title = emailData.title
		end
		
		if stitle == "" and emailData.subtitle ~= "" then
			stitle = emailData.subtitle
		end

		if attachments == "" and emailData.attachment ~= "" then
			if next(rewardPms) then
				attachments = emailData.attachment:format(table.unpack(rewardPms))
			else
				attachments = emailData.attachment
			end
		end
	end

	return {
		cfgId = emailId,
		id = self:getProperty("id"),
		status = self:getProperty("status"),
		createtime = self:getProperty("createtime"),
		title = title,
		stitle = stitle,
		content = content,
		contentPms = contentPms,
		attachments = attachments,
	}
end

return Email