public function getAllPaging($where = [], $number_pagination = '')
{
//check month
$month = '';
if (isset($where['month'])) {
$month = $where['month'];
unset($where['month']);
}
$where_temp = $where;
foreach ($where_temp as $k => $v) {
unset($where[$k]);
$where[$this->table . '.' . $k] = $v;
}
$user_in_ex = \App\UserIncomeExpenditure::select($this->table . '.*', 'user.full_name', 'user.first_name', 'user.last_name')->join('user', function ($join) {
$join->on('user.user_id', '=', $this->table . '.user_id');
})->where($where);
if ($month) {
$user_in_ex = $user_in_ex->whereRaw("DATE_FORMAT(`date`, '%m/%Y') = '" . $month . "'");
}
$user_in_ex = $user_in_ex->orderBy($this->table . '.created_at', 'desc');
if ($number_pagination) {
$user_in_ex = $user_in_ex->paginate($number_pagination);
foreach (Input::except('page') as $input => $value) {
$user_in_ex->appends($input, $value);
}
} else {
$user_in_ex = $user_in_ex->get();
}
return $user_in_ex;
}
/**
* @author: lmkhang - skype
* @date: 2016-02-05
* Get all amount of all user >= min pay
*/
public function getPaidAmount()
{
return \App\UserIncomeExpenditure::whereRaw('status = ? AND action = ? AND is_payment = ?', [1, 2, 1])->sum('original_amount');
}