项目总结 -option改变/复选框选中加载/加载更多/导入数据

1.option改变

<select id="title_search" name="title_search"  class="center-block color_fff ss1">
    <option value ="0" style="display:none;"><?php echo $pro_id!=0 ? get_pro_name($pro_id) : '搜索产品名称'; ?></option>
    <?php if(is_array($p_list)): ?>
    <?php foreach($p_list  as $k=>$vo): ?>
        <option value ="{$vo['pid']}"><?php echo get_pro_name($vo['pid']); ?></option>
    <?php endforeach; endif; ?>
</select>
$(".ss1").on('change',function(){
    var pro_id = $(".ss1 option:selected").val();
    window.location.replace("//{$web_url}"+'/index.php/default/index.html?pro_id='+pro_id); 
})

2.复选框选中加载
<form class="tj_type" method="get">
	<label><input type="checkbox"  id="all"  class="ccc" name="type_all" value="1" <?php echo $type['type_all']==1?"checked":''; ?> /><span>全部</span></label>
    <label><input type="checkbox" class="ccc" name="type_jd" value="1" <?php echo ($type['type_jd']==1 && $type['type_all']!==1)?"checked":''; ?>  /><span>季度</span></label>
    <label><input type="checkbox"  class="ccc" name="type_nd"  value="1" <?php echo ($type['type_nd']==1 && $type['type_all']!==1)?"checked":''; ?>  /><span>年度</span></label>
    <label><input type="checkbox"  class="ccc" name="type_lr" value="1" <?php echo ($type['type_lr']==1 && $type['type_all']!==1)?"checked":''; ?>  /><span>利润</span></label>
    <input type="text" / placeholder="<?php echo $keyword!=0 ? $keyword :'关键词搜索';  ?>" id="search1" name="keyword" class="placeholder_color">
</form>
$('.tj_type input[type="checkbox"]').on('change',function(){
    var pro_id = {$pro_id}?{$pro_id} : 0;
    if(pro_id){
        // alert("存在")
        var url = '__URL__/url_tran.html?pro_id='+{$pro_id};
    }else{
        var url = '__URL__/url_tran.html';
    }
    var data = $(".tj_type input,.tj_type select,.tj_type textarea,.tj_type option,.tj_type radio").serialize();      
    $.ajax({
        type:'post',
        url:url,
        data:data,
        dataType:'json',
        success:function(res){
            console.log(res.msg)
            window.location.replace(res.msg); 
        }
    })
});

3.加载更多
<ul class="container ul1">
    <?php if(is_array($list)): ?>
    <?php foreach($list as $k=>$vo): ?>
    	<li class="clearfix">
            <a href="{$vo['url']}" class="color_000">
            	<p class="title pull-left">
                	{$vo['title']}
                	<span class="color_ccc pull-right"><?php echo date("Y-m-d",$vo['time']); ?></span>
                </p>
            </a>
        </li>
    <?php endforeach;  ?>
    <?php else: ?>
        <p style="text-align: center;">暂无</p>

    <?php endif; ?>
    
</ul>
<?php if(is_array($list)): ?>
    <a href="javascript:void(0)" class="load_more color_000 text-center">加载更多</a>
<?php endif; ?>

$(".load_more").on("click",function(){
    var length = $(".container li").length
    $.ajax({
        type:'post',
        url:'__URL__/load_more.html',
        data:{length:length,pro_id:{$pro_id},keyword:{$keyword}},
        dataType:'json',
        success:function(res){
            if(res.result==1){
                if(!res.msg.list || res.msg.more==0){
                    layer.msg("没有了")
                    $(".load_more").text("没有了")
                }
                var html= ""
                for(var i=0;i<res.msg.num;i++){
                    html += '<li class="clearfix">';
                    html += '<a href="'+res.msg.list[i]['url'] +'" class="color_000">';
                    html += '<p class="title pull-left">';
                    html += res.msg.list[i]['title'];
                    html += '<span class="color_ccc pull-right">'+res.msg.list[i]['time']+'</span>';
                    html += '</p></a></li>';           
                }
                $(".ul1").append(html)
                
            }else{
                layer.msg("加载错误")
            }
        }
    })
})

4.会员导入
<button type="button" class="layui-btn" id="member_up"><i class="layui-icon"></i>1.会员导入</button>
<script type="text/javascript">
	layui.use(['layer', 'upload'], function(){
	  var layer = layui.layer
	  ,upload = layui.upload;

	  //用户上传
	   upload.render({
	     elem: '#member_up'
	     ,url: "__URL__/import_member.html"
	     ,accept: 'file' //普通文件
	     ,done: function(res){
	       if(res.result==1){
	        layer.msg(res.msg);
	        setTimeout(function () {
	          window.location.reload()
	        }, 3000);
	       }else{
	        layer.msg(res.msg);

	       }
	     }
	   });
	});
</script>

public function import_member(){
    $fileName = $_FILES['file']['name'];//文件名
    $tmpName = $_FILES['file']['tmp_name'];//临时存放的目录
    $fileError = $_FILES['file']['error'];
    $fileType = $_FILES['file']['type'];
    $fileSize = $_FILES['file']['size'];

    if($fileError>0){
        switch($fileError){
            case 1:
                echo "上传的文件超过了 php.ini 中 upload_max_filesize 选项限制的值";
                break;
            case 2:
                echo "上传文件的大小超过了 HTML 表单中 MAX_FILE_SIZE 选项指定的值";
                break;
            case 3:
                echo "文件只有部分被上传";
                break;
            case 4:
                echo "没有文件被上传";
                break;
            case 6:
                echo "找不到临时文件夹。PHP 4.3.10 和 PHP 5.0.3 引进";
                break;
            case 7:
                echo "文件写入失败。PHP 5.1.0 引进";
                break;
        }
    }   
    $ext = pathinfo($fileName,PATHINFO_EXTENSION);//类型
    $saveName = 'member_'.date('Ymd').mt_rand(1,100).'.'.$ext;
    //生成保存路径
    $uploads = "./uploads/";
    $path = rtrim($uploads,'/')."/".date('Y/m/d/');
    if(!file_exists($path)){
        mkdir($path,0777,true);
    }
    $saveFile = $path .$saveName;
    if(move_uploaded_file($tmpName,$saveFile)){
        // echo "上传成功";
        $ret['message']= $saveFile;
    }else{
      $this->jserroor("上传失败");die;
    }

    require_once '/include/ext/PHPExcel.php';
    require_once '/include/ext/PHPExcel/IOFactory.php';
    require_once '/include/ext/PHPExcel/Reader/Excel5.php';
    //以上三步加载phpExcel的类
    $objReader = PHPExcel_IOFactory::createReader('Excel5');//use excel2007 for 2007 format
    $filename=$saveFile;//指定excel文件从上传中取出
    $objPHPExcel = $objReader->load($filename); //$filename可以是上传的文件，或者是指定的文件
    $sheet = $objPHPExcel->getSheet(0);
    $highestRow = $sheet->getHighestRow(); // 取得总行数
    $highestColumn = $sheet->getHighestColumn(); // 取得总列数
    $k = 0;
    //循环读取excel文件,读取一条,保存一条
    for($j=2;$j<=$highestRow;$j++) {//j=2是因为第一行表为提示，从第二行开始取 { 
        $a = $objPHPExcel->getActiveSheet()->getCell("A".$j)->getValue();//获取A列的值
        $b = $objPHPExcel->getActiveSheet()->getCell("B".$j)->getValue();//获取B列的值
        $c = $objPHPExcel->getActiveSheet()->getCell("C".$j)->getValue();//获取C列的值
        $d = $objPHPExcel->getActiveSheet()->getCell("D".$j)->getValue();//获取C列的值

        $data[$j]['uid'] = $a;
        $data[$j]['username'] = $b;
        $data[$j]['tel'] = $c;
        $data[$j]['idcode'] = $d;
        $data[$j]['password'] = md5(substr($data[$j]['idcode'],-6));
        $data[$j]['createtime'] = time();

        //判断是否存在
        $res_if = $this->model->table('member')->where("tel=".$data[$j]['tel'])->find();
        if(!$res_if){
            //执行添加
            $res_add = $this->model->table('member')->data($data[$j])->insert();
            if(!$res_add){
                $data_log['msg'] = 'user error';
                $data_log['tel'] = $data[$j]['tel'];
                $data_log['tel'] = $data[$j]['tel'];
                logOutput($data_log);
            }
        }
    }
    // echo $_GET['refreshUrl'];die;
    $this->jssuccess('已导入！');
}