50 lines
1.3 KiB
PHP
50 lines
1.3 KiB
PHP
<?php
|
|
|
|
namespace common\models\oldDb;
|
|
|
|
use yii\behaviors\TimestampBehavior;
|
|
use yii\db\ActiveRecord;
|
|
|
|
class DrugStoreDrug extends \common\modelsgii\oldDb\DrugStoreDrug
|
|
{
|
|
public function behaviors()
|
|
{
|
|
return [
|
|
[
|
|
'class' => TimestampBehavior::class,
|
|
'attributes' => [
|
|
ActiveRecord::EVENT_BEFORE_INSERT => ['created_at','updated_at'],
|
|
ActiveRecord::EVENT_BEFORE_UPDATE => ['updated_at'],
|
|
],
|
|
],
|
|
];
|
|
}
|
|
|
|
//关联门店
|
|
public function getStore()
|
|
{
|
|
return $this->hasOne(Store::class,['drugstore_id' => 'drugstore_id']);
|
|
}
|
|
|
|
//关联基础商品
|
|
public function getDrug()
|
|
{
|
|
return $this->hasOne(Drug::class,['id' => 'drug_id']);
|
|
}
|
|
|
|
|
|
public static function inventory($params, $storeId)
|
|
{
|
|
$list = self::find()->with(['drug'])->asArray()->all();
|
|
$result = [];
|
|
foreach ($list as $k => $v) {
|
|
$result[$k]['drug_id'] = $v['drug_id'];
|
|
$result[$k]['drug_name'] = array_key_exists('drug_name', $v['drug'] ?? [])? $v['drug']['drug_name']: '获取失败';
|
|
$result[$k]['market_price'] = $v['market_price'];
|
|
$result[$k]['price'] = $v['price'];
|
|
}
|
|
return $result;
|
|
|
|
}
|
|
}
|