public function stockGatepassSearch($date_from, $dateto) { $wh_id = $this->_identity->getWarehouseId(); if (!empty($date_from) && !empty($dateto)) { $where[] = "sm.transactionDate BETWEEN '" . App_Controller_Functions::dateTimeToDbFormat($date_from) . "' AND '" . App_Controller_Functions::dateTimeToDbFormat($dateto) . "'"; } if (!empty($wh_id)) { $where[] = "sm.fromWarehouse = '" . $wh_id . "'"; } $where[] = "sm.transactionType = '" . Model_TransactionTypes::TRANSACTION_ISSUE . "'"; if (is_array($where)) { $where_s = implode(" AND ", $where); } $str_sql = $this->_em->createQueryBuilder()->select("sm.pkId,sm.transactionNumber,sm.transactionDate")->from("StockMaster", "sm")->where($where_s); //echo $str_sql->getQuery()->getSql(); $row = $str_sql->getQuery()->getResult(); if (!empty($row) && count($row) > 0) { return $row; } else { return false; } }
public function update() { $warehouse_data = $this->_em->getRepository("HfDataMaster")->find($this->form_values['pk_id']); $warehouse_data->setReceivedBalance($this->form_values['received_balance']); $warehouse_data->setClosingBalance($this->form_values['closing_balance']); $warehouse_data->setModifiedDate(new \DateTime(App_Controller_Functions::dateTimeToDbFormat(date("d/m/Y")))); $user = $this->_em->getRepository('Users')->find($this->_user_id); $warehouse_data->setModifiedBy($user); $this->_em->persist($warehouse_data); $this->_em->flush(); return true; }
public function stockGatepassSearch() { //$wh_id = $this->_identity->getWarehouseId(); $where = ""; if (!empty($this->form_values['vehicle_type_id'])) { $where[] = "gpv.vehicleType= '" . $this->form_values['vehicle_type_id'] . "'"; } if (!empty($this->form_values['item_pack_size_id'])) { $where[] = "ip.pkId = '" . $this->form_values['item_pack_size_id'] . "'"; } if (!empty($this->form_values['stock_batch_id'])) { $where[] = "sd.stockBatchWarehouse = '" . $this->form_values['stock_batch_id'] . "'"; } if (!empty($this->form_values['date_from']) && !empty($this->form_values['date_to'])) { $where[] = "DATE_FORMAT(gpm.transactionDate,'%Y-%m-%d') BETWEEN '" . App_Controller_Functions::dateTimeToDbFormat($this->form_values['date_from']) . "' AND '" . App_Controller_Functions::dateTimeToDbFormat($this->form_values['date_to']) . "'"; } $str_sqlee = $this->_em->createQueryBuilder()->select(" gpm.number as gpmnumber,gpm.transactionDate," . " gpv.number as gpnumber," . " sb.number," . "ip.itemName")->from("GatepassDetail", "gpd")->join("gpd.gatepassMaster", "gpm")->join("gpm.gatepassVehicle", "gpv")->join("gpd.stockDetail", "sd")->join("sd.stockBatchWarehouse", "sbw")->join("sbw.stockBatch", "sb")->join('sb.packInfo', 'pi')->join('pi.stakeholderItemPackSize', 'sip')->join("sip.itemPackSize", 'ip'); if (is_array($where)) { $where_s = implode(" AND ", $where); $str_sqlee->where($where_s); } //->orderBy("s.transactionNumber", "ASC"); //echo $str_sqlee->getQuery()->getSql();//exit; $result12 = $str_sqlee->getQuery()->getResult(); //print_r($result12);exit; return $result12; }