public function actionWorkshopTo()
{
$consignments = ConsignmentModel::read();
$places_workshop = PlaceModel::readByColumnValue('id_warehouse', 2);
if (isset($_POST['id_consignment']) && isset($_POST['id_from']) && isset($_POST['qty']) && isset($_POST['qty_t']) && isset($_POST['kr']) && isset($_POST['parts'])) {
$move = new MoveModel();
$move->id_type = '4';
$move->id_consignment = $_POST['id_consignment'];
$move->id_from = $_POST['id_from'];
$move->qty_from = $_POST['qty'];
$move->qty_t = $_POST['qty_t'];
$move->kr = $_POST['kr'];
$move->parts = $_POST['parts'];
$move->create();
header('Location: /report/main');
}
$this->render('workshop_to', ['consignments' => $consignments, 'places_workshop' => $places_workshop]);
}
/**
* @param $id
* @return array
*/
public static function getDataForType($id)
{
$list = MoveModel::query('
SELECT DISTINCT
DATE_FORMAT(move.date, "%Y") AS year
FROM move
');
foreach ($list as $key => $value) {
$list[$key]['months'] = MoveModel::query('
SELECT DISTINCT
DATE_FORMAT(move.date, "%M") AS month
FROM move
WHERE DATE_FORMAT(move.date, "%Y") = ' . $value['year'] . '
');
foreach ($list[$key]['months'] as $mkey => $mvalue) {
$list[$key]['months'][$mkey]['rows'] = MoveModel::readByCondition('
move.id_type = :id AND
DATE_FORMAT(move.date, "%Y") = :year AND
DATE_FORMAT(move.date, "%M") = :month
', [':id' => $id, ':year' => $value['year'], ':month' => $mvalue['month']]);
}
}
return $list;
}
public function actionMain()
{
$moves = MoveModel::read();
$this->render('read', ['moves' => $moves]);
}
