Teach you how to implement a sales funnel-PHP开发-php.cn

Teach you how to implement a sales funnel

大家讲道理

Release： 2016-11-12 14:36:34

Original

3113 people have browsed it

Foreword
A relatively complete CRM, a sales funnel is essential. It can intuitively and graphically point out the proportional relationship, or the conversion rate, of a company's customer resources from the potential customer stage to the intended customer stage, the negotiation stage and the transaction stage. This information is extremely important for any seller. The traditional method of calculating statistics using paper and pen is time-consuming, labor-intensive, and unintuitive. The emergence of sales funnel is to solve such a problem. So, how to implement a sales funnel? This should be an issue that everyone is more concerned about. Let me explain it one by one.

Demand analysis
Implement sales funnel chart through Highcharts plug-in. (This is a plug-in for Yii2. You can download and install it by yourself. I will attach the download address at the end of the article)

Renderings
Teach you how to implement a sales funnel
Implementation ideas
I checked the information online and did not find any article that directly explains it. The PHP usage of sales funnels all refers to JS usage. There is no reference to the mother parent, so you can only work hard on your own. With an idea, I converted the array format of JS usage found by Baidu into PHP language, and it was successful. Although the plug-ins have different languages, their usage is still the same haha.

Code analysis
1. Reference format of plug-in requirement array.

$funnel=[&#39;0&#39;=>[
     &#39;name&#39;=> &#39;Unique users&#39;,
         &#39;data&#39;=> [
            [&#39;Website visits&#39;,   15654],
            [&#39;Downloads&#39;,       4064],
            [&#39;Requested price list&#39;, 1987],
            [&#39;Invoice sent&#39;,    976],
            [&#39;Finalized&#39;,    846]
        ]
      ]
  ];

Copy after login

2. Arrange the array according to the array format required by the plug-in.

    public function actionIndex()
    {  
       $company_id=isset(Yii::$app->user->identity->attributes[&#39;company_id&#39;])?Yii::$app->user->identity->attributes[&#39;company_id&#39;]:"-1";
       $company=Company::getAllN($company_id);
       $funnel=[];
       $_time=$this->currentMonth();  
       //调用销售漏斗方法
       $funnel=$this->actionCountMoney($_time[&#39;begin_time&#39;],$_time[&#39;end_time&#39;]);       
        return $this->render(&#39;index&#39;, [
            &#39;funnel&#39;=>$funnel,
            &#39;company&#39;=>$company,
        ]);
    }

Copy after login

 /*
    *销售漏斗
    *按公司按销售阶段统计线索的销售金额
   */
    public function actionCountMoney($begin_time,$end_time)
    {   
      $company_id=isset(Yii::$app->user->identity->attributes[&#39;company_id&#39;])?Yii::$app->user->identity->attributes[&#39;company_id&#39;]:"-1";
      $uids=UserService::getCUser($company_id);
      $query = new Query();
      $query->select([
            &#39;sell_status.status as status&#39;,
            &#39;sum(`money`) as count_money&#39;
        ])
            ->from(&#39;t_chance&#39;)
            ->groupBy([
            &#39;status&#39;
        ])
            ->join(&#39;left join&#39;,&#39;sell_status&#39;,&#39;t_chance.status = sell_status.id&#39;)
            ->orderBy(&#39;status&#39;);
      //匹配公司所有员工
      $query->andWhere([&#39;in&#39;,&#39;owner_id&#39;,$uids]);    
      //按本月、本季度、本年查找 
      $query->andWhere([&#39;between&#39;,&#39;end_date&#39;,strtotime($begin_time),strtotime($end_time)]);          
      $data=$query->all(); 
      //销售漏斗的主要数组格式部分（重点）
      $_data=[];
      if(!empty($data)){
        foreach ($data as $k => $val) { 
          $data1[0]=$val[&#39;status&#39;];
          if(empty($val[&#39;status&#39;])){
             $data1[0]=Yii::t(&#39;yii&#39;,&#39;Not status&#39;);
          }
          $data1[1]=(int)$val[&#39;count_money&#39;];//数字部分必须转为整型（int）才行
          $_data[]=$data1;
        }
      }else{
        $_data[]=[Yii::t(&#39;yii&#39;,&#39;Not status&#39;),0]; 
      } 
     
      $data2[&#39;name&#39;]=Yii::t(&#39;yii&#39;,&#39;Sales amount&#39;);
      $data2[&#39;data&#39;]=$_data;  
      $_data2[0]=$data2;
      return $_data2;
    }

Copy after login

3. View call.

<?php 
use yii\helpers\Html;
use hr\assets\AppAsset;
use miloschuman\highcharts\Highcharts; 
use yii\web\JsExpression;
?>

Copy after login

 <?php 
    //这部分参设置的数组格式就是我前面说的仿造Js格式来的。
    echo Highcharts::widget([
           &#39;id&#39;=>&#39;funnel_highcharts&#39;, //定义一个唯一的id
           &#39;scripts&#39; => [
           &#39;modules/funnel&#39;,
           &#39;themes/funnel.src&#39;,
           ],
           &#39;options&#39;=>[
                &#39;chart&#39;=>[
                      &#39;type&#39;=> &#39;funnel&#39;,
                      &#39;height&#39;=>300,  //设置图表的高度
                      &#39;marginRight&#39;=>100 
                ],
                &#39;title&#39;=> [
                      &#39;text&#39;=>Yii::t(&#39;yii&#39;,&#39;Funnel chart of sales amount in different sales stages&#39;),
                      &#39;x&#39;=>-50
                ],
                &#39;plotOptions&#39;=>[
                      &#39;series&#39;=> [
                            &#39;dataLabels&#39;=> [
                                    &#39;enabled&#39;=>true,
                                    &#39;format&#39;=>&#39;<b>{point.name}</b>: {point.y:,.0f}&#39;,
                                    &#39;color&#39;=> &#39;(Highcharts.theme && Highcharts.theme.contrastTextColor) || black&#39;,
                                    &#39;color&#39; => new JsExpression(&#39;(Highcharts.theme && Highcharts.theme.contrastTextColor) || "black"&#39;),
                                    &#39;softConnector&#39;=> true
                                                                    
                             ],
                           &#39;neckWidth&#39;=>&#39;15%&#39;,
                           &#39;neckHeight&#39;=>&#39;12.5%&#39;
                    ],
                   &#39;funnel&#39;=>[
                           &#39;height&#39;=>250,  //设置漏斗的高度
                           &#39;width&#39; => 200
                    ],
                ],
                &#39;legend&#39;=>[
                    &#39;enabled&#39;=>false
                 ],
                &#39;series&#39;=> $funnel,
        ]
 ]);
?>

Copy after login

Notes
1. Define a unique ID for the plug-in to avoid conflicts caused by using the same plug-in multiple times on a page.

2. Arrange the array according to the array format required by the plug-in. The format must be consistent, and the numeric part must be converted to an integer (int).