PHP manage_person_dependency::GetAllDepSupports Exemples

Exemple #1

Fichier : dependent.data.php Projet : jafarkhani/rtfund

function SelectPersonDependents()
{
    $where = "1=1";
    $whereParam = array();
    //.................................
    if (!empty($_REQUEST["from_StaffID"])) {
        $where .= " AND s.staff_id>=:fpid";
        $whereParam[":fpid"] = $_REQUEST["from_StaffID"];
    }
    if (!empty($_REQUEST["to_StaffID"])) {
        $where .= " AND s.staff_id<=:tpid";
        $whereParam[":tpid"] = $_REQUEST["to_StaffID"];
    }
    if (!empty($_REQUEST["pfname"])) {
        $where .= " AND p.pfname like :pfname";
        $whereParam[":pfname"] = "%" . $_REQUEST["pfname"] . "%";
    }
    if (!empty($_REQUEST["plname"])) {
        $where .= " AND p.plname like :plname";
        $whereParam[":plname"] = "%" . $_REQUEST["plname"] . "%";
    }
    $no = count(manage_person_dependency::GetAllDepSupports($where, $whereParam));
    $temp = manage_person_dependency::GetAllDepSupports($where, $whereParam);
    echo dataReader::getJsonData($temp, $no, $_GET["callback"]);
    die;
}