point_mall_card/application/admin/controller/card/Number.php

<?php
namespace app\admin\controller\card;
use app\admin\controller\Admin;

/**
*	发卡
*/
class Number extends Admin{

	protected $CardNumber = null;
	protected function _initialize(){
		parent::_initialize();
		$this->CardNumber = model('card.Number');
	}

	public function index(){
		$this->assign('meta_title','卡号管理');
		$maxid = $this->CardNumber->max('id');
		$this->assign('maxid',$maxid);
		return $this->fetch();
	}

	public function load(){
		$page = input('get.page');
		$limit = input('get.limit');
		$where = [];
		$is_bind = input('get.is_bind');
		if ($is_bind === 0) {
			$where['bind_time'] = 0;
		}else if($is_bind == 1){
			$where['bind_time'] = ['neq',0];
		}
		$no = input('param.no');
		if (!empty($no)) {
			$where['no'] = $no;
		}
		$search = input('get.search');
		if (!empty($search)) {
			$where['c.cname|c.id'] = ['like','%'.$search.'%'];
		}
		$start_id = input('get.start_id');
		$end_id = input('get.end_id');
		if (!empty($start_id) ) {
			if (empty($end_id)) {
				$where['cn.id'] = ['egt',$start_id];
			}else{
				$where['cn.id'] = ['between',[$start_id,$end_id]];
			}
		}else if (!empty($end_id)) {
			$where['cn.id'] = ['elt',$end_id];
		}

		$list = $this->CardNumber->field('cn.*')
					->alias('cn')
					->join('Customer c','c.id = cn.customer_id','left')
					->where($where)->order('cn.id desc')->paginate($limit,false,['page'=>$page]);
		$data = [];
		foreach ($list as $key => $value) {
			$data[$key]['id'] = $value['id'];
			$data[$key]['no'] = $value['no']."\t";
			$data[$key]['secret'] = $value['secret'];
			$data[$key]['denomination'] = $value['denomination'];
			$data[$key]['balance'] = $value['balance'];
			if (!empty($value['expire_start_time'])) {
				$data[$key]['expire_start_time'] = date('Y-m-d',$value['expire_start_time']);
			}else{
			    $data[$key]['expire_start_time'] = '';
			}
			if (!empty($value['expire_end_time'])) {
				$data[$key]['expire_end_time'] = date('Y-m-d',$value['expire_end_time']);
			}else{
			    $data[$key]['expire_end_time'] = '';
			}
			if (!empty($value['sale_time'])) {
				$data[$key]['sale_time'] = date('Y-m-d H:i:s',$value['sale_time']);
			}else{
			    $data[$key]['sale_time'] = '';
			}
			if (!empty($value['bind_time'])) {
				$data[$key]['bind_time'] = date('Y-m-d H:i:s',$value['bind_time']);
			}else{
			    $data[$key]['bind_time'] = '';
			}
			$data[$key]['state'] = $value['state'];
			$data[$key]['create_time'] = $value['create_time'];

			$customer = $value['customer'];
			if ($customer) {
				$data[$key]['customer'] = $customer['cname'].'['.$customer['id'].']';
			}else{
			    $data[$key]['customer'] = '';
			}
			$goods_type = $value['goods_type'];
			if ($goods_type) {
				$goods_type_str = '';
				foreach ($goods_type as $k => $val) {
					$goods_type_str .= '【'.$val['cname'].'】';
				}
				$data[$key]['goods_type'] = $goods_type_str;
			}else{
				$data[$key]['goods_type'] = '全品类';
			}
            $store_type = $value['store_type'];
            if ($store_type) {
                $store_type_str = '';
                foreach ($store_type as $k => $val) {
                    $store_type_str .= '【'.$val['cname'].'】';
                }
                $data[$key]['store_type'] = $store_type_str;
            }else{
                $data[$key]['store_type'] = '全品类';
            }

			$url = "https://mall-h5.jucai.gov.cn/member/bind_card?card_no=".$value['no']."&card_pwd=".$value['secret'];
			$data[$key]['qrcode'] = createqrcode($url);
		}
		$this->output(0,'获取成功',$data,$list->total());
	}

	public function state(){
		if($this->request->isPost()){
			$id = input('post.id');
			$number = $this->CardNumber->where(['id'=>$id])->find();
			if (!$number) {
				$this->output(1,'参数错误');
			}
	        $state = input('post.state');
	        $number->state = $state == 'true'?1:0;
	        $result = $number->save();
	        if (!$result) {
	        	$this->output(1,'保存失败');
	        }
	        $this->output(0,'保存成功');
		}
	}
}