1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
<?php
include_once("DBModel.php");
/**
* Model that contains the required JobOffer properties. It also contains the request methods to the job_offers table.
*/
class JobOffer extends DBModel {
public const TABLE_NAME = "job_offers";
public const TABLE_COLUMNS = array("title " . DB::STRING_TYPE, "description " . DB::STRING_TYPE, "company " . DB::STRING_TYPE, "salary " . DB::FLOAT_TYPE);
public string $title;
public string $description;
public string $company;
public float $salary;
function __construct(string $title, string $description, string $company, float $salary) {
$this->title = $title;
$this->description = $description;
$this->company = $company;
$this->salary = $salary;
self::$DB->createTable(self::TABLE_NAME, self::TABLE_COLUMNS);
}
/* Create */
/**
* Inserts the giveb JobOffer into the databse. The id is automatically generated in the database.
*
* @param JobOffer $jb
*/
static function insertIntoDB($jb) {
self::$DB->insertValue(self::TABLE_NAME, $jb->title, $jb->description, $jb->company, $jb->salary);
}
/* Read */
/**
* Returns the JobOffer with the given id from the database.
*
* @return JobOffer
*/
static function getFromDBById(int $id) {
return self::$DB->getById(self::TABLE_NAME, $id);
}
/**
* Returns all JobOffers from the database.
*
* @return JobOffer[]
*/
static function getAllFromDB() {
return self::$DB->getAllValues(self::TABLE_NAME);
}
/* Update */
/**
* Updates the given JobOffer from the database.
* **WARNING**: the JobOffer **MUST** have it's database id.
*
* @param JobOffer $jb
*/
static function updateFromDB($jb) {
self::$DB->updateById(self::TABLE_NAME, $jb->id, "title", $jb->title, "description", $jb->description, "company", $jb->company, "salary", $jb->salary);
}
/* Delete */
/**
* Deletes the JobOffer with the given id from the database.
*/
static function deleteFromDB(int $id) {
self::$DB->deleteById(self::TABLE_NAME, $id);
}
}
|
