public function viewCheckBangLuong($em_id, $thang, $nam) { if ($em_id) { $bangluongModel = new Front_Model_BangLuong(); $bang_luong = $bangluongModel->fetchByDate($em_id, "{$nam}-{$thang}-01 00:00:00", "{$nam}-{$thang}-31 23:59:59"); if ($bang_luong) { return true; } return false; } return false; }
public function auto02Action() { $translate = Zend_Registry::get('Zend_Translate'); $this->view->title = 'Tính lương hệ số 0.2 - ' . $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"); if ($bang_luong && $bang_luong->bl_tong_he_so > 0) { $luong_toi_thieu = $bang_luong->bl_luong_toi_thieu; //luong co ban $tong_hs_luong_pc = $bang_luong->bl_tong_he_so; $tam_chi_dau_vao = $tong_hs_luong_pc * $luong_toi_thieu * 0.5; $data = array('bl_ptccb_id' => $my_id, 'bl_tam_chi_dau_vao_02' => $tam_chi_dau_vao, 'bl_02' => 1); $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 downAction() { $translate = Zend_Registry::get('Zend_Translate'); $this->view->title = 'In lương - ' . $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); $date = time(); $thang = $this->_getParam('thang', date('m', $date)); $nam = $this->_getParam('nam', date('Y', $date)); $auth = Zend_Auth::getInstance(); $identity = $auth->getIdentity(); $em_id = $identity->em_id; $emModel = new Front_Model_Employees(); $em_info = $emModel->fetchRow("em_id={$em_id}"); $khenthuongModel = new Front_Model_KhenThuong(); $khen_thuong = $khenthuongModel->fetchByDate($em_id, "{$nam}-{$thang}-01 00:00:00", "{$nam}-{$thang}-31 23:59:59"); $kyluatModel = new Front_Model_KyLuat(); $ky_luat = $kyluatModel->fetchByDate($em_id, "{$nam}-{$thang}-01 00:00:00", "{$nam}-{$thang}-31 23:59:59"); $bangluongModel = new Front_Model_BangLuong(); $bang_luong = $bangluongModel->fetchByDate($em_id, "{$nam}-{$thang}-01 00:00:00", "{$nam}-{$thang}-31 23:59:59"); if (!$em_info || !$bang_luong) { $this->_helper->viewRenderer->setRender('loi'); } else { $luong_toi_thieu = $bang_luong->bl_luong_toi_thieu; $giai_doan = $bang_luong->bl_giai_doan; $loai_luong = $bang_luong->bl_loai_luong; $luong_thu_viec = $bang_luong->bl_luong_thu_viec; $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; $tham_nien = $bang_luong->bl_tham_nien; $uu_dai_nghe = $bang_luong->bl_hs_pc_udn; $cong_vu = $bang_luong->bl_hs_pc_cong_vu; $kiem_nhiem = $bang_luong->bl_pc_kiem_nhiem; $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; $phan_loai = strtoupper($bang_luong->bl_phan_loai); $phan_loai_he_so = $bang_luong->bl_phan_loai_he_so; $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; $thanh_tien_hsl = $luong_toi_thieu_sau_bh * $he_so_luong * $phan_loai_he_so; //if ($this->he_so->eh_giai_doan) //$hs_pc_chuc_vu = number_format ($this->he_so->eh_pc_cong_viec*(100-$luong_thu_viec)/100, 2); $thanh_tien_pc_chuc_vu = $hs_pc_chuc_vu * $pc_chuc_vu * $phan_loai_he_so; //if ($this->he_so->eh_giai_doan) //$hs_pc_trach_nhiem = number_format ($this->he_so->eh_pc_trach_nhiem*(100-$luong_thu_viec)/100, 2); $thanh_tien_pc_trach_nhiem = $hs_pc_trach_nhiem * $pc_trach_nhiem * $phan_loai_he_so; //if ($this->he_so->eh_giai_doan) //$hs_pc_khu_vuc = number_format ($this->he_so->eh_pc_kv*(100-$luong_thu_viec)/100, 2); $thanh_tien_pc_khu_vuc = $hs_pc_khu_vuc * $pc_khu_vuc * $phan_loai_he_so; $hs_pc_tnvk = ($he_so_luong + $hs_pc_chuc_vu) * $hs_pc_tnvk_phan_tram / 100; //if ($this->he_so->eh_giai_doan) //$hs_pc_tnvk = number_format ($hs_pc_tnvk*(100-$luong_thu_viec)/100, 2); $thanh_tien_pc_tham_nien_vuot_khung = $hs_pc_tnvk * $pc_tnvk * $phan_loai_he_so; $hs_pc_tham_nien = floor(($he_so_luong + $hs_pc_chuc_vu + $hs_pc_trach_nhiem) * $tham_nien / 100 * 100) / 100; $thanh_tien_pc_tham_nien = $hs_pc_tham_nien * $pc_tham_nien * $phan_loai_he_so; $hs_pc_thu_hut = floor(($he_so_luong + $hs_pc_chuc_vu + $hs_pc_tnvk) * $hs_pc_thu_hut_phan_tram / 100 * 100) / 100; $thanh_tien_pc_thu_hut = $hs_pc_thu_hut * $pc_thu_hut * $phan_loai_he_so; $hs_pc_uu_dai_nghe = floor(($he_so_luong + $hs_pc_chuc_vu + $hs_pc_tnvk) * $uu_dai_nghe / 100 * 100) / 100; $thanh_tien_pc_uu_dai_nghe = $hs_pc_uu_dai_nghe * $pc_uu_dai_nghe * $phan_loai_he_so; $hs_pc_cong_vu = floor(($he_so_luong + $hs_pc_chuc_vu + $hs_pc_tnvk) * $cong_vu / 100 * 100) / 100; $thanh_tien_pc_cong_vu = $hs_pc_cong_vu * $pc_cong_vu * $phan_loai_he_so; $hs_pc_kiem_nhiem = floor(($he_so_luong + $hs_pc_chuc_vu + $hs_pc_tnvk) * $kiem_nhiem / 100 * 100) / 100; $thanh_tien_pc_kiem_nhiem = $hs_pc_kiem_nhiem * $pc_kiem_nhiem * $phan_loai_he_so; $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; } $thanh_tien_pc_khac = $thanh_tien_pc_khac * $phan_loai_he_so; $tong_1 = (int) ($thanh_tien_pc_thu_hut + $thanh_tien_hsl + $thanh_tien_pc_chuc_vu + $thanh_tien_pc_trach_nhiem + $thanh_tien_pc_khu_vuc + $thanh_tien_pc_tham_nien_vuot_khung + $thanh_tien_pc_tham_nien + $thanh_tien_pc_uu_dai_nghe + $thanh_tien_pc_cong_vu + $thanh_tien_pc_kiem_nhiem); $hs_tang_them = $hs_pc_thu_hut + $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_cong_vu + $hs_pc_kiem_nhiem + $hs_pc_khac_he_so; $ti_le_tang_them = ($hs_tang_them - $hs_pc_kiem_nhiem) * $luong_toi_thieu * $he_so_tang_them * $phan_loai_he_so; $tong_2 = (int) $tong_1 + $ti_le_tang_them; $tong_khen_thuong = 0; if (sizeof($khen_thuong)) { foreach ($khen_thuong as $kt) { $tong_khen_thuong += $kt->kt_money; } } $tong_khien_trach = 0; if (sizeof($ky_luat)) { foreach ($ky_luat as $kl) { $tong_khien_trach += $kl->kl_money; } } $tong_cong = $tong_2 + $tong_khen_thuong - $tong_khien_trach; //$mpdf = new mPDF(); $khen_thuong_text_out = ' <tr> <td colspan="3" class="tieu-de">Khen thưởng</td> </tr> <tr> <td colspan="3"> <br/> <table border="1" width="100%" class="noi-dung" cellpadding="5" nobr="true"> <tr> <td style="width: 36pt;"><strong>#</strong></td> <td><strong>Ngày</strong></td> <td style="width: 235pt;"><strong>Lý do</strong></td> <td style="width: 100pt;"><strong>Mức thưởng</strong></td> </tr>'; if (sizeof($khen_thuong)) { $i = 0; foreach ($khen_thuong as $kt) { $i++; $khen_thuong_text_out .= '<tr> <td>' . $i . '</td> <td>' . date('d-m-Y', strtotime($kt->kt_date)) . '</td> <td>' . $kt->kt_ly_do . '</td> <td>' . number_format($kt->kt_money, 0, '.', ',') . '</td> </tr>'; } } else { $khen_thuong_text_out .= '<tr><td colspan="4">Không có khen thưởng nào!</td></tr>'; } $khen_thuong_text_out .= ' <tr> <td colspan="3"><strong>Tổng cộng (III)</strong></td> <td><strong>' . number_format($tong_khen_thuong, 0, '.', ',') . '</strong></td> </tr> </table> </td> </tr>'; $ky_luat_text_out = ' <tr> <td colspan="3" class="tieu-de">Kỷ luật/Khiển trách</td> </tr> <tr> <td colspan="3"> <br/> <table border="1" width="100%" class="noi-dung" cellpadding="5" nobr="true"> <tr> <td style="width: 36pt;"><strong>#</strong></td> <td><strong>Ngày</strong></td> <td style="width: 235pt;"><strong>Lý do</strong></td> <td style="width: 100pt;"><strong>Mức phạt</strong></td> </tr>'; if (sizeof($ky_luat)) { $i = 0; foreach ($ky_luat as $kl) { $i++; $ky_luat_text_out .= '<tr> <td>' . $i . '</td> <td>' . date('d-m-Y', strtotime($kl->kl_date)) . '</td> <td>' . $kl->kl_ly_do . '</td> <td>' . number_format($kl->kl_money, 0, '.', ',') . '</td> </tr>'; } } else { $ky_luat_text_out .= '<tr><td colspan="4">Không có kỷ luật/khiển trách nào nào!</td></tr>'; } $ky_luat_text_out .= ' <tr> <td colspan="3"><strong>Tổng cộng (IV)</strong></td> <td><strong>' . number_format($tong_khien_trach, 0, '.', ',') . '</strong></td> </tr> </table> </td> </tr>'; $text_outout = ' <style> .ten-co-quan { color: #000; font-size: 10pt; height: 50px; text-align:center; } .ten-bang-luong{ height: 30px; text-align:center; font-size: 10pt; } table.first { color: #003300; font-family: helvetica; font-size: 8pt; border-left: 3px solid red; border-right: 3px solid #FF00FF; border-top: 3px solid green; border-bottom: 3px solid blue; background-color: #ccffcc; } .borders { border: 1px solid #000; font-size: 10px; } .tieu-de{ height: 20px; font-size: 11px; } .noi-dung{ font-size: 10px; } td.second { border: 2px dashed green; } .lowercase { text-transform: lowercase; } .uppercase { text-transform: uppercase; } .capitalize { text-transform: capitalize; } </style> <table width="100%"> <tr> <td width="200" class="ten-co-quan uppercase"> TỔNG CỤC HẢI QUAN <div><strong>CỤC HẢI QUAN HÀ TĨNH</strong></div> </td> <td colspan="2"> </td> </tr> <tr> <td colspan="3" class="ten-bang-luong uppercase">BẢNG LƯƠNG THÁNG ' . $thang . '-' . $nam . '</td> </tr> <tr> <td colspan="3" class="tieu-de">Thông tin cá nhân</td> </tr> <tr> <td colspan="3"> <br/> <table border="1" class="noi-dung" cellpadding="5" nobr="true"> <tr> <td style="width: 120pt;"><strong>Họ tên</strong></td> <td style="width: 80pt;"><strong>Giới tính</strong></td> <td style="width: 100pt;"><strong>Ngày sinh</strong></td> <td style="width: 100pt;"><strong>Phòng ban</strong></td> <td style="width: 96pt;"><strong>Chức vụ</strong></td> </tr> <tr> <td>' . $em_info->em_ho . ' ' . $em_info->em_ten . '</td> <td>' . ($em_info->em_gioi_tinh ? 'Nam' : 'Nữ') . '</td> <td>' . date('d-m-Y', strtotime($em_info->em_ngay_sinh)) . '</td> <td>' . $this->view->viewGetPhongBanName($em_info->em_phong_ban) . '</td> <td>' . $this->view->viewGetChucVuName($em_info->em_chuc_vu) . '</td> </tr> </table> </td> </tr> <tr> <td colspan="3" class="tieu-de"></td> </tr> <tr> <td colspan="3" class="tieu-de">Thông số lương cơ bản</td> </tr> <tr> <td colspan="3"> <br /> <table border="1" width="575pt" class="noi-dung" cellpadding="5" nobr="true"> <tr> <td><strong>Lương cơ bản</strong></td> ' . ($giai_doan ? '<td><strong>Thử việc</strong></td> ' : '') . ' <td style="width: 70pt;"><strong>BHXH</strong></td> <td style="width: 70pt;"><strong>BHYT</strong></td> <td style="width: 210pt;"><strong>Đã trừ BHXH+BHYT</strong></td> </tr> <tr> <td>' . number_format($luong_toi_thieu, 0, '.', ',') . '</td> ' . ($giai_doan ? '<td>' . $luong_thu_viec . '%</td> ' : '') . ' <td>' . $bhxh . '%</td> <td>' . $bhyt . '%</td> <td> Đã trừ BHYT + BHXH: ' . number_format($luong_toi_thieu_sau_bh, 0, '.', ',') . ' <br> Đã trừ BHYT: ' . number_format($luong_toi_thieu_bhyt, 0, '.', ',') . ' </td> </tr> </table> </td> </tr> <tr> <td colspan="3" class="tieu-de"></td> </tr> <tr> <td colspan="3" class="tieu-de">Bảng lương</td> </tr> <tr> <td colspan="3"> <br/> <table border="1" width="100%" class="noi-dung" cellpadding="5" nobr="true"> <tr> <td style="width: 150pt;"><strong>Tên</strong></td> <td style="width: 245pt;" colspan="2"><strong>Hệ số</strong></td> <td style="width: 100pt;"><strong>Thành tiền</strong></td> </tr> <tr> <td>Kết quả phân loại tháng</td> <td> ' . $phan_loai . ' </td> <td> ' . $phan_loai_he_so . '</td> <td></td> </tr> <tr> <td>Hệ số lương</td> <td colspan="2">' . $he_so_luong . '</td> <td>' . number_format($thanh_tien_hsl, 0, '.', ',') . '</td> </tr> <tr> <td>PC chức vụ</td> <td colspan="2">' . $hs_pc_chuc_vu . '</td> <td>' . number_format($thanh_tien_pc_cong_viec, 0, '.', ',') . '</td> </tr> <tr> <td>PC trách nhiệm</td> <td colspan="2">' . $hs_pc_trach_nhiem . '</td> <td>' . number_format($thanh_tien_pc_trach_nhiem, 0, '.', ',') . '</td> </tr> <tr> <td>PC khu vực</td> <td colspan="2">' . $hs_pc_khu_vuc . '</td> <td>' . number_format($thanh_tien_pc_khu_vuc, 0, '.', ',') . '</td> </tr> <tr> <td>PC thu hút</td> <td>' . $hs_pc_thu_hut_phan_tram . '%</td> <td>' . $hs_pc_thu_hut . '</td> <td>' . number_format($thanh_tien_pc_thu_hut, 0, '.', ',') . '</td> </tr> <tr> <td>PC thâm niên vượt khung</td> <td>' . $hs_pc_tnvk_phan_tram . '%</td> <td>' . $hs_pc_tnvk . '</td> <td>' . number_format($thanh_tien_pc_tham_nien_vuot_khung, 0, '.', ',') . '</td> </tr> <tr> <td>PC thâm niên</td> <td>' . $tham_nien . ' Năm</td> <td>' . $hs_pc_tham_nien . '</td> <td>' . number_format($thanh_tien_pc_tham_nien, 0, '.', ',') . '</td> </tr> <tr> <td>PC ưu đãi nghề</td> <td>' . $uu_dai_nghe . '%</td> <td>' . $hs_pc_uu_dai_nghe . '</td> <td>' . number_format($thanh_tien_pc_uu_dai_nghe, 0, '.', ',') . '</td> </tr> <tr> <td>PC công vụ</td> <td>' . $cong_vu . '%</td> <td>' . $hs_pc_cong_vu . '</td> <td>' . number_format($thanh_tien_pc_cong_vu, 0, '.', ',') . '</td> </tr> <tr> <td>PC kiêm nhiệm</td> <td colspan="2">' . $hs_pc_kiem_nhiem . '</td> <td>' . number_format($thanh_tien_pc_kiem_nhiem, 0, '.', ',') . '</td> </tr> <tr> <td>PC khác</td> <td colspan="2">' . $hs_pc_khac . ($hs_pc_khac_type ? '%' : '') . '</td> <td>' . number_format($thanh_tien_pc_khac, 0, '.', ',') . '</td> </tr> <tr> <td colspan="3">Tổng cộng (I)</td> <td>' . number_format($tong_1, 0, '.', ',') . '</td> </tr> <tr> <td>Tỷ lệ tăng thêm</td> <td colspan="2">' . $hs_tang_them . '</td> <td>' . number_format($ti_le_tang_them, 0, '.', ',') . '</td> </tr> <tr> <td colspan="3"><strong>Tổng cộng (II)</strong></td> <td><strong>' . number_format($tong_2, 0, '.', ',') . '</strong></td> </tr> </table> </td> </tr> <tr> <td colspan="3" class="tieu-de"></td> </tr> ' . $khen_thuong_text_out . ' <tr> <td colspan="3" class="tieu-de"></td> </tr> ' . $ky_luat_text_out . ' <tr> <td colspan="3" class="tieu-de"></td> </tr> <tr> <td colspan="3"> <br/> <table border="1" width="100%" class="noi-dung" cellpadding="5" nobr="true"> <tr> <td style="width: 395pt;"><strong>Tổng được nhận = II + III + IV</strong></td> <td style="width: 100pt;"><strong>' . number_format($tong_cong, 0, '.', ',') . '</strong></td> </tr> </table> </td> </tr> </table> '; /* $mpdf->WriteHTML($text_outout); $file_name = $this->loc_tieng_viet($em_info->em_ho) . '_' . $this->loc_tieng_viet($em_info->em_ten) . '_' . $thang . '-' . $nam . '.pdf'; $mpdf->Output($file_name, 'D'); */ $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor(PDF_AUTHOR); $pdf->SetTitle(PDF_HEADER_TITLE); $pdf->SetSubject(PDF_HEADER_TITLE); $pdf->SetKeywords('bang luong'); $pdf->setPrintHeader(false); $pdf->setFooterData(array(0, 64, 0), array(0, 64, 128)); $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); $pdf->SetHeaderMargin(PDF_MARGIN_HEADER); $pdf->SetFooterMargin(PDF_MARGIN_FOOTER); $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); $pdf->setFontSubsetting(true); $pdf->SetFont('dejavusans', '', 14, '', true); $pdf->AddPage(); $pdf->setTextShadow(array('enabled' => true, 'depth_w' => 0.2, 'depth_h' => 0.2, 'color' => array(196, 196, 196), 'opacity' => 1, 'blend_mode' => 'Normal')); $file_name = $this->loc_tieng_viet($em_info->em_ho) . '_' . $this->loc_tieng_viet($em_info->em_ten) . '_' . $thang . '-' . $nam . '.pdf'; $pdf->writeHTMLCell(0, 0, '', '', $text_outout, 0, 1, 0, true, '', true); // --------------------------------------------------------- // Close and output PDF document // This method has several options, check the source code documentation for more information. $pdf->Output($file_name, 'I'); die; } }
public function jqupdatestatusAction() { $this->_helper->layout()->disableLayout(); $process_status = 0; $new_status = ''; if ($this->_request->isPost()) { $em_id = $this->_arrParam['em_id']; $dg_thang = (int) $this->_arrParam['d_thang']; $dg_nam = (int) $this->_arrParam['dg_nam']; $c_status = strtoupper(trim($this->_arrParam['dg_status'])); $danhgiaModel = new Front_Model_DanhGia(); $find_row = $danhgiaModel->fetchRow("dg_em_id={$em_id} and dg_thang={$dg_thang} and dg_nam={$dg_nam}"); if ($find_row) { $dg_id = $find_row->dg_id; $data_update = array('dg_ptccb_status' => $c_status); if ($c_status == '') { $data_update['dg_don_vi_status'] = $c_status; } $process_status = $danhgiaModel->update($data_update, "dg_id={$dg_id}"); if ($process_status) { $new_status = $c_status; if ($new_status == 'O') { $new_status = '-'; } $bangluongModel = new Front_Model_BangLuong(); $bang_luong = $bangluongModel->fetchByDate($em_id, "{$dg_nam}-{$dg_thang}-01 00:00:00", "{$dg_nam}-{$dg_thang}-31 23:59:59"); $thongbao_model = new Front_Model_ThongBao(); $current_time = new Zend_Db_Expr('NOW()'); if ($c_status == '') { $em_info = $this->view->viewGetEmployeeInfo($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 ' . $dg_thang . '-' . $dg_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'] = $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 ' . $dg_thang . '-' . $dg_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($em_id, 3005); foreach ($don_vi_user as $user) { $data['tb_to'] = $user->em_id; $thongbao_model->insert($data); } } } } } $this->view->new_status = $new_status; $this->view->process_status = $process_status; }