コード例 #1
0
 public function importAppointments()
 {
     if (Input::hasFile('file')) {
         $file = Input::file('file');
         Appointment::truncate();
         Excel::load($file, function ($reader) {
             $reader->setDateFormat('j/n/Y H:i:s');
             $results = $reader->get();
             foreach ($results as $result) {
                 $args = ['user_id' => 2, 'lead_id' => $result->lead_id, 'agent_id' => NULL, 'appointment_confirmed' => $result->confirmed, 'appointment_date' => Carbon::parse($result->appointment_set_date)];
                 Appointment::create($args);
                 $lead = Lead::find($result->lead_id);
                 if ($lead) {
                     $lead->lead_acceptance_type = $result->dta;
                     $lead->save();
                 }
                 var_dump($result);
             }
         });
     }
 }