application/controllers/admincpVendercode.php

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

/**
 * 厂家码管理列表
 * @author lxn
 */
class Vendercode extends CI_Controller
{
    private static $data = array();

    public function __construct()
    {
        parent::__construct();
        $this->load->model('User_model', 'user');
        $this->load->model('Public_model', 'public');
        $this->load->model('Webcommon_model', 'common');
        $this->load->model('Vendercode_model', 'vender');
        self::$data['header'] = $this->public->header('');
        self::$data['left'] = $this->public->leftmenu('');
        self::$data['footer'] = $this->public->footer();
        $this->load->library('Session');
        $this->public->authentication();
    }

    /**
     * 厂家码列表
     */
    public function index()
    {
        if ($_GET) {
            //获取Datatables发送的参数 必要
            $draw = $_GET['draw'];//这个值作者会直接返回给前台
            //排序
            $order_column = $_GET['order']['0']['column'];//那一列排序，从0开始
            $order_dir = $_GET['order']['0']['dir'];//ase desc 升序或者降序
            //拼接排序sql
            $orderSql = "";
            if (isset($order_column)) {
                $i = intval($order_column);
                switch ($i) {
                    case 0;
                        $orderSql = " order by id " . $order_dir;
                        break; //ID
                    case 2;
                        $orderSql = " order by owner_name " . $order_dir;
                        break; //发布时间
                    case 3;
                        $orderSql = " order by create_admin " . $order_dir;
                        break; //分类
                    case 4;
                        $orderSql = " order by create_time " . $order_dir;
                        break;
                    case 5;
                        $orderSql = " order by status " . $order_dir;
                        break;

                    default;
                        $orderSql = '';
                }
            }
            //搜索
            $search = $_GET['search']['value'];//获取前台传过来的过滤条件

            //分页
            $start = $_GET['start'];//从多少开始
            $length = $_GET['length'];//数据长度
            $limitSql = '';
            $limitFlag = isset($_GET['start']) && $length != -1;
            if ($limitFlag) {
                $limitSql = " LIMIT " . intval($start) . ", " . intval($length);
            }
            $where = "";
            //状态查询
            if (isset($_GET['stime']) && $_GET['stime'] != 'all') {
                $stime = $_GET['stime'];
                $where .= " AND  a.create_time >=" . $stime;
            }
            //状态查询
            if (isset($_GET['etime']) && $_GET['etime'] != 'all') {
                $etime = $_GET['etime'];
                $where .= " AND  a.create_time <=" . $etime;
            }
            //定义查询数据总记录数sql
            $sumSql = "SELECT count(*) as sum FROM vendor as a  where id>0  " . $where;
            //定义过滤条件查询过滤后的记录数sql
            $sumSqlWhere =' and a.code LIKE "%'. $search .'%"';
            //条件过滤后记录数 必要
            $recordsFiltered = 0;
            //表的总记录数 必要
            $recordsTotal = 0;
            //查询总数
            $total = $this->common->getsqldata($sumSql);
            $recordsTotal = $total[0]['sum'];
            $totalResultSql = "SELECT a.*,au.adminName  from vendor as a left join admin au on a.create_admin = au.adminId where a.id>0 " . $where;
            if (strlen($search) > 0) {
                //记录总数
                $total = $this->common->getsqldata($sumSql . $sumSqlWhere);
                $recordsFiltered = $total[0]['sum'];
                $list = $this->common->getsqldata($totalResultSql . $sumSqlWhere . $orderSql . $limitSql);
            } else {
                //记录总数
                $recordsFiltered = $recordsTotal;
                $list = $this->common->getsqldata($totalResultSql . $orderSql . $limitSql);
            }
            header("Content-Type:text/html;charset=utf-8");
            foreach ($list as $key => $value) {


            }
            exit(json_encode(array(
                "draw" => intval($draw),
                "recordsTotal" => intval($recordsTotal),
                "recordsFiltered" => intval($recordsFiltered),
                "data" => $list
            )));
        } else {
            $this->load->view('admincp/vendercode/index', self::$data);
        }
    }


    /**
     * 添加新厂家码
     */
    public function addvendercode()
    {
        $this->load->view('/admincp/vendercode/addvendercode', self::$data);
    }

    /**
     * 删除角色
     */
    public function delete()
    {
        $res = array(
            'err' => 1,
            'msg' => '系统错误'
        );
        $userId = trim($this->input->get_post('userId'));
        $userInfo = $this->user->getUserRow($userId, 2);

        if (empty($userInfo)) {
            $res['msg'] = '参数错误';
            echo json_encode($res);
            exit();
        }
        $dzData = array('deleteFlag' => 1);
        $bool = $this->user->delete($userId);
//         $bool = $this->dz->delete( $listId );
        $res['err'] = $bool ? 0 : 1;
        $res['msg'] = $bool ? '删除成功' : '删除失败';
        echo json_encode($res);
        exit();
    }

    /**
     * 更改厂家码状态
     */
    public function updatestate()
    {
        $res = array(
            'err' => 1,
            'msg' => '系统错误'
        );
        $status = $this->input->get_post('status');
        $id = $this->input->get_post('id');

        $venderarr = array(
            'status' => $status
        );
        $bool = $this->vender->setUserByID($venderarr,$id);
//        echo $this->db->last_query();
        $res['err'] = $bool ? 0 : 1;
        $res['msg'] = $bool ? '更改成功' : '更改失败';
        echo json_encode($res);
        exit();
    }

    public function updateData()
    {
        $code = $this->input->get_post('code');
        $ownerName = $this->input->get_post('ownerName');
        $venderData = array(
            'code' => $code,
            'owner_name' => $ownerName,
            'create_admin' => $_SESSION['adminId'],
            'status' => 'normal',//0正常1停用
            'create_time' => date('Y-m-d H:i:s')
        );
        try {
            $bool = $this->vender->insertData($venderData);
        } catch (Exception $e) {
            $bool = false;
        }


        $referer = $this->config->item('base_url') . '/admincp/Vendercode/index';
        $msg = $bool ? '添加成功!' : '添加失败!';
        $isok = $bool ? 0 : 1;
        echo $this->public->message($msg, $referer, $isok);
        exit;
    }

}