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');
}
