82 lines
2.6 KiB
PHP
82 lines
2.6 KiB
PHP
<?php
|
|
class flow_assetmClassModel extends flowModel
|
|
{
|
|
public $statearr;
|
|
public function initModel()
|
|
{
|
|
$this->statearr = c('array')->strtoarray('blue|闲置,#ff6600|在用,red|维修,gray|报废,gray|丢失');
|
|
}
|
|
|
|
public function flowrsreplace($rs,$lx=0)
|
|
{
|
|
if(isset($rs['typeid']))$rs['typeid'] = $this->db->getmou('[Q]option','name',"`id`='".$rs['typeid']."'");
|
|
if(isset($rs['ckid']) && $rs['ckid']>0){
|
|
$rs['ckid'] = $this->db->getmou('[Q]option','name',"`id`='".$rs['ckid']."'");
|
|
if(isset($rs['address']) && isempt($rs['address'])){
|
|
$rs['address'] = $rs['ckid'];
|
|
$this->update("`address`='".$rs['address']."'", $rs['id']);
|
|
}
|
|
}
|
|
if(isset($this->statearr[$rs['state']])){
|
|
$b = $this->statearr[$rs['state']];
|
|
$rs['state'] = '<font color="'.$b[0].'">'.$b[1].'</font>';
|
|
}
|
|
if(isset($rs['fengmian']) && !isempt($rs['fengmian']))$rs['fengmian'] = '<img src="'.$rs['fengmian'].'" height="100">';
|
|
|
|
if($lx==1){
|
|
$rows = $this->db->getall('select a.runren,a.id,a.optdt from `[Q]planm` a left join `[Q]plans` b on a.id=b.mid where b.itemid='.$rs['id'].' and a.`type`=1');
|
|
$str = '';
|
|
foreach($rows as $k1=>$rs1){
|
|
$url = $this->getxiangurl('assetmly', $rs1['id'],'auto');
|
|
$str.=''.$rs1['runren'].'('.$rs1['optdt'].') <a href="'.$url.'">查看</a><br>';
|
|
}
|
|
$rs['lycount'] = $str;
|
|
}
|
|
return $rs;
|
|
}
|
|
|
|
protected function flowbillwhere($uid, $lx)
|
|
{
|
|
$where = '';
|
|
$typeid = $this->rock->post('typeid','0');
|
|
//$key = $this->rock->post('key');
|
|
if($typeid!='0'){
|
|
$alltpeid = m('option')->getalldownid($typeid);
|
|
$where .= ' and `typeid` in('.$alltpeid.')';
|
|
}
|
|
//弃用这个，去到表单表示元素管理开启搜索
|
|
//if($key != '')$where.=" and (`title` like '%$key%' or `num` like '%$key%' or `usename` like '%$key%')";
|
|
return array(
|
|
'where' => $where,
|
|
'orlikefields'=>'title,num,usename',
|
|
'order' => 'optdt desc',
|
|
//'fields'=> 'id,title,num,brand,optdt,usename,state,ckid'
|
|
);
|
|
}
|
|
|
|
//导入数据的测试显示
|
|
public function flowdaorutestdata()
|
|
{
|
|
return array(
|
|
'typeid' => '电脑/台式电脑',
|
|
'title' => '这是一个电脑啊',
|
|
'num' => 'ZiCAN-001',
|
|
'brand' => '联想',
|
|
'laiyuan' => '购买',
|
|
'buydt' => '2017-01-17',
|
|
'explain' => '简单说明一下',
|
|
'address' => '放哪里了',
|
|
);
|
|
}
|
|
|
|
//导入之前
|
|
public function flowdaorubefore($rows)
|
|
{
|
|
foreach($rows as $k=>$rs){
|
|
$rows[$k]['typeid'] = $this->option->gettypeid('assetstype',$rs['typeid']);
|
|
$rows[$k]['adddt'] = $this->rock->now;
|
|
$rows[$k]['optdt'] = $this->rock->now;
|
|
}
|
|
return $rows;
|
|
}
|
|
} |