itemmeasurenum.php 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141
  1. <?php
  2. Doo::loadModel('itemmnum');
  3. class ItemMeasureNumpofper
  4. {
  5. private $__itemMeasureNum;
  6. function __construct()
  7. {
  8. $this->__itemMeasureNum = new ItemMeasureNumofper();
  9. }
  10. public function insert($postArray)
  11. {
  12. $this->__itemMeasureNum->iaid = $postArray['iaid'];
  13. $this->__itemMeasureNum->ownerid = $postArray['ownerid'];
  14. $this->__itemMeasureNum->softwareitemid = $postArray['itemid'];
  15. $this->__itemMeasureNum->pid = $postArray['pid'];
  16. $this->__itemMeasureNum->pmid = $postArray['pmid'];
  17. $this->__itemMeasureNum->isdel = 0;
  18. $this->__itemMeasureNum->deltime = 0;
  19. $this->__itemMeasureNum->categoryid = $postArray['categoryid'];
  20. $this->__itemMeasureNum->tips = $postArray['tips'];
  21. $this->__itemMeasureNum->numpname = $postArray['numpname'];
  22. $this->__itemMeasureNum->intime = time();
  23. return $this->__itemMeasureNum->insert();
  24. }
  25. public function getItemMeasureNum($tenderid, $limit, $numpname, $userid)
  26. {
  27. if (!empty($limit)) {
  28. if (isset($numpname) && isset($userid)) {
  29. return $this->__itemMeasureNum->limit($limit, null, 'imnid', array('where' => "pmid=? AND isdel=0 AND numpname=? AND ownerid=?", 'param' => array($tenderid, $numpname, $userid), 'asArray' => TRUE));
  30. } elseif (isset($numpname)) {
  31. return $this->__itemMeasureNum->limit($limit, null, 'imnid', array('where' => "pmid=? AND isdel=0 AND numpname=?", 'param' => array($tenderid, $numpname), 'asArray' => TRUE));
  32. } elseif (isset($userid)) {
  33. return $this->__itemMeasureNum->limit($limit, null, 'imnid', array('where' => "pmid=? AND isdel=0 AND ownerid=?", 'param' => array($tenderid, $userid), 'asArray' => TRUE));
  34. } else {
  35. return $this->__itemMeasureNum->limit($limit, null, 'imnid', array('where' => "pmid=? AND isdel=0", 'param' => array($tenderid), 'asArray' => TRUE));
  36. }
  37. } else {
  38. return $this->__itemMeasureNum->find(array('where' => 'pmid=? AND isdel=0', 'param' => array($tenderid), 'asArray' => TRUE));
  39. }
  40. }
  41. public function getItemMeasureNumDel($limit, $tenderid)
  42. {
  43. if (!empty($limit)) {
  44. return $this->__itemMeasureNum->limit($limit, null, 'imnid', array('where' => "pmid=? AND isdel=1", 'param' => array($tenderid), 'asArray' => TRUE));
  45. } else {
  46. return $this->__itemMeasureNum->find(array('where' => 'pmid=? AND isdel=1', 'param' => array($tenderid), 'asArray' => TRUE));
  47. }
  48. }
  49. public function getCount($tenderid, $deltag = 1, $numpname, $userid)
  50. {
  51. if (isset($numpname) && isset($userid)) {
  52. return $this->__itemMeasureNum->count(array('where' => 'pmid=? AND isdel=? AND numpname=? AND ownerid=?', 'param' => array($tenderid, $deltag, $numpname, $userid), 'asArray' => TRUE));
  53. }
  54. if (isset($numpname)) {
  55. return $this->__itemMeasureNum->count(array('where' => 'pmid=? AND isdel=? AND numpname=? ', 'param' => array($tenderid, $deltag, $numpname), 'asArray' => TRUE));
  56. }
  57. if (isset($userid)) {
  58. return $this->__itemMeasureNum->count(array('where' => 'pmid=? AND isdel=? AND ownerid=?', 'param' => array($tenderid, $deltag, $userid), 'asArray' => TRUE));
  59. }
  60. return $this->__itemMeasureNum->count(array('where' => 'pmid=? AND isdel=?', 'param' => array($tenderid, $deltag), 'asArray' => TRUE));
  61. }
  62. public function getRowData($imnid)
  63. {
  64. return $this->__itemMeasureNum->getOne(array('where' => 'imnid=?', 'param' => array($imnid), 'asArray' => TRUE));
  65. }
  66. public function updateItemFields($id, $tips)
  67. {
  68. $this->__itemMeasureNum->tips = iconv('GBK', 'UTF-8', $tips);
  69. return $this->__itemMeasureNum->update(array('where' => 'imnid=?', 'param' => array($id)));
  70. }
  71. public function deleteItem($id)
  72. {
  73. return $this->__itemMeasureNum->delete(array('where' => 'imnid=?', 'param' => array($id)));
  74. }
  75. public function updateDeltag($id, $deluid)
  76. {
  77. $this->__itemMeasureNum->isdel = 1;
  78. $this->__itemMeasureNum->deltime = time();
  79. $this->__itemMeasureNum->deluid = $deluid;
  80. return $this->__itemMeasureNum->update(array('where' => 'imnid=?', 'param' => array($id)));
  81. }
  82. public function recoveryDel($id)
  83. {
  84. $this->__itemMeasureNum->isdel = 0;
  85. return $this->__itemMeasureNum->update(array('where' => 'imnid=?', 'param' => array($id)));
  86. }
  87. public function updateIAID($oldiaid, $newiaid)
  88. {
  89. $this->__itemMeasureNum->iaid = $newiaid;
  90. return $this->__itemMeasureNum->update(array('where' => 'iaid=?', 'param' => array($oldiaid)));
  91. }
  92. public function delItemFields($imnid)
  93. {
  94. return $this->__itemMeasureNum->delete(array('where' => 'imnid=?', 'param' => array($imnid)));
  95. }
  96. public function delItemIAID($iaid)
  97. {
  98. return $this->__itemMeasureNum->delete(array('where' => 'iaid=?', 'param' => array($iaid)));
  99. }
  100. public function delItembyPmid($pmid)
  101. {
  102. $list = $this->__itemMeasureNum->find(array('where' => 'pmid=?', 'param' => array($pmid), 'asArray' => TRUE));
  103. if(!empty($list)){
  104. include (DOO::conf()->SITE_PATH . 'protected/class/itemfile.php');
  105. // Doo::loadClass('itemfile');
  106. include (DOO::conf()->SITE_PATH . 'protected/plugin/io.han.php');
  107. foreach($list as $k => $v){
  108. $itemfile = new ItemFile();
  109. //删除附件文件、数据库记录
  110. $itemfile_arr = $itemfile->getItemFile($v['iaid']);
  111. if($itemfile_arr){
  112. $this->IoHandler = new IoHandler();
  113. $path = DOO::conf()->SITE_PATH.$itemfile_arr['filepath'];
  114. $this->IoHandler->DeleteFile($path);
  115. $itemfile->delItem($v['iaid']);
  116. }
  117. $this->delItemFields($v['imnid']);
  118. }
  119. }
  120. }
  121. }