/** * testDeleteDependentWithConditions method * * @return void */ public function testDeleteDependentWithConditions() { $this->loadFixtures('Cd', 'Book', 'OverallFavorite'); $Cd = new Cd(); $Book = new Book(); $OverallFavorite = new OverallFavorite(); $Cd->delete(1); $result = $OverallFavorite->find('all', array('fields' => array('model_type', 'model_id', 'priority'))); $expected = array(array('OverallFavorite' => array('model_type' => 'Book', 'model_id' => 1, 'priority' => 2))); $this->assertTrue(is_array($result)); $this->assertEquals($expected, $result); $Book->delete(1); $result = $OverallFavorite->find('all', array('fields' => array('model_type', 'model_id', 'priority'))); $expected = array(); $this->assertTrue(is_array($result)); $this->assertEquals($expected, $result); }
public function getDeleteCd($id) { $cd = Cd::where('id', '=', $id)->first(); if ($cd) { $cd->delete(); return Redirect::to('/browse-cds')->with('flash_message', 'Delete successfuly!'); } else { return Redirect::to('/browse-cds')->with('flash_message', 'Delete failed! Try again...!'); } }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return Cd the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Cd::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
<?php require_once __DIR__ . "/../vendor/autoload.php"; require_once __DIR__ . "/../src/Cd.php"; session_start(); $cds = array(); if (empty($_SESSION['list_of_cds'])) { $_SESSION['list_of_cds'] = $cds; } $app = new Silex\Application(); $app->register(new Silex\Provider\TwigServiceProvider(), array('twig.path' => __DIR__ . '/../views')); //ROOT ROUTE $app->get("/", function () use($app) { return $app['twig']->render('cd.html.twig', array('cds' => Cd::getAll())); }); $app->get('/new_cd', function () use($app) { return $app['twig']->render('new_cd.html.twig', array('cds' => Cd::getAll())); }); $app->get('/searchbyartist', function () use($app) { return $app['twig']->render('searchbyartist.html.twig', array('cds' => Cd::getAll())); }); $app->post('/cd_confirm', function () use($app) { $cd = new Cd($_POST['artist'], $_POST['title'], $_POST['price']); $cd->save(); return $app['twig']->render('cd_confirm.html.twig', array('newcd' => $cd)); }); return $app;
return $app['twig']->render('cds.html.twig', array('cds' => Cd::getAll())); }); /**Enter CD webpage**/ $app->get("/enter_music", function () use($app) { return $app['twig']->render('enter_music.twig.html'); }); /**Add New CD**/ $app->post("/add", function () use($app) { $cd = new Cd($_POST['artist'], $_POST['album_name'], $_POST['year'], $_POST['cover_art']); $cd->save(); return $app['twig']->render('review_cd.html.twig', array('newcd' => $cd)); }); /**View Search**/ $app->get("/results", function () use($app) { $user_artist = strtolower($_GET['user_artist']); $cds = $_SESSION['list_of_cds']; $cds_match = $_SESSION['matching_cds']; foreach ($cds as $cd) { if ($user_artist == strtolower($cd->getArtist())) { array_push($cds_match, $cd); } } var_dump($cds_match); return $app['twig']->render('search_results.html.twig', array('matching_cds' => $cds_match)); }); /**Delete CDs**/ $app->post("/delete_cds", function () use($app) { Cd::deleteAll(); return $app['twig']->render('delete_cds.html.twig'); }); return $app;
session_start(); if (empty($_SESSION['list_of_cds'])) { $_SESSION['list_of_cds'] = array(); } if (empty($_SESSION['list_of_artists'])) { $_SESSION['list_of_artists'] = array(); } $app = new Silex\Application(); $app->register(new Silex\Provider\TwigServiceProvider(), array('twig.path' => __DIR__ . '/../views')); // routes $app->get("/", function () use($app) { return $app['twig']->render('cds.html.twig', array('cds' => Cd::getAll())); }); $app->post("/cds", function () use($app) { $new_artist = new Artist($_POST['artist']); $new_cd = new Cd($new_artist, $_POST['title'], $_POST['cover']); $new_cd->saveCd(); $new_artist->saveArtist(); return $app['twig']->render('cds.html.twig', array('cds' => Cd::getAll())); }); $app->get("/search", function () use($app) { return $app['twig']->render('search.html.twig'); }); $app->post("/search", function () use($app) { $cds = Cd::getAll(); $artist_matching_search = array(); foreach ($cds as $cd) { if ($cd->search($_POST['user_input'])) { array_push($artist_matching_search, $cd); } }
/** * Creates or updates the track in database getting data from file. * Used in /album/actions/executeRefreshAlbum * * @param Cd $cd_object ex: CD(Cd 1) * @param Array $track_info[] ex: [3, Beat it, MICHAEL JACKSON, 4:32, 128 kbps, 3,4 MB] * @return Track */ public static function createTrack($cd_object, $track_info) { //looking for this episode in db $track_object = NULL; foreach ($cd_object['Tracks'] as $track) { if ($track->title == $track_info['title']) { $track_object = $track; } } //if there is no episode if ($track_object == NULL) { $track_object = new Track(); $track_object->title = $track_info['title']; } $track_object->num_track = $track_info['num_track']; $track_object->duration = $track_info['duration']; $track_object->bitrate = $track_info['bitrate']; $track_object->filesize = $track_info['filesize']; $track_object->rating = $track_info['rating']; $track_object->lyrics = $track_info['lyrics']; $track_object->file_rel = $track_info['file_rel']; /********************************* YEAR *********************************/ if ($track_info['year'] == "") { $track_object->Year = NULL; } else { $year_object = Doctrine::getTable('Year')->findOneByName($track_info['year']); if ($year_object == NULL) { $year_object = Util::createYear($track_info['year']); } $track_object->Year = $year_object; } /********************************* GENRE *********************************/ if ($track_info['genre'] == "") { $track_object->Genre = NULL; } else { $genre_object = Doctrine::getTable('Genre')->findOneByName($track_info['genre']); if ($genre_object == NULL) { $genre_object = Util::createGenre($track_info['genre']); } $track_object->Genre = $genre_object; } /********************************* SINGER *********************************/ if ($track_info['artist'] == "") { $track_object->Singer = NULL; } else { $singer_object = Doctrine::getTable('Singer')->findOneByName(Util::formatName($track_info['artist'])); if ($singer_object == NULL) { $singer_object = Util::createSinger(Util::formatName($track_info['artist'])); } $track_object->Singer = $singer_object; } $track_object->save(); $cd_object->Tracks[] = $track_object; $cd_object->save(); return $track_object; }
require_once __DIR__ . '/../vendor/autoload.php'; require_once __DIR__ . '/../src/Cd.php'; session_start(); if (empty($_SESSION['list_of_cds'])) { $_SESSION['list_of_cds'] = array(); } $app = new Silex\Application(); $app->register(new Silex\Provider\TwigServiceProvider(), array('twig.path' => __DIR__ . '/../views')); $app->get('/', function () use($app) { return $app['twig']->render('cd_organizer.html.twig', array('cds' => Cd::getAll())); }); $app->get('/new_cd', function () use($app) { return $app['twig']->render('create_cd.html.twig'); }); $app->post('/create_cd', function () use($app) { $album = new Cd($_POST['newCd'], $_POST['newArtist']); $album->save(); return $app['twig']->render('new_cd.html.twig', array('newcd' => $album)); }); $app->get('/delete_cds', function () use($app) { Cd::deleteAll(); return $app['twig']->render('delete_cds.html.twig'); }); $app->get('/search_by_artist', function () use($app) { return $app['twig']->render('search_by_artist.html.twig'); }); $app->post('/results', function () use($app) { $results = array(); $searched_artist = strtolower($_POST['artistSearch']); foreach ($_SESSION['list_of_cds'] as $cd) { if (strtolower($cd->getArtist()) == $searched_artist) {