def populate_tickets(): #This will make every screening have 7,22 and 44 seats taken. for each in Screening.query.all(): ticket1 = Ticket(customer_id=1,screening_id=each.screening_id,seat_id=7) ticket2 = Ticket(customer_id=2,screening_id=each.screening_id,seat_id=22) ticket3 = Ticket(customer_id=3,screening_id=each.screening_id,seat_id=45) db.session.add(ticket1) db.session.add(ticket2) db.session.add(ticket3) db.session.commit()
def setUp(self): TestFactory.setUp(self) data = [] data.append(State(descripcion="abierto")) data.append(State(descripcion="cerrado")) data.append(Priority(descripcion="baja")) data.append(Priority(descripcion="Alta")) data.append(Department(descripcion="default")) data.append(Client(nombre="default")) db.session.add_all(data) db.session.commit() data = Ticket( titulo="prueba", content= """My money's in that office, right? If she start giving me some bullshit about it ain't there, and we got to go someplace else and get it, I'm gonna shoot you in the head then and there. Then I'm gonna shoot that bitch in the kneecaps, find out where my goddamn money is. She gonna tell me too. Hey, look at me when I'm talking to you, m**********r. You listen: we go in there, and that n***a Winston or anybody else is in there, you the first m**********r to get shot. You understand?""", email="*****@*****.**", client_id=1, department_id=1, priority_id=1, state_id=1, user_id=1) db.session.add(data) db.session.commit() self.path = '/tickets'
def book_ticket(data): user_name = data['userName'] phone_no = data['phoneNo'] show_time = data['showTime'] #Condition for Expiry : curTime - showTime < 8hr if not isActive(show_time): return {'result' : 'Enter valid Time'} #Checking Ticket count count = Ticket.query.filter_by(showTime = show_time).count() if count > 20: return { 'result' : 'Failure - Housefull!! More than 20 Tickets Exist!'} user = User.query.filter_by(userName = user_name , phoneNo = phone_no).first() if not user: new_user = User(userName = user_name , phoneNo = phone_no) db.session.add(new_user) db.session.commit() user = User.query.filter_by(userName = user_name , phoneNo = phone_no).first() new_entry = Ticket(userId = user.userId ,showTime = show_time) db.session.add(new_entry) db.session.commit() return { 'result' : 'Success - Ticket booked'}
def post(self, id): json_data = request.get_json() if not json_data: response = jsonify({'error': 'Invalid Input'}) response.status_code = 400 return response #deserialising json_data data = ticket_schema.load(json_data) project = Project.query.get_or_404(id) if not project: response = {'error': 'Project not found'} return resoponse, 400 ticket = Ticket() ticket.project_id = project.id ticket.subject = data['subject'] ticket.description = data['description'] ticket.priority = data['priority'] db.session.add(ticket) db.session.commit() return make_response(jsonify(data), 200)
def create_ticket(old_id=None, event_id=None, order_id=None, eventdate_id=None, ticket_type=None, name=None, price=None, status=None, ticket_number=None): data = { 'old_id': old_id, 'event_id': event_id, 'order_id': order_id, 'ticket_type': ticket_type, 'eventdate_id': eventdate_id, 'name': name, 'price': price, 'status': status, 'ticket_number': ticket_number, } ticket = Ticket(**data) dao_create_record(ticket) return ticket
def create_ticket(description, reclamation, delay, customer_service=False, is_open=False): if customer_service: assigned = User.query.get(random.randint(22, 31)) else: assigned = User.query.get(random.randint(2, 21)) requester = assigned.team.team_leader if is_open: finished_date = None else: finished_date = reclamation.informed_date + timedelta( days=delay + random.randint(0, 2)) ticket = Ticket( ticket_requester=requester, ticket_assigned=assigned, description_ticket=description, reclamation=reclamation, due_date=reclamation.informed_date + timedelta(days=20), finished_date=finished_date, ) db.session.add(ticket) ticket.creation_date = reclamation.informed_date db.session.commit() create_notification(ticket.id, assigned, requester, ticket.creation_date, reclamation)
def post(self): args = post_parser.parse_args() keys = Key.query.all() result = '' for row in keys: if(args.content.find(row.word) > -1): result = result + ' ' + row.word ticket = Ticket( titulo = args.titulo, content = args.content, keys = result, email = args.email, telefono = args.telefono, celular = args.celular, client_id = args.client_id, department_id = args.department_id, priority_id = args.priority_id, state_id = 1, user_id = args.user_id ) db.session.add(ticket) db.session.commit() text_body = render_template('email/new_ticket.txt',ticket=ticket) html_body=render_template('email/new_ticket.html',ticket=ticket) #send_email("[{}] Nueva solicitud".format(Config.SITENAME),Config.MAILSYS,[args.email],text_body, html_body) return ticket,201
def setUp(self): """ Will be called before every test """ db.create_all() # create test admin user user = User(name="Rohit", password="******",position="Stuccan",department="controls") # save users to database db.session.add(user) db.session.commit() #create static data if User.query.count()==1: user_id = user.id location = Location(description="ABQ-First") db.session.add(location) db.session.commit() inventory = Inventory(inventory_type="Fist Inv",purchased_by=user_id,location=location.id) db.session.add(inventory) db.session.commit() ticket_types = TicketType(description="First ticket_type") db.session.add(ticket_types) db.session.commit() ticket = Ticket(ticket_type=ticket_types.id,opened_by=user_id,updated_by=user_id,description="First Ticket") db.session.add(ticket) db.session.commit()
def createticket(): form = TicketCreate() title = 'Ticket' user = User.query.filter_by(username=current_user.username) if request.method == 'POST': try: acctid = request.form['cx_id'] acctname = request.form['cx_name'] sql = text('ALTER TABLE Ticket AUTO_INCREMENT = 80000000') db.engine.execute(sql) db.session.commit() ticket = Ticket(account_id=acctid, contact_name=acctname, description=form.description.data, version=form.version.data, priority=form.priority.data, status=form.status.data, o365=form.o365.data, o365status=form.o365status.data, assigned_to=form.assigned_to.data) db.session.add(ticket) t = Ticket.query.all() for x in t: print(x.id) db.session.commit() except: print("I failed during create ticket") return render_template('createticket.html', month=month, user=user, title=title, form=form)
def user_page(): ticket = Ticket( requester_id=current_user.id, status=TicketStatus.OPEN, create_date=datetime.now(), ) form = TicketForm(request.form, obj=ticket) print(current_user) print(current_user.__dict__) print(current_user.id) if form.validate_on_submit(): # Copy form fields to user_profile fields form.populate_obj(ticket) # Save ticket db.session.add(ticket) db.session.commit() # reset form and flash success flash("Successfully created ticket", "success") else: for field, errors in form.errors.items(): for error in errors: flash( "Error in the %s field - %s" % (getattr(form, field).label.text, error), "error", ) # Pull all tickets requested by this user for display tickets = current_user.requested_tickets return render_template("main/user_page.html", form=form, tickets=tickets)
def buy(id=None): form = TicketForm() flight = Flight.query.filter_by(flight_num=id).first_or_404() if session['type'] == 1: email= session['username'] booking_agent_ID = '' elif session['type'] == 2: email = '' agent = Agent.query.filter(Agent.email == session['username']).first() booking_agent_ID = agent.booking_agent_id if flight.rest_seat == 0: flash("The rest ticket are zero and cannot be purchased.") return redirect(url_for("home.index")) if form.validate_on_submit(): data = form.data ticket = Ticket( ticket_id=''.join(random.sample(string.ascii_letters + string.digits, 6)), user_email = data["email"], airline_name = flight.airline_name, flight_num = data["flight_num"], price = data["price"], booking_agent_ID = booking_agent_ID ) db.session.add(ticket) flight.rest_seat = flight.rest_seat-1 db.session.add(flight) db.session.commit() flash("Buy success!") return redirect(url_for("home.index")) return render_template("home/buy-flight.html",form=form,flight=flight,email=email)
def ticket(): form = TicketForm() if form.validate_on_submit(): ticket = Ticket(description=form.description.data, author=current_user, priority=form.priority.data, link=form.link.data, tag='open') db.session.add(ticket) db.session.commit() flash('Your ticket is now live!') return redirect(url_for('index')) return render_template('ticket.html', title='Home', form=form)
def create_ticket(): form = SupportForm() if form.validate_on_submit(): ticket = Ticket(body=form.message.data, author=current_user) db.session.add(ticket) db.session.commit() flash(_('Thanks for contributing the issue. You ticket has been submitted!')) return redirect(url_for('tips.get_tip')) return render_template('support/new_ticket.html', title='Create new ticket', form=form)
def post(self): ticket = Ticket() args = parser.parse_args() merge(ticket, args) with safe_session(db): db.session.add(ticket) return {Const.MESSAGE_KEY: '工单表创建成功'}, Const.STATUS_OK
def home(): form = TicketForm() if form.validate_on_submit(): ticket = Ticket(requester=form.requester.data, request=form.request.data, urgency=form.urgency.data) db.session.add(ticket) db.session.commit() flash('Your ticket has been sent') return render_template('tickets.html', title='Home', form=form)
def build_ticket(): form = Add_ticket() if form.validate_on_submit(): info = Ticket(number=form.number.data, summary=form.summary.data, ticket_type=form.ticket_type.data, assinge_date=form.assigne_date.data, assigne_id=form.assigne_id.data) info.save() return redirect(url_for('main.index')) return render_template('main/build_ticket.html', form=form)
def store(): if request.method == 'POST': fname = request.form['fname'] lname = request.form['lname'] from1 = request.form['from1'] to1 = request.form['to1'] date = request.form['date'] type1 = request.form['type1'] count = request.form['count'] class1 = request.form['class1'] email = request.form['email'] tel = request.form['tel'] payment = request.form.getlist('payment') payment = payment[0] l = [fname, lname, from1, to1, date, type1, count, class1, email, tel, payment] pnr = randint(1000000000,10000000000) pnr_list = [] for ele in Ticket.query.all(): pnr_list.append(ele.pnr) while pnr in pnr_list: pnr = randint(1000000000,10000000000) try: try: db.session.add(Ticket(pnr=pnr, fname=fname, lname=lname, from1=from1, to1=to1, date=date, type1=type1, count=count, class1=class1, email=email, tel=tel, payment=payment)) db.session.commit() return render_template('index.html',response = 'Ticked Booked Sucessfully') except: db.create_all() db.session.add(Ticket(pnr=pnr, fname=fname, lname=lname, from1=from1, to1=to1, date=date, type1=type1, count=count, class1=class1, email=email, tel=tel, payment=payment)) db.session.commit() return render_template('index.html',response = 'Ticked Booked Sucessfully') except: return render_template('index.html',response = 'Something Went Wrong') elif request.method == 'GET': return render_template('index.html',response = '')
def generate_random_ticket(capacity): """ Randomly generate tickets based on plane's capacity """ tickets = [] col = 6 rows = int(capacity/col) for row in range(rows): for col in range(1, col+1): ticket = Ticket(seat_number=plane_rows[row] + str(col), available=True, price=random.choice(prices)) tickets.append(ticket) return tickets
def createticket_form(idd): project = Project.query.get(int(idd)) #only admin and pm allowed if current_user.role != "Developer": if request.method == "POST": title=request.form.get("title") description = request.form.get("description") assigned = request.form.get("assigned") priority = request.form.get("priority") status = request.form.get("status") ticket_type = request.form.get("type") #create ref num ref_n = [] for _ in range(6): n = random.randint(0, 9) ref_n.append(str(n)) ref_num = "".join(ref_n) #check assigned developer check_assigned_dev = User.query.filter_by(email=assigned).first() if check_assigned_dev: #save ticket to database new_ticket = Ticket(title = title, description = description,assigned_dev = assigned,ticket_type = ticket_type, priority = priority,status = status, ref_num = int(ref_num), user_ticket= current_user, project_ticket = project) db.session.add(new_ticket) db.session.commit() #add log to ticket history get_ticket = Ticket.query.filter_by(title=title).first() log = "created this ticket" add_log(current_user.name, get_ticket, log) #add notifictaion details = "%s created a ticket and assigned to %s " % ( current_user.name, check_assigned_dev.name) a_dev = check_assigned_dev.name link = "/mytickets" add_notification(details, a_dev, link) flash("Ticket Created") return redirect(url_for("main.mytickets")) else: flash("Assigned developer not found") return redirect(url_for("main.createticket_form", idd = idd)) users =project.team return(render_template("createticket.html", project= project, users=users)) else: abort(404)
def test_post_new_ticket_and_reply(self): #create user and ticket author = self.create_dummy_user("*****@*****.**") ticket = Ticket(tickettitle="test title", ticketrequest="test body", user=author) response = self.client.post(url_for("main.new_ticket"), data={ "tickettitle": "test title", "ticketrequest": "test ticket body"}, follow_redirects=True) self.assertIn(b"test ticket body", response.data) self.assertIn(b"john", response.data) #create ticket comment response = self.client.post(url_for("main.ticket", ticketnum=ticket.id), data={ "commentbody": "test comment body" }, follow_redirects=True) self.assertIn(b"test comment body", response.data)
def new_ticket(rec_id=0): if rec_id == 0: form = TicketForm() if form.validate_on_submit(): new_ticket = Ticket( ticket_requester=current_user, ticket_assigned=form.assigned_employee.data, due_date=form.due_date.data, description_ticket=form.description_ticket.data, reclamation=form.reclamation.data, ) db.session.add(new_ticket) db.session.commit() send_message(Ticket, new_ticket.id, new_ticket.ticket_assigned) return redirect( url_for("ticket_bp.ticket", ticket_number=str(new_ticket.id))) else: form = TicketFromReclamationForm() reclamation = Reclamation.query.filter_by( id=int(rec_id)).first_or_404() form.reclamation.data = reclamation if form.validate_on_submit(): new_ticket = Ticket( ticket_requester=current_user, ticket_assigned=form.assigned_employee.data, due_date=form.due_date.data, description_ticket=form.description_ticket.data, reclamation=reclamation, ) db.session.add(new_ticket) db.session.commit() send_message(Ticket, new_ticket.id, new_ticket.ticket_assigned) return redirect( url_for("ticket_bp.ticket", ticket_number=str(new_ticket.id))) return render_template("ticket/new_ticket.html", form=form)
def ticket(): form = TicketForm(current_user.username) if form.validate_on_submit(): tickets = Ticket(c_num=form.c_num.data, m_num=form.m_num.data, p_person=form.p_person.data, p_role=form.p_role.data, t_date=form.t_date.data, p_price=form.p_price.data, t_payment=form.t_payment.data) db.session.add(tickets) db.session.commit() flash(_('Submit Success!')) return redirect(url_for('main.user')) return render_template('ticket.html', title=_('Ticket'), form=form)
def add_tickets(): form = TicketSetForm() admin_list = [1] if int(current_user.get_id()) in admin_list: if form.validate_on_submit(): if Train.query.get(form.train_number.data): data = Ticket(cost=form.cost.data, train_id=form.train_number.data, user_id=form.owner.data) db.session.add(data) db.session.commit() return redirect(url_for('add_tickets')) else: flash('Такого поезда не существует!') return redirect(url_for('add_tickets')) else: return redirect(url_for('tickets')) return render_template('admin_panel_ticket.html', title='Добавление билетов', form=form)
def CreateTicket(): form = forms.RegisterTicket() if form.validate_on_submit(): expireDate = form.departureDate.data - timedelta(days=7) if form.arrivalDate.data < form.departureDate.data: errorMessage = ( '%s must be greater than %s' % (form.arrivalDate.label.text, form.departureDate.label.text)) form.arrivalDate.errors.append(errorMessage) return render_template('employee/flights/addTicket.html', form=form) if form.returnDate.data < form.arrivalDate.data: errorMessage = ( '%s must be greater than %s' % (form.returnDate.label.text, form.arrivalDate.label.text)) form.returnDate.errors.append(errorMessage) return render_template('employee/flights/addTicket.html', form=form) newTicket = Ticket(origin=form.origin.data, arrival=form.arrival.data, flightNo=form.flightNo.data, departureDate=form.departureDate.data, departureTime=form.departureTime.data, arrivalDate=form.arrivalDate.data, arrivalTime=form.arrivalTime.data, returnDate=form.returnDate.data, returnTime=form.returnTime.data, expirationDate=expireDate, remainingSlots=form.slots.data, isPackaged=form.isPackaged.data, price=form.price.data) db.session.add(newTicket) user = current_user fullName = user.firstName + ' ' + user.lastName if user.role == "AD": role = "Admin" elif user.role == "RO": role = "Reservation Officer" else: role = "Financial Officer" event = (fullName + ' (' + role + ') created ' + form.flightNo.data + ' (' + form.origin.data + '-' + form.arrival.data + ')') newLogTrail = LogTrail(event=event) db.session.add(newLogTrail) db.session.commit() return redirect(url_for('main.UserHomeRO')) return render_template('employee/flights/addTicket.html', form=form)
def new_ticket(): if request.method == 'GET': clients = Client.query.all() products = ProductArea.query.all() users = TicketUser.query.all() return render_template('new_ticket.html', clients=clients, products=products, users=users) else: title = request.form['title'] description = request.form['description'] top_queue = False if request.form.get('top_queue'): top_queue = True if request.form['top_queue'].lower( ) == 'on' else False target_date = request.form['target_date'] client_id = request.form['client'] product_area_id = request.form['product_area'] ticket_url = request.form['ticket_url'] user_id = request.form['assigned_to'] client = Client.query.get(int(client_id)) product_area = ProductArea.query.get(int(product_area_id)) user = TicketUser.query.get(int(user_id)) if top_queue == True: for ticket in client.tickets: ticket.decrease_priority() ticket = Ticket( title=title, description=description, priority=1 if top_queue == True else len(client.tickets) + 1, target=parse_date(target_date), ticket_url=ticket_url, client=client, product_area=product_area, assigned_to=user) db.session.add(ticket) db.session.commit() ticket.add_log(constants.TICKET_LOG_TYPE_STATUS_CHANGE) return redirect(url_for('tickets'))
def create(self, validated_data): log.debug("TicketCreateSerializer:create") instance = Ticket() title = validated_data.get('title', "No Title") description = validated_data.get('description', "No Description") user = validated_data.get('user', None) speed_test = validated_data.get("speed_test", None) wifi_points = validated_data.get("wifi_points", None) location_point = validated_data.get("location_point", None) instance.title = title instance.description = description instance.user = user if user else None instance.speed_test = speed_test instance.wifi_points = wifi_points instance.location_point = location_point instance.save() return instance
def create_user_ticket(user_id): data = request.get_json(force=True) ticket = Ticket( price=float(data["price"]), flight_id=data["flight_id"], type_id=data["type_id"], user_id=user_id ) db.session.add(ticket) db.session.commit() ticket = Ticket.query.filter_by(id=ticket.id).first() return jsonify( id=ticket.id, price=float(ticket.price), flight_id=ticket.flight_id, type_id=ticket.type_id, user_id=ticket.user_id )
def tickets(): form = CreateTicketForm() if form.validate_on_submit(): ticket = Ticket(title=form.title.data, content=form.content.data, department=form.department.data, file=form.file.data, priority=form.priority.data, email=form.email.data, name=form.name.data) db.session.add(ticket) db.session.commit() user = Ticket.query.filter_by(email=form.email.data).first() if user: send_ticket_details(user) flash('Ticket submitted successfully') return redirect(url_for('index')) return render_template('ticket.html', title='Tickets', form=form)
def mock_ticket(): ticket = Ticket( ticket_id='tid01', tel_phone='1199883', idcard_num="988223", ticket_date='[2018-12-15][2018-12-16]', start_from='[北京][北京北][北京东][北京南][北京西][昌平北]', end_to='[汉口][武昌][武汉]', train_number='[C7084][D944][T96][G2922]', passengers= '[岑晓威,1,440307199608140313_1][付新鹏,1,652325199009083410_1][方章伟,1,445224199104012452_1][黄河长,1,43282219761010097X_1][康志香,1,430523198004150064]', passenger_num=5, success_rate=80, price=100, status=1, seat_type='[一等座][二等座][软卧][硬卧][硬座]', is_student=0, from_to='北京--武汉') return ticket
def data_load(): u = User(userid='grasmed', fullname='Jon Gras') db.session.add(u) t = Ticket(ticket='REQ-1234', sponsor='OAA', status='In Process', title='Do this work for me') db.session.add(t) w = Worklog(workdate=datetime.now(), hours=2.5, message='did work', u_log=u, t_log=t) db.session.add(w) db.session.commit() return 'Loaded'