/**
* Manages all models.
*/
public function actionAdmin() {
$model = new UserCredit('search');
$model->unsetAttributes(); // clear any default values
if (isset($_GET['UserCredit']))
$model->attributes = $_GET['UserCredit'];
$this->render('admin', array(
'model' => $model,
));
}
public function actionTransaction($id) {
$user_id = $id;
$user = Users::model()->findByPk($id);
$sql = "SELECT id, COALESCE(SUM(credit),0) - COALESCE(SUM(debit),0) AS balance from user_trans where user_id = '" . $id . "'";
$result = BaseModel::executeSimpleQueryFirstRow($sql);
if(!empty($result['balance']))
{
$balance = $result['balance'];
}
else
{
$balance = 0;
}
$c_sql = "SELECT SUM(credit) AS credited FROM user_trans WHERE credit IS NOT NULL AND user_id = '$id'";
$c_result = BaseModel::executeSimpleQueryFirstRow($c_sql);
if(empty($c_result['credited'])){
$credit = 0;
} else {
$credit = $c_result['credited'];
}
$d_sql = "SELECT SUM(debit) AS debited FROM user_trans WHERE debit IS NOT NULL AND user_id = '$id'";
$d_result = BaseModel::executeSimpleQueryFirstRow($d_sql);
if(empty($d_result['debited'])){
$debit = 0;
} else {
$debit = $d_result['debited'];
}
$donations = new Donation('users');
$donations->unsetAttributes();
$payments = new UserCredit('users');
$payments->unsetAttributes();
$logs = new Log('users');
$logs->unsetAttributes();
$this->render('transaction', array(
'user' => $user,
'balance' => $balance,
'credit' => $credit,
'debit' => $debit,
'donations' => $donations,
'payments' => $payments,
'logs' => $logs
));
}
/**
* Manages all models.
*/
public function actionManage()
{
$model = new UserCredit('search');
$model->unsetAttributes();
// clear any default values
$users_lists = BaseModel::getAll('Users');
$users = array();
foreach ($users_lists as $user) {
$users[$user->id] = $user->first_name . ' ' . $user->last_name . '(' . $user->username . ')';
}
if (isset($_GET['UserCredit'])) {
$model->attributes = $_GET['UserCredit'];
}
$this->render('admin', array('model' => $model, 'users' => $users));
}
