public function submitforhelp()
 {
     if (!empty(Input::get('question_id'))) {
         $question_id = Input::get('question_id');
     }
     $giver_id = Auth::user()->id;
     if (!empty($question_id) && !empty($giver_id)) {
         $Questionwillingtohelp = new Questionwillingtohelp();
         $Questionwillingtohelp->question_id = $question_id;
         $Questionwillingtohelp->user_id = $giver_id;
         if ($Questionwillingtohelp->save()) {
             $helper = User::find($giver_id);
             $helper->karmascore = $helper->karmascore + 2;
             if ($helper->save()) {
                 return Redirect::to('/karma-queries');
             }
         }
     }
 }
 public static function otherProfileTrail()
 {
     $karmacircleFeed = Karmafeed::select('message_type As type', 'id_type', 'receiver_id', 'giver_id', 'updated_at')->get();
     foreach ($karmacircleFeed as $karmaFeed) {
         $receiverId = $karmaFeed->receiver_id;
         $giverId = $karmaFeed->giver_id;
         $karmaFeedMessage = $karmaFeed->type;
         $karmaFeedId = $karmaFeed->id_type;
         $karmaFeedDate = $karmaFeed->updated_at;
         if (!empty($receiverId)) {
             $receiverData = User::where('id', '=', $receiverId)->select('fname As receiverFirstName', 'lname As receiverLastName', 'piclink As receiverPic')->first();
         }
         if (!empty($giverId)) {
             $giverData = User::where('id', '=', $giverId)->select('fname As giverFirstName', 'lname As giverLastName', 'piclink As giverPic')->first();
         }
         if ($karmaFeedMessage == 'KarmaNote') {
             $getKarmaNoteDetails = Karmanote::where('id', '=', $karmaFeedId)->select(array('karmanotes.details As description'))->first();
             $karmaNoteFeed[] = array_merge($karmaFeed->toArray(), $getKarmaNoteDetails->toArray(), $giverData->toArray(), $receiverData->toArray());
         } else {
             $karmacircleFeedCount = DB::table('users_karmafeeds')->where('message_type', '=', 'KarmaNote')->count();
             if ($karmacircleFeedCount < 1) {
                 $karmaNoteFeed = array();
             }
         }
         if ($karmaFeedMessage == 'Group') {
             $getGroupDetails = Group::where('id', '=', $karmaFeedId)->select(array('groups.name As name', 'groups.description As description'))->first();
             $groupFeed[] = array_merge($karmaFeed->toArray(), $getGroupDetails->toArray(), $receiverData->toArray());
         } else {
             $karmacircleGroupCount = DB::table('users_karmafeeds')->where('message_type', '=', 'Group')->count();
             if ($karmacircleGroupCount < 1) {
                 $groupFeed = array();
             }
         }
         if ($karmaFeedMessage == 'KarmaQuery') {
             $getQueryDetails = Question::where('id', '=', $karmaFeedId)->select(array('questions.queryStatus As queryStatus', 'questions.description As description'))->first();
             $queryFeed[] = array_merge($karmaFeed->toArray(), $getQueryDetails->toArray(), $receiverData->toArray());
         } else {
             $karmacircleQueryCount = DB::table('users_karmafeeds')->where('message_type', '=', 'Question')->count();
             if ($karmacircleQueryCount < 1) {
                 $queryFeed = array();
             }
         }
         if ($karmaFeedMessage == 'OfferHelpTo') {
             $getOfferHelpDetails = Question::where('id', '=', $karmaFeedId)->select(array('questions.queryStatus As queryStatus', 'questions.description As description'))->first();
             $getOfferHelpCount = Questionwillingtohelp::has('id')->where('user_id', '=', $receiverId)->where('question_id', '=', $karmaFeedId)->count();
             $offerHelpToFeed[] = array_merge($karmaFeed->toArray(), $getOfferHelpDetails->toArray(), $receiverData->toArray(), $giverData->toArray());
         } else {
             $offerHelpToFeedCount = DB::table('users_karmafeeds')->where('message_type', '=', 'OfferHelpTo')->count();
             if ($offerHelpToFeedCount < 1) {
                 $offerHelpToFeed = array();
             }
         }
     }
     $feed = array_merge($karmaNoteFeed, $groupFeed, $queryFeed);
     $sort = array();
     foreach ($feed as $k => $v) {
         $sort['updated_at'][$k] = $v['updated_at'];
     }
     array_multisort($sort['updated_at'], SORT_DESC, $feed);
     echo "<pre>";
     print_r($arr);
     die;
     echo '<pre>';
     print_r($feed);
     die;
 }
 public function deletequery()
 {
     $id = Input::get('queryId');
     $deleteQuestionwillingtohelp = Questionwillingtohelp::where('question_id', '=', $id)->delete();
     $deleteGroupQuestion = Groupquestion::where('question_id', '=', $id)->delete();
     $deleteQuestion = Question::where('id', '=', $id)->delete();
     $deleteKarmafeed = Karmafeed::where('id_type', '=', $id)->whereIn('message_type', array('KarmaQuery', 'OfferHelpTo'))->delete();
     $deleteMykarma = Mykarma::where('entry_id', '=', $id)->whereIn('users_role', array('PostedQuery', 'OfferedHelp'))->delete();
     echo "Question " . $id . " deleted";
 }