Sql query in php put in a function

[maryTooker]

I have a lot of queries with a bit different from each other for example the first query is same to second query except I add a single line of where statement to it.

if($ut=='Admin'){ // if the user is Admin the query should not have a filter
            $queryCustomer = Yii::app()->db->createCommand()
                ->select('cust.mobile_number as customer,sum(trans.price) as sales,trans.datetime')
                 ->from('customers cust')
                ->join('transactions trans', 'cust.id=trans.customer_id')
                ->where('transaction_type_id=:id', array(':id'=>1))    
                ->group('customer_id')
                ->order('trans.datetime DESC')
                ->queryAll();
                 $per_customer=$this->renderTableCustomer($queryCustomer); 
        } else { // if the user is not Admin the query should have a filter
            $queryCustomer = Yii::app()->db->createCommand()
                ->select('cust.mobile_number as customer,sum(trans.price) as sales,trans.datetime')
                 ->from('customers cust')
                ->join('transactions trans', 'cust.id=trans.customer_id')
                ->where('transaction_type_id=:id', array(':id'=>1))
                ->andWhere('user_id=:userID',array(':userID'=>$filter))        
                ->group('customer_id')
                ->order('trans.datetime DESC')
                ->queryAll();
                 $per_customer=$this->renderTableCustomer($queryCustomer);
        }  
 

Since the query is same, is there a possibility to put it on a function and when I call it I will add the where statement as a parameter?

For example. I put the query to function.

public function actionSample($queryCustomer){
        $queryCustomer = Yii::app()->db->createCommand()
                ->select('cust.mobile_number as customer,sum(trans.price) as sales,trans.datetime')
                 ->from('customers cust')
                ->join('transactions trans', 'cust.id=trans.customer_id')
                ->where('transaction_type_id=:id', array(':id'=>1))    
                ->group('customer_id')
                ->order('trans.datetime DESC')
                ->queryAll();
 
           return $queryCustomer;
 
 
    }

then if the user is not admin I will add this line of code

->andWhere('user_id=:userID',array(':userID'=>$filter))

This is the code what I've done so far.

  if($ut=='Admin'){ // if the user is Admin the query should not have a filter
$results=$this->actionSample($queryCustomer);
$per_day="$this->renderTable($results);
else{
$addWhere="->andWhere('user_id=:userID',array(':userID'=>$filter))";
$results=$this->actionSample($queryCustomer,$addWhere);
$per_day="$this->renderTable($results);
}

The else code doesn't work. What is my mistake? By the way I am using Yii framework. please help! THanks in advance