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.ORDER_TYPE
, 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'];
$data['ORDER_TYPE'] = $data['orderRaw']['ORDER_TYPE'];
return $data;
}
public function previewOrder($data) {
?>
:
Dotyczy projektu:
{$data['zamowienie_suma']}"); ?>
previewOrder($data['id_order']); ?>
UPDATE_OBJ('CRM_LISTA_ZASOBOW_ORDERS', (object)$sqlObj);
echo '';
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");
}
?>
';
}
}