def goodsSelect(request):
try:
if isTokenExpired(request):
if len(request.GET) > 0:
condition = {}
selectType = {}
if 'goodsID' in request.GET and isValid(
request.GET['goodsID']):
condition['id'] = int(request.GET['goodsID'])
if 'stock' in request.GET and isValid(request.GET['stock']):
condition['stock'] = int(request.GET['stock'])
if 'purchase' in request.GET and isValid(
request.GET['purchase']):
condition['purchase'] = atof(request.GET['purchase'])
if 'brand' in request.GET and isValid(request.GET['brand']):
condition['brand'] = request.GET['brand']
if 'state' in request.GET and isValid(request.GET['state']):
condition['state'] = int(request.GET['state'])
goodsSelect = paging(request, ONE_PAGE_OF_DATA, condition,
selectType)
else:
goodsSelect = paging(request, ONE_PAGE_OF_DATA, None, None)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
goodsSelect = setStatus(500, traceback.format_exc())
def multiWriteoffSelect(request):
try:
if isTokenExpired(request):
if len(request.GET) > 0:
condition = {}
selectType = {}
if 'writeoffType' in request.GET and isValid(
request.GET['writeoffType']):
condition['writeoff_type'] = int(
request.GET['writeoffType'])
if 'queryTime' in request.GET and isValid(
request.GET['queryTime']):
queryTime = request.GET['queryTime']
timeFrom = queryTime.split('~')[0].strip()
timeTo = queryTime.split('~')[1].strip()
selectType['timeFrom'] = timeFrom + ' 00:00:00'
selectType['timeTo'] = timeTo + ' 23:59:59'
multiWriteoffSelect = paging(request, ONE_PAGE_OF_DATA,
condition, selectType)
else:
multiWriteoffSelect = paging(request, ONE_PAGE_OF_DATA, None,
None)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
multiWriteoffSelect = setStatus(500, traceback.format_exc())
def departmentUpdate(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifier = json2Dict['identifier']
departments = Department.objects.filter(identifier=identifier)
if len(departments) > 0:
department = departments[0]
else:
departmentUpdate = setStatus(300, {})
return HttpResponse(json.dumps(departmentUpdate),
content_type='application/json')
if 'name' in json2Dict:
if isValid(json2Dict['name']):
name = json2Dict['name']
department.name = name
if 'operatorIdentifier' in json2Dict:
if isValid(json2Dict['operatorIdentifier']):
operator_identifier = json2Dict['operatorIdentifier']
department.operator_identifier = operator_identifier
department.save()
departmentJSON = getDepartment(department)
departmentUpdate = setStatus(200, departmentJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
departmentUpdate = setStatus(500, traceback.format_exc())
def departmentSelect(request):
try:
if isTokenExpired(request):
if len(request.GET) > 0:
condition = {}
selectType = {}
if 'identifier' in request.GET and isValid(
request.GET['identifier']):
condition['identifier'] = request.GET['identifier']
if 'name' in request.GET and isValid(request.GET['name']):
condition['name'] = request.GET['name']
if 'operatorIdentifier' in request.GET and isValid(
request.GET['operatorIdentifier']):
condition['operator_identifier'] = request.GET[
'operatorIdentifier']
condition['is_delete'] = 0
if 'queryTime' in request.GET and isValid(
request.GET['queryTime']):
queryTime = request.GET['queryTime']
timeFrom = queryTime.split('~')[0].strip()
timeTo = queryTime.split('~')[1].strip()
selectType['timeFrom'] = timeFrom + ' 00:00:00'
selectType['timeTo'] = timeTo + ' 23:59:59'
departmentSelect = paging(request, ONE_PAGE_OF_DATA, condition,
selectType)
else:
departmentSelect = paging(request, ONE_PAGE_OF_DATA, None,
None)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
departmentSelect = setStatus(500, traceback.format_exc())
def firstClassificationInsert(request):
try:
if isTokenExpired(request):
logRecord = basic_log.Logger('record')
firstClassificationInsert = {}
logRecord.log("input: " + str(request.body))
json2Dict = json.loads(request.body)
if 'name' in json2Dict:
if isValid(json2Dict['name']):
name = json2Dict['name']
else:
name = None
else:
name = None
if 'keyWord' in json2Dict:
if isValid(json2Dict['keyWord']):
key_word = json2Dict['keyWord']
else:
key_word = None
else:
key_word = None
if 'operator' in json2Dict:
if isValid(json2Dict['operator']):
operator_identifier = json2Dict['operator']
else:
operator_identifier = None
else:
operator_identifier = None
if 'type' in json2Dict:
if isValid(json2Dict['type']):
type = int(json2Dict['type'])
else:
type = 0
else:
type = 0
is_delete = 0
parent_id = 0
operator_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
identifier = 'PO-' + operator_time[0:10] + '-'
firstClassification = Classification(None, identifier, name,
parent_id, key_word,
operator_identifier,
operator_time, type,
is_delete)
firstClassification.save()
firstClassification.identifier = identifier + str(
firstClassification.id)
firstClassification.save()
rData = getClassification(firstClassification)
firstClassificationInsert = setStatus(200, rData)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
firstClassificationInsert = setStatus(500, traceback.format_exc())
def secondClassificationUpdate(request):
try:
if isTokenExpired(request):
logRecord = basic_log.Logger('record')
secondClassificationUpdate = {}
json2Dict = json.loads(request.body)
identifier = json2Dict['identifier']
classifications = Classification.objects.filter(
identifier=identifier)
if len(classifications) > 0:
classification = classifications[0]
isAdd = 0
if 'parentID' in json2Dict:
if isValid(json2Dict['parentID']):
parent_id = json2Dict['parentID']
classification.parent_id = parent_id
isAdd += 1
if 'name' in json2Dict:
if isValid(json2Dict['name']):
name = json2Dict['name']
classification.name = name
isAdd += 1
if 'keyWord' in json2Dict:
if isValid(json2Dict['keyWord']):
key_word = json2Dict['keyWord']
classification.key_word = key_word
isAdd += 1
if 'operator' in json2Dict:
if isValid(json2Dict['operator']):
operator_identifier = json2Dict['operator']
classification.operator_identifier = operator_identifier
isAdd += 1
if 'type' in json2Dict:
if isValid(json2Dict['type']):
type = int(json2Dict['type'])
classification.type = type
isAdd += 1
if isAdd > 0:
operator_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
classification.operator_time = operator_time
classification.save()
rData = getClassification(classification)
secondClassificationUpdate = setStatus(200, rData)
else:
secondClassificationUpdate = setStatus(300, {})
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
secondClassificationUpdate = setStatus(500, traceback.format_exc())
def thirdPartySelect(request):
try:
if isTokenExpired(request):
thirdPartySelect = {}
condition = {}
selectType = {}
if len(request.GET) > 0:
if 'identifier' in request.GET and isValid(
request.GET['identifier']):
condition['identifier'] = request.GET['identifier']
if 'name' in request.GET and isValid(request.GET['name']):
name = request.GET['name']
condition['name'] = name
if 'fromType' in request.GET and isValid(
request.GET['fromType']):
from_type = request.GET['fromType']
condition['from_type'] = from_type
if 'queryTime' in request.GET and isValid(
request.GET['queryTime']):
queryTime = request.GET['queryTime']
timeFrom = queryTime.split('~')[0].strip()
timeTo = queryTime.split('~')[1].strip()
selectType['timeFrom'] = timeFrom + ' 00:00:00'
selectType['timeTo'] = timeTo + ' 23:59:59'
if 'state' in request.GET and isValid(request.GET['state']):
state = request.GET['state']
condition['state'] = state
if 'province' in request.GET and isValid(
request.GET['province']):
province = request.GET['province']
condition['province'] = province
if 'city' in request.GET and isValid(request.GET['city']):
city = request.GET['city']
condition['city'] = city
if 'area' in request.GET and isValid(request.GET['area']):
area = request.GET['area']
condition['area'] = area
if 'classificationID' in request.GET and isValid(
request.GET['classificationID']):
classificationID = int(request.GET['classificationID'])
condition['classification_id'] = classificationID
thirdPartySelect = paging(request, ONE_PAGE_OF_DATA, condition,
selectType)
else:
thirdPartySelect = paging(request, ONE_PAGE_OF_DATA, None,
None)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
thirdPartySelect = setStatus(500, traceback.format_exc())
def goodsInsert(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
if 'stock' in json2Dict:
if isValid(json2Dict['stock']):
stock = int(json2Dict['stock'])
else:
stock = 0
else:
stock = 0
if 'purchase' in json2Dict:
if isValid(json2Dict['purchase']):
purchase = atof(json2Dict['purchase'])
else:
purchase = 0
else:
purchase = 0
if 'brand' in json2Dict:
if isValid(json2Dict['brand']):
brand = json2Dict['brand']
else:
brand = None
else:
brand = None
if 'state' in json2Dict:
if isValid(json2Dict['state']):
state = int(json2Dict['state'])
else:
state = 0
else:
state = 0
goods = Goods(None, stock, purchase, brand, state)
goods.save()
goodsJSON = getGoods(goods)
goodsInsert = setStatus(200, goodsJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
goodsInsert = setStatus(500, traceback.format_exc())
def goodsUpdate(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
goodsID = json2Dict['goodsID']
goodses = Goods.objects.filter(id=goodsID)
if len(goodses) > 0:
goods = goodses[0]
else:
goodsUpdate = setStatus(300, {})
return HttpResponse(json.dumps(goodsUpdate),
content_type='application/json')
if 'stock' in json2Dict:
if isValid(json2Dict['stock']):
stock = int(json2Dict['stock'])
goods.stock = stock
if 'purchase' in json2Dict:
if isValid(json2Dict['purchase']):
purchase = atof(json2Dict['purchase'])
goods.purchase = purchase
if 'brand' in json2Dict:
if isValid(json2Dict['brand']):
brand = json2Dict['brand']
goods.brand = brand
if 'state' in json2Dict:
if isValid(json2Dict['state']):
state = int(json2Dict['state'])
goods.state = state
goods.save()
goodsJSON = getGoods(goods)
goodsUpdate = setStatus(200, goodsJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
goodsUpdate = setStatus(500, traceback.format_exc())
def stockCheckSelect(request):
try:
if isTokenExpired(request):
if len(request.GET) > 0:
condition = {}
selectType = {}
if 'identifier' in request.GET and isValid(
request.GET['identifier']):
condition['identifier'] = request.GET['identifier']
if 'warehouseID' in request.GET and isValid(
request.GET['warehouseID']):
condition['warehouse_id'] = int(request.GET['warehouseID'])
if 'personID' in request.GET and isValid(
request.GET['personID']):
condition['person_id'] = int(request.GET['personID'])
if 'state' in request.GET and isValid(request.GET['state']):
condition['state'] = int(request.GET['state'])
condition['is_delete'] = 0
if 'queryTime' in request.GET and isValid(
request.GET['queryTime']):
queryTime = request.GET['queryTime']
timeFrom = queryTime.split('~')[0].strip()
timeTo = queryTime.split('~')[1].strip()
selectType['timeFrom'] = timeFrom + ' 00:00:00'
selectType['timeTo'] = timeTo + ' 23:59:59'
stockCheckSelect = paging(request, ONE_PAGE_OF_DATA, condition,
selectType)
else:
stockCheckSelect = paging(request, ONE_PAGE_OF_DATA, None,
None)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
stockCheckSelect = setStatus(500, traceback.format_exc())
def departmentInsert(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
if 'name' in json2Dict:
if isValid(json2Dict['name']):
name = json2Dict['name']
else:
name = None
else:
name = None
if 'operatorIdentifier' in json2Dict:
if isValid(json2Dict['operatorIdentifier']):
operator_identifier = json2Dict['operatorIdentifier']
else:
operator_identifier = None
else:
operator_identifier = None
operator_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
identifier = 'DEP-' + operator_time[0:10] + '-'
is_delete = 0
department = Department(None, name, operator_identifier,
operator_time, identifier, is_delete)
department.save()
department.identifier = identifier + str(department.id)
department.save()
departmentJSON = getDepartment(department)
departmentInsert = setStatus(200, departmentJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
departmentInsert = setStatus(500, traceback.format_exc())
def secondClassificationSelect(request):
try:
if isTokenExpired(request):
logRecord = basic_log.Logger('record')
secondClassificationSelect = {}
if len(request.GET) > 0:
condition = {}
selectType = {}
if 'identifier' in request.GET and isValid(request.GET['identifier']):
condition['identifier'] = request.GET['identifier']
if 'firstClassIdentifer' in request.GET and isValid(request.GET['firstClassIdentifer']):
condition['parent_id'] = int(request.GET['firstClassIdentifer'])
'''
parents = Classification.objects.filter(identifier=firstClassIdentifer)
parents = Classification.objects.filter(parent_id=firstClassIdentifer)
if len(parents) > 0:
parent = parents[0]
condition['parent_id'] = parent.id
else:
secondClassificationSelect = setStatus(300, {})
return HttpResponse(json.dumps(secondClassificationSelect), content_type='application/json')
'''
if 'type' in request.GET and isValid(request.GET['type']):
condition['type'] = int(request.GET['type'])
if 'keyWord' in request.GET and isValid(request.GET['keyWord']):
condition['key_word'] = request.GET['keyWord']
if 'name' in request.GET and isValid(request.GET['name']):
condition['name'] = request.GET['name']
if 'operator' in request.GET and isValid(request.GET['operator']):
selectType['operator'] = request.GET['operator']
if 'queryTime' in request.GET and isValid(request.GET['queryTime']):
queryTime = request.GET['queryTime']
timeFrom = queryTime.split('~')[0].strip()
timeTo = queryTime.split('~')[1].strip()
selectType['timeFrom'] = timeFrom + ' 00:00:00'
selectType['timeTo'] = timeTo + ' 23:59:59'
condition['is_delete'] = 0
if 'noPaging' in request.GET and request.GET['noPaging'] == "true":
secondClassificationSelect = conditionSelect(condition, True, selectType)
else:
secondClassificationSelect = paging(request, ONE_PAGE_OF_DATA, condition,False,selectType)
else:
secondClassificationSelect = paging(request, ONE_PAGE_OF_DATA, None,False, None)
else:
return notTokenExpired()
except Exception,e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
secondClassificationSelect = setStatus(500,traceback.format_exc())
def firstClassificationSelect(request):
try:
if isTokenExpired(request):
logRecord = basic_log.Logger('record')
firstClassificationSelect = {}
if len(request.GET) > 0:
condition = {}
selectType = {}
if 'identifier' in request.GET and isValid(request.GET['identifier']):
condition['identifier'] = request.GET['identifier']
if 'type' in request.GET and isValid(request.GET['type']):
condition['type'] = int(request.GET['type'])
if 'keyWord' in request.GET and isValid(request.GET['keyWord']):
condition['key_word'] = request.GET['keyWord']
if 'name' in request.GET and isValid(request.GET['name']):
condition['name'] = request.GET['name']
if 'operator' in request.GET and isValid(request.GET['operator']):
condition['operator'] = request.GET['operator']
if 'queryTime' in request.GET and isValid(request.GET['queryTime']):
queryTime = request.GET['queryTime']
timeFrom = queryTime.split('~')[0].strip()
timeTo = queryTime.split('~')[1].strip()
selectType['timeFrom'] = timeFrom + ' 00:00:00'
selectType['timeTo'] = timeTo + ' 23:59:59'
condition['is_delete'] = 0
condition['parent_id'] = 0
logRecord.log("condition: " + str(condition))
if 'noPaging' in request.GET and request.GET['noPaging'] == "true":
firstClassificationSelect = conditionSelect(condition, True, selectType)
else:
firstClassificationSelect = paging(request, ONE_PAGE_OF_DATA, condition, True, selectType)
logRecord.log("return: " + str(firstClassificationSelect))
else:
firstClassificationSelect = paging(request, ONE_PAGE_OF_DATA, None, True, None)
else:
return notTokenExpired()
except Exception,e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
firstClassificationSelect = setStatus(500,traceback.format_exc())
def basicUpdate(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
tableName = json2Dict['tableName']
operator_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
if tableName == 'shippingMode':
identifier = json2Dict['identifier']
shippingModes = ShippingMode.objects.filter(
identifier=identifier)
if len(shippingModes) > 0:
shippingMode = shippingModes[0]
if 'name' in json2Dict:
if isValid(json2Dict['name']):
name = json2Dict['name']
shippingMode.name = name
if 'operatorIdentifier' in json2Dict:
if isValid(json2Dict['operatorIdentifier']):
operator_identifier = json2Dict[
'operatorIdentifier']
shippingMode.operator_identifier = operator_identifier
shippingMode.save()
else:
basicUpdate = setStatus(300, {})
return HttpResponse(json.dumps(basicUpdate),
content_type='application/json')
basicJSON = getBasicJSON(shippingMode, tableName)
elif tableName == 'settlementType':
identifier = json2Dict['identifier']
settlementTypes = SettlementType.objects.filter(
identifier=identifier)
if len(settlementTypes) > 0:
settlementType = settlementTypes[0]
if 'name' in json2Dict:
if isValid(json2Dict['name']):
name = json2Dict['name']
settlementType.name = name
if 'operatorIdentifier' in json2Dict:
if isValid(json2Dict['operatorIdentifier']):
operator_identifier = json2Dict[
'operatorIdentifier']
settlementType.operator_identifier = operator_identifier
settlementType.save()
else:
basicUpdate = setStatus(300, {})
return HttpResponse(json.dumps(basicUpdate),
content_type='application/json')
basicJSON = getBasicJSON(settlementType, tableName)
elif tableName == 'department':
identifier = json2Dict['identifier']
departments = Department.objects.filter(identifier=identifier)
if len(departments) > 0:
department = departments[0]
if 'name' in json2Dict:
if isValid(json2Dict['name']):
name = json2Dict['name']
department.name = name
if 'operatorIdentifier' in json2Dict:
if isValid(json2Dict['operatorIdentifier']):
operator_identifier = json2Dict[
'operatorIdentifier']
department.operator_identifier = operator_identifier
department.save()
else:
basicUpdate = setStatus(300, {})
return HttpResponse(json.dumps(basicUpdate),
content_type='application/json')
basicJSON = getBasicJSON(department, tableName)
elif tableName == 'warehouse':
identifier = json2Dict['identifier']
warehouses = Warehouse.objects.filter(identifier=identifier)
if len(warehouses) > 0:
warehouse = warehouses[0]
if 'name' in json2Dict:
if isValid(json2Dict['name']):
name = json2Dict['name']
warehouse.name = name
if 'operatorIdentifier' in json2Dict:
if isValid(json2Dict['operatorIdentifier']):
operator_identifier = json2Dict[
'operatorIdentifier']
warehouse.operator_identifier = operator_identifier
if 'position' in json2Dict:
if isValid(json2Dict['position']):
position = json2Dict['position']
warehouse.position = position
warehouse.save()
else:
basicUpdate = setStatus(300, {})
return HttpResponse(json.dumps(basicUpdate),
content_type='application/json')
basicJSON = getBasicJSON(warehouse, tableName)
else:
basicUpdate = setStatus(300, {})
return HttpResponse(json.dumps(basicUpdate),
content_type='application/json')
basicUpdate = setStatus(200, basicJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
basicUpdate = setStatus(500, traceback.format_exc())
def basicSelect(request):
try:
if isTokenExpired(request):
tableName = request.GET['tableName']
if tableName == 'shippingMode':
condition = {}
selectType = {}
if 'identifier' in request.GET and isValid(
request.GET['identifier']):
condition['identifier'] = request.GET['identifier']
if 'name' in request.GET and isValid(request.GET['name']):
condition['name'] = request.GET['name']
if 'operatorIdentifier' in request.GET and isValid(
request.GET['operatorIdentifier']):
condition['operator_identifier'] = request.GET[
'operatorIdentifier']
if 'queryTime' in request.GET and isValid(
request.GET['queryTime']):
queryTime = request.GET['queryTime']
timeFrom = queryTime.split('~')[0].strip()
timeTo = queryTime.split('~')[1].strip()
selectType['timeFrom'] = timeFrom + ' 00:00:00'
selectType['timeTo'] = timeTo + ' 23:59:59'
condition['is_delete'] = 0
if 'noPaging' in request.GET and request.GET[
'noPaging'] == "true":
basicSelect = conditionSelect(tableName, condition,
selectType)
else:
basicSelect = paging4ShippingMode(request,
ONE_PAGE_OF_DATA,
tableName, condition,
selectType)
elif tableName == 'settlementType':
condition = {}
selectType = {}
if 'identifier' in request.GET and isValid(
request.GET['identifier']):
condition['identifier'] = request.GET['identifier']
if 'name' in request.GET and isValid(request.GET['name']):
condition['name'] = request.GET['name']
if 'operatorIdentifier' in request.GET and isValid(
request.GET['operatorIdentifier']):
condition['operator_identifier'] = request.GET[
'operatorIdentifier']
if 'queryTime' in request.GET and isValid(
request.GET['queryTime']):
queryTime = request.GET['queryTime']
timeFrom = queryTime.split('~')[0].strip()
timeTo = queryTime.split('~')[1].strip()
selectType['timeFrom'] = timeFrom + ' 00:00:00'
selectType['timeTo'] = timeTo + ' 23:59:59'
condition['is_delete'] = 0
if 'noPaging' in request.GET and request.GET[
'noPaging'] == "true":
basicSelect = conditionSelect(tableName, condition,
selectType)
else:
basicSelect = paging4SettlementType(
request, ONE_PAGE_OF_DATA, tableName, condition,
selectType)
elif tableName == 'department':
condition = {}
selectType = {}
if 'identifier' in request.GET and isValid(
request.GET['identifier']):
condition['identifier'] = request.GET['identifier']
if 'name' in request.GET and isValid(request.GET['name']):
condition['name'] = request.GET['name']
if 'operatorIdentifier' in request.GET and isValid(
request.GET['operatorIdentifier']):
condition['operator_identifier'] = request.GET[
'operatorIdentifier']
if 'queryTime' in request.GET and isValid(
request.GET['queryTime']):
queryTime = request.GET['queryTime']
timeFrom = queryTime.split('~')[0].strip()
timeTo = queryTime.split('~')[1].strip()
selectType['timeFrom'] = timeFrom + ' 00:00:00'
selectType['timeTo'] = timeTo + ' 23:59:59'
condition['is_delete'] = 0
if 'noPaging' in request.GET and request.GET[
'noPaging'] == "true":
basicSelect = conditionSelect(tableName, condition,
selectType)
else:
basicSelect = paging4Department(request, ONE_PAGE_OF_DATA,
tableName, condition,
selectType)
elif tableName == 'warehouse':
condition = {}
selectType = {}
if 'identifier' in request.GET and isValid(
request.GET['identifier']):
condition['identifier'] = request.GET['identifier']
if 'name' in request.GET and isValid(request.GET['name']):
condition['name'] = request.GET['name']
if 'operatorIdentifier' in request.GET and isValid(
request.GET['operatorIdentifier']):
condition['operator_identifier'] = request.GET[
'operatorIdentifier']
if 'queryTime' in request.GET and isValid(
request.GET['queryTime']):
queryTime = request.GET['queryTime']
timeFrom = queryTime.split('~')[0].strip()
timeTo = queryTime.split('~')[1].strip()
selectType['timeFrom'] = timeFrom + ' 00:00:00'
selectType['timeTo'] = timeTo + ' 23:59:59'
condition['is_delete'] = 0
if 'noPaging' in request.GET and request.GET[
'noPaging'] == "true":
basicSelect = conditionSelect(tableName, condition,
selectType)
else:
basicSelect = paging4Warehouse(request, ONE_PAGE_OF_DATA,
tableName, condition,
selectType)
else:
basicSelect = setStatus(300, {})
return HttpResponse(json.dumps(basicSelect),
content_type='application/json')
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
basicSelete = setStatus(500, traceback.format_exc())
def firstClassificationSelect(request):
try:
if isTokenExpired(request):
logRecord = basic_log.Logger('record')
firstClassificationSelect = {}
if len(request.GET) > 0:
if 'identifier' in request.GET and request.GET[
'identifier'] != "":
identifier = request.GET['identifier']
classifications = Classification.objects.filter(
identifier=identifier)
if len(classifications) > 0:
classification = classifications[0]
classificationJSON = getClassification(classification)
firstClassificationSelect = setStatus(
200, classificationJSON)
else:
firstClassificationSelect = setStatus(300, {})
return HttpResponse(json.dumps(firstClassificationSelect),
content_type='application/json')
else:
condition = {}
selectType = {}
if 'type' in request.GET and request.GET['type'] != "":
if isValid(request.GET['type']):
condition['type'] = int(request.GET['type'])
if 'keyWord' in request.GET and request.GET[
'keyWord'] != "":
if isValid(request.GET['keyWord']):
condition['key_word'] = request.GET['keyWord']
if 'name' in request.GET and request.GET['name'] != "":
if isValid(request.GET['name']):
condition['name'] = request.GET['name']
if 'operator' in request.GET and request.GET[
'operator'] != "":
if isValid(request.GET['operator']):
condition['operator'] = request.GET['operator']
if 'queryTime' in request.GET and request.GET[
'queryTime'] != "":
queryTime = request.GET['queryTime']
timeFrom = queryTime.split('~')[0].strip()
timeTo = queryTime.split('~')[1].strip()
selectType['timeFrom'] = timeFrom + ' 00:00:00'
selectType['timeTo'] = timeTo + ' 23:59:59'
condition['is_delete'] = 0
condition['parent_id'] = 0
logRecord.log("condition: " + str(condition))
firstClassificationSelect = paging(request,
ONE_PAGE_OF_DATA,
condition, selectType)
logRecord.log("return: " + str(firstClassificationSelect))
else:
firstClassificationSelect = paging(request, ONE_PAGE_OF_DATA,
None, None)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
firstClassificationSelect = setStatus(500, traceback.format_exc())
def thirdPartyUpdate(request):
try:
if isTokenExpired(request):
thirdPartyUpdate = {}
json2Dict = json.loads(request.body)
identifier = json2Dict['identifier']
supCtos = Supcto.objects.filter(identifier=identifier)
if len(supCtos) > 0:
supCto = supCtos[0]
if 'classificationID' in json2Dict:
if isValid(json2Dict['classificationID']):
classification_id = json2Dict['classificationID']
supCto.classification_id = classification_id
if 'name' in json2Dict:
if isValid(json2Dict['name']):
name = json2Dict['name']
supCto.name = name
if 'fullName' in json2Dict:
if isValid(json2Dict['fullName']):
full_name = json2Dict['fullName']
supCto.full_name = full_name
if 'frade' in json2Dict:
if isValid(json2Dict['frade']):
frade = json2Dict['frade']
supCto.frade = frade
if 'fromType' in json2Dict:
if isValid(json2Dict['fromType']):
from_type = json2Dict['fromType']
supCto.from_type = from_type
if 'settlementTypeID' in json2Dict:
if isValid(json2Dict['settlementTypeID']):
settlement_type_id = json2Dict['settlementTypeID']
supCto.settlement_type_id = settlement_type_id
if 'phone' in json2Dict:
if isValid(json2Dict['phone']):
phone = json2Dict['phone']
supCto.phone = phone
if 'contactPeople' in json2Dict:
if isValid(json2Dict['contactPeople']):
contact_people = json2Dict['contactPeople']
supCto.contact_people = contact_people
if 'postcode' in json2Dict:
if isValid(json2Dict['postcode']):
postcode = json2Dict['postcode']
supCto.postcode = postcode
if 'fax' in json2Dict:
if isValid(json2Dict['fax']):
fax = json2Dict['fax']
supCto.fax = fax
if 'bankAccount' in json2Dict:
if isValid(json2Dict['bankAccount']):
bank_account = json2Dict['bankAccount']
supCto.bank_account = bank_account
if 'bank' in json2Dict:
if isValid(json2Dict['bank']):
bank = json2Dict['bank']
supCto.bank = bank
if 'ratepaying' in json2Dict:
if isValid(json2Dict['ratepaying']):
ratepaying = json2Dict['ratepaying']
supCto.ratepaying = ratepaying
if 'mailbox' in json2Dict:
if isValid(json2Dict['mailbox']):
mailbox = json2Dict['mailbox']
supCto.mailbox = mailbox
if 'invoiceType' in json2Dict:
if isValid(json2Dict['invoiceType']):
invoice_type = json2Dict['invoiceType']
supCto.invoice_type = invoice_type
if 'deliveryAddress' in json2Dict:
if isValid(json2Dict['deliveryAddress']):
delivery_address = json2Dict['deliveryAddress']
supCto.delivery_address = delivery_address
if 'creditDays' in json2Dict:
if isValid(json2Dict['creditDays']):
credit_days = json2Dict['creditDays']
supCto.credit_days = credit_days
if 'creditMoney' in json2Dict:
if isValid(json2Dict['creditMoney']):
credit_money = json2Dict['creditMoney']
supCto.credit_money = credit_money
if 'information' in json2Dict:
if isValid(json2Dict['information']):
information = json2Dict['information']
supCto.information = information
if 'otherInformation' in json2Dict:
if isValid(json2Dict['otherInformation']):
other_information = json2Dict['otherInformation']
supCto.other_information = other_information
if 'departmentID' in json2Dict:
if isValid(json2Dict['departmentID']):
department_id = json2Dict['departmentID']
supCto.department_id = department_id
if 'personID' in json2Dict:
if isValid(json2Dict['personID']):
person_id = json2Dict['personID']
supCto.person_id = person_id
if 'currency' in json2Dict:
if isValid(json2Dict['currency']):
currency = json2Dict['currency']
supCto.currency = currency
if 'communicationAddress' in json2Dict:
if isValid(json2Dict['communicationAddress']):
communication_address = json2Dict[
'communicationAddress']
supCto.communication_address = communication_address
if 'taxes' in json2Dict:
if isValid(json2Dict['taxes']):
taxes = json2Dict['taxes']
supCto.taxes = taxes
if 'member' in json2Dict:
if isValid(json2Dict['member']):
member = json2Dict['member']
supCto.member = member
if 'shippingModeID' in json2Dict:
if isValid(json2Dict['shippingModeID']):
shipping_mode_id = json2Dict['shippingModeID']
supCto.shipping_mode_id = shipping_mode_id
if 'remark' in json2Dict:
if isValid(json2Dict['remark']):
remark = json2Dict['remark']
supCto.remark = remark
if 'commonPhone' in json2Dict:
if isValid(json2Dict['commonPhone']):
common_phone = json2Dict['commonPhone']
supCto.common_phone = common_phone
if 'reservePhone' in json2Dict:
if isValid(json2Dict['reservePhone']):
reserve_phone = json2Dict['reservePhone']
supCto.reserve_phone = reserve_phone
if 'state' in json2Dict:
if isValid(json2Dict['state']):
state = json2Dict['state']
supCto.state = state
if 'province' in json2Dict:
if isValid(json2Dict['province']):
province = json2Dict['province']
supCto.province = province
if 'city' in json2Dict:
if isValid(json2Dict['city']):
city = json2Dict['city']
supCto.city = city
if 'area' in json2Dict:
if isValid(json2Dict['area']):
area = json2Dict['area']
supCto.area = area
if 'customerOrSupplier' in json2Dict:
customer_or_supplier = int(json2Dict['customerOrSupplier'])
if supCto.customer_or_supplier != customer_or_supplier:
if customer_or_supplier == 1:
identifier = 'CTO' + supCto.identifier[3:]
supCto.identifier = identifier
supCto.customer_or_supplier = customer_or_supplier
elif customer_or_supplier == 2:
identifier = 'SUP' + supCto.identifier[3:]
supCto.identifier = identifier
supCto.customer_or_supplier = customer_or_supplier
else:
pass
supCto.operator_time = time.strftime(
'%Y-%m-%d %H:%M:%S', time.localtime(time.time()))
if 'operatorIdentifier' in json2Dict:
if isValid(json2Dict['operatorIdentifier']):
operator_identifier = json2Dict['operatorIdentifier']
supCto.operator_identifier = operator_identifier
if 'provinceCode' in json2Dict:
if isValid(json2Dict['provinceCode']):
province_code = json2Dict['provinceCode']
supCto.province_code = province_code
if 'cityCode' in json2Dict:
if isValid(json2Dict['cityCode']):
city_code = json2Dict['cityCode']
supCto.city_code = city_code
if 'areaCode' in json2Dict:
if isValid(json2Dict['areaCode']):
area_code = json2Dict['areaCode']
supCto.area_code = area_code
if 'website' in json2Dict:
if isValid(json2Dict['website']):
website = json2Dict['website']
supCto.website = website
if 'memoryCode' in json2Dict:
if isValid(json2Dict['memoryCode']):
memory_code = json2Dict['memoryCode']
supCto.memory_code = memory_code
if 'useable' in json2Dict:
if isValid(json2Dict['useable']):
useable = json2Dict['useable']
supCto.useable = useable
if 'advanceMoney' in json2Dict:
if isValid(json2Dict['advanceMoney']):
advance_money = json2Dict['advanceMoney']
supCto.advance_money = advance_money
if 'isShow' in json2Dict:
if isValid(json2Dict['isShow']):
is_show = json2Dict['isShow']
supCto.is_show = is_show
if 'parentID' in json2Dict:
if isValid(json2Dict['parentID']):
parent_id = json2Dict['parentID']
supCto.parent_id = parent_id
supCto.save()
if 'commodityList' in json2Dict:
commodity_list = json2Dict['commodityList']
for commodity in commodity_list:
if 'supctoCommodityID' in commodity:
supcto_commodity_id = commodity[
'supctoCommodityID']
supctoCommodity = SupctoCommodity.objects.get(
id=supcto_commodity_id)
if 'commodityID' in commodity:
if isValid(commodity['commodityID']):
commodity_id = commodity['commodityID']
supctoCommodity.commodity_id = commodity_id
if 'price' in commodity:
if isValid(commodity['price']):
price = commodity['price']
supctoCommodity.price = price
if 'supctoID' in commodity:
if isValid(commodity['supctoID']):
supcto_id = commodity['supctoID']
supctoCommodity.supcto_id = supcto_id
supctoCommodity.save()
else:
continue
supCtoJSON = getSupCto(supCto)
thirdPartyUpdate = setStatus(200, supCtoJSON)
else:
thirdPartyUpdate = setStatus(300, {})
return HttpResponse(json.dumps(thirdPartyUpdate),
content_type='application/json')
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
thirdPartyUpdate = setStatus(500, traceback.format_exc())
def thirdPartyInsert(request):
try:
if isTokenExpired(request):
thirdPartyInsert = {}
json2Dict = json.loads(request.body)
if 'classificationID' in json2Dict:
if isValid(json2Dict['classificationID']):
classification_id = int(json2Dict['classificationID'])
else:
classification_id = 0
else:
classification_id = 0
if 'name' in json2Dict:
if isValid(json2Dict['name']):
name = json2Dict['name']
else:
name = None
else:
name = None
if 'fullName' in json2Dict:
if isValid(json2Dict['fullName']):
full_name = json2Dict['fullName']
else:
full_name = None
else:
full_name = None
if 'frade' in json2Dict:
if isValid(json2Dict['frade']):
frade = int(json2Dict['frade'])
else:
frade = 1
else:
frade = 1
if 'fromType' in json2Dict:
if isValid(json2Dict['fromType']):
from_type = int(json2Dict['fromType'])
else:
from_type = 1
else:
from_type = 1
if 'settlementTypeID' in json2Dict:
if isValid(json2Dict['settlementTypeID']):
settlement_type_id = int(json2Dict['settlementTypeID'])
else:
settlement_type_id = 0
else:
settlement_type_id = 0
if 'phone' in json2Dict:
if isValid(json2Dict['phone']):
phone = json2Dict['phone']
else:
phone = None
else:
phone = None
if 'contactPeople' in json2Dict:
if isValid(json2Dict['contactPeople']):
contact_people = json2Dict['contactPeople']
else:
contact_people = None
else:
contact_people = None
if 'postcode' in json2Dict:
if isValid(json2Dict['postcode']):
postcode = json2Dict['postcode']
else:
postcode = None
else:
postcode = None
if 'fax' in json2Dict:
if isValid(json2Dict['fax']):
fax = json2Dict['fax']
else:
fax = None
else:
fax = None
if 'bankAccount' in json2Dict:
if isValid(json2Dict['bankAccount']):
bank_account = json2Dict['bankAccount']
else:
bank_account = None
else:
bank_account = None
if 'bank' in json2Dict:
if isValid(json2Dict['bank']):
bank = json2Dict['bank']
else:
bank = None
else:
bank = None
if 'ratepaying' in json2Dict:
if isValid(json2Dict['ratepaying']):
ratepaying = json2Dict['ratepaying']
else:
ratepaying = None
else:
ratepaying = None
if 'mailbox' in json2Dict:
if isValid(json2Dict['mailbox']):
mailbox = json2Dict['mailbox']
else:
mailbox = None
else:
mailbox = None
if 'invoiceType' in json2Dict:
if isValid(json2Dict['invoiceType']):
invoice_type = int(json2Dict['invoiceType'])
else:
invoice_type = 1
else:
invoice_type = 1
if 'deliveryAddress' in json2Dict:
if isValid(json2Dict['deliveryAddress']):
delivery_address = json2Dict['deliveryAddress']
else:
delivery_address = None
else:
delivery_address = None
if 'creditDays' in json2Dict:
if isValid(json2Dict['creditDays']):
credit_days = int(json2Dict['creditDays'])
else:
credit_days = 0
else:
credit_days = 0
if 'creditMoney' in json2Dict:
if isValid(json2Dict['creditMoney']):
credit_money = atof(json2Dict['creditMoney'])
else:
credit_money = 0
else:
credit_money = 0
if 'information' in json2Dict:
if isValid(json2Dict['information']):
information = json2Dict['information']
else:
information = None
else:
information = None
if 'otherInformation' in json2Dict:
if isValid(json2Dict['otherInformation']):
other_information = json2Dict['otherInformation']
else:
other_information = None
else:
other_information = None
if 'departmentID' in json2Dict:
if isValid(json2Dict['departmentID']):
department_id = int(json2Dict['departmentID'])
else:
department_id = 0
else:
department_id = 0
if 'personID' in json2Dict:
if isValid(json2Dict['personID']):
person_id = int(json2Dict['personID'])
else:
person_id = 0
else:
person_id = 0
if 'currency' in json2Dict:
if isValid(json2Dict['currency']):
currency = int(json2Dict['currency'])
else:
currency = 0
else:
currency = 0
if 'communicationAddress' in json2Dict:
if isValid(json2Dict['communicationAddress']):
communication_address = json2Dict['communicationAddress']
else:
communication_address = None
else:
communication_address = None
if 'taxes' in json2Dict:
if isValid(json2Dict['taxes']):
taxes = atof(json2Dict['taxes'])
else:
taxes = 0
else:
taxes = 0
if 'member' in json2Dict:
if isValid(json2Dict['member']):
member = json2Dict['member']
else:
member = None
else:
member = None
if 'shippingModeID' in json2Dict:
if isValid(json2Dict['shippingModeID']):
shipping_mode_id = int(json2Dict['shippingModeID'])
else:
shipping_mode_id = 0
else:
shipping_mode_id = 0
if 'remark' in json2Dict:
if isValid(json2Dict['remark']):
remark = json2Dict['remark']
else:
remark = None
else:
remark = None
if 'commonPhone' in json2Dict:
if isValid(json2Dict['commonPhone']):
common_phone = json2Dict['commonPhone']
else:
common_phone = None
else:
common_phone = None
if 'reservePhone' in json2Dict:
if isValid(json2Dict['reservePhone']):
reserve_phone = json2Dict['reservePhone']
else:
reserve_phone = None
else:
reserve_phone = None
if 'state' in json2Dict:
if isValid(json2Dict['state']):
state = int(json2Dict['state'])
else:
state = 1
else:
state = 1
if 'province' in json2Dict:
if isValid(json2Dict['province']):
province = json2Dict['province']
else:
province = None
else:
province = None
if 'city' in json2Dict:
if isValid(json2Dict['city']):
city = json2Dict['city']
else:
city = None
else:
city = None
if 'area' in json2Dict:
if isValid(json2Dict['area']):
area = json2Dict['area']
else:
area = None
else:
area = None
customer_or_supplier = int(json2Dict['customerOrSupplier'])
operator_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
if customer_or_supplier == 1:
identifier = 'CTO-' + operator_time[0:10] + '-'
elif customer_or_supplier == 2:
identifier = 'SUP-' + operator_time[0:10] + '-'
else:
thirdPartyInsert = setStatus(300, {})
return HttpResponse(json.dumps(thirdPartyInsert),
content_type='application/json')
if 'operatorIdentifier' in json2Dict:
if isValid(json2Dict['operatorIdentifier']):
operator_identifier = json2Dict['operatorIdentifier']
else:
operator_identifier = None
else:
operator_identifier = None
if 'provinceCode' in json2Dict:
if isValid(json2Dict['provinceCode']):
province_code = json2Dict['provinceCode']
else:
province_code = None
else:
province_code = None
if 'cityCode' in json2Dict:
if isValid(json2Dict['cityCode']):
city_code = json2Dict['cityCode']
else:
city_code = None
else:
city_code = None
if 'areaCode' in json2Dict:
if isValid(json2Dict['areaCode']):
area_code = json2Dict['areaCode']
else:
area_code = None
else:
area_code = None
if 'website' in json2Dict:
if isValid(json2Dict['website']):
website = json2Dict['website']
else:
website = None
else:
website = None
if 'memoryCode' in json2Dict:
if isValid(json2Dict['memoryCode']):
memory_code = json2Dict['memoryCode']
else:
memory_code = None
else:
memory_code = None
if 'useable' in json2Dict:
if isValid(json2Dict['useable']):
useable = int(json2Dict['useable'])
else:
useable = 1
else:
useable = 1
if 'advanceMoney' in json2Dict:
if isValid(json2Dict['advanceMoney']):
advance_money = atof(json2Dict['advanceMoney'])
else:
advance_money = 0
else:
advance_money = 0
if 'isShow' in json2Dict:
if isValid(json2Dict['isShow']):
is_show = int(json2Dict['isShow'])
else:
is_show = 1
else:
is_show = 1
if 'parentID' in json2Dict:
if isValid(json2Dict['parentID']):
parent_id = int(json2Dict['parentID'])
else:
parent_id = 0
else:
parent_id = 0
supCto = Supcto(
None, classification_id, name, full_name, frade, from_type,
settlement_type_id, phone, contact_people, postcode, fax,
bank_account, bank, ratepaying, mailbox, invoice_type,
delivery_address, credit_days, credit_money, identifier,
information, other_information, department_id, person_id,
currency, communication_address, taxes, member,
shipping_mode_id, remark, common_phone, reserve_phone, state,
province, city, area, customer_or_supplier,
operator_identifier, operator_time, province_code, city_code,
area_code, website, memory_code, useable, advance_money,
is_show, parent_id)
supCto.save()
supCto.identifier = identifier + str(supCto.id)
supCto.save()
if 'commodityList' in json2Dict:
commodities = json2Dict['commodityList']
for commodity in commodities:
commodity_id = commodity['commodityID']
price = commodity['price']
supcto_id = supCto.id
supctoCommodity = SupctoCommodity(None, commodity_id,
supcto_id, price)
supctoCommodity.save()
supCtoJSON = getSupCto(supCto)
thirdPartyInsert = setStatus(200, supCtoJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
thirdPartyInsert = setStatus(500, traceback.format_exc())
def breakageUpdate(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifier = json2Dict['identifier']
breakages = BreakageOrder.objects.filter(identifier=identifier)
if len(breakages) > 0:
breakage = breakages[0]
else:
breakageUpdate = setStatus(300, {})
return HttpResponse(json.dumps(breakageUpdate),
content_type='application/json')
if 'warehouseID' in json2Dict:
if isValid(json2Dict['warehouseID']):
warehouse_id = int(json2Dict['warehouseID'])
breakage.warehouse_id = warehouse_id
if 'personID' in json2Dict:
if isValid(json2Dict['personID']):
person_id = int(json2Dict['personID'])
breakage.person_id = person_id
if 'originator' in json2Dict:
if isValid(json2Dict['originator']):
originator = json2Dict['originator']
breakage.originator = originator
if 'reviewer' in json2Dict:
if isValid(json2Dict['reviewer']):
reviewer = json2Dict['reviewer']
breakage.reviewer = reviewer
if 'summary' in json2Dict:
if isValid(json2Dict['summary']):
summary = json2Dict['summary']
breakage.summary = summary
if 'state' in json2Dict:
if isValid(json2Dict['state']):
state = int(json2Dict['state'])
breakage.state = state
if 'printNum' in json2Dict:
if isValid(json2Dict['printNum']):
print_num = int(json2Dict['printNum'])
breakage.print_num = print_num
breakage.save()
if 'breakageOrderCommodities' in json2Dict:
breakageCommodities = json2Dict['breakageCommodities']
for breakageCommodity in breakageCommodities:
if 'breakageCommodityID' in breakageCommodity:
breakageCommodityID = breakageCommodity[
'breakageCommodityID']
breakageCommodityObjs = BreakageOrderCommodity.objects.filter(
id=breakageCommodityID)
if len(breakageCommodityObjs) > 0:
breakageCommodityObj = breakageCommodityObjs[0]
else:
breakageUpdate = setStatus(300, {})
return HttpResponse(
json.dumps(breakageUpdate),
content_type='application/json')
else:
continue
if 'commoditySpecificationID' in breakageCommodity:
if isValid(
breakageCommodity['commoditySpecificationID']):
commodity_specification_id = int(
breakageCommodity['commoditySpecificationID'])
breakageCommodityObj.commodity_specification_id = commodity_specification_id
if 'number' in breakageCommodity:
if isValid(breakageCommodity['number']):
number = int(breakageCommodity['number'])
breakageCommodityObj.number = number
if 'unitPrice' in breakageCommodity:
if isValid(breakageCommodity['unitPrice']):
unit_price = atof(breakageCommodity['unitPrice'])
breakageCommodityObj.unit_price = unit_price
if 'money' in breakageCommodity:
if isValid(breakageCommodity['money']):
money = atof(breakageCommodity['money'])
breakageCommodityObj.money = money
breakageCommodityObj.save()
breakageJSON = getBreakage(breakage)
breakageUpdate = setStatus(200, breakageJSON)
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
breakageUpdate = setStatus(500, traceback.format_exc())
def personInsert(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
if 'name' in json2Dict:
if isValid(json2Dict['name']):
name = json2Dict['name']
else:
name = None
else:
name = None
if 'type' in json2Dict:
if isValid(json2Dict['type']):
type = json2Dict['type']
else:
type = None
else:
type = None
if 'departmentID' in json2Dict:
if isValid(json2Dict['departmentID']):
department_id = int(json2Dict['departmentID'])
else:
department_id = 0
else:
department_id = 0
if 'entryTime' in json2Dict:
if isValid(json2Dict['entryTime']):
entryTimeStr = json2Dict['entryTime']
entry_time = time.strptime(entryTimeStr, '%Y-%m-%d')
entry_time = datetime.datetime(*entry_time[:3]).date()
else:
entry_time = time.strftime('%Y-%m-%d',
time.localtime(time.time()))
else:
entry_time = time.strftime('%Y-%m-%d',
time.localtime(time.time()))
if 'duties' in json2Dict:
if isValid(json2Dict['duties']):
duties = json2Dict['duties']
else:
duties = None
else:
duties = None
if 'education' in json2Dict:
if isValid(json2Dict['education']):
education = json2Dict['education']
else:
education = None
else:
education = None
if 'sex' in json2Dict:
if isValid(json2Dict['sex']):
sex = json2Dict['sex']
else:
sex = None
else:
sex = None
if 'birthTime' in json2Dict:
if isValid(json2Dict['birthTime']):
birthTimeStr = json2Dict['birthTime']
birth_time = time.strptime(birthTimeStr, '%Y-%m-%d')
birth_time = datetime.datetime(*birth_time[:3]).date()
else:
birth_time = None
else:
birth_time = None
if 'nativePlace' in json2Dict:
if isValid(json2Dict['nativePlace']):
native_place = json2Dict['nativePlace']
else:
native_place = None
else:
native_place = None
if 'phone' in json2Dict:
if isValid(json2Dict['phone']):
phone = json2Dict['phone']
else:
phone = None
else:
phone = None
if 'homePhone' in json2Dict:
if isValid(json2Dict['homePhone']):
home_phone = json2Dict['homePhone']
else:
home_phone = None
else:
home_phone = None
if 'commonPhone' in json2Dict:
if isValid(json2Dict['commonPhone']):
common_phone = json2Dict['commonPhone']
else:
common_phone = None
else:
common_phone = None
if 'reservePhone' in json2Dict:
if isValid(json2Dict['reservePhone']):
reserve_phone = json2Dict['reservePhone']
else:
reserve_phone = None
else:
reserve_phone = None
if 'postcode' in json2Dict:
if isValid(json2Dict['postcode']):
postcode = json2Dict['postcode']
else:
postcode = None
else:
postcode = None
if 'homeAddress' in json2Dict:
if isValid(json2Dict['homeAddress']):
home_address = json2Dict['homeAddress']
else:
home_address = None
else:
home_address = None
if 'mailbox' in json2Dict:
if isValid(json2Dict['mailbox']):
mailbox = json2Dict['mailbox']
else:
mailbox = None
else:
mailbox = None
quit_time = None
if 'business' in json2Dict:
if isValid(json2Dict['business']):
business = int(json2Dict['business'])
else:
business = 0
else:
business = 0
if 'quite' in json2Dict:
if isValid(json2Dict['quite']):
quite = int(json2Dict['quite'])
else:
quite = 0
else:
quite = 0
if 'operatorIdentifier' in json2Dict:
if isValid(json2Dict['operatorIdentifier']):
operator_identifier = json2Dict['operatorIdentifier']
else:
operator_identifier = ''
else:
operator_identifier = ''
operator_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
if 'remark' in json2Dict:
if isValid(json2Dict['remark']):
remark = json2Dict['remark']
else:
remark = None
else:
remark = None
if 'idNumber' in json2Dict:
if isValid(json2Dict['idNumber']):
id_number = json2Dict['idNumber']
else:
id_number = None
else:
id_number = None
identifier = 'PPL-' + operator_time[0:10] + '-'
if 'loginName' in json2Dict:
if isValid(json2Dict['loginName']):
login_name = json2Dict['loginName']
personCount = Person.objects.filter(
login_name=login_name).count()
if personCount > 0:
personInsert = setStatus(
300, "the 'loginName' is exists ! ")
return HttpResponse(json.dumps(personInsert),
content_type='application/json')
else:
login_name = None
else:
login_name = None
if 'password' in json2Dict:
if isValid(json2Dict['password']):
password = json2Dict['password']
password = base64.b64encode(password)
else:
password = base64.b64encode('1')
else:
password = base64.b64encode('1')
if 'warehouseID' in json2Dict:
if isValid(json2Dict['warehouseID']):
warehouse_id = int(json2Dict['warehouseID'])
else:
warehouse_id = 0
else:
warehouse_id = 0
if 'place' in json2Dict:
if isValid(json2Dict['place']):
place = json2Dict['place']
else:
place = None
else:
place = None
is_delete = 0
person = Person(None, name, type, department_id, entry_time,
duties, education, sex, birth_time, native_place,
phone, home_phone, common_phone, reserve_phone,
postcode, home_address, mailbox, quit_time,
business, quite, operator_identifier,
operator_time, remark, id_number, identifier,
login_name, password, warehouse_id, place,
is_delete)
person.save()
person.identifier = identifier + str(person.id)
person.save()
personToken = PersonToken(None, person.id, None, None, None)
personToken.save()
if 'resIDs' in json2Dict:
create_time = operator_time
resIds = json2Dict['resIDs']
user_id = person.id
operator_identifier = person.identifier
for resId in resIds:
menu_id = resId
permission = Permission(None, user_id, menu_id,
operator_identifier, create_time)
permission.save()
person.save()
personJSON = getPersonObj(person)
personInsert = setStatus(200, personJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
personInsert = setStatus(500, traceback.format_exc())
def breakageInsert(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
breakage_date = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
identifier = 'BO-' + breakage_date[0:10] + '-'
if 'warehouseID' in json2Dict:
if isValid(json2Dict['warehouseID']):
warehouse_id = int(json2Dict['warehouseID'])
else:
warehouse_id = 0
else:
warehouse_id = 0
if 'personID' in json2Dict:
if isValid(json2Dict['personID']):
person_id = int(json2Dict['personID'])
else:
person_id = 0
else:
person_id = 0
if 'originator' in json2Dict:
if isValid(json2Dict['originator']):
originator = json2Dict['originator']
else:
originator = None
else:
originator = None
if 'reviewer' in json2Dict:
if isValid(json2Dict['reviewer']):
reviewer = json2Dict['reviewer']
else:
reviewer = None
else:
reviewer = None
if 'summary' in json2Dict:
if isValid(json2Dict['summary']):
summary = json2Dict['summary']
else:
summary = None
else:
summary = None
if 'state' in json2Dict:
if isValid(json2Dict['state']):
state = int(json2Dict['state'])
else:
state = 0
else:
state = 0
if 'printNum' in json2Dict:
if isValid(json2Dict['printNum']):
print_num = int(json2Dict['printNum'])
else:
print_num = 0
else:
print_num = 0
is_delete = 0
breakage = BreakageOrder(None, breakage_date, identifier,
warehouse_id, person_id, originator,
reviewer, summary, state, print_num,
is_delete)
breakage.save()
breakage.identifier = identifier + str(breakage.id)
breakage.save()
if 'breakageCommodities' in json2Dict:
breakageCommodities = json2Dict['breakageCommodities']
for breakageCommodity in breakageCommodities:
breakage_order_id = breakage.id
if 'commoditySpecificationID' in breakageCommodity:
if isValid(json2Dict['commoditySpecificationID']):
commodity_specification_id = int(
breakageCommodity['commoditySpecificationID'])
else:
commodity_specification_id = 0
else:
commodity_specification_id = 0
if 'number' in breakageCommodity:
if isValid(json2Dict['number']):
number = int(breakageCommodity['number'])
else:
number = 0
else:
number = 0
if 'unitPrice' in breakageCommodity:
if isValid(json2Dict['unitPrice']):
unit_price = atof(breakageCommodity['unitPrice'])
else:
unit_price = 0
else:
unit_price = 0
if 'money' in breakageCommodity:
if isValid(json2Dict['money']):
money = atof(breakageCommodity['money'])
else:
money = 0
else:
money = 0
breakageCommodityObj = BreakageOrderCommodity(
None, breakage_order_id, commodity_specification_id,
number, unit_price, money)
breakageCommodityObj.save()
breakageJSON = getBreakage(breakage)
breakageInsert = setStatus(200, breakageJSON)
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
breakageInsert = setStatus(500, traceback.format_exc())
def salesPlanInsert(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
create_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
identifier = 'SP-' + create_time[0:10] + '-'
if 'endTime' in json2Dict:
if isValid(json2Dict['endTime']):
end_time_str = json2Dict['endTime']
end_time = time.strptime(end_time_str, '%Y-%m-%d')
end_time = datetime.datetime(*end_time[:3]).date()
else:
end_time = None
else:
end_time = None
if 'currency' in json2Dict:
if isValid(json2Dict['currency']):
currency = int(json2Dict['currency'])
else:
currency = 0
else:
currency = 0
if 'branch' in json2Dict:
if isValid(json2Dict['branch']):
branch = json2Dict['branch']
else:
branch = None
else:
branch = None
if 'originator' in json2Dict:
if isValid(json2Dict['originator']):
originator = json2Dict['originator']
else:
originator = None
else:
originator = None
if 'summary' in json2Dict:
if isValid(json2Dict['summary']):
summary = json2Dict['summary']
else:
summary = None
else:
summary = None
if 'supctoID' in json2Dict:
if isValid(json2Dict['supctoID']):
supcto_id = int(json2Dict['supctoID'])
else:
supcto_id = 0
else:
supcto_id = 0
if 'personID' in json2Dict:
if isValid(json2Dict['personID']):
person_id = int(json2Dict['personID'])
else:
person_id = 0
else:
person_id = 0
if 'state' in json2Dict:
if isValid(json2Dict['state']):
state = int(json2Dict['state'])
else:
state = 0
else:
state = 0
if 'isAppOrder' in json2Dict:
if isValid(json2Dict['isAppOrder']):
is_app_order = int(json2Dict['isAppOrder'])
else:
is_app_order = 0
else:
is_app_order = 0
if 'appConsigneeName' in json2Dict:
if isValid(json2Dict['appConsigneeName']):
app_consignee_name = json2Dict['appConsigneeName']
else:
app_consignee_name = None
else:
app_consignee_name = None
if 'appConsigneePhone' in json2Dict:
if isValid(json2Dict['appConsigneePhone']):
app_consignee_phone = json2Dict['appConsigneePhone']
else:
app_consignee_phone = None
else:
app_consignee_phone = None
if 'appConsigneeAddress' in json2Dict:
if isValid(json2Dict['appConsigneeAddress']):
app_consignee_address = json2Dict['appConsigneeAddress']
else:
app_consignee_address = None
else:
app_consignee_address = None
if 'missOrderID' in json2Dict:
if isValid(json2Dict['missOrderID']):
miss_order_id = int(json2Dict['missOrderID'])
else:
miss_order_id = 0
else:
miss_order_id = 0
if 'activityID' in json2Dict:
if isValid(json2Dict['activityID']):
activity_id = int(json2Dict['activityID'])
else:
activity_id = 0
else:
activity_id = 0
if 'fax' in json2Dict:
if isValid(json2Dict['fax']):
fax = json2Dict['fax']
else:
fax = None
else:
fax = None
if 'shippingModeID' in json2Dict:
if isValid(json2Dict['shippingModeID']):
shipping_mode_id = int(json2Dict['shippingModeID'])
else:
shipping_mode_id = 0
else:
shipping_mode_id = 0
if 'phone' in json2Dict:
if isValid(json2Dict['phone']):
phone = json2Dict['phone']
else:
phone = None
else:
phone = None
if 'deliverGoodsPlace' in json2Dict:
if isValid(json2Dict['deliverGoodsPlace']):
deliver_goods_place = json2Dict['deliverGoodsPlace']
else:
deliver_goods_place = None
else:
deliver_goods_place = None
if 'orderer' in json2Dict:
if isValid(json2Dict['orderer']):
orderer = json2Dict['orderer']
else:
orderer = None
else:
orderer = None
salesPlanOrder = SalesPlanOrder(
None, identifier, create_time, end_time, currency, branch,
originator, summary, supcto_id, person_id, state, is_app_order,
app_consignee_name, app_consignee_phone, app_consignee_address,
miss_order_id, activity_id, fax, shipping_mode_id, phone,
deliver_goods_place, orderer)
salesPlanOrder.save()
salesPlanOrder.identifier = identifier + str(salesPlanOrder.id)
salesPlanOrder.save()
if 'salesPlanOrderCommodities' in json2Dict:
salesPlanOrderCommodities = json2Dict[
'salesPlanOrderCommodities']
for salesPlanOrderCommodity in salesPlanOrderCommodities:
sales_plan_order_id = salesPlanOrder.id
if 'commoditiespecificationID' in salesPlanOrderCommodity:
if isValid(json2Dict['commoditiespecificationID']):
commodity_specification_id = int(
salesPlanOrderCommodity[
'commoditiespecificationID'])
else:
commodity_specification_id = 0
else:
commodity_specification_id = 0
if 'number' in salesPlanOrderCommodity:
if isValid(salesPlanOrderCommodity['number']):
number = int(salesPlanOrderCommodity['number'])
else:
number = 0
else:
number = 0
if 'unitPrice' in salesPlanOrderCommodity:
if isValid(salesPlanOrderCommodity['unitPrice']):
unit_price = int(
salesPlanOrderCommodity['unitPrice'])
else:
unit_price = 0
else:
unit_price = 0
if 'money' in salesPlanOrderCommodity:
if isValid(salesPlanOrderCommodity['money']):
money = atof(salesPlanOrderCommodity['money'])
else:
money = 0
else:
money = 0
if 'remark' in salesPlanOrderCommodity:
if isValid(salesPlanOrderCommodity['remark']):
remark = salesPlanOrderCommodity['remark']
else:
remark = None
else:
remark = None
salesPlanOrderCommodity = SalesPlanOrderCommodity(
None, sales_plan_order_id, commodity_specification_id,
number, unit_price, money, remark)
salesPlanOrderCommodity.save()
salesPlanOrderJSON = getSalesPlanOrder(salesPlanOrder)
salesPlanInsert = setStatus(200, salesPlanOrderJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
salesPlanInsert = setStatus(500, traceback.format_exc())
def packageOrTeardownInsert(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
package_or_teardown_date = time.strftime(
'%Y-%m-%d %H:%M:%S', time.localtime(time.time()))
identifier = 'PAK-' + package_or_teardown_date[0:10] + '-'
order_type = int(json2Dict['orderType'])
if 'warehouseID' in json2Dict:
if isValid(json2Dict['warehouseID']):
warehouse_id = int(json2Dict['warehouseID'])
else:
warehouse_id = 0
else:
warehouse_id = 0
if 'commoditySpecificationID' in json2Dict:
if isValid(json2Dict['commoditySpecificationID']):
commodity_specification_id = int(
json2Dict['commoditySpecificationID'])
else:
commodity_specification_id = 0
else:
commodity_specification_id = 0
if 'packageOrTeardownNum' in json2Dict:
if isValid(json2Dict['packageOrTeardownNum']):
package_or_teardown_num = int(
json2Dict['packageOrTeardownNum'])
else:
package_or_teardown_num = 0
else:
package_or_teardown_num = 0
if 'unitPrice' in json2Dict:
if isValid(json2Dict['unitPrice']):
unit_price = atof(json2Dict['unitPrice'])
else:
unit_price = 0
else:
unit_price = 0
if 'totalMoney' in json2Dict:
if isValid(json2Dict['totalMoney']):
total_money = atof(json2Dict['totalMoney'])
else:
total_money = 0
else:
total_money = 0
if 'personID' in json2Dict:
if isValid(json2Dict['personID']):
person_id = int(json2Dict['personID'])
else:
person_id = 0
else:
person_id = 0
if 'originator' in json2Dict:
if isValid(json2Dict['originator']):
originator = json2Dict['originator']
else:
originator = None
else:
originator = None
if 'reviewer' in json2Dict:
if isValid(json2Dict['reviewer']):
reviewer = json2Dict['reviewer']
else:
reviewer = None
else:
reviewer = None
if 'summary' in json2Dict:
if isValid(json2Dict['summary']):
summary = json2Dict['summary']
else:
summary = None
else:
summary = None
if 'state' in json2Dict:
if isValid(json2Dict['state']):
state = int(json2Dict['state'])
else:
state = 0
else:
state = 0
if 'printNum' in json2Dict:
if isValid(json2Dict['printNum']):
print_num = int(json2Dict['printNum'])
else:
print_num = 0
else:
print_num = 0
is_delete = 0
package = PackageOrTeardownOrder(
None, order_type, package_or_teardown_date, identifier,
warehouse_id, commodity_specification_id,
package_or_teardown_num, unit_price, total_money, person_id,
originator, reviewer, summary, state, print_num, is_delete)
package.save()
package.identifier = identifier + str(package.id)
package.save()
if 'packageCommodities' in json2Dict:
packageCommodities = json2Dict['packageCommodities']
for packageCommodity in packageCommodities:
package_or_teardown_order_id = package.id
if 'commoditySpecificationID' in packageCommodity:
if isValid(packageCommodity['number']):
commodity_specification_id = int(
packageCommodity['commoditySpecificationID'])
else:
commodity_specification_id = 0
else:
commodity_specification_id = 0
if 'number' in packageCommodity:
if isValid(packageCommodity['number']):
number = int(packageCommodity['number'])
else:
number = 0
else:
number = 0
if 'unitPrice' in packageCommodity:
if isValid(packageCommodity['unitPrice']):
unit_price = atof(packageCommodity['unitPrice'])
else:
unit_price = 0
else:
unit_price = 0
if 'money' in packageCommodity:
if isValid(packageCommodity['money']):
money = atof(packageCommodity['money'])
else:
money = 0
else:
money = 0
packageCommodityObj = PackageOrTeardownOrderCommodity(
None, package_or_teardown_order_id,
commodity_specification_id, number, unit_price, money)
packageCommodityObj.save()
packageCommodityJSON = getPackage(package)
packageOrTeardownInsert = setStatus(200, packageCommodityJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
packageOrTeardownInsert = setStatus(500, traceback.format_exc())
def writeoffInsert(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
create_date = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
writeoff_code = 'AT-' + create_date[0:10] + '-'
if 'writeoffType' in json2Dict:
if isValid(json2Dict['writeoffType']):
writeoff_type = json2Dict['writeoffType']
else:
writeoff_type = None
else:
writeoff_type = None
if 'companyOne' in json2Dict:
if isValid(json2Dict['companyOne']):
company_one = int(json2Dict['companyOne'])
else:
company_one = 0
else:
company_one = 0
if 'companyTwo' in json2Dict:
if isValid(json2Dict['companyTwo']):
company_two = int(json2Dict['companyTwo'])
else:
company_two = 0
else:
company_two = 0
if 'money' in json2Dict:
if isValid(json2Dict['money']):
money = atof(json2Dict['money'])
else:
money = 0
else:
money = 0
if 'originator' in json2Dict:
if isValid(json2Dict['originator']):
originator = json2Dict['originator']
else:
originator = None
else:
originator = None
if 'personID' in json2Dict:
if isValid(json2Dict['personID']):
person_id = int(json2Dict['personID'])
else:
person_id = 0
else:
person_id = 0
if 'summary' in json2Dict:
if isValid(json2Dict['summary']):
summary = json2Dict['summary']
else:
summary = None
else:
summary = None
if 'remark' in json2Dict:
if isValid(json2Dict['remark']):
remark = json2Dict['remark']
else:
remark = None
else:
remark = None
if 'voucherNo' in json2Dict:
if isValid(json2Dict['voucherNo']):
voucher_no = json2Dict['voucherNo']
else:
voucher_no = None
else:
voucher_no = None
if 'branch' in json2Dict:
if isValid(json2Dict['branch']):
branch = json2Dict['branch']
else:
branch = None
else:
branch = None
writeoff = Writeoff(None, writeoff_code, writeoff_type,
company_one, company_two, money, create_date,
originator, person_id, summary, remark,
voucher_no, branch)
writeoff.save()
writeoff.writeoff_code = writeoff_code + str(writeoff.id)
writeoff.save()
if 'writeOffSubs' in json2Dict:
writeOffSubs = json2Dict['writeOffSubs']
for writeOffSub in writeOffSubs:
writeoff_id = writeoff.id
if 'procureSalesID' in writeOffSub:
if isValid(writeOffSub['procureSalesID']):
procure_sales_id = int(
writeOffSub['procureSalesID'])
else:
procure_sales_id = 0
else:
procure_sales_id = 0
if 'clearMoney' in writeOffSub:
if isValid(writeOffSub['clearMoney']):
clear_money = atof(writeOffSub['clearMoney'])
else:
clear_money = 0
else:
clear_money = 0
if 'stayMoney' in writeOffSub:
if isValid(writeOffSub['stayMoney']):
stay_money = atof(writeOffSub['stayMoney'])
else:
stay_money = 0
else:
stay_money = 0
if 'theMoney' in writeOffSub:
if isValid(writeOffSub['theMoney']):
the_money = int(writeOffSub['theMoney'])
else:
the_money = 0
else:
the_money = 0
if 'isWriteoff' in writeOffSub:
if isValid(writeOffSub['isWriteoff']):
is_writeoff = writeOffSub['isWriteoff']
else:
is_writeoff = None
else:
is_writeoff = None
if 'isProcureSales' in writeOffSub:
if isValid(writeOffSub['isProcureSales']):
is_procure_sales = int(
writeOffSub['isProcureSales'])
else:
is_procure_sales = 0
else:
is_procure_sales = 0
if 'remark' in writeOffSub:
if isValid(writeOffSub['remark']):
remark = writeOffSub['remark']
else:
remark = None
else:
remark = None
writeoffSubObj = WriteoffSub(None, writeoff_id,
procure_sales_id, clear_money,
stay_money, the_money,
is_writeoff, is_procure_sales,
remark)
writeoffSubObj.save()
writeoffJSON = getWriteoff(writeoff)
writeoffInsert = setStatus(200, writeoffJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
writeoffInsert = setStatus(500, traceback.format_exc())
def billInsert(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
bills_date = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time()))
bills_code = 'AP-' + bills_date[0:10] + '-'
if 'customerSupplierID' in json2Dict:
if isValid(json2Dict['customerSupplierID']):
customer_supplier_id = int(json2Dict['customerSupplierID'])
else:
customer_supplier_id = 0
else:
customer_supplier_id = 0
if 'billsType' in json2Dict:
if isValid(json2Dict['billsType']):
bills_type = json2Dict['billsType']
else:
bills_type = 0
else:
bills_type = None
if 'bank' in json2Dict:
if isValid(json2Dict['bank']):
bank = json2Dict['bank']
else:
bank = None
else:
bank = None
if 'bankAccount' in json2Dict:
if isValid(json2Dict['bankAccount']):
bank_account = json2Dict['bankAccount']
else:
bank_account = None
else:
bank_account = None
if 'payment' in json2Dict:
if isValid(json2Dict['payment']):
payment = int(json2Dict['payment'])
else:
payment = 0
else:
payment = 0
if 'originator' in json2Dict:
if isValid(json2Dict['originator']):
originator = json2Dict['originator']
else:
originator = None
else:
originator = None
if 'personID' in json2Dict:
if isValid(json2Dict['personID']):
person_id = int(json2Dict['personID'])
else:
person_id = 0
else:
person_id = 0
if 'summary' in json2Dict:
if isValid(json2Dict['summary']):
summary = json2Dict['summary']
else:
summary = None
else:
summary = None
if 'remark' in json2Dict:
if isValid(json2Dict['remark']):
remark = json2Dict['remark']
else:
remark = None
else:
remark = None
if 'money' in json2Dict:
if isValid(json2Dict['money']):
money = atof(json2Dict['money'])
else:
money = 0
else:
money = 0
if 'ticketNo' in json2Dict:
if isValid(json2Dict['ticketNo']):
ticket_no = json2Dict['ticketNo']
else:
ticket_no = None
else:
ticket_no = None
if 'branch' in json2Dict:
if isValid(json2Dict['branch']):
branch = json2Dict['branch']
else:
branch = None
else:
branch = None
if 'balance' in json2Dict:
if isValid(json2Dict['balance']):
balance = atof(json2Dict['balance'])
else:
balance = 0
else:
balance = 0
if 'account' in json2Dict:
if isValid(json2Dict['account']):
account = json2Dict['account']
else:
account = None
else:
account = None
if 'orderType' in json2Dict:
if isValid(json2Dict['orderType']):
order_type = json2Dict['orderType']
else:
order_type = None
else:
order_type = None
bill = Bills(None,bills_code,customer_supplier_id,bills_type,bills_date,bank,bank_account,payment,originator,person_id,summary,remark,money,ticket_no,branch,balance,account,order_type)
bill.save()
bill.bills_code = bills_code + str(bill.id)
bill.save()
if 'billsSubs' in json2Dict:
billsSubs = json2Dict['billsSubs']
for billsSub in billsSubs:
bills_id = bill.id
if 'procureSalesID' in billsSub:
if isValid(billsSub['procureSalesID']):
procure_sales_id = int(billsSub['procureSalesID'])
else:
procure_sales_id = 0
else:
procure_sales_id = 0
if 'clearingMoney' in billsSub:
if isValid(billsSub['clearingMoney']):
clearing_money = atof(billsSub['clearingMoney'])
else:
clearing_money = 0
else:
clearing_money = 0
if 'stayMoney' in billsSub:
if isValid(billsSub['stayMoney']):
stay_money = atof(billsSub['stayMoney'])
else:
stay_money = 0
else:
stay_money = 0
if 'theMoeny' in billsSub:
if isValid(billsSub['theMoeny']):
the_moeny = atof(billsSub['theMoeny'])
else:
the_moeny = 0
else:
the_moeny = 0
if 'actualMoney' in billsSub:
if isValid(billsSub['actualMoney']):
actual_money = atof(billsSub['actualMoney'])
else:
actual_money = 0
else:
actual_money = 0
if 'rebateMoney' in billsSub:
if isValid(billsSub['rebateMoney']):
rebate_money = atof(billsSub['rebateMoney'])
else:
rebate_money = 0
else:
rebate_money = 0
if 'isPayment' in billsSub:
if isValid(billsSub['isPayment']):
is_payment = billsSub['isPayment']
else:
is_payment = None
else:
is_payment = None
if 'rebate' in billsSub:
if isValid(billsSub['rebate']):
rebate = int(billsSub['rebate'])
else:
rebate = 0
else:
rebate = 0
if 'remark' in billsSub:
if isValid(billsSub['remark']):
remark = billsSub['remark']
else:
remark = None
else:
remark = None
if 'payMoney' in billsSub:
if isValid(billsSub['payMoney']):
pay_money = atof(billsSub['payMoney'])
else:
pay_money = 0
else:
pay_money = 0
billsSubObj = BillsSub(None,bills_id,procure_sales_id,clearing_money,stay_money,the_moeny,actual_money,rebate_money,is_payment,rebate,remark,pay_money)
billsSubObj.save()
billsJSON = getBills(bill)
billInsert = setStatus(200,billsJSON)
else:
return notTokenExpired()
except Exception,e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
billInsert = setStatus(500,traceback.format_exc())
def packageOrTeardownUpdate(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifier = json2Dict['identifier']
packages = PackageOrTeardownOrder.objects.filter(
identifier=identifier)
if len(packages) > 0:
package = packages[0]
else:
packageOrTeardownUpdate = setStatus(300, {})
return HttpResponse(json.dumps(packageOrTeardownUpdate),
content_type='application/json')
if 'orderType' in json2Dict:
if isValid(json2Dict['orderType']):
order_type = int(json2Dict['orderType'])
package.order_type = order_type
if 'warehouseID' in json2Dict:
if isValid(json2Dict['warehouseID']):
warehouse_id = int(json2Dict['warehouseID'])
package.warehouse_id = warehouse_id
if 'commoditySpecificationID' in json2Dict:
if isValid(json2Dict['commoditySpecificationID']):
commodity_specification_id = int(
json2Dict['commoditySpecificationID'])
package.commodity_specification_id = commodity_specification_id
if 'packageOrTeardownNum' in json2Dict:
if isValid(json2Dict['packageOrTeardownNum']):
package_or_teardown_num = int(
json2Dict['packageOrTeardownNum'])
package.package_or_teardown_num = package_or_teardown_num
if 'unitPrice' in json2Dict:
if isValid(json2Dict['unitPrice']):
unit_price = atof(json2Dict['unitPrice'])
package.unit_price = unit_price
if 'totalMoney' in json2Dict:
if isValid(json2Dict['totalMoney']):
total_money = atof(json2Dict['totalMoney'])
package.total_money = total_money
if 'personID' in json2Dict:
if isValid(json2Dict['personID']):
person_id = int(json2Dict['personID'])
package.person_id = person_id
if 'originator' in json2Dict:
if isValid(json2Dict['originator']):
originator = json2Dict['originator']
package.originator = originator
if 'reviewer' in json2Dict:
if isValid(json2Dict['reviewer']):
reviewer = json2Dict['reviewer']
package.reviewer = reviewer
if 'summary' in json2Dict:
if isValid(json2Dict['summary']):
summary = json2Dict['summary']
package.summary = summary
if 'state' in json2Dict:
if isValid(json2Dict['state']):
state = int(json2Dict['state'])
package.state = state
if 'printNum' in json2Dict:
if isValid(json2Dict['printNum']):
print_num = int(json2Dict['printNum'])
package.print_num = print_num
package.save()
if 'packageCommodities' in json2Dict:
packageCommodities = json2Dict['packageCommodities']
for packageCommodity in packageCommodities:
if 'packageCommodityID' in packageCommodity:
packageCommodityID = int(
packageCommodity['packageCommodityID'])
packageCommodityObjs = PackageOrTeardownOrderCommodity.objects.filter(
id=packageCommodityID)
if len(packageCommodityObjs) > 0:
packageCommodityObj = packageCommodityObjs[0]
else:
packageOrTeardownUpdate = setStatus(300, {})
return HttpResponse(
json.dumps(packageOrTeardownUpdate),
content_type='application/json')
else:
continue
if 'commoditySpecificationID' in packageCommodity:
if isValid(
packageCommodity['commoditySpecificationID']):
commodity_specification_id = int(
packageCommodity['commoditySpecificationID'])
packageCommodityObj.commodity_specification_id = commodity_specification_id
if 'number' in packageCommodity:
if isValid(packageCommodity['number']):
number = int(packageCommodity['number'])
packageCommodityObj.number = number
if 'unitPrice' in packageCommodity:
if isValid(packageCommodity['unitPrice']):
unit_price = atof(packageCommodity['unitPrice'])
packageCommodityObj.unit_price = unit_price
if 'money' in packageCommodity:
if isValid(packageCommodity['money']):
money = atof(packageCommodity['money'])
packageCommodityObj.money = money
packageCommodityObj.save()
packageJSON = getPackage(package)
packageOrTeardownUpdate = setStatus(200, packageJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
packageOrTeardownUpdate = setStatus(500, traceback.format_exc())
def personUpdate(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifier = json2Dict['identifier']
persons = Person.objects.filter(identifier=identifier)
if len(persons) > 0:
person = persons[0]
else:
personUpdate = setStatus(300, {})
return HttpResponse(json.dumps(personUpdate),
content_type='application/json')
if 'name' in json2Dict:
if isValid(json2Dict['name']):
name = json2Dict['name']
person.name = name
if 'type' in json2Dict:
if isValid(json2Dict['type']):
type = json2Dict['type']
person.type = type
if 'departmentID' in json2Dict:
if isValid(json2Dict['departmentID']):
department_id = int(json2Dict['departmentID'])
person.department_id = department_id
if 'entryTime' in json2Dict:
if isValid(json2Dict['entryTime']):
entryTimeStr = json2Dict['entryTime']
entry_time = time.strptime(entryTimeStr, '%Y-%m-%d')
person.entry_time = datetime.datetime(
*entry_time[:3]).date()
if 'duties' in json2Dict:
if isValid(json2Dict['duties']):
duties = json2Dict['duties']
person.duties = duties
if 'education' in json2Dict:
if isValid(json2Dict['education']):
education = json2Dict['education']
person.education = education
if 'sex' in json2Dict:
if isValid(json2Dict['sex']):
sex = json2Dict['sex']
person.sex = sex
if 'birthTime' in json2Dict:
if isValid(json2Dict['birthTime']):
birthTimeStr = json2Dict['birthTime']
birth_time = time.strptime(birthTimeStr, '%Y-%m-%d')
birth_time = datetime.datetime(*birth_time[:3]).date()
person.birth_time = birth_time
if 'nativePlace' in json2Dict:
if isValid(json2Dict['nativePlace']):
native_place = json2Dict['nativePlace']
person.native_place = native_place
if 'phone' in json2Dict:
if isValid(json2Dict['phone']):
phone = json2Dict['phone']
person.phone = phone
if 'homePhone' in json2Dict:
if isValid(json2Dict['homePhone']):
home_phone = json2Dict['homePhone']
person.home_phone = home_phone
if 'commonPhone' in json2Dict:
if isValid(json2Dict['commonPhone']):
common_phone = json2Dict['commonPhone']
person.common_phone = common_phone
if 'reservePhone' in json2Dict:
if isValid(json2Dict['reservePhone']):
reserve_phone = json2Dict['reservePhone']
person.reserve_phone = reserve_phone
if 'postcode' in json2Dict:
if isValid(json2Dict['postcode']):
postcode = json2Dict['postcode']
person.postcode = postcode
if 'homeAddress' in json2Dict:
if isValid(json2Dict['homeAddress']):
home_address = json2Dict['homeAddress']
person.home_address = home_address
if 'mailbox' in json2Dict:
if isValid(json2Dict['mailbox']):
mailbox = json2Dict['mailbox']
person.mailbox = mailbox
if 'quitTime' in json2Dict:
if isValid(json2Dict['quitTime']):
quit_time = json2Dict['quitTime']
person.quit_time = quit_time
if 'business' in json2Dict:
if isValid(json2Dict['business']):
business = int(json2Dict['business'])
person.business = business
if 'quite' in json2Dict:
if isValid(json2Dict['quite']):
quite = int(json2Dict['quite'])
person.quite = quite
if 'operatorIdentifier' in json2Dict:
if isValid(json2Dict['operatorIdentifier']):
operator_identifier = json2Dict['operatorIdentifier']
person.operator_identifier = operator_identifier
operator_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
if 'remark' in json2Dict:
if isValid(json2Dict['remark']):
remark = json2Dict['remark']
person.remark = remark
if 'idNumber' in json2Dict:
if isValid(json2Dict['idNumber']):
id_number = json2Dict['idNumber']
person.id_number = id_number
if 'loginName' in json2Dict:
if isValid(json2Dict['loginName']):
login_name = json2Dict['loginName']
personCount = Person.objects.filter(
login_name=login_name).count()
if personCount > 0 and login_name != person.login_name:
personUpdate = setStatus(
300, "the 'loginName' is exists ! ")
return HttpResponse(json.dumps(personUpdate),
content_type='application/json')
person.login_name = login_name
if 'password' in json2Dict:
if isValid(json2Dict['password']):
password = json2Dict['password']
person.password = base64.b64encode(password)
if 'warehouseID' in json2Dict:
if isValid(json2Dict['warehouseID']):
warehouse_id = int(json2Dict['warehouseID'])
person.warehouse_id = warehouse_id
if 'place' in json2Dict:
if isValid(json2Dict['place']):
place = json2Dict['place']
person.place = place
if 'resIDs' in json2Dict:
user_id = person.id
permissions = Permission.objects.filter(user_id=user_id)
for permission in permissions:
permission.delete()
create_time = operator_time
resIDs = json2Dict['resIDs']
for resID in resIDs:
menu_id = resID
permission = Permission(None, user_id, menu_id,
person.identifier, create_time)
permission.save()
person.save()
personJSON = getPersonObj(person)
personUpdate = setStatus(200, personJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
personUpdate = setStatus(500, traceback.format_exc())
def stockCheckInsert(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
take_stock_date = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
identifier = 'TSO-' + take_stock_date[0:10] + '-'
if 'warehouseID' in json2Dict:
if isValid(json2Dict['warehouseID']):
warehouse_id = int(json2Dict['warehouseID'])
else:
warehouse_id = 0
else:
warehouse_id = 0
if 'personID' in json2Dict:
if isValid(json2Dict['personID']):
person_id = int(json2Dict['personID'])
else:
person_id = 0
else:
person_id = 0
if 'originator' in json2Dict:
if isValid(json2Dict['originator']):
originator = json2Dict['originator']
else:
originator = None
else:
warehouse_id = None
if 'financeReviewer' in json2Dict:
if isValid(json2Dict['financeReviewer']):
finance_reviewer = json2Dict['financeReviewer']
else:
finance_reviewer = None
else:
finance_reviewer = None
if 'managerReviewer' in json2Dict:
if isValid(json2Dict['managerReviewer']):
manager_reviewer = json2Dict['managerReviewer']
else:
manager_reviewer = None
else:
manager_reviewer = None
if 'summary' in json2Dict:
if isValid(json2Dict['summary']):
summary = json2Dict['summary']
else:
summary = None
else:
summary = None
if 'state' in json2Dict:
if isValid(json2Dict['state']):
state = int(json2Dict['state'])
else:
state = 0
else:
state = 0
if 'printNum' in json2Dict:
if isValid(json2Dict['printNum']):
print_num = int(json2Dict['printNum'])
else:
print_num = 0
else:
print_num = 0
is_delete = 0
stock = TakeStockOrder(None, take_stock_date, identifier,
warehouse_id, person_id, originator,
finance_reviewer, manager_reviewer, summary,
state, print_num, is_delete)
stock.save()
stock.identifier = identifier + str(stock.id)
stock.save()
if 'stockCommodities' in json2Dict:
stockCommodities = json2Dict['stockCommodities']
for stockCommodity in stockCommodities:
take_stock_order_id = stock.id
if 'commoditySpecificationID' in stockCommodity:
if isValid(stockCommodity['commoditySpecificationID']):
commodity_specification_id = int(
stockCommodity['commoditySpecificationID'])
else:
commodity_specification_id = 0
else:
commodity_specification_id = 0
if 'inventoryNum' in stockCommodity:
if isValid(stockCommodity['inventoryNum']):
inventory_num = int(stockCommodity['inventoryNum'])
else:
inventory_num = 0
else:
inventory_num = 0
if 'realNum' in stockCommodity:
if isValid(stockCommodity['realNum']):
real_num = int(stockCommodity['realNum'])
else:
real_num = 0
else:
real_num = 0
if 'profitOrLossNum' in stockCommodity:
if isValid(stockCommodity['profitOrLossNum']):
profit_or_loss_num = int(
stockCommodity['profitOrLossNum'])
else:
profit_or_loss_num = 0
else:
profit_or_loss_num = 0
if 'unitPrice' in stockCommodity:
if isValid(stockCommodity['unitPrice']):
unit_price = atof(stockCommodity['unitPrice'])
else:
unit_price = 0
else:
unit_price = 0
if 'money' in stockCommodity:
if isValid(stockCommodity['money']):
money = atof(stockCommodity['money'])
else:
money = 0
else:
money = 0
stockCommoditiObj = TakeStockOrderCommodity(
None, take_stock_order_id, commodity_specification_id,
inventory_num, real_num, profit_or_loss_num,
unit_price, money)
stockCommoditiObj.save()
stockJSON = getStock(stock)
stockCheckInsert = setStatus(200, stockJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
stockCheckInsert = setStatus(500, traceback.format_exc())
def salesPlanUpdate(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifier = json2Dict['identifier']
salesPlanOrders = SalesPlanOrder.objects.filter(
identifier=identifier)
if len(salesPlanOrders) > 0:
salesPlanOrder = salesPlanOrders[0]
else:
salesPlanUpdate = setStatus(300, {})
return HttpResponse(json.dumps(salesPlanUpdate),
content_type='application/json')
if 'endTime' in json2Dict:
if isValid(json2Dict['endTime']):
end_time_str = json2Dict['endTime']
end_time = time.strptime(end_time_str, '%Y-%m-%d')
end_time = datetime.datetime(*end_time[:3]).date()
salesPlanOrder.end_time = end_time
if 'currency' in json2Dict:
if isValid(json2Dict['currency']):
currency = int(json2Dict['currency'])
salesPlanOrder.currency = currency
if 'branch' in json2Dict:
if isValid(json2Dict['branch']):
branch = json2Dict['branch']
salesPlanOrder.branch = branch
if 'originator' in json2Dict:
if isValid(json2Dict['originator']):
originator = json2Dict['originator']
salesPlanOrder.originator = originator
if 'summary' in json2Dict:
if isValid(json2Dict['summary']):
summary = json2Dict['summary']
salesPlanOrder.summary = summary
if 'supctoID' in json2Dict:
if isValid(json2Dict['supctoID']):
supcto_id = int(json2Dict['supctoID'])
salesPlanOrder.supcto_id = supcto_id
if 'personID' in json2Dict:
if isValid(json2Dict['personID']):
person_id = int(json2Dict['personID'])
salesPlanOrder.person_id = person_id
if 'state' in json2Dict:
if isValid(json2Dict['state']):
state = int(json2Dict['state'])
salesPlanOrder.state = state
if 'isAppOrder' in json2Dict:
if isValid(json2Dict['isAppOrder']):
is_app_order = int(json2Dict['isAppOrder'])
salesPlanOrder.is_app_order = is_app_order
if 'appConsigneeName' in json2Dict:
if isValid(json2Dict['appConsigneeName']):
app_consignee_name = json2Dict['appConsigneeName']
salesPlanOrder.app_consignee_name = app_consignee_name
if 'appConsigneePhone' in json2Dict:
if isValid(json2Dict['appConsigneePhone']):
app_consignee_phone = json2Dict['appConsigneePhone']
salesPlanOrder.app_consignee_phone = app_consignee_phone
if 'appConsigneeAddress' in json2Dict:
if isValid(json2Dict['appConsigneeAddress']):
app_consignee_address = json2Dict['appConsigneeAddress']
salesPlanOrder.app_consignee_address = app_consignee_address
if 'missOrderID' in json2Dict:
if isValid(json2Dict['missOrderID']):
miss_order_id = int(json2Dict['missOrderID'])
salesPlanOrder.miss_order_id = miss_order_id
if 'activityID' in json2Dict:
if isValid(json2Dict['activityID']):
activity_id = int(json2Dict['activityID'])
salesPlanOrder.activity_id = activity_id
if 'fax' in json2Dict:
if isValid(json2Dict['fax']):
fax = json2Dict['fax']
salesPlanOrder.fax = fax
if 'shippingModeID' in json2Dict:
if isValid(json2Dict['shippingModeID']):
shipping_mode_id = int(json2Dict['shippingModeID'])
salesPlanOrder.shipping_mode_id = shipping_mode_id
if 'phone' in json2Dict:
if isValid(json2Dict['phone']):
phone = json2Dict['phone']
salesPlanOrder.phone = phone
if 'deliverGoodsPlace' in json2Dict:
if isValid(json2Dict['deliverGoodsPlace']):
deliver_goods_place = json2Dict['deliverGoodsPlace']
salesPlanOrder.deliver_goods_place = deliver_goods_place
if 'orderer' in json2Dict:
if isValid(json2Dict['orderer']):
orderer = json2Dict['orderer']
salesPlanOrder.orderer = orderer
salesPlanOrder.save()
if 'salesPlanOrderCommodities' in json2Dict:
salesPlanOrderCommodities = json2Dict[
'salesPlanOrderCommodities']
for salesPlanOrderCommodity in salesPlanOrderCommodities:
if 'slesPlanOrderCommodityID' in salesPlanOrderCommodity:
slesPlanOrderCommodityID = salesPlanOrderCommodity[
'slesPlanOrderCommodityID']
spocs = SalesPlanOrderCommodity.objects.filter(
id=slesPlanOrderCommodityID)
if len(spocs) > 0:
spoc = spocs[0]
else:
salesPlanUpdate = setStatus(300, {})
return HttpResponse(
json.dumps(salesPlanUpdate),
content_type='application/json')
else:
continue
if 'commoditySpecificationID' in salesPlanOrderCommodity:
if isValid(salesPlanOrderCommodity[
'commoditySpecificationID']):
commodity_specification_id = int(
salesPlanOrderCommodity[
'commoditySpecificationID'])
spoc.commodity_specification_id = commodity_specification_id
else:
commodity_specification_id = 0
if 'number' in salesPlanOrderCommodity:
if isValid(salesPlanOrderCommodity['number']):
number = int(salesPlanOrderCommodity['number'])
spoc.number = number
else:
number = 0
if 'unitPrice' in salesPlanOrderCommodity:
if isValid(salesPlanOrderCommodity['unitPrice']):
unit_price = int(
salesPlanOrderCommodity['unitPrice'])
spoc.unit_price = unit_price
else:
unit_price = 0
if 'money' in salesPlanOrderCommodity:
if isValid(salesPlanOrderCommodity['money']):
money = atof(salesPlanOrderCommodity['money'])
spoc.money = money
else:
money = 0
if 'remark' in salesPlanOrderCommodity:
if isValid(salesPlanOrderCommodity['remark']):
remark = salesPlanOrderCommodity['remark']
spoc.remark = remark
else:
remark = None
spoc.save()
salesPlanOrderJSON = getSalesPlanOrder(salesPlanOrder)
salesPlanUpdate = setStatus(200, salesPlanOrderJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
salesPlanUpdate = setStatus(500, traceback.format_exc())
def stockCheckUpdate(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifier = json2Dict['identifier']
stocks = TakeStockOrder.objects.filter(identifier=identifier)
if len(stocks) > 0:
stock = stocks[0]
else:
stockUpdate = setStatus(300, {})
return HttpResponse(json.dumps(stockUpdate),
content_type='application/json')
if 'warehouseID' in json2Dict:
if isValid(json2Dict['warehouseID']):
warehouse_id = int(json2Dict['warehouseID'])
stock.warehouse_id = warehouse_id
if 'personID' in json2Dict:
if isValid(json2Dict['personID']):
person_id = int(json2Dict['personID'])
stock.person_id = person_id
if 'originator' in json2Dict:
if isValid(json2Dict['originator']):
originator = json2Dict['originator']
stock.originator = originator
if 'financeReviewer' in json2Dict:
if isValid(json2Dict['financeReviewer']):
finance_reviewer = json2Dict['financeReviewer']
stock.finance_reviewer = finance_reviewer
if 'managerReviewer' in json2Dict:
if isValid(json2Dict['managerReviewer']):
manager_reviewer = json2Dict['managerReviewer']
stock.manager_reviewer = manager_reviewer
if 'summary' in json2Dict:
if isValid(json2Dict['summary']):
summary = json2Dict['summary']
stock.summary = summary
if 'state' in json2Dict:
if isValid(json2Dict['state']):
state = int(json2Dict['state'])
stock.state = state
if 'printNum' in json2Dict:
if isValid(json2Dict['printNum']):
print_num = int(json2Dict['printNum'])
stock.print_num = print_num
stock.save()
if 'stockCommodities' in json2Dict:
stockCommodities = json2Dict['stockCommodities']
for stockCommodity in stockCommodities:
if 'stockCommoditiyID' in stockCommodity:
stockCommoditiyID = stockCommodity['stockCommoditiyID']
stockCommodityObjs = TakeStockOrderCommodity.objects.filter(
id=stockCommoditiyID)
if len(stockCommodityObjs) > 0:
stockCommodityObj = stockCommodityObjs[0]
else:
stockUpdate = setStatus(300, {})
return HttpResponse(
json.dumps(stockUpdate),
content_type='application/json')
else:
continue
if 'commoditySpecificationID' in stockCommodity:
if isValid(stockCommodity['commoditySpecificationID']):
commodity_specification_id = int(
stockCommodity['commoditySpecificationID'])
stockCommodityObj.commodity_specification_id = commodity_specification_id
if 'inventoryNum' in stockCommodity:
if isValid(stockCommodity['inventoryNum']):
inventory_num = int(stockCommodity['inventoryNum'])
stockCommodityObj.inventory_num = inventory_num
if 'realNum' in stockCommodity:
if isValid(stockCommodity['realNum']):
real_num = int(stockCommodity['realNum'])
stockCommodityObj.real_num = real_num
if 'profitOrLossNum' in stockCommodity:
if isValid(stockCommodity['profitOrLossNum']):
profit_or_loss_num = int(
stockCommodity['profitOrLossNum'])
stockCommodityObj.profit_or_loss_num = profit_or_loss_num
if 'advanceMoney' in stockCommodity:
if isValid(stockCommodity['advanceMoney']):
unit_price = atof(stockCommodity['advanceMoney'])
stockCommodityObj.unit_price = unit_price
if 'money' in stockCommodity:
if isValid(stockCommodity['money']):
money = atof(stockCommodity['money'])
stockCommodityObj.money = money
stockCommodityObj.save()
stockJSON = getStock(stock)
stockCheckUpdate = setStatus(200, stockJSON)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
stockCheckUpdate = setStatus(500, traceback.format_exc())
