PHP DAO::resetDAO方法代碼示例

本文整理匯總了PHP中DAO::resetDAO方法的典型用法代碼示例。如果您正苦於以下問題：PHP DAO::resetDAO方法的具體用法？PHP DAO::resetDAO怎麽用？PHP DAO::resetDAO使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類DAO的用法示例。

在下文中一共展示了DAO::resetDAO方法的4個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。

示例1: getTareasAbiertasYUsuarios

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

開發者ID:elcuy，項目名稱:Novopan，代碼行數:10，代碼來源:reportPlazosReclamo.php

示例2: getDuracionCerradosPorCliente

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"];
}

開發者ID:elcuy，項目名稱:Novopan，代碼行數:11，代碼來源:reportReclamosMontosCliente.php

示例3: getStandardReportData

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

開發者ID:elcuy，項目名稱:Novopan，代碼行數:38，代碼來源:reportCruceATS.php

示例4: getStandardReportData

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

開發者ID:elcuy，項目名稱:Novopan，代碼行數:37，代碼來源:reportDistribucionCosto.php

注：本文中的DAO::resetDAO方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。