public function init() { //Generate WareHouses Combo $pc = new Model_PipelineConsignments(); $result1 = $pc->getPipelineToWarehouses(); $this->_list["to_warehouse_id"][""] = 'Select'; foreach ($result1 as $wh) { $this->_list["to_warehouse_id"][$wh['pkId']] = $wh['warehouseName']; } //Generate Item Combo $item_pack_size = new Model_ItemPackSizes(); $result = $item_pack_size->getItemsAll(); $this->_list["item_pack_size_id"][''] = "Select"; if ($result) { $item_id = $result[0]->getPkId(); foreach ($result as $row) { $this->_list["item_pack_size_id"][$row->getPkId()] = $row->getItemName(); } } $date_from = date('01/m/Y'); $date_to = date('d/m/Y'); foreach ($this->_fields as $col => $name) { switch ($col) { case "from_date": $this->addElement("text", $col, array("attribs" => array("class" => "form-control", 'readonly' => 'true'), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array(), "value" => $date_from)); $this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag"); break; case "to_date": $this->addElement("text", $col, array("attribs" => array("class" => "form-control", 'readonly' => 'true'), "allowEmpty" => false, "filters" => array("StringTrim", "StripTags"), "validators" => array(), "value" => $date_to)); $this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag"); break; default: break; } if (in_array($col, array_keys($this->_list))) { $this->addElement("select", $col, array("attribs" => array("class" => "form-control"), "filters" => array("StringTrim", "StripTags"), "allowEmpty" => true, "required" => false, "registerInArrayValidator" => false, "multiOptions" => $this->_list[$col], "validators" => array(array("validator" => "Float", "breakChainOnFailure" => false, "options" => array("messages" => array("notFloat" => $name . " must be a valid option")))))); $this->getElement($col)->removeDecorator("Label")->removeDecorator("HtmlTag"); } } }
public function getIssueVoucherListAction() { $wh_id = $this->_request->getParam('wh_id', ''); $pipeline_consignments = new Model_PipelineConsignments(); $result = $pipeline_consignments->getPlannedIssueByWh($wh_id); // $result = $stock_master->getUnpickedIssueNo($wh_id); // $result = $stock_master->getIssueVoucherList($wh_id); // $result = $stock_master->getUnpickedIssueNo($wh_id); echo Zend_Json::encode($result); }
public function ajaxPlannedIssueDetailsAction() { $this->_helper->layout->disableLayout(); $id = $this->_request->getParam('id', ''); $pipeline_consignments = new Model_PipelineConsignments(); if (!empty($id)) { $pipeline_consignments->form_values = array('voucher_number' => $id, 'source' => $this->_identity->getWarehouseId(), 'type' => 2); $arr_data = $pipeline_consignments->getBySearch(); $this->view->voucher_number = $id; $this->view->arr_data = $arr_data; } }
public function addPipelineConsignments() { $form_values = $this->form_values; $end = $form_values['counter']; $furute_arrival = new Model_PipelineConsignments(); $vouchers = $furute_arrival->getTempraryNumber($form_values['expected_arrival_date'], 1); $counter = 0; for ($i = 0; $i < $end; $i++) { $row = $form_values["rows" . $i]; if (!empty($row['item_pack_size_id']) && !empty($row['batch_number']) && !empty($row['expiry_date']) && !empty($row['quantity'])) { $farr = new PipelineConsignments(); $farr->setVoucherNumber($vouchers['temp_no']); $farr->setTransactionCounter($vouchers['id']); $farr->setExpectedArrivalDate(new \DateTime(App_Controller_Functions::dateToDbFormat($form_values['expected_arrival_date']))); $farr->setReferenceNumber($form_values['reference_number']); $activity = $this->_em->getRepository("StakeholderActivities")->find($form_values['stakeholder_activity_id']); $farr->setStakeholderActivity($activity); $farr->setDescription($form_values['description']); $item_pack_size = $this->_em->getRepository("ItemPackSizes")->find($row['item_pack_size_id']); $farr->setItemPackSize($item_pack_size); $farr->setBatchNumber($row['batch_number']); $farr->setProductionDate(new \DateTime(App_Controller_Functions::dateToDbFormat($row['production_date']))); $farr->setExpiryDate(new \DateTime(App_Controller_Functions::dateToDbFormat($row['expiry_date']))); $manufacturer = $this->_em->getRepository("StakeholderItemPackSizes")->find($row['manufacturer_id']); $farr->setManufacturer($manufacturer); $vvm_type = $this->_em->getRepository("VvmTypes")->find($row['vvm_type_id']); $farr->setVvmType($vvm_type); $farr->setUnitPrice($row['unit_price']); $quantity = str_replace(",", "", $row['quantity']); $farr->setQuantity($quantity); $farr->setReceivedQuantity(0); $from_wh = $this->_em->getRepository("Warehouses")->find($form_values['from_warehouse_id']); $farr->setFromWarehouse($from_wh); $to_wh = $this->_em->getRepository("Warehouses")->find($this->_identity->getWarehouseId()); $farr->setToWarehouse($to_wh); $user = $this->_em->getRepository("Users")->find($this->_user_id); $farr->setCreatedBy($user); $farr->setCreatedDate(new \DateTime(App_Controller_Functions::dateToDbFormat(date("d/m/Y")))); $farr->setMasterId(0); $farr->setStatus('Planned'); $tr_type = $this->_em->getRepository("TransactionTypes")->find(1); $farr->setTransactionType($tr_type); $this->_em->persist($farr); $counter++; } } $this->_em->flush(); if ($counter >= 1) { // Delete Draft entries $rs = $this->_em->getRepository('PipelineConsignmentsDraft')->findBy(array('toWarehouse' => $this->_identity->getWarehouseId())); foreach ($rs as $ro) { $this->_em->remove($ro); } $this->_em->flush(); return true; } return false; }