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 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 packageOrTeardownDelete(request): try: if isTokenExpired(request): json2Dict = json.loads(request.body) identifiers = int(json2Dict['identifiers']) errorIDs = [] for identifier in identifiers: identifier = int(identifier) packages = PackageOrTeardownOrder.objects.filter(id=identifier) if len(packages) > 0: package = packages[0] package.is_delete = 1 package.save() packageOrTeardownDelete = setStatus(200, {}) else: errorIDs.append(identifier) if len(errorIDs) > 0: packageOrTeardownDelete = setStatus(300, errorIDs) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() packageOrTeardownDelete = setStatus(500, traceback.format_exc())
def thirdPartyDelete(request): try: if isTokenExpired(request): json2Dict = json.loads(request.body) identifiers = int(json2Dict['identifiers']) errorIDs = [] for identifier in identifiers: identifier = int(identifier) supCtos = Supcto.objects.filter(id=identifier) if len(supCtos) > 0: supCto = supCtos[0] supctoCommodities = SupctoCommodity.objects.filter( supcto_id=supCto.id) for supctoCommodity in supctoCommodities: supctoCommodity.delete() supCto.delete() thirdPartyDelete = setStatus(200, {}) else: errorIDs.append(identifier) if len(errorIDs) > 0: thirdPartyDelete = setStatus(300, errorIDs) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() thirdPartyDelete = setStatus(500, traceback.format_exc())
def secondClassificationDelete(request): try: if isTokenExpired(request): logRecord = basic_log.Logger('record') secondClassificationDelete = {} json2Dict = json.loads(request.body) identifiers = json2Dict['identifiers'] errorIDs = [] for identifier in identifiers: identifier = int(identifier) classifications = Classification.objects.filter(id=identifier,parent_id__gt=0) if len(classifications) > 0: classification = classifications[0] classification.is_delete = 1 classification.save() secondClassificationDelete = setStatus(200,{}) else: errorIDs.append(identifier) if len(errorIDs) > 0: secondClassificationDelete = setStatus(300, errorIDs) else: return notTokenExpired() except Exception,e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() secondClassificationDelete = setStatus(500,traceback.format_exc())
def 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 firstClassificationDelete(request): try: if isTokenExpired(request): logRecord = basic_log.Logger('record') firstClassificationDelete = {} identifier = request.GET['identifier'] classifications = Classification.objects.filter( identifier=identifier, parent_id=0) if len(classifications) > 0: classification = classifications[0] classification.is_delete = 1 children = Classification.objects.filter( parent_id=classification.id) for child in children: child.is_delete = 1 child.save() classification.save() firstClassificationDelete = setStatus(200, {}) else: firstClassificationDelete = setStatus(300, {}) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() firstClassificationDelete = setStatus(500, traceback.format_exc())
def basicInsert(request): try: if isTokenExpired(request): json2Dict = json.loads(request.body) tableName = json2Dict['tableName'] operator_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) name = json2Dict['name'] operator_identifier = json2Dict['operatorIdentifier'] is_delete = 0 if tableName == 'shippingMode': identifier = 'SHIP-' + operator_time[0:10] + '-' shippingMode = ShippingMode(None, name, operator_identifier, operator_time, is_delete, identifier) shippingMode.save() shippingMode.identifier = identifier + str(shippingMode.id) shippingMode.save() basicJSON = getBasicJSON(shippingMode, tableName) elif tableName == 'settlementType': identifier = 'SET_TYP-' + operator_time[0:10] + '-' settlementType = SettlementType(None, name, identifier, operator_identifier, operator_time, is_delete) settlementType.save() settlementType.identifier = identifier + str(settlementType.id) settlementType.save() basicJSON = getBasicJSON(settlementType, tableName) elif tableName == 'department': identifier = 'DEP-' + operator_time[0:10] + '-' department = Department(None, name, operator_identifier, operator_time, identifier, is_delete) department.save() department.identifier = identifier + str(department.id) department.save() basicJSON = getBasicJSON(department, tableName) elif tableName == 'warehouse': identifier = 'WAH-' + operator_time[0:10] + '-' position = json2Dict['position'] warehouse = Warehouse(None, name, position, operator_identifier, operator_time, identifier, is_delete) warehouse.save() warehouse.identifier = identifier + str(warehouse.id) warehouse.save() basicJSON = getBasicJSON(warehouse, tableName) else: basicInsert = setStatus(300, {}) return HttpResponse(json.dumps(basicInsert), content_type='application/json') basicInsert = setStatus(200, basicJSON) return HttpResponse(json.dumps(basicInsert), content_type='application/json') else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() basicInsert = setStatus(500, traceback.format_exc())
def personDelete(request): try: if isTokenExpired(request): json2Dict = json.loads(request.body) identifiers = int(json2Dict['identifiers']) errorIDs = [] for identifier in identifiers: identifier = int(identifier) persons = Person.objects.filter(id=identifier) if len(persons) > 0: person = persons[0] person.is_delete = 1 person.quit_time = time.strftime( '%Y-%m-%d', time.localtime(time.time())) person.save() personDelete = setStatus(200, {}) else: errorIDs.append(identifier) if len(errorIDs) > 0: personDelete = setStatus(300, errorIDs) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() personDelete = setStatus(500, traceback.format_exc())
def departmentUpdate(request): try: if isTokenExpired(request): json2Dict = json.loads(request.body) identifier = json2Dict['identifier'] departments = Department.objects.filter(identifier=identifier) if len(departments) > 0: department = departments[0] else: departmentUpdate = setStatus(300, {}) return HttpResponse(json.dumps(departmentUpdate), content_type='application/json') if 'name' in json2Dict: if isValid(json2Dict['name']): name = json2Dict['name'] department.name = name if 'operatorIdentifier' in json2Dict: if isValid(json2Dict['operatorIdentifier']): operator_identifier = json2Dict['operatorIdentifier'] department.operator_identifier = operator_identifier department.save() departmentJSON = getDepartment(department) departmentUpdate = setStatus(200, departmentJSON) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() departmentUpdate = setStatus(500, traceback.format_exc())
def departmentDelete(request): try: if isTokenExpired(request): json2Dict = json.loads(request.body) identifiers = int(json2Dict['identifiers']) errorIDs = [] for identifier in identifiers: identifier = int(identifier) departments = Department.objects.filter(id=identifier) if len(departments) > 0: department = departments[0] department.is_delete = 1 department.save() departmentDelete = setStatus(200, {}) else: errorIDs.append(identifier) if len(errorIDs) > 0: departmentDelete = setStatus(300, errorIDs) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() departmentDelete = setStatus(500, traceback.format_exc())
def salesPlanDelete(request): try: if isTokenExpired(request): json2Dict = json.loads(request.body) identifiers = int(json2Dict['identifiers']) errorIDs = [] for identifier in identifiers: identifier = int(identifier) salesPlanOrders = SalesPlanOrder.objects.filter(id=identifier) if len(salesPlanOrders) > 0: salesPlanOrder = salesPlanOrders[0] salesPlanOrderCommodities = SalesPlanOrderCommodity.objects.filter( sales_plan_order_id=salesPlanOrder.id) for salesPlanOrderCommodity in salesPlanOrderCommodities: salesPlanOrderCommodity.delete() salesPlanOrder.delete() salesPlanDelete = setStatus(200, {}) else: errorIDs.append(identifier) if len(errorIDs) > 0: salesPlanDelete = setStatus(300, errorIDs) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() salesPlanDelete = setStatus(500, traceback.format_exc())
def stockCheckDelete(request): try: if isTokenExpired(request): json2Dict = json.loads(request.body) identifiers = int(json2Dict['identifiers']) errorIDs = [] for identifier in identifiers: identifier = int(identifier) stocks = TakeStockOrder.objects.filter(id=identifier) if len(stocks) > 0: stock = stocks[0] stock.is_delete = 1 stock.save() stockCheckDelete = setStatus(200, {}) else: errorIDs.append(identifier) if len(errorIDs) > 0: stockCheckDelete = setStatus(300, errorIDs) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() stockCheckDelete = setStatus(500, traceback.format_exc())
def allotDelete(request): try: if isTokenExpired(request): json2Dict = json.loads(request.body) identifiers = int(json2Dict['identifiers']) errorIDs = [] for identifier in identifiers: identifier = int(identifier) allots = AllotOrder.objects.filter(id=identifier) if len(allots) > 0: allot = allots[0] allotCommodities = AllotOrderCommodity.objects.filter(allot_order_id=allot.id) for allotCommodity in allotCommodities: allotCommodity.delete() allot.delete() allotDelete = setStatus(200,{}) else: errorIDs.append(identifier) if len(errorIDs) > 0: allotDelete = setStatus(300,errorIDs) else: return notTokenExpired() except Exception,e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() allotDelete = setStatus(500,traceback.format_exc())
def 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 thirdPartySelect(request): try: if isTokenExpired(request): thirdPartySelect = {} condition = {} selectType = {} if len(request.GET) > 0: if 'identifier' in request.GET and isValid( request.GET['identifier']): condition['identifier'] = request.GET['identifier'] if 'name' in request.GET and isValid(request.GET['name']): name = request.GET['name'] condition['name'] = name if 'fromType' in request.GET and isValid( request.GET['fromType']): from_type = request.GET['fromType'] condition['from_type'] = from_type if 'queryTime' in request.GET and isValid( request.GET['queryTime']): queryTime = request.GET['queryTime'] timeFrom = queryTime.split('~')[0].strip() timeTo = queryTime.split('~')[1].strip() selectType['timeFrom'] = timeFrom + ' 00:00:00' selectType['timeTo'] = timeTo + ' 23:59:59' if 'state' in request.GET and isValid(request.GET['state']): state = request.GET['state'] condition['state'] = state if 'province' in request.GET and isValid( request.GET['province']): province = request.GET['province'] condition['province'] = province if 'city' in request.GET and isValid(request.GET['city']): city = request.GET['city'] condition['city'] = city if 'area' in request.GET and isValid(request.GET['area']): area = request.GET['area'] condition['area'] = area if 'classificationID' in request.GET and isValid( request.GET['classificationID']): classificationID = int(request.GET['classificationID']) condition['classification_id'] = classificationID thirdPartySelect = paging(request, ONE_PAGE_OF_DATA, condition, selectType) else: thirdPartySelect = paging(request, ONE_PAGE_OF_DATA, None, None) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() thirdPartySelect = setStatus(500, traceback.format_exc())
def orderPlanToNormal(request): try: if isTokenExpired(request): identifier = request.GET['identifier'] #这个api是将计划销售单,转换成正式销售单,⽣成新的单⼦ else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() orderPlanToNormal = setStatus(500, traceback.format_exc())
def secondClassificationUpdate(request): try: if isTokenExpired(request): logRecord = basic_log.Logger('record') secondClassificationUpdate = {} json2Dict = json.loads(request.body) identifier = json2Dict['identifier'] classifications = Classification.objects.filter( identifier=identifier) if len(classifications) > 0: classification = classifications[0] isAdd = 0 if 'parentID' in json2Dict: if isValid(json2Dict['parentID']): parent_id = json2Dict['parentID'] classification.parent_id = parent_id isAdd += 1 if 'name' in json2Dict: if isValid(json2Dict['name']): name = json2Dict['name'] classification.name = name isAdd += 1 if 'keyWord' in json2Dict: if isValid(json2Dict['keyWord']): key_word = json2Dict['keyWord'] classification.key_word = key_word isAdd += 1 if 'operator' in json2Dict: if isValid(json2Dict['operator']): operator_identifier = json2Dict['operator'] classification.operator_identifier = operator_identifier isAdd += 1 if 'type' in json2Dict: if isValid(json2Dict['type']): type = int(json2Dict['type']) classification.type = type isAdd += 1 if isAdd > 0: operator_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) classification.operator_time = operator_time classification.save() rData = getClassification(classification) secondClassificationUpdate = setStatus(200, rData) else: secondClassificationUpdate = setStatus(300, {}) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() secondClassificationUpdate = setStatus(500, traceback.format_exc())
def secondClassificationSelect(request): try: if isTokenExpired(request): logRecord = basic_log.Logger('record') secondClassificationSelect = {} if len(request.GET) > 0: condition = {} selectType = {} if 'identifier' in request.GET and isValid(request.GET['identifier']): condition['identifier'] = request.GET['identifier'] if 'firstClassIdentifer' in request.GET and isValid(request.GET['firstClassIdentifer']): condition['parent_id'] = int(request.GET['firstClassIdentifer']) ''' parents = Classification.objects.filter(identifier=firstClassIdentifer) parents = Classification.objects.filter(parent_id=firstClassIdentifer) if len(parents) > 0: parent = parents[0] condition['parent_id'] = parent.id else: secondClassificationSelect = setStatus(300, {}) return HttpResponse(json.dumps(secondClassificationSelect), content_type='application/json') ''' if 'type' in request.GET and isValid(request.GET['type']): condition['type'] = int(request.GET['type']) if 'keyWord' in request.GET and isValid(request.GET['keyWord']): condition['key_word'] = request.GET['keyWord'] if 'name' in request.GET and isValid(request.GET['name']): condition['name'] = request.GET['name'] if 'operator' in request.GET and isValid(request.GET['operator']): selectType['operator'] = request.GET['operator'] if 'queryTime' in request.GET and isValid(request.GET['queryTime']): queryTime = request.GET['queryTime'] timeFrom = queryTime.split('~')[0].strip() timeTo = queryTime.split('~')[1].strip() selectType['timeFrom'] = timeFrom + ' 00:00:00' selectType['timeTo'] = timeTo + ' 23:59:59' condition['is_delete'] = 0 if 'noPaging' in request.GET and request.GET['noPaging'] == "true": secondClassificationSelect = conditionSelect(condition, True, selectType) else: secondClassificationSelect = paging(request, ONE_PAGE_OF_DATA, condition,False,selectType) else: secondClassificationSelect = paging(request, ONE_PAGE_OF_DATA, None,False, None) else: return notTokenExpired() except Exception,e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() secondClassificationSelect = setStatus(500,traceback.format_exc())
def singleBillSelect(request): try: if isTokenExpired(request): billsCode = request.GET['billsCode'] bills = Bills.objects.filter(bills_code=billsCode) if len(bills) > 0: bill = bills[0] singleBillSelect = getBills(bill) else: singleBillSelect = setStatus(300, {}) return HttpResponse(json.dumps(singleBillSelect), content_type='application/json') else: return notTokenExpired() except Exception,e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() singleBillSelect = setStatus(500,traceback.format_exc())
def singleWriteoffSelect(request): try: if isTokenExpired(request): writeoff_code = request.GET['writeoffCode'] writeoffs = Writeoff.objects.filter(writeoff_code=writeoff_code) if len(writeoffs) > 0: writeoff = writeoffs[0] singleWriteoffSelect = getWriteoff(writeoff) else: singleWriteoffSelect = setStatus(300, {}) return HttpResponse(json.dumps(singleWriteoffSelect), content_type='application/json') else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() singleWriteoffSelect = setStatus(500, traceback.format_exc())
def 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 salesPlanSelect(request): try: if isTokenExpired(request): if len(request.GET) > 0: condition = {} selectType = {} if 'identifier' in request.GET and isValid( request.GET['identifier']): condition['identifier'] = request.GET['identifier'] if 'commodityName' in request.GET and isValid( request.GET['commodityName']): commodityName = request.GET['commodityName'] else: commodityName = None if 'supctoID' in request.GET and isValid( request.GET['supctoID']): condition['supcto_id'] = int(request.GET['supctoID']) if 'personID' in request.GET and isValid( request.GET['personID']): condition['person_id'] = request.GET['personID'] if 'state' in request.GET and isValid(request.GET['state']): condition['state'] = int(request.GET['state']) if 'queryTime' in request.GET and isValid( request.GET['queryTime']): queryTime = request.GET['queryTime'] timeFrom = queryTime.split('~')[0].strip() timeTo = queryTime.split('~')[1].strip() selectType['timeFrom'] = timeFrom + ' 00:00:00' selectType['timeTo'] = timeTo + ' 23:59:59' salesPlanSelect = paging(request, ONE_PAGE_OF_DATA, condition, selectType, commodityName) else: salesPlanSelect = paging(request, ONE_PAGE_OF_DATA, None, None, None) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() salesPlanSelect = setStatus(500, traceback.format_exc())
def 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 thirdPartySingleSelect(request): try: if isTokenExpired(request): thirdPartySingleSelect = {} identifier = request.GET['identifier'] supCtos = Supcto.objects.filter(identifier=identifier) if len(supCtos) > 0: supCto = supCtos[0] supCtoJSON = getSupCto(supCto) thirdPartySingleSelect = setStatus(200, supCtoJSON) else: thirdPartySingleSelect = setStatus(300, {}) return HttpResponse(json.dumps(thirdPartySingleSelect), content_type='application/json') else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() thirdPartySingleSelect = setStatus(500, traceback.format_exc())
def packageOrTeardownSelect(request): try: if isTokenExpired(request): if len(request.GET) > 0: condition = {} selectType = {} if 'identifier' in request.GET and isValid( request.GET['identifier']): condition['identifier'] = request.GET['identifier'] if 'warehouseID' in request.GET and isValid( request.GET['warehouseID']): condition['warehouse_id'] = int(request.GET['warehouseID']) if 'personID' in request.GET and isValid( request.GET['personID']): condition['person_id'] = int(request.GET['personID']) if 'orderType' in request.GET and isValid( request.GET['orderType']): condition['order_type'] = int(request.GET['orderType']) if 'state' in request.GET and isValid(request.GET['state']): condition['state'] = int(request.GET['state']) condition['is_delete'] = 0 if 'queryTime' in request.GET and isValid( request.GET['queryTime']): queryTime = request.GET['queryTime'] timeFrom = queryTime.split('~')[0].strip() timeTo = queryTime.split('~')[1].strip() selectType['timeFrom'] = timeFrom + ' 00:00:00' selectType['timeTo'] = timeTo + ' 23:59:59' packageOrTeardownSelect = paging(request, ONE_PAGE_OF_DATA, condition, selectType) else: packageOrTeardownSelect = paging(request, ONE_PAGE_OF_DATA, None, None) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() packageOrTeardownSelect = setStatus(500, traceback.format_exc())
def goodsUpdate(request): try: if isTokenExpired(request): json2Dict = json.loads(request.body) goodsID = json2Dict['goodsID'] goodses = Goods.objects.filter(id=goodsID) if len(goodses) > 0: goods = goodses[0] else: goodsUpdate = setStatus(300, {}) return HttpResponse(json.dumps(goodsUpdate), content_type='application/json') if 'stock' in json2Dict: if isValid(json2Dict['stock']): stock = int(json2Dict['stock']) goods.stock = stock if 'purchase' in json2Dict: if isValid(json2Dict['purchase']): purchase = atof(json2Dict['purchase']) goods.purchase = purchase if 'brand' in json2Dict: if isValid(json2Dict['brand']): brand = json2Dict['brand'] goods.brand = brand if 'state' in json2Dict: if isValid(json2Dict['state']): state = int(json2Dict['state']) goods.state = state goods.save() goodsJSON = getGoods(goods) goodsUpdate = setStatus(200, goodsJSON) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() goodsUpdate = setStatus(500, traceback.format_exc())
def 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 updatePwdByID(request): try: if isTokenExpired(request): updatePwdByID = {} identifier = request.GET['identifier'] person = Person.objects.filter(identifier=identifier) password = base64.b64encode('1') logRecord.log("person:" + str(len(person))) logRecord.log("person:" + str(person)) if len(person) > 0: logRecord.log("person: hehehe " + str(person[0])) person[0].password = password person[0].save() updatePwdByID = setStatus(200, {}) return HttpResponse(json.dumps(updatePwdByID), content_type='application/json') else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() updatePwdByID = setStatus(500, traceback.format_exc())
def goodsDelete(request): try: if isTokenExpired(request): json2Dict = json.loads(request.body) identifiers = int(json2Dict['identifiers']) errorIDs = [] for identifier in identifiers: goodsID = int(identifier) goodses = Goods.objects.filter(id=goodsID) if len(goodses) > 0: goods = goodses[0] goods.delete() goodsDelete = setStatus(200, {}) else: errorIDs.append(identifier) if len(errorIDs) > 0: goodsDelete = setStatus(300, errorIDs) else: return notTokenExpired() except Exception, e: logErr = basic_log.Logger('error') logErr.log(traceback.format_exc()) transaction.rollback() goodsDelete = setStatus(500, traceback.format_exc())