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