ONE PIECE HACKING

Ngiler SH3LL 360
: / home / tbf / membrubackend / app / Console / Commands /

Information Server
MySQL : OFF Perl : OFF CURL : ON WGET : OFF PKEXEC : OFF

Directive	Local Value
IP Address	89.40.16.97
System	Linux server.atelieruldeit.ro 3.10.0-1160.el7.x86_64 #1 SMP Mon Oct 19 16:18:59 UTC 2020 x86_64
User	tbf
PHP Version	7.3.33
Software	Apache
Doc root	Writable

Edit File : CreateInvoiceCommand.php \| Size : 23.38 KB
<?php namespace App\Console\Commands; use Illuminate\Console\Command; use App\Models\Invoice; use App\Models\Instance; use Carbon\Carbon; use Illuminate\Support\Facades\Mail; use App\Repositories\InvoiceRepository; use Str; class CreateInvoiceCommand extends Command { /** * The name and signature of the console command. * * @var string / protected $signature = 'command:create-invoice-and-enroll-to-learn'; /* * The console command description. * * @var string / protected $description = 'Send invoice to clients'; /* * Create a new command instance. * * @return void / public function __construct() { parent::__construct(); } /* * Execute the console command. * * @return mixed */ public function handle() { $proforme = array( // array( // 'ID' => '301', // 'nr PROFORMA' => 1165, // 'Serie factura' => 'SM', // 'SUMA' => 5242, // 'Status' => 'incasat OP', // 'CE CURS' => 'Vanzari', // 'Email' => 'bigmattrade@gmail.com', // 'Nume' => 'Hancu Catalin', // 'CNP' => '', // 'Nume companie' => 'SC BIGMAT TRADE SRL', // 'CUI"' => '15875330"' // ), array( 'ID' => '315', 'nr PROFORMA' => 1173, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'oana.leotescu@soft-tehnica.com', 'Nume' => 'Oana Leotescu', 'CNP' => '', 'Nume companie' => 'SOFTTEHNICA SRL', 'CUI"' => 'RO16819215"' ), array( 'ID' => '333', 'nr PROFORMA' => 1182, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'sabin@ebin.ro', 'Nume' => 'Sabin Podea', 'CNP' => '', 'Nume companie' => 'SC EBIN ONLINE SRL', 'CUI"' => 'RO33759954"' ), array( 'ID' => '312', 'nr PROFORMA' => 1172, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'elisabeta@secoplan.ro', 'Nume' => 'Hajnal-Elisabeta Kakucs', 'CNP' => '', 'Nume companie' => 'Secoplan Building Systems SRL', 'CUI"' => 'RO 36164462"' ), array( 'ID' => '339', 'nr PROFORMA' => 1186, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'ioanamacavei@yahoo.com', 'Nume' => 'IOANA BARA', 'CNP' => '', 'Nume companie' => 'santa viva med srl', 'CUI"' => '32814139"' ), array( 'ID' => '392', 'nr PROFORMA' => 1217, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'luxorientminna@gmail.com', 'Nume' => 'Maria Costina Ursu', 'CNP' => '', 'Nume companie' => 'Sc Luxorient Minna Parfum SRL', 'CUI"' => 'RO41815362"' ), array( 'ID' => '367', 'nr PROFORMA' => 1203, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'paul@corporationconstruct.ro', 'Nume' => 'Paul Constantin Sibianu', 'CNP' => '', 'Nume companie' => 'Corporation Construct Srl', 'CUI"' => 'RO18691995"' ), array( 'ID' => '396', 'nr PROFORMA' => 1218, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'dianaboca@ymail.com', 'Nume' => 'Diana Apetri', 'CNP' => '', 'Nume companie' => 'DORNA MEDICAL', 'CUI"' => '15978905"' ), array( 'ID' => '389', 'nr PROFORMA' => 1215, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'sabin.marinescu@gmail.com', 'Nume' => 'SOFI-SABIN MARINESCU', 'CNP' => '', 'Nume companie' => 'ALM POWER GROUP SRL', 'CUI"' => 'RO32610317"' ), array( 'ID' => '379', 'nr PROFORMA' => 1209, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'paul@corporationconstruct.ro', 'Nume' => 'Paul Constantin Sibianu', 'CNP' => '', 'Nume companie' => 'Corporation Construct Srl', 'CUI"' => 'RO18691995"' ), array( 'ID' => '398', 'nr PROFORMA' => 1220, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'sandra.isfan1989@gmail.com', 'Nume' => 'SANDRA NICOARA', 'CNP' => '', 'Nume companie' => 'Sandra Lashes Makeup SRL', 'CUI"' => '37381575"' ), array( 'ID' => '426', 'nr PROFORMA' => 1233, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'lupu.elena.alina@gmail.com', 'Nume' => 'Elena alina Lupu', 'CNP' => '', 'Nume companie' => 'Passionate Clinic srl', 'CUI"' => '42055141"' ), array( 'ID' => '411', 'nr PROFORMA' => 1227, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'ionel.rasinar@goldenimobiliare.ro', 'Nume' => 'Ionel Rasinar', 'CNP' => '', 'Nume companie' => 'Golden Imozone', 'CUI"' => '36395530"' ), array( 'ID' => '331', 'nr PROFORMA' => 1180, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'elena@rocktrans.ro', 'Nume' => 'Elena Ladariu', 'CNP' => '', 'Nume companie' => 'Rock Trans Spedition SRL', 'CUI"' => 'RO31736040"' ), array( 'ID' => '294', 'nr PROFORMA' => 1162, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'elena@rocktrans.ro', 'Nume' => 'Elena Ladariu', 'CNP' => '', 'Nume companie' => 'Rock Trans Spedition SRL', 'CUI"' => 'RO31736040"' ), array( 'ID' => '429', 'nr PROFORMA' => 1234, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'paulpantea@zaharlaplic.ro', 'Nume' => 'Paul Pantea', 'CNP' => '', 'Nume companie' => 'gelmaxim', 'CUI"' => '31300660"' ), array( 'ID' => '434', 'nr PROFORMA' => 1239, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'dragoslav_florin@yahoo.com', 'Nume' => 'Florin Dragoslav', 'CNP' => '', 'Nume companie' => 'Galaxy Imob Real Estate', 'CUI"' => '38390130"' ), array( 'ID' => '359', 'nr PROFORMA' => 1201, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'dianaboca@ymail.com', 'Nume' => 'DIANA APETRI', 'CNP' => '', 'Nume companie' => 'DORNA MEDICAL', 'CUI"' => '15978905"' ), array( 'ID' => '413', 'nr PROFORMA' => 1228, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'calin.hidrogeofor@gmail.com', 'Nume' => 'Alexandru Calin', 'CNP' => '', 'Nume companie' => 'HIDROGEOFOR SRL', 'CUI"' => 'RO17998100"' ), array( 'ID' => '433', 'nr PROFORMA' => 1238, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'ionel.rasinar@goldenimobiliare.ro', 'Nume' => 'Ionel Rasinar', 'CNP' => '', 'Nume companie' => 'Golden Imozone', 'CUI"' => 'RO36395530"' ), array( 'ID' => '409', 'nr PROFORMA' => 1226, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'nicolaebadea1982@yahoo.com', 'Nume' => 'Nicolae Badea', 'CNP' => '', 'Nume companie' => 'Cofetaria Narcisa', 'CUI"' => 'RO1355443"' ), array( 'ID' => '375', 'nr PROFORMA' => 1208, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'calinachim2008@gmail.com', 'Nume' => 'Calin Achim', 'CNP' => '', 'Nume companie' => 'CAR OANCEAKIM SRL', 'CUI"' => 'RO43410551"' ), array( 'ID' => '387', 'nr PROFORMA' => 1214, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'calinachim2008@gmail.com', 'Nume' => 'Calin Achim', 'CNP' => '', 'Nume companie' => 'CAR OANCEAKIM SRL', 'CUI"' => 'RO43410551"' ), array( 'ID' => '473', 'nr PROFORMA' => 1262, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'csongor@mobman.ro', 'Nume' => 'Csongor Nagy', 'CNP' => '', 'Nume companie' => 'Mebelissimo Srl', 'CUI"' => 'RO41213669"' ), array( 'ID' => '475', 'nr PROFORMA' => 1263, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'csongor@mobman.ro', 'Nume' => 'Csongor Nagy', 'CNP' => '', 'Nume companie' => 'Mebelissimo Srl', 'CUI"' => 'RO41213669"' ), array( 'ID' => '450', 'nr PROFORMA' => 1250, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'dacia.hincu5@gmail.com', 'Nume' => 'Dacia Hincu', 'CNP' => '', 'Nume companie' => 'Vizual Med', 'CUI"' => '23885041"' ), array( 'ID' => '438', 'nr PROFORMA' => 1242, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'dacia.hincu5@gmail.com', 'Nume' => 'Dacia Hincu', 'CNP' => '', 'Nume companie' => 'Vizual Med', 'CUI"' => '23885041"' ), array( 'ID' => '382', 'nr PROFORMA' => 1211, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'office@opsimus.ro', 'Nume' => 'VALENTIN COSTEL POLHAC', 'CNP' => '', 'Nume companie' => 'sc OPSIMUS SRL', 'CUI"' => 'RO 7123647"' ), array( 'ID' => '492', 'nr PROFORMA' => 1273, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'mari.smilevisionro@gmail.com', 'Nume' => 'Zaharia Mariana', 'CNP' => '', 'Nume companie' => 'Business Services For You S.R.L', 'CUI"' => '38594822"' ), array( 'ID' => '342', 'nr PROFORMA' => 1188, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'tanasov@gmail.com', 'Nume' => 'Dumitru TANASOV', 'CNP' => '', 'Nume companie' => 'FINOMATEX', 'CUI"' => '32234646"' ), array( 'ID' => '346', 'nr PROFORMA' => 1192, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'petre.ghita@triton.com.ro', 'Nume' => 'Ghita Petre SC TRITON SRL', 'CNP' => '', 'Nume companie' => 'SC TRITON SRL', 'CUI"' => '7424364"' ), array( 'ID' => '358', 'nr PROFORMA' => 1200, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'petre.ghita@triton.com.ro', 'Nume' => 'PETRE GHITA', 'CNP' => '', 'Nume companie' => 'SC TRITON SRL', 'CUI"' => '7424364"' ), array( 'ID' => '446', 'nr PROFORMA' => 1247, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'steinfrancisc@hennlich.ro', 'Nume' => 'Francisc Stein', 'CNP' => '', 'Nume companie' => 'SC HENNLICH SRL', 'CUI"' => 'RO18137214"' ), array( 'ID' => '442', 'nr PROFORMA' => 1244, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'steinfrancisc@gmail.com', 'Nume' => 'Francisc Stein', 'CNP' => '', 'Nume companie' => 'SC HENNLICH SRL', 'CUI"' => 'RO18137214"' ), array( 'ID' => '308', 'nr PROFORMA' => 1169, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'ioan.popa@smarthotel.ro', 'Nume' => 'Ioan Popa', 'CNP' => '', 'Nume companie' => 'Artur Smart Srl', 'CUI"' => '14644478"' ), array( 'ID' => '397', 'nr PROFORMA' => 1219, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'ana.nedea@simtel.ro', 'Nume' => 'Ana Nedea', 'CNP' => '', 'Nume companie' => 'Simtel Team SA', 'CUI"' => 'RO26414626"' ), array( 'ID' => '300', 'nr PROFORMA' => 1164, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'marian@f64studio.ro', 'Nume' => 'Alecsiu Marian Dan', 'CNP' => '', 'Nume companie' => 'F64 Studio s.r.l.', 'CUI"' => '14080808"' ), array( 'ID' => '430', 'nr PROFORMA' => 1235, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'saris.fruit@gmail.com', 'Nume' => 'Saris Ionut', 'CNP' => '', 'Nume companie' => 'saris fruit srl', 'CUI"' => '32284997"' ), array( 'ID' => '421', 'nr PROFORMA' => 1231, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'ene.andraioana@yahoo.com', 'Nume' => 'Andra ioana Ene', 'CNP' => '', 'Nume companie' => 'SC RECOVER SRL', 'CUI"' => '17867520"' ), array( 'ID' => '363', 'nr PROFORMA' => 1202, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'office@rsbauro.ro', 'Nume' => 'ALINA TAREAN', 'CNP' => '', 'Nume companie' => 'RSBAURO', 'CUI"' => 'RO18573973"' ), array( 'ID' => '341', 'nr PROFORMA' => 1187, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'office@rsbauro.ro', 'Nume' => 'ALINA TAREAN', 'CNP' => '', 'Nume companie' => 'RSBAURO', 'CUI"' => 'RO18573973"' ), array( 'ID' => '330', 'nr PROFORMA' => 1179, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'mihai.moisei@optilab.ro', 'Nume' => 'Mihai Moisei', 'CNP' => '', 'Nume companie' => 'Optilab Solutions', 'CUI"' => '40367767"' ), array( 'ID' => '443', 'nr PROFORMA' => 1245, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'eugen.uta@basicra.ro', 'Nume' => 'Eugen Uta', 'CNP' => '', 'Nume companie' => 'Basicra Prod Serv SRL', 'CUI"' => 'RO10092974"' ), array( 'ID' => '445', 'nr PROFORMA' => 1246, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'silvian@bestautovest.ro', 'Nume' => 'Nanea Silvian', 'CNP' => '', 'Nume companie' => 'e-autoparts europa srl', 'CUI"' => 'ro32372789"' ), array( 'ID' => '500', 'nr PROFORMA' => 1278, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'madalina.milesan@euronarcis.ro', 'Nume' => 'MADALINA MILESAN', 'CNP' => '', 'Nume companie' => 'EURO NARCIS SRL', 'CUI"' => 'RO14953201"' ), array( 'ID' => '499', 'nr PROFORMA' => 1277, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'madalina.milesan@euronarcis.ro', 'Nume' => 'MADALINA MILESAN', 'CNP' => '', 'Nume companie' => 'EURO NARCIS SRL', 'CUI"' => 'RO14953201"' ), array( 'ID' => '488', 'nr PROFORMA' => 1269, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'demco@demco.ro', 'Nume' => 'Calangea Doru', 'CNP' => '', 'Nume companie' => 'DEMCO ELECTRO DESIGN S.R.L.', 'CUI"' => 'RO 26521185"' ), array( 'ID' => '305', 'nr PROFORMA' => 1167, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'adrianpopescu@emtsolutions.eu', 'Nume' => 'Adrian Popescu', 'CNP' => '', 'Nume companie' => 'EMT Solutions SRL', 'CUI"' => 'ro35947725"' ), array( 'ID' => '423', 'nr PROFORMA' => 1232, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'corina.bartalici@yload.ro', 'Nume' => 'Corina Huzau', 'CNP' => '', 'Nume companie' => 'Yload Global SA', 'CUI"' => 'RO41337497"' ), array( 'ID' => '284', 'nr PROFORMA' => 1156, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'horatiu.otelea@centralmo.ro', 'Nume' => 'Horatiu Otelea', 'CNP' => '', 'Nume companie' => 'Sc Central Moreni Srl', 'CUI"' => '937273"' ), array( 'ID' => '344', 'nr PROFORMA' => 1190, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'adrianpopescu@emtsolutions.eu', 'Nume' => 'Adrian Popescu', 'CNP' => '', 'Nume companie' => 'EMT Solutions SRL', 'CUI"' => 'ro35947725"' ), array( 'ID' => '480', 'nr PROFORMA' => 1265, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'richard.scutermag@gmail.com', 'Nume' => 'Richard Mitrea', 'CNP' => '', 'Nume companie' => 'Motorevolution Franchise', 'CUI"' => 'RO43214326"' ), array( 'ID' => '456', 'nr PROFORMA' => 1253, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'aarmasu@profial.ro', 'Nume' => 'ADRIAN ARMASU', 'CNP' => '', 'Nume companie' => 'A&D PROFIAL COMPANY', 'CUI"' => 'RO6407586"' ), array( 'ID' => '457', 'nr PROFORMA' => 1254, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'Carmen.Mazilu@gigroup.com', 'Nume' => 'Mazilu Carmen', 'CNP' => '', 'Nume companie' => 'Barnett McCall Recruitment', 'CUI"' => '11577960"' ), array( 'ID' => '353', 'nr PROFORMA' => 1196, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'razvan.chirion@kindustrial.ro', 'Nume' => 'Razvan CHIRION', 'CNP' => '', 'Nume companie' => 'Kardynal Intserv Office', 'CUI"' => '31508441"' ), array( 'ID' => '285', 'nr PROFORMA' => 1157, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'razvan.chirion@kindustrial.ro', 'Nume' => 'Razvan CHIRION', 'CNP' => '', 'Nume companie' => 'Kardynal Intserv Office', 'CUI"' => '31508441"' ), array( 'ID' => '469', 'nr PROFORMA' => 1259, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'info@memory.ro', 'Nume' => 'Eva Szabo', 'CNP' => '', 'Nume companie' => 'Memory SRL', 'CUI"' => 'RO10694678"' ), array( 'ID' => '355', 'nr PROFORMA' => 1198, 'Serie factura' => 'SM', 'SUMA' => 5242, 'Status' => 'incasat OP', 'CE CURS' => 'Vanzari', 'Email' => 'mihai.varutoiu@gmail.com', 'Nume' => 'Mihai Varutoiu', 'CNP' => '', 'Nume companie' => 'Agrifond Partners', 'CUI"' => '36152557"' ), array( 'ID' => '334', 'nr PROFORMA' => 1183, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'mihai.varutoiu@gmail.com', 'Nume' => 'Mihai Varutoiu', 'CNP' => '', 'Nume companie' => 'Agrifond Partners', 'CUI"' => '36152557"' ), array( 'ID' => '525', 'nr PROFORMA' => 1289, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'victor@cxcgroup.ro', 'Nume' => 'Victor Donea', 'CNP' => '', 'Nume companie' => 'AD INFINITUM NETWORK SRL', 'CUI"' => 'RO43788329"' ), array( 'ID' => '546', 'nr PROFORMA' => 1304, 'Serie factura' => 'SM', 'SUMA' => 7581, 'Status' => 'incasat OP', 'CE CURS' => 'Management', 'Email' => 'foldvary.andras@landmark-imobiliare.ro', 'Nume' => 'Andras Foldvary', 'CNP' => '', 'Nume companie' => 'MA LANDMARK SRL', 'CUI"' => 'Ro19002452"' ) ); foreach($proforme as $proforma) { $proforma_db = Invoice::where('id',$proforma['ID'])->first(); $instance = $proforma_db->instance; if($instance){ $user = $instance->users->first(); $randPassword = Str::random(8); $user->password = bcrypt($randPassword); $user->save(); // sa trimit email sa aiba parola pentru learnworld $alreadyregisteredInLearn = learworldsInit($user, $randPassword); newUserCreatedMail($user, $randPassword, $alreadyregisteredInLearn); // se genereaza factura $invoice = InvoiceRepository::generateInvoice( $instance->id, $instance->package->price_in_ron, 'paid', 'stripe_payment_id', 'RON', $user->email ); $instance->update([ 'status' => Instance::STATUS_ACTIVE, 'first_payment' => 0, ]); }else{ var_dump("Nu am gasit instanta pentru proforma:".$proforma['ID']); } // add user with tag in active campaign createCronjobActiveCampaign(Auth::user(), 'tbf_curs'); } } } Back

Edit File : CreateInvoiceCommand.php | Size : 23.38 KB

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use App\Models\Invoice;
use App\Models\Instance;
use Carbon\Carbon;
use Illuminate\Support\Facades\Mail;
use App\Repositories\InvoiceRepository;
use Str;

class CreateInvoiceCommand extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'command:create-invoice-and-enroll-to-learn';

/**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Send invoice to clients';

/**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

/**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
		$proforme = array(
		  // array(
		  //   'ID' => '301',
		  //   'nr PROFORMA' => 1165,
		  //   'Serie factura' => 'SM',
		  //   'SUMA' => 5242,
		  //   'Status' => 'incasat OP',
		  //   'CE CURS' => 'Vanzari',
		  //   'Email' => 'bigmattrade@gmail.com',
		  //   'Nume' => 'Hancu Catalin',
		  //   'CNP' => '',
		  //   'Nume companie' => 'SC BIGMAT TRADE SRL',
		  //   'CUI"' => '15875330"'
		  // ),
		  array(
		    'ID' => '315',
		    'nr PROFORMA' => 1173,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'oana.leotescu@soft-tehnica.com',
		    'Nume' => 'Oana Leotescu',
		    'CNP' => '',
		    'Nume companie' => 'SOFTTEHNICA SRL',
		    'CUI"' => 'RO16819215"'
		  ),
		  array(
		    'ID' => '333',
		    'nr PROFORMA' => 1182,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'sabin@ebin.ro',
		    'Nume' => 'Sabin Podea',
		    'CNP' => '',
		    'Nume companie' => 'SC EBIN ONLINE SRL',
		    'CUI"' => 'RO33759954"'
		  ),
		  array(
		    'ID' => '312',
		    'nr PROFORMA' => 1172,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'elisabeta@secoplan.ro',
		    'Nume' => 'Hajnal-Elisabeta Kakucs',
		    'CNP' => '',
		    'Nume companie' => 'Secoplan Building Systems SRL',
		    'CUI"' => 'RO 36164462"'
		  ),
		  array(
		    'ID' => '339',
		    'nr PROFORMA' => 1186,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'ioanamacavei@yahoo.com',
		    'Nume' => 'IOANA BARA',
		    'CNP' => '',
		    'Nume companie' => 'santa viva med srl',
		    'CUI"' => '32814139"'
		  ),
		  array(
		    'ID' => '392',
		    'nr PROFORMA' => 1217,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'luxorientminna@gmail.com',
		    'Nume' => 'Maria Costina Ursu',
		    'CNP' => '',
		    'Nume companie' => 'Sc Luxorient Minna Parfum SRL',
		    'CUI"' => 'RO41815362"'
		  ),
		  array(
		    'ID' => '367',
		    'nr PROFORMA' => 1203,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'paul@corporationconstruct.ro',
		    'Nume' => 'Paul Constantin Sibianu',
		    'CNP' => '',
		    'Nume companie' => 'Corporation Construct Srl',
		    'CUI"' => 'RO18691995"'
		  ),
		  array(
		    'ID' => '396',
		    'nr PROFORMA' => 1218,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'dianaboca@ymail.com',
		    'Nume' => 'Diana Apetri',
		    'CNP' => '',
		    'Nume companie' => 'DORNA MEDICAL',
		    'CUI"' => '15978905"'
		  ),
		  array(
		    'ID' => '389',
		    'nr PROFORMA' => 1215,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'sabin.marinescu@gmail.com',
		    'Nume' => 'SOFI-SABIN MARINESCU',
		    'CNP' => '',
		    'Nume companie' => 'ALM POWER GROUP SRL',
		    'CUI"' => 'RO32610317"'
		  ),
		  array(
		    'ID' => '379',
		    'nr PROFORMA' => 1209,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'paul@corporationconstruct.ro',
		    'Nume' => 'Paul Constantin Sibianu',
		    'CNP' => '',
		    'Nume companie' => 'Corporation Construct Srl',
		    'CUI"' => 'RO18691995"'
		  ),
		  array(
		    'ID' => '398',
		    'nr PROFORMA' => 1220,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'sandra.isfan1989@gmail.com',
		    'Nume' => 'SANDRA NICOARA',
		    'CNP' => '',
		    'Nume companie' => 'Sandra Lashes Makeup SRL',
		    'CUI"' => '37381575"'
		  ),
		  array(
		    'ID' => '426',
		    'nr PROFORMA' => 1233,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'lupu.elena.alina@gmail.com',
		    'Nume' => 'Elena alina Lupu',
		    'CNP' => '',
		    'Nume companie' => 'Passionate Clinic srl',
		    'CUI"' => '42055141"'
		  ),
		  array(
		    'ID' => '411',
		    'nr PROFORMA' => 1227,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'ionel.rasinar@goldenimobiliare.ro',
		    'Nume' => 'Ionel Rasinar',
		    'CNP' => '',
		    'Nume companie' => 'Golden Imozone',
		    'CUI"' => '36395530"'
		  ),
		  array(
		    'ID' => '331',
		    'nr PROFORMA' => 1180,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'elena@rocktrans.ro',
		    'Nume' => 'Elena Ladariu',
		    'CNP' => '',
		    'Nume companie' => 'Rock Trans Spedition SRL',
		    'CUI"' => 'RO31736040"'
		  ),
		  array(
		    'ID' => '294',
		    'nr PROFORMA' => 1162,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'elena@rocktrans.ro',
		    'Nume' => 'Elena Ladariu',
		    'CNP' => '',
		    'Nume companie' => 'Rock Trans Spedition SRL',
		    'CUI"' => 'RO31736040"'
		  ),
		  array(
		    'ID' => '429',
		    'nr PROFORMA' => 1234,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'paulpantea@zaharlaplic.ro',
		    'Nume' => 'Paul Pantea',
		    'CNP' => '',
		    'Nume companie' => 'gelmaxim',
		    'CUI"' => '31300660"'
		  ),
		  array(
		    'ID' => '434',
		    'nr PROFORMA' => 1239,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'dragoslav_florin@yahoo.com',
		    'Nume' => 'Florin Dragoslav',
		    'CNP' => '',
		    'Nume companie' => 'Galaxy Imob Real Estate',
		    'CUI"' => '38390130"'
		  ),
		  array(
		    'ID' => '359',
		    'nr PROFORMA' => 1201,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'dianaboca@ymail.com',
		    'Nume' => 'DIANA APETRI',
		    'CNP' => '',
		    'Nume companie' => 'DORNA MEDICAL',
		    'CUI"' => '15978905"'
		  ),
		  array(
		    'ID' => '413',
		    'nr PROFORMA' => 1228,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'calin.hidrogeofor@gmail.com',
		    'Nume' => 'Alexandru Calin',
		    'CNP' => '',
		    'Nume companie' => 'HIDROGEOFOR SRL',
		    'CUI"' => 'RO17998100"'
		  ),
		  array(
		    'ID' => '433',
		    'nr PROFORMA' => 1238,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'ionel.rasinar@goldenimobiliare.ro',
		    'Nume' => 'Ionel Rasinar',
		    'CNP' => '',
		    'Nume companie' => 'Golden Imozone',
		    'CUI"' => 'RO36395530"'
		  ),
		  array(
		    'ID' => '409',
		    'nr PROFORMA' => 1226,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'nicolaebadea1982@yahoo.com',
		    'Nume' => 'Nicolae Badea',
		    'CNP' => '',
		    'Nume companie' => 'Cofetaria Narcisa',
		    'CUI"' => 'RO1355443"'
		  ),
		  array(
		    'ID' => '375',
		    'nr PROFORMA' => 1208,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'calinachim2008@gmail.com',
		    'Nume' => 'Calin Achim',
		    'CNP' => '',
		    'Nume companie' => 'CAR OANCEAKIM SRL',
		    'CUI"' => 'RO43410551"'
		  ),
		  array(
		    'ID' => '387',
		    'nr PROFORMA' => 1214,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'calinachim2008@gmail.com',
		    'Nume' => 'Calin Achim',
		    'CNP' => '',
		    'Nume companie' => 'CAR OANCEAKIM SRL',
		    'CUI"' => 'RO43410551"'
		  ),
		  array(
		    'ID' => '473',
		    'nr PROFORMA' => 1262,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'csongor@mobman.ro',
		    'Nume' => 'Csongor Nagy',
		    'CNP' => '',
		    'Nume companie' => 'Mebelissimo Srl',
		    'CUI"' => 'RO41213669"'
		  ),
		  array(
		    'ID' => '475',
		    'nr PROFORMA' => 1263,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'csongor@mobman.ro',
		    'Nume' => 'Csongor Nagy',
		    'CNP' => '',
		    'Nume companie' => 'Mebelissimo Srl',
		    'CUI"' => 'RO41213669"'
		  ),
		  array(
		    'ID' => '450',
		    'nr PROFORMA' => 1250,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'dacia.hincu5@gmail.com',
		    'Nume' => 'Dacia Hincu',
		    'CNP' => '',
		    'Nume companie' => 'Vizual Med',
		    'CUI"' => '23885041"'
		  ),
		  array(
		    'ID' => '438',
		    'nr PROFORMA' => 1242,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'dacia.hincu5@gmail.com',
		    'Nume' => 'Dacia Hincu',
		    'CNP' => '',
		    'Nume companie' => 'Vizual Med',
		    'CUI"' => '23885041"'
		  ),
		  array(
		    'ID' => '382',
		    'nr PROFORMA' => 1211,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'office@opsimus.ro',
		    'Nume' => 'VALENTIN COSTEL POLHAC',
		    'CNP' => '',
		    'Nume companie' => 'sc OPSIMUS SRL',
		    'CUI"' => 'RO 7123647"'
		  ),
		  array(
		    'ID' => '492',
		    'nr PROFORMA' => 1273,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'mari.smilevisionro@gmail.com',
		    'Nume' => 'Zaharia Mariana',
		    'CNP' => '',
		    'Nume companie' => 'Business Services For You S.R.L',
		    'CUI"' => '38594822"'
		  ),
		  array(
		    'ID' => '342',
		    'nr PROFORMA' => 1188,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'tanasov@gmail.com',
		    'Nume' => 'Dumitru TANASOV',
		    'CNP' => '',
		    'Nume companie' => 'FINOMATEX',
		    'CUI"' => '32234646"'
		  ),
		  array(
		    'ID' => '346',
		    'nr PROFORMA' => 1192,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'petre.ghita@triton.com.ro',
		    'Nume' => 'Ghita Petre SC TRITON SRL',
		    'CNP' => '',
		    'Nume companie' => 'SC TRITON SRL',
		    'CUI"' => '7424364"'
		  ),
		  array(
		    'ID' => '358',
		    'nr PROFORMA' => 1200,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'petre.ghita@triton.com.ro',
		    'Nume' => 'PETRE GHITA',
		    'CNP' => '',
		    'Nume companie' => 'SC TRITON SRL',
		    'CUI"' => '7424364"'
		  ),
		  array(
		    'ID' => '446',
		    'nr PROFORMA' => 1247,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'steinfrancisc@hennlich.ro',
		    'Nume' => 'Francisc Stein',
		    'CNP' => '',
		    'Nume companie' => 'SC HENNLICH SRL',
		    'CUI"' => 'RO18137214"'
		  ),
		  array(
		    'ID' => '442',
		    'nr PROFORMA' => 1244,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'steinfrancisc@gmail.com',
		    'Nume' => 'Francisc Stein',
		    'CNP' => '',
		    'Nume companie' => 'SC HENNLICH SRL',
		    'CUI"' => 'RO18137214"'
		  ),
		  array(
		    'ID' => '308',
		    'nr PROFORMA' => 1169,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'ioan.popa@smarthotel.ro',
		    'Nume' => 'Ioan Popa',
		    'CNP' => '',
		    'Nume companie' => 'Artur Smart Srl',
		    'CUI"' => '14644478"'
		  ),
		  array(
		    'ID' => '397',
		    'nr PROFORMA' => 1219,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'ana.nedea@simtel.ro',
		    'Nume' => 'Ana Nedea',
		    'CNP' => '',
		    'Nume companie' => 'Simtel Team SA',
		    'CUI"' => 'RO26414626"'
		  ),
		  array(
		    'ID' => '300',
		    'nr PROFORMA' => 1164,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'marian@f64studio.ro',
		    'Nume' => 'Alecsiu Marian Dan',
		    'CNP' => '',
		    'Nume companie' => 'F64 Studio s.r.l.',
		    'CUI"' => '14080808"'
		  ),
		  array(
		    'ID' => '430',
		    'nr PROFORMA' => 1235,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'saris.fruit@gmail.com',
		    'Nume' => 'Saris Ionut',
		    'CNP' => '',
		    'Nume companie' => 'saris fruit srl',
		    'CUI"' => '32284997"'
		  ),
		  array(
		    'ID' => '421',
		    'nr PROFORMA' => 1231,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'ene.andraioana@yahoo.com',
		    'Nume' => 'Andra ioana Ene',
		    'CNP' => '',
		    'Nume companie' => 'SC RECOVER SRL',
		    'CUI"' => '17867520"'
		  ),
		  array(
		    'ID' => '363',
		    'nr PROFORMA' => 1202,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'office@rsbauro.ro',
		    'Nume' => 'ALINA TAREAN',
		    'CNP' => '',
		    'Nume companie' => 'RSBAURO',
		    'CUI"' => 'RO18573973"'
		  ),
		  array(
		    'ID' => '341',
		    'nr PROFORMA' => 1187,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'office@rsbauro.ro',
		    'Nume' => 'ALINA TAREAN',
		    'CNP' => '',
		    'Nume companie' => 'RSBAURO',
		    'CUI"' => 'RO18573973"'
		  ),
		  array(
		    'ID' => '330',
		    'nr PROFORMA' => 1179,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'mihai.moisei@optilab.ro',
		    'Nume' => 'Mihai Moisei',
		    'CNP' => '',
		    'Nume companie' => 'Optilab Solutions',
		    'CUI"' => '40367767"'
		  ),
		  array(
		    'ID' => '443',
		    'nr PROFORMA' => 1245,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'eugen.uta@basicra.ro',
		    'Nume' => 'Eugen Uta',
		    'CNP' => '',
		    'Nume companie' => 'Basicra Prod Serv SRL',
		    'CUI"' => 'RO10092974"'
		  ),
		  array(
		    'ID' => '445',
		    'nr PROFORMA' => 1246,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'silvian@bestautovest.ro',
		    'Nume' => 'Nanea Silvian',
		    'CNP' => '',
		    'Nume companie' => 'e-autoparts europa srl',
		    'CUI"' => 'ro32372789"'
		  ),
		  array(
		    'ID' => '500',
		    'nr PROFORMA' => 1278,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'madalina.milesan@euronarcis.ro',
		    'Nume' => 'MADALINA MILESAN',
		    'CNP' => '',
		    'Nume companie' => 'EURO NARCIS SRL',
		    'CUI"' => 'RO14953201"'
		  ),
		  array(
		    'ID' => '499',
		    'nr PROFORMA' => 1277,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'madalina.milesan@euronarcis.ro',
		    'Nume' => 'MADALINA MILESAN',
		    'CNP' => '',
		    'Nume companie' => 'EURO NARCIS SRL',
		    'CUI"' => 'RO14953201"'
		  ),
		  array(
		    'ID' => '488',
		    'nr PROFORMA' => 1269,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'demco@demco.ro',
		    'Nume' => 'Calangea Doru',
		    'CNP' => '',
		    'Nume companie' => 'DEMCO ELECTRO DESIGN S.R.L.',
		    'CUI"' => 'RO 26521185"'
		  ),
		  array(
		    'ID' => '305',
		    'nr PROFORMA' => 1167,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'adrianpopescu@emtsolutions.eu',
		    'Nume' => 'Adrian Popescu',
		    'CNP' => '',
		    'Nume companie' => 'EMT Solutions SRL',
		    'CUI"' => 'ro35947725"'
		  ),
		  array(
		    'ID' => '423',
		    'nr PROFORMA' => 1232,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'corina.bartalici@yload.ro',
		    'Nume' => 'Corina Huzau',
		    'CNP' => '',
		    'Nume companie' => 'Yload Global SA',
		    'CUI"' => 'RO41337497"'
		  ),
		  array(
		    'ID' => '284',
		    'nr PROFORMA' => 1156,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'horatiu.otelea@centralmo.ro',
		    'Nume' => 'Horatiu Otelea',
		    'CNP' => '',
		    'Nume companie' => 'Sc Central Moreni Srl',
		    'CUI"' => '937273"'
		  ),
		  array(
		    'ID' => '344',
		    'nr PROFORMA' => 1190,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'adrianpopescu@emtsolutions.eu',
		    'Nume' => 'Adrian Popescu',
		    'CNP' => '',
		    'Nume companie' => 'EMT Solutions SRL',
		    'CUI"' => 'ro35947725"'
		  ),
		  array(
		    'ID' => '480',
		    'nr PROFORMA' => 1265,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'richard.scutermag@gmail.com',
		    'Nume' => 'Richard Mitrea',
		    'CNP' => '',
		    'Nume companie' => 'Motorevolution Franchise',
		    'CUI"' => 'RO43214326"'
		  ),
		  array(
		    'ID' => '456',
		    'nr PROFORMA' => 1253,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'aarmasu@profial.ro',
		    'Nume' => 'ADRIAN ARMASU',
		    'CNP' => '',
		    'Nume companie' => 'A&D PROFIAL COMPANY',
		    'CUI"' => 'RO6407586"'
		  ),
		  array(
		    'ID' => '457',
		    'nr PROFORMA' => 1254,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'Carmen.Mazilu@gigroup.com',
		    'Nume' => 'Mazilu Carmen',
		    'CNP' => '',
		    'Nume companie' => 'Barnett McCall Recruitment',
		    'CUI"' => '11577960"'
		  ),
		  array(
		    'ID' => '353',
		    'nr PROFORMA' => 1196,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'razvan.chirion@kindustrial.ro',
		    'Nume' => 'Razvan CHIRION',
		    'CNP' => '',
		    'Nume companie' => 'Kardynal Intserv Office',
		    'CUI"' => '31508441"'
		  ),
		  array(
		    'ID' => '285',
		    'nr PROFORMA' => 1157,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'razvan.chirion@kindustrial.ro',
		    'Nume' => 'Razvan CHIRION',
		    'CNP' => '',
		    'Nume companie' => 'Kardynal Intserv Office',
		    'CUI"' => '31508441"'
		  ),
		  array(
		    'ID' => '469',
		    'nr PROFORMA' => 1259,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'info@memory.ro',
		    'Nume' => 'Eva Szabo',
		    'CNP' => '',
		    'Nume companie' => 'Memory SRL',
		    'CUI"' => 'RO10694678"'
		  ),
		  array(
		    'ID' => '355',
		    'nr PROFORMA' => 1198,
		    'Serie factura' => 'SM',
		    'SUMA' => 5242,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Vanzari',
		    'Email' => 'mihai.varutoiu@gmail.com',
		    'Nume' => 'Mihai Varutoiu',
		    'CNP' => '',
		    'Nume companie' => 'Agrifond Partners',
		    'CUI"' => '36152557"'
		  ),
		  array(
		    'ID' => '334',
		    'nr PROFORMA' => 1183,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'mihai.varutoiu@gmail.com',
		    'Nume' => 'Mihai Varutoiu',
		    'CNP' => '',
		    'Nume companie' => 'Agrifond Partners',
		    'CUI"' => '36152557"'
		  ),
		  array(
		    'ID' => '525',
		    'nr PROFORMA' => 1289,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'victor@cxcgroup.ro',
		    'Nume' => 'Victor Donea',
		    'CNP' => '',
		    'Nume companie' => 'AD INFINITUM NETWORK SRL',
		    'CUI"' => 'RO43788329"'
		  ),
		  array(
		    'ID' => '546',
		    'nr PROFORMA' => 1304,
		    'Serie factura' => 'SM',
		    'SUMA' => 7581,
		    'Status' => 'incasat OP',
		    'CE CURS' => 'Management',
		    'Email' => 'foldvary.andras@landmark-imobiliare.ro',
		    'Nume' => 'Andras Foldvary',
		    'CNP' => '',
		    'Nume companie' => 'MA LANDMARK SRL',
		    'CUI"' => 'Ro19002452"'
		  )
		);

foreach($proforme as $proforma) {
			$proforma_db = Invoice::where('id',$proforma['ID'])->first();
	        $instance = $proforma_db->instance;
	        if($instance){
		        $user = $instance->users->first();
		        $randPassword = Str::random(8);
		        $user->password = bcrypt($randPassword);
		        $user->save();
		        // sa trimit email sa aiba parola pentru learnworld
		        $alreadyregisteredInLearn = learworldsInit($user, $randPassword);
		        newUserCreatedMail($user, $randPassword, $alreadyregisteredInLearn);

// se genereaza factura
		        $invoice = InvoiceRepository::generateInvoice(
		            $instance->id,
		            $instance->package->price_in_ron,
		            'paid',
		            'stripe_payment_id',
		            'RON',
		            $user->email
		        );

$instance->update([
		            'status'        => Instance::STATUS_ACTIVE,
		            'first_payment' => 0,
		        ]);
	        }else{
	        	var_dump("Nu am gasit instanta pentru proforma:".$proforma['ID']);
	        }

// add user with tag in active campaign
	        createCronjobActiveCampaign(Auth::user(), 'tbf_curs');
		}
    }
}

Back