Assistant.php 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485
  1. <?php
  2. require_once("DataBase/database.php");
  3. class Assistant
  4. {
  5. function Assistant()
  6. {
  7. $this->db = new Database();
  8. }
  9. function create($assistant_id, $value)
  10. {
  11. $query = "INSERT INTO ".$this->db->assistant_table." VALUES('".$assistant_id."'";
  12. for($i = 0; $i < count($value); $i++)
  13. $query .= ", '".$value[$i]."'";
  14. $query .= ")";
  15. $this->db->query($query);
  16. }
  17. function update($assistant_id, $value)
  18. {
  19. $query = "UPDATE ".$this->db->assistant_table." SET ";
  20. $query .= "prename='".$value[0]."', ";
  21. $query .= "postname='".$value[1]."', ";
  22. $query .= "street='".$value[2]."', ";
  23. $query .= "streetnumber='".$value[3]."', ";
  24. $query .= "plz='".$value[4]."', ";
  25. $query .= "city='".$value[5]."', ";
  26. $query .= "telephone='".$value[6]."', ";
  27. $query .= "telefax='".$value[7]."', ";
  28. $query .= "email='".$value[8]."', ";
  29. $query .= "tax_number='".$value[9]."', ";
  30. $query .= "blz='".$value[10]."', ";
  31. $query .= "bank_account='".$value[11]."', ";
  32. $query .= "additional='".$value[12]."', ";
  33. $query .= "utax_id='".$value[13]."', ";
  34. $query .= "bank_name='".$value[14]."', ";
  35. $query .= "bill_ext='".$value[15]."' ";
  36. $query .= "WHERE assistant_id='".$assistant_id."'";
  37. $this->db->query($query);
  38. }
  39. function delete($assistant_id)
  40. {
  41. $query = "DELETE FROM ".$this->db->assistant_table." WHERE assistant_id='$assistant_id'";
  42. $this->db->query($query);
  43. }
  44. function get($assistant_id = "", $row_names = array(), $search = "")
  45. {
  46. if($assistant_id == "")
  47. {
  48. if(count($row_names) == 0)
  49. $query = "SELECT * FROM ".$this->db->assistant_table;
  50. else
  51. {
  52. $query = "SELECT ".$row_names[0];
  53. for($i = 1; $i < count($row_names); $i++)
  54. $query .= ", ".$row_names[$i];
  55. $query .= " FROM ".$this->db->assistant_table;
  56. }
  57. if($search != "")
  58. $query .= " WHERE ".$search;
  59. $query .= " ORDER BY assistant_id ASC";
  60. return $this->db->fetchRows($this->db->query($query));
  61. }
  62. else
  63. {
  64. $query = "SELECT * FROM ".$this->db->assistant_table." WHERE assistant_id='".$assistant_id."'";
  65. $query .= " ORDER BY assistant_id ASC";
  66. return $this->db->fetchRows($this->db->query($query));
  67. }
  68. }
  69. }
  70. ?>