项目中有个对新增的机器进行自行编号保证编号的唯一和快速,下面把程序丢出来记录下:
<?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