public function updateStatus($stationId, $decimal)
{
$binary = Convert::dec2Bin($decimal, 10);
// get equipments
$query = new Query();
$query->select('b1.*, b2.sort')->from('equipment_status b1')->leftJoin('equipment b2', 'b1.equipment_id = b2.id')->where(['station_id' => $stationId]);
$equipments = $query->createCommand()->queryAll();
if (!empty($equipments)) {
foreach ($equipments as $e) {
Yii::$app->db->createCommand()->update('equipment_status', ['status' => $binary[$e['sort']]], ['station_id' => $stationId, 'equipment_id' => $e['equipment_id']])->execute();
}
}
}
