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)); } } }