automatically create a task when a lead status is changed

[sawan]

Hello everyone,

O/S:Windows 2000
SugarCRM community edition
Version 5.0.0b (Build 3150) (upgraded from Version 5.0.0a (Build 3150))


I have added a date field follow-up-date in leads module.
I have also made the label of lead status Dead to "Close".

So when a lead status is changed to Close i want to create a new task with due date as follow-up-date.

I am trying to find out,please help me.
Its really urgent.

Your help will be really very much appericiable.

[andopes]

HI, sawan.

I just answered this question into your other post.

Cheers


--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br

[sawan]

Hey thanks Andopes ,yes it should be in quotes,my mistake.
i am working further on logic right now.
Thanks again.

[sawan]

Now i have to write the logic of insert new task.that is fine.but the problem is,each task has an unique id field which is generated by sugarcrm.i think createguid function does that.but while creating a new task(i.e. inserting new task in db) in normal manner i.e. create task in sugarcrm is having some definate flow.i can insert all other field values except this id field ,how can i achieve this?
please guide.
thanks

[sawan]

Hello every one,

i have found the solution.
i got help from some threads:

http://www.sugarcrm.com/forums/showthread.php?t=30315
http://www.sugarcrm.com/forums/showthread.php?t=28400

thanks to these people.

here is the code

<?php
require_once('include/utils.php');

class TestClass{

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

if($event == 'before_save' && $bean->status == 'Dead')
{
$guid = create_guid();
$leadname2='Call lead '.$bean->first_name.$bean->last_name;

$query="insert into Tasks(id,name,modified_user_id ,created_by,assigned_user_id,status,date_due,paren t_type,parent_id,priority)values('$guid','$leadnam e2','1','1','1','In Progress','$bean->followupdate_c','Leads','$bean->id','High')";

$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

}

}