Esempi in PHP per manage_person_misc_doc::CountMiscDoc

Esempio n. 1

File: misc_doc.data.php Progetto: jafarkhani/rtfund

function selectMiscDoc()
{
    $where = " PersonID = :PID ";
    $whereParam = array();
    $whereParam[":PID"] = $_GET["Q0"];
    $field = isset($_GET["fields"]) ? $_GET["fields"] : "";
    if (isset($_GET["query"]) && $_GET["query"] != "") {
        switch ($field) {
            case "title":
                $where .= " AND title LIKE :qry ";
                $whereParam[":qry"] = "%" . $_GET["query"] . "%";
                break;
            case "doc_no":
                $where .= " AND doc_no=:qry ";
                $whereParam[":qry"] = $_GET["query"];
                break;
            case "row_no":
                $where .= " AND row_no=:qry ";
                $whereParam[":qry"] = $_GET["query"];
                break;
        }
    }
    $no = manage_person_misc_doc::CountMiscDoc($where, $whereParam);
    $where .= dataReader::makeOrder();
    $where .= isset($_GET["start"]) ? " limit " . $_GET["start"] . "," . $_GET["limit"] : "";
    $temp = manage_person_misc_doc::GetAllMiscDoc($where, $whereParam);
    echo dataReader::getJsonData($temp, $no, $_GET["callback"]);
    die;
}