';print_r($advance);die;
        #advance current qtr : collecting advances based on the qtr selected
        $amount_current_quarter = array();
        foreach($advance as $item){
            $item = get_object_vars($item);

            #if not a custom array, filter it based on the year and quarter
            if($selected_quarter != 5 ){
                if($item['advance_quarter']==$selected_quarter && $item['advance_year'] == $selected_year){
                    $amount_current_quarter[$item['book_id']][] =$item['advance_amount'];
                }else{
                   
                    $amount_current_quarter[$item['book_id']][]=0;
                }
            }else{

                #custom quarter dates
                $default_first_date = date('Y-m-d', strtotime($selected_year . '-' . ((1 * 3) - 2) . '-1'));
                $default_last_date = date('Y-m-t', strtotime($selected_year . '-' . ((4 * 3)) . '-1'));

                if(\Session::get('week_from') == ""){
                    $custom_week_from = $default_first_date; 
                }else{
                    $custom_week_from = \Session::get('week_from');
                }  

                if(\Session::get('week_to') == ""){
                    $custom_week_to = $default_last_date;
                }else{
                   $custom_week_to = \Session::get('week_to');
                } 

                $custom_quarter_from = ceil(date('m', strtotime($custom_week_from))/3);
                $custom_quarter_to = ceil(date('m', strtotime($custom_week_to))/3);

                #custom quarter amount
                if($item['advance_year'] == $selected_year && ( $item['advance_quarter'] >= $custom_quarter_from && $item['advance_quarter'] <= $custom_quarter_to )){

                    $amount_current_quarter[$item['book_id']][] =$item['advance_amount'];

                }else{
                    if(!isset($amount_current_quarter)){

                        $amount_current_quarter[$item['book_id']][]=0;
                    }
                }
            }
        }
        
        #append advance data in book details
        foreach($amount_current_quarter as $bookid=>$advance){
            foreach($book_details as $key=>$book){
                if($bookid == $book['id']){
                    $book_details[$key]['advance'] = array_sum($advance);
                }
            }
        }

        #excel sheet fields            
        $b_details = array();
        $b_details[] = ['BOOK NAME','ISBN Physical 13','ISBN Digital 13','ISBN 10','DIAMOND CODE','QB CLASSES','PRINT PRICE (In Dollars)','DIGITAL PRICE (In Dollars)','EXPENSE (In Dollars)','ADVANCE (In Dollars)'];
        foreach($book_details as $bd){
            unset($bd['id']);
            $b_details[]  = $bd;
        } 

        #setting up quarter values
        if($selected_quarter == '1'){
            $quarter = '1st Qtr';
        }else if($selected_quarter == '2'){
            $quarter = '2nd Qtr';
        }else if($selected_quarter == '3'){
            $quarter = '3rd Qtr';
        }else if($selected_quarter == '4'){
            $quarter = '4th Qtr';
        }else if($selected_quarter == '5'){
            $quarter = 'Custom Qtr';
        }

        #running the excel
        try{
            return Excel::create('expense_advance_sheet_('.$quarter.' - '.$selected_year.')'.date("m/d/Y"), function($excel) use ($b_details){
                $excel->setTitle('Books/Percentage');
                $excel->setDescription('Book Report');
                $excel->sheet('sheet', function($sheet) use ($b_details){
                    $sheet->fromArray($b_details, null, 'A1', false, false);
                    #Align starts
                    $sheet->getDefaultStyle()
                    ->getAlignment()
                    ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
                    #Align ends
                });
            })->download('xls');
        }catch(\Exception $e){
            return $e->getMessage();
        }
    }/***ends download_expense_advance sheet***/


    /**
    Add / Save Comment Function starts
    **/

    public function add_comment_popup(Request $request){
        #redirect to home if user not a contributor
        if(\Session::get('login_type') != 1){
            return redirect()->route('dashboard');
        }        
        #request to view the comment
        if($request->has('view_comment')){

            #contributor id
            $contri_id = $request['id'];
            
            ##logged in user
            $id = Auth::user()->id;

            #collecting the comment
            try{
                $contr_details = DB::table('users')
                ->select('users.id','users.name','users.merged_contributor','users.email','users.login_type','users.added_by','users.contributor_comment')
                ->where(function ($query) {
                    $query->where('users.merged_contributor','!=',1)
                        ->orWhereNull('users.merged_contributor');
                })  
                ->where('added_by',$id)
                ->where('id',$contri_id)
                ->where('login_type', 2)
                ->get()->toArray();
               
            }catch(\Exception $e){
                return $e->getMessage();
            }

            #putting the comment in var
            foreach($contr_details as $details){
                $name = $details->name;
                $contri_comment = $details->contributor_comment;
            }

            #returning the reponse
            return response()->json(array(
                'success'=>1,
                'contri_id'=>$contri_id,
                'name' => $name,
                'contri_comment' => $contri_comment, 
            ));
        }#request to view comments ends here
        
        
        /***********
        Save Comment Added for contributor
        ************/

        if($request->has('add_comment_report')){

            $data = $request->all();

            #contributor id
            $contributor_id = $request->contributor_id;

            #comment
            $contributor_add_comment = $request->add_comment;

            if(empty($contributor_add_comment)){

                try{
                    $contr_comment_update_empty = DB::table('users')->where('id', $contributor_id)->update(['contributor_comment' => $data['add_comment']]);
                }catch(\Exception $e){
                    return $e->getMessage();
                }

                if($contr_comment_update_empty == 0){
                    return response()->json(array(
                        'msg'=> 'No Comment was entered.',
                        'error'=>1,
                    ));
                }else{
                    return response()->json(array(
                        'msg'=> 'Unable to process.',
                        'error'=>1,
                    ));
                }
            }

            #checking if the added comment is already added.
            try{
                $contr_comment_text = DB::table('users')
                                    ->where('id', $contributor_id)
                                    ->where('contributor_comment', $contributor_add_comment)
                                    ->first();
            }catch(\Exception $e){
                return $e->getMessage();
            }

            #if not added, update
            try{
                if(empty($contr_comment_text)){
                    try{
                        $contributor_comment = DB::table('users')->where('id', $contributor_id)->update(['contributor_comment' => $data['add_comment']]);
                    }catch(\Exception $e){
                        return $e->getMessage();
                    }

                    if($contributor_comment == 1){
                        return response()->json(array(
                            'msg'=> 'Comment added successfully.',
                            'success'=>1,
                        ));
                    }else{
                        return response()->json(array(
                            'msg'=> 'Unable to add comment.',
                            'error'=>1,
                        ));
                    }
                }
            }catch(\Exception $e){
                return $e->getMessage();
            }
            
            #if value exists then dont update
            if($contr_comment_text){
                return response()->json(array(
                    'msg'=> 'Comment already saved.',
                    'error'=>1,
                ));
            }
        }#end of save comment if
    } #ends add /save comment function
} /* End Controller*/