protected function getPositions($id) { $positionsDb = new Sales_Model_DbTable_Salesorderpos(); $positions = $positionsDb->fetchAll($positionsDb->select()->where('salesorderid = ?', $id)->where('clientid = ?', $this->_user['clientid'])->order('ordering')); return $positions; }
public function generatesalesorderAction() { $id = $this->_getParam('id', 0); $quoteDb = new Sales_Model_DbTable_Quote(); $data = $quoteDb->getQuote($id); unset($data['id'], $data['quoteid'], $data['quotedate']); $data['salesorderdate'] = '0000-00-00'; $data['state'] = 100; $data['created'] = $this->_date; $data['createdby'] = $this->_user['id']; $data['modified'] = '0000-00-00'; $data['modifiedby'] = 0; $data['clientid'] = $this->_user['clientid']; $salesorder = new Sales_Model_DbTable_Salesorder(); $salesorderid = $salesorder->addSalesorder($data); $positions = $this->getPositions($id); $positionsSalesorderDb = new Sales_Model_DbTable_Salesorderpos(); foreach ($positions as $position) { $dataPosition = $position->toArray(); $dataPosition['salesorderid'] = $salesorderid; $dataPosition['created'] = $this->_date; $dataPosition['createdby'] = $this->_user['id']; $dataPosition['modified'] = '0000-00-00'; $dataPosition['modifiedby'] = 0; unset($dataPosition['id'], $dataPosition['quoteid']); $positionsSalesorderDb->addPosition($dataPosition); } $this->_flashMessenger->addMessage('MESSAGES_SALES_ORDER_SUCCESFULLY_GENERATED'); $this->_helper->redirector->gotoSimple('edit', 'salesorder', null, array('id' => $salesorderid)); }
protected function setOrdering($salesorderid) { $i = 1; $positions = $this->getPositions($salesorderid); foreach ($positions as $position) { if ($position->ordering != $i) { if (!isset($positionsDb)) { $positionsDb = new Sales_Model_DbTable_Salesorderpos(); } $positionsDb->sortPosition($position->id, $i); } ++$i; } }