$instance
$instance : object
Reference to the CI singleton
厂家码管理列表
This class object is the super class that every library in CodeIgniter will be assigned to.
<?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;
}
}