assetmModel.php 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. <?php
  2. class flow_assetmClassModel extends flowModel
  3. {
  4. public function initModel()
  5. {
  6. $this->statearr = c('array')->strtoarray('blue|闲置,#ff6600|在用,red|维修,gray|报废,gray|丢失');
  7. }
  8. public function flowrsreplace($rs)
  9. {
  10. if(isset($rs['typeid']))$rs['typeid'] = $this->db->getmou('[Q]option','name',"`id`='".$rs['typeid']."'");
  11. if(isset($rs['ckid']) && $rs['ckid']>0){
  12. $rs['ckid'] = $this->db->getmou('[Q]option','name',"`id`='".$rs['ckid']."'");
  13. if(isset($rs['address']) && isempt($rs['address'])){
  14. $rs['address'] = $rs['ckid'];
  15. $this->update("`address`='".$rs['address']."'", $rs['id']);
  16. }
  17. }
  18. if(isset($this->statearr[$rs['state']])){
  19. $b = $this->statearr[$rs['state']];
  20. $rs['state'] = '<font color="'.$b[0].'">'.$b[1].'</font>';
  21. }
  22. if(isset($rs['fengmian']) && !isempt($rs['fengmian']))$rs['fengmian'] = '<img src="'.$rs['fengmian'].'" height="100">';
  23. return $rs;
  24. }
  25. protected function flowbillwhere($uid, $lx)
  26. {
  27. $where = '';
  28. $typeid = $this->rock->post('typeid','0');
  29. //$key = $this->rock->post('key');
  30. if($typeid!='0'){
  31. $alltpeid = m('option')->getalldownid($typeid);
  32. $where .= ' and `typeid` in('.$alltpeid.')';
  33. }
  34. //弃用这个,去到表单表示元素管理开启搜索
  35. //if($key != '')$where.=" and (`title` like '%$key%' or `num` like '%$key%' or `usename` like '%$key%')";
  36. return array(
  37. 'where' => $where,
  38. 'orlikefields'=>'title,num,usename',
  39. 'order' => 'optdt desc',
  40. //'fields'=> 'id,title,num,brand,optdt,usename,state,ckid'
  41. );
  42. }
  43. //导入数据的测试显示
  44. public function flowdaorutestdata()
  45. {
  46. return array(
  47. 'typeid' => '电脑/台式电脑',
  48. 'title' => '这是一个电脑啊',
  49. 'num' => 'ZiCAN-001',
  50. 'brand' => '联想',
  51. 'laiyuan' => '购买',
  52. 'buydt' => '2017-01-17',
  53. 'explain' => '简单说明一下',
  54. 'address' => '放哪里了',
  55. );
  56. }
  57. //导入之前
  58. public function flowdaorubefore($rows)
  59. {
  60. foreach($rows as $k=>$rs){
  61. $rows[$k]['typeid'] = $this->option->gettypeid('assetstype',$rs['typeid']);
  62. $rows[$k]['adddt'] = $this->rock->now;
  63. $rows[$k]['optdt'] = $this->rock->now;
  64. }
  65. return $rows;
  66. }
  67. }