public function depositIsPay($id) { $row = self::getDeposit($id); if ($row) { if ($row['added'] == 'true') { return; } $db = JO_Db::getDefaultAdapter(); if (JO_Session::get('user_id')) { $user_data = Model_Users::getUser($row['user_id']); /* razkomentirame, ako iskame da nachislqva pari na referral_id i pri deposit if($user_data['referal_id'] > 0) { $referal = Model_Users::getUser($user_data['referal_id']); $referal_cnt = JO_Registry::forceGet('referal_sum'); $percent = str_replace('%', '', JO_Registry::forceGet('referal_percent')); $sum = $row['deposit'] * ((int) $percent / 100); if($referal_cnt > 0) { $cnt = Model_Users::getTotalReferals($user_data['user_id'], $user_data['referal_id']); if(($cnt + 1) >= $referal_cnt) $user_data['referal_id'] = 0; } $db->update(Model_Users::getPrefixDB().'users', array( 'earning' => new JO_Db_Expr('earning + ' . $sum), 'total' => new JO_Db_Expr('total + ' . $sum) ), array('user_id = ?' => (int)$referal['user_id'])); $db->insert(Model_Users::getPrefixDB().'users_referals_count', array( 'user_id' => (int)$row['user_id'], 'referal_id' => (int)$referal['user_id'], 'datetime' => new JO_Db_Expr('NOW()'), 'order_type' => 'deposit', 'referal_sum' => (float) $sum )); } */ $db->update(Model_Users::getPrefixDB() . 'users', array('deposit' => new JO_Db_Expr('deposit + ' . $row['deposit']), 'total' => new JO_Db_Expr('total + ' . $row['deposit'])), array('user_id = ?' => (int) $row['user_id'])); $db->update(Model_Users::getPrefixDB() . 'deposit', array('added' => 'true'), array('id = ?' => (int) $id)); if ($user_data) { $groups = unserialize($user_data['groups']); if (is_array($groups) && count($groups) > 0) { $query_group = $db->select()->from(Model_Users::getPrefixDB() . 'user_groups')->where("ug_id IN (?)", new JO_Db_Expr(implode(',', array_keys($groups)))); $fetch_all = $db->fetchAll($query_group); $user_data['access'] = array(); if ($fetch_all) { foreach ($fetch_all as $row) { $modules = unserialize($row['rights']); if (is_array($modules)) { foreach ($modules as $module => $ison) { $user_data['access'][$module] = $module; } } } } } } if ($user_data) { if (isset($user_data['access']) && count($user_data['access'])) { $user_data['is_admin'] = true; } JO_Session::set($user_data); } } $translate = JO_Translate::getInstance(); Model_History::add($translate->translate('Deposit from') . ' ' . WM_Currency::format($row['deposit']), $id, $row['user_id']); } }
public static function deleteBalance($balance_id) { $db = JO_Db::getDefaultAdapter(); $row = self::getBalance($balance_id); if (!$row) { return; } $aff = $db->delete('deposit', array('id = ?' => (int) $balance_id)); if ($aff) { $db->update(Model_Users::getPrefixDB() . 'users', array('deposit' => new JO_Db_Expr('deposit - ' . (int) $row['deposit']), 'total' => new JO_Db_Expr('total - ' . (int) $row['deposit'])), array('user_id = ?' => (int) $row['user_id'])); $translate = JO_Translate::getInstance(); Model_History::add($translate->translate('[Delete from admin ' . ($row['paid'] == 'true' ? '"paid"' : '"not paid"') . '] Deposit from') . ' ' . WM_Currency::format($row['deposit']), $balance_id, $row['user_id']); } return $balance_id; }