/**
* the getList method is used to
* pupolate the listing table
*/
public function getList($id = "", $pg)
{
$purl = array();
if (isset($_GET['url'])) {
$purl = $_GET['url'];
$purl = rtrim($purl);
$purl = explode('/', $_GET['url']);
} else {
$purl = null;
}
if (!isset($purl['2'])) {
$pn = 1;
} else {
$pn = $purl['2'];
}
global $database;
$resultEmployee = $database->db_query("SELECT * FROM items");
$pagin = new Pagination();
//create the pagination object;
$pagin->nr = $database->dbNumRows($resultEmployee);
$pagin->itemsPerPage = 20;
$myitems = Items::find_by_sql("SELECT * FROM items " . $pagin->pgLimit($pn));
$index_array = array("items" => $myitems, "mypagin" => $pagin->render($pg));
return $index_array;
return $index_array;
}
/**
* the getList method is used to
* pupolate the listing table
*/
public function getList($id = "", $pg)
{
$purl = array();
if (isset($_GET['url'])) {
$purl = $_GET['url'];
$purl = rtrim($purl);
$purl = explode('/', $_GET['url']);
} else {
$purl = null;
}
if (!isset($purl['2'])) {
$pn = 1;
} else {
$pn = $purl['2'];
}
$itemnamefield = "";
$descfield = "";
$condifield = "";
print_r($_POST['condi']);
/**
* of all the filter fields if only one field is set
*/
$filterResult = "";
if (isset($_POST['itemname']) && !empty($_POST['itemname'])) {
$itemnamefield .= " AND item_name = '" . $_POST['itemname'] . "' ";
}
if (isset($_POST['descript']) && !empty($_POST['descript'])) {
$descfield .= " AND item_description LIKE '%" . $_POST['descript'] . "%' ";
}
if (!empty($_POST['price']) && !empty($_POST['condi'])) {
$condifield .= " AND item_cost " . $_POST['condi'] . " " . $_POST["price"];
}
if (!empty($_POST['fdate']) && !empty($_POST['tdate'])) {
$datefield .= " AND datecreated BETWEEN '" . $_POST['fdate'] . "' AND '" . $_POST['tdate'] . "' ";
}
if (empty($_POST['fdate']) && !empty($_POST['tdate'])) {
$datefield .= " AND datecreated < '" . $_POST['tdate'] . "' ";
}
if (!empty($_POST['fdate']) && empty($_POST['tdate'])) {
$datefield .= " AND datecreated > '" . $_POST['fdate'] . "' ";
}
$filterResult .= " WHERE id !='' " . $itemnamefield . $descfield . $condifield;
global $database;
$resultEmployee = $database->db_query("SELECT * FROM items " . $filterResult);
$pagin = new Pagination();
//create the pagination object;
$pagin->nr = $database->dbNumRows($resultEmployee);
$pagin->itemsPerPage = 20;
$myitems = Items::find_by_sql("SELECT * FROM items " . $filterResult . " " . $pagin->pgLimit($pn));
$index_array = array("items" => $myitems, "mypagin" => $pagin->render($pg));
return $index_array;
}
/**
* this section is used to get auto complete
* feature for the item
* textbox
*/
public function itemID_AutoComplete($id = "")
{
return Items::find_by_sql("SELECT * FROM items WHERE item_name LIKE '%" . $_POST['input'] . "%'");
}
