public function model(array $row) { $data['TransactionDate'] = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($row[0])->format('Y-m-d'); $data['Loginemail'] = $row[1];
//******************** Check the user exists******************//
$VerfiyUser = DB::table('users')->where('email','=',$data['Loginemail'])->count();
if($VerfiyUser==1)
{
//******************** Check the Data exists From Transactionstage******************//
$checkDataexesist = DB::table('transactionstage')
->where('Loginemail', '=' , $data['Loginemail'])
->where('TransactionDate', '=' , $data['TransactionDate'])->count();
if($checkDataexesist==0){
$rec = DB::table('users')->where('email','LIKE','%'.$row[1].'%')->first();
$data = array();
$data['Userid'] = $rec->id;
$data['TransactionDate'] = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($row[0])->format('Y-m-d');
$data['SuccessLinks'] = $row[2];
$data['NotFoundLinks'] = $row[3];
$data['UploadDate'] = date('d-m-Y');
$data['Loginemail'] = $row[1];
$data['UploadBatchID'] = Session::get('Batchid');
$data['UploadBy'] = Auth::user()->id;
$data['Status'] = 0;
DB::table("transactionstage")->insert($data);
}else
{
// $Duplicateenty = $data['Loginemail'];
// echo 'Duplicate Entry'.$Duplicateenty.'-------->return duplicate data form insert screen';
// die();
}
}else
{
$invalidUser = $data['Loginemail'];
// return redirect('adminupload')->with ("Error","The".$invalidUser." user Not In the user List The Batch is not Accept");
}
}
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire