How to generate Item code for different products

combine two column (and also 'unit_price' ??) to one column item_id (FK)

$table->string('item_code');
$table->string('item_name');

if use "item001", how you know the number of 0 zero give to str_pad()

@maaz how about you use the id of the puchase_details that you created so that you have a unique item_code?

// after you created the purchase_details

$itemCode = 'item' . str_pad($purchase_details->id, 4, '0', STR_PAD_LEFT);
$purchase_details->item_code = $itemCode;
// item_code will be item0001 if id is 1, you get the point

$purchase_details->save();

and if you want to expand to item00000001 just change 4 to 8 or what you prefer.

thanks a lot let me try :)

so you table column value look weird....

item001

item00001999

item0000000023333

if item_code is base on item_id

https://laravel.com/docs/7.x/eloquent-mutators#accessors-and-mutators

@newbie360 nope, if your $id = 122 the item_code will be item0122

that's why it's very important to know what is the possible length of the purchase_details, let's say the possible is ranging between 1,000,000 and 10,000,000 records then we can use 8 as length to have item00000001 or if id is 32456 then it will be item00032456

@maaz please note on this

@neilstee yup, i know ;)

because the item id is keep increasing, so can't exactly know the number to pad

@maaz can you give specific example?

@maaz

   public function up()
    {
        Schema::create('purchase_details', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('purchase_id');
            $table->unsignedBigInteger('item_id');
            $table->float('qty');
            $table->flat('discount_on_all')->default(0);
            $table->float('net_amount');
            $table->timestamps();
            $table->foreign('item_id')->references('id')->on('items');
        });
    }

so the item_id is belongsTo items table id

the items table

| id  | name    | price |
| --- | ------  | ----- |
| 1   | ASUS    | 900   |
| 2   | ASUS    | 888   |
| 3   | Linksys | 50    |