def addimp_place():
name = request.form['name']
description = request.form['description']
latitude = request.form['latitude']
longitude = request.form['longitude']
qry = "insert into imp_place_reg values (null,'" + name + "','" + description + "','" + latitude + "','" + longitude + "')"
iud(qry)
return ''' <script> alert('successful');window.location='/view_important_place'</script>'''
def addsignal():
name = request.form['name']
latitude = request.form['latitude']
longitude = request.form['longitude']
qry = "insert into trafficsignal_reg values(null,'" + name + "','" + latitude + "','" + longitude + "')"
print(qry)
iud(qry)
return ''' <script> alert('successful');window.location='/view_traffic_signal'</script>'''
def addpolice():
first_name = request.form['fname']
mid_name = request.form['mname']
last_name = request.form['lname']
phone = request.form['ph']
email = request.form['email']
uname = request.form['un']
password = request.form['pwd']
qry = "insert into login values(null,'" + uname + "','" + password + "','police')"
print(qry)
lid = iud(qry)
qry = "insert into traffic_police_reg values(null,'" + str(
lid
) + "','" + first_name + "','" + mid_name + "','" + last_name + "' ," + phone + ",'" + email + "')"
print(qry)
iud(qry)
return ''' <script> alert('successful');window.location='/view_traffic_police'</script>'''
def deletepolice():
police_id = request.args.get('id')
qry = "delete from traffic_police_reg where tp_id=" + str(police_id) + ""
iud(qry)
return ''' <script> alert('deleted');window.location='/view_traffic_police'</script>'''
def unblockuser():
lid = request.args.get('lid')
qry = "update login set type='user' where id=" + str(lid) + ""
iud(qry)
return ''' <script> alert('unblock');window.location='/admin_view_user'</script>'''
def deleteplace():
place_id = request.args.get('id')
qry = "delete from imp_place_reg where ip_id='" + str(place_id) + "'"
iud(qry)
return ''' <script> alert('deleted');window.location='/view_important_place'</script>'''
def deletesignal():
signal_id = request.args.get('id')
qry = "delete from trafficsignal_reg where ts_id=" + str(signal_id) + ""
iud(qry)
return ''' <script> alert('deleted');window.location='/view_traffic_signal'</script>'''