'mysql', 'database_name' => 'interblue_sklep', 'server' => 'localhost', 'username' => 'interblue_sklep', 'password' => '2212+#++@pSVSb4', 'charset' => 'utf8' ] ); // $file = fopen('sollux.csv', 'r'); // while (($line = fgetcsv($file)) !== FALSE) { // $mdb -> update( 'ps_product', [ 'ean13' => $line[3] ], [ 'AND' => [ 'reference' => $line[2], 'reference[!]' => '' ] ] ); // print_r( $line ); // // die(); // } // fclose($file); echo '
';
  $results = $mdb -> query( 'SELECT id_order FROM ps_orders WHERE date_add < \'2021-01-01 00:00:00\' ORDER BY date_add DESC LIMIT 10' ) -> fetchAll( \PDO::FETCH_ASSOC );
  print_r( $results );
  if ( is_array( $results ) ) foreach ( $results as $row )
  {
    $thisorder = $mdb -> select( 'ps_orders', 'id_cart', [ 'id_order' => $row['id_order'] ] );

    if (isset( $thisorder[0] ) )
    {
      $mdb -> exec( 'DELETE a,b FROM ps_order_return AS a LEFT JOIN ps_order_return_detail AS b ON a.id_order_return = b.id_order_return WHERE id_order=\'' . $row['id_order'] . '\'' );
      // print_r( $mdb -> error() );

      $mdb -> exec( 'DELETE a,b FROM ps_order_slip AS a LEFT JOIN ps_order_slip_detail AS b ON a.id_order_slip = b.id_order_slip WHERE id_order=\'' . $row['id_order'] . '\'' );
      // print_r( $mdb -> error() );

      $mdb -> exec( 'DELETE FROM ps_cart_product WHERE id_cart=\'' . $thisorder[0] . '\'' );
      // print_r( $mdb -> error() );

      $mdb -> exec( 'DELETE FROM ps_order_history WHERE id_order=\'' . $row['id_order'] . '\'' );
      // print_r( $mdb -> error() );

      $mdb -> exec( 'DELETE FROM ps_order_detail_tax WHERE id_order_detail IN (SELECT id_order_detail FROM ps_order_detail WHERE id_order =\'' . $row['id_order'] . '\')' );
      // print_r( $mdb -> error() );

      $mdb -> exec( 'DELETE FROM ps_order_detail WHERE id_order=\'' . $row['id_order'] . '\'' );
      // print_r( $mdb -> error() );

      $mdb -> exec( 'DELETE FROM ps_order_payment WHERE order_reference IN (SELECT reference FROM ps_orders WHERE id_order=\'' . $row['id_order'] . '\')' );
      // print_r( $mdb -> error() );

      $mdb -> exec( 'DELETE FROM ps_orders WHERE id_order=\'' . $row['id_order'] . '\'' );
      // print_r( $mdb -> error() );

      $mdb -> exec( 'DELETE FROM ps_order_carrier WHERE id_order=\'' . $row['id_order'] . '\'' );
      // print_r( $mdb -> error() );

      $mdb -> exec( 'DELETE FROM ps_order_invoice_tax WHERE id_order_invoice IN (SELECT id_order_invoice FROM ps_order_invoice WHERE id_order=\'' . $row['id_order'] . '\')' );
      // print_r( $mdb -> error() );

      $mdb -> exec( 'DELETE FROM ps_order_invoice WHERE id_order=\'' . $row['id_order'] . '\'' );
      // print_r( $mdb -> error() );

      $mdb -> exec( 'DELETE FROM ps_order_invoice_payment WHERE id_order=\'' . $row['id_order'] . '\'' );
      // print_r( $mdb -> error() );

      $mdb -> exec( 'DELETE FROM ps_order_cart_rule WHERE id_order=\'' . $row['id_order'] . '\'' );
      // print_r( $mdb -> error() );
    }
  }
  ?>