db = new Database(); } function create($customer_id, $tour_id, $assistant_id, $bill_number, $date) { $query = "INSERT INTO ".$this->db->bill_table." (customer_id, tour_id, assistant_id, bill_number, timestamp, date) VALUES(".$customer_id.", ".$tour_id.",".$assistant_id.",".$bill_number.",CURRENT_TIMESTAMP(),'".$date."')"; $this->db->query($query); $query = "SELECT bill_id from ".$this->db->bill_table." ORDER BY bill_id DESC"; $tmp = $this->db->fetchRows($this->db->query($query)); return $tmp[0][0]; } function update($bill_id, $value) { $query = "UPDATE ".$this->db->bill_table." SET "; $query .= "customer_id=".$value[0].", "; $query .= "tour_id=".$value[1].", "; $query .= "date='".$value[2]."', "; $query .= "assistant_id=".$value[3].", "; $query .= "bill_number=".$value[4]." "; $query .= "WHERE bill_id=".$bill_id.""; $this->db->query($query); } function setNumber($bill_id) { $data = $this->get($bill_id); $query = "UPDATE ".$this->db->bill_table." SET "; $query .= "bill_number=".$this->getNextFreeNumberByAssistant($data[0][4])." "; $query .= "WHERE bill_id=".$bill_id.""; $this->db->query($query); } function delete($bill_id) { $query = "DELETE FROM ".$this->db->bill_table." WHERE bill_id=".$bill_id.""; $this->db->query($query); } function get($bill_id = "", $row_names = array(), $search = "") { if($bill_id == "") { if(count($row_names) == 0) $query = "SELECT * FROM ".$this->db->bill_table.", ".$this->db->customer_table; else { $query = "SELECT ".$row_names[0]; for($i = 1; $i < count($row_names); $i++) $query .= ", ".$row_names[$i]; $query .= " FROM ".$this->db->bill_table.", ".$this->db->customer_table; } $query .= " WHERE bill.customer_id=customer.customer_id "; if($search != "") $query .= " AND ( ".$search." )"; $query .= " ORDER BY bill_number ASC"; return $this->db->fetchRows($this->db->query($query)); } else { $query = "SELECT * FROM ".$this->db->bill_table." WHERE bill_id=".$bill_id.""; $query .= " ORDER BY bill_number ASC"; return $this->db->fetchRows($this->db->query($query)); } } function getNextFreeNumberByAssistant($assistant_id) { $query = "SELECT bill_number FROM ".$this->db->bill_table." WHERE assistant_id=".$assistant_id." ORDER BY bill_number DESC"; $result = $this->db->fetchRows($this->db->query($query)); return $result[0][0]+1; } } ?>