'."\n";
while ($h = mysql_fetch_array($result)) {
$ILOSC_PISM++;
$JOB = "";
if (($h['K_LOKALIZACJA']!=$h['K_LOKALIZACJA_NEW'])&&($h['K_LOKALIZACJA_NEW']!='')) {
$JOB .= " PRZEMIEŚĆ / WYŚLIJ DOKUMENT DO MIEJSCA :
".$h['K_LOKALIZACJA_NEW']."(".$h['K_LOKALIZACJA_OPIS_NEW'].") ";
}
if (($h['NOW']>$h['A_RECORD_UPDATE_DATE_TS']+864000)&&($h['A_STATUS']!='OFF_HARD')) {
$JOB .= " SPRAWA PRZEDAWNIONA PONAD 10 DNI!!! ";
}
if (($h['ID_PROJECT']=='0')) {
$JOB .= " REKORD WYMAGA DEKRETACJI NA SPRAWE ";
}
if (($h['A_STATUS']=='WAITING')) {
$JOB .= " SPRAWA WYMAGA ZAŁATWIENIA (WAITING) ";
}
if (strlen($h['M_DIST_FILES'])>5) {
$JOB .= " (JEST SKAN) ";
}
$cls = 'row-'.($t = 1 - $t);
$cls .= ' type-' . "POCZTA";
if ($h['L_APPOITMENT_DATE'] > date('Y-m-d')) $cls .= ' l-app-stare';// . ' l-app-date-' . $h['L_APPOITMENT_DATE'];
echo '';
echo '';
echo $h['CO'];
//echo'
('.$h['_test'].')';
//echo'
[K.'.$h['ID'].'/P.'.$h['PROJ_ID'].']';
//echo'
{K.'.$h['_test_kor_app'].'}';
//echo'
{P.'.$h['_test_proj_app'].'}';
if ($selected_user) {
echo'
('.$h['_test_id'].')';
//} else {
// echo '
';
// if ($h['_test_kor_app']) {
// echo '(kor. ' . $h['_test_kor_app'] . ') ';
// }
// if ($h['_test_proj_app']) {
// echo '(proj. ' . $h['_test_proj_app'] . ') ';
// }
}
echo ' | ';
echo '';
echo "L.Dz.(K_ID):";
echo ''.$h['ID'].'';
echo ' | ';
echo ''.$h['A_RECORD_CREATE_DATE'].' | ';
echo ''.$h['K_TYP_KORESP']." -".$h['K_TYP_RODZAJ']." (".$h['K_TYP_RODZAJ_OPIS'].")".' | ';
echo ''.$JOB.' | ';
echo ''."Wpr: ".$h['A_RECORD_CREATE_AUTHOR']."/ akt : ".$h['A_RECORD_UPDATE_AUTHOR']."(".$h['A_RECORD_UPDATE_DATE'].")".' | ';
echo ''.$h['K_OD_KOGO']."/".$h['OD_KOGO_ADRES']."/".$h['K_ZAWARTOS'].' | ';
echo ''.$h['L_APPOITMENT_USER']." ".$h['L_APPOITMENT_INFO']." ".$h['L_APPOITMENT_INFO']."Termin:".$h['L_APPOITMENT_DATE'].' | ';
echo ''.$h['K_ZNAK_REFERENTA'].' | ';
echo ''.$h['ID_PROJECT']."
".$h['P_M_DIST_DESC']." ( firma ".$h['P_M_DISTRIBUTOR'].") ".' | ';
echo ''.$h['K_LOKALIZACJA']."(".$h['K_LOKALIZACJA_OPIS'].")".' | ';
echo '
'."\n";
}// eof while sql
/**
* zapytania:
* 1. wszytkie projekty przypisane do $selected_user
* 2. przypisane do nikogo, gdzie proj. nadrzedny (P_ID) jest przyipsany do $selected_user
* 3. przypisane do nikogo, gdzie proj. nadrzedny do nikogo, a projekt nad nim do $selected_user
* 4. ...
* ...
*/
if ($selected_user) {// for recursive search of admins of project @2012-05-03
$extra_proj[1] = " and t1.`L_APPOITMENT_USER`='".$selected_user."' ";
$extra_proj[2] = " and t2.`L_APPOITMENT_USER`='".$selected_user."' ";
$extra_proj[3] = " and t3.`L_APPOITMENT_USER`='".$selected_user."' ";
}
$zap_sql = "select t1.*
-- , 'SPRAWA/PROJEKT' as CO
, 'PROJEKT' as CO
, IF(''='".$selected_user."', '',
IF(t1.`L_APPOITMENT_USER`='".$selected_user."', t1.ID, t1.ID)
) as _test_proj_id
, unix_timestamp(now()) as NOW
, unix_timestamp(t1.A_RECORD_UPDATE_DATE) as A_RECORD_UPDATE_DATE_TS
from IN7_MK_BAZA_DYSTRYBUCJI as t1
where (
t1.A_STATUS='WAITING'
-- or ( t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > (864000+unix_timestamp(t1.A_RECORD_UPDATE_DATE)) )
-- or ( t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > unix_timestamp(t1.L_APPOITMENT_DATE) and t1.L_APPOITMENT_DATE!='' )
or (
IF(t1.L_APPOITMENT_DATE!=''
, t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > unix_timestamp(t1.L_APPOITMENT_DATE)
, t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > (864000+unix_timestamp(t1.A_RECORD_UPDATE_DATE))
)
)
)
and t1.A_STATUS!='DELETED'
".$extra_proj[1]."
union
select t1.*
-- , 'SPRAWA/PROJEKT' as CO
, 'PROJEKT' as CO
, IF(''='".$selected_user."', '',
IF(t1.`L_APPOITMENT_USER`='".$selected_user."', t1.ID, t2.ID)
) as _test_proj_id
, unix_timestamp(now()) as NOW
, unix_timestamp(t1.A_RECORD_UPDATE_DATE) as A_RECORD_UPDATE_DATE_TS
from IN7_MK_BAZA_DYSTRYBUCJI as t2
left join IN7_MK_BAZA_DYSTRYBUCJI as t1 on ( t2.ID=t1.P_ID )
where (
t1.A_STATUS='WAITING'
-- or ( t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > (864000+unix_timestamp(t1.A_RECORD_UPDATE_DATE)) )
-- or ( t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > unix_timestamp(t1.L_APPOITMENT_DATE) and t1.L_APPOITMENT_DATE!='' )
or (
IF(t1.L_APPOITMENT_DATE!=''
, t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > unix_timestamp(t1.L_APPOITMENT_DATE)
, t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > (864000+unix_timestamp(t1.A_RECORD_UPDATE_DATE))
)
)
)
and t1.A_STATUS!='DELETED'
and t1.L_APPOITMENT_USER=''
".$extra_proj[2]."
union
select t1.*
-- , 'SPRAWA/PROJEKT' as CO
, 'PROJEKT' as CO
, IF(''='".$selected_user."', '',
IF(t1.`L_APPOITMENT_USER`='".$selected_user."', t1.ID, t3.ID)
) as _test_proj_id
, unix_timestamp(now()) as NOW
, unix_timestamp(t1.A_RECORD_UPDATE_DATE) as A_RECORD_UPDATE_DATE_TS
from IN7_MK_BAZA_DYSTRYBUCJI as t3
left join IN7_MK_BAZA_DYSTRYBUCJI as t2 on ( t3.ID=t2.P_ID )
left join IN7_MK_BAZA_DYSTRYBUCJI as t1 on ( t2.ID=t1.P_ID )
where (
t1.A_STATUS='WAITING'
-- or ( t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > (86400+unix_timestamp(t1.A_RECORD_UPDATE_DATE)) )
-- or ( t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > unix_timestamp(t1.L_APPOITMENT_DATE) and t1.L_APPOITMENT_DATE!='' )
or (
IF(t1.L_APPOITMENT_DATE!=''
, t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > unix_timestamp(t1.L_APPOITMENT_DATE)
, t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > (864000+unix_timestamp(t1.A_RECORD_UPDATE_DATE))
)
)
)
and t1.A_STATUS!='DELETED'
and t1.L_APPOITMENT_USER=''
and t2.L_APPOITMENT_USER=''
".$extra_proj[3]."
";
$zap_sql_join = "";
$zap_sql_where = "";
if ($selected_user) {
$CD = 2;
$zap_sql_where .= "\n and t".($CD-1).".L_APPOITMENT_USER='' ";
$CD = 3;
$zap_sql_where .= "\n and t".($CD-1).".L_APPOITMENT_USER='' ";
}
for ($CD = 4; $CD <= $DEEP_SQL_RECURSE; $CD++) {
if ($selected_user) {
$zap_sql_where .= "\n and t".($CD-1).".L_APPOITMENT_USER='' ";
}
$zap_sql_join = "
left join `IN7_MK_BAZA_DYSTRYBUCJI` as t".($CD-1)." on ( t".$CD.".ID=t".($CD-1).".P_ID )
".$zap_sql_join;
$zap_sql .= "
union
select t1.*
-- ,'SPRAWA/PROJEKT' as CO
, 'PROJEKT' as CO
, IF(''='".$selected_user."', '',
IF(t1.`L_APPOITMENT_USER`='".$selected_user."', t1.ID, t".$CD.".ID)
) as _test_proj_id
, unix_timestamp(now()) as NOW
, unix_timestamp(t1.A_RECORD_UPDATE_DATE) as A_RECORD_UPDATE_DATE_TS
from `IN7_MK_BAZA_DYSTRYBUCJI` as t".$CD."
".$zap_sql_join."
left join `IN7_MK_BAZA_DYSTRYBUCJI` as t2 on ( t3.ID=t2.P_ID )
left join `IN7_MK_BAZA_DYSTRYBUCJI` as t1 on ( t2.ID=t1.P_ID )
where (
t1.`A_STATUS`='WAITING'
-- or ( t1.`A_STATUS`!='OFF_HARD' and unix_timestamp(now()) > (86400+unix_timestamp(t1.`A_RECORD_UPDATE_DATE`)) )
-- or ( t1.`A_STATUS`!='OFF_HARD' and unix_timestamp(now()) > unix_timestamp(t1.`L_APPOITMENT_DATE`) and t1.`L_APPOITMENT_DATE`!='' )
or (
IF(t1.L_APPOITMENT_DATE!=''
, t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > unix_timestamp(t1.L_APPOITMENT_DATE)
, t1.A_STATUS!='OFF_HARD' and unix_timestamp(now()) > (864000+unix_timestamp(t1.A_RECORD_UPDATE_DATE))
)
)
)
and t1.`A_STATUS`!='DELETED'
";
if ($selected_user) {
$zap_sql .= $zap_sql_where . " and t".$CD.".`L_APPOITMENT_USER`='".$selected_user."' \n ";
}
}
$zap_sql .= " group by t1.ID ";
if(isset($_GET['DBG']) && $_GET['DBG']==1){echo'zap_sql: '."\n";print_r($zap_sql);echo'
';}
$result = mysql_query($zap_sql, $conn1) or die("blad zapytania do bazy ".$zap_sql);
while ($h = mysql_fetch_array($result)) {
$ILOSC_SPRAW++;
echo '';
echo '';
echo $h['CO']." ".''.$h['A_STATUS'].'';
if ($selected_user) {
echo'
('.$h['_test_proj_id'].')';
}
echo ' | ';
echo ''."Sprawa(ID):".''.$h['ID'].''."
Teczka Nadrzędna(PID): ".''.$h['P_ID'].''." ".' | ';
echo ''."M DIST DATE ".$h['M_DIST_DATE'].' | ';
echo '';
if (strlen($h['M_DIST_TYPE'] > 20)) {
echo $h['M_DIST_TYPE'];
} else {
echo str_replace('_',' ',$h['M_DIST_TYPE']);
}
echo ' | ';
echo '';
echo $h['M_DIST_DESC']." ( firma ".$h['M_DISTRIBUTOR'].") ";
if (strstr($h['M_DIST_TYPE'], 'TV_')) {
foreach ($h as $HRI => $HRV) {
if (isset($h[$HRI])) {
if (strstr($HRI, 'TV_')) {
if (strlen($h[$HRI]) > 1) {
echo " ".str_replace('_',' ',$HRI).": ".$h[$HRI]."";
}
}
}
}
}
echo ' | ';
echo ''."Wpr: ".$h['A_RECORD_CREATE_AUTHOR']."/ akt : ".$h['A_RECORD_UPDATE_AUTHOR']."(".$h['A_RECORD_UPDATE_DATE'].")".' | ';
echo ''." ".$h['A_PROBLEM']." ".$h['A_PROBLEM_DATE']." ".$h['A_PROBLEM_DESC']." ".' | ';
echo'
';
} //eof while sql
echo'';
echo '