Gecko [ unitednationsplay.com ]

Name	Size	Permission	Date
.gitignore	0 B	-rw-rw-r--	2022-12-03 10:44
AdminController.php	705 B	-rw-rw-r--	2022-12-03 10:44
AnalyticsController.php	47.03 KB	-rw-rw-r--	2023-08-29 09:18
AuthController.php	2.14 KB	-rw-rw-r--	2022-12-03 10:44
CronController (copy).php	28.3 KB	-rw-rw-r--	2023-04-27 09:46
CronController.php	62.54 KB	-rw-rw-r--	2023-08-18 10:30
FirstRunController.php	28.3 KB	-rw-rw-r--	2023-05-18 07:53
HomeController.php	603 B	-rw-rw-r--	2022-12-24 11:33
RegistrationController.php	8.73 KB	-rw-rw-r--	2023-08-29 09:18
UsersController.php	2.63 KB	-rw-rw-r--	2022-12-03 10:44

Rename

<?php

namespace App\Controller;

use App\Entity\Catalog;
use App\Entity\CatalogLog;
use App\Entity\CatalogUpdates;
use App\Entity\Incomes;
use App\Entity\Orders;
use App\Entity\Sales;
use App\Entity\Stocks;
use App\Entity\Warehouses;
use App\Entity\Reports;
use Knp\Component\Pager\PaginatorInterface;
use Doctrine\ORM\EntityManagerInterface;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\JsonResponse;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Component\Security\Core\Exception\AccessDeniedException;
use Symfony\Contracts\Translation\TranslatorInterface;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;

/**
 * @IsGranted("ROLE_ADMIN")
 */
class FirstRunController extends AbstractController
{

private $em;

public function __construct(EntityManagerInterface $em)
    {
        $this->em = $em;
    }

/**
    * @Route("/lk/cron_refresh")
    */
    public function refreshAction(Request $request, PaginatorInterface $paginator): Response
    {

$entityManager = $this->getDoctrine()->getManager();
        $catalogRepo = $this->getCatalogRepo();
        $catalogLogRepo = $this->getCatalogLogRepo();
        $catalogUpdatesRepo = $this->getCatalogUpdatesRepo();

$last_update = $catalogUpdatesRepo->findBy([], ['id'=>'DESC'], 1, 0);
        $update_time = $last_update[0]->getCreatedAt()->format("Y-m-d")."T".$last_update[0]->getCreatedAt()->format("H:i:s");
        $update_time = "2023-01-01T00:00:00";
        $arCards = $arCatalog = [];
        /*$standart_api_key = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhY2Nlc3NJRCI6IjIzNzVmMDViLWYxNGQtNDQ4ZS04OWYwLTMwNTI4YTUwOWIyMiJ9.1vjHcP-7GCd-NtJQIe_5Rl5kUkkBDRRtv0-uLQXQW_U";
        $statistics_api_key = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhY2Nlc3NJRCI6ImY2NDBkYzIzLTJmNWMtNDE0MS04YWRjLWFlNzU0OWMyM2E2YiJ9.EtEoNE3damTZazLzwGpYSV2cqtcDVechNKlt-uuZkh8";

$standart_api_key = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhY2Nlc3NJRCI6ImMxZGZhMDU3LTJmMDItNGI0ZC1iOWY4LTg0NDNjMGQzMDVjNyJ9.svLtu5d78jxoR6Bn84pKhIfLp0Xms-bbJGZ8e4-ASIo";
                $statistics_api_key = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhY2Nlc3NJRCI6IjVkODUyMTZiLTQ2OTMtNDFjNC04OTdiLTdjZmFlMzU4YzQwZiJ9.UPy3FdF_MhR6rLRRvKGRQSybk_gtJvgXe0CGCf-pXw8";*/

$standart_api_key = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhY2Nlc3NJRCI6IjgzN2I1ZGYxLWFlYjQtNGJkZC1hYTJiLTdiN2NmZjc2MzMxMiJ9.LwLuGSZoRUgVypVTbIYK42HXksKhL8Q3HRLT6xRWWWc";
        $statistics_api_key = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhY2Nlc3NJRCI6ImY2NDBkYzIzLTJmNWMtNDE0MS04YWRjLWFlNzU0OWMyM2E2YiJ9.EtEoNE3damTZazLzwGpYSV2cqtcDVechNKlt-uuZkh8";

/*
//"updatedAt": "'.$update_time.'"}, "nmID": 78771860
        $data = '{"sort": {"cursor": {"limit": 1000}, "filter": {"withPhoto": -1}}}';
        $url = 'https://suppliers-api.wildberries.ru/content/v1/cards/cursor/list';
        $headers = array(
            'Authorization: '.$standart_api_key,
            'Content-Type: application/json'
        );

//curl -X POST https://suppliers-api.wildberries.ru/content/v1/cards/cursor/list -H "Authorization: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhY2Nlc3NJRCI6IjgzN2I1ZGYxLWFlYjQtNGJkZC1hYTJiLTdiN2NmZjc2MzMxMiJ9.LwLuGSZoRUgVypVTbIYK42HXksKhL8Q3HRLT6xRWWWc" -H "Content-Type: application/json" -d "[{"sort": {"cursor": {"limit": 1000}, "filter": {"withPhoto": -1}}}]"

$ch = curl_init();
                $options = array(
                    CURLOPT_URL => $url,
                    CURLOPT_CUSTOMREQUEST => 'POST',
                    CURLOPT_RETURNTRANSFER => true,
                    CURLOPT_POSTFIELDS => $data,
                    CURLOPT_HTTPHEADER => $headers
                );
                curl_setopt_array($ch, $options);
                curl_setopt($ch, CURLOPT_POST, 1);
                curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30);

$result = curl_exec($ch);
                $arResult = json_decode($result);
                $status = curl_getinfo($ch);
                curl_close($ch);

echo $update_time."arResult<pre>";
                print_r($arResult);
                echo "</pre>";

echo "status<pre>";
                print_r($status);
                echo "</pre>";

setlocale(LC_MONETARY, 'ru_RU');

$k=0;
                        $arCards = [];
                        if (!empty($arResult->data->cards)) {
                            foreach ($arResult->data->cards as $card) {

if ($k<20) {
                                    $arTmp = [];
                                    if (!empty($card->updateAt)) $arTmp["updateAt"] = $card->updateAt; else $arTmp["updateAt"] = '';
                                    if (!empty($card->vendorCode)) $arTmp["vendorCode"] = $card->vendorCode; else $arTmp["vendorCode"] = '';
                                    if (!empty($card->object)) $arTmp["object"] = $card->object; else $arTmp["object"] = '';
                                    if (!empty($card->brand)) $arTmp["brand"] = $card->brand; else $arTmp["brand"] = '';
                                    if (!empty($card->nmID)) $arTmp["nmID"] = $card->nmID; else $arTmp["nmID"] = '';
                                    if (!empty($card->mediaFiles[0])) $arTmp["img"] = $card->mediaFiles[0]; else $arTmp["img"] = '';
                                    if (!empty($card->sizes[0]->skus[0])) $arTmp["skus"] = $card->sizes[0]->skus[0]; else $arTmp["skus"] = '';

$arCards[] = $arTmp;
                                }

$catalog = new Catalog();

$date = new \DateTime();

if (!empty($card->object)) $catalog->setObject($card->object);
                                if (!empty($card->brand)) $catalog->setBrand($card->brand);
                                if (!empty($card->vendorCode)) $catalog->setVendorCode($card->vendorCode);
                                if (!empty($card->updateAt)) $catalog->setUpdateAt($card->updateAt);
                                if (!empty($card->colors)) $catalog->setColors(json_encode($card->colors));
                                if (!empty($card->nmID)) $catalog->setNmID($card->nmID);
                                if (!empty($card->mediaFiles)) $catalog->setMediaFiles(json_encode($card->mediaFiles));
                                if (!empty($card->sizes)) $catalog->setSizes(json_encode($card->sizes));
                                $catalog->setAccountId(1);
                                $catalog->setUpdatedAt($date);
                                $catalog->setCreatedAt($date);

$entityManager->persist($catalog);

$k++;
                            }
                            $entityManager->flush();
                        }
*/

/*
        $data = 'dateFrom=2020-12-21T00:00:00';
        //$data = '';
        $url = 'https://statistics-api.wildberries.ru/api/v1/supplier/incomes?dateFrom=2022-12-21T00:00:00';
        $headers = array(
            'Authorization: '.$statistics_api_key,
            //'Content-Type: application/json'
        );

//curl -X GET https://suppliers-api.wildberries.ru/api/v2/warehouses -H "Authorization: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhY2Nlc3NJRCI6ImIxOGQxZDk2LTNmM2ItNGM0Yi1hMjU3LWQ2NGU4NGVkM2UyOSJ9.WTcgkv3AdWXhokqFjSkK17_jARPCqqLUFWkKJXNPHjs" -d "[{"dateFrom": "2022-12-01T00:00:00"}]"

$ch = curl_init();
        $options = array(
            CURLOPT_URL => $url,
            CURLOPT_CUSTOMREQUEST => 'GET',
            CURLOPT_RETURNTRANSFER => true,
            CURLOPT_POSTFIELDS => $data,
            CURLOPT_HTTPHEADER => $headers
        );
        curl_setopt_array($ch, $options);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30);

$result = curl_exec($ch);
        $arResult = json_decode($result);
        $status = curl_getinfo($ch);
        curl_close($ch);

echo "arResult<pre>";
        print_r($arResult);
        echo "</pre>";

echo "status<pre>";
        print_r($status);
        echo "</pre>";

if (!empty($arResult)){
            foreach ($arResult as $item) {

$incomes = new Incomes();

$date = new \DateTime();

if (!empty($item->incomeId)) $incomes->setIncomeId($item->incomeId);
                if (!empty($item->number)) $incomes->setNumber($item->number);
                if (!empty($item->date)) $incomes->setDate(new \DateTime($item->date));
                if (!empty($item->lastChangeDate)) $incomes->setLastChangeDate(new \DateTime($item->lastChangeDate));
                if (!empty($item->supplierArticle)) $incomes->setSupplierArticle($item->supplierArticle);
                if (!empty($item->techSize)) $incomes->setTechSize($item->techSize);
                if (!empty($item->barcode)) $incomes->setBarcode($item->barcode);
                if (!empty($item->quantity)) $incomes->setQuantity($item->quantity);
                if (!empty($item->totalPrice)) $incomes->setTotalPrice($item->totalPrice);
                if (!empty($item->dateClose)) $incomes->setDateClose(new \DateTime($item->dateClose));
                if (!empty($item->warehouseName)) $incomes->setWarehouseName($item->warehouseName);
                if (!empty($item->nmId)) $incomes->setNmID($item->nmId);
                if (!empty($item->status)) $incomes->setStatus($item->status);
                $incomes->setAccountId(1);
                $incomes->setCreatedAt($date);
                $incomes->setUpdatedAt($date);

$entityManager->persist($incomes);

}
            $entityManager->flush();
        }
*/

/*
        $data = '';
        $url = 'https://suppliers-api.wildberries.ru/api/v2/warehouses';
        $headers = array(
            'Authorization: '.$standart_api_key,
            //'Content-Type: application/json'
        );

$result = curl_exec($ch);
        $arResult = json_decode($result);
        $status = curl_getinfo($ch);
        curl_close($ch);

echo "arResult<pre>";
        print_r($arResult);
        echo "</pre>";

echo "status<pre>";
        print_r($status);
        echo "</pre>";
*/
/*
        $data = 'dateFrom=2020-12-21T00:00:00';
        $url = 'https://statistics-api.wildberries.ru/api/v1/supplier/stocks?dateFrom=2022-12-21T00:00:00';
        $headers = array(
            'Authorization: '.$statistics_api_key,
            //'Content-Type: application/json'
        );

$result = curl_exec($ch);
        $arResult = json_decode($result);
        $status = curl_getinfo($ch);
        curl_close($ch);

echo "arResult<pre>";
        print_r($arResult);
        echo "</pre>";

echo "status<pre>";
        print_r($status);
        echo "</pre>";

if (!empty($arResult)){
            foreach ($arResult as $item) {

$stocks = new Stocks();

$date = new \DateTime();

if (!empty($item->lastChangeDate)) $stocks->setLastChangeDate(new \DateTime($item->lastChangeDate));
                if (!empty($item->supplierArticle)) $stocks->setSupplierArticle($item->supplierArticle);
                if (!empty($item->techSize)) $stocks->setTechSize($item->techSize);
                if (!empty($item->barcode)) $stocks->setBarcode($item->barcode);
                if (!empty($item->quantity)) $stocks->setQuantity($item->quantity);
                if (!empty($item->isSupply)) $stocks->setIsSupply($item->isSupply);
                if (!empty($item->isRealization)) $stocks->setIsRealization($item->isRealization);
                if (!empty($item->quantityFull)) $stocks->setQuantityFull($item->quantityFull);
                if (!empty($item->warehouseName)) $stocks->setWarehouseName($item->warehouseName);
                if (!empty($item->nmId)) $stocks->setNmID($item->nmId);
                if (!empty($item->subject)) $stocks->setSubject($item->subject);
                if (!empty($item->category)) $stocks->setCategory($item->category);
                if (!empty($item->daysOnSite)) $stocks->setDaysOnSite($item->daysOnSite);
                if (!empty($item->brand)) $stocks->setBrand($item->brand);
                if (!empty($item->SCCode)) $stocks->setSCCode($item->SCCode);
                if (!empty($item->Price)) $stocks->setPrice($item->Price);
                if (!empty($item->Discount)) $stocks->setDiscount($item->Discount);
                $stocks->setAccountId(1);
                $stocks->setCreatedAt($date);
                $stocks->setUpdatedAt($date);

$entityManager->persist($stocks);

}
            $entityManager->flush();
        }
*/
/*
        $data = 'dateFrom=2020-12-21T00:00:00';
        $url = 'https://statistics-api.wildberries.ru/api/v1/supplier/orders?dateFrom=2022-12-21T00:00:00';
        $headers = array(
            'Authorization: '.$statistics_api_key,
            //'Content-Type: application/json'
        );

$result = curl_exec($ch);
        $arResult = json_decode($result);
        $status = curl_getinfo($ch);
        curl_close($ch);

echo "arResult<pre>";
        print_r($arResult);
        echo "</pre>";

echo "status<pre>";
        print_r($status);
        echo "</pre>";

if (!empty($arResult)){
            foreach ($arResult as $item) {

$orders = new Orders();

$date = new \DateTime();

if (!empty($item->date)) $orders->setDate(new \DateTime($item->date));
                if (!empty($item->lastChangeDate)) $orders->setLastChangeDate(new \DateTime($item->lastChangeDate));
                if (!empty($item->supplierArticle)) $orders->setSupplierArticle($item->supplierArticle);
                if (!empty($item->techSize)) $orders->setTechSize($item->techSize);
                if (!empty($item->barcode)) $orders->setBarcode($item->barcode);
                if (!empty($item->totalPrice)) $orders->setTotalPrice($item->totalPrice);
                if (!empty($item->discountPercent)) $orders->setDiscountPercent($item->discountPercent);
                if (!empty($item->warehouseName)) $orders->setWarehouseName($item->warehouseName);
                if (!empty($item->oblast)) $orders->setOblast($item->oblast);
                if (!empty($item->incomeID)) $orders->setIncomeID($item->incomeID);
                if (!empty($item->odid)) $orders->setOdid($item->odid);
                if (!empty($item->nmId)) $orders->setNmId($item->nmId);
                if (!empty($item->subject)) $orders->setSubject($item->subject);
                if (!empty($item->category)) $orders->setCategory($item->category);
                if (!empty($item->brand)) $orders->setBrand($item->brand);
                if (!empty($item->isCancel)) $orders->setIsCancel($item->isCancel);
                if (!empty($item->cancel_dt)) $orders->setCancelDt(new \DateTime($item->cancel_dt));
                if (!empty($item->gNumber)) $orders->setGNumber($item->gNumber);
                if (!empty($item->sticker)) $orders->setSticker($item->sticker);
                if (!empty($item->srid)) $orders->setSrid($item->srid);
                $orders->setAccountId(1);
                $orders->setCreatedAt($date);
                $orders->setUpdatedAt($date);

$entityManager->persist($orders);

}
            $entityManager->flush();
        }
*/
/*
        $data = 'dateFrom=2020-12-21T00:00:00';
        $url = 'https://statistics-api.wildberries.ru/api/v1/supplier/sales?dateFrom=2022-12-21T00:00:00';
        $headers = array(
            'Authorization: '.$statistics_api_key,
            //'Content-Type: application/json'
        );

$result = curl_exec($ch);
        $arResult = json_decode($result);
        $status = curl_getinfo($ch);
        curl_close($ch);

echo "arResult<pre>";
        print_r($arResult);
        echo "</pre>";

echo "status<pre>";
        print_r($status);
        echo "</pre>";

if (!empty($arResult)){
            foreach ($arResult as $item) {

$sales = new Sales();

$date = new \DateTime();

if (!empty($item->date)) $sales->setDate(new \DateTime($item->date));
                if (!empty($item->lastChangeDate)) $sales->setLastChangeDate(new \DateTime($item->lastChangeDate));
                if (!empty($item->supplierArticle)) $sales->setSupplierArticle($item->supplierArticle);
                if (!empty($item->techSize)) $sales->setTechSize($item->techSize);
                if (!empty($item->barcode)) $sales->setBarcode($item->barcode);
                if (!empty($item->totalPrice)) $sales->setTotalPrice($item->totalPrice);
                if (!empty($item->discountPercent)) $sales->setDiscountPercent($item->discountPercent);
                if (!empty($item->isSupply)) $sales->setIsSupply($item->isSupply);
                if (!empty($item->isRealization)) $sales->setIsRealization($item->isRealization);
                if (!empty($item->promoCodeDiscount)) $sales->setPromoCodeDiscount($item->promoCodeDiscount);
                if (!empty($item->warehouseName)) $sales->setWarehouseName($item->warehouseName);
                if (!empty($item->countryName)) $sales->setCountryName($item->countryName);
                if (!empty($item->oblastOkrugName)) $sales->setOblastOkrugName($item->oblastOkrugName);
                if (!empty($item->regionName)) $sales->setRegionName($item->regionName);
                if (!empty($item->incomeID)) $sales->setIncomeID($item->incomeID);
                if (!empty($item->saleID)) $sales->setSaleID($item->saleID);
                if (!empty($item->odid)) $sales->setOdid($item->odid);
                if (!empty($item->spp)) $sales->setSpp($item->spp);
                if (!empty($item->forPay)) $sales->setForPay($item->forPay);
                if (!empty($item->finishedPrice)) $sales->setFinishedPrice($item->finishedPrice);
                if (!empty($item->priceWithDisc)) $sales->setPriceWithDisc($item->priceWithDisc);
                if (!empty($item->nmId)) $sales->setNmId($item->nmId);
                if (!empty($item->subject)) $sales->setSubject($item->subject);
                if (!empty($item->category)) $sales->setCategory($item->category);
                if (!empty($item->brand)) $sales->setBrand($item->brand);
                if (!empty($item->IsStorno)) $sales->setIsStorno($item->IsStorno);
                if (!empty($item->gNumber)) $sales->setGNumber($item->gNumber);
                if (!empty($item->sticker)) $sales->setSticker($item->sticker);
                if (!empty($item->srid)) $sales->setSrid($item->srid);
                $sales->setAccountId(1);
                $sales->setCreatedAt($date);
                $sales->setUpdatedAt($date);

$entityManager->persist($sales);

}
            $entityManager->flush();
        }
*/
/*
        $data = 'dateFrom=2020-12-21T00:00:00';
        $url = 'https://statistics-api.wildberries.ru/api/v1/supplier/reportDetailByPeriod?dateFrom=2023-02-01T00:00:00&dateTo=2023-04-30T23:59:59';
        $headers = array(
            'Authorization: '.$statistics_api_key,
            //'Content-Type: application/json'
        );

$result = curl_exec($ch);
        $arResult = json_decode($result);
        $status = curl_getinfo($ch);
        curl_close($ch);

echo "arResult<pre>";
        print_r($arResult);
        echo "</pre>";

echo "status<pre>";
        print_r($status);
        echo "</pre>";

if (!empty($arResult)){
            foreach ($arResult as $item) {

$reports = new Reports();

$date = new \DateTime();

if (!empty($item->realizationreport_id)) $reports->setRealizationreportId($item->realizationreport_id);
                if (!empty($item->date_from)) $reports->setDateFrom(new \DateTime($item->date_from));
                if (!empty($item->date_to)) $reports->setDateTo(new \DateTime($item->date_to));
                if (!empty($item->create_dt)) $reports->setCreateDt(new \DateTime($item->create_dt));
                if (!empty($item->suppliercontract_code)) $reports->setSuppliercontractCode($item->suppliercontract_code);
                if (!empty($item->rrd_id)) $reports->setRrdId($item->rrd_id);
                if (!empty($item->gi_id)) $reports->setGiId($item->gi_id);
                if (!empty($item->subject_name)) $reports->setSubjectName($item->subject_name);
                if (!empty($item->nm_id)) $reports->setNmId($item->nm_id);
                if (!empty($item->brand_name)) $reports->setBrandName($item->brand_name);
                if (!empty($item->sa_name)) $reports->setSaName($item->sa_name);
                if (!empty($item->ts_name)) $reports->setTsName($item->ts_name);
                if (!empty($item->barcode)) $reports->setBarcode($item->barcode);
                if (!empty($item->doc_type_name)) $reports->setDocTypeName($item->doc_type_name);
                if (!empty($item->quantity)) $reports->setQuantity($item->quantity);
                if (!empty($item->retail_price)) $reports->setRetailPrice($item->retail_price);
                if (!empty($item->retail_amount)) $reports->setRetailAmount($item->retail_amount);
                if (!empty($item->sale_percent)) $reports->setSalePercent($item->sale_percent);
                if (!empty($item->commission_percent)) $reports->setCommissionPercent($item->commission_percent);
                if (!empty($item->office_name)) $reports->setOfficeName($item->office_name);
                if (!empty($item->supplier_oper_name)) $reports->setSupplierOperName($item->supplier_oper_name);
                if (!empty($item->order_dt)) $reports->setOrderDt(new \DateTime($item->order_dt));
                if (!empty($item->sale_dt)) $reports->setSaleDt(new \DateTime($item->sale_dt));
                if (!empty($item->rr_dt)) $reports->setRrDt(new \DateTime($item->rr_dt));
                if (!empty($item->shk_id)) $reports->setShkId($item->shk_id);
                if (!empty($item->retail_price_withdisc_rub)) $reports->setRetailPriceWithdiscRub($item->retail_price_withdisc_rub);
                if (!empty($item->delivery_amount)) $reports->setDeliveryAmount($item->delivery_amount);
                if (!empty($item->return_amount)) $reports->setReturnAmount($item->return_amount);
                if (!empty($item->delivery_rub)) $reports->setDeliveryRub($item->delivery_rub);
                if (!empty($item->gi_box_type_name)) $reports->setGiBoxTypeName($item->gi_box_type_name);
                if (!empty($item->product_discount_for_report)) $reports->setProductDiscountForReport($item->product_discount_for_report);
                if (!empty($item->supplier_promo)) $reports->setSupplierPromo($item->supplier_promo);
                if (!empty($item->rid)) $reports->setRid($item->rid);
                if (!empty($item->ppvz_spp_prc)) $reports->setPpvzSppPrc($item->ppvz_spp_prc);
                if (!empty($item->ppvz_kvw_prc_base)) $reports->setPpvzKvwPrcBase($item->ppvz_kvw_prc_base);
                if (!empty($item->ppvz_kvw_prc)) $reports->setPpvzKvwPrc($item->ppvz_kvw_prc);
                if (!empty($item->ppvz_sales_commission)) $reports->setPpvzSalesCommission($item->ppvz_sales_commission);
                if (!empty($item->ppvz_for_pay)) $reports->setPpvzForPay($item->ppvz_for_pay);
                if (!empty($item->ppvz_reward)) $reports->setPpvzReward($item->ppvz_reward);
                if (!empty($item->acquiring_fee)) $reports->setAcquiringFee($item->acquiring_fee);
                if (!empty($item->acquiring_bank)) $reports->setAcquiringBank($item->acquiring_bank);
                if (!empty($item->ppvz_vw)) $reports->setPpvzVw($item->ppvz_vw);
                if (!empty($item->ppvz_vw_nds)) $reports->setPpvzVwNds($item->ppvz_vw_nds);
                if (!empty($item->ppvz_office_id)) $reports->setPpvzOfficeId($item->ppvz_office_id);
                if (!empty($item->ppvz_office_name)) $reports->setPpvzOfficeName($item->ppvz_office_name);
                if (!empty($item->ppvz_supplier_id)) $reports->setPpvzSupplierId($item->ppvz_supplier_id);
                if (!empty($item->ppvz_supplier_name)) $reports->setPpvzSupplierName($item->ppvz_supplier_name);
                if (!empty($item->ppvz_inn)) $reports->setPpvzInn($item->ppvz_inn);
                if (!empty($item->declaration_number)) $reports->setDeclarationNumber($item->declaration_number);
                if (!empty($item->bonus_type_name)) $reports->setBonusTypeName($item->bonus_type_name);
                if (!empty($item->sticker_id)) $reports->setStickerId($item->sticker_id);
                if (!empty($item->site_country)) $reports->setSiteCountry($item->site_country);
                if (!empty($item->penalty)) $reports->setPenalty($item->penalty);
                if (!empty($item->additional_payment)) $reports->setAdditionalPayment($item->additional_payment);
                if (!empty($item->kiz)) $reports->setKiz($item->kiz);
                if (!empty($item->srid)) $reports->setSrid($item->srid);
                $reports->setAccountId(1);
                $reports->setCreatedAt($date);
                $reports->setUpdatedAt($date);

$entityManager->persist($reports);

}
            $entityManager->flush();
        }
*/

/*
                if ($this->isGranted('ROLE_ADMIN')) {
                    return $this->redirectToRoute('admin_main');
                } elseif ($this->isGranted('ROLE_USER')) {
                    return $this->redirectToRoute('projects_page');
                }
        */
        return $this->render('cron/index.html.twig', [

]);

}

/**
     * @return \Doctrine\Common\Persistence\ObjectRepository|\App\Repository\CatalogRepository
     */
    protected function getCatalogRepo()
    {
        return $this->getDoctrine()->getRepository(Catalog::class);
    }

/**
     * @return \Doctrine\Common\Persistence\ObjectRepository|\App\Repository\CatalogRepository
     */
    protected function getCatalogLogRepo()
    {
        return $this->getDoctrine()->getRepository(CatalogLog::class);
    }

/**
     * @return \Doctrine\Common\Persistence\ObjectRepository|\App\Repository\CatalogRepository
     */
    protected function getCatalogUpdatesRepo()
    {
        return $this->getDoctrine()->getRepository(CatalogUpdates::class);
    }

}