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);
}
