def getallspcode(userid): """不用了""" allspace_fmunitespace = theFmWebSql.getAllUniteSpace(userid) allspace_fmuspace = theFmWebSql.getAllSpace(userid) allspace_fmuspace_F = theFmWebSql.getAllSpace(userid, "F") #无图商品 allspace = allspace_fmuspace + allspace_fmunitespace + allspace_fmuspace_F result=[] for space in allspace: SpaceId = space["Id"] Version = space["Version"] SpaceTitle = space["Title"] if SpaceId[0] != "U": SpaceData = theFmWebSql.getSpaceData(SpaceId, Version, userid) else: SpaceData = webUnite.getSpaceData(SpaceId, Version, userid) newSpaceData = [x for x in SpaceData if int(x[3])>-1] #去除淘汰商品 result = result + newSpaceData spcodes = [] for line in result: spcodes.append(line[0]) return f8(spcodes)
def getallspcode(userid): """不用了""" allspace_fmunitespace = theFmWebSql.getAllUniteSpace(userid) allspace_fmuspace = theFmWebSql.getAllSpace(userid) allspace_fmuspace_F = theFmWebSql.getAllSpace(userid, "F") #无图商品 allspace = allspace_fmuspace + allspace_fmunitespace + allspace_fmuspace_F result = [] for space in allspace: SpaceId = space["Id"] Version = space["Version"] SpaceTitle = space["Title"] if SpaceId[0] != "U": SpaceData = theFmWebSql.getSpaceData(SpaceId, Version, userid) else: SpaceData = webUnite.getSpaceData(SpaceId, Version, userid) newSpaceData = [x for x in SpaceData if int(x[3]) > -1] #去除淘汰商品 result = result + newSpaceData spcodes = [] for line in result: spcodes.append(line[0]) return f8(spcodes)
def getallspcode3(userid): "为写入yq3" allspace_fmunitespace = theFmWebSql.getAllUniteSpace(userid) allspace_fmuspace = theFmWebSql.getAllSpace(userid) allspace_fmuspace_T = allspace_fmuspace + allspace_fmunitespace #有图商品 allspace_fmuspace_F = theFmWebSql.getAllSpace(userid, "F") #无图商品 result_T = [] result_F = [] for space in allspace_fmuspace_T: SpaceId = space["Id"] Version = space["Version"] SpaceTitle = space["Title"] if SpaceId[0] != "U": SpaceData = theFmWebSql.getSpaceData(SpaceId, Version, userid) else: SpaceData = webUnite.getSpaceData(SpaceId, Version, userid) newSpaceData = [ x + [SpaceId, SpaceTitle, Version, "youtu"] for x in SpaceData ] #不去除淘汰商品 #print str(newSpaceData) result_T = result_T + newSpaceData for space in allspace_fmuspace_F: SpaceId = space["Id"] Version = space["Version"] SpaceTitle = space["Title"] if SpaceId[0] != "U": SpaceData = theFmWebSql.getSpaceData(SpaceId, Version, userid) else: SpaceData = webUnite.getSpaceData(SpaceId, Version, userid) newSpaceData = [ x + [SpaceId, SpaceTitle, Version, "wutu"] for x in SpaceData ] #不去除淘汰商品 result_F = result_F + newSpaceData spcodes_T = [x[0] for x in result_T] spcodes_F = [x for x in result_F if x[0] not in spcodes_T] spcodes = f9(spcodes_F) + f9(result_T) return spcodes
def getallspcode3(userid): "为写入yq3" allspace_fmunitespace = theFmWebSql.getAllUniteSpace(userid) allspace_fmuspace = theFmWebSql.getAllSpace(userid) allspace_fmuspace_T = allspace_fmuspace + allspace_fmunitespace #有图商品 allspace_fmuspace_F = theFmWebSql.getAllSpace(userid, "F") #无图商品 result_T=[] result_F=[] for space in allspace_fmuspace_T: SpaceId = space["Id"] Version = space["Version"] SpaceTitle = space["Title"] if SpaceId[0] != "U": SpaceData = theFmWebSql.getSpaceData(SpaceId, Version, userid) else: SpaceData = webUnite.getSpaceData(SpaceId, Version, userid) newSpaceData = [x + [SpaceId, SpaceTitle, Version, "youtu"] for x in SpaceData ] #不去除淘汰商品 #print str(newSpaceData) result_T = result_T + newSpaceData for space in allspace_fmuspace_F: SpaceId = space["Id"] Version = space["Version"] SpaceTitle = space["Title"] if SpaceId[0] != "U": SpaceData = theFmWebSql.getSpaceData(SpaceId, Version, userid) else: SpaceData = webUnite.getSpaceData(SpaceId, Version, userid) newSpaceData = [x + [SpaceId, SpaceTitle, Version, "wutu"] for x in SpaceData ] #不去除淘汰商品 result_F = result_F + newSpaceData spcodes_T = [ x[0] for x in result_T] spcodes_F = [ x for x in result_F if x[0] not in spcodes_T] spcodes = f9(spcodes_F) + f9(result_T) return spcodes
def getallspcode2(userid): "有图无图商品分开" allspace_fmunitespace = theFmWebSql.getAllUniteSpace(userid) allspace_fmuspace = theFmWebSql.getAllSpace(userid) allspace_fmuspace_T = allspace_fmuspace + allspace_fmunitespace #有图商品 allspace_fmuspace_F = theFmWebSql.getAllSpace(userid, "F") #无图商品 result_T=[] result_F=[] for space in allspace_fmuspace_T: SpaceId = space["Id"] Version = space["Version"] SpaceTitle = space["Title"] if SpaceId[0] != "U": SpaceData = theFmWebSql.getSpaceData(SpaceId, Version, userid) else: SpaceData = webUnite.getSpaceData(SpaceId, Version, userid) newSpaceData = [x for x in SpaceData if int(x[3])>-1] #去除淘汰商品 result_T = result_T + newSpaceData for space in allspace_fmuspace_F: SpaceId = space["Id"] Version = space["Version"] SpaceTitle = space["Title"] if SpaceId[0] != "U": SpaceData = theFmWebSql.getSpaceData(SpaceId, Version, userid) else: SpaceData = webUnite.getSpaceData(SpaceId, Version, userid) newSpaceData = [x for x in SpaceData if int(x[3])>-1] #去除淘汰商品 result_F = result_F + newSpaceData spcodes_T = [ x[0] for x in result_T] spcodes_F = [ x[0] for x in result_F if x[0] not in spcodes_T] return {'youtu':f8(spcodes_T), 'wutu':f8(spcodes_F)}
def getallspcode2(userid): "有图无图商品分开" allspace_fmunitespace = theFmWebSql.getAllUniteSpace(userid) allspace_fmuspace = theFmWebSql.getAllSpace(userid) allspace_fmuspace_T = allspace_fmuspace + allspace_fmunitespace #有图商品 allspace_fmuspace_F = theFmWebSql.getAllSpace(userid, "F") #无图商品 result_T = [] result_F = [] for space in allspace_fmuspace_T: SpaceId = space["Id"] Version = space["Version"] SpaceTitle = space["Title"] if SpaceId[0] != "U": SpaceData = theFmWebSql.getSpaceData(SpaceId, Version, userid) else: SpaceData = webUnite.getSpaceData(SpaceId, Version, userid) newSpaceData = [x for x in SpaceData if int(x[3]) > -1] #去除淘汰商品 result_T = result_T + newSpaceData for space in allspace_fmuspace_F: SpaceId = space["Id"] Version = space["Version"] SpaceTitle = space["Title"] if SpaceId[0] != "U": SpaceData = theFmWebSql.getSpaceData(SpaceId, Version, userid) else: SpaceData = webUnite.getSpaceData(SpaceId, Version, userid) newSpaceData = [x for x in SpaceData if int(x[3]) > -1] #去除淘汰商品 result_F = result_F + newSpaceData spcodes_T = [x[0] for x in result_T] spcodes_F = [x[0] for x in result_F if x[0] not in spcodes_T] return {'youtu': f8(spcodes_T), 'wutu': f8(spcodes_F)}
def getallspbyuserid(userid): result = [] allspace_fmunitespace = theFmWebSql.getAllUniteSpace(userid) allspace_fmuspace = theFmWebSql.getAllSpace(userid) allspace_fmuspace_F = theFmWebSql.getAllSpace(userid, "F") allspace = allspace_fmuspace + allspace_fmunitespace + allspace_fmuspace_F #allspace = allspace_fmuspace_F for space in allspace: SpaceId = space["Id"] Version = space["Version"] SpaceTitle = space["Title"] if SpaceId[0] != "U": SpaceData = theFmWebSql.getSpaceData(SpaceId, Version, userid) else: SpaceData = webUnite.getSpaceData(SpaceId, Version, userid) result = result + SpaceData return result