I am using an accounting Php software that it has a customer page that you can save name of your customers ... and in this page you can search name of customers... but I need to change it to search in all fields of it like addresses , emails , phones ... I am new at php and if you can help me please write me.
this is the whole code , and it is save with .tpl file.
case 'list':
Event::trigger('contacts/list/');
$ui->assign('_st', $_L['Contacts'].'<span class="pull-right"><a href="'.U.'contacts/set_view_mode/card/'.'"><i class="fa fa-th"></i></a> <a href="'.U.'contacts/set_view_mode/tbl/'.'"><i class="fa fa-align-justify"></i></a></span>');
$name = _post('name');
//find all tags
$t = ORM::for_table('sys_tags')->where('type','contacts')->find_many();
$ui->assign('t',$t);
if($name != ''){
$paginator = Paginator::bootstrap('crm_accounts','account','%'.$name.'%');
$d = ORM::for_table('crm_accounts')->where_like('account','%'.$name.'%')->offset($paginator['startpoint'])->limit($paginator['limit'])->order_by_desc('id')->find_many();
}
elseif(isset($routes[2]) AND ($routes[2]) != '' AND (!is_numeric($routes[2]))){
$tags = $routes[2];
$paginator['contents'] = '';
$d = ORM::for_table('crm_accounts')->where_like('tags','%'.$tags.'%')->order_by_desc('id')->find_many();
}
else{
$paginator = Paginator::bootstrap('crm_accounts');
$d = ORM::for_table('crm_accounts')->offset($paginator['startpoint'])->limit($paginator['limit'])->order_by_desc('id')->find_many();
}
$ui->assign('d',$d);
$ui->assign('paginator',$paginator);
$ui->assign('xfooter', '
<script type="text/javascript" src="' . $_theme . '/lib/list-contacts.js"></script>
');
$ui->assign('jsvar', '
_L[\'are_you_sure\'] = \''.$_L['are_you_sure'].'\';
');
$ui->display('list-contacts.tpl');
break;
and this is when I change it works :
if($name != ''){
$paginator = Paginator::bootstrap('crm_accounts','account','%'.$name.'%');
$d = ORM::for_table('crm_accounts')->where_like('account','%'.$name.'%')->offset($paginator['startpoint'])->limit($paginator['limit'])->order_by_desc('id')->find_many();
}
You see in table "crm_accounts" it has Columns that names with : " accounts " "email " "phone" ....
please tell me to how add more search option with this code
Aucun commentaire:
Enregistrer un commentaire