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;
}
