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