metinbaris/inventory-bundle

使用给定的CSV文件更新Symfony应用的MYSQL数据库

1.0.2 2024-03-06 11:24 UTC

This package is auto-updated.

Last update: 2024-09-06 12:26:45 UTC


README

库存更新的Symfony扩展包

要在您的symfony项目中安装此扩展包,请运行

composer require metinbaris/inventory-bundle

更新项目.env文件,应包含以下内容

INVENTORY_MAIL={email_address_to_share_stock_info}
MAILER_DSN={smtp://your_smtp_configuration}
DATABASE_URL={mysql_connection}

创建数据库表stocks

php bin/console doctrine:migrations:diff
php bin/console doctrine:migrations:migrate

将metin_baris_routes.yaml复制到您的路由目录,或将以下内容粘贴到路由文件中

 metin_baris_inventory_bundle_routes:
    resource: '@InventoryBundle/Controller/'
    type: attribute

要从主symfony项目根目录上传csv,请运行

php bin/console metinbaris:read-inventory "{path_to_your_csv}/example.csv"

确保Symfony Messenger工作进程正在运行,以便更新库存时发送缺货邮件

php bin/console messenger:consume async

库存路由列表

/index

alt text

项目依赖

确保您的环境已安装PHP >=8.2 以及以下PHP扩展和Composer包

  • PHP版本: >=8.2
  • ext-ctype
  • ext-iconv
  • doctrine/dbal: ^3
  • doctrine/doctrine-bundle: ^2.11
  • doctrine/doctrine-migrations-bundle: ^3.3
  • doctrine/orm: ^3.1
  • phpdocumentor/reflection-docblock: ^5.3
  • phpstan/phpdoc-parser: ^1.26
  • symfony/asset: 7.0.*
  • symfony/asset-mapper: 7.0.*
  • symfony/console: 7.0.*
  • symfony/doctrine-messenger: 7.0.*
  • symfony/dotenv: 7.0.*
  • symfony/expression-language: 7.0.*
  • symfony/flex: ^2
  • symfony/form: 7.0.*
  • symfony/framework-bundle: 7.0.*
  • symfony/http-client: 7.0.*
  • symfony/intl: 7.0.*
  • symfony/mailer: 7.0.*
  • symfony/mime: 7.0.*
  • symfony/monolog-bundle: ^3.0
  • symfony/notifier: 7.0.*
  • symfony/process: 7.0.*
  • symfony/property-access: 7.0.*
  • symfony/property-info: 7.0.*
  • symfony/runtime: 7.0.*
  • symfony/security-bundle: 7.0.*
  • symfony/serializer: 7.0.*
  • symfony/stimulus-bundle: ^2.16
  • symfony/string: 7.0.*
  • symfony/translation: 7.0.*
  • symfony/twig-bundle: 7.0.*
  • symfony/ux-turbo: ^2.16
  • symfony/validator: 7.0.*
  • symfony/web-link: 7.0.*
  • symfony/yaml: 7.0.*
  • twig/extra-bundle: ^2.12|^3.0
  • twig/twig: ^2.12|^3.0