如果你对该文章中的内容有疑问/不解,可以点击此处链接提问
要注明问题和此文章链接地址 点击此处跳转
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('已导入!'); }