ExpenseReportTest.php 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318
  1. <?php
  2. /* Copyright (C) 2010 Laurent Destailleur <eldy@users.sourceforge.net>
  3. * Copyright (C) 2023 Alexandre Janniaux <alexandre.janniaux@gmail.com>
  4. *
  5. * This program is free software; you can redistribute it and/or modify
  6. * it under the terms of the GNU General Public License as published by
  7. * the Free Software Foundation; either version 3 of the License, or
  8. * (at your option) any later version.
  9. *
  10. * This program is distributed in the hope that it will be useful,
  11. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  12. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  13. * GNU General Public License for more details.
  14. *
  15. * You should have received a copy of the GNU General Public License
  16. * along with this program. If not, see <https://www.gnu.org/licenses/>.
  17. * or see https://www.gnu.org/
  18. */
  19. /**
  20. * \file test/phpunit/ExpenseReportTest.php
  21. * \ingroup test
  22. * \brief PHPUnit test
  23. * \remarks To run this script as CLI: phpunit filename.php
  24. */
  25. global $conf,$user,$langs,$db;
  26. //define('TEST_DB_FORCE_TYPE','mysql'); // This is to force using mysql driver
  27. //require_once 'PHPUnit/Autoload.php';
  28. require_once dirname(__FILE__).'/../../htdocs/master.inc.php';
  29. require_once dirname(__FILE__).'/../../htdocs/expensereport/class/expensereport.class.php';
  30. if (empty($user->id)) {
  31. print "Load permissions for admin user nb 1\n";
  32. $user->fetch(1);
  33. $user->getrights();
  34. }
  35. $conf->global->MAIN_DISABLE_ALL_MAILS=1;
  36. /**
  37. * Class for PHPUnit tests
  38. *
  39. * @backupGlobals disabled
  40. * @backupStaticAttributes enabled
  41. * @remarks backupGlobals must be disabled to have db,conf,user and lang not erased.
  42. */
  43. class ExpenseReportTest extends PHPUnit\Framework\TestCase
  44. {
  45. protected $savconf;
  46. protected $savuser;
  47. protected $savlangs;
  48. protected $savdb;
  49. /**
  50. * Constructor
  51. * We save global variables into local variables
  52. *
  53. * @param string $name Name
  54. * @return ExpenseReportTest
  55. */
  56. public function __construct($name = '')
  57. {
  58. parent::__construct($name);
  59. //$this->sharedFixture
  60. global $conf,$user,$langs,$db;
  61. $this->savconf=$conf;
  62. $this->savuser=$user;
  63. $this->savlangs=$langs;
  64. $this->savdb=$db;
  65. print __METHOD__." db->type=".$db->type." user->id=".$user->id;
  66. //print " - db ".$db->db;
  67. print "\n";
  68. }
  69. /**
  70. * setUpBeforeClass
  71. *
  72. * @return void
  73. */
  74. public static function setUpBeforeClass(): void
  75. {
  76. global $conf,$user,$langs,$db;
  77. $db->begin(); // This is to have all actions inside a transaction even if test launched without suite.
  78. print __METHOD__."\n";
  79. }
  80. /**
  81. * tearDownAfterClass
  82. *
  83. * @return void
  84. */
  85. public static function tearDownAfterClass(): void
  86. {
  87. global $conf,$user,$langs,$db;
  88. $db->rollback();
  89. print __METHOD__."\n";
  90. }
  91. /**
  92. * Init phpunit tests
  93. *
  94. * @return void
  95. */
  96. protected function setUp(): void
  97. {
  98. global $conf,$user,$langs,$db;
  99. $conf=$this->savconf;
  100. $user=$this->savuser;
  101. $langs=$this->savlangs;
  102. $db=$this->savdb;
  103. print __METHOD__."\n";
  104. //print $db->getVersion()."\n";
  105. }
  106. /**
  107. * End phpunit tests
  108. *
  109. * @return void
  110. */
  111. protected function tearDown(): void
  112. {
  113. print __METHOD__."\n";
  114. }
  115. /**
  116. * testExpenseReportCreate
  117. *
  118. * @return void
  119. */
  120. public function testExpenseReportCreate()
  121. {
  122. global $conf,$user,$langs,$db;
  123. $conf=$this->savconf;
  124. $user=$this->savuser;
  125. $langs=$this->savlangs;
  126. $db=$this->savdb;
  127. // Create supplier order with a too low quantity
  128. $localobject=new ExpenseReport($db);
  129. $localobject->initAsSpecimen(); // Init a specimen with lines
  130. $localobject->status = 0;
  131. $localobject->fk_statut = 0;
  132. $localobject->date_fin = null; // Force bad value
  133. $result=$localobject->create($user);
  134. print __METHOD__." result=".$result."\n";
  135. $this->assertEquals(-1, $result, "Error on test ExpenseReport create 1 : ".$localobject->error); // must be -1 because of missing mandatory fields
  136. $sql="DELETE FROM ".MAIN_DB_PREFIX."expensereport where ref=''";
  137. $db->query($sql);
  138. // Create supplier order
  139. $localobject2=new ExpenseReport($db);
  140. $localobject2->initAsSpecimen(); // Init a specimen with lines
  141. $localobject2->status = 0;
  142. $localobject2->fk_statut = 0;
  143. $result=$localobject2->create($user);
  144. print __METHOD__." result=".$result."\n";
  145. $this->assertGreaterThanOrEqual(0, $result, "Error on test ExpenseReport create 2 : ".$localobject2->error);
  146. return $result;
  147. }
  148. /**
  149. * testExpenseReportFetch
  150. *
  151. * @param int $id Id of supplier order
  152. * @return void
  153. *
  154. * @depends testExpenseReportCreate
  155. * The depends says test is run only if previous is ok
  156. */
  157. public function testExpenseReportFetch($id)
  158. {
  159. global $conf,$user,$langs,$db;
  160. $conf=$this->savconf;
  161. $user=$this->savuser;
  162. $langs=$this->savlangs;
  163. $db=$this->savdb;
  164. $localobject=new ExpenseReport($db);
  165. $result=$localobject->fetch($id);
  166. print __METHOD__." id=".$id." result=".$result."\n";
  167. $this->assertLessThan($result, 0);
  168. return $localobject;
  169. }
  170. /**
  171. * testExpenseReportValid
  172. *
  173. * @param ExpenseReport $localobject ExpenseReport
  174. * @return void
  175. *
  176. * @depends testExpenseReportFetch
  177. * The depends says test is run only if previous is ok
  178. */
  179. public function testExpenseReportValid($localobject)
  180. {
  181. global $conf,$user,$langs,$db;
  182. $conf=$this->savconf;
  183. $user=$this->savuser;
  184. $langs=$this->savlangs;
  185. $db=$this->savdb;
  186. $result=$localobject->setValidate($user);
  187. print __METHOD__." id=".$localobject->id." result=".$result."\n";
  188. $this->assertLessThan($result, 0);
  189. return $localobject;
  190. }
  191. /**
  192. * testExpenseReportApprove
  193. *
  194. * @param ExpenseReport $localobject ExpenseReport
  195. * @return void
  196. *
  197. * @depends testExpenseReportValid
  198. * The depends says test is run only if previous is ok
  199. */
  200. public function testExpenseReportApprove($localobject)
  201. {
  202. global $conf,$user,$langs,$db;
  203. $conf=$this->savconf;
  204. $user=$this->savuser;
  205. $langs=$this->savlangs;
  206. $db=$this->savdb;
  207. $result=$localobject->setApproved($user);
  208. print __METHOD__." id=".$localobject->id." result=".$result."\n";
  209. $this->assertLessThan($result, 0);
  210. return $localobject;
  211. }
  212. /**
  213. * testExpenseReportCancel
  214. *
  215. * @param ExpenseReport $localobject ExpenseReport
  216. * @return void
  217. *
  218. * @depends testExpenseReportApprove
  219. * The depends says test is run only if previous is ok
  220. */
  221. public function testExpenseReportCancel($localobject)
  222. {
  223. global $conf,$user,$langs,$db;
  224. $conf=$this->savconf;
  225. $user=$this->savuser;
  226. $langs=$this->savlangs;
  227. $db=$this->savdb;
  228. $result=$localobject->set_cancel($user, 'Because...');
  229. print __METHOD__." id=".$localobject->id." result=".$result."\n";
  230. $this->assertLessThan($result, 0);
  231. return $localobject;
  232. }
  233. /**
  234. * testExpenseReportOther
  235. *
  236. * @param ExpenseReport $localobject ExpenseReport
  237. * @return void
  238. *
  239. * @depends testExpenseReportCancel
  240. * The depends says test is run only if previous is ok
  241. */
  242. public function testExpenseReportOther($localobject)
  243. {
  244. global $conf,$user,$langs,$db;
  245. $conf=$this->savconf;
  246. $user=$this->savuser;
  247. $langs=$this->savlangs;
  248. $db=$this->savdb;
  249. $result=$localobject->getSumPayments();
  250. print __METHOD__." id=".$localobject->id." result=".$result."\n";
  251. $this->assertGreaterThanOrEqual(0, $result);
  252. return $localobject->id;
  253. }
  254. /**
  255. * testExpenseReportDelete
  256. *
  257. * @param int $id Id of order
  258. * @return void
  259. *
  260. * @depends testExpenseReportOther
  261. * The depends says test is run only if previous is ok
  262. */
  263. public function testExpenseReportDelete($id)
  264. {
  265. global $conf,$user,$langs,$db;
  266. $conf=$this->savconf;
  267. $user=$this->savuser;
  268. $langs=$this->savlangs;
  269. $db=$this->savdb;
  270. $localobject=new ExpenseReport($db);
  271. $result=$localobject->fetch($id);
  272. $result=$localobject->delete($user);
  273. print __METHOD__." id=".$id." result=".$result."\n";
  274. $this->assertGreaterThan(0, $result);
  275. return $result;
  276. }
  277. }