SugarCRM Forums - Developer Help

How to send Email notifcation for case using logic hook

learner_01 — Sat, 18 May 2013 07:17:22 GMT

hello everyone,
i want to send email when i create case in SugarCRM version 6.4.5.
The email automatically send to assigned user, but email not send to client on case created and i also want email send to admin.
i tried logic hook for that, but that also doesn't help me.
i have tried this following code which i have attached in attachment. but i don't know, that will work for my requirement or not.
i also refereed angel's following blog but still i am confused can anyone help me?

Angel's Blog: Simple SugarCRM Logic Hook Example
Angel's Blog: SugarCRM Customization: Custom Workflow E-mails

thank you in advance

Learner_01

Attached Files

email_notification.php (1,004 Bytes)
logic_hooks.php (416 Bytes)

SugarCRM PRO General customization doubt

cent — Sat, 18 May 2013 01:20:39 GMT

Dear Friends,
I am using Sugar CRM Pro and now in work of planning a new CRM instance .
In my concern there is 4 modules
1 . Products
2. Quotes
3. Opportunity
4. Contacts

In current understanding I can add 'quotes' of an opportunity as Subpanel .
But my customers need the visibility of

1. In a particular opportunity they can easily find the report of the
including products and contacts , How it can implement?
In current scenario we have Quotes under opportunity .

2, We plan to implement lead web form from external web site, in that
there is option to select more than one product (for eg: Soap,Cheap,Mirror)
How to include multiple product in lead and on conversion how to identify that
products in quotes ?

I am really confused , do you please advise a general solution for my confusion.

Thankfully,
Anes

Workflow module and Email attachment

bivis — Fri, 17 May 2013 11:44:10 GMT

Hi all
I need help with workflow module.
I create workflow for new beans, then i create Alert Email Template. Then, when i create new bean, i want send email with attachment, but i can't found how i can do this.
And this is my question - Can i send email with attachment using Sugar workflow module or not?

Sugar version Ent.

Project-Email Templates relationship.

sahay143 — Fri, 17 May 2013 11:04:49 GMT

Hi All,

I have query, Is there a way to create relationship of Project with Email Templates???

I want to show the Email Templates as the subpanel under the Project module.

Looking forward for reply.....

Thanks & Regards
Sumit Sahay
sumit143sweta@gmailcom

How do I add invited Contacts to a Meeting via the API?

john2x — Fri, 17 May 2013 09:49:38 GMT

I'm creating Meetings via the SOAP api, but I can't figure out how to invite Contacts to the meetings created.
Which module or table do I need to add the invites?

How to convert the integer datatype to decimal data type in the sugarcrm

prince — Fri, 17 May 2013 06:55:34 GMT

Hi Evry one,
How to convert the integer datatype to decimal data type in the sugarcrm

The valid date must be not pass date and validdate<=End date

prince — Fri, 17 May 2013 06:53:46 GMT

Hello evry one ,How to validate date the two dates in the sugarcrm ,

1)The valid date must be not pass date ,
2)validdate<=End date

How to create a upload document filed in sugacrm pro 6.5.7 version

prince — Fri, 17 May 2013 06:51:28 GMT

Hi Every body...
How to create a upload document custom filed in custom module in the sugarcrm pro 6.5.7 version

Grouping Fields in EditView

banning — Thu, 16 May 2013 16:34:34 GMT

Here is the deal. I have a field called Billable Time... but I want to replaced that field in the EditView with billable_hours field and the billable_minutes drop down. My end result is that I am trying to reproduce the same effect that can be seen in the Calls module for the field duration.

PHP Code:


          1 => 

          array (

            'name' => 'billable_time_c',

            'label' => 'LBL_BILLABLE_TIME',

            'customCode' => 'some how add 2 custom fields in here called billable_hours_c & billable_minutes_c (billable_hours_c is a drop down menu)',

          ),

Duplicate entries in contact search screen

MWilson — Thu, 16 May 2013 15:47:22 GMT

I came in this morning to a peculiar problem raised by our sales team:

It seems that "most" contacts have duplicate entries in the contact search screen that, when clicked through, point to the same single record.

So the same contact will show up 2 or sometimes 3 times and behave for the most part just fine.

The data appears to be clean everywhere but the search screen itself.

Any idea where to look for this?

Business is fully functional (albeit with a couple work arounds) But I'm pretty stumped at where to start.

Searching Leads throw email-address using SOAP

SpockPT — Thu, 16 May 2013 15:07:38 GMT

Hi guys...

I'm trying to make a web service where i try to retrieve a lead by searching an email address... so i got this

PHP Code:


function checkClientIfProspect($client,$session_id,$email) {
        $query = 'leads.id in (
              select 
                eabr.bean_id
              from 
                email_addr_bean_rel eabr 
              join 
                email_addresses ea 
              on 
                eabr.email_address_id = ea.id 
              where 
                eabr.bean_module = \'Leads\' 
              and 
                ea.email_address = \''.$email.'\'
            )';
            $result = $client->call( 'get_entry_list',
                        array(
                            'session'=>$session_id,
                            'module_name'=>'Leads',
                            'query'=>$query, 
                            'order_by'=>'',
                            'offset'=>0,
                            'select_fields'=>array(
                                'id',
                            ),
                            'max_results'=>10
                        )
                    );
            echo "";
            print_r($result);
            echo "
";
            if ($result['result_count']==1) { //IF NOT EMPTY EXISTS A LEAD WITH THAT MAIL
                $module = 'Leads';
                $id = $result['entry_list']['0']['id'];
            }
    }

all function parameters are correct but the result i go is and the Lead with that mail exists... :\ already tryed with other emails and the result is always empty

Code:

Array

(

    [result_count] => 0

    [total_count] => 0

    [next_offset] => 0

    [entry_list] => Array

        (

        )



    [relationship_list] => Array

        (

        )



)

What is wrong in this function? i have a similar function to accounts that work well...

PHP Code:


function checkClientIfAccount($client,$session_id,$email) {
        $query = '
            accounts.id in (
              select 
                eabr.bean_id
              from 
                email_addr_bean_rel eabr 
              join 
                email_addresses ea 
              on 
                eabr.email_address_id = ea.id 
              where 
                eabr.bean_module = \'Accounts\' 
              and 
                ea.email_address = \''.$email.'\'
            )';
        
        $result = $client->call( 'get_entry_list',
                        array(
                            'session'=>$session_id,
                            'module_name'=>'Accounts',
                            'query'=>$query, 
                            'order_by'=>'',
                            'offset'=>0,
                            'select_fields'=>array(
                                'id',
                            ),
                            'max_results'=>10
                        )
                    );
                            
        //IF NOT EMPTY EXISTS A ACCOUNT WITH THAT MAIL
        if ($result['result_count']==1) {
            $module = 'Account';
               $id = $result['entry_list']['0']['id'];
        
        }
        
    }

Thank you in advance,
SpockPT :cool:

Add a quick create button in a subpanel

sugarswede — Thu, 16 May 2013 14:31:19 GMT

I've created a module using Module Builder and Studio and added a subpanel showing targets. Now I'm trying to add a quick-create-call-button to the subpanel (one button for each target). I want the button to trigger the 'quick create call'. Where do I start? :-)

Attached Images

How to insert row into Sugar config table during package install?

mike.smedley — Thu, 16 May 2013 13:15:09 GMT

How can I insert a row into Sugar's "config" table during the installation of my package?

I need help about Logic hooks for auto increment

ckander — Thu, 16 May 2013 10:35:33 GMT

Hi SugarCRM Community
I need a help for writing logic , I do not deeply syntax of beam files
I want to save value as Auto increment series like

Pro_01
Pro_02
Pro_03
I am writing code in Logic hooks like
I have no idea how handle this situation

// prevents directly accessing this file from a web browser
if(! defined('sugarEntry') || ! sugarEntry)
die('Not A Valid Entry Point');

class Process
{

function process(&$bean, $event,$arguments)
{

// for product calculations
$bean->test_c = ($bean->c_rate_c * $bean->t_amount_c);

// i am trying but i have no idea for handle
$bean->serial_c="Pro_"+1;

}

}

?>

Do not show current module in all Tab Groups (Module Menu Filters)

ivit — Thu, 16 May 2013 09:51:53 GMT

In SugarCRM CE 6.5.10 (I guess it is the same for all 6.5.x and earlier versions), current module is shown in all Tab Groups i.e. in all Module Menu Filters.
I need to show only modules that I have configured in Module Menu Filters.

Example:
I have "Sales" module filter (Tab group) that does not include "Cases" module. If I click on Cases module within "Support" module filter, I will enter Cases module. Now, I can see that module Cases is visible within "Sales" module filter (and visible in all other module filters).

How can I achieve that module appears only in the module filters where I have configured to appear (Admin section -> Configure Module Menu Filters)?
Is there a "friendly" config entry that can set such behavior?

Thanks,
Igor