Advertisement
Guest User

Untitled

a guest
Aug 25th, 2016
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. public function getPrSolicitation()
  2. {
  3. return $this->hasOne(Tblprsolicitations::className(), ['pr_solicitation_id'
  4. => 'pr_solicitation_id']);
  5. }
  6.  
  7. public function getPRsuppliers()
  8. {
  9. return $this->hasOne(Tblprsuppliers::className(), ['pr_solicitaion_id'
  10. => 'pr_solicitaion_id']);
  11. }
  12.  
  13. <?= $form->field($model, 'prSolicitation[pRsuppliers][supplier_id]')->textInput(['placeholder' => 'Enter supplier'])->label(false); ?>
  14.  
  15. public function search($params)
  16. {
  17. $query = Tblpritems::find();
  18.  
  19. // add conditions that should always apply here
  20.  
  21. $dataProvider = new ActiveDataProvider([
  22. 'query' => $query,
  23. ]);
  24.  
  25. $this->load($params);
  26.  
  27.  
  28. // grid filtering conditions
  29. $query->andFilterWhere([
  30. 'PRlineID' => $this->PRlineID,
  31. 'Quantity' => $this->Quantity,
  32. 'Unit_Price' => $this->Unit_Price,
  33. 'Extended_price' => $this->Extended_price,
  34. 'Currency_ID' => $this->Currency_ID,
  35. 'PRID' => $this->PRID,
  36. 'pr_solicitation_id' => $this->pr_solicitation_id, //This is what am using t filter the grid
  37. 'date_item_received' => $this->date_item_received,
  38. 'Quantity_received' => $this->Quantity_received,
  39. 'Received_by' => $this->Received_by,
  40. 'item_received_status' => $this->item_received_status,
  41. ]);
  42.  
  43. $query->andFilterWhere(['like', 'Tracking_Code', $this->Tracking_Code])
  44. ->andFilterWhere(['like', 'Description', $this->Description])
  45. ->andFilterWhere(['like', 'Remarks_on_receipt', $this->Remarks_on_receipt]);
  46.  
  47. return $dataProvider;
  48. }
  49.  
  50. <?= $form->field($model, 'prSolicitation->pRsuppliers[supplier_id]')->textInput(['placeholder' => 'Enter supplier'])->label(false); ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement