public function investRecord($borrow_id = 0) { isset($_GET['borrow_id']) && ($borrow_id = intval($_GET['borrow_id'])); $Page = D('Page'); import("ORG.Util.Page"); $count = M("borrow_investor")->where('borrow_id=' . $borrow_id)->count('id'); $Page = new \Org\Util\Page($count, 10); $show = $Page->ajax_show(); $this->assign('page', $show); if ($_GET['borrow_id']) { $list = M("borrow_investor as b")->join(C(DB_PREFIX) . "members as m on b.investor_uid = m.id")->join(C(DB_PREFIX) . "borrow_info as i on b.borrow_id = i.id")->field('i.borrow_interest_rate, i.repayment_type, b.investor_capital, b.add_time, b.is_auto, m.user_name')->where('b.borrow_id=' . $borrow_id)->order('b.id')->limit($Page->firstRow . ',' . $Page->listRows)->select(); /*foreach($list as $k=>$v){ $relult=$k%2; if(!$relult){ $string .= "<tr style='background-color: rgb(255, 255, 255);' class='borrowlist3'> <td width='148' class='txtC'>".hidecard($v['user_name'],5)."</td> <td width='148' class='txtC'>"; }else{ $string .= "<tr style='background-color: rgb(236, 249, 255);' class='borrowlist5'> <td width='148' class='txtC'>".hidecard($v['user_name'],5)."</td> <td width='148' class='txtC'>"; } $string .= $v['is_auto']?'自动':'手动'; $string .= "</td> <td width='128' class='txtRight pr30'>".Fmoney($v['investor_capital'])."元</td> <td width='198' class='txtC'>".date("Y-m-d H:i",$v['add_time'])."</td> <td></td></tr>"; }*/ foreach ($list as $k => $v) { echo '<div class="c_jilu">'; echo '<div class="c_tbjl01">' . hidecard($v['user_name'], 4) . '</div>'; echo '<div class="c_tbjl02">' . $v['borrow_interest_rate'] . '%</div>'; echo '<div class="c_tbjl03">' . Fmoney($v['investor_capital']) . '</div>'; echo '<div class="c_tbjl04">' . date("Y-m-d", $v['add_time']) . ' <span>' . date("H:i", $v['add_time']) . '</span></div>'; echo '<div class="c_tbjl05">'; echo $v['is_auto'] ? '自动' : '手动'; echo '</div>'; echo '<div class="c_tbjl06"><img src="/Style/H/images/images/wancheng2.png" width="21" height="21" /></div>'; echo '<div class="clear"></div>'; echo '</div>'; } } }