order('ordid asc')->select(); $this->assign("typelist", $typelist); $this->assign('key_word', $key_word); $this->assign('pagenum', $pagenum); $this->assign('type', $type); $this->assign('cur_page', $cur_page); return $this->fetch(); } public function ajaximglist() { $type_id = I('type_id'); $key_word = I('key_word'); $key_word = I('key_word') ? trim(I('key_word')) : ''; // 关键词搜索 $cur_page = I('p/d', 0);//当前页数 if ($cur_page <= 0) { $cur_page = 1; } $pagenum = I('pagenum/d', 10); $where = " 1=1 "; if ($type_id) { $where .= " and a.type_id=" . $type_id; } if ($key_word) { $where .= " and a.title like '%$key_word%'"; } $model = M('qy_imglist'); $count = $model->alias('a')->join('qy_imgtype b', 'a.type_id=b.id', 'left') ->where($where)->count(); $Page = new AjaxPage($count, $pagenum); $show = $Page->show(); $List = $model->alias('a')->join('qy_imgtype b', 'a.type_id=b.id', 'left') ->where($where)->order("a.billdate desc") ->field('a.*,b.typename') ->limit($Page->firstRow . ',' . $Page->listRows)->select(); $oldurl = U('manager/Userqy/imglist', array( "key_word" => $key_word, "pagenum" => $pagenum, "p" => $cur_page, )); $this->assign('oldurl', urlencode($oldurl)); $this->assign('key_word', $key_word); $this->assign('pagenum', $pagenum); $this->assign('type_id', $type_id); $this->assign('cur_page', $cur_page); $this->assign('List', $List); $this->assign('page', $show);// 赋值分页输出 $this->assign('pager', $Page); return $this->fetch(); } public function addimg() { $typelist = M('qy_imgtype')->order('ordid asc')->select(); $this->assign("typelist", $typelist); $getId = I('id'); if ($getId) { $info = M('qy_imglist')->where(array('id' => $getId))->find(); if ($info) { } } else { $info["isshow"] = 1; } $this->assign("info", $info); return $this->fetch(); } //提交保存 public function imghandle() { $postdata = I('POST.'); $getId = $postdata['id']; if ($getId) { unset($postdata['id']); $mid = session('manager_id'); $rr = M("manager_admin")->where("manager_id", $mid)->find(); $postdata['editman'] = $rr['manager_name']; $postdata['editdate'] = time(); M('qy_imglist')->where(array('id' => $getId))->save($postdata); return json(['code' => 1]); } $postdata['billdate'] = time(); M('qy_imglist')->save($postdata); return json(['code' => 1]); //新增 } /** * 模板类型列表 * @return wxsendtype */ public function imgtype() { $model = M('qy_imgtype'); $list = array(); $pagenum = 20;//每页显示多少条 if ((int)I('pagenum/s') > 0) { $pagenum = I('pagenum/s'); } $keywords = I('keywords/s'); if ($keywords) { $where['typename'] = array(['like', '%' . $keywords . '%']);; } $count = $model->where($where)->count(); $Page = $pager = new Page($count, $pagenum); $list = $model->where($where)->limit($Page->firstRow . ',' . $Page->listRows)->order('ordid asc')->select(); $show = $Page->show(); $this->assign('keywords', $keywords); $this->assign('list', $list);// 赋值数据集 $this->assign('page', $show);// 赋值分页输出 $this->assign('pager', $pager); $this->assign('pagenum', $pagenum); $this->assign('oldurl', urlencode(curPageURL())); return $this->fetch(); } //添加微信模板 public function addimgtype() { $oldurl = I('oldurl/s'); if ($oldurl) { $oldurl = urldecode(urldecode($oldurl)); } $getstoid = getAdmStoId(); $id = I('id'); $wxsend = M('qy_imgtype')->where(array('id' => $id))->find(); if (empty($wxsend)) { $getmaxordid = 1; $maxordid = M('qy_imgtype')->max('ordid'); if ($maxordid) { $getmaxordid = $maxordid + 1; } $wxsend['ordid'] = $getmaxordid; } if (IS_POST) { $data = input('post.'); if ($id) { $data['id'] = $id; M("qy_imgtype")->update($data); } else { $sendlist = M('qy_imgtype')->where(array('id' => $id))->find(); if ($sendlist) { $this->error('该分类已存在!', U('Manager/Userqy/addimgtype')); exit(); } else { M("qy_imgtype")->insert($data); } } if ($oldurl) { $this->success("操作成功!!!", $oldurl); } else { $this->success("操作成功!!!", U('Manager/Userqy/addimgtype')); } exit; } $this->assign('wxsend', $wxsend); return $this->fetch('', getAdmStoId()); } //删除 public function delimgtype() { $getid = I('id/d'); $modelist = M('qy_imglist')->where(array('type_id' => $getid))->count(); if ($modelist > 0) { $return_arr = array('status' => -1, 'msg' => '删除失败,此类型已存在记录', 'data' => '',); //$return_arr = array('status' => -1,'msg' => '删除失败','data' =>'',); $this->ajaxReturn($return_arr); } $deltype = M("qy_imgtype")->where(array('id' => $getid))->delete(); if ($deltype) { $return_arr = array('status' => 1, 'msg' => '操作成功', 'data' => '',); //$return_arr = array('status' => -1,'msg' => '删除失败','data' =>'',); } else { $return_arr = array('status' => -1, 'msg' => '删除失败', 'data' => '',); } $this->ajaxReturn($return_arr); } public function delimglist() { $getid = I('id/d'); $modelist = M('qy_imglist')->where(array('id' => $getid))->count(); if (empty($modelist)) { $return_arr = array('status' => -1, 'msg' => '删除失败,存在记录', 'data' => '',); $this->ajaxReturn($return_arr); } $deltype = M("qy_imglist")->where(array('id' => $getid))->delete(); if ($deltype) { $return_arr = array('status' => 1, 'msg' => '操作成功', 'data' => '',); } else { $return_arr = array('status' => -1, 'msg' => '删除失败', 'data' => '',); } $this->ajaxReturn($return_arr); } /** * 初始化编辑器链接 * 本编辑器参考 地址 http://fex.baidu.com/ueditor/ */ private function initEditor() { $this->assign("URL_upload", U('admin/Ueditor/imageUp', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 图片上传目录 $this->assign("URL_imageUp", U('admin/Ueditor/imageUp', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 不知道啥图片 $this->assign("URL_fileUp", U('admin/Ueditor/fileUp', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 文件上传s $this->assign("URL_scrawlUp", U('admin/Ueditor/scrawlUp', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 图片流 $this->assign("URL_getRemoteImage", U('admin/Ueditor/getRemoteImage', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 远程图片管理 $this->assign("URL_imageManager", U('admin/Ueditor/imageManager', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 图片管理 $this->assign("URL_getMovie", U('admin/Ueditor/getMovie', array('savepath' => 'goods', 'savepath1' => getERPId()))); // 视频上传 $this->assign("URL_Home", ""); } }