LOR

local userRouter = require("app.routes.user")
local HomePageRouter= require("app.routes.homepage")
local judoPageRouter= require("app.routes.judo")
local yogoPageRouter= require("app.routes.yoga")
local freepowerPageRouter =  require("app.routes.freepower")
local AerabicPageRouter= require("app.routes.aerabic")
local AdminPageRouter = require("app.routes.admin")
local AuthRouter =  require("app.routes.auth")
local uploadRouter = require("app.routes.upload")
local AdtopicRouter = require("app.routes.adtopic")
local CoverRouter= require("app.routes.cover")
local GymanasiumPicsRouter= require("app.routes.gymanasium_pics")
local GymnasiumDescriRouter = require("app.routes.gymnasium_descri")
local TrainnerPicRouter =  require("app.routes.trainner_pics")
local TrainnerDescriRouter = require("app.routes.trainner_descri")
local CourseRouter = require("app.routes.course")
return function(app)

local AdminPageRouter = require("app.routes.admin")
app:use("/admin",AdminPageRouter())

local category = {
					first="广告",
					second = "柔道",
					third  = "瑜伽",
					fouth  = "自由力量",
					fiveth = "有氧运动"
}

AdimPageRouter:get("/ad",function(req, res, next)
		
		res:render("admin_ad",{ 
			title = category.first,
			})

	end)

local DB = require("app.libs.db")
local db = DB:new()
local uuid = require("app.libs.uuid.uuid")
local utils  = require("app.libs.utils")


local  Ad_Model = {}

function Ad_Model:new(title,coverImage,content)
	local unique_number = uuid();
    local creat_time = utils.now()
	return  db:query("insert into ad_topic(title, coverimage, content,ad_uuid,create_time) values(?,?,?,?,?)",
            {title,coverImage,content,unique_number,creat_time})

end

function Ad_Model:query_by_uuid(uuid)
	local result, err =  db:query("select * from ad_topic where ad_uuid=?", {uuid})
    if not result or err or type(result) ~= "table" or #result ~=1 then
        return nil, err
    else
        return result[1], err
    end
end

function Ad_Model:delete_by_uuid(uuid)
    local res,err
    res,err = db:query("delete from ad_topic where ad_uuid=?", {uuid})

    if res and not err then
        return true
    else
        return false
    end
end

function Ad_Model:update_ad_topic_by_uuid(title,coverImage,content,uuid)
	return db:query("update ad_topic set title=?,coverimage=?,content=? where ad_uuid=?", {title,coverImage,content,uuid})
end


function Ad_Model:get_total_count()
    local res,err
    res, err =  db:query("select count(ad_id) as c from ad_topic")

    if err or not res or #res~=1 or not res[1].c then
        return 0
    else
        return res[1].c
    end
end

function Ad_Model:get_all()
    local res,err
    -- body
    res,err = db:query("select * from ad_topic")

    if not res or err or type(res) ~= "table" or #res <= 0 then
        return {}
    else
        return res
    end
end


function Ad_Model:get_all_uuid()
    local res,err
    -- body
    res,err = db:query("select ad_uuid from ad_topic")

    if not res or err or type(res) ~= "table" or #res <= 0 then
        return {}
    else
        return res
    end
end

function Ad_Model:get_all_sample()
    local res,err
    -- body
    res,err = db:query("select title,coverimage,ad_uuid from ad_topic")

    if not res or err or type(res) ~= "table" or #res <= 0 then
        return {}
    else
        return res
    end
end


return Ad_Model

  app:use("/adtopic",AdtopicRouter())

local lor = require("lor.index")
local AdtopicRouter = lor:Router()
local Admodel= require("app.model.ad_model")



AdtopicRouter:post("/new",function(req, res, next)
	    local title = req.body.title
		local coverimg   =  req.body.coverimg
		local content    =  req.body.content
  	    local reslut,err = Admodel:new(title,coverimg,content)

		if not reslut or err then
        	res:json({
                success = false,
                msg = "保存失败"
            })
    	else
            res:json({
                success = true,
                msg = "保存成功",
                data = {
                    id = res.ad_uuid
                }
            })
    	end
   	end)


AdtopicRouter:get("/count",function(req, res, next)
	local adcount = Admodel:get_total_count()
	res:json({
            	success = true,
            	ad_count = adcount
        	})	
    end)



AdtopicRouter:get("/:ad_uuid/detail", function(req, res, next)
	local uuid = req.params.ad_uuid
	local adtopic = Admodel:query_by_uuid(uuid)

    res:render("adtopic/adtopic",{adtopic = adtopic })


	end)


AdtopicRouter:post("/:ad_uuid/delete", function(req, res, next)
    local uuid = req.params.ad_uuid
    local isDel = Admodel:delete_by_uuid(uuid)

    if isDel then
       res:json({
                success = true
            })  
    else
      res:json({
                success = false
            })  
    end


    end)

local function _multipart_formdata(config)

	local form, err = upload:new(config.chunk_size)
	if not form then
		ngx.log(ngx.ERR, "failed to new upload: ", err)
		ngx.exit(500)
	end
	form:set_timeout(config.recieve_timeout)
	

	local unique_name = uuid()
	local success, msg = false, ""
	local file,origin_filename, filename, path, extname, url,err
	local prefix,suffix
	local isFile =false
	local params = {}
	local paramKey, paramValue
    
	while true do
		local typ, res, err = form:read()

		if not typ then
			success = false
			msg = "failed to read"
			ngx.log(ngx.ERR, "failed to read: ", err)
			return success, msg
		end

		if err then
		   ngx.log(ngx.ERR, "read form err: ", err)
		end

		if typ == "header" then
			prefix,suffix = res[1],res[2]

			if prefix == "Content-Disposition" then
				paramKey = match(suffix, "name=\"(.-)\"")
				origin_filename = match(suffix, "filename=\"(.-)\"")
				if origin_filename then
					isFile = true
				else
					isFile = false
				end
			elseif prefix == "Content-Type" then
				filetype = suffix
			end

			

			if isFile and origin_filename and filetype then
			   if not extname then
					extname = getextension(origin_filename)
					extname = extname:lower()
				end

				if extname ~= "png" and extname ~= "jpg" and extname ~= "jpeg"  and extname ~= "bmp"  and extname ~= "gif" then
					success = false
					msg = "not allowed upload file type"
					ngx.log(ngx.ERR, "not allowed upload file type:", origin_filename)
					return success, msg
				end  

				filename = unique_name .. "." .. extname
				path = config.dir.. "/" .. filename
			
				
				file, err = io.open(path, "w+")

				if err then
					success = false
					msg = "open file error"
					ngx.log(ngx.ERR, "open file error:", err)
					return success, msg
				end
			end

		elseif typ == "body" then

		  if isFile then 
		    if file then
			   file:write(res)
			   success = true
			else
			   success = false
			   msg = "upload file error"
			   ngx.log(ngx.ERR, "upload file error, path:", path)
			   return success, msg
			end
		  else
		  	success = true
		    paramValue = res
		  end
			
		elseif typ == "part_end" then
		
		  if isFile then
		     file:close()
		     url = '/static/images/'..filename
             file = nil
             filename = nil
             origin_filename = nil
             isFile =false
             filetype = nil
		  else
		  	params[paramKey] = paramValue
		  end 
     
		elseif typ == "eof" then
			break
		end
	end

	return success, msg, url,params
end