public function retrieveId($field, $key)
{
$sql = "SELECT id FROM {$this->tab} WHERE {$field} ='" . $key . "'";
var_dump($sql);
$data = Request::cleanInput($this->db->query($sql));
return intval($data['id']);
}
public function CreateBrick()
{
$files = Request::cleanInput($_FILES);
$datas = $files['tmp_name'];
$names = $files['name'];
$medias = [];
$name = Request::input('name');
$type = Request::input('type');
$media = Request::input('media');
if ($type == "IMG" || $type == "WAV") {
$medias = explode(",", $media);
}
$data = $this->Brick->FindIDBrickByTitle($name);
// Title doesn't exists
if ($data == 0) {
for ($i = 0; $i < count($medias); $i++) {
$this->Media->setTitle($medias[$i]);
$this->Media->setUrl(URL . 'medias/' . $medias[$i]);
$this->Media->setType($type);
$this->Brick->createBrick($name, $type, $medias[$i]);
$this->Media->setFields();
$this->Media->create();
$this->Media_Brick->set_id_Bricks($this->Brick->FindIDBrickByTitle($name));
$this->Media_Brick->set_id_Medias($this->Media->retrieveId('title', $medias[$i]));
$this->Media_Brick->setFields();
$this->Media_Brick->create();
}
Session::setFlash("You have created your new brick !", 'success');
} else {
Session::setFlash(" This title already exists choose another one !", "danger");
}
//setFlash($message, $type = 'info', $title = null)
$this->Media->upload($datas, $names);
$this->view->redirect_to('/brick/edit');
}
public function index($id = null)
{
if ($id) {
if ($idmedia = $this->Media->read($id)) {
$currentMedia = Request::cleanInput($idmedia);
$this->view->currentMedia = $currentMedia;
} else {
Session::setFlash("This Media doesn't exist", "warning");
}
}
$this->view->medias = $this->Media->read();
$this->view->render('medias/index');
}
