public function viewGetPhanLoai($em_id = 0, $thang = 0, $nam = 0) { if ($em_id) { $danhgiaModel = new Front_Model_DanhGia(); $danh_gia = $danhgiaModel->fetchRow("dg_em_id= {$em_id} and dg_thang={$thang} and dg_nam={$nam}"); if ($danh_gia) { return $danh_gia; } return false; } return false; }
public function jqaddstatusAction() { $this->_helper->layout()->disableLayout(); $process_status = 0; $new_status = ''; if ($this->_request->isPost()) { $em_id = $this->_arrParam['em_id']; $thang = $this->_arrParam['dg_thang']; $nam = $this->_arrParam['dg_nam']; $c_status = strtoupper(trim($this->_arrParam['dg_status'])); $danhgiaModel = new Front_Model_DanhGia(); $check_row = $danhgiaModel->fetchRow("dg_em_id={$em_id} and dg_thang={$thang} and dg_nam={$nam}"); if ($check_row) { $process_status = $danhgiaModel->update(array('dg_don_vi_status' => $c_status), "dg_id={$check_row->dg_id} and (dg_ptccb_status='' or dg_ptccb_status IS NULL)"); } else { if ($c_status) { $current_time = new Zend_Db_Expr('NOW()'); $process_status = $danhgiaModel->insert(array('dg_em_id' => $em_id, 'dg_thang' => $thang, 'dg_nam' => $nam, 'dg_cong_viec' => '', 'dg_ket_qua_cong_viec' => 0, 'dg_don_vi_status' => $c_status, 'dg_date_modifyed' => $current_time, 'dg_date_created' => $current_time)); } } if ($process_status) { $new_status = $c_status; $users = $this->_helper->GlobalHelpers->checkToChucUsers(4003); $current_time = new Zend_Db_Expr('NOW()'); $thongbao_model = new Front_Model_ThongBao(); $data = array(); $data['tb_from'] = 0; $data['tb_tieu_de'] = '[Thông báo] Duyệt đánh giá phân loại.'; $data['tb_noi_dung'] = 'Có đơn đánh giá phân phân loại theo tháng mới<br/> Bạn hãy <strong><a href="' . $this->view->baseUrl('tochuccanbo/duyetphanloai') . '">click vào đây</a></strong> để xét duyệt.'; $data['tb_status'] = 0; $data['tb_date_added'] = $current_time; $data['tb_date_modified'] = $current_time; foreach ($users as $user) { $data['tb_to'] = $user->em_id; $thongbao_model->insert($data); } } } if ($new_status == 'O') { $new_status = '-'; } $this->view->new_status = $new_status; $this->view->process_status = $process_status; }
public function auto03Action() { $translate = Zend_Registry::get('Zend_Translate'); $this->view->title = 'Tính lương hệ số 0.3 - ' . $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(); $date->subMonth(1); $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(); $bangluongModel = new Front_Model_BangLuong(); $danhgiaModel = new Front_Model_DanhGia(); $lastHeSoLuong = $hesocbModel->fetchOneData(array('hs_ngay_bat_dau' => date("{$nam}-{$thang}-1")), 'hs_ngay_bat_dau DESC'); $he_so_tang_them = 0.5; $he_so_phan_loai = array('O' => 0, 'A' => 1.2, 'B' => 1, 'C' => 0.8, 'D' => 0); $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"); $danh_gia = $danhgiaModel->fetchRow("dg_em_id= {$v} and dg_thang={$thang} and dg_nam={$nam}"); if ($bang_luong && $danh_gia && $danh_gia->dg_ptccb_status != '') { $luong_thu_viec = 0; $luong_toi_thieu = $bang_luong->bl_luong_toi_thieu; //luong co ban $giai_doan = $bang_luong->bl_giai_doan; //0: chinh thuc, 1: thu viec $loai_luong = $bang_luong->bl_loai_luong; //0: bien che, 1: hop dong $luong_thu_viec = $bang_luong->bl_luong_thu_viec; //so phan tram so voi luong chinh $he_so_luong = $bang_luong->bl_hs_luong; $bhxh = $bang_luong->bl_bhxh; $bhyt = $bang_luong->bl_bhyt; $hs_pc_chuc_vu = $bang_luong->bl_hs_pc_cong_viec; $hs_pc_trach_nhiem = $bang_luong->bl_hs_pc_trach_nhiem; $hs_pc_khu_vuc = $bang_luong->bl_hs_pc_khu_vuc; $hs_pc_tnvk_phan_tram = $bang_luong->bl_hs_pc_tnvk; $hs_pc_tham_nien_phan_tram = $bang_luong->bl_tham_nien; $uu_dai_nghe = $bang_luong->bl_hs_pc_udn; $cong_vu = $bang_luong->bl_hs_pc_cong_vu; $hs_pc_khac = $bang_luong->bl_hs_pc_khac; $he_so_tang_them = $bang_luong->bl_pc_tang_them; $hs_pc_khac_type = $bang_luong->bl_pc_khac_type; $hs_pc_thu_hut_phan_tram = $bang_luong->bl_pc_thu_hut; $tong_hs_luong_pc = $bang_luong->bl_tong_he_so; $tong_hs_luong_pc_ca_nhan = $bang_luong->bl_tong_he_so_ca_nhan; $tong_hs_luong_pc_plld = $bang_luong->bl_tong_he_so_plld; $tam_chi_dau_vao = $bang_luong->bl_tam_chi_dau_vao; $phan_loai = $danh_gia->dg_ptccb_status; $phan_loai_he_so = $he_so_phan_loai[$phan_loai]; $luong_toi_thieu_sau_bh = (int) ($luong_toi_thieu * (100 - ($bhxh + $bhyt)) / 100); $luong_toi_thieu_bhyt = (int) ($luong_toi_thieu * (100 - $bhyt) / 100); $pc_trach_nhiem = $pc_cong_vu = $pc_khac = $pc_kiem_nhiem = $pc_uu_dai_nghe = $luong_toi_thieu; $pc_chuc_vu = $pc_tnvk = $pc_thu_hut = $pc_tham_nien = $luong_toi_thieu_sau_bh; $pc_khu_vuc = $luong_toi_thieu_bhyt; 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_thu_hut = ($he_so_luong + $hs_pc_chuc_vu + $hs_pc_tnvk) * $hs_pc_thu_hut_phan_tram / 100; $hs_pc_uu_dai_nghe = ($he_so_luong + $hs_pc_chuc_vu + $hs_pc_tnvk) * $uu_dai_nghe / 100; $thanh_tien_pc_khac = $hs_pc_khac * $pc_khac; $hs_pc_khac_he_so = $hs_pc_khac; if ($hs_pc_khac_type) { $thanh_tien_pc_khac = $thanh_tien_pc_khac / 100; $hs_pc_khac_he_so = $hs_pc_khac / 100; } $tong_hs_luong_pc = $he_so_luong + $hs_pc_chuc_vu + $hs_pc_trach_nhiem + $hs_pc_khu_vuc + $hs_pc_tnvk + $hs_pc_tham_nien + $hs_pc_uu_dai_nghe + $hs_pc_khac_he_so + $hs_pc_thu_hut; $tong_hs_luong_pc_ca_nhan = $he_so_luong + $hs_pc_chuc_vu + $hs_pc_khu_vuc + $hs_pc_tnvk + $hs_pc_uu_dai_nghe; $tong_hs_luong_pc_plld = $tong_hs_luong_pc_ca_nhan * $phan_loai_he_so; $tam_chi_dau_vao = $tong_hs_luong_pc * $luong_toi_thieu * 0.5; $data = array('bl_ptccb_id' => $my_id, 'bl_phan_loai' => $phan_loai, 'bl_phan_loai_he_so' => $phan_loai_he_so, 'bl_tong_he_so' => $tong_hs_luong_pc, 'bl_tong_he_so_ca_nhan' => $tong_hs_luong_pc_ca_nhan, 'bl_tong_he_so_plld' => $tong_hs_luong_pc_plld, 'bl_tam_chi_dau_vao' => $tam_chi_dau_vao); $bl_id = $bang_luong->bl_id; $bangluongModel->update($data, "bl_id={$bl_id}"); } } } $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; }
public function updatestatusAction() { $this->_helper->layout()->disableLayout(); $process_status = 0; if ($this->_request->isPost()) { $thang = (int) $this->_request->getParam('thang', 0); $nam = (int) $this->_request->getParam('nam', 0); $phongban = (int) $this->_request->getParam('phongban', 0); $status = (int) $this->_request->getParam('status', 0); $danhgiaModel = new Front_Model_DanhGia(); $item = $this->getRequest()->getPost('cid'); foreach ($item as $k => $v) { $find_row = $danhgiaModel->fetchRow("dg_em_id={$v} and dg_thang={$thang} and dg_nam={$nam}"); if ($find_row) { if ($status) { $process_status = $danhgiaModel->update(array('dg_ptccb_status' => $find_row->dg_don_vi_status), "dg_id={$find_row->dg_id}"); } else { $process_status = $danhgiaModel->update(array('dg_ptccb_status' => '', 'dg_don_vi_status' => ''), "dg_id={$find_row->dg_id}"); } if ($process_status) { $thongbao_model = new Front_Model_ThongBao(); $current_time = new Zend_Db_Expr('NOW()'); if (!$status) { $em_info = $this->view->viewGetEmployeeInfo($find_row->dg_em_id); $data = array(); $data['tb_from'] = 0; $data['tb_tieu_de'] = '[Thông báo] Phòng tổ chức không duyệt đánh giá phân loại.'; $data['tb_noi_dung'] = 'Đánh giá phân phân loại theo tháng của bạn tháng ' . $thang . '-' . $nam . ' không được duyệt.<br/> Yêu cầu bạn hãy <strong><a href="' . $this->view->baseUrl('canhan/danhgiaphanloai') . '">click vào đây</a></strong> để xét chỉnh sửa.'; $data['tb_status'] = 0; $data['tb_date_added'] = $current_time; $data['tb_date_modified'] = $current_time; $data['tb_to'] = $find_row->dg_em_id; $thongbao_model->insert($data); $data['tb_noi_dung'] = 'Đánh giá phân loại của <strong>' . $em_info->em_ho . ' ' . $em_info->em_ten . '</strong> tháng ' . $thang . '-' . $nam . ' phòng tổ chức không duyệt.<br/> Bạn hãy <strong><a href="' . $this->view->baseUrl('donvi/duyetphanloai') . '">click vào đây</a></strong> để xét duyệt lại.'; $don_vi_user = $this->_helper->GlobalHelpers->checkDonViUsers($find_row->dg_em_id, 3005); foreach ($don_vi_user as $user) { $data['tb_to'] = $user->em_id; $thongbao_model->insert($data); } } } } } $this->_redirect('tochuccanbo/duyetphanloai/index/thang/' . $thang . '/nam/' . $nam . '/phongban/' . $phongban); } }