要计算用户生病,然后根据服务年限给出限制,将其从表格中取出


To Count users sick, then take that away form given limits based on years of service

我对PHP很陌生,对CakePHP更陌生,这就是我的代码编写的目的,但我认为我的问题出在我的一些标准PHP代码上。

好的,现在这段代码大部分都可以工作,但是当我选择的用户同时花费超过一天时,它似乎给了我一个错误的结果!

好的,所以它要做的是为所选用户获取服务年限,它可以正常工作(我认为,至少没有问题)。然后,根据服务年限,我设置了病假权利,全天,然后是半天。

一旦我这样做了,代码应该让选定的用户生病,并取下他们用权利拿走的东西,第一个完整,然后当它是空的时,把它从一半拿走。但就像我说的,当用户连续休息超过一天时,它仍然只休息一天?

这可能是我开始我的foreach循环并进行计数的地方,不确定这是否正确?

请帮忙??

 function sickDay($id = null) {
    if($this->CURRENT_USER['User']['role_id'] > 3) { //directors and admins
    /*if(empty($this->data) || !isset($this->data['Holiday']['id'])) {
    } else {*/
        //Caculate if it's a full pay, half pay or nothing
        //$data = $this->data['Holiday'];
        //Get Holidaytypes
        $types = $this->Holiday->find(
            'all',
            array(
                'conditions' => array(
                    'Holiday.holidaystype_id' => 3,
                    'Holiday.user_id' => $id
                )
            )
        );
        //Get starting date
        $contracts = $this->Holiday->User->Contract->find(
            'all',
            array(
                'conditions' => array(
                    'Contract.user_id' => $id //$data['user_id']
                ),
                'order' => array(
                    'Contract.startson' => 'ASC'
                )
            )
        );
        //Get How Many sick days
        foreach ($types as $key => $value) {
            $typesDataEnds =  strftime ("%u-%d-%Y", $types[$key]['Holiday']['endson']);
            $typesDataStarts = strftime ("%u-%d-%Y", $types[$key]['Holiday']['startson']);
            $SickTotal = count($typesDataEnds - $typesDataStarts);  
            //echo $SickTotal;
        //Get Contract Start & End Dates
        $start = array_shift($contracts);
        $end = array_pop($contracts);
        $endDate = $end['Contract']['endson'];
        $startDate = $start['Contract']['startson'];
        if (empty($endDate)) {
                $endDate = time('now');
        }
        if (!empty($startDate)) {
            $SortEnd = strftime("%Y", $endDate);
            $SortStart = strftime("%Y", $startDate);
            $YearsService = $SortEnd - $SortStart;
            if ($YearsService <= 1) {
                    $SetFullEntitlement = 5;
                    $SetHalfEntitlement = 5;
                    //echo 'one year';
            } elseif ($YearsService <= 2) {
                    $SetFullEntitlement = 10;
                    $SetHalfEntitlement = 10;
                    //echo 'two years';
            } elseif ($YearsService <= 5) {
                    $SetFullEntitlement = 20;
                    $SetHalfEntitlement = 20;
                    //echo 'up to five years';
            } elseif ($YearsService >= 6) {
                    $SetFullEntitlement = 30;
                    $SetHalfEntitlement = 30;
                    //echo 'five years or more';
            } else {
                    $SetFullEntitlement = 0;
                    $SetHalfEntitlement = 0;
                    //echo 'no sick pay';
            }
        } else {
            $YearsService = 0;
            //echo 'Sorry No Start Date For You Found!';
        }
        while ($SickTotal > 0) {
            if ($SetFullEntitlement != 0) {
                $SetFullEntitlement--;
            } elseif ($SetHalfEntitlement != 0) {
                $SetHalfEntitlement--;
            }
            $SickTotal--;
        }
        echo 'FullPay:';
        echo $SetFullEntitlement;
        echo '<br/><br/>Halfpay:';
        echo $SetHalfEntitlement;
        }
        //debug($SickTotal);
        die();  
        //$this->render('/artists/holidayslist');
    //} //End For if empty check
 } // End for if CURRENT_USER
} //End of Function

更新

我明白你说的话,是的,我现在知道 %u 用于我需要它做的事情是错误的。现在我已经完成了你说的,但我为选定的用户返回了 0,我知道应该有两个?

foreach ($types as $key => $value) {
    $typesDataEnds =  strtotime($types[$key]['Holiday']['endson']);
    $typesDataStarts = strtotime($types[$key]['Holiday']['startson']);
    //$typesDataEnds =  strftime ("%Y-%m-%d", $types[$key]['Holiday']['endson']);
    //$typesDataStarts = strftime ("%Y-%m-%d", $types[$key]['Holiday']['startson']);
    $sickTotal = floor(($typesDataEnds - $typesDataStarts) / 86400);
    echo 'testing: ';
    debug($sickTotal);
    die();
 does more.....
 } //end

我做错了什么吗?

非常感谢您的帮助

格伦。

我在计算病假的行中看到三个问题:

  1. 您在计算之前设置了日期的格式(格式错误,请参阅文档以了解%u的含义)。计算需要数值。如果日期的格式可按strtotime解析,这应该有效:

    $end = strtotime($types[$key]['Holiday']['endson']);
    $start = strrotime($types[$key]['Holiday']['startson']);
    
  2. 然后你尝试减去两个字符串。那行不通。但是如果你使用strtotime它确实有效,因为这样你就是在对整数进行操作:

    $sickTotal = floor(($end - $start) / 86400);
    // 86400 seconds in a day
    
  3. 不要对结果使用count。这是针对数组和对象的,当你将任何其他东西传递给它时,它会返回1(这解释了你看到的错误结果;你传递了一个字符串)。

我已经为计算构建了一个工作演示。