where('ad_id',$ad_id)->find();
$ad_info['start_time'] = date('Y-m-d H:i:s',$ad_info['start_time']);
$ad_info['end_time'] = date('Y-m-d H:i:s',$ad_info['end_time']);
}
if($act == 'add')
$ad_info['pid'] = $this->request->param('pid');
$position = D('ad_position')->where('1=1')->select();
$this->assign('info',$ad_info);
$this->assign('act',$act);
$this->assign('position',$position);
$this->assign('erpid',getERPId());
$this->assign('oldurl', $oldurl);
$qclurl=QCLOUD_IMGURL;
$this->assign('qclurl',$qclurl);
return $this->fetch('',getAdmStoId());
}
public function adList(){
delFile(RUNTIME_PATH.'Html'); // 先清除缓存, 否则不好预览
$Ad = M('ad');
$pid = I('pid',0);
$pagenum=20;//每页显示多少条
if ((int)I('pagenum/s')>0)
{
$pagenum=I('pagenum/s');
}
$where['store_id'] = getAdmStoId();
if($pid){
$where['pid'] = $pid;
$this->assign('pid',I('pid'));
}
$keywords = I('keywords/s',false,'trim');
if($keywords){
$where['ad_name'] = array('like','%'.$keywords.'%');
}
$count = $Ad->where($where)->count();// 查询满足要求的总记录数
$Page = $pager = new Page($count,$pagenum);// 实例化分页类 传入总记录数和每页显示的记录数
$res = $Ad->where($where)->order('pid asc')->limit($Page->firstRow.','.$Page->listRows)->select();
$list = array();
if($res){
$media = array('图片','文字','flash');
foreach ($res as $val){
$val['media_type'] = $media[$val['media_type']];
$list[] = $val;
}
}
$ad_position_list = M('AdPosition')->getField("position_id,position_name,is_open");
$this->assign('ad_position_list',$ad_position_list);//广告位
$show = $Page->show();// 分页显示输出
$this->assign('list',$list);// 赋值数据集
$this->assign('page',$show);// 赋值分页输出
$this->assign('pager',$pager);
$this->assign('pagenum',$pagenum);
$this->assign('oldurl',urlencode(curPageURL()));
return $this->fetch('',getAdmStoId());
}
public function position(){
$act = I('get.act','add');
$position_id = I('get.position_id/d');
$info = array();
if($position_id){
$info = D('ad_position')->where('position_id',$position_id)->find();
}
$this->assign('info',$info);
$this->assign('act',$act);
return $this->fetch('',getAdmStoId());
}
public function positionList(){
$Position = M('ad_position');
$count = $Position->where('1=1')->count();// 查询满足要求的总记录数
$Page = $pager = new Page($count,10);// 实例化分页类 传入总记录数和每页显示的记录数
$list = $Position->order('position_id DESC')->limit($Page->firstRow.','.$Page->listRows)->select();
$this->assign('list',$list);// 赋值数据集
$show = $Page->show();// 分页显示输出
$this->assign('page',$show);// 赋值分页输出
$this->assign('pager',$pager);
return $this->fetch('',getAdmStoId());
}
public function adHandle(){
$data = I('post.');
$data['start_time'] = strtotime($data['begin']);
$data['end_time'] = strtotime($data['end']);
$oldurl = I('oldurl/s');
if($oldurl){
$oldurl = urldecode($oldurl);
$oldurl = urldecode($oldurl);
}
unset($data['oldurl']);
if($data['act'] == 'add'){
// upload_ylp_log('增加广告');
$data["store_id"]=getAdmStoId();
$r = D('ad')->add($data);
}
if($data['act'] == 'edit'){
// upload_ylp_log('编辑广告');
$data["store_id"]=getAdmStoId();
unset($data['act']);
unset($data['begin']);
unset($data['end']);
$q=D('ad')->where('ad_id', $data['ad_id'])->where($data)->find();
if($q){
if($oldurl){
$this->success('操作成功',$oldurl);
}
else {
$this->success("操作成功1", U('Admin/Ad/adList'));
}
exit;
}
$r = D('ad')->where('ad_id', $data['ad_id'])->save($data);
}
if($data['act'] == 'del'){
// upload_ylp_log('删除广告');
$d=D('ad')->where('ad_id', $data['del_id'])->find();
if($d){
$url=$d['ad_code'];
if(!empty($url)){
mdelFile(ROOT_PATH.$url);
vendor('qcloudcos.myqcloudcos');
$delres = Myqcloudcos::delFile('wxd', $url);
}
$r = D('ad')->where('ad_id', $data['del_id'])->delete();
if($r) exit(json_encode(1));
}else{
$this->error("未找到该广告",$referurl);
exit;
}
}
/*--清除缓存--*/
ClearALLCache();
delFile(TEMP_PATH."/".getAdmStoId());
$referurl = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : U('Admin/Ad/adList');
// 不管是添加还是修改广告 都清除一下缓存
delFile(RUNTIME_PATH.'Html'); // 先清除缓存, 否则不好预览
if($r){
$this->success("操作成功",U('Admin/Ad/adList'));
}else{
$this->error("操作失败",$referurl);
}
}
public function positionHandle(){
$data = I('post.');
if($data['act'] == 'add'){
// upload_ylp_log('增加广告位');
$r = M('ad_position')->add($data);
}
if($data['act'] == 'edit'){
// upload_ylp_log('编辑广告位');
$r = M('ad_position')->where('position_id',$data['position_id'])->save($data);
}
if($data['act'] == 'del'){
// upload_ylp_log('删除广告位');
if(M('ad')->where('pid',$data['position_id'])->count()>0){
$this->error("此广告位下还有广告,请先清除",U('Admin/Ad/positionList'));
}else{
$r = M('ad_position')->where('position_id', $data['position_id'])->delete();
if($r) exit(json_encode(1));
}
}
$referurl = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : U('Admin/Ad/positionList');
if($r){
$this->success("操作成功",$referurl);
}else{
$this->error("操作失败",$referurl);
}
}
public function changeAdField(){
// upload_ylp_log('保存广告');
$field = $this->request->request('field');
$data[$field] = I('get.value');
$data['ad_id'] = I('get.ad_id');
M('ad')->save($data); // 根据条件保存修改的数据
}
//商城首页广告
public function shop_index(){
//在页面渲染,无法直接使用,必须赋值给标签才能使用(json)
$getmintime=date('Y-m-d 00:00:00',time());
$getmaxtime=date('Y-m-d 23:59:59',time());
$this->assign('getmaxtime',$getmaxtime);
$this->assign('getmintime',$getmintime);
$this->assign('erpid',getERPId());
// upload_ylp_log('商城首页广告');
return $this->fetch('',getAdmStoId());
}
//商城首页广告
public function shop_user(){
//在页面渲染,无法直接使用,必须赋值给标签才能使用(json)
$getmintime=date('Y-m-d 00:00:00',time());
$getmaxtime=date('Y-m-d 23:59:59',time());
$this->assign('getmaxtime',$getmaxtime);
$this->assign('getmintime',$getmintime);
$this->assign('erpid',getERPId());
// upload_ylp_log('个人中心广告');
return $this->fetch('',getAdmStoId());
}
//积分兑换广告
public function shop_integral(){
$getmintime=date('Y-m-d 00:00:00',time());
$getmaxtime=date('Y-m-d 23:59:59',time());
$this->assign('getmaxtime',$getmaxtime);
$this->assign('getmintime',$getmintime);
$this->assign('erpid',getERPId());
return $this->fetch('',getAdmStoId());
}
//客显屏幕广告
public function erp_kxpm(){
$getmintime=date('Y-m-d 00:00:00',time());
$getmaxtime=date('Y-m-d 23:59:59',time());
$this->assign('getmaxtime',$getmaxtime);
$this->assign('getmintime',$getmintime);
$this->assign('erpid',getERPId());
return $this->fetch('',getAdmStoId());
}
public function search_strore()
{
$pickup_listid=I('pickup_listid');
$where='';
if ($pickup_listid){
$newstr = substr($pickup_listid,0,strlen($pickup_listid)-1);
$where="(pickup_id not in($newstr)) and";
}
$pagenum = 5;//每页显示多少条
$getAdmStoId =getAdmStoId();
$where = "$where store_id=" . $getAdmStoId;
$kword = urldecode(urldecode(I('keywords/s')));
//分页
$intro = I('intro');
if (!empty($intro)) {
$where = "$where and " . I('intro') . " = 1";
$this->assign('intro', $intro);
}
//搜索
if (!empty($kword)) {
$this->assign('keywords', $kword);
$where = "$where and (pickup_no like '%" . $kword . "%' or pickup_name like '%" . $kword . "%')";
}
$count = M('pick_up')->where($where)->count();
$Page = new Page($count, $pagenum);
$stroreList = M('pick_up')->where($where)->order('pickup_id DESC')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$show = $Page->show();//分页显示输出
$this->assign('page', $show);//赋值分页输出
$this->assign('stroreList', $stroreList);
$this->assign('pickup_listid', $pickup_listid);
$this->assign('pager', $Page);//赋值分页输出
$tpl = I('get.tpl', 'search_strore');
return $this->fetch($tpl, getAdmStoId());
}
// 优惠促销增加,编辑
public function prom_goods_info()
{
$prom_id = I('id','0');
$store_id = getAdmStoId();
$time = time();
$info['start_time'] = date('Y-m-d H:i:s');
$info['end_time'] = date('Y-m-d H:i:s', time() + 3600 * 60 * 24);
$coupon = M('coupon')->where(['store_id' => $store_id, 'send_end_time' => ['gt', $time], 'type' => 5])->select();
$gift = M('gift')->where(['store_id' => $store_id, 'is_end' => 0])->select();
$libao=M('libao_form')->where(['store_id' => $store_id,'isdel'=>0,
'startime'=>['lt', $time],'endtime' => ['gt', $time]])->select();
//全场活动的开始时间
$now = time();
$wh = " store_id=" . $store_id . " and is_end=0 and prom_type=3 ".
" and e_time>" . $now . " and good_object=0";
$wh.=" and act_id<>".$prom_id;
$fu = M("activitylist")->where($wh)->field('id,goods_listid,s_time,e_time')->find();
if ($fu) {
$this->assign('quan_s_time', date('Y-m-d H:i:s', $fu['s_time']));
$this->assign('quan_e_time', date('Y-m-d H:i:s', $fu['e_time']));
}
//其他所有活动的结束时间,开始时间
$wh1 = " store_id=" . $store_id . " and is_end=0".
" and end_time>" . $now;
$wh1.=" and id<>".$prom_id;
$max=M("prom_goods")->where($wh1)->max('end_time');
$min=M("prom_goods")->where($wh1)->min('start_time');
if($max)
$this->assign('zhiding_e_time', date('Y-m-d H:i:s',$max));
if($min)
$this->assign('zhiding_s_time', date('Y-m-d H:i:s',$min));
//是否有全场的,包括指定商品不参与
if(empty($prom_id)) {
if ($fu) {
if($fu['s_time']<$now) {
$this->assign('isfull', 1);
if (empty($fu['goods_listid'])) $this->assign('isall', 1);
}
else{
$this->assign('goods_listid', $fu['goods_listid']);
}
}
}
if ($prom_id > 0) {
//是否有全场的,包括指定商品不参与
if ($fu) {
if($fu['s_time']<$now) {
$this->assign('isfull', 1);
if (empty($fu['goods_listid'])) $this->assign('isall', 1);
}
else{
$this->assign('goods_listid', $fu['goods_listid']);
}
}
$is_full = 'false';
$info = M('prom_goods')->where(['store_id' => $store_id, 'id' => $prom_id])->find();
$info['start_time'] = date('Y-m-d H:i:s', $info['start_time']);
$info['end_time'] = date('Y-m-d H:i:s', $info['end_time']);
$list = M('prom_goods_list')->where('prom_id', $prom_id)->select();
foreach ($list as $k => $v) {
$list[$k]['preferential_type'] = json_decode($v['preferential_type'], true);
}
$this->assign('list', $list);
// $prom_goods = M('goods')->where("prom_id=$prom_id and prom_type=3")->select();
$activitylist = M('activitylist')->where("act_id=$prom_id and prom_type=3")->field('goods_listid')->find();
if ($activitylist) {
$prom_goods = M('goods')->where("goods_id", array('in', '0' . $activitylist['goods_listid'] . '0'))->order('goods_id DESC')->select();
}
$this->assign('prom_goods', $prom_goods);
}
$tpl = I('tpl', '');
$this->assign([
'coupon' => $coupon,
'info' => $info,
'gift' => $gift,
'tpl' => $tpl,
'libao' => $libao,
]);
return $this->fetch('', getAdmStoId());
}
//商城首页广告数据
public function getgg()
{
$getstoid=getAdmStoId();
$gettypid=I('typeid');
$resgg=M('ad')->where(array('store_id'=>$getstoid,'pid'=>$gettypid))->order('orderby desc')->select();
if ($resgg)
{
foreach ($resgg as $k=>$v){
$pickup_listid=$resgg[$k]['pickup_listid'];
if($pickup_listid != null){
$newstr = substr($pickup_listid,0,strlen($pickup_listid)-1);
$where="(pickup_id IN($newstr))";
$pickupList=M('pick_up')->where($where)->select();
if($pickupList){
$resgg[$k]['pick_list']=$pickupList;
}
}
}
return json(['code'=>0,'data'=>json_encode($resgg)]);
}
else
{
return json(['code'=>1,'msg'=>'没有记录']);
}
}
//商城首页广告添加和修改
public function addEditAd(){
$ad_id=I('ad_id');
$typeid=I('typeid');
$enable=I('ad_enabled');
if($enable == null){
$enable=1;
}
$data = I('post.');
$data['store_id']=getAdmStoId();
$data['start_time'] = strtotime($data['start_time']);
$data['end_time'] = strtotime($data['end_time']);
$data['pid'] = $typeid;
$data['enabled']=$enable;
// echo "alert('"+$data['pid']+"')";
if(empty($ad_id)){
//新增
$r = D('ad')->add($data);
}else{
//修改
upload_ylp_log('A11商城首页编辑/确认提交');
$r = D('ad')->where('ad_id', $ad_id)->save($data);
}
/*--清除缓存--*/
ClearALLCache();
delFile(TEMP_PATH."/".getAdmStoId());
if($r){
$this->success("操作成功",U('Admin/Ad/shop_index'));
}else{
$this->error("操作失败");
}
}
//商城个人中心添加和修改广告
public function addEditAd_user(){
$ad_id=I('ad_id');
$typeid=I('typeid');
$enable=I('ad_enabled');
$data = I('post.');
$data['store_id']=getAdmStoId();
$data['start_time'] = strtotime($data['start_time']);
$data['end_time'] = strtotime($data['end_time']);
$data['pid'] = $typeid;
$data['enabled']=$enable;
// var_dump($data['enabled']);
// die();
// echo "alert('"+$data['pid']+"')";
if(empty($ad_id)){
//新增
$r = D('ad')->add($data);
}else{
//修改
upload_ylp_log('A12个人中心页编辑/确认提交');
$r = D('ad')->where(array('ad_id'=>$ad_id))->save($data);
}
/*--清除缓存--*/
ClearALLCache();
delFile(TEMP_PATH."/".getAdmStoId());
if($r){
$this->success("操作成功",U('Admin/Ad/shop_user'));
}else{
$this->error("操作失败");
}
}
//删除所有广告
public function delAd(){
// upload_ylp_log('删除所有广告');
// $typeid=$_GET['typeid'];
$typeid=I('typeid');
$d=D('ad')->where(array('pid'=>$typeid,'store_id'=>getAdmStoId()))->find();
if($d){
$url=$d['ad_code'];
if(!empty($url)){
mdelFile(ROOT_PATH.$url);
vendor('qcloudcos.myqcloudcos');
$delres = Myqcloudcos::delFile('wxd', $url);
}
$r=D('ad')->where(array('pid'=>$typeid,'store_id'=>getAdmStoId()))->delete();
/*--清除缓存--*/
ClearALLCache();
delFile(TEMP_PATH."/".getAdmStoId());
if($r){
$this->success("操作成功",U('Admin/Ad/shop_index'));
}
}else{
exit;
}
}
//删除轮播
public function delAdid(){
// upload_ylp_log('删除广告轮播');
$ad_id=$_GET['id'];
$d=D('ad')->where(array('ad_id'=>$ad_id,'store_id'=>getAdmStoId()))->find();
if($d){
$url=$d['ad_code'];
if(!empty($url)){
vendor('qcloudcos.myqcloudcos');
$urllist=explode(',',$url);
$url_len = count($urllist);
for ($i = 0; $i < $url_len; $i++) {
mdelFile(ROOT_PATH . $urllist[$i]);
$delres = Myqcloudcos::delFile('wxd', $urllist[$i]);
}
}
$r=D('ad')->where(array('ad_id'=>$ad_id,'store_id'=>getAdmStoId()))->delete();
/*--清除缓存--*/
ClearALLCache();
delFile(TEMP_PATH."/".getAdmStoId());
if($r){
$this->success("操作成功",U('Admin/Ad/shop_index'));
exit;
}
}else{
exit;
}
}
//删除单个广告
public function delId_sigle()
{
vendor('qcloudcos.myqcloudcos');
$ad_id = $_GET['id'];
$imgurl = $_GET['imgurl'];
$getadcode = $_GET['ad_code'];
if ($ad_id) {
$d = D('ad')->where(array('ad_id' => $ad_id, 'store_id' => getAdmStoId()))->find();
if ($d) {
$url = $d['ad_code'];
}
} else {
$url = $getadcode;
}
//
if ($url) {
$urllist = explode(',', $url);
$url_len = count($urllist);
$newurl = "";
for ($i = 0; $i < $url_len; $i++) {
if ($urllist[$i] == $imgurl) {
if ($imgurl) {
mdelFile(ROOT_PATH . $urllist[$i]);
$delres = Myqcloudcos::delFile('wxd', $urllist[$i]);
}
} else {
if ($urllist[$i]) {
if ($newurl) {
$newurl .= "," . $urllist[$i];
} else {
$newurl = $urllist[$i];
}
}
}
}
if ($ad_id) {
$r = D('ad')->where(array('ad_id' => $ad_id, 'store_id' => getAdmStoId()))->save(array('ad_code' => $newurl));
/*--清除缓存--*/
ClearALLCache();
delFile(TEMP_PATH . "/" . getAdmStoId());
if ($r) {
return json(array('code' => 1, 'msg' => '删除成功!', 'urllist' => $newurl));
}
}
else
{
return json(array('code' => 1, 'msg' => '删除成功!', 'urllist' => $newurl));
}
}
//
}
//积分兑换添加和修改广告
public function addEditAd_integral(){
$ad_id=I('ad_id');
$typeid=I('typeid');
$enable=I('ad_enabled');
$data = I('post.');
$data['store_id']=getAdmStoId();
$data['start_time'] = strtotime($data['start_time']);
$data['end_time'] = strtotime($data['end_time']);
$data['pid'] = $typeid;
$data['enabled']=$enable;
if(empty($ad_id)){
//新增
$r = D('ad')->add($data);
}else{
//修改
upload_ylp_log('A12积分兑换页编辑/确认提交');
$r = D('ad')->where(array('ad_id'=>$ad_id))->save($data);
}
/*--清除缓存--*/
ClearALLCache();
delFile(TEMP_PATH."/".getAdmStoId());
if($r){
$this->success("操作成功",U('Admin/Ad/shop_integral'));
}else{
$this->error("操作失败");
}
}
//客显屏幕广告添加和修改广告
public function addEditAd_erpkxpm(){
$ad_id=I('ad_id');
$typeid=I('typeid');
$enable=I('ad_enabled');
$data = I('post.');
$intype=$data['intype'];
if($intype==0){
$data['pickup_listid']='';
}
$data['store_id']=getAdmStoId();
$data['start_time'] = strtotime($data['start_time']);
$data['end_time'] = strtotime($data['end_time']);
$data['pid'] = $typeid;
$data['enabled']=$enable;
if(empty($ad_id)){
//新增
$r = D('ad')->add($data);
}else{
//修改
upload_ylp_log('A12客显屏幕页编辑/确认提交');
$r = D('ad')->where(array('ad_id'=>$ad_id))->save($data);
}
/*--清除缓存--*/
ClearALLCache();
delFile(TEMP_PATH."/".getAdmStoId());
if($r){
$this->success("操作成功",U('Admin/Ad/erp_kxpm'));
}else{
$this->error("操作失败");
}
}
}