function selectsalaryItem() { $where = " (1=1) "; $whereParam = array(); if (!empty($_REQUEST['full_title'])) { $where .= " AND full_title LIKE :tit "; $whereParam[":tit"] = "%" . $_REQUEST['full_title'] . "%"; } if (!empty($_REQUEST['print_title'])) { $where .= " AND print_title LIKE :ptit "; $whereParam[":ptit"] = "%" . $_REQUEST['print_title'] . "%"; } $field = isset($_GET["fields"]) ? $_GET["fields"] : ""; if (isset($_GET["query"]) && $_GET["query"] != "") { switch ($field) { case "PTitle": $where .= " AND bi1.Title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "compute_place_title": $where .= " AND bi3.Title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "full_title": $where .= " AND full_title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "effectTitle": $where .= " AND bi2.Title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "insure_include_title": $where .= " AND insure_include = "; $where .= $_GET["query"] == '*' ? "1" : "''"; break; case "tax_include_title": $where .= " AND tax_include = "; $where .= $_GET["query"] == '*' ? "1" : "''"; break; case "retired_include_title": $where .= " AND retired_include = "; $where .= $_GET["query"] == '*' ? "1" : "''"; break; case "pension_include_title": $where .= " AND pension_include = "; $where .= $_GET["query"] == '*' ? "1" : "''"; break; case "user_data_entry_title": $where .= " AND user_data_entry = "; $where .= $_GET["query"] == '*' ? "1" : "''"; break; case "salary_compute_type_title": $where .= " AND bi4.Title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "salary_item_type_id": $where .= " AND salary_item_type_id = :qry "; $whereParam[":qry"] = $_GET["query"]; break; } } $no = manage_salary_item_type::Count($where, $whereParam); $where .= dataReader::makeOrder(); $where .= isset($_GET["start"]) ? " limit " . $_GET["start"] . "," . $_GET["limit"] : ""; $temp = manage_salary_item_type::Select($where, $whereParam); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }