public function indexAction()
{
$translate = Zend_Registry::get('Zend_Translate');
$this->view->title = 'Thống kê thá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 = new Zend_Date();
$date->subMonth(1);
$thang = $this->_getParam('thang', $date->toString("M"));
$nam = $this->_getParam('nam', $date->toString("Y"));
$auth = Zend_Auth::getInstance();
$identity = $auth->getIdentity();
$em_id = $identity->em_id;
$holidaysModel = new Front_Model_Holidays();
$list_holidays = $holidaysModel->fetchData(array(), 'hld_order ASC');
$xinnghiphepModel = new Front_Model_XinNghiPhep();
$list_nghi_phep = $xinnghiphepModel->fetchByDate($em_id, "{$nam}-{$thang}-01 00:00:00", "{$nam}-{$thang}-31 23:59:59");
$chamcongModel = new Front_Model_ChamCong();
$cham_cong = $chamcongModel->fetchOneData(array('c_em_id' => $em_id, 'c_thang' => $thang, 'c_nam' => $nam));
$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");
$this->view->cham_cong = $cham_cong;
$this->view->thang = $thang;
$this->view->nam = $nam;
$this->view->list_holidays = $list_holidays;
$this->view->list_nghi_phep = $list_nghi_phep;
$this->view->khen_thuong = $khen_thuong;
$this->view->ky_luat = $ky_luat;
}
public function indexAction()
{
$translate = Zend_Registry::get('Zend_Translate');
$this->view->title = 'Chấm cô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 = new Zend_Date();
$date->subMonth(1);
$thang = $this->_getParam('thang', $date->toString("M"));
$nam = $this->_getParam('nam', $date->toString("Y"));
$auth = Zend_Auth::getInstance();
$identity = $auth->getIdentity();
$em_id = $identity->em_id;
$holidaysModel = new Front_Model_Holidays();
$list_holidays = $holidaysModel->fetchData(array(), 'hld_order ASC');
$xinnghiphepModel = new Front_Model_XinNghiPhep();
$list_nghi_phep = $xinnghiphepModel->fetchByDate($em_id, "{$nam}-{$thang}-01 00:00:00", "{$nam}-{$thang}-31 23:59:59");
$chamcongModel = new Front_Model_ChamCong();
$cham_cong = $chamcongModel->fetchOneData(array('c_em_id' => $em_id, 'c_thang' => $thang, 'c_nam' => $nam));
$error_message = array();
$success_message = '';
if ($this->_request->isPost()) {
$data_cham_cong = $this->_arrParam['cham_cong'];
$current_time = new Zend_Db_Expr('NOW()');
if ($cham_cong && ($cham_cong->c_don_vi_status != '-1' || $cham_cong->c_ptccb_status != '-1')) {
$error_message[] = 'Chấm công đã được duyệt nên không thể thay đổi.';
}
if (!sizeof($error_message)) {
if ($cham_cong) {
$chamcongModel->update(array('c_ngay_1' => isset($data_cham_cong[1]) ? $data_cham_cong[1] : '', 'c_ngay_2' => isset($data_cham_cong[2]) ? $data_cham_cong[2] : '', 'c_ngay_3' => isset($data_cham_cong[3]) ? $data_cham_cong[3] : '', 'c_ngay_4' => isset($data_cham_cong[4]) ? $data_cham_cong[4] : '', 'c_ngay_5' => isset($data_cham_cong[5]) ? $data_cham_cong[5] : '', 'c_ngay_6' => isset($data_cham_cong[6]) ? $data_cham_cong[6] : '', 'c_ngay_7' => isset($data_cham_cong[7]) ? $data_cham_cong[7] : '', 'c_ngay_8' => isset($data_cham_cong[8]) ? $data_cham_cong[8] : '', 'c_ngay_9' => isset($data_cham_cong[9]) ? $data_cham_cong[9] : '', 'c_ngay_10' => isset($data_cham_cong[10]) ? $data_cham_cong[10] : '', 'c_ngay_11' => isset($data_cham_cong[11]) ? $data_cham_cong[11] : '', 'c_ngay_12' => isset($data_cham_cong[12]) ? $data_cham_cong[12] : '', 'c_ngay_13' => isset($data_cham_cong[13]) ? $data_cham_cong[13] : '', 'c_ngay_14' => isset($data_cham_cong[14]) ? $data_cham_cong[14] : '', 'c_ngay_15' => isset($data_cham_cong[15]) ? $data_cham_cong[15] : '', 'c_ngay_16' => isset($data_cham_cong[16]) ? $data_cham_cong[16] : '', 'c_ngay_17' => isset($data_cham_cong[17]) ? $data_cham_cong[17] : '', 'c_ngay_18' => isset($data_cham_cong[18]) ? $data_cham_cong[18] : '', 'c_ngay_19' => isset($data_cham_cong[19]) ? $data_cham_cong[19] : '', 'c_ngay_20' => isset($data_cham_cong[20]) ? $data_cham_cong[20] : '', 'c_ngay_21' => isset($data_cham_cong[21]) ? $data_cham_cong[21] : '', 'c_ngay_22' => isset($data_cham_cong[22]) ? $data_cham_cong[22] : '', 'c_ngay_23' => isset($data_cham_cong[23]) ? $data_cham_cong[23] : '', 'c_ngay_24' => isset($data_cham_cong[24]) ? $data_cham_cong[24] : '', 'c_ngay_25' => isset($data_cham_cong[25]) ? $data_cham_cong[25] : '', 'c_ngay_26' => isset($data_cham_cong[26]) ? $data_cham_cong[26] : '', 'c_ngay_27' => isset($data_cham_cong[27]) ? $data_cham_cong[27] : '', 'c_ngay_28' => isset($data_cham_cong[28]) ? $data_cham_cong[28] : '', 'c_ngay_29' => isset($data_cham_cong[29]) ? $data_cham_cong[29] : '', 'c_ngay_30' => isset($data_cham_cong[30]) ? $data_cham_cong[30] : '', 'c_ngay_31' => isset($data_cham_cong[31]) ? $data_cham_cong[31] : '', 'c_date_modifyed' => $current_time), 'c_id=' . $cham_cong->c_id);
} else {
$chamcongModel->insert(array('c_em_id' => $em_id, 'c_thang' => $thang, 'c_nam' => $nam, 'c_ngay_1' => isset($data_cham_cong[1]) ? $data_cham_cong[1] : '', 'c_ngay_2' => isset($data_cham_cong[2]) ? $data_cham_cong[2] : '', 'c_ngay_3' => isset($data_cham_cong[3]) ? $data_cham_cong[3] : '', 'c_ngay_4' => isset($data_cham_cong[4]) ? $data_cham_cong[4] : '', 'c_ngay_5' => isset($data_cham_cong[5]) ? $data_cham_cong[5] : '', 'c_ngay_6' => isset($data_cham_cong[6]) ? $data_cham_cong[6] : '', 'c_ngay_7' => isset($data_cham_cong[7]) ? $data_cham_cong[7] : '', 'c_ngay_8' => isset($data_cham_cong[8]) ? $data_cham_cong[8] : '', 'c_ngay_9' => isset($data_cham_cong[9]) ? $data_cham_cong[9] : '', 'c_ngay_10' => isset($data_cham_cong[10]) ? $data_cham_cong[10] : '', 'c_ngay_11' => isset($data_cham_cong[11]) ? $data_cham_cong[11] : '', 'c_ngay_12' => isset($data_cham_cong[12]) ? $data_cham_cong[12] : '', 'c_ngay_13' => isset($data_cham_cong[13]) ? $data_cham_cong[13] : '', 'c_ngay_14' => isset($data_cham_cong[14]) ? $data_cham_cong[14] : '', 'c_ngay_15' => isset($data_cham_cong[15]) ? $data_cham_cong[15] : '', 'c_ngay_16' => isset($data_cham_cong[16]) ? $data_cham_cong[16] : '', 'c_ngay_17' => isset($data_cham_cong[17]) ? $data_cham_cong[17] : '', 'c_ngay_18' => isset($data_cham_cong[18]) ? $data_cham_cong[18] : '', 'c_ngay_19' => isset($data_cham_cong[19]) ? $data_cham_cong[19] : '', 'c_ngay_20' => isset($data_cham_cong[20]) ? $data_cham_cong[20] : '', 'c_ngay_21' => isset($data_cham_cong[21]) ? $data_cham_cong[21] : '', 'c_ngay_22' => isset($data_cham_cong[22]) ? $data_cham_cong[22] : '', 'c_ngay_23' => isset($data_cham_cong[23]) ? $data_cham_cong[23] : '', 'c_ngay_24' => isset($data_cham_cong[24]) ? $data_cham_cong[24] : '', 'c_ngay_25' => isset($data_cham_cong[25]) ? $data_cham_cong[25] : '', 'c_ngay_26' => isset($data_cham_cong[26]) ? $data_cham_cong[26] : '', 'c_ngay_27' => isset($data_cham_cong[27]) ? $data_cham_cong[27] : '', 'c_ngay_28' => isset($data_cham_cong[28]) ? $data_cham_cong[28] : '', 'c_ngay_29' => isset($data_cham_cong[29]) ? $data_cham_cong[29] : '', 'c_ngay_30' => isset($data_cham_cong[30]) ? $data_cham_cong[30] : '', 'c_ngay_31' => isset($data_cham_cong[31]) ? $data_cham_cong[31] : '', 'c_date_created' => $current_time, 'c_date_modifyed' => $current_time));
}
$success_message = 'Đã cập nhật thành công.';
$cham_cong = $chamcongModel->fetchOneData(array('c_em_id' => $em_id, 'c_thang' => $thang, 'c_nam' => $nam));
}
}
$this->view->success_message = $success_message;
$this->view->error_message = $error_message;
$this->view->thang = $thang;
$this->view->nam = $nam;
$this->view->cham_cong = $cham_cong;
$this->view->list_holidays = $list_holidays;
$this->view->list_nghi_phep = $list_nghi_phep;
}
public function detailAction()
{
$translate = Zend_Registry::get('Zend_Translate');
$this->view->title = 'Danh sách thành viê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);
$date = time();
$thang = $this->_getParam('thang', date('m', $date));
$nam = $this->_getParam('nam', date('Y', $date));
$em_id = $this->_getParam('em', 0);
$holidaysModel = new Front_Model_Holidays();
$list_holidays = $holidaysModel->fetchData(array(), 'hld_order ASC');
$xinnghiphepModel = new Front_Model_XinNghiPhep();
$list_nghi_phep = $xinnghiphepModel->fetchByDate($em_id, "{$nam}-{$thang}-01 00:00:00", "{$nam}-{$thang}-31 23:59:59");
$chamcongModel = new Front_Model_ChamCong();
$cham_cong = $chamcongModel->fetchOneData(array('c_em_id' => $em_id, 'c_thang' => $thang, 'c_nam' => $nam));
$this->view->cham_cong = $cham_cong;
$this->view->thang = $thang;
$this->view->nam = $nam;
$this->view->list_holidays = $list_holidays;
$this->view->list_nghi_phep = $list_nghi_phep;
}
function deleteAction()
{
$this->_helper->layout()->disableLayout();
$xinnghiphepModel = new Front_Model_XinNghiPhep();
if ($this->_request->isPost()) {
$auth = Zend_Auth::getInstance();
$identity = $auth->getIdentity();
$em_id = $identity->em_id;
$xnp_id = $this->_arrParam['xnp_id'];
$xnp_info = $xinnghiphepModel->fetchRow($xinnghiphepModel->select()->where('xnp_id = ?', $xnp_id)->where('xnp_em_id=?', $em_id)->where('xnp_don_vi_status=?', '-1')->where('xnp_ptccb_status=?', '-1'));
if ($xnp_info) {
$success_message = $xinnghiphepModel->delete(array('xnp_id' => $xnp_id));
$this->view->success_message = $success_message;
}
}
}
public function updatestatusAction()
{
$this->_helper->layout()->disableLayout();
$xnp_status = $this->_request->getParam('status', 0);
$thang = $this->_request->getParam('thang', 0);
$nam = $this->_request->getParam('nam', 0);
$phongban = $this->_request->getParam('phongban', 0);
$current_time = new Zend_Db_Expr('NOW()');
if ($xnp_status > 1) {
$xnp_status = 1;
}
if ($xnp_status <= 0) {
$xnp_status = -1;
}
$xnpModel = new Front_Model_XinNghiPhep();
if ($this->_request->isPost()) {
$item = $this->getRequest()->getPost('cid');
foreach ($item as $k => $v) {
$don_nghi_phep = $xnpModel->fetchRow("xnp_id={$v}");
if ($don_nghi_phep && $don_nghi_phep->xnp_don_vi_status > 0) {
$process_status = $xnpModel->update(array('xnp_ptccb_status' => $xnp_status), "xnp_id={$v}");
if ($process_status) {
$thongbao_model = new Front_Model_ThongBao();
$row_content = $xnpModel->fetchRow(array('xnp_id' => $v));
$data = array();
$data['tb_from'] = 0;
$data['tb_to'] = $row_content->xnp_em_id;
$data['tb_tieu_de'] = '[Xin nghỉ phép] Đơn xin nghỉ phép đã được duyệt.';
$data['tb_noi_dung'] = 'Đơn nghỉ phép của bạn đã được duyệt.<br> Lịch nghỉ của bạn bắt đầu từ ' . date('d-m-Y', strtotime($row_content->xnp_from_date)) . ' đến ngày ' . date('d-m-Y', strtotime($row_content->xnp_to_date));
$data['tb_status'] = 0;
$data['tb_date_added'] = $current_time;
$data['tb_date_modified'] = $current_time;
if (!$xnp_status) {
$data['tb_tieu_de'] = '[Xin nghỉ phép] Đơn xin nghỉ phép đã không được chấp nhận.';
$data['tb_noi_dung'] = 'Đơn nghỉ phép của bạn đã không được chấp nhận.<br> Bạn không được phép nghỉ từ ' . date('d-m-Y', strtotime($row_content->xnp_from_date)) . ' đến ngày ' . date('d-m-Y', strtotime($row_content->xnp_to_date));
}
$thongbao_model->insert($data);
}
}
}
}
$this->_redirect('tochuccanbo/duyetnghiphep/index/thang/' . $thang . '/nam/' . $nam . '/phongban/' . $phongban);
}
public function updatestatusAction()
{
$this->_helper->layout()->disableLayout();
$xnp_status = $this->_request->getParam('status', 0);
$thang = $this->_request->getParam('thang', 0);
$nam = $this->_request->getParam('nam', 0);
if ($xnp_status > 1) {
$xnp_status = 1;
}
if ($xnp_status < 0) {
$xnp_status = -1;
}
$xnpModel = new Front_Model_XinNghiPhep();
if ($this->_request->isPost()) {
$item = $this->getRequest()->getPost('cid');
foreach ($item as $k => $v) {
$xnpModel->update(array('xnp_don_vi_status' => $xnp_status), "xnp_id={$v} and xnp_ptccb_status<0");
}
if ($xnp_status) {
$users = $this->_helper->GlobalHelpers->checkToChucUsers(4004);
$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 đơn xin nghỉ phép.';
$data['tb_noi_dung'] = 'Có đơn đơn xin nghỉ phép mới<br/> Bạn hãy <strong><a href="' . $this->view->baseUrl('tochuccanbo/duyetnghiphep') . '">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);
}
}
}
$this->_redirect('donvi/duyetnghiphep/index/thang/' . $thang . '/nam/' . $nam);
}
public function thongkeAction()
{
$layoutPath = APPLICATION_PATH . '/templates/' . TEMPLATE_USED;
$option = array('layout' => '1_column/layout', 'layoutPath' => $layoutPath);
Zend_Layout::startMvc($option);
$translate = Zend_Registry::get('Zend_Translate');
$this->view->title = 'Quản lý cán bộ - ' . $translate->_('TEXT_DEFAULT_TITLE');
$this->view->headTitle($this->view->title);
$date = time();
$thang = $this->_getParam('thang', date('m', $date));
$nam = $this->_getParam('nam', date('Y', $date));
$em_id = $this->_getParam('id', 0);
$holidaysModel = new Front_Model_Holidays();
$list_holidays = $holidaysModel->fetchData(array(), 'hld_order ASC');
$xinnghiphepModel = new Front_Model_XinNghiPhep();
$list_nghi_phep = $xinnghiphepModel->fetchByDate($em_id, "{$nam}-{$thang}-01 00:00:00", "{$nam}-{$thang}-31 23:59:59");
$chamcongModel = new Front_Model_ChamCong();
$cham_cong = $chamcongModel->fetchOneData(array('c_em_id' => $em_id, 'c_thang' => $thang, 'c_nam' => $nam));
$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");
$ltgModel = new Front_Model_LamThemGio();
$list_lam_them_gio = $ltgModel->fetchData(array('ltg_em_id' => $em_id), 'ltg_date_added ASC');
$this->view->cham_cong = $cham_cong;
$this->view->thang = $thang;
$this->view->nam = $nam;
$this->view->list_holidays = $list_holidays;
$this->view->list_nghi_phep = $list_nghi_phep;
$this->view->khen_thuong = $khen_thuong;
$this->view->ky_luat = $ky_luat;
$this->view->em_id = $em_id;
$this->view->list_lam_them_gio = $list_lam_them_gio;
$this->view->page = $this->_page;
}
