/** * 根据工号获取员工剩余年假天数 * @param unknown $number * @return number */ public function getVacationQty($number) { $result = array('qty' => 0, 'qty_used' => 0, 'in_year_qty' => 0); $res = $this->fetchAll("number = '" . $number . "'", "in_year_qty desc"); if ($res->count() > 0) { $data = $res->toArray(); $result['qty_used'] = $data[0]['qty_used']; $result['qty'] = $data[0]['qty']; $result['in_year_qty'] = $data[0]['in_year_qty']; $employee = new Hra_Model_Employee(); $user_id = $employee->getUserIdByNumber($number); $vacation = new Hra_Model_Attendance_Vacation(); // 员工剩余可使用年假天数需要扣除已提交但未发布的请假申请 $vRes = $vacation->fetchAll("apply_user = "******" and type = 2 and state != 3 and state != 1"); if ($vRes->count() > 0) { $vData = $vRes->toArray(); foreach ($vData as $v) { $result['qty_used'] += $v['qty']; } } $result['qty'] -= $result['qty_used']; } /* echo '<pre>'; print_r($result); exit; */ return $result; }