se/SE/superedit-ANALIZA_HISTORII_USERS2.php

<?php

if($_GET[ANALIZA_HISTORII_USERS2]) {
echo "ANALIZA_HISTORII_USERS2 <form action=$PHP_SELF method=\"GET\">";
echo "<input type=hidden name=ADD value=ADD>";
echo "<input type=hidden name=ANALIZA_HISTORII_USERS2 value=1>";


echo "<table border=1><tr><td>";

echo "Dodaj Lancuch dla poszukiwan okresu , (zakoncz znakiem %) - 500 rekordow</td><td>  <input type=text name=A_RECORD_UPDATE_DATE size=10 value=$_GET[A_RECORD_UPDATE_DATE]></td>
<td>  <input type=text name=A_RECORD_UPDATE_AUTHOR  size=10 value=\"$_GET[A_RECORD_UPDATE_AUTHOR]\"></td>
</tr>";
echo "<tr><td colspan=1><input type=submit name=ADD value=SZUKAJ></td><td>DATA (np. 2007-%)</td><td>Autor (np. %sqix%)</td><td>OPER</td><td>OPER_FIN</td><td>OPER_ZAD</td></tr>";

$ZAP_SQL="SELECT t1.S_ADDRESS_STREET as S_ADDRESS_STREET_t1 , t2.* FROM USERS2_HIST as t2 left join USERS2 as t1 on t1.ID=t2.ID_USERS2 where ( t2.A_RECORD_UPDATE_DATE like '".$_GET[A_RECORD_UPDATE_DATE]."' and t2.A_RECORD_UPDATE_AUTHOR like '".$_GET[A_RECORD_UPDATE_AUTHOR]."' ) limit 5000 ";
echo "$ZAP_SQL \n <br>";
if($_GET[A_RECORD_UPDATE_DATE]) ZAP_SQL("$ZAP_SQL");

while($DWA=mysql_fetch_array($result)) {

echo "<tr>\n";
    $AR=0;
//   print_r($DWA);

       if($DWA[A_PROBLEM]=='') $ARR[PROBLEM_CLEAR][$DWA[A_RECORD_UPDATE_AUTHOR]]++;
       else if($DWA[A_PROBLEM]!='N/S;') $ARR[PROBLEM_SET][$DWA[A_RECORD_UPDATE_AUTHOR]]++;
    foreach ($DWA as $DWA_A=>$DWA_V ) {

   if(($DWA_V!='N/S;')&&($DWA_A!=$AR)||($DWA_V=='S_ADDRESS_STREET_t1')) {
	
        echo "<td> ".str_replace('_',' ',$DWA_A)." = $DWA_V </td>";   
      $ARR[STAT][$DWA[A_RECORD_UPDATE_AUTHOR]][$DWA_A]++;
       if($DWA_A=='A_RECORD_UPDATE_AUTHOR') $ARR[AUTH][$DWA_V]++;


     }
     if($DWA_A==$AR)$AR++;
	//echo "<tr><td>".$DWA[S_ADDRESS_STREET]." $DWA[P_NAME] $DWA[P_PHONE]  $DWA[S_ALIAS] ( $DWA[S_OTHER_INFO] ) </td><td>".$DWA[I_OPER_ZAINT]."</td><td>".$DWA[I_BAD_DATE]." ";
	//echo "</td><td>$DWA[I_OPER]</td><td>$DWA[I_OPER_FIN]</td><td>$DWA[I_OPER_ZAD] asdf</td></tr>";

   
    }
echo "</tr>\n";


 }

echo "</table><pre>
Statystyka:
";

print_r($ARR);
echo "</pre>";

} //EOF IF