public function saveSegmentMap($dataaccount)
{
/* $deleteIds = Word::where('dataaccount', $dataaccount)->get( array('id') );
$notDeleteIds = []; $tmp = [];
*/
//return Response::json( count(Input::get('idsToBeDeleted')) );
if (count(Input::get('idsToBeDeleted')) > 0) {
Keyword::destroy(Input::get('idsToBeDeleted'));
// refresh wordcloud only if some keyword is deleted
Word::where('dataaccount', $dataaccount)->delete();
Word::createWordCloud($dataaccount);
}
foreach (Input::get('segmentMap') as $k => $word) {
Word::where('dataaccount', $dataaccount)->where('word', $word['word'])->update(array('segment' => $word['segment'], 'brand' => $word['brand'], 'compete' => $word['compete'], 'negativeword' => $word['negativeword'], 'stopword' => $word['stopword']));
// 'numword'=>$word['numword'],
// 'dataaccount'=>$word['dataaccount']) );
//$notDeleteIds[] = $word['id'];
//Word::find( $word['id'] )->update($word);
}
/*
foreach($deleteIds as $k=>$v)
{
if(in_array($v['id'], $notDeleteIds)) $tmp[] = $v['id'];
}
return $tmp;
*/
return Response::json(array('success' => true));
/*
//return Response::json( count(Input::get('toBeDeleted')) );
if( count(Input::get('toBeDeleted')) > 0 ) Keyword::destroy(Input::get('toBeDeleted'));
$tempId = [];
$tempSeg = [];
//return Response::json( count(Input::get('segmentMap')) );
if( count(Input::has('segmentMap')) > 0)
{
foreach(Input::get('segmentMap') as $key => $val)
{
$tempId[] = $val['id'];
$tempSeg[] = $val['segment'];
Keyword::find($val['id'])->update( array('usersegment' => $val['segment']) );
}
}
//Keyword::find($tempId)->update( array('usersegment' => $tempSeg) )->save();
return Response::json( Keyword::find($tempId) );
//return Response::json( array('success' => true) );
//return Response::json( Input::get('segmentMap') );
*/
}
public function uploadCSV()
{
//return public_path();
$dataAccount = DataAccount::create(array('dataaccount' => Input::get('newdataaccount'), 'user_id' => Input::get('user_id')));
$dataaccount = $dataAccount->id;
//return Input::get('newdataaccount');
if (Input::hasFile('file')) {
$file = Input::file('file');
$name = time() . '-' . $file->getClientOriginalName();
//check out the edit content on bottom of my answer for details on $storage
//$storage = public_path().'/../app/storage';
$storage = public_path();
$path = $storage . '/uploads/CSV/';
// Moves file to folder on server
$file->move($path, $name);
// Import the moved file to DB and return OK if there were rows affected
$this->_import_csv($path, $name, $dataaccount);
//? 'OK' : 'No rows affected' );
// After upload create word cloud
return Response::json(Word::createWordCloud($dataaccount));
return 'OK';
//? 'OK' : 'No rows affected' );
}
//return Response::json( Input::file('file')->getClientOriginalName() );
}