$where_clause .= sprintf(' AND id_company = %d', $id_company);
}
$search_params = "&search_text={$search_text}&id_company={$id_company}";
$table->width = '99%';
$table->class = 'search-table';
$table->style = array();
$table->style[0] = 'font-weight: bold;';
$table->data = array();
$table->data[0][0] = print_input_text("search_text", $search_text, "", 15, 100, true, __('Search'));
$params = array();
$params['input_id'] = 'id_company';
$params['input_name'] = 'id_company';
$params['input_value'] = $id_company;
$params['title'] = __('Company');
$params['return'] = true;
$table->data[0][1] = print_company_autocomplete_input($params);
$table->data[0][2] = print_submit_button(__('Search'), "search_btn", false, 'class="sub search"', true);
// Delete new lines from the string
$where_clause = str_replace(array("\r", "\n"), '', $where_clause);
$table->data[0][3] = print_button(__('Export to CSV'), '', false, 'window.open(\'include/export_csv.php?export_csv_contacts=1&where_clause=' . str_replace("'", "\\'", $where_clause) . '\')', 'class="sub csv"', true);
echo '<form id="contact_search_form" method="post">';
print_table($table);
echo '</form>';
$contacts = crm_get_all_contacts($where_clause);
$contacts = print_array_pagination($contacts, "index.php?sec=customers&sec2=operation/contacts/contact_detail¶ms={$search_params}", $offset);
if ($contacts !== false) {
unset($table);
$table->width = "99%";
$table->class = "listing";
$table->data = array();
$table->size = array();
//~ $table_advanced->class = 'search-table';
//~ $table_advanced->style = array ();
//~ $table_advanced->style[0] = 'font-weight: bold;';
//~ $table_advanced->data = array ();
//~ $table_advanced->width = "99%";
//~ $table_advanced->colspan = array();
//~ $table_advanced->colspan[1][1] = 2;
$table_advanced = '<tr>';
$params = array();
$params['input_id'] = 'id_company_search';
$params['input_name'] = 'id_company_search';
$params['input_value'] = $id_company;
$params['title'] = __('Managed by');
$params['return'] = true;
$table_advanced .= '<td>';
$table_advanced .= print_company_autocomplete_input($params);
$table_advanced .= '</td><td>';
$table_advanced .= combo_kb_products ($id_category, true, 'Product type', true);
$table_advanced .= '</td>';
$table_advanced .= "<td rowspan=2 valign=top>".get_last_date_control ($last_date, 'last_date_search', __('Date'), $start_date, 'start_date_search', __('Start date'), $end_date, 'end_date_search', __('End date'));
$table_advanced .= '</td>';
$table_advanced .= '<tr><td>';
$progress_values = lead_progress_array ();
$table_advanced .= print_select ($progress_values, 'progress_search', $progress, '', __('Any'), 0, true, 0, false, __('Lead progress') );
$table_advanced .= '</td><td>';
$table_advanced .= print_select_from_sql ('SELECT id_language, name FROM tlanguage ORDER BY name',
'id_language', $id_language, '', __('Any'), '', true, false, false, __('Language'));
$table_advanced .= '<tr>';
$table->data['advanced'][2] = print_container('lead_search_advanced', __('Advanced search'), $table_advanced, 'closed', true, false,'','no_border',3);
$table->colspan['advanced'][2] = 4;
?>
<td class="datos" colspan=2><input type="text" name="telefono" value="<?php
echo $telefono;
?>
">
<tr><td class="datos"><?php
echo __('Company');
?>
<td class="datos" colspan=2>
<?php
$params = array();
$params['input_id'] = 'id_company';
$params['input_name'] = 'id_company';
$params['input_value'] = $id_company;
print_company_autocomplete_input($params);
//print_select (get_companies (), 'id_company', $id_company, '', __('None'), 0, false);
?>
<tr><td class="datos"><?php
echo __('Location');
?>
<td class="datos" colspan=2><input type="text" name="location" value="<?php
echo $location;
?>
">
<tr><td class="datos2"><?php
echo __('Global profile');
?>
$table->data['tags'][0] = print_label(__('Tags'), '', 'select', true);
$table->data['tags'][0] .= html_render_tags_editor($tag_editor_props, true);
$table_advanced->class = 'search-table';
$table_advanced->style = array();
$table_advanced->style[0] = 'font-weight: bold;';
$table_advanced->data = array();
$table_advanced->width = "99%";
$table_advanced->colspan = array();
$table_advanced->colspan[1][1] = 2;
$params = array();
$params['input_id'] = 'id_company_search';
$params['input_name'] = 'id_company_search';
$params['input_value'] = $id_company;
$params['title'] = __('Managed by');
$params['return'] = true;
$table_advanced->data[0][0] = print_company_autocomplete_input($params);
$table_advanced->data[0][1] = combo_kb_products($id_category, true, 'Product type', true);
$table_advanced->data[0][2] = print_select_from_sql('SELECT id_language, name FROM tlanguage ORDER BY name', 'id_language', $id_language, '', __('Any'), '', true, false, false, __('Language'));
$progress_values = lead_progress_array();
$table_advanced->data[1][0] = print_select($progress_values, 'progress_search', $progress, '', __('Any'), 0, true, 0, false, __('Lead progress'));
$table_advanced->data[1][1] = get_last_date_control($last_date, 'last_date_search', __('Date'), $start_date, 'start_date_search', __('Start date'), $end_date, 'end_date_search', __('End date'));
$table->data['advanced'][2] = print_container('lead_search_advanced', __('Advanced search'), print_table($table_advanced, true), 'closed', true, false);
$table->colspan['advanced'][2] = 4;
// Delete new lines from the string
$where_clause = str_replace(array("\r", "\n"), '', $where_clause);
$table->data[3][0] = print_button(__('Export to CSV'), '', false, 'window.open(\'include/export_csv.php?export_csv_leads=1&where_clause=' . str_replace('"', "\\'", $where_clause) . '\')', 'class="sub csv" style="float:right;"', true);
$table->data[3][0] .= print_submit_button(__('Search'), "search_btn", false, 'class="sub search" style="float:right;"', true);
$table->align[3] = "right";
$table->align[3][0] = "right";
$table->colspan[3][0] = "3";
$table->size[3][0] = "100%";
