| ' . "ID" . ' | '; echo '' . "Nr umowy" . ' | '; echo '' . "Klient" . ' | '; echo '' . "Data umowy" . ' | '; echo '' . "Data końca umowy" . ' | '; echo '' . "Usługi info (brutto)" . ' | ';
echo '' . "Suma (netto)" . ' | ';
echo '' . "Adres" . ' | '; echo '' . "L_APOINTMENT" . ' | '; echo '||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ' . "ID" . ' | '; echo '' . "ID" . ' | '; echo '' . "DATE" . ' | '; echo '' . "USER" . ' | '; echo '' . "TYPE" . ' | '; echo '' . "INFO" . ' | '; echo '|||||||
| '; $link_href = "?" . implode("&", $link_base) . "&_limitstart=0"; echo "Brak danych. Wróć do " . '' . "pierwszej strony" . ''; echo ' | '; } else { foreach ($deals as $r) { $v_usluga_suma = 0; $v_usluga_adresy = array(); if (!empty($r->uslugi)) { foreach ($r->uslugi as $v_usluga) { if ($v_usluga->S_ADDRESS_STREET) { $v_usluga_adresy [$v_usluga->S_ADDRESS_STREET] = true; } $v_usluga_suma += $v_usluga->ABONAMENT_VALUE * (100 + $v_usluga->VAT) / 100.0; } } // filters $hide_row = false; if ($tbl_filters['L_APOINTMENT_DATE']['value'] == 'stare') { $hide_row = true ; //zawsze chowamy wiersz, liczac , ze jakies spotkanie jest nieprzedawnione foreach($v_usluga_adresy as $IN=>$VA) { if (substr($adresy_info[ $IN ]->L_APPOITMENT_DATE,0,10) <= date('Y-m-d')) { $hide_row = false; } } // if($adresy_info[ $v_street ]->L_APPOITMENT_DATE=='2012-10-18') { // $hide_row=true; // echo "TAAAK"; // } // if($r->ID=='206') $hide_row = true; /* if (empty($v_usluga_adresy)) { $hide_row = true; } else { $v_street = reset(array_keys($v_usluga_adresy)); if (!$v_stree || !array_key_exists($v_street, $adresy_info)) { $hide_row = true; } else if ($adresy_info[ $v_street ]->L_APPOITMENT_DATE >= date('Y-m-d')) { $hide_row = true; } } */ } $cls = ''; if ($hide_row) { //continue; $cls = ' style="display:none"'; } echo ''; echo $r->ID; echo ' | '; echo ''; echo $r->P_DEALNUMBER; echo ' | '; echo '';
echo $r->ID_BILLING_USERS;
$link_deal = "?MENU_INIT=USERS2_OFFERS_COSTS_SALES_PLAN&ARG1=DEALS_CHECK_END&_month=2012-07&_deal=" . $r->P_DEALNUMBER . "&_klient=" . $r->ID_BILLING_USERS;
$ico_deal = ' ';
echo " " . '' . $ico_deal . '';
echo ' | ';
echo '';
echo ' | ';
echo '';
echo ' | ';
echo '';
if (empty($r->uslugi)) {
echo '' . "brak usług!" . '';
} else {
foreach ($r->uslugi as $v_usluga) {
echo ' '; } } echo ' | ';
echo ''; if (!empty($r->uslugi)) { echo number_format($v_usluga_suma, 2, '.', ','); } echo ' | '; $cell_cls = ''; $cell_title = ''; if (count($v_usluga_adresy) == 0) { $cell_cls = ' class="err"'; $cell_title = ' title="' . "Brak danych" . '"'; } else if (count($v_usluga_adresy) > 1) { $cell_cls = ' class="err"'; $cell_title = ' title="' . "Za dużo adresów!" . '"'; } echo '';
$link_edit = "?MENU_INIT=USERS2_MARKETING_EDIT&ARG1=EDIT&ARG1_VAL=" . $adresy_info[ $v_street ]->ID;
$link_edit = "index.php?MENU_INIT=VIEWTABLE_AJAX&ZASOB_ID=23#EDIT/{$adresy_info[$v_street]->ID}";
$ico_edit = '![' . $adresy_info[ $v_street ]->ID . '](icon/edit.gif){kind=icon} ';
echo '' . $ico_edit . '';
echo ' | ';
$add_cls = '';
if ($adresy_info[ $v_street ]->L_APPOITMENT_DATE == '') {
$add_cls = ' l_app-date_empty';
} else {
if ($adresy_info[ $v_street ]->L_APPOITMENT_DATE < date('Y-m-d')) {//$_month . '-00'
$add_cls = ' l_app-date_past';
} else {
$add_cls = ' l_app-date_future';
}
}
echo '';
echo ' | ';
echo ''; echo $adresy_info[ $v_street ]->L_APPOITMENT_USER; echo ' | '; echo ''; echo $adresy_info[ $v_street ]->L_APPOITMENT_TYPE; echo ' | '; echo ''; echo $adresy_info[ $v_street ]->L_APPOITMENT_INFO; echo ' | '; } /* echo ''; if ($r->DEALS_ID > 0) { echo $r->DEALS_ID; echo ' / '; echo $r->S_ADDRESS_STREET; } else { echo '' . "brak wpisu w DEALS!" . ''; } echo ' | '; */ echo ''; //extra linia dla zapisania notatek by sqix @2012-10-04 TODO echo '
| Notaki: '.$adresy_info[ $v_street ]->M_REWIR.' | ';
echo 'L2: '.$r->BUA_P_NAME.' tel : '.$r->BUA_P_PHONE.' '; echo 'MK:'.$adresy_info[ $v_street ]->P_NAME.' tel : '.$adresy_info[ $v_street ]->P_PHONE.' | ';
echo ''; echo ' | ||||||||||
'."Update deals stats...".'
'; } } $deals_stats_by_months = ColumnDealsStatus::get_deals_stats_by_months($force_update); echo '' . "Umowy - daty zakończenia" . '
'; echo '| ' . "Koniec umowy (miesiąc)" . ' | '; echo '' . "Ilość" . ' | '; echo '' . "Suma" . ' | '; echo '' . " " . ' | '; echo '
|---|---|---|---|
| '; echo ($r['deal_term_month'] == '0000-00')? "zakończone" : $r['deal_term_month']; echo ' | '; echo ''; echo $r['cnt']; echo ' | '; echo ''; if ($r['suma'] > 0) { echo number_format($r['suma'], 2, ',', ' ') . " zł"; } echo ' | '; echo ''; echo '' . "check" . ''; echo ' | '; echo '
' . implode(" | ", $params['toolbar']) . '
'; } SalesPlan::print_css(); echo ''; $page = V::get('_page', 0, $_GET, 'int'); $sql_limit = 100; if ($page > 0) { $sql_limit .= ' offset ' . ($page * 100); } $arr = array(); $streets_arr = array(); if ($type == 'DEALS_CHECK_WYP') { $sql = "select d.`ID` , d.`P_DEALNUMBER_OLD` , d.`ID_BILLING_USERS` , d.`S_ADDRESS_STREET` , d.`P_DEALDATE` , d.`DEALDESC` , d.`A_STATUS` from `DEALS_TABLE` as d where d.`RODZAJ_DZIALANIA_HANDLOWEGO`='REZYGNACJA WYPROWADZKA' order by d.`P_DEALDATE` desc limit $sql_limit "; } else {// default: DEALS_CHECK_REZ $sql = "select d.`ID` , d.`P_DEALNUMBER_OLD` , d.`ID_BILLING_USERS` , d.`S_ADDRESS_STREET` , d.`P_DEALDATE` , d.`DEALDESC` , d.`A_STATUS` from `DEALS_TABLE` as d where d.`P_DEALNUMBER_OLD`>0 and (d.`P_DEALNUMBER`=0 or d.`P_DEALNUMBER`='' or d.`P_DEALNUMBER` is null) and d.`A_STATUS` in('NORMAL', 'WAITING') order by d.`P_DEALDATE` desc limit $sql_limit "; } $res = DB::query( $sql ); while ($r = DB::fetch( $res )) { $arr []= $r; if (isset($r->S_ADDRESS_STREET)) { $streets_arr[$r->S_ADDRESS_STREET] = true; } } $adresy_info = array(); $cols_adresy = array(); $cols_adresy['ID'] = 'ID'; $cols_adresy['L_APPOITMENT_DATE'] = 'DATE'; $cols_adresy['L_APPOITMENT_USER'] = 'USER'; $cols_adresy['L_APPOITMENT_INFO'] = 'TYPE'; $cols_adresy['L_APPOITMENT_TYPE'] = 'INFO'; if (!empty($streets_arr)) { $sql_adresy = array(); foreach ($streets_arr as $k_street => $v_val) { $sql_adresy []= "'{$k_street}'"; } $db = DB::getDB(); $sql = "select m.`ID` , m.`S_ADDRESS_STREET` , m.`L_APPOITMENT_DATE` , m.`L_APPOITMENT_USER` , m.`L_APPOITMENT_INFO` , m.`L_APPOITMENT_TYPE` , m.`P_NAME`, m.`P_PHONE`, m.`M_REWIR` from `USERS2_MARKETING` as m where m.`S_ADDRESS_STREET` in (" . implode(", ", $sql_adresy) . ") "; $res = $db->query($sql); while ($r = $db->fetch($res)) { $adresy_info [$r->S_ADDRESS_STREET] = $r; } } echo ''; if ($type == 'DEALS_CHECK_WYP') { echo "Umowy - rezygnacje wyprowadzka"; } else { echo "Umowy - rezygnacje"; } echo '
'; $cols = array_keys(get_object_vars(reset($arr))); echo '' . "Strona: "; for ($i = 0; $i <= $page; $i++) { echo ' ' . ($i + 1) . ''; } echo ' ' . " next " . ''; echo '
'; if (empty($arr)) { echo ''."Brak danych - wróć do " . '' . "pierwszej strony" . '' .'
'; } else { echo '| ' . $k_field . ' | '; } echo '' . "L_APOINTMENT" . ' | '; echo '|||
|---|---|---|---|---|
| ' . $col . ' | '; } echo '||||
| ' . $r->$k_field . ' | '; } if (isset($r->S_ADDRESS_STREET) && array_key_exists($r->S_ADDRESS_STREET, $adresy_info)) { $adres = $adresy_info[$r->S_ADDRESS_STREET]; foreach ($cols_adresy as $k_col => $v_label) { if ($k_col == 'ID') { echo '';
$link_edit = "?MENU_INIT=USERS2_MARKETING_EDIT&ARG1=EDIT&ARG1_VAL={$adres->$k_col}";
$link_edit = "index.php?MENU_INIT=VIEWTABLE_AJAX&ZASOB_ID=23#EDIT/{$adresy_info[$v_street]->ID}";
echo '';
echo '';
echo '';
echo ' | ';
} else if ($k_col == 'L_APPOITMENT_DATE') {
$add_cls = '';
if ($adres->$k_col == '') {
$add_cls = ' l_app-date_empty';
} else {
if ($adres->$k_col < date('Y-m-d')) {//$_month . '-00'
$add_cls = ' l_app-date_past';
} else {
$add_cls = ' l_app-date_future';
}
}
echo '';
echo ' | ';
} else {
echo '' . $adres->$k_col . ' | '; } } } else { echo ''."".' | '; } echo '