<?php

/**
 * Author: ykxiao
 * Date: 2025/3/7
 * Time: 下午3:27
 * Description: 创建库存表 inventory 的迁移文件
 *
 * (c) ykxiao <yk_9001@hotmail.com>
 *
 * This source file is subject to the MIT license that is bundled
 * with this source code in the file LICENSE.
 */

use App\Service\MigrateService;
use Hyperf\Database\Schema\Schema;
use Hyperf\Database\Schema\Blueprint;
use Hyperf\Database\Migrations\Migration;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('inventory', function (Blueprint $table) {
            $table->bigIncrements('id');

            $table->string('company_code', 50)->default('')->comment('公司代码');
            $table->tinyInteger('status')->default(1)->comment('资源状态(-1:删除,0:禁用,1:在途,2:已入库,3:部分出库,4:全部出库,5:待分配库位)');
            $table->integer('bale_id')->default(0)->comment('采购捆包id');
            $table->tinyInteger('source')->default(1)->comment('数据来源(1:自建,2:仓储)');
            $table->integer('stock_id')->default(0)->comment('库存汇总ID');
            $table->string('bale_no', 45)->default('')->comment('捆包号');
            $table->string('supplier', 50)->default('')->comment('供应商');
            $table->integer('supplier_id')->default(0)->comment('供应商id');
            $table->string('issuing', 50)->default('')->comment('开证公司');
            $table->integer('issuing_id')->default(0)->comment('开证公司id');
            $table->string('breed', 50)->default('')->comment('商品名称');
            $table->integer('breed_id')->default(0)->comment('品名id');
            $table->string('brand', 50)->default('')->comment('品牌');
            $table->integer('brand_id')->default(0)->comment('品牌id');
            $table->string('grade', 50)->default('')->comment('等级');
            $table->integer('grade_id')->default(0)->comment('等级id');
            $table->string('thickness', 50)->default('')->comment('厚度');
            $table->string('width', 50)->default('')->comment('宽度');
            $table->string('length', 50)->default('')->comment('长度');
            $table->string('pieces', 50)->default('')->comment('片数');
            $table->decimal('per_cube', 18, 9)->comment('单包立方');
            $table->unsignedInteger('init_number')->default(0)->comment('入库初始件数');
            $table->unsignedInteger('number')->default(0)->comment('库存件数');
            $table->unsignedInteger('lock_number')->default(0)->comment('锁定件数');
            $table->unsignedInteger('enable_number')->default(0)->comment('可用件数');
            $table->unsignedInteger('out_number')->default(0)->comment('已出件数');
            $table->decimal('foreign_currency_price', 18, 2)->default(0.00)->comment('外币单价');
            $table->integer('foreign_currency_id')->default(0)->comment('外币名称id');
            $table->string('foreign_currency_unit', 3)->comment('外币符号');
            $table->decimal('purchase_amount', 18, 2)->default(0.00)->comment('采购金额');
            $table->decimal('sales_price', 18, 2)->default(0.00)->comment('销售单价/挂牌价');
            $table->decimal('pay_rate', 18, 4)->default(0.0000)->comment('实付汇率');
            $table->decimal('purchase_price', 18, 2)->default(0.00)->comment('采购单价');
            $table->decimal('cost_price', 18, 2)->comment('费用平摊单价');
            $table->integer('storage_location_id')->default(0)->comment('库位ID');
            $table->string('storage_location', 100)->default('')->comment('库位');
            $table->string('contract_no', 45)->default('')->comment('合同号');
            $table->string('bill_lading_no', 45)->default('')->comment('提单号');
            $table->integer('port_id')->default(0)->comment('港口id');
            $table->string('purpose_port', 255)->default('')->comment('目的港');
            $table->integer('expected_storage_time')->default(0)->comment('预计入库时间');
            $table->integer('expected_arrival_time')->default(0)->comment('预计到港时间');
            $table->string('place_origin', 255)->default('')->comment('产地');
            $table->tinyInteger('is_changed')->default(0)->comment('是否改动(0:未改动,1:已改动)');
            $table->tinyInteger('qr_code_status')->default(0)->comment('扫码状态(1-未扫码，2-已扫码)');
            $table->tinyInteger('purchase_type')->default(0)->comment('采购类型 (1 合同采购, 2外调采购)');
            $table->json('images')->comment('产品图片');
            $table->string('thumbnail', 255)->default('')->comment('封面缩略图');
            $table->integer('inbound_time')->default(0)->comment('入库时间');
            $table->integer('stocker_id')->default(0)->comment('入库人id');
            $table->string('stocker_name', 30)->default('')->comment('入库人名字');
            $table->string('cargo_remark', 200)->default('')->comment('货物状态');

            // 仓库字段
            $table->string('purchase_sn', 45)->default('')->comment('采购单号'); 
            $table->string('contract_sn', 45)->default('')->comment('采购合同号'); 
            $table->string('container_no', 45)->default('')->comment('柜号/车牌号');
            $table->tinyInteger('customer_type')->default(1)->comment('代理类型：1-代理 2-非代理'); 
            $table->tinyInteger('category')->default(1)->comment('货物类型：1-原木 2-板材'); 
            $table->tinyInteger('packaging_type')->default(1)->comment('包装类型（1-整包、2-混包）'); 
            $table->string('spec', 100)->default('')->comment('仓库规格'); 
            $table->integer('sh_company_id')->default(0)->unsigned()->comment('收货公司id'); 
            $table->string('sh_company_name', 45)->default('')->comment('收货公司');
            $table->integer('aisle_id')->default(0)->unsigned()->comment('通道ID'); 
            $table->string('aisle_name', 45)->default('')->comment('通道名');
            $table->integer('warehouse_id')->default(0)->comment('仓库id');
            $table->string('warehouse', 255)->default('')->comment('仓库');
            $table->integer('location_id')->default(0)->unsigned()->comment('仓库库位ID'); 
            $table->integer('attribute_id')->default(0)->unsigned()->comment('库位属性ID'); 
            $table->string('custom', 45)->default('')->comment('自定义属性'); 
            $table->string('location_no', 100)->default('')->comment('仓库库位拼接信息');
            $table->string('remark', 300)->default('')->comment('备注');

            MigrateService::migrateCreateInfo($table);

            $table->comment('库存表');
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('inventory');
    }
};