public function generateEmployeeId()
{
$hiredate = strtotime($this->hiredate);
$code = date('ym', $hiredate);
$c = new CDbCriteria();
$c->condition = 'code like :code';
$c->params = array(':code' => "{$code}%");
$c->select = 'MAX(CONVERT(RIGHT(code,3),UNSIGNED INTEGER)) AS last_number';
$model = MastersEmployees::model()->find($c);
$last_number = count($model) > 0 ? $model->last_number + 1 : 1;
return $code . MyHelper::numberString($last_number, 3, '0');
}
