getPgoodsShowState(); //获得兑换商品的推荐状态 $pgoodsrecommendstate_arr = $pointprod_model->getPgoodsRecommendState(); //条件 $where = array(); $pgoods_name = trim($_GET['pg_name']); if ($pgoods_name){ $where['pgoods_name'] = array('like',"%{$pgoods_name}%"); } switch (trim($_GET['pg_state'])){ case 'show': $where['pgoods_show'] = $pgoodsshowstate_arr['show'][0]; break; case 'nshow': $where['pgoods_show'] = $pgoodsshowstate_arr['unshow'][0]; break; case 'commend': $where['pgoods_commend'] = $pgoodsrecommendstate_arr['commend'][0]; break; } $prod_list = $pointprod_model->getPointProdList($where, '*', 'pgoods_sort asc,pgoods_id desc', 0, 10); //信息输出 Tpl::output('prod_list',$prod_list); Tpl::output('show_page',$pointprod_model->showpage()); Tpl::showpage('pointprod.list'); } /** * 积分礼品添加 */ public function prod_addOp(){ $hourarr = array('00','01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23'); $upload_model = Model('upload'); if (chksubmit()){ //验证表单 $obj_validate = new Validator(); $validate_arr[] = array("input"=>$_POST["goodsname"],"require"=>"true","message"=>L('admin_pointprod_add_goodsname_error')); $validate_arr[] = array("input"=>$_POST["goodsprice"],"require"=>"true","validator"=>"DoublePositive","message"=>L('admin_pointprod_add_goodsprice_number_error')); $validate_arr[] = array('input'=>$_POST['goodspoints'],'require'=>'true','validator'=>'IntegerPositive','message'=>L('admin_pointprod_add_goodspoint_number_error')); $validate_arr[] = array('input'=>$_POST['goodsserial'],'require'=>'true','message'=>L('admin_pointprod_add_goodsserial_null_error')); $validate_arr[] = array('input'=>$_POST['goodsstorage'],'require'=>'true','validator'=>'IntegerPositive','message'=>L('admin_pointprod_add_storage_number_error')); $validate_arr[] = array('input'=>$_POST['sort'],'require'=>'true','validator'=>'IntegerPositive','message'=>L('admin_pointprod_add_sort_number_error')); if ($_POST['islimit'] == 1){ $validate_arr[] = array('input'=>$_POST['limitnum'],'validator'=>'IntegerPositive','message'=>L('admin_pointprod_add_limitnum_digits_error')); } if ($_POST['islimittime']){ $validate_arr[] = array('input'=>$_POST['starttime'],'require'=>'true','message'=>L('admin_pointprod_add_limittime_null_error')); $validate_arr[] = array('input'=>$_POST['endtime'],'require'=>'true','message'=>L('admin_pointprod_add_limittime_null_error')); } $obj_validate->validateparam = $validate_arr; $error = $obj_validate->validate(); if ($error != ''){ showDialog(L('error').$error,'','error'); } $model_pointprod = Model('pointprod'); $goods_array = array(); $goods_array['pgoods_name'] = trim($_POST['goodsname']); $goods_array['pgoods_tag'] = trim($_POST['goodstag']); $goods_array['pgoods_price'] = trim($_POST['goodsprice']); $goods_array['pgoods_points'] = trim($_POST['goodspoints']); $goods_array['pgoods_serial'] = trim($_POST['goodsserial']); $goods_array['pgoods_storage'] = intval($_POST['goodsstorage']); $goods_array['pgoods_islimit'] = intval($_POST['islimit']); if ($goods_array['pgoods_islimit'] == 1){ $goods_array['pgoods_limitnum'] = intval($_POST['limitnum']); }else { $goods_array['pgoods_limitnum'] = 0; } $goods_array['pgoods_islimittime'] = intval($_POST['islimittime']); if ($goods_array['pgoods_islimittime'] == 1){ //如果添加了开始时间 if (trim($_POST['starttime'])){ $starttime = trim($_POST['starttime']); $sdatearr = explode('-',$starttime); $starttime = mktime(intval($_POST['starthour']),0,0,$sdatearr[1],$sdatearr[2],$sdatearr[0]); unset($sdatearr); } if (trim($_POST['endtime'])){ $endtime = trim($_POST['endtime']); $edatearr = explode('-',$endtime); $endtime = mktime(intval($_POST['endhour']),0,0,$edatearr[1],$edatearr[2],$edatearr[0]); } $goods_array['pgoods_starttime'] = $starttime; $goods_array['pgoods_endtime'] = $endtime; }else { $goods_array['pgoods_starttime'] = ''; $goods_array['pgoods_endtime'] = ''; } $goods_array['pgoods_show'] = trim($_POST['showstate']); $goods_array['pgoods_commend'] = trim($_POST['commendstate']); $goods_array['pgoods_add_time'] = time(); $goods_array['pgoods_state'] = trim($_POST['forbidstate']); $goods_array['pgoods_close_reason'] = trim($_POST['forbidreason']); $goods_array['pgoods_keywords'] = trim($_POST['keywords']); $goods_array['pgoods_description'] = trim($_POST['description']); $goods_array['pgoods_body'] = trim($_POST['pgoods_body']); $goods_array['pgoods_sort'] = intval($_POST['sort']); $goods_array['pgoods_limitmgrade'] = intval($_POST['limitgrade']); //添加礼品代表图片 $indeximg_succ = false; if (!empty($_FILES['goods_image']['name'])){ $upload = new UploadFile(); $upload->set('default_dir',ATTACH_POINTPROD); $upload->set('thumb_width', '60,240'); $upload->set('thumb_height','60,240'); $upload->set('thumb_ext', '_small,_mid'); $result = $upload->upfile('goods_image'); if ($result){ $indeximg_succ = true; $goods_array['pgoods_image'] = $upload->file_name; }else { showDialog($upload->error,'','error'); } } $state = $model_pointprod->addPointGoods($goods_array); if($state){ //礼品代表图片数据入库 if ($indeximg_succ){ $insert_array = array(); $insert_array['file_name'] = $upload->file_name; $insert_array['file_thumb'] = $upload->thumb_image; $insert_array['upload_type'] = 5; $insert_array['file_size'] = filesize(BASE_UPLOAD_PATH.DS.ATTACH_POINTPROD.DS.$upload->file_name); $insert_array['item_id'] = $state; $insert_array['upload_time'] = time(); $upload_model->add($insert_array); } //更新积分礼品描述图片 $file_idstr = ''; if (is_array($_POST['file_id']) && count($_POST['file_id'])>0){ $file_idstr = "'".implode("','",$_POST['file_id'])."'"; } $upload_model->updatebywhere(array('item_id'=>$state),array('upload_type'=>6,'item_id'=>'0','upload_id_in'=>"{$file_idstr}")); $this->log(L('admin_pointprod_add_title').'['.$_POST['goodsname'].']'); showDialog(L('admin_pointprod_add_success'),'index.php?act=pointprod&op=pointprod','succ'); } } //模型实例化 $where = array(); $where['upload_type'] = '6'; $where['item_id'] = '0'; $file_upload = $upload_model->getUploadList($where); if (is_array($file_upload)){ foreach ($file_upload as $k => $v){ $file_upload[$k]['upload_path'] = UPLOAD_SITE_URL.DS.ATTACH_POINTPROD.DS.$file_upload[$k]['file_name']; } } Tpl::output('file_upload',$file_upload); Tpl::output('PHPSESSID',session_id()); $hourarr = array('00','01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23'); Tpl::output('hourarr',$hourarr); //会员级别 $member_grade = Model('member')->getMemberGradeArr(); Tpl::output('member_grade',$member_grade); Tpl::showpage('pointprod.add'); } /** * 积分礼品编辑 */ public function prod_editOp(){ $hourarr = array('00','01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23'); $upload_model = Model('upload'); $pg_id = intval($_GET['pg_id']); if (!$pg_id){ showDialog(L('admin_pointprod_parameter_error'),'index.php?act=pointprod&op=pointprod','error'); } $model_pointprod = Model('pointprod'); //查询礼品记录是否存在 $prod_info = $model_pointprod->getPointProdInfo(array('pgoods_id'=>$pg_id)); if (!$prod_info){ showDialog(L('admin_pointprod_record_error'),'index.php?act=pointprod&op=pointprod','error'); } if (chksubmit()){ //验证表单 $obj_validate = new Validator(); $validate_arr[] = array("input"=>$_POST["goodsname"],"require"=>"true","message"=>L('admin_pointprod_add_goodsname_error')); $validate_arr[] = array("input"=>$_POST["goodsprice"],"require"=>"true","validator"=>"DoublePositive","message"=>L('admin_pointprod_add_goodsprice_number_error')); $validate_arr[] = array('input'=>$_POST['goodspoints'],'require'=>'true','validator'=>'IntegerPositive','message'=>L('admin_pointprod_add_goodspoint_number_error')); $validate_arr[] = array('input'=>$_POST['goodsserial'],'require'=>'true','message'=>L('admin_pointprod_add_goodsserial_null_error')); $validate_arr[] = array('input'=>$_POST['goodsstorage'],'require'=>'true','validator'=>'IntegerPositive','message'=>L('admin_pointprod_add_storage_number_error')); $validate_arr[] = array('input'=>$_POST['sort'],'require'=>'true','validator'=>'IntegerPositive','message'=>L('admin_pointprod_add_sort_number_error')); if ($_POST['islimit'] == 1){ $validate_arr[] = array('input'=>$_POST['limitnum'],'validator'=>'IntegerPositive','message'=>L('admin_pointprod_add_limitnum_digits_error')); } if ($_POST['islimittime']){ $validate_arr[] = array('input'=>$_POST['starttime'],'require'=>'true','message'=>L('admin_pointprod_add_limittime_null_error')); $validate_arr[] = array('input'=>$_POST['endtime'],'require'=>'true','message'=>L('admin_pointprod_add_limittime_null_error')); } $obj_validate->validateparam = $validate_arr; $error = $obj_validate->validate(); if ($error != ''){ showDialog(L('error').$error,'','error'); } //实例化店铺商品模型 $model_pointprod = Model('pointprod'); $goods_array = array(); $goods_array['pgoods_name'] = trim($_POST['goodsname']); $goods_array['pgoods_tag'] = trim($_POST['goodstag']); $goods_array['pgoods_price'] = trim($_POST['goodsprice']); $goods_array['pgoods_points'] = trim($_POST['goodspoints']); $goods_array['pgoods_serial'] = trim($_POST['goodsserial']); $goods_array['pgoods_storage'] = intval($_POST['goodsstorage']); $goods_array['pgoods_islimit'] = intval($_POST['islimit']); if ($goods_array['pgoods_islimit'] == 1){ $goods_array['pgoods_limitnum'] = intval($_POST['limitnum']); }else { $goods_array['pgoods_limitnum'] = 0; } $goods_array['pgoods_islimittime'] = intval($_POST['islimittime']); if ($goods_array['pgoods_islimittime'] == 1){ //如果添加了开始时间 if (trim($_POST['starttime'])){ $starttime = trim($_POST['starttime']); $sdatearr = explode('-',$starttime); $starttime = mktime(intval($_POST['starthour']),0,0,$sdatearr[1],$sdatearr[2],$sdatearr[0]); unset($sdatearr); } if (trim($_POST['endtime'])){ $endtime = trim($_POST['endtime']); $edatearr = explode('-',$endtime); $endtime = mktime(intval($_POST['endhour']),0,0,$edatearr[1],$edatearr[2],$edatearr[0]); } $goods_array['pgoods_starttime'] = $starttime; $goods_array['pgoods_endtime'] = $endtime; }else { $goods_array['pgoods_starttime'] = ''; $goods_array['pgoods_endtime'] = ''; } $goods_array['pgoods_show'] = trim($_POST['showstate']); $goods_array['pgoods_commend'] = trim($_POST['commendstate']); $goods_array['pgoods_state'] = trim($_POST['forbidstate']); $goods_array['pgoods_close_reason'] = trim($_POST['forbidreason']); $goods_array['pgoods_keywords'] = trim($_POST['keywords']); $goods_array['pgoods_description'] = trim($_POST['description']); $goods_array['pgoods_body'] = trim($_POST['pgoods_body']); $goods_array['pgoods_sort'] = intval($_POST['sort']); $goods_array['pgoods_limitmgrade'] = intval($_POST['limitgrade']); //添加礼品代表图片 $indeximg_succ = false; if (!empty($_FILES['goods_image']['name'])){ $upload = new UploadFile(); $upload->set('default_dir',ATTACH_POINTPROD); $upload->set('thumb_width', '60,240'); $upload->set('thumb_height','60,240'); $upload->set('thumb_ext', '_small,_mid'); $result = $upload->upfile('goods_image'); if ($result){ $indeximg_succ = true; $goods_array['pgoods_image'] = $upload->file_name; }else { showDialog($upload->error,'','error'); } } $state = $model_pointprod->editPointProd($goods_array,array('pgoods_id'=>$prod_info['pgoods_id'])); if($state){ //礼品代表图片数据入库 if ($indeximg_succ){ //删除原有图片 $upload_list = $upload_model->getUploadList(array('upload_type'=>5,'item_id'=>$prod_info['pgoods_id'])); if (is_array($upload_list) && count($upload_list)>0){ $upload_idarr = array(); foreach ($upload_list as $v){ @unlink(BASE_UPLOAD_PATH.DS.ATTACH_POINTPROD.DS.$v['file_name']); @unlink(BASE_UPLOAD_PATH.DS.ATTACH_POINTPROD.DS.$v['file_thumb']); $upload_idarr[] = $v['upload_id']; } //删除图片 $upload_model->dropUploadById($upload_idarr); } $insert_array = array(); $insert_array['file_name'] = $upload->file_name; $insert_array['file_thumb'] = $upload->thumb_image; $insert_array['upload_type'] = 5; $insert_array['file_size'] = filesize(BASE_UPLOAD_PATH.DS.DS.ATTACH_POINTPROD.DS.$upload->file_name); $insert_array['item_id'] = $prod_info['pgoods_id']; $insert_array['upload_time'] = time(); $upload_model->add($insert_array); } //更新积分礼品描述图片 $file_idstr = ''; if (is_array($_POST['file_id']) && count($_POST['file_id'])>0){ $file_idstr = "'".implode("','",$_POST['file_id'])."'"; } $upload_model->updatebywhere(array('item_id'=>$prod_info['pgoods_id']),array('upload_type'=>6,'item_id'=>'0','upload_id_in'=>"{$file_idstr}")); $this->log(L('nc_edit,admin_pointprodp').'['.$_POST['goodsname'].']'); showDialog(L('admin_pointprod_edit_success'),'index.php?act=pointprod&op=pointprod','succ'); } }else { $where = array(); $where['upload_type'] = '6'; $where['item_id'] = $prod_info['pgoods_id']; $file_upload = $upload_model->getUploadList($where); if (is_array($file_upload)){ foreach ($file_upload as $k => $v){ $file_upload[$k]['upload_path'] = UPLOAD_SITE_URL.DS.ATTACH_POINTPROD.DS.$file_upload[$k]['file_name']; } } //会员级别 $member_grade = Model('member')->getMemberGradeArr(); Tpl::output('member_grade',$member_grade); Tpl::output('file_upload',$file_upload); Tpl::output('PHPSESSID',session_id()); Tpl::output('hourarr',$hourarr); Tpl::output('prod_info',$prod_info); Tpl::showpage('pointprod.edit'); } } /** * 删除积分礼品 */ public function prod_dropOp(){ $pg_id = intval($_GET['pg_id']); if (!$pg_id){ showDialog(L('admin_pointprod_parameter_error'),'index.php?act=pointprod&op=pointprod','error'); } $model_pointprod = Model('pointprod'); //查询礼品是否存在 $prod_info = $model_pointprod->getPointProdInfo(array('pgoods_id'=>$pg_id)); if (!is_array($prod_info) || count($prod_info)<=0){ showDialog(L('admin_pointprod_record_error'),'index.php?act=pointprod&op=pointprod','error'); } //查询积分礼品的下属信息(比如兑换信息) //删除操作 $result = $model_pointprod->delPointProdById($pg_id); if($result) { $this->log(L('nc_del,admin_pointprodp').'[ID:'.$pg_id.']'); showDialog(L('admin_pointprod_del_success'),'index.php?act=pointprod&op=pointprod','succ'); } else { showDialog(L('admin_pointprod_del_fail'),'index.php?act=pointprod&op=pointprod','error'); } } /** * 批量删除积分礼品 */ public function prod_dropallOp(){ $pg_id = $_POST['pg_id']; if (!$pg_id){ showDialog(L('admin_pointprod_parameter_error'),'index.php?act=pointprod&op=pointprod','','error'); } $result = Model('pointprod')->delPointProdById($pg_id); if($result) { $this->log(L('nc_del,admin_pointprodp').'[ID:'.implode(',',$pg_id).']'); showDialog(L('admin_pointprod_del_success'),'index.php?act=pointprod&op=pointprod','succ'); } else { showDialog(L('admin_pointprod_del_fail'),'index.php?act=pointprod&op=pointprod','','error'); } } /** * 积分礼品异步状态修改 */ public function ajaxOp(){ //礼品上架,礼品推荐,礼品禁售 $id = intval($_GET['id']); if ($id <= 0){ echo 'false'; exit; } $model_pointprod = Model('pointprod'); $update_array = array(); $update_array[$_GET['column']] = trim($_GET['value']); $model_pointprod->editPointProd($update_array,array('pgoods_id'=>$id)); echo 'true';exit; } /** * 积分礼品上传 */ public function pointprod_pic_uploadOp(){ /** * 上传图片 */ $upload = new UploadFile(); $upload->set('default_dir',ATTACH_POINTPROD); $result = $upload->upfile('fileupload'); if ($result){ $_POST['pic'] = $upload->file_name; }else { echo 'error';exit; } /** * 模型实例化 */ $model_upload = Model('upload'); /** * 图片数据入库 */ $insert_array = array(); $insert_array['file_name'] = $_POST['pic']; $insert_array['upload_type'] = '6'; $insert_array['file_size'] = $_FILES['Filedata']['size']; $insert_array['upload_time'] = time(); $insert_array['item_id'] = intval($_POST['item_id']); $result = $model_upload->add($insert_array); if ($result){ $data = array(); $data['file_id'] = $result; $data['file_name'] = $_POST['pic']; $data['file_path'] = $_POST['pic']; /** * 整理为json格式 */ $output = json_encode($data); echo $output; } } /** * ajax操作删除已上传图片 */ public function ajaxdeluploadOp(){ //删除文章图片 if (intval($_GET['file_id']) > 0){ $model_upload = Model('upload'); /** * 删除图片 */ $file_array = $model_upload->getOneUpload(intval($_GET['file_id'])); @unlink(BASE_UPLOAD_PATH.DS.ATTACH_POINTPROD.DS.$file_array['file_name']); /** * 删除信息 */ $model_upload->del(intval($_GET['file_id'])); echo 'true';exit; }else { echo 'false';exit; } } }