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; }