$table->data[1][2] = print_input_text('search_date_end', $search_date_end, '', 15, 20, true, __('Date to')); $table->data[1][3] = print_input_text('search_min_billing', $search_min_billing, '', 15, 20, true, __('Min. billing')); $buttons = 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); $buttons .= print_button(__('Export to CSV'), '', false, 'window.open(\'' . 'include/export_csv.php?export_csv_companies=1&where_clause=' . str_replace('"', "\\'", $where_clause) . '&date=' . $date . '\')', 'class="sub csv"', true); $table->data[2][0] = $buttons; $table->colspan[2][0] = 4; echo '<form method="post" id="company_stats_form" action="index.php?sec=customers&sec2=operation/companies/company_detail">'; print_table($table); // Input hidden for ORDER print_input_hidden('order_by_activity', $order_by_activity); print_input_hidden('order_by_company', $order_by_company); print_input_hidden('order_by_billing', $order_by_billing); echo '</form>'; $companies = crm_get_companies_list($where_clause, $date, $order_by, false, $having); $companies = print_array_pagination($companies, "index.php?sec=customers&sec2=operation/companies/company_detail{$search_params}", $offset); if ($companies !== false) { $table->width = "99%"; $table->class = "listing"; $table->data = array(); $table->style = array(); $table->colspan = array(); $table->head[0] = __('ID'); $table->head[1] = __('Company') . $company_order_image; $table->head[2] = __('Role'); $table->head[3] = __('Contracts'); $table->head[4] = __('Leads'); $table->head[5] = __('Manager'); $table->head[6] = __('Country'); $table->head[7] = __('Last activity') . $activity_order_image;
$where_clause = get_parameter('where_clause'); $rows = crm_get_all_contacts(clean_output($where_clause)); $filename = clean_output('contacts_export') . '-' . date("YmdHi"); if ($rows === false) { return; } } if ($export_csv_companies) { $read = check_crm_acl('company', 'cr'); if (!$read) { exit; } $where_clause = get_parameter('where_clause'); $date = get_parameter('date'); $filename = clean_output('company_export') . '-' . date("YmdHi"); $rows = crm_get_companies_list(clean_output($where_clause), $date); if ($rows === false) { return; } } if ($export_csv_leads) { $read = check_crm_acl('company', 'cr'); if (!$read) { exit; } $where_clause = get_parameter('where_clause'); $filename = clean_output('lead_export') . '-' . date("YmdHi"); $rows = crm_get_all_leads(clean_output($where_clause)); if ($rows === false) { return; }
require_once 'include/functions_db.php'; require_once 'include/functions_crm.php'; $id_user = (string) get_parameter('id_user', $config['id_user']); $string = (string) get_parameter('term'); // term is what autocomplete plugin gives $type = (string) get_parameter('type'); $filter = (string) get_parameter('filter'); // complements the main filter if ($filter) { $filter = safe_output($filter); } $where_clause = sprintf(' AND (tcompany.id = %d OR tcompany.name LIKE "%%%s%%" OR tcompany.country LIKE "%%%s%%" OR tcompany.manager LIKE "%%%s%%") AND tcompany.manager = "%s"', $string, $string, $string, $string, $id_user); $companies = crm_get_companies_list($where_clause . $filter, false, "ORDER BY name", true); if (!$companies) { return; } $result = array(); foreach ($companies as $id => $name) { switch ($type) { case 'invoice': if (check_crm_acl('invoice', '', $id_user, $id)) { array_push($result, array("label" => safe_output($name), "value" => $id)); } break; default: array_push($result, array("label" => safe_output($name), "value" => $id)); break; }
//$where_clause = "WHERE 1=1 AND id_company " .get_filter_by_company_accessibility($config["id_user"]); $where_clause = "WHERE 1=1"; if ($search_text != "") { $where_clause .= " AND (fullname LIKE '%{$search_text}%' OR email LIKE '%{$search_text}%'\n\t\t\t\t\tOR phone LIKE '%{$search_text}%' OR mobile LIKE '%{$search_text}%') "; } if ($id_company) { $where_clause .= sprintf(' AND id_company = %d', $id_company); } $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')); $companies = crm_get_companies_list("", false, "", true); $table->data[0][1] = print_select($companies, 'id_company', $id_company, '', 'All', 0, true, false, false, __('Company')); $table->data[0][2] = print_submit_button(__('Search'), "search_btn", false, 'class="sub search"', true); echo '<form id="contact_search_form" method="post">'; print_table($table); echo '</form>'; $contacts = crm_get_all_contacts($where_clause); if ($read && $enterprise) { $contacts = crm_get_user_contacts($config['id_user'], $contacts); } $contacts = print_array_pagination($contacts, "index.php?sec=customers&sec2=operation/contacts/contact_detail¶ms={$params}", $offset); if ($contacts !== false) { unset($table); $table->width = "99%"; $table->class = "listing"; $table->data = array();
$data[3] = $contract["date_end"]; array_push ($table->data, $data); } print_table ($table); } } // Companies if ( check_crm_acl('company', 'cr') && $show_customers != MENU_HIDDEN ){ $where_clause = " AND (tcompany.name LIKE '%".$search_string."%' OR tcompany.id IN (SELECT id_company FROM tcompany_activity WHERE description LIKE '%$search_string%'))"; $companies = crm_get_companies_list($where_clause, false, "ORDER BY name"); if ($companies) { echo "<h3>"; echo __("Companies"); echo "</h3>"; $table = new StdClass(); $table->width = '100%'; $table->class = 'listing'; $table->data = array (); $table->size = array (); $table->style = array (); $table->head = array(); $table->head[0] = __('Company');
$where_clause .= sprintf(' AND manager = "%s" ', $search_manager); } if ($search_parent != 0) { $where_clause .= sprintf(' AND id_parent = %d ', $search_parent); } if ($search_date_begin != "") { $where_clause .= " AND `date` >= {$search_date_begin}"; $date = true; } if ($search_date_end != "") { $where_clause .= " AND `date` <= {$search_date_end}"; $date = true; } } $params = "&search_manager={$search_manager}&search_text={$search_text}&search_role={$search_role}&search_country={$search_country}&search_parent={$search_parent}&search_date_begin={$search_date_begin}&search_date_end={$search_date_end}"; $companies = crm_get_companies_list($where_clause, $date); if ($companies !== false) { $table_list->width = "98%"; $table_list->class = "listing"; $table_list->data = array(); $table_list->style = array(); $table_list->colspan = array(); $table_list->head[0] = __('Company'); $table_list->head[1] = __('Role'); $table_list->head[2] = __('Estimated sale'); $table_list->head[3] = __('Manager'); $table_list->head[4] = __('Country'); $table_list->head[5] = __('Last activity'); $table_list->head[6] = __('Delete'); foreach ($companies as $company) { $data = array();