PHP w2p_Utilities_Date::calcDuration方法代码示例

function calcDuration($start_date, $start_hour, $start_minute, $end_date, $end_hour, $end_minute, $duration_type)
{
    $year = substr($start_date, 0, 4);
    $month = substr($start_date, 4, 2);
    $day = substr($start_date, 6, 2);
    $startDate = new w2p_Utilities_Date($year . '-' . $month . '-' . $day);
    $startDate->setTime($start_hour, $start_minute);
    $year = substr($end_date, 0, 4);
    $month = substr($end_date, 4, 2);
    $day = substr($end_date, 6, 2);
    $endDate = new w2p_Utilities_Date($year . '-' . $month . '-' . $day);
    $endDate->setTime($end_hour, $end_minute);
    $duration = $startDate->calcDuration($endDate);
    if (intval($duration_type) == 24) {
        $workHours = intval(w2PgetConfig('daily_working_hours'));
        $duration = $duration / $workHours;
    }
    $response = new xajaxResponse();
    $response->assign('task_duration', 'value', $duration);
    return $response;
}

 public function update_dep_dates($task_id)
 {
     $q = new w2p_Database_Query();
     $newTask = new CTask();
     $newTask->load($task_id);
     // Do not update tasks that are not tracking dependencies
     if (!in_array($newTask->task_dynamic, self::$tracking_dynamics)) {
         return;
     }
     // load original task dates and calculate task time span
     $tsd = new w2p_Utilities_Date($newTask->task_start_date);
     $ted = new w2p_Utilities_Date($newTask->task_end_date);
     $duration = $tsd->calcDuration($ted);
     // reset start date
     $nsd = new w2p_Utilities_Date($newTask->get_deps_max_end_date($newTask));
     // prefer Wed 8:00 over Tue 16:00 as start date
     $nsd = $nsd->next_working_day();
     $new_start_date = $nsd->format(FMT_DATETIME_MYSQL);
     // Add task time span to End Date again
     $ned = new w2p_Utilities_Date();
     $ned->copy($nsd);
     $ned->addDuration($duration, '1');
     // make sure one didn't land on a non-working day
     $ned = $ned->next_working_day(true);
     // prefer tue 16:00 over wed 8:00 as an end date
     $ned = $ned->prev_working_day();
     $new_end_date = $ned->format(FMT_DATETIME_MYSQL);
     // update the db
     $q->addTable('tasks');
     $q->addUpdate('task_start_date', $new_start_date);
     $q->addUpdate('task_end_date', $new_end_date);
     $q->addUpdate('task_updated', "'" . $q->dbfnNowWithTZ() . "'", false, true);
     $q->addWhere('task_dynamic <> 1 AND task_id = ' . (int) $task_id);
     $q->exec();
     $q->clear();
     if ($newTask->task_parent != $newTask->task_id) {
         $newTask->updateDynamics();
     }
     return;
 }

//.........这里部分代码省略.........
         } elseif ($tmp[0] != '') {
             $hperc_assign_ar[$tmp[0]] = 100;
         }
     }
     // let's check if there are some assigned departments to task
     $task->task_departments = implode(',', $this->getParam('dept_ids', self::TYPE_ARRAY));
     // convert dates to SQL format first
     if ($task->task_start_date) {
         $date = new w2p_Utilities_Date($task->task_start_date);
         $task->task_start_date = $date->format(FMT_DATETIME_MYSQL);
     }
     $end_date = null;
     if ($task->task_end_date) {
         if (strpos($task->task_end_date, '2400') !== false) {
             $task->task_end_date = str_replace('2400', '2359', $task->task_end_date);
         }
         $end_date = new w2p_Utilities_Date($task->task_end_date);
         $task->task_end_date = $end_date->format(FMT_DATETIME_MYSQL);
     }
     $error_array = $task->store($AppUI);
     // Return all the validation messages
     if ($error_array !== true) {
         $error_message = '';
         foreach ($error_array as $error) {
             $error_message .= $error . '. ';
         }
         throw new Frapi_Error('SAVE_ERROR', $error_message);
     }
     $task_parent = $this->getParam('task_parent') ? $this->getParam('task_parent', SELF::TYPE_INT) : 0;
     $old_task_parent = $this->getParam('old_task_parent') ? $this->getParam('old_task_parent', SELF::TYPE_INT) : 0;
     if ($task_parent != $old_task_parent) {
         $oldTask = new CTask();
         $oldTask->load($old_task_parent);
         $oldTask->updateDynamics(false);
     }
     // How to handle custom fields? Do we support it in api?
     // Now add any task reminders
     // If there wasn't a task, but there is one now, and
     // that task date is set, we need to set a reminder.
     if (empty($task_end_date) || !empty($end_date) && $task_end_date->dateDiff($end_date)) {
         $task->addReminder();
     }
     if (isset($hassign)) {
         $task->updateAssigned($hassign, $hperc_assign_ar);
     }
     if (isset($hdependencies)) {
         // && !empty($hdependencies)) {
         // there are dependencies set!
         // backup initial start and end dates
         $tsd = new w2p_Utilities_Date($task->task_start_date);
         $ted = new w2p_Utilities_Date($task->task_end_date);
         // updating the table recording the
         // dependency relations with this task
         $task->updateDependencies($hdependencies, $task_parent);
         // we will reset the task's start date based upon dependencies
         // and shift the end date appropriately
         if ($adjustStartDate && !is_null($hdependencies)) {
             // load already stored task data for this task
             $tempTask = new CTask();
             $tempTask->load($task->task_id);
             // shift new start date to the last dependency end date
             $nsd = new w2p_Utilities_Date($tempTask->get_deps_max_end_date($tempTask));
             // prefer Wed 8:00 over Tue 16:00 as start date
             $nsd = $nsd->next_working_day();
             // prepare the creation of the end date
             $ned = new w2p_Utilities_Date();
             $ned->copy($nsd);
             if (empty($task->task_start_date)) {
                 // appropriately calculated end date via start+duration
                 $ned->addDuration($task->task_duration, $task->task_duration_type);
             } else {
                 // calc task time span start - end
                 $d = $tsd->calcDuration($ted);
                 // Re-add (keep) task time span for end date.
                 // This is independent from $obj->task_duration.
                 // The value returned by Date::Duration() is always in hours ('1')
                 $ned->addDuration($d, '1');
             }
             // prefer tue 16:00 over wed 8:00 as an end date
             $ned = $ned->prev_working_day();
             $task->task_start_date = $nsd->format(FMT_DATETIME_MYSQL);
             $task->task_end_date = $ned->format(FMT_DATETIME_MYSQL);
             $q = new w2p_Database_Query();
             $q->addTable('tasks', 't');
             $q->addUpdate('task_start_date', $task->task_start_date);
             $q->addUpdate('task_end_date', $task->task_end_date);
             $q->addWhere('task_id = ' . (int) $task->task_id);
             $q->addWhere('task_dynamic <> 1');
             $q->exec();
             $q->clear();
         }
         $task->pushDependencies($task->task_id, $task->task_end_date);
     }
     //$task = (array)$task;
     $task->load($task_id);
     unset($task->_query, $task->_error, $task->_tbl_prefix, $task->_tbl, $task->_tbl_key, $task->_tbl_module);
     $this->data['task'] = $task;
     $this->data['success'] = true;
     return $this->toArray();
 }

 if (isset($hassign)) {
     $obj->updateAssigned($hassign, $hperc_assign_ar);
 }
 // This call has to be here to make sure that old dependencies are
 // cleared on save, even if there's no new dependencies
 $obj->updateDependencies($hdependencies, $obj->task_id);
 if (isset($hdependencies) && '' != $hdependencies) {
     // there are dependencies set!
     $nsd = new w2p_Utilities_Date($obj->get_deps_max_end_date($obj));
     if (isset($start_date)) {
         $shift = $nsd->compare($start_date, $nsd);
         if ($shift < 1) {
             //$obj->task_start_date = $nsd->format(FMT_DATETIME_MYSQL);
             $osd = new w2p_Utilities_Date($obj->task_start_date);
             $ned = new w2p_Utilities_Date($obj->task_end_date);
             $dur = -$ned->calcDuration($osd);
             $ned->copy($nsd);
             $ned->addDuration($dur, 1);
             $new_start_date = $nsd->format(FMT_DATETIME_MYSQL);
             $obj->task_start_date = $AppUI->formatTZAwareTime($new_start_date, '%Y-%m-%d %T');
             $new_end_date = $ned->format(FMT_DATETIME_MYSQL);
             $obj->task_end_date = $AppUI->formatTZAwareTime($new_end_date, '%Y-%m-%d %T');
             $obj->store();
         }
     }
 }
 $obj->updateDynamics();
 $billingCategory = w2PgetSysVal('BudgetCategory');
 $budgets = array();
 foreach ($billingCategory as $id => $category) {
     $budgets[$id] = w2PgetParam($_POST, 'budget_' . $id, 0);

 /**
  * This function is run immediately after a Task is stored. It uses that Task's
  *    end date and checks for dependent tasks beginning before that date.
  * If there are any dependencies that match those criteria, it updates those
  *    and recurses.
  * If not, it returns.
  *
  * @param type $task_id
  * @param type $lastEndDate
  */
 public function pushDependencies($task_id, $lastEndDate)
 {
     $task_end_int = strtotime($lastEndDate);
     $dependent_tasks = $this->getDependentTaskList($task_id);
     foreach ($dependent_tasks as $_task_id => $_task_data) {
         $task_start_int = strtotime($_task_data['task_start_date']);
         if ($task_start_int >= $task_end_int) {
             /**
              * Remember, this continue just means 'skip this iteration and
              *   go to the next one.' In this case, we're skipping the
              *   iteration because either the dependent task's start date is
              *   already at or after the end date we have.
              */
             continue;
         }
         $nsd = new w2p_Utilities_Date($lastEndDate);
         $osd = new w2p_Utilities_Date($_task_data['task_start_date']);
         $ned = new w2p_Utilities_Date($_task_data['task_end_date']);
         $dur = -$ned->calcDuration($osd);
         $ned->copy($nsd);
         $ned->addDuration($dur, 1);
         $new_start_date = $nsd->format(FMT_DATETIME_MYSQL);
         $new_end_date = $ned->format(FMT_DATETIME_MYSQL);
         $q = $this->_getQuery();
         $q->addTable('tasks');
         $q->addUpdate('task_start_date', $new_start_date);
         $q->addUpdate('task_end_date', $new_end_date);
         $q->addUpdate('task_updated', "'" . $q->dbfnNowWithTZ() . "'", false, true);
         $q->addWhere('task_dynamic > 1 AND task_id = ' . (int) $_task_id);
         $q->exec();
         $this->pushDependencies($_task_id, $new_end_date);
     }
 }

 /**
  * Tests calcDuration with negative change across non-working days
  */
 public function testCalcDurationAcrossNonWorkingDaysNegative()
 {
     $date = new w2p_Utilities_Date('2010-09-06 10:00:00');
     $this->assertEquals(-3, $date->calcDuration(new w2p_Utilities_Date('2010-09-03 15:00:00')));
 }

 // load already stored task data for this task
 $tempTask = new CTask();
 $tempTask->load($obj->task_id);
 // shift new start date to the last dependency end date
 $nsd = new w2p_Utilities_Date($tempTask->get_deps_max_end_date($tempTask));
 // prefer Wed 8:00 over Tue 16:00 as start date
 $nsd = $nsd->next_working_day();
 // prepare the creation of the end date
 $ned = new w2p_Utilities_Date();
 $ned->copy($nsd);
 if (empty($obj->task_start_date)) {
     // appropriately calculated end date via start+duration
     $ned->addDuration($obj->task_duration, $obj->task_duration_type);
 } else {
     // calc task time span start - end
     $d = $tsd->calcDuration($ted);
     // Re-add (keep) task time span for end date.
     // This is independent from $obj->task_duration.
     // The value returned by Date::Duration() is always in hours ('1')
     $ned->addDuration($d, '1');
 }
 // prefer tue 16:00 over wed 8:00 as an end date
 $ned = $ned->prev_working_day();
 $obj->task_start_date = $nsd->format(FMT_DATETIME_MYSQL);
 $obj->task_end_date = $ned->format(FMT_DATETIME_MYSQL);
 $q = new w2p_Database_Query();
 $q->addTable('tasks', 't');
 $q->addUpdate('task_start_date', $obj->task_start_date);
 $q->addUpdate('task_end_date', $obj->task_end_date);
 $q->addWhere('task_id = ' . (int) $obj->task_id);
 $q->addWhere('task_dynamic <> 1');