def logout(request):
if request.user.is_authenticated():
from django.contrib.auth import logout
logout(request)
data = { "success": True }
return callbackWrapper(request, data)
else:
#data = { "success": False, "error": "Invalid logout", "detail": "You are not authorized" }
#return callbackWrapper(request, data)
return redirect( '/')
def login(request):
from django.contrib.auth import authenticate, login
user = authenticate(username=getUsername(request), password=getPassword(request))
if user is not None:
if user.is_active:
login(request, user)
#if logger.isEnabledFor(logging.INFO):
#logger.info('Just Logged In User: %s, IP: %s, HOST: %s' % (request.user.username, request.META['REMOTE_ADDR'], request.META['HTTP_HOST']))
# Redirect to a success page.
data = { "success": True }
return callbackWrapper(request, data)
else:
# Return a 'disabled account' error message
data = { "success": False, "error": "Invalid login", "detail": "Username is disabled" }
return callbackWrapper(request, data)
else:
# Return an 'invalid login' error message.
data = { "success": False, "error": "Invalid login", "detail": "Username or Password aren't correct" }
return callbackWrapper(request, data)
def wrapper(**kwargs):
"""
обработка входных параметров
"""
request = kwargs['request']
req_params = kwargs['req_params']
_context = kwargs['context']
json = ''
if request.user.is_authenticated():
if _context == 'category':
req = CategoryRequired(request=request, req_params=req_params)
if _context == 'item':
req = ItemRequired(request=request, req_params=req_params)
if _context == 'vendor':
req = VendorRequired(request=request, req_params=req_params)
if _context == 'order':
req = OrderRequired(request=request, req_params=req_params)
if _context == 'unit':
req = UnitRequired(request=request, req_params=req_params)
if _context == 'purchase':
req = PurchaseRequired(request=request, req_params=req_params)
if _context == 'invoice':
req = InvoiceRequired(request=request, req_params=req_params)
if _context == 'itemProduct':
req = ItemProductRequired(request=request, req_params=req_params)
if _context == 'sendmail':
req = SendmailRequired(request=request, req_params=req_params)
if _context == 'item_match':
req = ItemMatchRequired(request=request, req_params=req_params)
if _context == 'products_purchase':
req = ProductsPurchaseRequired(request=request, req_params=req_params)
if req.success():
out = kwargs['worker'](req)
if 'success' in out:
if out['success']:
json = out
else:
json = { "success": False, "errors": out['errors'] }
else:
logger.error(req.errors())
json = { "success": False, "errors": req.errors() }
return callbackWrapper(request, json)
else:
#non-authorized request
json = { "success": False, "error": "Authorization is failed" }
return callbackWrapper(request, json)
def index(request):
ready_data_true = {'success': True }
ready_data_false = {'success': False}
#logger.debug('user:'******''
try:
hgm_www_host = settings.HGM_WWW_HOST
hgm_www_port = settings.HGM_WWW_PORT
hgm_www_user = settings.HGM_WWW_USER
hgm_www_password = settings.HGM_WWW_PASSWORD
hgm_www_db = settings.HGM_WWW_DB
# CONNECTION TO www.hudsongreenemarket.com 52.0.0.79
myDB = MySQLdb.connect(host=hgm_www_host,port=hgm_www_port,user=hgm_www_user,passwd=hgm_www_password,db=hgm_www_db)
cHandler = myDB.cursor()
# a. get categories (from www.hudsongreenemarket.com)
category = request.GET['id']
if category == 'root':
category = '0'
sql = "SELECT emk8r_virtuemart_categories.virtuemart_category_id, emk8r_virtuemart_categories_en_gb.category_name " + \
"FROM emk8r_virtuemart_categories " + \
"LEFT JOIN emk8r_virtuemart_categories_en_gb " + \
"ON emk8r_virtuemart_categories.virtuemart_category_id=emk8r_virtuemart_categories_en_gb.virtuemart_category_id "+ \
"LEFT JOIN emk8r_virtuemart_category_categories " + \
"ON emk8r_virtuemart_categories.virtuemart_category_id=emk8r_virtuemart_category_categories.id "+ \
"WHERE emk8r_virtuemart_categories.published=1 " + \
"AND emk8r_virtuemart_category_categories.category_parent_id='" + category + "' "
logger.debug('sql = ' + sql)
cHandler.execute(sql)
results = cHandler.fetchall()
data = []
for category in results:
cat = {}
cat['id'] = str(category[0])
cat['category_id'] = str(category[0])
cat['name'] = str(category[1])
data.append(cat)
ready_data_true["items"] = data
ready_data_true["total"] = len(data)
return callbackWrapper(request, ready_data_true)
except Exception, err:
logger.error('EXCEPTION: ' + str(err))
logger.error('EXCEPTION: ' + sql)
ready_data_false["error"] = str(err)
return callbackWrapper(request, ready_data_false)
# update qt in stock
if purchaseDetail.item.inventory_no_count:
purchaseDetail.inventory_updated = True
purchaseDetail.save()
i = i + 1
continue
else:
if purchaseDetail.item.qt_in_stock is None:
qt_in_stock = purchaseDetail.total_units
else:
qt_in_stock = purchaseDetail.item.qt_in_stock + purchaseDetail.total_units
if qt_in_stock < 0:
qt_in_stock = 0
purchaseDetail.item.qt_in_stock = qt_in_stock
purchaseDetail.inventory_updated = True
#logger.info('qt_in_stock: %s' % (qt_in_stock))
purchaseDetail.item.save()
purchaseDetail.save()
if settings.HGM == True: # UPDATE qt_in_stock in WWW
updateWwwQtInStock(purchaseDetail.item)
i = i + 1
except Exception, err:
logger.error(err)
continue # continue the loop even if there was a problem with 1 of the records
return callbackWrapper(request, { "success": True, "message": "Success: Inventory Updated" })
