def delete(self, id):
response = ResponseBuilder()
sponsor = db.session.query(Sponsor).filter_by(id=id)
if sponsor.first():
sponsor_dict = sponsor.first().as_dict()
if sponsor_dict['attachment'] is not None:
Helper().silent_remove(current_app.config['STATIC_DEST'] +
sponsor_dict['attachment'])
sponsor.delete()
db.session.commit()
return response.set_message('data deleted').set_data(None).build()
return response.set_message('data not found').set_error(True).build()
def delete(self, id):
response = ResponseBuilder()
self.model_booth_gallery = db.session.query(BoothGallery).filter_by(id=id)
if self.model_booth_gallery.first() is not None:
# delete file
os.remove(current_app.config['STATIC_DEST'] + self.model_booth_gallery.first().url)
# delete row
self.model_booth_gallery.delete()
db.session.commit()
return response.set_message('data deleted successfully').set_error(False).build()
else:
return response.set_message('data not found').set_error(True).build()
def postIncludes(self, includes):
response = ResponseBuilder()
user_id = self.model_user.as_dict()['id']
entityModel = eval(includes['name'])()
entityModel.user_id = user_id
for key in includes:
if key is not 'name':
setattr(entityModel, key, includes[key])
db.session.add(entityModel)
try:
db.session.commit()
if includes['name'] == 'Booth':
user_booth = UserBooth()
user_booth.user_id = user_id
user_booth.booth_id = entityModel.as_dict()['id']
db.session.add(user_booth)
db.session.commit()
return response.set_data(None).build()
except SQLAlchemyError as e:
data = e.args
return response.set_message(data).set_error(True).set_data(
None).build()
def update_photo(self, payloads, id):
response = ResponseBuilder()
try:
user_photo = db.session.query(UserPhoto).filter_by(user_id=id)
file = payloads['photo']
photo = None
photo = self.save_file(file, id)
if user_photo.first() is None:
user_photo = UserPhoto()
user_photo.user_id = id
user_photo.url = photo
db.session.add(user_photo)
db.session.commit()
return response.set_message('Photo updated').set_data(None).build()
if photo:
user_photo.update({
'url': photo,
'updated_at': datetime.datetime.now()
})
db.session.commit()
data = user_photo.first().as_dict()
return response.set_data(data).build()
except SQLAlchemyError as e:
data = e
return response.set_error(True).set_data(data).build()
def delete(self, id):
response = ResponseBuilder()
source = db.session.query(Source).filter_by(id=id)
if source.first() is not None:
# delete row
source.delete()
db.session.commit()
return response.set_message('data deleted').build()
else:
return response.set_data(None).set_message('data not found').set_error(True).build()
def delete(self, id):
response = ResponseBuilder()
rundown = db.session.query(RundownList).filter_by(id=id)
if rundown.first() is not None:
# delete row
rundown.delete()
db.session.commit()
return response.set_message('data deleted').build()
else:
data = 'data not found'
return response.set_data(None).set_message(data).set_error(True).build()
def delete(self, id):
response = ResponseBuilder()
packagemanagement = db.session.query(PackageManagement).filter_by(
id=id)
if packagemanagement.first() is not None:
packagemanagement.delete()
db.session.commit()
return response.set_message('Package entry was deleted').build()
else:
data = 'Entry not found'
return response.set_data(None).set_message(data).set_error(
True).build()
def delete(self, id):
response = ResponseBuilder()
orderverification = db.session.query(OrderVerification).filter_by(id=id).first()
if orderverification.payment_proof is not None:
Helper().silent_remove(current_app.config['STATIC_DEST'] + orderverification.payment_proof)
orderverification = db.session.query(OrderVerification).filter_by(id=id)
if orderverification.first() is not None:
orderverification.delete()
db.session.commit()
return response.set_message('Order Verification entry was deleted').build()
else:
data = 'Entry not found'
return response.set_data(None).set_message(data).set_error(True).build()
def credit_payment(self, payloads):
response = ResponseBuilder()
if not all(
isinstance(string, str) for string in [
payloads['order_id'], payloads['email'],
payloads['first_name'], payloads['last_name'],
payloads['phone'], payloads['card_number'],
payloads['card_exp_month'], payloads['card_exp_year'],
payloads['card_cvv'], payloads['client_key']
]) and not isinstance(payloads['gross_amount'], int):
return response.build_invalid_payload_response()
# get the token id first
token_id = requests.get(
url + 'card/register?' + 'card_number=' + payloads['card_number'] +
'&card_exp_month=' + payloads['card_exp_month'] +
'&card_exp_year=' + payloads['card_exp_year'] + '&card_cvv=' +
payloads['card_cvv'] + '&bank=' + payloads['bank'] + '&secure=' +
'true' + '&gross_amount=' + str(payloads['gross_amount']) +
'&client_key=' + payloads['client_key'],
headers=self.headers)
token_id = token_id.json()
# prepare data
data = {}
if 'status_code' in token_id and token_id['status_code'] == '200':
data['saved_token_id'] = token_id['saved_token_id']
data['masked_card'] = token_id['masked_card']
else:
return response.set_message(
token_id['validation_messages'][0]).set_error(True).build()
# check for referal discount
ref = self.get_order_referal(payloads['order_id'])
# generate order details payload
item_details = self.get_order_details(payloads['order_id'], ref)
data['payment_type'] = payloads['payment_type']
data['transaction_details'] = {}
data['transaction_details']['order_id'] = payloads['order_id']
data['transaction_details']['gross_amount'] = payloads['gross_amount']
data['credit_card'] = {}
data['credit_card']['token_id'] = token_id['saved_token_id']
data['item_details'] = item_details
data['customer_details'] = {}
data['customer_details']['first_name'] = payloads['first_name']
data['customer_details']['last_name'] = payloads['last_name']
data['customer_details']['email'] = payloads['email']
data['customer_details']['phone'] = payloads['phone']
return self.send_to_midtrans_api(data)
def delete(self, id):
response = ResponseBuilder()
prizelist_dict = db.session.query(PrizeList).filter_by(id=id).first()
if prizelist_dict.attachment is not None:
os.remove(current_app.config['STATIC_DEST'] +
prizelist_dict.attachment)
prizelist = db.session.query(PrizeList).filter_by(id=id)
if prizelist.first() is not None:
prizelist.delete()
db.session.commit()
return response.set_message('Prize list entry was deleted').build()
else:
data = 'Entry not found'
return response.set_data(None).set_message(data).set_error(
True).build()
def create(self, payloads):
response = ResponseBuilder()
codes = [r.code for r in db.session.query(RedeemCode.code).all()]
for i in range(0, int(payloads['count'])):
code = secrets.token_hex(4)
while (code in codes):
code = secrets.token_hex(4)
self.model_redeem_code = RedeemCode()
self.model_redeem_code.codeable_type = payloads['codeable_type']
self.model_redeem_code.codeable_id = payloads['codeable_id']
self.model_redeem_code.code = code
self.model_redeem_code.used = False
db.session.add(self.model_redeem_code)
db.session.commit()
return response.set_message('Redeem code created successfully').set_data(None).set_error(False).build()
def show(self, speaker):
response = ResponseBuilder()
speaker_document = db.session.query(SpeakerDocument).filter_by(
speaker_id=speaker['id']).order_by(
SpeakerDocument.created_at.desc()).all()
if speaker_document is not None:
speaker_document = BaseModel.as_list(speaker_document)
for _speaker_document in speaker_document:
_speaker_document['material'] = Helper().url_helper(
_speaker_document['material'],
app.config['GET_SPEAKER_DOC_DEST'])
user = db.session.query(User).filter_by(
id=speaker['user_id']).first().include_photos().as_dict()
_speaker_document['user'] = user
return response.set_data(speaker_document).build()
else:
data = 'data not found'
return response.set_message(data).set_data(None).build()
def purchase(self, payloads):
response = ResponseBuilder()
codes = [r.code for r in db.session.query(RedeemCode.code).all()]
package = db.session.query(PackageManagement).filter_by(id=payloads['package_id']).first()
payloads['count'] = package.quota
for i in range(0, int(payloads['count'])):
code = secrets.token_hex(4)
while (code in codes):
code = secrets.token_hex(4)
self.model_redeem_code = RedeemCode()
self.model_redeem_code.codeable_type = payloads['codeable_type']
self.model_redeem_code.codeable_id = payloads['codeable_id']
self.model_redeem_code.code = code
self.model_redeem_code.used = False
db.session.add(self.model_redeem_code)
db.session.commit()
return response.set_message('Redeem code created successfully').set_data(package.as_dict()).set_error(False).build()
def purchase_user_redeems(self, payloads):
response = ResponseBuilder()
codes = [r.code for r in db.session.query(RedeemCode.code).all()]
ticket = db.session.query(Ticket).filter_by(id=payloads['ticket_id']).first()
for i in range(0, ticket.quota):
code = secrets.token_hex(4)
while (code in codes):
print(code)
code = secrets.token_hex(4)
self.model_redeem_code = RedeemCode()
self.model_redeem_code.codeable_type = 'user'
self.model_redeem_code.codeable_id = payloads['codeable_id']
self.model_redeem_code.code = code
self.model_redeem_code.used = False
db.session.add(self.model_redeem_code)
db.session.commit()
return response.set_message('Redeem code created successfully').set_data(None).set_error(False).build()
