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