//TOP 10 ESTIMATED SALES $where_clause_top10 = $where_clause . " AND progress < 100"; $leads_sales = crm_get_total_sales_lead($where_clause_top10); if ($read && $enterprise) { $leads_sales = crm_get_user_leads($config['id_user'], $leads_sales); } if ($leads_sales != false) { $leads_sales_content = print_table(crm_print_estimated_sales_leads($leads_sales), true); } else { $leads_sales_content = '<br><div class="pie_frame">' . __('No data to show') . '</div>'; } echo print_container('top_10_sales', __('Top 10 estimated sales'), $leads_sales_content, 'no', true, true, "container_simple_title", "container_simple_div"); //NEW LEADS $leads_creation = crm_get_total_leads_creation($where_clause); if ($read && $enterprise) { $leads_creation = crm_get_user_leads($config['id_user'], $leads_creation); } $leads_creation = crm_get_data_lead_creation_graph($leads_creation); if ($leads_creation !== false) { $area_width = 400; $area_height = 250; if ($clean_output) { $area_width = 240; $area_height = 155; } $leads_creation_content = area_graph($config['flash_charts'], $leads_creation, $area_width, $area_height, "#2179B1", '', '', '', "", "", $config["base_url"], "", '', '', '', $ttl); } else { $leads_creation_content = __('No data to show'); } $leads_creation_content = '<br><div class="pie_frame"><br>' . $leads_creation_content . '</div>'; echo print_container('new_leads', __('New leads'), $leads_creation_content, 'no', true, true, "container_simple_title", "container_simple_div");
$table->class = 'blank'; $table->width = '99%'; $table->data = array(); $table->style = array(); $table->valign = array(); $table->colspan = array(); $table->colsapan = array(); $table->valign[0] = "top"; $table->valign[1] = "top"; $table->size = array(); $table->size[0] = "50%"; $table->size[1] = "50%"; //Calculate leads funnel data $leads_funnel = crm_get_total_leads_funnel("WHERE id_campaign = " . $id); if ($read && $enterprise) { $leads_funnel = crm_get_user_leads($config['id_user'], $leads_funnel); } if ($leads_funnel != false) { $data = array(); $lead_progress = lead_progress_array(); $total_leads = count($total_leads_array); foreach ($lead_progress as $key => $name) { $data[$key] = array("title" => $name, "completion" => 0); } //Calculate total number of leads $total_leads = 0; foreach ($leads_funnel as $lf) { if ($lf["progress"] < 100 || $lf["progress"] == 200) { $total_leads = $total_leads + $lf["total_leads"]; } }