PHP sapp_Global::_convertArrayToHTMLTable方法代码示例

 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;
 }