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

1.option改变


    
    
    $vo): ?>
        
    

$(".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.复选框选中加载

	 />全部
      />季度
      />年度
      />利润
    

$('.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.加载更多

    
    $vo): ?>
    	

            
            	

                	{$vo['title']}
                	
                
            
        
    
    
        
暂无

    
    


    加载更多


$(".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';
                    html += '
';
                    html += res.msg.list[i]['title'];
                    html += ''+res.msg.list[i]['time']+'';
                    html += '
';           
                }
                $(".ul1").append(html)
                
            }else{
                layer.msg("加载错误")
            }
        }
    })
})

4.会员导入
1.会员导入


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('已导入！');
}