public function getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $exParam1 = '', $exParam2 = '', $exParam3 = '', $exParam4 = '')
{
$searchQuery = '';
$tablecontent = '';
$level_opt = array();
$searchArray = array();
$data = array();
$id = '';
$dataTmp = array();
if ($searchData != '' && $searchData != 'undefined') {
$searchValues = json_decode($searchData);
foreach ($searchValues as $key => $val) {
if ($key == 'from_date' || $key == 'to_date') {
$searchQuery .= " " . $key . " like '%" . sapp_Global::change_date($val, 'database') . "%' AND ";
} else {
$searchQuery .= " " . $key . " like '%" . $val . "%' AND ";
}
$searchArray[$key] = $val;
}
$searchQuery = rtrim($searchQuery, " AND");
}
/** search from grid - END * */
$objName = 'educationdetails';
$tableFields = array('action' => 'Action', 'educationlevel' => 'Education Level', 'institution_name' => 'Institution Name', 'course' => 'Course', 'from_date' => 'From', "to_date" => "To", "percentage" => "Percentage");
$tablecontent = $this->geteducationdetails($sort, $by, $pageNo, $perPage, $searchQuery, $exParam1);
$educationlevelcodemodel = new Default_Model_Educationlevelcode();
$educationlevelArr = $educationlevelcodemodel->getEducationlevelData();
if (!empty($educationlevelArr)) {
foreach ($educationlevelArr as $educationlevelres) {
$level_opt[$educationlevelres['id']] = $educationlevelres['educationlevelcode'];
}
}
$dataTmp = array('userid' => $exParam1, 'sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getEmployeeAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'dashboardcall' => $dashboardcall, 'add' => 'add', 'menuName' => 'Education', 'formgrid' => 'true', 'unitId' => $exParam1, 'call' => $call, 'context' => $exParam2, 'search_filters' => array('from_date' => array('type' => 'datepicker'), 'to_date' => array('type' => 'datepicker'), 'educationlevel' => array('type' => 'select', 'filter_data' => array('' => 'All') + $level_opt)));
return $dataTmp;
}
public function edueditAction()
{
if (defined('EMPTABCONFIGS')) {
$empOrganizationTabs = explode(",", EMPTABCONFIGS);
if (in_array('education_details', $empOrganizationTabs)) {
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$call = $this->_getParam('call');
if ($call == 'ajaxcall') {
$this->_helper->layout->disableLayout();
$userID = $this->_getParam('unitId') != '' ? $this->_getParam('unitId') : $this->_getParam('userid');
}
$userid = $this->getRequest()->getParam('userid');
if ($userid == '') {
$userid = $loginUserId;
}
$Uid = $userid ? $userid : $userID;
$employeeModal = new Default_Model_Employee();
try {
$empdata = $employeeModal->getsingleEmployeeData($Uid);
if ($empdata == 'norows') {
$this->view->rowexist = "norows";
$this->view->empdata = "";
} else {
$this->view->rowexist = "rows";
if (!empty($empdata)) {
$educationdetailsModel = new Default_Model_Educationdetails();
$view = Zend_Layout::getMvcInstance()->getView();
$objname = $this->_getParam('objname');
$refresh = $this->_getParam('refresh');
$data = array();
$employeeData = array();
$searchQuery = '';
$searchArray = array();
$tablecontent = '';
if ($refresh == 'refresh') {
$sort = 'DESC';
$by = 'e.modifieddate';
$perPage = PERPAGE;
$pageNo = 1;
$searchData = '';
} else {
$sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC';
$by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'e.modifieddate';
$perPage = $this->_getParam('per_page', PERPAGE);
$pageNo = $this->_getParam('page', 1);
$searchData = $this->_getParam('searchData');
$searchData = rtrim($searchData, ',');
/** search from grid - START **/
$searchData = $this->_getParam('searchData');
if ($searchData != '' && $searchData != 'undefined') {
$searchValues = json_decode($searchData);
foreach ($searchValues as $key => $val) {
if ($key == 'from_date' || $key == 'to_date') {
$searchQuery .= " " . $key . " like '%" . sapp_Global::change_date($val, 'database') . "%' AND ";
} else {
$searchQuery .= " " . $key . " like '%" . $val . "%' AND ";
}
$searchArray[$key] = $val;
}
$searchQuery = rtrim($searchQuery, " AND");
}
/** search from grid - END **/
}
$objName = 'educationdetails';
$tableFields = array('action' => 'Action', 'educationlevel' => 'Education Level', 'institution_name' => 'Institution Name', 'course' => 'Course', 'from_date' => 'From', "to_date" => "To", "percentage" => "Percentage");
$tablecontent = $educationdetailsModel->geteducationdetails($sort, $by, $pageNo, $perPage, $searchQuery, $Uid);
$educationlevelcodemodel = new Default_Model_Educationlevelcode();
$educationlevelArr = $educationlevelcodemodel->getEducationlevelData();
$level_opt = array();
if (!empty($educationlevelArr)) {
foreach ($educationlevelArr as $educationlevelres) {
$level_opt[$educationlevelres['id']] = $educationlevelres['educationlevelcode'];
}
}
$dataTmp = array('userid' => $Uid, 'sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getEmployeeAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'add' => 'add', 'menuName' => TAB_EMP_EDUCATION, 'formgrid' => 'true', 'unitId' => $Uid, 'call' => $call, 'context' => 'myteam', 'search_filters' => array('from_date' => array('type' => 'datepicker'), 'to_date' => array('type' => 'datepicker'), 'educationlevel' => array('type' => 'select', 'filter_data' => array('' => 'All') + $level_opt)));
array_push($data, $dataTmp);
$this->view->id = $Uid;
$this->view->controllername = $objName;
$this->view->dataArray = $data;
$this->view->employeedata = $empdata[0];
$this->view->call = $call;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
$this->view->empdata = $empdata;
}
} catch (Exception $e) {
$this->view->rowexist = "norows";
}
} else {
$this->_redirect('error');
}
} else {
$this->_redirect('error');
}
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$messages['flagtype'] = '';
$actionflag = 3;
if ($id) {
$educationlevelcodemodel = new Default_Model_Educationlevelcode();
$menumodel = new Default_Model_Menu();
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$elevel_data = $educationlevelcodemodel->getsingleEducationLevelCodeData($id);
$Id = $educationlevelcodemodel->SaveorUpdateEducationlevelData($data, $where);
if ($Id == 'update') {
sapp_Global::send_configuration_mail("Education Level", $elevel_data[0]['educationlevelcode']);
$menuidArr = $menumodel->getMenuObjID('/educationlevelcode');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Education level deleted successfully';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Education level cannot be deleted';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Education level cannot be deleted';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
public function editpopupAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/");
$id = $this->getRequest()->getParam('id');
//Id (PK) from form URL
$user_id = $this->getRequest()->getParam('unitId');
//This is User_id taking from URL set to form...
$educationDetailsform = new Default_Form_Educationdetails();
$educationDetailsModel = new Default_Model_Educationdetails();
$educationlevelcodemodel = new Default_Model_Educationlevelcode();
if ($id) {
$data = $educationDetailsModel->geteducationdetailsRecord($id);
$educationlevelArr = $educationlevelcodemodel->getEducationlevelData();
if (!empty($educationlevelArr)) {
$educationDetailsform->educationlevel->addMultiOption('', 'Select Education Level');
foreach ($educationlevelArr as $educationlevelres) {
$educationDetailsform->educationlevel->addMultiOption($educationlevelres['id'], $educationlevelres['educationlevelcode']);
}
}
$educationDetailsform->setDefault("id", $data[0]["id"]);
$educationDetailsform->setDefault("educationlevel", $data[0]["educationlevel"]);
$educationDetailsform->setDefault("institution_name", $data[0]["institution_name"]);
$educationDetailsform->setDefault("course", $data[0]["course"]);
$from_date = sapp_Global::change_date($data[0]['from_date'], 'view');
$educationDetailsform->setDefault('from_date', $from_date);
$to_date = sapp_Global::change_date($data[0]['to_date'], 'view');
$educationDetailsform->setDefault('to_date', $to_date);
$educationDetailsform->setDefault("percentage", $data[0]["percentage"]);
$educationDetailsform->setAttrib('action', BASE_URL . 'educationdetails/editpopup/id/' . $id . '/unitId/' . $user_id);
$educationDetailsform->setDefault("user_id", $user_id);
$this->view->id = $user_id;
}
$educationDetailsform->setAttrib('action', BASE_URL . 'educationdetails/editpopup/id/' . $id . '/unitId/' . $user_id);
$this->view->form = $educationDetailsform;
if ($this->getRequest()->getPost()) {
$result = $this->save($educationDetailsform, $user_id);
$this->view->msgarray = $result;
}
}
