'; if ($affected >= 0) { SE_Layout::alert('success', "Zmieniono status zamówienia na ODRZUCONE"); } else { SE_Layout::alert('danger', "Wystąpiły błędy podczas zmieniania statusu zamówienia"); } ?> '; } 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 finalApproveFormView($data) { ?>