args[$k] = $v; } public function get($k) { return V::get($k, null, $this->args); } function print_css() { $col_silver = "#faf2f2"; $col_silver_0 = "#ddd";//"#F2F2F2"; $col_silver_1 = "#e6e6e6";//"#fff"; $col_hover = "#daf9da"; $col_sub_hover = "#ffe5b5"; return ''; } function print_jquery_ui() { $out = '' . "\n"; $out .= '' . "\n"; return $out; } function print_ui_widget_info($title, $msg = '') { $out .= '
'; $out .= '
'; $out .= '

'; $out .= ' ' . $title . '

'; if (!empty($msg)) { $out .= '

' . $msg . '

'; } $out .= '
'; $out .= '
'; return $out; } function print_ui_widget_ok($title, $msg = '') { $out .= '
'; $out .= '
'; $out .= '

'; $out .= ' ' . $title . '

'; if (!empty($msg)) { $out .= '

' . $msg . '

'; } $out .= '
'; $out .= '
'; return $out; } function print_ui_widget_errors($title, $errors_arr = array()) { $out = ''; $out .= '
'; $out .= '
'; $out .= '

'; $out .= 'Error: ' . $title . '

'; if (!empty($errors_arr)) { $out .= ''; } $out .= '
'; $out .= '
'; return $out; } function print_simple_tbl_header($cols, $caption = '') { if (!empty($caption)) echo '' . $caption . ''; $is_ID = in_array('ID', $cols); echo ''; if ($is_ID) { echo '' . "ID" . ''; } foreach ($cols as $v_field_name) { if ($is_ID && $v_field_name == 'ID') continue; echo '' . str_replace('_', ' ', $v_field_name) . ''; } echo ''; } function print_simple_tbl_body_row($obj, $cols, $params = array()) { $is_ID = in_array('ID', $cols); $cls = V::get('class', '', $params); if (!empty($cls)) $cls = ' class="' . $cls . '"'; echo ''; if ($is_ID) { if (isset($obj->ID)) { echo '' . $obj->ID . ''; } else { echo '' . " " . ''; } } foreach ($cols as $v_field_name) { if ($is_ID && $v_field_name == 'ID') continue; if (isset($obj->$v_field_name)) { echo ''; if (strlen($obj->$v_field_name) > 20) { echo '' . substr($obj->$v_field_name, 0, 20) . "..." . ''; } else { echo $obj->$v_field_name; } echo ''; } else { echo '' . " " . ''; } } echo ''; } function print_simple_tbl($obj, $cols, $caption = '') { echo ''; if (!empty($caption)) echo ''; PokazOfertyView::print_simple_tbl_header($cols); echo ''; PokazOfertyView::print_simple_tbl_body_row($obj, $cols); echo ''; echo '
' . $caption . '
'; } function printServices($user, $active_deals_by_id) { ?>

Aktualne umowy

Brak aktualnych umów $v_deal) { if (!empty($v_deal->services)) { foreach ($v_deal->services as $k_p_service => $v_srv_arr) { foreach ($v_srv_arr as $k_srv_id => $v_srv) { if ($v_srv->_status != 'NORMAL') { $has_not_active = true; } } } } } if ($has_not_active) : ?> $v_deal) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; if (empty($v_deal->services)) { echo ''; } else { echo ''; echo ''; echo ''; echo ''; } } ?>
ID Numer umowy Data umowy Termin Adres Pakiet
' . $v_deal->ID_DEALS . '' . "Numer: " . $v_deal->P_DEALNUMBER . '' . "Data: " . $v_deal->P_DEALDATE . '' . "Termin: " .$v_deal->P_DEALDATE_TERM . '' . $v_deal->SERVICES_S_ADDRESS_STREET . '' . "Pakiet: " . (($v_deal->ID_OFFERS_GROUP > 0)? $v_deal->ID_OFFERS_GROUP : '' . "nieznany" . '') . '
' . "Brak przypisanych usług" . '
' . " " . ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($v_deal->services as $k_p_service => $v_srv_arr) { foreach ($v_srv_arr as $k_srv_id => $v_srv) { $ses_x_a = null; if (!array_key_exists($k_srv_id, $v_deal->ses_x_a)) { echo 'brak danych'; } else { $ses_x_a = $v_deal->ses_x_a[$k_srv_id]; } echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '' . "\n"; } } echo ''; echo '
' . "ID" . '' . "P_SERVICE" . '' . "ABONAMENT_VALUE" . '' . "ID_OFFERS" . '' . "description" . '' . "parametry (ses_x_a)" . '' . "T WHEN CONNECTED" . '' . "STATUS" . '' . "HANGUP" . '
' . $v_srv->ID . '' . $v_srv->P_SERVICE . '' . $v_srv->ABONAMENT_VALUE . '' . $v_srv->ID_OFFERS . '' . $v_srv->description . ''; if ($ses_x_a) { // show params $srv_params = array(); if ($v_srv->NAME_LIST_SERVICES == 'USERS2') { $srv_params []= '' . $ses_x_a->P_SERVICE_QUOTA . "kbit" . ''; if ($ses_x_a->CONN_DIV == 'YES') { $srv_params []= '' . "CONN_DIV" . ''; } if ($ses_x_a->S_PUBLIC_IP == 'YES') { $srv_params []= '' . "S_PUBLIC_IP" . ''; } if ($ses_x_a->S_E_PORT_1293 == 'YES') { $srv_params []= '' . "PORT" . ''; } if ($ses_x_a->S_SOHO_WIFI_ROUTER_1292 == 'YES') { $srv_params []= '' . "WIFI ROUTER" . ''; } //echo'
TV (F.' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($ses_x_a);echo'
'; } else if ($v_srv->NAME_LIST_SERVICES == 'TV') { $srv_params []= '' . $ses_x_a->P_SERVICE_CLASS . ''; if ($ses_x_a->P_DEVICE != 'BRAK') { $srv_params []= '' . $ses_x_a->P_DEVICE . ''; } if ($ses_x_a->P_SERVICE_SOCKETS_AMMOUNT_1298 > 0) { $srv_params []= '' . "Dodatkowe gniazda: " . $ses_x_a->P_SERVICE_SOCKETS_AMMOUNT_1298 . ''; } if ($ses_x_a->ID_DOMAINS_PACKET_ID > 0) { $srv_params []= '' . $ses_x_a->ID_DOMAINS . ": " . $ses_x_a->ID_DOMAINS_PACKET_ID . ''; } //echo'
TV (F.' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($ses_x_a);echo'
'; } else if ($v_srv->NAME_LIST_SERVICES == 'VOIP') { if (!empty($ses_x_a->S_PHONE_NUMBER)) { $srv_params []= '' . $ses_x_a->S_PHONE_NUMBER . ''; } if (!empty($ses_x_a->ID_DOMAINS)) { $srv_params []= '' . $ses_x_a->ID_DOMAINS . ": " . $ses_x_a->ID_DOMAINS_PACKET_ID . ''; } } if (empty($srv_params)) { echo 'brak danych'; } else { echo implode(', ', $srv_params); } } echo '
'; if ($ses_x_a) { echo $ses_x_a->T_WHEN_CONNECTED; } echo ''; echo ($v_srv->A_STATUS_DESC)? $v_srv->A_STATUS_DESC : $v_srv->_status; echo ''; if ($v_srv->HANGUP_FROM || $v_srv->HANGUP_TILL) { if ($v_srv->HANGUP_STATUS) { echo ' ' . $v_srv->HANGUP_STATUS . ''; } echo ' ('; echo ($v_srv->HANGUP_FROM)? $v_srv->HANGUP_FROM : '0000-00-00'; echo ' - '; echo ($v_srv->HANGUP_TILL)? $v_srv->HANGUP_TILL : '0000-00-00'; echo ')'; } echo '
'; echo '
Dane klienta ID_BILLING_USERS . (($user->is_firma)? ' ' . "(firma)" . '' : ''); ?> BILLING_OWNER == 1) : ?> BIALL-NET BILLING_OWNER == 2) : ?> NETDAY Aktualne umowy
Imię i nazwiskoP_NAME . " " . $user->P_NAME_SECOND; ?>
adresul. P_ADDRESS_STREET . " " . $user->P_ADDRESS_HOUSE . "/" . $user->P_ADDRESS_HOME . ", " . $user->P_ADDRESS_POST_CODE . " " . $user->P_ADDRESS_CITY; ?>
tel.P_PHONE; ?>
mailuser_mail_contact; ?>
Brak aktualnych umów $v_deal) { if (!empty($v_deal->services)) { foreach ($v_deal->services as $k_p_service => $v_srv_arr) { foreach ($v_srv_arr as $k_srv_id => $v_srv) { if ($v_srv->_status != 'NORMAL') { $has_not_active = true; } } } } } if ($has_not_active) : ?> $v_deal) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; if (empty($v_deal->services)) { echo ''; } else { echo ''; echo ''; echo ''; echo ''; } } ?>
ID Numer umowy Data umowy Termin Adres Pakiet
' . $v_deal->ID_DEALS . '' . "Numer: " . $v_deal->P_DEALNUMBER . '' . "Data: " . $v_deal->P_DEALDATE . '' . "Termin: " .$v_deal->P_DEALDATE_TERM . '' . $v_deal->SERVICES_S_ADDRESS_STREET . '' . "Pakiet: " . (($v_deal->ID_OFFERS_GROUP > 0)? $v_deal->ID_OFFERS_GROUP : '' . "nieznany" . '') . '
' . "Brak przypisanych usług" . '
' . " " . ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($v_deal->services as $k_p_service => $v_srv_arr) { foreach ($v_srv_arr as $k_srv_id => $v_srv) { $ses_x_a = null; if (!array_key_exists($k_srv_id, $v_deal->ses_x_a)) { echo 'brak danych'; } else { $ses_x_a = $v_deal->ses_x_a[$k_srv_id]; } echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '' . "\n"; } } echo ''; echo '
' . "ID" . '' . "P_SERVICE" . '' . "ABONAMENT_VALUE" . '' . "ID_OFFERS" . '' . "description" . '' . "parametry (ses_x_a)" . '' . "T WHEN CONNECTED" . '' . "STATUS" . '' . "HANGUP" . '
' . $v_srv->ID . '' . $v_srv->P_SERVICE . '' . $v_srv->ABONAMENT_VALUE . '' . $v_srv->ID_OFFERS . '' . $v_srv->description . ''; if ($ses_x_a) { // show params $srv_params = array(); if ($v_srv->NAME_LIST_SERVICES == 'USERS2') { $srv_params []= '' . $ses_x_a->P_SERVICE_QUOTA . "kbit" . ''; if ($ses_x_a->CONN_DIV == 'YES') { $srv_params []= '' . "CONN_DIV" . ''; } if ($ses_x_a->S_PUBLIC_IP == 'YES') { $srv_params []= '' . "S_PUBLIC_IP" . ''; } if ($ses_x_a->S_E_PORT_1293 == 'YES') { $srv_params []= '' . "PORT" . ''; } if ($ses_x_a->S_SOHO_WIFI_ROUTER_1292 == 'YES') { $srv_params []= '' . "WIFI ROUTER" . ''; } //echo'
TV (F.' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($ses_x_a);echo'
'; } else if ($v_srv->NAME_LIST_SERVICES == 'TV') { $srv_params []= '' . $ses_x_a->P_SERVICE_CLASS . ''; if ($ses_x_a->P_DEVICE != 'BRAK') { $srv_params []= '' . $ses_x_a->P_DEVICE . ''; } if ($ses_x_a->P_SERVICE_SOCKETS_AMMOUNT_1298 > 0) { $srv_params []= '' . "Dodatkowe gniazda: " . $ses_x_a->P_SERVICE_SOCKETS_AMMOUNT_1298 . ''; } if ($ses_x_a->ID_DOMAINS_PACKET_ID > 0) { $srv_params []= '' . $ses_x_a->ID_DOMAINS . ": " . $ses_x_a->ID_DOMAINS_PACKET_ID . ''; } //echo'
TV (F.' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($ses_x_a);echo'
'; } else if ($v_srv->NAME_LIST_SERVICES == 'VOIP') { if (!empty($ses_x_a->S_PHONE_NUMBER)) { $srv_params []= '' . $ses_x_a->S_PHONE_NUMBER . ''; } if (!empty($ses_x_a->ID_DOMAINS)) { $srv_params []= '' . $ses_x_a->ID_DOMAINS . ": " . $ses_x_a->ID_DOMAINS_PACKET_ID . ''; } } if (empty($srv_params)) { echo 'brak danych'; } else { echo implode(', ', $srv_params); } } echo '
'; if ($ses_x_a) { echo $ses_x_a->T_WHEN_CONNECTED; } echo ''; echo ($v_srv->A_STATUS_DESC)? $v_srv->A_STATUS_DESC : $v_srv->_status; echo ''; if ($v_srv->HANGUP_FROM || $v_srv->HANGUP_TILL) { if ($v_srv->HANGUP_STATUS) { echo ' ' . $v_srv->HANGUP_STATUS . ''; } echo ' ('; echo ($v_srv->HANGUP_FROM)? $v_srv->HANGUP_FROM : '0000-00-00'; echo ' - '; echo ($v_srv->HANGUP_TILL)? $v_srv->HANGUP_TILL : '0000-00-00'; echo ')'; } echo '
'; echo '
' . " function show_opcje(cell_id, service){ var n=jQuery('#' + cell_id); if (!n) return; if (n.find('tr').length === 1) {// init, fetch data var tbody_opcje=jQuery('#oferty-opcje-service-' + service).find('tr'); if (tbody_opcje.length > 0) { for (var i = 0; i < tbody_opcje.length; i++) { n.append(jQuery(tbody_opcje[i]).clone()); } } else { n.append('Brak danych'); } } else { if (!n.hasClass('hide_options')) { n.addClass('hide_options'); // remove selected rows and checked inputs n.find('.row-oferty-opcje-selected').removeClass('row-oferty-opcje-selected'); n.find('input[type=\'checkbox\']:checked').attr('checked', false); } else { n.removeClass('hide_options'); } } return false; } function select_option(n){ n=jQuery(n); n.parents('tr:first').toggleClass('row-oferty-opcje-selected'); } function print_umowa(n){ var add=''; n=jQuery(n); n.parents('table').find('input[type=\'checkbox\']:checked').each(function(ind, o){ if (o.value > 0) { add += '&' + o.name + '=' + o.value; } }); n.attr('href', n.attr('href_base') + add); return true; } " . ''; } function get_oferty_opcje_visible_cols() { $cols = array(); $cols ['ID'] = 'ID oferty'; //$cols ['ID_PROCES' ] = ''; $cols ['S_OTHER_INFO' ] = ' ! '; $cols ['P_SERVICE_NAME' ] = 'Nazwa oferty'; $cols ['P_INSTALL_QUOTE' ] = 'Promocyjna cena instalacji (brutto)'; $cols ['P_PROMO_MONTH_PRICE' ] = 'Wartość abonamentu w promocyjnych miesiącach (brutto)'; $cols ['P_CONTRACT_PRICE' ] = 'Wartość abonamentu po promocji (brutto)'; $cols ['P_DEAL_PROMO_MONTHS' ] = 'Ilość promocyjnych miesięcy'; //$cols ['P_DEALTERM_MONTHS' ] = ''; $cols ['P_NORMAL_PRICE' ] = 'Nominalna wartość abonamentu (brutto)'; $cols ['srednia'] = 'Średnia (brutto)'; $cols ['upust'] = 'Upust od ceny normalnej do wyliczeń kary (brutto)'; $cols ['koszt'] = 'Koszt (netto)'; return $cols; } function print_js_show_hide_groups() { return ''; } function print_groups_info_header($params = array()) { echo self::print_js_umowa(); $show_zysk = V::get('show_zysk', $this->get('show_zysk'), $params); $show_www = V::get('show_www', $this->get('show_www'), $params); $show_status = V::get('show_status', $this->get('show_status'), $params); $show_rewir = V::get('show_rewir', $this->get('show_rewir'), $params); echo ''; echo ''; echo ''; if ($show_www) echo ''; if ($show_status) echo ''; if ($show_rewir) echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; if ($show_zysk) { echo ''; echo ''; } echo ''; echo ''; } function print_groups_info_footer() { echo ''; echo '
' . "ID 0_1380" . '' . '' . "www" . $show_www . '' . '' . '' . "status" . $show_status . '' . '' . "rewir" . '' . "nazwa promocji 0_451" . '' . "okres umowy 0_456" . '' . "suma opłat instalacyjnych (brutto)" . '' . "suma abonamentów w promocyjnych miesiącach / po promocji (brutto)" . '' . "średnia kwota (brutto)" . '' . "suma kosztów (netto)" . '' . "zysk (netto)" . '
'; } function print_group_info($group, $params = array()) { $deal_add_opcje_frm = V::get('DealAddOptionsForm', null, $params); $deal_rm_opcje_frm = V::get('DealRmOptionsForm', null, $params); $hide_header = V::get('hide_header', null, $params); $show_zysk = V::get('show_zysk', $this->get('show_zysk'), $params); $show_www = V::get('show_www', $this->get('show_www'), $params); $show_status = V::get('show_status', $this->get('show_status'), $params); $show_rewir = V::get('show_rewir', $this->get('show_rewir'), $params); $opcje_cols = $this->get_oferty_opcje_visible_cols(); if (isset($opcje_cols['koszt'])) { unset($opcje_cols['koszt']); } if (!$hide_header) { $this->print_groups_info_header(); } echo ''; echo '' . $group->get('ID') . ''; if ($show_www) echo '' . '' . $group->get('OFERTA_WWW') . $show_www . '' . ''; if ($show_status) echo '' . '' . $group->get('A_STATUS') . $show_status . '' . ''; if ($show_rewir) echo '' . $group->get('M_REWIR') . ''; echo '' . $group->get('S_ALIAS') . ' (' . $group->get('P_PROMOTION_NAME') . ')'; echo '' . $group->get('P_DEALTERM_MONTHS') . ''; echo '' . number_format($group->suma_P_PROMO_INSTALL_PRICE, 2, ',', ' ') . " zł" . ''; echo '' . "" . number_format($group->suma_P_PROMO_MONTH_PRICE, 2, ',', ' ') . " zł" . " / " . number_format($group->suma_P_CONTRACT_PRICE, 2, ',', ' ') . " zł" . ''; echo '' . "" . number_format($group->suma_P_OFFER_SREDNIA, 2, ',', ' ') . " zł" . ''; if ($show_zysk) { echo '' . "" . number_format($group->suma_P_OFFER_COSTS, 2, ',', ' ') . " zł" . ''; echo '' . "" . number_format($group->suma_P_OFFER_SREDNIA_NETTO - $group->suma_P_OFFER_COSTS, 2, ',', ' ') . " zł" . ''; } echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($opcje_cols as $k_zasob_id => $v_label) { echo ''; } echo ''; echo ''; foreach ($group->get_offers() as $k_p_service => $v_offers_arr) { foreach ($v_offers_arr as $k_offer_id => $v_offer) { echo ''; echo ''; echo ''; foreach ($opcje_cols as $k_field_name => $v_label) { echo ''; } echo ''; echo ''; $oferta_opcje = $group->get_options_by_service($v_offer->P_SERVICE); if (!empty($oferta_opcje)) { foreach ($oferta_opcje as $v_offer_opcja_id => $v_opcja) { echo ''; echo ''; foreach ($opcje_cols as $k_field => $v_type_label) { if ($k_field == 'koszt') { echo ''; } else { echo ''; } } /* echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '';// Średnia echo '';// Upust od ceny normalnej do wyliczeń kary //echo ''; */ echo ''; } } if ($deal_add_opcje_frm) { $add_oferty_opcje = $deal_add_opcje_frm->get_oferty_opcje_by_service($v_offer->P_SERVICE); foreach ($add_oferty_opcje as $k_id => $v_oferta) { if (array_key_exists($k_id, $oferta_opcje)) { continue; } echo ''; echo ''; foreach ($opcje_cols as $k_field => $v_type_label) { if ($k_field == 'koszt') { echo ''; } else { echo ''; } } echo ''; } } } } echo '
'; if (!V::get('hide_print', '', $params)) { $link_href = "./odt2xhtml/1379.umowa.php"; $link_href .= "?id_group=" . $group->get('ID'); if (($user_id = V::get('user_id', 0, $params, 'int')) > 0) { $link_href .= "&id_user={$user_id}"; } $js = "return print_umowa(this);"; echo '' . '' . ''; } echo '' . $v_label . '
'; echo $v_offer->P_SERVICE; echo '' . $v_offer->$k_field_name . '
' . " "; if (!$deal_add_opcje_frm) { if ($deal_rm_opcje_frm) { echo ''; } else { echo ''; echo ''; echo ''; } } echo '' . number_format($v_opcja->$k_field, 2, ',', ' ') . '' . $v_opcja->$k_field . '' . $v_opcja->P_SERVICE_NAME . '' . $v_opcja->P_INSTALL_QUOTE . '' . $v_opcja->P_PROMO_MONTH_PRICE . '' . $v_opcja->P_CONTRACT_PRICE . '' . ((isset($v_opcja->P_DEAL_PROMO_MONTHS))? $v_opcja->P_DEAL_PROMO_MONTHS : 0) . '' . $v_opcja->P_NORMAL_PRICE . '
'; $chck = ($deal_add_opcje_frm->has_option($v_offer->P_SERVICE, $k_id))? ' checked="checked"' : ''; $option_name = 'id_options_' . $v_offer->P_SERVICE . '[]'; echo ''; echo '' . number_format($v_oferta->$k_field, 2, ',', ' ') . '' . $v_oferta->$k_field . '
'; echo ''; echo ''; if (!$hide_header) { $this->print_groups_info_footer(); } } function print_options_tree($options_tree, $cols, $title = 'Wybrane opcje') { echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($cols as $k_field => $v_label) { echo ''; } echo ''; echo ''; foreach ($options_tree as $k_service => $v_options) { echo ''; echo ''; echo ''; echo ''; foreach ($v_options as $v_option) { echo ''; echo ''; foreach ($cols as $k_field => $v_label) { echo ''; } echo ''; } } echo '
' . $title . ':
' . $v_label . '
'; echo $k_service; echo ''; echo '
' . $v_option->$k_field . '
'; } }