public function pwe_routing() { $result = cases::parameter(); $result["class"] = $result[1]; $result["method"] = $result[2]; if (MODE_CONTROLLER == "oop") { if (empty($result["class"])) { $result["class"] = self::$pwe_start_controller; } if (file_exists(RELATIVE . "content/controller/" . $result["class"] . ".php")) { define(in_controller, false); include_once RELATIVE . "content/controller/" . $result["class"] . ".php"; $myclass = new $result["class"](); if (method_exists($myclass, $result["method"])) { echo $myclass->{$result}["method"](); define(ERROR, false); } else { if ($result["method"] == null && method_exists($myclass, "index")) { echo $myclass->index(); define(ERROR, false); } else { define(ERROR, true); if (OOP_ERROR != true) { include_once RELATIVE . "content/error/" . ERROR404; } } } } else { define(in_controller, true); if (file_exists(RELATIVE . "content/controller/" . self::$pwe_start_controller . ".php")) { include_once RELATIVE . "content/controller/" . self::$pwe_start_controller . ".php"; $index_class = START_CONTROLLER; $myclass = new $index_class(); if (method_exists($myclass, $result["class"])) { echo $myclass->{$result}["class"](); define(ERROR, false); } else { define(ERROR, true); if (OOP_ERROR != true) { include_once RELATIVE . "content/error/" . ERROR404; } } } else { define(ERROR, true); if (OOP_ERROR != true) { include_once RELATIVE . "content/error/" . ERROR404; } } } } }
<?php $array = array('status' => 'error', 'data' => 'command not found'); switch ($options['module_name']) { case "cases": $case = new cases(); $array = $case->set_values($options['module_id'], $options['type'], $options); break; }
require_once 'class/class.FctSearchScreen.php'; ob_end_clean(); header("Content-type: text/csv"); header("Cache-Control: no-store, no-cache"); header('Content-Disposition: attachment; filename="filename.csv"'); $page = $_REQUEST['page']; $arr = array(); $options = array(); $op = $_REQUEST['options']; foreach ($_REQUEST as $n => $v) { if (strtolower(substr($n, 0, 7)) == 'search_') { $options[substr($n, 7)] = $v; } } switch ($page) { case "bucket_search": $fct = new FctSearchScreen(); $arr = $fct->display_flowchart_task2($options, array('return_csv' => true, 'user_id' => $_SESSION['user_id'])); break; case "case_search": $case = new cases(); $arr = $case->display_search($options, array('return_csv' => true, 'user_id' => $_SESSION["user_id"])); break; } foreach ($arr['body'] as $row) { $clean_row = array(); foreach ($row as $name => $col) { $clean_row[$name] = $col; } echo '"' . trim(str_replace("\n", '', implode('","', $clean_row) . '"')) . "\n"; }
<?php //ini_set('display_errors',1); $case = new cases(); $global_tasks = new GlobalTask(); $contacts = new contacts(); //$sql = $case->search_query( array('case_id' => $options['case_id'] ) ); $sql = "SELECT * FROM contacts WHERE contact_id = '" . $options['contact_id'] . "'"; $array = $this->db->fetch_assoc($this->db->query($sql)); $array['tasks'] = array(); $tasks = $global_tasks->search_flow_chart_tasks(array('module' => 'contacts', 'module_id' => $options['contact_id'])); foreach ($tasks as $n => $v) { //$v['name'] = $v['subject']; $v['task_type'] = 'global_task'; $v['task_id'] = $v['chart_assign_id']; $v['access'] = $global_tasks->check_permitions($v); $v['options'] = $global_tasks->get_flowchart_options($v['flow_chart_id']); $array['tasks'][] = $v; } $array['activity'] = $this->get_activity_log_by_module('contacts', $options['contact_id']); $array['followers'] = $this->follow->get_followers_by_module('contacts', $options['contact_id']); $array['phone'] = $contacts->get_contact_phone($options['contact_id']); $array['email'] = $contacts->get_contact_email($options['contact_id']); $array['address'] = $contacts->get_contact_address($options['contact_id']); $array['im'] = $contacts->get_contact_im($options['contact_id']); if (array_key_exists($_SESSION['user_id'], $array['followers'])) { $array['following'] = true; } else { $array['following'] = false; } $sql = $case->search_query(array('module_name' => 'contacts', 'module_id' => $options['contact_id']));
require_once 'class/class.cases.php'; $secure = new secure(); if (PHONE_SYSTEM == "asterisk") { require_once 'class/class.asterisk.php'; $asterisk = new Asterisk(); } $contact_id = $vars['contact_id']; $em = new Event_Contacts(); $em->SetContactID($contact_id); $contact = new Contacts(); $evt = new Event(); $page = new basic_page(); $note = new Note(); $task = new Tasks(); $notify = new Notification(); $cases = new cases(); $cert = new Certification_Type(); $app = new Application(); $dynamic_page = new dynamic_page(); $global_tasks = new GlobalTask(); ?> <table style="width: 100%"><tr><td style="width:70%;vertical-align: top;padding-right: 20px;" > <div id="div_credential" class="" style="display:none;"></div> <div id="prl" style="display:none;"><img id="prl_image" src="images/spinner.gif" /></div> <div id="content_column_header"> <?php echo $em->GetContactHead($contact_id, 'display_tag', 'em'); ?> <div class="edit_link" id="edit_link"><?php
<?php require_once 'app_code/global.config.php'; require_once 'class/config.inc.php'; require_once 'app_code/global.config.php'; require_once 'class/config.inc.php'; require_once 'class/class.email_client.php'; require_once 'class/class.flags.php'; require_once 'class/class.GlobalTask.php'; require_once 'class/class.smtp.php'; require_once 'class/class.display.php'; require_once 'class/class.casecreation.php'; require_once 'class/class.cases.php'; $case = new cases(); ?> <?php echo $case->display_search_bar(); $object = array(); $object['Status'] = 'Active'; ?> <br/> <div style="width: 100%;" id="search_result" ><?php echo $case->display_search($object, array('user_id' => $_SESSION["user_id"])); ?> </div>
public function getAllGeneratedDocumentsCriteria($sProcessUID, $sApplicationUID, $sTasKUID, $sUserUID) { \G::LoadClass("configuration"); $conf = new \Configurations(); $confEnvSetting = $conf->getFormats(); //verifica si la tabla OBJECT_PERMISSION $cases = new \cases(); $cases->verifyTable(); $listing = false; $oPluginRegistry = & \PMPluginRegistry::getSingleton(); if ($oPluginRegistry->existsTrigger(PM_CASE_DOCUMENT_LIST)) { $folderData = new \folderData(null, null, $sApplicationUID, null, $sUserUID); $folderData->PMType = "OUTPUT"; $folderData->returnList = true; //$oPluginRegistry = & PMPluginRegistry::getSingleton(); $listing = $oPluginRegistry->executeTriggers(PM_CASE_DOCUMENT_LIST, $folderData); } $aObjectPermissions = $cases->getAllObjects($sProcessUID, $sApplicationUID, $sTasKUID, $sUserUID); if (!is_array($aObjectPermissions)) { $aObjectPermissions = array('DYNAFORMS' => array(-1),'INPUT_DOCUMENTS' => array(-1),'OUTPUT_DOCUMENTS' => array(-1)); } if (!isset($aObjectPermissions['DYNAFORMS'])) { $aObjectPermissions['DYNAFORMS'] = array(-1); } else { if (!is_array($aObjectPermissions['DYNAFORMS'])) { $aObjectPermissions['DYNAFORMS'] = array(-1); } } if (!isset($aObjectPermissions['INPUT_DOCUMENTS'])) { $aObjectPermissions['INPUT_DOCUMENTS'] = array(-1); } else { if (!is_array($aObjectPermissions['INPUT_DOCUMENTS'])) { $aObjectPermissions['INPUT_DOCUMENTS'] = array(-1); } } if (!isset($aObjectPermissions['OUTPUT_DOCUMENTS'])) { $aObjectPermissions['OUTPUT_DOCUMENTS'] = array(-1); } else { if (!is_array($aObjectPermissions['OUTPUT_DOCUMENTS'])) { $aObjectPermissions['OUTPUT_DOCUMENTS'] = array(-1); } } $aDelete = $cases->getAllObjectsFrom($sProcessUID, $sApplicationUID, $sTasKUID, $sUserUID, 'DELETE'); $oAppDocument = new \AppDocument(); $oCriteria = new \Criteria('workflow'); $oCriteria->add(\AppDocumentPeer::APP_UID, $sApplicationUID); $oCriteria->add(\AppDocumentPeer::APP_DOC_TYPE, 'OUTPUT'); $oCriteria->add(\AppDocumentPeer::APP_DOC_STATUS, array('ACTIVE'), \Criteria::IN); //$oCriteria->add(AppDocumentPeer::APP_DOC_UID, $aObjectPermissions['OUTPUT_DOCUMENTS'], Criteria::IN); $oCriteria->add( $oCriteria->getNewCriterion( \AppDocumentPeer::APP_DOC_UID, $aObjectPermissions['OUTPUT_DOCUMENTS'], \Criteria::IN)->addOr($oCriteria->getNewCriterion(\AppDocumentPeer::USR_UID, $sUserUID, \Criteria::EQUAL)) ); $aConditions = array(); $aConditions[] = array(\AppDocumentPeer::APP_UID, \AppDelegationPeer::APP_UID); $aConditions[] = array(\AppDocumentPeer::DEL_INDEX, \AppDelegationPeer::DEL_INDEX); $oCriteria->addJoinMC($aConditions, \Criteria::LEFT_JOIN); $oCriteria->add(\AppDelegationPeer::PRO_UID, $sProcessUID); $oCriteria->addAscendingOrderByColumn(\AppDocumentPeer::APP_DOC_INDEX); $oDataset = \AppDocumentPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $oDataset->next(); $aOutputDocuments = array(); $aOutputDocuments[] = array( 'APP_DOC_UID' => 'char', 'DOC_UID' => 'char', 'APP_DOC_COMMENT' => 'char', 'APP_DOC_FILENAME' => 'char', 'APP_DOC_INDEX' => 'integer' ); $oUser = new \Users(); while ($aRow = $oDataset->getRow()) { $oCriteria2 = new \Criteria('workflow'); $oCriteria2->add(\AppDelegationPeer::APP_UID, $sApplicationUID); $oCriteria2->add(\AppDelegationPeer::DEL_INDEX, $aRow['DEL_INDEX']); $oDataset2 = \AppDelegationPeer::doSelectRS($oCriteria2); $oDataset2->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $oDataset2->next(); $aRow2 = $oDataset2->getRow(); $oTask = new \Task(); if ($oTask->taskExists($aRow2['TAS_UID'])) { $aTask = $oTask->load($aRow2['TAS_UID']); } else { $aTask = array('TAS_TITLE' => '(TASK DELETED)'); } $lastVersion = $oAppDocument->getLastDocVersion($aRow['DOC_UID'], $sApplicationUID); if ($lastVersion == $aRow['DOC_VERSION']) { //Only show last document Version $aAux = $oAppDocument->load($aRow['APP_DOC_UID'], $aRow['DOC_VERSION']); //Get output Document information $oOutputDocument = new \OutputDocument(); $aGields = $oOutputDocument->load($aRow['DOC_UID']); //OUTPUTDOCUMENT $outDocTitle = $aGields['OUT_DOC_TITLE']; switch ($aGields['OUT_DOC_GENERATE']) { //G::LoadTranslation(ID_DOWNLOAD) case "PDF": $fileDoc = 'javascript:alert("NO DOC")'; $fileDocLabel = " "; $filePdf = 'cases_ShowOutputDocument?a=' . $aRow['APP_DOC_UID'] . '&v=' . $aRow['DOC_VERSION'] . '&ext=pdf&random=' . rand(); $filePdfLabel = ".pdf"; if (is_array($listing)) { foreach ($listing as $folderitem) { if (($folderitem->filename == $aRow['APP_DOC_UID']) && ($folderitem->type == "PDF")) { $filePdfLabel = \G::LoadTranslation('ID_GET_EXTERNAL_FILE') . " .pdf"; $filePdf = $folderitem->downloadScript; continue; } } } break; case "DOC": $fileDoc = 'cases_ShowOutputDocument?a=' . $aRow['APP_DOC_UID'] . '&v=' . $aRow['DOC_VERSION'] . '&ext=doc&random=' . rand(); $fileDocLabel = ".doc"; $filePdf = 'javascript:alert("NO PDF")'; $filePdfLabel = " "; if (is_array($listing)) { foreach ($listing as $folderitem) { if (($folderitem->filename == $aRow['APP_DOC_UID']) && ($folderitem->type == "DOC")) { $fileDocLabel = \G::LoadTranslation('ID_GET_EXTERNAL_FILE') . " .doc"; $fileDoc = $folderitem->downloadScript; continue; } } } break; case "BOTH": $fileDoc = 'cases_ShowOutputDocument?a=' . $aRow['APP_DOC_UID'] . '&v=' . $aRow['DOC_VERSION'] . '&ext=doc&random=' . rand(); $fileDocLabel = ".doc"; if (is_array($listing)) { foreach ($listing as $folderitem) { if (($folderitem->filename == $aRow['APP_DOC_UID']) && ($folderitem->type == "DOC")) { $fileDocLabel = G::LoadTranslation('ID_GET_EXTERNAL_FILE') . " .doc"; $fileDoc = $folderitem->downloadScript; continue; } } } $filePdf = 'cases_ShowOutputDocument?a=' . $aRow['APP_DOC_UID'] . '&v=' . $aRow['DOC_VERSION'] . '&ext=pdf&random=' . rand(); $filePdfLabel = ".pdf"; if (is_array($listing)) { foreach ($listing as $folderitem) { if (($folderitem->filename == $aRow['APP_DOC_UID']) && ($folderitem->type == "PDF")) { $filePdfLabel = \G::LoadTranslation('ID_GET_EXTERNAL_FILE') . " .pdf"; $filePdf = $folderitem->downloadScript; continue; } } } break; } try { $aAux1 = $oUser->load($aAux['USR_UID']); $sUser = $conf->usersNameFormatBySetParameters($confEnvSetting["format"], $aAux1["USR_USERNAME"], $aAux1["USR_FIRSTNAME"], $aAux1["USR_LASTNAME"]); } catch (\Exception $oException) { $sUser = '******'; } //if both documents were generated, we choose the pdf one, only if doc was //generate then choose the doc file. $firstDocLink = $filePdf; $firstDocLabel = $filePdfLabel; if ($aGields['OUT_DOC_GENERATE'] == 'DOC') { $firstDocLink = $fileDoc; $firstDocLabel = $fileDocLabel; } $aFields = array( 'APP_DOC_UID' => $aAux['APP_DOC_UID'], 'DOC_UID' => $aAux['DOC_UID'], 'APP_DOC_COMMENT' => $aAux['APP_DOC_COMMENT'], 'APP_DOC_FILENAME' => $aAux['APP_DOC_FILENAME'], 'APP_DOC_INDEX' => $aAux['APP_DOC_INDEX'], 'ORIGIN' => $aTask['TAS_TITLE'], 'CREATE_DATE' => $aAux['APP_DOC_CREATE_DATE'], 'CREATED_BY' => $sUser, 'FILEDOC' => $fileDoc, 'FILEPDF' => $filePdf, 'OUTDOCTITLE' => $outDocTitle, 'DOC_VERSION' => $aAux['DOC_VERSION'], 'TYPE' => $aAux['APP_DOC_TYPE'] . ' ' . $aGields['OUT_DOC_GENERATE'], 'DOWNLOAD_LINK' => $firstDocLink, 'DOWNLOAD_FILE' => $aAux['APP_DOC_FILENAME'] . $firstDocLabel ); if (trim($fileDocLabel) != '') { $aFields['FILEDOCLABEL'] = $fileDocLabel; } if (trim($filePdfLabel) != '') { $aFields['FILEPDFLABEL'] = $filePdfLabel; } if ($aFields['APP_DOC_FILENAME'] != '') { $aFields['TITLE'] = $aFields['APP_DOC_FILENAME']; } else { $aFields['TITLE'] = $aFields['APP_DOC_COMMENT']; } //$aFields['POSITION'] = $_SESSION['STEP_POSITION']; $aFields['CONFIRM'] = \G::LoadTranslation('ID_CONFIRM_DELETE_ELEMENT'); if (in_array($aRow['APP_DOC_UID'], $aObjectPermissions['OUTPUT_DOCUMENTS'])) { if (in_array($aRow['APP_DOC_UID'], $aDelete['OUTPUT_DOCUMENTS'])) { $aFields['ID_DELETE'] = \G::LoadTranslation('ID_DELETE'); } } $aOutputDocuments[] = $aFields; } $oDataset->next(); } global $_DBArray; $_DBArray['outputDocuments'] = $aOutputDocuments; \G::LoadClass('ArrayPeer'); $oCriteria = new \Criteria('dbarray'); $oCriteria->setDBArrayTable('outputDocuments'); $oCriteria->addDescendingOrderByColumn('CREATE_DATE'); return $oCriteria; }
<?php //ini_set('display_errors',1); $case = new cases(); $global_tasks = new GlobalTask(); $sql = $case->search_query(array('case_id' => $options['case_id'])); $array = $this->db->fetch_assoc($this->db->query($sql)); $array['tasks'] = array(); $tasks = $global_tasks->search_flow_chart_tasks(array('module' => 'cases', 'module_id' => $options['case_id'])); foreach ($tasks as $n => $v) { //$v['name'] = $v['subject']; $v['task_type'] = 'global_task'; $v['task_id'] = $v['chart_assign_id']; $v['access'] = $global_tasks->check_permitions($v); $v['options'] = $global_tasks->get_flowchart_options($v['flow_chart_id']); $array['tasks'][] = $v; } $array['activity'] = $this->get_activity_log_by_module('cases', $options['case_id']); $array['followers'] = $this->follow->get_followers_by_module('cases', $options['case_id']); if (array_key_exists($_SESSION['user_id'], $array['followers'])) { $array['following'] = true; } else { $array['following'] = false; } $time = new TimeTracker(); $time->setModuleName('cases'); $time->setModuleID($options['case_id']); $array['time'] = array(); $array['time']['entries'] = $time->getTimeEntries(); $array['time']['open'] = $time->getOpenEntryId($array['time']['entries']);
<?php $case = new cases(); $search = array(); //I did it this way to allow alias's $avalible_keys = array('case_id' => 'case_id', 'group_id' => 'group_id', 'module_name' => 'module_name', 'subject' => 'subject', 'OrderNumber' => 'OrderNumber', 'module_id' => 'module_id', 'contact_module_id' => 'contact_module_id', 'contact_module_name' => 'contact_module_name', 'TicketNumber' => 'TicketNumber', 'Title' => 'Title', 'CreatedOn_min' => 'CreatedOn_min', 'CreatedOn_max' => 'CreatedOn_max', 'CaseType' => 'CaseType', 'Priority' => 'Priority', 'Owner' => 'Owner', 'owner' => 'Owner', 'Status' => 'Status', 'status' => 'Status', 'CaseOrigin' => 'CaseOrigin', 'client_name' => 'client_name', 'client_id' => 'client_id', 'no_account' => 'no_account', 'search' => 'search'); foreach ($options as $n => $v) { if (array_key_exists($n, $avalible_keys)) { $search[$avalible_keys[$n]] = $v; } switch ($n) { case 'self': if ($v == 'true') { $search['Owner'] = $_SESSION['user_id']; } break; } } $sql = $case->search_query($search); $result = $this->db->query($sql); while ($row = $this->db->fetch_assoc($result)) { $array[] = $row; } //$array=array('sql' => $sql);
<?php $case = new cases(); $info = array(); $info['CreatedOn'] = date('Y-m-d H:i:s'); $info['CreatedBy'] = $_SESSION['user_id']; $info['Owner'] = $_SESSION['user_id']; $info['Status'] = 'Active'; $avalible_keys = array('Status' => 'Status', 'status' => 'Status', 'group_id' => 'group_id', 'module_name' => 'module_name', 'module_id' => 'module_id', 'subject' => 'subject', 'contact_module_name' => 'contact_module_name', 'contact_module_id' => 'contact_module_id', 'CreatedOn' => 'CreatedOn', 'CaseType' => 'CaseType', 'CaseOrigin' => 'CaseOrigin', 'Owner' => 'Owner', 'createdon' => 'CreatedOn', 'casetype' => 'CaseType', 'caseorigin' => 'CaseOrigin', 'owner' => 'Owner'); foreach ($options as $n => $v) { if (array_key_exists($n, $avalible_keys)) { $info[$avalible_keys[$n]] = $v; } } $array['case'] = $case->create_case($info);