' . "Database Error" . '';
return;
}
$sqlList = array();
$task = V::get('task', '', $_GET);
if ($task == 'FVAT_POS_CHARTS') {
$DBG = V::get('DBG', '', $_GET);
$args = array();
$args['MONTH'] = V::get('MONTH', '', $_GET);
$args['id_owner'] = V::get('id_owner', '', $_GET);
$args['P_SERVICE'] = V::get('P_SERVICE', '', $_GET);
$db = DB::getDB();
$chart = new stdClass();
$chart->select = array();
$chart->groupBy = array();
$chart->osY = '';
$chart->osY_values = array();
$chart->osX = 'MONTH';
$chart->osX_values = array();
$chart->osX_range_min = '2013-01-00';
$chart->osX_range_max = '2014-05-00';
$chart->groupBy[] = 'MONTH';
$chart->groupBy[] = 'id_owner';
$chart->groupBy[] = 'P_SERVICE';
$chart->select['cnt'] = 'count(1)';
$chart->select['sum_INCOME'] = 'sum(`INCOME`)';
$sql_select = array();
foreach ($chart->select as $kLabel => $vField) {
$sql_select[] = "{$vField} as {$kLabel}";
}
foreach ($chart->groupBy as $vField) {
if (!array_key_exists($vField, $chart->select)) {
$sql_select[] = "{$vField} as {$vField}";
}
}
$sql_select = implode(',', $sql_select);
$sql_group_by = implode(',', $chart->groupBy);
$chart->data = array();
$sql = "select {$sql_select}
from `stats_BILLS_FVAT_POS`
where `{$chart->osX}` between '{$chart->osX_range_min}' and '{$chart->osX_range_max}'
group by {$sql_group_by}
";
if($DBG){echo'sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo'';}
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
if (empty($r->P_SERVICE)) {
$r->P_SERVICE = 'Unknown';
}
if (isset($r->MONTH) && substr($r->MONTH, -3) == '-00') {
$r->MONTH = substr($r->MONTH, 0, -3);
}
$r->cnt = (int)$r->cnt;
$r->sum_INCOME = (double)$r->sum_INCOME;
$chart->data[] = $r;
foreach ($chart->groupBy as $vField) {
if ($vField == $chart->osX) {
$chart->osX_values[$r->{$chart->osX}] = true;
}
else if (!array_key_exists($vField, $chart->select)) {
$chart->osY_values[$vField][$r->{$vField}] = true;
}
}
}
foreach ($chart->osY_values as $k => $v) {
$chart->osY_values[$k] = array_keys($v);
sort($chart->osY_values[$k]);
}
$chart->osX_values = array_keys($chart->osX_values);
sort($chart->osX_values);
if($DBG){echo'$chart->data (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($chart->data);echo'';}
if($DBG){echo'$chart->osY_values (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($chart->osY_values);echo'';}
?>
0
";
$sqlList[] = "update `stats_BILLS_FVAT_POS` as f, `DEALS_TABLE` as d
set
f.`S_ADDRESS_STREET`=d.`S_ADDRESS_STREET`
where d.`ID`=f.`ID_DEALS_TABLE`
and f.`S_ADDRESS_STREET`=''
";
$sqlList[] = "update `stats_BILLS_FVAT_POS` as f, `USERS2_MARKETING` as m, `BUILDINGS` as b
set
f.`T_TELBOX_BUILDING_IN`=m.`T_TELBOX_BUILDING_IN`
, f.`M_REWIR`=b.`M_REWIR`
, f.`P_OSIEDLE`=IF(b.`P_OSIEDLE`!=''
, CONCAT(b.`S_ADDRESS_CITY`, ' - ', b.`P_OSIEDLE`)
, b.`S_ADDRESS_CITY`
)
where m.`S_ADDRESS_STREET`=f.`S_ADDRESS_STREET`
and b.`S_ADDRESS_STREET`=m.`T_TELBOX_BUILDING_IN`
and f.`S_ADDRESS_STREET`!=''
";
$sqlList[] = "update `stats_BILLS_FVAT_POS` as f, `USERS2_OFFERS` as o, `USERS2_OFFERS_COSTS_GROUPS` as c
set
f.`P_SERVICE`=IF(o.`P_SERVICE`='OPCJE'
, concat(o.`P_SERVICE`, '_', o.`P_SERVICE_PARENT`)
, o.`P_SERVICE`
)
, f.`P_NET_SPEED`=IF(o.`P_SERVICE` in('NET')
, o.`P_S_PARAM1`
, '')
, f.`P_TV_NAME`=IF(o.`P_SERVICE` in('TV','TVC','TVCP')
, o.`P_SERVICE_NAME`
, '')
, f.`P_TEL_NAME`=IF(o.`P_SERVICE` in('TEL')
, o.`P_SERVICE_NAME`
, '')
, f.`P_OFFER_COSTS`=c.`P_OFFER_COSTS`
where o.`ID`=f.`ID_OFFERS`
and c.`ID`=o.`ID_COSTS_GROUPS`
and f.`ID_OFFERS`>0
";
$sqlList[] = "update `stats_BILLS_FVAT_POS` as f, `USERS2_OFFERS` as o, `USERS2_PRODUKT` as p
set
f.`P_NET_GROUP`=p.`P_NAME`
where o.`ID`=f.`ID_OFFERS`
and p.`ID`=o.`ID_PRODUKT`
and f.`ID_OFFERS`>0
and o.`ID_PRODUKT`>0
and o.`P_SERVICE`='NET'
";
$sqlList[] = "update `stats_BILLS_FVAT_POS` as f
set
f.`P_OFFER_ZYSK`=f.`INCOME` - f.`P_OFFER_COSTS`
";
}
else {
{// temp_USERS2_INTERNET_STATUS_INTERNET_NORMAL
$sqlList[] = "drop table if exists temp_USERS2_INTERNET_STATUS_INTERNET_NORMAL";
$sqlList[] = "create table temp_USERS2_INTERNET_STATUS_INTERNET_NORMAL
select ID, S_ADDRESS_STREET, USERS2_INTERNET_STATUS, P_DEALEXPIRE
from temp_USERS2_INTERNET_STATUS
where
( USERS2_INTERNET_STATUS like 'NORMAL%' or USERS2_INTERNET_STATUS like 'WAITING%' )
and NAME_LIST_SERVICES like 'USERS2'
group by S_ADDRESS_STREET
";
$sqlList[] = "alter table temp_USERS2_INTERNET_STATUS_INTERNET_NORMAL add index(S_ADDRESS_STREET)";
}
{// temp_USERS2_INTERNET_STATUS_VOIP_NORMAL
$sqlList[] = "drop table if exists temp_USERS2_INTERNET_STATUS_VOIP_NORMAL";
$sqlList[] = "create table temp_USERS2_INTERNET_STATUS_VOIP_NORMAL
select ID, S_ADDRESS_STREET, USERS2_INTERNET_STATUS, P_DEALEXPIRE
from temp_USERS2_INTERNET_STATUS
where
( USERS2_INTERNET_STATUS like 'NORMAL%' or USERS2_INTERNET_STATUS like 'WAITING%' )
and NAME_LIST_SERVICES like 'VOIP'
group by S_ADDRESS_STREET
";
$sqlList[] = "alter table temp_USERS2_INTERNET_STATUS_VOIP_NORMAL add index(S_ADDRESS_STREET)";
}
{// temp_USERS2_INTERNET_STATUS_TV_NORMAL
$sqlList[] = "drop table if exists temp_USERS2_INTERNET_STATUS_TV_NORMAL";
$sqlList[] = "create table temp_USERS2_INTERNET_STATUS_TV_NORMAL
select ID, S_ADDRESS_STREET, USERS2_INTERNET_STATUS, P_DEALEXPIRE
from temp_USERS2_INTERNET_STATUS
where
( USERS2_INTERNET_STATUS like 'NORMAL%' or USERS2_INTERNET_STATUS like 'WAITING%' )
and NAME_LIST_SERVICES like 'TV'
group by S_ADDRESS_STREET
";
$sqlList[] = "alter table temp_USERS2_INTERNET_STATUS_TV_NORMAL add index(S_ADDRESS_STREET)";
}
{// temp_USERS2_INTERNET_STATUS_OFF_HARD
$sqlList[] = "drop table if exists temp_USERS2_INTERNET_STATUS_OFF_HARD";
$sqlList[] = "create table temp_USERS2_INTERNET_STATUS_OFF_HARD
select t1.ID, t1.S_ADDRESS_STREET, t2.ID as T2_ID
from USERS2_MARKETING as t1
left join temp_USERS2_INTERNET_STATUS_INTERNET_NORMAL as t2 on(t2.S_ADDRESS_STREET=t1.S_ADDRESS_STREET)
where
t2.ID is NULL
and t1.I_OPER='BN'
";
}
{// update USERS2_MARKETING fields: I_OPER, I_OPER_FIN
// by NORMAL - temp_USERS2_INTERNET_STATUS_INTERNET_NORMAL
$sqlList[] = "update USERS2_MARKETING, temp_USERS2_INTERNET_STATUS_INTERNET_NORMAL
set USERS2_MARKETING.I_OPER='BN',
USERS2_MARKETING.I_OPER_FIN=temp_USERS2_INTERNET_STATUS_INTERNET_NORMAL.P_DEALEXPIRE
where USERS2_MARKETING.S_ADDRESS_STREET=temp_USERS2_INTERNET_STATUS_INTERNET_NORMAL.S_ADDRESS_STREET
";
// update USERS2_MARKETING fields: I_OPER by OFF_HARD
$sqlList[] = "update USERS2_MARKETING, temp_USERS2_INTERNET_STATUS_OFF_HARD
set USERS2_MARKETING.I_OPER='NIEWIADOMO'
where USERS2_MARKETING.I_OPER='BN'
and USERS2_MARKETING.S_ADDRESS_STREET=temp_USERS2_INTERNET_STATUS_OFF_HARD.S_ADDRESS_STREET
";
// update USERS2_MARKETING fields: I_OPER, T_OPER_FIN by VOIP
$sqlList[] = "update USERS2_MARKETING, temp_USERS2_INTERNET_STATUS_VOIP_NORMAL
set USERS2_MARKETING.T_OPER='BN',
USERS2_MARKETING.T_OPER_FIN=temp_USERS2_INTERNET_STATUS_VOIP_NORMAL.P_DEALEXPIRE
where USERS2_MARKETING.S_ADDRESS_STREET=temp_USERS2_INTERNET_STATUS_VOIP_NORMAL.S_ADDRESS_STREET
";
// update USERS2_MARKETING fields: TV_OPER, TV_OPER_FIN
$sqlList[] = "update USERS2_MARKETING, temp_USERS2_INTERNET_STATUS_TV_NORMAL
set USERS2_MARKETING.TV_OPER='BN',
USERS2_MARKETING.TV_OPER_FIN=temp_USERS2_INTERNET_STATUS_TV_NORMAL.P_DEALEXPIRE
where USERS2_MARKETING.S_ADDRESS_STREET=temp_USERS2_INTERNET_STATUS_TV_NORMAL.S_ADDRESS_STREET
";
}
{// USERS2_MARKETING_OVERWIEV
$sqlList[] = "drop table if exists USERS2_MARKETING_OVERWIEV";
// update `USERS2_MARKETING` fields: `M_REWIR`
$sqlList[] = "update USERS2_MARKETING , BUILDINGS
set USERS2_MARKETING.M_REWIR=BUILDINGS.M_REWIR
where
USERS2_MARKETING.T_TELBOX_BUILDING_IN=BUILDINGS.S_ADDRESS_STREET
and BUILDINGS.M_REWIR!=''
and BUILDINGS.M_REWIR is not null
";
$COLSFORSTATS = array('I','T','TV');
$COLSFORSTATS_OPERS = array('INNY','UPC','NSM','TP','EIA','BRAK','JARSAT');
//BEGIN MIESZKANIA STATSY
$sql = "select 0 as ID
, USERS2_MARKETING.T_TELBOX_BUILDING_IN
, USERS2_MARKETING.M_REWIR
, BUILDINGS.T_NETWORK_SERVER
, sum(if(USERS2_MARKETING.I_OPER='BN',1,0) ) as ABO_I ,count(USERS2_MARKETING.S_ADDRESS_STREET) as MIESZKAN
, round(( sum( if(
( USERS2_MARKETING.I_BAD_DATE> from_unixtime(unix_timestamp(now())-31536000)
or USERS2_MARKETING.T_BAD_DATE> from_unixtime(unix_timestamp(now())-31536000)
or USERS2_MARKETING.TV_BAD_DATE> from_unixtime(unix_timestamp(now())-31536000)
), 1, 0) ) / count(USERS2_MARKETING.S_ADDRESS_STREET) * 100), 2) as BADAN_I
, round(( sum( if(
( USERS2_MARKETING.I_BAD_DATE> from_unixtime(unix_timestamp(now())-31536000)
or USERS2_MARKETING.T_BAD_DATE> from_unixtime(unix_timestamp(now())-31536000)
or USERS2_MARKETING.TV_BAD_DATE> from_unixtime(unix_timestamp(now())-31536000)
or USERS2_MARKETING.I_OPER='BN'
or USERS2_MARKETING.T_OPER='BN'
or USERS2_MARKETING.TV_OPER='BN'
), 1, 0) ) / count(USERS2_MARKETING.S_ADDRESS_STREET) * 100), 2) as ANKIET_I
, BUILDINGS.A_ADM_COMPANY
";
foreach ($COLSFORSTATS as $FFS) {
$sql .= " , round((sum(if( USERS2_MARKETING.{$FFS}_OPER='BN',1,0) ) / count(USERS2_MARKETING.S_ADDRESS_STREET) * 100), 2) as NAS_{$FFS} ";
foreach ($COLSFORSTATS_OPERS as $FFFS) {
$sql .= " , round((
sum(
if( USERS2_MARKETING.{$FFS}_OPER='{$FFFS}', 1, 0)
) / sum(
if(
(USERS2_MARKETING.{$FFS}_BAD_DATE!='0000-00-00')
and (USERS2_MARKETING.{$FFS}_OPER!='BN'), 1, 0
)
) * (
count(USERS2_MARKETING.S_ADDRESS_STREET)
-
sum(if(USERS2_MARKETING.{$FFS}_OPER='BN', 1, 0))
) / count(USERS2_MARKETING.S_ADDRESS_STREET)
) * 100, 2) as PR_{$FFS}_{$FFFS}
";
}
$sql .= "
, round((
sum(
if(
(USERS2_MARKETING.{$FFS}_OPER!='BN'
and USERS2_MARKETING.{$FFS}_OPER_ZAINT > 2
and USERS2_MARKETING.{$FFS}_OPER_ZAINT != 'NIEWIADOMO'), 1, 0)
) / sum(
if( (USERS2_MARKETING.{$FFS}_BAD_DATE!='0000-00-00') and (USERS2_MARKETING.{$FFS}_OPER!='BN'), 1, 0)
) * (
count(USERS2_MARKETING.S_ADDRESS_STREET)
-
sum(if(USERS2_MARKETING.{$FFS}_OPER='BN',1,0))
) / count(USERS2_MARKETING.S_ADDRESS_STREET)
) * 100, 2) as PR_{$FFS}_ZAINT
, round ((
sum(
if(
(USERS2_MARKETING.{$FFS}_OPER!='BN'
and USERS2_MARKETING.{$FFS}_OPER!='BRAK'
and USERS2_MARKETING.{$FFS}_OPER!='NIEWIADOMO'), 1, 0)
) / sum(
if(
(USERS2_MARKETING.{$FFS}_BAD_DATE!='0000-00-00') and (USERS2_MARKETING.{$FFS}_OPER!='BN') ,1,0 )
) * (
count(USERS2_MARKETING.S_ADDRESS_STREET)
-
sum(if(USERS2_MARKETING.{$FFS}_OPER='BN', 1, 0))
) / count(USERS2_MARKETING.S_ADDRESS_STREET)
) * 100, 2) as PR_{$FFS}_KONKUR
";
}
$sql .= "
from USERS2_MARKETING as USERS2_MARKETING
left join BUILDINGS on (BUILDINGS.S_ADDRESS_STREET=USERS2_MARKETING.T_TELBOX_BUILDING_IN)
where
USERS2_MARKETING.A_STATUS!='DELETED'
and BUILDINGS.A_STATUS!='DELETED'
group by USERS2_MARKETING.T_TELBOX_BUILDING_IN
order by USERS2_MARKETING.M_REWIR DESC, USERS2_MARKETING.T_TELBOX_BUILDING_IN
";
$sqlList[] = " create table `USERS2_MARKETING_OVERWIEV` \n {$sql} \n limit 1";
$sqlList[] = " truncate table `USERS2_MARKETING_OVERWIEV` ";
$sqlList[] = " ALTER TABLE `USERS2_MARKETING_OVERWIEV` ENGINE=MYISAM ";
$sqlList[] = " ALTER TABLE `USERS2_MARKETING_OVERWIEV` CHANGE `ID` `ID` INT(11) NOT NULL DEFAULT '0' ";
$sqlList[] = " ALTER TABLE `USERS2_MARKETING_OVERWIEV` ADD PRIMARY KEY(`ID`) ";
$sqlList[] = " ALTER TABLE `USERS2_MARKETING_OVERWIEV` CHANGE `ID` `ID` INT(11) NOT NULL AUTO_INCREMENT ";
$sqlList[] = " insert into `USERS2_MARKETING_OVERWIEV` \n {$sql}";
}
{// REWIRY STATSY - USERS2_MARKETING_OVERWIEV_REWIR
$sqlList[] = "drop table if exists USERS2_MARKETING_OVERWIEV_REWIR";
$sql = " select 0 as ID
, group_concat(distinct ' ', USERS2_MARKETING.T_TELBOX_BUILDING_IN) as T_TELBOX_BUILDING_IN
, USERS2_MARKETING.M_REWIR
, BUILDINGS.T_NETWORK_SERVER
, sum(if(USERS2_MARKETING.I_OPER='BN',1,0) ) as ABO_I
, count(USERS2_MARKETING.S_ADDRESS_STREET) as MIESZKAN
, round((sum(if(USERS2_MARKETING.I_OPER='BN', 1, 0)) / count(USERS2_MARKETING.S_ADDRESS_STREET) * 100), 2) as NAS_I
, round(( sum( if(
( USERS2_MARKETING.I_BAD_DATE> from_unixtime(unix_timestamp(now())-31536000)
or USERS2_MARKETING.T_BAD_DATE> from_unixtime(unix_timestamp(now())-31536000)
or USERS2_MARKETING.TV_BAD_DATE> from_unixtime(unix_timestamp(now())-31536000)
), 1, 0)
) / count(USERS2_MARKETING.S_ADDRESS_STREET) * 100), 2) as BADAN_I
, round(( sum( if(
( USERS2_MARKETING.I_BAD_DATE> from_unixtime(unix_timestamp(now())-31536000)
or USERS2_MARKETING.T_BAD_DATE> from_unixtime(unix_timestamp(now())-31536000)
or USERS2_MARKETING.TV_BAD_DATE> from_unixtime(unix_timestamp(now())-31536000)
or USERS2_MARKETING.I_OPER='BN'
or USERS2_MARKETING.T_OPER='BN'
or USERS2_MARKETING.TV_OPER='BN'), 1, 0)
) / count(USERS2_MARKETING.S_ADDRESS_STREET) * 100), 2) as ANKIET_I
, BUILDINGS.A_ADM_COMPANY
";
foreach ($COLSFORSTATS as $FFS) {
foreach ($COLSFORSTATS_OPERS as $FFFS) {
$sql .= ", round(( sum(
if(USERS2_MARKETING.{$FFS}_OPER='{$FFFS}', 1, 0)
) / sum(
if( (USERS2_MARKETING.{$FFS}_BAD_DATE!='0000-00-00') and (USERS2_MARKETING.{$FFS}_OPER!='BN'), 1, 0)
) * (
count(USERS2_MARKETING.S_ADDRESS_STREET)
- sum(if(USERS2_MARKETING.{$FFS}_OPER='BN', 1, 0))
) / count(USERS2_MARKETING.S_ADDRESS_STREET)) * 100, 2) as PR_{$FFS}_{$FFFS}
";
}
$sql .= ", round(( sum(
if(
(USERS2_MARKETING.{$FFS}_OPER!='BN'
and USERS2_MARKETING.{$FFS}_OPER_ZAINT > 2
and USERS2_MARKETING.{$FFS}_OPER_ZAINT!='NIEWIADOMO'), 1, 0)
) / sum(
if( (USERS2_MARKETING.{$FFS}_BAD_DATE!='0000-00-00') and (USERS2_MARKETING.{$FFS}_OPER!='BN'), 1, 0)
) * (
count(USERS2_MARKETING.S_ADDRESS_STREET)
- sum(if(USERS2_MARKETING.{$FFS}_OPER='BN', 1, 0))
) / count(USERS2_MARKETING.S_ADDRESS_STREET)) * 100, 2) as PR_{$FFS}_ZAINT
, round((
sum(
if( (USERS2_MARKETING.{$FFS}_OPER!='BN' and USERS2_MARKETING.{$FFS}_OPER!='BRAK' and USERS2_MARKETING.{$FFS}_OPER!='NIEWIADOMO'), 1, 0)
) / sum(
if( (USERS2_MARKETING.{$FFS}_BAD_DATE!='0000-00-00') and (USERS2_MARKETING.{$FFS}_OPER!='BN'), 1, 0)
) * (
count(USERS2_MARKETING.S_ADDRESS_STREET)
- sum(if(USERS2_MARKETING.{$FFS}_OPER='BN',1,0))
) / count(USERS2_MARKETING.S_ADDRESS_STREET)
) * 100, 2) as PR_{$FFS}_KONKUR
";
}
$sql .= "
from USERS2_MARKETING as USERS2_MARKETING
left join BUILDINGS on BUILDINGS.S_ADDRESS_STREET=USERS2_MARKETING.T_TELBOX_BUILDING_IN
where USERS2_MARKETING.A_STATUS!='DELETED' and BUILDINGS.A_STATUS!='DELETED'
group by USERS2_MARKETING.M_REWIR
order by USERS2_MARKETING.M_REWIR DESC ,USERS2_MARKETING.T_TELBOX_BUILDING_IN
";
$sqlList[] = " create table `USERS2_MARKETING_OVERWIEV_REWIR` \n {$sql} \n limit 1";
$sqlList[] = " truncate table `USERS2_MARKETING_OVERWIEV_REWIR` ";
$sqlList[] = " ALTER TABLE `USERS2_MARKETING_OVERWIEV_REWIR` ENGINE=MYISAM ";
$sqlList[] = " ALTER TABLE `USERS2_MARKETING_OVERWIEV_REWIR` CHANGE `ID` `ID` INT(11) NOT NULL DEFAULT '0' ";
$sqlList[] = " ALTER TABLE `USERS2_MARKETING_OVERWIEV_REWIR` ADD PRIMARY KEY(`ID`) ";
$sqlList[] = " ALTER TABLE `USERS2_MARKETING_OVERWIEV_REWIR` CHANGE `ID` `ID` INT(11) NOT NULL AUTO_INCREMENT ";
$sqlList[] = " insert into `USERS2_MARKETING_OVERWIEV_REWIR` \n {$sql}";
}
{// add fields to USERS2_MARKETING_OVERWIEV
/*
$sqlList[] = "ALTER TABLE `USERS2_MARKETING_OVERWIEV` CHANGE `ABO_I` `ABO_I` CHAR( 10 ) NOT NULL DEFAULT '0',
CHANGE `MIESZKAN` `MIESZKAN` CHAR( 10 ) NOT NULL DEFAULT '0',
CHANGE `NAS_I` `NAS_I` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `ANKIET_I` `ANKIET_I` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `PR_I_UPC` `PR_I_UPC` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `PR_I_INNY` `PR_I_INNY` CHAR( 10 ) NULL DEFAULT NULL , CHANGE `PR_I_NSM` `PR_I_NSM` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `PR_I_TP` `PR_I_TP` CHAR( 10 ) NULL DEFAULT NULL , CHANGE `PR_I_EIA` `PR_I_EIA` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `PR_I_BRAK` `PR_I_BRAK` CHAR( 10 ) NULL DEFAULT NULL , CHANGE `PR_I_KONKUR` `PR_I_KONKUR` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `BADAN_I` `BADAN_I` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `PR_I_ZAINT` `PR_I_ZAINT` CHAR( 10 ) NULL DEFAULT NULL,
CHANGE `PR_I_JARSAT` `PR_I_JARSAT` CHAR( 10 ) NULL DEFAULT NULL
";
*/
/*
$sqlList[] = "ALTER TABLE `USERS2_MARKETING_OVERWIEV_REWIR` CHANGE `ABO_I` `ABO_I` CHAR( 10 ) NOT NULL DEFAULT '0',
CHANGE `MIESZKAN` `MIESZKAN` CHAR( 10 ) NOT NULL DEFAULT '0',
CHANGE `NAS_I` `NAS_I` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `ANKIET_I` `ANKIET_I` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `PR_I_UPC` `PR_I_UPC` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `PR_I_INNY` `PR_I_INNY` CHAR( 10 ) NULL DEFAULT NULL , CHANGE `PR_I_NSM` `PR_I_NSM` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `PR_I_TP` `PR_I_TP` CHAR( 10 ) NULL DEFAULT NULL , CHANGE `PR_I_EIA` `PR_I_EIA` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `PR_I_BRAK` `PR_I_BRAK` CHAR( 10 ) NULL DEFAULT NULL , CHANGE `PR_I_KONKUR` `PR_I_KONKUR` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `BADAN_I` `BADAN_I` CHAR( 10 ) NULL DEFAULT NULL ,
CHANGE `PR_I_ZAINT` `PR_I_ZAINT` CHAR( 10 ) NULL DEFAULT NULL
";
*/
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add A_RECORD_CREATE_DATE varchar(30) ;";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add A_RECORD_CREATE_AUTHOR varchar(100) not null ;";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add A_RECORD_UPDATE_DATE varchar(30) ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add A_RECORD_UPDATE_AUTHOR varchar(100) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add L_APPOITMENT_DATE varchar(30) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add L_APPOITMENT_USER varchar(100) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add L_APPOITMENT_PERIOD varchar(4) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add L_APPOITMENT_INFO varchar(255) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add L_APPOITMENT_TYPE enum('', 'ARRANGED', 'TO_ARRANGE', 'CANCELLED', 'TO_CANCEL', 'RELATE', 'WAIT') ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add A_PROBLEM enum('', 'WARNING', 'PROBLEM', 'SERIOUS', 'UNVERIFIED') ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add A_PROBLEM_DESC varchar(255) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add A_PROBLEM_DATE varchar(30) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add A_STATUS enum('WAITING', 'NORMAL', 'MONITOR', 'WARNING', 'OFF_SOFT', 'OFF_HARD', 'DELETED') ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add A_STATUS_INFO varchar(255) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add A_CLASSIFIED varchar(100) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add T_WORKPOINTS varchar(100) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add T_WORKPOINTS_VALUE varchar(100) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add T_WORKPOINTS_TYPE varchar(100) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add T_WORKPOINTS_USER varchar(100) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add T_WORKPOINTS_DATE varchar(100) not null ; ";
$sqlList[] = " alter table USERS2_MARKETING_OVERWIEV add P_ACCOUNT varchar(40) not null ; ";
}
}
$errors = false;
foreach ($sqlList as $sql) {
echo'sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo'';
$res = $db->query($sql);
if ($db->has_errors()) {
$errors = true;
echo' (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($db->get_errors());echo'';
}
}
if ($errors) {
echo '' . "Uwaga wystąpiły błędy - w czerwonej ramce" . '
';
} else {
echo '' . "Operacje zakończone pomyślnie" . '
';
}
}