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())