public function actionIndex() { $labels = Twitter::attributeLabels(); $total = Twitter::find()->count(); $regional = Regional::find()->all(); $result = array(); foreach ($labels as $key => $rows) { $label = strtoupper($rows); $filled = Twitter::find()->where($key . ' IS NOT NULL')->count(); $notfilled = Twitter::find()->where($key . ' IS NULL')->count(); array_push($result, array('labels' => $label, 'count' => $total, 'filled' => $filled, 'notfilled' => $notfilled)); } return $this->render('index', ['data' => $result, 'regional' => $regional]); }
public function actionIndex() { $mregional = new Regional(); $mcustomer = new Customer(); $session = new Session(); $company = $session->get('company'); $facebook = Facebook::find()->asArray()->count(); $twitter = Twitter::find()->asArray()->count(); $blog = Blog::find()->asArray()->count(); $instagram = Instagram::find()->asArray()->count(); $customer = Customer::find()->asArray()->count(); $customer_countall = $mcustomer->find()->limit(7)->count(); $regional = $mregional->find()->limit(7)->all(); $speedo = ""; foreach ($regional as $key => $rows) { $customer_count = $mcustomer->find()->where(['FIELD7' => $rows->FIELD1])->andWhere(['FIELD9' => $company])->limit(7)->count(); $no = $key + 1; $percentage = $customer_count / $customer_countall * 100; $agree = number_format($percentage, 0, '.', '.'); $speedo .= "<div class='wrapp-spedo'>\n <div id='speedo" . $no . "'>\n " . $agree . "\n </div>\n <h4 align='center'>REGIONAL " . $no . "</h4>\n </div>"; } return $this->render('index', ['speedo' => $speedo, 'facebook' => $facebook, 'twitter' => $twitter, 'blog' => $blog, 'instagram' => $instagram, 'customer' => $customer]); }