public function viewGetHuyenName($id = 0)
 {
     if ($id) {
         $huyenModel = new Front_Model_Huyen();
         $huyen = $huyenModel->fetchRow('huyen_id=' . $id . ' and huyen_status=1');
         if ($huyen) {
             return $huyen->huyen_name;
         }
         return '';
     }
     return '';
 }
 public function gethuyenAction()
 {
     $this->_helper->layout()->disableLayout();
     $tinhID = $this->_getParam('tid', 0);
     $huyenModel = new Front_Model_Huyen();
     $list_huyen = $huyenModel->fetchData(array('huyen_parent' => $tinhID, 'huyen_status' > 1));
     $this->view->list_huyen = $list_huyen;
 }
 function hdeleteitemsAction()
 {
     $this->_helper->layout()->disableLayout();
     $huyenModel = new Front_Model_Huyen();
     $tinh_id = $this->_getParam('parent', 0);
     if ($this->_request->isPost()) {
         $item = $this->getRequest()->getPost('cid');
         foreach ($item as $k => $v) {
             $huyenModel->delete('huyen_id=' . $v);
         }
     }
     $this->_redirect('hethong/tinh/huyen/parent/' . $tinh_id . '/page/' . $this->_page);
 }
 public function indexAction()
 {
     $translate = Zend_Registry::get('Zend_Translate');
     $this->view->title = 'Quản lý tài khoản - ' . $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);
     $employeesModel = new Front_Model_Employees();
     $employeesEditModel = new Front_Model_EmployeesEdit();
     $auth = Zend_Auth::getInstance();
     $identity = $auth->getIdentity();
     $success_message = '';
     $id = $identity->em_id;
     $employee_info = $employeesModel->fetchRow('em_id=' . $id);
     if (!$employee_info) {
         $error_message[] = 'Không tìm thấy thông tin.';
     }
     $tinhModel = new Front_Model_Tinh();
     $list_tinh = $tinhModel->fetchData(array('tinh_status' => 1));
     $huyenModel = new Front_Model_Huyen();
     $list_huyen = $huyenModel->fetchData(array('huyen_status' => 1));
     $dantocModel = new Front_Model_Dantoc();
     $list_dan_toc = $dantocModel->fetchData(array('dt_status' => 1));
     $hochamModel = new Front_Model_Hocham();
     $list_hoc_ham = $hochamModel->fetchData(array('hh_status' => 1));
     $bangcapModel = new Front_Model_Bangcap();
     $list_bang_cap = $bangcapModel->fetchData(array('bc_status' => 1));
     $chungchiModel = new Front_Model_Chungchi();
     $list_chung_chi = $chungchiModel->fetchData(array('cc_status' => 1));
     $chucvudoanModel = new Front_Model_ChucVuDoan();
     $list_chuc_vu_doan = $chucvudoanModel->fetchData(array('cvdoan_status' => 1));
     $chucvudangModel = new Front_Model_ChucVuDang();
     $list_chuc_vu_dang = $chucvudangModel->fetchData(array('cvdang_status' => 1));
     $chucvucongdoanModel = new Front_Model_ChucVuCongDoan();
     $list_chuc_vu_cong_doan = $chucvucongdoanModel->fetchData(array('cvcdoan_status' => 1));
     $lyluanModel = new Front_Model_LyLuanChinhTri();
     $list_ly_luan_chinh_tri = $lyluanModel->fetchData(array('llct_status' => 1));
     $quanlynnModel = new Front_Model_QuanLyNhaNuoc();
     $list_quan_ly_nn = $quanlynnModel->fetchData(array('qlnn_status' => 1));
     $error_message = array();
     $min = 10;
     $max = 20 * 1024 * 1024;
     //20MB
     $dir = '/avatars';
     //thu muc uploads
     $dir_upload = UPLOAD_PATH . $dir;
     //duong dan
     $upload = new Zend_File_Transfer_Adapter_Http();
     $upload->setDestination($dir_upload);
     $upload->addValidator('Count', false, array('min' => 1, 'max' => 1))->addValidator('Size', false, array('min' => $min, 'max' => $max))->addValidator('Extension', false, 'jpg,png,gif,jpeg');
     $files = $upload->getFileInfo();
     if ($this->_request->isPost()) {
         $data = array('em_id' => $id);
         if ($upload->isValid()) {
             foreach ($files as $file => $info) {
                 if ($info['name'] != '') {
                     $validator = new Zend_Validate_File_Exists($dir_upload);
                     if ($validator->isValid($info['name'])) {
                         $file_name = $upload->getFileName($info['name']);
                         preg_match("/\\.([^\\.]+)\$/", $file_name, $matches);
                         $file_ext = $matches[1];
                         $file_name = time() . '.' . $file_ext;
                         $arrFileName[$file] = $file_name;
                         $upload->addFilter('Rename', $dir_upload . '/' . $file_name);
                     } else {
                         $arrFileName[$file] = $info['name'];
                     }
                     $upload->receive($file);
                 }
             }
             $data['eme_anh_the'] = $arrFileName['em_anh_the'];
         }
         $em_ho = trim($this->_arrParam['em_ho']);
         $em_ten = trim($this->_arrParam['em_ten']);
         $em_ten_khac = $this->_arrParam['em_ten_khac'];
         $em_so_chung_minh_thu = trim($this->_arrParam['em_so_chung_minh_thu']);
         $em_gioi_tinh = $this->_arrParam['em_gioi_tinh'];
         $ngay_sinh = $this->_arrParam['ngay_sinh'];
         $em_home_phone = $this->_arrParam['em_home_phone'];
         $em_phone = $this->_arrParam['em_phone'];
         $em_noi_sinh = trim($this->_arrParam['em_noi_sinh']);
         $em_que_quan = trim($this->_arrParam['em_que_quan']);
         $em_dia_chi = $this->_arrParam['em_dia_chi'];
         $em_dia_chi_tinh = $this->_arrParam['em_dia_chi_tinh'];
         $em_dia_chi_huyen = $this->_arrParam['em_dia_chi_huyen'];
         $em_dan_toc = $this->_arrParam['em_dan_toc'];
         $em_chuc_vu_dang = $this->_arrParam['em_chuc_vu_dang'];
         $ngay_dang = $this->_arrParam['ngay_dang'];
         $em_chuc_vu_doan = $this->_arrParam['em_chuc_vu_doan'];
         $ngay_doan = $this->_arrParam['ngay_doan'];
         $em_chuc_vu_cong_doan = $this->_arrParam['em_chuc_vu_cong_doan'];
         $em_van_hoa_pt = trim($this->_arrParam['em_van_hoa_pt']);
         $em_hoc_ham = $this->_arrParam['em_hoc_ham'];
         $em_bang_cap = $this->_arrParam['em_bang_cap'];
         $em_ngoai_ngu = $this->_arrParam['em_ngoai_ngu'];
         $em_tin_hoc = $this->_arrParam['em_tin_hoc'];
         $em_chung_chi_khac = $this->_arrParam['em_chung_chi_khac'];
         $em_bang_scan_upload = $this->_arrParam['anh_bang_cap'];
         $em_tai_lieu_khac = $this->_arrParam['anh_tai_lieu_khac'];
         /* Moi them */
         $em_ton_giao = trim($this->_arrParam['em_ton_giao']);
         $em_noi_sinh_huyen = trim($this->_arrParam['em_noi_sinh_huyen']);
         $em_noi_sinh_tinh = trim($this->_arrParam['em_noi_sinh_tinh']);
         $em_que_quan_huyen = trim($this->_arrParam['em_que_quan_huyen']);
         $em_que_quan_tinh = trim($this->_arrParam['em_que_quan_tinh']);
         $em_noi_o = trim($this->_arrParam['em_noi_o']);
         $em_noi_o_huyen = $this->_arrParam['em_noi_o_huyen'];
         $em_noi_o_tinh = $this->_arrParam['em_noi_o_tinh'];
         $em_ngay_nhap_ngu = trim($this->_arrParam['em_ngay_nhap_ngu']);
         $em_ngay_xuat_ngu = trim($this->_arrParam['em_ngay_xuat_ngu']);
         $em_cmt_ngay_cap = trim($this->_arrParam['em_cmt_ngay_cap']);
         $em_quan_ham = trim($this->_arrParam['em_quan_ham']);
         $em_danh_hieu = trim($this->_arrParam['em_danh_hieu']);
         $em_so_bhxh = trim($this->_arrParam['em_so_bhxh']);
         $em_tinh_trang_suc_khoe = trim($this->_arrParam['em_tinh_trang_suc_khoe']);
         $em_chieu_cao = trim($this->_arrParam['em_chieu_cao']);
         $em_can_nang = trim($this->_arrParam['em_can_nang']);
         $em_nhom_mau = trim($this->_arrParam['em_nhom_mau']);
         $em_thuong_binh = trim($this->_arrParam['em_thuong_binh']);
         $em_gia_dinh_chinh_sach = trim($this->_arrParam['em_gia_dinh_chinh_sach']);
         $em_lich_su_dao_tao = $this->_arrParam['em_lich_su_dao_tao'];
         $em_qua_trinh_cong_tac = $this->_arrParam['em_qua_trinh_cong_tac'];
         $em_gia_dinh_ban_than = $this->_arrParam['em_gia_dinh_ban_than'];
         $em_gia_dinh_vo = $this->_arrParam['em_gia_dinh_vo'];
         $em_qua_trinh_luong = $this->_arrParam['em_qua_trinh_luong'];
         $em_bi_bat = trim($this->_arrParam['em_bi_bat']);
         $em_tham_gia_to_chuc = trim($this->_arrParam['em_tham_gia_to_chuc']);
         $em_than_nhan_nuoc_ngoai = trim($this->_arrParam['em_than_nhan_nuoc_ngoai']);
         $em_ly_luan_chinh_tri = trim($this->_arrParam['em_ly_luan_chinh_tri']);
         $em_quan_ly_nha_nuoc = trim($this->_arrParam['em_quan_ly_nha_nuoc']);
         $validator_length = new Zend_Validate_StringLength(array('min' => 2, 'max' => 255));
         //kiem tra dữ liệu
         if (!$validator_length->isValid($em_ho)) {
             $error_message[] = 'Họ không được bỏ trống và phải lớn hơn hoặc bằng 2 ký tự.';
         }
         if (!$validator_length->isValid($em_ten)) {
             $error_message[] = 'Họ không được bỏ trống và phải lớn hơn hoặc bằng 2 ký tự.';
         }
         if (!sizeof($error_message)) {
             $current_time = new Zend_Db_Expr('NOW()');
             if ($ngay_sinh != '') {
                 $ngay_sinh = str_replace('/', '-', $ngay_sinh);
                 $ngay_sinh = date('Y-m-d', strtotime($ngay_sinh));
             }
             if ($ngay_dang != '') {
                 $ngay_dang = str_replace('/', '-', $ngay_dang);
                 $ngay_dang = date('Y-m-d', strtotime($ngay_dang));
             }
             if ($ngay_doan != '') {
                 $ngay_doan = str_replace('/', '-', $ngay_doan);
                 $ngay_doan = date('Y-m-d', strtotime($ngay_doan));
             }
             if ($em_ngay_nhap_ngu != '') {
                 $em_ngay_nhap_ngu = str_replace('/', '-', $em_ngay_nhap_ngu);
                 $em_ngay_nhap_ngu = date('Y-m-d', strtotime($em_ngay_nhap_ngu));
             }
             if ($em_ngay_xuat_ngu != '') {
                 $em_ngay_xuat_ngu = str_replace('/', '-', $em_ngay_xuat_ngu);
                 $em_ngay_xuat_ngu = date('Y-m-d', strtotime($em_ngay_xuat_ngu));
             }
             if ($em_cmt_ngay_cap != '') {
                 $em_cmt_ngay_cap = str_replace('/', '-', $em_cmt_ngay_cap);
                 $em_cmt_ngay_cap = date('Y-m-d', strtotime($em_cmt_ngay_cap));
             }
             $data['eme_ho'] = $em_ho;
             $data['eme_ten'] = $em_ten;
             $data['eme_ten_khac'] = $em_ten_khac;
             $data['eme_so_chung_minh_thu'] = $em_so_chung_minh_thu;
             $data['eme_cmt_ngay_cap'] = $em_cmt_ngay_cap;
             $data['eme_gioi_tinh'] = $em_gioi_tinh;
             $data['eme_home_phone'] = $em_home_phone;
             $data['eme_phone'] = $em_phone;
             $data['eme_noi_sinh'] = $em_noi_sinh;
             $data['eme_que_quan'] = $em_que_quan;
             $data['eme_dia_chi'] = $em_dia_chi;
             $data['eme_dia_chi_tinh'] = $em_dia_chi_tinh;
             $data['eme_dia_chi_huyen'] = $em_dia_chi_huyen;
             $data['eme_dan_toc'] = $em_dan_toc;
             $data['eme_chuc_vu_dang'] = $em_chuc_vu_dang;
             $data['eme_chuc_vu_doan'] = $em_chuc_vu_doan;
             $data['eme_chuc_vu_cong_doan'] = $em_chuc_vu_cong_doan;
             $data['eme_van_hoa_pt'] = $em_van_hoa_pt;
             $data['eme_hoc_ham'] = $em_hoc_ham;
             $data['eme_bang_cap'] = $em_bang_cap;
             $data['eme_ngoai_ngu'] = $em_ngoai_ngu;
             $data['eme_tin_hoc'] = $em_tin_hoc;
             $data['eme_chung_chi_khac'] = $em_chung_chi_khac;
             $data['eme_anh_bang_cap'] = serialize($em_bang_scan_upload);
             $data['eme_tai_lieu_khac'] = serialize($em_tai_lieu_khac);
             $data['eme_ngay_sinh'] = $ngay_sinh;
             $data['eme_ngay_vao_dang'] = $ngay_dang;
             $data['eme_ngay_vao_doan'] = $ngay_doan;
             $data['eme_date_modified'] = $current_time;
             /* Moi them */
             $data['eme_ton_giao'] = $em_ton_giao;
             $data['eme_noi_sinh_huyen'] = $em_noi_sinh_huyen;
             $data['eme_noi_sinh_tinh'] = $em_noi_sinh_tinh;
             $data['eme_que_quan_huyen'] = $em_que_quan_huyen;
             $data['eme_que_quan_tinh'] = $em_que_quan_tinh;
             $data['eme_noi_o'] = $em_noi_o;
             $data['eme_noi_o_huyen'] = $em_noi_o_huyen;
             $data['eme_noi_o_tinh'] = $em_noi_o_tinh;
             $data['eme_ngay_nhap_ngu'] = $em_ngay_nhap_ngu;
             $data['eme_ngay_xuat_ngu'] = $em_ngay_xuat_ngu;
             $data['eme_quan_ham'] = $em_quan_ham;
             $data['eme_danh_hieu'] = $em_danh_hieu;
             $data['eme_so_bhxh'] = $em_so_bhxh;
             $data['eme_tinh_trang_suc_khoe'] = $em_tinh_trang_suc_khoe;
             $data['eme_chieu_cao'] = $em_chieu_cao;
             $data['eme_can_nang'] = $em_can_nang;
             $data['eme_nhom_mau'] = $em_nhom_mau;
             $data['eme_thuong_binh'] = $em_thuong_binh;
             $data['eme_gia_dinh_chinh_sach'] = $em_gia_dinh_chinh_sach;
             $data['eme_lich_su_dao_tao'] = serialize($em_lich_su_dao_tao);
             $data['eme_qua_trinh_cong_tac'] = serialize($em_qua_trinh_cong_tac);
             $data['eme_gia_dinh_ban_than'] = serialize($em_gia_dinh_ban_than);
             $data['eme_gia_dinh_vo'] = serialize($em_gia_dinh_vo);
             $data['eme_qua_trinh_luong'] = serialize($em_qua_trinh_luong);
             $data['eme_bi_bat'] = $em_bi_bat;
             $data['eme_tham_gia_to_chuc'] = $em_tham_gia_to_chuc;
             $data['eme_than_nhan_nuoc_ngoai'] = $em_than_nhan_nuoc_ngoai;
             $data['eme_ly_luan_chinh_tri'] = $em_ly_luan_chinh_tri;
             $data['eme_quan_ly_nha_nuoc'] = $em_quan_ly_nha_nuoc;
             $checkExit = $employeesEditModel->fetchRow('em_id=' . $id);
             if ($checkExit) {
                 $employeesEditModel->update($data, 'eme_id=' . $checkExit->eme_id);
             } else {
                 $data['eme_date_added'] = $current_time;
                 $employeesEditModel->insert($data);
             }
             $users = $this->_helper->GlobalHelpers->checkToChucUsers(4002);
             $thongbao_model = new Front_Model_ThongBao();
             $data = array();
             $data['tb_from'] = 0;
             $data['tb_tieu_de'] = '[Thông báo] Có yêu cầu cập nhật thông tin.';
             $data['tb_noi_dung'] = 'Cán bộ <strong>' . $em_ho . ' ' . $em_ten . '</strong> đã khai báo thông tin cá nhân mới.<br/> Bạn hãy <strong><a href="' . $this->view->baseUrl('tochuccanbo/capnhatthongtin') . '">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);
             }
             $success_message = 'Yêu cầu cập nhật thông tin thành công';
         }
     }
     $this->view->employee_info = $employee_info;
     $this->view->success_message = $success_message;
     $this->view->error_message = $error_message;
     $this->view->list_tinh = $list_tinh;
     $this->view->list_huyen = $list_huyen;
     $this->view->list_dan_toc = $list_dan_toc;
     $this->view->list_hoc_ham = $list_hoc_ham;
     $this->view->list_bang_cap = $list_bang_cap;
     $this->view->list_chung_chi = $list_chung_chi;
     $this->view->list_chuc_vu_doan = $list_chuc_vu_doan;
     $this->view->list_chuc_vu_dang = $list_chuc_vu_dang;
     $this->view->list_chuc_vu_cong_doan = $list_chuc_vu_cong_doan;
     $this->view->list_ly_luan_chinh_tri = $list_ly_luan_chinh_tri;
     $this->view->list_quan_ly_nha_nuoc = $list_quan_ly_nn;
 }