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 Session;
use DB;

class QuantityUpdate extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'nimda:quantity:update';

/**
     * 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()
    {

$parse = new Parse();
        $parse->GetAll();

$log = DB::connection('mysql_quant')->table('nimda_quant.update_log')->where('status','1')->get();

if (count($log)>0) {

DB::connection('mysql_quant')->table('nimda_quant.update_log')->where('id', $log[0]->id)->update(array("status"=>2, 'updated_at' => date('Y-m-d H:i:s')));

$apiREST = new apiREST();

$arGoods = DB::select("select id, unique_id, orig_id from goods WHERE unique_id>0 AND approve='1' ");
            foreach ($arGoods as $arGood) {

unset($arData);
                $quant = $quant_north = $quant_south = 0;
                $arQuants = DB::connection('mysql_quant')->table('nimda_quant.quantities')->where('unique_id', $arGood->unique_id)->get();
                foreach ($arQuants as $arQ) {
                    if (isset($arQ->approve) AND !isset($arQ->upload_to_nimda)) {
                        if ($arQ->site_id == 6) $quant_north = $arQ->quant;
                        if ($arQ->site_id == 7) $quant_south = $arQ->quant;
                        //$quant += $arQ->quant;
                    }
                }

$sites = Sites::where('autodealer', '=', '0')->get();
                foreach ($sites as $site) {
                    $arData[$site->id]["data"]["unique_id"] = $arGood->unique_id;
                    $arData[$site->id]["data"]["quant_north"] = $quant_north;
                    $arData[$site->id]["data"]["quant_south"] = $quant_south;
                    DB::table('prices')->where('goods_id', $arGood->id)->where('sites_id', 6)->update(['quantity' => $quant_north]);
                    DB::table('prices')->where('goods_id', $arGood->id)->where('sites_id', 7)->update(['quantity' => $quant_south]);
                }

DB::table('goods')->where('id', $arGood->id)->update(['amount' => $quant]);

$apiREST->updateQuantityOnSites($arGood->unique_id, '', $arData);

}

DB::connection('mysql_quant')->table('nimda_quant.update_log')->where('id', $log[0]->id)->update(array("status"=>3,'updated_at' => date('Y-m-d H:i:s')));
        } /*else {
            DB::connection('mysql_quant')->table('nimda_quant.update_log')->insert([
                'status' => '0',
                'created_at' => date("Y-m-d H:i:s"),
                'updated_at' => date("Y-m-d H:i:s"),
            ]);
        }*/

}
}