/**
* Model constructor.
*
* @param array $attributesValues
*/
public function __construct(array $attributesValues = [])
{
$this->db = DB::getInstance()->getConnection();
$this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
if (!empty($attributesValues)) {
$this->setAttributesValues($attributesValues);
}
}
/**
* Project constructor.
* @param $_id
* @param $_titre
* @param $_dead_line
* @param $_task_list
*/
public function __construct($_id, $_titre, $_dead_line)
{
$this->_id = $_id;
$this->_titre = $_titre;
$this->_dead_line = $_dead_line;
$tasks = DB::getInstance()->query('SELECT * FROM tache WHERE id_projet = ?', [$_id]);
foreach ($tasks as $task) {
$this->_task_liste[] = new Task($task['id'], $task['intitule'], $task['commenntaire'], $task['is_sstache'], $task['sous_tache_id'], $task['done']);
}
}
public function findAll($params = null)
{
var_dump($params);
if (!is_array($params)) {
return DB::getInstance()->query('SELECT * FROM users');
echo 'SELECT * FROM users';
} else {
echo 'SELECT * FROM users WHERE ' . $params[0] . ' = "' . $params[1] . '"';
//return DB::getInstance()->query('SELECT * FROM users WHERE '.$params[0].' = ?', [$params[1]]);
}
}
/**
* Set instance DB pada property $db.
*
* @return void
*/
public function __construct()
{
$this->db = DB::getInstance();
}
/**
* delete the current model from database based on primary key value
* @return boolean
*/
public function delete()
{
if (!isset($this->{$this->primary})) {
throw new \InvalidArgumentException("No value found for key {$this->primary}");
}
$this->sqlDelete = str_replace(['{delete}', '{primary}'], [$this->table, $this->primary], $this->sqlDelete);
$this->pdo = DB::getInstance();
$stmt = $this->pdo->prepare($this->sqlDelete);
$stmt->bindParam(':primary', $this->{$this->primary}, $this->pdoType(gettype($this->{$this->primary})));
$return = $stmt->execute();
$this->errorInfo = $stmt->errorInfo();
return $return;
}
