Example #1
0
 function FindSupplies()
 {
     $this->MakeSafe();
     /* Return all of the bins where this SupplyID is found */
     $sql = "SELECT a.* FROM fac_BinContents a, fac_SupplyBin b WHERE \n\t\t\ta.SupplyID={$this->SupplyID} AND a.BinID=b.BinID ORDER BY b.Location ASC;";
     $binList = array();
     foreach ($this->query($sql) as $row) {
         $binList[] = BinContents::RowToObject($row);
     }
     return $binList;
 }