Gecko [ unitednationsplay.com ]

Name	Size	Permission	Date
AddNew.php	17.39 KB	-rw-r--r--	2021-03-26 07:26
CommonSchedule.php	6.27 KB	-rw-r--r--	2021-03-26 07:26
DoImport.php	3.18 KB	-rw-r--r--	2021-03-26 07:26
Inspire.php	602 B	-rw-r--r--	2021-03-26 07:26
QuantityUpdate.php	3.28 KB	-rw-r--r--	2021-03-26 07:26

Rename

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use Illuminate\Mail\Message;
use Illuminate\Support\Facades\Redirect;
use Illuminate\Http\Request;
use App\Models\apiREST;
use App\Models\Metas;
use App\Models\Sites;
use App\Models\Prices;
use App\Models\Parse;
use App\Models\Goods;
use App\Models\Import_workout;
use App\Models\Suppliers;
use App\Imports\ImportparseImport;
use Session;
use DB;

class DoImport extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'nimda:doimport {id}';

protected function getArguments()
    {
        return [
            ['id', InputArgument::REQUIRED, 'Id шаблона выгрузки', 0],
        ];
    }

/**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Импорт прайсов';

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

/**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        $id = str_replace('id=','',$this->argument('id'));
        $template = DB::table('import_xml')->where("id","=",$id)->get();

$columns = DB::table('import_xml_fields')->join('global_list_settings', 'import_xml_fields.field_code', '=', 'global_list_settings.field')->where("parent_id", "=", $id)->where("global_list_settings.model", "import_xml_parse")->where("global_list_settings.show", "1")->get();

$parse_columns = DB::table('import_xml_fields')->where("parent_id","=",$id)->get();

$supplier = DB::table('suppliers')->where("id","=",$template[0]->supplier_id)->get();

$arParsed = $arTemp = $arDisappear = array();
        $Import_workout = new Import_workout();

if ($template[0]->type==2 AND $template[0]->element_wrap AND count($columns) > 0)
            $arParsed = $Import_workout->parseXml($template[0]->id, $template[0]->element_wrap, $parse_columns);
        elseif ($template[0]->type==1)
            $arParsed = $Import_workout->parseExcel($template[0]->id);

if (is_array($arParsed) AND !empty($arParsed) AND empty($arParsed["wrong"]) AND empty($arParsed["chdir"])) {
            if ($template[0]->supplier_id AND $template[0]->type==2)
                $Import_workout->setStatusesXml($arParsed,$template[0]->supplier_id,$id);
            elseif ($template[0]->supplier_id AND $template[0]->type==1)
                $Import_workout->setStatusesExcel($arParsed, $template[0]->supplier_id, $id);

DB::table('import_xml_supplier_logs_' . $template[0]->supplier_id)->insert(
                [
                    'status_id' => 255,
                    'status_text' => 'Прайс успешно обработан',
                    'created_at' => date("Y-m-d H:i:s"),
                    'updated_at' => date("Y-m-d H:i:s"),
                ]
            );
            echo "Прайс успешно обработан\r\n";
        } else {
            if (!empty($arParsed["wrong"])) {
                //echo implode("; ",$arParsed["wrong"]);
            }
        }

}
}