logic hook ??

[tamhd_vn88]

i fill information



i create a logic_hook, type before_save to check same infomation. If i write

$query="select id from m10_khachhang where name='$bean->name' and dienthoaicodinh='$bean->dienthoaicodinh' and deleted=0" ;
$results = $bean->db->query($query, true);
if($bean->db->getRowCount($results) != 0)
{
header('location:index.php?module=M10_Khachhang&ac tion=EditView&return_module=M10_Khachhang&return_a ction=DetailView');
die();
}

result is


But i want if same infomation, will show alert and come back previous page
result is





i know use "header('location:index.php?module=M10_Khachhang&a ction=EditView&return_module=M10_Khachhang&return_ action=DetailView');" can't sloving my problem.I think i want use a different command or use a different way.
Please help me in sloving this problem
thanks & Regards

[AlexAv]

It's not clear for me. What do you want to do?

[tamhd_vn88]

It's not clear for me. What do you want to do?

hello alex
I want when same infomation, will display a alert , after that will come back previous page( but all infomation i fill is'nt cleared). I want to write in hook or show for me different way to sloving this problem. Thank!!

[davidboris]

Hi,

Why not check your conditions on ajax call before it saves the record?

[AlexAv]

I got it. Try this.

 $query="select id from m10_khachhang where name='$bean->name' and dienthoaicodinh='$bean->dienthoaicodinh' and deleted=0" ;
$results = $bean->db->query($query);
if($row = $bean->db->fetchByAssoc($results))
{
  header('location:index.php?module=M10_Khachhang&action=EditView&record='.$row['id']);
  die();
} 
  

[davidboris]

Hi,

It wont work for new records, as it is not saved into db yet.

[tamhd_vn88]

hi alex,thank you but it don't work for new records.
And how to display alert when same infomation ?
Please help me in sloving this problem

[tamhd_vn88]

Hi,

Why not check your conditions on ajax call before it saves the record?

hi David, can you show for me detail

[Chien_Khmt]

HI Mr Tam !
Follow me, you should add more Validate in this Page

Go to dir include/javascript/sugar_grp1.js

using Validates function and may be create more by your selft

after that using Javascript to add them into your page

[davidboris]

Hi,

You need to customize the save button in edit view. Make an AJAX call to a file which returns true in case the condition satisfied else false(and show an alert). Keep Sugar's check_form too!