/** * 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'] . "%'"); }