Exemplo n.º 1
0
Arquivo: Series.php Projeto: ras263/lc
 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;
 }
Exemplo n.º 2
0
Arquivo: Bill.php Projeto: ras263/lc
 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;
 }
Exemplo n.º 3
0
Arquivo: Card.php Projeto: ras263/lc
 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;
 }