PHP WAR_requests::SelectAllの例

コード例 #1

ファイル: request.data.php プロジェクト: jafarkhani/rtfund

function SelectAllWarrentyRequests()
{
    $param = array();
    $where = "1=1 ";
    if (!empty($_REQUEST["RequestID"])) {
        $where .= " AND RequestID=:r";
        $param[":r"] = $_REQUEST["RequestID"];
    }
    $param = array();
    if (isset($_REQUEST['fields']) && isset($_REQUEST['query'])) {
        $field = $_REQUEST['fields'];
        $field = $field == "fullname" ? "concat_ws(' ',fname,lname,CompanyName)" : $field;
        $where .= ' and ' . $field . ' like :fld';
        $param[':fld'] = '%' . $_REQUEST['query'] . '%';
    }
    if (!empty($_REQUEST["IsEnded"])) {
        $where .= " AND StatusID = :e ";
        $param[":e"] = WAR_STEPID_END;
    }
    $dt = WAR_requests::SelectAll($where, $param, dataReader::makeOrder());
    //print_r(ExceptionHandler::PopAllExceptions());
    //echo PdoDataAccess::GetLatestQueryString();
    $count = $dt->rowCount();
    $dt = PdoDataAccess::fetchAll($dt, $_GET["start"], $_GET["limit"]);
    echo dataReader::getJsonData($dt, $count, $_GET["callback"]);
    die;
}