yii2-autonumber Auto Number Extension for Yii 2

  1. Requirements
  2. Installation
  3. Usage
  4. Resources

Requirements

Yii 2.0 or above

Installation

The preferred way to install this extension is through composer.

Either run ~~~ php composer.phar require --prefer-dist mdmsoft/yii2-autonumber "" ~~~ or add ~~~ "mdmsoft/yii2-autonumber": "" ~~~ to the require section of your composer.json file.

Usage

Prepare required table by execute yii migrate. ~~~ yii migrate --migrationPath=@mdm/autonumber/migrations ~~~ if wantn't use db migration. you can create required table manually. ~~~ [sql] CREATE TABLE auto_number (

template_group varchar(64) NOT NULL,
template_num varchar(64) NOT NULL,
auto_number int NOT NULL,
optimistic_lock int NOT NULL,
update_time int,
PRIMARY KEY (template_group, template_num)

); ~~~ Once the extension is installed, simply modify your ActiveRecord class:

public function behaviors()
{
    return [
        [
            'class' => 'mdm\autonumber\Behavior',
            'attribute' => 'sales_num', // required
            'group' => 'sales', // required, unique
            'value' => 'SA.'.date('Y-m-d').'.?' , // format auto number. '?' will be replaced with generated number
            'digit' => 4 // optional, default to null. 
        ],
        ...
    ];
}

// it will set value $model->sales_num as 'SA.2014-06-25.0001'

Resources

0 0
3 followers
0 downloads
Yii Version: 2.0
License: BSD-2-Clause
Category: Database
Developed by: Misbahul D Munir
Created on: May 28, 2014
Last updated: 9 years ago

Related Extensions