numofper.php 2.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. <?php
  2. Doo::loadCore('db/DooModel');
  3. /**
  4. * 用户表
  5. */
  6. class Anumofper extends DooModel {
  7. public $mpid;
  8. public $iszero;
  9. public $uid;
  10. public $pid;
  11. public $pmid;
  12. public $stid;
  13. public $numpname;
  14. public $times;
  15. public $currcontractval;
  16. public $currchangeval;
  17. public $stopnowtotal;
  18. public $currdone;
  19. public $curralltotal;
  20. public $currstatus;
  21. public $audittime;
  22. public $_table = 'jl_measure_numofper';
  23. public $_primarykey = 'mpid';
  24. public $_fields = array('pmid', 'iszero', 'uid', 'pid', 'pmid', 'stid', 'numpname', 'times', 'currcontractval', 'currchangeval', 'stopnowtotal', 'currcontractval', 'currdone', 'curralltotal', 'currstatus', 'audittime');
  25. public function __construct() {
  26. parent::setupModel(__CLASS__);
  27. }
  28. //标段下最新一期
  29. public function getLastNew2($pmid) {
  30. return $this->getOne(array('where' => 'pmid = ?', 'groupby' => 'pmid, numpname', 'desc' => 'numpname', 'param' => array($pmid), 'asArray' => TRUE));
  31. // return $this->__numofperact->getOne(array('select' => 'stopnowtotal, currdone', 'where' => 'pmid = ? and currstatus!=\'checkno\'', 'orderby' => 'numpname', 'desc' => 'numpname', 'param' => array($pmid), 'asArray' => TRUE));
  32. }
  33. public function getMaxStatusTimes($pmid, $numpname) {
  34. return $this->getOne(array('select' => 'currstatus', 'where' => 'pmid=? and numpname=?', 'param' => array($pmid, $numpname), 'desc' => 'times', 'asArray' => TRUE));
  35. }
  36. //获取标段的所有期数
  37. public function getGroupByLastOne2($pmid) {
  38. return $this->find(array('where' => 'pmid=?', 'groupby' => 'numpname', 'desc' => 'numpname', 'param' => array($pmid), 'asArray' => TRUE));
  39. }
  40. public function getRowByMpid($mpid) {
  41. return $this->getOne(array('where' => 'mpid=?', 'param' => array($mpid), 'asArray' => TRUE));
  42. }
  43. //更新数据
  44. public function updateAuditStatus($mpid, $statuno = 'checking') {
  45. $this->currstatus = $statuno;
  46. $this->audittime = $statuno != 'checking' ? time() : 0;
  47. return $this->update(array('where' => 'mpid=?', 'param' => array($mpid)));
  48. }
  49. public function del($mpid)
  50. {
  51. return $this->delete(array('where' => 'mpid=?', 'param' => array($mpid)));
  52. }
  53. }
  54. ?>