carmreseModel.php 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. <?php
  2. class flow_carmreseClassModel extends flowModel
  3. {
  4. protected function flowbillwhere($uid, $lx)
  5. {
  6. $where = '';
  7. //$key = $this->rock->post('key');
  8. //$dt = $this->rock->post('dt');
  9. //if($key != '')$where.=" and (`carnum`='$key' or `usename` like '%$key%' or `optname` like '%$key%')";
  10. //if($dt != '')$where.=" and (`applydt`='$dt' or `startdt` like '$dt%')";
  11. return array(
  12. 'where' => $where,
  13. 'order' => 'optdt desc'
  14. );
  15. }
  16. //自定义审核人读取
  17. protected function flowcheckname($num){
  18. $sid = '';
  19. $sna = '';
  20. //驾驶员审核读取
  21. if($num=='jias'){
  22. $sid = $this->rs['jiaid'];
  23. $sna = $this->rs['jianame'];
  24. }
  25. return array($sid, $sna);
  26. }
  27. //可预定的车辆
  28. public function getcardata()
  29. {
  30. $where = $this->adminmodel->getcompanywhere(1);
  31. $rows = m('carm')->getall("`ispublic`=1 and `state`=1 ".$where."",'carnum as name,id as value');
  32. $db = m('carmrese');
  33. //读取车辆最后公里数
  34. foreach($rows as $k=>$rs){
  35. $onrs = $db->getone("`status`=1 and `carid`=".$rs['value']." and ifnull(`kmend`,'')<>''", '`kmend`,`kmstart`','`kmend` desc');
  36. $km = '';
  37. if($onrs){
  38. $km = $onrs['kmend'];
  39. if(isempt($km))$km = $onrs['kmstart'];
  40. }
  41. $rows[$k]['kmstart'] = $km;
  42. }
  43. return $rows;
  44. }
  45. }
粤ICP备19079148号