public function getdatafromajaxcallAction()
{
$meetingroomModel = new Default_Model_Meetingroom();
$methodKey = $this->_getParam('methodKey', null);
if ($methodKey == "1") {
//Get Departments by ProjectID
$projectid = $this->_getParam('projectid', null);
$options_data = "";
$options_data .= sapp_Global::selectOptionBuilder('0', 'Select Department');
if ($projectid != '') {
$rows = $meetingroomModel->getDepartmentsByProject($projectid);
foreach ($rows as $row) {
$options_data .= sapp_Global::selectOptionBuilder($row['id'], $row['name']);
}
}
$this->_helper->json(array('options' => $options_data));
} else {
if ($methodKey == "2") {
$projectid = $this->_getParam('projectid', null);
$prjIDS = $projectid;
$options_data = "";
if (is_array($projectid)) {
$prjIDS = implode(",", $projectid);
}
$options_data .= sapp_Global::selectOptionBuilder('0', 'Select Resource');
if ($projectid != '') {
$rows = $meetingroomModel->getEmployeesByBU($prjIDS);
foreach ($rows as $row) {
$options_data .= sapp_Global::selectOptionBuilder($row['id'], $row['name']);
}
}
$this->_helper->json(array('options' => $options_data));
} else {
if ($methodKey == "3") {
try {
$meetingroomModel = new Default_Model_Meetingroom();
$roomid = $this->_getParam('roomid', null);
$bookeddate = $this->_getParam('bookeddate', null);
$rows = $meetingroomModel->getMeetingsByRoomAndDate($roomid, $bookeddate);
$datatable = "";
$datatable .= sapp_Global::_convertArrayToHTMLTable("leavecardtablegrid", "Booked Meetings", $rows);
$this->_helper->json(array('meetingtable' => $datatable));
} catch (Exception $e) {
echo $e->getMessage();
}
}
}
}
}
public function getdatafromajaxcallAction()
{
$taskallocation_model = new Default_Model_Tasksallocation();
$methodKey = $this->_getParam('methodKey', null);
if ($methodKey == "1") {
//Get Project Tasks
$projectid = $this->_getParam('projectid', null);
$options_data = "";
$options_data .= sapp_Global::selectOptionBuilder('0', 'Select Task');
if ($projectid != '') {
$dept_data = $taskallocation_model->getProjectTasks($projectid);
foreach ($dept_data as $dept) {
$options_data .= sapp_Global::selectOptionBuilder($dept['id'], $dept['name']);
}
}
$this->_helper->json(array('options' => $options_data));
} else {
if ($methodKey == "2") {
//Get Tasks Planned Activities
$taskid = $this->_getParam('taskid', null);
$this->_helper->json(array('options' => sapp_Global::_convertArrayToHTMLTable("leavecardtablegrid", "Task Details", $taskallocation_model->getTaskDetails($taskid))));
} else {
if ($methodKey == "3") {
//Get Tasks Planned Activities
$taskid = $this->_getParam('taskid', null);
$taskActivityDetails = $taskallocation_model->getTaskActivityDetails($taskid);
$this->_helper->json(array('options' => $this->getActivitesEditableGrid($taskActivityDetails)));
//$this->_helper->json(array('options' => sapp_Global::_convertArrayToHTMLTable("leavecardtablegrid", "Task Activity Details", $taskActivityDetails)));
} else {
if ($methodKey == "4") {
//Get Project resources
$projectid = $this->_getParam('projectid', null);
$options_data = "";
//$options_data .= sapp_Global::selectOptionBuilder('0', 'Select Task');
if ($projectid != '') {
$dept_data = $taskallocation_model->getEmployeesByProject($projectid);
foreach ($dept_data as $dept) {
$options_data .= sapp_Global::selectOptionBuilder($dept['id'], $dept['name']);
}
}
$this->_helper->json(array('options' => $options_data));
}
}
}
}
}
public function viewAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$id = $this->getRequest()->getParam('id');
if (is_numeric($id) && $id > 0) {
$taskModel = new Default_Model_Createtasks();
$data = $taskModel->getProjectTaskDetailsForView($id);
$activitiesdata = sapp_Global::_convertArrayToHTMLTable("leavecardtablegrid", "Task Activities", $taskModel->getTaskActivityDetails($id));
if (!empty($data)) {
foreach ($data as $key => $val) {
$data[$key] = htmlentities($val, ENT_QUOTES, "UTF-8");
}
$this->view->data = $data;
$this->view->activitiesdata = $activitiesdata;
$this->view->id = $id;
$this->view->controllername = "tasks";
$this->view->ermsg = '';
$this->view->loginuserGroup = $loginuserGroup;
} else {
$this->view->ermsg = 'nodata';
}
} else {
$this->view->ermsg = 'nodata';
}
}
public function editAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->getRequest()->getParam('id');
$callval = $this->getRequest()->getParam('call');
if ($callval == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$managerleaverequestform = new Default_Form_managerleaverequest();
try {
if ($id && is_numeric($id) && $id > 0) {
$leaverequestmodel = new Default_Model_Leaverequest();
$usersmodel = new Default_Model_Users();
$flag = 'true';
$userid = $leaverequestmodel->getUserID($id);
$getreportingManagerArr = $leaverequestmodel->getReportingManagerId($id);
$reportingManager = $getreportingManagerArr[0]['repmanager'];
if ($reportingManager != $loginUserId) {
$flag = 'false';
}
if (!empty($userid)) {
$isactiveuser = $usersmodel->getUserDetailsByID($userid[0]['user_id']);
$getUserLeaves = sapp_Global::_convertArrayToHTMLTable("leavecardtablegrid", "Leaves Pool", $leaverequestmodel->getUserLeaves($userid[0]['user_id']));
} else {
$this->view->rowexist = "rows";
}
if (!empty($userid) && !empty($isactiveuser) && $flag == 'true') {
$data = $leaverequestmodel->getLeaveRequestDetails($id);
//if (!empty($data) && $data[0]['leavestatus'] == 'Pending for approval') {
if (!empty($data)) {
$data = $data[0];
$reason = $data['reason'];
$appliedleavescount = $data['appliedleavescount'];
$employeeid = $data['user_id'];
$leavetypeid = $data['leavetypeid'];
$employeeleavetypemodel = new Default_Model_Employeeleavetypes();
$usersmodel = new Default_Model_Users();
$employeesmodel = new Default_Model_Employees();
$businessunitid = '';
$loggedInEmployeeDetails = $employeesmodel->getLoggedInEmployeeDetails($employeeid);
if ($loggedInEmployeeDetails[0]['businessunit_id'] != '') {
$businessunitid = $loggedInEmployeeDetails[0]['businessunit_id'];
}
$employeeleavetypeArr = $employeeleavetypemodel->getsingleEmployeeLeavetypeData($data['leavetypeid']);
if ($employeeleavetypeArr != 'norows') {
$managerleaverequestform->leavetypeid->addMultiOption($employeeleavetypeArr[0]['id'], utf8_encode($employeeleavetypeArr[0]['leavetype']));
}
if ($data['leaveday'] == 1) {
$managerleaverequestform->leaveday->addMultiOption($data['leaveday'], 'Full Day');
} else {
$managerleaverequestform->leaveday->addMultiOption($data['leaveday'], 'Half Day');
}
$employeenameArr = $usersmodel->getUserDetailsByID($data['user_id']);
$employeeemail = $employeenameArr[0]['emailaddress'];
$employeename = $employeenameArr[0]['userfullname'];
$managerleaverequestform->populate($data);
$from_date = sapp_Global::change_date($data['from_date'], 'view');
$to_date = sapp_Global::change_date($data['to_date'], 'view');
$appliedon = sapp_Global::change_date($data['createddate'], 'view');
$managerleaverequestform->from_date->setValue($from_date);
$managerleaverequestform->to_date->setValue($to_date);
$managerleaverequestform->createddate->setValue($appliedon);
$managerleaverequestform->appliedleavesdaycount->setValue($data['appliedleavescount']);
$managerleaverequestform->employeename->setValue($employeenameArr[0]['userfullname']);
$managerleaverequestform->setDefault('leavetypeid', $data['leavetypeid']);
$managerleaverequestform->setDefault('leaveday', $data['leaveday']);
$this->view->id = $id;
$this->view->getUserLeaves = $getUserLeaves;
$this->view->form = $managerleaverequestform;
$this->view->data = $data;
$managerleaverequestform->setAttrib('action', DOMAIN . 'manageremployeevacations/edit/id/' . $id);
} else {
$this->view->rowexist = "rows";
}
} else {
$this->view->rowexist = "rows";
}
} else {
$this->view->rowexist = "rows";
}
} catch (Exception $e) {
$this->view->rowexist = 'norows';
}
if ($this->getRequest()->getPost()) {
$result = $this->save($managerleaverequestform, $appliedleavescount, $employeeemail, $employeeid, $employeename, $from_date, $to_date, $reason, $businessunitid, $leavetypeid);
$this->view->msgarray = $result;
}
}
public function viewAction()
{
$id = $this->getRequest()->getParam('id');
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$candidatesmodel = new Default_Model_Shortlistedcandidates();
$requi_model = new Default_Model_Requisition();
$jobtitleModel = new Default_Model_Jobtitles();
$intrvwroundsData = array();
$intrvwData = array();
$jobtitle = '';
try {
$candidateData = $candidatesmodel->getcandidateData($id);
$cand_status = $candidateData['cand_status'];
$req_id = $candidateData['requisition_id'];
try {
$requisitionData = $requi_model->getRequisitionDataById($req_id);
$requisitionData['jobtitlename'] = '';
$jobttlArr = $jobtitleModel->getsingleJobTitleData($requisitionData['jobtitle']);
if (!empty($jobttlArr) && $jobttlArr != 'norows') {
$jobtitle = $jobttlArr[0]['jobtitlename'];
$requisitionData['jobtitlename'] = $jobttlArr[0]['jobtitlename'];
}
$intrvwData = $candidatesmodel->getinterviewData($requisitionData['id'], $candidateData['id']);
if (!empty($intrvwData)) {
$intrvwroundsData = $candidatesmodel->getinterviewrounds($intrvwData['id'], $requisitionData['id'], $candidateData['id']);
$intrvwroundsSkillSetData = $candidatesmodel->getinterviewroundskillsetsummary($intrvwroundsData[0]['interview_round_number'], $requisitionData['id'], $candidateData['id']);
$intrvwroundsSkillSetDataSummary = $tLeaveCardData01 = sapp_Global::_convertArrayToHTMLTable("leavecardtablegrid", "", $intrvwroundsSkillSetData);
$this->view->intrvwroundsSkillSetDataSummary = $intrvwroundsSkillSetDataSummary;
$this->view->candidateData = $candidateData;
$this->view->requisitionData = $requisitionData;
$this->view->intrvwrounds = $intrvwroundsData;
$this->view->intrvwData = $intrvwData;
$this->view->ermsg = '';
} else {
$this->view->ermsg = 'nodata';
}
} catch (Exception $e) {
$this->view->ermsg = 'nodata';
}
} catch (Exception $e) {
$this->view->ermsg = 'nodata';
}
$this->view->loginuserGroup = $loginuserGroup;
}
