Esempio n. 1
0
 private function calc_EndDatefromPrevious($Node)
 {
     $SQL = "SELECT * FROM ta_activity_activity WHERE idtm_activity = '" . $Node->idtm_activity . "'";
     $Result = ActivityActivityRecord::finder()->findAllBySQL($SQL);
     $myDate = new DateTime("now");
     $FEZ = $myDate->format("Y-m-d");
     if (count(ActivityActivityRecord::finder()->findAllBySQL($SQL)) > 0) {
         foreach ($Result as $Record) {
             $ActRecord = $this->return_ActivityByPK($Record->pre_idtm_activity);
             if ($ActRecord != 0) {
                 $this->calc_StartDatenEndDate($ActRecord);
                 //this is the code where me make the recursive walk!
                 $compDate = new DateTime($ActRecord->ttact_enddate);
                 $fcompDate = $compDate->format("Y-m-d");
                 if ($FEZ <= $fcompDate) {
                     $tempDate = new DateTime($ActRecord->ttact_enddate);
                     $FEZ = $tempDate->format("Y-m-d");
                     //print_r($FEZ);
                 }
             }
         }
     }
     return $FEZ;
 }
Esempio n. 2
0
 public function get_PSPChildren($Node)
 {
     $SQL = "SELECT * FROM ta_activity_activity WHERE pre_idtm_activity = '" . $Node->idtm_activity . "'";
     $Result = count(ActivityActivityRecord::finder()->findAllBySQL($SQL));
     $SSQL = "SELECT * FROM tm_activity WHERE ";
     $counter = 0;
     if ($Result >= 1) {
         foreach (ActivityActivityRecord::finder()->findAllBySQL($SQL) as $Results) {
             $counter == 0 ? $SSQL .= "idtm_activity = '" . $Results->idtm_activity . "'" : ($SSQL .= " OR idtm_activity = '" . $Results->idtm_activity . "'");
             $counter++;
         }
     } else {
         $SSQL .= "idtm_activity = '0'";
     }
     return ActivityRecord::finder()->findAllBySQL($SSQL);
 }
Esempio n. 3
0
 private function return_RelTypeParents($Node, $CurrentID)
 {
     $temp = array();
     $SQL = "SELECT * FROM ta_activity_activity WHERE pre_idtm_activity = " . $Node->idtm_activity . " AND idtm_activity =" . $CurrentID;
     $result = ActivityActivityRecord::finder()->findBySQL($SQL);
     if (count(ActivityActivityRecord::finder()->findAllBySQL($SQL)) == 1) {
         $temp['RELTYPE'] = $result->actact_type;
         $temp['MINZ'] = $result->actact_minz;
         $temp['MAXZ'] = $result->actact_maxz;
         $temp['PREID'] = $CurrentID;
     } else {
         $temp['RELTYPE'] = 0;
         $temp['MINZ'] = 0;
         $temp['MAXZ'] = 0;
         $temp['PREID'] = 0;
     }
     return $temp;
 }
Esempio n. 4
0
 public function addActivityActivity()
 {
     $myRecord = new ActivityActivityRecord();
     $myRecord->idtm_activity = $this->edidtm_activity->Text;
     $myRecord->pre_idtm_activity = $this->ttedidtm_activity->Text;
     $myRecord->actact_minz = $this->edactact_minz->Text;
     $myRecord->actact_maxz = $this->edactact_maxz->Text;
     $myRecord->actact_type = $this->edactact_type->Text;
     $myRecord->save();
     $this->edActivityActivitybindList($this->edidtm_activity->Text);
 }