isAjax()) { $page_index = input('page', 1); $page_size = input('page_size', PAGE_LIST_ROWS); $search_text = input('search_text', ""); $search_text_type = input('search_text_type', "goods_name"); $goods_state = input('goods_state', ""); $verify_state = input('verify_state', ""); $category_id = input('category_id', ""); $brand_id = input('goods_brand', ''); $goods_attr_class = input("goods_attr_class", ""); $site_id = input("site_id", ""); $goods_class = input('goods_class', ""); $condition = []; if (!empty($search_text)) { $condition[] = [ $search_text_type, 'like', '%' . $search_text . '%' ]; } if ($goods_class !== "") { $condition[] = [ 'goods_class', '=', $goods_class ]; } if ($goods_state !== '') { $condition[] = [ 'goods_state', '=', $goods_state ]; } if ($verify_state !== '') { $condition[] = [ 'verify_state', '=', $verify_state ]; } if (!empty($category_id)) { $condition[] = [ 'category_id|category_id_1|category_id_2|category_id_3', '=', $category_id ]; } if ($brand_id) { $condition[] = [ 'brand_id', '=', $brand_id ]; } if ($goods_attr_class) { $condition[] = [ 'goods_attr_class', '=', $goods_attr_class ]; } if (!empty($site_id)) { $condition[] = [ 'site_id', '=', $site_id ]; } $res = $goods_model->getGoodsPageList($condition, $page_index, $page_size); return $res; } else { $verify_state = $goods_model->getVerifyState(); $arr = []; foreach ($verify_state as $k => $v) { // 过滤已审核状态 if ($k != 1) { $total = $goods_model->getGoodsTotalCount([ [ 'verify_state', '=', $k ] ]); $total = $total['data']; $arr[] = [ 'state' => $k, 'value' => $v, 'count' => $total ]; } } $verify_state = $arr; $this->assign("verify_state", $verify_state); return $this->fetch('goods/lists'); } } /** * 刷新审核状态商品数量 */ public function refreshVerifyStateCount() { if (request()->isAjax()) { $goods_model = new GoodsModel(); $verify_state = $goods_model->getVerifyState(); $arr = []; foreach ($verify_state as $k => $v) { // 过滤已审核状态 if ($k != 1) { $total = $goods_model->getGoodsTotalCount([ [ 'verify_state', '=', $k ] ]); $total = $total['data']; $arr[] = [ 'state' => $k, 'value' => $v, 'count' => $total ]; } } $verify_state = $arr; return $verify_state; } } /** * 获取SKU商品列表 * @return \multitype */ public function getGoodsSkuList() { if (request()->isAjax()) { $goods_id = input("goods_id", 0); $goods_model = new GoodsModel(); $res = $goods_model->getGoodsSkuList([ [ 'goods_id', '=', $goods_id ] ], 'sku_id,sku_name,price,stock,sale_num,sku_image,spec_name'); return $res; } } /******************************* 违规下架商品列表及相关操作 ***************************/ /** * 违规下架 */ public function lockup() { if (request()->isAjax()) { $verify_state_remark = input("verify_state_remark", 0); $goods_ids = input("goods_ids", 0); $goods_model = new GoodsModel(); $res = $goods_model->lockup([ [ 'goods_id', 'in', $goods_ids ] ], $verify_state_remark,$goods_ids); $this->addLog("商品违规下架id:" . $goods_ids . "原因:" . $verify_state_remark); return $res; } } /** * 获取商品违规或审核失败说明 * @return \multitype */ public function getVerifyStateRemark() { if (request()->isAjax()) { $goods_id = input("goods_id", 0); $goods_model = new GoodsModel(); $res = $goods_model->getGoodsInfo([ [ 'goods_id', '=', $goods_id ], [ 'verify_state', 'in', [ -2, 10 ] ] ], 'verify_state_remark'); return $res; } } /******************************* 待审核商品列表及相关操作 ***************************/ /** * 商品审核 */ public function verifyOn() { if (request()->isAjax()) { $goods_ids = input("goods_ids", 0); $verify_state = input("verify_state", -2); $verify_state_remark = input("verify_state_remark", ''); $goods_model = new GoodsModel(); $res = $goods_model->modifyVerifyState($goods_ids, $verify_state, $verify_state_remark); return $res; } } /** * 审核设置 */ public function verifyConfig() { if (request()->isAjax()) { $is_open = input("is_open", 0); $data = [ 'is_open' => $is_open ]; $goods_config = new GoodsConfigModel(); $res = $goods_config->setVerifyConfig($data); return $res; } else { $goods_config = new GoodsConfigModel(); $goods_verify_info = $goods_config->getVerifyConfig(); $goods_verify_info = $goods_verify_info['data']; $this->assign("goods_verify_info", $goods_verify_info['value']); return $this->fetch('goods/verify_config'); } } /******************************* 商品评价列表及相关操作 ***************************/ /** * 商品评价 */ public function evaluateList() { if (request()->isAjax()) { $page_index = input('page', 1); $page_size = input('limit', PAGE_LIST_ROWS); $site_id = input("site_id", ""); $explain_type = input('explain_type', ''); //1好评2中评3差评 $search_text = input('search_text', ""); $search_type = input('search_type', "sku_name"); $condition = []; //评分类型 if ($explain_type != "") { $condition[] = [ "explain_type", "=", $explain_type ]; } if (!empty($search_text)) { if (!empty($search_type)) { $condition[] = [ $search_type, 'like', '%' . $search_text . '%' ]; } else { $condition[] = [ 'sku_name', 'like', '%' . $search_text . '%' ]; } } if (!empty($site_id)) { $condition[] = [ 'site_id', '=', $site_id ]; } $evaluate_model = new GoodsEvaluate(); $res = $evaluate_model->getEvaluatePageList($condition, $page_index, $page_size); return $res; } else { return $this->fetch('goods/evaluate_list'); } } /** * 评价删除 */ public function deleteEvaluate() { if (request()->isAjax()) { $id = input('id', ''); $evaluate_model = new GoodsEvaluate(); $res = $evaluate_model->deleteEvaluate($id); $this->addLog("删除商品评价id:" . $id); return $res; } } /** * 商品推广 * return */ public function goodsUrl() { $goods_id = input('goods_id', ''); $goods_model = new GoodsModel(); $goods_sku_info = $goods_model->getGoodsSkuInfo([ [ 'goods_id', '=', $goods_id ] ], 'sku_id,goods_name'); $goods_sku_info = $goods_sku_info['data']; $res = $goods_model->qrcode($goods_sku_info['sku_id'], $goods_sku_info['goods_name']); return $res; } /** * 商品预览 * return */ public function goodsPreview() { $goods_id = input('goods_id', ''); $goods_model = new GoodsModel(); $goods_sku_info = $goods_model->getGoodsSkuInfo([ [ 'goods_id', '=', $goods_id ] ], 'sku_id,goods_name'); $goods_sku_info = $goods_sku_info['data']; $res = $goods_model->qrcode($goods_sku_info['sku_id'], $goods_sku_info['goods_name']); return $res; } }