public function handle_request_internal() { $apf = APF::get_instance(); $request = $apf->get_request(); $response = $apf->get_response(); if ($this->get_broker_usertype() != 2) { //普通用户不能进入此页面 $this->redirect_to_login(); } $params = $request->get_parameters(); $broker = self::$BrokerInfo; //套餐经纪人,进入新的账户管理页面 if ($broker['BaseInfo']['PAYTYPE'] == 9999) { $this->redirect('/ajkbroker/combo/account/accountlog'); } $logtype = $params['logtype'] ? $params['logtype'] : ""; if (isset($params['p']) && !empty($params['p'])) { $page = intval($params['p']); } else { $page = 1; } $userId = $broker['BaseInfo']['USERID']; if (empty($params['tt']) && empty($params['ff'])) { $lastDay = Model_Log_AccountBalanceLog::getLastDayByUserId($broker['BaseInfo']['USERID']); $starttime = $lastDay; $endtime = $lastDay; } else { $starttime = date("Ymd", strtotime($params['ff'])); $endtime = date("Ymd", strtotime($params['tt'])); } $AccountAll = 0; $dao = new Dao_Broker_AccountBalanceLog(); //通过 userid 获取账户日志 $UserAccountInfo = $dao->searchAccountBalanceLog($userId, $logtype, $starttime, $endtime, $page, $this->page_num); if (!empty($UserAccountInfo)) { $AccountAll = $UserAccountInfo['counts']; } unset($UserAccountInfo["counts"]); //echo "<pre>";print_r(isset($params['ff']) ? $params['ff'] : date('Y-m-d', strtotime($starttime)));exit; if (empty($UserAccountInfo) && empty($params['tt']) && empty($params['ff'])) { $starttime = date('Y-m-d', strtotime('-29 day')); $endtime = date('Y-m-d'); } $balance = Bll_Service_Payment::balance(Bll_Service_Payment::SITE_ANJUKE, array('userId' => $userId)); $FreezeAccount = $balance['data']['jp']['frozen'] / 100.0 + $balance['data']['hz']['frozen'] / 100.0 + $balance['data']['ajk']['frozen'] / 100.0; //冻结余额 $UserAccount = $balance['data']['balance'] / 100.0; //账户余额 $UserAccountTotal = $FreezeAccount + $UserAccount; //账户总额 = 账户余额 + 冻结余额 $request->set_attribute("AccountLogDownLOadName", sha1($broker['BaseInfo']['USERID'] . '安居客账户日志明细')); $request->set_attribute("UserAccount", $UserAccount); $request->set_attribute("FreezeAccount", $FreezeAccount); $request->set_attribute("UserAccountTotal", $UserAccountTotal); $request->set_attribute("UserAccountInfo", $UserAccountInfo); $request->set_attribute("AccountAll", $AccountAll); $request->set_attribute('params', $params); $request->set_attribute('ff', isset($params['ff']) ? $params['ff'] : date('Y-m-d', strtotime($starttime))); $request->set_attribute('tt', isset($params['tt']) ? $params['tt'] : date('Y-m-d', strtotime($endtime))); $arrPager = $this->getPager($params, $AccountAll); $request->set_attribute('arrPager', $arrPager); return 'Broker_Accountmanagement'; }
/** * @param array $data * @return bool */ public static function insertBalanceLog(array $data) { if (!$data) { return false; } $obj = new Model_Log_AccountBalanceLog(date('m', strtotime($data['createTimeStart']))); foreach ($data as $key => $value) { $obj->{$key} = $value; } $obj->lastUpdate = date('Y-m-d H:i:s'); $obj->save(); return $obj->id; }
/** * 根据用户id查询账户日志总表2个id之间的数据 * * @param $userId 用户id * @param $startId 起始id(包含) * @param $endId 结束id(包含) * @return array * @throws Exception sql或者其他错误 */ public function getDifferentBalanceLog($userId, $startId, $endId) { return Model_Log_AccountBalanceLog::data_access(date('m'))->filter_by_op('userId', '=', $userId)->filter_by_op('id', '>', $startId)->filter_by_op('id', '<=', $endId)->sort('id', 'asc')->find(); }
/** * 获取账户日志 * @param $userid * @param string $logtype * @param string $start_date * @param string $end_date * @param int $page * @param $page_num * @return array */ public function searchAccountBalanceLog($userid, $logtype = '', $start_date = '', $end_date = '', $page = 1, $page_num) { $logModel = new Model_Log_AccountBalanceLog(); return $logModel->searchBalanceLogByUserId($userid, $logtype, $start_date, $end_date, $page, $page_num); }