Unique Number Incremental

[DanBrown]

Hi im using :
MySQL client version: 5.0.45
Sugar 5.0.0g

I have managed to create a unique number that auto increments for my accounts, however is it possible to define a defualt numbering format instead of it going up like 1, 2, 3, 4 etc, can a default format be set like A00001, A00002, A00003?

Many Thanks

[andopes]

Hi Dan.

1. You create the custom field in accounts (text field);
2. You create a logic_hook before_save for Accounts. This logic_hook can define the next value based on the last value saved into database. For this use a query to find out the last auto incremental value;
3. You use the function sprintf to generate the next value formated.

Cheers

[DanBrown]

How do i create a logic hook, can it be done in PHP?

[andopes]

Hi Dan.

There are articles into Sugar Wiki which can help you how to create logic_hook.

Cheers

[DanBrown]

Thanks Andre

[DanBrown]

do i need to build an installer for this logic hook?
can you confirm i am looking at the correct Wiki article:
http://www.sugarcrm.com/wiki/index.p...r_Custom_Logic

[andopes]

Hi Dan,

No, you don't need to create an installer for the logic_hook.

You just have to:
1. create the file custom/modules/<ModuleName>/logic_hooks.php
2. Add inside this file the enough array to call the method in the Logic Hook Class
3. Create the Class
4. Create the method will be called by logic_hook. This method will perform the custom logic.

An example of the Logic Hook Class:

 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 
class UserHook {
    function setSearchFields(&$focus, $event, $arguments) {
        global $current_user;
        
        if($focus->id == $current_user->id && isset($_REQUEST['action'])) {
            if($_REQUEST['module'] == 'UP2_placements') {
                //cleaning the template HTML every time
                //this is necessary in non-Developer mode because of the custom code in the check-boxes
                require_once('modules/Administration/QuickRepairAndRebuild.php');
                
                $selected_actions = Array(0 => 'clearTpls');
                $modules = Array(0 => 'UP2_placements');
                $RepairAndClear = new RepairAndClear();
                $RepairAndClear->repairAndClearAll($selected_actions, $modules, $autoexecute=false, $show_output=false);
                //end this is necessary in non-Developer mode because of the custom code in the check-boxes
            }
            if($_REQUEST['action'] == 'AdDeliveryImportView') {
                $this->setAdDeliveryImportSearchFields();
            } else if($_REQUEST['action'] == 'SelectInventoryView') {
                $this->setSelectInventorySearchFields();
            } else if($_REQUEST['action'] == 'MonthEndValidationView') {
                $this->setMonthEndValidationSearchFields();
            }
        }
    }
} 
  

Best regards.

[DanBrown]

Thanks André

Ill give it a go, just so i know what does the PHP code you pasted here actually do, just so i can reference it with the one i try to create.

[kuske]

In this thread http://www.sugarcrm.com/forums/showthread.php?t=27290
I described such a solution.