/**
Create, update, and delete a batch
Try each mode with and without an owner filter
*/
public function unitTest($phpunit)
{
$get = $this->get_view();
$phpunit->assertNotEquals(0, strlen($get));
$this->connection->selectDB($this->config->get('OP_DB'));
$model = new BatchesModel($this->connection);
$this->newType = 1;
$this->newName = 'Test BatchListPage';
$this->newStart = date('Y-m-d 00:00:00');
$this->newEnd = date('Y-m-d 00:00:00');
$this->newOwner = 'IT';
ob_start();
$this->post_newType_newName_newStart_newEnd_newOwner_handler();
ob_end_clean();
$model->batchName($this->newName);
$matches = $model->find();
$phpunit->assertEquals(1, count($matches));
$model->reset();
$model->batchID($matches[0]->batchID());
$phpunit->assertEquals(true, $model->load());
$phpunit->assertEquals($this->newType, $model->batchType());
$phpunit->assertEquals($this->newName, $model->batchName());
$phpunit->assertEquals($this->newStart, $model->startDate());
$phpunit->assertEquals($this->newEnd, $model->endDate());
$phpunit->assertEquals($this->newOwner, $model->owner());
$this->id = $model->batchID();
$this->batchName = 'Change BatchListPage';
$this->batchType = 2;
$this->startDate = date('Y-m-d 00:00:00', strtotime('yesterday'));
$this->endDate = $this->startDate;
$this->owner = 'Admin';
ob_start();
$this->post_id_batchName_batchType_startDate_endDate_owner_handler();
ob_end_clean();
$model->reset();
$model->batchID($this->id);
$phpunit->assertEquals(true, $model->load());
$phpunit->assertEquals($this->batchType, $model->batchType());
$phpunit->assertEquals($this->batchName, $model->batchName());
$phpunit->assertEquals($this->startDate, $model->startDate());
$phpunit->assertEquals($this->endDate, $model->endDate());
$phpunit->assertEquals($this->owner, $model->owner());
$this->delete = 1;
ob_start();
$this->post_delete_id_handler();
ob_end_clean();
$model->reset();
$model->batchID($this->id);
$phpunit->assertEquals(false, $model->load());
$modes = array('pending', 'current', 'historical', 'all');
foreach ($modes as $m) {
$get = $this->batchListDisplay('', $m, rand(0, 50));
$phpunit->assertNotEquals(0, strlen($get));
$get = $this->batchListDisplay('IT', $m, rand(0, 50));
$phpunit->assertNotEquals(0, strlen($get));
}
}
protected function hookAddColumnowner()
{
// copy existing values from batchowner.owner to
// new batches.owner column
if ($this->connection->table_exists('batchowner')) {
$dataR = $this->connection->query('SELECT batchID, owner FROM batchowner');
$tempModel = new BatchesModel($this->connection);
while ($dataW = $this->connection->fetch_row($dataR)) {
$tempModel->reset();
$tempModel->batchID($dataW['batchID']);
if ($tempModel->load()) {
$tempModel->owner($dataW['owner']);
$tempModel->save();
}
}
}
}
