datediff('d', $this->rock->date, $rs['enddt']);
if($jg<0){
$ztname='已到期';
$rs['ishui'] = 1;
}
if($jg==0)$ztname='今日到期';
if($jg>0 && $jg<30)$ztname=''.$jg.'天后到期';
if($jg>=30)$ztname='生效中';
}
if(isset($rs['carnum'])){
$ors = $rs;
}else{
$ors = m('carm')->getone($rs['carid']);
}
if($ors)$rs['carid'] = ''.$ors['carbrand'].','.$ors['carmode'].'('.$ors['carnum'].')';
$rs['ztname'] = $ztname;
return $rs;
}
public function flowbillwhere($uid, $lx)
{
$where = '';
$carid = (int)$this->rock->get('carid',0);
if($carid>0)$where='and a.`carid`='.$carid.'';
return array(
'table' => '`[Q]'.$this->mtable.'` a left join `[Q]carm` b on a.`carid`=b.id',
'fields' => 'a.*,b.carnum,b.carbrand,b.carmode,cartype',
'orlikefields' => 'b.carnum,b.carbrand,b.carmode,b.`cartype`,a.`otype`@1',
'asqom' => 'a.',
'where' => $where,
);
}
//每天信息提醒
public function todocarms($toid)
{
if(isempt($toid))return '没设置提醒人员';
$dt = $this->rock->date;
$dt30 = c('date')->adddate($dt,'d', 30);
$rows = $this->db->getall('select a.`enddt`,a.`otype`,b.`carnum` from `[Q]carms` a left join `[Q]carm` b on a.carid=b.id where b.id is not null and a.`enddt` is not null and a.`enddt`>=\''.$dt.'\'');
$txlist = m('option')->getval('cartodo','0,3,7,15,30');
$txarr = explode(',', $txlist);
$dtobj = c('date');
$cars = array();
$str = '';
foreach($rows as $k=>$rs){
$jg = $dtobj->datediff('d', $dt, $rs['enddt']);
if(in_array($jg, $txarr)){
$strs = ''.$jg.'天后('.$rs['enddt'].')';
if($jg==1)$strs='明天';
if($jg==0)$strs='今天';
$str .= ''.$rs['carnum'].'的['.$rs['otype'].']将在'.$strs.'到期;';
}
}
//下次保养提醒
$rows = $this->db->getall('select a.`nextdt`,b.`carnum`,a.`jiaid`,a.`uid` from `[Q]carmang` a left join `[Q]carm` b on a.carid=b.id where b.id is not null and a.`type`=1 and a.`status`=1 and a.`nextdt` is not null and a.`nextdt`>=\''.$dt.'\'');
foreach($rows as $k=>$rs){
$jg = $dtobj->datediff('d', $dt, $rs['nextdt']);
if(in_array($jg, $txarr)){
$strs = ''.$jg.'后('.$rs['nextdt'].')';
if($jg==1)$strs='明天';
if($jg==0)$strs='今天';
$str .= ''.$rs['carnum'].'在'.$strs.'后需保养了;';
}
}
if($str!=''){
$this->push($toid, '车辆', $str, '车辆信息提醒');
}
return 'success';
}
}