typearr = array('收款合同','付款合同'); $this->typesarr = array('收','付'); $this->statearr = c('array')->strtoarray('待生效|blue,生效中|green,已过期|#888888'); $this->dtobj = c('date'); $this->crmobj = m('crm'); $this->goodmobj = m('goodm'); $this->wherejoin['custfina'] = 'htid'; $this->wherejoin['custfinb'] = 'htid'; } //作废或删除时 protected function flowzuofeibill($sm) { m('goodm')->update('`custractid`=0', "`custractid`='".$this->id."'");//销售单取消关联合同 $xiaoid = (int)arrvalue($this->rs,'xiaoid','0'); } public function flowrsreplace($rs, $lx=0){ $type = $rs['type']; $rs['type'] = $this->typearr[$type]; $statetext = ''; $dt = $this->rock->date; $htstatus = 0; if($rs['startdt']>$dt){ $statetext='待生效'; }else if($rs['startdt']<=$dt && $rs['enddt']>=$dt){ $jg = $this->dtobj->datediff('d', $dt, $rs['enddt']); $statetext='生效中
'.$jg.'天过期'; if($jg==0)$statetext='今日到期'; $htstatus = 1; }else if($rs['enddt']<$dt){ $statetext='已过期'; $rs['ishui'] = 1; $htstatus = 2; } $rs['statetext'] = $statetext; $nrss = $this->crmobj->ractmoney($rs); $ispay = $nrss[0]; $moneys = $nrss[1]; $dsmoney = ''; $ts = $this->typesarr[$type]; if($ispay==1){ $dsmoney = '已全部'.$ts.'款'; }else{ $dsmoney = '待'.$ts.''.$moneys.''; } if(isset($rs['xiaoid']) && $rs['xiaoid']>0){ $xiaors = $this->goodmobj->getone("`id`='".$rs['xiaoid']."' and `status`<>5"); if($xiaors){ if($lx==1){ $dsmoney.=',销售单:'.$xiaors['num'].''; }else{ $dsmoney.=',销售单:
'.$xiaors['num'].''; } }else{ $this->update('`xiaoid`=0', $rs['id']); } } $rs['moneys'] = $dsmoney; $rs['htstatus'] = $htstatus; return $rs; } protected function flowbillwhere($uid, $lx) { $month = $this->rock->post('dt'); $where = ''; if($month!=''){ $where =" and `signdt` like '$month%'"; } return array( 'where' => $where, 'order' => '`optdt` desc', //'orlikefields' => 'custname' ); } protected function flowoptmenu($ors, $arrs) { //创建待收付款单 if($ors['num']=='cjdaishou'){ $moneys = m('crm')->getmoneys($this->rs['id']); $money = $this->rs['money'] - $moneys; if($money > 0){ $arr['htid'] = $this->rs['id']; $arr['htnum'] = $this->rs['num']; $arr['uid'] = $this->rs['uid']; $arr['custid'] = $this->rs['custid']; $arr['custname']= $this->rs['custname']; $arr['dt'] = $this->rock->date; $arr['optdt'] = $this->rock->now; $arr['createdt']= $this->rock->now; $arr['optname'] = $this->adminname; $arr['createname']= $this->adminname; $arr['createid'] = $this->adminid; //$arr['optid'] = $this->adminid; $arr['type'] = $this->rs['type']; $arr['explain'] = $arrs['sm']; $arr['money'] = $money; m('custfina')->insert($arr); } } } /** * 客户合同到期提醒 */ public function custractdaoqi() { $dt = $this->rock->date; $rows = $this->getall("status=1 and `enddt` is not null and `enddt`>='$dt'",'uid,num,custname,enddt','`uid`'); $txlist = m('option')->getval('crmtodo','0,3,7,15,30');//提醒的时间 $txarr = explode(',', $txlist); $dtobj = c('date'); $txrows = array(); foreach($rows as $k=>$rs){ $jg = $dtobj->datediff('d', $dt, $rs['enddt']); $uid= $rs['uid']; if(in_array($jg, $txarr)){ $strs = ''.$jg.'天后('.$rs['enddt'].')'; if($jg==1)$strs='明天'; if($jg==0)$strs='今天'; if(!isset($txrows[$uid]))$txrows[$uid]=''; $txrows[$uid] .= '客户['.$rs['custname'].']的[合同:'.$rs['num'].']将在'.$strs.'到期;'; } } foreach($txrows as $uid=>$cont){ $this->push($uid, '客户,CRM', $cont, '客户合同到期提醒'); } } //对外的详情页 public function flowopenxiang($da, $xiangdata) { $zdarr = array('num','custname','type','fenlei','signdt','money','startdt','enddt','explain'); $slsts = array(); foreach($xiangdata as $k=>$rs){ if(in_array($rs['fields'], $zdarr)){ $slsts[] = $rs; } } //相关文件 $filedata = array(); $htfileid = arrvalue($da,'htfileid'); if($htfileid){ $filedata = m('file')->getall('id in('.$htfileid.')','id,filename,filesizecn,fileext'); } return array('xiangdata'=>$slsts,'filedata'=>$filedata); } }