PHP:自动编码规则生成

///自动编码，按照规则生成；

1. Editviewdefs界面：

'default' => array(
    //编号+供应商 
    0 =>
    array(
        0 =>
        array(
            'name' => 'number',
            'studio' => 'visible',
            'label' => 'LBL_NUMBER',
            'customCode' => '{$NUMBER}',
        ),

2.View.edit界面：

$wo_num_html="";

if(empty($this->bean->number)){

    //如果当前工作单号为空，则返回自动编号标签

    $wo_num_html='保存后自动分配'.'<input type="hidden" value="" id="number" name="number">';

} else {

    $wo_num_html=$this->bean->number.'<input type="hidden" value="'.$this->bean->number.'" id="number" name="number">';

}

$this->ss->assign('NUMBER',$wo_num_html);

 

3..Php中的save方法；

//编号规则

        $str = date('Ymd');

        $max_mpr_number = $db->getOne("SELECT number FROM hat_quality_feedback WHERE number LIKE '%" . $str . "%' ORDER BY number DESC LIMIT 1");

        if ($max_mpr_number) {

            $num = (int)substr($max_mpr_number, -4);

            $new_mpr_number = $str .'-'. sprintf('%04d', $num + 1);

        } else {

            $new_mpr_number = $str .'-'. sprintf('%04d', 1);

        }

        $this->number = $new_mpr_number;

        parent::save($check_notify);