EDYCJA ',SERVICES.NAME_LIST_SERVICES,'')";
$_SESSION['SERVICES_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['SHOW_RECORD_L3']=$_SESSION['SERVICES_COLUMN']['RELATIVEDB']['TRG_COLUMN']['SHOW_RECORD_L3'];
$_SESSION['SERVICES_COLUMN']['RELATIVEDB']['JOINQUERY']['L3_SERVICE_INFO_TABLES']="left join SES_USERS2_A as L3_SERVICE_INFO_TABLES_USERS2 on L3_SERVICE_INFO_TABLES_USERS2.ID_SERVICES=SERVICES.ID
left join SES_VOIP_A as L3_SERVICE_INFO_TABLES_VOIP_A on L3_SERVICE_INFO_TABLES_VOIP_A.ID_SERVICES=SERVICES.ID
left join SES_TV_A as L3_SERVICE_INFO_TABLES_TV_A on L3_SERVICE_INFO_TABLES_TV_A.ID_SERVICES=SERVICES.ID
";
//EOF @2012-10-05 definicja SERVICES RELATIVEDB
//BEGIN BILLING_USERS_ADD
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['SRC_COLUMN']['L2_SERVICE_STATUS']="L3_SERVICE_INFO_TABLES";
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN']['L2_SERVICE_STATUS']=$A_STATUS_L2_SQL;
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['L2_SERVICE_STATUS']=$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN']['L2_SERVICE_STATUS'];
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['SRC_COLUMN']['L3_SERVICE_STATUS']="L3_SERVICE_INFO_TABLES";
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN']['L3_SERVICE_STATUS']="concat_ws('',L3_SERVICE_INFO_TABLES_USERS2.A_STATUS,L3_SERVICE_INFO_TABLES_VOIP_A.A_STATUS,L3_SERVICE_INFO_TABLES_TV_A.A_STATUS)";
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['L3_SERVICE_STATUS']=$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN']['L3_SERVICE_STATUS'];
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['SRC_COLUMN']['L3_SERVICE_INFO']="L3_SERVICE_INFO_TABLES";
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN']['L3_SERVICE_INFO']="concat_ws('',SV.NAME_LIST_SERVICES,' ',concat('ULICA:',L3_SERVICE_INFO_TABLES_USERS2.S_ADDRESS_STREET),
concat(' TELEFON:',L3_SERVICE_INFO_TABLES_VOIP_A.S_PHONE_NUMBER),
concat(' ULICA:',L3_SERVICE_INFO_TABLES_TV_A.S_ADDRESS_STREET,' TV_CLASS:',L3_SERVICE_INFO_TABLES_TV_A.P_SERVICE_CLASS))";
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['L3_SERVICE_INFO']=$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN']['L3_SERVICE_INFO'];
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['SRC_COLUMN']['SHOW_RECORD_L3']="L3_SERVICE_INFO_TABLES";
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN']['SHOW_RECORD_L3']="concat('EDYCJA L3 ',SV.NAME_LIST_SERVICES,'')";
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['SHOW_RECORD_L3']=$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN']['SHOW_RECORD_L3'];
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['SRC_COLUMN']['SHOW_RECORD_L2']="L3_SERVICE_INFO_TABLES";
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN']['SHOW_RECORD_L2']="concat('EDYCJA L2 ',SV.NAME_LIST_SERVICES,'')";
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['SHOW_RECORD_L3']=$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['TRG_COLUMN']['SHOW_RECORD_L3'];
$_SESSION['BILLING_USERS_ADD_COLUMN']['RELATIVEDB']['JOINQUERY']['L3_SERVICE_INFO_TABLES']="
left join SERVICES as SV on SV.ID_BILLING_USERS=BILLING_USERS_ADD.id_users
left join SES_USERS2_A as L3_SERVICE_INFO_TABLES_USERS2 on L3_SERVICE_INFO_TABLES_USERS2.ID_SERVICES=SV.ID
left join SES_VOIP_A as L3_SERVICE_INFO_TABLES_VOIP_A on L3_SERVICE_INFO_TABLES_VOIP_A.ID_SERVICES=SV.ID
left join SES_TV_A as L3_SERVICE_INFO_TABLES_TV_A on L3_SERVICE_INFO_TABLES_TV_A.ID_SERVICES=SV.ID
";
//END BILLING_USERS_ADD
//TODO!!!
//$_SESSION['SES_USERS2_A_COLUMN']['RELATIVEDB']=$_SESSION['SES_USERS2_A_COLUMN']['RELATIVEDB'];
//$_SESSION['SES_USERS2_A_COLUMN']['TYPESPECIAL']=$_SESSION['SES_USERS2_A_COLUMN']['TYPESPECIAL'];
$_SESSION['USERS2_WINDYKACJA_COLUMN']['RELATIVEDB']['SRC_COLUMN']['P_NAME_R']="bu";
$_SESSION['USERS2_WINDYKACJA_COLUMN']['RELATIVEDB']['TRG_COLUMN']['P_NAME_R']="concat(bu.P_NAME , ' ', bu.P_NAME_SECOND)";
$_SESSION['USERS2_WINDYKACJA_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['P_NAME_R']="concat(bu.P_NAME , ' ', bu.P_NAME_SECOND)";
$_SESSION['USERS2_WINDYKACJA_COLUMN']['RELATIVEDB']['SRC_COLUMN']['P_ADDRESS_R']="bu";
$_SESSION['USERS2_WINDYKACJA_COLUMN']['RELATIVEDB']['TRG_COLUMN']['P_ADDRESS_R']="concat(bu.P_ADDRESS_POST_CODE , ' ', bu.P_ADDRESS_CITY , ', ul. ' , bu.P_ADDRESS_STREET , ' ' , bu.P_ADDRESS_HOUSE , ' / ' , bu.P_ADDRESS_HOME)";
$_SESSION['USERS2_WINDYKACJA_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['P_ADDRESS_R']="concat(bu.P_ADDRESS_POST_CODE , ' ', bu.P_ADDRESS_CITY , ', ul. ' , bu.P_ADDRESS_STREET , ' ' , bu.P_ADDRESS_HOUSE , ' / ' , bu.P_ADDRESS_HOME)";
$_SESSION['USERS2_WINDYKACJA_COLUMN']['RELATIVEDB']['JOINQUERY']['bu']="LEFT JOIN `BILLING_USERS_ADD` as bu on (USERS2_WINDYKACJA.`ID_BILLING_USERS`=bu.`id_users`)";
$_SESSION['IN7_DZIENNIK_KORESP_COLUMN']['RELATIVEDB']['SRC_COLUMN']['ID_PROJECT']="IN7_MK_BAZA_DYSTRYBUCJI";
$_SESSION['IN7_DZIENNIK_KORESP_COLUMN']['RELATIVEDB']['TRG_COLUMN']['ID_PROJECT']="concat('Znak Pisma( xx-',IN7_MK_BAZA_DYSTRYBUCJI.P_ID,'-',IN7_MK_BAZA_DYSTRYBUCJI.ID,'-',IN7_DZIENNIK_KORESP.ID,') (',IN7_MK_BAZA_DYSTRYBUCJI.M_DIST_DESC,')',IN7_MK_BAZA_DYSTRYBUCJI.M_DISTRIBUTOR,' ',IN7_MK_BAZA_DYSTRYBUCJI.L_APPOITMENT_USER,'',IN7_MK_BAZA_DYSTRYBUCJI.A_STATUS,'') ";
$_SESSION['IN7_DZIENNIK_KORESP_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['ID_PROJECT']="concat(IN7_MK_BAZA_DYSTRYBUCJI.M_DIST_DESC,IN7_MK_BAZA_DYSTRYBUCJI.ID)";
$_SESSION['IN7_DZIENNIK_KORESP_COLUMN']['RELATIVEDB']['JOINQUERY']['IN7_MK_BAZA_DYSTRYBUCJI']="LEFT JOIN IN7_MK_BAZA_DYSTRYBUCJI on IN7_DZIENNIK_KORESP.ID_PROJECT=IN7_MK_BAZA_DYSTRYBUCJI.ID";
//offer costs
$_SESSION['USERS2_OFFERS_COSTS_COLUMN']['RELATIVEDB']['SRC_COLUMN']['ID_PROJECT']="IN7_MK_BAZA_DYSTRYBUCJI";
$_SESSION['USERS2_OFFERS_COSTS_COLUMN']['RELATIVEDB']['TRG_COLUMN']['ID_PROJECT']="concat(IN7_MK_BAZA_DYSTRYBUCJI.P_ID,'-',IN7_MK_BAZA_DYSTRYBUCJI.ID,'-',IN7_MK_BAZA_DYSTRYBUCJI.M_DIST_DESC,')',IN7_MK_BAZA_DYSTRYBUCJI.M_DISTRIBUTOR,'-',IN7_MK_BAZA_DYSTRYBUCJI.L_APPOITMENT_USER,'-',IN7_MK_BAZA_DYSTRYBUCJI.A_STATUS,'-',IN7_MK_BAZA_DYSTRYBUCJI.TV_SIGAL_DELIVERY) ";
$_SESSION['USERS2_OFFERS_COSTS_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['ID_PROJECT']="concat(IN7_MK_BAZA_DYSTRYBUCJI.P_ID,'-',IN7_MK_BAZA_DYSTRYBUCJI.ID,'-',IN7_MK_BAZA_DYSTRYBUCJI.M_DIST_DESC,'-',IN7_MK_BAZA_DYSTRYBUCJI.A_STATUS,'-',IN7_MK_BAZA_DYSTRYBUCJI.TV_SIGAL_DELIVERY)";
$_SESSION['USERS2_OFFERS_COSTS_COLUMN']['RELATIVEDB']['JOINQUERY']['IN7_MK_BAZA_DYSTRYBUCJI']="LEFT JOIN IN7_MK_BAZA_DYSTRYBUCJI on USERS2_OFFERS_COSTS.ID_PROJECT=IN7_MK_BAZA_DYSTRYBUCJI.ID";
// virtual column
$_SESSION['USERS2_OFFERS_COSTS_COLUMN']['PERMEDIT']['TV_NAZWA_PROGRAMU'] = 'R';
$_SESSION['USERS2_OFFERS_COSTS_COLUMN']['RELATIVEDB']['SRC_COLUMN']['TV_NAZWA_PROGRAMU']="IN7_MK_BAZA_DYSTRYBUCJI";
$_SESSION['USERS2_OFFERS_COSTS_COLUMN']['RELATIVEDB']['TRG_COLUMN']['TV_NAZWA_PROGRAMU']="IN7_MK_BAZA_DYSTRYBUCJI.TV_NAZWA_PROGRAMU";
$_SESSION['USERS2_OFFERS_COSTS_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['TV_NAZWA_PROGRAMU']="IN7_MK_BAZA_DYSTRYBUCJI.TV_NAZWA_PROGRAMU";
$_SESSION['USERS2_OFFERS_COSTS_COLUMN']['RELATIVEDB']['SRC_COLUMN']['ID_COSTS_GROUPS']="USERS2_OFFERS_COSTS_GROUPS";
$_SESSION['USERS2_OFFERS_COSTS_COLUMN']['RELATIVEDB']['TRG_COLUMN']['ID_COSTS_GROUPS']="concat(USERS2_OFFERS_COSTS_GROUPS.ID,'-',USERS2_OFFERS_COSTS_GROUPS.S_OTHER_INFO,'-',USERS2_OFFERS_COSTS_GROUPS.A_STATUS,'(',USERS2_OFFERS_COSTS_GROUPS.P_OFFER_COSTS,')') ";
$_SESSION['USERS2_OFFERS_COSTS_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['ID_COSTS_GROUPS']="concat(USERS2_OFFERS_COSTS_GROUPS.ID,'-',USERS2_OFFERS_COSTS_GROUPS.S_OTHER_INFO,'-',USERS2_OFFERS_COSTS_GROUPS.A_STATUS)";
$_SESSION['USERS2_OFFERS_COSTS_COLUMN']['RELATIVEDB']['JOINQUERY']['USERS2_OFFERS_COSTS_GROUPS']="LEFT JOIN USERS2_OFFERS_COSTS_GROUPS on USERS2_OFFERS_COSTS.ID_COSTS_GROUPS=USERS2_OFFERS_COSTS_GROUPS.ID";
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SRC_COLUMN']['INTERNET_STATUS']="temp_USERS2_INTERNET_STATUS";
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['TRG_COLUMN']['INTERNET_STATUS']="temp_USERS2_INTERNET_STATUS.USERS2_INTERNET_STATUS";
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['INTERNET_STATUS']="temp_USERS2_INTERNET_STATUS.USERS2_INTERNET_STATUS";
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['JOINQUERY']['temp_USERS2_INTERNET_STATUS']="LEFT JOIN temp_USERS2_INTERNET_STATUS as temp_USERS2_INTERNET_STATUS on temp_USERS2_INTERNET_STATUS.S_ADDRESS_STREET=USERS2_MARKETING.S_ADDRESS_STREET ";
//USERS2_OFFERS_COSTS_GROUPS
/* ???
$_SESSION['USERS2_OFFERS_COSTS_GROUPS_COLUMN']['RELATIVEDB']['SRC_COLUMN']['S_OTHER_INFO']="USERS2_OFFERS_COSTS";
$_SESSION['USERS2_OFFERS_COSTS_GROUPS_COLUMN']['RELATIVEDB']['TRG_COLUMN']['S_OTHER_INFO']="USERS2_OFFERS_COSTS_GROUPS.S_OTHER_INFO";
$_SESSION['USERS2_OFFERS_COSTS_GROUPS_COLUMN']['RELATIVEDB']['TRG_COLUMN_NAME']['S_OTHER_INFO']="USERS2_OFFERS_COSTS_GROUPS.S_OTHER_INFO";
$_SESSION['USERS2_OFFERS_COSTS_GROUPS_COLUMN']['RELATIVEDB']['JOINQUERY']['USERS2_OFFERS_COSTS']="LEFT JOIN USERS2_OFFERS_COSTS as USERS2_OFFERS_COSTS on USERS2_OFFERS_COSTS.ID_COSTS_GROUPS=USERS2_OFFERS_COSTS_GROUPS.ID ";
*/
$_SESSION['USERS2_OFFERS_COSTS_GROUPS_COLUMN']['RELATIVEDB']['SQL_QUERY'][1]="
-- update `USERS2_OFFERS_COSTS_GROUPS` ug set
-- `P_OFFER_COSTS`=(select sum(if(us.`COST_ACCOUNTED_ON`='MONTHLY',us.`COST_POWER`,us.`COST_POWER`/12))
-- from `USERS2_OFFERS_COSTS` as us
-- where us.`ID_COSTS_GROUPS`=ug.`ID` and us.`A_STATUS` in('WAITING','NORMAL')
-- ) ;
update `USERS2_OFFERS_COSTS_GROUPS` ug
set
`P_OFFER_COSTS`=(select sum(us.`COST_POWER`)
from `USERS2_OFFERS_COSTS` as us
where
us.`ID_COSTS_GROUPS`=ug.`ID`
and us.`A_STATUS` in('WAITING','NORMAL')
and us.`COST_ACCOUNTED_ON`='MONTHLY'
)
, `P_OFFER_COSTS_START`=(select sum(us.`COST_POWER`)
from `USERS2_OFFERS_COSTS` as us
where
us.`ID_COSTS_GROUPS`=ug.`ID`
and us.`A_STATUS` in('WAITING','NORMAL')
and us.`COST_ACCOUNTED_ON`='START'
)
";
//TODO madrzejsza inicjalizacja zapytania
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SQL_QUERY'][]=" drop table if exists temp_USERS2_INTERNET_STATUS; ";
//@2012-09-24_inicjalizacja danych dla handlowcow by SQIX
//$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SQL_QUERY'][2]=" create table temp_USERS2_INTERNET_STATUS select ID,S_ADDRESS_STREET,concat(A_STATUS,'.',A_STATUS_CURRENT,'.',P_SERVICE,' SPEED:',P_SERVICE_QUOTA,' DEALD:',P_DEALNUMBER,' VIP:',S_VIP_LEVEL) as USERS2_INTERNET_STATUS , P_DEALEXPIRE from USERS2 ; ";
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SQL_QUERY'][]=" create table temp_USERS2_INTERNET_STATUS
select SV.ID,
US2.S_ADDRESS_STREET,
concat_ws('',".$A_STATUS_L2_SQL."
,'.', coalesce(US2.A_STATUS_CURRENT), ' USLUGA:INTERNET(USERS2)' , ' GNIAZDO/USL:',US2.P_SERVICE,' CENA:',coalesce(SV.ABONAMENT_VALUE),' SPEED:',coalesce(US2.P_SERVICE_QUOTA),' DEALD:(',coalesce(DT.ID),coalesce(DT.P_DEALPREFIX), '):', coalesce(DT.P_DEALDATE),'--',coalesce(DT.P_DEALDATE_TERM),
' KONTAKT_L2:',coalesce(BUA.P_PHONE),',', coalesce(BUA.user_mail_contact),',' , coalesce(BUA.P_FAX)) as USERS2_INTERNET_STATUS
, DT.P_DEALDATE_TERM as P_DEALEXPIRE , SV.NAME_LIST_SERVICES
, ".$A_STATUS_L2_SQL."
as A_STATUS, SV.HANGUP_STATUS
from SERVICES as SV
inner JOIN SES_USERS2_A as US2 on SV.ID=US2.ID_SERVICES
inner JOIN BILLING_USERS_ADD as BUA on BUA.id_users=SV.ID_BILLING_USERS
left join DEALS_TABLE as DT on DT.ID=SV.ID_DEALS_TABLE
where SV.NAME_LIST_SERVICES='USERS2' and ( SV.P_ID_SERVICES is NULL or SV.P_ID_SERVICES=0)
;
"; //eof
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SQL_QUERY'][]=" insert ignore into temp_USERS2_INTERNET_STATUS
select SV.ID,
US2.S_ADDRESS_STREET,
concat_ws('',
".$A_STATUS_L2_SQL." ,'.', coalesce(US2.A_STATUS_CURRENT), ' USLUGA:',SV.NAME_LIST_SERVICES , ' GNIAZDO/USL:',US2.P_SERVICE,' CENA:',coalesce(SV.ABONAMENT_VALUE),' DEALD:(',coalesce(DT.ID),coalesce(DT.P_DEALPREFIX), '):', coalesce(DT.P_DEALDATE),'--',coalesce(DT.P_DEALDATE_TERM),
' KONTAKT_L2:',coalesce(BUA.P_PHONE),',' ,coalesce(BUA.user_mail_contact),',' , coalesce(BUA.P_FAX)) as USERS2_INTERNET_STATUS
, DT.P_DEALDATE_TERM as P_DEALEXPIRE , SV.NAME_LIST_SERVICES
, ".$A_STATUS_L2_SQL.", SV.HANGUP_STATUS
from SERVICES as SV
inner JOIN SES_TV_A as US2 on SV.ID=US2.ID_SERVICES
inner JOIN BILLING_USERS_ADD as BUA on BUA.id_users=SV.ID_BILLING_USERS
left join DEALS_TABLE as DT on DT.ID=SV.ID_DEALS_TABLE
where SV.NAME_LIST_SERVICES='TV' and ( SV.P_ID_SERVICES is NULL or SV.P_ID_SERVICES=0)
";
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SQL_QUERY'][]=" insert ignore into temp_USERS2_INTERNET_STATUS
select SV.ID,
US22.S_ADDRESS_STREET,
concat_ws('',".$A_STATUS_L2_SQL."
,'.', coalesce(US2.A_STATUS_CURRENT), ' USLUGA:',SV.NAME_LIST_SERVICES , ' GNIAZDO/USL:',US2.S_PHONE_NUMBER,' CENA:',coalesce(SV.ABONAMENT_VALUE),' DEALD:(',coalesce(DT.ID),coalesce(DT.P_DEALPREFIX), '):', coalesce(DT.P_DEALDATE),'--',coalesce(DT.P_DEALDATE_TERM) ,
' KONTAKT_L2:',coalesce(BUA.P_PHONE),',' ,coalesce(BUA.user_mail_contact),',' , coalesce(BUA.P_FAX)) as USERS2_INTERNET_STATUS
, DT.P_DEALDATE_TERM as P_DEALEXPIRE , SV.NAME_LIST_SERVICES
, ".$A_STATUS_L2_SQL."
as A_STATUS, SV.HANGUP_STATUS
from SERVICES as SV
inner JOIN SES_VOIP_A as US2 on SV.ID=US2.ID_SERVICES
inner JOIN BILLING_USERS_ADD as BUA on BUA.id_users=SV.ID_BILLING_USERS
inner JOIN SERVICES as SV2 on SV2.P_ID_SERVICES=SV.ID
inner JOIN SES_USERS2_A as US22 on US22.ID_SERVICES=SV2.ID
left join DEALS_TABLE as DT on DT.ID=SV.ID_DEALS_TABLE
where SV.NAME_LIST_SERVICES='VOIP' and ( SV.P_ID_SERVICES is NULL or SV.P_ID_SERVICES=0)
";
unset($_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SQL_QUERY']);
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SQL_QUERY'][]=" ALTER TABLE temp_USERS2_INTERNET_STATUS CHANGE USERS2_INTERNET_STATUS USERS2_INTERNET_STATUS VARCHAR( 255 ) NOT NULL;";
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SQL_QUERY'][]=" insert ignore into USERS2_MARKETING (A_RECORD_CREATE_DATE,A_RECORD_CREATE_AUTHOR,S_ADDRESS_STREET,T_NETWORK_SERVER,P_PHONE,P_OTHER_INFO,A_STATUS,A_STATUS_INFO,S_ALIAS) SELECT A_RECORD_CREATE_DATE,A_RECORD_CREATE_AUTHOR,S_ADDRESS_STREET,T_NETWORK_SERVER,P_PHONE,P_OTHER_INFO,A_STATUS,A_STATUS_INFO,S_ALIAS FROM USERS2 ORDER BY A_RECORD_UPDATE_DATE DESC ; ";
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SQL_QUERY'][]=" UPDATE USERS2_MARKETING AS USERS2_MARKETING , USERS2 AS USERS2 SET USERS2_MARKETING.S_ALIAS=USERS2.S_ALIAS , USERS2_MARKETING.P_PHONE=USERS2.P_PHONE WHERE USERS2_MARKETING.S_ADDRESS_STREET=USERS2.S_ADDRESS_STREET AND USERS2.A_RECORD_UPDATE_DATE>USERS2_MARKETING.A_RECORD_UPDATE_DATE and 1=0 ;";
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SQL_QUERY'][]=" alter table temp_USERS2_INTERNET_STATUS add index(S_ADDRESS_STREET) , add index(USERS2_INTERNET_STATUS) ; ";
//@2012-04-24 aktualizacja ADM_COMPANY z BUILDINGS
$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SQL_QUERY'][]=" UPDATE USERS2_MARKETING AS USERS2_MARKETING , BUILDINGS AS BUILDINGS SET USERS2_MARKETING.A_ADM_COMPANY=BUILDINGS.A_ADM_COMPANY WHERE USERS2_MARKETING.T_TELBOX_BUILDING_IN=BUILDINGS.S_ADDRESS_STREET;";
//TODO czy to dziala ?
$_SESSION['KSIEG_DOKUMENTY_COLUMN']['RELATIVEDB']['SQL_QUERY'][1]=" update KSIEG_DOKUMENTY set wartosc=ILOSC*CENA_JEDN_NETTO; ";
$_SESSION['IN7_MK_BAZA_DYSTRYBUCJI_COLUMN']['RELATIVEDB']['SQL_QUERY'][1]="
update IN7_MK_BAZA_DYSTRYBUCJI set T_WORKPOINTS_TYPE=if(M_DIST_INVOICE_IN_KSIEG!='0000-00-00','7) OK',
if(M_DIST_CLAIM_DATE!='0000-00-00','6) BRAK FAKTURY',
if(unix_timestamp(now())>(unix_timestamp(M_DIST_TERM_OF_CLAIM)-404800) and M_DIST_TERM_OF_CLAIM!='0000-00-00','1) PILNIE ODDAJ MATERIALY termin mniej niz 4 dni !!!',
if(unix_timestamp(now())>(unix_timestamp(M_DIST_TERM_OF_CLAIM)-604800) and M_DIST_TERM_OF_CLAIM!='0000-00-00','5) ODDAJ MATERIALY termin mniej niz 7 dni',
if(unix_timestamp(now())<=(unix_timestamp(M_DIST_TERM_OF_CLAIM)-604800) and M_DIST_TERM_OF_CLAIM!='0000-00-00' and M_DIST_DATE!='0000-00-00' ,'4) ODDAJ MATERIALY termin ponad 7 dni ',
if(unix_timestamp(now())>(unix_timestamp(M_DIST_DATE)-1204800) and M_DIST_ORDER_DATE='0000-00-00','2) PILNIE WYPISZ ZAMOWIENIE !!!',
if(M_DIST_ORDER_DATE='0000-00-00','3) WYPISZ ZAMOWIENIE','ERROR IF')
)
)
)
)
)
); ";
//$_SESSION['IN7_MK_BAZA_DYSTRYBUCJI_COLUMN']['RELATIVEDB'][SQL_QUERY][2]="update IN7_MK_BAZA_DYSTRYBUCJI as t1, KSIEG_DOKUMENTY as t2 set t1.M_DIST_DOCUMENTED_COST=sum(t2.wartosc) where t1.ID=t2.ID_PROJECT group by t1.ID";
//$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['SRC_COLUMN'][VOIP_STATUS]="USERS2_VOIP_STATUS";
//$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['TRG_COLUMN'][VOIP_STATUS]="A_STATUS";
//$_SESSION['USERS2_MARKETING_COLUMN']['RELATIVEDB']['JOINQUERY'][USERS2_VOIP_STATUS]="LEFT JOIN USERS2 as USERS2_VOIP_STATUS on ( USERS2_VOIP_STATUS.S_ADDRESS_STREET=USERS2_MARKETING.S_ADDRESS_STREET and USERS2_VOIP_STATUS.P_SERVICE not like '%VOIP%' ) ";
//print_r($_SESSION);
if(strstr($_SESSION['ADM_ADMIN_DESC'],"Podwykonawca")) {
echo "
TRyb serwisu
";
$_SESSION['PERMMENU']['IN7_SERWIS']="X";
// $_SESSION['SES_USERS2_A_COLUMN'][SPECIALFILTER]=" and ( USERS2.L_APPOITMENT_USER like '".$_SESSION[ADM_ACCOUNT]."' or ( USERS2.A_STATUS like 'WAITING' and USERS2.A_PROBLEM!='' ) ) ";
$_SESSION['SES_USERS2_A_COLUMN']['SPECIALFILTER']=" and ( SES_USERS2_A.L_APPOITMENT_USER like '".$_SESSION['ADM_ACCOUNT']."' ) ";
$_SESSION['SES_TV_A_COLUMN']['SPECIALFILTER']=" and ( SES_TV_A.L_APPOITMENT_USER like '".$_SESSION['ADM_ACCOUNT']."' ) ";
$_SESSION['SES_VOIP_A_COLUMN']['SPECIALFILTER']=" and ( SES_VOIP_A.L_APPOITMENT_USER like '".$_SESSION['ADM_ACCOUNT']."' ) ";
$RESET_COLUMN=array('EXTRA_SERVICES_COLUMN','TELBOX_COLUMN','DEVICES_COLUMN','BUILDINGS_COLUMN','USERS2_MARKETING_COLUMN','USERS2_MARKETING_OVERWIEV_COLUMN','IN7_DZIENNIK_KORESP_COLUMN','USERS2_DEALS_COLUMN','USERS2_WINDYKACJA_COLUMN','KSIEG_DOKUMENTY_COLUMN','IN7_MK_BAZA_DYSTRYBUCJI_COLUMN');
// global $MENUS ;
// print_r($MENUS);
foreach($RESET_COLUMN as $RCOLUMN) {
foreach($_SESSION[$RCOLUMN]['PERMEDIT'] as $V=>$I) {
// echo " z $RCOLUMN V to $V i to $I
";
$_SESSION[$RCOLUMN]['PERMEDIT'][$V]="";
}
}
$_SESSION['SES_USERS2_A_COLUMN']['PERMEDIT']['A_STATUS']='RWX';
$_SESSION['SES_USERS2_A_COLUMN']['PERMEDIT']['A_STATUS_CURRENT']="R";
$_SESSION['SES_USERS2_A_COLUMN']['PERMEDIT']['P_DEALNUMBER']="R";
$_SESSION['SES_USERS2_A_COLUMN']['PERMEDIT']['TAB_UPDATE_STAT']="R";
//SERWIS
} //SERIS ?
// 2011-08-01: VOIP_CENNIK, VOIP_MAP, VOIP_PROMO, VOIP_FREE_TIME
include dirname(__FILE__) . '/' . 'superedit-USERS_FIELDS_PROFILE_INIT-VOIP.php';
if (true) {// celowe wyzwolenie zawsze autopermow $_SESSION['ADM_ADMIN_LEVEL'] == 5
global $result;
echo "Ustawiam profil uprawnien na bazie przydzielonych procesow dla uzytkownika
";
// resetuje wszystkie PERMY
$dbg_czysc_permy = true;
//@2012-10-21 - testuje aby zawsze wyzwalac autopermy, dla admin level ==1,0 po prostu nie czyscimy permow
if($_SESSION['ADM_ADMIN_LEVEL']<=1) $dbg_czysc_permy = false;
if ($dbg_czysc_permy) { echo 'usuwam uprawnienia dla tabel: '; }
foreach ($_SESSION as $ses_col_name => $col_vars) {
if (!is_array($col_vars) || empty($col_vars)) continue;
if ('_COLUMN' != substr($ses_col_name, -1 * strlen('_COLUMN'))) {
continue;
}
if (empty($col_vars['PERMEDIT'])) continue;
if ($dbg_czysc_permy) { echo '' . $ses_col_name . ' ';
foreach ($col_vars['PERMEDIT'] as $col_perm_ind => $col_perm_value) {
if ($col_perm_ind != 'ID') $_SESSION[$ses_col_name]['PERMEDIT'][$col_perm_ind] = "";
}
}
}
if ($dbg_czysc_permy) { echo '
'; }
unset($dbg_czysc_permy);
echo "\n
aktualne ustawienia";
$userAcl = User::getAcl();
// $_SESSION['ID_ZASOBOW_USERA'][$r->ID_ZASOB]=$r->ID_ZASOB;
$ID_ZASOBOW_USERA = $userAcl->fetchGroups();
$ID_ZASOBOW_USERA = array_keys($ID_ZASOBOW_USERA);
//szukam procesow, w ktorych moze grzebac
DEBUG_S(3,"ID ZASOBOW USERA: ",$ID_ZASOBOW_USERA,__FILE__, __FUNCTION__, __LINE__);
if (empty($ID_ZASOBOW_USERA)) {
echo '' . "Brak przypisanego stanowiska!" . " Zaktualizuj je tutaj w menu
";
}
else if (true) {//1 == V::get('test', '', $_GET)) {
$userAcl->fetchAllPerms();
}
else {// old way
$db = DB::getDB();
$ID_PROCESOW_USERA = $userAcl->getProcesIds();
DEBUG_S(3,"ID_PROCESOW_USERA: ",$ID_PROCESOW_USERA,__FILE__, __FUNCTION__, __LINE__);
// ! zapisuje cala tabele procesow do arraya (i procesy powiazane GOTO z IF_TRUE_GOTO_FLAG=1)
$CRM_PROCESS_TREE = $userAcl->getProcesTree();// TODO: raczej nie potrzebne - tylko wewnatrz userAcl
DEBUG_S(3,"CRM_PROCESS_TREE: ",$CRM_PROCESS_TREE,__FILE__, __FUNCTION__, __LINE__);
$CRM_PROCES_USERA_UZYTY = $userAcl->getUsedProcesIds();
$CRM_PROCES_USERA_UZYTY_MAP = $userAcl->getUsedProcesMap();
DEBUG_S(4,"CRM_PROCES_USERA_UZYTY: ",$CRM_PROCES_USERA_UZYTY,__FILE__, __FUNCTION__, __LINE__);
unset($CRM_PROCESS_TREE);// ??? TODO - to rm
if(!empty($CRM_PROCES_USERA_UZYTY)) {
//$TREE_CRM_WSKAZNIK = array();
$CRM_TREE_WSKAZNIK_NARZEDZIE = array();
//$TREE_CRM_WSKAZNIK_DESC = array();
$TREE_CRM_WSKAZNIK_CONF = array();
$TREE_CRM_WSKAZNIK_SORT_PRIO = array();
// ! dla sciezek procesow wyszukuje powiazanych zasobow aby dac im permy
$zap_sql = "select t1.`ID_PROCES`
, t1.`ID_ZASOB`
, replace(t2.`FORM_TREAT`, ',', '') as FORM_TREAT
, t3.`DESC` as ZASOB_DESC
, t3.`TYPE`
, t4.`DESC` as PARENT_ZASOB_DESC
, t4.`TYPE` as PARENT_TYPE
, t3.`SORT_PRIO` as z__SORT_PRIO
, t3.`OPIS` as ZASOB_OPIS , t1.`ID` as ID_WSKAZNIK
, t5.`ID` as ID_BAZY_KONFIG
from `CRM_WSKAZNIK` as t1
left join `CRM_PRZYPADEK` as t2 on (t1.ID_PRZYPADEK=t2.ID)
left join `CRM_LISTA_ZASOBOW` as t3 on (t3.ID=t1.ID_ZASOB)
left join `CRM_LISTA_ZASOBOW` as t4 on (t4.ID=t3.PARENT_ID)
left join `CRM_LISTA_ZASOBOW` as t5 on (t5.ID=t4.PARENT_ID)
where
(
( t3.`TYPE`='KOMORKA' and t4.`TYPE`='TABELA' )
or (t3.`TYPE`='NARZEDZIE')
or (t3.`TYPE`='URL')
)
and t1.`A_STATUS` in('NORMAL', 'WAITING')
and t1.`ID_PROCES` in(" . implode(",", $CRM_PROCES_USERA_UZYTY) . ")
";
DEBUG_S(3,"ZAP_SQL do wyszukania powiazanych tabeli itp: ",array($zap_sql,sizeof($CRM_PROCES_USERA_UZYTY)),__FILE__, __FUNCTION__, __LINE__);
$result = $db->query($zap_sql);
while ($r = $db->fetch($result)) {
if ($r->TYPE == 'NARZEDZIE') {//@2012-10-15 walka z warningami sqix
if (isset($CRM_TREE_WSKAZNIK_NARZEDZIE[$r->ID_ZASOB])) {
$CRM_TREE_WSKAZNIK_NARZEDZIE[$r->ID_ZASOB] .= $r->FORM_TREAT;
}
else {
$CRM_TREE_WSKAZNIK_NARZEDZIE[$r->ID_ZASOB] = $r->FORM_TREAT;
}
$CRM_WSKAZNIK_PROCES_WSKAZNIK_TREE[$r->ID_PROCES][]=$r->ID_WSKAZNIK;//ustawiam wskaznik od procesu, jak user wybierze proces do roboty, to ja poznam co moze mu sie pojawic
}
else if ($r->TYPE == 'URL') {
$CRM_WSKAZNIK_PROCES_WSKAZNIK_TREE[$r->ID_PROCES] []= $r->ID_WSKAZNIK;//ustawiam wskaznik od procesu, jak user wybierze proces do roboty, to ja poznam co moze mu sie pojawic
$_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'][$r->ID_ZASOB]['TYPE'] = $r->TYPE;
$_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'][$r->ID_ZASOB]['DESC'] = $r->ZASOB_DESC;
$_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'][$r->ID_ZASOB]['OPIS'] = $r->ZASOB_OPIS;
}
else {
//$TREE_CRM_WSKAZNIK[$r->ID_ZASOB] .= $r->FORM_TREAT;
//$TREE_CRM_WSKAZNIK_DESC[$r->ID_ZASOB] = $r->ZASOB_DESC;
if ($r->PARENT_TYPE == 'TABELA') {
$CRM_WSKAZNIK_PROCES_WSKAZNIK_TABELA_KONFIG[$r->PARENT_ZASOB_DESC] = $r->ID_BAZY_KONFIG;
$CRM_WSKAZNIK_PROCES_WSKAZNIK_TREE[$r->ID_PROCES] []= $r->ID_WSKAZNIK;//ustawiam wskaznik od procesu, jak user wybierze proces do roboty, to ja poznam co moze mu sie pojawic
if (isset($r->FORM_TREAT)) { //@2012-10-15 walka z warningami sqix
if (isset($TREE_CRM_WSKAZNIK_CONF[$r->PARENT_ZASOB_DESC][$r->ZASOB_DESC])) {
$TREE_CRM_WSKAZNIK_CONF[$r->PARENT_ZASOB_DESC][$r->ZASOB_DESC] .= $r->FORM_TREAT;
}
else {
$TREE_CRM_WSKAZNIK_CONF[$r->PARENT_ZASOB_DESC][$r->ZASOB_DESC] = $r->FORM_TREAT;
// echo "PARENT_ZASOB_DESC." ".$r->ZASOB_DESC." = ".$r->FORM_TREAT;
}
}
$TREE_CRM_WSKAZNIK_SORT_PRIO[$r->PARENT_ZASOB_DESC][$r->ZASOB_DESC] = $r->z__SORT_PRIO;
//@2012-10-10 by SQIX : dodajemy opus kolumny z opisu zasobow
if ($r->ZASOB_OPIS) {
$_SESSION["{$r->PARENT_ZASOB_DESC}_COLUMN"]['DESC_TO_LANG'][$r->ZASOB_DESC] = $r->ZASOB_OPIS;
}
else if (isset($_SESSION["{$r->PARENT_ZASOB_DESC}_COLUMN"]['DESC_TO_LANG'][$r->ZASOB_DESC]) && (strlen($_SESSION["{$r->PARENT_ZASOB_DESC}_COLUMN"]['DESC_TO_LANG'][$r->ZASOB_DESC]) > 1)) {
echo "
DODAJ opis dla zasobu {$r->ID_ZASOB} w postaci ".$_SESSION["{$r->PARENT_ZASOB_DESC}_COLUMN"]['DESC_TO_LANG'][$r->ZASOB_DESC]."";
}
}
}
}
//echo'$TREE_CRM_WSKAZNIK_CONF: ';print_r($TREE_CRM_WSKAZNIK_CONF);echo'
';
DEBUG_S(3,'Oznaczenia baz danych dla tabel',$CRM_WSKAZNIK_PROCES_WSKAZNIK_TABELA_KONFIG,__FILE__,__FUNCTION__,__LINE__);
$_SESSION['CRM_WSKAZNIK_PROCES_WSKAZNIK_TABELA_KONFIG'] = $CRM_WSKAZNIK_PROCES_WSKAZNIK_TABELA_KONFIG;
$dbg_set_permy = true;
// ! inicjalizuje uprawnienia
foreach ($TREE_CRM_WSKAZNIK_CONF as $ses_column_name => $field_perms_arr) {
foreach ($field_perms_arr as $k_name => $v_perm) {
$v_perm = str_split($v_perm);
$v_perm = array_unique($v_perm);
$v_perm = implode("", $v_perm);
DEBUG_S(6, "['{$ses_column_name}_COLUMN']['PERMEDIT']['{$k_name}']={$v_perm}",'',__FILE__,__FUNCTION__,__LINE__);
//if(isset($_SESSION[$ses_column_name."_COLUMN"]['PERMEDIT'][$k_name]))
$_SESSION["{$ses_column_name}_COLUMN"]['PERMEDIT'][$k_name] = $v_perm;
//else $_SESSION[$ses_column_name."_COLUMN"]['PERMEDIT'][$k_name] = $v_perm."RWX"; //dokladamy permy do istniejacych!!! @2012-10-21- najlepsze na okres przejsciowy do generowania procesow!
$debug_perms[]="_SESSION['{$ses_column_name}_COLUMN']['PERMEDIT'][{$k_name}]']={$v_perm}";
//jezeli jest w kolumnie ID==W , to znaczy, ze mozna dodawac nowy rekord
if ($k_name == 'ID' && strstr($v_perm, 'W')) {
$_SESSION[$ses_column_name."_COLUMN"]['FUNCPERMEDIT']['NEW_RECORD'] = "RWXC";
$_SESSION[$ses_column_name."_COLUMN"]['FUNCPERMEDIT']['TABLE_INSERTDB'] = "RWXC";
}
//jezeli jest funkcja powiazana to uprawnienia dostajemy takie same jak z komorki do tej funkcji!
if (isset($_SESSION[$ses_column_name."_COLUMN"]['TYPESPECIAL'][$k_name])) {
$debug_perms []= "_SESSION['{$ses_column_name}_COLUMN']['FUNCPERMEDIT']['".$_SESSION["{$ses_column_name}_COLUMN"]['TYPESPECIAL'][$k_name]."']={$v_perm}";
$_SESSION["{$ses_column_name}_COLUMN"]['FUNCPERMEDIT'][$_SESSION["{$ses_column_name}_COLUMN"]['TYPESPECIAL'][$k_name]] = $v_perm;
}
}
{// sort DESC by ZASOB.SORT_PRIO
$desc_to_sort = array();
if(!isset($_SESSION["{$ses_column_name}_COLUMN"]['DESC'])) {} //echo "
L2375 Brak definicji w systemie opisanej procesami tabeli ".$ses_column_name.""; //@2012-10-15 sqix walka z warningami
else
foreach ($_SESSION["{$ses_column_name}_COLUMN"]['DESC'] as $k_ind => $v_val) {
$desc_to_sort[$v_val] = $k_ind;
}
$TREE_CRM_WSKAZNIK_SORT_PRIO[$ses_column_name];
asort($TREE_CRM_WSKAZNIK_SORT_PRIO[$ses_column_name]);
$new_desc = array();
foreach ($TREE_CRM_WSKAZNIK_SORT_PRIO[$ses_column_name] as $k_name => $v_sort_prio) {
if (!isset($desc_to_sort[$k_name])) {
//echo "
Brak spojnosci definicji dla kolumny : ".$ses_column_name."[".$k_name."] ";
}
else {
$new_desc[ $desc_to_sort[$k_name] ] = $k_name;//@2012-10-15 walka z warningami sqix
}
}
// add columns
foreach ($desc_to_sort as $k_name => $v_ind) {
$new_desc[ $v_ind ] = $k_name;
}
$_SESSION["{$ses_column_name}_COLUMN"]['DESC'] = $new_desc;
}// sort DESC by ZASOB.SORT_PRIO
}
unset($dbg_set_permy);
$_SESSION['CRM_PROCES_USERA_UZYTY'] = $CRM_PROCES_USERA_UZYTY;
$_SESSION['CRM_PROCES_USERA_UZYTY_MAP'] = $CRM_PROCES_USERA_UZYTY_MAP;
$_SESSION['CRM_LISTA_ZASOBOW_TREE'] = $CRM_TREE_WSKAZNIK_NARZEDZIE;//zapisanie jakie zasoby user ma dostepne!!! TODO
$_SESSION['CRM_WSKAZNIK_PROCES_WSKAZNIK_TREE'] = $CRM_WSKAZNIK_PROCES_WSKAZNIK_TREE;//zapisanie jakie zasoby user ma dostepne!!! TODO
// ! tutaj poszukamy co jest proces_init tylko z CRM_PROCES_USERA_UZYTY_MAP
$CRM_PROCES_USERA_UZYTY_MAP = array_keys($CRM_PROCES_USERA_UZYTY_MAP);
//DEBUG_S(-3,'menu_to_show',$menu_to_show,__FILE__,__FUNCTION__,__LINE__);
if (!empty($CRM_PROCES_USERA_UZYTY_MAP)) {
$sql = "select `ID`,`DESC` from `CRM_PROCES` where `TYPE`='PROCES_INIT' and ID in (".implode(",", $CRM_PROCES_USERA_UZYTY_MAP).") ";
$result = $db->query($sql);
$CRM_PROCES_USERA_UZYTY_MAP_PROCES_INIT = array();
while ($h = $db->fetch($result)) {
$CRM_PROCES_USERA_UZYTY_MAP_PROCES_INIT []= $h->ID;
}
$_SESSION['CRM_PROCES_USERA_UZYTY_MAP_PROCES_INIT'] = $CRM_PROCES_USERA_UZYTY_MAP_PROCES_INIT;
}
}
}
//nie wiem czy to tu wstawic czy wyzej ??? proba inicjalizacji tabel na bazie uzytych tabel::
//zerzniete z MENU by PIOTR by sqix
foreach ($_SESSION as $COLUMN_INDEX => $COLUMN_VAR) {
if (substr($COLUMN_INDEX, -7) == '_COLUMN') {
$prems_ok = false;
if (isset($COLUMN_VAR['PERMEDIT'])) {
$fields_deafult_R = array('ID','A_RECORD_CREATE_DATE','A_RECORD_CREATE_AUTHOR','A_RECORD_UPDATE_DATE','A_RECORD_UPDATE_AUTHOR');
foreach ($COLUMN_VAR['PERMEDIT'] as $k_field => $v_perm) {
if (in_array($k_field, $fields_deafult_R)) {
continue;
}
if (false !== strpos($v_perm, 'R')) {
$prems_ok = true;
}
}
}
if ($prems_ok) {
if (substr($COLUMN_INDEX, -12) != '_HIST_COLUMN') { // jezeli nie jest kolumna HIST!!
$RELATIVEDB_TRG_COLUMN_PARM = ""; //parametr do przekazanie do funkcji dla extracolumn wirtualnych
if (is_array($COLUMN_VAR))
if (isset($COLUMN_VAR['RELATIVEDB']))
if (isset($COLUMN_VAR['RELATIVEDB']['TRG_COLUMN']))
foreach ($COLUMN_VAR['RELATIVEDB']['TRG_COLUMN'] as $VCOLUMN => $VCOLUMN_VAR) {
if (empty($RELATIVEDB_TRG_COLUMN_PARM)) {
$RELATIVEDB_TRG_COLUMN_PARM = $VCOLUMN;
}
else {
$RELATIVEDB_TRG_COLUMN_PARM .= " ".$VCOLUMN;
}
}
DEBUG_S(1, 'perms_ok('.$COLUMN_INDEX.') = "' . $prems_ok . '"',array($COLUMN_VAR,$RELATIVEDB_TRG_COLUMN_PARM),__FILE__,__FUNCTION__,__LINE__);
SEF('USERS_COLUMN_INIT2');
global $special_tables_ignore_init;
if (!isset($special_tables_ignore_init)) $special_tables_ignore_init = array();
if (!in_array(substr($COLUMN_INDEX, 0, (strlen($COLUMN_INDEX) - 7)), $special_tables_ignore_init)) {
//if(!isset($_SESSION[$COLUMN_INDEX]['DESC'])) {
DEBUG_S(3, 'Uruchamiam '.$COLUMN_INDEX.' USERS_COLUMN_INIT2(' . substr($COLUMN_INDEX,0,(strlen($COLUMN_INDEX)-7)) . ',0,'.$RELATIVEDB_TRG_COLUMN_PARM.',N)',array($COLUMN_INDEX,$special_tables_ignore_init),__FILE__,__FUNCTION__,__LINE__);
#OFF 2013-06-11 USERS_COLUMN_INIT2(substr($COLUMN_INDEX, 0, (strlen($COLUMN_INDEX) - 7)), $RELATIVEDB_TRG_COLUMN_PARM, 'N', '');
}
}
}
}
}
}
}