git.tine20.org Git - tine20/blob - tests/tine20/Sales/InvoiceControllerTests.php

   1 <?php
   2 /**
   3  * Tine 2.0 - http://www.tine20.org
   4  *
   5  * @package     Sales
   6  * @license     http://www.gnu.org/licenses/agpl.html
   7  * @copyright   Copyright (c) 2014 Metaways Infosystems GmbH (http://www.metaways.de)
   8  * @author      Alexander Stintzing <a.stintzing@metaways.de>
   9  *
  10  */
  11
  12
  13 /**
  14  * Test class for Sales Invoice Controller
  15  */
  16 class Sales_InvoiceControllerTests extends Sales_InvoiceTestCase
  17 {
  18     protected $_testUser = NULL;
  19
  20     /**
  21      * Runs the test methods of this class.
  22      *
  23      * @access public
  24      * @static
  25      */
  26     public static function main()
  27     {
  28         $suite  = new PHPUnit_Framework_TestSuite('Tine 2.0 Sales Invoice Controller Tests');
  29         PHPUnit_TextUI_TestRunner::run($suite);
  30     }
  31
  32     /**
  33      * (non-PHPdoc)
  34      * @see TestCase::tearDown()
  35      */
  36     protected function tearDown()
  37     {
  38         // switch back to admin user
  39         if ($this->_testUser) {
  40             Tinebase_Core::set(Tinebase_Core::USER, $this->_testUser);
  41         }
  42
  43         parent::tearDown();
  44
  45     }
  46
  47     protected function _createFailingContracts()
  48     {
  49         // add contract not to bill
  50         $this->_contractRecords->addRecord($this->_contractController->create(new Sales_Model_Contract(array(
  51             'number'       => 5,
  52             'title'        => Tinebase_Record_Abstract::generateUID(),
  53             'description'  => '5 unittest no auto',
  54             'container_id' => $this->_sharedContractsContainerId,
  55             'billing_address_id' => $this->_addressRecords->filter('customer_id', $this->_customerRecords->filter('name', 'Customer3')->getFirstRecord()->getId())->filter('type', 'billing')->getFirstRecord()->getId(),
  56             'start_date' => $this->_referenceDate,
  57             'end_date' => NULL,
  58         ))));
  59
  60         // add contract without customer
  61         $contract = new Sales_Model_Contract(array(
  62             'number'       => 6,
  63             'title'        => Tinebase_Record_Abstract::generateUID(),
  64             'description'  => '6 unittest auto not possible',
  65             'container_id' => $this->_sharedContractsContainerId,
  66             'start_date' => $this->_referenceDate,
  67             'end_date' => NULL,
  68             'billing_address_id' => $this->_addressRecords->filter('customer_id', $this->_customerRecords->filter('name', 'Customer3')->getFirstRecord()->getId())->filter('type', 'billing')->getFirstRecord()->getId(),
  69         ));
  70
  71         $contract->relations = array(
  72             array(
  73                 'own_model'              => 'Sales_Model_Contract',
  74                 'own_backend'            => Tasks_Backend_Factory::SQL,
  75                 'own_id'                 => NULL,
  76                 'own_degree'             => Tinebase_Model_Relation::DEGREE_SIBLING,
  77                 'related_model'          => 'Sales_Model_CostCenter',
  78                 'related_backend'        => Tasks_Backend_Factory::SQL,
  79                 'related_id'             => $this->_costcenterRecords->getFirstRecord()->getId(),
  80                 'type'                   => 'LEAD_COST_CENTER'
  81             ),
  82         );
  83
  84         $this->_contractRecords->addRecord($this->_contractController->create($contract));
  85
  86         // add contract without address
  87         $contract = new Sales_Model_Contract(array(
  88             'number'       => 7,
  89             'title'        => Tinebase_Record_Abstract::generateUID(),
  90             'description'  => '7 unittest auto not possible',
  91             'container_id' => $this->_sharedContractsContainerId,
  92             'start_date' => $this->_referenceDate,
  93             'end_date' => NULL,
  94         ));
  95
  96         $this->_contractRecords->addRecord($this->_contractController->create($contract));
  97     }
  98
  99     /**
 100      * tests auto invoice creation
 101      */
 102     public function testFullAutoInvoice()
 103     {
 104         $this->markTestSkipped('0010492: fix failing invoices and timetracker tests');
 105
 106         $this->_createFullFixtures();
 107         $this->_createFailingContracts();
 108
 109         $this->assertEquals(7, $this->_contractRecords->count());
 110
 111         $date = clone $this->_referenceDate;
 112
 113         $i = 0;
 114
 115         // the whole year, 12 months
 116         while ($i < 12) {
 117             $result = $this->_invoiceController->createAutoInvoices($date);
 118             $date->addMonth(1);
 119             $i++;
 120         }
 121
 122         $this->assertEquals(6, count($result['failures']));
 123
 124         $failures = '';
 125         foreach($result['failures'] as $failure) {
 126             $failures .= $failure;
 127         }
 128
 129         $this->assertTrue(strstr($failures, 'no customer') !== FALSE);
 130         $this->assertTrue(strstr($failures, 'no billing') !== FALSE);
 131         $this->assertTrue(strstr($failures, 'no costcenter') !== FALSE);
 132
 133         // also add an hour to get the last end
 134         $date->addHour(1);
 135         $this->_invoiceController->createAutoInvoices($date);
 136         $date->addHour(1);
 137         $this->_invoiceController->createAutoInvoices($date);
 138
 139         $all = $this->_invoiceController->getAll();
 140
 141         $cc1 = $this->_costcenterRecords->filter('remark', 'unittest1')->getFirstRecord();
 142         $cc2 = $this->_costcenterRecords->filter('remark', 'unittest2')->getFirstRecord();
 143         $cc3 = $this->_costcenterRecords->filter('remark', 'unittest3')->getFirstRecord();
 144         $cc4 = $this->_costcenterRecords->filter('remark', 'unittest4')->getFirstRecord();
 145
 146         $all->setTimezone(Tinebase_Core::getUserTimezone());
 147
 148         $customer1Invoices = $all->filter('costcenter_id', $cc1->getId())->sort('start_date');
 149         $customer2Invoices = $all->filter('costcenter_id', $cc2->getId())->sort('start_date');
 150         $customer3Invoices = $all->filter('costcenter_id', $cc3->getId())->sort('start_date');
 151         $customer4Invoices = $all->filter('costcenter_id', $cc4->getId())->sort('start_date');
 152
 153         // customer 1 must have one invoice (timeaccount with budget has been billed the first month)
 154         $this->assertEquals(1, $customer1Invoices->count(), 'Customer 1 must have 1 invoice!');
 155
 156         // customer 2 must have one invoice (timeaccount with budget has been billed the first time)
 157         $this->assertEquals(1, $customer2Invoices->count(), 'Customer 2 must have 1 invoice!');
 158
 159         // there are timesheets in 2 intervals, so no empty invoice should be generated
 160         $this->assertEquals(2, $customer3Invoices->count(), 'Customer 3 must have 2 invoices!');
 161
 162         // there are 2 products, interval 3,6 -> so every quarter in this year and the first of next year must be found
 163         $this->assertEquals(5, $customer4Invoices->count(), 'Customer 4 must have 5 invoices!');
 164
 165         // test invoice positions
 166         $allInvoicePositions = Sales_Controller_InvoicePosition::getInstance()->getAll();
 167
 168         $this->assertEquals(1, $allInvoicePositions->filter('invoice_id', $customer1Invoices->getFirstRecord()->getId())->count());
 169         $this->assertEquals(1, $allInvoicePositions->filter('invoice_id', $customer2Invoices->getFirstRecord()->getId())->count());
 170
 171         // each invoice should contain 1 timeaccount
 172         foreach($customer3Invoices as $ci) {
 173             $this->assertEquals(1, $allInvoicePositions->filter('invoice_id', $ci->getId())->count());
 174         }
 175
 176         // we need 9,3,9,3,9 invoice positions
 177         $i = 1;
 178         foreach($customer4Invoices as $ci) {
 179             $ip = $allInvoicePositions->filter('invoice_id', $ci->getId());
 180             $this->assertEquals(($i % 2 == 1) ? 9 : 3, $ip->count());
 181             $i++;
 182         }
 183
 184         // contract 1 gets billed at the begin of the period
 185         $c1IArray = $customer1Invoices->start_date;
 186
 187         $this->assertEquals($this->_referenceYear . '-01-01 00:00:00', $c1IArray[0]->toString());
 188
 189         $c1IArray = $customer1Invoices->end_date;
 190         $this->assertEquals($this->_referenceYear . '-01-31 23:59:59', $c1IArray[0]->toString());
 191
 192         // contract 2 gets billed at the end of the period, and the second period ends at 1.8.20xx
 193         $c2IsArray = $customer2Invoices->start_date;
 194         $c2IeArray = $customer2Invoices->end_date;
 195
 196         $this->assertEquals($this->_referenceYear . '-05-01 00:00:00', $c2IsArray[0]->toString());
 197         $this->assertEquals($this->_referenceYear . '-05-31 23:59:59', $c2IeArray[0]->toString());
 198
 199         // test correct timesheet handling of customer 3
 200         $c3IsArray = $customer3Invoices->start_date;
 201         $c3IeArray = $customer3Invoices->end_date;
 202
 203         $this->assertEquals($this->_referenceYear . '-05-01 00:00:00', $c3IsArray[0]->toString());
 204         $this->assertEquals($this->_referenceYear . '-05-31 23:59:59', $c3IeArray[0]->toString());
 205
 206         $this->assertEquals($this->_referenceYear . '-09-01 00:00:00', $c3IsArray[1]->toString());
 207         $this->assertEquals($this->_referenceYear . '-09-30 23:59:59', $c3IeArray[1]->toString());
 208
 209         // test customer 4 having products only
 210         $c4IsArray = $customer4Invoices->start_date;
 211         $c4IeArray = $customer4Invoices->end_date;
 212
 213         // should contain billeachquarter & billhalfyearly
 214         $this->assertEquals($this->_referenceYear . '-01-01 00:00:00', $c4IsArray[0]->toString());
 215         $this->assertEquals($this->_referenceYear . '-06-30 23:59:59', $c4IeArray[0]->toString());
 216
 217         // should contain billeachquarter
 218         $this->assertEquals($this->_referenceYear . '-04-01 00:00:00', $c4IsArray[1]->toString());
 219         $this->assertEquals($this->_referenceYear . '-06-30 23:59:59', $c4IeArray[1]->toString());
 220
 221         // should contain billeachquarter & billhalfyearly
 222         $this->assertEquals($this->_referenceYear . '-07-01 00:00:00', $c4IsArray[2]->toString());
 223         $this->assertEquals($this->_referenceYear . '-12-31 23:59:59', $c4IeArray[2]->toString());
 224
 225         // should contain billeachquarter
 226         $this->assertEquals($this->_referenceYear . '-10-01 00:00:00', $c4IsArray[3]->toString());
 227         $this->assertEquals($this->_referenceYear . '-12-31 23:59:59', $c4IeArray[3]->toString());
 228
 229         // look if hours of timesheets gets calculated properly
 230         $c3Invoice = $customer3Invoices->getFirstRecord();
 231         $filter = new Sales_Model_InvoicePositionFilter(array());
 232         $filter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'invoice_id', 'operator' => 'equals', 'value' => $c3Invoice->getId())));
 233         $c3InvoicePositions = Sales_Controller_InvoicePosition::getInstance()->search($filter);
 234
 235         $this->assertEquals(1, $c3InvoicePositions->count());
 236         $this->assertEquals(3.5, $c3InvoicePositions->getFirstRecord()->quantity);
 237
 238         $invoice = $customer1Invoices->getFirstRecord();
 239         $invoice->relations = Tinebase_Relations::getInstance()->getRelations('Sales_Model_Invoice', 'Sql', $invoice->getId())->toArray();
 240
 241         $filter = new Sales_Model_InvoicePositionFilter(array());
 242         $filter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'invoice_id', 'operator' => 'equals', 'value' => $invoice['id'])));
 243         $invoice->positions = Sales_Controller_InvoicePosition::getInstance()->search($filter);
 244
 245         $invoice->cleared = 'CLEARED';
 246         $invoice = $this->_invoiceController->update($invoice);
 247
 248         // check correct number generation
 249         $this->assertEquals("R-00001", $invoice->number);
 250
 251         $invoice = $customer2Invoices->getFirstRecord();
 252         $invoice->relations = Tinebase_Relations::getInstance()->getRelations('Sales_Model_Invoice', 'Sql', $invoice->getId())->toArray();
 253         $filter = new Sales_Model_InvoicePositionFilter(array());
 254         $filter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'invoice_id', 'operator' => 'equals', 'value' => $invoice['id'])));
 255         $invoice->positions = Sales_Controller_InvoicePosition::getInstance()->search($filter);
 256
 257         $invoice->cleared = 'CLEARED';
 258         $invoice = $this->_invoiceController->update($invoice);
 259
 260         $this->assertEquals("R-00002", $invoice->number);
 261
 262         // check disallow editing invoice after clearing
 263         $invoice->credit_term = 20;
 264         $this->setExpectedException('Sales_Exception_InvoiceAlreadyClearedEdit');
 265
 266         $this->_invoiceController->update($invoice);
 267     }
 268
 269     public function testDeleteInvoice()
 270     {
 271         $this->_createFullFixtures();
 272
 273         $date = clone $this->_referenceDate;
 274         $date->addMonth(12);
 275
 276         $this->_invoiceController->createAutoInvoices($date);
 277
 278         $paController = Sales_Controller_ProductAggregate::getInstance();
 279         $productAggregates = $paController->getAll();
 280         $contracts = $this->_contractController->getAll();
 281         $contracts->sort('id', 'DESC');
 282
 283         $c1 = $contracts->getFirstRecord();
 284
 285         $this->assertEquals(5, $productAggregates->count());
 286
 287         $taController = Timetracker_Controller_Timeaccount::getInstance();
 288         $tsController = Timetracker_Controller_Timesheet::getInstance();
 289
 290         $allTimesheets = $tsController->getAll();
 291         $allTimeaccounts = $taController->getAll();
 292
 293         foreach($allTimesheets as $ts) {
 294             $this->assertTrue($ts->invoice_id != NULL);
 295         }
 296
 297         foreach($allTimeaccounts as $ta) {
 298             if (intval($ta->budget) == 0) {
 299                 $this->assertTrue($ta->invoice_id == NULL);
 300             }
 301         }
 302
 303         $allInvoices = $this->_invoiceController->getAll('start_date', 'DESC');
 304         $this->assertEquals(9, $allInvoices->count(), print_r($allInvoices->toArray(), 1));
 305
 306         foreach($allInvoices as $invoice) {
 307             $this->_invoiceController->delete($invoice);
 308         }
 309
 310         $allTimesheets = $tsController->getAll();
 311         $allTimeaccounts = $taController->getAll();
 312
 313         foreach($allTimeaccounts as $ta) {
 314             if (intval($ta->budget) == 0) {
 315                 $this->assertTrue($ta->invoice_id == NULL, print_r($ta->toArray(), 1));
 316             }
 317         }
 318
 319         foreach($allTimesheets as $ts) {
 320             $this->assertTrue($ts->invoice_id == NULL, print_r($ts->toArray(), 1));
 321         }
 322     }
 323
 324     protected function _createInvoiceUpdateRecreationFixtures($createTimesheet = true)
 325     {
 326         $this->_createFullFixtures();
 327
 328         // we dont want this contract 1 to be part of the runs below, move it out of the way
 329         $this->_contractRecords->getByIndex(0)->start_date->addMonth(12);
 330         Sales_Controller_Contract::getInstance()->update($this->_contractRecords->getByIndex(0));
 331
 332         $date = clone $this->_referenceDate;
 333         $customer4Timeaccount = $this->_timeaccountRecords->filter('title', 'TA-for-Customer4')->getFirstRecord();
 334         $customer4Timeaccount->status = 'to bill';
 335         $customer4Timeaccount->budget = NULL;
 336
 337         if (null === $this->_timesheetController)
 338             $this->_timesheetController = Timetracker_Controller_Timesheet::getInstance();
 339         if (null === $this->_timeaccountController)
 340             $this->_timeaccountController = Timetracker_Controller_Timeaccount::getInstance();
 341         $this->_timeaccountController->update($customer4Timeaccount);
 342
 343         // this is a ts on 20xx-03-18
 344         $this->sharedTimesheet = new Timetracker_Model_Timesheet(array(
 345             'account_id' => Tinebase_Core::getUser()->getId(),
 346             'timeaccount_id' => $customer4Timeaccount->getId(),
 347             'start_date' => $date->addMonth(2)->addDay(17),
 348             'duration' => 120,
 349             'description' => 'ts from ' . (string) $date,
 350         ));
 351         if (true === $createTimesheet)
 352             $this->_timesheetController->create($this->sharedTimesheet);
 353
 354         //run autoinvoicing with 20xx-04-01
 355         $date = clone $this->_referenceDate;
 356         $date->addMonth(3);
 357         $result = $this->_invoiceController->createAutoInvoices($date);
 358         $this->assertEquals(2, count($result['created']));
 359
 360         return $result;
 361     }
 362
 363     public function testInvoiceRecreation()
 364     {
 365         $this->markTestSkipped('FIXME: this fails randomly :(');
 366
 367         $result = $this->_createInvoiceUpdateRecreationFixtures();
 368
 369         $oldInvoiceId0 = $result['created'][0];
 370         $ipc = Sales_Controller_InvoicePosition::getInstance();
 371         $f = new Sales_Model_InvoicePositionFilter(array(
 372             array('field' => 'invoice_id', 'operator' => 'AND', 'value' => array(
 373                 array('field' => 'id', 'operator' => 'equals', 'value' => $oldInvoiceId0),
 374             )),
 375         ));
 376         $positions = $ipc->search($f);
 377         $this->assertEquals(9, $positions->count());
 378
 379         $oldInvoiceId1 = $result['created'][1];
 380         $ipc = Sales_Controller_InvoicePosition::getInstance();
 381         $f = new Sales_Model_InvoicePositionFilter(array(
 382             array('field' => 'invoice_id', 'operator' => 'AND', 'value' => array(
 383                 array('field' => 'id', 'operator' => 'equals', 'value' => $oldInvoiceId1),
 384             )),
 385         ));
 386         $positions = $ipc->search($f);
 387         $this->assertEquals(4, $positions->count());
 388
 389         $contract4 = $this->_contractRecords->getByIndex(3);
 390         $filter = new Sales_Model_ProductAggregateFilter(
 391             array(
 392                 array('field' => 'interval', 'operator' => 'equals', 'value' => 3),
 393                 //array('field' => 'contract_id', 'operator' => 'equals', 'value' => $this->_contractRecords->getByIndex(3)->getId()),
 394             ), 'AND');
 395         $filter->addFilter(new Tinebase_Model_Filter_ForeignId(//ExplicitRelatedRecord(
 396             array('field' => 'contract_id', 'operator' => 'AND', 'value' =>
 397                 array(
 398                     array(
 399                         'field' =>  ':id', 'operator' => 'equals', 'value' => $contract4->getId()
 400                     )
 401                 ),
 402                 'options' => array(
 403                     'controller'        => 'Sales_Controller_Contract',
 404                     'filtergroup'       => 'Sales_Model_ContractFilter',
 405                     //'own_filtergroup'   => 'Sales_Model_ProductAggregateFilter',
 406                     //'own_controller'    => 'Sales_Controller_ProductAggregate',
 407                     //'related_model'     => 'Sales_Model_Contract',
 408                     'modelName' => 'Sales_Model_Contract',
 409                 ),
 410             )
 411         ));
 412
 413         $pA = Sales_Controller_ProductAggregate::getInstance()->search($filter);
 414         $this->assertEquals(1, $pA->count());
 415         $pA = $pA->getFirstRecord();
 416         $pA->interval = 4;
 417         Sales_Controller_ProductAggregate::getInstance()->update($pA);
 418         $contract4->title = $contract4->getTitle() . ' changed';
 419         sleep(1);
 420         $this->_contractController->update($contract4);
 421
 422         $this->sharedTimesheet->id = NULL;
 423         $this->_timesheetController->create($this->sharedTimesheet);
 424
 425         $result = $this->_invoiceController->checkForContractOrInvoiceUpdates();
 426         $this->assertEquals(true, (count($result)===2||count($result)===3));
 427
 428         $mapping = $this->_invoiceController->getAutoInvoiceRecreationResults();
 429         $this->assertEquals(true, isset($mapping[$oldInvoiceId0]));
 430         $this->assertEquals(true, isset($mapping[$oldInvoiceId1]));
 431         $newInvoiceId0 = $mapping[$oldInvoiceId0];
 432         $newInvoiceId1 = $mapping[$oldInvoiceId1];
 433         $this->assertNotEquals($oldInvoiceId0, $newInvoiceId0);
 434         $this->assertNotEquals($oldInvoiceId1, $newInvoiceId1);
 435
 436         $this->_checkInvoiceUpdateExistingTimeaccount($newInvoiceId1);
 437
 438         $f = new Sales_Model_InvoicePositionFilter(array(
 439             array('field' => 'invoice_id', 'operator' => 'AND', 'value' => array(
 440                 array('field' => 'id', 'operator' => 'equals', 'value' => $newInvoiceId0),
 441             )),
 442         ));
 443         $positions = $ipc->search($f);
 444         $this->assertEquals(10, $positions->count());
 445
 446         $f = new Sales_Model_InvoicePositionFilter(array(
 447             array('field' => 'invoice_id', 'operator' => 'AND', 'value' => array(
 448                 array('field' => 'id', 'operator' => 'equals', 'value' => $newInvoiceId1),
 449             )),
 450         ));
 451         $positions = $ipc->search($f);
 452         $this->assertEquals(1, $positions->count());
 453     }
 454
 455     /**
 456      *
 457      */
 458     public function testInvoiceUpdateExistingTimeaccount()
 459     {
 460         $result = $this->_createInvoiceUpdateRecreationFixtures();
 461
 462         $this->sharedTimesheet->id = NULL;
 463         $this->_timesheetController->create($this->sharedTimesheet);
 464
 465         $maybeRecreated = $this->_invoiceController->checkForUpdate($result['created'][1]);
 466         if (isset($maybeRecreated[0])) {
 467             $result = $maybeRecreated;
 468         } else {
 469             $result = array($result['created'][1]);
 470         }
 471
 472         $this->_checkInvoiceUpdateExistingTimeaccount($result[0]);
 473
 474         //check that the same update run doesnt do anything anymore
 475         $maybeRecreated = $this->_invoiceController->checkForUpdate($result[0]);
 476         if (isset($maybeRecreated[0])) {
 477             $result = $maybeRecreated;
 478         }
 479
 480         $this->_checkInvoiceUpdateExistingTimeaccount($result[0]);
 481     }
 482
 483     public function testCheckForContractOrInvoiceUpdatesExistingTimeaccount()
 484     {
 485         $result = $this->_createInvoiceUpdateRecreationFixtures();
 486
 487         $this->sharedTimesheet->id = NULL;
 488         $this->_timesheetController->create($this->sharedTimesheet);
 489
 490         $maybeRecreated = $this->_invoiceController->checkForContractOrInvoiceUpdates();
 491         if (isset($maybeRecreated[0])) {
 492             $result = $maybeRecreated;
 493         } else {
 494             $result = array($result['created'][1]);
 495         }
 496
 497         $this->_checkInvoiceUpdateExistingTimeaccount($result[0]);
 498
 499         $maybeRecreated = $this->_invoiceController->checkForContractOrInvoiceUpdates();
 500         if (isset($maybeRecreated[0])) {
 501             $result = $maybeRecreated;
 502         }
 503
 504         $this->_checkInvoiceUpdateExistingTimeaccount($result[0]);
 505     }
 506
 507     protected function _checkInvoiceUpdateExistingTimeaccount($invoiceId, $result = 4)
 508     {
 509         $ipc = Sales_Controller_InvoicePosition::getInstance();
 510         $f = new Sales_Model_InvoicePositionFilter(array(
 511             array('field' => 'model', 'operator' => 'equals', 'value' => 'Timetracker_Model_Timeaccount'),
 512             array('field' => 'invoice_id', 'operator' => 'AND', 'value' => array(
 513                 array('field' => 'id', 'operator' => 'equals', 'value' => $invoiceId),
 514             )),
 515         ));
 516         $positions = $ipc->search($f);
 517         $this->assertEquals(1, $positions->count());
 518         $this->assertEquals($result, $positions->getFirstRecord()->quantity);
 519     }
 520
 521     public function testCheckForContractOrInvoiceUpdatesWithUpdatedTimesheet()
 522     {
 523         $result = $this->_createInvoiceUpdateRecreationFixtures();
 524
 525         $this->sharedTimesheet->id = NULL;
 526         $this->sharedTimesheet = $this->_timesheetController->create($this->sharedTimesheet);
 527
 528         $maybeRecreated = $this->_invoiceController->checkForContractOrInvoiceUpdates();
 529         if (isset($maybeRecreated[0])) {
 530             $result = $maybeRecreated;
 531         } else {
 532             $result = array($result['created'][1]);
 533         }
 534
 535         $this->assertEquals(true, isset($result[0]));
 536
 537         $this->_checkInvoiceUpdateExistingTimeaccount($result[0]);
 538
 539         sleep(1);
 540
 541         $this->sharedTimesheet->duration = 180;
 542         $this->sharedTimesheet = $this->_timesheetController->update($this->sharedTimesheet);
 543
 544         $maybeRecreated = $this->_invoiceController->checkForContractOrInvoiceUpdates();
 545         if (isset($maybeRecreated[0])) {
 546             $result = $maybeRecreated;
 547         }
 548
 549         $this->_checkInvoiceUpdateExistingTimeaccount($result[0], 5);
 550     }
 551
 552     protected function _checkInvoiceUpdateWithNewTimeaccount($invoiceId)
 553     {
 554         $ipc = Sales_Controller_InvoicePosition::getInstance();
 555         $f = new Sales_Model_InvoicePositionFilter(array(
 556             array('field' => 'model', 'operator' => 'equals', 'value' => 'Timetracker_Model_Timeaccount'),
 557             array('field' => 'invoice_id', 'operator' => 'AND', 'value' => array(
 558                 array('field' => 'id', 'operator' => 'equals', 'value' => $invoiceId),
 559             )),
 560         ));
 561         $positions = $ipc->search($f);
 562         $this->assertEquals(1, $positions->count());
 563         $this->assertEquals(2, $positions->getFirstRecord()->quantity);
 564     }
 565     /**
 566      *
 567      */
 568     public function testInvoiceUpdateWithNewTimeaccount()
 569     {
 570         $result = $this->_createInvoiceUpdateRecreationFixtures(false);
 571
 572         $this->_timesheetController->create($this->sharedTimesheet);
 573
 574         $maybeRecreated = $this->_invoiceController->checkForUpdate($result['created'][1]);
 575         if (isset($maybeRecreated[0])) {
 576             $result = $maybeRecreated;
 577         } else {
 578             $result = array($result['created'][1]);
 579         }
 580
 581         $this->_checkInvoiceUpdateWithNewTimeaccount($result[0]);
 582
 583         //check that the same update run doesnt do anything anymore
 584         $maybeRecreated = $this->_invoiceController->checkForUpdate($result[0]);
 585         if (isset($maybeRecreated[0])) {
 586             $result = $maybeRecreated;
 587         }
 588
 589         $this->_checkInvoiceUpdateWithNewTimeaccount($result[0]);
 590     }
 591
 592     public function testCheckForContractOrInvoiceUpdatesWithNewTimeaccount()
 593     {
 594         $result = $this->_createInvoiceUpdateRecreationFixtures(false);
 595
 596         $this->_timesheetController->create($this->sharedTimesheet);
 597
 598         $maybeRecreated = $this->_invoiceController->checkForContractOrInvoiceUpdates();
 599         if (isset($maybeRecreated[0])) {
 600             $result = $maybeRecreated;
 601         } else {
 602             $result = array($result['created'][1]);
 603         }
 604
 605         $this->_checkInvoiceUpdateWithNewTimeaccount($result[0]);
 606
 607         $maybeRecreated = $this->_invoiceController->checkForContractOrInvoiceUpdates();
 608         if (isset($maybeRecreated[0])) {
 609             $result = $maybeRecreated;
 610         }
 611
 612         $this->_checkInvoiceUpdateWithNewTimeaccount($result[0]);
 613     }
 614
 615     /**
 616      * @see: rt127444
 617      *
 618      * make sure timeaccounts won't be billed if they shouldn't
 619      */
 620     public function testBudgetTimeaccountBilled()
 621     {
 622         $this->_createFullFixtures();
 623
 624         $date = clone $this->_referenceDate;
 625         $i = 0;
 626
 627         // do not set to bill, this ta has a budget
 628         $customer1Timeaccount = $this->_timeaccountRecords->filter('title', 'TA-for-Customer1')->getFirstRecord();
 629         $customer1Timeaccount->status = 'not yet billed';
 630
 631         $tsController = Timetracker_Controller_Timesheet::getInstance();
 632         $taController = Timetracker_Controller_Timeaccount::getInstance();
 633         $taController->update($customer1Timeaccount);
 634
 635         // this is a ts on 20xx-01-18
 636         $timesheet = new Timetracker_Model_Timesheet(array(
 637             'account_id' => Tinebase_Core::getUser()->getId(),
 638             'timeaccount_id' => $customer1Timeaccount->getId(),
 639             'start_date' => $date->addDay(17),
 640             'duration' => 120,
 641             'description' => 'ts from ' . (string) $date,
 642         ));
 643
 644         $tsController->create($timesheet);
 645
 646         // this is a ts on 20xx-02-03
 647         $timesheet->id = NULL;
 648         $timesheet->start_date  = $date->addDay(17);
 649         $timesheet->description = 'ts from ' . (string) $date;
 650
 651         $tsController->create($timesheet);
 652
 653         $date = clone $this->_referenceDate;
 654         $date->addMonth(1);
 655
 656         $result = $this->_invoiceController->createAutoInvoices($date);
 657
 658         $this->assertEquals(1, count($result['created']));
 659
 660         $customer1Timeaccount->status = 'to bill';
 661         $taController->update($customer1Timeaccount);
 662
 663         $date->addSecond(1);
 664
 665         $result = $this->_invoiceController->createAutoInvoices($date);
 666         $this->assertEquals(1, count($result['created']));
 667
 668         $invoiceId = $result['created'][0];
 669         $invoice = $this->_invoiceController->get($invoiceId);
 670         $found = FALSE;
 671
 672         foreach($invoice->relations as $relation) {
 673             if ($relation->related_model == 'Timetracker_Model_Timeaccount') {
 674                 $this->assertEquals('TA-for-Customer1',     $relation->related_record->title);
 675                 $found = TRUE;
 676             }
 677         }
 678
 679         $this->assertTrue($found, 'the timeaccount could not be found in the invoice!');
 680     }
 681
 682
 683     /**
 684      * tests if the rights work: Sales_Acl_Rights::SET_INVOICE_NUMBER, Sales_Acl_Rights::MANAGE_INVOICES
 685      */
 686     public function testSetManualNumberRight()
 687     {
 688         $this->_createCustomers();
 689         $this->_createCostCenters();
 690
 691         $customer = $this->_customerRecords->filter('name', 'Customer1')->getFirstRecord();
 692         $invoice = $this->_invoiceController->create(new Sales_Model_Invoice(array(
 693             'number' => 'R-3000',
 694             'customer_id' => $customer->getId(),
 695             'description' => 'Manual',
 696             'address_id' => $this->_addressRecords->filter('customer_id', $customer->getId())->getFirstRecord()->getId(),
 697             'costcenter_id' => $this->_costcenterRecords->getFirstRecord()->getId()
 698         )));
 699
 700         // fetch user group
 701         $group   = Tinebase_Group::getInstance()->getGroupByName('Users');
 702         $groupId = $group->getId();
 703
 704         // create new user
 705         $user = new Tinebase_Model_FullUser(array(
 706             'accountLoginName'      => 'testuser',
 707             'accountPrimaryGroup'   => $groupId,
 708             'accountDisplayName'    => 'Test User',
 709             'accountLastName'       => 'User',
 710             'accountFirstName'      => 'Test',
 711             'accountFullName'       => 'Test User',
 712             'accountEmailAddress'   => 'unittestx8@tine20.org',
 713         ));
 714
 715         $user = Admin_Controller_User::getInstance()->create($user, 'pw', 'pw');
 716         $this->_testUser = Tinebase_Core::getUser();
 717
 718         Tinebase_Core::set(Tinebase_Core::USER, $user);
 719
 720         $e = new Exception('No Message');
 721
 722         try {
 723             $invoice = $this->_invoiceController->create(new Sales_Model_Invoice(array(
 724                 'number' => 'R-3001',
 725                 'customer_id' => $customer->getId(),
 726                 'description' => 'Manual Forbidden',
 727                 'address_id' => $this->_addressRecords->filter('customer_id', $customer->getId())->getFirstRecord()->getId(),
 728                 'costcenter_id' => $this->_costcenterRecords->getFirstRecord()->getId()
 729             )));
 730         } catch (Exception $e) {
 731         }
 732
 733         $this->assertTrue(get_class($e) == 'Tinebase_Exception_AccessDenied');
 734         $this->assertTrue($e->getMessage() == 'You don\'t have the right to manage invoices!');
 735
 736         Tinebase_Core::set(Tinebase_Core::USER, $this->_testUser);
 737
 738         $fe = new Admin_Frontend_Json();
 739         $userRoles = $fe->getRoles('user', array(), array(), 0, 1);
 740         $userRole = $fe->getRole($userRoles['results'][0]['id']);
 741
 742         $roleRights = $fe->getRoleRights($userRole['id']);
 743         $roleMembers = $fe->getRoleMembers($userRole['id']);
 744         $roleMembers['results'][] = array('name' => 'testuser', 'type' => 'user', 'id' => $user->accountId);
 745
 746         $app = Tinebase_Application::getInstance()->getApplicationByName('Sales');
 747
 748         $roleRights['results'][] = array('application_id' => $app->getId(), 'right' => Sales_Acl_Rights::MANAGE_INVOICES);
 749         $fe->saveRole($userRole, $roleMembers['results'], $roleRights['results']);
 750
 751         Tinebase_Core::set(Tinebase_Core::USER, $user);
 752
 753         $e = new Exception('No Message');
 754
 755         try {
 756             $invoice = $this->_invoiceController->create(new Sales_Model_Invoice(array(
 757                 'number' => 'R-3001',
 758                 'customer_id' => $customer->getId(),
 759                 'description' => 'Manual Forbidden',
 760                 'address_id' => $this->_addressRecords->filter('customer_id', $customer->getId())->getFirstRecord()->getId(),
 761                 'costcenter_id' => $this->_costcenterRecords->getFirstRecord()->getId()
 762             )));
 763         } catch (Exception $e) {
 764         }
 765
 766         $this->assertEquals('Tinebase_Exception_AccessDenied', get_class($e));
 767         $this->assertEquals('You have no right to set the invoice number!', $e->getMessage());
 768     }
 769
 770     /**
 771      * tests if a product aggregate gets billed in the correct periods
 772      */
 773     public function testOneProductContractInterval()
 774     {
 775         $startDate = clone $this->_referenceDate;
 776
 777         $this->_createProducts();
 778
 779         $this->_createCustomers(1);
 780         $this->_createCostCenters();
 781
 782         $monthBack = clone $this->_referenceDate;
 783         $monthBack->subMonth(1);
 784         $addressId = $this->_addressRecords->filter(
 785                 'customer_id', $this->_customerRecords->filter(
 786                     'name', 'Customer1')->getFirstRecord()->getId())->filter(
 787                         'type', 'billing')->getFirstRecord()->getId();
 788
 789         $this->assertTrue($addressId !== NULL);
 790
 791         // this contract begins 6 months before the first invoice will be created
 792         $this->_createContracts(array(array(
 793             'number'       => 100,
 794             'title'        => 'MyContract',
 795             'description'  => 'unittest',
 796             'container_id' => $this->_sharedContractsContainerId,
 797             'billing_point' => 'begin',
 798             'billing_address_id' => $addressId,
 799
 800             'interval' => 1,
 801             'start_date' => $startDate->subMonth(6),
 802             'last_autobill' => clone $this->_referenceDate,
 803             'end_date' => NULL,
 804             'products' => array(
 805                 array('product_id' => $this->_productRecords->getByIndex(0)->getId(), 'quantity' => 1, 'interval' => 1, 'last_autobill' => $monthBack),
 806             )
 807         )));
 808
 809         $startDate = clone $this->_referenceDate;
 810         $startDate->addDay(5);
 811         $startDate->addMonth(24);
 812
 813         $result = $this->_invoiceController->createAutoInvoices($startDate);
 814         $this->assertEquals(25, $result['created_count']);
 815
 816         $invoices = $this->_invoiceController->getAll('start_date');
 817         $firstInvoice = $invoices->getFirstRecord();
 818         $this->assertInstanceOf('Tinebase_DateTime', $firstInvoice->start_date);
 819         $this->assertEquals('0101', $firstInvoice->start_date->format('md'));
 820
 821         $this->assertEquals(25, $invoices->count());
 822
 823         $filter = new Sales_Model_InvoicePositionFilter(array());
 824         $filter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'invoice_id', 'operator' => 'in', 'value' => $invoices->getArrayOfIds())));
 825
 826         $pagination = new Tinebase_Model_Pagination(array('sort' => 'month', 'dir' => 'ASC'));
 827
 828         $invoicePositions = Sales_Controller_InvoicePosition::getInstance()->search($filter, $pagination);
 829
 830         // get sure each invoice positions has the same month as the invoice and the start_date is the first
 831         foreach($invoices as $invoice) {
 832             $month = (int) $invoice->start_date->format('n');
 833             $index = $month - 1;
 834
 835             $this->assertEquals('01', $invoice->start_date->format('d'));
 836             $this->assertEquals($invoice->end_date->format('t'), $invoice->end_date->format('d'), print_r($invoice->toArray(), 1));
 837
 838             $this->assertEquals(1, $invoice->start_date->format('d'));
 839
 840             $pos = $invoicePositions->filter('invoice_id', $invoice->getId())->getFirstRecord();
 841             $this->assertEquals($invoice->start_date->format('Y-m'), $pos->month);
 842             $this->assertEquals($invoice->end_date->format('Y-m'), $pos->month);
 843         }
 844
 845         $this->assertEquals(25, $invoicePositions->count());
 846
 847         $this->assertEquals($this->_referenceYear . '-01', $invoicePositions->getFirstRecord()->month);
 848
 849         $invoicePositions->sort('month', 'DESC');
 850
 851         $this->assertEquals($this->_referenceYear + 2 . '-01', $invoicePositions->getFirstRecord()->month);
 852     }
 853
 854     /**
 855      * test product only contract setting last_autobill and resetting last_autobill on delete
 856      */
 857     public function testLastAutobillAfterDeleteInvoice()
 858     {
 859         $startDate = clone $this->_referenceDate;
 860         $lab = clone $this->_referenceDate;
 861         $lab->subMonth(1);
 862         $this->_createProducts(array(array(
 863             'name' => 'Hours',
 864             'description' => 'timesheets',
 865             'price' => '100',
 866             'accountable' => 'Timetracker_Model_Timeaccount'
 867         )));
 868
 869         $this->_createCustomers(1);
 870         $this->_createCostCenters();
 871
 872         // has budget, is to bill
 873         $ta = $this->_createTimeaccounts(array(array(
 874             'title'         => 'Tacss',
 875             'description'   => 'blabla',
 876             'is_open'       => 1,
 877             'status'        => 'open',
 878             'budget'        => NULL,
 879
 880         )))->getFirstRecord();
 881
 882         // has timeaccount without budget, must be billed at end of the period (each month has at least one timesheet)
 883         $this->_createContracts(array(array(
 884             'number'       => 100,
 885             'title'        => 'MyContract',
 886             'description'  => 'unittest',
 887             'container_id' => $this->_sharedContractsContainerId,
 888             'billing_address_id' => $this->_addressRecords->filter(
 889                 'customer_id', $this->_customerRecords->filter(
 890                     'name', 'Customer1')->getFirstRecord()->getId())->filter(
 891                         'type', 'billing')->getFirstRecord()->getId(),
 892
 893             'start_date' => $startDate,
 894             'last_autobill' => NULL,
 895             'end_date' => NULL,
 896             'products' => array(
 897                 array('product_id' => $this->_productRecords->getByIndex(0)->getId(),
 898                     'quantity' => 1, 'interval' => 1, 'billing_point' => 'end'),
 899             )
 900         )));
 901
 902         // create timesheets
 903         $tsDate = clone $this->_referenceDate;
 904         $tsDate->addDay(10);
 905
 906         $i = 0;
 907         while($i < 12) {
 908             $this->_createTimesheets(array(array(
 909                 'account_id' => Tinebase_Core::getUser()->getId(),
 910                 'timeaccount_id' => $ta->getId(),
 911                 'start_date' => $tsDate,
 912                 'duration' => 105,
 913                 'description' => 'ts from ' . (string) $tsDate,
 914             )));
 915             $tsDate->addMonth(1);
 916             $i++;
 917         }
 918
 919
 920         $contract = $this->_contractController->getAll()->getFirstRecord();
 921         $this->assertEquals($startDate->__toString(), $contract->start_date->__toString());
 922
 923         // find product aggregate
 924         $paController = Sales_Controller_ProductAggregate::getInstance();
 925         $productAggregate = $paController->getAll()->getFirstRecord();
 926         $productAggregate->setTimezone(Tinebase_Core::getUserTimezone());
 927
 928         $this->assertEquals(NULL, $productAggregate->last_autobill);
 929
 930         // create 6 invoices - each month one invoice - last autobill must be increased each month
 931         for ($i = 1; $i < 7; $i++) {
 932             $myDate = clone $this->_referenceDate;
 933             $myDate->addMonth($i)->addHour(3);
 934
 935             $testDate = clone $this->_referenceDate;
 936             $testDate->addMonth($i);
 937
 938             $result = $this->_invoiceController->createAutoInvoices($myDate);
 939             $this->assertEquals(1, $result['created_count']);
 940
 941             $productAggregate = $paController->get($productAggregate->getId());
 942             $productAggregate->setTimezone(Tinebase_Core::getUserTimezone());
 943             $this->assertEquals($testDate, $productAggregate->last_autobill);
 944         }
 945
 946         $testDate = clone $this->_referenceDate;
 947         $testDate->addMonth(6);
 948         $this->assertEquals($testDate, $productAggregate->last_autobill);
 949
 950         // delete all created invoices again
 951         $allInvoices = $this->_invoiceController->getAll('start_date', 'DESC');
 952
 953         foreach($allInvoices as $invoice) {
 954             $this->_invoiceController->delete($invoice);
 955         }
 956
 957         $productAggregate = $paController->get($productAggregate->getId());
 958         $productAggregate->setTimezone(Tinebase_Core::getUserTimezone());
 959
 960         $this->assertEquals($this->_referenceDate, $productAggregate->last_autobill);
 961
 962         // create 6 invoices again - each month one invoice - last autobill must be increased each month
 963         for ($i = 1; $i < 7; $i++) {
 964             $myDate = clone $this->_referenceDate;
 965             $myDate->addMonth($i)->addHour(3);
 966
 967             $testDate = clone $this->_referenceDate;
 968             $testDate->addMonth($i);
 969
 970             $result = $this->_invoiceController->createAutoInvoices($myDate);
 971             $this->assertEquals(1, $result['created_count']);
 972
 973             $productAggregate = $paController->get($productAggregate->getId());
 974             $productAggregate->setTimezone(Tinebase_Core::getUserTimezone());
 975             $this->assertEquals($testDate, $productAggregate->last_autobill);
 976         }
 977
 978         $testDate = clone $this->_referenceDate;
 979         $testDate->addMonth(6);
 980         $this->assertEquals($testDate, $productAggregate->last_autobill);
 981
 982     }
 983
 984     /**
 985      * @see step2 FS0012
 986      *
 987      * products must be billed on the beginning of a period
 988      * the first dates must fit
 989      */
 990     public function testProductWithOneYearInterval()
 991     {
 992         // last year, the 1.1 in usertimezone
 993         $date      = clone $this->_referenceDate;
 994
 995         $startDateContract = clone $this->_referenceDate;
 996         $startDateContract->subMonth(13);
 997
 998         // this has been billed for the last year.
 999         $startDateProduct = clone $this->_referenceDate;
1000         $startDateProduct->subMonth(12);
1001
1002         $this->_createProducts();
1003
1004         $this->_createCustomers(1);
1005         $this->_createCostCenters();
1006
1007         $addressId = $this->_addressRecords->filter(
1008                 'customer_id', $this->_customerRecords->filter(
1009                     'name', 'Customer1')->getFirstRecord()->getId())->filter(
1010                         'type', 'billing')->getFirstRecord()->getId();
1011
1012         // the contract has an interval of 0, but it has to be billed
1013         $this->_createContracts(array(array(
1014             'number'       => 100,
1015             'title'        => 'MyContract',
1016             'description'  => 'unittest',
1017             'container_id' => $this->_sharedContractsContainerId,
1018             'billing_point' => 'begin',
1019             'billing_address_id' => $addressId,
1020             'interval' => 0,
1021             'start_date' => $startDateContract,
1022             'last_autobill' => clone $this->_referenceDate,
1023             'end_date' => NULL,
1024             'products' => array(
1025                 array('product_id' => $this->_productRecords->getByIndex(0)->getId(),
1026                     'quantity' => 1, 'interval' => 12, 'last_autobill' => $startDateProduct),
1027             )
1028         )));
1029
1030         $startDate = clone $this->_referenceDate;
1031         $startDate->addHour(3);
1032
1033         $i=0;
1034
1035         $result = $this->_invoiceController->createAutoInvoices($startDate);
1036         $this->assertEquals(1, $result['created_count']);
1037
1038         $invoice = $this->_invoiceController->get($result['created'][0]);
1039
1040         $invoicePositions = Sales_Controller_InvoicePosition::getInstance()->getAll('month')->filter('invoice_id', $result['created'][0]);
1041         $this->assertEquals(12, $invoicePositions->count());
1042
1043         $i = 1;
1044
1045         foreach($invoicePositions as $ipo) {
1046             $this->assertEquals($this->_referenceYear . '-' . ($i > 9 ? '' : '0') . $i, $ipo->month, print_r($invoicePositions->toArray(), 1));
1047             $this->assertEquals($ipo->invoice_id, $invoice->getId());
1048             $i++;
1049         }
1050     }
1051
1052     /**
1053      * make sure that timesheets get created for the right month
1054      */
1055     public function testTimesheetOnMonthEndAndBegin()
1056     {
1057         $dates = array(
1058             clone $this->_referenceDate,
1059             clone $this->_referenceDate,
1060             clone $this->_referenceDate,
1061             clone $this->_referenceDate
1062         );
1063         // 0: 1.1.xxxx, 1: 31.1.xxxx, 2: 1.2.xxxx, 3: 28/29.2.xxxx
1064         $dates[1]->addMonth(1)->subDay(1);
1065         $dates[2]->addMonth(1);
1066         $dates[3]->addMonth(2)->subDay(1);
1067
1068         $customer = $this->_createCustomers(1)->getFirstRecord();
1069         $this->_createCostCenters();
1070
1071         // has no budget
1072         $ta = $this->_createTimeaccounts(array(array(
1073             'title'         => 'TaTest',
1074             'description'   => 'blabla',
1075             'is_open'       => 1,
1076             'status'        => 'not yet billed',
1077             'budget'        => null
1078         )))->getFirstRecord();
1079
1080         foreach($dates as $date) {
1081             $this->_createTimesheets(array(
1082                 array(
1083                     'account_id' => Tinebase_Core::getUser()->getId(),
1084                     'timeaccount_id' => $ta->getId(),
1085                     'start_date' => $date,
1086                     'duration' => 105,
1087                     'description' => 'ts from ' . (string) $date,
1088                 ))
1089             );
1090         }
1091
1092         $this->assertEquals(4, $this->_timesheetRecords->count());
1093
1094         $csDate = clone $this->_referenceDate;
1095         $csDate->subMonth(10);
1096
1097         $lab = clone $this->_referenceDate;
1098         // set start position (must be manually set on introducing the invoice module)
1099         $lab->subMonth(1);
1100         $this->_createProducts();
1101         $this->_createContracts(array(array(
1102             'number'       => 100,
1103             'title'        => 'MyContract',
1104             'description'  => 'unittest',
1105             'container_id' => $this->_sharedContractsContainerId,
1106             'billing_point' => 'begin',
1107             'billing_address_id' => $this->_addressRecords->filter(
1108                 'customer_id', $customer->getId())->filter(
1109                         'type', 'billing')->getFirstRecord()->getId(),
1110
1111             'start_date' => $csDate,
1112             'end_date' => NULL,
1113             'products' => array(
1114                     array('start_date' => $csDate, 'end_date' => NULL, 'quantity' => 1, 'interval' => 1, 'billing_point' => 'end', 'product_id' => $this->_productRecords->filter('name', 'Hours')->getFirstRecord()->getId()),
1115             )
1116         )));
1117
1118         $json = new Sales_Frontend_Json();
1119
1120         $date = clone $this->_referenceDate;
1121         // this is set by cli if called by cli
1122         $date->setTime(3,0,0);
1123
1124         $result = $this->_invoiceController->createAutoInvoices($date);
1125         $this->assertEquals(0, $result['created_count'], (string) $date);
1126         sleep(1);
1127         $date->addMonth(1);
1128         $result = $this->_invoiceController->createAutoInvoices($date);
1129         $this->assertEquals(1, $result['created_count'], (string) $date);
1130         $invoice1Id = $result['created'][0];
1131         $invoice = $json->getInvoice($invoice1Id);
1132         $this->assertEquals(1, count($invoice['positions']), print_r($invoice['positions'], 1));
1133         sleep(1);
1134         $date->addMonth(1);
1135         $result = $this->_invoiceController->createAutoInvoices($date);
1136         $this->assertEquals(1, $result['created_count'], (string) $date);
1137         $invoice2Id = $result['created'][0];
1138         $invoice = $json->getInvoice($invoice2Id);
1139         $this->assertEquals(1, count($invoice['positions']));
1140         sleep(1);
1141         $date->addMonth(1);
1142         $result = $this->_invoiceController->createAutoInvoices($date);
1143         $this->assertEquals(0, $result['created_count'], (string) $date);
1144
1145         $filter = new Timetracker_Model_TimesheetFilter(array());
1146         $filter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'invoice_id', 'operator' => 'equals', 'value' => $invoice1Id)));
1147         $timesheets = $this->_timesheetController->search($filter);
1148         $this->assertEquals(2, $timesheets->count());
1149
1150         $filter = new Timetracker_Model_TimesheetFilter(array());
1151         $filter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'invoice_id', 'operator' => 'equals', 'value' => $invoice2Id)));
1152         $timesheets = $this->_timesheetController->search($filter);
1153         $this->assertEquals(2, $timesheets->count());
1154
1155         // now try to delete the first invoice, which is not allowed
1156         $this->setExpectedException('Sales_Exception_DeletePreviousInvoice');
1157
1158         $this->_invoiceController->delete(array($invoice1Id));
1159     }
1160
1161     /**
1162      * make sure that timesheets get created for the right month
1163      */
1164     public function test2MonthIntervalTimesheetOnMonthEndAndBegin()
1165     {
1166         $dates = array(
1167             clone $this->_referenceDate,
1168             clone $this->_referenceDate,
1169             clone $this->_referenceDate,
1170             clone $this->_referenceDate
1171         );
1172         // 0: 1.1.xxxx, 1: 31.1.xxxx, 2: 1.2.xxxx, 3: 28/29.2.xxxx
1173         $dates[1]->addMonth(1)->subDay(1);
1174         $dates[2]->addMonth(1);
1175         $dates[3]->addMonth(2)->subDay(1);
1176
1177         // create much more timesheets
1178         $dt = clone $this->_referenceDate;
1179         for ($i = 0; $i < 80; $i++) {
1180             $dt->addHour(12);
1181             $dates[] = clone $dt;
1182         }
1183
1184         $customer = $this->_createCustomers(1)->getFirstRecord();
1185         $this->_createCostCenters();
1186
1187         // has no budget
1188         $ta = $this->_createTimeaccounts(array(array(
1189             'title'         => 'TaTest',
1190             'description'   => 'blabla',
1191             'is_open'       => 1,
1192             'status'        => 'not yet billed',
1193             'budget'        => null
1194         )))->getFirstRecord();
1195
1196         foreach($dates as $date) {
1197             $this->_createTimesheets(array(
1198                 array(
1199                     'account_id' => Tinebase_Core::getUser()->getId(),
1200                     'timeaccount_id' => $ta->getId(),
1201                     'start_date' => $date,
1202                     'duration' => 105,
1203                     'description' => 'ts from ' . (string) $date,
1204                 ))
1205             );
1206         }
1207
1208         $this->assertEquals(84, $this->_timesheetRecords->count());
1209         $this->_createProducts();
1210         $csDate = clone $this->_referenceDate;
1211         $csDate->subMonth(10);
1212
1213         $lab = clone $this->_referenceDate;
1214         $this->_createContracts(array(array(
1215             'number'       => 100,
1216             'title'        => 'MyContract',
1217             'description'  => 'unittest',
1218             'container_id' => $this->_sharedContractsContainerId,
1219             'billing_point' => 'begin',
1220             'billing_address_id' => $this->_addressRecords->filter(
1221                 'customer_id', $customer->getId())->filter(
1222                     'type', 'billing')->getFirstRecord()->getId(),
1223
1224             'start_date' => $csDate,
1225             'end_date' => NULL,
1226             'products' => array(
1227                 array('start_date' => $csDate, 'end_date' => NULL, 'quantity' => 1, 'interval' => 1, 'billing_point' => 'end', 'product_id' => $this->_productRecords->filter('name', 'Hours')->getFirstRecord()->getId())
1228             )
1229         )));
1230
1231         $json = new Sales_Frontend_Json();
1232
1233         $date = clone $this->_referenceDate;
1234         // this is set by cli if called by cli
1235         $date->setTime(3,0,0);
1236
1237         $result = $this->_invoiceController->createAutoInvoices($date);
1238         $this->assertEquals(0, $result['created_count']);
1239
1240         $date->addMonth(1);
1241         $result = $this->_invoiceController->createAutoInvoices($date);
1242         $this->assertEquals(1, $result['created_count']);
1243
1244         $invoice1Id = $result['created'][0];
1245         $filter = new Timetracker_Model_TimesheetFilter(array());
1246         $filter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'invoice_id', 'operator' => 'equals', 'value' => $invoice1Id)));
1247         $timesheets = $this->_timesheetController->search($filter);
1248         $this->assertEquals(63, $timesheets->count());
1249
1250         $date->addMonth(1);
1251         $result = $this->_invoiceController->createAutoInvoices($date);
1252         $this->assertEquals(1, $result['created_count'], (string) $date);
1253         $invoice2Id = $result['created'][0];
1254         $invoice = $json->getInvoice($invoice2Id);
1255         $this->assertEquals(1, count($invoice['positions']));
1256
1257         $date->addMonth(1);
1258         $result = $this->_invoiceController->createAutoInvoices($date);
1259         $this->assertEquals(0, $result['created_count']);
1260
1261         $filter = new Timetracker_Model_TimesheetFilter(array());
1262         $filter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'invoice_id', 'operator' => 'equals', 'value' => $invoice2Id)));
1263         $timesheets = $this->_timesheetController->search($filter);
1264         $this->assertEquals(21, $timesheets->count());
1265     }
1266
1267     /**
1268      * tests new fields
1269      */
1270     public function testManualInvoice()
1271     {
1272         $customer = $this->_createCustomers(1)->getFirstRecord();
1273         $this->_createCostCenters();
1274
1275         $invoice = $this->_invoiceController->create(new Sales_Model_Invoice(array(
1276             'number' => 100,
1277             'description' => 'test',
1278             'address_id' => $this->_addressRecords->getFirstRecord()->getId(),
1279             'costcenter_id' => $this->_costcenterRecords->getFirstRecord()->getId(),
1280             'is_auto' => TRUE,
1281             'price_net' => 200.20,
1282             'price_gross' => 238.45,
1283             'sales_tax' => 19.5
1284         )));
1285
1286         $this->assertEquals(19.5, $invoice->sales_tax);
1287         $this->assertEquals(200.20, $invoice->price_net);
1288         $this->assertEquals(238.45, $invoice->price_gross);
1289     }
1290
1291     /**
1292      * tests if timesheets get resetted properly after deleting the invoice
1293      * and recreate the same invoice again containing the same timesheets
1294      */
1295     public function testDeleteAndRunAgainInvoice()
1296     {
1297         $this->_createFullFixtures();
1298
1299         $date = clone $this->_referenceDate;
1300         $date->addMonth(8);
1301         $i = 0;
1302
1303         $result = $this->_invoiceController->createAutoInvoices($date);
1304
1305         $this->assertEquals(6, count($result['created']));
1306
1307         $tsController = Timetracker_Controller_Timesheet::getInstance();
1308
1309         // get first valid invoice id from all timesheets
1310         $tsInvoiceIds = array_unique($tsController->getAll()->invoice_id);
1311         sort($tsInvoiceIds);
1312         $tsInvoiceIds = array_reverse($tsInvoiceIds);
1313         $this->assertTrue(! empty($tsInvoiceIds[0]));
1314         $myInvoice = $this->_invoiceController->get($tsInvoiceIds[0]);
1315
1316         $f = new Timetracker_Model_TimesheetFilter(array());
1317         $f->addFilter(new Tinebase_Model_Filter_Text(
1318                 array('field' => 'invoice_id', 'operator' => 'equals', 'value' => $myInvoice->getId())
1319         ));
1320         $myTimesheets = $tsController->search($f);
1321         $this->assertEquals(2, $myTimesheets->count(), 'timesheets not found for invoice ' . $myInvoice->getId());
1322
1323         $this->_invoiceController->delete(array($myInvoice->getId()));
1324         $allTimesheets = $tsController->getAll();
1325         foreach($allTimesheets as $ts) {
1326             $this->assertSame(NULL, $ts->invoice_id, 'invoice id should be reset');
1327         }
1328
1329         $this->_invoiceController->createAutoInvoices($date);
1330
1331         $tsId = $myTimesheets->getFirstRecord()->getId();
1332
1333         $myTimesheet = $tsController->get($tsId);
1334         $f = new Timetracker_Model_TimesheetFilter(array());
1335         $f->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'invoice_id', 'operator' => 'equals', 'value' => $myTimesheet->invoice_id)));
1336
1337         $myTimesheets = $tsController->search($f);
1338         $this->assertEquals(2, $myTimesheets->count());
1339
1340         foreach($myTimesheets as $ts) {
1341             $this->assertEquals(40, strlen($ts->invoice_id));
1342         }
1343     }
1344
1345     public function testInterval12LastAutobill()
1346     {
1347         $startDate = clone $this->_referenceDate;
1348         $startDate->subYear(1);
1349
1350         $this->_createProducts(array(
1351                 array('name' => 'bill yearly',
1352                 'description' => 'bill every year',
1353                 'price' => '1002','accountable' => 'Sales_Model_Product')
1354         ));
1355         $this->_createCustomers(1);
1356         $this->_createCostCenters();
1357         $addressId = $this->_addressRecords->filter(
1358                         'customer_id', $this->_customerRecords->filter(
1359                                 'name', 'Customer1')->getFirstRecord()->getId())->filter(
1360                                         'type', 'billing')->getFirstRecord()->getId();
1361
1362         // this contract begins 6 months before the first invoice will be created
1363         $this->_createContracts(array(array(
1364                 'number'       => 100,
1365                 'title'        => 'MyContract',
1366                 'description'  => 'unittest',
1367                 'container_id' => $this->_sharedContractsContainerId,
1368                 'billing_point' => 'begin',
1369                 'billing_address_id' => $addressId,
1370                 'interval' => 12,
1371                 'start_date' => $startDate,
1372                 'last_autobill' => $startDate,
1373                 'end_date' => NULL,
1374                 'products' => array(
1375                         array('product_id' => $this->_productRecords->getByIndex(0)->getId(), 'quantity' => 1, 'interval' => 12, 'last_autobill' => $startDate),
1376                 )
1377         )));
1378
1379         $startDate = clone $this->_referenceDate;
1380         $startDate->subMonth(1);
1381
1382         $startDate = clone $this->_referenceDate;
1383         $startDate->addDay(5);
1384         $result = $this->_invoiceController->createAutoInvoices($startDate);
1385
1386         $this->assertEquals(1, $result['created_count']);
1387
1388         $invoices = $this->_invoiceController->getAll();
1389         $firstInvoice = $invoices->getFirstRecord();
1390         $this->assertEquals(1, $invoices->count());
1391
1392         $filter = new Sales_Model_InvoicePositionFilter(array());
1393         $filter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'invoice_id', 'operator' => 'in', 'value' => $invoices->getArrayOfIds())));
1394
1395         $invoicePositions = Sales_Controller_InvoicePosition::getInstance()->search($filter);
1396
1397         $this->assertEquals(12, $invoicePositions->count());
1398
1399         $contract = $this->_contractRecords->getFirstRecord();
1400         $contract->setTimezone(Tinebase_Core::getUserTimezone());
1401
1402         $autobillDate = clone $this->_referenceDate;
1403
1404         for ($i = 0; $i < 8; $i++) {
1405             $startDate->addDay(1);
1406             $result = $this->_invoiceController->createAutoInvoices($startDate);
1407             $this->assertEquals(0, $result['created_count']);
1408         }
1409
1410         $productAggregate = Sales_Controller_ProductAggregate::getInstance()->getAll()->getFirstRecord();
1411         $productAggregate->setTimezone(Tinebase_Core::getUserTimezone());
1412         $this->assertEquals($autobillDate, $productAggregate->last_autobill);
1413     }
1414
1415     /**
1416      * tests if uncleared invoices gets deleted
1417      */
1418     public function testUnclearedDeletion()
1419     {
1420         $this->_createFullFixtures();
1421
1422         $date = clone $this->_referenceDate;
1423         $date->addMonth(8);
1424         $i = 0;
1425
1426         $result = $this->_invoiceController->createAutoInvoices($date);
1427
1428         $this->assertEquals(6, count($result['created']));
1429
1430         $invoice = $this->_invoiceController->get($result['created'][0]);
1431         $invoice->cleared = 'CLEARED';
1432         $this->_invoiceController->update($invoice);
1433
1434         $cli = new Sales_Frontend_Cli();
1435         $cli->removeUnbilledAutoInvoices();
1436
1437         $invoices = $this->_invoiceController->getAll();
1438
1439         $this->assertEquals(1, $invoices->count());
1440     }
1441
1442     /**
1443      * if no productaggregates are defined for a contract, but
1444      * accountables are related, use default billing Info from accountable
1445      * (product will be created if it does not exist - is needed in the invoice position)
1446      */
1447     public function testDefaultAutobillInterval()
1448     {
1449         $startDate = clone $this->_referenceDate;
1450         $startDate->subYear(1);
1451
1452         $this->_createCustomers(1);
1453         $this->_createCostCenters();
1454
1455         $this->_createTimeaccounts(array(array(
1456                 'title'         => 'TA',
1457                 'description'   => 'blabla',
1458                 'is_open'       => 1,
1459                 'status'        => 'to bill',
1460                 'budget'        => 100
1461         )));
1462
1463         $addressId = $this->_addressRecords->filter(
1464                         'customer_id', $this->_customerRecords->filter(
1465                                 'name', 'Customer1')->getFirstRecord()->getId())->filter(
1466                                         'type', 'billing')->getFirstRecord()->getId();
1467
1468         // this contract begins 6 months before the first invoice will be created
1469         $this->_createContracts(array(array(
1470                 'number'       => 100,
1471                 'title'        => 'MyContract',
1472                 'description'  => 'unittest',
1473                 'container_id' => $this->_sharedContractsContainerId,
1474                 'billing_point' => 'begin',
1475                 'billing_address_id' => $addressId,
1476
1477                 'start_date' => $startDate,
1478                 'end_date' => NULL,
1479         )));
1480
1481         $startDate = clone $this->_referenceDate;
1482         $startDate->subMonth(1);
1483
1484         $startDate = clone $this->_referenceDate;
1485         $startDate->addDay(5);
1486         $result = $this->_invoiceController->createAutoInvoices($startDate);
1487
1488         $this->assertEquals(1, $result['created_count']);
1489
1490         $filter = new Sales_Model_ProductFilter(array());
1491         $filter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'accountable', 'operator' => 'equals', 'value' => 'Timetracker_Model_Timeaccount')));
1492
1493         $products = Sales_Controller_Product::getInstance()->search($filter);
1494         $this->assertEquals(1, $products->count());
1495
1496
1497         $this->assertEquals('Timetracker_Model_Timeaccount', $products->getFirstRecord()->accountable);
1498
1499         $filter = new Sales_Model_InvoicePositionFilter(array());
1500         $filter->addFilter(new Tinebase_Model_Filter_Text(array('field' => 'invoice_id', 'operator' => 'equals', 'value' => $result['created'][0])));
1501
1502         $invoicePositions = Sales_Controller_InvoicePosition::getInstance()->search($filter);
1503
1504         $this->assertEquals(1, $invoicePositions->count());
1505     }
1506 }