项目中有个对新增的机器进行自行编号保证编号的唯一和快速,下面把程序丢出来记录下:
<?PHP
/**
* @file
* Defines "warehouse import" Feeds import.
*
* @Todo: Split admin functions into their own file.
*/
/* function node_modfiy_form_alter(&$form,$form_state,$form_id) {
if ($form_id == 'fixed_assets_node_form') {
drupal_set_message(t('some message.'));
dpm($form);
dpm($node);
}
} */
function node_modfiy_form_alter(&$form,&$form_state,$form_id) {
if($form_id=='fixed_assets_node_form'){
//dpm($form);
//dpm($form_state);
if(!isset($form['nid']['#value'])){
$form['title']['#ajax']=array(
'event'=>'click','wrapper'=>'form-item-form-type-textfield-form-item-title','callback'=>'node_modfiy_title_ajax_callback',);
$form['title']['#prefix']='<div id=form-item-form-type-textfield-form-item-title>';
$form['title']['#suffix']='</div>';
$form['title']['#validate']=TRUE;
//form_set_cache($form['#build_id'],$form,$form_state);
$form['#validate'][]='node_modfiy_form_validate';
//dpm($form['#validate']);
}
}
}
/**
* Implementation of hook_validate().
*验证输入的条码不可以有重复
*/
function node_modfiy_form_validate($form,&$form_state){
if(strlen($form_state['values']['title'])<10 )
form_set_error('title','请选择正确的位置信息和机器分类信息');
$myresult=db_query("select n.nid FROM {node} n Where n.title=:title And n.type=:type",array('title'=>$form_state['values']['title'],'type'=>"fixed_assets"));
$nid=$myresult->fetchColumn(1);
if($nid)
form_set_error('title','重复的条码!');
}
function node_modfiy_title_ajax_callback($form,$form_state){
$fixed_barcode=taxonomy_term_load($form_state['storage']['hs']['hs_fields']['field_localtion-und']['hierarchical_select']['selects'][0]['#default_value'])->name;
$fixed_barcode.=taxonomy_term_load($form_state['storage']['hs']['hs_fields']['field_machineclass-und']['hierarchical_select']['selects'][0]['#default_value'])->name;
$fixed_barcode.=taxonomy_term_load($form_state['storage']['hs']['hs_fields']['field_machineclass-und']['hierarchical_select']['selects'][1]['#default_value'])->name;
$fixed_class=$form_state['storage']['hs']['hs_fields']['field_machineclass-und']['hierarchical_select']['selects'][1]['#default_value'];
$count=db_query("select count(nid) from {taxonomy_index} where tid in (SELECT tid FROM {taxonomy_term_hierarchy} WHERE parent=".$form_state['storage']['hs']['hs_fields']['field_machineclass-und']['hierarchical_select']['selects'][1]['#default_value'].")")->fetchField();
//$count = $query->execute()->fetchField();
$myid=$fixed_barcode.(sprintf("%04d",$count+1));
//$myresult=db_result(db_query("select 1 FROM {node} Where title=%s And type=%s",$myid,"fixed_assets"));
$form['title']=array(
'#type'=>'textfield','#title'=>'衣车编号','#required'=>TRUE,'#value'=>$myid,'#maxlength'=>255,'#weight'=>-7,'#prefix'=>'<div id=form-item-form-type-textfield-form-item-title>','#suffix' => '</div>','#validated' => TRUE,'#name' => 'title','#id'=>'edit-title','#class'=>'form-text required ajax-processed'
);
//if(strlen($myid)<10 || $myresult){
if(strlen($myid)<10){
form_set_error('title','请选择正确的位置信息和机器分类信息,将生成衣车编号');
}
return $form['title'];
}
程序很简单但其中有较多的知识点:AJAX的使用,sprintf 函数,form_set_error ,二个Hook,还有找到应的变量的结构等等。
程序参考了以下资料:
SQL查询方面的,
https://api.drupal.org/api/drupal/includes!database!select.inc/function/SelectQuery%3A%3AaddExpression/7
https://api.drupal.org/api/drupal/includes%21database%21database.inc/function/db_query/7
https://api.drupal.org/api/drupal/includes!database!database.inc/function/db_select/7
https://www.drupal.org/node/1051242
https://www.drupal.org/node/494026
一个验证Hook,
http://www.thinkindrupal.com/node/1016
AJAX例子,
https://www.drupal.org/node/2465119