public function actionIndex() { //'SELECT * FROM po_type WHERE active = 1 ORDER BY po_type' $po_types = po_type::findAll(['active' => '1']); $departments = department::findAll(['active' => '1']); $buildings = building::findAll(['active' => '1']); $rooms = room::findAll(['active' => '1']); $sets = sets::findAll(['room_id' => '11']); $consignments = consignment::find()->All(); //print_r($po_types); return $this->render('find', ['consignments' => $consignments, 'po_types' => $po_types, 'departments' => $departments, 'buildings' => $buildings, 'rooms' => $rooms, 'sets' => $sets]); }
public function actionGetSets($room) { $sets = sets::findAll(['room_id' => $room]); foreach ($sets as $set) { echo '<option value = ' . $set->id . '>' . $set->name . '</option>'; } }