app.py

import gradio as gr
import pandas as pd
from datatable import (dt, f,fread, by, ifelse, update, sort,count, min, max, mean, sum, rowsum,rowmean,rowcount,shift,rbind,cbind,union)
import requests
import openpyxl
import docx
from docx import Document

'''
import hashlib
import tempfile
from TTS.utils.manage import ModelManager
from TTS.utils.synthesizer import Synthesizer

def fx(x:str):
    hash=hashlib.md5()
    hash.update(x.encode(encoding='utf-8'))
    return hash.hexdigest()
    
manager = ModelManager()
model_path, config_path, model_item = manager.download_model("tts_models/zh-CN/baker/tacotron2-DDC-GST")
synthesizer = Synthesizer(
    model_path, config_path, None, None, None,
)


def inference(text: str):
    wavs = synthesizer.tts(text)
    with tempfile.NamedTemporaryFile(suffix=".wav", delete=False) as fp:
        synthesizer.save_wav(wavs, fp)
        return fp.name
'''
def fx_m(s:str):
    headers= {"Content-Type": "application/json"}
    url="https://m-formatter.azurewebsites.net/api/v2"
    data={'code':s,'resultType':'text'}
    respose=requests.post(url,json=data,headers=headers)
    ms=respose.json()
    return ms['result']

def fx_dax(s:str):
    url="https://www.daxformatter.com/"
    data = {"embed":"1","l":"short","fx":s}
    ct=requests.post(url = url,data = data)
    html=ct.text
    s1=html.split('<div class="result">')[1]
    s2='<div class="result">'+s1.split('<a href')[0]+'<a href="https://pbihub.cn/users/44" target="_top"><img src="https://pbihub.cn/uploads/avatars/44_1536391253.jpg?imageView2/1/w/380/h/380" alt="万剑归宗" class="badge" width="380" height="380"></a>'
    return s2
    
def fx_datatable(code:str):
    namespace = {}
    fun = compile(code,'<string>','exec')
    exec(fun,namespace)
    return namespace['py_exe']
    
def xz():
    x=pd.DataFrame([{'姓名':'畅心','成绩':100},{'姓名':'吹水','成绩':66}])
    y=x.to_excel('statics/test.xlsx',index=False)
    return 'statics/test.xlsx'
def fx_rq(date:str):
    chinese_data_dict = {'1': '一','2': '二','3': '三','4': '四','5': '五','6': '六','7': '七','8': '八','9': '九','0': '〇'}
    chinese_data2_dict = {'一': '十','二': '二十','三': '三十'}
    for c in date:
        if c in chinese_data_dict:
            date = date.replace(c, chinese_data_dict[c])
    y = date.split('-')[0]
    m = date.split('-')[1]
    temp = ''
    if len(m) == 2:
        temp += chinese_data2_dict[m[0]]
        if m[1] != "〇":
            temp += m[1]
        m = temp

    d = date.split('-')[2]
    temp = ''
    if len(d) == 2:
        temp += chinese_data2_dict[d[0]]
        if d[1] != "〇":
            temp += d[1]
        d = temp

    date = y + '年' + m + '月' + d + '日'
    return date

def wd(x):
    doc=Document(x)
    all_paragraphs = document.paragraphs
    t=[y.text for paragraph in all_paragraphs]
    return t
    
'''    
def fx_dd(tk:str,s:str):
    headers= {"Content-Type": "application/json"}
    url="https://oapi.dingtalk.com/robot/send?access_token="+tk
    data={'msgtype':'text','text':{'title': '吹牛逼',"content": s}, 'at': {'atMobiles': [], 'isAtAll': True}}
    response=requests.post(url,json=data,headers=headers)
    return response.text    
        
def dd_ocr(tk,sl,dt):
    headers= {"Content-Type": "application/json"}
    url="https://oapi.dingtalk.com/topapi/ocr/structured/recognize?access_token="+tk
    dc={"身份证":"idcard","增值税发票":"invoice","营业执照":"blicense","银行卡":"bank_card","车牌":"car_no","机动车发票":"car_invoice","驾驶证":"driving_license","行驶证":"vehicle_license","火车票":"train_ticket","定额发票":"quota_invoice","出租车发票":"taxi_ticket","机票行程单":"air_itinerary","审批表单":"approval_table","花名册":"roster"}
    data={"image_url":sl,"type":dc[dt]}
    response=requests.post(url,json=data,headers=headers)
    return response.json()

def fx_dt(dc,x,y):
    DT=fread(dc)
    gr.JSON(DT.names)
    D_table=DT[:,sum(f[int(y-1)]),by(f[int(x-1)])]
    return D_table.to_pandas()
'''  

'''
        with gr.TabItem("测试1"):
            with gr.Column():
                text_input=gr.Textbox(placeholder='请输入测试字符串',label="请输入需要MD5加密的测试内容")
                text_output=gr.Textbox(label="输出",visible=False)
                text_input.change(fn=lambda visible: gr.update(visible=True), inputs=text_input, outputs=text_output)
                bb_button=gr.Button("运行")
                bb_button.click(fx, inputs=text_input, outputs=text_output,api_name='md5')
            with gr.Column():
                gr.Markdown("# TTS文本字符串转语音合成训练")
                TTS_input=gr.Textbox(label="输入文本") 
                TTS_button=gr.Button("合成")
                TTS_button.click(inference, inputs=TTS_input, outputs=gr.Audio(label="输出合成结果"),api_name='tts')          
        with gr.TabItem("钉钉群消息推送"):
            gr.Markdown("# 推送测试")
            dd_input=[gr.Textbox(label="请填写机器人token"),gr.Textbox(label="请填写需要推送的信息",lines=10)]
            dd_output=gr.Textbox(label="推送提示") 
            dd_button=gr.Button("提交")
            dd_button.click(fx_dd, inputs=dd_input, outputs=dd_output,api_name='dingding_robot')
            
        with gr.TabItem("钉钉ocr"):
            gr.Markdown("# 网络图片OCR识别")
            ocr_input=[gr.Textbox(label="请填写ocr_token"),gr.Textbox(label="请填写图片网址"),gr.Radio(["身份证","增值税发票","营业执照","银行卡","车牌","机动车发票","驾驶证","行驶证","火车票","定额发票","出租车发票","机票行程单","审批表单","花名册"],value="营业执照增值税发票",label="请选择识别类型：")]
            ocr_button=gr.Button("开始识别>>")
            ocr_output=gr.JSON(label="识别结果") 
            ocr_button.click(dd_ocr, inputs=ocr_input, outputs=ocr_output,api_name='dingding_ocr')
            
        with gr.TabItem("datatable"):
            gr.Markdown("# datatable测试")
            dt_input=[gr.File(label="选择需要读取的文档",type='bytes'),gr.Number(label='请输入分组列序号'),gr.Number(label='请输入聚合列序号')]
            dt_output=gr.DataFrame(label="输出",max_rows=10,wrap=True) 
            dt_button=gr.Button("分类汇总")
            dt_button.click(fx_dt, inputs=dt_input, outputs=dt_output,api_name='datatable')
'''  
    
demo=gr.Blocks(css="#jsc:hover{background-color: red;}")
with demo:
    with gr.Tabs():                
        with gr.TabItem("M-Formatter"):
            gr.Markdown("# PowerQuery M语言脚本格式化测试")
            M_input=gr.Textbox(label="请填写需要格式化的M脚本",lines=18)
            M_button=gr.Button("开始格式化>>")
            M_output=gr.Textbox(label="格式化结果",lines=50) 
            M_button.click(fx_m, inputs=M_input, outputs=M_output,api_name='M')
            
        with gr.TabItem("DAX-Formatter"):
            gr.Markdown("# DAX表达式格式化测试")
            with gr.Row():
                DAX_input=gr.Textbox(label="请填写需要格式化的DAX表达式",lines=28)
                DAX_button=gr.Button("格式化>>")
                DAX_output=gr.HTML(label="DAX表达式格式化结果") 
                DAX_button.click(fx_dax, inputs=DAX_input, outputs=DAX_output,api_name='DAX')

        with gr.TabItem("Python-Execute"):
            gr.Markdown("# Python脚本测试")
            test_code='''from datatable import (dt, f,fread, by, ifelse, update, sort,count, min, max, mean, sum, rowsum)
DT=fread('https://huggingface.co/spaces/changxin/test/raw/main/statics/test.csv')
d_t=DT[:,sum(f.销量),by('小组')]
py_exe=d_t.to_pandas()'''
            d_input=gr.Textbox(label="请填写需要datatable库处理的脚本(最终输出使用变量名py_exe)",lines=18,value=test_code)
            d_button=gr.Button("开始编译>>")
            d_output=gr.DataFrame(label="输出>",overflow_row_behaviour="paginate")
            d_button.click(fx_datatable, inputs=d_input, outputs=d_output,api_name='pyexe')
            
        with gr.TabItem("js"):
            gr.Markdown("# js处理测试")
            a=gr.Textbox(label='请输入需要js处理的字符串')
            js_output=gr.Textbox(label="JS输出") 
            js_button1=gr.Button("js_test")
            js_button2=gr.Button("js_test2")
            js_button=gr.Button("js逆序字符串处理")
            js_button3=gr.Button("调用js引用",elem_id="jsc")
            js_button1.click(None,a,js_output,_js="x=>'你好：'+x")
            js_button2.click(None,a,js_output,_js="x=>`你好：${x},欢迎吹水！`")
            js_button.click(None,a,js_output,_js="(x) => [...x].reverse().join('')",api_name='js')
            js_button3.click(None,a,js_output,_js='(x)=>md5(x);<script src="https://huggingface.co/spaces/changxin/test/raw/main/statics/md5.js"></script>')
            
        with gr.TabItem("画册展示"):
            gr.Markdown("# 画册展示_khc")
            S='<iframe style="height: 600px; width: 100%;" src="https://app.kuhuace.com/player/index.html?id=60" allowfullscreen="allowfullscreen"><iframe>'
            gr.HTML(S)
        with gr.TabItem("下载测试"):
            with gr.Row():
                xz_button=gr.Button("绑定下载资源>>")
                xz_button.click(xz,[], gr.File(label="输出下载资源"),api_name='xz')
        with gr.TabItem("date转换"):
            dt_input=gr.Textbox(label='请输入需要处理的日期字符串')
            dt_button=gr.Button("转换日期>>")
            dt_output=gr.Textbox(label='输出处理的日期字符串')
            dt_button.click(fx_rq,dt_input,dt_output,api_name='date_chinese')
            
        with gr.TabItem("读取word"):
            file_input = gr.File(file_count="single",label="请选择需要读取的word文件",show_label=True)
            text_output = gr.Textbox(label="输出读取文本",show_label=True)
            dq_button = gr.Button("开始读取>>") 
            dq_button.click(wd, inputs=file_input, outputs=text_output,api_name="word-text")
demo.launch()