public function loadCase($sAppUid, $iDelIndex = 0) { try { $oApp = new Application(); $aFields = $oApp->Load($sAppUid); //$aFields = $oApp->toArray(BasePeer::TYPE_FIELDNAME); $appData = @unserialize($aFields['APP_DATA']); // BUG 8134, FIX!// for single/double quote troubles // Unserialize with utf8 content get trouble if ($appData === false) { $appData = preg_replace('!s:(\\d+):"(.*?)";!e', "'s:'.strlen('\$2').':\"\$2\";'", $aFields['APP_DATA']); $appData = @unserialize($appData); } $aFields['APP_DATA'] = G::array_merges(G::getSystemConstants(), $appData); switch ($oApp->getAppStatus()) { case 'COMPLETED': $aFields['STATUS'] = G::LoadTranslation('ID_COMPLETED'); break; case 'CANCELLED': $aFields['STATUS'] = G::LoadTranslation('ID_CANCELLED'); break; case 'PAUSED': $aFields['STATUS'] = G::LoadTranslation('ID_PAUSED'); break; case 'DRAFT': $aFields['STATUS'] = G::LoadTranslation('ID_DRAFT'); break; case 'TO_DO': $aFields['STATUS'] = G::LoadTranslation('ID_TO_DO'); break; } $oUser = new Users(); try { $oUser->load($oApp->getAppInitUser()); $uFields = $oUser->toArray(BasePeer::TYPE_FIELDNAME); //$aFields['TITLE'] = $oApp->getAppTitle(); $aFields['TITLE'] = $aFields['APP_TITLE']; $aFields['DESCRIPTION'] = $aFields['APP_DESCRIPTION']; $aFields['CREATOR'] = $oUser->getUsrFirstname() . ' ' . $oUser->getUsrLastname(); $aFields['CREATE_DATE'] = $oApp->getAppCreateDate(); $aFields['UPDATE_DATE'] = $oApp->getAppUpdateDate(); } catch (Exception $oError) { $aFields['TITLE'] = $oApp->getAppTitle(); $aFields['DESCRIPTION'] = ''; $aFields['CREATOR'] = '(USER_DELETED)'; $aFields['CREATE_DATE'] = $oApp->getAppCreateDate(); $aFields['UPDATE_DATE'] = $oApp->getAppUpdateDate(); } if ($iDelIndex > 0) { //get the Delegation fields, $oAppDel = new AppDelegation(); $oAppDel->Load($sAppUid, $iDelIndex); $aAppDel = $oAppDel->toArray(BasePeer::TYPE_FIELDNAME); $aFields['TAS_UID'] = $aAppDel['TAS_UID']; $aFields['DEL_INDEX'] = $aAppDel['DEL_INDEX']; $aFields['DEL_PREVIOUS'] = $aAppDel['DEL_PREVIOUS']; $aFields['DEL_TYPE'] = $aAppDel['DEL_TYPE']; $aFields['DEL_PRIORITY'] = $aAppDel['DEL_PRIORITY']; $aFields['DEL_THREAD_STATUS'] = $aAppDel['DEL_THREAD_STATUS']; $aFields['DEL_THREAD'] = $aAppDel['DEL_THREAD']; $aFields['DEL_DELEGATE_DATE'] = $aAppDel['DEL_DELEGATE_DATE']; $aFields['DEL_INIT_DATE'] = $aAppDel['DEL_INIT_DATE']; $aFields['DEL_TASK_DUE_DATE'] = $aAppDel['DEL_TASK_DUE_DATE']; $aFields['DEL_FINISH_DATE'] = $aAppDel['DEL_FINISH_DATE']; $aFields['CURRENT_USER_UID'] = $aAppDel['USR_UID']; try { $oCurUser = new Users(); $oCurUser->load($aAppDel['USR_UID']); $aFields['CURRENT_USER'] = $oCurUser->getUsrFirstname() . ' ' . $oCurUser->getUsrLastname(); } catch (Exception $oError) { $aFields['CURRENT_USER'] = ''; } } return $aFields; } catch (exception $e) { throw $e; } }
public function loadCase($sAppUid, $iDelIndex = 0, $jump = '') { try { $oApp = new Application; $aFields = $oApp->Load($sAppUid); $appData = self::unserializeData($aFields['APP_DATA']); $aFields['APP_DATA'] = G::array_merges(G::getSystemConstants(), $appData); switch ($oApp->getAppStatus()) { case 'COMPLETED': $aFields['STATUS'] = G::LoadTranslation('ID_COMPLETED'); break; case 'CANCELLED': $aFields['STATUS'] = G::LoadTranslation('ID_CANCELLED'); break; case 'PAUSED': $aFields['STATUS'] = G::LoadTranslation('ID_PAUSED'); break; case 'DRAFT': $aFields['STATUS'] = G::LoadTranslation('ID_DRAFT'); break; case 'TO_DO': $aFields['STATUS'] = G::LoadTranslation('ID_TO_DO'); break; } $oUser = new Users(); try { $oUser->load($oApp->getAppInitUser()); $uFields = $oUser->toArray(BasePeer::TYPE_FIELDNAME); //$aFields['TITLE'] = $oApp->getAppTitle(); $aFields['TITLE'] = $aFields['APP_TITLE']; $aFields['DESCRIPTION'] = $aFields['APP_DESCRIPTION']; $aFields['CREATOR'] = $oUser->getUsrFirstname() . ' ' . $oUser->getUsrLastname(); $aFields['CREATE_DATE'] = $oApp->getAppCreateDate(); $aFields['UPDATE_DATE'] = $oApp->getAppUpdateDate(); } catch (Exception $oError) { $aFields['TITLE'] = $oApp->getAppTitle(); $aFields['DESCRIPTION'] = ''; $aFields['CREATOR'] = '(USER_DELETED)'; $aFields['CREATE_DATE'] = $oApp->getAppCreateDate(); $aFields['UPDATE_DATE'] = $oApp->getAppUpdateDate(); } if ($iDelIndex > 0) { //get the Delegation fields, $oAppDel = new AppDelegation(); $oAppDel->Load($sAppUid, $iDelIndex); $aAppDel = $oAppDel->toArray(BasePeer::TYPE_FIELDNAME); $aFields['TAS_UID'] = $aAppDel['TAS_UID']; $aFields['DEL_INDEX'] = $aAppDel['DEL_INDEX']; $aFields['DEL_PREVIOUS'] = $aAppDel['DEL_PREVIOUS']; $aFields['DEL_TYPE'] = $aAppDel['DEL_TYPE']; $aFields['DEL_PRIORITY'] = $aAppDel['DEL_PRIORITY']; $aFields['DEL_THREAD_STATUS'] = $aAppDel['DEL_THREAD_STATUS']; $aFields['DEL_THREAD'] = $aAppDel['DEL_THREAD']; $aFields['DEL_DELEGATE_DATE'] = $aAppDel['DEL_DELEGATE_DATE']; $aFields['DEL_INIT_DATE'] = $aAppDel['DEL_INIT_DATE']; $aFields['DEL_TASK_DUE_DATE'] = $aAppDel['DEL_TASK_DUE_DATE']; $aFields['DEL_FINISH_DATE'] = $aAppDel['DEL_FINISH_DATE']; $aFields['CURRENT_USER_UID'] = $aAppDel['USR_UID']; try { //$oCurUser = new Users(); //$oCurUser->load($aAppDel['USR_UID']); //$aFields['CURRENT_USER'] = $oCurUser->getUsrFirstname() . ' ' . $oCurUser->getUsrLastname(); $oCurUser = new Users(); if ($jump != '') { $aCases = $oAppDel->LoadParallel($sAppUid); $aFields['TAS_UID'] = ''; $aFields['CURRENT_USER'] = array(); foreach ($aCases as $key => $value) { $oCurUser->load($value['USR_UID']); $aFields['CURRENT_USER'][]= $oCurUser->getUsrFirstname() . ' ' . $oCurUser->getUsrLastname(); $aFields['TAS_UID'].= $value['TAS_UID'].'-'; } $aFields['CURRENT_USER'] = implode(" - ", array_values($aFields['CURRENT_USER'])); $tasksArray = array_filter(explode("-",$aFields['TAS_UID'])); if(count($tasksArray) == 1) { $aFields['TAS_UID'] = $tasksArray[0]; } } else { $oCurUser->load($aAppDel['USR_UID']); $aFields['CURRENT_USER'] = $oCurUser->getUsrFirstname() . ' ' . $oCurUser->getUsrLastname(); } } catch (Exception $oError) { $aFields['CURRENT_USER'] = ''; } } return $aFields; } catch (exception $e) { throw ($e); } }
//update with $fields $newTitle = 'new title'; $Fields['APP_UID'] = $appUid; $Fields['APP_TITLE'] = $newTitle; $Fields['APP_PARENT'] = rand(1000, 5000); $Fields['APP_INIT_DATE'] = 'now'; try { $obj = new Application(); $res = $obj->update($Fields); //#25 $t->is($res, 1, "update() update 1 row"); $Fields = $obj->Load($appUid); //#26 $t->is($obj->getAppUid(), $appUid, "update() APP_UID = " . $appUid); //#27 $t->is($obj->getAppTitle(), $newTitle, "update() getAppTitle"); //#28 $t->is($Fields['APP_TITLE'], $newTitle, "update() APP_TITLE= " . $newTitle); //#29 $t->is($Fields['APP_INIT_DATE'], date('Y-m-d H:i:s'), "update() APP_INIT_DATE= " . date('Y-m-d H:i:s')); } catch (Exception $e) { //#14 // $t->isa_ok( $e, 'PropelException', 'update() return error ' . $e->getMessage() ); $t->isa_ok($e, 'Exception', 'update() return error ' . $e->getMessage()); } //remove with empty try { $obj = new Application(); $res = $obj->remove(NULL); } catch (Exception $e) { //#30