/** * Store a newly created resource in storage. * * @return Response */ public function store() { $url = new LandingPageUrl(array('landingpageurl' => Input::get('landingpageurl'))); $dataaccount = DataAccount::find(Input::get('dataaccount')); $url->dataAccount()->associate($dataaccount); return Response::json($url->save()); }
public function fetchDataSetsByUserId($userId) { // Return all data accounts $temp = []; // AUTHENTICATION NOT IMPLIMENTED //$dataac = DataAccount::where('user_id', $userId)->get(); $dataac = DataAccount::get(); foreach ($dataac as $k => $v) { $v->keywordCount = Keyword::where('dataAccount', $v->id)->count(); $v->landingPageUrls = $v->landingPageUrls()->get(); // Laravel's magic $temp[] = $v; } return Response::json($temp); //return Response::make(DataAccount::get()); return $userId; }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { // Delete the data account and all data associated with it $lp = DataAccount::find($id)->landingPageUrls()->get(); // Laravel's magic foreach ($lp as $v) { DB::table('landingpagewordcloud')->where('landing_page_urls_id', $v->id)->delete(); } DataAccount::find($id)->landingPageUrls()->delete(); DataAccount::destroy($id); Keyword::where('dataAccount', $id)->delete(); Stopword::where('dataAccount', $id)->delete(); Negativekeyword::where('dataAccount', $id)->delete(); DB::table('keywords_segment')->where('dataAccount', $id)->delete(); DB::table('segmentmap')->where('dataAccount', $id)->delete(); DB::table('wordcloud')->where('dataAccount', $id)->delete(); //DB::statement( 'drop database data_' . $id ); return Response::json(array('success' => true)); }