/**
*
*/
defined('BASEPATH') OR exit('No direct script access allowed');
class Monthsx extends CI_Controller
{
function __construct()
{
parent::__construct();
}
public function index(){
$res['date']=$this->db->get('month_type')->result_array();
$this->load->view('month/index.html',$res);
}
public function sear(){
$mid =$this->input->get('mid');
$date=$this->db->get_where('type','mid='.$mid)->result_array();
echo json_encode($date);
}
public function save_type(){
$id =$this->input->get('str');
$mid =$this->input->get('mid');
//选中默认
$sql='UPDATE type set ismr=1 where id in('.$id.')';
//取消默认
$sql2='UPDATE type set ismr=0 where id not in('.$id.') and mid='.$mid;
$res1=$this->db->query($sql);
$res2=$this->db->query($sql2);
if($res1){
echo '1';
}else{
echo '0';
}
}
}
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<script type="text/javascript" src="<?php echo base_url();?>public/home/js/jquery1.js"></script>
</head>
<body>
商品分类:
<select name="type" class="sel">
<option value="0">请选择</option>
<?php foreach($date as $v): ?>
<option value="<?=$v['mid']?>"><?=$v['m_name']?></option>
<?php endforeach; ?>
</select>
<div id="ser" style="display: none;"></div>
</body>
<script>
$('.sel').change(function(){
_this=$(this);
mid=_this.val();
var url='<?php echo site_url("&d=home&c=monthsx&m=sear");?>';
if(mid!=0){
$.get(url,{mid:mid},function(msg){
var str='';
$.each(msg,function(k,v){
if(v['ismr']==1){
str+='<input type="checkbox" name="ismr[]" value="'+v['id']+'" checked/>'+v['t_name']+'<br>';
}else{
str+='<input type="checkbox" name="ismr[]" value="'+v['id']+'"/>'+v['t_name']+'<br>';
}
})
$('#ser').html(str+'<button class="btn-sv">保存</button>');
$('#ser').show(500)
},'json');
}
});
//保存
$(document).on('click','.btn-sv',function(){
var ch=$('input:checked').length;
var str='';
if(ch!=0){
for(var i=0;i<ch;i++){
str+=','+$('input:checked').eq(i).val();
}
str=str.substr(1)
}
var url='<?php echo site_url("&d=home&c=monthsx&m=save_type");?>';
$.get(url,{str:str,mid:mid},function(msg){
if(msg==1){
alert('更改成功')
$('#ser').hide(500)
}else{
alert('更改失败')
}
});
});
</script>
</html>