73 lines
1.8 KiB
PHP
73 lines
1.8 KiB
PHP
<?php
|
|
|
|
namespace App\Console\Commands\ChannelManager;
|
|
|
|
use App\Core\Mail\LogMail;
|
|
use App\Core\Service\PropertyRoomRatePriceService;
|
|
use App\Core\Service\PropertyRoomService;
|
|
use App\Exceptions\ApiErrorException;
|
|
use Carbon\Carbon;
|
|
use GuzzleHttp\Client;
|
|
use Illuminate\Console\Command;
|
|
use Illuminate\Mail\Mailer;
|
|
use Illuminate\Support\Facades\App;
|
|
use Illuminate\Support\Facades\Config;
|
|
use Illuminate\Support\Facades\DB;
|
|
use Illuminate\Support\Facades\Log;
|
|
use Maatwebsite\Excel\Facades\Excel;
|
|
use PhpOffice\PhpSpreadsheet\IOFactory;
|
|
|
|
class PropertyBookingSyncService extends Command
|
|
{
|
|
protected $signature = 'cron:propertybooking-sync-service';
|
|
|
|
protected $description = '';
|
|
protected $mailer;
|
|
|
|
public function __construct(
|
|
Mailer $mailer,
|
|
PropertyRoomService $propertyRoomService,
|
|
PropertyRoomRatePriceService $propertyRoomRatePriceService
|
|
)
|
|
{
|
|
parent::__construct();
|
|
$this->mailer = $mailer;
|
|
$this->propertyRoomService = $propertyRoomService;
|
|
$this->propertyRoomRatePriceService = $propertyRoomRatePriceService;
|
|
}
|
|
|
|
public function handle()
|
|
{
|
|
|
|
$sourcePath = 'C:\www\api.extranetwork.com\app\Console\Commands\ChannelManager\akgun.xlsx';
|
|
|
|
|
|
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
|
|
$spreadsheet = $reader->load($sourcePath);
|
|
$sheet = $spreadsheet->getSheet($spreadsheet->getFirstSheetIndex());
|
|
$rows = $sheet->toArray();
|
|
|
|
$rowKey = 0;
|
|
foreach ($rows as $row) {
|
|
|
|
$rowKey++;
|
|
|
|
if($rowKey < 3) {
|
|
continue;
|
|
}
|
|
|
|
dd($row);
|
|
}
|
|
|
|
//dd(file_exists($sourcePath));
|
|
|
|
$this->info(date('Y-m-d H:i:s') . ' : Start');
|
|
|
|
|
|
|
|
$this->info(date('Y-m-d H:i:s') . ' : Finished');
|
|
|
|
|
|
}
|
|
}
|