0) { $pagenum = I('pagenum/s'); } $this->assign('key_word', $key_word); $this->assign('isedit', $isedit); $this->assign('pagenum', $pagenum); $this->assign('cur_page', $getp); return $this->fetch(); } /** * 图库列表 */ public function ajaxmztklist() { $key_word = I('key_word') ? trim(I('key_word')) : ''; // 关键词搜索 $isedit = I('isedit') ? I('isedit') : '';//是否修改 $cur_page = 1;//当前页数 if ((int)I('p/s') > 0) { $cur_page = I('p/s'); } $pagenum = 10;//每页显示多少条 if ((int)I('pagenum/s') > 0) { $pagenum = I('pagenum/s'); } $where = ' 1 = 1 '; // 搜索条件 if ($isedit) { $is = $isedit - 1; $where = "$where and a.isedit= '$is'"; } if ($key_word) { $where = "$where and (a.goods_name like '%$key_word%' or a.sku like '%$key_word%' or a.goods_sn like '%$key_word%' or b.store_name like '%$key_word%')"; } $count = M('barcodegoods')->alias('a')->join('store b', 'a.store_id=b.store_id', 'left')->where($where)->count(); $Page = new AjaxPage($count, $pagenum); $show = $Page->show(); $goodsList = M('barcodegoods')->alias('a')->join('store b', 'a.store_id=b.store_id', 'left')->where($where)->field('a.*,b.store_name')->order('a.goods_id desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); foreach ($goodsList as $k => $v) { $res = M('goods')->where(['sku' => $v['sku'], 'is_enable' => 1])->find(); if (!empty($res)) { $goodsList[$k]['url'] = 'href="/Mobile/Goods/goodsInfo/stoid/' . $res['store_id'] . '/id/' . $res['goods_id'] . '.html" target="_blank"'; } else { $goodsList[$k]['url'] = 'href="javascript:void(0);"'; } } $this->assign('goodsList', $goodsList); $this->assign('page', $show);// 赋值分页输出 $this->assign('pager', $Page); $this->assign('pagenum', $pagenum); $oldurl = U('Manager/mztk/mztklist', array( "isedit" => $isedit, "key_word" => $key_word, "pagenum" => $pagenum, "p" => $cur_page, )); $this->assign('oldurl', urlencode($oldurl)); $this->assign('key_word', $key_word); $this->assign('isedit', $isedit); $this->assign('pagenum', $pagenum); $this->assign('cur_page', $cur_page); return $this->fetch(); } // 图库编辑 public function mztk_edit() { $oldurl = I('oldurl/s'); $sku = I('sku/s'); $id = I('bar_id/s'); $this->assign('sku', $sku); $this->assign('bar_id', $id); $this->assign('oldurl', $oldurl); $this->assign('pagenum', 10); return $this->fetch(); } // 图库编辑数据 public function ajaxmztkedit() { $sku = I('sku/s'); $key_word = I('key_word') ? trim(I('key_word')) : ''; // 关键词搜索 $cur_page = 1;//当前页数 if ((int)I('p/s') > 0) { $cur_page = I('p/s'); } $pagenum = 10;//每页显示多少条 if ((int)I('pagenum/s') > 0) { $pagenum = I('pagenum/s'); } $where = " a.sku = '$sku'"; // 搜索条件 if ($key_word) { $where = "$where and (a.goods_name like '%$key_word%' or a.goods_sn like '%$key_word%')"; } $count = M('goods')->alias('a')->where($where)->count(); $Page = new AjaxPage($count, $pagenum); $show = $Page->show(); $goodsList = M('goods')->alias('a')->join('store s', 'a.store_id=s.store_id')->where($where)->field('a.*,s.store_name')->limit($Page->firstRow . ',' . $Page->listRows)->select(); foreach ($goodsList as $k => $v) { $goodsList[$k]['url'] = 'href="/Mobile/Goods/goodsInfo/stoid/' . $v['store_id'] . '/id/' . $v['goods_id'] . '.html" target="_blank"'; } $this->assign('goodsList', $goodsList); $this->assign('page', $show);// 赋值分页输出 // $this->assign('pager', $Page); $this->assign('pagenum', $pagenum); $this->assign('key_word', $key_word); return $this->fetch(); } // 更改状态 public function change_enable() { $id = I('id'); $ed_id = I('ed_id', ''); $store=I('store'); $html = I('html'); $name = M('admin')->where('admin_id', getAdminId())->field('ERPName')->find()['ERPName']; $newgoodsinfo=M('goods')->where('goods_id', $id)->find(); if ($newgoodsinfo) { $data['original_img'] = $newgoodsinfo['original_img']; } $bar_id = I('bar_id'); $data['goods_content'] = $html; $data['isedit'] = 1; $data['store_id'] = $store; $data['edit_man'] = $name; $data['edit_time'] = time(); $data['edit_ip'] = getIP(); M('goods')->where('goods_id', $id)->update(['is_enable' => 1]); M('barcodegoods')->where('goods_id', $bar_id)->update($data); if (!empty($ed_id)) { M('goods')->where('goods_id', $ed_id)->update(['is_enable' => 0]); } return json(['msg' => '操作成功']); } // 删除图库 public function delmztk() { $id = trim(I('id')); M('barcodegoods')->where('goods_id', $id)->delete(); M('barcodegoods_images')->where('goods_id', $id)->delete(); return json(['msg' => '操作成功']); } }