def create_ticket():
data = request.get_json() or {}
if 'title' not in data or 'content' not in data or 'category_id' not in data or 'ticket_priority_id' not in data:
return bad_request('Must include title, content, category_id and ticket_priority_id.')
if not isinstance(data['category_id'], int) or not isinstance(data['ticket_priority_id'], int):
return bad_request('ticket_priority_id and category_id must be integers.')
if not FlicketCategory.query.filter_by(id=data['category_id']).first():
return bad_request('not a valid category_id')
if not FlicketPriority.query.filter_by(id=data['ticket_priority_id']).first():
return bad_request('not a valid ticket_priority_id')
ticket = FlicketTicket()
ticket.from_dict(data)
ticket.started_id = g.current_user.id
ticket.date_added = datetime.datetime.now()
ticket.status_id = 1
db.session.add(ticket)
db.session.commit()
response = jsonify(ticket.to_dict())
response.status_code = 201
response.headers['Location'] = url_for('bp_api.get_ticket', id=ticket.id)
return response
def topic_creation():
# if the number of topics is already satisfied don't add any more.
topic_count = FlicketTicket.query.count()
if topic_count == num_topics:
print('Topic number already satisfied')
return
for i in range(topic_count, num_topics):
new_ticket = FlicketTicket(
title=get_random_words(),
content=get_random_sentence(),
user=get_random_user(),
date_added=datetime.datetime.now(),
current_status=get_random_status(),
ticket_priority=get_random_priority(),
category=get_random_category(),
assigned=get_random_user()
)
db.session.add(new_ticket)
mess_1 = "#{}: ticket ....".format(i)
print(mess_1, end="\r")
replies = randint(0, num_replies)
for ii in range(0, replies):
create_ticket_reply(new_ticket)
mess_2 = mess_1 + "adding replies ... # {}".format(ii)
print(mess_2, end="\r")
db.session.commit()
def create_ticket(title=None,
user=None,
content=None,
priority=None,
category=None,
files=None,
hours=0):
"""
:param title:
:param user:
:param content:
:param priority:
:param category:
:param files:
:param hours:
:return:
"""
ticket_status = FlicketStatus.query.filter_by(status="Open").first()
ticket_priority = FlicketPriority.query.filter_by(
id=int(priority)).first()
ticket_category = FlicketCategory.query.filter_by(
id=int(category)).first()
upload_attachments = UploadAttachment(files)
if upload_attachments.are_attachments():
upload_attachments.upload_files()
date_added = datetime.datetime.now()
# submit ticket data to database
new_ticket = FlicketTicket(
title=title,
date_added=date_added,
user=user,
current_status=ticket_status,
content=content,
ticket_priority=ticket_priority,
category=ticket_category,
hours=hours,
last_updated=date_added,
)
db.session.add(new_ticket)
# add attachments to the database
upload_attachments.populate_db(new_ticket)
# subscribe user to ticket.
subscribe = FlicketSubscription(user=user, ticket=new_ticket)
db.session.add(subscribe)
# add count of 1 to users total posts.
user.total_posts += 1
db.session.commit()
return new_ticket
def ticket_create():
form = CreateTicketForm()
if form.validate_on_submit():
# this is a new post so ticket status is 'open'
ticket_status = FlicketStatus.query.filter_by(status='open').first()
ticket_priority = FlicketPriority.query.filter_by(
id=int(form.priority.data)).first()
ticket_category = FlicketCategory.query.filter_by(
id=int(form.category.data)).first()
files = request.files.getlist("file")
upload_attachments = UploadAttachment(files)
if upload_attachments.are_attachements():
upload_attachments.upload_files()
# submit ticket data to database
new_ticket = FlicketTicket(title=form.title.data,
date_added=datetime.datetime.now(),
user=g.user,
current_status=ticket_status,
content=form.content.data,
ticket_priority=ticket_priority,
category=ticket_category)
db.session.add(new_ticket)
# add attachments to the dataabase.
upload_attachments.populate_db(new_ticket)
# subscribe user to ticket
subscribe = FlicketSubscription(user=g.user, ticket=new_ticket)
db.session.add(subscribe)
# commit changes to the database
db.session.commit()
# send email
# TEST SEND EMAIL HERE
f_mail = FlicketMail()
f_mail.create_ticket(ticket=new_ticket)
flash('New Ticket created.', category='success')
return redirect(
url_for('flicket_bp.ticket_view', ticket_id=new_ticket.id))
return render_template('flicket_create.html',
title='Flicket - Create Ticket',
form=form)
def __init__(self, user):
title = 'I have a problem with my mouse'
content = 'It squeeks! most troublesome.'
status = FlicketStatus.query.first()
priority = FlicketPriority.query.first()
category = FlicketCategory.query.first()
self.ticket = FlicketTicket(title=title,
date_added=datetime.datetime.now(),
user=user,
current_status=status,
content=content,
ticket_priority=priority,
category=category)
db.session.add(self.ticket)
db.session.commit()
def topic_creation(num_topics_):
# if the number of topics is already satisfied don't add any more.
topic_count = FlicketTicket.query.count()
if topic_count >= num_topics_:
print('Topic number already satisfied')
return
else:
num_topics_ = num_topics_ - topic_count
for i in range(topic_count, num_topics_):
t = Text()
new_ticket = FlicketTicket(
title=t.title()[0:field_size['title_max_length']],
content=t.text(randint(3, 15)),
user=get_random_user(),
date_added=datetime.datetime.now(),
current_status=get_random_status(),
ticket_priority=get_random_priority(),
category=get_random_category(),
assigned=get_random_user()
)
new_ticket.user.total_posts += 1
db.session.add(new_ticket)
mess_1 = "#{}: ticket ....".format(i)
print(mess_1, end="\r")
replies = randint(0, num_replies)
for ii in range(0, replies):
create_ticket_reply(new_ticket)
mess_2 = mess_1 + "adding replies ... # {}".format(ii)
print(mess_2, end="\r")
db.session.commit()
def create_ticket():
data = request.get_json() or {}
if "title" not in data or "content" not in data or "domain_id" not in data:
return bad_request("Must include title, content, domain_id")
if not FlicketDomain.query.filter_by(id=data["domain_id"]).first():
return bad_request("not a valid domain_id")
ticket = FlicketTicket()
ticket.from_dict(data)
ticket.started_id = g.current_user.id
ticket.date_added = datetime.datetime.now()
ticket.status_id = 1
db.session.add(ticket)
db.session.commit()
response = jsonify(ticket.to_dict())
response.status_code = 201
response.headers["Location"] = url_for("bp_api.get_ticket", id=ticket.id)
return response
def create_ticket(
title=None,
user=None,
content=None,
requester=None,
referee=None,
requester_role=None,
request_stage=None,
procedure_stage=None,
domain=None,
institute=None,
files=None,
days=0,
):
"""
:param title:
:param user:
:param content:
:param requester:
:param requester_role:
:param domain:
:param files:
:param days:
:return:
"""
ticket_status = FlicketStatus.query.filter_by(status="Open").first()
ticket_institute = FlicketInstitute.query.filter_by(
id=int(institute)).first()
ticket_domain = FlicketDomain.query.filter_by(id=int(domain)).first()
requester_role = FlicketRequesterRole.query.filter_by(
id=int(requester_role)).first()
request_stage = FlicketRequestStage.query.filter_by(
request_stage="New").first()
procedure_stage = FlicketProcedureStage.query.filter_by(
id=int(procedure_stage)).first()
upload_attachments = UploadAttachment(files)
if upload_attachments.are_attachments():
upload_attachments.upload_files()
# submit ticket data to database
new_ticket = FlicketTicket(
title=title,
date_added=datetime.datetime.now(),
user=user,
current_status=ticket_status,
content=content,
institute=ticket_institute,
requester=requester,
referee=referee,
requester_role=requester_role,
request_stage=request_stage,
procedure_stage=procedure_stage,
domain=ticket_domain,
days=days,
)
db.session.add(new_ticket)
# add attachments to the database
upload_attachments.populate_db(new_ticket)
# subscribe user to ticket.
subscribe = FlicketSubscription(user=user, ticket=new_ticket)
db.session.add(subscribe)
# add count of 1 to users total posts.
user.total_posts += 1
db.session.commit()
return new_ticket