/**
* @author: lmkhang - skype
* @date: 2016-01-15
* DASHBOARD HOME
*/
public function index(Request $request)
{
//set Title for PAGE
$this->_page_title = 'Home';
//get
$gets = $request->all();
$gets = $this->trim_all($gets);
$filter = isset($gets['filter']) ? $gets['filter'] : [];
//unset if dont choose
$filter_temp = $filter;
foreach ($filter_temp as $k => $v) {
if (!$v) {
unset($filter[$k]);
}
}
$filter['del_flg'] = 1;
$filter['status'] = 1;
//Get income-expenditure list
$user_get = new \App\User();
$number_pagination = \App\Config::where(['prefix' => 'site', 'name' => 'pagination', 'del_flg' => 1])->get()[0]['value'];
$user_in_ex = $user_get->getAllPaging($filter, $number_pagination);
//get info payment
$currency = \App\Config::where(['prefix' => 'payment', 'name' => 'currency', 'del_flg' => 1])->get()[0]['value'];
$tax_pay_bank = \App\Config::where(['prefix' => 'payment', 'name' => 'tax_pay_bank', 'del_flg' => 1])->get()[0]['value'];
//get Stats
$home_get = new \App\Home();
$gross_amount = $home_get->getKey(['prefix' => 'stats', 'name' => 'gross_amount', 'del_flg' => 1])->value;
$net_mount = $home_get->getKey(['prefix' => 'stats', 'name' => 'net_mount', 'del_flg' => 1])->value;
$pay_amount = $home_get->getKey(['prefix' => 'stats', 'name' => 'pay_amount', 'del_flg' => 1])->value;
$blocked_mount = $home_get->getKey(['prefix' => 'stats', 'name' => 'blocked_mount', 'del_flg' => 1])->value;
$hold_amount = $home_get->getKey(['prefix' => 'stats', 'name' => 'hold_amount', 'del_flg' => 1])->value;
$paid_amount = $home_get->getKey(['prefix' => 'stats', 'name' => 'paid_amount', 'del_flg' => 1])->value;
$home = ['gross_amount' => $gross_amount, 'net_mount' => $net_mount, 'pay_amount' => $pay_amount, 'blocked_mount' => $blocked_mount, 'hold_amount' => $hold_amount, 'paid_amount' => $paid_amount];
//get user list
$users = $user_get->getAllPaging(['status' => 1, 'del_flg' => 1]);
return view('admin.home.index', ['admin' => $this->_admin, 'name' => $this->getName(), 'page_title' => $this->_page_title, 'active' => $this->_active, 'user_in_ex' => $user_in_ex, 'in_expen_type' => config('constant.in_expen_type'), 'currency' => $currency, 'tax_pay_bank' => $tax_pay_bank, 'home' => $home, 'users' => $users]);
}
/**
* @author: lmkhang - skype
* @date: 2016-05-02
* Update all Amount: Gross, Net, Blocked, Hold
*/
public function update()
{
//Get Amount
$user_stats_get = new \App\UserStats();
#Gross Amount
#Net Amount
$net_amount = $user_stats_get->getAmountAllAccount([], 'total');
#Pay Amount
$pay_amount = $user_stats_get->getPayAmount();
#Blocked Amount
$blocked_amount = $user_stats_get->getAmountAllAccount([], 'loss_total');
#Hold Amount
$hold_amount = $user_stats_get->getHoldAmount();
#Paid Amount
$paid_amount = $user_stats_get->getPaidAmount();
//Update Amount
$home_get = new \App\Home();
#Gross Amount
#Net Amount
$net_amount_get = $home_get->getKey(['prefix' => 'stats', 'name' => 'net_mount', 'del_flg' => 1]);
$net_amount_get->value = $net_amount;
$net_amount_get->save();
#Pay Amount
$pay_amount_get = $home_get->getKey(['prefix' => 'stats', 'name' => 'pay_amount', 'del_flg' => 1]);
$pay_amount_get->value = $pay_amount;
$pay_amount_get->save();
#Blocked Amount
$blocked_amount_get = $home_get->getKey(['prefix' => 'stats', 'name' => 'blocked_mount', 'del_flg' => 1]);
$blocked_amount_get->value = $blocked_amount;
$blocked_amount_get->save();
#Hold Amount
$hold_amount_get = $home_get->getKey(['prefix' => 'stats', 'name' => 'hold_amount', 'del_flg' => 1]);
$hold_amount_get->value = $hold_amount;
$hold_amount_get->save();
#Paid Amount
$paid_amount_get = $home_get->getKey(['prefix' => 'stats', 'name' => 'paid_amount', 'del_flg' => 1]);
$paid_amount_get->value = $paid_amount;
$paid_amount_get->save();
//set Flash Message
$this->setFlash('message', 'Updated successfully!');
return redirect()->back()->with('message', 'Updated successfully!');
}
