def firstClassificationDelete(request):
try:
if isTokenExpired(request):
logRecord = basic_log.Logger('record')
firstClassificationDelete = {}
identifier = request.GET['identifier']
classifications = Classification.objects.filter(
identifier=identifier, parent_id=0)
if len(classifications) > 0:
classification = classifications[0]
classification.is_delete = 1
children = Classification.objects.filter(
parent_id=classification.id)
for child in children:
child.is_delete = 1
child.save()
classification.save()
firstClassificationDelete = setStatus(200, {})
else:
firstClassificationDelete = setStatus(300, {})
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
firstClassificationDelete = setStatus(500, traceback.format_exc())
def secondClassificationDelete(request):
try:
if isTokenExpired(request):
logRecord = basic_log.Logger('record')
secondClassificationDelete = {}
json2Dict = json.loads(request.body)
identifiers = json2Dict['identifiers']
errorIDs = []
for identifier in identifiers:
identifier = int(identifier)
classifications = Classification.objects.filter(id=identifier,parent_id__gt=0)
if len(classifications) > 0:
classification = classifications[0]
classification.is_delete = 1
classification.save()
secondClassificationDelete = setStatus(200,{})
else:
errorIDs.append(identifier)
if len(errorIDs) > 0:
secondClassificationDelete = setStatus(300, errorIDs)
else:
return notTokenExpired()
except Exception,e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
secondClassificationDelete = 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 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 thirdPartyDelete(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifiers = int(json2Dict['identifiers'])
errorIDs = []
for identifier in identifiers:
identifier = int(identifier)
supCtos = Supcto.objects.filter(id=identifier)
if len(supCtos) > 0:
supCto = supCtos[0]
supctoCommodities = SupctoCommodity.objects.filter(
supcto_id=supCto.id)
for supctoCommodity in supctoCommodities:
supctoCommodity.delete()
supCto.delete()
thirdPartyDelete = setStatus(200, {})
else:
errorIDs.append(identifier)
if len(errorIDs) > 0:
thirdPartyDelete = setStatus(300, errorIDs)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
thirdPartyDelete = 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 basicInsert(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()))
name = json2Dict['name']
operator_identifier = json2Dict['operatorIdentifier']
is_delete = 0
if tableName == 'shippingMode':
identifier = 'SHIP-' + operator_time[0:10] + '-'
shippingMode = ShippingMode(None, name, operator_identifier,
operator_time, is_delete,
identifier)
shippingMode.save()
shippingMode.identifier = identifier + str(shippingMode.id)
shippingMode.save()
basicJSON = getBasicJSON(shippingMode, tableName)
elif tableName == 'settlementType':
identifier = 'SET_TYP-' + operator_time[0:10] + '-'
settlementType = SettlementType(None, name, identifier,
operator_identifier,
operator_time, is_delete)
settlementType.save()
settlementType.identifier = identifier + str(settlementType.id)
settlementType.save()
basicJSON = getBasicJSON(settlementType, tableName)
elif tableName == 'department':
identifier = 'DEP-' + operator_time[0:10] + '-'
department = Department(None, name, operator_identifier,
operator_time, identifier, is_delete)
department.save()
department.identifier = identifier + str(department.id)
department.save()
basicJSON = getBasicJSON(department, tableName)
elif tableName == 'warehouse':
identifier = 'WAH-' + operator_time[0:10] + '-'
position = json2Dict['position']
warehouse = Warehouse(None, name, position,
operator_identifier, operator_time,
identifier, is_delete)
warehouse.save()
warehouse.identifier = identifier + str(warehouse.id)
warehouse.save()
basicJSON = getBasicJSON(warehouse, tableName)
else:
basicInsert = setStatus(300, {})
return HttpResponse(json.dumps(basicInsert),
content_type='application/json')
basicInsert = setStatus(200, basicJSON)
return HttpResponse(json.dumps(basicInsert),
content_type='application/json')
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
basicInsert = 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 departmentDelete(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifiers = int(json2Dict['identifiers'])
errorIDs = []
for identifier in identifiers:
identifier = int(identifier)
departments = Department.objects.filter(id=identifier)
if len(departments) > 0:
department = departments[0]
department.is_delete = 1
department.save()
departmentDelete = setStatus(200, {})
else:
errorIDs.append(identifier)
if len(errorIDs) > 0:
departmentDelete = setStatus(300, errorIDs)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
departmentDelete = setStatus(500, traceback.format_exc())
def stockCheckDelete(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifiers = int(json2Dict['identifiers'])
errorIDs = []
for identifier in identifiers:
identifier = int(identifier)
stocks = TakeStockOrder.objects.filter(id=identifier)
if len(stocks) > 0:
stock = stocks[0]
stock.is_delete = 1
stock.save()
stockCheckDelete = setStatus(200, {})
else:
errorIDs.append(identifier)
if len(errorIDs) > 0:
stockCheckDelete = setStatus(300, errorIDs)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
stockCheckDelete = setStatus(500, traceback.format_exc())
def allotDelete(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifiers = int(json2Dict['identifiers'])
errorIDs = []
for identifier in identifiers:
identifier = int(identifier)
allots = AllotOrder.objects.filter(id=identifier)
if len(allots) > 0:
allot = allots[0]
allotCommodities = AllotOrderCommodity.objects.filter(allot_order_id=allot.id)
for allotCommodity in allotCommodities:
allotCommodity.delete()
allot.delete()
allotDelete = setStatus(200,{})
else:
errorIDs.append(identifier)
if len(errorIDs) > 0:
allotDelete = setStatus(300,errorIDs)
else:
return notTokenExpired()
except Exception,e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
allotDelete = setStatus(500,traceback.format_exc())
def packageOrTeardownDelete(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifiers = int(json2Dict['identifiers'])
errorIDs = []
for identifier in identifiers:
identifier = int(identifier)
packages = PackageOrTeardownOrder.objects.filter(id=identifier)
if len(packages) > 0:
package = packages[0]
package.is_delete = 1
package.save()
packageOrTeardownDelete = setStatus(200, {})
else:
errorIDs.append(identifier)
if len(errorIDs) > 0:
packageOrTeardownDelete = setStatus(300, errorIDs)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
packageOrTeardownDelete = setStatus(500, traceback.format_exc())
def paging(request, ONE_PAGE_OF_DATA, condition, selectType):
logRecord = basic_log.Logger('record')
pagingSelect = {}
datasJSON = []
if 'curPage' in request.GET:
curPage = int(request.GET['curPage'])
else:
curPage = 1
if 'sizePage' in request.GET:
ONE_PAGE_OF_DATA = int(request.GET['sizePage'])
allPage = 1
if condition == None:
basicsCount = Person.objects.filter(is_delete=0).count()
else:
if 'timeFrom' in selectType and 'timeTo' in selectType:
timeFrom = selectType['timeFrom']
timeTo = selectType['timeTo']
basicsCount = Person.objects.filter(
Q(**condition) & Q(operator_time__gte=timeFrom)
& Q(operator_time__lte=timeTo)).count()
else:
basicsCount = Person.objects.filter(**condition).count()
if basicsCount != 0:
if basicsCount % ONE_PAGE_OF_DATA == 0:
allPage = basicsCount / ONE_PAGE_OF_DATA
else:
allPage = basicsCount / ONE_PAGE_OF_DATA + 1
else:
allPage = 1
if curPage > allPage or curPage < 1:
pagingSelect['code'] = 300
pagingSelect['curPage'] = curPage
pagingSelect['allPage'] = allPage
pagingSelect['data'] = 'curPage is invalid !'
return pagingSelect
startPos = (curPage - 1) * ONE_PAGE_OF_DATA
endPos = startPos + ONE_PAGE_OF_DATA
if condition == None:
basicObjs = Person.objects.filter(is_delete=0)[startPos:endPos]
else:
if 'timeFrom' in selectType and 'timeTo' in selectType:
timeFrom = selectType['timeFrom']
timeTo = selectType['timeTo']
basicObjs = Person.objects.filter(
Q(**condition) & Q(operator_time__gte=timeFrom)
& Q(operator_time__lte=timeTo))[startPos:endPos]
else:
basicObjs = Person.objects.filter(**condition)[startPos:endPos]
for basicObj in basicObjs:
basicJSON = getPersonObj(basicObj)
datasJSON.append(basicJSON)
pagingSelect['code'] = 200
dataJSON = {}
dataJSON['curPage'] = curPage
dataJSON['allPage'] = allPage
dataJSON['total'] = basicsCount
dataJSON['datas'] = datasJSON
pagingSelect['data'] = dataJSON
return pagingSelect
def personDelete(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifiers = int(json2Dict['identifiers'])
errorIDs = []
for identifier in identifiers:
identifier = int(identifier)
persons = Person.objects.filter(id=identifier)
if len(persons) > 0:
person = persons[0]
person.is_delete = 1
person.quit_time = time.strftime(
'%Y-%m-%d', time.localtime(time.time()))
person.save()
personDelete = setStatus(200, {})
else:
errorIDs.append(identifier)
if len(errorIDs) > 0:
personDelete = setStatus(300, errorIDs)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
personDelete = setStatus(500, traceback.format_exc())
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 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 salesPlanDelete(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifiers = int(json2Dict['identifiers'])
errorIDs = []
for identifier in identifiers:
identifier = int(identifier)
salesPlanOrders = SalesPlanOrder.objects.filter(id=identifier)
if len(salesPlanOrders) > 0:
salesPlanOrder = salesPlanOrders[0]
salesPlanOrderCommodities = SalesPlanOrderCommodity.objects.filter(
sales_plan_order_id=salesPlanOrder.id)
for salesPlanOrderCommodity in salesPlanOrderCommodities:
salesPlanOrderCommodity.delete()
salesPlanOrder.delete()
salesPlanDelete = setStatus(200, {})
else:
errorIDs.append(identifier)
if len(errorIDs) > 0:
salesPlanDelete = setStatus(300, errorIDs)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
salesPlanDelete = 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 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 orderPlanToNormal(request):
try:
if isTokenExpired(request):
identifier = request.GET['identifier']
#这个api是将计划销售单，转换成正式销售单，⽣成新的单⼦
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
orderPlanToNormal = setStatus(500, traceback.format_exc())
def singleBillSelect(request):
try:
if isTokenExpired(request):
billsCode = request.GET['billsCode']
bills = Bills.objects.filter(bills_code=billsCode)
if len(bills) > 0:
bill = bills[0]
singleBillSelect = getBills(bill)
else:
singleBillSelect = setStatus(300, {})
return HttpResponse(json.dumps(singleBillSelect), content_type='application/json')
else:
return notTokenExpired()
except Exception,e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
singleBillSelect = 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 singleWriteoffSelect(request):
try:
if isTokenExpired(request):
writeoff_code = request.GET['writeoffCode']
writeoffs = Writeoff.objects.filter(writeoff_code=writeoff_code)
if len(writeoffs) > 0:
writeoff = writeoffs[0]
singleWriteoffSelect = getWriteoff(writeoff)
else:
singleWriteoffSelect = setStatus(300, {})
return HttpResponse(json.dumps(singleWriteoffSelect),
content_type='application/json')
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
singleWriteoffSelect = setStatus(500, traceback.format_exc())
def salesPlanSelect(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 'commodityName' in request.GET and isValid(
request.GET['commodityName']):
commodityName = request.GET['commodityName']
else:
commodityName = None
if 'supctoID' in request.GET and isValid(
request.GET['supctoID']):
condition['supcto_id'] = int(request.GET['supctoID'])
if 'personID' in request.GET and isValid(
request.GET['personID']):
condition['person_id'] = request.GET['personID']
if 'state' in request.GET and isValid(request.GET['state']):
condition['state'] = int(request.GET['state'])
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'
salesPlanSelect = paging(request, ONE_PAGE_OF_DATA, condition,
selectType, commodityName)
else:
salesPlanSelect = paging(request, ONE_PAGE_OF_DATA, None, None,
None)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
salesPlanSelect = setStatus(500, traceback.format_exc())
def thirdPartySingleSelect(request):
try:
if isTokenExpired(request):
thirdPartySingleSelect = {}
identifier = request.GET['identifier']
supCtos = Supcto.objects.filter(identifier=identifier)
if len(supCtos) > 0:
supCto = supCtos[0]
supCtoJSON = getSupCto(supCto)
thirdPartySingleSelect = setStatus(200, supCtoJSON)
else:
thirdPartySingleSelect = setStatus(300, {})
return HttpResponse(json.dumps(thirdPartySingleSelect),
content_type='application/json')
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
thirdPartySingleSelect = setStatus(500, traceback.format_exc())
def packageOrTeardownSelect(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 'orderType' in request.GET and isValid(
request.GET['orderType']):
condition['order_type'] = int(request.GET['orderType'])
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'
packageOrTeardownSelect = paging(request, ONE_PAGE_OF_DATA,
condition, selectType)
else:
packageOrTeardownSelect = 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()
packageOrTeardownSelect = 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 updatePwdByID(request):
try:
if isTokenExpired(request):
updatePwdByID = {}
identifier = request.GET['identifier']
person = Person.objects.filter(identifier=identifier)
password = base64.b64encode('1')
logRecord.log("person:" + str(len(person)))
logRecord.log("person:" + str(person))
if len(person) > 0:
logRecord.log("person: hehehe " + str(person[0]))
person[0].password = password
person[0].save()
updatePwdByID = setStatus(200, {})
return HttpResponse(json.dumps(updatePwdByID),
content_type='application/json')
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
updatePwdByID = setStatus(500, traceback.format_exc())
def goodsDelete(request):
try:
if isTokenExpired(request):
json2Dict = json.loads(request.body)
identifiers = int(json2Dict['identifiers'])
errorIDs = []
for identifier in identifiers:
goodsID = int(identifier)
goodses = Goods.objects.filter(id=goodsID)
if len(goodses) > 0:
goods = goodses[0]
goods.delete()
goodsDelete = setStatus(200, {})
else:
errorIDs.append(identifier)
if len(errorIDs) > 0:
goodsDelete = setStatus(300, errorIDs)
else:
return notTokenExpired()
except Exception, e:
logErr = basic_log.Logger('error')
logErr.log(traceback.format_exc())
transaction.rollback()
goodsDelete = setStatus(500, traceback.format_exc())
