private function getForm() { $request = $this->getRequest(); $id = $request->getQuery('id'); if ($id) { $info = Model_Bulletin::getBulletin($id); } $this->view->page_num = $this->getRequest()->getRequest('page', 1); if (isset($info)) { $this->view->info = $info; $this->view->info['text'] = html_entity_decode($info['text'], ENT_QUOTES, 'utf-8'); $date = new JO_Date($info['datetime'], 'H:i dd MM yy'); $this->view->info['datetime'] = $date->toString(); } if ($id) { if ($request->getPost('name')) { $this->view->name = $request->getPost('name'); } elseif (isset($info)) { $this->view->name = $info['name']; } else { $this->view->name = ''; } if ($request->getPost('text')) { $this->view->text = $request->getPost('text'); } elseif (isset($info)) { $this->view->text = $info['text']; } else { $this->view->text = ''; } } }
public function balanceAction() { $this->view->page_num = $this->getRequest()->getQuery('page'); $this->view->user_id = $balance_id = $this->getRequest()->getQuery('id'); $request = $this->getRequest(); $url = ''; if ($request->getQuery('sort')) { $url .= '&sort=' . $request->getQuery('sort'); } if ($request->getQuery('order')) { $url .= '&order=' . $request->getQuery('order'); } if ($request->getQuery('page')) { $url .= '&page=' . $request->getQuery('page'); } if ($request->getQuery('filter_id')) { $url .= '&filter_id=' . $request->getQuery('filter_id'); } if ($request->getQuery('filter_username')) { $url .= '&filter_username='******'filter_username'); } if ($request->getQuery('filter_total')) { $url .= '&filter_total=' . $request->getQuery('filter_total'); } if ($request->getQuery('filter_sales')) { $url .= '&filter_sales=' . $request->getQuery('filter_sales'); } if ($request->getQuery('filter_sold')) { $url .= '&filter_sold=' . $request->getQuery('filter_sold'); } if ($request->getQuery('filter_web_profit2')) { $url .= '&filter_web_profit2=' . $request->getQuery('filter_web_profit2'); } if ($request->getQuery('filter_commission')) { $url .= '&filter_commission=' . $request->getQuery('filter_commission'); } if ($request->getQuery('filter_items')) { $url .= '&filter_items=' . $request->getQuery('filter_items'); } if ($request->getQuery('filter_referals')) { $url .= '&filter_referals=' . $request->getQuery('filter_referals'); } if ($request->getQuery('filter_referal_money')) { $url .= '&filter_referal_money=' . $request->getQuery('filter_referal_money'); } if ($request->getQuery('filter_featured_author')) { $url .= '&filter_featured_author=' . $request->getQuery('filter_featured_author'); } if ($request->getQuery('id')) { $url .= '&id=' . $request->getQuery('id'); } $user_info = Model_Users::getUser($balance_id); if (!$user_info) { $this->redirect($this->getRequest()->getBaseUrl() . $this->getRequest()->getModule() . '/users/?' . $url); } $this->view->createBalans = $this->getRequest()->getBaseUrl() . $this->getRequest()->getModule() . '/users/createBalance/?' . $url; $this->view->back_href = $this->getRequest()->getBaseUrl() . $this->getRequest()->getModule() . '/users/?' . $url; $this->view->username = $user_info['username']; if ($this->session->get('successfu_edite')) { $this->view->successfu_edite = true; $this->session->clear('successfu_edite'); } $this->view->balances = array(); $balances = Model_Users::getBalances($balance_id); if ($balances) { foreach ($balances as $balance) { $last_login_datetime = new JO_Date($balance['datetime'], 'dd MM yy'); $balance['datetime'] = $last_login_datetime->toString(); $balance['deposit'] = WM_Currency::format($balance['deposit']); $balance['edit'] = $this->getRequest()->getBaseUrl() . $this->getRequest()->getModule() . '/users/editBalance/?bid=' . $balance['id'] . $url; $this->view->balances[] = $balance; } } }
private function getForm() { $request = $this->getRequest(); $id = $request->getQuery('id'); $info = Model_Users::getWithdraw($id); if (!$info) { $url = ''; if ($this->getRequest()->getQuery('page')) { $url = '?page=' . $this->getRequest()->getQuery('page'); } $this->redirect($this->getRequest()->getBaseUrl() . $this->getRequest()->getModule() . '/gainpayingup/' . $url); } $this->view->page_num = $this->getRequest()->getRequest('page', 1); $info['earning_formated'] = WM_Currency::format($info['earning']); $info['earning'] = WM_Currency::format($info['earning'], false); $date = new JO_Date($info['datetime'], 'dd MM yy'); $info['datetime'] = $date->toString(); $this->view->info = $info; }
public function indexAction() { $request = $this->getRequest(); if ($request->getQuery('from')) { $this->view->from = $request->getQuery('from'); } else { $date = new JO_Date(null, 'yy-mm-01'); $this->view->from = $date->toString(); } if ($request->getQuery('to')) { $this->view->to = $request->getQuery('to'); } else { $date = new JO_Date(null, 'yy-mm-t'); $this->view->to = $date->toString(); } $reportData = Model_Reports::getReport($this->view->from, $this->view->to); $depositData = Model_Reports::getDeposits($this->view->from, $this->view->to); $withdrawData = Model_Reports::getWithdraws($this->view->from, $this->view->to); $data = array(); foreach ($reportData as $date => $v) { $data[$date] = array(); } foreach ($depositData as $date => $v) { $data[$date] = array(); } foreach ($withdrawData as $date => $v) { $data[$date] = array(); } foreach ($data as $k => $v) { if (isset($reportData[$k])) { $data[$k]['total'] = $reportData[$k]['total']; $data[$k]['receive'] = $reportData[$k]['receive']; $data[$k]['referal'] = $reportData[$k]['referal']; $data[$k]['win'] = $reportData[$k]['win']; $data[$k]['total_for'] = WM_Currency::format($reportData[$k]['total']); $data[$k]['receive_for'] = WM_Currency::format($reportData[$k]['receive']); $data[$k]['referal_for'] = WM_Currency::format($reportData[$k]['referal']); $data[$k]['win_for'] = WM_Currency::format($reportData[$k]['win']); } else { $data[$k]['total'] = 0; $data[$k]['receive'] = 0; $data[$k]['referal'] = 0; $data[$k]['win'] = 0; $data[$k]['total_for'] = WM_Currency::format(0); $data[$k]['receive_for'] = WM_Currency::format(0); $data[$k]['referal_for'] = WM_Currency::format(0); $data[$k]['win_for'] = WM_Currency::format(0); } if (isset($depositData[$k])) { $data[$k]['deposit'] = $depositData[$k]['deposit']; $data[$k]['deposit_for'] = WM_Currency::format($depositData[$k]['deposit']); } else { $data[$k]['deposit'] = 0; $data[$k]['deposit_for'] = WM_Currency::format(0); } if (isset($withdrawData[$k])) { $data[$k]['withdraw'] = $withdrawData[$k]['amount']; $data[$k]['withdraw_for'] = WM_Currency::format($withdrawData[$k]['amount']); } else { $data[$k]['withdraw'] = 0; $data[$k]['withdraw_for'] = WM_Currency::format(0); } } $this->view->reports = $data; }
public function indexAction() { $request = $this->getRequest(); $this->view->base_url = $request->getBaseUrl(); #LINKS FOR HEAD PARTS IN BOX $this->view->finance_href = $request->getModule() . '/reports/'; $this->view->sales_href = $request->getModule() . '/orders/'; $this->view->users_href = $request->getModule() . '/users/'; $this->view->approval_href = $request->getModule() . '/queueitems/'; $this->view->queue_href = $request->getModule() . '/queueupdateditems/'; $this->view->contacts_href = $request->getModule() . '/contacts/'; $this->view->gainpayingup_href = $request->getModule() . '/gainpayingup/'; $this->view->tags_href = $request->getModule() . '/tags/?filter_visible=false'; #LOAD ORDERS COUNT $this->view->total = Model_Orders::getSalesStatus(); if ($this->view->total) { $this->view->total['total_f'] = WM_Currency::format($this->view->total['total']); } $ref = Model_Orders::getSalesStatus(" AND `datetime` > '" . date('Y-m') . "-01 00:00:00' ", 'referal'); $sales = Model_Orders::getSalesStatus(" AND `datetime` > '" . date('Y-m') . "-01 00:00:00' "); if ($sales) { if ($ref) { $sales['referal'] = $ref['receive']; } else { $sales['referal'] = 0; } $sales['win'] = floatval($sales['total']) - floatval($sales['receive']) - floatval($sales['referal']); $sales['total_f'] = WM_Currency::format($sales['total']); $sales['receive_f'] = WM_Currency::format($sales['receive']); $sales['referal_f'] = WM_Currency::format($sales['referal']); $sales['win_f'] = WM_Currency::format($sales['win']); } $this->view->sales = $sales; unset($ref); $ref = Model_Orders::getSalesStatus("", 'referal'); $sales = Model_Orders::getSalesStatus(""); if ($sales) { if ($ref) { $sales['referal'] = $ref['receive']; } else { $sales['referal'] = 0; } $sales['win'] = floatval($sales['total']) - floatval($sales['receive']) - floatval($sales['referal']); $sales['total_f'] = WM_Currency::format($sales['total']); $sales['receive_f'] = WM_Currency::format($sales['receive']); $sales['referal_f'] = WM_Currency::format($sales['referal']); $sales['win_f'] = WM_Currency::format($sales['win']); } $this->view->sales2 = $sales; unset($ref); #LOAD USERS COUNT $this->view->users = array(); $this->view->users['month'] = Model_Users::getUsersCount(" `register_datetime` > '" . date('Y-m') . "-01 00:00:00' AND `status` = 'activate' "); $this->view->users['total'] = Model_Users::getUsersCount(" `status` = 'activate' "); $this->view->topAuthors = array(); $topAuthors = Model_Users::getAll(0, 5, " `status` = 'activate' ", "`sales` DESC"); if ($topAuthors) { $percentsClass = new Model_Percents(); foreach ($topAuthors as $user) { $user['deposit'] = WM_Currency::format($user['deposit']); $user['earning'] = WM_Currency::format($user['earning']); $user['total'] = WM_Currency::format($user['total']); $user['sold'] = WM_Currency::format($user['sold']); $user['referal_money'] = WM_Currency::format($user['referal_money']); $comision = $percentsClass->getPercentRow($user['user_id']); $user['commission'] = round($comision['percent']); $user['sum'] = Model_Balance::getTotalUserBalanceByType($user['user_id']); $user['web_profit'] = WM_Currency::format($user['web_profit']); $user['web_profit2'] = WM_Currency::format($user['web_profit2']); $user['has_referral_sum'] = $user['referral_sum']; $user['referral_sum'] = WM_Currency::format($user['referral_sum']); $user['edit_href'] = $request->getModule() . '/users/edite/?id=' . $user['user_id']; $user['balance_href'] = $request->getModule() . '/users/balance/?id=' . $user['user_id']; $this->view->topAuthors[] = $user; } } #LOAD WITHDRAW $this->view->withdraw = array(); $this->view->withdraw['no'] = Model_Deposit::getWithdrawCount(" `paid` = 'false' AND `datetime` > '" . date('Y-m') . "-01 00:00:00' "); if ($this->view->withdraw['no']) { $this->view->withdraw['no']['total_f'] = WM_Currency::format($this->view->withdraw['no']['total']); } $this->view->withdraw['paid'] = Model_Deposit::getWithdrawCount(" `paid` = 'true' AND `paid_datetime` > '" . date('Y-m') . "-01 00:00:00' "); if ($this->view->withdraw['paid']) { $this->view->withdraw['paid']['total_f'] = WM_Currency::format($this->view->withdraw['paid']['total']); } #LOAD THEMES $this->view->items = Model_Items::getItems(array('filter_status' => 'queue', 'start' => 0, 'limit' => 5)); $this->view->updated_items = Model_Items::getItems(array('filter_update' => true, 'start' => 0, 'limit' => 5)); #LOAD LAST REQUEST $this->view->contacts = array(); $contacts = Model_Contacts::getContacts(array('filter_answer_datetime' => '0000-00-00', 'start' => 0, 'limit' => 5)); if ($contacts) { foreach ($contacts as $contact) { $data = new JO_Date($contact['datetime'], 'dd MM yy'); $contact['datetime'] = $data->toString(); $contact['has_response'] = $contact['answer_datetime'] != '0000-00-00 00:00:00'; if ($contact['answer_datetime'] != '0000-00-00 00:00:00') { $data = new JO_Date($contact['answer_datetime'], 'dd MM yy'); $contact['answer_datetime'] = $data->toString(); } else { $contact['answer_datetime'] = ''; } $this->view->contacts[] = $contact; } } #Withdrawals $this->view->withdraws = array(); $withdraws = Model_Users::getWithdraws(array('start' => 0, 'limit' => 5)); if ($withdraws) { foreach ($withdraws as $withdraw) { $withdraw['earning'] = WM_Currency::format($withdraw['earning']); $date = new JO_Date($withdraw['datetime'], 'dd MM yy'); $withdraw['datetime'] = $date->toString(); if ($withdraw['paid'] == 'true') { $date = new JO_Date($withdraw['paid_datetime'], 'dd MM yy'); $withdraw['paid_datetime'] = $date->toString(); } else { $withdraw['paid_datetime'] = ''; } $withdraw['amount'] = WM_Currency::format($withdraw['amount']); $this->view->withdraws[] = $withdraw; } } #TAGS NO ACTIVE $this->view->tags = Model_Tags::getTags(array('filter_visible' => 'false', 'start' => 0, 'limit' => 20)); #DRAW GRAPHCS $referal_sum = Model_Orders::getSalesStatusByDay(" AND `datetime` > '" . date('Y-m') . "-01 00:00:00' ", 'referal'); $sales_sum = Model_Orders::getSalesStatusByDay(" AND `datetime` > '" . date('Y-m') . "-01 00:00:00' "); $referal_money = array(); $sales_money = array(); $user_money = array(); $win_money = array(); $sales_num = array(); $referal_num = array(); $days = array(); // for($i=1; $i<= date('t'); $i++) { // if(isset($referal_sum[date("Y-m-") . sprintf('%02d', $i)])) { // $referal_money[] = number_format($referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'], 2, '.', ''); // } else { // $referal_money[] = 0; // } // if(isset($sales_sum[date("Y-m-") . sprintf('%02d', $i)])) { // $sales_money[] = number_format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['total'], 2, '.', ''); // $user_money[] = number_format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'], 2, '.', ''); // if(isset($referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'])) { // $sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'] = $referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive']; // } // if(!isset($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'])) { // $sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'] = 0; // } // $sales_num[] = $sales_sum[date("Y-m-") . sprintf('%02d', $i)]['num']; // $win_money[] = number_format( floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['total']) - floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['receive']) - floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal']), 2, '.', ''); // } else { // $sales_money[] = 0; // $user_money[] = 0; // $win_money[] = 0; // $sales_num[] = 0; // } // $days[] = $i; // } for ($i = 1; $i <= date('t'); $i++) { if (isset($referal_sum[date("Y-m-") . sprintf('%02d', $i)])) { $referal_money[] = array(WM_Currency::format($referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive']), (double) WM_Currency::format($referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'], '', '', false)); } else { $referal_money[] = array(WM_Currency::format(0), 0); } if (isset($referal_sum[date("Y-m-") . sprintf('%02d', $i)]['num'])) { $referal_num[] = array($i, $referal_sum[date("Y-m-") . sprintf('%02d', $i)]['num']); } else { $referal_num[] = array($i, 0); } if (isset($sales_sum[date("Y-m-") . sprintf('%02d', $i)])) { $sales_money[] = array(WM_Currency::format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['total']), (double) WM_Currency::format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['total'], '', '', false)); $user_money[] = array(WM_Currency::format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['receive']), (double) WM_Currency::format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'], '', '', false)); if (isset($referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'])) { $sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'] = $referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive']; } if (!isset($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'])) { $sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'] = 0; } $sales_num[] = array($i, $sales_sum[date("Y-m-") . sprintf('%02d', $i)]['num']); $win_money[] = array(WM_Currency::format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['total'] - floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['receive']) - floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'])), (double) WM_Currency::format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['total'] - floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['receive']) - floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal']), '', '', false)); } else { $sales_money[] = array(WM_Currency::format(0), 0); $user_money[] = array(WM_Currency::format(0), 0); $win_money[] = array(WM_Currency::format(0), 0); $sales_num[] = array($i, 0); } $days[] = $i; } $new_array = array(); $new_array[] = array('name' => $this->translate('Total'), 'data' => $sales_money); $new_array[] = array('name' => $this->translate('User\'s profit'), 'data' => $user_money); $new_array[] = array('name' => $this->translate('Net total'), 'data' => $win_money); $new_array[] = array('name' => $this->translate('Referent'), 'data' => $referal_money); $new_array2 = array(); $new_array2[] = array('name' => $this->translate('Referent'), 'data' => $referal_num); $new_array2[] = array('name' => $this->translate('Sales'), 'data' => $sales_num); $this->view->finance_array = JO_Json::encode($new_array); $this->view->sales_array = JO_Json::encode($new_array2); $this->view->days = JO_Json::encode($days); $this->view->currency = WM_Currency::getCurrency(); }