package route import ( "opennamu/route/tool" ) func Api_w_page_view_post(config tool.Config, doc_name string) map[string]any { db := tool.DB_connect() defer tool.DB_close(db) pv_continue := tool.Get_setting(db, "not_use_view_count", "") if len(pv_continue) == 0 || pv_continue[0][0] == "" { // 전체 조회수 view_count := "0" tool.QueryRow_DB( db, "select set_data from data_set where doc_name = ? and set_name = 'view_count' and doc_rev = ''", []any{ &view_count }, doc_name, ) if view_count == "0" { tool.Exec_DB( db, "insert into data_set (doc_name, doc_rev, set_name, set_data) values (?, '', 'view_count', '1')", doc_name, ) } else { view_count_int := tool.Str_to_int(view_count) tool.Exec_DB( db, "update data_set set set_data = ? where doc_name = ? and set_name = 'view_count' and doc_rev = ''", view_count_int + 1, doc_name, ) } // 월간 조회수 now_date := tool.Get_month() view_count = "0" tool.QueryRow_DB( db, "select set_data from data_set where doc_name = ? and set_name = 'view_count' and doc_rev = ?", []any{ &view_count }, doc_name, now_date, ) if view_count == "0" { tool.Exec_DB( db, "insert into data_set (doc_name, doc_rev, set_name, set_data) values (?, ?, 'view_count', '1')", doc_name, now_date, ) } else { view_count_int := tool.Str_to_int(view_count) tool.Exec_DB( db, "update data_set set set_data = ? where doc_name = ? and set_name = 'view_count' and doc_rev = ?", view_count_int + 1, doc_name, now_date, ) } // 하루 조회수 now_date = tool.Get_date() view_count = "0" tool.QueryRow_DB( db, "select set_data from data_set where doc_name = ? and set_name = 'view_count' and doc_rev = ?", []any{ &view_count }, doc_name, now_date, ) if view_count == "0" { tool.Exec_DB( db, "insert into data_set (doc_name, doc_rev, set_name, set_data) values (?, ?, 'view_count', '1')", doc_name, now_date, ) } else { view_count_int := tool.Str_to_int(view_count) tool.Exec_DB( db, "update data_set set set_data = ? where doc_name = ? and set_name = 'view_count' and doc_rev = ?", view_count_int + 1, doc_name, now_date, ) } } return_data := make(map[string]any) return_data["response"] = "ok" return return_data }