load->_model('Model_shopsku','shopsku');
$this->load->_model('Model_typeclass','typeclass');
$this->load->_model('Model_shop','shop');
}
//定义方法的调用规则 获取URI第二段值
public function _remap($arg,$arg_array)
{
if($arg == 'add')
{
$this->_add();
}
else if($arg == 'edit')
{
$this->_edit($arg_array);
}
else if($arg == 'del')
{
$this->_del();
}
else
{
$this->_index();
}
}
public function _index()
{
$post = $this->input->post(NULL, TRUE);
if(isset($post['page']))
{
$page = $this->input->post('page',true);
$perpage = $this->input->post('perpage',true);
$title = $this->input->post('title',true);
$where = "1=1";
if($title)
{
$where .= " and title like '%$title%'";
}
//数据排序
$order_str = "id desc";
if(empty($page))
{
$start = 0;
$perpage = 1;
}
else
{
$start = ($page - 1)*$perpage;
}
$typeclass = array();
$class = $this->typeclass->find_all();
foreach ($class as $v)
{
$v['spare'] = explode('|',$v['spare']);
$typeclass[$v['id']] = $v['spare'][0];
}
$s = array();
$shop = $this->shop->find_all();
foreach ($shop as $v)
{
$s[$v['id']] = $v['shopname'];
}
$info_list = $this->shopsku->find_all($where,'id,shop,sku',$order_str,$start,$perpage);
foreach ($info_list as $key=>$value)
{
$info_list[$key]['sku'] = '';
$info_list[$key]['shop'] = '';
$sku = explode(',',trim($value['sku'],','));
foreach ($sku as $v)
{
$info_list[$key]['sku'] .= $v.'
';
}
$shop = explode(',',trim($value['shop'],','));
foreach ($shop as $v)
{
$v = $s[$v];
$info_list[$key]['shop'] .= $v.'
';
}
}
$total = $this->shopsku->find_count($where);
$pagenum = ceil($total/$perpage);
$over = $total-($start+$perpage);
$rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list));
echo json_encode($rows);exit;
}
$this->_Template('shopsku',$this->data);
}
public function _add()
{
$post = $this->input->post(NULL, TRUE);
if(isset($post['sku']))
{
if($this->shopsku->insert($post))
{
echo json_encode(array('msg'=>'添加成功','success'=>true));exit;
}
else
{
echo json_encode(array('msg'=>'添加失败,请重试','success'=>false));exit;
}
}
$this->_Template('shopsku_add',$this->data);
}
public function _edit($arg_array)
{
$post = $this->input->post(NULL, TRUE);
if(isset($post['id']))
{
$id = $this->input->post('id',true);
if($this->shopsku->save($post,$id))
{
echo json_encode(array('msg'=>'修改成功','success'=>true));exit;
}
else
{
echo json_encode(array('msg'=>'修改失败,请重试','success'=>false));exit;
}
}
$arg_array = $arg_array[0];
$shopsku = $this->shopsku->read($arg_array);
$this->data['shopsku'] = $shopsku;
$this->_Template('shopsku_edit',$this->data);
}
//删除
public function _del()
{
$post = $this->input->post(NULL, TRUE);
if(isset($post['s']))
{
$id_arr = $this->input->post('s');
$id_arr = explode(',',$id_arr);
if(!$id_arr)
{
echo json_encode(array('msg'=>'参数错误!','success'=>false));exit;
}
//循环删除记录
foreach ($id_arr as $v)
{
$this->shopsku->remove($v);
}
echo json_encode(array('del'=>$id_arr,'msg'=>'删除记录成功!','success'=>true));
}
}
}