';print_r($value);
                    $serviceProviders = $this->quotationToSpRepository->getAllByCondition(array('quotation_id'=>$value->id));
                    $userdetails = $this->userRepository->findById(array('id'=>$value->posted_id));
                    $cityDetails =  $this->cityRepository->getAllById($value->city_id);
                    $serviceDetails =  $this->serviceRepository->getAllById($value->city_id);
                    if($serviceProviders) {
                        foreach ($serviceProviders as $k => $v) {
                            $serviceProvidersdetails = $this->userRepository->findById(array('id'=>$v->serviceprovider_id));
                            $to = $serviceProvidersdetails->email;
                            $email_text='   
                                                
                                                   
Dear '.$serviceProvidersdetails->first_name.' '.$serviceProvidersdetails->last_name.' 
                                                
                                            
                                            
                                                
                                                   
We are informing you that, there is a User posted quotation for you, if you inrested please find it.
                                                   
Quotation details follows:
                                                   
Quotation ID: '.$value->id.'
                                                   
User Name: '.$userdetails->first_name.' '.$userdetails->last_name.'
                                                   
Quotation Date: '.date('Y-m-d H:i:s').'
                                                   
Quotation City: '.$cityDetails->city_name.'
                                                   
Quotation Service: '.$serviceDetails->category_name.'
                                                   
Quotation Message: '.$value->quotation_message.'
                                                
                                            
                                            
                                                
                                                   
Stay connected with us. We appreciate very much your trust in us.
                                                   
Please do not hesitate to contact us for any other requests.
                                                
                                            ';
                                    //echo $to.'|'.$email_text; die;
                            $data['email_text'] = $email_text;    
                            Mail::send('frontend.mail.email_template', $data, function($message) use ($to)
                            {
                                $message->from($this->fromemail, $this->fromname);
                                $message->to($to);
                                $message->subject('Quotation post mail');
                            });
                            $this->quotationRepository->update(array('id'=>$value->id),array('cron_firing_time'=>date('Y-m-d H:i:s')));
                        }
                    }
                }
            }
        }
    }
    /**
     * @return \Illuminate\Cron
     */
    public function emails()
    {
        $email_text='   
                            
                               
Dear Milan Rock 
                            
                        
                        
                            
                               
We are informing you that, there is a User posted quotation for you, if you inrested please find it.
                               
Quotation details follows:
                               
Quotation ID: 112
                               
User Name: Sayan Rock
                               
Quotation Date: 31-01-2019 00:00:00
                               
Quotation City: Augura
                               
Quotation Service: Plumber
                               
Quotation Message: Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test 
                            
                        
                        
                            
                               
Stay connected with us. We appreciate very much your trust in us.
                               
Please do not hesitate to contact us for any other requests.
                            
                        ';
        $data['email_text'] = $email_text;
        return view('frontend.mail.email_template',['email_text'=>$email_text]);
    }
}