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 actionDelete($id) { $paint = PaintModel::readById($id); $paint->delete(); header('Location: /paint/read'); }