def bch_send_coin(user_id, sendto, amount, comment):
"""
Add work order to send off site
:param user_id:
:param sendto:
:param amount:
:param comment:
:return:
"""
timestamp = datetime.utcnow()
getwallet = db.session\
.query(Bch_WalletFee)\
.filter_by(id=1)\
.first()
walletfee = getwallet.btc
a = bch_check_balance(user_id=user_id, amount=amount)
if a == 1:
strcomment = str(comment)
type_transaction = 2
userswallet = db.session\
.query(Bch_Wallet)\
.filter_by(user_id=user_id)\
.first()
wallet = Bch_WalletWork(user_id=user_id,
type=type_transaction,
amount=amount,
sendto=sendto,
comment=0,
created=timestamp,
txtcomment=strcomment,
shard=userswallet.shard)
db.session.add(wallet)
# turn sting to a decimal
amountdecimal = Decimal(amount)
# make decimal 8th power
amounttomod = floating_decimals(amountdecimal, 8)
# gets current balance
curbalance = floating_decimals(userswallet.currentbalance, 8)
# gets amount and fee
amountandfee = floating_decimals(amounttomod + walletfee, 8)
# subtracts amount and fee from current balance
y = floating_decimals(curbalance - amountandfee, 8)
# set balance as new amount
userswallet.currentbalance = floating_decimals(y, 8)
db.session.add(userswallet)
else:
notification(type=34,
username='',
user_id=user_id,
salenumber=0,
bitcoin=amount)
def btc_cash_sendCoin(userid, sendto, amount, comment):
getwallet = btccash_walletFee.query.filter_by(id=1).first()
walletfee = getwallet.btc
a = checkbalance_btccash(userid=userid, amount=amount)
if a == 1:
strcomment = str(comment)
type_transaction = 2
timestamp = datetime.utcnow()
userswallet = btccash_Wallet.query.filter_by(userid=userid).first()
wallet = btccash_Wallet_Work(
userid=userid,
type=type_transaction,
amount=amount,
sendto=sendto,
comment=0,
created=timestamp,
txtcomment=strcomment,
shard=userswallet.shard
)
db.session.add(wallet)
db.session.commit()
# turn sting to a decimal
amountdecimal = Decimal(amount)
# make decimal 8th power
amounttomod = floating_decimals(amountdecimal, 8)
# gets current balance
curbalance = floating_decimals(userswallet.currentbalance, 8)
# gets amount and fee
amountandfee = floating_decimals(amounttomod + walletfee, 8)
# subtracts amount and fee from current balance
y = floating_decimals(curbalance - amountandfee, 8)
# set balance as new amount
userswallet.currentbalance = floating_decimals(y, 8)
db.session.add(userswallet)
db.session.commit()
else:
notification(
type=34,
username='',
userid=userid,
salenumber=0,
bitcoin=amount
)
def sendnotification(user_id, notetype):
"""
# This function send notifications
"""
# Positive
# 0 = wallet sent
# errors
# 100 = too litte or too much at withdrawl
# 102 = wallet error
# 103 = btc address error
# btc address error
notification(
thetypeofnote=notetype,
user_id=user_id,
)
def bch_send_coin_to_escrow(amount, comment, user_id):
"""
# TO clearnet_webapp Wallet
# this function will move the coin to clearnets wallet_btc from a user
:param amount:
:param comment:
:param user_id:
:return:
"""
a = bch_check_balance(user_id=user_id, amount=amount)
if a == 1:
try:
type_transaction = 4
userswallet = db.session\
.query(Bch_Wallet)\
.filter_by(user_id=user_id)\
.first()
curbal = Decimal(userswallet.currentbalance)
amounttomod = Decimal(amount)
newbalance = Decimal(curbal) - Decimal(amounttomod)
userswallet.currentbalance = newbalance
db.session.add(userswallet)
oid = int(comment)
bch_add_transaction(category=type_transaction,
amount=amount,
user_id=user_id,
comment='Sent Coin To Escrow',
shard=userswallet.shard,
orderid=oid,
balance=newbalance)
except Exception as e:
print(str(e))
notification(type=34,
username='',
user_id=user_id,
salenumber=comment,
bitcoin=amount)
else:
print("a equals", a)
notification(type=34,
username='',
user_id=user_id,
salenumber=comment,
bitcoin=amount)
def returns_2days():
"""
# after a return is initiated, the vendor has 2 days to provide a return address.
If not vendor keeps money
:return:
"""
# request return is 2
acceptedorders = db.session.query(Vendor_Orders)
acceptedorders = acceptedorders.filter(Vendor_Orders.completed == 0)
acceptedorders = acceptedorders.filter(Vendor_Orders.request_return == 2)
acceptedorders = acceptedorders.filter(Vendor_Orders.type == 1)
aorders = acceptedorders.all()
for accorder in aorders:
whenrequested = accorder.returncancelage
itemprice = Decimal(accorder.price)
shipprice = Decimal(accorder.shipping_price)
totalprice = Decimal(itemprice + shipprice)
comment = "Return time expired for order#:" + str(accorder.id)
sevenday = (whenrequested + timedelta(days=2))
if datetime.utcnow() > sevenday:
# Autofinalize so give to vendor
bch_send_coin_to_user(amount=totalprice,
comment=comment,
user_id=accorder.vendor_id)
# notify customer
notification(type=6,
username=accorder.customer,
user_id=accorder.customer_id,
salenumber=accorder.id,
bitcoin=accorder.totalprice)
# notify vendor
notification(type=6,
username=accorder.vendor,
user_id=accorder.vendor_id,
salenumber=accorder.id,
bitcoin=accorder.totalprice)
markascompleted(itemid=accorder.id)
db.session.commit()
def requestcancel_24rs():
"""
# this function is if customer requests return,
but vendor hasn't responded in 24 hrs.
auto cancels and refunds user
:return:
"""
acceptedorders = db.session.query(Vendor_Orders)
acceptedorders = acceptedorders.filter(Vendor_Orders.completed == 0)
acceptedorders = acceptedorders.filter(Vendor_Orders.type == 0)
acceptedorders = acceptedorders.filter(Vendor_Orders.request_cancel == 1)
aorders = acceptedorders.all()
for accorder in aorders:
whenrequested = accorder.returncancelage
itemprice = Decimal(accorder.price)
shipprice = Decimal(accorder.shipping_price)
totalprice = Decimal(itemprice + shipprice)
comment = "Order was canceled. Order#" + str(accorder.id)
nextday = (whenrequested + timedelta(days=1))
if datetime.utcnow() > nextday:
# Order was accepted but not shipped..return back to customer
# this function adds the work to db
bch_send_coin_to_user(amount=totalprice,
comment=comment,
user_id=accorder.customer_id)
# notify customer
notification(type=6,
username=accorder.customer,
user_id=accorder.customer_id,
salenumber=accorder.id,
bitcoin=accorder.totalprice)
# notify vendor
notification(type=6,
username=accorder.vendor,
user_id=accorder.vendor_id,
salenumber=accorder.id,
bitcoin=accorder.totalprice)
markascancelled(itemid=accorder.id)
db.session.commit()
def neworders_48hours():
"""
#this function is if the vendor didnt accepted in 48 hours. cancels gives back to customer
:return:
"""
acceptedorders = db.session.query(Vendor_Orders)
acceptedorders = acceptedorders.filter(Vendor_Orders.completed == 0)
acceptedorders = acceptedorders.filter(Vendor_Orders.type == 1)
acceptedorders = acceptedorders.filter(Vendor_Orders.new_order == 1)
aorders = acceptedorders.all()
for f in aorders:
whenbought = f.age
itemprice = Decimal(f.price)
shipprice = Decimal(f.shipping_price)
totalprice = Decimal(itemprice + shipprice)
comment = "Vendor accept expired. Automatic refund for order number " + str(
f.id)
twoday = (whenbought + timedelta(days=2))
if datetime.utcnow() > twoday:
# Order was not accepted in time. Give money back to customer
# this function adds the work to db
bch_send_coin_to_user(amount=totalprice,
comment=comment,
user_id=f.customer_id)
# notify customer
notification(type=6,
username=f.customer,
user_id=f.customer_id,
salenumber=f.id,
bitcoin=f.totalprice)
# notify vendor
notification(type=6,
username=f.vendor,
user_id=f.vendor_id,
salenumber=f.id,
bitcoin=f.totalprice)
markascancelled(itemid=f.id)
db.session.commit()
def acceptedorders_1week():
"""
#this function is for if the vendor didnt ship after 1 week. Cancel give back to customer
:return:
"""
acceptedorders = db.session.query(Vendor_Orders)
acceptedorders = acceptedorders.filter(Vendor_Orders.completed == 0)
acceptedorders = acceptedorders.filter(Vendor_Orders.type == 1)
acceptedorders = acceptedorders.filter(Vendor_Orders.accepted_order == 1)
aorders = acceptedorders.all()
for f in aorders:
whenbought = f.age
itemprice = Decimal(f.price)
shipprice = Decimal(f.shipping_price)
totalprice = Decimal(itemprice + shipprice)
comment = "Vendor didnt ship in time. Automatic refund for order number " + str(
f.id)
nextday = (whenbought + timedelta(days=7))
if datetime.utcnow() > nextday:
# Order was accepted but not shipped..return back to customer
# this function adds the work to db
bch_send_coin_to_user(amount=totalprice,
comment=comment,
user_id=f.customer_id)
# notify customer
notification(type=6,
username=f.customer,
user_id=f.customer_id,
salenumber=f.id,
bitcoin=f.totalprice)
# notify vendor
notification(type=6,
username=f.vendor,
user_id=f.vendor_id,
salenumber=f.id,
bitcoin=f.totalprice)
markascancelled(itemid=f.id)
db.session.commit()
def returns_14days():
"""
#after a return is marked as shipped by customer, vendor gets money in 14 days. If not
:return:
"""
acceptedorders = db.session.query(Vendor_Orders)
acceptedorders = acceptedorders.filter(Vendor_Orders.completed == 0)
acceptedorders = acceptedorders.filter(Vendor_Orders.request_return == 3)
acceptedorders = acceptedorders.filter(Vendor_Orders.type == 1)
aorders = acceptedorders.all()
for accorder in aorders:
whenreturned = accorder.returncancelage
itemprice = Decimal(accorder.price)
shipprice = Decimal(accorder.shipping_price)
totalprice = Decimal(itemprice + shipprice)
comment = "Return for order#:" + str(accorder.id)
nextday = (whenreturned + timedelta(days=14))
if datetime.utcnow() > nextday:
# Autofinalize so give to user
bch_send_coin_to_user(amount=totalprice,
comment=comment,
user_id=accorder.customer_id)
# notify customer
notification(type=6,
username=accorder.customer,
user_id=accorder.customer_id,
salenumber=accorder.id,
bitcoin=accorder.totalprice)
# notify vendor
notification(type=6,
username=accorder.vendor,
user_id=accorder.vendor_id,
salenumber=accorder.id,
bitcoin=accorder.totalprice)
markascompleted(itemid=accorder.id)
db.session.commit()
def btc_cash_sendCointoEscrow(amount, comment, userid):
a = checkbalance_btccash(userid=userid, amount=amount)
if a == 1:
try:
type_transaction = 4
userswallet = btccash_Wallet.query.filter_by(userid=userid).first()
curbal = Decimal(userswallet.currentbalance)
amounttomod = Decimal(amount)
newbalance = Decimal(curbal) - Decimal(amounttomod)
userswallet.currentbalance = newbalance
db.session.add(userswallet)
db.session.commit()
oid = int(comment)
btc_cash_addtransaction(category=type_transaction,
amount=amount,
userid=userid,
comment='Sent Coin To Escrow',
shard=userswallet.shard,
orderid=oid,
balance=newbalance
)
except Exception as e:
print(str(e))
notification(
type=34,
username='',
userid=userid,
salenumber=comment,
bitcoin=amount
)
else:
print("a equals", a)
notification(
type=34,
username='',
userid=userid,
salenumber=comment,
bitcoin=amount
)
def autofinalize_30days():
"""
#this function gives the money to the vendor after 30 days if no issues
:return:
"""
# get the current fee
currentfee = Admin_ClearnetFee.query.filter_by(id=1).first()
physicalitemfee = currentfee.itempurchase
acceptedorders = db.session.query(Vendor_Orders)
acceptedorders = acceptedorders.filter(Vendor_Orders.completed == 0)
acceptedorders = acceptedorders.filter(Vendor_Orders.type == 1)
acceptedorders = acceptedorders.filter(Vendor_Orders.waiting_order == 1)
acceptedorders = acceptedorders.filter(Vendor_Orders.disputed_order == 0)
acceptedorders = acceptedorders.filter(Vendor_Orders.request_return == 0)
aorders = acceptedorders.all()
for order_to_be_finalized in aorders:
getcustomer = db.session.query(Auth_User).filter(
Auth_User.id == order_to_be_finalized.customer_id).first()
whenbought = order_to_be_finalized.age
itemprice = Decimal(order_to_be_finalized.price)
shipprice = Decimal(order_to_be_finalized.shipping_price)
thefee = Decimal(order_to_be_finalized.fee)
totalprice = Decimal(itemprice + shipprice) - thefee
thirtydaysfromorder = (whenbought + timedelta(days=30))
if datetime.utcnow() > thirtydaysfromorder:
# BTC
if order_to_be_finalized.digital_currency == 2:
if order_to_be_finalized.affiliate_code != 0 and order_to_be_finalized.affiliate_discount_percent != 0:
# split the profit and how much affiliate gets
getpromo = db.session\
.query(Affiliate_Overview)\
.filter(Affiliate_Overview.promocode == order_to_be_finalized.affiliate_code)\
.first()
# variables
promopercent = (Decimal(getpromo.aff_fee / 100))
amounttomodify = (Decimal(
order_to_be_finalized.price_beforediscount))
# percent for affiliate
# multiply amount before fee off * promo percent
amount_to_affiliate = (amounttomodify * promopercent)
# percent to protos
# physicalfeefor item - feeforaffiliate == feeforprotos
feeforprotos = physicalitemfee - promopercent
if feeforprotos < 0:
feeforprotos = 0
else:
feeforprotos = feeforprotos
# amounttomnodify * feeforprotos
amount_to_protos = amounttomodify * feeforprotos
# order the amount sent
bch_send_coin_to_affiliate(
amount=amount_to_affiliate,
comment=order_to_be_finalized.id,
user_id=getpromo.user_id)
# amount = fee - affiliate fee
bch_send_coin_to_clearnet(amount=amount_to_protos,
comment=order_to_be_finalized.id,
shard=getcustomer.shard)
# add affiliate stats
userdata_aff_stats(user_id=getpromo.user_id,
amount=amount_to_affiliate,
currency=2)
else:
# send normal fee- BTC
bch_send_coin_to_clearnet(amount=thefee,
comment=order_to_be_finalized.id,
shard=getcustomer.shard)
# Autofinalize so give to vendor
# send price + shipping
bch_send_coin_to_user(amount=totalprice,
comment=order_to_be_finalized.id,
user_id=order_to_be_finalized.vendor_id)
# BTC Cash
else:
# split the profit and how much affiliate gets
if order_to_be_finalized.affiliate_code != 0 and order_to_be_finalized.affiliate_discount_percent != 0:
getpromo = db.session\
.query(Affiliate_Overview) \
.filter(Affiliate_Overview.promocode == order_to_be_finalized.affiliate_code)\
.first()
# variables
promopercent = (Decimal(getpromo.aff_fee / 100))
amounttomodify = (Decimal(
order_to_be_finalized.price_beforediscount))
# percent for affiliate
# multiply amount before fee off * promo percent
amount_to_affiliate = (amounttomodify * promopercent)
# percent to protos
# physicalfeefor item - feeforaffiliate == feeforprotos
feeforprotos = physicalitemfee - promopercent
if feeforprotos < 0:
feeforprotos = 0
else:
feeforprotos = feeforprotos
# amounttomnodify * feeforprotos
amount_to_protos = amounttomodify * feeforprotos
# percennt to affiliate
bch_send_coin_to_affiliate(
amount=amount_to_affiliate,
comment=order_to_be_finalized.id,
user_id=getpromo.user_id)
# percent to protoss
bch_send_coin_to_clearnet(amount=amount_to_protos,
comment=order_to_be_finalized.id,
shard=getcustomer.shard)
# add affiliate stats
userdata_aff_stats(user_id=getpromo.user_id,
amount=amount_to_affiliate,
currency=2)
else:
# percent to protoss
bch_send_coin_to_clearnet(amount=thefee,
comment=order_to_be_finalized.id,
shard=getcustomer.shard)
# Autofinalize so give to vendor - BTC CASH
bch_send_coin_to_user(amount=totalprice,
comment=order_to_be_finalized.id,
user_id=order_to_be_finalized.vendor_id)
# notify vendor
notification(type=6,
username=order_to_be_finalized.vendor,
user_id=order_to_be_finalized.vendor_id,
salenumber=order_to_be_finalized.id,
bitcoin=totalprice)
# mark as completed
markascompleted(itemid=order_to_be_finalized.id)
# add stats
# Add total items bought
userdata_add_total_items_bought(
user_id=order_to_be_finalized.customer_id,
howmany=order_to_be_finalized.quantity)
# add total sold to vendor
userdata_add_total_items_sold(
user_id=order_to_be_finalized.vendor_id,
howmany=order_to_be_finalized.quantity)
# Bch Spent by user
userdata_total_spent_on_item_bch(
user_id=order_to_be_finalized.customer_id,
howmany=order_to_be_finalized.quantity,
amount=order_to_be_finalized.price)
# Bch recieved by vendor
userdata_total_made_on_item_bch(
user_id=order_to_be_finalized.vendor_id,
amount=order_to_be_finalized.price)
# Give Vendor experience points
exppoint(user=order_to_be_finalized.vendor_id,
price=order_to_be_finalized.price,
type=11,
quantity=order_to_be_finalized.quantity,
currency=order_to_be_finalized.currency)
# Give user experience points
exppoint(user=order_to_be_finalized.customer_id,
price=order_to_be_finalized.price,
type=1,
quantity=order_to_be_finalized.quantity,
currency=order_to_be_finalized.currency)
db.session.commit()
def sendCointoEscrow(amount, comment, userid):
"""
#TO Agora Wallet
##this function will move the coin to agoras wallet_btc from a user
:param amount:
:param comment:
:param userid:
:return:
"""
a = checkbalance(userid=userid, amount=amount)
if a == 1:
try:
type_transaction = 4
userswallet = BtcWallet.query.filter_by(userid=userid).first()
curbal = Decimal(userswallet.currentbalance)
amounttomod = Decimal(amount)
newbalance = Decimal(curbal) - Decimal(amounttomod)
userswallet.currentbalance = newbalance
db.session.add(userswallet)
db.session.commit()
oid = int(comment)
addtransaction(category=type_transaction,
amount=amount,
userid=userid,
comment='Sent Coin To Escrow',
shard=userswallet.shard,
orderid=oid,
balance=newbalance)
except Exception as e:
errorLogger(function='sendcointoescrow',
error=e,
kindoferror=4,
user=userid)
# find order and cancel it
order = db.session.query(Orders).filter(
Orders.id == comment).first()
# change the order status
order.disputed_order = 0
order.cancelled = 1
order.completed = 1
order.buyorsell = 1
order.released = 1
order.completed_time = datetime.utcnow()
db.session.add(order)
db.session.commit()
else:
order = db.session.query(Orders).filter(Orders.id == comment).first()
# change the order status
# change the order status
order.disputed_order = 0
order.cancelled = 1
order.completed = 1
order.buyorsell = 1
order.released = 1
order.completed_time = datetime.utcnow()
db.session.add(order)
db.session.commit()
notification(type=34,
username='',
userid=userid,
salenumber=comment,
bitcoin=amount)