Order.php 1.63 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
	}

38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
	public function getItemsInOrder1()
	{
		return $this->hasMany(Item::className(), ['id' => 'item_id'])
			->via('orderItems', function ($q) {
				$q->orderBy(['subtotal' => SORT_ASC]);
			})->orderBy('name');
	}

	public function getItemsInOrder2()
	{
		return $this->hasMany(Item::className(), ['id' => 'item_id'])
			->via('orderItems', function ($q) {
				$q->orderBy(['subtotal' => SORT_DESC]);
			})->orderBy('name');
	}

Qiang Xue committed
54
	public function getBooks()
Qiang Xue committed
55
	{
56
		return $this->hasMany(Item::className(), ['id' => 'item_id'])
Alexander Makarov committed
57 58
			->viaTable('tbl_order_item', ['order_id' => 'id'])
			->where(['category_id' => 1]);
Qiang Xue committed
59
	}
Qiang Xue committed
60

61 62 63 64 65 66 67
	public function getBooks2()
	{
		return $this->hasMany(Item::className(), ['id' => 'item_id'])
			->onCondition(['category_id' => 1])
			->viaTable('tbl_order_item', ['order_id' => 'id']);
	}

Qiang Xue committed
68 69 70 71 72 73 74 75 76
	public function beforeSave($insert)
	{
		if (parent::beforeSave($insert)) {
			$this->create_time = time();
			return true;
		} else {
			return false;
		}
	}
Zander Baldwin committed
77
}