<?php
namespace app\index\controller;
use app\index\controller\Common;
class Sendnewsz extends Common{
public function index(){
$conf=db('conf')->where('id',1)->find();
$check['name']="ptid";
$check['id']="0";
$ptid=0;
$pid=0;
$price=0;
$fensi=0;
$yuedu=0;
$lei=0;
if (request()->isGet() && input('ptid') ) {
$check['name']='ptid';
$check['id']=input('ptid');
$where['ptid']=input('ptid');
$ptid=input('ptid');
}
if (request()->isGet() && input('pid') ) {
$check['name']='pid';
$check['id']=input('pid');
$where['pdtype']=input('pid');
$pid=input('pid');
}
if (input('price')) {
$check['name']='price';
$check['id']=input('price');
if ($check['id']==1) {
$where['price']=array('between','1,10');
}
if ($check['id']==2) {
$where['price']=array('between','10,20');
}
if ($check['id']==3) {
$where['price']=array('between','20,50');
}
if ($check['id']==4) {
$where['price']=array('between','50,100');
}
if($check['id']==5){
$where['price']=array('egt','100');
}
$price=input('price');
}
if (input('fensi')) {
$check['name']='fensi';
$check['id']=input('fensi');
if ($check['id']==1) {
$where['fensi']=array('between','0,10000');
}
if ($check['id']==2) {
$where['fensi']=array('between','10000,50000');
}
if ($check['id']==3) {
$where['fensi']=array('between','50000,100000');
}
if ($check['id']==4) {
$where['fensi']=array('between','100000,500000');
}
if($check['id']==5){
$where['fensi']=array('egt','500000');
}
$fensi=input('fensi');
}
if (input('yuedu')) {
$check['name']='yuedu';
$check['id']=input('yuedu');
if ($check['id']==1) {
$where['yuedu']=array('between','0,1000');
}
if ($check['id']==2) {
$where['yuedu']=array('between','1000,5000');
}
if ($check['id']==3) {
$where['yuedu']=array('between','5000,10000');
}
if ($check['id']==4) {
$where['yuedu']=array('between','10000,20000');
}
if($check['id']==5){
$where['yuedu']=array('egt','20000');
}
$yuedu=input('yuedu');
}
if (input('lei')) {
$check['name']='lei';
$check['id']=input('lei');
if ($check['id']==1) {
$where['week']=1;
}
if ($check['id']==2) {
$where['neilian']=1;
}
if ($check['id']==3) {
$where['lxfs']=1;
}
if ($check['id']==4) {
$where['tishi']=1;
}
if ($check['id']==5) {
$where['tishi']=2;
}
if ($check['id']==6) {
$where['tishi']=3;
}
if ($check['id']==7) {
$where['renzheng']=1;
}
$lei=input('lei');
}
$ptname=db('ptname')->select();
$pdtype=db('pdtype')->select();
$where['status']=2;
$lsts=db('mediaz')->where($where)->alias('a')->join('ptname b','a.ptid=b.id','left')->join('pdtype c','a.pdtype=c.pid','left')->order('a.price')->field('a.*,b.ptname,c.pname')->paginate(20,false, [
'query' => request()->param()]);
$this->assign(['ptname'=>$ptname,'pdtype'=>$pdtype]);
$lst['title']='自媒体价格';
$this->assign('lsts',$lsts);
$this->assign('lst',$lst);
$this->assign('check',$check);
$this->assign('conf',$conf);
$this->assign('ptid',$ptid);
$this->assign('pid',$pid);
$this->assign('fensi',$fensi);
$this->assign('yuedu',$yuedu);
$this->assign('lei',$lei);
$this->assign('price',$price);
return view();
}
public function search(){
if (input('post.url')) {
$url=input('post.url');
$where['url']=array('like','%'.$url.'%');
$this->assign('search',$url);
}elseif(input('post.title')) {
$title=input('post.title');
$where['title']=array('like','%'.$title.'%');
$this->assign('title',$title);
}
$conf=db('conf')->where('id',1)->find();
$check['name']="cid";
$check['id']="0";
$ptname=db('ptname')->select();
$pdtype=db('pdtype')->select();
$where['status']=2;
$lsts=db('mediaz')->where($where)->alias('a')->join('ptname b','a.ptid=b.id','left')->join('pdtype c','a.pdtype=c.pid','left')->order('a.price')->field('a.id,a.title,a.url,a.price,b.ptname,c.pname,a.fensi,a.yuedu,a.neilian,a.lxfs,a.renzheng,a.week,a.uid,a.remarks,a.tishi')->select();
$this->assign(['ptname'=>$ptname,'pdtype'=>$pdtype]);
$lst['title']='自媒体价格';
$this->assign('lst',$lst);
$this->assign('lsts',$lsts);
$this->assign('check',$check);
$this->assign('conf',$conf);
return view();
}
public function daochu(){
if (request()->isGet() && input('cid') ) {
$check['name']='cid';
$check['id']=input('cid');
$where['area']=input('cid');
$cid=input('cid');
}
if (request()->isGet() && input('ptid') ) {
$check['name']='ptid';
$check['id']=input('ptid');
$where['ptid']=input('ptid');
$ptid=input('ptid');
}
if (request()->isGet() && input('pid') ) {
$check['name']='pid';
$check['id']=input('pid');
$where['pdtype']=input('pid');
$pid=input('pid');
}
if (input('price')) {
$check['name']='price';
$check['id']=input('price');
if ($check['id']==1) {
$where['price']=array('between','1,10');
}
if ($check['id']==2) {
$where['price']=array('between','10,20');
}
if ($check['id']==3) {
$where['price']=array('between','20,50');
}
if ($check['id']==4) {
$where['price']=array('between','50,100');
}
if($check['id']==5){
$where['price']=array('egt','100');
}
$price=input('price');
}
if (input('fensi')) {
$check['name']='fensi';
$check['id']=input('fensi');
if ($check['id']==1) {
$where['fensi']=array('between','0,10000');
}
if ($check['id']==2) {
$where['fensi']=array('between','10000,50000');
}
if ($check['id']==3) {
$where['fensi']=array('between','50000,100000');
}
if ($check['id']==4) {
$where['fensi']=array('between','100000,500000');
}
if($check['id']==5){
$where['fensi']=array('egt','500000');
}
$fensi=input('fensi');
}
if (input('yuedu')) {
$check['name']='yuedu';
$check['id']=input('yuedu');
if ($check['id']==1) {
$where['yuedu']=array('between','0,1000');
}
if ($check['id']==2) {
$where['yuedu']=array('between','1000,5000');
}
if ($check['id']==3) {
$where['yuedu']=array('between','5000,10000');
}
if ($check['id']==4) {
$where['yuedu']=array('between','10000,20000');
}
if($check['id']==5){
$where['yuedu']=array('egt','20000');
}
$yuedu=input('yuedu');
}
if (input('lei')) {
$check['name']='lei';
$check['id']=input('lei');
if ($check['id']==1) {
$where['week']=1;
}
if ($check['id']==2) {
$where['neilian']=1;
}
if ($check['id']==3) {
$where['lxfs']=1;
}
if ($check['id']==4) {
$where['tishi']=1;
}
if ($check['id']==5) {
$where['tishi']=2;
}
if ($check['id']==6) {
$where['tishi']=3;
}
if ($check['id']==7) {
$where['renzheng']=1;
}
$lei=input('lei');
}
$where['status']=2;
$list=db('mediaz')->where($where)->alias('a')->join('ptname b','a.ptid=b.id','left')->join('pdtype c','a.pdtype=c.pid','left')->order('id')->field('a.id,a.title,a.url,a.price,b.ptname,a.tishi,c.pname,a.fensi,a.yuedu,a.neilian,a.lxfs,a.renzheng,a.week,a.uid,a.remarks')->select();
vendor("PHPExcel.PHPExcel");
set_time_limit(0);
ini_set("memory_limit", "1024M");
\PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip; // 单元格缓存为MemoryGZip
$objPHPExcel = new \PHPExcel();
$objPHPExcel->getProperties()->setCreator("ctos")
->setLastModifiedBy("ctos")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test
超好用的媒介新闻稿发布软文发布自媒体自助交易平台智慧软文前端源码有媒体资源的可以入住接单，获得收入，有发稿需要的用户可以注册账号把稿件发布到各大媒体平台.zip （46个子文件） 
index validate 
AuthGroup.php 557B Media.php 754B Links.php 502B AuthRule.php 718B Article.php 376B Login.php 400B Admin.php 1KB Cate.php 250B Recharge.php 818B Cart.php 380B controller Sendnewsz.php 15KB Common.php 415B Write.php 243B Taocan.php 244B Login.php 2KB Contact.php 448B Forcase.php 222B Register.php 2KB News.php 2KB Sendnews.php 13KB League.php 244B Chat.php 235B Logout.php 433B Index.php 2KB view index 
article.html 13KB index.html 36KB newarticle.html 13KB write index.html 10KB chat index.html 6KB forcase index.html 12KB sendnews search.html 6KB index.html 13KB public head.html 10KB foot.html 7KB news tag.html 15KB article.html 13KB index.html 13KB newarticle.html 13KB register index.html 28KB sendnewsz search.html 5KB index.html 15KB league index.html 7KB contact article.html 5KB index.html 7KB taocan index.html 27KB login index.html 8KB model H1 1 A 资源评论
N201871643
- 粉丝: 1041
- 资源: 2529
最新资源
- 8051Proteus仿真c源码(proteus)俄罗斯方块程序
- 8051Proteus仿真c源码左右来回的流水灯
- clickhouse-backup 备份工具
- 8051Proteus仿真c源码字符液晶显示的频率计
- 递归神经网络（RNN）基础与实践：自然语言处理的核心.md
- 基于YOLO-lite的web实时人脸检测，tfjs人脸检测，目标检测+源代码+文档说明+数据集（高分作品）
- 8051Proteus仿真c源码正反转可控的直流电机
- axios-1.x 源码
- 8051Proteus仿真c源码正反转可控的步进电机
- 基于yolo-v5实现的火焰图像（视频）识别+python源代码+文档说明（高分作品）
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
