function selectWrtData() { $where = ""; $whereParam = array(); MakeAdvanceSearchWhere($where, $whereParam); $field = isset($_GET["fields"]) ? $_GET["fields"] : ""; if (isset($_GET["query"]) && $_GET["query"] != "") { switch ($field) { case "PersonID": $where .= " AND p.PersonID = :qry1 "; $whereParam[":qry1"] = "%" . $_GET["query"] . "%"; break; case "writ_id": $where .= " AND w.writ_id = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "writ_ver": $where .= " AND w.writ_ver = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "fullname": $where .= " AND fullname LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "staff_id": $where .= " AND w.staff_id = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "org_title": $where .= " AND org_title = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "wt_title": $where .= " AND wt_title LIKE :qry "; $whereParam[":qry"] = $_GET["query"]; break; case "emp_state_title": $where .= " AND emp_state_title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "execute_date": $where .= " AND w.execute_date = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "history_only_title": $where .= " AND history_only_title = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "corrective_title": $where .= " AND corrective_title = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "corrective_writ_id": $where .= " AND corrective_writ_id = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "mablagh": $where .= " AND mablagh = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; } } $temp = manage_writ::GetAllWrits($where . dataReader::makeOrder(), $whereParam); $no = $temp->rowCount(); $temp = PdoDataAccess::fetchAll($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); // echo PdoDataAccess::GetLatestQueryString(); die; }