--抖音授权
local M = {}
local mysqldbx = require "mysqldbx"
local tools = require "tools"
local skynet = require "skynet"
local md5 =	require	"md5"


function M.add_aweme_auth_list(msg_body)
    local isok ,key =  tools.checkData({"aweme_id","aweme_name"},msg_body)
    if not isok then
        return false,string.format("缺少字段： %s.", key)
    end

    local sql  = string.format("INSERT INTO `aweme_auth_list` (aweme_id,aweme_name)  VALUES ('%s','%s')",
    msg_body.aweme_id,msg_body.aweme_name)
    mysqldbx.query(sql)
    return true, {}
end

function M.modify_aweme_auth_list(msg_body)
    local isok ,key =  tools.checkData({"aweme_id","aweme_name"},msg_body)
    if not isok then
        return false,string.format("缺少字段： %s.", key)
    end
    local sql = string.format("UPDATE  `aweme_auth_list` SET aweme_id = '%s' ,aweme_name = '%s'  WHERE id = %d ",
    msg_body.aweme_id,msg_body.aweme_name,msg_body.id)
    mysqldbx.query(sql)
    return true, {}
end

function M.search_aweme_auth_list(msg_body)
    local isok ,key =  tools.checkData({"page_size","page_number"},msg_body)
    if not isok then
        return false,string.format("缺少字段： %s.", key)
    end
    local page_size = msg_body.page_size
    local page_number = msg_body.page_number
    local offset = (page_number - 1) * page_size
    
    -- local content_param = ""
    -- if msg_body.content~="" then
    --     content_param =  string.format(" AND  ( title LIKE CONCAT( '%%%s%%')) ",msg_body.content)
    -- end

    -- local create_date_param = ""
    -- if msg_body.start_create_time~="" and msg_body.end_create_time~="" then
    --     create_date_param = " AND DATE(create_time) >= DATE(FROM_UNIXTIME(" .. (msg_body.start_create_time / 1000) .. ")) AND DATE(create_time) <= DATE(FROM_UNIXTIME(" .. (msg_body.end_create_time / 1000) .. "))"
    -- end

    local sql = "SELECT * FROM aweme_auth_list WHERE 1=1 "..string.format(" LIMIT %d OFFSET %d ",page_size, offset)
    local list = mysqldbx.query(sql)
    sql = "SELECT   COUNT(*) AS total  FROM aweme_auth_list  WHERE 1=1 "
    local total = mysqldbx.query(sql)
    return true,list,total[1].total
end

return M