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

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

use App\Http\Requests\Admin\Stock as Request;
use App\Models\AdminUser;
use App\Models\Producer;
use App\Models\Product;
use App\Models\Stock as Model;
use Illuminate\Support\Carbon;

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

	/**
	 * 首页列表
	 * 
	 * */
    public function index(Model $Model,AdminUser $AdminUser,Product $Product,Producer $Producer){
		// 接受参数
		$code					= request('enter_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[] = ['stock.id','=',$id];
		if( $productId )		$map[] = ['product.id','=',$productId];
		if( $productName )		$map[] = ['product.name','=',$productName];
		if( $startTime )		$map[] = ['stock.insert_time','>=',Carbon::createFromFormat('Y-m-d',$startTime)->startOfDay()->getTimestamp()];
		if( $endTime )			$map[] = ['stock.insert_time','<=',Carbon::createFromFormat('Y-m-d',$endTime)->endOfDay()->getTimestamp()];
		if( !is_null($status) )	$map[] = ['stock.status','=',$status];
		// 查询数据
		$list					= $Model->query()->join('product','stock.product_id','=','product.id')
								->where($map)
								->orderByDesc('id')
								->select(['stock.*','product.name as product_name','product.spec as product_spec','product.producer_id as producer_id','product.price','product.market_price'])
								->paginate(request('limit',config('page_num',10)))
								->appends(request()->all());
		// 循环处理数据
		foreach ($list as $key => $value) {
			// id转编号
			$value['enter_code']	= $Model->idToCode($value['id']);
			// id转编号
			$value['product_code']	= $Product->idToCode($value['product_id']);
			// 创建人员
			$value['admin_name']	= $AdminUser->getOne($value['admin_uid'],'username');
			// 创建人员
			$value['producer_name']	= $Producer->getOne($value['producer_id'],'name');
			// 重组
			$list[$key]				= $value;
		}
		// 分配数据
		$this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
		$this->assign('list', $list);
		// 加载模板
		return $this->fetch();
    }

	/**
	 * 添加
	 * 
	 * */
	public function add( Request $request, Model $Model,Product $Product,Producer $Producer){
		if( request()->isMethod('post') ){
			// 验证参数
			$request->scene('add')->validate();
			// 组合数据
			$data['quantity']		= request('quantity',0);
			$data['produce_batch']	= request('produce_batch','');
			$data['produce_time']	= request('produce_time','');
			$data['exp_time']		= request('exp_time','');
			$data['produce_time']	= strtotime($data['produce_time']);
			$data['exp_time']		= strtotime($data['exp_time']);
			$data['product_id']		= $Product->codeToId(request('product_code',''));
			$data['admin_uid']		= admin('uid');
			// 提示新增失败
			if( !$data['product_id'] ) return json_send(['code'=>'error','msg'=>'请核对产品编码']);
			// 写入
			$id						= $Model->add($data);
			// 提示新增失败
			if( !$id )				return json_send(['code'=>'error','msg'=>'新增失败']);
			// 库存更新
			$Product->updateStock($data['product_id'],$data['quantity']);
			// 记录行为
			$this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
			// 告知结果
			return					json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
		}
		// 获取编码转ID
		$productData				= $Product->codeToId(request('product_code',''));
		// 查询数据
		$productData				= $productData ? $Product->query()->find($productData,['id','producer_id','price','market_price','spec']) : [];
		// 如果有数据的话
		if( $productData )			{
			// 数据转换
			$productData			= $productData->toArray();
			$productData['producer_name'] = $Producer->getOne($productData['producer_id'],'name');
		}
		// 分配数据
		$this->assign('productData',$productData);
		$this->assign('crumbs','新增');
		// 加载模板
		return 					$this->fetch();
	}
	
	/**
	 * 编辑
	 * 
	 * */
	public function edit( Request $request, Model $Model,Product $Product){
		// 接收参数
		$id							= request('id',0);
		// 查询数据
		$oldData					= $Model->where(['id'=>$id])->first();
		// 修改
		if(request()->isMethod('post')){
			// 验证参数
			$request->scene('edit')->validate();
			// 组合数据
			$data['quantity']		= request('quantity',0);
			$data['produce_batch']	= request('produce_batch','');
			$data['produce_time']	= request('produce_time','');
			$data['exp_time']		= request('exp_time','');
			$data['produce_time']	= strtotime($data['produce_time']);
			$data['exp_time']		= strtotime($data['exp_time']);
			$data['product_id']		= $Product->codeToId(request('product_code',''));
			$data['admin_uid']		= admin('uid');
			// 提示新增失败
			if( !$data['product_id'] ) return json_send(['code'=>'error','msg'=>'请核对产品编码']);
			// 写入
			$result					= $Model->edit($id,$data);
			// 提示新增失败
			if( !$result )			return json_send(['code'=>'error','msg'=>'修改失败']);
			// 记录行为
			$this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,[],$data);
			// 告知结果
			return					json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);			
		}
		// 如果是没有数据
		if( !$oldData ) 			return $this->error('查无数据');
		// 转产品编码
		$oldData['product_code']	= $Product->idToCode($oldData['product_id']);
		// 分配数据
		$this->assign('oldData',$oldData);
		$this->assign('crumbs','修改');
		// 加载模板
		return 						$this->fetch();
	}

	/**
	 * 状态
	 * 
	 * */
	public function set_status( Request $request, Model $Model ){
		// 验证参数
		$request->scene('set_status')->validate();
		// 接收参数
		$id				= request('id',0);
		$status			= request('status',0);
		// 查询数据
		$result			= $Model->edit($id,['status'=>$status]);
		// 提示新增失败
		if( !$result )	return json_send(['code'=>'error','msg'=>'设置失败']);
		// 记录行为
		$this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,[],['status'=>$status]);
		// 告知结果
		return			json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
	}

}