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; $resultUser = $database->db_query("SELECT * FROM users_client"); $pagin = new Pagination(); $pagin->nr = $database->dbNumRows($resultUser); $pagin->itemsPerPage = 20; $users = User::find_by_sql("SELECT * FROM users_client WHERE company_id=" . $_SESSION['client_ident'] . " " . $pagin->pgLimit($pn)); $index_array = array("myusers" => $users, "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']; } global $database; $resultEmployee = $database->db_query("SELECT * FROM vendors"); $pagin = new Pagination(); //create the pagination object; $pagin->nr = $database->dbNumRows($resultEmployee); $pagin->itemsPerPage = 20; $myitems = Vendor::find_by_sql("SELECT * FROM vendors " . $pagin->pgLimit($pn)); $index_array = array("vendors" => $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']; } $prodname = ""; $clientname = ""; $areaname = ""; $regionname = ""; $atmtype = ""; $clientid = ""; /** * of all the filter fields if only one field is set */ $filterResult = ""; if (isset($_REQUEST['prodname']) && !empty($_REQUEST['prodname'])) { $prodname .= " AND prod_name = '" . $_REQUEST['prodname'] . "' "; } if (isset($_REQUEST['prodname']) && !empty($_REQUEST['prodname'])) { $prodname .= " AND prod_name = '" . $_REQUEST['prodname'] . "' "; } if (isset($_REQUEST['clientid']) && !empty($_REQUEST['clientid'])) { $clientid .= " AND client_id ='" . $_REQUEST['clientid'] . "'"; } if (isset($_REQUEST['clientname']) && !empty($_REQUEST['clientname'])) { $clientname .= " AND client_name='" . $_REQUEST['clientname'] . "' "; } if (isset($_REQUEST['areaname']) && !empty($_REQUEST['areaname'])) { $areaname .= " AND install_area='" . $_REQUEST['areaname'] . "' "; } if (isset($_REQUEST['location']) && !empty($_REQUEST['location'])) { $regionname .= " AND (install_city LIKE '%" . $_REQUEST['location'] . "%' OR install_address LIKE '%" . $_REQUEST['location'] . "%') "; } if (isset($_REQUEST['machine']) && !empty($_REQUEST['machine'])) { $atmtype .= " AND atm_type='" . $_REQUEST['machine'] . "' "; } $filterResult .= " WHERE id !='' " . $prodname . $clientname . $areaname . $regionname . $atmtype . $clientid; print_r($filterResult); global $database; $result = $database->db_query("SELECT * FROM client_product "); $resultEmployee = $database->db_query("SELECT * FROM client_product " . $filterResult); $pagin = new Pagination(); //create the pagination object; $pagin->nr = $database->dbNumRows($resultEmployee); $pagin->itemsPerPage = 20; $pagin->totalRec = $database->dbNumRows($result); $myitems = Cproduct::find_by_sql("SELECT * FROM client_product " . $filterResult . " ORDER BY id DESC " . $pagin->pgLimit($pn)); $index_array = array("clientproduct" => $myitems, "mypagin" => $pagin->render($pg)); 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; }
public function getScheduleList($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; $resultSchedule = $database->db_query("SELECT * FROM schedule "); $pagin = new Pagination(); //create the pagination object; $pagin->nr = $database->dbNumRows($resultWorksheet); $pagin->itemsPerPage = 20; $AllSchedule = Schedule::find_by_sql("SELECT * FROM schedule " . $pagin->pgLimit($pn)); $index_array = array("schedules" => $AllSchedule, "mypagin" => $pagin->render($pg)); return $index_array; return $index_array; }
public function ActivationList($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']; } $statusfield = ""; $clientidfield = ""; $prodnamefield = ""; $issuefield = ""; $locationfield = ""; $datefield = ""; /** * of all the filter fields if only one field is set */ $filterResult = ""; if (isset($_REQUEST['status']) && !empty($_REQUEST['status'])) { if (strtolower($_REQUEST['status']) == "pending") { $statusfield .= " AND status = 'Admin Reply' OR status ='Customer Reply'"; } else { $statusfield .= " AND status = '" . $_REQUEST['status'] . "' "; } } if (isset($_REQUEST['clientid']) && !empty($_REQUEST['clientid'])) { $clientidfield .= " AND client_id='" . $_REQUEST['clientid'] . "' "; } if (isset($_REQUEST['prodid']) && !empty($_REQUEST['prodid'])) { $prodnamefield .= " AND prod_id = '" . $_REQUEST['prodid'] . "' "; } if (isset($_REQUEST['location']) && !empty($_REQUEST['location'])) { $locationfield .= " AND location LIKE '%" . $_REQUEST['location'] . "%' "; } if (isset($_REQUEST['issue']) && !empty($_REQUEST['issue'])) { $issuefield .= " AND issue LIKE '%" . $_REQUEST['issue'] . "%' "; } if (!empty($_REQUEST['fdate']) && !empty($_REQUEST['tdate'])) { $datefield .= " AND datecreated BETWEEN '" . $_REQUEST['fdate'] . "' AND '" . $_REQUEST['tdate'] . "' "; } if (empty($_REQUEST['fdate']) && !empty($_REQUEST['tdate'])) { $datefield .= " AND datecreated < '" . $_REQUEST['tdate'] . "' "; } if (!empty($_REQUEST['fdate']) && empty($_REQUEST['tdate'])) { $datefield .= " AND datecreated > '" . $_REQUEST['fdate'] . "' "; } $filterResult .= " WHERE id !=''" . $statusfield . $clientidfield . $prodnamefield . $locationfield . $issuefield . $datefield; global $database; $resultEmployee = $database->db_query("SELECT * FROM activation "); $pagin = new Pagination(); //create the pagination object; $pagin->nr = $database->dbNumRows($resultEmployee); $pagin->itemsPerPage = 20; $myitems = Activation::find_by_sql("SELECT * FROM activation " . $filterResult . " ORDER BY id DESC " . $pagin->pgLimit($pn)); //print_r($myitems); $index_array = array("activations" => $myitems, "mypagin" => $pagin->render($pg, "ticketlist")); return $index_array; }
public function getListActivation($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']; } $statusfield = ""; /** * of all the filter fields if only one field is set */ $filterResult = ""; if (isset($_REQUEST['status']) && !empty($_REQUEST['status'])) { if ($_REQUEST['status'] != "Pending") { $statusfield .= " AND status = '" . $_REQUEST['status'] . "' "; } else { $statusfield .= " AND status = 'Admin Reply' OR status = 'Customer Reply'"; } } $filterResult .= " WHERE client_id ='" . $_SESSION['client_ident'] . "' " . $statusfield; global $database; $resultEmployee = $database->db_query("SELECT * FROM activation WHERE client_id='" . $_SESSION["client_ident"] . "'"); $pagin = new Pagination(); //create the pagination object; $pagin->nr = $database->dbNumRows($resultEmployee); $pagin->itemsPerPage = 20; $myitems = Activation::find_by_sql("SELECT * FROM activation " . $filterResult . " ORDER BY id DESC " . $pagin->pgLimit($pn) . ""); $index_array = array("supportticket" => $myitems, "mypagin" => $pagin->render($pg)); return $index_array; return $index_array; }