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>'''