erp/core/CoreApp/controllers/Shopsku.php

<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Shopsku extends Start_Controller {
	public function __construct(){
		parent::__construct();
		$this->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.'<br>';
				}
				$shop = explode(',',trim($value['shop'],','));
				foreach ($shop as $v) 
		        {
			    	$v = $s[$v];
				    $info_list[$key]['shop'] .= $v.'<br>';
				}
			}
			$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));
		}
    }
}