post('dt1');
$dt2 = $this->post('dt2');
if(isempt($dt1))$dt1 = date('Y-01');
if(isempt($dt2))$dt2 = date('Y-m');
$dtobj = c('date');
$start = $dt1.'-01';
$enddt = $dtobj->getenddt($dt2);
$jg = $dtobj->datediff('m', $dt1.'-01', $dt2.'-01');
$where = m('admin')->getcompanywhere(1);
$drows = m('finpiao')->getall("`opendt`>='$start' and `opendt`<='$enddt' and `status`=1 ".$where."");
$toarr = array();
foreach($drows as $k=>$rs){
$rq = substr($rs['opendt'],0,7);
if(!isset($toarr[$rq]))$toarr[$rq] = array('moneyshou'=>0,'moneykai'=>0,'moneyzong'=>0);
$fee = floatval($rs['money']);
//收到的
if($rs['type']=='1'){
$toarr[$rq]['moneyshou']+=$fee;
}else{
$toarr[$rq]['moneykai']+=$fee;
}
}
$month = $dt2;
$hjrows= array('moneyshou'=>0,'month' => '合计','moneykai'=>0,'moneyzong'=>0);
for($i=0;$i<=$jg; $i++){
if($i>0){
$month = $dtobj->adddate($dt2.'-01','m',0-$i,'Y-m');
}
$jers = array('moneyshou'=>0,'month' => $month,'moneykai'=>0,'moneyzong'=>0);
if(isset($toarr[$month])){
$jers1 = $toarr[$month];
$jers['moneyshou'] = $jers1['moneyshou'];
$jers['moneykai'] = $jers1['moneykai'];
$jers['moneyzong'] = $jers1['moneykai']-$jers1['moneyshou'];
}
$hjrows['moneyshou']+=$jers['moneyshou'];
$hjrows['moneykai']+=$jers['moneykai'];
$hjrows['moneyzong']+=$jers['moneyzong'];
if($jers['moneyshou']==0)$jers['moneyshou']='';
if($jers['moneykai']==0)$jers['moneykai']='';
if($jers['moneyzong']==0)$jers['moneyzong']='';
$rows[] = $jers;
}
if($hjrows['moneyshou']==0)$hjrows['moneyshou']='';
if($hjrows['moneykai']==0)$hjrows['moneykai']='';
if($hjrows['moneyzong']==0)$hjrows['moneyzong']='';
$rows[] = $hjrows;
foreach($rows as $k=>$rs){
if($rs['moneyshou'])$rows[$k]['moneyshou'] = $this->rock->number($rs['moneyshou']);
if($rs['moneykai'])$rows[$k]['moneykai'] = $this->rock->number($rs['moneykai']);
if($rs['moneyzong'])$rows[$k]['moneyzong'] = $this->rock->number($rs['moneyzong']);
}
$barr = array(
'rows' => $rows,
'dt1' => $dt1,
'dt2' => $dt2,
'jg' => $jg,
'totalCount'=>count($rows),
);
if($this->post('execldown')=='true')return $this->exceldown($barr); //导出
return $barr;
}
/**
* 发邮件给客户
*/
public function sendemailAjax()
{
$id = (int)$this->get('id','0');
$rs = m('finpiao')->getone('`id`='.$id.'');
if(!$rs || $rs['type']!=0)return returnerror('不存在');
$mairs = m('customer')->getone('`id`='.$rs['maicustid'].'');
if(!$mairs)return returnerror('客户不存在');
$email = $mairs['email'];
if(isempt($email))return returnerror('此客户没有设置邮箱');
$fjar = m('file')->getfilepath('finpiao', $id);
$html = c('html')->createtable(array(
'custname' => '开票方',
'maicustname' => '购买方',
'opendt' => '开票日期',
'ptype' => '发票类型',
'daima' => '发票代码',
'haoma' => '发票号码',
'money' => '金额',
), $rs,'发票信息');
$emcont = '您好：
这是我们开的发票消息请查收。
'.$html.'';
if($fjar[2])$emcont.='
相关文件：
'.$fjar[2].'';
$emcont .= '
发送人：'.$rs['optname'].'
发送时间：'.$this->now.'';
$msg = m('email')->sendmail('给您开的发票信息',$emcont , array(
'receemail' => $email,
'recename' => $rs['maicustname'],
'receid' => $mairs['id'],
), array(), 0, array(
'attachpath'=> $fjar[0],
'attachname'=> $fjar[1],
));
if($msg!='ok')return returnerror($msg);
return returnsuccess('已发送给：'.$email.'');
}
}