$trans_) { if(!isset($struct[$fld])) $ok=false; if(!isset($keys['`'.$fld.'`']) && $fld!='ID' ) $conn->add_index($tbl,$fld); } if($ok) { //sa wszystkie kolumny do utworzenia widoku $transform_=", '' as `ADRES` "; foreach($transform as $src=>$dst) { if(isset($struct[$src])) { $transform_=", `".$src."` as `".$dst."`"; echo "
Jest transform!"; } else echo "
Nie ma ".$src." w tabeli".$tbl; } $sql_=array(); if(isset($sql)) $sql[]=" union "; foreach($trans as $fld=>$as) { $sql_[]="`".$fld."` as `".$as."`"; } $sql[]=" ( select `ID`, '".$tbl."' as `TABLE`,".implode(',', $sql_).$transform_." from `".$tbl."` where ( L_APPOITMENT_DATE!='' ) order by A_RECORD_UPDATE_DATE DESC ) "; $msc=microtime(true); $conn->query("select `ID`, '".$tbl."' as `TABLE`,".implode(',', $sql_).$transform_." from `".$tbl."` where L_APPOITMENT_DATE!='' order by A_RECORD_UPDATE_DATE DESC "); $msc=microtime(true)-$msc; $czas[]="Czas ".$msc." dla tabeli ".$tbl; } } } DEBUG_S(3,'sql',$sql,__FILE__,__FUNCTION__,__LINE__); $sql_alter=$sql_drop." ".$sql_create." ".implode(" ", $sql); DEBUG_S(-3,'sql_alter',$sql_alter,__FILE__,__FUNCTION__,__LINE__); DEBUG_S(-3,'czasy',$czas,__FILE__,__FUNCTION__,__LINE__); $res=$conn->query($sql_alter); DEBUG_S(-3,'res',$res); //$struct=$conn->STRUCTURE_GENERATE($tbls); }