12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484 |
- <?php
- namespace app\home\controller;
- use think\facade\View;
- use think\facade\Lang;
- use think\facade\Db;
- /**
-
- *
-
- *
- * ----------------------------------------------------------------------------
- *
-
- * 控制器
- */
- class Sellergoodsonline extends BaseSeller
- {
- public function initialize()
- {
- parent::initialize();
- Lang::load(base_path() . 'home/lang/' . config('lang.default_lang') . '/sellergoodsadd.lang.php');
- $this->template_dir = 'default/seller/sellergoodsadd/';
- }
- public function index()
- {
- $this->goods_list();
- }
- /**
- * 出售中的商品列表
- */
- public function goods_list()
- {
- $goods_model = model('goods');
- $where = array();
- $where[] = array('goodscommon.store_id', '=', session('store_id'));
- $where[] = array('goodscommon.goods_state', '=', 1);
- $where[] = array('goodscommon.goods_verify', '=', 1);
- $storegc_id = intval(input('get.storegc_id'));
- if ($storegc_id > 0) {
- $where[] = array('goodscommon.goods_stcids', 'like', '%,' . $storegc_id . ',%');
- }
- $keyword = trim(input('get.keyword'));
- $search_type = trim(input('get.search_type'));
- if (trim($keyword) != '') {
- switch ($search_type) {
- case 0:
- $where[] = array('goodscommon.goods_name', 'like', '%' . trim($keyword) . '%');
- break;
- case 1:
- $where[] = array('goodscommon.goods_serial', 'like', '%' . trim($keyword) . '%');
- break;
- case 2:
- $where[] = array('goodscommon.goods_commonid', '=', intval($keyword));
- break;
- }
- }
- $stock = trim(input('get.stock'));
- switch ($stock) {
- case 1:
- $where[] = array('goods.goods_storage', 'EXP', Db::raw('<=goods.goods_storage_alarm'));
- $where[] = array('goods.goods_storage_alarm', '>', 0);
- break;
- }
- $goods_list = $goods_model->getGoodsUnionList($where, 'goods.goods_id,goods.goods_storage_alarm,goods.goods_storage,goodscommon.goods_commonid,goodscommon.mobile_body,goodscommon.goods_name,goodscommon.goods_addtime,goodscommon.goods_lock,goodscommon.goods_sort,goodscommon.goods_commend,goodscommon.goods_serial,goodscommon.is_virtual,goodscommon.virtual_type,goodscommon.is_goodsfcode,goodscommon.is_appoint,goodscommon.goods_advword,goodscommon.goods_image,goodscommon.store_id,goods.goods_promotion_price,goodscommon.goods_price', 'goodscommon.goods_commonid desc', 'goodscommon.goods_commonid', 10);
- foreach ($goods_list as $key => $val) {
- if ($val['goods_storage_alarm'] != 0 && $val['goods_storage'] <= $val['goods_storage_alarm']) {
- $goods_list[$key]['alarm'] = true;
- }
- $goods_list[$key]['sum'] = Db::name('goods')->where(array(array('goods_commonid', '=', $val['goods_commonid'])))->sum('goods_storage');
- $val['goods_type'] = 1;
- if ($val['goods_lock']) {
- $goods_info = $goods_model->getGoodsInfoAndPromotionById($val['goods_id']);
- if (isset($goods_info['groupbuy_info']) && $goods_info['groupbuy_info']) {
- $val['goods_type'] = 2;
- }
- if (isset($goods_info['pintuan_info']) && $goods_info['pintuan_info']) {
- $val['goods_type'] = 6;
- }
- if (isset($goods_info['bargain_info']) && $goods_info['bargain_info']) {
- $val['goods_type'] = 8;
- }
- if (isset($goods_info['presell_info']) && $goods_info['presell_info']) {
- $val['goods_type'] = 10;
- }
- if (isset($goods_info['xianshi_info']) && $goods_info['xianshi_info']) {
- $val['goods_type'] = 3;
- }
- if (isset($goods_info['wholesale_info']) && $goods_info['wholesale_info']) {
- $val['goods_type'] = 9;
- }
- }
- $goods_list[$key]['goods_type_cn'] = get_order_goodstype($val['goods_type']);
- }
- View::assign('show_page', $goods_model->page_info->render());
- View::assign('goods_list', $goods_list);
- // 商品分类
- $store_goods_class = model('storegoodsclass')->getClassTree(array('store_id' => session('store_id'), 'storegc_state' => '1'));
- View::assign('store_goods_class', $store_goods_class);
- /* 设置卖家当前菜单 */
- $this->setSellerCurMenu('sellergoodsonline');
- $this->setSellerCurItem('goods_list');
- echo View::fetch($this->template_dir . 'store_goods_list_online');
- exit;
- }
- /**
- * 编辑商品页面
- */
- public function edit_goods()
- {
- $common_id = intval(input('param.commonid'));
- if ($common_id <= 0) {
- $this->error(lang('param_error'));
- }
- $goods_model = model('goods');
- $goodscommon_info = $goods_model->getGoodsCommonInfoByID($common_id);
- if (empty($goodscommon_info) || $goodscommon_info['store_id'] != session('store_id') || $goodscommon_info['goods_lock'] == 1) {
- $this->error(lang('goods_not_exist_or_lock'));
- }
- $where = array('goods_commonid' => $common_id, 'store_id' => session('store_id'));
- $goodscommon_info['g_storage'] = $goods_model->getGoodsSum($where, 'goods_storage');
- $goodscommon_info['spec_name'] = unserialize($goodscommon_info['spec_name']);
- if ($goodscommon_info['mobile_body'] != '') {
- $goodscommon_info['mb_body'] = unserialize($goodscommon_info['mobile_body']);
- if (is_array($goodscommon_info['mb_body'])) {
- $mobile_body = '[';
- foreach ($goodscommon_info['mb_body'] as $val) {
- $mobile_body .= '{"type":"' . $val['type'] . '","value":"' . $val['value'] . '"},';
- }
- $mobile_body = rtrim($mobile_body, ',') . ']';
- }
- $goodscommon_info['mobile_body'] = $mobile_body;
- }
- $class_id = intval(input('param.class_id'));
- if ($class_id > 0) {
- $goodscommon_info['gc_id'] = $class_id;
- }
- $goods_class = model('goodsclass')->getGoodsclassLineForTag($goodscommon_info['gc_id']);
- View::assign('goods_class', $goods_class);
- $type_model = model('type');
- // 获取类型相关数据
- $typeinfo = $type_model->getAttribute($goods_class['type_id'], session('store_id'), $goodscommon_info['gc_id']);
- list($spec_json, $spec_list, $attr_list, $brand_list) = $typeinfo;
- View::assign('spec_json', $spec_json);
- View::assign('sign_i', count($spec_list));
- View::assign('spec_list', $spec_list);
- View::assign('attr_list', $attr_list);
- View::assign('brand_list', $brand_list);
- // 取得商品规格的输入值
- $goods_array = $goods_model->getGoodsList($where, 'goods_id,goods_marketprice,goods_price,goods_storage,goods_serial,goods_storage_alarm,goods_spec,goods_weight,virtual_content');
- $sp_value = array();
- if (is_array($goods_array) && !empty($goods_array)) {
- $goodscommon_info['goods_weight'] = $goods_array[0]['goods_weight'];
- switch ($goodscommon_info['virtual_type']) {
- case 1:
- $goodscommon_info['vc_card'] = $goods_array[0]['virtual_content'];
- break;
- case 2:
- $goodscommon_info['vc_pan'] = $goods_array[0]['virtual_content'];
- break;
- case 3:
- $goodscommon_info['vc_file'] = $goods_array[0]['virtual_content'];
- break;
- }
- // 取得已选择了哪些商品的属性
- $attr_checked_l = $type_model->typeRelatedList('goodsattrindex', array(
- 'goods_id' => intval($goods_array[0]['goods_id'])
- ), 'attrvalue_id');
- $attr_checked = array();
- if (is_array($attr_checked_l) && !empty($attr_checked_l)) {
- foreach ($attr_checked_l as $val) {
- $attr_checked[] = $val['attrvalue_id'];
- }
- }
- View::assign('attr_checked', $attr_checked);
- $spec_checked = array();
- foreach ($goods_array as $k => $v) {
- $a = unserialize($v['goods_spec']);
- if (!empty($a)) {
- foreach ($a as $key => $val) {
- $spec_checked[$key]['id'] = $key;
- $spec_checked[$key]['name'] = addslashes($val);
- }
- $matchs = array_keys($a);
- sort($matchs);
- $id = str_replace(',', '', implode(',', $matchs));
- $sp_value['i_' . $id . '|marketprice'] = $v['goods_marketprice'];
- $sp_value['i_' . $id . '|price'] = $v['goods_price'];
- $sp_value['i_' . $id . '|id'] = $v['goods_id'];
- $sp_value['i_' . $id . '|stock'] = $v['goods_storage'];
- $sp_value['i_' . $id . '|alarm'] = $v['goods_storage_alarm'];
- $sp_value['i_' . $id . '|sku'] = $v['goods_serial'];
- $sp_value['i_' . $id . '|goods_weight'] = $v['goods_weight'];
- switch ($goodscommon_info['virtual_type']) {
- case 1:
- $sp_value['i_' . $id . '|vc_card'] = $v['virtual_content'];
- break;
- case 2:
- $sp_value['i_' . $id . '|vc_pan'] = $v['virtual_content'];
- break;
- case 3:
- $sp_value['i_' . $id . '|vc_file'] = $v['virtual_content'];
- break;
- }
- }
- }
- View::assign('spec_checked', $spec_checked);
- }
- $goodscommon_info['store_service_ids'] = explode(',', $goodscommon_info['store_service_ids']);
- View::assign('goods', $goodscommon_info);
- View::assign('sp_value', $sp_value);
- // 实例化店铺商品分类模型
- $store_goods_class = model('storegoodsclass')->getClassTree(array('store_id' => session('store_id'), 'storegc_state' => '1'));
- View::assign('store_goods_class', $store_goods_class);
- //处理商品所属分类
- $store_goods_class_tmp = array();
- if (!empty($store_goods_class)) {
- foreach ($store_goods_class as $k => $v) {
- $store_goods_class_tmp[$v['storegc_id']] = $v;
- if (isset($v['child'])) {
- foreach ($v['child'] as $son_k => $son_v) {
- $store_goods_class_tmp[$son_v['storegc_id']] = $son_v;
- }
- }
- }
- }
- $goodscommon_info['goods_stcids'] = trim($goodscommon_info['goods_stcids'], ',');
- $goods_stcids = empty($goodscommon_info['goods_stcids']) ? array() : explode(',', $goodscommon_info['goods_stcids']);
- $goods_stcids_tmp = $goods_stcids_new = array();
- if (!empty($goods_stcids)) {
- foreach ($goods_stcids as $k => $v) {
- if (isset($store_goods_class_tmp[$v])) {
- $storegc_parent_id = $store_goods_class_tmp[$v]['storegc_parent_id'];
- } else {
- $storegc_parent_id = 0;
- }
- //分类进行分组,构造为array('1'=>array(5,6,8));
- if ($storegc_parent_id > 0) { //如果为二级分类,则分组到父级分类下
- $goods_stcids_tmp[$storegc_parent_id][] = $v;
- } elseif (empty($goods_stcids_tmp[$v])) { //如果为一级分类而且分组不存在,则建立一个空分组数组
- $goods_stcids_tmp[$v] = array();
- }
- }
- foreach ($goods_stcids_tmp as $k => $v) {
- if (!empty($v) && count($v) > 0) {
- $goods_stcids_new = array_merge($goods_stcids_new, $v);
- } else {
- $goods_stcids_new[] = $k;
- }
- }
- }
- View::assign('store_class_goods', $goods_stcids_new);
- // 小时分钟显示
- $hour_array = array('00', '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23');
- View::assign('hour_array', $hour_array);
- $minute_array = array('05', '10', '15', '20', '25', '30', '35', '40', '45', '50', '55');
- View::assign('minute_array', $minute_array);
- // 关联版式
- $plate_list = model('storeplate')->getStoreplateList(array('store_id' => session('store_id')), 'storeplate_id,storeplate_name,storeplate_position');
- $plate_list = array_under_reset($plate_list, 'storeplate_position', 2);
- View::assign('plate_list', $plate_list);
- // F码
- if ($goodscommon_info['is_goodsfcode'] == 1) {
- $fcode_array = model('goodsfcode')->getGoodsfcodeList(array('goods_commonid' => $goodscommon_info['goods_commonid']));
- View::assign('fcode_array', $fcode_array);
- }
- View::assign('edit_goods_sign', true);
- $store_service_model = model('store_service');
- $store_service_list = $store_service_model->getStoreServiceList(array(array('store_id', '=', session('store_id'))), '*', 0);
- View::assign('store_service_list', $store_service_list);
- /* 设置卖家当前菜单 */
- $this->setSellerCurMenu('sellergoodsonline');
- $this->setSellerCurItem('edit_goods');
- return View::fetch($this->template_dir . 'store_goods_add_step2');
- }
- /**
- * 编辑商品保存
- */
- public function edit_save_goods()
- {
- $common_id = intval(input('param.commonid'));
- if (!request()->isPost() || $common_id <= 0) {
- ds_json_encode(10001, lang('store_goods_index_goods_edit_fail'));
- }
- $gc_id = intval(input('post.cate_id'));
- // 验证商品分类是否存在且商品分类是否为最后一级
- $data = model('goodsclass')->getGoodsclassForCacheModel();
- if (!isset($data[$gc_id]) || isset($data[$gc_id]['child']) || isset($data[$gc_id]['childchild'])) {
- ds_json_encode(10001, lang('store_goods_index_again_choose_category1'));
- }
- // 三方店铺验证是否绑定了该分类
- if (!check_platform_store()) {
- //商品分类 提供批量显示所有分类插件
- $storebindclass_model = model('storebindclass');
- $goods_class = model('goodsclass')->getGoodsclassForCacheModel();
- $condition = array();
- $condition[] = array('store_id', '=', session('store_id'));
- $class_2 = isset($goods_class[$gc_id]['gc_parent_id']) ? $goods_class[$gc_id]['gc_parent_id'] : 0;
- $class_1 = isset($goods_class[$class_2]['gc_parent_id']) ? $goods_class[$class_2]['gc_parent_id'] : 0;
- $condition_class_1 = array(array('class_1', '=', ($class_1 > 0) ? $class_1 : (($class_2 > 0) ? $class_2 : $gc_id)));
- $condition_class_2 = array(array('class_2', '=', ($class_1 > 0) ? $class_2 : (($class_2 > 0) ? $gc_id : 0)));
- $condition_class_3 = array(array('class_3', '=', ($class_1 > 0 && $class_2 > 0) ? $gc_id : 0));
- $bind_info = $storebindclass_model->getStorebindclassInfo(array_merge($condition, $condition_class_1, $condition_class_2, $condition_class_3));
- if (empty($bind_info)) {
- $condition_class_3 = array(array('class_3', '=', 0));
- $bind_info = $storebindclass_model->getStorebindclassInfo(array_merge($condition, $condition_class_1, $condition_class_2, $condition_class_3));
- if (empty($bind_info)) {
- $condition_class_2 = array(array('class_2', '=', 0));
- $condition_class_3 = array(array('class_3', '=', 0));
- $bind_info = $storebindclass_model->getStorebindclassInfo(array_merge($condition, $condition_class_1, $condition_class_2, $condition_class_3));
- if (empty($bind_info)) {
- $condition_class_1 = array(array('class_1', '=', 0));
- $condition_class_2 = array(array('class_2', '=', 0));
- $condition_class_3 = array(array('class_3', '=', 0));
- $bind_info = $storebindclass_model->getStorebindclassInfo(array_merge($condition, $condition_class_1, $condition_class_2, $condition_class_3));
- if (empty($bind_info)) {
- ds_json_encode(10001, lang('store_goods_index_again_choose_category2'));
- }
- }
- }
- }
- }
- // 分类信息
- $goods_class = model('goodsclass')->getGoodsclassLineForTag(intval(input('post.cate_id')));
- $goods_model = model('goods');
- $update_common = array();
- $update_common['goods_name'] = input('post.g_name');
- $update_common['goods_advword'] = input('post.g_jingle');
- $update_common['gc_id'] = $gc_id;
- $update_common['gc_id_1'] = isset($goods_class['gc_id_1']) ? intval($goods_class['gc_id_1']) : 0;
- $update_common['gc_id_2'] = isset($goods_class['gc_id_2']) ? intval($goods_class['gc_id_2']) : 0;
- $update_common['gc_id_3'] = isset($goods_class['gc_id_3']) ? intval($goods_class['gc_id_3']) : 0;
- $update_common['gc_name'] = input('post.cate_name');
- $update_common['brand_id'] = input('post.b_id');
- $update_common['brand_name'] = input('post.b_name');
- $update_common['type_id'] = intval(input('post.type_id'));
- $update_common['goods_image'] = input('post.image_path');
- $update_common['goodsvideo_name'] = input('post.goodsvideo_name');
- $update_common['goods_price'] = floatval(input('post.g_price'));
- $update_common['goods_marketprice'] = floatval(input('post.g_marketprice'));
- $update_common['goods_costprice'] = floatval(input('post.g_costprice'));
- $update_common['goods_discount'] = floatval(input('post.g_discount'));
- $update_common['goods_serial'] = input('post.g_serial');
- $update_common['goods_storage_alarm'] = intval(input('post.g_alarm'));
- $update_common['goods_attr'] = !empty(input('post.attr/a')) ? serialize(input('post.attr/a')) : '';
- $update_common['store_service_ids'] = !empty(input('post.store_service_ids/a')) ? implode(',', input('post.store_service_ids/a')) : '';
- $goods_body = preg_replace_callback("/<\s*img\s+[^>]*?src\s*=\s*(\'|\")(.*?)\\1[^>]*?\/?\s*>/i", function ($matches) {
- return str_replace($matches[2], strip_tags($matches[2]), $matches[0]);
- }, htmlspecialchars_decode(input('post.goods_body')));
- $update_common['goods_body'] = $goods_body;
- // 序列化保存手机端商品描述数据
- $mobile_body = input('post.m_body');
- if ($mobile_body != '') {
- $mobile_body = str_replace('"', '"', $mobile_body);
- $mobile_body = json_decode($mobile_body, true);
- if (!empty($mobile_body)) {
- $mobile_body = serialize($mobile_body);
- } else {
- $mobile_body = '';
- }
- }
- $update_common['mobile_body'] = $mobile_body;
- $update_common['goods_commend'] = intval(input('post.g_commend'));
- $update_common['goods_state'] = ($this->store_info['store_state'] != 1) ? 0 : intval(input('post.g_state')); // 店铺关闭时,商品下架
- $update_common['goods_shelftime'] = strtotime(input('post.starttime')) + intval(input('post.starttime_H')) * 3600 + intval(input('post.starttime_i')) * 60;
- $update_common['goods_verify'] = (config('ds_config.goods_verify') == 1) ? 10 : 1;
- $update_common['spec_name'] = !empty(input('post.spec/a')) ? serialize(input('post.sp_name/a')) : serialize(null);
- $update_common['spec_value'] = !empty(input('post.spec/a')) ? serialize(input('post.sp_val/a')) : serialize(null);
- $update_common['goods_vat'] = intval(input('post.g_vat'));
- $update_common['areaid_1'] = intval(input('post.province_id'));
- $update_common['areaid_2'] = intval(input('post.city_id'));
- $update_common['transport_id'] = (input('post.freight') == '0') ? '0' : intval(input('post.transport_id')); // 售卖区域
- $update_common['transport_title'] = input('post.transport_title');
- $update_common['goods_freight'] = floatval(input('post.g_freight'));
- $sellergoodsonline_validate = ds_validate('sellergoodsonline');
- if (!$sellergoodsonline_validate->scene('edit_save_goods')->check($update_common)) {
- ds_json_encode('10001', $sellergoodsonline_validate->getError());
- }
- //查询店铺商品分类
- $goods_stcids_arr = array();
- $sgcate_id_array = input('post.sgcate_id/a'); #获取数组
- if (!empty($sgcate_id_array)) {
- $sgcate_id_arr = array();
- foreach ($sgcate_id_array as $k => $v) {
- $sgcate_id_arr[] = intval($v);
- }
- $sgcate_id_arr = array_unique($sgcate_id_arr);
- $store_goods_class = model('storegoodsclass')->getStoregoodsclassList(array(array('store_id', '=', session('store_id')), array('storegc_id', 'in', $sgcate_id_arr), array('storegc_state', '=', '1')));
- if (!empty($store_goods_class)) {
- foreach ($store_goods_class as $k => $v) {
- if ($v['storegc_id'] > 0) {
- $goods_stcids_arr[] = $v['storegc_id'];
- }
- if ($v['storegc_parent_id'] > 0) {
- $goods_stcids_arr[] = $v['storegc_parent_id'];
- }
- }
- $goods_stcids_arr = array_unique($goods_stcids_arr);
- sort($goods_stcids_arr);
- }
- }
- if (empty($goods_stcids_arr)) {
- $update_common['goods_stcids'] = '';
- } else {
- $update_common['goods_stcids'] = ',' . implode(',', $goods_stcids_arr) . ',';
- }
- $update_common['plateid_top'] = intval(input('post.plate_top')) > 0 ? intval(input('post.plate_top')) : '';
- $update_common['plateid_bottom'] = intval(input('post.plate_bottom')) > 0 ? intval(input('post.plate_bottom')) : '';
- $update_common['is_virtual'] = intval(input('post.is_gv'));
- $update_common['virtual_type'] = $update_common['is_virtual'] ? intval(input('post.virtual_type')) : 0;
- $update_common['virtual_indate'] = input('post.g_vindate') != '' ? (strtotime(input('post.g_vindate')) + 24 * 60 * 60 - 1) : 0; // 当天的最后一秒结束
- $update_common['virtual_limit'] = intval(input('post.g_vlimit')) > 10 || intval(input('post.g_vlimit')) < 0 ? 10 : intval(input('post.g_vlimit'));
- $update_common['virtual_invalid_refund'] = intval(input('post.g_vinvalidrefund'));
- $update_common['is_goodsfcode'] = $update_common['is_virtual'] ? 0 : intval(input('post.is_fc'));
- $update_common['is_appoint'] = $update_common['is_virtual'] ? 0 : intval(input('post.is_appoint')); // 只有库存为零的商品可以预约
- $update_common['appoint_satedate'] = $update_common['is_appoint'] == 1 ? strtotime(input('post.g_saledate')) : ''; // 预约商品的销售时间
- $update_common['is_platform_store'] = in_array(session('store_id'), model('store')->getOwnShopIds()) ? 1 : 0;
- // 开始事务
- Db::startTrans();
- try {
- $goods_model->lock = true;
- $goodsgift_model = model('goodsgift');
- // 清除原有规格数据
- $type_model = model('type');
- $type_model->delGoodsAttr(array('goods_commonid' => $common_id));
- // 更新商品规格
- $goodsid_array = array();
- $colorid_array = array();
- $spec_array = input('post.spec/a'); #获取数组
- if (is_array($spec_array) && !empty($spec_array)) {
- foreach ($spec_array as $value) {
- $goods_info = $goods_model->getGoodsInfo(array('goods_id' => $value['goods_id'], 'goods_commonid' => $common_id, 'store_id' => session('store_id')), 'goods_id');
- if (!empty($goods_info)) {
- $goods_id = $goods_info['goods_id'];
- $update = array();
- $update['goods_commonid'] = $common_id;
- $update['goods_name'] = $update_common['goods_name'] . ' ' . implode(' ', $value['sp_value']);
- $update['goods_advword'] = $update_common['goods_advword'];
- $update['store_id'] = session('store_id');
- $update['store_name'] = session('store_name');
- $update['gc_id'] = $update_common['gc_id'];
- $update['gc_id_1'] = $update_common['gc_id_1'];
- $update['gc_id_2'] = $update_common['gc_id_2'];
- $update['gc_id_3'] = $update_common['gc_id_3'];
- $update['brand_id'] = $update_common['brand_id'];
- $update['goods_price'] = $value['price'];
- $update['goods_marketprice'] = $value['marketprice'] == 0 ? $update_common['goods_marketprice'] : $value['marketprice'];
- $update['goods_serial'] = $value['sku'];
- $update['goods_storage_alarm'] = intval($value['alarm']);
- $update['goods_spec'] = serialize($value['sp_value']);
- $update['goods_storage'] = $value['stock'];
- $update['goods_weight'] = $value['goods_weight'];
- $update['goods_state'] = $update_common['goods_state'];
- $update['goods_verify'] = $update_common['goods_verify'];
- $update['goods_edittime'] = TIMESTAMP;
- $update['areaid_1'] = $update_common['areaid_1'];
- $update['areaid_2'] = $update_common['areaid_2'];
- $update['color_id'] = isset($value['color']) ? intval($value['color']) : '';
- $update['transport_id'] = $update_common['transport_id'];
- $update['goods_freight'] = $update_common['goods_freight'];
- $update['goods_vat'] = $update_common['goods_vat'];
- $update['goods_commend'] = $update_common['goods_commend'];
- $update['goods_stcids'] = $update_common['goods_stcids'];
- $update['is_virtual'] = $update_common['is_virtual'];
- $update['virtual_indate'] = $update_common['virtual_indate'];
- $update['virtual_limit'] = $update_common['virtual_limit'];
- $update['virtual_invalid_refund'] = $update_common['virtual_invalid_refund'];
- $update['is_goodsfcode'] = $update_common['is_goodsfcode'];
- $update['is_appoint'] = $update_common['is_appoint'];
- switch ($update_common['virtual_type']) {
- case 1:
- $update['virtual_content'] = $value['vc_card'];
- $res = $goods_model->getAvailableGoodsCard(array_merge($update, array('goods_id' => $goods_info['goods_id'])));
- if ($res['code']) {
- $update['goods_storage'] = $res['data']['card_num'];
- } else {
- $update['goods_storage'] = 0;
- }
- break;
- case 2:
- $update['virtual_content'] = $value['vc_pan'];
- $update['goods_storage'] = 1;
- break;
- case 3:
- $update['virtual_content'] = $value['vc_file'];
- $update['goods_storage'] = 1;
- break;
- default:
- $update['virtual_content'] = '';
- }
- // 虚拟商品不能有赠品
- if ($update_common['is_virtual'] == 1) {
- $update['is_have_gift'] = 0;
- $goodsgift_model->delGoodsgift(array('goods_id' => $goods_id));
- }
- $update['is_platform_store'] = $update_common['is_platform_store'];
- $goods_model->editGoodsById($update, $goods_id);
- } else {
- $insert = array();
- $insert['goods_commonid'] = $common_id;
- $insert['goods_name'] = $update_common['goods_name'] . ' ' . implode(' ', $value['sp_value']);
- $insert['goods_advword'] = $update_common['goods_advword'];
- $insert['store_id'] = session('store_id');
- $insert['store_name'] = session('store_name');
- $insert['gc_id'] = $update_common['gc_id'];
- $insert['gc_id_1'] = $update_common['gc_id_1'];
- $insert['gc_id_2'] = $update_common['gc_id_2'];
- $insert['gc_id_3'] = $update_common['gc_id_3'];
- $insert['brand_id'] = $update_common['brand_id'];
- $insert['goods_price'] = $value['price'];
- $insert['goods_promotion_price'] = $value['price'];
- $insert['goods_marketprice'] = $value['marketprice'] == 0 ? $update_common['goods_marketprice'] : $value['marketprice'];
- $insert['goods_serial'] = $value['sku'];
- $insert['goods_storage_alarm'] = intval($value['alarm']);
- $insert['goods_spec'] = serialize($value['sp_value']);
- $insert['goods_storage'] = $value['stock'];
- $insert['goods_weight'] = $value['goods_weight'];
- $insert['goods_image'] = $update_common['goods_image'];
- $insert['goods_state'] = $update_common['goods_state'];
- $insert['goods_verify'] = $update_common['goods_verify'];
- $insert['goods_addtime'] = TIMESTAMP;
- $insert['goods_edittime'] = TIMESTAMP;
- $insert['areaid_1'] = $update_common['areaid_1'];
- $insert['areaid_2'] = $update_common['areaid_2'];
- $insert['color_id'] = isset($value['color']) ? intval($value['color']) : '';
- $insert['transport_id'] = $update_common['transport_id'];
- $insert['goods_freight'] = $update_common['goods_freight'];
- $insert['goods_vat'] = $update_common['goods_vat'];
- $insert['goods_commend'] = $update_common['goods_commend'];
- $insert['goods_stcids'] = $update_common['goods_stcids'];
- $insert['is_virtual'] = $update_common['is_virtual'];
- $insert['virtual_indate'] = $update_common['virtual_indate'];
- $insert['virtual_limit'] = $update_common['virtual_limit'];
- $insert['virtual_invalid_refund'] = $update_common['virtual_invalid_refund'];
- $insert['is_goodsfcode'] = $update_common['is_goodsfcode'];
- $insert['is_appoint'] = $update_common['is_appoint'];
- $insert['is_platform_store'] = $update_common['is_platform_store'];
- switch ($update_common['virtual_type']) {
- case 1:
- $insert['virtual_content'] = $value['vc_card'];
- $card_list = explode("\r\n", $insert['virtual_content']);
- $insert['goods_storage'] = count($card_list);
- break;
- case 2:
- $insert['virtual_content'] = $value['vc_pan'];
- $insert['goods_storage'] = 1;
- break;
- case 3:
- $insert['virtual_content'] = $value['vc_file'];
- $insert['goods_storage'] = 1;
- break;
- default:
- $insert['virtual_content'] = '';
- }
- $goods_id = $goods_model->addGoods($insert);
- }
- $goodsid_array[] = intval($goods_id);
- $colorid_array[] = isset($value['color']) ? intval($value['color']) : '';
- $type_model->addGoodsType($goods_id, $common_id, array('cate_id' => input('post.cate_id'), 'type_id' => input('post.type_id'), 'attr' => input('post.attr/a')));
- }
- } else {
- $goods_info = $goods_model->getGoodsInfo(array('goods_spec' => serialize(null), 'goods_commonid' => $common_id, 'store_id' => session('store_id')), 'goods_id');
- if (!empty($goods_info)) {
- $goods_id = $goods_info['goods_id'];
- $update = array();
- $update['goods_commonid'] = $common_id;
- $update['goods_name'] = $update_common['goods_name'];
- $update['goods_advword'] = $update_common['goods_advword'];
- $update['store_id'] = session('store_id');
- $update['store_name'] = session('store_name');
- $update['gc_id'] = $update_common['gc_id'];
- $update['gc_id_1'] = $update_common['gc_id_1'];
- $update['gc_id_2'] = $update_common['gc_id_2'];
- $update['gc_id_3'] = $update_common['gc_id_3'];
- $update['brand_id'] = $update_common['brand_id'];
- $update['goods_price'] = $update_common['goods_price'];
- $update['goods_marketprice'] = $update_common['goods_marketprice'];
- $update['goods_serial'] = $update_common['goods_serial'];
- $update['goods_storage_alarm'] = $update_common['goods_storage_alarm'];
- $update['goods_spec'] = serialize(null);
- $update['goods_storage'] = intval(input('post.g_storage'));
- $update['goods_weight'] = floatval(input('post.goods_weight'));
- $update['goods_state'] = $update_common['goods_state'];
- $update['goods_verify'] = $update_common['goods_verify'];
- $update['goods_edittime'] = TIMESTAMP;
- $update['areaid_1'] = $update_common['areaid_1'];
- $update['areaid_2'] = $update_common['areaid_2'];
- $update['color_id'] = 0;
- $update['transport_id'] = $update_common['transport_id'];
- $update['goods_freight'] = $update_common['goods_freight'];
- $update['goods_vat'] = $update_common['goods_vat'];
- $update['goods_commend'] = $update_common['goods_commend'];
- $update['goods_stcids'] = $update_common['goods_stcids'];
- $update['is_virtual'] = $update_common['is_virtual'];
- $update['virtual_indate'] = $update_common['virtual_indate'];
- $update['virtual_limit'] = $update_common['virtual_limit'];
- $update['virtual_invalid_refund'] = $update_common['virtual_invalid_refund'];
- $update['is_goodsfcode'] = $update_common['is_goodsfcode'];
- $update['is_appoint'] = $update_common['is_appoint'];
- switch ($update_common['virtual_type']) {
- case 1:
- $update['virtual_content'] = input('post.vc_card');
- $res = $goods_model->getAvailableGoodsCard(array_merge($update, array('goods_id' => $goods_info['goods_id'])));
- if ($res['code']) {
- $update['goods_storage'] = $res['data']['card_num'];
- } else {
- $update['goods_storage'] = 0;
- }
- break;
- case 2:
- $update['virtual_content'] = input('post.vc_pan');
- $update['goods_storage'] = 1;
- break;
- case 3:
- $update['virtual_content'] = input('post.vc_file');
- $update['goods_storage'] = 1;
- break;
- default:
- $update['virtual_content'] = '';
- }
- if ($update_common['is_virtual'] == 1) {
- $update['is_have_gift'] = 0;
- $goodsgift_model->delGoodsgift(array('goods_id' => $goods_id));
- }
- $update['is_platform_store'] = $update_common['is_platform_store'];
- $goods_model->editGoodsById($update, $goods_id);
- } else {
- $insert = array();
- $insert['goods_commonid'] = $common_id;
- $insert['goods_name'] = $update_common['goods_name'];
- $insert['goods_advword'] = $update_common['goods_advword'];
- $insert['store_id'] = session('store_id');
- $insert['store_name'] = session('store_name');
- $insert['gc_id'] = $update_common['gc_id'];
- $insert['gc_id_1'] = $update_common['gc_id_1'];
- $insert['gc_id_2'] = $update_common['gc_id_2'];
- $insert['gc_id_3'] = $update_common['gc_id_3'];
- $insert['brand_id'] = $update_common['brand_id'];
- $insert['goods_price'] = $update_common['goods_price'];
- $insert['goods_promotion_price'] = $update_common['goods_price'];
- $insert['goods_marketprice'] = $update_common['goods_marketprice'];
- $insert['goods_serial'] = $update_common['goods_serial'];
- $insert['goods_storage_alarm'] = $update_common['goods_storage_alarm'];
- $insert['goods_spec'] = serialize(null);
- $insert['goods_storage'] = intval(input('post.g_storage'));
- $insert['goods_weight'] = floatval(input('post.goods_weight'));
- $insert['goods_image'] = $update_common['goods_image'];
- $insert['goods_state'] = $update_common['goods_state'];
- $insert['goods_verify'] = $update_common['goods_verify'];
- $insert['goods_addtime'] = TIMESTAMP;
- $insert['goods_edittime'] = TIMESTAMP;
- $insert['areaid_1'] = $update_common['areaid_1'];
- $insert['areaid_2'] = $update_common['areaid_2'];
- $insert['color_id'] = 0;
- $insert['transport_id'] = $update_common['transport_id'];
- $insert['goods_freight'] = $update_common['goods_freight'];
- $insert['goods_vat'] = $update_common['goods_vat'];
- $insert['goods_commend'] = $update_common['goods_commend'];
- $insert['goods_stcids'] = $update_common['goods_stcids'];
- $insert['is_virtual'] = $update_common['is_virtual'];
- $insert['virtual_indate'] = $update_common['virtual_indate'];
- $insert['virtual_limit'] = $update_common['virtual_limit'];
- $insert['virtual_invalid_refund'] = $update_common['virtual_invalid_refund'];
- $insert['is_goodsfcode'] = $update_common['is_goodsfcode'];
- $insert['is_appoint'] = $update_common['is_appoint'];
- $insert['is_platform_store'] = $update_common['is_platform_store'];
- switch ($update_common['virtual_type']) {
- case 1:
- $insert['virtual_content'] = input('post.vc_card');
- $card_list = explode("\r\n", $insert['virtual_content']);
- $insert['goods_storage'] = count($card_list);
- break;
- case 2:
- $insert['virtual_content'] = input('post.vc_pan');
- $insert['goods_storage'] = 1;
- break;
- case 3:
- $insert['virtual_content'] = input('post.vc_file');
- $insert['goods_storage'] = 1;
- break;
- default:
- $insert['virtual_content'] = '';
- }
- $goods_id = $goods_model->addGoods($insert);
- }
- $goodsid_array[] = intval($goods_id);
- $colorid_array[] = 0;
- $type_model->addGoodsType($goods_id, $common_id, array('cate_id' => input('post.cate_id'), 'type_id' => input('post.type_id'), 'attr' => input('post.attr/a')));
- }
- // 清理商品数据
- $condition_goods = array();
- $condition_goods[] = array('goods_id', 'not in', $goodsid_array);
- $condition_goods[] = array('goods_commonid', '=', $common_id);
- $condition_goods[] = array('store_id', '=', session('store_id'));
- $goods_model->delGoods($condition_goods);
- // 清理商品图片表
- $colorid_array = array_unique($colorid_array);
- $condition_goodsimages = array();
- $condition_goodsimages[] = array('goods_commonid', '=', $common_id);
- $condition_goodsimages[] = array('color_id', 'not in', $colorid_array);
- $goods_model->delGoodsImages($condition_goodsimages);
- // 更新商品默认主图
- $default_image_list = $goods_model->getGoodsImageList(array('goods_commonid' => $common_id, 'goodsimage_isdefault' => 1), 'color_id,goodsimage_url');
- if (!empty($default_image_list)) {
- foreach ($default_image_list as $val) {
- $goods_model->editGoods(array('goods_image' => $val['goodsimage_url']), array('goods_commonid' => $common_id, 'color_id' => $val['color_id']));
- }
- }
- // 商品加入上架队列
- if (!empty(input('post.starttime'))) {
- $selltime = strtotime(input('post.starttime')) + intval(input('post.starttime_H')) * 3600 + intval(input('post.starttime_i')) * 60;
- if ($selltime > TIMESTAMP) {
- $this->addcron(array('cron_exetime' => $selltime, 'cron_value' => serialize(intval($common_id)), 'cron_type' => 'editProducesOnline'), true);
- }
- }
- // 添加操作日志
- $this->recordSellerlog('编辑商品,平台货号:' . $common_id);
- if ($update_common['is_virtual'] == 1 || $update_common['is_goodsfcode'] == 1) {
- // 如果是特殊商品清理促销活动,抢购、秒杀、组合销售
- model('cron')->addCron(array('cron_exetime' => TIMESTAMP, 'cron_type' => 'clearSpecialGoodsPromotion', 'cron_value' => serialize(array('goods_commonid' => $common_id, 'goodsid_array' => $goodsid_array))));
- } else {
- // 更新商品促销价格
- model('cron')->addCron(array('cron_exetime' => TIMESTAMP, 'cron_type' => 'updateGoodsPromotionPriceByGoodsCommonId', 'cron_value' => serialize($common_id)));
- }
- // 生成F码
- if ($update_common['is_goodsfcode'] == 1) {
- model('goodsfcode')->createGoodsfcode(array('goods_commonid' => $common_id, 'goodsfcode_count' => intval(input('post.g_fccount')), 'goodsfcode_prefix' => input('post.g_fcprefix')));
- }
- $return = $goods_model->editGoodsCommon($update_common, array('goods_commonid' => $common_id, 'store_id' => session('store_id')));
- } catch (\Exception $e) {
- Db::rollback();
- ds_json_encode(10001, $e->getMessage());
- }
- Db::commit();
- ds_json_encode(10000, lang('ds_common_op_succ'));
- }
- /**
- * 编辑图片
- */
- public function edit_image()
- {
- $common_id = intval(input('param.commonid'));
- if ($common_id <= 0) {
- $this->error(lang('param_error'), (string) url('Seller/index'));
- }
- $goods_model = model('goods');
- $common_list = $goods_model->getGoodsCommonInfoByID($common_id);
- if ($common_list['store_id'] != session('store_id') || $common_list['goods_lock'] == 1) {
- $this->error(lang('goods_not_exist_or_lock'), (string) url('Seller/index'));
- }
- $spec_value = unserialize($common_list['spec_value']);
- if (isset($spec_value[1])) {
- View::assign('spec_value', $spec_value);
- } else {
- View::assign('spec_value', null);
- }
- $image_list = $goods_model->getGoodsImageList(array('goods_commonid' => $common_id));
- $image_list = array_under_reset($image_list, 'color_id', 2);
- $img_array = $goods_model->getGoodsList(array('goods_commonid' => $common_id), '*', 'color_id');
- // 整理,更具id查询颜色名称
- if (!empty($img_array)) {
- foreach ($img_array as $val) {
- if (isset($image_list[$val['color_id']])) {
- $image_array[$val['color_id']] = $image_list[$val['color_id']];
- } else {
- $image_array[$val['color_id']][0]['goodsimage_url'] = isset($val['goodsimage_url']) ? $val['goodsimage_url'] : '';
- $image_array[$val['color_id']][0]['goodsimage_sort'] = 0;
- $image_array[$val['color_id']][0]['goodsimage_isdefault'] = 1;
- }
- $colorid_array[] = $val['color_id'];
- }
- }
- View::assign('img', $image_array);
- $spec_model = model('spec');
- $value_array = $spec_model->getSpecvalueList(array(array('spvalue_id', 'in', $colorid_array), array('store_id', '=', session('store_id'))), 'spvalue_id,spvalue_name');
- if (empty($value_array)) {
- $value_array[] = array('spvalue_id' => '0', 'spvalue_name' => lang('no_color'));
- }
- View::assign('value_array', $value_array);
- View::assign('commonid', $common_id);
- /* 设置卖家当前菜单 */
- $this->setSellerCurMenu('sellergoodsonline');
- $this->setSellerCurItem('edit_image');
- View::assign('edit_goods_sign', true);
- return View::fetch($this->template_dir . 'store_goods_add_step3');
- }
- /**
- * 保存商品图片
- */
- public function edit_save_image()
- {
- if (request()->isPost()) {
- $common_id = intval(input('param.commonid'));
- $img_array = input('post.img/a'); #获取数组
- if ($common_id <= 0 || empty($img_array)) {
- ds_json_encode(10001, lang('param_error'));
- }
- $goods_model = model('goods');
- // 删除原有图片信息
- $goods_model->delGoodsImages(array('goods_commonid' => $common_id, 'store_id' => session('store_id')));
- // 保存
- $insert_array = array();
- foreach ($img_array as $key => $value) {
- $k = 0;
- foreach ($value as $v) {
- if ($v['name'] == '') {
- continue;
- }
- // 商品默认主图
- $update_array = array(); // 更新商品主图
- $update_where = array();
- $update_array['goods_image'] = $v['name'];
- $update_where['goods_commonid'] = $common_id;
- $update_where['store_id'] = session('store_id');
- $update_where['color_id'] = $key;
- if ($k == 0 || $v['default'] == 1) {
- $k++;
- $update_array['goods_image'] = $v['name'];
- $update_where['goods_commonid'] = $common_id;
- $update_where['store_id'] = session('store_id');
- $update_where['color_id'] = $key;
- // 更新商品主图
- $goods_model->editGoods($update_array, $update_where);
- }
- $tmp_insert = array();
- $tmp_insert['goods_commonid'] = $common_id;
- $tmp_insert['store_id'] = session('store_id');
- $tmp_insert['color_id'] = $key;
- $tmp_insert['goodsimage_url'] = $v['name'];
- $tmp_insert['goodsimage_sort'] = ($v['default'] == 1) ? 0 : intval($v['sort']);
- $tmp_insert['goodsimage_isdefault'] = $v['default'];
- $insert_array[] = $tmp_insert;
- }
- }
- if (!empty($insert_array)) {
- $rs = $goods_model->addGoodsImagesAll($insert_array);
- if ($rs) {
- // 添加操作日志
- $this->recordSellerlog('编辑商品,平台货号:' . $common_id);
- ds_json_encode(10000, lang('ds_common_op_succ'));
- } else {
- ds_json_encode(10001, lang('ds_common_save_fail'));
- }
- } else {
- ds_json_encode(10000, lang('ds_common_op_succ'));
- }
- }
- }
- /**
- * 编辑分类
- */
- public function edit_class()
- {
- // 实例化商品分类模型
- $goodsclass_model = model('goodsclass');
- // 商品分类
- $goods_class = $goodsclass_model->getGoodsclass(session('store_id'));
- // 常用商品分类
- $staple_model = model('goodsclassstaple');
- $param_array = array();
- $param_array['member_id'] = session('member_id');
- $staple_array = $staple_model->getGoodsclassstapleList($param_array);
- View::assign('staple_array', $staple_array);
- View::assign('goods_class', $goods_class);
- View::assign('commonid', input('param.commonid'));
- /* 设置卖家当前菜单 */
- $this->setSellerCurMenu('sellergoodsonline');
- $this->setSellerCurItem('edit_class');
- View::assign('edit_goods_sign', true);
- return View::fetch($this->template_dir . 'store_goods_add_step1');
- }
- /**
- * 删除商品
- */
- public function drop_goods()
- {
- $commonid = input('param.commonid');
- $common_id = $this->checkRequestCommonId($commonid);
- $commonid_array = explode(',', $common_id);
- $goods_model = model('goods');
- $where = array();
- $where[] = array('goods_commonid', 'in', $commonid_array);
- $where[] = array('store_id', '=', session('store_id'));
- $return = $goods_model->delGoodsNoLock($where);
- if ($return) {
- // 添加操作日志
- $this->recordSellerlog('删除商品,平台货号:' . $common_id);
- ds_json_encode(10000, lang('store_goods_index_goods_del_success'));
- } else {
- ds_json_encode(10001, lang('store_goods_index_goods_del_fail'));
- }
- }
- /**
- * 商品下架
- */
- public function goods_unshow()
- {
- $common_id = $this->checkRequestCommonId(input('param.commonid'));
- $commonid_array = explode(',', $common_id);
- $goods_model = model('goods');
- $where = array();
- $where[] = array('goods_commonid', 'in', $commonid_array);
- $where[] = array('store_id', '=', session('store_id'));
- $return = model('goods')->editProducesOffline($where);
- if ($return) {
- // 更新优惠套餐状态关闭
- $goods_list = $goods_model->getGoodsList($where, 'goods_id');
- if (!empty($goods_list)) {
- $goodsid_array = array();
- foreach ($goods_list as $val) {
- $goodsid_array[] = $val['goods_id'];
- }
- model('pbundling')->editBundlingCloseByGoodsIds(array(array('goods_id', 'in', $goodsid_array)));
- }
- // 添加操作日志
- $this->recordSellerlog('商品下架,平台货号:' . $common_id);
- ds_json_encode(10000, lang('store_goods_index_goods_unshow_success'));
- } else {
- ds_json_encode(10001, lang('store_goods_index_goods_unshow_fail'));
- }
- }
- /**
- * 设置排序
- */
- public function edit_sort()
- {
- $common_id = $this->checkRequestCommonId(input('param.commonid'));
- if (request()->isPost()) {
- $goods_sort = input('param.g_sort');
- $res1 = model('goods')->editGoodsCommonById(['goods_sort' => $goods_sort], array($common_id));
- $res2 = model('goods')->editGoods(['goods_sort' => $goods_sort], ['goods_commonid' => $common_id]);
- if ($res1 && $res2) {
- // 添加操作日志
- $this->recordSellerlog('设置排序,平台货号:' . $common_id);
- ds_json_encode(10000, lang('ds_common_op_succ'));
- } else {
- ds_json_encode(10001, lang('ds_common_op_fail'));
- }
- }
- return View::fetch($this->template_dir . 'edit_sort');
- }
- /**
- * 设置广告词
- */
- public function edit_jingle()
- {
- if (request()->isPost()) {
- $common_id = $this->checkRequestCommonId(input('param.commonid'));
- $commonid_array = explode(',', $common_id);
- $where = array(array('goods_commonid', 'in', $commonid_array), array('store_id', '=', session('store_id')));
- $update = array('goods_advword' => trim(input('post.g_jingle')));
- $return = model('goods')->editProducesNoLock($where, $update);
- if ($return) {
- // 添加操作日志
- $this->recordSellerlog('设置广告词,平台货号:' . $common_id);
- ds_json_encode(10000, lang('ds_common_op_succ'));
- } else {
- ds_json_encode(10001, lang('ds_common_op_fail'));
- }
- }
- $common_id = $this->checkRequestCommonId(input('param.commonid'));
- return View::fetch($this->template_dir . 'edit_jingle');
- }
- /**
- * 编辑库存
- */
- public function edit_storage()
- {
- $common_id = intval(input('param.commonid'));
- if (!$common_id) {
- ds_json_encode(10001, lang('param_error'));
- }
- $goods_model = model('goods');
- $goodscommon_info = $goods_model->getGoodsCommonInfoByID($common_id);
- if (empty($goodscommon_info) || $goodscommon_info['store_id'] != session('store_id')) {
- ds_json_encode(10001, '您的商品不存在,或商品已被锁定,请联系管理员删除促销解除锁定');
- }
- if (request()->isPost()) {
- Db::startTrans();
- try {
- $spec = input('param.spec/a');
- $min_item = array();
- foreach ($spec as $goods_id => $val) {
- $data = array(
- 'goods_weight' => abs(intval($val['goods_weight'])),
- 'goods_storage' => abs(intval($val['stock'])),
- 'goods_storage_alarm' => abs(intval($val['alarm'])),
- 'goods_serial' => $val['sku'],
- );
- if (!$goodscommon_info['goods_lock']) {
- $data['goods_marketprice'] = abs(floatval($val['marketprice']));
- $data['goods_price'] = abs(floatval($val['price']));
- $data['goods_promotion_price'] = abs(floatval($val['price']));
- if ($data['goods_price'] == 0) {
- throw new \think\Exception(lang('prompt_information4'), 10006);
- }
- if ($data['goods_marketprice'] > 0 && $data['goods_price'] > $data['goods_marketprice']) {
- throw new \think\Exception(lang('not_higher_than'), 10006);
- }
- if (empty($min_item) || $min_item['goods_price'] > $data['goods_price']) {
- $min_item = $data;
- }
- }
- $goods_model->editGoods($data, array('goods_commonid' => $common_id, 'goods_id' => $goods_id, 'store_id' => session('store_id')));
- }
- //最低价格
- if (!empty($min_item)) {
- $goods_model->editGoodsCommon(array('goods_discount' => $min_item['goods_marketprice'] > 0 ? intval($min_item['goods_price'] / $min_item['goods_marketprice'] * 100) : 0, 'goods_marketprice' => $min_item['goods_marketprice'], 'goods_price' => $min_item['goods_price']), array('goods_commonid' => $common_id, 'store_id' => session('store_id')));
- }
- } catch (\Exception $e) {
- Db::rollback();
- ds_json_encode(10001, $e->getMessage());
- }
- Db::commit();
- ds_json_encode(10000, lang('ds_common_op_succ'));
- } else {
- View::assign('goodscommon_info', $goodscommon_info);
- $goods_list = $goods_model->getGoodsList(array('goods_commonid' => $common_id, 'store_id' => session('store_id')));
- View::assign('goods_list', $goods_list);
- return View::fetch($this->template_dir . 'edit_storage');
- }
- }
- /**
- * 设置关联版式
- */
- public function edit_plate()
- {
- if (request()->isPost()) {
- $common_id = $this->checkRequestCommonId(input('post.commonid'));
- $commonid_array = explode(',', $common_id);
- $where = array(array('goods_commonid', 'in', $commonid_array), array('store_id', '=', session('store_id')));
- $update = array();
- $update['plateid_top'] = intval(input('post.plate_top')) > 0 ? intval(input('post.plate_top')) : '';
- $update['plateid_bottom'] = intval(input('post.plate_bottom')) > 0 ? intval(input('post.plate_bottom')) : '';
- $return = model('goods')->editGoodsCommon($update, $where);
- if ($return) {
- // 添加操作日志
- $this->recordSellerlog('设置关联版式,平台货号:' . $common_id);
- ds_json_encode(10000, lang('ds_common_op_succ'));
- } else {
- ds_json_encode(10001, lang('ds_common_op_fail'));
- }
- } else {
- $common_id = $this->checkRequestCommonId(input('param.commonid'));
- $plateid_bottom = Db::name('goodscommon')->where(array('goods_commonid' => $common_id))->field('plateid_bottom,plateid_top')->find();
- View::assign('plateid', $plateid_bottom);
- // 关联版式
- $plate_list = model('storeplate')->getStoreplateList(array('store_id' => session('store_id')), 'storeplate_id,storeplate_name,storeplate_position');
- $plate_list = array_under_reset($plate_list, 'storeplate_position', 2);
- View::assign('plate_list', $plate_list);
- return View::fetch($this->template_dir . 'edit_plate');
- }
- }
- /**
- * 添加赠品
- */
- public function add_gift()
- {
- $common_id = intval(input('param.commonid'));
- if ($common_id <= 0) {
- $this->error(lang('param_error'), (string) url('Seller/index'));
- }
- $goods_model = model('goods');
- $goodscommon_info = $goods_model->getGoodsCommonInfoByID($common_id);
- if (empty($goodscommon_info) || $goodscommon_info['store_id'] != session('store_id')) {
- $this->error(lang('param_error'), (string) url('Seller/index'));
- }
- // 商品列表
- $goods_array = $goods_model->getGoodsListForPromotion(array(array('goods_commonid', '=', $common_id)), '*', 0, 'gift');
- View::assign('goods_array', $goods_array);
- // 赠品列表
- $gift_list = model('goodsgift')->getGoodsgiftList(array('goods_commonid' => $common_id));
- $gift_array = array();
- if (!empty($gift_list)) {
- foreach ($gift_list as $val) {
- $gift_array[$val['goods_id']][] = $val;
- }
- }
- View::assign('gift_array', $gift_array);
- /* 设置卖家当前菜单 */
- $this->setSellerCurMenu('sellergoodsonline');
- $this->setSellerCurItem('add_gift');
- return View::fetch($this->template_dir . 'store_goods_edit_add_gift');
- }
- /**
- * 保存赠品
- */
- public function save_gift()
- {
- if (!request()->isPost()) {
- ds_json_encode(10001, lang('param_error'));
- }
- $gift_array = input('post.gift/a', array());
- $commonid = intval(input('param.commonid'));
- if ($commonid <= 0) {
- ds_json_encode(10001, lang('param_error'));
- }
- $goods_model = model('goods');
- $goodsgift_model = model('goodsgift');
- // 验证商品是否存在
- $goods_list = $goods_model->getGoodsListForPromotion(array(array('goods_commonid', '=', $commonid), array('store_id', '=', session('store_id'))), 'goods_id', 0, 'gift');
- if (empty($goods_list)) {
- ds_json_encode(10001, lang('param_error'));
- }
- // 删除该商品原有赠品
- $goodsgift_model->delGoodsgift(array('goods_commonid' => $commonid));
- // 重置商品礼品标记
- $goods_model->editGoods(array('is_have_gift' => 0), array('goods_commonid' => $commonid));
- // 商品id
- $goodsid_array = array();
- foreach ($goods_list as $val) {
- $goodsid_array[] = $val['goods_id'];
- }
- $insert = array();
- $update_goodsid = array();
- foreach ($gift_array as $key => $val) {
- $owner_gid = intval($key); // 主商品id
- // 验证主商品是否为本店铺商品,如果不是本店商品继续下一个循环
- if (!in_array($owner_gid, $goodsid_array)) {
- continue;
- }
- $update_goodsid[] = $owner_gid;
- foreach ($val as $k => $v) {
- $gift_gid = intval($k); // 礼品id
- // 验证赠品是否为本店铺商品,如果不是本店商品继续下一个循环
- $gift_info = $goods_model->getGoodsInfoByID($gift_gid);
- $is_general = $goods_model->checkIsGeneral($gift_info); // 验证是否为普通商品
- if ($gift_info['store_id'] != session('store_id') || $is_general == false) {
- continue;
- }
- $array = array();
- $array['goods_id'] = $owner_gid;
- $array['goods_commonid'] = $commonid;
- $array['gift_goodsid'] = $gift_gid;
- $array['gift_goodsname'] = $gift_info['goods_name'];
- $array['gift_goodsimage'] = $gift_info['goods_image'];
- $array['gift_amount'] = intval($v);
- $insert[] = $array;
- }
- }
- // 插入数据
- if (!empty($insert))
- $goodsgift_model->addGoodsgiftAll($insert);
- // 更新商品赠品标记
- if (!empty($update_goodsid)) {
- $goods_model->editGoodsById(array('is_have_gift' => 1), $update_goodsid);
- }
- ds_json_encode(10000, lang('ds_common_save_succ'));
- }
- /**
- * 推荐搭配
- */
- public function add_combo()
- {
- $common_id = intval(input('param.commonid'));
- if ($common_id <= 0) {
- $this->error(lang('param_error'), (string) url('Seller/index'));
- }
- $goods_model = model('goods');
- $goodscommon_info = $goods_model->getGoodsCommonInfoByID($common_id);
- if (empty($goodscommon_info) || $goodscommon_info['store_id'] != session('store_id')) {
- $this->error(lang('param_error'), (string) url('Seller/index'));
- }
- $goods_array = $goods_model->getGoodsListForPromotion(array(array('goods_commonid', '=', $common_id)), '*', 0, 'combo');
- View::assign('goods_array', $goods_array);
- // 推荐组合商品列表
- $combo_list = model('goodscombo')->getGoodscomboList(array('goods_commonid' => $common_id));
- $combo_goodsid_array = array();
- if (!empty($combo_list)) {
- foreach ($combo_list as $val) {
- $combo_goodsid_array[] = $val['combo_goodsid'];
- }
- }
- $combo_goods_array = $goods_model->getGeneralGoodsList(array(array('goods_id', 'in', $combo_goodsid_array)), 'goods_id,goods_name,goods_image,goods_price');
- $combo_goods_list = array();
- if (!empty($combo_goods_array)) {
- foreach ($combo_goods_array as $val) {
- $combo_goods_list[$val['goods_id']] = $val;
- }
- }
- $combo_array = array();
- foreach ($combo_list as $val) {
- $combo_array[$val['goods_id']][] = $combo_goods_list[$val['combo_goodsid']];
- }
- View::assign('combo_array', $combo_array);
- /* 设置卖家当前菜单 */
- $this->setSellerCurMenu('sellergoodsonline');
- $this->setSellerCurItem('add_combo');
- return View::fetch($this->template_dir . 'store_goods_edit_add_combo');
- }
- /**
- * 保存赠品
- */
- public function save_combo()
- {
- if (!request()->isPost()) {
- ds_json_encode(10001, lang('param_error'));
- }
- $combo_array = input('post.combo/a'); #获取数组
- $commonid = intval(input('param.commonid'));
- if ($commonid <= 0) {
- ds_json_encode(10001, lang('param_error'));
- }
- $goods_model = model('goods');
- $goodscombo_model = model('goodscombo');
- // 验证商品是否存在
- $goods_list = $goods_model->getGoodsListForPromotion(array(array('goods_commonid', '=', $commonid), array('store_id', '=', session('store_id'))), 'goods_id', 0, 'combo');
- if (empty($goods_list)) {
- ds_json_encode(10001, lang('param_error'));
- }
- // 删除该商品原有赠品
- $goodscombo_model->delGoodscombo(array('goods_commonid' => $commonid));
- // 商品id
- $goodsid_array = array();
- foreach ($goods_list as $val) {
- $goodsid_array[] = $val['goods_id'];
- }
- $insert = array();
- if (!empty($combo_array)) {
- foreach ($combo_array as $key => $val) {
- $owner_gid = intval($key); // 主商品id
- // 验证主商品是否为本店铺商品,如果不是本店商品继续下一个循环
- if (!in_array($owner_gid, $goodsid_array)) {
- continue;
- }
- $val = array_unique($val);
- foreach ($val as $v) {
- $combo_gid = intval($v); // 礼品id
- // 验证推荐组合商品是否为本店铺商品,如果不是本店商品继续下一个循环
- $combo_info = $goods_model->getGoodsInfoByID($combo_gid);
- $is_general = $goods_model->checkIsGeneral($combo_info); // 验证是否为普通商品
- if ($combo_info['store_id'] != session('store_id') || $is_general == false || $owner_gid == $combo_gid) {
- continue;
- }
- $array = array();
- $array['goods_id'] = $owner_gid;
- $array['goods_commonid'] = $commonid;
- $array['combo_goodsid'] = $combo_gid;
- $insert[] = $array;
- }
- }
- // 插入数据
- $goodscombo_model->addGoodscomboAll($insert);
- }
- ds_json_encode(10000, lang('ds_common_save_succ'));
- }
- /**
- * 搜索商品(添加赠品/推荐搭配)
- */
- public function search_goods()
- {
- $where = array();
- $where[] = array('store_id', '=', session('store_id'));
- $name = input('param.name');
- if ($name) {
- $where[] = array('goods_name', 'like', '%' . $name . '%');
- }
- $goods_model = model('goods');
- $goods_list = $goods_model->getGeneralGoodsList($where, '*', 5);
- View::assign('show_page', $goods_model->page_info->render());
- View::assign('goods_list', $goods_list);
- echo View::fetch($this->template_dir . 'store_goods_edit_search_goods');
- exit;
- }
- /**
- * 下载F码
- */
- public function download_f_code_excel()
- {
- $common_id = input('param.commonid');
- if ($common_id <= 0) {
- $this->error(lang('param_error'));
- }
- $common_info = model('goods')->getGoodsCommonInfoByID($common_id);
- if (empty($common_info) || $common_info['store_id'] != session('store_id')) {
- $this->error(lang('param_error'));
- }
- $excel_obj = new \excel\Excel();
- $excel_data = array();
- //设置样式
- $excel_obj->setStyle(array('id' => 's_title', 'Font' => array('FontName' => '宋体', 'Size' => '12', 'Bold' => '1')));
- //header
- $excel_data[0][] = array('styleid' => 's_title', 'data' => lang('goodsfcode_code'));
- $excel_data[0][] = array('styleid' => 's_title', 'data' => lang('goodsfcode_state'));
- $data = model('goodsfcode')->getGoodsfcodeList(array('goods_commonid' => $common_id));
- foreach ($data as $k => $v) {
- $tmp = array();
- $tmp[] = array('data' => $v['goodsfcode_code']);
- $tmp[] = array('data' => $v['goodsfcode_state'] ? lang('goodsfcode_state_1') : lang('goodsfcode_state_0'));
- $excel_data[] = $tmp;
- }
- $excel_data = $excel_obj->charset($excel_data, CHARSET);
- $excel_obj->addArray($excel_data);
- $excel_obj->addWorksheet($excel_obj->charset($common_info['goods_name'], CHARSET));
- $excel_obj->generateXML($excel_obj->charset($common_info['goods_name'], CHARSET) . '-' . date('Y-m-d-H', TIMESTAMP));
- }
- /**
- * 验证commonid
- */
- private function checkRequestCommonId($common_ids)
- {
- if (!preg_match('/^[\d,]+$/i', $common_ids)) {
- ds_json_encode(10001, lang('param_error'));
- }
- return $common_ids;
- }
- /**
- * ajax获取商品列表
- */
- public function get_goods_list_ajax()
- {
- $common_id = input('param.commonid');
- if ($common_id <= 0) {
- echo 'false';
- exit();
- }
- $goods_model = model('goods');
- $goodscommon_list = $goods_model->getGoodsCommonInfoByID($common_id);
- if (empty($goodscommon_list) || $goodscommon_list['store_id'] != session('store_id')) {
- echo 'false';
- exit();
- }
- $goods_list = $goods_model->getGoodsList(array('store_id' => session('store_id'), 'goods_commonid' => $common_id), 'goods_id,goods_spec,store_id,goods_price,goods_serial,goods_storage_alarm,goods_storage,goods_image');
- if (empty($goods_list)) {
- echo 'false';
- exit();
- }
- $spec_name = array_values((array) unserialize($goodscommon_list['spec_name']));
- foreach ($goods_list as $key => $val) {
- $goods_spec = array_values((array) unserialize($val['goods_spec']));
- $spec_array = array();
- foreach ($goods_spec as $k => $v) {
- $spec_array[] = '<div class="goods_spec">' . $spec_name[$k] . lang('ds_colon') . '<em title="' . $v . '">' . $v . '</em>' . '</div>';
- }
- $goods_list[$key]['goods_image'] = goods_thumb($val, '240');
- $goods_list[$key]['goods_spec'] = implode('', $spec_array);
- $goods_list[$key]['alarm'] = ($val['goods_storage_alarm'] != 0 && $val['goods_storage'] <= $val['goods_storage_alarm']) ? 'style="color:red;"' : '';
- $goods_list[$key]['url'] = (string) url('Goods/index', ['goods_id' => $val['goods_id']]);
- }
- echo json_encode($goods_list);
- }
- /**
- * 栏目菜单
- */
- function getSellerItemList()
- {
- $item_list = array(
- array(
- 'name' => 'goods_list',
- 'text' => lang('goods_on_sale'),
- 'url' => (string) url('Sellergoodsonline/index'),
- ),
- );
- if (request()->action() === 'edit_goods' || request()->action() === 'edit_image' || request()->action() === 'add_gift' || request()->action() === 'add_combo' || request()->action() === 'edit_class') {
- $item_list[] = array(
- 'name' => 'edit_goods',
- 'text' => lang('store_goods_index_edit_goods'),
- 'url' => (string) url('Sellergoodsonline/edit_goods', ['commonid' => input('param.commonid')]),
- );
- $item_list[] = array(
- 'name' => 'edit_image',
- 'text' => lang('edit_image'),
- 'url' => (string) url('Sellergoodsonline/edit_image', ['commonid' => input('param.commonid')]),
- );
- $item_list[] = array(
- 'name' => 'add_gift',
- 'text' => lang('add_gift'),
- 'url' => (string) url('Sellergoodsonline/add_gift', ['commonid' => input('param.commonid')]),
- );
- $item_list[] = array(
- 'name' => 'add_combo',
- 'text' => lang('add_combo'),
- 'url' => (string) url('Sellergoodsonline/add_combo', ['commonid' => input('param.commonid')]),
- );
- $item_list[] = array(
- 'name' => 'edit_class',
- 'text' => lang('edit_class'),
- 'url' => (string) url('Sellergoodsonline/edit_class', ['commonid' => input('param.commonid')]),
- );
- }
- return $item_list;
- }
- }
|