Order.php 1.02 KB
Newer Older
Qiang Xue committed
1 2 3 4
<?php

namespace yiiunit\data\ar;

5 6 7 8 9 10 11 12
/**
 * Class Order
 *
 * @property integer $id
 * @property integer $customer_id
 * @property integer $create_time
 * @property string $total
 */
Qiang Xue committed
13 14
class Order extends ActiveRecord
{
Qiang Xue committed
15
	public static function tableName()
Qiang Xue committed
16 17 18
	{
		return 'tbl_order';
	}
Qiang Xue committed
19

Qiang Xue committed
20
	public function getCustomer()
Qiang Xue committed
21
	{
22
		return $this->hasOne(Customer::className(), ['id' => 'customer_id']);
Qiang Xue committed
23 24
	}

Qiang Xue committed
25
	public function getOrderItems()
Qiang Xue committed
26
	{
27
		return $this->hasMany(OrderItem::className(), ['order_id' => 'id']);
Qiang Xue committed
28 29
	}

Qiang Xue committed
30
	public function getItems()
Qiang Xue committed
31
	{
32
		return $this->hasMany(Item::className(), ['id' => 'item_id'])
Alexander Makarov committed
33
			->via('orderItems', function ($q) {
34 35
				// additional query configuration
			})->orderBy('id');
Qiang Xue committed
36 37
	}

Qiang Xue committed
38
	public function getBooks()
Qiang Xue committed
39
	{
40
		return $this->hasMany(Item::className(), ['id' => 'item_id'])
Alexander Makarov committed
41 42
			->viaTable('tbl_order_item', ['order_id' => 'id'])
			->where(['category_id' => 1]);
Qiang Xue committed
43
	}
Qiang Xue committed
44 45 46 47 48 49 50 51 52 53

	public function beforeSave($insert)
	{
		if (parent::beforeSave($insert)) {
			$this->create_time = time();
			return true;
		} else {
			return false;
		}
	}
Zander Baldwin committed
54
}