public function auto05Action()
{
$translate = Zend_Registry::get('Zend_Translate');
$this->view->title = 'Tinh lương hệ số 0.5 - ' . $translate->_('TEXT_DEFAULT_TITLE');
$this->view->headTitle($this->view->title);
$layoutPath = APPLICATION_PATH . '/templates/' . TEMPLATE_USED;
$option = array('layout' => '1_column/layout', 'layoutPath' => $layoutPath);
Zend_Layout::startMvc($option);
$auth = Zend_Auth::getInstance();
$identity = $auth->getIdentity();
$my_id = $identity->em_id;
$date = new Zend_Date();
$thang = $this->_getParam('thang', $date->toString('M'));
$nam = $this->_getParam('nam', $date->toString('Y'));
$emModel = new Front_Model_Employees();
$phongbanModel = new Front_Model_Phongban();
$chucvuModel = new Front_Model_Chucvu();
$hesocbModel = new Front_Model_HeSo();
$hesoModel = new Front_Model_EmployeesHeso();
$phucapModel = new Front_Model_EmployeesPhuCap();
$bangluongModel = new Front_Model_BangLuong();
$lastHeSoLuong = $hesocbModel->fetchOneData(array('hs_ngay_bat_dau' => date("{$nam}-{$thang}-1")), 'hs_ngay_bat_dau DESC');
$he_so_tang_them = 0.5;
$pb_selected = $this->_getParam('phongban', 0);
$phong_ban_id = $list_phongban_selected = $phong_ban = array();
$phong_ban_id[] = $pb_selected;
$list_phongban_selected = $phongbanModel->fetchDataStatus($pb_selected, $phong_ban);
$list_chuc_vu = $chucvuModel->fetchAll();
$list_nhan_vien = $phong_ban_options = array();
$list_phong_ban_option = $phongbanModel->fetchData(0, $phong_ban_options);
if (sizeof($list_phongban_selected)) {
foreach ($list_phongban_selected as $phong_ban_info) {
$phong_ban_id[] = $phong_ban_info->pb_id;
}
}
$phong_ban_id = implode(',', $phong_ban_id);
if ($pb_selected) {
$list_nhan_vien = $emModel->fetchAll("em_phong_ban in ({$phong_ban_id}) and em_status=1");
}
if ($this->_request->isPost()) {
$item = $this->getRequest()->getPost('cid');
foreach ($item as $k => $v) {
$bang_luong = $bangluongModel->fetchByDate($v, "{$nam}-{$thang}-01 00:00:00", "{$nam}-{$thang}-31 23:59:59");
if (!$bang_luong) {
$em_he_so = $hesoModel->getCurrentHeSo($thang, $nam, $v);
$em_phu_cap = $phucapModel->getCurrentHeSo($thang, $nam, $v);
$luong_toi_thieu = $lastHeSoLuong->hs_luong_co_ban;
//luong co ban
$giai_doan = $em_he_so->eh_giai_doan;
//0: chinh thuc, 1: thu viec
$loai_luong = $em_he_so->eh_loai_luong;
//0: bien che, 1: hop dong
$he_so_luong = $em_he_so->eh_he_so;
$luong_thu_viec = 0;
if ($giai_doan) {
$luong_thu_viec = $lastHeSoLuong->hs_he_so_luong_thuc_tap;
//so phan tram so voi luong chinh
$he_so_luong = number_format($em_he_so->eh_he_so * (100 - $luong_thu_viec) / 100, 2);
}
$bhxh = $lastHeSoLuong->hs_bhxh > 0 ? $lastHeSoLuong->hs_bhxh : 0;
//bao hiem xa hoi
$bhyt = $lastHeSoLuong->hs_bhyt > 0 ? $lastHeSoLuong->hs_bhyt : 0;
//bao hiem y te
$hs_pc_chuc_vu = $em_phu_cap->eh_pc_cong_viec;
//he so pc chuc vu
$hs_pc_trach_nhiem = $em_phu_cap->eh_pc_trach_nhiem;
//he so pc trach nhiem
$hs_pc_khu_vuc = $em_phu_cap->eh_pc_kv;
//he so pc khu vuc
$hs_pc_tnvk_phan_tram = $em_phu_cap->eh_pc_tnvk_phan_tram;
//he so pc tnvk
$time_tham_niem = strtotime($em_phu_cap->eh_tham_niem);
//tinh tham nien tu ngay
$hs_pc_tham_nien_phan_tram = $em_phu_cap->eh_pc_tham_nien;
$uu_dai_nghe = $em_phu_cap->eh_pc_udn_phan_tram;
//he so pc uu dai nghe
$cong_vu = $em_phu_cap->eh_pc_cong_vu_phan_tram;
//he so pc cong vu
$thu_hut = $em_phu_cap->eh_pc_thu_hut;
//he so pc thu hut
$kiem_nhiem = $em_phu_cap->eh_pc_kiem_nhiem;
//he so pc kiem nhiem
$hs_pc_khac = $em_phu_cap->eh_pc_khac;
//he so pc khac
$hs_pc_khac_type = $em_phu_cap->eh_pc_khac_type;
//0: he so, 1: phan tram
if (!$giai_doan && !$loai_luong) {
$hs_pc_tnvk = ($he_so_luong + $hs_pc_chuc_vu) * $hs_pc_tnvk_phan_tram / 100;
} else {
$hs_pc_tnvk = $hs_pc_chuc_vu * $hs_pc_tnvk_phan_tram / 100;
}
if (!$giai_doan) {
$hs_pc_tham_nien = ($he_so_luong + $hs_pc_chuc_vu + $hs_pc_tnvk) * $hs_pc_tham_nien_phan_tram / 100;
} else {
$hs_pc_tham_nien = ($hs_pc_chuc_vu + $hs_pc_tnvk) * $hs_pc_tham_nien_phan_tram / 100;
}
$hs_pc_uu_dai_nghe = ($he_so_luong + $hs_pc_chuc_vu + $hs_pc_tnvk) * $uu_dai_nghe / 100;
$hs_pc_cong_vu = ($he_so_luong + $hs_pc_chuc_vu + $hs_pc_tnvk) * $cong_vu / 100;
$hs_pc_thu_hut = ($he_so_luong + $hs_pc_chuc_vu + $hs_pc_tnvk) * $thu_hut / 100;
if (!$giai_doan && !$loai_luong) {
$hs_pc_kiem_nhiem = ($he_so_luong + $hs_pc_chuc_vu + $hs_pc_tnvk) * $kiem_nhiem / 100;
} else {
$hs_pc_kiem_nhiem = ($hs_pc_chuc_vu + $hs_pc_tnvk) * $kiem_nhiem / 100;
}
$hs_pc_khac_he_so = $hs_pc_khac;
if ($hs_pc_khac_type) {
$hs_pc_khac_he_so = $hs_pc_khac / 100;
}
$current_time = new Zend_Db_Expr('NOW()');
$data = array('bl_em_id' => $v, 'bl_ptccb_id' => $my_id, 'bl_luong_toi_thieu' => $luong_toi_thieu, 'bl_luong_thu_viec' => $luong_thu_viec, 'bl_giai_doan' => $giai_doan, 'bl_loai_luong' => $loai_luong, 'bl_bhxh' => $bhxh, 'bl_bhyt' => $bhyt, 'bl_tham_nien' => $hs_pc_tham_nien_phan_tram, 'bl_time_tham_nien' => date('Y-m-d', $time_tham_niem), 'bl_pc_kiem_nhiem' => $kiem_nhiem, 'bl_pc_tang_them' => $he_so_tang_them, 'bl_hs_luong' => $he_so_luong, 'bl_hs_pc_cong_viec' => $hs_pc_chuc_vu, 'bl_hs_pc_trach_nhiem' => $hs_pc_trach_nhiem, 'bl_hs_pc_khu_vuc' => $hs_pc_khu_vuc, 'bl_hs_pc_tnvk' => $hs_pc_tnvk_phan_tram, 'bl_hs_pc_udn' => $uu_dai_nghe, 'bl_hs_pc_cong_vu' => $cong_vu, 'bl_pc_thu_hut' => $thu_hut, 'bl_hs_pc_khac' => $hs_pc_khac, 'bl_pc_khac_type' => $hs_pc_khac_type, 'bl_date_modified' => $current_time, 'bl_date_added' => $current_time, 'bl_date' => "{$nam}-{$thang}-1");
$bangluongModel->insert($data);
}
}
}
$this->view->list_nhan_vien = $list_nhan_vien;
$this->view->thang = $thang;
$this->view->nam = $nam;
$this->view->pb_id = $pb_selected;
$this->view->list_phong_ban_option = $list_phong_ban_option;
$this->view->list_chuc_vu = $list_chuc_vu;
}
