public function fix_loan_breach()
{
$stat = new \Loan\Model\StatModel();
for ($i = 4; $i < date('m'); $i++) {
$i = str_pad($i, 2, '0', STR_PAD_LEFT);
$stat->updateBreach('2015-' . $i);
}
die('done');
}
protected function _report_breach($where, $where_order)
{
$orderModel = new \Loan\Model\OrderModel();
$data = [];
$statModel = new \Loan\Model\StatModel();
$statModel->updateBreach();
$where = ['type' => ['in', [$statModel::TYPE_LOAN_MONEY_UNREPAY, $statModel::TYPE_LOAN_MONEY_BREACH, $statModel::TYPE_LOAN_MONEY_BREACH_REPAY, $statModel::TYPE_LOAN_MONEY_BREACH_UNREPAY]]];
list($city, $is_city_id) = $this->_initRegion();
if ($city > 0) {
$where['university_id'] = ['exp', ' in (select university_id from zj_university_campus where ' . ($is_city_id ? 'city_id' : 'province_id') . '=' . $city . ')'];
}
for ($month = '2015-04-01'; $month < date('Y-m-01');) {
$where['target_date'] = $month;
$data[substr($month, 0, -3)] = $statModel->where($where)->group('type')->getField('type, sum(number)');
$month = date('Y-m-d', strtotime('+1 month', strtotime($month)));
}
$where['target_date'] = date('Y-m-01');
$data['当前'] = $statModel->where($where)->group('type')->getField('type, sum(number)');
foreach ($data as &$row) {
for ($i = 7; $i <= 10; $i++) {
$row[$i] = number_format(isset($row[$i]) ? $row[$i] / 10000 : 0, 2);
}
}
$this->assign('data', $data);
}
