se/SE/se-lib/Route/UrlAction/ProjektyProNetMediaRequestApproveZam.php

<?php

Lib::loadClass('RouteBase');
Lib::loadClass('TypespecialVariable');
Lib::loadClass('Request');
Lib::loadClass('Response');

class Route_UrlAction_ProjektyProNetMediaRequestApproveZam extends RouteBase {// TODO: UrlActionBase @see Route_UrlAction

	public function handleAuth() {
		if (!User::logged()) {
			User::authByRequest();
		}
	}

	public function defaultAction() {
		SE_Layout::gora();
		if (1 != V::get('_print', '', $_GET)) SE_Layout::menu();
		try {
			$data = array();
			$data['id_order'] = V::get('ID_ORDER', 0, $_REQUEST, 'int');
			if (!$data['id_order']) throw new Exception("Error: Brak nr zamówienia!");
			$data = $this->setProps($data);
			if (V::get('_change', '', $_POST)) {
				$this->changeStatusToWaitingApproval($data);
			} else {
				$this->previewOrder($data);
			}
		} catch (Exception $e) {
			SE_Layout::alert('danger', "Error #" . $e->getCode() .  "|" . $e->getLine() .  ": " . $e->getMessage());
		}
		SE_Layout::dol();
	}

	public function setProps($data) {
		$idOrder = V::get('id_order', 0, $data, 'int');
		if (!$idOrder) throw new Exception("Error: Brak nr zamówienia!");
		$data['id_order'] = $idOrder;
		$data['zamowienie_label'] = '';

		$data['orderRaw'] = DB::getPDO()->fetchAll("
			select r.ID
					, r.ORDER_LABEL
					, r.ID_PROJECT
					, sum(o.OFFER_PRICE_PER_UNIT * o.OFFER_QUANTITY) as SUM_NETTO
					, p.M_DIST_DESC
			from CRM_LISTA_ZASOBOW_ORDERS r
				join IN7_MK_BAZA_DYSTRYBUCJI p on(p.ID = r.ID_PROJECT)
				left join CRM_LISTA_ZASOBOW_OFFERS o on(
					o.ID_ORDER = r.ID
					and (o.A_STATUS is null or o.A_STATUS not in('DELETED'))
				)
			where (r.A_STATUS is null or r.A_STATUS not in('DELETED'))
				and r.ID = {$idOrder}
		");
		if (empty($data['orderRaw'])) throw new Exception("Error: Brak danych dla zamówienia {$idOrder}!");
		$data['orderRaw'] = $data['orderRaw'][0];
		$data['zamowienie_label'] = $data['orderRaw']['ORDER_LABEL'];
		$data['zamowienie_suma'] = number_format($data['orderRaw']['SUM_NETTO'], 2, ',', ' ');
		$data['id_project'] = $data['orderRaw']['ID_PROJECT'];
		$data['project_label'] = $data['orderRaw']['M_DIST_DESC'];

		return $data;
	}

	public function previewOrder($data) {
?>
<div class="container">
	<h1>Zamówienie: <?php echo $data['zamowienie_label']; ?>
		<br><small>Dotyczy projektu: <?php echo $data['project_label']; ?></small>
	</h1>

	<?php echo SE_Layout::alert('info', "Suma netto zamówienia: <b>{$data['zamowienie_suma']}</b>"); ?>

	<form style="text-align:center" method="post">
		<input type="hidden" name="_route" value="UrlAction_ProjektyProNetMediaRequestApproveZam">
		<input type="hidden" name="ID_ORDER" value="<?php echo $data['id_order']; ?>">
		<input type="hidden" name="_change" value="1">
		<input type="submit" class="btn btn-lg btn-primary" value="Zmień status"/>
		<span style="font-size:1.6em">na <code>OCZEKUJE_ZATWIERDZENIA</code></span>
	</form>

	<hr>
	<?php Router::getRoute('UrlAction_ProjektyProNetMediaZamZlec')->previewOrder($data['id_order']); ?>
</div>
<?php
	}

	public function changeStatusToWaitingApproval($data) {
		$idOrder = V::get('id_order', 0, $data, 'int');
		if (!$idOrder) throw new Exception("Error: Brak nr zamówienia!");
		$sqlObj = array();
		$sqlObj['ID'] = $idOrder;
		$sqlObj['APPROVE_STATUS'] = 'OCZEKUJE_ZATWIERDZENIA';
		$affected = DB::getDB()->UPDATE_OBJ('CRM_LISTA_ZASOBOW_ORDERS', (object)$sqlObj);
		echo '<div class="container">';
		if ($affected >= 0) {
			SE_Layout::alert('success', "Zmieniono status zamówienia na OCZEKUJE_ZATWIERDZENIA");
		} else {
			SE_Layout::alert('danger', "Wystąpiły błędy podczas zmieniania statusu zamówienia");
		}
		?>
		<div style="text-align:center">
			<a href="index.php?_route=UrlAction_ProjektyProNetMediaZamZlec&ID_PROJECT=<?php echo $data['id_project']; ?>" class="btn btn-primary">Wróć</a>
		</div>
		<?php
		echo '</div>';
	}

}