public function actionPaint() { $paints = PaintModel::read(); $paints = ReportModel::getRemains($paints, 'IFNULL(wf.name, wt.name) AS stock', 'WHERE paint.id = :id GROUP BY stock'); $this->render('paint', ['paints' => $paints]); }
public function actionUpdate($id) { $consignment = ConsignmentModel::readById($id); $paints = PaintModel::read(); if (isset($_POST['name']) && isset($_POST['id_paint']) && isset($_POST['date_of_end'])) { $consignment->name = $_POST['name']; $consignment->id_paint = $_POST['id_paint']; $consignment->date_of_end = $_POST['date_of_end']; $consignment->update(); header('Location: /consignment/read'); } $this->render('update', ['consignment' => $consignment->data, 'paints' => $paints]); }
public function actionRead() { $paints = PaintModel::read(); $this->render('read', ['paints' => $paints]); }