assign('day',$day); $this->assign('ishf',$ishf); return $this->fetch('',getAdmStoId()); } public function detail(){ $id = I('get.id/d'); $res = M('comment')->alias('a')->join('users b',' a.user_id=b.user_id','left')->where(array('comment_id'=>$id))->find(); if(!$res){ exit($this->error('不存在该评论')); } if(IS_POST){ $add['parent_id'] = $id; $add['content'] = I('post.content'); $add['goods_id'] = $res['goods_id']; $add['add_time'] = time(); $add['username'] = 'admin'; $add['store_id'] =getAdmStoId(); $add['is_show'] = 1; $row = M('comment')->add($add); if($row){ // upload_ylp_log('评论回复'); $this->success('添加成功'); }else{ $this->error('添加失败'); } exit; } $reply = M('comment')->where(array('parent_id'=>$id))->select(); // 评论回复列表 if($res['source_type']==0){ if($res['img']) $res['s_mg']=unserialize($res['img']); }else{ if($res['weapp_img']) $res['s_mg']= json_decode($res['weapp_img'],true); } $this->assign('comment',$res); $this->assign('reply',$reply); return $this->fetch('',getAdmStoId()); } public function del(){ $id = I('get.id/d'); $row = M('comment')->where(array('comment_id'=>$id))->delete(); if($row){ // upload_ylp_log('删除订单评价');//记录事件日志 $this->success('删除成功'); }else{ $this->error('删除失败'); } } public function op(){ $type = I('post.type'); $selected_id = I('post.selected/a'); if(!in_array($type,array('del','show','hide')) || !$selected_id) $this->error('非法操作'); $where['comment_id'] = array('IN', $selected_id); if($type == 'del'){ //删除回复 $where['parent_id'] = ['IN',$selected_id]; $row = M('comment')->whereOr($where)->delete(); // exit(DB::getLastSql()); } if($type == 'show'){ $row = M('comment')->where($where)->save(array('is_show'=>1)); } if($type == 'hide'){ $row = M('comment')->where($where)->save(array('is_show'=>0)); } if(!$row){ $this->error('操作失败'); }else{ // upload_ylp_log('评价操作'); $this->success('操作成功'); } } public function ajaxindex(){ $model = M('comment'); $username = I('nickname','','trim'); $content = I('content','','trim'); $ishow=I('is_show'); $isauto=I('isauto'); $day = trim(I('day',"")); $today = strtotime(date('Y-m-d')); $where['parent_id'] = 0; $getAdmStoId=getAdmStoId(); $where['store_id']=$getAdmStoId; if($username){ $where['username'] = $username; } if ($content) { $where['content'] = ['like', '%' . $content . '%']; } $where1=""; $ishf=I('ishf'); if ($ishf==1) { $where1=" comment_id not in(select parent_id from wxd_comment where store_id=".$getAdmStoId." and parent_id<>0) "; } if($ishow>-1){ $where['is_show']=$ishow; } if($isauto>-1){ $where['isauto']=$isauto; } // // if ($day=="1") $where['add_time']=array('egt',$today); $count = $model->where($where)->where($where1)->count(); $Page = $pager = new AjaxPage($count,16); $show = $Page->show(); $comment_list = $model->where($where)->where($where1)->order('add_time DESC')->limit($Page->firstRow.','.$Page->listRows)->select(); if(!empty($comment_list)) { $goods_id_arr = get_arr_column($comment_list, 'goods_id'); $goods_list = M('Goods')->where("goods_id", "in" , implode(',', $goods_id_arr))->getField("goods_id,goods_name"); } $this->assign('goods_list',$goods_list); $this->assign('comment_list',$comment_list); $this->assign('page',$show);// 赋值分页输出 $this->assign('pager',$pager);// 赋值分页输出 upload_ylp_log('B17评价管理查询/搜索'); return $this->fetch('',getAdmStoId()); } public function ask_list(){ return $this->fetch('',getAdmStoId()); } public function ajax_ask_list(){ $model = M('goods_consult'); $username = I('nickname','','trim'); $content = I('content','','trim'); $where=' parent_id = 0'; if($username){ $where .= " AND username='$username'"; } if($content){ $where .= " AND content like '%{$content}%'"; } $count = $model->where($where)->count(); $Page = $pager = new AjaxPage($count,10); $show = $Page->show(); $comment_list = $model->where($where)->order('add_time DESC')->limit($Page->firstRow.','.$Page->listRows)->select(); if(!empty($comment_list)) { $goods_id_arr = get_arr_column($comment_list, 'goods_id'); $goods_list = M('Goods')->where("goods_id", "in", implode(',', $goods_id_arr))->getField("goods_id,goods_name"); } $consult_type = array(0=>'默认咨询',1=>'商品咨询',2=>'支付咨询',3=>'配送',4=>'售后'); $this->assign('consult_type',$consult_type); $this->assign('goods_list',$goods_list); $this->assign('comment_list',$comment_list); $this->assign('page',$show);// 赋值分页输出 $this->assign('pager',$pager);// 赋值分页输出 return $this->fetch('',getAdmStoId()); } public function consult_info(){ $id = I('get.id/d'); $res = M('goods_consult')->where(array('id'=>$id))->find(); if(!$res){ exit($this->error('不存在该咨询')); } if(IS_POST){ $add['parent_id'] = $id; $add['content'] = I('post.content'); $add['goods_id'] = $res['goods_id']; $add['consult_type'] = $res['consult_type']; $add['add_time'] = time(); $add['is_show'] = 1; $row = M('goods_consult')->add($add); if($row){ $this->success('添加成功'); }else{ $this->error('添加失败'); } exit; } $reply = M('goods_consult')->where(array('parent_id'=>$id))->select(); // 咨询回复列表 $this->assign('comment',$res); $this->assign('reply',$reply); return $this->fetch('',getAdmStoId()); } public function ask_handle() { $type = I('post.type'); $selected_id = I('post.selected/a'); if (!in_array($type, array('del', 'show', 'hide')) || !$selected_id) $this->error('操作完成'); $selected_id = implode(',', $selected_id); if ($type == 'del') { //删除咨询 $row = M('goods_consult')->where('id', 'IN', $selected_id)->whereOr('parent_id', 'IN', $selected_id)->delete(); } if ($type == 'show') { $row = M('goods_consult')->where('id', 'IN', $selected_id)->save(array('is_show' => 1)); } if ($type == 'hide') { $row = M('goods_consult')->where('id', 'IN', $selected_id)->save(array('is_show' => 0)); } $this->success('操作完成'); } }