/**
* 根据工号获取员工剩余年假天数
* @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;
}
