<?php // $Id: timeSpentByDept.php,v 1.9 2006/02/06 19:58:23 eric_juden Exp $ include_once XHELP_JPGRAPH_PATH . '/jpgraph.php'; include_once XHELP_CLASS_PATH . '/report.php'; xhelpIncludeReportLangFile('timeSpentByDept'); global $xoopsDB, $paramVals; $startDate = date('m/d/y h:i:s A', mktime(0, 0, 0, date("m") - 1, date("d"), date("Y"))); $endDate = date('m/d/y') . " 12:00:00 AM"; // Cannot fill date values in class...have to fill these values later $paramVals = array('startDate' => isset($_REQUEST['startDate']) && $_REQUEST['startDate'] != '' ? $_REQUEST['startDate'] : $startDate, 'endDate' => isset($_REQUEST['endDate']) && $_REQUEST['endDate'] != '' ? $_REQUEST['endDate'] : $endDate); class xhelpTimeSpentByDeptReport extends xhelpReport { function xhelpTimeSpentByDeptReport() { $this->initVar('results', XOBJ_DTYPE_ARRAY, null, false); $this->initVar('hasResults', XOBJ_DTYPE_INT, 0, false); $this->initVar('hasGraph', XOBJ_DTYPE_INT, 1, false); } var $name = 'timeSpentByDept'; var $meta = array('name' => _XHELP_TSBD_NAME, 'author' => 'Eric Juden', 'authorEmail' => '*****@*****.**', 'description' => _XHELP_TSBD_DESC, 'version' => '1.0', 'dbFields' => array('department' => _XHELP_TSBD_DB1, 'TotalTime' => _XHELP_TSBD_DB2)); var $parameters = array(_XHELP_TSBD_PARAM1 => array('controltype' => XHELP_CONTROL_DATETIME, 'fieldname' => 'startDate', 'value' => '', 'values' => '', 'fieldlength' => 25, 'dbfield' => 'r.updateTime', 'dbaction' => '>'), _XHELP_TSBD_PARAM2 => array('controltype' => XHELP_CONTROL_DATETIME, 'fieldname' => 'endDate', 'value' => '', 'values' => '', 'fieldlength' => 25, 'dbfield' => 'r.updateTime', 'dbaction' => '<=')); /* function generateReport() { global $paramVals; if($this->getVar('hasResults') == 0){ $this->_setResults(); } $aResults = $this->getVar('results');
<?php // $Id: unresolvedTicketsByDept.php,v 1.6 2006/02/06 19:58:23 eric_juden Exp $ include_once XHELP_JPGRAPH_PATH . '/jpgraph.php'; include_once XHELP_CLASS_PATH . '/report.php'; xhelpIncludeReportLangFile('unresolvedTicketsByDept'); global $xoopsDB, $paramVals; $startDate = date('m/d/y h:i:s A', mktime(0, 0, 0, date("m") - 1, date("d"), date("Y"))); $endDate = date('m/d/y') . " 12:00:00 AM"; // Cannot fill date values in class...have to fill these values later $paramVals = array('startDate' => isset($_REQUEST['startDate']) && $_REQUEST['startDate'] != '' ? $_REQUEST['startDate'] : $startDate, 'endDate' => isset($_REQUEST['endDate']) && $_REQUEST['endDate'] != '' ? $_REQUEST['endDate'] : $endDate); class xhelpUnresolvedTicketsByDeptReport extends xhelpReport { function xhelpUnresolvedTicketsByDeptReport() { $this->initVar('results', XOBJ_DTYPE_ARRAY, null, false); $this->initVar('hasResults', XOBJ_DTYPE_INT, 0, false); $this->initVar('hasGraph', XOBJ_DTYPE_INT, 1, false); } var $name = 'unresolvedTicketsByDept'; var $meta = array('name' => _XHELP_UTBD_NAME, 'author' => 'Eric Juden', 'authorEmail' => '*****@*****.**', 'description' => _XHELP_UTBD_DESC, 'version' => '1.0', 'dbFields' => array('department' => _XHELP_UTBD_DB1, 'id' => _XHELP_UTBD_DB2, 'subject' => _XHELP_UTBD_DB3, 'status' => _XHELP_UTBD_DB4, 'totalTimeSpent' => _XHELP_UTBD_DB5, 'postTime' => _XHELP_UTBD_DB6)); var $parameters = array(_XHELP_UTBD_PARAM1 => array('controltype' => XHELP_CONTROL_DATETIME, 'fieldname' => 'startDate', 'value' => '', 'values' => '', 'fieldlength' => 25, 'dbfield' => 't.posted', 'dbaction' => '>'), _XHELP_UTBD_PARAM2 => array('controltype' => XHELP_CONTROL_DATETIME, 'fieldname' => 'endDate', 'value' => '', 'values' => '', 'fieldlength' => 25, 'dbfield' => 't.posted', 'dbaction' => '<=')); /* function generateReport() { global $paramVals; if($this->getVar('hasResults') == 0){ $this->_setResults(); } $aResults = $this->getVar('results');
<?php // $Id: staffRolesByDept.php,v 1.5 2006/02/06 19:58:23 eric_juden Exp $ include_once XHELP_CLASS_PATH . '/report.php'; xhelpIncludeReportLangFile('staffRolesByDept'); include_once XHELP_JPGRAPH_PATH . '/jpgraph.php'; include_once XHELP_CLASS_PATH . '/report.php'; global $xoopsDB; class xhelpStaffRolesByDeptReport extends xhelpReport { function xhelpStaffRolesByDeptReport() { $this->initVar('results', XOBJ_DTYPE_ARRAY, null, false); $this->initVar('hasResults', XOBJ_DTYPE_INT, 0, false); $this->initVar('hasGraph', XOBJ_DTYPE_INT, 0, false); } var $meta = array('name' => _XHELP_SRD_NAME, 'author' => 'Eric Juden', 'author_email' => '*****@*****.**', 'description' => _XHELP_SRD_DESC, 'version' => '1.0', 'dbFields' => array('Department' => _XHELP_SRD_DB3, 'Role' => _XHELP_SRD_DB2, 'name' => _XHELP_SRD_DB1)); /* function generateReport() { if($this->getVar('hasResults') == 0){ $this->_setResults(); } $aResults = $this->getVar('results'); if(empty($aResults)){ // If no records found $myReport = $this->generateReportNoData(); return $myReport; } // Print graph
<?php // $Id: departmentSummary.php,v 1.2 2006/02/06 19:58:21 eric_juden Exp $ include_once XHELP_JPGRAPH_PATH . '/jpgraph.php'; include_once XHELP_JPGRAPH_PATH . '/jpgraph_bar.php'; // añado para ver si funciona <====================18/03/2010 include_once XHELP_CLASS_PATH . '/report.php'; xhelpIncludeReportLangFile('departmentSummary'); global $xoopsDB, $paramVals; $startDate = date('m/d/y h:i:s A', mktime(0, 0, 0, date("m") - 1, date("d"), date("Y"))); $endDate = date('m/d/y') . " 12:00:00 AM"; $hDepartments =& xhelpGetHandler('department'); $crit = new Criteria('', ''); $crit->setSort('department'); $crit->setOrder('ASC'); $departments =& $hDepartments->getObjects($crit, true); $i = 0; $aDepts = array(); $aDepts[-999] = 'All'; foreach ($departments as $id => $dept) { if ($i == 0) { $deptid = $id; } $aDepts[$id] = $dept->getVar('department'); $i++; } // Cannot fill date values in class...have to fill these values later $paramVals = array('startDate' => isset($_REQUEST['startDate']) && $_REQUEST['startDate'] != '' ? $_REQUEST['startDate'] : $startDate, 'endDate' => isset($_REQUEST['endDate']) && $_REQUEST['endDate'] != '' ? $_REQUEST['endDate'] : $endDate, 'department' => array($aDepts, isset($_REQUEST['department']) ? $_REQUEST['department'] : '')); class xhelpDepartmentSummaryReport extends xhelpReport { function xhelpDepartmentSummaryReport()
<?php // $Id: ticketsByDept.php,v 1.8 2006/02/06 19:58:23 eric_juden Exp $ include_once XHELP_JPGRAPH_PATH . '/jpgraph.php'; include_once XHELP_CLASS_PATH . '/report.php'; xhelpIncludeReportLangFile('ticketsByDept'); global $xoopsDB, $paramVals; $startDate = date('m/d/y h:i:s A', mktime(0, 0, 0, date("m") - 1, date("d"), date("Y"))); $endDate = date('m/d/y') . " 12:00:00 AM"; // Cannot fill date values in class...have to fill these values later $paramVals = array('startDate' => isset($_REQUEST['startDate']) && $_REQUEST['startDate'] != '' ? $_REQUEST['startDate'] : $startDate, 'endDate' => isset($_REQUEST['endDate']) && $_REQUEST['endDate'] != '' ? $_REQUEST['endDate'] : $endDate); class xhelpTicketsByDeptReport extends xhelpReport { function xhelpTicketsByDeptReport() { $this->initVar('results', XOBJ_DTYPE_ARRAY, null, false); $this->initVar('hasResults', XOBJ_DTYPE_INT, 0, false); $this->initVar('hasGraph', XOBJ_DTYPE_INT, 1, false); } var $name = 'ticketsByDept'; var $meta = array('name' => _XHELP_TBD_NAME, 'author' => 'Eric Juden', 'authorEmail' => '*****@*****.**', 'description' => _XHELP_TBD_DESC, 'version' => '1.0', 'dbFields' => array('department' => _XHELP_TBD_DB1, 'TicketCount' => _XHELP_TBD_DB2)); var $parameters = array(_XHELP_TBD_PARAM1 => array('controltype' => XHELP_CONTROL_DATETIME, 'fieldname' => 'startDate', 'value' => '', 'values' => '', 'fieldlength' => 25, 'dbfield' => 't.posted', 'dbaction' => '>'), _XHELP_TBD_PARAM2 => array('controltype' => XHELP_CONTROL_DATETIME, 'fieldname' => 'endDate', 'value' => '', 'values' => '', 'fieldlength' => 25, 'dbfield' => 't.posted', 'dbaction' => '<=')); /* function generateReport() { global $paramVals; if($this->getVar('hasResults') == 0){ $this->_setResults(); } $aResults = $this->getVar('results');
<?php // $Id: timeSpentByStaff.php,v 1.6 2006/02/06 19:58:23 eric_juden Exp $ include_once XHELP_JPGRAPH_PATH . '/jpgraph.php'; include_once XHELP_CLASS_PATH . '/report.php'; xhelpIncludeReportLangFile('timeSpentByStaff'); global $xoopsDB, $paramVals; $startDate = date('m/d/y h:i:s A', mktime(0, 0, 0, date("m") - 1, date("d"), date("Y"))); $endDate = date('m/d/y') . " 12:00:00 AM"; // Cannot fill date values in class...have to fill these values later $paramVals = array('startDate' => isset($_REQUEST['startDate']) && $_REQUEST['startDate'] != '' ? $_REQUEST['startDate'] : $startDate, 'endDate' => isset($_REQUEST['endDate']) && $_REQUEST['endDate'] != '' ? $_REQUEST['endDate'] : $endDate); class xhelpTimeSpentByStaffReport extends xhelpReport { function xhelpTimeSpentByStaffReport() { $this->initVar('results', XOBJ_DTYPE_ARRAY, null, false); $this->initVar('hasResults', XOBJ_DTYPE_INT, 0, false); $this->initVar('hasGraph', XOBJ_DTYPE_INT, 1, false); } var $name = 'timeSpentByStaff'; var $meta = array('name' => _XHELP_TSBS_NAME, 'author' => 'Eric Juden', 'authorEmail' => '*****@*****.**', 'description' => _XHELP_TSBS_DESC, 'version' => '1.0', 'dbFields' => array('name' => _XHELP_TSBS_DB1, 'TotalTime' => _XHELP_TSBS_DB2)); var $parameters = array(_XHELP_TSBS_PARAM1 => array('controltype' => XHELP_CONTROL_DATETIME, 'fieldname' => 'startDate', 'value' => '', 'values' => '', 'fieldlength' => 25, 'dbfield' => 'r.updateTime', 'dbaction' => '>'), _XHELP_TSBS_PARAM2 => array('controltype' => XHELP_CONTROL_DATETIME, 'fieldname' => 'endDate', 'value' => '', 'values' => '', 'fieldlength' => 25, 'dbfield' => 'r.updateTime', 'dbaction' => '<=')); /* function generateReport() { global $paramVals; if($this->getVar('hasResults') == 0){ $this->_setResults(); } $aResults = $this->getVar('results');
<?php // $Id: staffInfo.php,v 1.8 2006/02/06 19:58:23 eric_juden Exp $ include_once XHELP_JPGRAPH_PATH . '/jpgraph.php'; include_once XHELP_JPGRAPH_PATH . '/jpgraph_bar.php'; include_once XHELP_CLASS_PATH . '/report.php'; xhelpIncludeReportLangFile('staffInfo'); global $xoopsDB; class xhelpStaffInfoReport extends xhelpReport { function xhelpStaffInfoReport() { $this->initVar('results', XOBJ_DTYPE_ARRAY, null, false); $this->initVar('hasResults', XOBJ_DTYPE_INT, 0, false); $this->initVar('hasGraph', XOBJ_DTYPE_INT, 1, false); /* if(phpversion() >= 5){ // Problems with JPGRAPH and php5 using bar graphs - Don't display for php5 $this->setVar('hasGraph', 0); } else { $this->setVar('hasGraph', 1); } */ } var $name = 'staffInfo'; var $meta = array('name' => _XHELP_STAFF_INFO_NAME, 'author' => 'Eric Juden', 'authorEmail' => '*****@*****.**', 'description' => _XHELP_STAFF_INFO_DESC, 'version' => '1.0', 'dbFields' => array('name' => 'Name', 'ticketsResponded' => 'Tickets Responded', 'callsClosed' => 'Calls Closed', 'avgResponseTime' => 'Average Response Time (in Minutes)')); var $parameters = array(); /* function generateReport() { if($this->getVar('hasResults') == 0){ $this->_setResults();