function populate()
{
$orders = new POrderLineCollection();
$orders->setParams();
$sh = new SearchHandler($orders, false);
$sh->addConstraint(new Constraint('status', 'in', "('A','P')"));
$sh->addConstraint(new Constraint('order_status', '!=', "X"));
$sh->addConstraint(new Constraint('due_delivery_date', '<', fix_date(date(DATE_FORMAT))));
$this->setSearchLimit($sh);
$sh->setOrderBy(array('due_delivery_date', 'id'));
$orders->load($sh);
$this->contents = $orders;
}
public function viewAwaitingDelivery()
{
$s_data = array();
// Set context from calling module
if (isset($this->_data['plmaster_id'])) {
$s_data['plmaster_id'] = $this->_data['plmaster_id'];
}
if (isset($this->_data['stitem_id'])) {
$s_data['stitem_id'] = $this->_data['stitem_id'];
}
if (isset($this->_data['order_id'])) {
$s_data['order_id'] = $this->_data['order_id'];
}
$this->setSearch('pogoodsreceivedSearch', 'confirmReceipt', $s_data);
$s_data['plmaster_id'] = $this->search->getValue('plmaster_id');
$s_data['stitem_id'] = $this->search->getValue('stitem_id');
$s_data['order_id'] = $this->search->getValue('order_id');
$orderlines = new POrderLineCollection(DataObjectFactory::Factory('POrderLine'));
if ($s_data['plmaster_id'] > 0 || $s_data['stitem_id'] > 0 || $s_data['order_id'] > 0) {
if (isset($this->_data['orderby'])) {
$sh = new SearchHandler($orderlines, true);
} else {
$sh = new SearchHandler($orderlines, false);
}
$sh->extract();
$sh->setLimit('');
$sh->addConstraint(new Constraint('status', 'in', "('A','P')"));
if ($s_data['plmaster_id'] > 0) {
$sh->addConstraint(new Constraint('plmaster_id', '=', $s_data['plmaster_id']));
}
if ($s_data['stitem_id'] > 0) {
$sh->addConstraint(new Constraint('stitem_id', '=', $s_data['stitem_id']));
}
if ($s_data['order_id'] > 0) {
$sh->addConstraint(new Constraint('order_id', '=', $s_data['order_id']));
}
$DisplayFields = array('id');
foreach ($orderlines->getFields() as $field => $attr) {
if (!$attr->ignoreField) {
$DisplayFields[] = $field;
}
}
$DisplayFields[] = 'receive_action';
$sh->setFields($DisplayFields);
$orderlines->load($sh);
$this->view->set('num_records', $orderlines->num_records);
foreach ($orderlines as $orderline) {
$orderline->getAction();
$orderline->whaction_id = $orderline->receive_action;
$orderline->from_location_id = $orderline->getFromLocation($orderline->receive_action);
$orderline->to_location_id = $orderline->getToLocation($orderline->receive_action);
$whlocation = DataObjectFactory::Factory('WHLocation');
$whlocation->load($orderline->to_location_id);
if ($whlocation->isLoaded()) {
$orderline->to_location = $whlocation->whstore . '/' . $whlocation->description;
} else {
$orderline->to_location = '';
}
$orderline->to_bin_list = $orderline->getToBin($orderline->receive_action);
}
}
$this->_templateName = $this->getTemplateName('confirmreceipt');
$this->view->set('porderlines', $orderlines);
$sidebar = new SidebarController($this->view);
$actions = array();
$actions['viewnotes'] = array('link' => array('modules' => $this->_modules, 'controller' => $this->name, 'action' => 'index'), 'tag' => 'view goods received notes');
$sidebar->addList('Actions', $actions);
$this->view->set('page_title', $this->getPageName('Confirm Delivery of Order', ''));
$this->view->register('sidebar', $sidebar);
$this->view->set('sidebar', $sidebar);
// Override output button - there is no point to it here
$this->printaction = '';
}
public function getPOstructures()
{
// This gets all Purchase Order Lines
if ($this->postructures) {
return $this->postructures;
}
$polines = new POrderLineCollection();
$polines->_tablename = 'po_structure_lines';
$sh = new SearchHandler($polines, false);
$sh->addConstraint(new Constraint('ststructure_id', '=', $this->id));
$sh->addConstraint(new Constraint('status', 'in', "('A', 'N', 'O', 'P')"));
$sh->setOrderby('due_delivery_date');
$polines->load($sh);
if ($polines) {
$this->postructures = $polines;
return $this->postructures;
} else {
return array();
}
}