function selectEduc()
{
$where = " pe.PersonID = :PID ";
$whereParam = array();
$whereParam[":PID"] = $_GET["Q0"];
$field = isset($_GET["fields"]) ? $_GET["fields"] : "";
if (isset($_GET["query"]) && $_GET["query"] != "") {
switch ($field) {
case "fname":
$where .= " AND fname LIKE :qry ";
$whereParam[":qry"] = "%" . $_GET["query"] . "%";
break;
case "lname":
$where .= " AND lname LIKE :qry ";
$whereParam[":qry"] = "%" . $_GET["query"] . "%";
break;
case "birth_date":
$where .= " AND birth_date = :qry1 ";
$whereParam[":qry1"] = $_GET["query"];
break;
case "idcard_no":
$where .= " AND idcard_no = :qry1 ";
$whereParam[":qry1"] = $_GET["query"];
break;
case "father_name":
$where .= " AND Fname LIKE :qry ";
$whereParam[":qry"] = "%" . $_GET["query"] . "%";
break;
case "Title":
$where .= " AND Title LIKE :qry ";
$whereParam[":qry"] = "%" . $_GET["query"] . "%";
break;
case "insure_type":
// شماره بیمه
$where .= " AND insure_type LIKE :qry ";
$whereParam[":qry"] = "%" . $_GET["query"] . "%";
break;
}
}
$no = manage_person_education::CountEducation($where, $whereParam);
$where .= dataReader::makeOrder();
$where .= isset($_GET["start"]) ? " limit " . $_GET["start"] . "," . $_GET["limit"] : "";
$temp = manage_person_education::GetAllEducations($where, $whereParam);
echo dataReader::getJsonData($temp, $no, $_GET["callback"]);
die;
}
