function populate()
{
$invoices = new PInvoiceCollection();
$invoices->setParams();
$sh = new SearchHandler($invoices, FALSE);
$sh->addConstraint(new Constraint('status', '=', 'Q'));
$this->setSearchLimit($sh);
$sh->setOrderBy('due_date');
$invoices->load($sh);
$this->contents = $invoices;
// set vars
$this->vars['type_label'] = 'Supplier';
$this->vars['type_field'] = 'supplier';
$this->vars['module'] = 'purchase_invoicing';
$this->vars['controller'] = 'pinvoices';
}
public function hasCurrentActivity()
{
$db = DB::Instance();
// Check that no orders/invoices have been raised
$model = DataObjectFactory::Factory('POrder');
$collection = new POrderCollection($model);
$sh = new SearchHandler($collection, FALSE);
$sh->addConstraint(new Constraint('plmaster_id', '=', $this->id));
$sh->addConstraint(new Constraint('status', 'NOT IN', '(' . $db->qstr($model->cancelStatus()) . ', ' . $db->qstr($model->invoiceStatus()) . ')'));
if (count($collection->load($sh, null, RETURN_ROWS)) > 0) {
return TRUE;
}
$model = DataObjectFactory::Factory('PInvoice');
$collection = new PInvoiceCollection($model);
$sh = new SearchHandler($collection, FALSE);
$sh->addConstraint(new Constraint('plmaster_id', '=', $this->id));
$sh->addConstraint(new Constraint('status', '!=', $model->paidStatus()));
if (count($collection->load($sh, null, RETURN_ROWS)) > 0) {
return TRUE;
}
$model = DataObjectFactory::Factory('PLTransaction');
$collection = new PLTransactionCollection($model);
$sh = new SearchHandler($collection, FALSE);
$sh->addConstraint(new Constraint('plmaster_id', '=', $this->id));
$sh->addConstraint(new Constraint('status', '!=', $model->paid()));
if (count($collection->load($sh, null, RETURN_ROWS)) > 0) {
return TRUE;
}
return FALSE;
}
public function view_invoices()
{
if (isset($this->_data['Search']['productline_header_id'])) {
$this->_data['id'] = $this->_data['Search']['productline_header_id'];
}
if (!isset($this->_data['id'])) {
$this->DataError();
sendBack();
}
$s_data = array();
// Set context from calling module
$s_data['productline_header_id'] = $this->_data['id'];
$this->setSearch('productlinesSearch', 'supplierInvoices', $s_data);
$this->view();
// Now load the required data
$invoices = new PInvoiceCollection();
$invoices->setViewName('po_product_invoices');
$sh = $this->setSearchHandler($invoices);
parent::index($invoices, $sh);
$this->view->set('clickmodule', array('purchase_invoicing'));
$this->view->set('clickcontroller', 'pinvoices');
$this->view->set('clickaction', 'view');
$this->view->set('related_collection', $invoices);
$this->setTemplateName('view_related');
}
