('.$allParameters.')'; } function nvl($value, $nvl) { if ($value == "" || !isset($value)) { return $nvl; } else { return $value; } } $hresIsHipo = 'N'; // Ob der User(Hres) zu der Stelle oder darunter geh�rt if (isset($caOids)) { foreach($caOids as $caOid) { if (isset($_POST['dutyOid'.$caOid])) { $dutyOid = htmlentities(strip_tags(trim($_POST["dutyOid".$caOid]))); } else { $dutyOid = ''; } $dutyOids[$caOid] = $dutyOid; if (isset($_POST['info'.$caOid])) { $info = htmlentities(strip_tags(trim($_POST["info".$caOid]))); } else { $info = ''; } $infos[$caOid] = $info; if (isset($_POST['caDutyOid'.$caOid])) { $caDutyOid = htmlentities(strip_tags(trim($_POST["caDutyOid".$caOid]))); } else { $caDutyOid = ''; } $caDutyOids[$caOid] = $caDutyOid; } } $finishCTButton = false; $finishCAButton = false; $empty = true; if (isset($caOids)) { foreach($caOids as $caOid) { if (isset($_POST['finishCA'.$caOid])) { $finishCAButton = true; $editNavigation = "#ca".$caOid; } if (isset($_POST['finishCT'.$caOid])) { $finishCTButton = true; $editNavigation = "#ca".$caOid; } } $empty = false; } if ($finishCTButton) { foreach($caOids as $caOid) { if (isset($_POST['ctOid'.$caOid])) { $ctOid = htmlentities(strip_tags(trim($_POST["ctOid".$caOid]))); } else { unset($ctOid); } // WB 23.02.12: auch wenn der HR kein user ist, soll die Aufgabe zu erledigen sein. if (!isset($usOid)) { $usOid = ''; } if (isset($ctOid) && isset($usOid)) { if ($dutyOids[$caOid] == '') { $dutyOid = 'null'; } else { $dutyOid = $dutyOids[$caOid]; } if ($usOid == '') { $usOid = 'null'; } if ($ctOid == '') { $ctOid = 'null'; } if ($infos[$caOid] == '') { $info = ''; } else { $info = $infos[$caOid]; } // WB 26.05.2014: Fileupload // Einstellungswerte aus DB holen $sql = 'select rworld_pack_settings.get(\'LINKPATHDB\', null, null, null, null, null) val from dual'; $tabLinkPathDB = getQuery($sql); if (isset($tabLinkPathDB)) { foreach($tabLinkPathDB as $v) { $linkPathDB = $v['VAL']; } } if (!isset($linkPathDB)) { $linkPathDB = 'd:\\e-pilot\\'; } $sql = 'select rworld_pack_settings.get(\'TEMP_PATH\', null, null, null, null, null) val from dual'; $tabTempPath = getQuery($sql); if (isset($tabTempPath)) { foreach($tabTempPath as $v) { $tempPath = $v['VAL']; } } if (!isset($tempPath)) { $tempPath = 'tempdata\\'; } if (isset($_FILES)) { for($i=0; $i\') TEXT1 , replace(apex_escape.HTML_ATTRIBUTE(substr(text, 501,500)), chr(38)||\'#xA;\',\'
\') TEXT2 , replace(apex_escape.HTML_ATTRIBUTE(substr(text,1001,500)), chr(38)||\'#xA;\',\'
\') TEXT3 , replace(apex_escape.HTML_ATTRIBUTE(substr(text,1501,500)), chr(38)||\'#xA;\',\'
\') TEXT4 , replace(apex_escape.HTML_ATTRIBUTE(substr(text,2001,500)), chr(38)||\'#xA;\',\'
\') TEXT5 , replace(apex_escape.HTML_ATTRIBUTE(substr(text,2501,500)), chr(38)||\'#xA;\',\'
\') TEXT6 , replace(apex_escape.HTML_ATTRIBUTE(substr(text,3001,500)), chr(38)||\'#xA;\',\'
\') TEXT7 , replace(apex_escape.HTML_ATTRIBUTE(substr(text,3501,500)), chr(38)||\'#xA;\',\'
\') TEXT8 , SETS_OID, apex_escape.HTML_ATTRIBUTE(sets_name) SETS_NAME, CA_OID , to_char(DEADLINE,\'YYYY-MM-DD HH24:MI:SS\') deadline, FLAG_OK, SERU_OID, FINISH_US_OID, apex_escape.HTML_ATTRIBUTE(FINISH_US_SF_NAME) FINISH_US_SF_NAME , to_char(FINISH_DATE,\'YYYY-MM-DD HH24:MI:SS\') finish_date, MAIL_TEXT , to_char(MAIL_DATE,\'YYYY-MM-DD HH24:MI:SS\') mail_date, MAIL_US_OID, MAIL_COMT_CODA_OID, ESC_PHASE, CAST_TEXT , IMPORTANT, CT_CAST_CODA_OID, CT_CAST_NAME, CT_CAST_TEXT, apex_escape.HTML_ATTRIBUTE(case_status) CASE_STATUS, CT_MAIL_TEXT, CT_INFO, DUTY_CODA_OID , apex_escape.HTML_ATTRIBUTE(duty_name) DUTY_NAME, CATA_CODA_OID, CATA_NAME, SPEZIFIKATION' .' from rworld_ca_v where oid in ('; $i = 0; foreach ($caOids as $cOid) { $i++; switch ($i) { case 1: $sql .= $cOid; break; default: $sql .= ','.$cOid; break; } } $sql .= ')'; } $tabCa = getQuery($sql); if (isset($tabCa)) { foreach($tabCa as $recCa) { // Ermitteln des Communications $sql = 'select apex_escape.HTML_ATTRIBUTE(DIALLING_CODE) DIALLING_CODE, apex_escape.HTML_ATTRIBUTE(COMM_CODE) COMM_CODE, apex_escape.HTML_ATTRIBUTE(DIRECT_CODE) DIRECT_CODE, apex_escape.HTML_ATTRIBUTE(COMT_NAME) COMT_NAME from rworld_communications_v where per_oid=to_number(\''.$recCa['PER_OID'].'\') order by seq, comt_name, oid'; $tabComm[$recCa['OID']] = getQuery($sql); // ermitteln der CaseItems $sql = 'select SEQ, apex_escape.HTML_ATTRIBUTE(item_name) ITEM_NAME, apex_escape.HTML_ATTRIBUTE(value) VALUE, apex_escape.HTML_ATTRIBUTE(tooltip) TOOLTIP from rworld_cait_v where ca_oid='.$recCa['OID'].'and item_flag_show=\'J\' order by seq, item_name, item_oid'; $tabCait[$recCa['OID']] = getQuery($sql); // ermitteln der CaseTasks $sql = 'select FLAG_OK, CATA_CODA_OID, apex_escape.HTML_ATTRIBUTE(cata_name) CATA_NAME, HRES_OID, HIPO_OID, ROLE_OID,DUTY_FLAG_SUCCESS, to_char(finish_date,\'YYYY-MM-DD HH24:MI:SS\') FINISH_DATE, apex_escape.HTML_ATTRIBUTE(duty_name) DUTY_NAME, apex_escape.HTML_ATTRIBUTE(name) NAME, apex_escape.HTML_ATTRIBUTE(cast_name) CAST_NAME, apex_escape.HTML_ATTRIBUTE(info) INFO, OID from rworld_ct_v where ca_oid='.$recCa['OID'].' order by flag_ok, seq, cre_date, oid'; $tabCt[$recCa['OID']] = getQuery($sql); // ermitteln der Case-Erledigungsarten $sql = 'select hier_oid,sets_oid,oid,apex_escape.HTML_ATTRIBUTE(name) name,flag_type,flag_success,cata_coda_oid from rworld_duty_lov duty where hier_oid='.$recCa['HIER_OID'].' and flag_type in (\'B\', \'C\') and sets_oid='.$recCa['SETS_OID'].'and cata_coda_oid is null order by upper(name)'; $tabCaDuty[$recCa['OID']] = getQuery($sql); $sql = 'select letr.oid,letr.seq, apex_escape.HTML_ATTRIBUTE(art.id) art_id,apex_escape.HTML_ATTRIBUTE(letr.add_text) add_text, apex_escape.HTML_ATTRIBUTE(stun.name) stun_name' .', decode(busi.curr_oid, nvl(curr.oid, busi.curr_oid), decode(nvl(letr.quantity,0), 0, round(letr.price,2), round(letr.price/letr.quantity,2)), round(rworld_pack_curr.get_fw_betrag(curr.oid, busi.curr_oid, decode(nvl(letr.quantity,0), 0, letr.price, letr.price/letr.quantity), nvl(ca.case_date,ca.cre_date),2))) price_per_unit' .', letr.quantity' .', decode(busi.curr_oid, nvl(curr.oid, busi.curr_oid), decode(nvl(letr.quantity,0), 0, round(letr.price,2), round(letr.price/letr.quantity,2) * letr.quantity), round(decode(nvl(letr.quantity,0),0, rworld_pack_curr.get_fw_betrag(curr.oid, busi.curr_oid, letr.price, nvl(ca.case_date,ca.cre_date),2),rworld_pack_curr.get_fw_betrag(curr.oid, busi.curr_oid, letr.price/letr.quantity, nvl(ca.case_date,ca.cre_date),2) * letr.quantity))) price' .', apex_escape.HTML_ATTRIBUTE(curr.id) curr_id, curr.oid curr_oid' .', apex_escape.HTML_ATTRIBUTE(busi_curr.id) busi_curr_id, busi_curr.oid busi_curr_oid' .', apex_escape.HTML_ATTRIBUTE(rwwws_pack_trla.get_ladi_ids(letr.oid)) ladis' .', decode(busi.curr_oid, nvl(curr.oid, busi.curr_oid), 0, round(rworld_pack_curr.get_fw_betrag(curr.oid, busi.curr_oid, 1, nvl(ca.case_date,ca.cre_date),6))) kurs' .' from rworld_currencies busi_curr, rwwws_standard_units stun, rwwws_articles art, rwwws_ledger_trades letr, rworld_business_years busi, rworld_currencies curr, rwwws_trade_headers trhe, rworld_cases ca, rworld_ca_trhe catr' .' where catr.ca_oid = '.$recCa['OID'].' and ca.oid = catr.ca_oid and trhe.oid = catr.trhe_oid and busi.oid = trhe.by_oid and curr.oid(+) = trhe.curr_oid and letr.trhe_oid = trhe.oid and art.oid = letr.art_oid and stun.oid = art.stun_oid and busi_curr.oid = busi.curr_oid' .' and not exists (select 1 from rwwws_trhe_order_details trod where trod.trhe_oid = trhe.oid)' .' order by trhe.id, trhe.oid, letr.seq,letr.oid,art.seq,art.id'; $tabLetr[$recCa['OID']] = getQuery($sql); } } ?> Case Anzeige
'; } if (isset($tabCa) && count($tabCa) > 0) { $anzCases = 0; foreach($tabCa as $recCa) { $anzCases++; switch ($anzCases) { case 1: break; default: echo '
'; break; } /* *************************************************************************************** * Caseinitiator ****************************************************************************************/ echo '
'; echo '

'.trim(($recCa['HIER_NAME'])).'

'; echo ''; if ($recCa['DEADLINE'] == '' ) { $deadline = ''; $deadlineTxt = ''; } else { if (date('H:i',strtotime($recCa['DEADLINE'])) == '00:00') { $deadline = date('d.m.Y',strtotime($recCa['DEADLINE'])); } else { $deadline = date('d.m.Y H:i',strtotime($recCa['DEADLINE'])); } $deadlineTxt = _FRIST; } if ($recCa['FLAG_OK'] == 'J') { $img = 'OK'; } else { $img = ''; } echo '
'; echo '

'.trim(htmlentities(_INITIATOR)).'

'; echo '

'.trim(($recCa['PER_SF_NAME'])).'

'; echo '

'.trim(($recCa['PER_STREET'])).'

'; echo '

'.trim(($recCa['PER_PLACE'])).'

'; //echo ''; echo '
'; //echo '
'; /* *************************************************************************************** * Kommunikationen ****************************************************************************************/ if (isset($tabComm[$recCa['OID']])) { if (count($tabComm[$recCa['OID']] > 0)) { echo '

'.trim(htmlentities(_KOMMUNICATION)).'

'; echo ''; foreach($tabComm[$recCa['OID']] as $recComm) { // xxx if (strpos($recComm['DIALLING_CODE'].$recComm['COMM_CODE'].$recComm['DIRECT_CODE'],'@') !== FALSE) { // email-adresse $comm = ''.trim(($recComm['DIALLING_CODE'].$recComm['COMM_CODE'].$recComm['DIRECT_CODE'])).''; } elseif (strpos(strtolower($recComm['COMT_NAME']), 'tel') !== FALSE) { // telefonnummer $comm = $recComm['DIALLING_CODE'].$recComm['COMM_CODE'].$recComm['DIRECT_CODE']; $comm = ''.trim(($comm)).''; } elseif (strpos(strtolower($recComm['COMT_NAME']), 'fax') !== FALSE) { // faxnummer $comm = $recComm['DIALLING_CODE'].$recComm['COMM_CODE'].$recComm['DIRECT_CODE']; $comm = ''.trim(($comm)).''; } else { // andere $comm = trim(($recComm['DIALLING_CODE'].$recComm['COMM_CODE'].$recComm['DIRECT_CODE'])); } echo ''; } echo '
'.$recComm['COMT_NAME'].':'.$comm.'
'; echo '
'; } } echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; if ($deadline != '') { echo ''; } if ($recCa['FLAG_OK'] == 'J') { echo ''; echo ''; echo ''; } if ($recCa['CASE_STATUS'] != '') { echo ''; } echo '
'.trim(($recCa['SETY_NAME'])).'
'.trim(htmlentities(_CASE_ID)).''.$recCa['ID'].'
'.trim(htmlentities(_ERFASST_DURCH)).''.trim(($recCa['US_SF_NAME'])).'
'.trim(htmlentities(_ERFASST_AM)).''.date('d.m.Y H:i',strtotime($recCa['CRE_DATE'])).'
'.trim(htmlentities(_FRIST)).''.$deadline.'
'.trim(htmlentities(_ABGESCHLOSSEN_VON)).''.trim(($recCa['FINISH_US_SF_NAME'])).'
'.trim(htmlentities(_ABGESCHLOSSEN_AM)).''.date('d.m.Y H:i',strtotime($recCa['FINISH_DATE'])).'
'.trim(htmlentities(_CASE_ERL_ART)).''.trim(($recCa['DUTY_NAME'])).'
'.trim(htmlentities(_STATUS)).''.trim(($recCa['CASE_STATUS'])).'
'; echo '
'; echo '
'; /* *************************************************************************************** * Casedetail ****************************************************************************************/ echo '
'; echo ''; echo '

'.trim(($recCa['SETS_NAME'])).$img.'

'; echo '
'; echo '
'; /* *************************************************************************************** * Items ****************************************************************************************/ if (isset($tabCait[$recCa['OID']]) && count($tabCait[$recCa['OID']]) > 0) { $x = 0; $openTab = false; echo ''; foreach($tabCait[$recCa['OID']] as $recCait) { if ($recCait['SEQ']%2 == 0) { // links $lItem = $recCait['ITEM_NAME']; $lValue = $recCait['VALUE']; if ($recCait['TOOLTIP'] != '') { $lTooltip = ' title="'.trim(($recCait['TOOLTIP'])).'"'; } else { $lTooltip = ''; } $rItem = ''; $rValue = ''; $rTooltip = ''; } else { // rechts $lItem = ''; $lValue = ''; $lTooltip = ''; $rItem = $recCait['ITEM_NAME']; $rValue = $recCait['VALUE']; if ($recCait['TOOLTIP'] != '') { $rTooltip = ' title="'.trim(($recCait['TOOLTIP'])).'"'; } else { $rTooltip = ''; } } if ($x == 0) { if ($recCait['SEQ']%2 == 0) { echo ''; echo ''.''; $x = 1; $openTab = true; } else { if ($openTab) { echo ''.''; $openTab = false; } echo ''.''; echo ''.''; $x = 0; $openTab = false; } } else { if ($recCait['SEQ']%2 == 0) { echo ''.''; echo ''.''; $openTab = true; $x = 1; } else { echo ''.''; $openTab = false; $x = 0; } } //echo ''.''; //echo ''.''; } if ($openTab) { echo ''.''; $openTab = false; } echo '
'.trim(($lItem)).''.trim(($lValue)).'
'.trim(($rItem)).''.trim(($rValue)).'
'.trim(($lItem)).''.trim(($lValue)).''.trim(($rItem)).''.trim(($rValue)).'
'.$lItem.''.$lValue.''.$rItem.''.$rValue.'
'; } echo '
'; echo '
'; if (trim(($recCa['TEXT1'])) != '') { echo '

'.trim(htmlentities(_TEXT)).'
'.str_replace(chr(13),'',str_replace(chr(10),'
',trim(($recCa['TEXT1'].$recCa['TEXT2'].$recCa['TEXT3'].$recCa['TEXT4'].$recCa['TEXT5'].$recCa['TEXT6'].$recCa['TEXT7'].$recCa['TEXT8'])))).'

'; } echo '
'; echo '
'; /* *************************************************************************************** * Warenwirtschaftzeilen ****************************************************************************************/ if (isset($tabLetr[$recCa['OID']]) && count($tabLetr[$recCa['OID']]) > 0) { echo '
'; echo ''; $letrSum = 0; $anzLetr = 0; foreach($tabLetr[$recCa['OID']] as $recLetr) { if ($anzLetr == 0) { $currencySymbol = ' ('.$recLetr['BUSI_CURR_ID'].')'; if ($recLetr['CURR_OID'] == '' || $recLetr['CURR_OID'] == $recLetr['BUSI_CURR_OID']) { $showCurrRate = 'N'; $trheCurrID = ''; $busiCurrID = ''; $currKurs = ''; } else { $showCurrRate = 'J'; $trheCurrID = $recLetr['CURR_ID']; $busiCurrID = $recLetr['BUSI_CURR_ID']; $currKurs = $recLetr['KURS']; } echo ''; } $anzLetr++; echo ''; $letrSum += $recLetr['PRICE']; } echo ''; echo '
#'.trim(htmlentities(_ARTIKEL)).''.trim(htmlentities(_EINHEIT)).''.trim(htmlentities(_PREIS_PRO_EINHEIT)).$currencySymbol.''.trim(htmlentities(_ANZAHL)).''.trim(htmlentities(_PREIS)).$currencySymbol.''.trim(htmlentities(_DIMENSIONEN)).'
'.$recLetr['SEQ'].''.trim(($recLetr['ADD_TEXT'])).''.trim(($recLetr['STUN_NAME'])).''.number_format($recLetr['PRICE_PER_UNIT'],2,DECI,TSD).''.number_format($recLetr['QUANTITY'],2,DECI,TSD).''.number_format($recLetr['PRICE'],2,DECI,TSD).''.trim(($recLetr['LADIS'])).'
'._SUMME.$currencySymbol.''.number_format($letrSum,2,DECI,TSD).'
'; if ($showCurrRate == 'J') { echo '

'.trim(htmlentities(_WAE_DES_VERTRAGES)).' '.$trheCurrID.' '.trim(htmlentities(_WECHSELKURS_ZU)).' '.$busiCurrID.':'.number_format($currKurs,6,DECI,TSD).'

'; } echo '
'; echo '
'; } /* *************************************************************************************** * Lobs ****************************************************************************************/ $lobs = getLobs($recCa['OID'], '', ''.$usOid.''); if (isset($lobs) && count($lobs) > 0) { echo '
'; foreach($lobs as $lob) { echo ''.trim(($lob['file_name'])).' '; /* WB 02.12.19: Umlauteproblem echo ''.trim(($lob['file_name'])).' '; */ echo ''.trim($lob['file_name']).' '; } echo '
'; echo '
'; } /* *************************************************************************************** * Aufgaben ****************************************************************************************/ echo '
'; if (isset($tabCt[$recCa['OID']]) && count($tabCt[$recCa['OID']]) > 0) { echo '

'.trim(htmlentities(_AUFGABEN)).'

'; echo ''; echo ''.''.''.''.''.''; $allCataErledigt = 'J'; foreach($tabCt[$recCa['OID']] as $recCt) { if ($recCt['FLAG_OK'] == 'N') { $allCataErledigt = 'N'; } // ermitteln der Casetasks-Erledigungsarten if ($recCt['CATA_CODA_OID'] == '') { $cataCodaOid = -1; } else { $cataCodaOid = $recCt['CATA_CODA_OID']; } $sql = 'select hier_oid,sets_oid,oid,apex_escape.HTML_ATTRIBUTE(name) name,flag_type,flag_success,cata_coda_oid from rworld_duty_lov duty where hier_oid='.$recCa['HIER_OID'].' and flag_type in (\'B\', \'T\') and sets_oid='.$recCa['SETS_OID'].' and nvl(cata_coda_oid,-1)='.$cataCodaOid.' order by upper(name)'; $tabDuty[$recCa['OID']] = getQuery($sql); $hresIsHipo = 'N'; if ($recCt['HRES_OID'] == '' && ($recCt['HIPO_OID'] != '' || $recCt['ROLE_OID'] != '') && $recCt['FLAG_OK'] == 'N' && $hresOid != '') { // ermitteln, ob der User zu der Stelle gehört $sql = 'select \'J\' FLAG_EXISTS from dual where '.$hresOid.' in ( select hphr.hres_oid from rwh_hipo_hres hphr , rwh_hier_positions hipo where hphr.hipo_oid(+) = hipo.oid and trunc(sysdate) between nvl(hphr.start_date, trunc(sysdate)) and nvl(hphr.end_date, trunc(sysdate)) group by hphr.hres_oid connect by prior hipo.oid = hipo.hipo_oid start with hipo.oid = '.nvl($recCt['HIPO_OID'],-1).' UNION select roru.hres_oid oid from rwf_ladi_dimensions ladi , rworld_role_rules roru where roru.role_oid = '.nvl($recCt['ROLE_OID'],-1).' and ladi.oid = roru.ladi_oid and ladi.per_oid = '.nvl($recCa['PER_OID'],-1).' and roru.hres_oid is not null and sysdate between nvl(roru.start_date,sysdate) and nvl(roru.end_date,sysdate) UNION select roru.hres_oid oid from rworld_role_rules roru where roru.role_oid = '.nvl($recCt['ROLE_OID'],-1).' and roru.hier_oid = '.nvl($recCa['HIER_OID'],-1).' and roru.ladi_oid is null and roru.hres_oid is not null and not exists ( select 1 from rwf_ladi_dimensions ladi , rworld_role_rules rr where rr.role_oid = roru.role_oid and ladi.oid = rr.ladi_oid and ladi.per_oid = '.nvl($recCa['PER_OID'],-1).' ) UNION select roru.hres_oid oid from rworld_role_rules roru where roru.role_oid = '.nvl($recCt['ROLE_OID'],-1).' and roru.hier_oid is null and roru.ladi_oid is null and roru.hres_oid is not null and not exists ( select 1 from rwf_ladi_dimensions ladi , rworld_role_rules rr where rr.role_oid = roru.role_oid and ladi.oid = rr.ladi_oid and ladi.per_oid= '.nvl($recCa['PER_OID'],-1).' ) and not exists ( select 1 from rworld_role_rules rr where rr.role_oid = roru.role_oid and rr.hier_oid = '.nvl($recCa['HIER_OID'],-1).' ) UNION select hphr.hres_oid oid from rwh_hipo_hres hphr , rwf_ladi_dimensions ladi , rworld_role_rules roru where roru.role_oid = '.nvl($recCt['ROLE_OID'],-1).' and ladi.oid = roru.ladi_oid and ladi.per_oid = '.nvl($recCa['PER_OID'],-1).' and roru.hipo_oid is not null and sysdate between nvl(roru.start_date, sysdate) and nvl(roru.end_date, sysdate) and hphr.hipo_oid in ( select hipo.oid from rwh_hier_positions hipo connect by prior hipo.oid = hipo.hipo_oid start with oid = roru.hipo_oid ) and trunc(sysdate) between nvl(hphr.start_date, trunc(sysdate)) and nvl(hphr.end_date, trunc(sysdate)) group by hphr.hres_oid UNION select hphr.hres_oid oid from rwh_hipo_hres hphr , rworld_role_rules roru where roru.role_oid = '.nvl($recCt['ROLE_OID'],-1).' and roru.hier_oid = '.nvl($recCa['HIER_OID'],-1).' and roru.ladi_oid is null and roru.hipo_oid is not null and hphr.hipo_oid in ( select hipo.oid from rwh_hier_positions hipo connect by prior hipo.oid = hipo.hipo_oid start with oid = roru.hipo_oid ) and trunc(sysdate) between nvl(hphr.start_date, trunc(sysdate)) and nvl(hphr.end_date, trunc(sysdate)) and not exists ( select 1 from rwf_ladi_dimensions ladi , rworld_role_rules rr where rr.role_oid =roru.role_oid and ladi.oid =rr.ladi_oid and ladi.per_oid='.nvl($recCa['PER_OID'],-1).' ) group by hphr.hres_oid UNION select hphr.hres_oid oid from rwh_hipo_hres hphr , rworld_role_rules roru where roru.role_oid = '.nvl($recCt['ROLE_OID'],-1).' and roru.hier_oid is null and roru.ladi_oid is null and roru.hipo_oid is not null and hphr.hipo_oid in ( select hipo.oid from rwh_hier_positions hipo connect by prior hipo.oid = hipo.hipo_oid start with oid = roru.hipo_oid ) and trunc(sysdate) between nvl(hphr.start_date, trunc(sysdate)) and nvl(hphr.end_date, trunc(sysdate)) and not exists ( select 1 from rwf_ladi_dimensions ladi , rworld_role_rules rr where rr.role_oid = roru.role_oid and ladi.oid = rr.ladi_oid and ladi.per_oid= '.nvl($recCa['PER_OID'],-1).' ) and not exists ( select 1 from rworld_role_rules rr where rr.role_oid = roru.role_oid and rr.hier_oid = '.nvl($recCa['HIER_OID'],-1).' ) group by hphr.hres_oid )'; $tabUs = getQuery($sql); if (isset($tabUs) && count($tabUs)>0) { foreach($tabUs as $recUs) { if ($recUs['FLAG_EXISTS'] == 'J') { $hresIsHipo = 'J'; } } } } if (($recCt['HRES_OID'] == $hresOid || $hresIsHipo == 'J') && $recCt['FLAG_OK'] == 'N') { $class = ' class="aktCT"'; } else { $class = ''; } if ($recCt['FLAG_OK'] == 'J') { if ($recCt['DUTY_FLAG_SUCCESS'] == 'N') { $img = 'OK'; } else { $img = 'OK'; } } else { $img = ''; } if (nvl($recCt['FINISH_DATE'],"") == "") { $ctFinishDate = ""; } else { $ctFinishDate = date('d.m.Y H:i',strtotime($recCt['FINISH_DATE'])); if ($ctFinishDate == date('d.m.Y H:i',strtotime(date('d.m.Y',strtotime($recCt['FINISH_DATE']))))) { $ctFinishDate = date('d.m.Y',strtotime($recCt['FINISH_DATE'])); } } echo ''.''.''.''.''.''; if ($class != '' && $aktion == 'E') { // abbruch, wenn die Aufgabe, die erledigt werden soll erreicht wurde. Die Aufgaben danach brauchen nicht angezeigt werden break 1; } } echo '
'.trim(htmlentities(_CT_ERLEDIGT)).''.trim(htmlentities(_CT_CATA_NAME)).''.trim(htmlentities(_CT_DUTY_NAME)).''.trim(htmlentities(_CT_FINISH_DATE)).''.trim(htmlentities(_CT_NAME)).''.trim(htmlentities(_CT_CAST_NAME)).''.trim(htmlentities(_CT_INFO)).'
'.$img.''.trim(($recCt['CATA_NAME'])).''.trim(($recCt['DUTY_NAME'])).''.$ctFinishDate.''.trim(($recCt['NAME'])).''.trim(($recCt['CAST_NAME'])).''.trim(($recCt['INFO'])); if (($class != '' || $hresIsHipo == 'J') && $aktion == 'E') { // abbruch, wenn die Aufgabe, die erledigt werden soll erreicht wurde. Die Aufgaben danach brauchen nicht angezeigt werden echo ''; } echo '
'; if ($class != '' && $hresIsHipo == 'N' && $recCt['HRES_OID'] != '') { //Erledigungsart und Erledigunsbutton anzeigen echo ''; echo ''; echo ''; //echo ' '; echo ''; echo ''; echo '
'.trim(htmlentities(_ERLEDIGUNGSART)).'
'.trim(htmlentities(_KOMMENTAR)).'
'.trim(htmlentities(_DATEIEN)).'
'; } elseif ($hresIsHipo == 'J' && $aktion == 'E') { echo '

'; echo ' '; echo '

'; } // wenn alle Aufgaben erledigt, dann Case erledigen anzeigen if ($allCataErledigt == 'J' && $aktion == 'E' && $recCa['FLAG_OK'] == 'N') { echo ''; echo ''; echo ''; echo ''; echo '
'.trim(htmlentities(_ERLEDIGUNGSART)).'
'; } } echo '
'; echo '
'; } } else { echo '

'.trim(htmlentities(_KEINE_DATEN_VORHANDEN)).$errorHint.'

'; } if ($aktion == 'E') { echo ''; } if ($editNavigation != '') { echo ''; }; ?>