public function agreement($pid, $uid)
{
$project = D('ProjectFundView')->where(array('p.id' => $id, 'p.status' => 9))->find();
$leader = M('ProjectLeader')->where(array('project_id' => $pid, 'lead_type' => 9))->find();
if ($leader) {
$leader_name = M('UsersDetail')->where(array('id' => $leader['leader_id']))->find();
if (strstr($leader_name['name'], '公司') || strstr($leader_name['name'], '企业')) {
$leaderinfo = $leader_name['name'];
} else {
$leaderinfo = $leader_name['name'] . '(' . $leader_name['card_id'] . ')';
}
}
if ($project['id'] == 151) {
$rate = floor($invest['fund'] / 5000) * 0.05;
} else {
$rate = round($invest['fund'] / $project['final_valuation'] * 100, 4);
}
$data = array('姓名' => $user['name'], '身份证号' => $user['card_id'], '领投人' => $leaderinfo, '投资金额' => number_format($invest['fund'], 2), '投资占比' => $rate, '公司名称' => $project['company_name'], '大写金额' => cny($invest['fund']), '联系电话' => $user['phone'], '签约日期' => time_format(NOW_TIME, 'Y年m月d日'));
if (!empty($project['agreement'])) {
$detail = M('Agreement')->where(array('key' => $project['agreement']))->find();
} else {
if ($project['id'] == 33 || $project['id'] == 48) {
$detail = M('Agreement')->where(array('key' => 'weituochiguo'))->find();
} else {
$detail = M('Agreement')->where(array('key' => 'judaodaichi'))->find();
}
}
$agreement = $detail['content'];
foreach ($data as $key => $value) {
$detail['content'] = str_replace("[{$key}]", $value, $detail['content']);
}
$agreementInvest = M('AgreementInvest')->where(array('pid' => $pid, 'uid' => $uid))->find();
if (!$agreementInvest) {
$agreementInvest = array('content' => $detail['content'], 'agreement_id' => $detail['id'], 'pid' => $pid, 'uid' => $uid, 'create_time' => NOW_TIME, 'create_id' => $uid, 'update_time' => NOW_TIME, 'update_id' => $uid, 'status' => 1, 'client_ip' => get_client_ip(0));
M('AgreementInvest')->add($agreementInvest);
} else {
if ($agreementInvest['status'] == 0) {
M('AgreementInvest')->save(array('id' => $agreementInvest['id'], 'content' => $detail['content'], 'update_time' => NOW_TIME, 'update_id' => $uid, 'status' => 1, 'client_ip' => get_client_ip(0)));
}
}
}
public function download_xls()
{
$report_type = $this->input->post('report_type');
$date_from = $this->input->post('date_from');
$date_to = $this->input->post('date_to');
if ($report_type != '' && $date_from != '' && $date_to != '') {
$this->load->library('PHPExcel');
$objPHPExcel = new PHPExcel();
$title = "untitled";
switch ($report_type) {
case 'day':
$title = "ERP 日报表 {$date_from} - {$date_to}";
$bills = $this->Mbill->objGetZentsBillsOfDay($date_from, $date_to);
break;
case 'month':
$bills = $this->Mbill->objGetZentsBillsOfMonth($date_from, $date_to);
$date_from = date('Y-m', strtotime($date_from));
$date_to = date('Y-m', strtotime($date_to));
$title = "ERP 月报表 {$date_from} - {$date_to}";
break;
case 'year':
$bills = $this->Mbill->objGetZentsBillsOfYear($date_from, $date_to);
$date_from = date('Y', strtotime($date_from));
$date_to = date('Y', strtotime($date_to));
$title = "ERP 年报表 {$date_from} - {$date_to}";
break;
case 'products':
$bills = $this->Mbill->objGetProductBills($date_from, $date_to);
$title = "ERP 产品报表 {$date_from} - {$date_to}";
break;
case 'users':
$bills = $this->Mbill->objGetUserBills($date_from, $date_to);
$title = "ERP 代理交易统计报表 {$date_from} - {$date_to}";
break;
default:
break;
}
// Set document properties
$objPHPExcel->getProperties()->setCreator("Princelo Lamkimcheung@gmail.com")->setLastModifiedBy("Princelo Lamkimcheung@gmail.com")->setTitle($title)->setSubject($title)->setDescription($title)->setKeywords("Princelo lamkimcheung@gmail.com")->setCategory($report_type);
if ($report_type == 'products') {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $title)->setCellValue('A2', '产品ID')->setCellValue('B2', '产品名称')->setCellValue('C2', '出货量')->setCellValue('D2', '总金额');
foreach ($bills as $k => $v) {
$i = $k + 3;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$i}", $v->product_id)->setCellValue("B{$i}", $v->title)->setCellValue("C{$i}", $v->total_quantity)->setCellValue("D{$i}", $v->amount);
}
} elseif ($report_type == 'users') {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $title)->setCellValue('A2', '代理')->setCellValue('B2', '业绩增量')->setCellValue('C2', '自下级(下下级)收益增量(不含推荐)')->setCellValue('D2', '自下级推荐收益增量')->setCellValue('E2', '总收益增量')->setCellValue('F2', '至推荐人收益')->setCellValue('G2', '至推荐人推荐收益')->setCellValue('H2', '至推荐人总收益')->setCellValue('I2', '至跨界推荐人收益')->setCellValue('J2', '推荐人代理')->setCellValue('K2', '跨界推荐人代理');
foreach ($bills as $k => $v) {
$i = $k + 3;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$i}", $v->name . "(" . $v->username . "/" . $v->id . ")")->setCellValue("B{$i}", cny($v->turnover))->setCellValue("C{$i}", cny($v->normal_return_profit_sub2self))->setCellValue("D{$i}", cny($v->extra_return_profit_sub2self))->setCellValue("E{$i}", '￥' . bcadd(bcadd(money($v->normal_return_profit_sub2self), money($v->extra_return_profit_sub2self), 2), 0, 2))->setCellValue("F{$i}", cny($v->normal_return_profit_self2parent))->setCellValue("G{$i}", cny($v->extra_return_profit_self2parent))->setCellValue("H{$i}", "￥" . bcadd(money($v->normal_return_profit_self2parent), money($v->extra_return_profit_self2parent), 2))->setCellValue("I{$i}", cny($v->normal_return_profit_self2gparent));
if (intval($v->pid) > 0) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("J{$i}", $v->pname . "(" . $v->pusername . "/" . $v->pid . ")");
} else {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("J{$i}", "无推荐人");
}
if (intval($v->gpid) > 0) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("K{$i}", $v->gpname . "(" . $v->gpusername . "/" . $v->gpid . ")");
} else {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("K{$i}", "无跨界推荐人");
}
}
} else {
// Add some data
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $title)->setCellValue('A2', '日期')->setCellValue('B2', '总金额(含运费)')->setCellValue('C2', '产品总金额')->setCellValue('D2', '运费总金额')->setCellValue('E2', '即时收益总量')->setCellValue('F2', '收益总量')->setCellValue('G2', '订单数');
// Miscellaneous glyphs, UTF-8
foreach ($bills as $k => $v) {
$i = $k + 3;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$i}", $v->date)->setCellValue("B{$i}", $v->total_volume)->setCellValue("C{$i}", $v->products_volume)->setCellValue("D{$i}", $v->post_fee)->setCellValue("E{$i}", $v->normal_return_profit_volume)->setCellValue("F{$i}", "￥" . bcadd(money($v->normal_return_profit_volume), 0, 2))->setCellValue("G{$i}", $v->order_quantity);
}
}
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('REPORT');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="' . $title . '.xls"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');
// If you're serving to IE over SSL, then the following may be needed
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
// Date in the past
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
// always modified
header('Cache-Control: cache, must-revalidate');
// HTTP/1.1
header('Pragma: public');
// HTTP/1.0
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;
} else {
exit('This page is expired !');
}
}
?>
</td>
<td><?php
echo $v->profit_potential == '' ? '' : $v->profit_potential . '%';
?>
</td>
<td><?php
echo substr($v->stock_time, 0, 19);
?>
</td>
<!--<td><?php
echo cny($v->return_profit);
?>
</td>
<td><?php
echo cny($v->p_return_invite);
?>
</td>-->
<td><a href="<?php
echo base_url();
?>
order/details_admin/<?php
echo $v->id;
?>
">查看详情</a></td>
<td><?php
if ($v->is_pay != true) {
?>
<a href="javascript:void(0);" onclick="myconfirm(<?php
echo $v->id;
?>
</td>
</tr>
<tr class="odd">
<th>使用代金券</th>
<td>
<span class="info important"><?php
echo cny($v->coupon_volume);
?>
</span>
</td>
</tr>
<tr class="even">
<th>使用现金</th>
<td>
<span class="info important"><?php
echo cny($v->cash_volume);
?>
</span>
</td>
</tr>
<tr class="odd">
<th>付款方式</th>
<td>
<span class="info"><?php
echo $v->pay_method == 'alipay' ? '线上付款' : '线下付款';
?>
</span>
</td>
</tr>
<tr class="even">
<th>付款时间</th>
?>
</td>
<td><?php
echo cny($v->self_turnover);
?>
</td>
<td><?php
echo cny($v->sub_turnover);
?>
</td>
<td><?php
echo cny($v->normal_return_profit_sub2self);
?>
</td>
<td><?php
echo cny($v->extra_return_profit_sub2self);
?>
</td>
<!--<td><?php
//=cny($v->delay_return_profit)
?>
</td>-->
<!--<td>￥<?php
//=bcadd(money($v->normal_return_profit_sub2self), bcadd(money($v->extra_return_profit_sub2self),$v->delay_return_profit,2), 2 )
?>
</td>-->
<!--<td><?php
//=cny($v->normal_return_profit_self2parent);
?>
</td>-->
<!--<td><?php
g
</td>
<td>
<?php
echo $v->additional_weight;
?>
g
</td>
<td>
<?php
echo cny($v->first_pay);
?>
</td>
<td>
<?php
echo cny($v->additional_pay);
?>
</td>
<td><a href="<?php
echo base_url();
?>
post_setting/edit/<?php
echo $v->id;
?>
">编辑</a></td>
<?php
if ($v->province_id != 0) {
?>
<td><a href="<?php
echo base_url();
?>
?>
</td>
<td><?php
echo $v->wechat_id;
?>
</td>
<td><?php
echo $v->qq_no;
?>
</td>
<td><?php
echo cny($v->turnover);
?>
</td>
<td><?php
echo cny($v->profit);
?>
</td>
<td><?php
echo $v->is_valid == true ? '是' : '否';
?>
</td>
<td><a href="<?php
echo base_url();
?>
order/query_sub/<?php
echo $v->id;
?>
">查询他的订单</a></td>
</tr>
<?php
?>
</td>
<td><?php
echo cny($v->products_volume);
?>
</td>
<td><?php
echo cny($v->post_fee);
?>
</td>
<td><?php
echo cny($v->normal_return_profit_volume);
?>
</td>
<td><?php
echo cny($v->invite_return_profit_volume);
?>
</td>
<!--<td><?php
//=cny($v->delay_return_profit_volume);
?>
</td>-->
<td>￥<?php
echo bcadd(bcadd(money($v->normal_return_profit_volume), 0, 2), money($v->invite_return_profit_volume), 2);
?>
</td>
<td><?php
echo $v->order_quantity;
?>
</td>
</tr>
<div class="price_tip">
<h3>
本次交易总额为<span class="red">￥<?php
echo cny(bcadd($pay_amt_without_post_fee, $post_fee, 2));
?>
</span>，<br>
其中产品价格<span class="red">￥<?php
echo cny($pay_amt_without_post_fee);
?>
</span>，<br>
运费共<span class="red">￥<?php
echo cny($post_fee);
?>
</span>,<br>
使用代金券共<span class="red"><?php
echo cny($coupon_volume);
?>
</span>,<br>
还需付款: <span style="color:#f60; font-weight:bold">￥<?php
echo bcsub(bcadd($pay_amt_without_post_fee, $post_fee, 2), money($coupon_volume), 2);
?>
</span>
</h3>
</div>
<form id="pay" action="<?php
echo base_url();
?>
order/pay/<?php
echo $order_id;
?>
" method="post">
$total = bcadd($total, bcmul(money($v->unit_price), $products_quantity[$v->pid], 2), 2);
?>
<tr class="<?php
echo $n % 2 == 0 ? "even" : "odd";
?>
">
<td><?php
echo $v->title;
?>
</td>
<td><?php
echo $products_quantity[$v->pid];
?>
</td>
<td><?php
echo cny($v->unit_price);
?>
</td>
<td>￥<?php
echo bcmul(money($v->unit_price), $products_quantity[$v->pid], 2);
?>
</td>
</tr>
<?php
}
?>
<?php
}
?>
<tr>
public function downliuzhuanfile()
{
$per = C('DB_PREFIX');
$borrow_config = (require C("APP_ROOT") . "Conf/borrow_config.php");
$invest_id = intval($_GET['id']);
//$borrow_id=intval($_GET['id']);
//old
//$iinfo = M('borrow_investor')->field('id,borrow_id,investor_capital,investor_interest,deadline,investor_uid,add_time')->where("(investor_uid={$this->uid} OR borrow_uid={$this->uid}) AND id={$invest_id}")->find();
$iinfo = M('borrow_investor')->field('id,borrow_id,investor_capital,investor_interest,deadline,investor_uid,add_time')->where("investor_uid={$this->uid} AND id={$invest_id}")->find();
$investor_capital_big = cny($iinfo['investor_capital']);
$borrow_id = $iinfo['borrow_id'];
//dump( $borrow_id);
//exit;
$binfo = M('borrow_info bi')->field('bi.id,bi.repayment_type,bi.borrow_duration,bi.borrow_uid,bi.borrow_type,bi.borrow_use,bi.borrow_money,bi.full_time,bi.add_time,bi.borrow_interest_rate,bi.deadline,bi.second_verify_time,bi.collect_time,mi.real_name,mi.stamp_img')->join("{$per}member_info mi ON bi.danbao=mi.uid")->find($borrow_id);
//dump($iinfo);
//dump(M("members m")->getlastsql());
//exit;
$mBorrow = M("members m")->join("{$per}member_info mi ON mi.uid=m.id")->field('mi.real_name,m.user_name,mi.idcard,mi.stamp_img')->where("m.id={$binfo['borrow_uid']}")->find();
//$mInvest = M("members m")->join("{$per}member_info mi ON mi.uid=m.id")->field('mi.real_name,m.user_name')->where("m.id={$iinfo['investor_uid']}")->find();
$mInvest = M("members m")->join("{$per}member_info mi ON mi.uid=m.id")->field('mi.real_name,mi.address,mi.cell_phone,mi.idcard,m.user_name,m.user_email')->where("m.id={$iinfo['investor_uid']}")->find();
//if(!is_array($iinfo)||!is_array($binfo)||!is_array($mBorrow)||!is_array($mInvest)) exit;
$detail = M('investor_detail d')->field('d.borrow_id,d.investor_uid,d.borrow_uid,d.capital,sum(d.capital+d.interest-d.interest_fee) benxi,d.total')->where("d.borrow_id={$iinfo['borrow_id']} and d.invest_id ={$iinfo['id']}")->group('d.investor_uid')->find();
//$detailinfo = M('investor_detail d')->join("{$per}borrow_investor bi ON bi.id=d.invest_id")->join("{$per}members m ON m.id=d.investor_uid")->field('d.borrow_id,d.investor_uid,d.borrow_uid,d.capital,sum(d.capital+d.interest-d.interest_fee) benxi,d.total,m.user_name,bi.investor_capital,bi.add_time')->where("d.borrow_id={$iinfo['borrow_id']} and d.invest_id ={$iinfo['id']}")->group('d.investor_uid')->find();
$detailinfo = M('investor_detail d')->field('d.borrow_id,d.investor_uid,d.borrow_uid,(d.capital+d.interest-d.interest_fee) benxi,d.capital,d.interest,d.interest_fee,d.sort_order,d.deadline')->where("d.borrow_id={$iinfo['borrow_id']} and d.invest_id ={$iinfo['id']}")->select();
$time = M('borrow_investor')->field('id,add_time')->where("borrow_id={$iinfo['borrow_id']} order by add_time asc")->limit(1)->find();
if ($binfo['repayment_type'] == 1) {
$deadline_last = strtotime("+{$binfo['borrow_duration']} day", $time['add_time']);
} else {
$deadline_last = strtotime("+{$binfo['borrow_duration']} month", $time['add_time']);
}
$this->assign('deadline_last', $deadline_last);
$this->assign('detailinfo', $detailinfo);
$this->assign('detail', $detail);
$type1 = $this->gloconf['BORROW_USE'];
$binfo['borrow_use'] = $type1[$binfo['borrow_use']];
$ht = M('hetong')->field('hetong_img,name,dizhi,tel')->find();
$this->assign("ht", $ht);
$type = $borrow_config['REPAYMENT_TYPE'];
//echo $binfo['repayment_type'];
$binfo['repayment_name'] = $type[$binfo['repayment_type']];
// dump($binfo['stamp_img']);exit;
$iinfo['repay'] = getFloatValue(($iinfo['investor_capital'] + $iinfo['investor_interest']) / $binfo['borrow_duration'], 2);
$this->assign("bid", "bytp2pD");
//print_r($type);
$this->assign('investor_capital_big', $investor_capital_big);
$this->assign('iinfo', $iinfo);
$this->assign('binfo', $binfo);
$this->assign('mBorrow', $mBorrow);
$this->assign('mInvest', $mInvest);
$this->assign('borrow_id', $borrow_id);
$detail_list = M('investor_detail')->field(true)->where("invest_id={$invest_id}")->select();
$this->assign("detail_list", $detail_list);
//echo "<pre>";print_r($binfo);echo "</pre>";exit;
//$this->display("transfer");exit;
Vendor('Mpdf.mpdf');
$mpdf = new mPDF('UTF-8', 'A4', '', '', 15, 15, 4, 15);
$mpdf->useAdobeCJK = true;
$mpdf->SetAutoFont(AUTOFONT_ALL);
$mpdf->SetDisplayMode('fullpage');
$mpdf->SetAutoFont();
$mpdf->SetHTMLFooter(' >>{PAGENO}<<');
$mpdf->WriteHTML($this->fetch('transfer'));
$mpdf->Output('cailaijinfu.pdf', 'I');
exit;
$this->display("transfer");
}
$n++;
?>
<tr class="<?php
echo $n % 2 == 0 ? "even" : "odd";
?>
">
<td><?php
echo $v->wid;
?>
</td>
<td><?php
echo cny($v->volume);
?>
</td>
<td><?php
echo cny($v->balance_before);
?>
</td>
<td>￥<?php
echo bcsub(money($v->balance_before), money($v->volume), 2);
?>
</td>
<!--<td><?php
//=cny($v->balance);
?>
</td>-->
<td><?php
echo substr($v->create_time, 0, 19);
?>
</td>
</tr>
/**
*
* 导出缴费通知单（水电费）
*/
public function export3()
{
$data = array();
if (checkRight('fee_export') === FALSE) {
$this->showView('denied', $data);
exit;
}
$id = $this->input->get('did');
$this->load->model('MIS_Fee');
$this->load->model('MIS_Enterprise');
$info = $this->MIS_Fee->getInfo($id);
$buildInfo = array();
$this->MIS_Enterprise->getEnterpriseBuildingInfo($info['enterprise_id'], $buildInfo);
//加载PHPExcel库
require_once THIRD_PATH . 'PHPExcel.php';
require_once THIRD_PATH . 'PHPExcel/IOFactory.php';
$objPHPExcel = new PHPExcel();
//列宽
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(24);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(24);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(24);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(24);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(24);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(24);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(36);
//第一行
$objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->mergeCells('A1:G1');
$objPHPExcel->getActiveSheet()->setCellValue('A1', '缴费通知单');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(20);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//第二行
$objPHPExcel->getActiveSheet()->getRowDimension(2)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->mergeCells('A2:D2');
$objPHPExcel->getActiveSheet()->setCellValue('A2', '公司名称：' . $info['enterprise_name']);
$objPHPExcel->getActiveSheet()->getStyle('A2:D2')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->mergeCells('E2:G2');
$objPHPExcel->getActiveSheet()->setCellValue('E2', '编号：水电费-' . date('Y-m', $info['fee_date']));
$objPHPExcel->getActiveSheet()->getStyle('E2:G2')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//第三行
$objPHPExcel->getActiveSheet()->getRowDimension(3)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->mergeCells('A3:G3');
$objPHPExcel->getActiveSheet()->setCellValue('A3', '你好！贵单位在创投大厦 层 号房水电费缴费明细如下：');
$objPHPExcel->getActiveSheet()->getStyle('A3')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('A3')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A3:G3')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//第四行
$objPHPExcel->getActiveSheet()->getRowDimension(4)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->setCellValue('A4', '缴费类别');
$objPHPExcel->getActiveSheet()->setCellValue('B4', '上期读数');
$objPHPExcel->getActiveSheet()->setCellValue('C4', '本期读数');
$objPHPExcel->getActiveSheet()->setCellValue('D4', '计费数量（吨/度）');
$objPHPExcel->getActiveSheet()->setCellValue('E4', '单价（元）');
$objPHPExcel->getActiveSheet()->setCellValue('F4', '费用（元）');
$objPHPExcel->getActiveSheet()->getStyle('A4:G4')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A4:G4')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A4:G4')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//第五行
$objPHPExcel->getActiveSheet()->getRowDimension(5)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->setCellValue('A5', date('n月份电费', $info['fee_date']));
$objPHPExcel->getActiveSheet()->setCellValue('B5', $info['last_elec_num']);
$objPHPExcel->getActiveSheet()->setCellValue('C5', $info['cur_elec_num']);
$objPHPExcel->getActiveSheet()->setCellValue('D5', $info['elec_fee_num']);
$objPHPExcel->getActiveSheet()->setCellValue('E5', $info['elec_fee_unit_price']);
$objPHPExcel->getActiveSheet()->setCellValue('F5', $info['elec_fee_num'] * $info['elec_fee_unit_price']);
$objPHPExcel->getActiveSheet()->getStyle('A5:G5')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A5:G5')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A5:G5')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//第六行
$objPHPExcel->getActiveSheet()->getRowDimension(6)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->setCellValue('A6', date('n月份水费', $info['fee_date']));
$objPHPExcel->getActiveSheet()->setCellValue('B6', $info['last_water_num']);
$objPHPExcel->getActiveSheet()->setCellValue('C6', $info['cur_water_num']);
$objPHPExcel->getActiveSheet()->setCellValue('D6', $info['water_fee_num']);
$objPHPExcel->getActiveSheet()->setCellValue('E6', $info['water_fee_unit_price']);
$objPHPExcel->getActiveSheet()->setCellValue('F6', $info['water_fee_num'] * $info['water_fee_unit_price']);
$objPHPExcel->getActiveSheet()->getStyle('A6:G6')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A6:G6')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A6:G6')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//第七行
$objPHPExcel->getActiveSheet()->mergeCells('A7:G7');
$objPHPExcel->getActiveSheet()->getStyle('A7:G7')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//第八行
$objPHPExcel->getActiveSheet()->getRowDimension(8)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->setCellValue('A8', '费用合计');
$objPHPExcel->getActiveSheet()->mergeCells('B8:E8');
$total = $info['elec_fee_num'] * $info['elec_fee_unit_price'] + $info['water_fee_num'] * $info['water_fee_unit_price'];
$objPHPExcel->getActiveSheet()->setCellValue('B8', '（人民币大写）：' . cny($total));
$objPHPExcel->getActiveSheet()->setCellValue('F8', '￥' . $total);
$objPHPExcel->getActiveSheet()->getStyle('A8:G8')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A8:G8')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A8:G8')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('B8')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
//第九行
$objPHPExcel->getActiveSheet()->getRowDimension(9)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->mergeCells('A9:G9');
$objPHPExcel->getActiveSheet()->setCellValue('A9', '请贵单位在接到该缴费通知单后5个工作日内支付该款项，谢谢！');
$objPHPExcel->getActiveSheet()->getStyle('A9')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//第十行
$objPHPExcel->getActiveSheet()->getRowDimension(10)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->mergeCells('A10:G10');
$objPHPExcel->getActiveSheet()->setCellValue('A10', '联系人：');
$objPHPExcel->getActiveSheet()->getStyle('A10')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//第十一行
$objPHPExcel->getActiveSheet()->getRowDimension(11)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->mergeCells('A11:G11');
$objPHPExcel->getActiveSheet()->setCellValue('A11', '联系电话：');
$objPHPExcel->getActiveSheet()->getStyle('A11')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//第十二行
$objPHPExcel->getActiveSheet()->getRowDimension(12)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->setCellValue('G12', date('Y年m月d日', time()));
$objPHPExcel->getActiveSheet()->getStyle('G12')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//第十三行
$objPHPExcel->getActiveSheet()->getRowDimension(13)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->mergeCells('A13:G13');
$objPHPExcel->getActiveSheet()->setCellValue('A13', '户 名：');
$objPHPExcel->getActiveSheet()->getStyle('A13')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//第十四行
$objPHPExcel->getActiveSheet()->getRowDimension(14)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->mergeCells('A14:G14');
$objPHPExcel->getActiveSheet()->setCellValue('A14', '账号：');
$objPHPExcel->getActiveSheet()->getStyle('A14')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//第十五行
$objPHPExcel->getActiveSheet()->getRowDimension(15)->setRowHeight(30);
$objPHPExcel->getActiveSheet()->mergeCells('A15:G15');
$objPHPExcel->getActiveSheet()->setCellValue('A15', '行址：');
$objPHPExcel->getActiveSheet()->getStyle('A15')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->setTitle('缴费通知单（水电费）');
$objWriter = IOFactory::createWriter($objPHPExcel, 'Excel2007');
$file_name = "缴费通知单（水电费）_" . date("YmdHis") . ".xlsx";
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="' . $file_name . '"');
header('Cache-Control: max-age=0');
$objWriter->save('php://output');
}
</td>
</tr>
<tr>
<th>已生效现金卷</th>
<td>
<input type="text" value="<?php
echo cny($v->active_coupon);
?>
" disabled="disabled" style="color:#f60;">
</td>
</tr>
<tr>
<th>未生效现金卷</th>
<td>
<input type="text" value="<?php
echo cny($v->inactivated_coupon);
?>
" disabled="disabled" style="color:#f60;">
</td>
</tr>
<tr>
<th>帐号状态</th>
<td>
<input type="text" value="<?php
if ($this->session->userdata('initiation')) {
echo "代理会员";
} else {
echo "普通会员";
}
?>
" disabled="disabled" style="">
<fieldset>
<legend> 使用代金卷</legend>
<div class="price_tip">
本次交易总额为<span class="red">￥<?php
echo cny(bcadd($pay_amt_without_post_fee, $post_fee, 2));
?>
</span>，
其中产品价格<span class="red">￥<?php
echo cny($pay_amt_without_post_fee);
?>
</span>，
运费共<span class="red">￥<?php
echo cny($post_fee);
?>
</span>
</div>
<div style="float:left;">
<form id="pay" action="<?php
echo base_url();
?>
order/modify_payment/<?php
echo $order_info->id;
?>
" method="post">
<div class="form-group">
<label>使用代金卷金额</label>
<input type="text" value="<?php
echo $max;
?>
</td>
<td><?php
echo cny($v->normal_return_profit_self2parent);
?>
</td>
<td><?php
echo cny($v->extra_return_profit_self2parent);
?>
</td>
<td>￥<?php
echo bcadd(money($v->normal_return_profit_self2parent), money($v->extra_return_profit_self2parent), 2);
?>
</td>
<td><?php
echo cny($v->normal_return_profit_self2gparent);
?>
</td>
<?php
if (intval($v->pid) <= 0) {
?>
<td>无推荐人</td>
<?php
} else {
?>
<td><a href="<?php
echo base_url();
?>
user/details_admin/<?php
echo $v->pid;
?>
echo $v->product_id;
?>
"><?php
echo $v->title;
?>
</a></td>
<td><?php
echo $v->total_quantity;
?>
</td>
<td><?php
echo cny($v->original_amount);
?>
</td>
<td><?php
echo cny($v->amount);
?>
</td>
</tr>
<?php
}
?>
</table>
<div class="page"><?php
echo $page;
?>
</div>
<script>
/*function myconfirm(id){
if (confirm("are you sure?")){
window.location.href = "<?php
<th><label for="price_special">价格 <span>*</span></label></th>
<td>
<input disabled name="price" data-validate="required,decimal" value="<?php
echo cny($v->price);
?>
"/>(单位: 元)
</td>
</tr>
<tr>
<th><label for="price_special">折后价格(<?php
echo $v->discount;
?>
%) <span>*</span></label></th>
<td>
<input disabled name="price" data-validate="required,decimal" value="<?php
echo cny($v->discount_price);
?>
"/>(单位: 元)
</td>
</tr>
<tr>
<th>产品图片</th>
<td>
<img src="<?php
echo $v->img;
?>
" />
</td>
</tr>
<tr>
<th><label for="is_valid">是否上架 <span>*</span></label></th>
?>
</td>
<td><?php
echo $v->mobile;
?>
</td>
<!--<td><?php
echo $v->remark;
?>
</td>-->
<td><?php
echo $v->post_info;
?>
</td>
<td><?php
echo cny($v->coupon_volume);
?>
</td>
<td><?php
echo substr($v->stock_time, 0, 19);
?>
</td>
<td><a href="<?php
echo base_url();
?>
order/details/<?php
echo $v->id;
?>
">查看详情</a></td>
<td>
<?php
?>
</td>
<!--<td><?php
//=cny($v->delay_return_profit)
?>
</td>-->
<td>￥<?php
echo bcadd(money($v->normal_return_profit_sub2self), bcadd(money($v->extra_return_profit_sub2self), 0, 2), 2);
?>
</td>
<!--<td><?php
echo cny($v->normal_return_profit_self2parent);
?>
</td>
<td><?php
echo cny($v->extra_return_profit_self2parent);
?>
</td>
<td>￥<?php
echo bcadd(money($v->normal_return_profit_self2parent), money($v->extra_return_profit_self2parent), 2);
?>
</td>-->
<?php
if (intval($v->pid) <= 0 || $v->pid == '') {
?>
<td></td>
<?php
} else {
?>
<td><a target="_blank" href="<?php
echo base_url();
public function downliuzhuanfile()
{
$per = C('DB_PREFIX');
$borrow_config = (require C("APP_ROOT") . "Conf/borrow_config.php");
$type = $borrow_config['REPAYMENT_TYPE'];
$invest_id = intval($_GET['id']);
$iinfo = M("transfer_borrow_investor")->field(true)->where("investor_uid={$this->uid} AND id={$invest_id}")->find();
$binfo = M('transfer_borrow_info')->field(true)->find($iinfo['borrow_id']);
$tou = M('transfer_investor_detail')->where(" borrow_id={$iinfo['borrow_id']} AND investor_uid={$this->uid} ")->find();
$mBorrow = M("members m")->join("{$per}member_info mi ON mi.uid=m.id")->field('mi.real_name,m.user_name')->where("m.id={$binfo['borrow_uid']}")->find();
$mInvest = M("members m")->join("{$per}member_info mi ON mi.uid=m.id")->field('mi.real_name,m.user_name')->where("m.id={$iinfo['investor_uid']}")->find();
if (!is_array($tou)) {
$mBorrow['real_name'] = hidecard($mBorrow['real_name'], 5);
}
$binfo['repayment_name'] = $type[$binfo['repayment_type']];
$this->assign("bid", "LZBHT-" . str_repeat("0", 5 - strlen($binfo['id'])) . $binfo['id']);
$detailinfo = M('transfer_investor_detail d')->join("{$per}transfer_borrow_investor bi ON bi.id=d.invest_id")->join("{$per}members m ON m.id=d.investor_uid")->field('d.borrow_id,d.investor_uid,d.borrow_uid,d.capital,sum(d.capital+d.interest-d.interest_fee) benxi,d.total,m.user_name,bi.investor_capital,bi.add_time')->where("d.borrow_id={$iinfo['borrow_id']} and d.invest_id ={$iinfo['id']}")->group('d.investor_uid')->find();
$time = M('transfer_borrow_investor')->field('id,add_time')->where("borrow_id={$iinfo['borrow_id']} order by add_time asc")->limit(1)->find();
$deadline_last = strtotime("+{$binfo['borrow_duration']} month", $time['add_time']);
$this->assign('deadline_last', $deadline_last);
$this->assign('detailinfo', $detailinfo);
$type1 = $this->gloconf['BORROW_USE'];
$binfo['borrow_use'] = $type1[$binfo['borrow_use']];
$type = $borrow_config['REPAYMENT_TYPE'];
//echo $binfo['repayment_type'];
$binfo['repayment_name'] = $type[$binfo['repayment_type']];
$iinfo['repay'] = getFloatValue(($iinfo['investor_capital'] + $iinfo['investor_interest']) / $binfo['borrow_duration'], 2);
$iinfo['investor_capital'] = cny($iinfo['investor_capital']);
$binfo['borrow_interest_rate'] = substr(cny($binfo['borrow_interest_rate']), 0, -3);
$this->assign('iinfo', $iinfo);
//dump($binfo);die;
$this->assign('binfo', $binfo);
$this->assign('mBorrow', $mBorrow);
$this->assign('mInvest', $mInvest);
$detail_list = M('transfer_investor_detail')->field(true)->where("invest_id={$invest_id}")->select();
$this->assign("detail_list", $detail_list);
$ht = M('hetong')->field('hetong_img,name,dizhi,tel')->find();
$this->assign("ht", $ht);
if (isset($_GET['dl'])) {
// 带有flag标记并且为dl
Vendor('Mpdf.mpdf');
$mpdf = new mPDF('UTF-8', 'A4', '', '', 15, 15, 44, 15);
$mpdf->useAdobeCJK = true;
$mpdf->SetAutoFont(AUTOFONT_ALL);
$mpdf->SetDisplayMode('fullpage');
$mpdf->SetAutoFont();
$mpdf->SetHTMLFooter(' >>{PAGENO}<<');
$mpdf->WriteHTML($this->fetch('transfer'));
$mpdf->Output('zgtrbao.pdf', 'I');
exit;
}
$this->display("transfer");
}
