public function getrequestsAction()
{
$service_desk_id = $this->_getParam('service_desk_id', null);
$service_desk_conf_id = $this->_getParam('service_desk_conf_id', null);
$data = array();
$options = sapp_Global::selectOptionBuilder('', 'Select request', '');
if ($service_desk_id != '') {
$sd_dept_model = new Default_Model_Servicedeskdepartment();
$data = $sd_dept_model->getRequestsById($service_desk_id);
if (count($data) > 0) {
foreach ($data as $opt) {
$options .= sapp_Global::selectOptionBuilder($opt['id'], utf8_encode($opt['service_request_name']), '');
}
}
}
$attachment = false;
if ($service_desk_conf_id != '') {
$sd_conf_model = new Default_Model_Servicedeskconf();
$sd_conf_data = $sd_conf_model->getServiceDeskConfbyID($service_desk_conf_id);
if (count($sd_conf_data) > 0) {
if ($sd_conf_data[0]['attachment'] == 1) {
$attachment = true;
}
}
}
$this->_helper->json(array('options' => $options, 'datacount' => count($data), 'attachment' => $attachment));
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$actionflag = 3;
$count = 0;
if ($id) {
$servicedeskconfmodel = new Default_Model_Servicedeskconf();
$servicedeskdepartmentmodel = new Default_Model_Servicedeskdepartment();
$menumodel = new Default_Model_Menu();
$servicedeskconfdata = $servicedeskconfmodel->getServiceDeskConfbyID($id);
if (!empty($servicedeskconfdata)) {
$pendingRequestdata = $servicedeskconfmodel->getPendingServiceReqData($servicedeskconfdata[0]['businessunit_id']);
}
if (!empty($pendingRequestdata)) {
$count = $pendingRequestdata[0]['count'];
}
if ($count < 1) {
$serviceDeptData = $servicedeskdepartmentmodel->getServiceDeskDepartmentDatabyID($servicedeskconfdata[0]['service_desk_id']);
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$Id = $servicedeskconfmodel->SaveorUpdateServiceConfData($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/servicedeskconf');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
if (!empty($serviceDeptData)) {
$configmail = sapp_Global::send_configuration_mail('Setting', $serviceDeptData[0]['service_desk_name']);
}
$messages['message'] = 'Setting deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Setting cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Setting cannot be deleted as requests are in pending state.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Setting cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
