kailin/app/Http/Controllers/Admin/OrdersProduct.php

<?php namespace App\Http\Controllers\Admin;

use App\Models\AdminUser;
use App\Models\Product;
use App\Models\Orders;
use App\Models\OrdersProduct as Model;
use App\Http\Requests\Admin\OrdersProduct as Request;

/**
 * 订单管理
 *
 * @author    刘相欣
 *
 */
class OrdersProduct extends Auth{
	
	protected function _initialize(){
		parent::_initialize();
		$this->assign('breadcrumb1','订单管理');
		$this->assign('breadcrumb2','订单管理');
	}

	/**
	 * 首页列表
	 * 
	 * */
    public function index(Model $Model,AdminUser $AdminUser,Product $Product,Orders $Orders){
		// 接受参数
		$code					= request('out_code','');
		$productCode			= request('product_code','');
		$productCode			= request('product_code','');
		$productName			= request('product_name','');
		$status					= request('status');
		$startTime				= request('start_time','');
		$endTime				= request('end_time','');
		// 编码转ID
		$id						= $code ? $Model->codeToId($code) : 0;
		$productId				= $productCode ? $Product->codeToId($productCode) : 0;
		// 查询条件
		$map 					= [];
		// 编码ID
		if( $id )				$map[] = ['orders_product.id','=',$id];
		if( $productId )		$map[] = ['product.id','=',$productId];
		if( $productName )		$map[] = ['product.name','=',$productName];
		if( $startTime )		$map[] = ['orders_product.insert_time','>=',strtotime($startTime)];
		if( $endTime )			$map[] = ['orders_product.insert_time','<=',strtotime($endTime)];
		if( !is_null($status) )	$map[] = ['orders_product.status','=',$status];
		// 查询数据
		$list					= $Model->query()->join('product','orders_product.product_id','=','product.id')
								->where($map)
								->orderByDesc('id')
								->select(['orders_product.*','product.name as product_name'])
								->paginate(request('limit',config('page_num',10)))
								->appends(request()->all());
		// 循环处理数据
		foreach ($list as $key => $value) {
			// id转编号
			$value['out_code']		= $Model->idToCode($value['id']);
			// id转编号
			$value['product_code']	= $Product->idToCode($value['product_id']);
			// id转编号
			$value['order_code']	= $Orders->idToCode($value['order_id']);
			// 创建人员
			$value['admin_name']	= $AdminUser->getOne($value['admin_uid'],'username');
			// 重组
			$list[$key]				= $value;
		}
		// 分配数据
		$this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
		$this->assign('list', $list);
		// 加载模板
		return $this->fetch();
    }

	/**
	 * 状态
	 * 
	 * */
	public function set_status( Request $request, Model $Model,Product $Product){
		// 验证参数
		$request->scene('set_status')->validate();
		// 接收参数
		$id				= request('id',0);
		$status			= request('status',0);
		// 获取产品和数量
		$oldData 		= $Model->query()->find($id,['prouduct_id','buy_num']);
		// 如果用户不存在
		if( !$oldData )	return json_send(['code'=>'error','msg'=>'用户不存在']);
		// 查询数据
		$result			= $Model->edit($id,['status'=>$status]);
		// 提示新增失败
		if( !$result )	return json_send(['code'=>'error','msg'=>'设置失败']);
		// 如果是取消订单,库存更新
		if( $status == 4 ) $Product->updateStock($oldData['product_id'],$oldData['buy_num']);
		// 记录行为
		$this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,[],['status'=>$status]);
		// 告知结果
		return			json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
	}

}