$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_=", t1.`".$src."` as `".$dst."`"; echo "
Jest transform!"; } else echo "
Nie ma ".$src." w tabeli".$tbl; } $errors_=" , if(t1.L_APPOITMENT_USER not like '' and t1.L_APPOITMENT_USER is not null and t1.A_STATUS in ('NORMAL','WAITING') and (t2.A_STATUS!='NORMAL' or t2.ADM_ADMIN_LEVEL>5),'Ustalony pracownik nie pracuje','') as ERROR "; //do weryfikacji bledow w spotkaniach $sql_=array(); if(isset($sql)) $sql[]=" union "; foreach($trans as $fld=>$as) { $sql_[]="t1.`".$fld."` as `".$as."`"; } $sql[]=" ( select t1.`ID`, '".$tbl."' as `TABLE`,".implode(',', $sql_).$transform_.$errors_." from `".$tbl."` as t1 left join ADMIN_USERS as t2 on t1.L_APPOITMENT_USER=t2.ADM_ACCOUNT where ( t1.L_APPOITMENT_DATE!='' ) order by t1.A_RECORD_UPDATE_DATE DESC ) "; $msc=microtime(true); $conn->query("select t1.`ID`, '".$tbl."' as `TABLE`,".implode(',', $sql_).$transform_.$errors_." from `".$tbl."` as t1 left join ADMIN_USERS as t2 on t1.L_APPOITMENT_USER=t2.ADM_ACCOUNT where t1.L_APPOITMENT_DATE!='' order by t1.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); }