PrestaShop | universal open-source software platform | Ecommerce library

$productIds = Db::getInstance()->executeS('SELECT id_product FROM `' . _DB_PREFIX_ . 'product` ORDER BY id_product LIMIT 60');
$categoryId = 1;
$time_pre_total = microtime(true);
foreach ($productIds as $id) {
  echo '------------------------------------------';
  var_dump($id);
  echo '
';
  $time_pre = microtime(true);
  $product = new Product((int)$id['id_product'], null, null, (int)Context::getContext()->shop->id);
  $time_post = microtime(true);
  $exec_time = $time_post - $time_pre;
  var_dump($exec_time);
  echo '
';
  $time_pre = microtime(true);
  $product->updateCategories([(int)$categoryId]);
  $time_post = microtime(true);
  $exec_time = $time_post - $time_pre;
  var_dump($exec_time);
  echo '
';
  $time_pre = microtime(true);
  $product->id_category_default = $categoryId;
  $time_post = microtime(true);
  $exec_time = $time_post - $time_pre;
  var_dump($exec_time);
  echo '
';
  $time_pre = microtime(true);
  $product->update();
  $time_post = microtime(true);
  $exec_time = $time_post - $time_pre;
  var_dump($exec_time);
  echo '
';
  echo '------------------------------------------';
}
echo '------------------------------------------';
echo '------------------------------------------';
echo '
';
$time_post_total = microtime(true);
$exec_time_total = $time_post_total - $time_pre_total;
var_dump($exec_time_total);
echo '
';
echo 'cycle ended';

UPDATE ps_stock_available sa
SET sa.reserved_quantity = (
    SELECT IFNULL(SUM(od.product_quantity - od.product_quantity_refunded),0) 
    FROM ps_orders o
    INNER JOIN ps_order_detail od ON od.id_order = o.id_order
    INNER JOIN ps_order_state os ON os.id_order_state = o.current_state
    WHERE o.id_shop = 1 AND
    os.shipped != 1 AND (
        o.valid = 1 OR (
            os.id_order_state NOT IN ('6,28,59') AND
            os.id_order_state NOT IN ('8')
        )
    ) AND sa.id_product = od.product_id AND
    sa.id_product_attribute = od.product_attribute_id
    GROUP BY od.product_id, od.product_attribute_id
)
WHERE sa.id_shop = 1 AND sa.id_product = 3374;

$updateReservedQuantityQuery = '
            UPDATE {table_prefix}stock_available sa
            SET sa.reserved_quantity = (
                SELECT SUM(od.product_quantity - od.product_quantity_refunded)
                FROM {table_prefix}orders o
                INNER JOIN {table_prefix}order_detail od ON od.id_order = o.id_order
                INNER JOIN {table_prefix}order_state os ON os.id_order_state = o.current_state
                WHERE o.id_shop = :shop_id AND
                os.shipped != 1 AND (
                    o.valid = 1 OR (
                        os.id_order_state != :error_state AND
                        os.id_order_state != :cancellation_state
                    )
                ) AND sa.id_product = od.product_id AND
                sa.id_product_attribute = od.product_attribute_id
                GROUP BY od.product_id, od.product_attribute_id
            )
            WHERE sa.id_shop = :shop_id
        ';

        $strParams = array(
            '{table_prefix}' => _DB_PREFIX_,
            ':shop_id' => (int) $shopId,
            ':error_state' => (int) $errorState,
            ':cancellation_state' => (int) $cancellationState,
        );

        if ($idProduct) {
            $updateReservedQuantityQuery .= ' AND sa.id_product = :product_id';
            $strParams[':product_id'] = (int) $idProduct;
        }

        if ($idOrder) {
            $updateReservedQuantityQuery .= ' AND sa.id_product IN (SELECT product_id FROM {table_prefix}order_detail WHERE id_order = :order_id)';
            $strParams[':order_id'] = (int) $idOrder;
        }

        $updateReservedQuantityQuery = strtr($updateReservedQuantityQuery, $strParams); 

render('@Modules/your-module/templates/admin/demo.html.twig');
    }
    public function listAction()
    {
        $em = $this->getDoctrine()->getManager();
        $data = $em->getRepository(YoutubeComment::class)->findAll();
        return $this->render(
            '@Modules/myyoutubemc/templates/admin/list.html.twig',
            [
                'data' => $data
            ]
        );
    }

youtube-list:
    path: youtuber/list
    methods: [GET]
    defaults:
      _controller: 'Myyoutubemc\Controller\YoutubeController::listAction'

{block name="hero_content"}
    {if Tools::getValue('id_category') == 11 || 19 || 20 || 21 || 22 || 23}
        
            {if $listing.pagination.items_shown_from == 1}
                
                    {$category.name}
                
                
                    {include file='catalog/_partials/subcategories.tpl'}
                
                
                    {$category.description nofilter}
                
            {/if}
        
    {/if}
{/block}

/modules/sdevmanomano/classes/MyClass.php
if (!defined('_PS_VERSION_')) {
    exit;
}

include_once(dirname(__FILE__) . '/OtherClass.php');

class MyClass
{
...
//Before execute the code i want check if he has open correctly the CSV in tmpName
    private function getDeliveryPrices(){
        $tmpName = fopen(dirname(dirname(__FILE__)) . '/prices/prezzi_spedizione_francia.csv', 'r');
        if ($tmpName){
           $csvAsArray = 'ok';
        } else {
            $csvAsArray = 'errore';
        }

        return $csvAsArray;
    }
}
// end of class
$test = new MyClass();

$res = $test->getDeliveryPrice();
var_dump($res);

Context::getContext()->cookie

document.cookie

  
    
      
      
        Channel
        
          {{ channel }}
        
      
      
        Countries
        
      
    
    
      Custom Channel
        
    
    
      
        Channel Type
        
          
            
            Standard
          
          
            
            Custom
          
        
      
      
        
          Assign Channel
          
        
      
    
  

export class OrganizationChannelsComponent implements OnInit {

  selectChannelsSources: Array = ["eMag Marketplace", "Vtex", "Shopify", "Magento1", "Magento2", "WooCommerce", "Prestashop", "TeamShare", "Gomag", "Opencart", "MerchantPro", "Cscart", "Allegro", "Idosell", "ChannelAdvisor", "Shoprenter", "Transfer", "Defecte/Defects", "Manual Order"];
  selectCountriesSources: Array = [];
  icons = {
    close: faTimes,
    plus: faPlus
  }

  organizationChannelForm!: FormGroup;

  selectedCountries: Array = [];
  selectedChannel: Channel | undefined;
  isChannelTypeStandard: boolean = true;

  @Input() organizationId!: ID;

  organizationChannels$: Observable = new BehaviorSubject([]);
  channels$: Observable = new BehaviorSubject([]);

  constructor(
    private organizationChannelsService: OrganizationsChannelsService,
    private organizationChannelsQuery: OrganizationChannelsQuery,
    private countriesService: CountriesService,
    private toasterService: ToasterService,
    private formBuilder: FormBuilder,
  ) { }

  ngOnInit(): void {
    this.organizationChannelForm = this.formBuilder.group({
      channel_id: ['', Validators.required],
    });

    this.organizationChannelsService.getOrganizationChannels(this.organizationId).subscribe();
    this.organizationChannels$ = this.organizationChannelsQuery.selectOrganizationChannels(this.organizationId as number);
    this.countriesService.get().subscribe(countries => this.selectCountriesSources = countries);
  }

  updateOrganizationChannelForm() {
    if (this.isChannelTypeStandard) {
      this.organizationChannelForm = this.formBuilder.group({
        channel_id: ['', Validators.required],
      });
    }
    else {
      this.organizationChannelForm = this.formBuilder.group({
        custom_channel_name: [Validators.required, Validators.minLength(8)]
      });
    }    
  }
}