vendredi 9 août 2019

how can i gat Laravel maataweb excel return error message

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