field with autoincrement

[Cata_bRc]

Hy,
if anyone could help me I would be very grateful.
I need a field with autoincrement like case_number
I have a module with orders and I need a field order_number with autoincrement
first order number field would be 1 next 2 ... 112,113
Can anyone help me please?
Thank you very much

[eitrix]

example:

module: orders
field: order_num_c (created from studio integer)

make before save logic hook on that module and function can go like:

 function orderIncrement($bean,$event,$arg){
 
// check if record is new, only do this on new records
if($bean->id != $bean->fetched_row['id']{
$db = //make db object here for whatever you use
 
$query = "SELECT order_num_c FROM orders_cstm WHERE deleted = 0 ORDER BY order_num_c DESC LIMIT 0,1";
 
// run query example mysql
$resullt = $db->query("query");
 
// get your result row as associative array
// if no result assign 1
if($result == false){
$bean->id = 1;
}elseif($row = $result->fetch_assoc()){
// assign value if you did get result
$bean->id = $row['order_num_c'] +1;
}else{
die("Error in db query");
}
}
} 
  

something like this

[Cata_bRc]

I will try it
Thank you very much

[rakeshray]

hi
Simply use following code.............. in vardefs..........

In a custom module I had the following in vardefs

'pay_no' =>
array (
'required' => '1',
'name' => 'pay_no',
'vname' => 'LBL_TIMENO',
'type' => 'int',
'massupdate' => 0,
'len' => '11',
'auto_increment'=>true,

),

and

'indices' => array (
array('name' =>'pay_no' , 'type'=>'unique' , 'fields'=>array('pay_no')
),),

[cedcas]

Hello Rakeshay,

I placed those two sets of codes into my module's vardefs.php but not getting any values on the field. Is there anything else to make this to work?