public static function get_all() { $db = new DB(); $query = 'SELECT * FROM cards_series WHERE serial_id <> ' . ADMCARDSERIAL; $data = $db->query_all($query, 'Series'); return $data; }
public static function get_bills($id) { $db = new DB(); $query = 'SELECT c.card_id id, b.bill_number bill, b.date_time, b.cost, st.store_name FROM bills b NATURAL JOIN cards c NATURAL JOIN stores st WHERE c.card_id = ' . $id . ' ORDER BY bill'; $bills = $db->query_all($query, 'Bill'); return $bills; }
public static function search() { $request = $_GET['request']; $db = new DB(); $query = 'SELECT c.card_id, s.name serial, c.number, c.release_date, c.end_date, c.status FROM cards_series s NATURAL JOIN cards c WHERE s.serial_id <> 5 AND (s.name LIKE "%' . $request . '%"' . 'OR c.number LIKE "%' . $request . '%" OR c.release_date LIKE "%' . $request . '%" OR c.end_date LIKE "%' . $request . '%")'; $data = $db->query_all($query, 'Card'); return $data; }