function getTareasAbiertasYUsuarios($request_id)
{
$daoHandler = new DAO();
$sql = "SELECT \ts.step_name, u.user_name\r\n\t\t\t\tFROM \tef_task t\r\n\t\t\t\tleft join ef_step s ON s.step_id = t.task_step AND s.step_flow = t.task_flow\r\n\t\t\t\tleft join ef_user u ON u.user_id = t.task_assignedto\r\n\t\t\t\tWHERE \t?\r\n\t\t\t\tAND \tt.task_request = '.{$request_id}.' \r\n\t\t\t\tAND \t(t.task_status is null or t.task_status = 'new' or t.task_status = '')\r\n\t\t\t\tAND \tt.task_flow = '" . $_SESSION["user_flow"] . "' ";
$daoHandler->resetDAO();
$daoHandler->setQuery($sql);
$daoHandler->setParameter('i', 1);
$reportData = $daoHandler->executeQuery();
return $reportData;
}
function getDuracionCerradosPorCliente($cliente, $filtros)
{
$daoHandler = new DAO();
$flow = $_SESSION["user_flow"];
$sql = "SELECT AVG(a.delay) delay\r\n\t\t\t\tFROM(\tSELECT SUM(IF (d.date_end is not null, \r\n\t\t\t\t\t\t\t\t\t\t(-1*TIME_TO_SEC(TIMEDIFF(d.date_start, d.date_end))), \r\n\t\t\t\t\t\t\t\t\t\t(-1*TIME_TO_SEC(TIMEDIFF(d.date_start, NOW())))\r\n\t\t\t\t\t\t\t\t\t\t)) delay\r\n\t\t\t\t\t\tFROM ef_date d\r\n\t\t\t\t\t\tLEFT JOIN ef_step s ON d.date_flow = s.step_flow AND d.date_step = s.step_id\r\n\t\t\t\t\t\tLEFT JOIN \tef_request r2 ON d.date_request = r2.request_id\r\n\t\t\t\t\t\tLEFT JOIN \trc_reclamo r1 ON r1.ef_id = r2.request_id\r\n\t\t\t\t\t\tLEFT JOIN \trc_clase c ON r1.reclamo_clase = c.id\t\r\n\t\t\t\t\t\tWHERE \t\t(r2.request_status = 'closed' OR r2.request_status = 'cancelled')\r\n\t\t\t\t\t\tAND \t\tr1.cliente_nombre = '" . $cliente . "'\r\n\t\t\t\t\t\tAND \t\tr2.request_flow = " . $flow . "\r\n\t\t\t\t\t\t" . $filtros . "\r\n\t\t\t\t\t\tGROUP BY \td.date_request\r\n\t\t\t\t\t) a\r\n\t\t\t\tWHERE ? ";
$daoHandler->resetDAO();
$daoHandler->setQuery($sql);
$daoHandler->setParameter('i', 1);
$reportData = $daoHandler->executeQuery();
return $reportData[0]["delay"];
}
function getStandardReportData($filterHeaderArray, $outputType)
{
$daoHandler = new DAO();
require_once APP_BASEPATH . "/includes/Entities/Task/TaskCore.php";
require_once APP_BASEPATH . "/includes/Entities/User/UserCore.php";
require_once APP_BASEPATH . "/includes/Entities/FlowSettings/FlowSettingsCore.php";
require_once APP_BASEPATH . "/includes/Entities/RequestMetadata/RequestMetadataCore.php";
require_once $_SESSION["environment_path"] . "/customcode/RecepcionDocumentos/includes/Entities/DocumentoCabecera/DocumentoCabeceraCore.php";
require_once $_SESSION["environment_path"] . "/customcode/RecepcionDocumentos/includes/Entities/DocumentoLinea/DocumentoLineaCore.php";
require_once $_SESSION["environment_path"] . "/customcode/RecepcionDocumentos/includes/Entities/DistribucionCabecera/DistribucionCabeceraCore.php";
require_once $_SESSION["environment_path"] . "/customcode/RecepcionDocumentos/includes/Entities/DistribucionLinea/DistribucionLineaCore.php";
$flowSettingsHandler = new FlowSettingsCore();
$handlerTaskCore = new TaskCore();
$handlerRequestMetadataCore = new RequestMetadataCore();
$flow = $_SESSION["user_flow"];
$step = $flowSettingsHandler->getSettingValue($_SESSION["user_flow"], "RDE_STEP_PROC_CONTABLE");
$sql = "select\t\tCONCAT(docc.estab, '-', docc.ptoEmi, '-', docc.secuencial) documento,\r\n\t\t\t\t\t\t\tdocc.fechaEmision fecha,\r\n\t\t\t\t\t\t\tdocc.tipo_doc,\r\n\t\t\t\t docc.ruc ruc, \r\n\t\t\t\t docc.razonSocial nombre,\r\n\t\t\t\t docc.ef_id ef_id\r\n\r\n\t\t\t\tfrom \t\trde_documento docc\r\n\t\t\t\twhere \t\t?\r\n\t\t\t\tand \t\tdocc.tipo_doc = 'FAC' \t";
// Build filters
foreach ($filterHeaderArray as $headerRecord) {
if ($headerRecord["field_filtered"] == 1) {
if ($headerRecord["field_data_type"] != "date") {
$sql .= " AND " . $headerRecord["field_filter_string"] . " BETWEEN " . $headerRecord["field_min"] . " AND " . $headerRecord["field_max"] . " ";
} else {
$start_date = $headerRecord["field_min"] . " 00:00:00";
$end_date = $headerRecord["field_max"] . " 23:59:59";
}
}
}
$daoHandler->resetDAO();
$daoHandler->setQuery($sql);
$daoHandler->setParameter('i', 1);
$reportData = $daoHandler->executeQuery();
foreach ($reportData as &$record) {
$record["registrada_ats"] = "";
unset($record["ef_id"]);
}
return $reportData;
}
function getStandardReportData($filterHeaderArray, $outputType)
{
$daoHandler = new DAO();
require_once APP_BASEPATH . "/includes/Entities/Task/TaskCore.php";
require_once APP_BASEPATH . "/includes/Entities/User/UserCore.php";
require_once APP_BASEPATH . "/includes/Entities/FlowSettings/FlowSettingsCore.php";
require_once APP_BASEPATH . "/includes/Entities/RequestMetadata/RequestMetadataCore.php";
require_once $_SESSION["environment_path"] . "/customcode/RecepcionDocumentos/includes/Entities/DocumentoCabecera/DocumentoCabeceraCore.php";
require_once $_SESSION["environment_path"] . "/customcode/RecepcionDocumentos/includes/Entities/DocumentoLinea/DocumentoLineaCore.php";
require_once $_SESSION["environment_path"] . "/customcode/RecepcionDocumentos/includes/Entities/DistribucionCabecera/DistribucionCabeceraCore.php";
require_once $_SESSION["environment_path"] . "/customcode/RecepcionDocumentos/includes/Entities/DistribucionLinea/DistribucionLineaCore.php";
$flowSettingsHandler = new FlowSettingsCore();
$handlerTaskCore = new TaskCore();
$flow = $_SESSION["user_flow"];
$step = $flowSettingsHandler->getSettingValue($_SESSION["user_flow"], "RDE_STEP_PROC_CONTABLE");
$sql = "select\t\tCONCAT(docc.estab, '-', docc.ptoEmi, '-', docc.secuencial) factura,\r\n\t\t\t\t\t\t\tdocc.fechaEmision fecha,\r\n\t\t\t\t CONCAT(docc.ruc, ' - ', docc.razonSocial) proveedor,\r\n\t\t\t\t docc.id,\r\n\t\t\t\t docc.ef_id ef_id,\r\n\t\t\t\t docc.distribucion tipo_distribucion\r\n\r\n\t\t\t\tfrom \t\trde_documento docc\r\n\r\n\t\t\t\twhere \t\tef_id\t IN (\tselect\t\tdistinct(task_request)\r\n\t\t\t\t\t\t\t\t\t\t\tfrom\t\tef_task\r\n\t\t\t\t\t\t\t\t\t\t\twhere \t\ttask_flow = " . $_SESSION["user_flow"] . "\r\n\t\t\t\t\t\t\t\t\t\t\tand \t\ttask_step = ?\r\n\t\t\t\t\t\t\t\t\t\t\tand \t\ttask_status != 'closed')\r\n\r\n\t\t\t\tand \t\tdocc.tipo_doc = 'FAC' \t";
// Build filters
foreach ($filterHeaderArray as $headerRecord) {
if ($headerRecord["field_filtered"] == 1) {
if ($headerRecord["field_data_type"] != "date") {
$sql .= " AND " . $headerRecord["field_filter_string"] . " BETWEEN " . $headerRecord["field_min"] . " AND " . $headerRecord["field_max"] . " ";
} else {
$start_date = $headerRecord["field_min"] . " 00:00:00";
$end_date = $headerRecord["field_max"] . " 23:59:59";
}
}
}
$daoHandler->resetDAO();
$daoHandler->setQuery($sql);
$daoHandler->setParameter('i', $step);
$reportData = $daoHandler->executeQuery();
$returnArray = array();
foreach ($reportData as &$record) {
$returnArray[] = array('<div style="border: 3px solid #666;">' . getHtmlDistribucion($record) . '</div>');
}
return $returnArray;
}
