def delete_content_stream(request):
id = request.POST.get("id")
channel_id = request.POST.get("channel")
streamcontentsbeans = CmsStreamcontentsBeans.objects.get(bean_id=id)
if CMS_CHECK_ON:
check = CmsCheck(
channel_id=channel_id,
module=CmsModule.CONFIG_STREAM,
table_name="CmsStreamcontentsBeans",
data_id=streamcontentsbeans.id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=0,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X", time.localtime()))
check.save()
streamcontentsbeans.delete()
CmsStreamcontentbeans.objects.get(id=id).delete()
if CMS_CHECK_ON:
check = CmsCheck(
channel_id=channel_id,
module=CmsModule.CONFIG_STREAM,
table_name="CmsStreamcontentbeans",
data_id=id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=1,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X", time.localtime()))
check.save()
return HttpResponse(0)
def delete_ad(request):
id = request.POST.get("id")
channel_id = request.POST.get('channel')
views = CmsViewScreenads.objects.filter(screenad_id=id)
if CMS_CHECK_ON:
for view in views:
check = CmsCheck(channel_id=channel_id,
module=CmsModule.CONFIG_SCREEN_AD,
table_name="CmsViewScreenads",
data_id=view.id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=0,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X",
time.localtime()))
check.save()
views.delete()
CmsScreenads.objects.filter(id=id).delete()
if CMS_CHECK_ON:
check = CmsCheck(channel_id=channel_id,
module=CmsModule.CONFIG_SCREEN_AD,
table_name="CmsScreenads",
data_id=id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=1,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X",
time.localtime()))
check.save()
return HttpResponse(0)
def delete_shop(request):
id = request.POST.get("id")
channel_id = request.POST.get("channel")
oCmsCategoryitemItembean = CmsCategoryitemItembean.objects.get(
item_bean_id=id)
if CMS_CHECK_ON:
check = CmsCheck(channel_id=channel_id,
module=CmsModule.CONFIG_SECOND_CATEGORY,
table_name="CmsCategoryitemItembean",
data_id=oCmsCategoryitemItembean.id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=0,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X",
time.localtime()))
check.save()
oCmsCategoryitemItembean.delete()
CmsCategoryItembean.objects.get(id=id).delete()
if CMS_CHECK_ON:
check = CmsCheck(channel_id=channel_id,
module=CmsModule.CONFIG_SECOND_CATEGORY,
table_name="CmsCategoryItembean",
data_id=id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=1,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X",
time.localtime()))
check.save()
return HttpResponse(0)
def del_category(request):
id = request.POST.get("id")
# 删除二级分类
children = CmsNaviCategory.objects.filter(parent_id=0, fatherid=id)
if CMS_CHECK_ON:
for child in children:
check = CmsCheck(module=CmsModule.MAIN_CATEGORY,
table_name="CmsNaviCategory",
data_id=child.id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=0,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X",
time.localtime()))
check.save()
children.delete()
# 删除一级分类
parent = CmsNaviCategory.objects.filter(id=id)
if CMS_CHECK_ON:
check = CmsCheck(module=CmsModule.MAIN_CATEGORY,
table_name="CmsNaviCategory",
data_id=id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=1,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X",
time.localtime()))
check.save()
parent.delete()
return HttpResponse(0)
def del_goods(request):
id = request.POST.get('id')
goods = CmsGoods.objects.get(id=id)
if CMS_CHECK_ON:
check = CmsCheck(module=CmsModule.MAIN_GOODS,
table_name="CmsGoods",
data_id=id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=1,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X",
time.localtime()))
check.save()
goods.delete()
return HttpResponse(0)
def exchange_obj(classobj1,
id1,
classobj2,
id2,
channel_id,
module,
request,
word1="location",
word2="location"):
obj1 = classobj1.objects.get(id=id1)
obj2 = classobj2.objects.get(id=id2)
value1 = getattr(obj1, word1)
value2 = getattr(obj2, word2)
setattr(obj1, word1, value2)
setattr(obj2, word2, value1)
obj1.save()
obj2.save()
if CMS_CHECK_ON:
check = CmsCheck(channel_id=channel_id,
module=module,
table_name=classobj1.__name__,
data_id=id1,
op_type=CheckOpType.EDIT,
status=CheckStatu.WAIT_SUBMIT,
is_show=1,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X",
time.localtime()))
check.save()
check = CmsCheck(channel_id=channel_id,
module=module,
table_name=classobj2.__name__,
data_id=id2,
op_type=CheckOpType.EDIT,
status=CheckStatu.WAIT_SUBMIT,
is_show=1,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X",
time.localtime()))
check.save()
def delete_specialtopic(request):
"""
删除内容库的专题，内容库的专题会删除掉，首页专题会删掉，发现页专题is_deleted=1
:param request:
:return:
"""
id = request.POST.get('id')
topic = CmsSpecialTopic.objects.get(id=id)
objs = CmsViewFindTopic.objects.filter(topic_id=id)
for obj in objs:
obj.is_deleted = 1
obj.delete_time = time.timezone.now()
obj.save()
if CMS_CHECK_ON:
check = CmsCheck(module=CmsModule.MAIN_TOPIC,
table_name="CmsViewFindTopic",
data_id=id,
op_type=CheckOpType.EDIT,
status=CheckStatu.WAIT_SUBMIT,
is_show=0,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X",
time.localtime()))
check.save()
if CMS_CHECK_ON:
check = CmsCheck(module=CmsModule.MAIN_TOPIC,
table_name="CmsSpecialTopic",
data_id=id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=1,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X",
time.localtime()))
check.save()
topic.delete()
return HttpResponse(0)
def delete_streamsgroup(request):
id = request.POST.get("id")
channel_id = request.POST.get("channel")
views = CmsViewStream.objects.filter(streamcontent_id=id)
if CMS_CHECK_ON:
for view in views:
check = CmsCheck(
channel_id=channel_id,
module=CmsModule.CONFIG_STREAM,
table_name="CmsViewStream",
data_id=view.id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=0,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X", time.localtime()))
check.save()
views.delete()
streamcontentgoods = CmsStreamcontentsGoods.objects.filter(streamcontent_id=id)
for streamcontentgood in streamcontentgoods:
if CMS_CHECK_ON:
check = CmsCheck(
channel_id=channel_id,
module=CmsModule.CONFIG_STREAM,
table_name="CmsGoods",
data_id=streamcontentgood.goods_id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=0,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X", time.localtime()))
check.save()
check = CmsCheck(
channel_id=channel_id,
module=CmsModule.CONFIG_STREAM,
table_name="CmsStreamcontentsGoods",
data_id=streamcontentgood.id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=0,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X", time.localtime()))
check.save()
streamcontentgood.goods.delete()
streamcontentgoods.delete()
streamcontentsbeans = CmsStreamcontentsBeans.objects.filter(streamcontent_id=id)
for streamcontentsbean in streamcontentsbeans:
if CMS_CHECK_ON:
check = CmsCheck(
channel_id=channel_id,
module=CmsModule.CONFIG_STREAM,
table_name="CmsStreamcontentbeans",
data_id=streamcontentsbean.bean_id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=0,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X", time.localtime()))
check.save()
check = CmsCheck(
channel_id=channel_id,
module=CmsModule.CONFIG_STREAM,
table_name="CmsStreamcontentsBeans",
data_id=streamcontentsbean.id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=0,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X", time.localtime()))
check.save()
streamcontentsbean.bean.delete()
streamcontentsbeans.delete()
CmsStreamcontent.objects.get(id=id).delete()
if CMS_CHECK_ON:
check = CmsCheck(
channel_id=channel_id,
module=CmsModule.CONFIG_STREAM,
table_name="CmsStreamcontent",
data_id=id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=1,
alter_person=request.user.username,
alter_date=time.strftime("%Y-%m-%d %X", time.localtime()))
check.save()
return HttpResponse(0)
def new_ad(request, template_name):
"""
新建开屏广告
#插入到开屏广告表，插入开屏广告和渠道关联表
url :{% url 'new_screen_ad' %}?channel={{ channel }}
:请求方式:Get
:请求参数：channel：渠道id
:返回数据： form 表单 citygroups 城市分组 actions：动作列表 (services 服务列表 goods 商品列表) open_type:类别 cities:所有城市（格式和之前一致）
screen_ad_times = [[1, "仅展示一次"], [100, "每次进入展示"]]
:格式：[[id,name],....]
:请求方式：Post
:请求参数：cms_screenads 表各字段
:
"""
channel_id = request.GET.get('channel')
c, v, t = getCVT(channel_id)
text = get_nav_text(str(t))
if request.method == 'POST':
form = CmsScreenadsForm(request.POST)
form.data['start'] = make_timestamp(form.data['start'])
form.data['end'] = make_timestamp(form.data['end'])
if form.is_valid():
oCmsScreenads = form.save()
if CMS_CHECK_ON:
check = CmsCheck(channel_id=channel_id,
module=CmsModule.CONFIG_SCREEN_AD,
table_name="CmsScreenads",
data_id=oCmsScreenads.id,
op_type=CheckOpType.NEW,
status=CheckStatu.WAIT_SUBMIT,
alter_person=request.user.username,
alter_date=time.strftime(
"%Y-%m-%d %X", time.localtime()))
check.save()
new_associate(channel_id, oCmsScreenads.id, CONFIG_ITEMS.SCREEN_AD,
request)
oCmsViewScreenads = CmsViewScreenads(
screenad=oCmsScreenads,
channel=CmsChannels.objects.get(id=channel_id),
status=0)
oCmsViewScreenads.save()
if CMS_CHECK_ON:
check = CmsCheck(channel_id=channel_id,
module=CmsModule.CONFIG_SCREEN_AD,
table_name="CmsViewScreenads",
data_id=oCmsViewScreenads.id,
op_type=CheckOpType.NEW,
status=CheckStatu.WAIT_SUBMIT,
is_show=0,
alter_person=request.user.username,
alter_date=time.strftime(
"%Y-%m-%d %X", time.localtime()))
check.save()
return HttpResponseRedirect(
reverse('screen_ads') + "?t=%d&c=%s&v=%s" % (t, c, v))
else:
form = CmsAdbeansForm()
citygroups = get_city_group()
actions = get_actions_select()
cities = get_city_list()
errors, fields = format_form(form)
if 'start' in fields.keys():
fields['start'] = json.dumps(timestamp2str(fields['start']))
if 'end' in fields.keys():
fields['end'] = json.dumps(timestamp2str(fields['end']))
return render_to_response(template_name, {
"fields": fields,
"errors": errors,
"citygroups": citygroups,
"actions": actions,
"cities": cities,
"open_type": open_type,
"screen_ad_times": screen_ad_times,
"t": t,
"c": c,
"v": v,
"text": text,
"channel": channel_id
},
context_instance=RequestContext(request))
def del_index_channel(cls, channel_id, db="default"):
"""
首页删除渠道，就要删除渠道下面的所有配置内容
:param channel_id:
:return:
"""
if CMS_CHECK_ON:
CmsCheck.objects.filter(channel_id=channel_id).delete()
channel = CmsChannels.objects.using(db).get(id=channel_id)
# 广告
if not get_relate_channel_list(channel_id, CONFIG_ITEMS.AD, db):
cls.del_ads(channel_id, db)
# 常用服务
if not get_relate_channel_list(channel_id,
CONFIG_ITEMS.COMMON_SERVICES, db):
cls.del_common_services(channel_id, db)
# 分类页服务
if not get_relate_channel_list(
channel_id, CONFIG_ITEMS.CATEGORY_PAGE_SERVICES, db):
cls.del_cate_page_services(channel_id, db)
# 内容流
if not get_relate_channel_list(channel_id, CONFIG_ITEMS.STREAMS, db):
cls.del_streams(channel_id, db)
# 运营配置
if not get_relate_channel_list(channel_id,
CONFIG_ITEMS.CONFIG_OPERATION, db):
cls.del_op_config(channel_id, db)
# 猜你喜欢
if not get_relate_channel_list(channel_id, CONFIG_ITEMS.LIKES, db):
cls.del_likes(channel_id, db)
# 活动
if not get_relate_channel_list(channel_id, CONFIG_ITEMS.ACTIVITY, db):
cls.del_activity(channel_id, db)
# 精品分类
if not get_relate_channel_list(channel_id,
CONFIG_ITEMS.CHOICENESS_CATEGORY, db):
cls.del_choiceness(channel_id, db)
# 优惠券
if not get_relate_channel_list(channel_id, CONFIG_ITEMS.COUPONS, db):
cls.del_coupon(channel_id, db)
# 二级分类
if not get_relate_channel_list(channel_id,
CONFIG_ITEMS.SECOND_CATEGORY, db):
cls.del_second_category(channel_id, db)
# 开屏广告
if not get_relate_channel_list(channel_id, CONFIG_ITEMS.SCREEN_AD, db):
cls.del_screen_ads(channel_id, db)
# Native活动
if not get_relate_channel_list(channel_id,
CONFIG_ITEMS.NATIVE_ACTIVITY, db):
cls.del_native_activity(channel_id, db)
# 品牌
if not get_relate_channel_list(channel_id, CONFIG_ITEMS.CP, db):
cls.del_cp(channel_id, db)
# 业务活动
if not get_relate_channel_list(channel_id,
CONFIG_ITEMS.COUPON_ACTIVITY, db):
cls.del_coupon_activity(channel_id, db)
# 分享券
if not get_relate_channel_list(channel_id, CONFIG_ITEMS.SHARE_COUPON,
db):
cls.del_share_coupon(channel_id, db)
# 秒杀
if not get_relate_channel_list(channel_id, CONFIG_ITEMS.SECKILLS, db):
cls.del_seckills(channel_id, db)
pass
# 首页专题
cls.del_homepage(channel_id, db)
# 发现页专题
cls.del_findpage(channel_id, db)
# 删除渠道关联表
channel_channels = CmsChannelChannel.objects.using(db).filter(
Q(channel_id1=channel_id) | Q(channel_id2=channel_id))
if CMS_CHECK_ON:
if db == "default":
for channel_channel in channel_channels:
check = CmsCheck(module=CmsModule.MAIN_CHANNEL,
table_name="CmsChannelChannel",
data_id=channel_channel.id,
op_type=CheckOpType.DELETE,
status=CheckStatu.WAIT_SUBMIT,
is_show=0,
alter_person="",
alter_date=time.strftime(
"%Y-%m-%d %X", time.localtime()))
check.save()
channel_channels.delete()
channel.delete()