-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathone.py
157 lines (147 loc) · 7.44 KB
/
one.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
from flask import Flask,render_template, request,jsonify,abort,Response, jsonify
from jinja2 import TemplateNotFound
import databases
import simplejson as json
import tables
app = Flask(__name__, template_folder='templates')
conn = databases.engine.connect()
extcashe=['array']
@app.route('/')
def form():
return render_template('form_submit.html')
@app.route('/search/', methods=['POST'])
def search():
name=request.form['yourname']
sip_user_result=tables.SUser.query.filter(tables.SUser.name == name).first()
check=request.form['check']
try:
sip_user_result.name==name
except AttributeError:
return render_template('form_submit.html',error='not found')
if (check=='2'):
return render_template('table_sip.html',id=sip_user_result.id
, accountcode= sip_user_result.accountcode
, disallow= sip_user_result.disallow
, allow= sip_user_result.allow
#, allowoverlap= sip_user_result.allowoverlap
#, allowsubscribe= sip_user_result.allowsubscribe
#, allowtransfer= sip_user_result.allowtransfer
, amaflags= sip_user_result.amaflags
#, autoframing= sip_user_result.autoframing
#, auth= sip_user_result.auth
#, buggymwi= sip_user_result.buggymwi
, callgroup= sip_user_result.callgroup
, callerid= sip_user_result.callerid
#, cid_number= sip_user_result.cid_number
#, fullname= sip_user_result.fullname
, calllimit= sip_user_result.calllimit
#, callingpres= sip_user_result.callingpres
, canreinvite= sip_user_result.canreinvite
, context= sip_user_result.context
, defaultip= sip_user_result.defaultip
, dtmfmode= sip_user_result.dtmfmode
, fromuser= sip_user_result.fromuser
, fromdomain= sip_user_result.fromdomain
, fullcontact= sip_user_result.fullcontact
#, g726nonstandard= sip_user_result.g726nonstandard
, host= sip_user_result.host
, insecure= sip_user_result.insecure
, ipaddr= sip_user_result.ipaddr
#, language= sip_user_result.language
, lastms= sip_user_result.lastms
, mailbox= sip_user_result.mailbox
#, maxcallbitrate= sip_user_result.maxcallbitrate
#, mohsuggest= sip_user_result.mohsuggest
, md5secret= sip_user_result.md5secret
, name= sip_user_result.name
, nat= sip_user_result.nat
#, outboundproxy= sip_user_result.outboundproxy
, deny= sip_user_result.deny
, permit= sip_user_result.permit
, pickupgroup= sip_user_result.pickupgroup
, port= sip_user_result.port
#, progressinband= sip_user_result.progressinband
#, promiscredir= sip_user_result.promiscredir
, qualify= sip_user_result.qualify
, regexten= sip_user_result.regexten
, regseconds= sip_user_result.regseconds
#, rfc2833compensate= sip_user_result.rfc2833compensate
, rtptimeout= sip_user_result.rtptimeout
, rtpholdtimeout= sip_user_result.rtpholdtimeout
, secret= sip_user_result.secret
#, setvar= sip_user_result.setvar
#, subscribecontext= sip_user_result.subscribecontext
#, subscribemwi= sip_user_result.subscribemwi
#, t38pt_udptl= sip_user_result.t38pt_udptl
#, trustrpid= sip_user_result.trustrpid
, type= sip_user_result.type
#, useclientcode= sip_user_result.useclientcode
#, username= sip_user_result.username
#, usereqphone= sip_user_result.usereqphone
#, videosupport= sip_user_result.videosupport
#, vmexten= sip_user_result.vmexten
, lastmoddate= sip_user_result.lastmoddate
, lastmoduser= sip_user_result.lastmoduser
, access= sip_user_result.access)
else:
return render_template('short_sip.html',id= sip_user_result.id
, name= sip_user_result.name
, secret= sip_user_result.secret
, host= sip_user_result.host
, type= sip_user_result.type
, callerid= sip_user_result.callerid
, accountcode= sip_user_result.accountcode
, allow= sip_user_result.allow
, calllimit= sip_user_result.calllimit
, nat= sip_user_result.nat
, permit= sip_user_result.permit
, deny= sip_user_result.deny
, ipaddr= sip_user_result.ipaddr
, port= sip_user_result.port
, fullcontact= sip_user_result.fullcontact
, lastms= sip_user_result.lastms
, regseconds= sip_user_result.regseconds
, lastmoddate= sip_user_result.lastmoddate
, lastmoduser= sip_user_result.lastmoduser
, access= sip_user_result.access)
@app.route('/test/', methods=['POST','JSON'])
def table():
global iterat
get_context=request.form['context']
r1= tables.TExt().select(get_context)
res = conn.execute(r1)
a=['array']
for result in res:
json_l1 ={
'id' : result['id'],
'context' : result['context'],
'exten' : result['exten'],
'priority' : result['priority'],
'app' : result['app'],
'appdata' : result['appdata'],
'lastmodname' : result['lastmodname'],
'lastmoddate' : str(result['lastmoddate']),
'access' : result['access']
}
a.append(json_l1)
return render_template('test.html', s_data=json.dumps(a, indent=2))
@app.route('/updateexten/', methods=['POST','GET'])
def updateexten():
if request.method == "POST":
# load _sid and _uip from posted JSON and save other data
# but request.form is empty.
# >>> request.form
# ImmutableMultiDict([])
#extcashe.append()
print request.form
return str('OK')
@app.route('/<page>/')
def show(page):
if page=='test':
return render_template('test.html', s_data='null')
try:
return render_template('%s.html' % page)
except TemplateNotFound:
abort(404)
if __name__ == '__main__':
app.run(debug=False)