function Show($obj = '')
{
global $dcl_info, $g_oSec;
if (!$g_oSec->HasPerm(DCL_ENTITY_LOOKUP, $this->mode == DCL_MODE_EDIT ? DCL_PERM_MODIFY : DCL_PERM_ADD)) {
return PrintPermissionDenied();
}
$Template = CreateTemplate(array('hForm' => 'htmlLookup.tpl'));
$Template->set_var('VAL_FORMACTION', menuLink());
$Template->set_var('BTN_SAVE', STR_CMMN_SAVE);
$Template->set_var('BTN_RESET', STR_CMMN_RESET);
$Template->set_var('CMB_ACTIVE', GetYesNoCombo($this->active, 'dcl_lookup_active', 0, false));
$Template->set_var('VAL_NAME', htmlspecialchars($this->name));
$Template->set_var('TXT_NAME', STR_LKP_NAME);
$Template->set_var('TXT_ACTIVE', STR_LKP_ACTIVE);
$Template->set_var('TXT_HIGHLIGHTEDNOTE', STR_CMMN_HIGHLIGHTEDNOTE);
if ($this->mode == DCL_MODE_EDIT) {
$Template->set_var('TXT_TITLE', STR_LKP_EDITTITLE);
$hiddenvars = GetHiddenVar('menuAction', 'boLookup.dbmodify');
$hiddenvars .= GetHiddenVar('dcl_lookup_id', $this->id);
} else {
$Template->set_var('TXT_TITLE', STR_LKP_ADDTITLE);
$hiddenvars = GetHiddenVar('menuAction', 'boLookup.dbadd');
}
$Template->set_var('HIDDEN_VARS', $hiddenvars);
$Template->pparse('out', 'hForm');
}
function showForm($obj = '')
{
global $g_oSec;
$isEdit = is_object($obj);
if (!$g_oSec->HasPerm(DCL_ENTITY_FORMTEMPLATES, $isEdit ? DCL_PERM_MODIFY : DCL_PERM_ADD)) {
return PrintPermissionDenied();
}
$t = CreateSmarty();
if ($isEdit) {
$t->assign('VAL_MENUACTION', 'boChecklistTpl.dbmodify');
$t->assign('CMB_ACTIVE', GetYesNoCombo($obj->dcl_chklst_tpl_active, 'dcl_chklst_tpl_active', 0, false));
$t->assign('VAL_NAME', $obj->dcl_chklst_tpl_name);
$t->assign('VAL_ID', $obj->dcl_chklst_tpl_id);
} else {
$t->assign('VAL_MENUACTION', 'boChecklistTpl.dbadd');
$t->assign('CMB_ACTIVE', GetYesNoCombo('Y', 'dcl_chklst_tpl_active', 0, false));
}
SmartyDisplay($t, 'htmlChklstTplAdd.tpl');
}
function ShowEntryForm($obj = '')
{
global $dcl_info, $g_oSec;
commonHeader();
$isEdit = is_object($obj);
if (!$g_oSec->HasPerm(DCL_ENTITY_PRODUCT, $isEdit ? DCL_PERM_MODIFY : DCL_PERM_ADD, $isEdit ? (int) $obj->id : 0)) {
return PrintPermissionDenied();
}
$t = CreateSmarty();
if ($isEdit) {
$t->assign('TXT_FUNCTION', STR_PROD_EDIT);
$t->assign('menuAction', 'htmlProducts.submitModify');
$t->assign('id', $obj->id);
} else {
$t->assign('TXT_FUNCTION', STR_PROD_ADD);
$t->assign('menuAction', 'htmlProducts.submitAdd');
}
// Data
$objHTMLPersonnel = CreateObject('dcl.htmlPersonnel');
$objHA = CreateObject('dcl.htmlAttributesets');
if ($isEdit) {
$t->assign('CMB_ACTIVE', GetYesNoCombo($obj->active, 'active', 0, false));
$t->assign('CMB_ISVERSIONED', GetYesNoCombo($obj->is_versioned, 'is_versioned', 0, false));
$t->assign('CMB_ISPROJECTREQUIRED', GetYesNoCombo($obj->is_project_required, 'is_project_required', 0, false));
$t->assign('CMB_ISPUBLIC', GetYesNoCombo($obj->is_public, 'is_public', 0, false));
$t->assign('VAL_SHORT', $obj->short);
$t->assign('VAL_NAME', $obj->name);
$t->assign('CMB_REPORTTO', $objHTMLPersonnel->GetCombo($obj->reportto, 'reportto'));
$t->assign('CMB_TICKETSTO', $objHTMLPersonnel->GetCombo($obj->ticketsto, 'ticketsto'));
$t->assign('CMB_WOATTRIBUTESET', $objHA->GetCombo($obj->wosetid, 'wosetid'));
$t->assign('CMB_TCKATTRIBUTESET', $objHA->GetCombo($obj->tcksetid, 'tcksetid'));
} else {
$t->assign('CMB_ACTIVE', GetYesNoCombo('Y', 'active', 0, false));
$t->assign('CMB_ISVERSIONED', GetYesNoCombo('Y', 'is_versioned', 0, false));
$t->assign('CMB_ISPROJECTREQUIRED', GetYesNoCombo('N', 'is_project_required', 0, false));
$t->assign('CMB_ISPUBLIC', GetYesNoCombo('N', 'is_public', 0, false));
$t->assign('CMB_REPORTTO', $objHTMLPersonnel->GetCombo($GLOBALS['DCLID'], 'reportto'));
$t->assign('CMB_TICKETSTO', $objHTMLPersonnel->GetCombo($GLOBALS['DCLID'], 'ticketsto'));
$t->assign('CMB_WOATTRIBUTESET', $objHA->GetCombo(0, 'wosetid'));
$t->assign('CMB_TCKATTRIBUTESET', $objHA->GetCombo(0, 'tcksetid'));
}
SmartyDisplay($t, 'htmlProductsForm.tpl');
}
function Show($oView = '')
{
global $dcl_info, $g_oSec, $g_oSession;
commonHeader();
if (!$g_oSec->HasPerm(DCL_ENTITY_WORKORDER, DCL_PERM_SEARCH)) {
return PrintPermissionDenied();
}
$bView = is_object($oView);
$aProtectedFields = array('notes', 'dcl_hotlist.hotlist_tag', 'is_public', 'timecards.actionby', 'timecards.summary');
$objJS = CreateObject('dcl.jsAttributesets');
$objJS->bModules = true;
$objJS->bStatusTypes = true;
$objJS->bDepartments = !$g_oSec->IsPublicUser();
$objJS->DisplayAttributeScript();
$objPersonnel = CreateObject('dcl.htmlPersonnel');
$objDepartment = CreateObject('dcl.htmlDepartments');
$objProducts = CreateObject('dcl.htmlProducts');
$objPriorities = CreateObject('dcl.htmlPriorities');
$objSeverities = CreateObject('dcl.htmlSeverities');
$objStatuses = CreateObject('dcl.htmlStatuses');
$objProjects = CreateObject('dcl.htmlProjects');
$objModules = CreateObject('dcl.htmlProductModules');
$objType = CreateObject('dcl.htmlWorkOrderType');
$oDBP = CreateObject('dcl.dbPersonnel');
$oDBP->Load($GLOBALS['DCLID']);
$t =& CreateSmarty();
if ($bView) {
$t->assign('VAL_REPORTTITLE', $oView->title);
} else {
$t->assign('VAL_REPORTTITLE', '');
}
$t->assign('VAL_DEPARTMENT', $oDBP->department);
$t->assign('VAL_ID', $GLOBALS['DCLID']);
$aDefault = array();
$aDefault['product'] = array();
$aDefault['priority'] = array();
$aDefault['severity'] = array();
$aDefault['dcl_wo_account.account_id'] = array();
$aDefault['status'] = array();
$aDefault['project'] = array();
$aDefault['wo_type_id'] = array();
$aDefault['statuses.dcl_status_type'] = array();
$aDefault['department'] = array();
$aDefault['personnel'] = array();
$aDefault['is_public'] = array();
$aDefault['entity_source_id'] = array();
$aDefault['module_id'] = array();
$sPersonnelKey = '';
$sStatusKey = '';
$sModuleKey = '';
if ($bView) {
foreach ($oView->filter as $field => $values) {
if (substr($field, 1) == '.department') {
if ($field[0] == 'a') {
$t->assign('CHK_RESPONSIBLE', ' checked');
} else {
if ($field[0] == 'b') {
$t->assign('CHK_CREATEBY', ' checked');
} else {
if ($field[0] == 'c') {
$t->assign('CHK_CLOSEDBY', ' checked');
}
}
}
$field = 'department';
$sPersonnelKey = '';
} else {
if ($field == 'responsible' || $field == 'createby' || $field == 'closedby') {
$t->assign('CHK_' . strtoupper($field), ' checked');
$field = 'personnel';
$sPersonnelKey = '';
} else {
if ($field == 'account') {
$field = 'dcl_wo_account.account_id';
} else {
if ($field == 'dcl_projects.projectid') {
$field = 'project';
}
}
}
}
if (array_key_exists($field, $aDefault)) {
$aDefault[$field] = $values;
}
}
if (isset($aDefault['personnel']) && is_array($aDefault['personnel']) && count($aDefault['personnel']) > 0) {
$sPersonnel = implode(',', $aDefault['personnel']);
$oDBP->Query("select department, id from personnel where id in ({$sPersonnel})");
while ($oDBP->next_record()) {
if (!in_array($oDBP->f(0), $aDefault['department'])) {
$aDefault['department'][] = $oDBP->f(0);
}
if ($sPersonnelKey != '') {
$sPersonnelKey .= ':';
}
$sPersonnelKey .= sprintf('%d,%d', $oDBP->f(0), $oDBP->f(1));
}
}
if (isset($aDefault['status']) && is_array($aDefault['status']) && count($aDefault['status']) > 0) {
$sStatus = implode(',', $aDefault['status']);
$oDBP->Query("select dcl_status_type, id from statuses where id in ({$sStatus})");
while ($oDBP->next_record()) {
if (!in_array($oDBP->f(0), $aDefault['statuses.dcl_status_type'])) {
$aDefault['statuses.dcl_status_type'][] = $oDBP->f(0);
}
if ($sStatusKey != '') {
$sStatusKey .= ':';
}
$sStatusKey .= sprintf('%d,%d', $oDBP->f(0), $oDBP->f(1));
}
}
if (isset($aDefault['module_id']) && is_array($aDefault['module_id']) && count($aDefault['module_id']) > 0) {
$sModule = implode(',', $aDefault['module_id']);
$oDBP->Query("select product_id, product_module_id from dcl_product_module where product_module_id in ({$sModule})");
while ($oDBP->next_record()) {
if (!in_array($oDBP->f(0), $aDefault['product'])) {
$aDefault['product'][] = $oDBP->f(0);
}
if ($sModuleKey != '') {
$sModuleKey .= ':';
}
$sModuleKey .= sprintf('%d,%d', $oDBP->f(0), $oDBP->f(1));
}
}
} else {
$aDefault['product'] = 0;
$aDefault['priority'] = 0;
$aDefault['severity'] = 0;
$aDefault['dcl_wo_account.account_id'] = 0;
$aDefault['status'] = 0;
$aDefault['project'] = 0;
$aDefault['wo_type_id'] = 0;
$aDefault['entity_source_id'] = 0;
$aDefault['is_public'] = 0;
$aDefault['statuses.dcl_status_type'] = 1;
$aDefault['department'] = array($oDBP->department);
$aDefault['personnel'] = $GLOBALS['DCLID'];
$sPersonnelKey = sprintf('%d,%d', $oDBP->department, $GLOBALS['DCLID']);
$sStatusKey = '';
$sModuleKey = '';
if ($GLOBALS['g_oSec']->HasPerm(DCL_ENTITY_WORKORDER, DCL_PERM_ACTION)) {
$t->assign('CHK_RESPONSIBLE', ' checked');
$t->assign('CHK_CREATEBY', '');
$t->assign('CHK_CLOSEDBY', '');
} else {
$t->assign('CHK_CREATEBY', ' checked');
$t->assign('CHK_RESPONSIBLE', '');
$t->assign('CHK_CLOSEDBY', '');
}
}
$t->assign('VAL_DEPARTMENTS', $aDefault['department']);
$t->assign('VAL_PERSONNEL', $aDefault['personnel']);
$t->assign('VAL_WO_TYPE', $aDefault['wo_type_id']);
$t->assign('VAL_PRODUCT', $aDefault['product']);
$t->assign('VAL_MODULE', $aDefault['module_id']);
$t->assign('VAL_PRIORITY', $aDefault['priority']);
$t->assign('VAL_SEVERITY', $aDefault['severity']);
$t->assign('VAL_SELECTPERSONNELKEY', $sPersonnelKey);
$t->assign('VAL_SELECTSTATUSKEY', $sStatusKey);
$t->assign('VAL_SELECTMODULEKEY', $sModuleKey);
$t->assign('CMB_STATUSES', $objStatuses->GetCombo($aDefault['status'], 'status', 'name', 8));
$t->assign('IS_PUBLIC', $g_oSec->IsPublicUser());
if (!$g_oSec->IsPublicUser()) {
$t->assign('CMB_PROJECTS', $objProjects->GetCombo($aDefault['project'], 'project', 'name', 8));
$t->assign('CMB_PUBLIC', GetYesNoCombo($aDefault['is_public'], 'is_public', 2, false));
}
$oSelect =& CreateObject('dcl.htmlSelect');
if ($g_oSec->IsOrgUser()) {
$oSelect->SetOptionsFromDb('dcl_org', 'org_id', 'name', 'org_id IN (' . $g_oSession->Value('member_of_orgs') . ')', 'name');
} else {
$oSelect->SetOptionsFromDb('dcl_org', 'org_id', 'name', '', 'name');
}
$oSelect->iSize = 8;
$oSelect->vDefault = $aDefault['dcl_wo_account.account_id'];
$oSelect->sName = 'account';
$t->assign('CMB_ACCOUNTS', $oSelect->GetHTML());
$oSource = CreateObject('dcl.htmlEntitySource');
$t->assign('CMB_SOURCE', $oSource->GetCombo($aDefault['entity_source_id'], 'entity_source_id', 8, false));
// Empty status is for selecting status type, then filtering status if desired
$oSelect->sName = 'status';
$oSelect->iSize = 8;
$t->assign('CMB_STATUSESEMPTY', $oSelect->GetHTML());
// Status Types
$oSelect->sName = 'dcl_status_type';
$oSelect->iSize = 8;
$oSelect->vDefault = $aDefault['statuses.dcl_status_type'];
$oSelect->SetOptionsFromDb('dcl_status_type', 'dcl_status_type_id', 'dcl_status_type_name', '', 'dcl_status_type_id');
$t->assign('CMB_STATUSTYPES', $oSelect->GetHTML());
$t->assign('CHK_SUMMARY', '');
$t->assign('CHK_NOTES', '');
$t->assign('CHK_DESCRIPTION', '');
$t->assign('VAL_SEARCHTEXT', '');
if ($bView && count($oView->filterlike) > 0) {
$searchText = '';
foreach ($oView->filterlike as $field => $values) {
if ($field == 'summary' || $field == 'notes' || $field == 'description') {
$t->assign('CHK_' . strtoupper($field), ' CHECKED');
$searchText = $values[0];
}
}
$t->assign('VAL_SEARCHTEXT', $searchText);
}
if (isset($oView->filter['dcl_tag.tag_desc']) && is_array($oView->filter['dcl_tag.tag_desc']) && count($oView->filter['dcl_tag.tag_desc']) > 0) {
$t->assign('VAL_TAGS', join(',', $oView->filter['dcl_tag.tag_desc']));
}
if (isset($oView->filter['dcl_hotlist.hotlist_tag']) && is_array($oView->filter['dcl_hotlist.hotlist_tag']) && count($oView->filter['dcl_hotlist.hotlist_tag']) > 0) {
$t->assign('VAL_HOTLISTS', join(',', $oView->filter['dcl_hotlist.hotlist_tag']));
}
$aDateChecks = array('createdon', 'closedon', 'statuson', 'lastactionon', 'deadlineon', 'eststarton', 'estendon', 'starton');
for ($i = 0; $i < count($aDateChecks); $i++) {
$t->assign('CHK_' . strtoupper($aDateChecks[$i]), '');
}
if ($bView) {
$t->assign('VAL_DATEFROM', '');
$t->assign('VAL_DATETO', '');
if (count($oView->filterdate) > 0) {
$fromDate = '';
$toDate = '';
foreach ($oView->filterdate as $field => $values) {
$t->assign('CHK_' . strtoupper($field), ' CHECKED');
$fromDate = $values[0];
$toDate = $values[1];
}
$t->assign('VAL_DATEFROM', $fromDate);
$t->assign('VAL_DATETO', $toDate);
}
} else {
$aFewDaysAgo = mktime(0, 0, 0, date('m'), date('d') - 3, date('Y'));
$t->assign('VAL_DATEFROM', date($dcl_info['DCL_DATE_FORMAT'], $aFewDaysAgo));
$t->assign('VAL_DATETO', date($dcl_info['DCL_DATE_FORMAT']));
}
$aCols = array('jcn' => STR_WO_JCN, 'seq' => STR_WO_SEQ, 'dcl_wo_type.type_name' => STR_WO_TYPE, 'responsible.short' => STR_WO_RESPONSIBLE, 'products.name' => STR_WO_PRODUCT, 'statuses.name' => STR_WO_STATUS, 'summary' => STR_WO_SUMMARY, 'dcl_product_module.module_name' => STR_CMMN_MODULE, 'dcl_projects.name' => STR_WO_PROJECT, 'dcl_org.name' => STR_WO_ACCOUNT, 'count(*):dcl_org' => '# ' . STR_WO_ACCOUNT, 'dcl_tag.tag_desc' => STR_CMMN_TAGS, 'dcl_hotlist.hotlist_tag' => 'Hotlists', 'createby.short' => STR_WO_OPENBY, 'createdon' => STR_WO_OPENEDON, 'closedby.short' => STR_WO_CLOSEBY, 'closedon' => STR_WO_CLOSEDON, 'statuson' => STR_WO_STATUSON, 'lastactionon' => STR_WO_LASTACTION, 'deadlineon' => STR_WO_DEADLINE, 'eststarton' => STR_WO_ESTSTART, 'estendon' => STR_WO_ESTEND, 'starton' => STR_WO_START, 'esthours' => STR_WO_ESTHOURS, 'etchours' => STR_WO_ETCHOURS, 'totalhours' => STR_WO_ACTHOURS, 'priorities.name' => STR_WO_PRIORITY, 'severities.name' => STR_WO_SEVERITY, 'reported_version_id.product_version_text' => STR_WO_REVISION, 'targeted_version_id.product_version_text' => 'Target Version', 'fixed_version_id.product_version_text' => 'Fixed Version', 'dcl_contact.last_name' => 'Contact Last Name', 'dcl_contact.first_name' => 'Contact First Name', 'dcl_contact_phone.phone_number' => STR_WO_CONTACTPHONE, 'notes' => STR_WO_NOTES, 'description' => STR_WO_DESCRIPTION, 'dcl_status_type.dcl_status_type_name' => STR_CMMN_STATUSTYPE, 'dcl_entity_source.entity_source_name' => STR_CMMN_SOURCE, 'is_public' => STR_CMMN_PUBLIC, 'actionby.short' => 'Last Time Card By', 'timecards.summary' => 'Last Time Card Summary');
if ($g_oSec->IsPublicUser()) {
foreach ($aProtectedFields as $sField) {
unset($aCols[$sField]);
}
}
if ($bView) {
$aShow = array();
$aGroup = array();
foreach ($oView->columns as $colName) {
if ($colName == 'a.short') {
$colName = 'responsible.short';
} else {
if ($colName == 'b.short') {
$colName = 'closedby.short';
} else {
if ($colName == 'c.short') {
$colName = 'createby.short';
} else {
if ($colName == 'g.short') {
$colName = 'actionby.short';
}
}
}
}
$aShow[$colName] = $aCols[$colName];
}
foreach ($oView->groups as $colName) {
if ($colName == 'a.short') {
$colName = 'responsible.short';
} else {
if ($colName == 'b.short') {
$colName = 'closedby.short';
} else {
if ($colName == 'c.short') {
$colName = 'createby.short';
} else {
if ($colName == 'g.short') {
$colName = 'actionby.short';
}
}
}
}
$aGroup[$colName] = $aCols[$colName];
}
if ($g_oSec->IsPublicUser()) {
foreach ($aProtectedFields as $sField) {
if (isset($aShow[$sField])) {
unset($aShow[$sField]);
}
if (isset($aGroup[$sField])) {
unset($aGroup[$sField]);
}
}
}
} else {
$aShow = array('jcn' => STR_WO_JCN, 'seq' => STR_WO_SEQ, 'dcl_wo_type.type_name' => STR_WO_TYPE, 'responsible.short' => STR_WO_RESPONSIBLE, 'products.name' => STR_WO_PRODUCT, 'statuses.name' => STR_WO_STATUS, 'summary' => STR_WO_SUMMARY);
$aGroup = array();
}
array_remove_keys($aCols, $aShow);
array_remove_keys($aCols, $aGroup);
$t->assign('VAL_COLS', $aCols);
$t->assign('VAL_SHOW', $aShow);
$t->assign('VAL_GROUP', $aGroup);
if ($bView) {
$aOrder = array();
foreach ($oView->order as $val) {
if ($val == 'priorities.weight') {
$sText = isset($aShow['priorities.name']) ? $aShow['priorities.name'] : $aCols['priorities.name'];
} else {
if ($val == 'severities.weight') {
$sText = isset($aShow['severities.name']) ? $aShow['severities.name'] : $aCols['severities.name'];
} else {
if (isset($aShow[$val])) {
$sText = $aShow[$val];
} else {
if (isset($aCols[$val])) {
$sText = $aCols[$val];
}
}
}
}
array_push($aOrder, array($val => $sText));
}
$t->assign('VAL_SORT');
}
SmartyDisplay($t, 'htmlWorkOrderSearch.tpl');
}
function ShowEntryForm($obj = '')
{
global $dcl_info, $g_oSec;
$isEdit = is_object($obj);
if (!$g_oSec->HasPerm(DCL_ENTITY_WORKORDERTYPE, $isEdit ? DCL_PERM_MODIFY : DCL_PERM_ADD)) {
return PrintPermissionDenied();
}
$t = CreateSmarty();
$t->assign('IS_EDIT', $isEdit);
if ($isEdit) {
if (($wo_type_id = DCL_Sanitize::ToInt($_REQUEST['wo_type_id'])) === null) {
trigger_error('Data sanitize failed.');
return;
}
$t->assign('VAL_WO_TYPE_ID', $wo_type_id);
}
$t->assign('URL_BACK', menuLink('', 'menuAction=htmlWorkOrderType.ShowAll'));
// Data
if ($isEdit) {
$t->assign('CMB_ACTIVE', GetYesNoCombo($obj->active, 'active', 0, false));
$t->assign('VAL_NAME', $obj->type_name);
} else {
$t->assign('CMB_ACTIVE', GetYesNoCombo('Y', 'active', 0, false));
$t->assign('VAL_NAME', '');
}
SmartyDisplay($t, 'htmlWorkOrderTypeForm.tpl');
}
function Show($oView = '')
{
global $dcl_info, $g_oSec, $g_oSession;
commonHeader();
$bView = is_object($oView);
$objJS =& CreateObject('dcl.jsAttributesets');
$objJS->bModules = true;
$objJS->bStatusTypes = true;
$objJS->bDepartments = !$g_oSec->IsPublicUser();
$objJS->DisplayAttributeScript();
$oSelect =& CreateObject('dcl.htmlSelect');
$objPersonnel =& CreateObject('dcl.htmlPersonnel');
$objProducts =& CreateObject('dcl.htmlProducts');
$objPriorities =& CreateObject('dcl.htmlPriorities');
$objSeverities =& CreateObject('dcl.htmlSeverities');
$objStatuses =& CreateObject('dcl.htmlStatuses');
$objDepartment =& CreateObject('dcl.htmlDepartments');
$objModules =& CreateObject('dcl.htmlProductModules');
$oDBP =& CreateObject('dcl.dbPersonnel');
$oDBP->Load($GLOBALS['DCLID']);
$t =& CreateSmarty();
if ($bView) {
$t->assign('VAL_REPORTTITLE', $oView->title);
} else {
$t->assign('VAL_REPORTTITLE', '');
}
$t->assign('VAL_DEPARTMENT', $oDBP->department);
$t->assign('VAL_ID', $GLOBALS['DCLID']);
$aDefault = array();
$aDefault['product'] = array();
$aDefault['module_id'] = array();
$aDefault['priority'] = array();
$aDefault['type'] = array();
$aDefault['account'] = array();
$aDefault['status'] = array();
$aDefault['statuses.dcl_status_type'] = array();
$aDefault['department'] = array();
$aDefault['personnel'] = array();
$aDefault['entity_source_id'] = array();
$aDefault['is_public'] = array();
$sPersonnelKey = '';
$sStatusKey = '';
$sModuleKey = '';
if ($bView) {
reset($oView->filter);
while (list($field, $values) = each($oView->filter)) {
if (substr($field, 1) == '.department') {
if ($field[0] == 'a') {
$t->assign('CHK_RESPONSIBLE', ' checked');
} else {
if ($field[0] == 'b') {
$t->assign('CHK_CREATEDBY', ' checked');
} else {
if ($field[0] == 'c') {
$t->assign('CHK_CLOSEDBY', ' checked');
}
}
}
$field = 'department';
$sPersonnelKey = '';
} else {
if ($field == 'responsible' || $field == 'createdby' || $field == 'closedby') {
$t->assign('CHK_' . strtoupper($field), ' checked');
$field = 'personnel';
$sPersonnelKey = '';
}
}
if (array_key_exists($field, $aDefault)) {
$aDefault[$field] = $values;
}
}
if (is_array($aDefault['personnel']) && count($aDefault['personnel']) > 0) {
$sPersonnel = implode(',', $aDefault['personnel']);
$oDBP->Query("select department, id from personnel where id in ({$sPersonnel})");
while ($oDBP->next_record()) {
if (!in_array($oDBP->f(0), $aDefault['department'])) {
$aDefault['department'][] = $oDBP->f(0);
}
if ($sPersonnelKey != '') {
$sPersonnelKey .= ':';
}
$sPersonnelKey .= sprintf('%d,%d', $oDBP->f(0), $oDBP->f(1));
}
}
if (is_array($aDefault['status']) && count($aDefault['status']) > 0) {
$sStatus = implode(',', $aDefault['status']);
$oDBP->Query("select dcl_status_type, id from statuses where id in ({$sStatus})");
while ($oDBP->next_record()) {
if (!in_array($oDBP->f(0), $aDefault['statuses.dcl_status_type'])) {
$aDefault['statuses.dcl_status_type'][] = $oDBP->f(0);
}
if ($sStatusKey != '') {
$sStatusKey .= ':';
}
$sStatusKey .= sprintf('%d,%d', $oDBP->f(0), $oDBP->f(1));
}
}
if (is_array($aDefault['module_id']) && count($aDefault['module_id']) > 0) {
$sModule = implode(',', $aDefault['module_id']);
$oDBP->Query("select product_id, product_module_id from dcl_product_module where product_module_id in ({$sModule})");
while ($oDBP->next_record()) {
if (!in_array($oDBP->f(0), $aDefault['product'])) {
$aDefault['product'][] = $oDBP->f(0);
}
if ($sModuleKey != '') {
$sModuleKey .= ':';
}
$sModuleKey .= sprintf('%d,%d', $oDBP->f(0), $oDBP->f(1));
}
}
} else {
$aDefault['product'] = 0;
$aDefault['priority'] = 0;
$aDefault['type'] = 0;
$aDefault['account'] = 0;
$aDefault['status'] = 0;
$aDefault['project'] = 0;
$aDefault['entity_source_id'] = 0;
$aDefault['statuses.dcl_status_type'] = 1;
$aDefault['department'] = array($oDBP->department);
$aDefault['personnel'] = $GLOBALS['DCLID'];
$aDefault['is_public'] = '';
$sPersonnelKey = sprintf('%d,%d', $oDBP->department, $GLOBALS['DCLID']);
$sStatusKey = '';
$sModuleKey = '';
if ($g_oSec->HasPerm(DCL_ENTITY_TICKET, DCL_PERM_ACTION)) {
$t->assign('CHK_RESPONSIBLE', ' checked');
$t->assign('CHK_CREATEBY', '');
$t->assign('CHK_CLOSEDBY', '');
} else {
$t->assign('CHK_CREATEBY', ' checked');
$t->assign('CHK_RESPONSIBLE', '');
$t->assign('CHK_CLOSEDBY', '');
}
}
$t->assign('VAL_DEPARTMENTS', $aDefault['department']);
$t->assign('VAL_PERSONNEL', $aDefault['personnel']);
$t->assign('VAL_PRODUCT', $aDefault['product']);
$t->assign('VAL_MODULE', $aDefault['module_id']);
$t->assign('VAL_PRIORITY', $aDefault['priority']);
$t->assign('VAL_TYPE', $aDefault['type']);
$t->assign('VAL_SELECTPERSONNELKEY', $sPersonnelKey);
$t->assign('VAL_SELECTSTATUSKEY', $sStatusKey);
$t->assign('VAL_SELECTMODULEKEY', $sModuleKey);
$t->assign('CMB_STATUS', $objStatuses->GetCombo($aDefault['status'], 'status', 'name', 8));
$t->assign('IS_PUBLIC', $g_oSec->IsPublicUser());
if (!$g_oSec->IsPublicUser()) {
$t->assign('CMB_PUBLIC', GetYesNoCombo($aDefault['is_public'], 'is_public', 3));
}
if ($g_oSec->IsOrgUser()) {
$oSelect->SetOptionsFromDb('dcl_org', 'org_id', 'name', 'org_id IN (' . $g_oSession->Value('member_of_orgs') . ')', 'name');
} else {
$oSelect->SetOptionsFromDb('dcl_org', 'org_id', 'name', '', 'name');
}
$oSelect->iSize = 8;
$oSelect->vDefault = $aDefault['account'];
$oSelect->sName = 'account';
$t->assign('CMB_ACCOUNTS', $oSelect->GetHTML());
$oSource = CreateObject('dcl.htmlEntitySource');
$t->assign('CMB_SOURCE', $oSource->GetCombo($aDefault['entity_source_id'], 'entity_source_id', 8, false));
// Modules only show for selected products
$oSelect->aOptions = array();
$oSelect->sName = 'module_id';
$oSelect->iSize = 8;
$t->assign('CMB_MODULES', $oSelect->GetHTML());
// Empty status is for selecting status type, then filtering status if desired
$oSelect->sName = 'status';
$oSelect->iSize = 8;
$t->assign('CMB_STATUSESEMPTY', $oSelect->GetHTML());
// Status Types
$oSelect->sName = 'dcl_status_type';
$oSelect->iSize = 8;
$oSelect->vDefault = $aDefault['statuses.dcl_status_type'];
$oSelect->SetOptionsFromDb('dcl_status_type', 'dcl_status_type_id', 'dcl_status_type_name', '', 'dcl_status_type_id');
$t->assign('CMB_STATUSTYPES', $oSelect->GetHTML());
if ($g_oSec->HasPerm(DCL_ENTITY_TICKET, DCL_PERM_ACTION)) {
$t->assign('CHK_SECLVLWO', ' CHECKED');
$t->assign('CHK_NOSECLVLWO', '');
} else {
$t->assign('CHK_SECLVLWO', '');
$t->assign('CHK_NOSECLVLWO', ' CHECKED');
}
$t->assign('VAL_SEARCHTEXT', '');
if ($bView && count($oView->filterlike) > 0) {
$searchText = '';
foreach ($oView->filterlike as $field => $values) {
$searchText = $values[0];
}
$t->assign('VAL_SEARCHTEXT', $searchText);
}
if (isset($oView->filter['dcl_tag.tag_desc']) && is_array($oView->filter['dcl_tag.tag_desc']) && count($oView->filter['dcl_tag.tag_desc']) > 0) {
$t->assign('VAL_TAGS', join(',', $oView->filter['dcl_tag.tag_desc']));
}
$aDateChecks = array('createdon', 'closedon', 'statuson', 'lastactionon');
for ($i = 0; $i < count($aDateChecks); $i++) {
$t->assign('CHK_' . strtoupper($aDateChecks[$i]), '');
}
if ($bView) {
$t->assign('VAL_DATEFROM', '');
$t->assign('VAL_DATETO', '');
if (count($oView->filterdate) > 0) {
$fromDate = '';
$toDate = '';
reset($oView->filterdate);
while (list($field, $values) = each($oView->filterdate)) {
$t->assign('CHK_' . strtoupper($field), ' CHECKED');
$fromDate = $values[0];
$toDate = $values[1];
}
$t->assign('VAL_DATEFROM', $fromDate);
$t->assign('VAL_DATETO', $toDate);
}
} else {
$aFewDaysAgo = mktime(0, 0, 0, date('m'), date('d') - 3, date('Y'));
$t->assign('VAL_DATEFROM', date($dcl_info['DCL_DATE_FORMAT'], $aFewDaysAgo));
$t->assign('VAL_DATETO', date($dcl_info['DCL_DATE_FORMAT']));
}
$aCols = array('ticketid' => STR_TCK_TICKET . '#', 'responsible.short' => STR_TCK_RESPONSIBLE, 'products.name' => STR_TCK_PRODUCT, 'dcl_org.name' => STR_TCK_ACCOUNT, 'statuses.name' => STR_TCK_STATUS, 'summary' => STR_TCK_SUMMARY, 'dcl_product_module.module_name' => STR_CMMN_MODULE, 'dcl_tag.tag_desc' => STR_CMMN_TAGS, 'version' => STR_TCK_VERSION, 'createdby.short' => STR_TCK_OPENEDBY, 'createdon' => STR_TCK_OPENEDON, 'closedby.short' => STR_TCK_CLOSEDBY, 'closedon' => STR_TCK_CLOSEDON, 'statuson' => STR_TCK_STATUSON, 'lastactionon' => STR_TCK_LASTACTIONON, 'priorities.name' => STR_TCK_PRIORITY, 'severities.name' => STR_TCK_TYPE, 'dcl_contact.last_name' => 'Contact Last Name', 'dcl_contact.first_name' => 'Contact First Name', 'dcl_contact_phone.phone_number' => STR_TCK_CONTACTPHONE, 'dcl_contact_email.email_addr' => STR_TCK_CONTACTEMAIL, 'issue' => STR_TCK_ISSUE, 'seconds' => STR_TCK_APPROXTIME, 'dcl_status_type.dcl_status_type_name' => STR_CMMN_STATUSTYPE, 'dcl_entity_source.entity_source_name' => 'Source', 'is_public' => 'Public');
if ($bView) {
$aShow = array();
$aGroup = array();
foreach ($oView->columns as $colName) {
if ($colName == 'a.short') {
$colName = 'responsible.short';
} else {
if ($colName == 'b.short') {
$colName = 'closedby.short';
} else {
if ($colName == 'c.short') {
$colName = 'createdby.short';
}
}
}
$aShow[$colName] = $aCols[$colName];
}
foreach ($oView->groups as $colName) {
if ($colName == 'a.short') {
$colName = 'responsible.short';
} else {
if ($colName == 'b.short') {
$colName = 'closedby.short';
} else {
if ($colName == 'c.short') {
$colName = 'createdby.short';
}
}
}
$aGroup[$colName] = $aCols[$colName];
}
} else {
$aShow = array('ticketid' => STR_TCK_TICKET . '#', 'responsible.short' => STR_TCK_RESPONSIBLE, 'products.name' => STR_TCK_PRODUCT, 'dcl_org.name' => STR_TCK_ACCOUNT, 'statuses.name' => STR_TCK_STATUS, 'summary' => STR_TCK_SUMMARY);
$aGroup = array();
}
array_remove_keys($aCols, $aShow);
array_remove_keys($aCols, $aGroup);
$t->assign('VAL_COLS', $aCols);
$t->assign('VAL_SHOW', $aShow);
$t->assign('VAL_GROUP', $aGroup);
if ($bView) {
$aOrder = array();
foreach ($oView->order as $val) {
if ($val == 'priorities.weight') {
$sText = $aShow['priorities.name'];
} else {
if ($val == 'severities.weight') {
$sText = $aShow['severities.name'];
} else {
$sText = $aShow[$val];
}
}
array_push($aOrder, array($val => $sText));
}
$t->assign('VAL_SORT');
}
SmartyDisplay($t, 'htmlTicketSearch.tpl');
}
function ShowEntryForm($obj = '')
{
global $dcl_info, $g_oSec;
$isEdit = is_object($obj);
if (!$g_oSec->HasPerm(DCL_ENTITY_STATUS, $isEdit ? DCL_PERM_MODIFY : DCL_PERM_ADD)) {
return PrintPermissionDenied();
}
$t = CreateSmarty();
$oSelect = CreateObject('dcl.htmlSelect');
$oSelect->SetOptionsFromDb('dcl_status_type', 'dcl_status_type_id', 'dcl_status_type_name', '', $order = 'dcl_status_type_id');
$oSelect->vDefault = 0;
$oSelect->sName = 'dcl_status_type';
$oSelect->sZeroOption = STR_CMMN_SELECTONE;
if ($isEdit) {
$t->assign('TXT_FUNCTION', STR_STAT_EDIT);
$t->assign('menuAction', 'boStatuses.dbmodify');
$t->assign('id', $obj->id);
$t->assign('CMB_ACTIVE', GetYesNoCombo($obj->active, 'active', 0, false));
$t->assign('VAL_SHORT', $obj->short);
$t->assign('VAL_NAME', $obj->name);
$oSelect->vDefault = $obj->dcl_status_type;
} else {
$t->assign('TXT_FUNCTION', STR_STAT_ADD);
$t->assign('menuAction', 'boStatuses.dbadd');
$t->assign('CMB_ACTIVE', GetYesNoCombo('Y', 'active', 0, false));
}
$t->assign('CMB_TYPE', $oSelect->GetHtml());
SmartyDisplay($t, 'htmlStatusesForm.tpl');
}
function ShowEntryForm()
{
global $dcl_info, $g_oSec;
if (!$g_oSec->HasPerm(DCL_ENTITY_SAVEDSEARCH, DCL_PERM_ADD)) {
return PrintPermissionDenied();
}
$Template = CreateTemplate(array('hForm' => 'htmlViewForm.tpl'));
$Template->set_var('TXT_TITLE', STR_VW_ADDVIEW);
$Template->set_var('TXT_PUBLIC', STR_VW_PUBLIC);
$Template->set_var('TXT_NAME', STR_VW_NAME);
$Template->set_var('BTN_SAVE', STR_CMMN_SAVE);
$Template->set_var('BTN_RESET', STR_CMMN_RESET);
$Template->set_var('TXT_HIGHLIGHTEDNOTE', STR_CMMN_HIGHLIGHTEDNOTE);
$Template->set_var('VAL_FORMACTION', menuLink());
$Template->set_var('BTN_CANCEL', STR_CMMN_CANCEL);
$Template->set_var('VAL_DCLID', $GLOBALS['DCLID']);
$Template->set_var('VAL_TABLENAME', $_REQUEST['vt']);
// Add the URL pieces
$viewUrl = '';
$objView = CreateObject("dcl.boView");
$o = CreateObject('dcl.dbPersonnel');
while (list($key, $val) = each($objView->urlpieces)) {
if (isset($_REQUEST[$val])) {
$viewUrl .= sprintf('<input type="hidden" name="%s" value="%s">', $val, htmlspecialchars($o->GPCStripSlashes($_REQUEST[$val])));
}
}
$Template->set_var('VAL_VIEWURL', $viewUrl);
$Template->set_var('CMB_ISPUBLIC', GetYesNoCombo("N", "ispublic", 0, false));
$Template->pparse('out', 'hForm');
}
function ShowEntryForm($obj = '')
{
global $dcl_info, $g_oSec;
$isEdit = is_object($obj);
if (!$g_oSec->HasPerm(DCL_ENTITY_ATTRIBUTESETS, $isEdit ? DCL_PERM_MODIFY : DCL_PERM_ADD)) {
return PrintPermissionDenied();
}
$t = CreateSmarty();
if ($isEdit) {
$t->assign('TXT_FUNCTION', STR_ATTR_EDITATTRIBUTESET);
$t->assign('menuAction', 'boAttributesets.dbmodify');
$t->assign('id', $obj->id);
$t->assign('CMB_ACTIVE', GetYesNoCombo($obj->active, 'active', 0, false));
$t->assign('VAL_SHORT', $obj->short);
$t->assign('VAL_NAME', $obj->name);
} else {
$t->assign('TXT_FUNCTION', STR_ATTR_ADDATTRIBUTESET);
$t->assign('menuAction', 'boAttributesets.dbadd');
$t->assign('CMB_ACTIVE', GetYesNoCombo('Y', 'active', 0, false));
}
SmartyDisplay($t, 'htmlAttributesetsForm.tpl');
}
function ShowEntryForm($obj = '')
{
global $dcl_info, $g_oSec;
commonHeader();
$isEdit = is_object($obj);
if (!$g_oSec->HasPerm(DCL_ENTITY_SOURCE, $isEdit ? DCL_PERM_MODIFY : DCL_PERM_ADD)) {
return PrintPermissionDenied();
}
if ($isEdit && ($id = DCL_Sanitize::ToInt($_REQUEST['entity_source_id'])) === null) {
trigger_error('Data sanitize failed.');
return;
}
$t = CreateSmarty();
if ($isEdit) {
$t->assign('TXT_FUNCTION', 'Edit Entity Source');
$t->assign('menuAction', 'htmlEntitySource.submitModify');
$t->assign('entity_source_id', $id);
$t->assign('CMB_ACTIVE', GetYesNoCombo($obj->active, 'active', 0, false));
$t->assign('VAL_NAME', $obj->entity_source_name);
} else {
$t->assign('TXT_FUNCTION', 'Add Entity Source');
$t->assign('menuAction', 'htmlEntitySource.submitAdd');
$t->assign('CMB_ACTIVE', GetYesNoCombo('Y', 'active', 0, false));
}
SmartyDisplay($t, 'htmlEntitySourceForm.tpl');
}
function ShowEntryForm($obj = '')
{
global $dcl_info, $g_oSec;
$isEdit = is_object($obj);
if (!$g_oSec->HasPerm(DCL_ENTITY_PRODUCTMODULE, $isEdit ? DCL_PERM_MODIFY : DCL_PERM_ADD)) {
return PrintPermissionDenied();
}
if ($isEdit) {
if (($product_module_id = DCL_Sanitize::ToInt($_REQUEST['product_module_id'])) === null) {
trigger_error('Data sanitize failed.');
return;
}
} else {
if (($product_id = DCL_Sanitize::ToInt($_REQUEST['product_id'])) === null) {
trigger_error('Data sanitize failed.');
return;
}
}
$oProduct = CreateObject('dcl.dbProducts');
$iProductID = $isEdit ? $obj->product_id : $product_id;
if ($oProduct->Load($iProductID) == -1) {
printf('Could not load product by id %d', $product_id);
return;
}
$t = CreateSmarty();
$t->assign('product_id', $iProductID);
if ($isEdit) {
$t->assign('TXT_FUNCTION', 'Edit Module for Product ' . $oProduct->name);
$t->assign('menuAction', 'htmlProductModules.submitModify');
$t->assign('product_module_id', $product_module_id);
$t->assign('CMB_ACTIVE', GetYesNoCombo($obj->active, 'active', 0, false));
$t->assign('VAL_NAME', $obj->module_name);
} else {
$t->assign('TXT_FUNCTION', 'Add Module for Product ' . $oProduct->name);
$t->assign('menuAction', 'htmlProductModules.submitAdd');
$t->assign('CMB_ACTIVE', GetYesNoCombo('Y', 'active', 0, false));
}
SmartyDisplay($t, 'htmlProductModulesForm.tpl');
}
