public function actionDetails($id)
{
$visit = Visits::model()->findByPk($id);
$visit_sql = "SELECT d.solicitor_id,d.user_id,d.visit_id,s.first_name,s.last_name,v.visit_code, CASE WHEN v.status = 1 THEN 'Yes' ELSE 'No' END AS visit_active, v.start_date,v.end_date, SUM( d.amount ) AS amount FROM `user_donation` d LEFT JOIN visits v ON d.visit_id = v.id LEFT JOIN solicitor s ON d.solicitor_id = s.id WHERE d.visit_id = '{$id}' GROUP BY d.visit_id";
$visits = BaseModel::executeSimpleQuery($visit_sql);
// pre($visits,true);
$donation = new Donation('users');
$donation->unsetAttributes();
$payments = new SolicitorCredit('solicitor');
$payments->unsetAttributes();
$this->render('donations', array('visit' => $visit->visit_code, 'visits' => $visits, 'donation' => $donation, 'payments' => $payments));
}
public function actionIndex()
{
$users = new Users('search');
$users->unsetAttributes();
$solicitors = new Solicitor('search');
$solicitors->unsetAttributes();
$donations = new Donation('search');
$donations->unsetAttributes();
$payments = new SolicitorCredit('search');
$payments->unsetAttributes();
$user = Users::model()->count();
$solicitor = Solicitor::model()->count();
$donation = BaseModel::getAll("Donation");
$t_donation = 0;
foreach($donation as $d){
$t_donation = $t_donation + $d->amount;
}
$debit = BaseModel::getAll("SolicitorCredit");
$t_debit = 0;
foreach ($debit as $d) {
$t_debit = $t_debit + $d->amount;
}
$this->render('index',array(
'users'=>$users,
'solicitors'=>$solicitors,
'donations'=>$donations,
'payments'=>$payments,
'user' => $user,
'solicitor' => $solicitor,
't_donation' => $t_donation,
't_debit' => $t_debit
));
}
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
));
}
public function actionDonations($id)
{
$visit_sql = "SELECT d.user_id,d.visit_id,s.first_name,s.last_name,v.visit_code, CASE WHEN v.status = 1 THEN 'Yes' ELSE 'No' END AS visit_active, v.start_date,v.end_date, SUM( d.amount ) AS amount FROM `user_donation` d LEFT JOIN visits v ON d.visit_id = v.id LEFT JOIN solicitor s ON d.solicitor_id = s.id WHERE s.id = '{$id}' GROUP BY d.visit_id ORDER BY d.date_entered DESC";
$visits = BaseModel::executeSimpleQuery($visit_sql);
$c_sql = "SELECT SUM(amount) AS amount FROM solicitor_credit WHERE solicitor_id = '{$id}'";
$c_result = BaseModel::executeSimpleQueryFirstRow($c_sql);
if ($c_result === null) {
$amount = 0;
} else {
$amount = $c_result['amount'];
}
$d_sql = "SELECT SUM(amount) AS amount FROM user_donation WHERE solicitor_id = '{$id}'";
$d_result = BaseModel::executeSimpleQueryFirstRow($d_sql);
if ($d_result === null) {
$damount = 0;
} else {
$damount = $d_result['amount'];
}
$solicitor = Solicitor::model()->findByPk($id);
$donation = new Donation('users');
$donation->unsetAttributes();
$payments = new SolicitorCredit('solicitor');
$payments->unsetAttributes();
$this->render('donations', array('visits' => $visits, 'donation' => $donation, 'solicitor' => $solicitor, 'amount' => $amount, 'damount' => $damount, 'payments' => $payments));
}
/**
* Manages all models.
*/
public function actionManage()
{
$model = new Donation('search');
$users_lists = BaseModel::getAll('Users');
$users = array();
foreach ($users_lists as $user) {
$users[$user->id] = $user->first_name . ' ' . $user->last_name . '(' . $user->username . ')';
}
// $users = CHtml::listData(BaseModel::getAll('Users'),'id','username');
$lists = BaseModel::getAll('Solicitor');
$solicitors = array();
foreach ($lists as $list) {
$solicitors[$list->id] = $list->first_name . ' ' . $list->last_name . '(' . $list->solicitor_code . ')';
}
$visits = CHtml::listData(BaseModel::getAll('Visits'), 'id', 'visit_code');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Donation'])) {
$model->attributes = $_GET['Donation'];
}
$this->render('admin', array('model' => $model, 'users' => $users, 'solicitors' => $solicitors, 'visits' => $visits));
}
