/** * 保存商品产品数据 */ public function do_save_publish() { $account_info = $GLOBALS['account_info']; $supplier_id = $account_info['supplier_id']; $account_id = $account_info['id']; $edit_type = intval($_REQUEST['edit_type']); $id = intval($_REQUEST['id']); if ($edit_type == 1 && $id > 0) { //判断是否有存在修改 $deal_submit_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "deal_submit where deal_id = " . $id . " and supplier_id = " . $supplier_id); if ($deal_submit_info && $deal_submit_info['admin_check_status'] == 0) { $result['status'] = 0; $result['info'] = "已经存在申请操作,请先删除避免重复申请"; ajax_return($result); exit; } else { $deal_info = $GLOBALS['db']->getRow("select d.* from " . DB_PREFIX . "deal d \n left join " . DB_PREFIX . "deal_location_link dll on dll.deal_id = d.id \n where d.is_effect = 1 and d.is_delete = 0 and id=" . $id . " and supplier_id = " . $supplier_id . "\n and dll.location_id in(" . implode(",", $account_info['location_ids']) . ")"); if (empty($deal_info)) { $result['status'] = 0; $result['info'] = "数据不存在或没有权限操作该数据"; ajax_return($result); exit; } $new_data = $deal_info; $new_data['deal_id'] = $deal_info['id']; unset($new_data['id']); $new_data['supplier_id'] = $supplier_id; $new_data['account_id'] = $account_id; //如果数据已经有存在,通过审核的数据,先清除掉在进行插入更新操作 if ($deal_submit_info && $deal_submit_info['admin_check_status'] != 0) { $GLOBALS['db']->query("delete from " . DB_PREFIX . "deal_submit where id=" . $deal_submit_info['id']); } //先建立数据 $GLOBALS['db']->autoExecute(DB_PREFIX . "deal_submit", $new_data); $deal_submit_id = $GLOBALS['db']->insert_id(); } } // 白名单过滤 require_once APP_ROOT_PATH . 'system/model/no_xss.php'; $this->check_goods_publish_data($_REQUEST); $data['supplier_id'] = $supplier_id; // 所属商户 $data['account_id'] = $account_id; $data['name'] = strim($_REQUEST['name']); // 商品名称 $data['sub_name'] = strim($_REQUEST['sub_name']); // 简短名称 $data['brief'] = strim($_REQUEST['brief']); // 简介 $data['buy_type'] = 0; // 默认为普通商品 $data['brand_id'] = intval($_REQUEST['brand_id']); // 品牌 $data['shop_cate_id'] = intval($_REQUEST['shop_cate_id']); //商品分类 $data['description'] = btrim(no_xss($_REQUEST['description'])); //描述 $data['begin_time'] = strim($_REQUEST['begin_time']) == '' ? 0 : to_timespan($_REQUEST['begin_time'], "Y-m-d H:i"); $data['end_time'] = strim($_REQUEST['end_time']) == '' ? 0 : to_timespan($_REQUEST['end_time'], "Y-m-d H:i"); $data['max_bought'] = intval($_REQUEST['max_bought']); // 库存 $data['user_min_bought'] = intval($_REQUEST['user_min_bought']); // 用户最小购买 $data['user_max_bought'] = intval($_REQUEST['user_max_bought']); // 用户最大购买 $data['origin_price'] = intval($_REQUEST['origin_price']); // 原价 $data['balance_price'] = intval($_REQUEST['balance_price']); // 商户结算价 $data['current_price'] = intval($_REQUEST['current_price']); // 商品价 $data['is_refund'] = intval($_REQUEST['is_refund']); //是否支持退款 $data['is_delivery'] = intval($_REQUEST['is_delivery']); //是否支持退款 //开始创建筛选项 $filter = $_REQUEST['filter']; foreach ($filter as $filter_group_id => $filter_value) { $filter_data = array(); $filter_data['filter'] = $filter_value; $filter_data['filter_group_id'] = $filter_group_id; $filter_data['deal_id'] = $list; $filter_data_cache[] = $filter_data; } $data['cache_deal_filter'] = serialize($filter_data_cache); $data['deal_goods_type'] = intval($_REQUEST['deal_goods_type']); //商品类型 $data['create_time'] = NOW_TIME; $data['update_time'] = NOW_TIME; $data['is_shop'] = 1; $data['is_effect'] = 1; $data['is_delete '] = 0; if ($_REQUEST['deal_attr'] && count($_REQUEST['deal_attr']) > 0) { //多套餐 $data['multi_attr'] = 1; } else { $data['multi_attr'] = 0; } $deal_tags = $_REQUEST['deal_tag']; // 标签 $deal_tag = 0; foreach ($deal_tags as $t) { $t2 = pow(2, $t); // 根据tag计算免预约 if ($t == 1) { $data['auto_order'] = 1; } $deal_tag = $deal_tag | $t2; } $data['deal_tag'] = $deal_tag; foreach ($deal_tags as $t) { if ($t == 0) { $data['is_lottery'] = 1; } // 根据tag计算免预约 if ($t == 1) { $data['auto_order'] = 1; } // 随时退 if ($t == 6) { $data['any_refund'] = 1; } // 过期退 if ($t == 5) { $data['expire_refund'] = 1; } } if ($data['any_refund'] == 1 || $data['expire_refund'] == 1) { $data['is_refund'] = 1; } $icon = strim($_REQUEST['img_icon']); // 缩略图 $focus_imgs = $_REQUEST['focus_imgs']; // 图集 if ($id > 0) { //更新操作需要替换图片地址 $icon = replace_public($icon); foreach ($focus_imgs as $k => $v) { $v = replace_public($v); $focus_imgs[$k] = $v; } } $data['icon'] = $icon; // 主图 foreach ($focus_imgs as $k => $v) { if ($v != '') { $data['img'] = $v; break; } } $location_id = $_REQUEST['location_id']; // 支持门店 $data['cache_location_id'] = serialize($location_id); //支持门店缓存 $data['cache_focus_imgs'] = serialize($focus_imgs); //图集缓存 // 开始处理属性 $deal_attr = $_REQUEST['deal_attr']; $deal_attr_price = $_REQUEST['deal_attr_price']; $deal_add_balance_price = $_REQUEST['deal_add_balance_price']; $deal_attr_stock_hd = $_REQUEST['deal_attr_stock_hd']; foreach ($deal_attr as $goods_type_attr_id => $arr) { foreach ($arr as $k => $v) { if ($v != '') { $deal_attr_item['goods_type_attr_id'] = $goods_type_attr_id; $deal_attr_item['name'] = $v; $deal_attr_item['price'] = $deal_attr_price[$goods_type_attr_id][$k]; $deal_attr_item['add_balance_price'] = $deal_add_balance_price[$goods_type_attr_id][$k]; $deal_attr_item['is_checked'] = intval($deal_attr_stock_hd[$goods_type_attr_id][$k]); $deal_attr_data[] = $deal_attr_item; } } } $data['cache_deal_attr'] = serialize($deal_attr_data); // 开始创建属性库存 $stock_cfg = $_REQUEST['stock_cfg_num']; $attr_cfg = $_REQUEST['stock_attr']; $attr_str = $_REQUEST['stock_cfg']; foreach ($stock_cfg as $row => $v) { $stock_data = array(); $stock_data['stock_cfg'] = $v; $stock_data['attr_str'] = $attr_str[$row]; $attr_cfg_data = array(); foreach ($attr_cfg as $attr_id => $cfg) { $attr_cfg_data[$attr_id] = $cfg[$row]; } $stock_data['attr_cfg'] = serialize($attr_cfg_data); $attr_stock[] = $stock_data; } $data['cache_attr_stock'] = serialize($attr_stock); // 管理员状态 $data['admin_check_status'] = 0; // 待审核 if ($id > 0) { if ($edit_type == 1) { $id = $deal_submit_id; //上面生成的记录IDs $data['biz_apply_status'] = 2; // 修改申请 } $GLOBALS['db']->autoExecute(DB_PREFIX . "deal_submit", $data, "UPDATE", " id=" . $id . " and account_id=" . $account_id); $result['status'] = 1; $result['info'] = "修改成功,等待管理员审核"; $result['jump'] = url("biz", "goods#no_online_index"); } else { $data['biz_apply_status'] = 1; // 新增申请 $list = $GLOBALS['db']->autoExecute(DB_PREFIX . "deal_submit", $data); if ($list) { $result['status'] = 1; $result['info'] = "提交成功,等待管理员审核"; $result['jump'] = url("biz", "goods#no_online_index"); } } ajax_return($result); }
/** * 保存团购产品数据 */ public function do_save_publish() { $account_info = $GLOBALS['account_info']; $supplier_id = $account_info['supplier_id']; $account_id = $account_info['id']; //print_r($_REQUEST);exit; $edit_type = intval($_REQUEST['edit_type']); $id = intval($_REQUEST['id']); if ($edit_type == 1 && $id > 0) { //判断是否有存在修改 $youhui_submit_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "youhui_biz_submit where youhui_id = " . $id . " and supplier_id = " . $supplier_id); if ($youhui_submit_info && $youhui_submit_info['admin_check_status'] == 0) { $result['status'] = 0; $result['info'] = "已经存在申请操作,请先删除避免重复申请"; ajax_return($result); exit; } else { $youhui_info = $GLOBALS['db']->getRow("select y.* from " . DB_PREFIX . "youhui as y \n left join " . DB_PREFIX . "youhui_location_link yl on yl.youhui_id = y.id \n where y.is_effect = 1 and y.id=" . $id . " and y.supplier_id = " . $supplier_id . "\n and yl.location_id in(" . implode(",", $account_info['location_ids']) . ")"); if (empty($youhui_info)) { $result['status'] = 0; $result['info'] = "数据不存在或没有权限操作该数据"; ajax_return($result); exit; } $new_data = $youhui_info; $new_data['youhui_id'] = $youhui_info['id']; $new_data['is_effect'] = 1; unset($new_data['id']); $new_data['supplier_id'] = $supplier_id; $new_data['account_id'] = $account_id; //如果数据已经有存在,通过审核的数据,先清除掉在进行插入更新操作 if ($youhui_submit_info && $youhui_submit_info['admin_check_status'] == 1) { $GLOBALS['db']->query("delete from " . DB_PREFIX . "youhui_biz_submit where id=" . $youhui_submit_info['id']); } //先建立数据 $GLOBALS['db']->autoExecute(DB_PREFIX . "youhui_biz_submit", $new_data); $youhui_submit_id = $GLOBALS['db']->insert_id(); } } // 白名单过滤 require_once APP_ROOT_PATH . 'system/model/no_xss.php'; $this->check_publish_data($_REQUEST); $data['supplier_id'] = $supplier_id; // 所属商户 $data['account_id'] = $account_id; $data['name'] = strim($_REQUEST['name1']); // 优惠券名称 $data['icon'] = strim($_REQUEST['icon']); // 优惠券名称 $data['image'] = strim($_REQUEST['image']); // 优惠券名称 if ($id > 0) { //更新操作需要替换图片地址 $data['icon'] = replace_public($data['icon']); $data['image'] = replace_public($data['image']); } $data['begin_time'] = strim($_REQUEST['begin_time']) == '' ? 0 : to_timespan($_REQUEST['begin_time'], "Y-m-d H:i"); $data['end_time'] = strim($_REQUEST['end_time']) == '' ? 0 : to_timespan($_REQUEST['end_time'], "Y-m-d H:i"); $data['expire_day'] = intval($_REQUEST['expire_day']); // 有效天数 $data['total_num'] = intval($_REQUEST['total_num']); // 总条数 $data['user_limit'] = intval($_REQUEST['user_limit']); // 下载限制 $data['city_id'] = intval($_REQUEST['city_id']); // 城市 $data['deal_cate_id'] = intval($_REQUEST['cate_id']); // 分类 $data['youhui_type'] = intval($_REQUEST['youhui_type']); // 优惠券类型 $data['xpoint'] = strim($_REQUEST['xpoint']); $data['ypoint'] = strim($_REQUEST['ypoint']); $data['is_effect'] = 1; // 简介 $data['list_brief'] = strim($_REQUEST['list_brief']); // 简介 $data['description'] = btrim(no_xss($_REQUEST['description'])); $data['use_notice'] = btrim(no_xss($_REQUEST['use_notice'])); $data['create_time'] = NOW_TIME; $deal_cate_type_id = $_REQUEST['deal_cate_type_id']; // 子分类 foreach ($deal_cate_type_id as $k => $v) { $deal_cate_type_id[$k] = intval($v); } $location_id = $_REQUEST['location_id']; // 支持门店 foreach ($location_id as $k => $v) { $location_id[$k] = intval($v); } $data['cache_deal_cate_type_youhui_link'] = serialize($deal_cate_type_id); $data['cache_youhui_location_link'] = serialize($location_id); // 管理员状态 $data['admin_check_status'] = 0; // 待审核 if ($id > 0) { if ($edit_type == 1) { $id = $youhui_submit_id; //上面生成的记录IDs $data['biz_apply_status'] = 2; // 修改申请 } $GLOBALS['db']->autoExecute(DB_PREFIX . "youhui_biz_submit", $data, "UPDATE", " id=" . $id . " and account_id=" . $account_id); $result['status'] = 1; $result['info'] = "修改成功,等待管理员审核"; $result['jump'] = url("biz", "youhui#no_online_index"); } else { $data['biz_apply_status'] = 1; // 新增申请 $list = $GLOBALS['db']->autoExecute(DB_PREFIX . "youhui_biz_submit", $data); if ($list) { $result['status'] = 1; $result['info'] = "提交成功,等待管理员审核"; $result['jump'] = url("biz", "youhui#no_online_index"); } } ajax_return($result); }
public function do_save_publish() { $account_info = $GLOBALS['account_info']; $supplier_id = $account_info['supplier_id']; $account_id = $account_info['id']; $edit_type = intval($_REQUEST['edit_type']); $id = intval($_REQUEST['id']); if ($edit_type == 1 && $id > 0) { //判断是否有存在修改 $event_submit_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "event_biz_submit where event_id = " . $id . " and supplier_id = " . $supplier_id); if ($event_submit_info && $event_submit_info['admin_check_status'] == 0) { //存在未审核数据 $result['status'] = 0; $result['info'] = "已经存在申请操作,请先删除避免重复申请"; ajax_return($result); exit; } else { $event_info = $GLOBALS['db']->getRow("select e.* from " . DB_PREFIX . "event e\n\t left join " . DB_PREFIX . "event_location_link ell on ell.event_id = e.id \n where is_effect = 1 and id=" . $id . " and supplier_id = " . $supplier_id . "\n and ell.location_id in(" . implode(",", $account_info['location_ids']) . ")"); if (empty($event_info)) { $result['status'] = 0; $result['info'] = "数据不存在或没有权限操作该数据"; ajax_return($result); exit; } $new_data = $event_info; $new_data['event_id'] = $event_info['id']; unset($new_data['id']); $new_data['supplier_id'] = $supplier_id; $new_data['account_id'] = $account_id; //如果数据已经有存在,通过审核的数据,先清除掉在进行插入更新操作 if ($event_submit_info && $event_submit_info['admin_check_status'] != 0) { //删除已审核 或 拒绝的数据 $GLOBALS['db']->query("delete from " . DB_PREFIX . "event_biz_submit where id=" . $event_submit_info['id']); } //先建立数据 $GLOBALS['db']->autoExecute(DB_PREFIX . "event_biz_submit", $new_data); $event_submit_id = $GLOBALS['db']->insert_id(); } } // 白名单过滤 require_once APP_ROOT_PATH . 'system/model/no_xss.php'; //数据验证 $this->check_event_publish_data($_REQUEST); $data['supplier_id'] = $supplier_id; // 所属商户 $data['account_id'] = $account_id; $data['name'] = strim($_REQUEST['name']); // 名称 //供应商标志图片 $icon = strim($_REQUEST['icon']); // 活动图片 if ($id > 0) { //更新操作需要替换图片地址 $icon = replace_public($icon); } $data['icon'] = $icon; $data['event_begin_time'] = strim($_REQUEST['event_begin_time']) == '' ? 0 : to_timespan($_REQUEST['event_begin_time'], "Y-m-d H:i"); $data['event_end_time'] = strim($_REQUEST['event_end_time']) == '' ? 0 : to_timespan($_REQUEST['event_end_time'], "Y-m-d H:i"); $data['submit_begin_time'] = strim($_REQUEST['submit_begin_time']) == '' ? 0 : to_timespan($_REQUEST['submit_begin_time'], "Y-m-d H:i"); // 报名开始时间: $data['submit_end_time'] = strim($_REQUEST['submit_end_time']) == '' ? 0 : to_timespan($_REQUEST['submit_end_time'], "Y-m-d H:i"); // 报名结束时间 $data['total_count'] = intval($_REQUEST['total_count']); //名额 $data['score_limit'] = intval($_REQUEST['score_limit']); //消耗积分 $data['point_limit'] = intval($_REQUEST['point_limit']); //经验限制 $data['city_id'] = intval($_REQUEST['city_id']); // 城市 $area_id = $_REQUEST['area_id']; // 地区列表 $data['cache_event_area_link'] = serialize($area_id); $data['cate_id'] = intval($_REQUEST['cate_id']); // 分类 $location_id = $_REQUEST['location_id']; // 支持门店 $data['cache_event_location_link'] = serialize($location_id); $data['address'] = strim($_REQUEST['address']); // 地址 $data['api_address'] = strim($_REQUEST['api_address']); // 地图定位的地址 $data['xpoint'] = strim($_REQUEST['xpoint']); // 经度 $data['ypoint'] = strim($_REQUEST['ypoint']); // 纬度 $data['brief'] = strim($_REQUEST['brief']); // 部门简介 $data['content'] = btrim(no_xss($_REQUEST['content'])); //内容 //字段配置 foreach ($_REQUEST['field_id'] as $k => $field_id) { $event_field = array(); $event_field['event_id'] = 0; $event_field['field_show_name'] = $_REQUEST['field_show_name'][$k]; $event_field['field_type'] = $_REQUEST['field_type'][$k]; $event_field['value_scope'] = $_REQUEST['value_scope'][$k]; $event_field['sort'] = $k; $cache_event_field[] = $event_field; } $data['cache_event_field'] = serialize($cache_event_field); /*默认参数*/ $data['is_effect'] = 1; // 管理员状态 $data['admin_check_status'] = 0; // 待审核 if ($id > 0) { if ($edit_type == 1) { $id = $event_submit_id; //上面生成的记录IDs $data['biz_apply_status'] = 2; // 修改申请 } $GLOBALS['db']->autoExecute(DB_PREFIX . "event_biz_submit", $data, "UPDATE", " id=" . $id . " and account_id=" . $account_id); $result['status'] = 1; $result['info'] = "修改成功,等待管理员审核"; $result['jump'] = url("biz", "event#no_online_index"); } else { $data['biz_apply_status'] = 1; // 新增申请 $list = $GLOBALS['db']->autoExecute(DB_PREFIX . "event_biz_submit", $data); if ($list) { $result['status'] = 1; $result['info'] = "提交成功,等待管理员审核"; $result['jump'] = url("biz", "event#no_online_index"); } } ajax_return($result); }
public function do_save_publish() { $account_info = $GLOBALS['account_info']; $supplier_id = $account_info['supplier_id']; $account_id = $account_info['id']; $edit_type = intval($_REQUEST['edit_type']); $id = intval($_REQUEST['id']); if ($edit_type == 1 && $id > 0) { //判断是否有存在修改 $location_submit_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_location_biz_submit where location_id = " . $id . " and supplier_id = " . $supplier_id); if ($location_submit_info && $location_submit_info['admin_check_status'] == 0) { //存在未审核数据 $result['status'] = 0; $result['info'] = "已经存在申请操作,请先删除避免重复申请"; ajax_return($result); exit; } else { $location_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_location\n where is_effect = 1 and id=" . $id . " and supplier_id = " . $supplier_id . "\n and id in(" . implode(",", $account_info['location_ids']) . ")"); if (empty($location_info)) { $result['status'] = 0; $result['info'] = "数据不存在或没有权限操作该数据"; ajax_return($result); exit; } $new_data = $location_info; $new_data['location_id'] = $location_info['id']; unset($new_data['id']); $new_data['supplier_id'] = $supplier_id; $new_data['account_id'] = $account_id; //如果数据已经有存在,通过审核的数据,先清除掉在进行插入更新操作 if ($location_submit_info && $location_submit_info['admin_check_status'] != 0) { //删除已审核 或 拒绝的数据 $GLOBALS['db']->query("delete from " . DB_PREFIX . "supplier_location_biz_submit where id=" . $location_submit_info['id']); } //先建立数据 $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_biz_submit", $new_data); $location_submit_id = $GLOBALS['db']->insert_id(); } } // 白名单过滤 require_once APP_ROOT_PATH . 'system/model/no_xss.php'; //数据验证 $this->check_location_publish_data($_REQUEST); $data['supplier_id'] = $supplier_id; // 所属商户 $data['account_id'] = $account_id; $data['name'] = strim($_REQUEST['name']); // 名称 $data['tags'] = strim($_REQUEST['tags']); // 标签 //供应商标志图片 $preview_img = strim($_REQUEST['preview']); // 缩略图 if ($id > 0) { //更新操作需要替换图片地址 $preview_img = replace_public($preview_img); } $data['preview'] = $preview_img; //图库 $location_images = $_REQUEST['location_images']; foreach ($location_images as $k => $v) { $cache_location_images[] = replace_public($v); } $data['cache_supplier_location_images'] = serialize($cache_location_images); $data['city_id'] = intval($_REQUEST['city_id']); // 城市 $area_id = $_REQUEST['area_id']; // 地区列表 $data['cache_supplier_location_area_link'] = serialize($area_id); $data['deal_cate_id'] = intval($_REQUEST['cate_id']); // 分类 $deal_cate_type_id = $_REQUEST['deal_cate_type_id']; // 子分类 $data['cache_deal_cate_type_location_link'] = serialize($deal_cate_type_id); $data['address'] = strim($_REQUEST['address']); // 地址 $data['route'] = strim($_REQUEST['route']); // 交通路线 $data['tel'] = strim($_REQUEST['tel']); // 地址 $data['address'] = strim($_REQUEST['address']); // 联系电话 $data['contact'] = strim($_REQUEST['contact']); // 联系人 $data['open_time'] = strim($_REQUEST['open_time']); // 营业时间 $data['api_address'] = strim($_REQUEST['api_address']); // 地图定位的地址 $data['xpoint'] = strim($_REQUEST['xpoint']); // 经度 $data['ypoint'] = strim($_REQUEST['ypoint']); // 纬度 $data['brief'] = btrim(no_xss($_REQUEST['brief'])); // 部门简介 /*默认参数*/ $data['is_main'] = 0; $data['is_effect'] = 1; // 管理员状态 $data['admin_check_status'] = 0; // 待审核 if ($id > 0) { if ($edit_type == 1) { $id = $location_submit_id; //上面生成的记录IDs $data['biz_apply_status'] = 2; // 修改申请 } $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_biz_submit", $data, "UPDATE", " id=" . $id . " and account_id=" . $account_id); $result['status'] = 1; $result['info'] = "修改成功,等待管理员审核"; $result['jump'] = url("biz", "location#no_online_index"); } else { $data['biz_apply_status'] = 1; // 新增申请 $list = $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_biz_submit", $data); if ($list) { $result['status'] = 1; $result['info'] = "提交成功,等待管理员审核"; $result['jump'] = url("biz", "location#no_online_index"); } } ajax_return($result); }