Пример #1
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getIdMattraffic()
 {
     return $this->hasOne(Mattraffic::className(), ['mattraffic_id' => 'id_mattraffic'])->from(['idMattraffic' => Mattraffic::tableName()])->inverseOf('trMats');
 }
Пример #2
0
 public function getCurrentMattraffic()
 {
     return $this->hasOne(Mattraffic::className(), ['id_material' => 'material_id'])->from(['currentmattraffic' => Mattraffic::tableName()])->leftJoin('mattraffic mt1', 'currentmattraffic.id_material = mt1.id_material and `currentmattraffic`.`mattraffic_tip` IN (1, 2) and mt1.mattraffic_tip IN (1, 2) and (currentmattraffic.mattraffic_date < mt1.mattraffic_date or currentmattraffic.mattraffic_date = mt1.mattraffic_date  and currentmattraffic.mattraffic_id < mt1.mattraffic_id)')->andWhere(['in', 'currentmattraffic.mattraffic_tip', [1, 2]])->andWhere(['mt1.mattraffic_date' => NULL]);
 }
Пример #3
0
 public function getIdMattraffic()
 {
     $a = new TrOsnov();
     return $a->hasOne(Mattraffic::className(), ['mattraffic_id' => 'id_mattraffic'])->from(['idMattraffic' => Mattraffic::tableName()]);
 }
Пример #4
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getMattraffics()
 {
     return $this->hasMany(Mattraffic::className(), ['id_mol' => 'employee_id'])->from(['mattraffics' => Mattraffic::tableName()]);
 }