/**
* 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));
}
