096 
097     public function getActiveRecipientCount() {
098         $sql = "SELECT COUNT(*) FROM {{recipient_group_connector}} AS t1 LEFT JOIN  {{recipient}} AS t2 ON t2.idrecipient = t1.recipient_idrecipient WHERE t1.group_idgroup=".$this->idgroup." AND t2.status=0";
099         $rows = self::model()->dbConnection->createCommand($sql)->queryScalar();
100         return $rows;
101     }
102 
103     // find recipients count on period
104     public function Stat1($start_date, $end_date, $status) {
105         $sql = "SELECT COUNT(*) FROM {{recipient_group_connector}} AS t1 LEFT JOIN  {{recipient}} AS t2 ON t2.idrecipient = t1.recipient_idrecipient WHERE t1.group_idgroup=".$this->idgroup." AND t2.status=:status AND registered>=:start_date AND registered<:end_date";
106         $command = self::model()->dbConnection->createCommand($sql);
107         $command = $command->bindParam(":status", $status);
108         $command = $command->bindParam(":start_date", date('Y-m-d', $start_date));
109         $command = $command->bindParam(":end_date", date('Y-m-d', $end_date));
110         return $command->queryScalar();
111     }
112 
113     // count letters
114     public function Stat2($start_date, $end_date) {
115 116         $sql = "SELECT SUM(t1.amountrecipients) FROM {{sendjob}} AS t1 LEFT JOIN {{sendjob_group_connector}} AS t2 ON t2.sendjob_idsendjob = t1.idsendjob WHERE (t1.type=0 OR t1.type=2) AND (start>=:start_date AND start<=:end_date) AND t2.group_idgroup=:group_id";
117         $command = self::model()->dbConnection->createCommand($sql);
118         $command = $command->bindParam(":group_id", $this->primarykey);
119         $command = $command->bindParam(":start_date", date('Y-m-d', $start_date));
120         $command = $command->bindParam(":end_date", date('Y-m-d', $end_date));