TP5.1模型的增删改查及软删除应用

摘要：<?php namespace app\index\controller; use think\Controller; use app\index\model\goods as GoodsModel; class Goods extends Controller { public functio

<?php
namespace app\index\controller;

use think\Controller;

use app\index\model\goods as GoodsModel;

class Goods extends Controller
{
	public function find(GoodsModel $Goods)
	{
		// dump($Goods->getName());
		$Goods->typeid= '16';
		$Goods->pname = '九妹槟榔';
		$Goods->price = 10.00;
		$Goods->pcount= 30;
		$Goods->save();
	}
	public function query()
	{
		// $Goods = GoodsModel::get(1);
		// dump($Goods);
		// var_dump($Goods);
		// echo $Goods['pname'];
		// echo $Goods->price;
		// $goods = GoodsModel::get(function($query)
		// {
		// 	$query->where('typeid','>',12)
		// 		->where('price','>',5);
		// });
		// $goods = GoodsModel::where('typeid','>',5)
		// 	->where('price','>',5)
		// 	->limit(3)
		// 	->all();
		// echo $goods;
		$typeid = $this->request->param('typeid')?:10;
		$price = $this->request->param('price')?:5;
		$goods = GoodsModel::all(function($query)use ($typeid,$price)
		{
			$query->where('typeid','>',$typeid)
				->where('price','>',$price);
		});
		dump($goods);
		foreach ($goods as $value)
		{
			echo $value['pname'].'<br>';
		}
	}
	public function update()
	{
		// $goods = GoodsModel::get(16);
		// $goods->price=5.00;
		// $goods->save();
		// GoodsModel::update(
		// [
		// 	'pname'=>'友文槟榔',
		// 	'price'=>3,
		// 	'pcount'=>66
		// ],
		// [
		// 	'pid'=>16
		// ]);
		// GoodsModel::update(
		// 	[
		// 		'pcount' => \think\Db::raw('pcount+30')
		// 	],function($query)
		// 	{
		// 		$query->where('pid',16);
		// 	});
		GoodsModel::where('pid',16)
		->data(['pcount'=>\think\Db::raw('pcount+10')])
		->update();
	}
	public function create()
	{
		$data = [
			'typeid'=>18,
			'pname'=>'金白沙',
			'price'=>9,
			'pcount'=>40
		];
		$field = ['typeid','pname','price','pcount'];
		// return GoodsModel::create($data,$field)?'ok':'oh no~';
		GoodsModel::insert($data);
	}
	public function delete()
	{
		// GoodsModel::destroy(14);
		GoodsModel::destroy(function($query)
		{
			$query->where('pid','>=',21);
		});
	}

	public function softDelete()
	{
		// GoodsModel::destroy(19);

		$goods = GoodsModel::all(function($query)
			{
				$query->where('pid','>','15');
			});
		$res = GoodsModel::withtrashed()
		->where('pid','>',15)
		->select();
		$res = GoodsModel::onlytrashed()
		->where('pid','>',15)
		->select();
		dump($res);
	}
}

TP5.1模型的增删改查及软删除应用

批改老师：韦小宝批改时间：2019-01-03 09:10:58
老师总结：写的很规范！很完整！不错不错！课后多看看tp的手册，可以让我们开发更方便！