Auto Number Extension for Yii 2
Yii2 extension to genarete formated autonumber. It can be used for generate
document number., (*1)
Installation
The preferred way to install this extension is through composer., (*2)
Either run, (*3)
php composer.phar require --prefer-dist mdmsoft/yii2-autonumber "~1.0"
or add, (*4)
"mdmsoft/yii2-autonumber": "~1.0"
to the require section of your composer.json
file., (*5)
Usage
Prepare required table by execute yii migrate., (*6)
yii migrate --migrationPath=@mdm/autonumber/migrations
if wantn't use db migration. you can create required table manually., (*7)
CREATE TABLE auto_number (
"group" varchar(32) NOT NULL,
"number" int,
optimistic_lock int,
update_time int,
PRIMARY KEY ("group")
);
Once the extension is installed, simply modify your ActiveRecord class:, (*8)
public function behaviors()
{
return [
[
'class' => 'mdm\autonumber\Behavior',
'attribute' => 'sales_num', // required
'group' => $this->id_branch, // optional
'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'
Instead of behavior, you can use this extension as validator, (*9)
public function rules()
{
return [
[['sales_num'], 'autonumber', 'format'=>'SA.'.date('Y-m-d').'.?'],
...
];
}
Since version 1.5 we introduce new format of number. Now we use {}
to evaluate as date and number of digit represented as number of ?
., (*10)
public function rules()
{
return [
[['sales_num'], 'autonumber', 'format' => 'SA/{Y/m}/?.???'],
...
];
}
// it will set value $model->sales_num as 'SA/2019/10/0.001'
public function behaviors()
{
return [
[
'class' => 'class' => 'mdm\autonumber\Behavior',
'attribute' => 'sales_num', // required
'value' => 'SA/{Y/m}/?.???'
]
];
}
// another usage
public function actionCreate()
{
$model = new Sales()
$model->load(Yii::$app->request->post());
$model->sales_num = mdm\autonumber\AutoNumber::generate('SA/{Y/m}/?.???');
...
}